APPS.PO_AUTO_IMPLEMENT_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 36: x_group_line_id PO_REQUISITION_LINES_ALL.group_line_id%TYPE;

32: l_progress VARCHAR2(3) := '000';
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:

Line 58: x_clm_option_exercised PO_REQUISITION_LINES_ALL.clm_option_exercised%TYPE; -- Bug 9838483

54: x_pcard_id PO_HEADERS_INTERFACE.pcard_id%TYPE := null;
55:
56: -- Lines Interface
57: x_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
58: x_clm_option_exercised PO_REQUISITION_LINES_ALL.clm_option_exercised%TYPE; -- Bug 9838483
59:
60: BEGIN
61:
62: IF g_debug_stmt THEN

Line 210: FROM po_requisition_lines_all prl

206: SELECT group_line_id,
207: clm_info_flag
208: INTO x_group_line_id,
209: x_info_slin_falg
210: FROM po_requisition_lines_all prl
211: WHERE prl.requisition_line_id=x_req_line_id
212: AND prl.group_line_id IS NOT NULL;
213:
214:

Line 225: FROM po_requisition_lines_all prl

221:
222: -- Bug 9838483: Retrieve clm_option_exercised from requisition lines
223: SELECT clm_option_exercised
224: INTO x_clm_option_exercised
225: FROM po_requisition_lines_all prl
226: WHERE prl.requisition_line_id=x_req_line_id;
227:
228:
229: EXCEPTION

Line 241: FROM po_requisition_lines_all prl

237: IF x_info_slin_falg = 'N' THEN
238:
239: SELECT line_location_id
240: INTO x_po_line_location_id
241: FROM po_requisition_lines_all prl
242: WHERE prl.requisition_line_id = x_req_line_id;
243:
244: ELSE
245: SELECT line_location_id

Line 247: FROM po_requisition_lines_all prl

243:
244: ELSE
245: SELECT line_location_id
246: INTO x_po_line_location_id
247: FROM po_requisition_lines_all prl
248: WHERE prl.requisition_line_id = x_group_line_id;
249: END IF;
250:
251: EXCEPTION

Line 448: x_group_line_id PO_REQUISITION_LINES_ALL.group_line_id%TYPE;

444: l_progress VARCHAR2(3) := '000';
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:

Line 451: x_req_operating_unit_id PO_REQUISITION_LINES_ALL.org_id%TYPE;

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:
454: BEGIN
455:

Line 470: FROM po_requisition_lines_all prl

466: org_id
467: INTO x_group_line_id,
468: x_info_slin_falg,
469: x_req_operating_unit_id
470: FROM po_requisition_lines_all prl
471: WHERE prl.requisition_line_id=x_req_line_id
472: AND prl.group_line_id IS NOT NULL;
473:
474:

Line 487: FROM po_requisition_lines_all prl

483: IF x_info_slin_falg = 'N' THEN
484:
485: SELECT line_location_id
486: INTO x_po_line_location_id
487: FROM po_requisition_lines_all prl
488: WHERE prl.requisition_line_id = x_req_line_id;
489:
490: ELSE
491: SELECT line_location_id

Line 493: FROM po_requisition_lines_all prl

489:
490: ELSE
491: SELECT line_location_id
492: INTO x_po_line_location_id
493: FROM po_requisition_lines_all prl
494: WHERE prl.requisition_line_id = x_group_line_id;
495: END IF;
496:
497: EXCEPTION