PAY_ELEMENT_LINK_API.delete_element_link

DECLARE    l_effective_start_date   DATE;    l_effective_end_date     DATE;    l_entries_warning       ...

hr_sit_api.create_sit

DECLARE    err_code                         varchar2 (50);    err_msg       ...

hr_sit_api.delete_sit

DECLARE    CURSOR c1    IS       SELECT   PERSON_ANALYSIS_ID, OBJECT_VERSION_NUMBER         FROM   PER_PERSON_ANALYSES  ...

Introduction to Oracle 10g Pl/sql - Fundamentals 1

Introduction to Oracle 10g Pl/sql - Fundamentals 1- Author Nancy Greenberg https://drive.google.com/open?id=17j94S3CBU3ivmysYbmNMqu-3k7q-gL...

Kill Session

select s.sid,s.serial#, s.status,p.spid from v$session s,v$process p where s.username='USER_NAME' and p.addr(+)=s.paddr; alter system kill session '<sid>,<serial#>...

Create Person Phone in Oracle apps HRMS

Create Person Phone in Oracle apps HRMS: Sample code: DECLARE    err_code                  VARCHAR2 (50);    err_msg ...

Finding dates against day name in a specific month in Oracle Pl/sql

  SELECT   A.LEV, MONTH_DATE, DAY_NAME     FROM   (    SELECT   LEVEL LEV,              ...

Create Person Address (Temporary) in Oracle apps HRMS

Create Person Address (Temporary) in Oracle apps HRMS: Sample Code: DECLARE    err_code                   VARCHAR2 (50);  ...

Create Person Address (Permanent) in Oracle apps HRMS

Create Person Address (Permanent) in Oracle apps HRMS: Sample Code: DECLARE    err_code                   VARCHAR2 (50);  ...