[Home] [Help]
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
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
114: then
115:
116: l_home_url := home_url;
117:
118: update ICX_SESSIONS
119: set HOME_URL = l_home_url
120: where SESSION_ID = n_session_id;
121:
122: if i_3 is null
121:
122: if i_3 is null
123: then
124:
125: update ICX_SESSIONS
126: set HOME_URL = l_home_url
127: where SESSION_ID = n_session_id;
128:
129: displayResps(n_session_id);
129: displayResps(n_session_id);
130:
131: else
132:
133: update ICX_SESSIONS
134: set HOME_URL = l_home_url,
135: MODE_CODE = 'SLAVE'
136: where SESSION_ID = n_session_id;
137:
172: l_session_id := icx_sec.g_session_id;
173:
174: select MENU_ID
175: into l_menu_id
176: from ICX_SESSIONS
177: where SESSION_ID = l_session_id;
178:
179: if l_menu_id is null
180: then
300: -- The following should be set be Profiles
301:
302: select user_id
303: into l_user_id
304: from icx_sessions
305: where session_id = n_session_id;
306:
307: fnd_profile.get_specific(
308: name_z => 'ICX_LANGUAGE',
426: -- The following should be set be Profiles
427:
428: select user_id
429: into l_user_id
430: from icx_sessions
431: where session_id = n_session_id;
432:
433: fnd_profile.get_specific(
434: name_z => 'ICX_LANGUAGE',
486: into l_function_id
487: from fnd_form_functions fff
488: where fff.function_name = i_3;
489:
490: update icx_sessions
491: set responsibility_id = NULL,
492: function_id = l_function_id
493: where session_id = n_session_id;
494:
760: l_home_url:= wfa_html.conv_special_url_chars(l_home_url);
761: l_url2 := wfa_html.conv_special_url_chars(l_url);
762: l_maint_home_url := replace(l_url,'home','wwsec_app_priv.logout?p_done_url='||(nvl(l_home_url,l_url2)));
763:
764: ELSE --not using portal and just need to get to icx_sessions.home_url
765: l_maint_home_url := l_home_url;
766: END IF;
767:
768: owa_util.mime_header('text/html', TRUE);
780:
781:
782: ELSE -- not in maintenance mode
783:
784: --begin 2214212 mputman -- try to get lang from icx_sessions when session_id is avail via recreate and set nls context.
785: IF recreate IS NOT NULL THEN
786: l_text := icx_call.decrypt(recreate);
787: icx_on_utilities.unpack_parameters(l_text,l_parameters);
788: l_user_name:=l_parameters(2);
789: l_session_id:=l_parameters(1);
790: BEGIN
791: SELECT nls_language
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
942: begin
943: select b.language_code
944: into c_language_code
945: from fnd_languages b,
946: icx_sessions a
947: where a.session_id = c_session_id
948: and b.nls_language = a.nls_language;
949:
950: exception
1497: n_session_id := nri;
1498:
1499: select nls_language,date_format_mask
1500: into l_language,l_date_format
1501: from icx_sessions
1502: where session_id = n_session_id;
1503:
1504: l_session_id := n_session_id;
1505: FND_GLOBAL.set_nls_context(
1548: then
1549: select b.language_code
1550: into c_language_code
1551: from fnd_languages b,
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);
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:
1566: if c_toolbar = 'Y'
2467: val_z => l_org_id,
2468: defined_z => l_profile_defined);
2469: end if;
2470:
2471: update ICX_SESSIONS
2472: set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
2473: RESPONSIBILITY_ID = l_responsibility_id,
2474: SECURITY_GROUP_ID = l_security_group_id,
2475: ORG_ID = l_org_id,
2624: then
2625:
2626: select responsibility_id, RESPONSIBILITY_APPLICATION_ID
2627: into l_responsibility_id, l_resp_appl_id
2628: from icx_sessions
2629: where session_id = n_session_id;
2630:
2631:
2632: if ((l_responsibility_id is not NULL) AND (l_resp_appl_id is not null))
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'
2987: and a.start_date <= sysdate
3993: select nls_language
3994: into p_lang_change
3995: from fnd_languages
3996: where language_code = (SELECT language_code
3997: FROM icx_sessions
3998: WHERE session_id = n_session_id);
3999:
4000: select language_code
4001: into c_language_code
4003: where nls_language = c_LANGUAGE;
4004: -- bug 2656698
4005: -- get prof option vals for date_lang and sort.
4006: -- call fnd_global.set_nls to get return vals for date_lang and sort.
4007: -- when the prof vals are null, use the returns from fnd_global in the update to icx_sessions.
4008:
4009: fnd_profile.get(name => 'ICX_NLS_SORT',
4010: val => prof_sort);
4011: fnd_profile.get(name => 'ICX_DATE_LANGUAGE',
4037: ELSE
4038: z_date_lang :=prof_date_lang; --profile is null.. use value returned from fnd_global
4039: END IF;
4040: --added date_lang and sort to the update for 2656698
4041: update icx_sessions
4042: set nls_language = c_LANGUAGE,
4043: language_code = c_language_code,
4044: date_format_mask = l_date_format,
4045: nls_territory = c_TERRITORY,
4788: l_limit_connects,
4789: l_org_id,
4790: l_timeout);
4791:
4792: SELECT user_id INTO l_org_id FROM icx_sessions WHERE session_id=l_session_id;
4793: l_org_id:='';
4794:
4795:
4796: -- Session Hijacking. Re-set XSID whenever icx session is re-established.
4794:
4795:
4796: -- Session Hijacking. Re-set XSID whenever icx session is re-established.
4797: l_new_xsid := fnd_session_management.NewXSID;
4798: UPDATE icx_sessions
4799: SET user_id = l_user_id,
4800: first_connect = SYSDATE,
4801: last_connect = SYSDATE,
4802: counter =1,