APPS.FND_OAM_DSCRAM_TASKS_PKG dependencies on FND_OAM_DSCRAM_TASKS

Line 1: PACKAGE BODY FND_OAM_DSCRAM_TASKS_PKG as

1: PACKAGE BODY FND_OAM_DSCRAM_TASKS_PKG as
2: /* $Header: AFOAMDSTASKB.pls 120.4 2006/05/04 15:16 ilawler noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants

Line 20: FROM fnd_oam_dscram_tasks T

16: -- no workers are assigned.
17: CURSOR B_TASKS
18: IS
19: SELECT /*+ FIRST_ROWS(1) */ T.task_id, T.task_status
20: FROM fnd_oam_dscram_tasks T
21: WHERE T.bundle_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID
22: AND T.task_status in (FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
23: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
24: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_RESTARTABLE)

Line 147: FROM fnd_oam_dscram_tasks

143:
144: CURSOR C1
145: IS
146: SELECT task_status
147: FROM fnd_oam_dscram_tasks
148: WHERE task_id = p_task_id;
149: BEGIN
150: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
151: x_return_status := FND_API.G_RET_STS_ERROR;

Line 217: FROM fnd_oam_dscram_tasks

213:
214: CURSOR C1
215: IS
216: SELECT task_status
217: FROM fnd_oam_dscram_tasks
218: WHERE task_id = b_task_info.task_id;
219: BEGIN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: x_return_msg := '';

Line 323: FROM fnd_oam_dscram_tasks

319: -- row to add to the # of workers assigned. Also updates the status to started if it
320: -- hasn't been set yet.
321: SELECT task_status, workers_assigned
322: INTO l_status, l_workers_assigned
323: FROM fnd_oam_dscram_tasks
324: WHERE task_id = p_task_id
325: FOR UPDATE;
326:
327: fnd_oam_debug.log(1, l_ctxt, 'Task Status(Workers): '||l_status||'('||l_workers_assigned||')');

Line 350: UPDATE fnd_oam_dscram_tasks

346: p_source_object_id => p_task_id,
347: p_start_time => SYSDATE,
348: p_prestart_status => l_status,
349: x_stat_id => l_stat_id);
350: UPDATE fnd_oam_dscram_tasks
351: SET task_status = FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
352: STATS_FINISHED = FND_API.G_FALSE
353: WHERE task_id = p_task_id;
354: ELSE

Line 365: UPDATE fnd_oam_dscram_tasks

361: END IF;
362: END IF;
363:
364: --update the task's # of workers assigned
365: UPDATE fnd_oam_dscram_tasks
366: SET workers_assigned = workers_assigned + 1,
367: last_updated_by = fnd_global.user_id,
368: last_update_login = fnd_global.user_id,
369: last_update_date = SYSDATE

Line 418: FROM fnd_oam_dscram_tasks

414:
415: -- always lock the task since we have to decrement the worker count
416: SELECT task_status, workers_assigned
417: INTO l_status, l_workers_assigned
418: FROM fnd_oam_dscram_tasks
419: WHERE task_id = b_task_info.task_id
420: FOR UPDATE;
421:
422: -- translate the new_status into a valid final status

Line 434: UPDATE fnd_oam_dscram_tasks

430: fnd_oam_debug.log(1, l_ctxt, 'Translated Execute Ret Sts "'||p_proposed_ret_sts||'" into "'||l_final_ret_sts||'"');
431:
432: --if we discovered that we're full, possibly temporarily, just decrement the worker count and leave as long as we're not the last worker
433: IF l_final_ret_sts = FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_FULL AND l_workers_assigned > 1 THEN
434: UPDATE fnd_oam_dscram_tasks
435: SET workers_assigned = workers_assigned - 1,
436: last_updated_by = fnd_global.user_id,
437: last_update_login = fnd_global.user_id,
438: last_update_date = SYSDATE

Line 442: UPDATE fnd_oam_dscram_tasks

438: last_update_date = SYSDATE
439: WHERE task_id = b_task_info.task_id;
440: ELSE
441: -- otherwise, update the status and workers_assigned
442: UPDATE fnd_oam_dscram_tasks
443: SET task_status = l_final_status,
444: workers_assigned = workers_assigned - 1,
445: last_updated_by = fnd_global.user_id,
446: last_update_login = fnd_global.user_id,

Line 662: END FND_OAM_DSCRAM_TASKS_PKG;

658: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
659: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
660: END;
661:
662: END FND_OAM_DSCRAM_TASKS_PKG;