APPS.FND_OAM_DSCRAM_TASKS_PKG dependencies on FND_GLOBAL

Line 367: last_updated_by = fnd_global.user_id,

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
370: WHERE task_id = p_task_id;
371:

Line 368: last_update_login = fnd_global.user_id,

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
370: WHERE task_id = p_task_id;
371:
372: --commit the changes and release the lock

Line 436: last_updated_by = fnd_global.user_id,

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
439: WHERE task_id = b_task_info.task_id;
440: ELSE

Line 437: last_update_login = fnd_global.user_id,

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
439: WHERE task_id = b_task_info.task_id;
440: ELSE
441: -- otherwise, update the status and workers_assigned

Line 445: last_updated_by = fnd_global.user_id,

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,
447: last_update_date = SYSDATE
448: WHERE task_id = b_task_info.task_id;
449:

Line 446: last_update_login = fnd_global.user_id,

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,
447: last_update_date = SYSDATE
448: WHERE task_id = b_task_info.task_id;
449:
450: --only complete stats if we changed state