Showing posts with label Guide. Show all posts
Showing posts with label Guide. Show all posts

Wednesday, December 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;


Monday, December 10, 2012

Oracle Applications Shortcut Keys


Function
Hot Key
Clear Field
F5
Clear Form
F8
Clear Record
F6
Clear Block
F7
Commit / Save
Ctrl-S
Delete Record
Ctrl-↑
Down
Duplicate Field
Shift-F5
Duplicate Record
Shift-F6
Edit
Ctrl-E
Enter Query
F11
Execute Query
Ctrl-F11
Exit
F4
Insert Record
Ctrl-↓
List of Values
Ctrl-L
Next Block
Shift-PgDn
Next Record
Previous Block
Shift-PgUp
Previous Field
Shift-Tab
Previous Record
Next Field
Tab
Print
Ctrl-P
Scroll Down
PgDn
Scroll Up
PgUp
Show Keys
Ctrl-K
Up