R12 – Complete list of supported API’s

In R11 api’s was found in irep – in R12 api’s are found in the database. The “7417 Prototype scripts for API’s – R12” zip file is generated using the proto sql scripts from the sql4oracle.zip file.

Extract was generated using this sql:

select distinct '@proto3 ' || 
package_name || ' ' || 
object_name || ' ' || 
nvl(overload,0) 
from all_arguments aa 
where 1=1
and object_id in 
(select uo.object_id 
from  
user_objects uo,
FND_IREP_CLASSES fic
where 1=1
and uo.object_type = 'PACKAGE'
and uo.object_name = fic.irep_name
and fic.CLASS_TYPE = 'PLSQL');

Go to the SQL script page to download the “7417 Prototype scripts for API’s – R12” file.

This entry was posted in API, Applications development, Developer Scripts, News, R12, SQL. Bookmark the permalink.