[Home] [Help]
4534: po_headers = fp_po_header_rows ,
4535: po_receipts = fp_receipt_line_rows,
4536: po_requisition_headers = fp_req_header_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,
6684: from po_purge_vendor_list pvl
6685: where pvl.vendor_id = paa.vendor_id
6686: and pvl.double_check_flag = 'Y');
6687:
6688: debug_info := 'po_approved_supplier_list';
6689: IF g_debug_switch in ('y','Y') THEN
6690: Print('(Purge_Vendors)'||debug_info);
6691: END IF;
6692:
6689: IF g_debug_switch in ('y','Y') THEN
6690: Print('(Purge_Vendors)'||debug_info);
6691: END IF;
6692:
6693: -- delete_po_approved_supplier_list
6694:
6695: delete from po_approved_supplier_list pasl
6696: where exists
6697: (select null
6691: END IF;
6692:
6693: -- delete_po_approved_supplier_list
6694:
6695: delete from po_approved_supplier_list pasl
6696: where exists
6697: (select null
6698: from po_purge_vendor_list pvl
6699: where pvl.vendor_id = pasl.vendor_id
7197: po_headers = nvl(po_headers, 0) - po_header_rows,
7198: po_requisition_headers = nvl(po_requisition_headers, 0) - req_header_rows,
7199: po_vendors = nvl(po_vendors, 0) - vendor_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,