Query to find API Name for oracle apps diffrent Module.

Most public APIs have the words 'pub' or 'api' in them, which helps narrow down the field. For example if you were looking for an inventory item API, you could search on the word ITEM as follows :

SELECT distinct object_name pkg, procedure$ proc

FROM dba_objects obj, sys.argument$ args

WHERE obj.object_id = args.obj#

AND obj.object_type = 'PACKAGE'

AND obj.owner = 'APPS'

AND ( obj.object_name LIKE '%API%'

OR obj.object_name LIKE '%PUB%' )

AND args.procedure$ LIKE '%ITEM%'

ORDER BY object_name, procedure$