APPS.AP_PURGE_PKG dependencies on CHV_ITEM_ORDERS

Line 4445: FROM chv_item_orders;

4441:
4442: --
4443: SELECT count(*)
4444: INTO chv_ord_rows
4445: FROM chv_item_orders;
4446: --
4447:
4448: debug_info := 'chv_head';
4449: IF g_debug_switch in ('y','Y') THEN

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

Line 6168: debug_info := 'chv_item_orders';

6164: where cpsl.schedule_item_id = csi.schedule_item_id
6165: and cpsl.double_check_flag = 'Y'
6166: and cpsl.schedule_item_id between range_low and range_high);
6167:
6168: debug_info := 'chv_item_orders';
6169: IF g_debug_switch in ('y','Y') THEN
6170: Print('(Purge_Schedules_by_Cum)'||debug_info);
6171: END IF;
6172:

Line 6173: -- delete_chv_item_orders

6169: IF g_debug_switch in ('y','Y') THEN
6170: Print('(Purge_Schedules_by_Cum)'||debug_info);
6171: END IF;
6172:
6173: -- delete_chv_item_orders
6174:
6175: delete from chv_item_orders cio
6176: where exists
6177: (select null

Line 6175: delete from chv_item_orders cio

6171: END IF;
6172:
6173: -- delete_chv_item_orders
6174:
6175: delete from chv_item_orders cio
6176: where exists
6177: (select null
6178: from chv_purge_schedule_list cpsl
6179: where cpsl.schedule_item_id = cio.schedule_item_id

Line 6407: debug_info := 'chv_item_orders';

6403: where cpsl.schedule_item_id = csi.schedule_item_id
6404: and cpsl.double_check_flag = 'Y'
6405: and cpsl.schedule_item_id between range_low and range_high);
6406:
6407: debug_info := 'chv_item_orders';
6408: IF g_debug_switch in ('y','Y') THEN
6409: Print('(Purge_Schedules_by_Org)'||debug_info);
6410: END IF;
6411:

Line 6412: -- delete_chv_item_orders

6408: IF g_debug_switch in ('y','Y') THEN
6409: Print('(Purge_Schedules_by_Org)'||debug_info);
6410: END IF;
6411:
6412: -- delete_chv_item_orders
6413:
6414: delete from chv_item_orders cio
6415: where exists
6416: (select null

Line 6414: delete from chv_item_orders cio

6410: END IF;
6411:
6412: -- delete_chv_item_orders
6413:
6414: delete from chv_item_orders cio
6415: where exists
6416: (select null
6417: from chv_purge_schedule_list cpsl
6418: where cpsl.schedule_item_id = cio.schedule_item_id

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