APPS.FND_SIGNON dependencies on FND_LOGINS

Line 86: UPDATE FND_LOGINS FL

82: end if;
83:
84: -- Stamp end time on current login in FL
85:
86: UPDATE FND_LOGINS FL
87: SET END_TIME = SYSDATE
88: WHERE FL.LOGIN_ID = audit_user_end.login_id;
89:
90: -- End any open resps

Line 195: UPDATE FND_LOGINS FL

191: FROM V$PROCESS P, V$SESSION S
192: WHERE S.AUDSID = USERENV('SESSIONID')
193: AND S.PADDR = P.ADDR;
194:
195: UPDATE FND_LOGINS FL
196: SET PID = l_pid,
197: SERIAL# = l_serial,
198: PROCESS_SPID = l_spid
199: WHERE FL.LOGIN_ID = audit_responsibility.login_id;

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

262: AUDIT_USER_END(login_id);
263: AUDIT_RESPONSIBILITY_END(login_id);
264:
265: -- Create a new login id
266: SELECT FND_LOGINS_S.NEXTVAL INTO audit_user.login_id FROM SYS.DUAL;
267:
268: -- If auditing turned on insert record in FL for new login
269: -- bug 7160418, skip auditing for guest user
270: if (audit_level <> 'A') AND (user_id <> '6') then

Line 285: INSERT INTO FND_LOGINS

281: local_spid := null;
282: end;
283:
284: -- Insert record
285: INSERT INTO FND_LOGINS
286: (LOGIN_ID, USER_ID, START_TIME, TERMINAL_ID,
287: LOGIN_NAME, PID, SPID, SESSION_NUMBER, SERIAL#,
288: PROCESS_SPID, LOGIN_TYPE)
289: VALUES(audit_user.login_id, audit_user.user_id, SYSDATE,

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

893: BEGIN
894:
895: PRIVATE_NEW_SESSION(user_id, l_session_number, l_expired);
896: --
897: -- Bug 3238722: The login_id generated by FND_LOGINS_S is not being recorded in
898: -- FND_LOGINS when a user-level value for the profile option 'Sign-On Audit:Level' is set
899: -- but a site-level value is not. This happens when the audit level value returned by
900: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
901: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,

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

894:
895: PRIVATE_NEW_SESSION(user_id, l_session_number, l_expired);
896: --
897: -- Bug 3238722: The login_id generated by FND_LOGINS_S is not being recorded in
898: -- FND_LOGINS when a user-level value for the profile option 'Sign-On Audit:Level' is set
899: -- but a site-level value is not. This happens when the audit level value returned by
900: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
901: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
902: -- then the context is not set. If the context is not set, the code should call

Line 905: -- be properly recorded in FND_LOGINS.

901: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
902: -- then the context is not set. If the context is not set, the code should call
903: -- fnd_profile.value_specific and pass in the user_id to return an accurate value for
904: -- the audit level. Once an accurate value for the profile is returned, the login_id will
905: -- be properly recorded in FND_LOGINS.
906: --
907:
908: SELECT userenv('SESSIONID')
909: INTO l_session_id