11: begin
12: select BACKGROUND_COLOR
13: into l_color
14: from ICX_PAGE_COLOR_SCHEME 15: where USER_ID = icx_sec.g_user_id; 16: exception
17: when others then
18: l_color := '##CCCCCC';
19: end;
Line 39: where USER_ID = icx_sec.g_user_id;
35: begin
36: select BACKGROUND_COLOR
37: into l_color
38: from ICX_PAGE_COLOR_SCHEME 39: where USER_ID = icx_sec.g_user_id; 40: exception
41: when others then
42: l_color := '##FFFFFF';
43: end;
Line 62: where USER_ID = icx_sec.g_user_id;
58: begin
59: select HEADING_COLOR
60: into l_color
61: from ICX_PAGE_COLOR_SCHEME 62: where USER_ID = icx_sec.g_user_id; 63: exception
64: when others then
65: l_color := '#99CCFF';
66: end;
Line 82: where USER_ID = icx_sec.g_user_id;
78: begin
79: select HEADING_COLOR
80: into l_color
81: from ICX_PAGE_COLOR_SCHEME 82: where USER_ID = icx_sec.g_user_id; 83: exception
84: when others then
85: l_color := '#99CCFF';
86: end;
Line 104: where USER_ID = icx_sec.g_user_id;
100: begin
101: select BANNER_COLOR
102: into l_color
103: from ICX_PAGE_COLOR_SCHEME 104: where USER_ID = icx_sec.g_user_id; 105: exception
106: when others then
107: l_color := '#99CCFF';
108: end;
Line 124: where USER_ID = icx_sec.g_user_id;
120: begin
121: select COLOR_SCHEME
122: into l_color
123: from ICX_PAGE_COLOR_SCHEME 124: where USER_ID = icx_sec.g_user_id; 125: exception
126: when others then
127: l_color := 'BL';
128: end;
Line 145: where USER_ID = icx_sec.g_user_id;
141: begin
142: select BANNER_COLOR
143: into l_color
144: from ICX_PAGE_COLOR_SCHEME 145: where USER_ID = icx_sec.g_user_id; 146: exception
147: when others then
148: l_color := '#99CCFF';
149: end;
Line 167: where USER_ID = icx_sec.g_user_id;
163: begin
164: select TOOLBAR_COLOR
165: into l_color
166: from ICX_PAGE_COLOR_SCHEME 167: where USER_ID = icx_sec.g_user_id; 168: exception
169: when others then
170: l_color := '#0000CC';
171: end;
Line 189: where USER_ID = icx_sec.g_user_id;
185: begin
186: select COLOR_SCHEME
187: into l_color
188: from ICX_PAGE_COLOR_SCHEME 189: where USER_ID = icx_sec.g_user_id; 190: exception
191: when others then
192: l_color := 'BL';
193: end;
Line 224: if (substr(icx_sec.g_mode_code,1,3) = '115' or
220: index3 := LENGTHB(dad_url)+1;
221:
222: l_agent := substrb(dad_url,index2,index3-index2);
223: 224: if (substr(icx_sec.g_mode_code,1,3) = '115' or 225: icx_sec.g_mode_code = 'SLAVE')
226: then
227: l_agent := ltrim(l_agent,'/');
228: end if;
Line 225: icx_sec.g_mode_code = 'SLAVE')
221:
222: l_agent := substrb(dad_url,index2,index3-index2);
223:
224: if (substr(icx_sec.g_mode_code,1,3) = '115' or 225: icx_sec.g_mode_code = 'SLAVE') 226: then
227: l_agent := ltrim(l_agent,'/');
228: end if;
229:
Line 305: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
301: l_menu varchar2(240);
302:
303: begin
304: 305: if ( substr(icx_sec.g_mode_code,1,3) = '115' or 306: icx_sec.g_mode_code = 'SLAVE')
307: then
308: l_menu := owa_util.get_cgi_env('SCRIPT_NAME')||'/oraclemypage.home';
309: else
Line 306: icx_sec.g_mode_code = 'SLAVE')
302:
303: begin
304:
305: if ( substr(icx_sec.g_mode_code,1,3) = '115' or 306: icx_sec.g_mode_code = 'SLAVE') 307: then
308: l_menu := owa_util.get_cgi_env('SCRIPT_NAME')||'/oraclemypage.home';
309: else
310: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
Line 348: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
344:
345: begin
346:
347: l_Customize := icx_util.getPrompt(601,'ICX_OBIS_NAVIGATE',178,'ICX_CUSTOMIZE'); 348: if ( substr(icx_sec.g_mode_code,1,3) = '115' or 349: icx_sec.g_mode_code = 'SLAVE')
350: then
351: l_color := '#6699CC'; --'#000066';
352: l_text_color := '#ffffff';
Line 349: icx_sec.g_mode_code = 'SLAVE')
345: begin
346:
347: l_Customize := icx_util.getPrompt(601,'ICX_OBIS_NAVIGATE',178,'ICX_CUSTOMIZE');
348: if ( substr(icx_sec.g_mode_code,1,3) = '115' or 349: icx_sec.g_mode_code = 'SLAVE') 350: then
351: l_color := '#6699CC'; --'#000066';
352: l_text_color := '#ffffff';
353: l_text_face := 'Arial';
Line 397: if substr(icx_sec.g_mode_code,1,3) <> '115'
393: htf.anchor(curl => p_edit_URL,
394: ctext => l_Customize,
395: cattributes => 'TARGET="_top" onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_Customize)||''';return true"')||'');
396: end if; 397: if substr(icx_sec.g_mode_code,1,3) <> '115' 398: then
399: htp.p('
');
400: end if;
401: htp.p('');
Line 418: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
414:
415: begin
416:
417: l_Customize := icx_util.getPrompt(601,'ICX_OBIS_NAVIGATE',178,'ICX_CUSTOMIZE'); 418: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR 419: icx_sec.g_mode_code = 'SLAVE')
420: then
421: l_color := '#6699CC'; --'#000066';
422: else
Line 419: icx_sec.g_mode_code = 'SLAVE')
415: begin
416:
417: l_Customize := icx_util.getPrompt(601,'ICX_OBIS_NAVIGATE',178,'ICX_CUSTOMIZE');
418: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR 419: icx_sec.g_mode_code = 'SLAVE') 420: then
421: l_color := '#6699CC'; --'#000066';
422: else
423: l_color := icx_plug_utilities.bannercolor;
Line 483: if icx_sec.g_function_type = 'WWK'
479: end if;
480:
481: if p_function
482: then 483: if icx_sec.g_function_type = 'WWK' 484: then
485: htp.p('function windowunload() {
486: parent.opener.parent.main.document.functionwindowfocus.X.value = "FALSE";
487: };');
Line 524: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
520: begin
521:
522: if p_language_code is null
523: then 524: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 525: else
526: l_language_code := p_language_code;
527: end if;
528:
Line 551: if icx_sec.g_function_type = 'WWK' then
547:
548:
');
549:
550: if (p_disp_menu = 'Y') then 551: if icx_sec.g_function_type = 'WWK' then 552: l_href := 'javascript:window.close();';
553: else
554:
555: --l_href := 'javascript:top.location.href = ''OracleMyPage.DrawTabContent'||''';';
Line 557: l_href := 'javascript:top.location.href = ''OracleNavigate.Responsibility?P='||icx_sec.g_responsibility_id||''';';
566: if (p_disp_mainmenu = 'Y') then
567: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
568: l_agent := icx_plug_utilities.getPLSQLagent;
569: 570: if icx_sec.g_function_type = 'WWK' then 571: l_href := 'javascript:parent.opener.location.href = '''||owa_util.get_cgi_env('SCRIPT_NAME')||'/oraclemypage.home'';window.close();';
572: else
573: l_href := 'javascript:top.location.href = '''||owa_util.get_cgi_env('SCRIPT_NAME')||'/oraclemypage.home'';';
574: end if;
Line 676: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
672: l_menu_id number;
673:
674: begin
675: 676: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR 677: icx_sec.g_mode_code = 'SLAVE')
678: then
679:
680: begin
Line 677: icx_sec.g_mode_code = 'SLAVE')
673:
674: begin
675:
676: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR 677: icx_sec.g_mode_code = 'SLAVE') 678: then
679:
680: begin
681: select menu_id
Line 684: where session_id = icx_sec.g_session_id;
680: begin
681: select menu_id
682: into l_menu_id
683: from icx_sessions 684: where session_id = icx_sec.g_session_id; 685: exception
686: when no_data_found then
687: l_menu_id := null;
688: end;
Line 725: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
721: l_text := p_text;
722: end if;
723:
724: if p_language_code is null then 725: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 726: else
727: v_language_code := p_language_code;
728: end if;
729:
Line 730: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
726: else
727: v_language_code := p_language_code;
728: end if;
729: 730: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID); 731: l_session_mode := icx_sec.getID(icx_sec.PV_SESSION_MODE);
732: if l_session_mode is null
733: then
734: l_session_mode := 'OBIS';
Line 731: l_session_mode := icx_sec.getID(icx_sec.PV_SESSION_MODE);
727: v_language_code := p_language_code;
728: end if;
729:
730: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID); 731: l_session_mode := icx_sec.getID(icx_sec.PV_SESSION_MODE); 732: if l_session_mode is null
733: then
734: l_session_mode := 'OBIS';
735: end if;
Line 814: if icx_sec.g_function_type = 'WWK' then
810:
811: htp.p('
');
812:
813: if (p_disp_menu = 'Y' and l_session_mode <> 'SLAVE') then 814: if icx_sec.g_function_type = 'WWK' then 815: l_menu := 'javascript:window.close();';
816: else
817: l_menu := 'javascript:top.location.href = ''OracleNavigate.Responsibility?P='||icx_sec.g_responsibility_id||''';';
818: end if;
Line 817: l_menu := 'javascript:top.location.href = ''OracleNavigate.Responsibility?P='||icx_sec.g_responsibility_id||''';';
813: if (p_disp_menu = 'Y' and l_session_mode <> 'SLAVE') then
814: if icx_sec.g_function_type = 'WWK' then
815: l_menu := 'javascript:window.close();';
816: else 817: l_menu := 'javascript:top.location.href = ''OracleNavigate.Responsibility?P='||icx_sec.g_responsibility_id||''';'; 818: end if;
819: htp.tableData(htf.anchor(l_menu,
820: htf.img('/OA_MEDIA/FNDMENU.gif',
821: 'CENTER',
Line 830: if icx_sec.g_function_type = 'WWK' then
826: ||''';return true" TARGET="_top"'));
827: end if;
828:
829: if (p_disp_mainmenu = 'Y' and l_session_mode <> 'SLAVE') then 830: if icx_sec.g_function_type = 'WWK' then 831: l_menu := 'javascript:parent.opener.location.href = ''/OA_JAVA_SERV/oracle.apps.icx.myPage.MainMenu?dbHost='||l_host_instance||'&'||'agent='||l_agent||''';window.close();';
832: else
833: l_menu := 'javascript:top.location.href = ''/OA_JAVA_SERV/oracle.apps.icx.myPage.MainMenu?dbHost='||l_host_instance||'&'||'agent='||l_agent||''';';
834: end if;