APPS.PO_DOCUMENT_ACTIONS_SV dependencies on PO_DRAFTS

Line 149: UPDATE po_drafts

145: x_req_header_id_succ_tbl := PO_TBL_NUMBER();
146:
147: --<>
148: --Update the header status to returned for PAR document,if no par line exists on any mod.
149: UPDATE po_drafts
150: SET status = 'RETURNED'
151: WHERE draft_id IN (SELECT par_draft_id
152: FROM po_requisition_headers_all
153: -- Bug 16778189- Use column_value instaed of requisition_header_id

Line 163: PO_LOG.stmt(l_api_name, 10, 'No of records updated in po_drafts ', SQL%ROWCOUNT);

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);
164: END IF;
165:
166:
167: --Update the line status to returned for PAR document,if the par line doesnt exists on any mod.