[Home] [Help]
126: end if;
127:
128:
129:
130: fnd_global.apps_initialize(icx_sec.g_user_id,
131: p_object.responsibility_id,
132: p_object.resp_appl_id,
133: p_object.security_group_id);
134:
465: htp.formHidden('X','FALSE');
466: htp.formClose;
467:
468: icx_plug_utilities.toolbar(p_text => l_title,
469: p_language_code => icx_sec.g_language_code,
470: p_disp_help => 'Y',
471: p_disp_exit => 'Y',
472: p_disp_menu => 'N');
473:
535: from FND_SECURITY_GROUPS_VL fsg,
536: FND_RESPONSIBILITY_VL a,
537: FND_USER_RESP_GROUPS b,
538: fnd_menus m
539: where b.user_id = icx_sec.g_user_id
540: AND a.menu_id = m.menu_id
541: and b.start_date <= sysdate
542: and (b.end_date is null or b.end_date > sysdate)
543: and b.RESPONSIBILITY_id = a.responsibility_id
552: ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;
553:
554: begin
555:
556: if icx_sec.validateSession
557: then
558:
559: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE
560: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow
556: if icx_sec.validateSession
557: then
558:
559: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE
560: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow
561:
562: fnd_profile.get(name => 'APPS_PORTAL',
563: val => l_url);
564:
578: from FND_FORM_FUNCTIONS
579: where FUNCTION_NAME = 'OAHOMEPAGE';
580:
581: l_url := icx_portlet.createExecLink
582: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
583: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
584: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
585: p_function_id => l_function_id,
586: p_url_only => 'Y');
579: where FUNCTION_NAME = 'OAHOMEPAGE';
580:
581: l_url := icx_portlet.createExecLink
582: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
583: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
584: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
585: p_function_id => l_function_id,
586: p_url_only => 'Y');
587:
580:
581: l_url := icx_portlet.createExecLink
582: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
583: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
584: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
585: p_function_id => l_function_id,
586: p_url_only => 'Y');
587:
588: owa_util.mime_header('text/html', FALSE);
596: from FND_FORM_FUNCTIONS
597: where FUNCTION_NAME = 'FND_NAVIGATE_PAGE';
598:
599: l_url := icx_portlet.createExecLink
600: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
601: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
602: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
603: p_function_id => l_function_id,
604: p_url_only => 'Y');
597: where FUNCTION_NAME = 'FND_NAVIGATE_PAGE';
598:
599: l_url := icx_portlet.createExecLink
600: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
601: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
602: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
603: p_function_id => l_function_id,
604: p_url_only => 'Y');
605:
598:
599: l_url := icx_portlet.createExecLink
600: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
601: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
602: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
603: p_function_id => l_function_id,
604: p_url_only => 'Y');
605:
606: owa_util.mime_header('text/html', FALSE);
606: owa_util.mime_header('text/html', FALSE);
607: owa_util.redirect_url(l_url);
608: owa_util.http_header_close;
609:
610: elsif (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE') and
611: tab_context_flag = 'ON') then
612:
613: OracleMyPage.DrawTabContent;
614:
637:
638: if P is null
639: then
640:
641: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
642: if NVL(l_responsibility_id, -1) = -1
643: then
644: open responsibilities;
645: fetch responsibilities into l_resp_appl_id,
667: end if;
668:
669: if (D is null) then
670: -- check to see if need to get page for new style or old style page.
671: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
672:
673: l_session_id := icx_sec.getsessioncookie;
674:
675: select page_id into l_page_id
669: if (D is null) then
670: -- check to see if need to get page for new style or old style page.
671: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
672:
673: l_session_id := icx_sec.getsessioncookie;
674:
675: select page_id into l_page_id
676: from icx_sessions
677: where session_id = l_session_id;
681: select display_name
682: into l_name
683: from icx_page_plugs a,
684: icx_pages b
685: where b.user_id = icx_sec.g_user_id
686: and b.page_id = a.page_id
687: and a.page_id = l_page_id
688: and a.responsibility_id = -1
689: and a.menu_id = -1;
724: select DISPLAY_NAME
725: into l_name
726: from ICX_PAGE_PLUGS a,
727: ICX_PAGES b
728: where b.USER_ID = icx_sec.g_user_id
729: and b.PAGE_ID = a.PAGE_ID
730: and a.RESPONSIBILITY_ID = -1
731: and a.MENU_ID = -1
732: and b.page_id in (select MIN(page_id)
730: and a.RESPONSIBILITY_ID = -1
731: and a.MENU_ID = -1
732: and b.page_id in (select MIN(page_id)
733: from ICX_PAGES
734: where user_id = icx_sec.g_user_id
735: and PAGE_TYPE = 'USER');
736: exception
737: when no_data_found then
738: l_name := null;
757: and fff.function_id = fme.function_id
758: and fff.function_name = 'ICX_NAVIGATE_PLUG'
759: and ipp.page_id in (select MIN(page_id)
760: from ICX_PAGES
761: where user_id = icx_sec.g_user_id
762: and PAGE_TYPE = 'USER');
763: exception
764: when no_data_found then
765: l_name := null;
788: END IF;
789:
790: if S is null
791: then
792: l_security_group_id := icx_sec.g_security_group_id;
793: else
794: l_security_group_id := S;
795: end if;
796:
811: l_security_group_name
812: from FND_SECURITY_GROUPS_VL fsg,
813: FND_RESPONSIBILITY_VL a,
814: FND_USER_RESP_GROUPS b
815: where b.USER_ID = icx_sec.g_user_id
816: and a.APPLICATION_ID = b.RESPONSIBILITY_APPLICATION_ID
817: and a.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
818: and a.RESPONSIBILITY_ID = l_responsibility_id
819: and b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID
910: htp.p('');
911:
912: htp.p('');
913:
914: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
915: htp.p('
924: cattributes => 'NAME="functionwindowfocus"');
925: htp.formHidden('X','FALSE');
926: htp.formClose;
927:
928: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
929: icx_sec.g_mode_code = 'SLAVE')
930: then
931: l_target := '_self';
932: else
925: htp.formHidden('X','FALSE');
926: htp.formClose;
927:
928: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
929: icx_sec.g_mode_code = 'SLAVE')
930: then
931: l_target := '_self';
932: else
933: l_target := '_top';
932: else
933: l_target := '_top';
934:
935: icx_plug_utilities.toolbar(p_text => l_title,
936: p_language_code => icx_sec.g_language_code,
937: p_disp_help => 'Y',
938: p_disp_exit => 'Y',
939: p_disp_menu => 'N');
940: end if;
1103: htp.p(l_url);
1104: end if;
1105: end if;
1106: /*
1107: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
1108: icx_sec.g_mode_code = 'SLAVE')
1109: then
1110: IF ((g_list(i).FUNCTION_TYPE = 'WWK') OR (g_list(i).FUNCTION_TYPE = 'FORM')) THEN
1111: l_url := 'javascript:top.main.icx_nav_window('''||g_list(i).FUNCTION_TYPE||''','''||l_url||''', '''||icx_util.replace_quotes(g_list(i).PROMPT)||''')';
1104: end if;
1105: end if;
1106: /*
1107: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
1108: icx_sec.g_mode_code = 'SLAVE')
1109: then
1110: IF ((g_list(i).FUNCTION_TYPE = 'WWK') OR (g_list(i).FUNCTION_TYPE = 'FORM')) THEN
1111: l_url := 'javascript:top.main.icx_nav_window('''||g_list(i).FUNCTION_TYPE||''','''||l_url||''', '''||icx_util.replace_quotes(g_list(i).PROMPT)||''')';
1112: END IF;
1168:
1169: htp.p('');
1170:
1171: --htp.p('');--mputman debug
1172: end if; --icx_sec.validatesession
1173:
1174: end if; -- icx_sec.g_mode_code in ('115J', '115P');
1175:
1176: --added end if;
1170:
1171: --htp.p('');--mputman debug
1172: end if; --icx_sec.validatesession
1173:
1174: end if; -- icx_sec.g_mode_code in ('115J', '115P');
1175:
1176: --added end if;
1177: end if;
1178:
1222: fnd_responsibility_vl a,
1223: FND_USER_RESP_GROUPS b,
1224: FND_APPLICATION fa,
1225: FND_MENUS m
1226: where b.user_id = icx_sec.g_user_id
1227: AND m.menu_id = a.menu_id
1228: and version in ('4','W')
1229: and b.start_date <= sysdate
1230: and (b.end_date is null or b.end_date > sysdate)
1243:
1244: if p_delete = 'Y'
1245: then
1246: l_agent := l_agent;
1247: elsif icx_sec.validatePlugSession(p_plug_id,p_session_id)
1248: then
1249: /*
1250: ** The agent must have the web server in front of it to ensure
1251: ** it works in ie javascript. The problem is if your running the
1283:
1284: htp.p('
| '); 1285: htp.p('
|