APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_BGRP_DELTA_SYNC

Line 2433: from hr_bgrp_delta_sync bg

2429: from hr_all_organization_units org
2430: where last_update_date > p_max_run_date
2431: and org.organization_id = org.business_group_id
2432: and (business_group_id) not in (select business_group_id
2433: from hr_bgrp_delta_sync bg
2434: where org.business_group_id = bg.business_group_id
2435: and org.last_update_date <= bg.last_update_date
2436: and bg.status in ('QUEUED','SENT'));
2437:

Line 2441: hr_bgrp_delta_sync

2437:
2438: cursor fet_delta_status
2439: is
2440: select business_group_id,event_key,last_update_date from
2441: hr_bgrp_delta_sync
2442: where status = 'QUEUED';
2443:
2444: p_bgrp_id number(15);
2445: p_lstupd_date date;

Line 2521: update hr_bgrp_delta_sync

2517: fetch fet_delta_status into p_bgrp_id,p_event_key_gen,p_lstupd_date;
2518:
2519: if fet_delta_status%found then
2520:
2521: update hr_bgrp_delta_sync
2522: set status = 'SENT'
2523: where event_key = p_event_key_gen;
2524: commit;
2525:

Line 2531: insert into hr_bgrp_delta_sync(BUSINESS_GROUP_ID,BUSINESS_GROUP_NAME,

2527: fetch fet_bg_sync into p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date;
2528: if fet_bg_sync%found then
2529:
2530: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2531: insert into hr_bgrp_delta_sync(BUSINESS_GROUP_ID,BUSINESS_GROUP_NAME,
2532: EFFECTIVE_DATE,EFFECTIVE_STATUS,LAST_UPDATE_DATE ,STATUS,EFFECTIVE_STATUS_DATE,
2533: EVENT_KEY)
2534: values(p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date,'QUEUED',p_effective_date,
2535: to_char(p_bg_id)||'-'||to_char(p_unique_key));

Line 2573: insert into hr_bgrp_delta_sync(BUSINESS_GROUP_ID,BUSINESS_GROUP_NAME,

2569: loop
2570: fetch fet_bg_fsync into p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date;
2571: if fet_bg_fsync%found then
2572: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2573: insert into hr_bgrp_delta_sync(BUSINESS_GROUP_ID,BUSINESS_GROUP_NAME,
2574: EFFECTIVE_DATE,EFFECTIVE_STATUS,LAST_UPDATE_DATE ,STATUS,EFFECTIVE_STATUS_DATE,
2575: EVENT_KEY)
2576: values(p_bg_id,p_bg_name,p_eff_date,p_eff_status,p_last_update_date,'QUEUED',p_effective_date,
2577: to_char(p_bg_id)||'-'||to_char(p_unique_key));

Line 2955: update hr_bgrp_delta_sync

2951: where event_key = p_event_key;
2952:
2953: elsif p_process_name = 'BUSINESSGROUP_DELTA_SYNCH' then
2954:
2955: update hr_bgrp_delta_sync
2956: set status = 'SENT'
2957: where event_key = p_event_key;
2958:
2959: elsif p_process_name = 'PAYROLL_DELTA_SYNCH' then