APPS.PO_RELGEN_PKG dependencies on PO_REQUISITION_HEADERS

Line 168: from po_requisition_headers

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

Line 316: from po_requisition_headers

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

Line 577: from po_requisition_headers

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

Line 2387: PO_REQUISITION_HEADERS.segment1%TYPE,

2383: * used to create the given release distribution.
2384: **/
2385: PROCEDURE get_req_info_from_po_dist (p_po_distribution_id IN NUMBER,
2386: x_req_num OUT NOCOPY
2387: PO_REQUISITION_HEADERS.segment1%TYPE,
2388: x_req_line_num OUT NOCOPY NUMBER)
2389: IS
2390: BEGIN
2391: SELECT prh.segment1, prl.line_num

Line 2396: po_requisition_headers prh

2392: INTO x_req_num, x_req_line_num
2393: FROM po_distributions pod,
2394: po_req_distributions prd,
2395: po_requisition_lines prl,
2396: po_requisition_headers prh
2397: WHERE pod.po_distribution_id = p_po_distribution_id
2398: AND pod.req_distribution_id = prd.distribution_id
2399: AND prl.requisition_line_id = prd.requisition_line_id
2400: AND prh.requisition_header_id = prl.requisition_header_id;

Line 2416: PO_REQUISITION_HEADERS.segment1%TYPE,

2412: * Note that Create Releases only creates one distribution per shipment.
2413: **/
2414: PROCEDURE get_req_info_from_po_shipment (p_line_location_id IN NUMBER,
2415: x_req_num OUT NOCOPY
2416: PO_REQUISITION_HEADERS.segment1%TYPE,
2417: x_req_line_num OUT NOCOPY NUMBER)
2418: IS
2419: l_po_distribution_id NUMBER;
2420: BEGIN

Line 2477: l_req_num PO_REQUISITION_HEADERS.segment1%TYPE;

2473: l_ship_price_ext_precn NUMBER;
2474: l_shipment_to_req_rate NUMBER := 0;
2475: l_price_tolerance_allowed NUMBER := 0;
2476:
2477: l_req_num PO_REQUISITION_HEADERS.segment1%TYPE;
2478: L_req_line_num NUMBER;
2479:
2480: /*
2481: ** Setup the Release select cursor

Line 2856: l_req_num PO_REQUISITION_HEADERS.segment1%TYPE;

2852: TYPE NumTab is TABLE of NUMBER INDEX by BINARY_INTEGER;
2853: l_line_location_id NumTab;
2854: l_dist_id NumTab;
2855:
2856: l_req_num PO_REQUISITION_HEADERS.segment1%TYPE;
2857: L_req_line_num NUMBER;
2858:
2859: l_check_status VARCHAR2(1);
2860: l_progress VARCHAR2(3) := '001';