APPS.PO_DOCUMENT_ACTIONS_SV dependencies on PO_LINES_DRAFT_ALL

Line 159: AND EXISTS (SELECT po_line_id FROM po_lines_draft_all plda WHERE prl.par_line_id = plda.po_line_id

155: AND NOT EXISTS (SELECT par_line_id
156: FROM po_requisition_lines_all prl
157: WHERE requisition_header_id IN (SELECT column_value FROM TABLE(p_req_header_id_tbl))
158: -- Use Exists clause instead of Not in
159: AND EXISTS (SELECT po_line_id FROM po_lines_draft_all plda WHERE prl.par_line_id = plda.po_line_id
160: AND mod_draft_id IS NOT NULL)) ;
161:
162: IF (SQL%ROWCOUNT > 0) THEN
163: PO_LOG.stmt(l_api_name, 10, 'No of records updated in po_drafts ', SQL%ROWCOUNT);

Line 168: UPDATE po_lines_draft_all

164: END IF;
165:
166:
167: --Update the line status to returned for PAR document,if the par line doesnt exists on any mod.
168: UPDATE po_lines_draft_all
169: SET DRAFT_LINE_STATUS ='RETURNED'
170: WHERE po_line_id IN (SELECT par_line_id
171: FROM po_requisition_lines_all
172: WHERE requisition_header_id IN (SELECT column_value FROM TABLE(p_req_header_id_tbl)))

Line 180: PO_LOG.stmt(l_api_name, 20, 'No of records updated in po_lines_draft_all ', SQL%ROWCOUNT);

176: WHERE requisition_header_id IN (SELECT column_value FROM TABLE(p_req_header_id_tbl)))
177: AND mod_draft_id IS NULL;
178:
179: IF (SQL%ROWCOUNT > 0) THEN
180: PO_LOG.stmt(l_api_name, 20, 'No of records updated in po_lines_draft_all ', SQL%ROWCOUNT);
181: END IF;
182:
183: --In case of error, the txn will be rolled back.
184: --<>