APPS.INV_MOBILE_LOGIN_INFO_PVT dependencies on MTL_MOBILE_LOGIN_HIST

Line 24: UPDATE MTL_MOBILE_LOGIN_HIST

20: IF (p_event_type = 0 ) THEN
21:
22: --what about, if he is trying to log on with same user but on different
23: --machine/port, In this case it should not delete previous login record
24: UPDATE MTL_MOBILE_LOGIN_HIST
25: SET LOGOFF_DATE = logon_date,
26: event_message = 'MWA SERVER EXCEPTION'
27: WHERE
28: USER_ID = p_user_id

Line 33: INSERT INTO MTL_MOBILE_LOGIN_HIST (

29: AND SERVER_MACHINE_NAME = p_server_machine_name
30: AND SERVER_PORT_NUMBER = p_server_port_number
31: AND LOGOFF_DATE IS NULL;
32:
33: INSERT INTO MTL_MOBILE_LOGIN_HIST (
34: USER_ID,
35: LOGON_DATE,
36: SERVER_MACHINE_NAME,
37: SERVER_PORT_NUMBER,

Line 49: UPDATE MTL_MOBILE_LOGIN_HIST SET

45: substr(p_client_machine_name,1,95),
46: p_client_port_number);
47: ELSE
48:
49: UPDATE MTL_MOBILE_LOGIN_HIST SET
50: LOGOFF_DATE = SYSDATE,
51: EVENT_MESSAGE = p_event_message
52: WHERE USER_ID = p_user_id
53: AND SERVER_MACHINE_NAME = substr(p_server_machine_name,1,95)