APPS.AP_PURGE_PKG dependencies on CHV_HORIZONTAL_SCHEDULES

Line 4434: FROM chv_horizontal_schedules;

4430:
4431: --
4432: SELECT count(*)
4433: INTO chv_hor_rows
4434: FROM chv_horizontal_schedules;
4435: --
4436:
4437: debug_info := 'chv_ord';
4438: IF g_debug_switch in ('y','Y') THEN

Line 4544: chv_horizontal_schedules = fp_chv_hor_rows,

4540: po_asl_documents = fp_po_asl_doc_rows,
4541: chv_authorizations = fp_chv_auth_rows,
4542: chv_cum_adjustments = fp_chv_cum_adj_rows,
4543: chv_cum_periods = fp_chv_cum_rows,
4544: chv_horizontal_schedules = fp_chv_hor_rows,
4545: chv_item_orders = fp_chv_ord_rows,
4546: chv_schedule_headers = fp_chv_head_rows,
4547: chv_schedule_items = fp_chv_item_rows,
4548: ap_ae_lines = fp_ae_line_rows,

Line 6188: -- delete_chv_horizontal_schedules

6184: IF g_debug_switch in ('y','Y') THEN
6185: Print('(Purge_Schedules_by_Cum)'||debug_info);
6186: END IF;
6187:
6188: -- delete_chv_horizontal_schedules
6189:
6190: delete from chv_horizontal_Schedules chs
6191: where exists
6192: (select null

Line 6190: delete from chv_horizontal_Schedules chs

6186: END IF;
6187:
6188: -- delete_chv_horizontal_schedules
6189:
6190: delete from chv_horizontal_Schedules chs
6191: where exists
6192: (select null
6193: from chv_purge_schedule_list cpsl
6194: where cpsl.schedule_item_id = chs.schedule_item_id

Line 6427: -- delete_chv_horizontal_schedules

6423: IF g_debug_switch in ('y','Y') THEN
6424: Print('(Purge_Schedules_by_Org)'||debug_info);
6425: END IF;
6426:
6427: -- delete_chv_horizontal_schedules
6428:
6429: delete from chv_horizontal_Schedules chs
6430: where exists
6431: (select null

Line 6429: delete from chv_horizontal_Schedules chs

6425: END IF;
6426:
6427: -- delete_chv_horizontal_schedules
6428:
6429: delete from chv_horizontal_Schedules chs
6430: where exists
6431: (select null
6432: from chv_purge_schedule_list cpsl
6433: where cpsl.schedule_item_id = chs.schedule_item_id

Line 7207: chv_horizontal_Schedules = nvl(chv_horizontal_schedules,0) - chv_hor_rows,

7203: po_asl_documents = nvl(po_asl_documents,0) - po_asl_doc_rows,
7204: chv_authorizations = nvl(chv_authorizations,0) - chv_auth_rows,
7205: chv_cum_adjustments = nvl(chv_cum_adjustments,0) - chv_cum_adj_rows,
7206: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,
7207: chv_horizontal_Schedules = nvl(chv_horizontal_schedules,0) - chv_hor_rows,
7208: chv_item_orders = nvl(chv_item_orders,0) - chv_ord_rows,
7209: chv_schedule_headers = nvl(chv_schedule_headers,0) - chv_head_rows,
7210: chv_schedule_items = nvl(chv_schedule_items,0) - chv_item_rows,
7211: ap_ae_lines = nvl(ap_ae_lines,0) - ae_line_rows,