APPS.FND_OAM_DSCRAM_UTILS_PKG dependencies on FND_OAM_DSCRAM_TASKS

Line 271: l_id := FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID;

267: l_id NUMBER;
268: l_current_status VARCHAR2(30);
269: BEGIN
270: IF p_fatality_level = G_TYPE_TASK THEN
271: l_id := FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID;
272: fnd_oam_debug.log(1, l_ctxt, 'Attempting to stop Task ID: '||l_id);
273: SELECT task_status
274: INTO l_current_status
275: FROM fnd_oam_dscram_tasks

Line 275: FROM fnd_oam_dscram_tasks

271: l_id := FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID;
272: fnd_oam_debug.log(1, l_ctxt, 'Attempting to stop Task ID: '||l_id);
273: SELECT task_status
274: INTO l_current_status
275: FROM fnd_oam_dscram_tasks
276: WHERE task_id = l_id
277: FOR UPDATE;
278:
279: IF STATUS_IS_PROCESSING(l_current_status) THEN

Line 280: UPDATE fnd_oam_dscram_tasks

276: WHERE task_id = l_id
277: FOR UPDATE;
278:
279: IF STATUS_IS_PROCESSING(l_current_status) THEN
280: UPDATE fnd_oam_dscram_tasks
281: SET task_status = G_STATUS_STOPPING,
282: last_updated_by = fnd_global.user_id,
283: last_update_login = fnd_global.user_id,
284: last_update_date = SYSDATE

Line 788: DELETE FROM fnd_oam_dscram_tasks

784: p_task_id);
785:
786: --delete the actual entity
787: fnd_oam_debug.log(1, l_ctxt, 'Deleting entity...');
788: DELETE FROM fnd_oam_dscram_tasks
789: WHERE task_id = p_task_id;
790:
791: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
792: RETURN TRUE;

Line 818: FROM fnd_oam_dscram_tasks

814:
815: --grab the list of tasks
816: SELECT task_id
817: BULK COLLECT INTO l_ids
818: FROM fnd_oam_dscram_tasks
819: WHERE bundle_id = p_bundle_id;
820:
821: k := l_ids.FIRST;
822: WHILE k IS NOT NULL LOOP

Line 1442: FROM fnd_oam_dscram_tasks

1438: IF p_recurse_parents IS NOT NULL AND p_recurse_parents = FND_API.G_TRUE THEN
1439: FOR k in p_task_ids.FIRST..p_task_ids.LAST LOOP
1440: SELECT bundle_id
1441: INTO l_parent_id
1442: FROM fnd_oam_dscram_tasks
1443: WHERE task_id = p_task_ids(k);
1444:
1445: --add it to the parents_map if not present
1446: IF NOT l_parents_map.EXISTS(l_parent_id) THEN

Line 1465: UPDATE fnd_oam_dscram_tasks

1461:
1462: --and finally update the local entities
1463: fnd_oam_debug.log(1, l_ctxt, 'Processing '||p_task_ids.COUNT||' tasks...');
1464: FORALL k in p_task_ids.FIRST..p_task_ids.LAST
1465: UPDATE fnd_oam_dscram_tasks
1466: SET task_status = G_STATUS_RESTARTABLE,
1467: workers_assigned = 0
1468: WHERE task_id = p_task_ids(k)
1469: AND task_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);

Line 1512: FROM fnd_oam_dscram_tasks

1508:
1509: --get the tasks for the k'th bundle
1510: SELECT task_id
1511: BULK COLLECT INTO l_ids
1512: FROM fnd_oam_dscram_tasks
1513: WHERE bundle_id = p_bundle_ids(k)
1514: AND task_status NOT IN (G_STATUS_PROCESSED, G_STATUS_SKIPPED, G_STATUS_UNPROCESSED);
1515:
1516: --delegate the list to the child prepare_for_retry procedure