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.

[Home] [Help]

APPS.FND_SIGNON dependencies on FND_LOGIN_RESPONSIBILITIES

Line 58: UPDATE FND_LOGIN_RESPONSIBILITIES FLR

54: return;
55: end if;
56:
57: -- Stamp end time on any current resp for this login in FLR
58: UPDATE FND_LOGIN_RESPONSIBILITIES FLR
59: SET END_TIME = SYSDATE
60: WHERE FLR.LOGIN_ID = audit_responsibility_end.login_id
61: AND FLR.END_TIME is NULL;
62:

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

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

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 209: -- FND_LOGIN_RESPONSIBILITIES. The login_resp_id generated will be passed back to the API

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

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,

Line 217: INSERT INTO FND_LOGIN_RESPONSIBILITIES

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,
219: AUDSID)
220: VALUES (audit_responsibility.login_id,
221: audit_responsibility.login_resp_id,

Line 842: FROM fnd_login_responsibilities

838: if (l_audit_level in ('C', 'D')) then
839:
840: --see if there is already a row
841: SELECT count(*) INTO rows_exist
842: FROM fnd_login_responsibilities
843: WHERE login_id=audit_web_responsibility.login_id
844: AND login_resp_id=audit_web_responsibility.login_resp_id;
845:
846:

Line 849: INSERT INTO FND_LOGIN_RESPONSIBILITIES

845:
846:
847: IF rows_exist=0 THEN
848:
849: INSERT INTO FND_LOGIN_RESPONSIBILITIES
850: (LOGIN_ID, LOGIN_RESP_ID, RESP_APPL_ID, RESPONSIBILITY_ID, START_TIME,
851: AUDSID)
852: VALUES (audit_web_responsibility.login_id,
853: audit_web_responsibility.login_resp_id,