DBA Data[Home] [Help]

APPS.EAM_PM_LAST_SERVICE_PUB dependencies on FND_GLOBAL

Line 217: fnd_global.user_id,

213: p_pm_last_service_tbl(i).LAST_SERVICE_READING ,
214: p_pm_last_service_tbl(i).PREV_SERVICE_READING ,
215: --p_WIP_ENTITY_ID ,
216:
217: fnd_global.user_id,
218: sysdate,
219: fnd_global.login_id,
220: sysdate ,
221: fnd_global.user_id

Line 219: fnd_global.login_id,

215: --p_WIP_ENTITY_ID ,
216:
217: fnd_global.user_id,
218: sysdate,
219: fnd_global.login_id,
220: sysdate ,
221: fnd_global.user_id
222: );
223:

Line 221: fnd_global.user_id

217: fnd_global.user_id,
218: sysdate,
219: fnd_global.login_id,
220: sysdate ,
221: fnd_global.user_id
222: );
223:
224: ELSE
225: UPDATE EAM_PM_LAST_SERVICE

Line 233: LAST_UPDATE_LOGIN = fnd_global.login_id ,

229: LAST_SERVICE_READING = p_pm_last_service_tbl(i).LAST_SERVICE_READING,
230: PREV_SERVICE_READING = p_pm_last_service_tbl(i).PREV_SERVICE_READING,
231: --WIP_ENTITY_ID = p_WIP_ENTITY_ID ,
232:
233: LAST_UPDATE_LOGIN = fnd_global.login_id ,
234: LAST_UPDATE_DATE = sysdate ,
235: LAST_UPDATED_BY = fnd_global.user_id
236: WHERE METER_ID = p_pm_last_service_tbl(i).METER_ID AND
237: ACTIVITY_ASSOCIATION_ID = p_actv_assoc_id;

Line 235: LAST_UPDATED_BY = fnd_global.user_id

231: --WIP_ENTITY_ID = p_WIP_ENTITY_ID ,
232:
233: LAST_UPDATE_LOGIN = fnd_global.login_id ,
234: LAST_UPDATE_DATE = sysdate ,
235: LAST_UPDATED_BY = fnd_global.user_id
236: WHERE METER_ID = p_pm_last_service_tbl(i).METER_ID AND
237: ACTIVITY_ASSOCIATION_ID = p_actv_assoc_id;
238: END IF;
239: CLOSE c_check_update;