APPS.AP_PURGE_PKG dependencies on CHV_AUTHORIZATIONS

Line 4399: FROM chv_authorizations;

4395:
4396: --
4397: SELECT count(*)
4398: INTO chv_auth_rows
4399: FROM chv_authorizations;
4400:
4401: --
4402:
4403: debug_info := 'chv_cum_adj';

Line 4541: chv_authorizations = fp_chv_auth_rows,

4537: po_vendors = fp_vendor_rows,
4538: po_approved_supplier_list = fp_po_asl_rows,
4539: po_asl_attributes = fp_po_asl_attr_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,

Line 6198: debug_info := 'chv_authorizations';

6194: where cpsl.schedule_item_id = chs.schedule_item_id
6195: and cpsl.double_check_flag = 'Y'
6196: and cpsl.schedule_item_id between range_low and range_high);
6197:
6198: debug_info := 'chv_authorizations';
6199: IF g_debug_switch in ('y','Y') THEN
6200: Print('(Purge_Schedules_by_Cum)'||debug_info);
6201: END IF;
6202:

Line 6203: -- delete_chv_authorizations

6199: IF g_debug_switch in ('y','Y') THEN
6200: Print('(Purge_Schedules_by_Cum)'||debug_info);
6201: END IF;
6202:
6203: -- delete_chv_authorizations
6204:
6205: delete from chv_authorizations ca
6206: where exists
6207: (select null

Line 6205: delete from chv_authorizations ca

6201: END IF;
6202:
6203: -- delete_chv_authorizations
6204:
6205: delete from chv_authorizations ca
6206: where exists
6207: (select null
6208: from chv_purge_schedule_list cpsl
6209: where cpsl.schedule_item_id = ca.reference_id

Line 6240: -- delete_chv_authorizations

6236: IF g_debug_switch in ('y','Y') THEN
6237: Print('(Purge_Schedules_by_Cum)'||debug_info);
6238: END IF;
6239:
6240: -- delete_chv_authorizations
6241:
6242: delete from chv_authorizations ca
6243: where exists
6244: (select null

Line 6242: delete from chv_authorizations ca

6238: END IF;
6239:
6240: -- delete_chv_authorizations
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

Line 6437: debug_info := 'chv_authorizations';

6433: where cpsl.schedule_item_id = chs.schedule_item_id
6434: and cpsl.double_check_flag = 'Y'
6435: and cpsl.schedule_item_id between range_low and range_high);
6436:
6437: debug_info := 'chv_authorizations';
6438: IF g_debug_switch in ('y','Y') THEN
6439: Print('(Purge_Schedules_by_Org)'||debug_info);
6440: END IF;
6441:

Line 6442: -- delete_chv_authorizations

6438: IF g_debug_switch in ('y','Y') THEN
6439: Print('(Purge_Schedules_by_Org)'||debug_info);
6440: END IF;
6441:
6442: -- delete_chv_authorizations
6443:
6444: delete from chv_authorizations ca
6445: where exists
6446: (select null

Line 6444: delete from chv_authorizations ca

6440: END IF;
6441:
6442: -- delete_chv_authorizations
6443:
6444: delete from chv_authorizations ca
6445: where exists
6446: (select null
6447: from chv_purge_schedule_list cpsl
6448: where cpsl.schedule_item_id = ca.reference_id

Line 7204: chv_authorizations = nvl(chv_authorizations,0) - chv_auth_rows,

7200: po_receipts = nvl(po_receipts, 0) - shipment_line_rows,
7201: po_approved_supplier_list = nvl(po_approved_supplier_list,0) - po_asl_rows,
7202: po_asl_attributes = nvl(po_asl_attributes,0) - po_asl_attr_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,