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_USER

Line 359: from FND_USER

355: -- Bug 7160418 skip guest user as we do not audit guest
356: if (UID <> 6) then
357: select SESSION_NUMBER
358: into LSID
359: from FND_USER
360: where USER_ID = UID
361: for update of SESSION_NUMBER, LAST_LOGON_DATE;
362: LSID := LSID + 1;
363: SID := LSID;

Line 367: update FND_USER

363: SID := LSID;
364: --
365: -- Update session number, set logon date
366: --
367: update FND_USER
368: set LAST_LOGON_DATE = SYSDATE,
369: SESSION_NUMBER = LSID
370: where USER_ID = UID;
371:

Line 378: from FND_USER

374: --
375: begin
376: select 'Y'
377: into EXPIRED
378: from FND_USER
379: where USER_ID = UID
380: and ENCRYPTED_USER_PASSWORD <> 'EXTERNAL' -- Bug #2288977 --
381: and (PASSWORD_DATE is NULL or
382: (PASSWORD_LIFESPAN_ACCESSES is not NULL and

Line 394: update FND_USER

390: --
391: -- Decrement password accesses left
392: --
393: begin
394: update FND_USER
395: set PASSWORD_ACCESSES_LEFT = PASSWORD_ACCESSES_LEFT - 1
396: where USER_ID = UID
397: and PASSWORD_ACCESSES_LEFT > 0;
398: exception

Line 428: * expiration related bookkeeping data in fnd_user table if necessary.

424: -- (2) new_icx_session(UID,l_login_id): performs auditing and
425: -- session number related operation, to be used when a session
426: -- is created.
427: /* tests whether a password has expired or not, updates
428: * expiration related bookkeeping data in fnd_user table if necessary.
429: * update last_logon_date in fnd_user
430: */
431: procedure is_pwd_expired(UID in number,
432: EXPIRED out nocopy varchar2) is

Line 429: * update last_logon_date in fnd_user

425: -- session number related operation, to be used when a session
426: -- is created.
427: /* tests whether a password has expired or not, updates
428: * expiration related bookkeeping data in fnd_user table if necessary.
429: * update last_logon_date in fnd_user
430: */
431: procedure is_pwd_expired(UID in number,
432: EXPIRED out nocopy varchar2) is
433: pragma AUTONOMOUS_TRANSACTION;

Line 441: from FND_USER

437: --
438: begin
439: select 'Y'
440: into EXPIRED
441: from FND_USER
442: where USER_ID = UID
443: and ENCRYPTED_USER_PASSWORD <> 'EXTERNAL' -- Bug #2288977 --
444: and (PASSWORD_DATE is NULL or
445: (PASSWORD_LIFESPAN_ACCESSES is not NULL and

Line 457: update FND_USER

453: --
454: -- Decrement password accesses left
455: --
456: begin
457: update FND_USER
458: set PASSWORD_ACCESSES_LEFT = PASSWORD_ACCESSES_LEFT - 1
459: where USER_ID = UID
460: and PASSWORD_ACCESSES_LEFT > 0;
461: exception

Line 466: update FND_USER

462: when no_data_found then
463: null;
464: end;
465:
466: update FND_USER
467: set LAST_LOGON_DATE = SYSDATE
468: where USER_ID = UID;
469:
470: commit;

Line 478: * updates session_number in fnd_user table.

474: generic_error('FND_SIGNON.is_pwd_expired', SQLCODE, SQLERRM);
475: end is_pwd_expired;
476:
477: /*
478: * updates session_number in fnd_user table.
479: * generate auditing record
480: */
481: procedure new_icx_session(UID IN NUMBER,
482: login_id OUT nocopy NUMBER) IS

Line 488: * updates session_number in fnd_user table.

484: new_proxy_icx_session(UID, null, login_id);
485: end new_icx_session;
486:
487: /*
488: * updates session_number in fnd_user table.
489: * generate auditing record
490: * Same as new_icx_session except a single change for handling SIGNONAUDIT:LEVEL
491: * differently for Proxy Sessions.
492: */

Line 509: from FND_USER

505: -- Bug 7160418 skip guest user as we do not audit guest
506: if (UID <> 6) then
507: select SESSION_NUMBER
508: into LSID
509: from FND_USER
510: where USER_ID = UID
511: for update of SESSION_NUMBER, LAST_LOGON_DATE;
512: LSID := LSID + 1;
513: --

Line 516: update FND_USER

512: LSID := LSID + 1;
513: --
514: -- Update session number, set logon date
515: --
516: update FND_USER
517: set LAST_LOGON_DATE = SYSDATE,
518: SESSION_NUMBER = LSID
519: where USER_ID = UID;
520: else

Line 582: delete from FND_USER_DESKTOP_OBJECTS

578: is
579: begin
580: if (func_name is null) then
581: -- Delete if value nulled out
582: delete from FND_USER_DESKTOP_OBJECTS
583: where USER_ID = update_desktop_object.user_id
584: and APPLICATION_ID = update_desktop_object.appl_id
585: and RESPONSIBILITY_ID = update_desktop_object.resp_id
586: and TYPE = 'FUNCTION'

Line 590: update FND_USER_DESKTOP_OBJECTS set

586: and TYPE = 'FUNCTION'
587: and SEQUENCE = update_desktop_object.func_sequence;
588: else
589: -- Try for update
590: update FND_USER_DESKTOP_OBJECTS set
591: FUNCTION_NAME = update_desktop_object.func_name,
592: LAST_UPDATE_DATE = sysdate,
593: LAST_UPDATED_BY = update_desktop_object.user_id,
594: LAST_UPDATE_LOGIN = update_desktop_object.login_id

Line 603: insert into FND_USER_DESKTOP_OBJECTS (

599: and SEQUENCE = update_desktop_object.func_sequence;
600:
601: if (sql%rowcount = 0) then
602: -- Insert new row if not found
603: insert into FND_USER_DESKTOP_OBJECTS (
604: DESKTOP_OBJECT_ID,
605: USER_ID,
606: APPLICATION_ID,
607: RESPONSIBILITY_ID,

Line 995: from FND_USER

991:
992: -- check user id exist.
993: select user_id
994: into l_user_id
995: from FND_USER
996: where user_id = p_userID;
997:
998: -- Bug 7169414 - rewrite - changed query to be the same used in the Forms login
999:

Line 1002: from fnd_unsuccessful_logins ul, fnd_user u

998: -- Bug 7169414 - rewrite - changed query to be the same used in the Forms login
999:
1000: select count(ul.USER_ID)
1001: into number_of_unsuccessful_logins
1002: from fnd_unsuccessful_logins ul, fnd_user u
1003: where u.user_id = l_user_id
1004: and ul.user_id = u.user_id
1005: and ul.attempt_time > nvl(u.last_logon_date, u.last_update_date);
1006: