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 ICX_SEC

Line 19: if icx_sec.validateSession then

15: l_user_id number;
16:
17: begin
18:
19: if icx_sec.validateSession then
20:
21: --- Added security for guest and function security for Preferences SSWA
22:
23: select user_id into l_user_id from icx_sessions

Line 24: where session_id = icx_sec.g_session_id;

20:
21: --- Added security for guest and function security for Preferences SSWA
22:
23: select user_id into l_user_id from icx_sessions
24: where session_id = icx_sec.g_session_id;
25:
26: if l_user_id <> 6 and fnd_function.test('ICX_SSWA_USER_PREFERENCES')
27: then
28:

Line 109: l_message := icx_sec.validatePassword(i_1,i_2,n_session_id);

105:
106:
107: begin
108:
109: l_message := icx_sec.validatePassword(i_1,i_2,n_session_id);
110:
111:
112:
113: if l_message = '0'

Line 171: if(icx_sec.validateSession) then

167: l_encrypted_session_id varchar2(150);
168:
169: begin
170:
171: if(icx_sec.validateSession) then
172: l_session_id := icx_sec.g_session_id;
173:
174: select MENU_ID
175: into l_menu_id

Line 172: l_session_id := icx_sec.g_session_id;

168:
169: begin
170:
171: if(icx_sec.validateSession) then
172: l_session_id := icx_sec.g_session_id;
173:
174: select MENU_ID
175: into l_menu_id
176: from ICX_SESSIONS

Line 208: if(icx_sec.validateSession) then

204: err_num number;
205:
206: begin
207:
208: if(icx_sec.validateSession) then
209: displayResps(icx_sec.g_session_id);
210: end if;
211:
212: exception

Line 209: displayResps(icx_sec.g_session_id);

205:
206: begin
207:
208: if(icx_sec.validateSession) then
209: displayResps(icx_sec.g_session_id);
210: end if;
211:
212: exception
213: when others then

Line 285: l_message := icx_sec.validatePassword(

281: err_mesg varchar2(240);
282: err_num number;
283:
284: begin
285: l_message := icx_sec.validatePassword(
286: c_user_name => i_1,
287: c_user_password => i_2,
288: n_session_id => n_session_id,
289: c_validate_only => 'Y');

Line 322: l_language:=icx_sec.getNLS_PARAMETER('NLS_LANGUAGE'); -- replaces above select mputman 1574527

318: from v$nls_parameters
319: where parameter = 'NLS_LANGUAGE';
320: */
321:
322: l_language:=icx_sec.getNLS_PARAMETER('NLS_LANGUAGE'); -- replaces above select mputman 1574527
323:
324:
325: end if;
326:

Line 341: l_date_format:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527

337: into l_date_format
338: from v$nls_parameters
339: where parameter = 'NLS_DATE_FORMAT';
340: */
341: l_date_format:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527
342:
343:
344: end if;
345:

Line 411: l_message := icx_sec.validatePassword(

407: err_mesg varchar2(240);
408: err_num number;
409:
410: begin
411: l_message := icx_sec.validatePassword(
412: c_user_name => i_1,
413: c_user_password => i_2,
414: n_session_id => n_session_id,
415: c_validate_only => 'Y');

Line 447: l_language:=icx_sec.getNLS_PARAMETER('NLS_LANGUAGE'); -- replaces above select mputman 1574527

443: into l_language
444: from v$nls_parameters
445: where parameter = 'NLS_LANGUAGE';
446: */
447: l_language:=icx_sec.getNLS_PARAMETER('NLS_LANGUAGE'); -- replaces above select mputman 1574527
448:
449:
450: end if;
451:

Line 466: l_date_format:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527

462: into l_date_format
463: from v$nls_parameters
464: where parameter = 'NLS_DATE_FORMAT';
465: */
466: l_date_format:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527
467:
468:
469: end if;
470: FND_GLOBAL.set_nls_context(

Line 541: WHERE l_user_id = icx_sec.g_user_id

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
545: WHEN no_data_found THEN

Line 718: icx_sec.writeAudit;

714: b_hosted:=TRUE;
715: END IF;
716:
717:
718: icx_sec.writeAudit;
719:
720: --add redirect code to send to portal and sso if portal agent profile is not null
721: --check SSO_SDK, if null, then check apps_portal
722: fnd_profile.get(name => 'APPS_SSO',

Line 796: and nvl(icx_sec.g_language_c,'XXXXX') <> l_nls_lang

792: INTO l_nls_lang
793: FROM icx_sessions
794: WHERE session_id=l_session_id;
795: if l_nls_lang is not null
796: and nvl(icx_sec.g_language_c,'XXXXX') <> l_nls_lang
797: then
798: c_nls_language := l_nls_lang;
799: --c_nls_language := ''''||l_nls_lang||'''';
800: --dbms_session.set_nls('NLS_LANGUAGE' , c_nls_language); --replaced with call to fnd_global

Line 801: icx_sec.g_language_c:=l_nls_lang;

797: then
798: c_nls_language := l_nls_lang;
799: --c_nls_language := ''''||l_nls_lang||'''';
800: --dbms_session.set_nls('NLS_LANGUAGE' , c_nls_language); --replaced with call to fnd_global
801: icx_sec.g_language_c:=l_nls_lang;
802: FND_GLOBAL.set_nls_context(p_nls_language =>c_nls_language);
803: end if;
804:
805:

Line 844: (icx_sec.getsessioncookie <>-1)) THEN

840: htp.p('alert("'||c_error_msg||'");');
841: -- htp.p('');
842: ELSE
843: IF ((c_message IS NOT NULL) AND
844: (icx_sec.getsessioncookie <>-1)) THEN
845: htp.p('alert("'||c_message||'");');
846: END IF;
847: END IF;
848: htp.p('top.location="'||l_url||'"');

Line 876: icx_sec.RemoveCookie;

872: -- icx_on_utilities.unpack_parameters(l_text,l_parameters);
873: -- l_user_name:=l_parameters(2);
874: -- l_session_id:=l_parameters(1);
875: ELSE
876: icx_sec.RemoveCookie;
877: END IF;
878:
879: -- htp.htmlOpen;
880: -- htp.headOpen;

Line 932: c_session_id := icx_sec.getsessioncookie;

928: }');
929: END IF;
930: htp.p('');
931:
932: c_session_id := icx_sec.getsessioncookie;
933:
934: --****** if cookie exists, get session id ******--
935:
936: -- when we have corrected how icx_sec.RemoveCookie works,

Line 936: -- when we have corrected how icx_sec.RemoveCookie works,

932: c_session_id := icx_sec.getsessioncookie;
933:
934: --****** if cookie exists, get session id ******--
935:
936: -- when we have corrected how icx_sec.RemoveCookie works,
937: -- we can remove the check for -1 here
938:
939: if (c_session_id > 0)
940: then

Line 1226: l_session_id := icx_sec.createSession(p_user_id => l_user_id,

1222:
1223: end if;
1224:
1225:
1226: l_session_id := icx_sec.createSession(p_user_id => l_user_id,
1227: c_mode_code => '115P') ;
1228:
1229:
1230: owa_util.mime_header('text/html', FALSE);

Line 1232: icx_sec.sendsessioncookie(l_session_id);

1228:
1229:
1230: owa_util.mime_header('text/html', FALSE);
1231:
1232: icx_sec.sendsessioncookie(l_session_id);
1233:
1234: if (instr(l_anchor,'OA.jsp') > 0)
1235: then
1236: fnd_profile.get(name => 'APPS_DATABASE_ID',

Line 1247: icx_sec.createTransaction(

1243:
1244: l_encrypted_session_id := icx_call.encrypt3(l_session_id);
1245:
1246: l_transaction_id :=
1247: icx_sec.createTransaction(
1248: l_session_id,l_resp_appl_id,l_responsibility_id,l_security_group_id,
1249: '','','','');
1250: l_encrypted_transaction_id := icx_call.encrypt3(l_transaction_id);
1251:

Line 1252: icx_sec.updateSessionContext(p_function_name => l_function_name,

1248: l_session_id,l_resp_appl_id,l_responsibility_id,l_security_group_id,
1249: '','','','');
1250: l_encrypted_transaction_id := icx_call.encrypt3(l_transaction_id);
1251:
1252: icx_sec.updateSessionContext(p_function_name => l_function_name,
1253: p_function_id => l_function_id,
1254: p_application_id => l_resp_appl_id,
1255: p_responsibility_id => l_responsibility_id,
1256: p_security_group_id => l_security_group_id,

Line 1262: '&'||'language_code='||icx_sec.g_language_code||

1258: p_transaction_id => l_transaction_id);
1259:
1260: l_anchor := l_anchor||
1261: '&'||'dbc='||l_dbc||
1262: '&'||'language_code='||icx_sec.g_language_code||
1263: '&'||'transactionid='||l_encrypted_transaction_id;
1264: end if;
1265:
1266: owa_util.redirect_url(l_anchor);

Line 1344: l_session_id := icx_sec.createSession(p_user_id => l_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') ;
1346:
1347: owa_util.mime_header('text/html', FALSE);
1348:

Line 1349: icx_sec.sendsessioncookie(l_session_id);

1345: c_mode_code => '115P') ;
1346:
1347: owa_util.mime_header('text/html', FALSE);
1348:
1349: icx_sec.sendsessioncookie(l_session_id);
1350:
1351: if (instr(l_anchor,'OA.jsp') > 0)
1352: then
1353: fnd_profile.get(name => 'APPS_DATABASE_ID',

Line 1363: icx_call.encrypt3(icx_sec.createTransaction(

1359: end if;
1360:
1361: l_encrypted_session_id := icx_call.encrypt3(l_session_id);
1362: l_encrypted_transaction_id :=
1363: icx_call.encrypt3(icx_sec.createTransaction(
1364: l_session_id,l_resp_appl_id,l_responsibility_id,l_security_group_id,
1365: '','','',''));
1366:
1367: l_anchor := l_anchor||

Line 1369: '&'||'language_code='||icx_sec.g_language_code||

1365: '','','',''));
1366:
1367: l_anchor := l_anchor||
1368: '&'||'dbc='||l_dbc||
1369: '&'||'language_code='||icx_sec.g_language_code||
1370: '&'||'transactionid='||l_encrypted_transaction_id;
1371: end if;
1372:
1373: owa_util.redirect_url(l_anchor);

Line 1519: elsif icx_sec.validateSession

1515:
1516: -- dbms_session.set_nls('NLS_DATE_FORMAT', l_date_format);
1517:
1518: -- if session is valid
1519: elsif icx_sec.validateSession
1520: then
1521:
1522: -- ************************************
1523: -- *** If session ID is not passed in,

Line 1527: n_session_id := icx_sec.getsessioncookie;

1523: -- *** If session ID is not passed in,
1524: -- *** get the cookie for this session.
1525: -- ************************************
1526:
1527: n_session_id := icx_sec.getsessioncookie;
1528:
1529: if (n_session_id <= 0)
1530: then
1531: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');

Line 1543: icx_sec.writeAudit;

1539: end if;
1540:
1541: if (b_return)
1542: then
1543: icx_sec.writeAudit;
1544:
1545: icx_util.getPrompts(601,'ICX_MAIN_MENU',c_title,c_prompts);
1546:
1547: if (l_session_id is not NULL) -- This will happen during the login process

Line 1556: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

1552: icx_sessions a
1553: where a.session_id = n_session_id
1554: and b.nls_language = a.nls_language;
1555: else
1556: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
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

Line 1910: if icx_sec.validateSession

1906: order by a.entry_sequence;
1907:
1908: begin
1909:
1910: if icx_sec.validateSession
1911: then
1912:
1913: if Q is not null
1914: then

Line 1915: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

1911: then
1912:
1913: if Q is not null
1914: then
1915: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1916:
1917: Y:=icx_call.decrypt2(Q);
1918: icx_on_utilities.unpack_parameters(Y, params);
1919:

Line 2269: IF icx_sec.validatesession THEN

2265: l_responsibility_id := l_parameters(3);
2266: l_security_group_id := l_parameters(4);
2267: l_function_id := l_parameters(5);
2268:
2269: IF icx_sec.validatesession THEN
2270:
2271: l_session_id := icx_sec.getsessioncookie;
2272: --mputman convert to execute effort
2273: --l_encrypted_function := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||

Line 2271: l_session_id := icx_sec.getsessioncookie;

2267: l_function_id := l_parameters(5);
2268:
2269: IF icx_sec.validatesession THEN
2270:
2271: l_session_id := icx_sec.getsessioncookie;
2272: --mputman convert to execute effort
2273: --l_encrypted_function := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||
2274: -- l_security_group_id||'*'||l_function_id||'***]',l_session_id);
2275:

Line 2296: l_session_id := icx_sec.createSession(l_user_id);

2292: -- per bug 2065286 mputman
2293:
2294: --to re-enable pseudo sessions, uncomment the following block of code
2295: /*
2296: l_session_id := icx_sec.createSession(l_user_id);
2297: l_encrypted_function := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||
2298: l_security_group_id||'*'||l_function_id||'***]',l_session_id);
2299: owa_util.mime_header('text/html', FALSE);
2300: icx_sec.sendsessioncookie(l_session_id);

Line 2300: icx_sec.sendsessioncookie(l_session_id);

2296: l_session_id := icx_sec.createSession(l_user_id);
2297: l_encrypted_function := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||
2298: l_security_group_id||'*'||l_function_id||'***]',l_session_id);
2299: owa_util.mime_header('text/html', FALSE);
2300: icx_sec.sendsessioncookie(l_session_id);
2301: owa_util.http_header_close;
2302: l_URL := 'OracleApps.RF?F='||l_encrypted_function;
2303: if P is not null
2304: then

Line 2400: l_session_id := icx_sec.getID(icx_sec.pv_session_id);

2396: */
2397:
2398: begin
2399:
2400: l_session_id := icx_sec.getID(icx_sec.pv_session_id);
2401:
2402: l_text := icx_call.decrypt2(F,l_session_id);
2403:
2404: icx_on_utilities.unpack_parameters(l_text,l_parameters);

Line 2449: -- l_validate := icx_sec.validateSessionPrivate(c_session_id => l_session_id,

2445: l_menu_id := l_parameters(5);
2446:
2447:
2448: --mputman moved to after multiorg code
2449: -- l_validate := icx_sec.validateSessionPrivate(c_session_id => l_session_id,
2450: -- c_resp_appl_id => l_resp_appl_id,
2451: -- c_security_group_id => l_security_group_id,
2452: -- c_responsibility_id => l_responsibility_id,
2453: -- c_function_id => l_function_id,

Line 2483: l_validate := icx_sec.validateSessionPrivate(c_session_id => l_session_id,

2479: where SESSION_ID = l_session_id;
2480:
2481: commit;
2482:
2483: l_validate := icx_sec.validateSessionPrivate(c_session_id => l_session_id,
2484: c_resp_appl_id => l_resp_appl_id,
2485: c_security_group_id => l_security_group_id,
2486: c_responsibility_id => l_responsibility_id,
2487: c_function_id => l_function_id,

Line 2490: fnd_signon.audit_web_responsibility(icx_sec.g_login_id,

2486: c_responsibility_id => l_responsibility_id,
2487: c_function_id => l_function_id,
2488: c_update => FALSE);
2489:
2490: fnd_signon.audit_web_responsibility(icx_sec.g_login_id,
2491: l_responsibility_id,
2492: l_resp_appl_id,
2493: l_responsibility_id); -- mputman added for 1941776
2494:

Line 2498: icx_sec.g_validateSession_flag := false;

2494:
2495: IF l_validate THEN
2496:
2497: -- nlbarlow 1574527
2498: icx_sec.g_validateSession_flag := false;
2499:
2500: runFunction(l_function_id,l_session_id,l_text,
2501: l_resp_appl_id,l_responsibility_id,l_security_group_id,
2502: l_menu_id,l_function_type,icx_sec.g_page_id);

Line 2502: l_menu_id,l_function_type,icx_sec.g_page_id);

2498: icx_sec.g_validateSession_flag := false;
2499:
2500: runFunction(l_function_id,l_session_id,l_text,
2501: l_resp_appl_id,l_responsibility_id,l_security_group_id,
2502: l_menu_id,l_function_type,icx_sec.g_page_id);
2503:
2504: icx_sec.g_validateSession_flag := true;
2505: END IF;
2506: */

Line 2504: icx_sec.g_validateSession_flag := true;

2500: runFunction(l_function_id,l_session_id,l_text,
2501: l_resp_appl_id,l_responsibility_id,l_security_group_id,
2502: l_menu_id,l_function_type,icx_sec.g_page_id);
2503:
2504: icx_sec.g_validateSession_flag := true;
2505: END IF;
2506: */
2507:
2508: exception

Line 2510: icx_sec.g_validateSession_flag := true;

2506: */
2507:
2508: exception
2509: when others then
2510: icx_sec.g_validateSession_flag := true;
2511: --htp.p(SQLERRM);
2512: htp.p(dbms_utility.format_error_stack);
2513: end;
2514:

Line 2619: l_parameters := replace(l_parameters,'[MENU_ID]',icx_sec.g_menu_id);

2615: end if;
2616:
2617: -- 1790825, support [MENU_ID]
2618:
2619: l_parameters := replace(l_parameters,'[MENU_ID]',icx_sec.g_menu_id);
2620:
2621: c_anchor := '';
2622:
2623: if f.type not in ('SERVLET','JSP', 'INTEROPJSP')

Line 2766: icx_call.encrypt3(icx_sec.createTransaction(

2762: c_anchor := '';
2763: end if;
2764:
2765: l_encrypted_transaction_id :=
2766: icx_call.encrypt3(icx_sec.createTransaction(
2767: n_session_id,p_resp_appl_id,p_responsibility_id,p_security_group_id,
2768: p_menu_id,c_function_id,p_function_type,p_page_id));
2769:
2770: c_anchor := FND_WEB_CONFIG.trail_slash(c_anchor)||

Line 2771: FND_WEB_CONFIG.trail_slash(icx_sec.g_OA_HTML)||

2767: n_session_id,p_resp_appl_id,p_responsibility_id,p_security_group_id,
2768: p_menu_id,c_function_id,p_function_type,p_page_id));
2769:
2770: c_anchor := FND_WEB_CONFIG.trail_slash(c_anchor)||
2771: FND_WEB_CONFIG.trail_slash(icx_sec.g_OA_HTML)||
2772: l_web_html_call;
2773:
2774: fnd_profile.get(name => 'APPS_DATABASE_ID',
2775: val => l_dbc);

Line 2789: c_anchor := c_anchor||'&'||'language_code='||icx_sec.g_language_code||

2785: else
2786: c_anchor := c_anchor||'?dbc='||l_dbc;
2787: end if;
2788:
2789: c_anchor := c_anchor||'&'||'language_code='||icx_sec.g_language_code||
2790: '&'||'transactionid='||l_encrypted_transaction_id;
2791:
2792: if (instr(c_anchor,'OA.jsp') = 0)
2793: then -- Other jsps still require sessionid

Line 3009: n_session_id := icx_sec.getsessioncookie;

3005: /*** Get the cookie for this session.
3006: and find out other information from the db
3007: ***/
3008:
3009: n_session_id := icx_sec.getsessioncookie;
3010:
3011: if (n_session_id <= 0)
3012: then
3013: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');

Line 3097: IF (icx_sec.g_mode_code <> 'SLAVE') THEN

3093:
3094: l_toolbar.menu_url :=owa_util.get_cgi_env('SCRIPT_NAME')||'/OracleNavigate.Responsibility'; --mputman added for bug 1402459
3095: l_toolbar.menu_mouseover := l_prompts(7); -- from region ICX_OBIS_TOOLBAR mputman added for bug 1402459
3096:
3097: IF (icx_sec.g_mode_code <> 'SLAVE') THEN
3098: --mputman isolated menubutton to exclude slave mode 1747045
3099: l_toolbar.custom_option1_url := icx_plug_utilities.getPLSQLagent ||
3100: 'OracleMyPage.Home';
3101: l_toolbar.custom_option1_mouseover := wf_core.translate('RETURN_TO_HOME');

Line 3220: if (icx_sec.validateSession) then

3216:
3217:
3218: begin
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;

Line 3224: where user_id = icx_sec.g_user_id;

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;
3228: l_date_format := replace(upper(l_date_format), 'YYYY', 'RRRR');

Line 3226: c_language_code := icx_sec.g_language_code;

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;
3228: l_date_format := replace(upper(l_date_format), 'YYYY', 'RRRR');
3229: l_date_format := replace(l_date_format, 'YY', 'RRRR');
3230: l_territory := icx_sec.g_nls_territory;

Line 3227: l_date_format := icx_sec.g_date_format;

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;
3228: l_date_format := replace(upper(l_date_format), 'YYYY', 'RRRR');
3229: l_date_format := replace(l_date_format, 'YY', 'RRRR');
3230: l_territory := icx_sec.g_nls_territory;
3231: l_numeric_characters := icx_sec.g_numeric_characters;

Line 3230: l_territory := icx_sec.g_nls_territory;

3226: c_language_code := icx_sec.g_language_code;
3227: l_date_format := icx_sec.g_date_format;
3228: l_date_format := replace(upper(l_date_format), 'YYYY', 'RRRR');
3229: l_date_format := replace(l_date_format, 'YY', 'RRRR');
3230: l_territory := icx_sec.g_nls_territory;
3231: l_numeric_characters := icx_sec.g_numeric_characters;
3232:
3233: --get profile value for CLIENT_TIMEZONE_ID
3234: --decode into displayed_name

Line 3231: l_numeric_characters := icx_sec.g_numeric_characters;

3227: l_date_format := icx_sec.g_date_format;
3228: l_date_format := replace(upper(l_date_format), 'YYYY', 'RRRR');
3229: l_date_format := replace(l_date_format, 'YY', 'RRRR');
3230: l_territory := icx_sec.g_nls_territory;
3231: l_numeric_characters := icx_sec.g_numeric_characters;
3232:
3233: --get profile value for CLIENT_TIMEZONE_ID
3234: --decode into displayed_name
3235: fnd_profile.get_specific(

Line 3237: user_id_z => icx_sec.g_user_id,

3233: --get profile value for CLIENT_TIMEZONE_ID
3234: --decode into displayed_name
3235: fnd_profile.get_specific(
3236: name_z => 'CLIENT_TIMEZONE_ID',
3237: user_id_z => icx_sec.g_user_id,
3238: val_z => l_timezone,
3239: defined_z => l_profile_defined);
3240:
3241: fnd_profile.get_specific(

Line 3243: user_id_z => icx_sec.g_user_id,

3239: defined_z => l_profile_defined);
3240:
3241: fnd_profile.get_specific(
3242: name_z => 'FND_NATIVE_CLIENT_ENCODING',
3243: user_id_z => icx_sec.g_user_id,
3244: val_z => l_encoding,
3245: defined_z => l_profile_defined);
3246:
3247:

Line 3250: user_id_z => icx_sec.g_user_id,

3246:
3247:
3248: fnd_profile.get_specific(
3249: name_z => 'ENABLE_TIMEZONE_CONVERSIONS',
3250: user_id_z => icx_sec.g_user_id,
3251: val_z => l_tz_enabled,
3252: defined_z => l_profile_defined);
3253:
3254: BEGIN

Line 3258: WHERE user_id = icx_sec.g_user_id

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
3262: WHEN no_data_found THEN

Line 3310: IF icx_sec.g_mode_code = 'SLAVE' THEN

3306: htp.p('