APPS.AP_PURGE_PKG dependencies on PO_ASL_ATTRIBUTES

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

Line 6664: debug_info := 'po_asl_attributes';

6660: from po_vendor_list_entries e
6661: where e.vendor_list_header_id =
6662: h.vendor_list_header_id);
6663:
6664: debug_info := 'po_asl_attributes';
6665: IF g_debug_switch in ('y','Y') THEN
6666: Print('(Purge_Vendors)'||debug_info);
6667: END IF;
6668:

Line 6672: exists (select null from po_asl_attributes paa,

6668:
6669: -- delete po_asl_docments
6670:
6671: delete from po_asl_documents pad where
6672: exists (select null from po_asl_attributes paa,
6673: po_purge_vendor_list pvl
6674: where pvl.vendor_id = paa.vendor_id
6675: and pvl.double_check_flag = 'Y'
6676: and paa.using_organization_id = pad.using_organization_id

Line 6679: -- delete_po_asl_attributes

6675: and pvl.double_check_flag = 'Y'
6676: and paa.using_organization_id = pad.using_organization_id
6677: and paa.asl_id = pad.asl_id);
6678:
6679: -- delete_po_asl_attributes
6680:
6681: delete from po_asl_attributes paa
6682: where exists
6683: (select null

Line 6681: delete from po_asl_attributes paa

6677: and paa.asl_id = pad.asl_id);
6678:
6679: -- delete_po_asl_attributes
6680:
6681: delete from po_asl_attributes paa
6682: where exists
6683: (select null
6684: from po_purge_vendor_list pvl
6685: where pvl.vendor_id = paa.vendor_id

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