APPS.AP_PURGE_PKG dependencies on CHV_ITEM_ORDERS

Line 3941: FROM chv_item_orders;

3937:
3938: --
3939: SELECT count(*)
3940: INTO chv_ord_rows
3941: FROM chv_item_orders;
3942: --
3943:
3944: debug_info := 'chv_head';
3945: IF g_debug_switch in ('y','Y') THEN

Line 4041: chv_item_orders = fp_chv_ord_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,
4045: ap_ae_headers = fp_ae_header_rows,

Line 5608: debug_info := 'chv_item_orders';

5604: where cpsl.schedule_item_id = csi.schedule_item_id
5605: and cpsl.double_check_flag = 'Y'
5606: and cpsl.schedule_item_id between range_low and range_high);
5607:
5608: debug_info := 'chv_item_orders';
5609: IF g_debug_switch in ('y','Y') THEN
5610: Print('(Purge_Schedules_by_Cum)'||debug_info);
5611: END IF;
5612:

Line 5613: -- delete_chv_item_orders

5609: IF g_debug_switch in ('y','Y') THEN
5610: Print('(Purge_Schedules_by_Cum)'||debug_info);
5611: END IF;
5612:
5613: -- delete_chv_item_orders
5614:
5615: delete from chv_item_orders cio
5616: where exists
5617: (select null

Line 5615: delete from chv_item_orders cio

5611: END IF;
5612:
5613: -- delete_chv_item_orders
5614:
5615: delete from chv_item_orders cio
5616: where exists
5617: (select null
5618: from chv_purge_schedule_list cpsl
5619: where cpsl.schedule_item_id = cio.schedule_item_id

Line 5847: debug_info := 'chv_item_orders';

5843: where cpsl.schedule_item_id = csi.schedule_item_id
5844: and cpsl.double_check_flag = 'Y'
5845: and cpsl.schedule_item_id between range_low and range_high);
5846:
5847: debug_info := 'chv_item_orders';
5848: IF g_debug_switch in ('y','Y') THEN
5849: Print('(Purge_Schedules_by_Org)'||debug_info);
5850: END IF;
5851:

Line 5852: -- delete_chv_item_orders

5848: IF g_debug_switch in ('y','Y') THEN
5849: Print('(Purge_Schedules_by_Org)'||debug_info);
5850: END IF;
5851:
5852: -- delete_chv_item_orders
5853:
5854: delete from chv_item_orders cio
5855: where exists
5856: (select null

Line 5854: delete from chv_item_orders cio

5850: END IF;
5851:
5852: -- delete_chv_item_orders
5853:
5854: delete from chv_item_orders cio
5855: where exists
5856: (select null
5857: from chv_purge_schedule_list cpsl
5858: where cpsl.schedule_item_id = cio.schedule_item_id

Line 6518: chv_item_orders = nvl(chv_item_orders,0) - chv_ord_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,
6522: ap_ae_headers = nvl(ap_ae_headers,0) - ae_header_rows,