APPS.FND_OAM_DSCRAM_UTILS_PKG dependencies on FND_OAM_DSCRAM_DMLS

Line 635: DELETE FROM fnd_oam_dscram_dmls

631: p_dml_id);
632:
633: --delete the actual entity
634: fnd_oam_debug.log(1, l_ctxt, 'Deleting entity...');
635: DELETE FROM fnd_oam_dscram_dmls
636: WHERE dml_id = p_dml_id;
637:
638: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
639: RETURN TRUE;

Line 693: FROM fnd_oam_dscram_dmls

689:
690: --now grab the list of dmls
691: SELECT dml_id
692: BULK COLLECT INTO l_ids
693: FROM fnd_oam_dscram_dmls
694: WHERE unit_id = p_unit_id;
695:
696: --nuke the dmls
697: k := l_ids.FIRST;

Line 1244: FROM fnd_oam_dscram_dmls

1240: IF p_recurse_parents IS NOT NULL AND p_recurse_parents = FND_API.G_TRUE THEN
1241: FOR k in p_dml_ids.FIRST..p_dml_ids.LAST LOOP
1242: SELECT unit_id
1243: INTO l_parent_id
1244: FROM fnd_oam_dscram_dmls
1245: WHERE dml_id = p_dml_ids(k);
1246:
1247: --add it to the parents_map if not present
1248: IF NOT l_parents_map.EXISTS(l_parent_id) THEN

Line 1267: UPDATE fnd_oam_dscram_dmls

1263:
1264: --and finally update the local entities
1265: fnd_oam_debug.log(1, l_ctxt, 'Processing '||p_dml_ids.COUNT||' dmls...');
1266: FORALL k in p_dml_ids.FIRST..p_dml_ids.LAST
1267: UPDATE fnd_oam_dscram_dmls
1268: SET finished_ret_sts = NULL
1269: WHERE dml_id = p_dml_ids(k)
1270: AND finished_ret_sts <> FND_API.G_RET_STS_SUCCESS;
1271: fnd_oam_debug.log(1, l_ctxt, 'Done.');

Line 1325: FROM fnd_oam_dscram_dmls

1321: --get the dmls for the k'th unit
1322: l_ids.DELETE;
1323: SELECT dml_id
1324: BULK COLLECT INTO l_ids
1325: FROM fnd_oam_dscram_dmls
1326: WHERE unit_id = p_unit_ids(k)
1327: AND finished_ret_sts <> FND_API.G_RET_STS_SUCCESS;
1328:
1329: --delegate the list to the child prepare_for_retry procedure