APPS.AP_PURGE_PKG dependencies on CHV_PURGE_CUM_LIST

Line 1449: insert into chv_purge_cum_list

1445: Print('(seed_chv_by_cum)' ||debug_info);
1446: END IF;
1447:
1448: --
1449: insert into chv_purge_cum_list
1450: (cum_period_id,
1451: purge_name,
1452: double_check_flag)
1453: select ccp.cum_period_id,

Line 1475: chv_purge_cum_list cpcl,

1471: p_purge_name,
1472: 'Y'
1473: from chv_schedule_items csi,
1474: chv_schedule_headers csh,
1475: chv_purge_cum_list cpcl,
1476: chv_cum_periods ccp
1477: where csh.schedule_id = csi.schedule_id
1478: and csh.schedule_horizon_start between ccp.cum_period_start_date
1479: and ccp.cum_period_end_date

Line 2718: from chv_purge_cum_list cpcl,

2714: ccp.cum_period_start_date,
2715: ccp.cum_period_end_date,
2716: ccp.creation_date,
2717: p_purge_name
2718: from chv_purge_cum_list cpcl,
2719: chv_cum_periods ccp
2720: where cpcl.cum_period_id = ccp.cum_period_id
2721: and cpcl.double_check_flag = 'Y';
2722: COMMIT;

Line 4222: update chv_purge_cum_list cpcl

4218: END IF;
4219:
4220: --
4221:
4222: update chv_purge_cum_list cpcl
4223: set double_check_flag = 'N'
4224: where cpcl.double_check_flag = 'Y'
4225: and not exists (select null from chv_cum_periods ccp
4226: where ccp.organization_id = g_organization_id

Line 4244: chv_purge_cum_list cpcl

4240: where cpsl.double_check_flag = 'Y'
4241: and not exists (select null from chv_schedule_items csi,
4242: chv_schedule_headers csh,
4243: chv_cum_periods ccp,
4244: chv_purge_cum_list cpcl
4245: where csh.schedule_id = csi.schedule_id
4246: and csh.schedule_horizon_start between ccp.cum_period_start_date
4247: and ccp.cum_period_end_date
4248: and ccp.cum_period_id = cpcl.cum_period_id

Line 6245: from chv_purge_cum_list cpcl

6241:
6242: delete from chv_authorizations ca
6243: where exists
6244: (select null
6245: from chv_purge_cum_list cpcl
6246: where cpcl.cum_period_id = ca.reference_id
6247: and cpcl.double_check_flag = 'Y'
6248: and ca.reference_type = 'CUM_PERIODS');
6249:

Line 6260: from chv_purge_cum_list cpcl

6256:
6257: delete from chv_cum_adjustments cca
6258: where exists
6259: (select null
6260: from chv_purge_cum_list cpcl
6261: where cpcl.cum_period_id = cca.cum_period_id
6262: and cpcl.double_check_flag = 'Y');
6263:
6264: debug_info := 'chv_cum_periods';

Line 6274: from chv_purge_cum_list cpcl

6270:
6271: delete from chv_cum_periods ccp
6272: where exists
6273: (select null
6274: from chv_purge_cum_list cpcl
6275: where cpcl.cum_period_id = ccp.cum_period_id
6276: and cpcl.double_check_flag = 'Y');
6277:
6278: debug_info := 'chv_schedule_items';

Line 7273: delete from chv_purge_cum_list;

7269: -- clear_schedule_list
7270: delete from chv_purge_schedule_list;
7271:
7272: -- clear_cum_list
7273: delete from chv_purge_cum_list;
7274:
7275: l_status := 'COMPLETED-PURGED';
7276:
7277: -- set_purge_status

Line 7350: delete from chv_purge_cum_list;

7346: FUNCTION CLEAR_CHV_CUM_LIST RETURN BOOLEAN IS
7347: BEGIN
7348:
7349: delete from chv_purge_schedule_list;
7350: delete from chv_purge_cum_list;
7351:
7352: RETURN (TRUE);
7353:
7354: RETURN NULL; EXCEPTION