APPS.AP_PURGE_PKG dependencies on CHV_HORIZONTAL_SCHEDULES

Line 3930: FROM chv_horizontal_schedules;

3926:
3927: --
3928: SELECT count(*)
3929: INTO chv_hor_rows
3930: FROM chv_horizontal_schedules;
3931: --
3932:
3933: debug_info := 'chv_ord';
3934: IF g_debug_switch in ('y','Y') THEN

Line 4040: chv_horizontal_schedules = fp_chv_hor_rows,

4036: po_asl_documents = fp_po_asl_doc_rows,
4037: chv_authorizations = fp_chv_auth_rows,
4038: chv_cum_adjustments = fp_chv_cum_adj_rows,
4039: chv_cum_periods = fp_chv_cum_rows,
4040: chv_horizontal_schedules = fp_chv_hor_rows,
4041: chv_item_orders = fp_chv_ord_rows,
4042: chv_schedule_headers = fp_chv_head_rows,
4043: chv_schedule_items = fp_chv_item_rows,
4044: ap_ae_lines = fp_ae_line_rows,

Line 5628: -- delete_chv_horizontal_schedules

5624: IF g_debug_switch in ('y','Y') THEN
5625: Print('(Purge_Schedules_by_Cum)'||debug_info);
5626: END IF;
5627:
5628: -- delete_chv_horizontal_schedules
5629:
5630: delete from chv_horizontal_Schedules chs
5631: where exists
5632: (select null

Line 5630: delete from chv_horizontal_Schedules chs

5626: END IF;
5627:
5628: -- delete_chv_horizontal_schedules
5629:
5630: delete from chv_horizontal_Schedules chs
5631: where exists
5632: (select null
5633: from chv_purge_schedule_list cpsl
5634: where cpsl.schedule_item_id = chs.schedule_item_id

Line 5867: -- delete_chv_horizontal_schedules

5863: IF g_debug_switch in ('y','Y') THEN
5864: Print('(Purge_Schedules_by_Org)'||debug_info);
5865: END IF;
5866:
5867: -- delete_chv_horizontal_schedules
5868:
5869: delete from chv_horizontal_Schedules chs
5870: where exists
5871: (select null

Line 5869: delete from chv_horizontal_Schedules chs

5865: END IF;
5866:
5867: -- delete_chv_horizontal_schedules
5868:
5869: delete from chv_horizontal_Schedules chs
5870: where exists
5871: (select null
5872: from chv_purge_schedule_list cpsl
5873: where cpsl.schedule_item_id = chs.schedule_item_id

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

6513: po_asl_documents = nvl(po_asl_documents,0) - po_asl_doc_rows,
6514: chv_authorizations = nvl(chv_authorizations,0) - chv_auth_rows,
6515: chv_cum_adjustments = nvl(chv_cum_adjustments,0) - chv_cum_adj_rows,
6516: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,
6517: chv_horizontal_Schedules = nvl(chv_horizontal_schedules,0) - chv_hor_rows,
6518: chv_item_orders = nvl(chv_item_orders,0) - chv_ord_rows,
6519: chv_schedule_headers = nvl(chv_schedule_headers,0) - chv_head_rows,
6520: chv_schedule_items = nvl(chv_schedule_items,0) - chv_item_rows,
6521: ap_ae_lines = nvl(ap_ae_lines,0) - ae_line_rows,