DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on FND_GLOBAL

Line 119: last_updated_by = Fnd_Global.user_id,

115: SET requested_quantity = 0,
116: status = 'DELETED',
117: object_version_number = l_object_version_number + 1,
118: last_update_date = SYSDATE,
119: last_updated_by = Fnd_Global.user_id,
120: last_update_login = Fnd_Global.login_id
121: WHERE scheduled_material_id = l_schedule_material_id;
122: --
123: END IF; --Scheduled date

Line 120: last_update_login = Fnd_Global.login_id

116: status = 'DELETED',
117: object_version_number = l_object_version_number + 1,
118: last_update_date = SYSDATE,
119: last_updated_by = Fnd_Global.user_id,
120: last_update_login = Fnd_Global.login_id
121: WHERE scheduled_material_id = l_schedule_material_id;
122: --
123: END IF; --Scheduled date
124: CLOSE c_visit_task_matrl_cur;

Line 624: fnd_global.user_id,

620: VALUES
621: (l_schedule_material_id,
622: 1,
623: SYSDATE,
624: fnd_global.user_id,
625: SYSDATE,
626: fnd_global.user_id,
627: fnd_global.login_id,
628: l_inventory_item_id,

Line 626: fnd_global.user_id,

622: 1,
623: SYSDATE,
624: fnd_global.user_id,
625: SYSDATE,
626: fnd_global.user_id,
627: fnd_global.login_id,
628: l_inventory_item_id,
629: NULL,
630: p_visit_id,

Line 627: fnd_global.login_id,

623: SYSDATE,
624: fnd_global.user_id,
625: SYSDATE,
626: fnd_global.user_id,
627: fnd_global.login_id,
628: l_inventory_item_id,
629: NULL,
630: p_visit_id,
631: NULL,

Line 3272: LAST_UPDATED_BY = Fnd_Global.USER_ID,

3268: UPDATE ahl_Schedule_materials
3269: SET STATUS = 'HISTORY',
3270: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3271: LAST_UPDATE_DATE = sysdate,
3272: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3273: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3274: WHERE visit_task_id = p_visit_task_id
3275: AND STATUS = 'ACTIVE';
3276:

Line 3273: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

3269: SET STATUS = 'HISTORY',
3270: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3271: LAST_UPDATE_DATE = sysdate,
3272: LAST_UPDATED_BY = Fnd_Global.USER_ID,
3273: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3274: WHERE visit_task_id = p_visit_task_id
3275: AND STATUS = 'ACTIVE';
3276:
3277: -- Standard check of p_commit