DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_LOGIN_RESPONSIBILITIES_S

Line 207: -- the session. A new sequence, FND_LOGIN_RESPONSIBILITIES_S, is created to generate unique

203: --
204: -- Bug 3457883: The unique index FND_LOGIN_RESPONSIBILITIES_U1 is being violated when a
205: -- responsibility is relaunched within an existing ICX session. This was brought about
206: -- by the changes in bug 3043856 wherein the login_id obtained by ICX is not used throughout
207: -- the session. A new sequence, FND_LOGIN_RESPONSIBILITIES_S, is created to generate unique
208: -- values for login_resp_id and will be used when inserting records into
209: -- FND_LOGIN_RESPONSIBILITIES. The login_resp_id generated will be passed back to the API
210: -- calling fnd_signon.audit_responsibility().
211: --

Line 214: select FND_LOGIN_RESPONSIBILITIES_S.nextval into login_resp_id from dual;

210: -- calling fnd_signon.audit_responsibility().
211: --
212: -- If login_resp_id is null, then generate one.
213: if (login_resp_id is null) then
214: select FND_LOGIN_RESPONSIBILITIES_S.nextval into login_resp_id from dual;
215: end if;
216:
217: INSERT INTO FND_LOGIN_RESPONSIBILITIES
218: (LOGIN_ID, LOGIN_RESP_ID, RESP_APPL_ID, RESPONSIBILITY_ID, START_TIME,