APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_WORKFORCE_DELTA_SYNC

Line 1367: procedure hr_workforce_delta_sync(errbuf OUT NOCOPY VARCHAR2

1363: end;
1364: /*Procedure to fetch the delta sync data for person ends here*/
1365:
1366: /*Procedure to extract the workforce data for delta synch process begins here*/
1367: procedure hr_workforce_delta_sync(errbuf OUT NOCOPY VARCHAR2
1368: ,retcode OUT NOCOPY VARCHAR2
1369: ,p_party_site_id in NUMBER)
1370: is
1371:

Line 1462: from HR_WORKFORCE_DELTA_SYNC

1458:
1459: cursor fet_delta_status
1460: is
1461: select employee_number,business_group_id,job_id,event_key,last_update_date
1462: from HR_WORKFORCE_DELTA_SYNC
1463: where status = 'QUEUED';
1464:
1465: p_emp_num VARCHAR2(30);
1466: p_bg_id number(15);

Line 1505: update HR_WORKFORCE_DELTA_SYNC

1501: fetch fet_delta_status into p_emp_num,p_bg_id,p_job_id,p_event_key_gen,p_lst_upd_date;
1502:
1503: if fet_delta_status%found then
1504:
1505: update HR_WORKFORCE_DELTA_SYNC
1506: set status = 'SENT'
1507: where event_key = p_event_key_gen;
1508: commit;
1509:

Line 1562: insert into HR_WORKFORCE_DELTA_SYNC

1558: if workforce_deltaq%FOUND then
1559:
1560:
1561: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1562: insert into HR_WORKFORCE_DELTA_SYNC
1563: (EMPLOYEE_NUMBER,
1564: EMPL_RCD ,
1565: ORIGINAL_DATE_OF_HIRE,
1566: PROBATION_PERIOD,

Line 1671: from HR_WORKFORCE_DELTA_SYNC wfrc

1667: ppf.effective_end_date(+)
1668: AND pas.last_update_date >= run_date
1669: AND (ppf.employee_number,pas.business_group_id,pas.job_id) not in (
1670: select wfrc.employee_number,wfrc.business_group_id,wfrc.job_id
1671: from HR_WORKFORCE_DELTA_SYNC wfrc
1672: where wfrc.employee_number = ppf.employee_number
1673: and wfrc.business_group_id = pas.business_group_id
1674: and wfrc.job_id = pas.job_id
1675: and pas.last_update_date <= wfrc.last_update_date

Line 1723: insert into HR_WORKFORCE_DELTA_SYNC

1719:
1720:
1721: FOR I IN 1 .. p_cnt Loop
1722: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1723: insert into HR_WORKFORCE_DELTA_SYNC
1724: (EMPLOYEE_NUMBER,
1725: EMPL_RCD ,
1726: ORIGINAL_DATE_OF_HIRE,
1727: PROBATION_PERIOD,

Line 1817: end hr_workforce_delta_sync;

1813: FND_FILE.put_line(fnd_file.log, 'Error in Work Force Delta Synch Extraction: '||SQLCODE);
1814: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1815: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
1816:
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

Line 2887: hr_delta_sync_messages.hr_workforce_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2883: then
2884: hr_delta_sync_messages.hr_person_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);

Line 2937: update HR_WORKFORCE_DELTA_SYNC

2933:
2934: elsif p_process_name = 'WORKFORCE_DELTA_SYNCH'
2935: then
2936:
2937: update HR_WORKFORCE_DELTA_SYNC
2938: set status = 'SENT'
2939: where event_key = p_event_key;
2940:
2941: elsif p_process_name = 'JOBCODE_DELTA_SYNCH' then