APPS.ORACLEMYPAGE dependencies on FND_PROFILE

Line 446: l_url := fnd_profile.value('APPS_SERVLET_AGENT')||'oracle.apps.icx.myPage.renderPage';

442: l_agent := icx_plug_utilities.getPLSQLagent;
443: -- OAS approach
444: -- l_url:= '/OA_JAVA_SERV/oracle.apps.icx.myPage.renderPage';
445: -- Below is for Servlet approach
446: l_url := fnd_profile.value('APPS_SERVLET_AGENT')||'oracle.apps.icx.myPage.renderPage';
447: l_server_name := owa_util.get_cgi_env('SERVER_NAME');
448: l_server_port := owa_util.get_cgi_env('SERVER_PORT');
449:
450: l_url:= l_url||'?db_host='||l_dbhost||'&'||'main_region_id='||to_char(main_region_id)||

Line 517: fnd_profile.get_specific

513: l_user_id := NULL;
514: END;
515:
516: IF l_user_id IS NOT NULL THEN
517: fnd_profile.get_specific
518: (name_z => 'APPS_SSO',
519: user_id_z => l_user_id,
520: val_z => l_apps_sso,
521: defined_z => l_profile_defined);

Line 523: l_apps_sso := fnd_profile.value('APPS_SSO');

519: user_id_z => l_user_id,
520: val_z => l_apps_sso,
521: defined_z => l_profile_defined);
522: ELSE
523: l_apps_sso := fnd_profile.value('APPS_SSO');
524: END IF;
525:
526: if l_apps_sso <> 'SSWA'
527: then

Line 546: fnd_profile.get(name => 'ENABLE_SECURITY_GROUPS',

542: end if;
543: */
544: l_mode_code := '115P';
545:
546: fnd_profile.get(name => 'ENABLE_SECURITY_GROUPS',
547: val => l_hosted_profile);
548:
549: IF (upper(l_hosted_profile)='HOSTED') THEN
550: b_hosted:=TRUE;

Line 597: if fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'

593: -- 1588724 nlbarlow added flags
594: icx_sec.g_validateSession_flag := false;
595:
596: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE
597: if fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
598: then
599: select FUNCTION_ID
600: into l_function_id
601: from FND_FORM_FUNCTIONS

Line 817: fnd_profile.get(name => 'APPS_PORTAL',

813: if (icx_sec.validatesession) THEN --1503616 mputman
814: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE
815: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow
816:
817: fnd_profile.get(name => 'APPS_PORTAL',
818: val => l_url);
819:
820: if l_url IS NULL Then
821: htp.p ('Please contact System Administrator. ');

Line 829: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'

825: owa_util.mime_header('text/html', FALSE);
826: owa_util.redirect_url(l_url);
827: owa_util.http_header_close;
828:
829: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
830: then
831: select FUNCTION_ID
832: into l_function_id
833: from FND_FORM_FUNCTIONS

Line 892: l_homepage_type := fnd_profile.value('APPLICATIONS_HOME_PAGE');

888: and a.start_date <= sysdate
889: and (a.end_date is null or a.end_date > sysdate)
890: and b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID;
891:
892: l_homepage_type := fnd_profile.value('APPLICATIONS_HOME_PAGE');
893:
894: IF (l_page_count=1) AND (l_resps_count=1) AND (l_region_count=1) AND (l_homepage_type = 'PHP')
895:
896: