APPS.PO_AUTO_IMPLEMENT_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 37: x_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

33:
34: x_info_slin_falg VARCHAR2(1) := 'N';
35:
36: x_group_line_id PO_REQUISITION_LINES_ALL.group_line_id%TYPE;
37: x_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
38: x_po_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
39: x_po_line_num PO_LINES_ALL.line_num%TYPE;
40:
41: -- Headers Interface

Line 38: x_po_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;

34: x_info_slin_falg VARCHAR2(1) := 'N';
35:
36: x_group_line_id PO_REQUISITION_LINES_ALL.group_line_id%TYPE;
37: x_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
38: x_po_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
39: x_po_line_num PO_LINES_ALL.line_num%TYPE;
40:
41: -- Headers Interface
42: x_interface_header_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;

Line 268: FROM po_line_locations_all pll,

264: SELECT pla.line_num,
265: pll.shipment_num
266: INTO x_po_line_num,
267: x_po_shipment_num
268: FROM po_line_locations_all pll,
269: po_lines_all pla
270: WHERE pla.po_line_id = pll.po_line_id
271: AND pll.line_location_id = x_po_line_location_id;
272:

Line 449: x_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

445:
446: x_info_slin_falg VARCHAR2(1):='N';
447:
448: x_group_line_id PO_REQUISITION_LINES_ALL.group_line_id%TYPE;
449: x_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
450: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
451: x_req_operating_unit_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
452:
453:

Line 513: FROM po_line_locations_all pll,

509:
510:
511: SELECT pha.po_header_id
512: INTO x_po_header_id
513: FROM po_line_locations_all pll,
514: po_headers_all pha
515: WHERE pha.po_header_id = pll.po_header_id
516: AND pll.line_location_id = x_po_line_location_id;
517: