DBA Data[Home] [Help]

APPS.GMO_DVC_INTG_PVT dependencies on FND_GLOBAL

Line 245: FND_GLOBAL.USER_ID,

241: GMO_DEVICE_RESPONSES_T_S.nextval,
242: P_REQUEST_ID,
243: P_RESP_COMP_CODE,
244: P_RESP_COMP_CODE_VALUE,
245: FND_GLOBAL.USER_ID,
246: sysdate,
247: FND_GLOBAL.USER_ID,
248: FND_GLOBAL.LOGIN_ID,
249: sysdate

Line 247: FND_GLOBAL.USER_ID,

243: P_RESP_COMP_CODE,
244: P_RESP_COMP_CODE_VALUE,
245: FND_GLOBAL.USER_ID,
246: sysdate,
247: FND_GLOBAL.USER_ID,
248: FND_GLOBAL.LOGIN_ID,
249: sysdate
250: );
251: ELSIF (P_ACTION = ACTION_UPDATE_RESPONSE) then

Line 248: FND_GLOBAL.LOGIN_ID,

244: P_RESP_COMP_CODE_VALUE,
245: FND_GLOBAL.USER_ID,
246: sysdate,
247: FND_GLOBAL.USER_ID,
248: FND_GLOBAL.LOGIN_ID,
249: sysdate
250: );
251: ELSIF (P_ACTION = ACTION_UPDATE_RESPONSE) then
252:

Line 255: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

251: ELSIF (P_ACTION = ACTION_UPDATE_RESPONSE) then
252:
253: update gmo_device_responses_t set
254: RESP_COMP_CODE_VALUE = P_RESP_COMP_CODE_VALUE,
255: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
256: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
257: LAST_UPDATE_DATE = sysdate
258: where REQUEST_ID = P_REQUEST_ID
259: and RESP_COMP_CODE = P_RESP_COMP_CODE;

Line 256: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

252:
253: update gmo_device_responses_t set
254: RESP_COMP_CODE_VALUE = P_RESP_COMP_CODE_VALUE,
255: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
256: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
257: LAST_UPDATE_DATE = sysdate
258: where REQUEST_ID = P_REQUEST_ID
259: and RESP_COMP_CODE = P_RESP_COMP_CODE;
260:

Line 299: VALUES (P_REQUEST_ID, P_DEVICE_ID, P_REQUESTER, '', P_DEVICE_STATUS, SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, SYSDATE);

295:
296: IF (P_ACTION = ACTION_INSERT_REQUEST) then
297:
298: INSERT INTO GMO_DEVICE_REQUESTS_T (REQUEST_ID, DEVICE_ID, REQUESTER, RESPONSE_STATUS, DEVICE_STATUS, REQUEST_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE)
299: VALUES (P_REQUEST_ID, P_DEVICE_ID, P_REQUESTER, '', P_DEVICE_STATUS, SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, SYSDATE);
300:
301: ELSIF (P_ACTION = ACTION_UPDATE_DEVICE_STATUS) then
302:
303: UPDATE GMO_DEVICE_REQUESTS_T SET

Line 306: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

302:
303: UPDATE GMO_DEVICE_REQUESTS_T SET
304: DEVICE_STATUS = P_DEVICE_STATUS,
305: LAST_UPDATE_DATE = sysdate,
306: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
307: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
308: WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;
309:
310: ELSIF (P_ACTION = ACTION_UPDATE_DEVICE_RESPONSE) then

Line 307: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

303: UPDATE GMO_DEVICE_REQUESTS_T SET
304: DEVICE_STATUS = P_DEVICE_STATUS,
305: LAST_UPDATE_DATE = sysdate,
306: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
307: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
308: WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;
309:
310: ELSIF (P_ACTION = ACTION_UPDATE_DEVICE_RESPONSE) then
311: -- update process_device_response

Line 315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

311: -- update process_device_response
312: UPDATE GMO_DEVICE_REQUESTS_T SET
313: RESPONSE_STATUS = FND_API.G_RET_STS_SUCCESS,
314: LAST_UPDATE_DATE = sysdate,
315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
316: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
317: WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;
318: END IF;
319:

Line 316: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

312: UPDATE GMO_DEVICE_REQUESTS_T SET
313: RESPONSE_STATUS = FND_API.G_RET_STS_SUCCESS,
314: LAST_UPDATE_DATE = sysdate,
315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
316: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
317: WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;
318: END IF;
319:
320: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1023: POST_REQUEST (P_ACTION => ACTION_UPDATE_DEVICE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_DEVICE_ID => P_DEVICE_ID , P_REQUESTER => FND_GLOBAL.USER_ID , P_DEVICE_STATUS => '');

1019: POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'58' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.DESTINATION_LOCATOR_ID);
1020: POST_RESPONSE (P_ACTION => ACTION_UPDATE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_RESP_COMP_CODE =>'59' , P_RESP_COMP_CODE_VALUE => P_PARAM_VALUES_RECORD.SOURCE_LOCATOR_ID);
1021:
1022: -- update process_device_response
1023: POST_REQUEST (P_ACTION => ACTION_UPDATE_DEVICE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_DEVICE_ID => P_DEVICE_ID , P_REQUESTER => FND_GLOBAL.USER_ID , P_DEVICE_STATUS => '');
1024:
1025: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1026:
1027: EXCEPTION