APPS.OKC_PO_MOD_PKG dependencies on PO_MULTI_MOD_CLAUSE_CHANGES

Line 193: FROM po_multi_mod_clause_changes

189:
190:
191: CURSOR c_get_clause_changes_csr IS
192: SELECT clause_action_code, old_article_version_id, new_article_version_id
193: FROM po_multi_mod_clause_changes
194: WHERE multi_mod_request_id = p_multi_mod_req_id;
195:
196: CURSOR c_get_section_id_csr(p_scn_code VARCHAR2) IS
197: SELECT scn_id

Line 282: /*For each PO in the Multi Mod Request Id, For each row in the po_multi_mod_clause_changes,

278: CLOSE l_tmpl_doc_exist_csr;
279:
280: l_mode := 'AMEND';
281:
282: /*For each PO in the Multi Mod Request Id, For each row in the po_multi_mod_clause_changes,
283: perform the action specified*/
284:
285: FOR c_get_clause_changes_csr_rec IN c_get_clause_changes_csr LOOP
286:

Line 533: DELETE FROM po_multi_mod_clause_changes

529:
530: -- Standard Start of API savepoint
531: SAVEPOINT g_del_clause_changes_GRP;
532:
533: DELETE FROM po_multi_mod_clause_changes
534: WHERE multi_mod_request_id = p_multi_mod_req_id;
535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:

Line 593: FROM po_multi_mod_clause_changes

589:
590: BEGIN
591:
592: SELECT Count(*) INTO l_count
593: FROM po_multi_mod_clause_changes
594: WHERE multi_mod_request_id = p_multi_mod_req_id;
595:
596: EXCEPTION
597: WHEN no_data_found THEN