Script that returns the list of custom API's list.

[kallice85]

Hi Experts,

There is a requirement internally within our organization to find out all the customn API's that have been used in the oracle applications 11i.
This is to find out the estimation of the customization with respect to API's.

Can you share your inputs as to how to go about or if you have already come across this or have any scripts/Documents relevant to this is of kind help to us.Be it sql script or UNix or any other approach!

Your response is highly appreciated.

Regards,
Kallice

[admin]

topic.asp?TOPIC_ID=3709

[ERP_GURU]

Hi Kallice,

Alternatively, you can find this out with simple sql query that will look something like

select * from all_source
where text like %api%.

You can apply more filters or modify this to get more fine tuned output, for eg, if you are looking for APIs used in package or something, yyou can apply one more filter for TYPE= 'PACKAge BODY'.
Let us know what you get..

Thanks!!

[ERP_GURU]

Sorry for typo..

It should be TYPE= 'PACKAGE BODY'