eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_SIGNON dependencies on FND_LOGIN_RESPONSIBILITIES

Line 64: UPDATE FND_LOGIN_RESPONSIBILITIES FLR

60: return;
61: end if;
62:
63: -- Stamp end time on any current resp for this login in FLR
64: UPDATE FND_LOGIN_RESPONSIBILITIES FLR
65: SET END_TIME = pend_time
66: WHERE FLR.LOGIN_ID = audit_responsibility_end.login_id
67: AND FLR.END_TIME is NULL;
68:

Line 228: -- Bug 3457883: The unique index FND_LOGIN_RESPONSIBILITIES_U1 is being violated when a

224:
225: -- If resp/form level auditing insert record for new resp
226: if (audit_level in ('C', 'D')) then
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

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

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

Line 233: -- FND_LOGIN_RESPONSIBILITIES. The login_resp_id generated will be passed back to the API

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: --
236: -- If login_resp_id is null, then generate one.
237: if (login_resp_id is null) then

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

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,

Line 241: INSERT INTO FND_LOGIN_RESPONSIBILITIES

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,
243: AUDSID)
244: VALUES (audit_responsibility.login_id,
245: audit_responsibility.login_resp_id,

Line 866: FROM fnd_login_responsibilities

862: if (l_audit_level in ('C', 'D')) then
863:
864: --see if there is already a row
865: SELECT count(*) INTO rows_exist
866: FROM fnd_login_responsibilities
867: WHERE login_id=audit_web_responsibility.login_id
868: AND login_resp_id=audit_web_responsibility.login_resp_id;
869:
870:

Line 873: INSERT INTO FND_LOGIN_RESPONSIBILITIES

869:
870:
871: IF rows_exist=0 THEN
872:
873: INSERT INTO FND_LOGIN_RESPONSIBILITIES
874: (LOGIN_ID, LOGIN_RESP_ID, RESP_APPL_ID, RESPONSIBILITY_ID, START_TIME,
875: AUDSID)
876: VALUES (audit_web_responsibility.login_id,
877: audit_web_responsibility.login_resp_id,