APPS.FND_SIGNON dependencies on FND_LOGINS_S

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