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

Line 80: u fnd_user%rowtype;

76: c_mode_code in varchar2,
77: c_url in varchar2)
78: return varchar2 is
79:
80: u fnd_user%rowtype;
81: c_server_name varchar2(240);
82: c_server_port varchar2(80);
83: l_server varchar2(240);
84: c_script_name varchar2(80);

Line 140: FROM fnd_user

136: -- start additions for 1916792
137: BEGIN
138: SELECT user_id
139: INTO t_user_id
140: FROM fnd_user
141: WHERE user_name=upper(c_user_name);
142: EXCEPTION
143: WHEN no_data_found THEN
144: t_user_id := NULL;

Line 199: from fnd_user

195: if l_result = 'N'
196: then
197: select *
198: into u
199: from fnd_user
200: where user_name = UPPER(c_user_name);
201:
202: if u.user_id = 6
203: then

Line 248: from FND_USER

244:
245: begin
246: select 'Y'
247: into l_expired
248: from FND_USER
249: where USER_NAME = UPPER(c_user_name)
250: and (PASSWORD_DATE is NULL or
251: (PASSWORD_LIFESPAN_ACCESSES is not NULL and
252: nvl(PASSWORD_ACCESSES_LEFT, 0) < 1) or

Line 268: from fnd_user

264: else
265:
266: select *
267: into u
268: from fnd_user
269: where user_name = UPPER(c_user_name);
270:
271: if u.end_date is null or u.end_date > sysdate
272: then

Line 295: from fnd_user

291:
292: begin
293: select *
294: into u
295: from fnd_user
296: where user_name = UPPER(c_user_name)
297: and WEB_PASSWORD is not null;
298: exception
299: when others then

Line 414: l_user fnd_user%rowtype;

410: l_parameters icx_on_utilities.v80_table;
411: l_user_id number;
412: l_responsibility_id number;
413: l_function_id number;
414: l_user fnd_user%rowtype;
415: l_session_id number;
416: c_server_name varchar2(240);
417: c_domain varchar2(240);
418: l_date_format_mask varchar2(240);

Line 601: FND_USER_RESP_GROUPS b,

597:
598: select count(*) into l_count_resp_f
599: from FND_SECURITY_GROUPS_VL fsg,
600: fnd_responsibility_vl a,
601: FND_USER_RESP_GROUPS b,
602: FND_APPLICATION fa
603: where b.user_id = p_user_id
604: and b.start_date <= sysdate
605: and (b.end_date is null or b.end_date > sysdate)

Line 617: FND_USER_RESP_GROUPS b,

613:
614: select count(*) into l_count_resp_o
615: from FND_SECURITY_GROUPS_VL fsg,
616: fnd_responsibility_vl a,
617: FND_USER_RESP_GROUPS b,
618: FND_APPLICATION fa
619: where b.user_id = p_user_id
620: and b.start_date <= sysdate
621: and (b.end_date is null or b.end_date > sysdate)

Line 672: FROM fnd_user

668:
669: BEGIN
670: SELECT user_id
671: INTO l_guest_user_id
672: FROM fnd_user
673: WHERE user_name = l_guest_username;
674: EXCEPTION
675: WHEN no_data_found THEN
676: l_guest_username := -999;

Line 969: function NewSession( user_info in fnd_user%rowtype,

965: -- ***********************************************
966: -- Function NewSession
967: -- ***********************************************
968:
969: function NewSession( user_info in fnd_user%rowtype,
970: c_user_name in varchar2,
971: c_password in varchar2,
972: n_session_id out NOCOPY number,
973: c_validate_only in varchar2,

Line 1851: FROM fnd_user

1847: c_login_msg := fnd_message.get;
1848: IF g_user_id IS NOT NULL THEN
1849: SELECT user_name
1850: INTO c_user_name
1851: FROM fnd_user
1852: WHERE user_id=g_user_id;
1853:
1854: END IF;
1855:

Line 1967: FROM fnd_user

1963: l_anon_name := SUBSTR(l_anon_name, 1, INSTR(l_anon_name, '/') -1);
1964: BEGIN
1965: SELECT user_id
1966: INTO l_user_id
1967: FROM fnd_user
1968: WHERE user_name = l_anon_name;
1969: EXCEPTION
1970: WHEN no_data_found THEN
1971: l_user_id := -999;

Line 1991: FROM fnd_user

1987:
1988: BEGIN
1989: SELECT user_id
1990: INTO l_user_id
1991: FROM fnd_user
1992: WHERE user_name = l_anon_name;
1993: EXCEPTION
1994: WHEN no_data_found THEN
1995: l_user_id := -999;

Line 2814: from fnd_user

2810: then
2811:
2812: select CUSTOMER_ID, SUPPLIER_ID, EMPLOYEE_ID
2813: into n_customer_contact_id, n_vendor_contact_id, n_internal_contact_id
2814: from fnd_user
2815: where user_id = n_user_id;
2816:
2817: if n_param = PV_CUST_CONTACT_ID --** CUSTOMER_CONTACT_ID (7)
2818: then

Line 2972: fnd_user b

2968: then
2969: select b.USER_NAME
2970: into n_id
2971: from icx_sessions a,
2972: fnd_user b
2973: where b.user_id = a.user_id
2974: and a.session_id = n_session_id;
2975:
2976: elsif n_param = PV_USER_ID --** WEB USER ID (10) **

Line 3135: FND_USER_RESP_GROUPS b

3131: select a.responsibility_name
3132: from
3133: --FND_SECURITY_GROUPS_VL fsg, -- mputman per 2018060
3134: fnd_responsibility_vl a,
3135: FND_USER_RESP_GROUPS b
3136: where b.user_id = c_user_id
3137: and b.start_date <= sysdate
3138: and (b.end_date is null or b.end_date > sysdate)
3139: and b.RESPONSIBILITY_id = a.responsibility_id

Line 4040: u fnd_user%rowtype;

4036: p_mode IN VARCHAR2)
4037: RETURN VARCHAR2
4038: IS
4039:
4040: u fnd_user%rowtype;
4041: c_server_name varchar2(240);
4042: c_server_port varchar2(80);
4043: l_server varchar2(240);
4044: c_script_name varchar2(80);

Line 4084: from FND_USER

4080:
4081: begin
4082: select 'Y'
4083: into l_expired
4084: from FND_USER
4085: where USER_NAME = UPPER(i_1)
4086: and (PASSWORD_DATE is NULL or
4087: (PASSWORD_LIFESPAN_ACCESSES is not NULL and
4088: nvl(PASSWORD_ACCESSES_LEFT, 0) < 1) or

Line 4105: from fnd_user

4101: else
4102:
4103: select *
4104: into u
4105: from fnd_user
4106: where user_name = UPPER(i_1);
4107:
4108: if u.end_date is null or u.end_date > sysdate
4109: then

Line 4313: FROM fnd_user

4309:
4310: BEGIN
4311: SELECT user_name
4312: INTO l_user_name
4313: FROM fnd_user
4314: WHERE user_id=l_user_id;
4315: EXCEPTION
4316: WHEN OTHERS THEN
4317: WF_CORE.CONTEXT('icx_sec', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);

Line 4426: FROM fnd_user

4422: l_anon_name := SUBSTR(l_anon_name, 1, INSTR(l_anon_name, '/') -1);
4423: BEGIN
4424: SELECT user_id
4425: INTO l_anon_user_id
4426: FROM fnd_user
4427: WHERE user_name = l_anon_name;
4428: EXCEPTION
4429: WHEN no_data_found THEN
4430: l_anon_user_id := -999;

Line 4441: fnd_user_resp_groups d,

4437: INTO n_hits
4438: from FND_FORM_FUNCTIONS a,
4439: fnd_menu_entries_vl b,
4440: fnd_responsibility_vl c,
4441: fnd_user_resp_groups d,
4442: fnd_security_groups_vl e
4443: where d.user_id = l_anon_user_id
4444: AND a.function_id = p_func_id
4445: and b.function_id = a.function_id