APPS.AP_PURGE_PKG dependencies on CHV_PURGE_CUM_LIST

Line 1285: insert into chv_purge_cum_list

1281: Print('(seed_chv_by_cum)' ||debug_info);
1282: END IF;
1283:
1284: --
1285: insert into chv_purge_cum_list
1286: (cum_period_id,
1287: purge_name,
1288: double_check_flag)
1289: select ccp.cum_period_id,

Line 1311: chv_purge_cum_list cpcl,

1307: p_purge_name,
1308: 'Y'
1309: from chv_schedule_items csi,
1310: chv_schedule_headers csh,
1311: chv_purge_cum_list cpcl,
1312: chv_cum_periods ccp
1313: where csh.schedule_id = csi.schedule_id
1314: and csh.schedule_horizon_start between ccp.cum_period_start_date
1315: and ccp.cum_period_end_date

Line 2463: from chv_purge_cum_list cpcl,

2459: ccp.cum_period_start_date,
2460: ccp.cum_period_end_date,
2461: ccp.creation_date,
2462: p_purge_name
2463: from chv_purge_cum_list cpcl,
2464: chv_cum_periods ccp
2465: where cpcl.cum_period_id = ccp.cum_period_id
2466: and cpcl.double_check_flag = 'Y';
2467: COMMIT;

Line 3718: update chv_purge_cum_list cpcl

3714: END IF;
3715:
3716: --
3717:
3718: update chv_purge_cum_list cpcl
3719: set double_check_flag = 'N'
3720: where cpcl.double_check_flag = 'Y'
3721: and not exists (select null from chv_cum_periods ccp
3722: where ccp.organization_id = g_organization_id

Line 3740: chv_purge_cum_list cpcl

3736: where cpsl.double_check_flag = 'Y'
3737: and not exists (select null from chv_schedule_items csi,
3738: chv_schedule_headers csh,
3739: chv_cum_periods ccp,
3740: chv_purge_cum_list cpcl
3741: where csh.schedule_id = csi.schedule_id
3742: and csh.schedule_horizon_start between ccp.cum_period_start_date
3743: and ccp.cum_period_end_date
3744: and ccp.cum_period_id = cpcl.cum_period_id

Line 5685: from chv_purge_cum_list cpcl

5681:
5682: delete from chv_authorizations ca
5683: where exists
5684: (select null
5685: from chv_purge_cum_list cpcl
5686: where cpcl.cum_period_id = ca.reference_id
5687: and cpcl.double_check_flag = 'Y'
5688: and ca.reference_type = 'CUM_PERIODS');
5689:

Line 5700: from chv_purge_cum_list cpcl

5696:
5697: delete from chv_cum_adjustments cca
5698: where exists
5699: (select null
5700: from chv_purge_cum_list cpcl
5701: where cpcl.cum_period_id = cca.cum_period_id
5702: and cpcl.double_check_flag = 'Y');
5703:
5704: debug_info := 'chv_cum_periods';

Line 5714: from chv_purge_cum_list cpcl

5710:
5711: delete from chv_cum_periods ccp
5712: where exists
5713: (select null
5714: from chv_purge_cum_list cpcl
5715: where cpcl.cum_period_id = ccp.cum_period_id
5716: and cpcl.double_check_flag = 'Y');
5717:
5718: debug_info := 'chv_schedule_items';

Line 6566: delete from chv_purge_cum_list;

6562: -- clear_schedule_list
6563: delete from chv_purge_schedule_list;
6564:
6565: -- clear_cum_list
6566: delete from chv_purge_cum_list;
6567:
6568: l_status := 'COMPLETED-PURGED';
6569:
6570: -- set_purge_status

Line 6643: delete from chv_purge_cum_list;

6639: FUNCTION CLEAR_CHV_CUM_LIST RETURN BOOLEAN IS
6640: BEGIN
6641:
6642: delete from chv_purge_schedule_list;
6643: delete from chv_purge_cum_list;
6644:
6645: RETURN (TRUE);
6646:
6647: RETURN NULL; EXCEPTION