APPS.FND_OAM_DSCRAM_UTILS_PKG dependencies on FND_OAM_DSCRAM_BUNDLES

Line 291: l_id := FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID;

287: ELSE
288: fnd_oam_debug.log(1, l_ctxt, 'Skipping stopping task due to current status: '||l_current_status);
289: END IF;
290: ELSIF p_fatality_level = G_TYPE_BUNDLE THEN
291: l_id := FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID;
292: fnd_oam_debug.log(1, l_ctxt, 'Attempting to stop Bundle ID: '||l_id);
293: SELECT bundle_status
294: INTO l_current_status
295: FROM fnd_oam_dscram_bundles

Line 295: FROM fnd_oam_dscram_bundles

291: l_id := FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID;
292: fnd_oam_debug.log(1, l_ctxt, 'Attempting to stop Bundle ID: '||l_id);
293: SELECT bundle_status
294: INTO l_current_status
295: FROM fnd_oam_dscram_bundles
296: WHERE bundle_id = l_id
297: FOR UPDATE;
298:
299: IF STATUS_IS_PROCESSING(l_current_status) THEN

Line 300: UPDATE fnd_oam_dscram_bundles

296: WHERE bundle_id = l_id
297: FOR UPDATE;
298:
299: IF STATUS_IS_PROCESSING(l_current_status) THEN
300: UPDATE fnd_oam_dscram_bundles
301: SET bundle_status = G_STATUS_STOPPING,
302: last_updated_by = fnd_global.user_id,
303: last_update_login = fnd_global.user_id,
304: last_update_date = SYSDATE

Line 837: DELETE FROM fnd_oam_dscram_bundles

833: p_bundle_id);
834:
835: --delete the actual entity
836: fnd_oam_debug.log(1, l_ctxt, 'Deleting entity...');
837: DELETE FROM fnd_oam_dscram_bundles
838: WHERE bundle_id = p_bundle_id;
839:
840: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
841: RETURN TRUE;

Line 876: FROM fnd_oam_dscram_bundles

872:
873: --grab the list of bundles
874: SELECT bundle_id
875: BULK COLLECT INTO l_ids
876: FROM fnd_oam_dscram_bundles
877: WHERE RUN_ID = p_run_id;
878:
879: --delete the child bundles
880: l_retbool := TRUE;

Line 1528: FROM fnd_oam_dscram_bundles

1524: IF p_recurse_parents IS NOT NULL AND p_recurse_parents = FND_API.G_TRUE THEN
1525: FOR k in p_bundle_ids.FIRST..p_bundle_ids.LAST LOOP
1526: SELECT run_id
1527: INTO l_parent_id
1528: FROM fnd_oam_dscram_bundles
1529: WHERE bundle_id = p_bundle_ids(k);
1530:
1531: --add it to the parents_map if not present
1532: IF NOT l_parents_map.EXISTS(l_parent_id) THEN

Line 1550: UPDATE fnd_oam_dscram_bundles

1546:
1547: --and finally update the local entities
1548: fnd_oam_debug.log(1, l_ctxt, 'Processing '||p_bundle_ids.COUNT||' bundles...');
1549: FORALL k in p_bundle_ids.FIRST..p_bundle_ids.LAST
1550: UPDATE fnd_oam_dscram_bundles
1551: SET bundle_status = G_STATUS_RESTARTABLE,
1552: workers_assigned = 0
1553: WHERE bundle_id = p_bundle_ids(k)
1554: AND bundle_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);

Line 1591: FROM fnd_oam_dscram_bundles

1587: FOR k in p_run_ids.FIRST..p_run_ids.LAST LOOP
1588: --get the bundles for the k'th task
1589: SELECT bundle_id
1590: BULK COLLECT INTO l_ids
1591: FROM fnd_oam_dscram_bundles
1592: WHERE run_id = p_run_ids(k)
1593: AND bundle_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);
1594:
1595: --delegate the list to the child prepare_for_retry procedure

Line 1655: FROM fnd_oam_dscram_bundles

1651: IF p_recurse_children IS NOT NULL AND p_recurse_children = FND_API.G_TRUE THEN
1652: --grab the list of bundles
1653: SELECT bundle_id
1654: BULK COLLECT INTO l_ids
1655: FROM fnd_oam_dscram_bundles
1656: WHERE RUN_ID = p_run_id;
1657:
1658: --delegate to the bundles_retry
1659: PREPARE_BUNDLES_FOR_RETRY(l_ids,