APPS.PO_RELGEN_PKG dependencies on PO_REQUISITION_HEADERS

Line 169: from po_requisition_headers

165:
166: x_no_convert_flag := 'N';
167:
168: select segment1 into x_req_num
169: from po_requisition_headers
170: where requisition_header_id = po_req_lines.requisition_header_id;
171:
172: select line_num into x_req_line_num
173: from po_requisition_lines

Line 317: from po_requisition_headers

313: -- Bug 2701147 START
314: -- Retrieve the req number and req line number for the
315: -- previous release created.
316: select segment1 into x_req_num
317: from po_requisition_headers
318: where requisition_header_id = old_po_req_line.requisition_header_id;
319:
320:
321: select line_num into x_req_line_num

Line 578: from po_requisition_headers

574:
575: l_progress := '230';
576: -- Bug 2701147 START
577: select segment1 into x_req_num
578: from po_requisition_headers
579: where requisition_header_id = old_po_req_line.requisition_header_id;
580:
581:
582: select line_num into x_req_line_num

Line 2412: PO_REQUISITION_HEADERS.segment1%TYPE,

2408: * used to create the given release distribution.
2409: **/
2410: PROCEDURE get_req_info_from_po_dist (p_po_distribution_id IN NUMBER,
2411: x_req_num OUT NOCOPY
2412: PO_REQUISITION_HEADERS.segment1%TYPE,
2413: x_req_line_num OUT NOCOPY NUMBER)
2414: IS
2415: BEGIN
2416: SELECT prh.segment1, prl.line_num

Line 2421: po_requisition_headers prh

2417: INTO x_req_num, x_req_line_num
2418: FROM po_distributions pod,
2419: po_req_distributions prd,
2420: po_requisition_lines prl,
2421: po_requisition_headers prh
2422: WHERE pod.po_distribution_id = p_po_distribution_id
2423: AND pod.req_distribution_id = prd.distribution_id
2424: AND prl.requisition_line_id = prd.requisition_line_id
2425: AND prh.requisition_header_id = prl.requisition_header_id;

Line 2441: PO_REQUISITION_HEADERS.segment1%TYPE,

2437: * Note that Create Releases only creates one distribution per shipment.
2438: **/
2439: PROCEDURE get_req_info_from_po_shipment (p_line_location_id IN NUMBER,
2440: x_req_num OUT NOCOPY
2441: PO_REQUISITION_HEADERS.segment1%TYPE,
2442: x_req_line_num OUT NOCOPY NUMBER)
2443: IS
2444: l_po_distribution_id NUMBER;
2445: BEGIN

Line 2502: l_req_num PO_REQUISITION_HEADERS.segment1%TYPE;

2498: l_ship_price_ext_precn NUMBER;
2499: l_shipment_to_req_rate NUMBER := 0;
2500: l_price_tolerance_allowed NUMBER := 0;
2501:
2502: l_req_num PO_REQUISITION_HEADERS.segment1%TYPE;
2503: L_req_line_num NUMBER;
2504:
2505: /*
2506: ** Setup the Release select cursor

Line 2881: l_req_num PO_REQUISITION_HEADERS.segment1%TYPE;

2877: TYPE NumTab is TABLE of NUMBER INDEX by BINARY_INTEGER;
2878: l_line_location_id NumTab;
2879: l_dist_id NumTab;
2880:
2881: l_req_num PO_REQUISITION_HEADERS.segment1%TYPE;
2882: L_req_line_num NUMBER;
2883:
2884: l_check_status VARCHAR2(1);
2885: l_progress VARCHAR2(3) := '001';