eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_DVC_INTG_PVT dependencies on GMO_DEVICE_REQUESTS_T

Line 195: (SELECT REQUEST_ID FROM GMO_DEVICE_REQUESTS_T

191: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.temp_data_cleanup', FALSE);
192: end if;
193:
194: DELETE FROM GMO_DEVICE_RESPONSES_T WHERE REQUEST_ID IN
195: (SELECT REQUEST_ID FROM GMO_DEVICE_REQUESTS_T
196: WHERE CREATION_DATE < l_cleanup_to_date );
197:
198: DELETE FROM GMO_DEVICE_REQUESTS_T WHERE CREATION_DATE < l_cleanup_to_date;
199:

Line 198: DELETE FROM GMO_DEVICE_REQUESTS_T WHERE CREATION_DATE < l_cleanup_to_date;

194: DELETE FROM GMO_DEVICE_RESPONSES_T WHERE REQUEST_ID IN
195: (SELECT REQUEST_ID FROM GMO_DEVICE_REQUESTS_T
196: WHERE CREATION_DATE < l_cleanup_to_date );
197:
198: DELETE FROM GMO_DEVICE_REQUESTS_T WHERE CREATION_DATE < l_cleanup_to_date;
199:
200: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
201:
202: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_CLEANUP_SUCCESS_MSG');

Line 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)

294: BEGIN
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:

Line 303: UPDATE GMO_DEVICE_REQUESTS_T SET

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
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

Line 312: UPDATE GMO_DEVICE_REQUESTS_T SET

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
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

Line 752: select RESPONSE_STATUS into l_response_status from gmo_device_requests_t where request_id = l_request_id;

748:
749: select sysdate into l_request_current_date from dual;
750: l_request_exec_time := (l_request_current_date - l_request_start_date)*24*60*60;
751:
752: select RESPONSE_STATUS into l_response_status from gmo_device_requests_t where request_id = l_request_id;
753:
754: if (l_response_status is not null) then
755: L_DEVICE_REQUEST_END := TRUE;
756:

Line 958: select count(*) into l_count from GMO_DEVICE_REQUESTS_T WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;

954: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
955: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
956: end if;
957:
958: select count(*) into l_count from GMO_DEVICE_REQUESTS_T WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;
959:
960: if (l_count = 0) then
961: raise l_request_not_found_err;
962: end if;