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.ORACLEAPPS dependencies on FND_USER

Line 534: from fnd_user

530:
531: BEGIN
532: SELECT user_id
533: into l_user_id
534: from fnd_user
535: where user_name = upper(c_user_name);
536:
537: BEGIN
538: SELECT 'LDAP'

Line 540: FROM fnd_user

536:
537: BEGIN
538: SELECT 'LDAP'
539: INTO l_auth_mode
540: FROM fnd_user
541: WHERE l_user_id = icx_sec.g_user_id
542: AND upper(encrypted_user_password)='EXTERNAL';
543:
544: EXCEPTION

Line 576: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.user.password.reset_requested',

572: e_parameters);
573: WF_EVENT.AddParameterToList('X_PASSWORD_LIFESPAN_DAYS', p_expire_days,
574: e_parameters);
575:
576: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.user.password.reset_requested',
577: p_event_key=>seq, p_parameters=>e_parameters);
578:
579: DBMS_RANDOM.terminate;
580:

Line 1150: fnd_user_resp_groups furg,

1146: cursor getResp(p_user_id in varchar2) is
1147: select fr.menu_id, furg.responsibility_id,
1148: furg.security_group_id, furg.responsibility_application_id
1149: from fnd_responsibility fr,
1150: fnd_user_resp_groups furg,
1151: fnd_user fu
1152: where fu.USER_ID = p_user_id
1153: and fu.START_DATE <= sysdate
1154: and (fu.END_DATE is null or fu.END_DATE > sysdate)

Line 1151: fnd_user fu

1147: select fr.menu_id, furg.responsibility_id,
1148: furg.security_group_id, furg.responsibility_application_id
1149: from fnd_responsibility fr,
1150: fnd_user_resp_groups furg,
1151: fnd_user fu
1152: where fu.USER_ID = p_user_id
1153: and fu.START_DATE <= sysdate
1154: and (fu.END_DATE is null or fu.END_DATE > sysdate)
1155: and furg.USER_ID = fu.USER_ID

Line 1182: from FND_USER

1178: if l_result = 'Y'
1179: then
1180: select USER_ID
1181: into l_user_id
1182: from FND_USER
1183: where USER_NAME = l_username;
1184:
1185: if (F is not null)
1186: then

Line 1341: from FND_USER

1337: if l_result = 'Y'
1338: then
1339: select USER_ID
1340: into l_user_id
1341: from FND_USER
1342: where USER_NAME = l_username;
1343:
1344: l_session_id := icx_sec.createSession(p_user_id => l_user_id,
1345: c_mode_code => '115P') ;

Line 1463: FND_USER_RESP_GROUPS b

1459: a.web_agent_name,
1460: a.version,
1461: a.menu_id
1462: from fnd_responsibility_vl a,
1463: FND_USER_RESP_GROUPS b
1464: where b.user_id = c_user_id
1465: and a.responsibility_id = b.responsibility_id
1466: and a.application_id = b.RESPONSIBILITY_application_id
1467: and a.version = 'W'

Line 1561: from fnd_user a,

1557: end if;
1558:
1559: select a.description, a.user_name, a.user_id
1560: into c_known_as, c_user_name, c_user_id
1561: from fnd_user a,
1562: icx_sessions b
1563: where b.session_id = n_session_id
1564: and b.user_id = a.user_id;
1565:

Line 2982: FND_USER_RESP_GROUPS b,

2978: cursor resps is
2979: select a.responsibility_id,a.responsibility_name,
2980: web_HOST_NAME,web_AGENT_NAME
2981: from fnd_responsibility_vl a,
2982: FND_USER_RESP_GROUPS b,
2983: icx_sessions c
2984: where n_session_id = c.session_id
2985: and c.user_id = b.user_id
2986: and a.version = 'W'

Line 3132: u fnd_user%rowtype;

3128: -- Procedure displayWebUserlocal
3129: -- ***********************************************
3130: procedure displayWebUserlocal(p_message_flag VARCHAR2) is
3131:
3132: u fnd_user%rowtype;
3133: c_user_id varchar2(15);
3134: c_lang_code varchar2(30);
3135: c_language_code varchar2(30);
3136: c_title varchar2(80);

Line 3223: from fnd_user

3219:
3220: if (icx_sec.validateSession) then
3221:
3222: select * into u
3223: from fnd_user
3224: where user_id = icx_sec.g_user_id;
3225:
3226: c_language_code := icx_sec.g_language_code;
3227: l_date_format := icx_sec.g_date_format;

Line 3257: FROM fnd_user

3253:
3254: BEGIN
3255: SELECT 'LDAP'
3256: INTO l_auth_mode
3257: FROM fnd_user
3258: WHERE user_id = icx_sec.g_user_id
3259: AND upper(encrypted_user_password)='EXTERNAL';
3260:
3261: EXCEPTION

Line 3650: -- retrieve the password change/validation error returned by fnd_user_pvt

3646: l_actiontext := fnd_message.get;
3647: icx_cabo.buttons(p_actions => l_actions,
3648: p_actiontext => l_actiontext);
3649: else
3650: -- retrieve the password change/validation error returned by fnd_user_pvt
3651: l_actiontext := p_message_flag;
3652: icx_cabo.buttons(p_actions => l_actions,
3653: p_actiontext => l_actiontext);
3654: end if;

Line 3882: fnd_message.set_token('TABLE','FND_USER');

3878: X_LEVEL_VALUE => l_user_id);
3879: if l_return_stat = FALSE then
3880:
3881: fnd_message.set_name('FND','SQL-NO INSERT');
3882: fnd_message.set_token('TABLE','FND_USER');
3883: fnd_msg_pub.Add;
3884: END IF;
3885:
3886:

Line 3903: FND_USER_PVT.Update_User(p_api_version_number => 1.0,

3899:
3900: l_server_name := owa_util.get_cgi_env('SERVER_NAME');
3901: l_server_port := owa_util.get_cgi_env('SERVER_PORT');
3902:
3903: FND_USER_PVT.Update_User(p_api_version_number => 1.0,
3904: p_init_msg_list => 'T',
3905: p_commit => 'T',
3906: p_host_port => l_server_name||':'||l_server_port,
3907: p_old_password => c_PASSWORD1,

Line 3926: c_error_msg := fnd_message.get; -- get the password update error placed on the stack by fnd_user_pvt

3922:
3923: if not l_password_updated
3924: then
3925:
3926: c_error_msg := fnd_message.get; -- get the password update error placed on the stack by fnd_user_pvt
3927: displaywebuserlocal(p_message_flag => c_error_msg);
3928: /*
3929: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3930: fnd_message.set_encoded(l_msg_data);

Line 3976: FND_USER_PVT.Update_User(p_api_version_number => 1.0,

3972:
3973: if l_password_updated
3974: then
3975:
3976: FND_USER_PVT.Update_User(p_api_version_number => 1.0,
3977: p_init_msg_list => 'T',
3978: p_commit => 'T',
3979: p_language => c_LANGUAGE,
3980: p_date_format_mask => l_date_format,

Line 4285: from fnd_user

4281: v_encrypted_psswd := to_char(icx_call.crchash(l_username,c_PASSWORD1));
4282:
4283: select user_id,web_password
4284: into l_user_id,l_web_password
4285: from fnd_user
4286: where user_name = l_username;
4287:
4288: if l_web_password = v_encrypted_upper_psswd
4289: then

Line 4776: FROM fnd_user

4772: --update session for new user.
4773: BEGIN
4774: SELECT user_id
4775: INTO l_user_id
4776: FROM fnd_user
4777: WHERE user_name = upper(i_1);
4778:
4779: icx_sec.setUserNLS(l_user_id,
4780: l_language,