APPS.FND_OAM_DSCRAM_UNITS_PKG dependencies on FND_GLOBAL

Line 523: last_updated_by = fnd_global.user_id,

519:
520: -- finally, always update the last updated fields and the # of workers assigned.
521: UPDATE fnd_oam_dscram_units
522: SET workers_assigned = workers_assigned + 1,
523: last_updated_by = fnd_global.user_id,
524: last_update_login = fnd_global.user_id,
525: last_update_date = SYSDATE
526: WHERE unit_id = p_unit_id;
527:

Line 524: last_update_login = fnd_global.user_id,

520: -- finally, always update the last updated fields and the # of workers assigned.
521: UPDATE fnd_oam_dscram_units
522: SET workers_assigned = workers_assigned + 1,
523: last_updated_by = fnd_global.user_id,
524: last_update_login = fnd_global.user_id,
525: last_update_date = SYSDATE
526: WHERE unit_id = p_unit_id;
527:
528: -- push changes and release lock

Line 784: last_updated_by = fnd_global.user_id,

780: --if we discovered that we're full, possibly temporarily, just decrement the worker count and leave if we're not the last worker
781: IF l_final_ret_sts = FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_FULL AND l_workers_assigned > 1 THEN
782: UPDATE fnd_oam_dscram_units
783: SET workers_assigned = workers_assigned - 1,
784: last_updated_by = fnd_global.user_id,
785: last_update_login = fnd_global.user_id,
786: last_update_date = SYSDATE
787: WHERE unit_id = p_unit_id;
788: ELSE

Line 785: last_update_login = fnd_global.user_id,

781: IF l_final_ret_sts = FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_FULL AND l_workers_assigned > 1 THEN
782: UPDATE fnd_oam_dscram_units
783: SET workers_assigned = workers_assigned - 1,
784: last_updated_by = fnd_global.user_id,
785: last_update_login = fnd_global.user_id,
786: last_update_date = SYSDATE
787: WHERE unit_id = p_unit_id;
788: ELSE
789: -- otherwise, update the status and workers_assigned

Line 793: last_updated_by = fnd_global.user_id,

789: -- otherwise, update the status and workers_assigned
790: UPDATE fnd_oam_dscram_units
791: SET unit_status = l_final_status,
792: workers_assigned = workers_assigned - 1,
793: last_updated_by = fnd_global.user_id,
794: last_update_login = fnd_global.user_id,
795: last_update_date = SYSDATE
796: WHERE unit_id = p_unit_id;
797:

Line 794: last_update_login = fnd_global.user_id,

790: UPDATE fnd_oam_dscram_units
791: SET unit_status = l_final_status,
792: workers_assigned = workers_assigned - 1,
793: last_updated_by = fnd_global.user_id,
794: last_update_login = fnd_global.user_id,
795: last_update_date = SYSDATE
796: WHERE unit_id = p_unit_id;
797:
798: --only complete stats if we changed state