APPS.PO_REQS_SV dependencies on PO_REQUISITION_LINES

Line 105: FROM PO_REQUISITION_LINES PORL

101: X_progress := '010';
102: SELECT COUNT(1),
103: nvl(sum(decode(PORL.line_location_id,NULL,0,1)),0)
104: INTO X_req_has_open_line, X_req_has_open_shipment
105: FROM PO_REQUISITION_LINES PORL
106: WHERE PORL.requisition_header_id = X_req_header_id
107: AND nvl(PORL.cancel_flag, 'N') IN ('N', 'I')
108: AND nvl(PORL.closed_code, 'OPEN') <> 'FINALLY CLOSED';
109:

Line 174: FROM po_requisition_lines

170: cursor c1 is SELECT 'Y'
171: FROM po_req_distributions
172: WHERE requisition_line_id
173: IN (SELECT requisition_line_id
174: FROM po_requisition_lines
175: WHERE requisition_header_id = X_req_hdr_id)
176: AND nvl(encumbered_flag,'N') <> 'N';
177:
178: Recinfo c1%rowtype;

Line 265: FROM po_requisition_lines

261:
262: x_progress VARCHAR2(3) := NULL;
263:
264: CURSOR S IS SELECT requisition_line_id
265: FROM po_requisition_lines
266: WHERE requisition_header_id = X_req_hdr_id;
267:
268: BEGIN
269:

Line 289: DELETE FROM po_requisition_lines

285: '',
286: 'Y');
287: x_progress := '030';
288:
289: DELETE FROM po_requisition_lines
290: WHERE requisition_line_id = Srec.requisition_line_id;
291:
292: END LOOP;
293: -- dbms_output.put_line('After delete of distributions and lines');