[Home] [Help]
227: --
228: -- Bug 3457883: The unique index FND_LOGIN_RESPONSIBILITIES_U1 is being violated when a
229: -- responsibility is relaunched within an existing ICX session. This was brought about
230: -- by the changes in bug 3043856 wherein the login_id obtained by ICX is not used throughout
231: -- the session. A new sequence, FND_LOGIN_RESPONSIBILITIES_S, is created to generate unique
232: -- values for login_resp_id and will be used when inserting records into
233: -- FND_LOGIN_RESPONSIBILITIES. The login_resp_id generated will be passed back to the API
234: -- calling fnd_signon.audit_responsibility().
235: --
234: -- calling fnd_signon.audit_responsibility().
235: --
236: -- If login_resp_id is null, then generate one.
237: if (login_resp_id is null) then
238: select FND_LOGIN_RESPONSIBILITIES_S.nextval into login_resp_id from dual;
239: end if;
240:
241: INSERT INTO FND_LOGIN_RESPONSIBILITIES
242: (LOGIN_ID, LOGIN_RESP_ID, RESP_APPL_ID, RESPONSIBILITY_ID, START_TIME,