APPS.PO_REQ_LINES_SV dependencies on PO_REQ_DISTRIBUTIONS

Line 127: DELETE FROM po_req_distributions

123: -- dbms_output.put_line('After call to delete attachments');
124:
125: x_progress := '020';
126:
127: DELETE FROM po_req_distributions
128: WHERE requisition_line_id = X_line_id;
129:
130: -- dbms_output.put_line('After call to delete distributions');
131:

Line 585: UPDATE PO_REQ_DISTRIBUTIONS

581: AND nvl(closed_code, 'OPEN') <> 'FINALLY CLOSED';
582:
583: -- dbms_output.put_line('Exit update_reqs_lines_status');
584: /* Start Bug 4036549 - updating the req_line_quantity to 0 for 'Purchase Req'*/
585: UPDATE PO_REQ_DISTRIBUTIONS
586: SET req_line_quantity = 0
587: WHERE requisition_line_id IN
588: (SELECT requisition_line_id
589: FROM po_requisition_lines PORL