[Home] [Help]
4407:
4408: --
4409: SELECT count(*)
4410: INTO chv_cum_adj_rows
4411: FROM chv_cum_adjustments;
4412:
4413: --
4414:
4415: debug_info := 'chv_cum';
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,
4546: chv_schedule_headers = fp_chv_head_rows,
6246: where cpcl.cum_period_id = ca.reference_id
6247: and cpcl.double_check_flag = 'Y'
6248: and ca.reference_type = 'CUM_PERIODS');
6249:
6250: debug_info := 'chv_cum_adjustments';
6251: IF g_debug_switch in ('y','Y') THEN
6252: Print('(Purge_Schedules_by_Cum)'||debug_info);
6253: END IF;
6254:
6251: IF g_debug_switch in ('y','Y') THEN
6252: Print('(Purge_Schedules_by_Cum)'||debug_info);
6253: END IF;
6254:
6255: -- delete_chv_cum_adjustments
6256:
6257: delete from chv_cum_adjustments cca
6258: where exists
6259: (select null
6253: END IF;
6254:
6255: -- delete_chv_cum_adjustments
6256:
6257: delete from chv_cum_adjustments cca
6258: where exists
6259: (select null
6260: from chv_purge_cum_list cpcl
6261: where cpcl.cum_period_id = cca.cum_period_id
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,
7209: chv_schedule_headers = nvl(chv_schedule_headers,0) - chv_head_rows,