APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_ORGANIZATION_DELTA_SYNC

Line 2179: from hr_organization_delta_sync orgn

2175: and nvl(org.date_to, to_date('31-12-4712', 'DD-MM-YYYY'))
2176: and sysdate between mgr.start_date(+) and mgr.end_date(+)
2177: and org.last_update_date > p_max_run_date
2178: and (org.business_group_id,org.organization_id) not in (select orgn.business_group_id,orgn.organization_id
2179: from hr_organization_delta_sync orgn
2180: where org.business_group_id = orgn.business_group_id
2181: and org.organization_id = orgn.organization_id
2182: and org.last_update_date <= orgn.last_update_date
2183: and orgn.status in ('QUEUED','SENT'));

Line 2193: hr_organization_delta_sync

2189:
2190: cursor fet_delta_status
2191: is
2192: select business_group_id,organization_id,event_key,last_update_date from
2193: hr_organization_delta_sync
2194: where status = 'QUEUED';
2195:
2196: p_bgrp_id number(15);
2197: p_orgn_id number(15);

Line 2281: update hr_organization_delta_sync

2277: fetch fet_delta_status into p_bgrp_id,p_orgn_id,p_event_key_gen,p_lstupd_date;
2278:
2279: if fet_delta_status%found then
2280:
2281: update hr_organization_delta_sync
2282: set status = 'SENT'
2283: where event_key = p_event_key_gen;
2284: commit;
2285:

Line 2291: insert into hr_organization_delta_sync(BUSINESS_GROUP_ID,

2287: fetch fet_orgn_sync into p_bg_id,p_dept_id,p_eff_date,p_eff_status,p_bg_name,p_loc_id,p_person_id,p_full_name,p_last_update_date;
2288: if fet_orgn_sync%found then
2289:
2290: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2291: insert into hr_organization_delta_sync(BUSINESS_GROUP_ID,
2292: ORGANIZATION_ID,
2293: BUSINESS_GROUP_NAME ,
2294: EFFECTIVE_DATE,
2295: EFFECTIVE_STATUS ,

Line 2345: insert into hr_organization_delta_sync(BUSINESS_GROUP_ID,

2341: loop
2342: fetch fet_orgn_fsync into p_bg_id,p_dept_id,p_eff_date,p_eff_status,p_bg_name,p_loc_id,p_person_id,p_full_name,p_last_update_date;
2343: if fet_orgn_fsync%found then
2344: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2345: insert into hr_organization_delta_sync(BUSINESS_GROUP_ID,
2346: ORGANIZATION_ID,
2347: BUSINESS_GROUP_NAME ,
2348: EFFECTIVE_DATE,
2349: EFFECTIVE_STATUS ,

Line 2949: update hr_organization_delta_sync

2945: where event_key = p_event_key;
2946:
2947: elsif p_process_name = 'ORGANIZATION_DELTA_SYNCH' then
2948:
2949: update hr_organization_delta_sync
2950: set status = 'SENT'
2951: where event_key = p_event_key;
2952:
2953: elsif p_process_name = 'BUSINESSGROUP_DELTA_SYNCH' then