APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_LOCN_DELTA_SYNC

Line 604: from hr_locn_delta_sync sync

600: hr_locations_all loc
601: where last_update_date > p_max_run_date
602: and (loc.location_id,loc.business_group_id)not in(
603: select sync.location_id,sync.business_group_id
604: from hr_locn_delta_sync sync
605: where loc.location_id = sync.location_id
606: and loc.business_group_id = sync.business_group_id
607: and loc.last_update_date <= sync.last_update_date
608: and sync.status in ('QUEUED','SENT'));

Line 614: hr_locn_delta_sync

610:
611: cursor fet_delta_status
612: is
613: select location_id,business_group_id,event_key from
614: hr_locn_delta_sync
615: where status = 'QUEUED';
616:
617: p_location_id number;
618: p_business_group_id number;

Line 696: update hr_locn_delta_sync

692: fetch fet_delta_status into p_location_id,p_business_group_id,p_event_key_gen;
693:
694: if fet_delta_status%found then
695:
696: update hr_locn_delta_sync
697: set status = 'SENT'
698: where event_key = p_event_key_gen;
699: commit;
700:

Line 709: insert into hr_locn_delta_sync(BUSINESS_GROUP_ID,

705: p_tel_no_3,p_loc_info_13, p_loc_info_14,p_loc_info_15,p_loc_info_16,p_loc_info_17,p_loc_info_18,
706: p_loc_info_19,p_loc_info_20,p_last_update_date;
707: if fet_loc_qsync%found then
708: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
709: insert into hr_locn_delta_sync(BUSINESS_GROUP_ID,
710: LOCATION_ID,
711: EFFECTIVE_DATE,
712: EFFECTIVE_STATUS,
713: LOCATION_CODE,

Line 787: insert into hr_locn_delta_sync(BUSINESS_GROUP_ID,

783: p_tel_no_3,p_loc_info_13, p_loc_info_14,p_loc_info_15,p_loc_info_16,p_loc_info_17,p_loc_info_18,
784: p_loc_info_19,p_loc_info_20,p_last_update_date;
785: if fet_loc_sync%found then
786: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
787: insert into hr_locn_delta_sync(BUSINESS_GROUP_ID,
788: LOCATION_ID,
789: EFFECTIVE_DATE,
790: EFFECTIVE_STATUS,
791: LOCATION_CODE,

Line 2923: update hr_locn_delta_sync

2919:
2920: elsif p_process_name = 'LOCATION_DELTA_SYNCH'
2921: then
2922:
2923: update hr_locn_delta_sync
2924: set status = 'SENT'
2925: where event_key = p_event_key;
2926:
2927: elsif p_process_name = 'PERSON_DELTA_SYNCH'