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 180: FROM po_requisition_lines

176: cursor c1 is SELECT 'Y'
177: FROM po_req_distributions
178: WHERE requisition_line_id
179: IN (SELECT requisition_line_id
180: FROM po_requisition_lines
181: WHERE requisition_header_id = X_req_hdr_id)
182: AND nvl(encumbered_flag,'N') <> 'N';
183:
184: Recinfo c1%rowtype;

Line 271: FROM po_requisition_lines

267:
268: x_progress VARCHAR2(3) := NULL;
269:
270: CURSOR S IS SELECT requisition_line_id
271: FROM po_requisition_lines
272: WHERE requisition_header_id = X_req_hdr_id;
273:
274: BEGIN
275:

Line 295: DELETE FROM po_requisition_lines

291: '',
292: 'Y');
293: x_progress := '030';
294:
295: DELETE FROM po_requisition_lines
296: WHERE requisition_line_id = Srec.requisition_line_id;
297:
298: END LOOP;
299: -- dbms_output.put_line('After delete of distributions and lines');