APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_HEADERS_ALL

Line 1658: l_type_lookup_code po_headers_all.type_lookup_code%type; --

1654: --
1655: l_base_unit_price po_lines.base_unit_price%TYPE := NULL; --
1656: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;
1657: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
1658: l_type_lookup_code po_headers_all.type_lookup_code%type; --
1659: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --
1660: l_needby_prf VARCHAR2(1);
1661: l_shipto_prf VARCHAR2(1);
1662: x_quote_header_id NUMBER := NULL;

Line 1659: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --

1655: l_base_unit_price po_lines.base_unit_price%TYPE := NULL; --
1656: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;
1657: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
1658: l_type_lookup_code po_headers_all.type_lookup_code%type; --
1659: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --
1660: l_needby_prf VARCHAR2(1);
1661: l_shipto_prf VARCHAR2(1);
1662: x_quote_header_id NUMBER := NULL;
1663: x_quote_line_id NUMBER := NULL;

Line 2033: po_headers_all poh

2029: poh.type_lookup_code
2030: INTO l_ga_uom,
2031: l_from_type_lookup_code
2032: FROM po_lines_all pol,
2033: po_headers_all poh
2034: WHERE pol.po_line_id = p_lines.from_line_id_tbl(i)
2035: AND poh.po_header_id =p_lines.from_header_id_tbl(i)
2036: AND poh.po_header_id =pol.po_header_id;
2037: EXCEPTION

Line 2682: FROM po_headers_all

2678: SELECT type_lookup_code,
2679: global_agreement_flag
2680: INTO l_type_lookup_code,
2681: l_global_agreement_flag
2682: FROM po_headers_all
2683: WHERE po_header_id=p_lines.from_header_id_tbl(i);
2684:
2685: -- if the source document is global agreement.
2686: IF l_type_lookup_code='BLANKET' AND l_global_agreement_flag='Y' THEN