APPS.FND_SIGNON dependencies on FND_LOGINS

Line 95: select spid into l_spid from fnd_logins

91: return;
92: else
93: -- Get the processes for this login_id as the same SPID will be associated
94: -- with different login_ids
95: select spid into l_spid from fnd_logins
96: where login_id = audit_user_end.login_id;
97: end if;
98:
99: -- Stamp end time on current login in FL

Line 101: UPDATE FND_LOGINS FL

97: end if;
98:
99: -- Stamp end time on current login in FL
100:
101: UPDATE FND_LOGINS FL
102: SET END_TIME = pend_time
103: WHERE FL.LOGIN_ID = audit_user_end.login_id;
104:
105: -- Bug 11904176: end date the associated SPIDs

Line 107: UPDATE FND_LOGINS FL

103: WHERE FL.LOGIN_ID = audit_user_end.login_id;
104:
105: -- Bug 11904176: end date the associated SPIDs
106: if (l_spid is not null) then
107: UPDATE FND_LOGINS FL
108: SET END_TIME = pend_time
109: where spid = l_spid;
110: end if;
111:

Line 219: UPDATE FND_LOGINS FL

215: FROM V$PROCESS P, V$SESSION S
216: WHERE S.AUDSID = USERENV('SESSIONID')
217: AND S.PADDR = P.ADDR;
218:
219: UPDATE FND_LOGINS FL
220: SET PID = l_pid,
221: SERIAL# = l_serial,
222: PROCESS_SPID = l_spid
223: WHERE FL.LOGIN_ID = audit_responsibility.login_id;

Line 290: SELECT FND_LOGINS_S.NEXTVAL INTO audit_user.login_id FROM SYS.DUAL;

286: AUDIT_USER_END(login_id);
287: AUDIT_RESPONSIBILITY_END(login_id);
288:
289: -- Create a new login id
290: SELECT FND_LOGINS_S.NEXTVAL INTO audit_user.login_id FROM SYS.DUAL;
291:
292: -- If auditing turned on insert record in FL for new login
293: -- bug 7160418, skip auditing for guest user
294: if (audit_level <> 'A') AND (user_id <> '6') then

Line 309: INSERT INTO FND_LOGINS

305: local_spid := null;
306: end;
307:
308: -- Insert record
309: INSERT INTO FND_LOGINS
310: (LOGIN_ID, USER_ID, START_TIME, TERMINAL_ID,
311: LOGIN_NAME, PID, SPID, SESSION_NUMBER, SERIAL#,
312: PROCESS_SPID, LOGIN_TYPE)
313: VALUES(audit_user.login_id, audit_user.user_id, SYSDATE,

Line 921: -- Bug 3238722: The login_id generated by FND_LOGINS_S is not being recorded in

917: BEGIN
918:
919: PRIVATE_NEW_SESSION(user_id, l_session_number, l_expired);
920: --
921: -- Bug 3238722: The login_id generated by FND_LOGINS_S is not being recorded in
922: -- FND_LOGINS when a user-level value for the profile option 'Sign-On Audit:Level' is set
923: -- but a site-level value is not. This happens when the audit level value returned by
924: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
925: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,

Line 922: -- FND_LOGINS when a user-level value for the profile option 'Sign-On Audit:Level' is set

918:
919: PRIVATE_NEW_SESSION(user_id, l_session_number, l_expired);
920: --
921: -- Bug 3238722: The login_id generated by FND_LOGINS_S is not being recorded in
922: -- FND_LOGINS when a user-level value for the profile option 'Sign-On Audit:Level' is set
923: -- but a site-level value is not. This happens when the audit level value returned by
924: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
925: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
926: -- then the context is not set. If the context is not set, the code should call

Line 929: -- be properly recorded in FND_LOGINS.

925: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
926: -- then the context is not set. If the context is not set, the code should call
927: -- fnd_profile.value_specific and pass in the user_id to return an accurate value for
928: -- the audit level. Once an accurate value for the profile is returned, the login_id will
929: -- be properly recorded in FND_LOGINS.
930: --
931:
932: SELECT userenv('SESSIONID')
933: INTO l_session_id