DBA Data[Home] [Help]

APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_LINES_ALL

Line 233: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --

229: l_org_name HR_ALL_ORGANIZATION_UNITS.name%TYPE;
230: l_po_number PO_HEADERS_ALL.segment1%TYPE;
231: l_release_number PO_RELEASES_ALL.release_num%TYPE;
232: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;
233: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --
234:
235: l_return_status VARCHAR2(1);
236:
237: d_progress VARCHAR2(3);

Line 280: FROM po_lines_all pol

276: --level for the PO then we will still get the p_line_id.
277: IF (p_doc_type = 'PO' AND p_line_id IS NOT NULL) THEN
278: SELECT pol.order_type_lookup_code
279: INTO l_line_value_basis
280: FROM po_lines_all pol
281: WHERE pol.po_line_id = p_line_id;
282: --If the action is at the shipment level for a release we will not get the p_line_id
283: ELSIF (p_doc_type = 'RELEASE' AND p_line_loc_id IS NOT NULL) THEN
284: SELECT pol.order_type_lookup_code

Line 286: FROM po_lines_all pol,

282: --If the action is at the shipment level for a release we will not get the p_line_id
283: ELSIF (p_doc_type = 'RELEASE' AND p_line_loc_id IS NOT NULL) THEN
284: SELECT pol.order_type_lookup_code
285: INTO l_line_value_basis
286: FROM po_lines_all pol,
287: po_line_locations_all pll
288: WHERE pll.line_location_id = p_line_loc_id
289: AND pll.po_line_id = pol.po_line_id;
290: END IF;