APPS.PO_REQIMP_PKG dependencies on PO_APPROVED_SUPPLIER_LIST

Line 9: g_count NUMBER := 0; -- Bug 3032472 : Counts number of rec in PO_APPROVED_SUPPLIER_LIST

5: l_error_msg po_interface_errors.error_message%TYPE ;
6: l_error_flag number;
7: l_index NATURAL;
8:
9: g_count NUMBER := 0; -- Bug 3032472 : Counts number of rec in PO_APPROVED_SUPPLIER_LIST
10: g_autosource_flag VARCHAR2(1); -- Bug 3032472 : To handle Min-Max set it to global variable. When Min-Max, 'P' will be populated.
11:
12: -- ** Declare exceptions
13: l_incorrect_table EXCEPTION;

Line 386: FROM po_approved_supplier_list pasl,

382: ph.po_header_id,
383: pl.line_num,
384: pl.po_line_id,
385: pl.unit_price
386: FROM po_approved_supplier_list pasl,
387: po_vendors pv,
388: po_vendor_sites_all pvs,
389: po_asl_attributes paa,
390: po_asl_documents pad,

Line 427: FROM po_approved_supplier_list pasl,

423: ph.po_header_id,
424: pl.line_num,
425: pl.po_line_id,
426: pl.unit_price
427: FROM po_approved_supplier_list pasl,
428: po_vendors pv,
429: po_vendor_sites_all pvs,
430: po_asl_attributes paa,
431: po_asl_documents pad,

Line 578: SELECT count(*) INTO g_count FROM PO_APPROVED_SUPPLIER_LIST;

574: l_uom_code := x_uom_code ;
575:
576: END IF ;
577:
578: SELECT count(*) INTO g_count FROM PO_APPROVED_SUPPLIER_LIST;
579:
580:
581: if x_autosource_doc_header_id is not null and
582: x_autosource_doc_line_num is not null then