Dec 18, 2013

Oracle HR related API List


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: