APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_LINES_ALL

Line 1657: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --

1653: l_quantity_temp PO_LINES.QUANTITY%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);

Line 1666: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL;

1662: x_quote_header_id NUMBER := NULL;
1663: x_quote_line_id NUMBER := NULL;
1664: l_routing_name VARCHAR2 (100);
1665: g_chktype_TRACKING_QTY_IND CONSTANT MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE := 'PS';
1666: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL;
1667: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;
1668: l_uom_convert VARCHAR2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
1669: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;
1670: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;

Line 2032: FROM po_lines_all pol,

2028: SELECT pol.unit_meas_lookup_code,
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;

Line 2690: FROM po_lines_all

2686: IF l_type_lookup_code='BLANKET' AND l_global_agreement_flag='Y' THEN
2687: l_progress := '391';
2688: SELECT negotiated_by_preparer_flag
2689: INTO l_negotiated_by_preparer_flag
2690: FROM po_lines_all
2691: WHERE po_line_id=p_lines.from_line_id_tbl(i);
2692: --if the source document is quotation.
2693: ELSIF l_type_lookup_code ='QUOTATION' THEN
2694: l_progress := '392';