APPS.FND_SIGNON dependencies on FND_LOGINS_S

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