How to find APIs?

Its difficult for a developer to find out APIs from DBA_OBJECTS table, so Oracle Corp. has come up with a web portal named Oracle Integration Repository (iRep) to access all public APIs.

Oracle® Integration Repository

Oracle Integration Repository is a compilation of information about the numerous interface endpoints exposed by Oracle applications. The full list of public APIs and the purpose of each API is available in the integration repository. It provides a complete catalog of Oracle E-Business Suite’s business interfaces, and a comprehensive view of the interface mechanisms available. You can use this tool to easily discover and deploy the appropriate business interface from the catalog for integration with any system, application, or business partner.

Website URL: http://www.irep.oracle.com/

Release 12 Integration Repository

In Oracle EBS R12, Integration Repository is bundled as a part of EBS suite as a responsibility “Integrated SOA Gateway”.

Where are these APIs Stored?

Each API is placed in a file with extension as ‘pls'(pl/sql source code file). These pls files are stored in Unix box in the following path

$APPLICATION_TOP/patch/115/sql/

Query to find APIs

You can use the below query to find out the APIs to some extent

SELECT SUBSTR(a.OWNER,1,20) , SUBSTR(a.NAME,1,30) , SUBSTR(a.TYPE,1,20) , SUBSTR(u.status,1,10) Stat , u.last_ddl_time , SUBSTR(text,1,80) Description FROM dba_source a, dba_objects u WHERE 2 =2 AND u.object_name = a.name AND a.text LIKE '%Header%' AND a.type = u.object_type AND a.name LIKE 'PA_%API%' ORDER BY a.owner, a.name;

Here PA is application short name of Project Accounting application

Thanks http://oracleappsdna.com/