Recently I had to work on lot of HR related interfaces, which use Oracle APIs. While I was working on the interfaces, I came across with the following website by Puneet Rajkumar, which I thought a very good resource for all HRMS related APIs. He provided some easy good examples.
https://blogs.oracle.com/prajkumar/entry/oracle_hrms_apis
You can also refer to Oracle article for more information:
Note: 179243.1 - Application Programmatic Interfaces (APIs) in Oracle HRMS
Or, you can run the following query:
SELECT SUBSTR (ds.owner, 1, 20) owner,
SUBSTR (ds.name, 1, 30) object_name,
SUBSTR (ds.type, 1, 20) object_type,
SUBSTR (do.status, 1, 10) status,
do.last_ddl_time last_ddl
FROM dba_source ds,
dba_objects do
WHERE 1 = 1
--
AND ds.name = do.object_name
AND ds.type = do.object_type
--
AND ds.text LIKE '%Header%'
AND ds.type = 'PACKAGE BODY'
AND ds.name LIKE 'HR_%API%'
--
ORDER
BY ds.owner, ds.name;
No comments:
Post a Comment