DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTIONS_SV dependencies on PO_LOG

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.

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: --<>