APPS.FND_OAM_DSCRAM_UTILS_PKG dependencies on FND_OAM_DSCRAM_PLSQLS

Line 601: DELETE FROM fnd_oam_dscram_plsqls

597: p_plsql_id);
598:
599: --delete the actual entity
600: fnd_oam_debug.log(1, l_ctxt, 'Deleting entity...');
601: DELETE FROM fnd_oam_dscram_plsqls
602: WHERE plsql_id = p_plsql_id;
603:
604: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
605: RETURN TRUE;

Line 710: FROM fnd_oam_dscram_plsqls

706:
707: --grab the list of plsqls
708: SELECT plsql_id
709: BULK COLLECT INTO l_ids
710: FROM fnd_oam_dscram_plsqls
711: WHERE unit_id = p_unit_id;
712:
713: --nuke them
714: k := l_ids.FIRST;

Line 1180: FROM fnd_oam_dscram_plsqls

1176: IF p_recurse_parents IS NOT NULL AND p_recurse_parents = FND_API.G_TRUE THEN
1177: FOR k in p_plsql_ids.FIRST..p_plsql_ids.LAST LOOP
1178: SELECT unit_id
1179: INTO l_parent_id
1180: FROM fnd_oam_dscram_plsqls
1181: WHERE plsql_id = p_plsql_ids(k);
1182:
1183: --add it to the parents_map if not present
1184: IF NOT l_parents_map.EXISTS(l_parent_id) THEN

Line 1203: UPDATE fnd_oam_dscram_plsqls

1199:
1200: --and finally update the local entities
1201: fnd_oam_debug.log(1, l_ctxt, 'Processing '||p_plsql_ids.COUNT||' plsqls...');
1202: FORALL k in p_plsql_ids.FIRST..p_plsql_ids.LAST
1203: UPDATE fnd_oam_dscram_plsqls
1204: SET finished_ret_sts = NULL
1205: WHERE plsql_id = p_plsql_ids(k)
1206: AND finished_ret_sts <> FND_API.G_RET_STS_SUCCESS;
1207: fnd_oam_debug.log(1, l_ctxt, 'Done.');

Line 1339: FROM fnd_oam_dscram_plsqls

1335: --get the dmls for the k'th unit
1336: l_ids.DELETE;
1337: SELECT plsql_id
1338: BULK COLLECT INTO l_ids
1339: FROM fnd_oam_dscram_plsqls
1340: WHERE unit_id = p_unit_ids(k)
1341: AND finished_ret_sts <> FND_API.G_RET_STS_SUCCESS;
1342:
1343: --delegate the list to the child prepare_for_retry procedure