[Home] [Help]
3903:
3904: --
3905: SELECT count(*)
3906: INTO chv_cum_adj_rows
3907: FROM chv_cum_adjustments;
3908:
3909: --
3910:
3911: debug_info := 'chv_cum';
4034: po_approved_supplier_list = fp_po_asl_rows,
4035: po_asl_attributes = fp_po_asl_attr_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,
5686: where cpcl.cum_period_id = ca.reference_id
5687: and cpcl.double_check_flag = 'Y'
5688: and ca.reference_type = 'CUM_PERIODS');
5689:
5690: debug_info := 'chv_cum_adjustments';
5691: IF g_debug_switch in ('y','Y') THEN
5692: Print('(Purge_Schedules_by_Cum)'||debug_info);
5693: END IF;
5694:
5691: IF g_debug_switch in ('y','Y') THEN
5692: Print('(Purge_Schedules_by_Cum)'||debug_info);
5693: END IF;
5694:
5695: -- delete_chv_cum_adjustments
5696:
5697: delete from chv_cum_adjustments cca
5698: where exists
5699: (select null
5693: END IF;
5694:
5695: -- delete_chv_cum_adjustments
5696:
5697: delete from chv_cum_adjustments cca
5698: where exists
5699: (select null
5700: from chv_purge_cum_list cpcl
5701: where cpcl.cum_period_id = cca.cum_period_id
6511: po_approved_supplier_list = nvl(po_approved_supplier_list,0) - po_asl_rows,
6512: po_asl_attributes = nvl(po_asl_attributes,0) - po_asl_attr_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,