APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_PERSON_DELTA_SYNC

Line 874: procedure hr_person_delta_sync(errbuf OUT NOCOPY VARCHAR2

870:
871: /*Procedure to fetch the delta sync data for location ends here*/
872:
873: /*Procedure to fetch the delta sync data for person begins here*/
874: procedure hr_person_delta_sync(errbuf OUT NOCOPY VARCHAR2
875: ,retcode OUT NOCOPY VARCHAR2
876: ,p_party_site_id in NUMBER) is
877:
878:

Line 1014: from hr_person_delta_sync per

1010: AND sysdate BETWEEN effective_start_date AND effective_end_date )
1011: OR (padr.last_update_date > P_SYNC_DATE) )
1012: AND (ppf.employee_number,ppf.business_group_id)
1013: not in (select per.employee_number,per.business_group_id
1014: from hr_person_delta_sync per
1015: where ppf.employee_number = per.employee_number
1016: and ppf.business_group_id = per.business_group_id
1017: and ppf.last_update_date = per.last_update_date
1018: and per.status in ('QUEUED','SENT'));

Line 1030: hr_person_delta_sync

1026:
1027: cursor fet_delta_status
1028: is
1029: select employee_number,business_group_id,record_key from
1030: hr_person_delta_sync
1031: where status = 'QUEUED';
1032:
1033: p_employee_number1 varchar2(50);
1034: p_business_group_id1 number(15);

Line 1195: update hr_person_delta_sync

1191: open fet_delta_status;
1192: loop
1193: fetch fet_delta_status into p_business_group_id1,p_employee_number1,p_event_key_gen;
1194: if fet_delta_status%found then
1195: update hr_person_delta_sync
1196: set status = 'SENT'
1197: where record_key = p_event_key_gen;
1198: commit;
1199:

Line 1214: insert into hr_person_delta_sync

1210:
1211: if csr_person_delta_qsync%found then
1212:
1213: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1214: insert into hr_person_delta_sync
1215: (EMPLOYEE_NUMBER,USER_PERSON_TYPE ,
1216: DATE_OF_BIRTH,TOWN_OF_BIRTH,
1217: COUNTRY_OF_BIRTH,BUSINESS_GROUP_ID,
1218: DATE_OF_DEATH,ORIGINAL_DATE_OF_HIRE,

Line 1286: insert into hr_person_delta_sync

1282:
1283: if csr_person_delta_sync%found then
1284:
1285: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
1286: insert into hr_person_delta_sync
1287: (EMPLOYEE_NUMBER,USER_PERSON_TYPE ,
1288: DATE_OF_BIRTH,TOWN_OF_BIRTH,
1289: COUNTRY_OF_BIRTH,BUSINESS_GROUP_ID,
1290: DATE_OF_DEATH,ORIGINAL_DATE_OF_HIRE,

Line 2884: hr_delta_sync_messages.hr_person_delta_sync(ERRBUF,RETCODE,p_party_site_id);

2880: then
2881: hr_delta_sync_messages.hr_location_delta_sync(ERRBUF,RETCODE,p_party_site_id);
2882: elsif p_process_name = 'PERSON_DELTA_SYNCH'
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

Line 2930: update hr_person_delta_sync

2926:
2927: elsif p_process_name = 'PERSON_DELTA_SYNCH'
2928: then
2929:
2930: update hr_person_delta_sync
2931: set status = 'SENT'
2932: where record_key = p_event_key;
2933:
2934: elsif p_process_name = 'WORKFORCE_DELTA_SYNCH'