DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on PO_MULTI_MOD_REQUESTS

Line 1250: UPDATE po_multi_mod_requests

1246:
1247: l_progress := 70;
1248: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_validation_status ' || l_validation_status);
1249:
1250: UPDATE po_multi_mod_requests
1251: SET VALIDATION_STATUS = l_validation_status
1252: WHERE MULTI_MOD_REQUEST_ID = p_req_id;
1253:
1254: l_progress := 100;

Line 1685: po_multi_mod_requests req

1681:
1682: SELECT listagg(DOCUMENT_ID,',') within GROUP (ORDER BY DOCUMENT_ID)
1683: INTO l_doc_ids
1684: FROM po_multi_mod_docs docs,
1685: po_multi_mod_requests req
1686: WHERE docs.MULTI_MOD_REQUEST_ID = req.MULTI_MOD_REQUEST_ID
1687: AND req.MULTI_MOD_REQUEST_TYPE = 'INITIATE_CLOSEOUT'
1688: AND docs.DOCUMENT_ID IN (SELECT *
1689: FROM TABLE (p_selected_docs));

Line 2134: UPDATE po_multi_mod_requests

2130: l_progress := 95;
2131: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_validation_status ' || l_validation_status);
2132: fnd_file.put_line(FND_FILE.LOG,'Validation Status : ' || l_validation_status);
2133:
2134: UPDATE po_multi_mod_requests
2135: SET VALIDATION_STATUS = l_validation_status
2136: WHERE MULTI_MOD_REQUEST_ID = p_req_id;
2137:
2138: l_progress := 100;