APPS.FND_OAM_DSCRAM_UTILS_PKG dependencies on FND_OAM_DSCRAM_UNITS

Line 669: FROM fnd_oam_dscram_units

665:
666: --get the unit type
667: SELECT unit_type, unit_object_owner, unit_object_name
668: INTO l_unit_type, l_object_owner, l_object_name
669: FROM fnd_oam_dscram_units
670: WHERE unit_id = p_unit_id;
671:
672: --first get the list of child units
673: SELECT unit_id

Line 675: FROM fnd_oam_dscram_units

671:
672: --first get the list of child units
673: SELECT unit_id
674: BULK COLLECT INTO l_ids
675: FROM fnd_oam_dscram_units
676: WHERE concurrent_group_unit_id = p_unit_id;
677:
678: --nuke the children
679: k := l_ids.FIRST;

Line 738: DELETE FROM fnd_oam_dscram_units

734: p_unit_id);
735:
736: --delete the actual entity
737: fnd_oam_debug.log(1, l_ctxt, 'Deleting entity...');
738: DELETE FROM fnd_oam_dscram_units
739: WHERE unit_id = p_unit_id;
740:
741: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
742: RETURN TRUE;

Line 768: FROM fnd_oam_dscram_units

764:
765: --grab the list of top-level units
766: SELECT unit_id
767: BULK COLLECT INTO l_ids
768: FROM fnd_oam_dscram_units
769: WHERE task_id = p_task_id
770: AND concurrent_group_unit_id IS NULL;
771:
772: k := l_ids.FIRST;

Line 1312: FROM fnd_oam_dscram_units

1308: --query out any child units
1309: fnd_oam_debug.log(1, l_ctxt, 'Processing child units of unit_id: '||p_unit_ids(k));
1310: SELECT unit_id
1311: BULK COLLECT INTO l_ids
1312: FROM fnd_oam_dscram_units
1313: WHERE concurrent_group_unit_id = p_unit_ids(k);
1314:
1315: PREPARE_UNITS_FOR_RETRY(l_ids,
1316: FND_API.G_FALSE,

Line 1355: FROM fnd_oam_dscram_units

1351: IF p_recurse_parents IS NOT NULL AND p_recurse_parents = FND_API.G_TRUE THEN
1352: FOR k in p_unit_ids.FIRST..p_unit_ids.LAST LOOP
1353: SELECT task_id
1354: INTO l_parent_id
1355: FROM fnd_oam_dscram_units
1356: WHERE unit_id = p_unit_ids(k);
1357:
1358: --add it to the parents_map if not present
1359: IF NOT l_parents_map.EXISTS(l_parent_id) THEN

Line 1379: UPDATE fnd_oam_dscram_units

1375:
1376: --and finally update the local entities
1377: fnd_oam_debug.log(1, l_ctxt, 'Processing '||p_unit_ids.COUNT||' units...');
1378: FORALL k in p_unit_ids.FIRST..p_unit_ids.LAST
1379: UPDATE fnd_oam_dscram_units
1380: SET unit_status = G_STATUS_RESTARTABLE,
1381: workers_assigned = 0
1382: WHERE unit_id = p_unit_ids(k)
1383: AND unit_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_NO_STATUS, G_STATUS_UNPROCESSED);

Line 1426: FROM fnd_oam_dscram_units

1422:
1423: --get the units for the k'th task
1424: SELECT unit_id
1425: BULK COLLECT INTO l_ids
1426: FROM fnd_oam_dscram_units
1427: WHERE task_id = p_task_ids(k)
1428: AND unit_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_NO_STATUS, G_STATUS_UNPROCESSED);
1429:
1430: --delegate the list to the child prepare_for_retry procedure