DBA Data[Home] [Help]

APPS.PO_AUTO_LINE_LOC_PROCESS_PVT dependencies on PO_HEADERS_ALL

Line 120: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;

116: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
117: l_manual_price_change_flag po_line_locations_all.manual_price_change_flag%TYPE := NULL; --bug 3495772
118:
119:
120: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;
121:
122: --
123: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
124: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

Line 232: FROM po_headers_all poh

228:
229: BEGIN
230: SELECT poh.type_lookup_code
231: INTO l_from_type_lookup_code
232: FROM po_headers_all poh
233: WHERE poh.po_header_id=p_lines.from_header_id_tbl(i) ;
234:
235: IF g_debug_stmt THEN
236: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'l_from_type_lookup_code :'||l_from_type_lookup_code);