APPS.AP_PURGE_PKG dependencies on PO_ASL_ATTRIBUTES

Line 4035: po_asl_attributes = fp_po_asl_attr_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,
4039: chv_cum_periods = fp_chv_cum_rows,

Line 6088: debug_info := 'po_asl_attributes';

6084: from po_vendor_list_entries e
6085: where e.vendor_list_header_id =
6086: h.vendor_list_header_id);
6087:
6088: debug_info := 'po_asl_attributes';
6089: IF g_debug_switch in ('y','Y') THEN
6090: Print('(Purge_Vendors)'||debug_info);
6091: END IF;
6092:

Line 6096: exists (select null from po_asl_attributes paa,

6092:
6093: -- delete po_asl_docments
6094:
6095: delete from po_asl_documents pad where
6096: exists (select null from po_asl_attributes paa,
6097: po_purge_vendor_list pvl
6098: where pvl.vendor_id = paa.vendor_id
6099: and pvl.double_check_flag = 'Y'
6100: and paa.using_organization_id = pad.using_organization_id

Line 6103: -- delete_po_asl_attributes

6099: and pvl.double_check_flag = 'Y'
6100: and paa.using_organization_id = pad.using_organization_id
6101: and paa.asl_id = pad.asl_id);
6102:
6103: -- delete_po_asl_attributes
6104:
6105: delete from po_asl_attributes paa
6106: where exists
6107: (select null

Line 6105: delete from po_asl_attributes paa

6101: and paa.asl_id = pad.asl_id);
6102:
6103: -- delete_po_asl_attributes
6104:
6105: delete from po_asl_attributes paa
6106: where exists
6107: (select null
6108: from po_purge_vendor_list pvl
6109: where pvl.vendor_id = paa.vendor_id

Line 6512: po_asl_attributes = nvl(po_asl_attributes,0) - po_asl_attr_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,
6516: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,