[Home] [Help]
4030: po_headers = fp_po_header_rows ,
4031: po_receipts = fp_receipt_line_rows,
4032: po_requisition_headers = fp_req_header_rows,
4033: po_vendors = fp_vendor_rows,
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,
6108: from po_purge_vendor_list pvl
6109: where pvl.vendor_id = paa.vendor_id
6110: and pvl.double_check_flag = 'Y');
6111:
6112: debug_info := 'po_approved_supplier_list';
6113: IF g_debug_switch in ('y','Y') THEN
6114: Print('(Purge_Vendors)'||debug_info);
6115: END IF;
6116:
6113: IF g_debug_switch in ('y','Y') THEN
6114: Print('(Purge_Vendors)'||debug_info);
6115: END IF;
6116:
6117: -- delete_po_approved_supplier_list
6118:
6119: delete from po_approved_supplier_list pasl
6120: where exists
6121: (select null
6115: END IF;
6116:
6117: -- delete_po_approved_supplier_list
6118:
6119: delete from po_approved_supplier_list pasl
6120: where exists
6121: (select null
6122: from po_purge_vendor_list pvl
6123: where pvl.vendor_id = pasl.vendor_id
6507: po_headers = nvl(po_headers, 0) - po_header_rows,
6508: po_requisition_headers = nvl(po_requisition_headers, 0) - req_header_rows,
6509: po_vendors = nvl(po_vendors, 0) - vendor_rows,
6510: po_receipts = nvl(po_receipts, 0) - shipment_line_rows,
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,