APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_HEADERS_ALL

Line 228: l_blanket_revision PO_HEADERS_ALL.revision_num%TYPE;

224: l_param_list PO_EVENT_PARAMS_TYPE;
225: l_command VARCHAR2(30);
226:
227: l_doc_revision NUMBER;
228: l_blanket_revision PO_HEADERS_ALL.revision_num%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;

Line 230: l_po_number PO_HEADERS_ALL.segment1%TYPE;

226:
227: l_doc_revision NUMBER;
228: l_blanket_revision PO_HEADERS_ALL.revision_num%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:

Line 232: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;

228: l_blanket_revision PO_HEADERS_ALL.revision_num%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:

Line 349: FROM po_headers_all poh

345: d_progress := '250';
346:
347: SELECT poh.shipping_control
348: INTO l_shipping_control
349: FROM po_headers_all poh
350: WHERE poh.po_header_id = p_doc_id;
351:
352: d_progress := '260';
353: END IF;