APPS.PO_AUTO_HEADER_PROCESS_PVT dependencies on PO_HEADERS_ALL

Line 14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

10: g_vendor_bill_to_loc_id NUMBER;
11: g_terms_id PO_HEADERS.terms_id%TYPE;
12: g_fob PO_HEADERS.fob_lookup_code%TYPE;
13: g_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;
16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;
17: g_vs_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
18: g_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

Line 18: g_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

14: g_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
15: g_vs_terms_id PO_HEADERS.terms_id%TYPE;
16: g_vs_fob PO_HEADERS.fob_lookup_code%TYPE;
17: g_vs_freight_term PO_HEADERS.freight_terms_lookup_code%TYPE;
18: g_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
19:
20: /* -------------------------------------------------------
21: ---------------- PRIVATE PROCEDURES -------------------
22: ------------------------------------------------------- */

Line 639: FROM po_headers_all PH,

635: x_headers.clm_external_idv,
636: x_headers.clm_contract_officer, --bug 12987412
637: x_headers.umbrella_program_id, --umbrella program
638: x_headers.fon_ref_id --umbrella program
639: FROM po_headers_all PH,
640: po_headers_interface PHI
641: WHERE PH.SEGMENT1 = REPLACE(PHI.DOCUMENT_NUM,'-')
642: AND PHI.interface_header_id = p_interface_header_id;
643:

Line 738: FROM po_headers_all ph

734: l_progress := '010';
735:
736: SELECT ph.po_header_id
737: INTO x_headers.po_header_id
738: FROM po_headers_all ph
739: WHERE ph.type_lookup_code = PO_AUTOCREATE_PARAMS.g_document_subtype
740: AND ph.segment1 = REPLACE(x_headers.document_num,'-')
741: AND NVL(org_id, -99) = NVL(PO_AUTOCREATE_PARAMS.g_purchasing_ou_id, -99);
742:

Line 1563: FROM po_headers_all

1559: supplier_notif_method, --Bug13547051 In add to mode the communication should be copied from the base award.
1560: fax, --Bug13547051
1561: email_address, --Bug13547051
1562: clm_effective_date --Bug13547051
1563: FROM po_headers_all
1564: WHERE po_header_id = x_headers.po_header_id;
1565:
1566: l_progress := '050';
1567: UPDATE po_headers_draft_all