APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_JOBCODE_DELTA_SYNC

Line 1821: procedure hr_jobcode_delta_sync(errbuf OUT NOCOPY VARCHAR2

1817: end hr_workforce_delta_sync;
1818: /*Procedure to extract the workforce data for delta synch process ends here*/
1819:
1820: /*Procedure to extract the jobcode data for delta synch process begins here*/
1821: procedure hr_jobcode_delta_sync(errbuf OUT NOCOPY VARCHAR2
1822: ,retcode OUT NOCOPY VARCHAR2
1823: ,p_party_site_id in NUMBER)
1824: is
1825:

Line 1876: HR_JOBCODE_DELTA_SYNC

1872:
1873: cursor fet_delta_status
1874: is
1875: select setid,jobcode,event_key,last_update_date from
1876: HR_JOBCODE_DELTA_SYNC
1877: where status = 'QUEUED';
1878:
1879: cursor csr_gen_msg(p_evn_key varchar2)
1880: is select generation_status,generation_message

Line 1926: update HR_JOBCODE_DELTA_SYNC

1922: fetch fet_delta_status into p_set_id,p_job_id,p_event_key_gen,p_lst_upddt;
1923:
1924: if fet_delta_status%found then
1925:
1926: update HR_JOBCODE_DELTA_SYNC
1927: set status = 'SENT'
1928: where event_key = p_event_key_gen;
1929: commit;
1930:

Line 1957: insert into HR_JOBCODE_DELTA_SYNC(

1953: IF jobcode_deltaq%found then
1954:
1955: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1956:
1957: insert into HR_JOBCODE_DELTA_SYNC(
1958: SETID ,
1959: JOBCODE ,
1960: EFFDT,
1961: EFF_STATUS ,

Line 2023: (select setid,jobcode from HR_JOBCODE_DELTA_SYNC jbcd

2019: job.LAST_UPDATE_DATE LAST_UPD_DATE
2020: FROM PER_JOBS job
2021: WHERE job.last_update_date >= run_date
2022: and (job.business_group_id,job.job_id)not in
2023: (select setid,jobcode from HR_JOBCODE_DELTA_SYNC jbcd
2024: where job.BUSINESS_GROUP_ID = jbcd.setid
2025: and job.JOB_ID = jbcd.jobcode
2026: and job.last_update_date <= jbcd.last_update_date
2027: and jbcd.status in ('QUEUED','SENT'));

Line 2035: FROM HR.HR_JOBCODE_DELTA_SYNC

2031: JOBCODE,
2032: EFFDT,
2033: EFF_STATUS,
2034: DESCR
2035: FROM HR.HR_JOBCODE_DELTA_SYNC
2036: WHERE STATUS = 'QUEUED';*/
2037:
2038: LOOP
2039: BEGIN

Line 2069: insert into HR_JOBCODE_DELTA_SYNC(

2065: FOR I IN 1 .. p_cnt Loop
2066:
2067: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2068:
2069: insert into HR_JOBCODE_DELTA_SYNC(
2070: SETID ,
2071: JOBCODE ,
2072: EFFDT,
2073: EFF_STATUS ,

Line 2132: end hr_jobcode_delta_sync;

2128: FND_FILE.put_line(fnd_file.log, 'Error in Jobcode Delta Synch Extraction: '||SQLCODE);
2129: FND_FILE.NEW_LINE(FND_FILE.log, 1);
2130: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
2131:
2132: end hr_jobcode_delta_sync;
2133: /*Procedure to extract the jobcode data for delta synch process ends here*/
2134: /*Procedure to extract the organization data for delta synch process begins here*/
2135: procedure hr_organizaton_delta_sync(errbuf OUT NOCOPY VARCHAR2
2136: ,retcode OUT NOCOPY VARCHAR2

Line 2889: hr_delta_sync_messages.hr_jobcode_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2885: elsif p_process_name = 'WORKFORCE_DELTA_SYNCH'
2886: then
2887: hr_delta_sync_messages.hr_workforce_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2888: elsif p_process_name = 'JOBCODE_DELTA_SYNCH' then
2889: hr_delta_sync_messages.hr_jobcode_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2890: elsif p_process_name = 'ORGANIZATION_DELTA_SYNCH' then
2891: hr_delta_sync_messages.hr_organizaton_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2892: elsif p_process_name = 'BUSINESSGROUP_DELTA_SYNCH' then
2893: hr_delta_sync_messages.hr_businessgrp_delta_sync(ERRBUF,RETCODE,p_party_site_id);

Line 2943: update HR_JOBCODE_DELTA_SYNC

2939: where event_key = p_event_key;
2940:
2941: elsif p_process_name = 'JOBCODE_DELTA_SYNCH' then
2942:
2943: update HR_JOBCODE_DELTA_SYNC
2944: set status = 'SENT'
2945: where event_key = p_event_key;
2946:
2947: elsif p_process_name = 'ORGANIZATION_DELTA_SYNCH' then