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.MSD_DEM_COMMON_UTILITIES dependencies on FND_PROFILE

Line 588: x_curr_val := fnd_profile.value('MSD_DEM_SCHEMA');

584: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_CTO_BOM TO ' || x_dem_schema;
585: execute immediate x_grant_sql;
586:
587: /* Set the profile MSD_DEM_SCHEMA if not set */
588: x_curr_val := fnd_profile.value('MSD_DEM_SCHEMA');
589:
590: IF (nvl(x_curr_val, '$$$') <> x_dem_schema)
591: THEN
592: x_success := fnd_profile.save ('MSD_DEM_SCHEMA', x_dem_schema, 'SITE');

Line 592: x_success := fnd_profile.save ('MSD_DEM_SCHEMA', x_dem_schema, 'SITE');

588: x_curr_val := fnd_profile.value('MSD_DEM_SCHEMA');
589:
590: IF (nvl(x_curr_val, '$$$') <> x_dem_schema)
591: THEN
592: x_success := fnd_profile.save ('MSD_DEM_SCHEMA', x_dem_schema, 'SITE');
593: log_message ('Profile MSD_DEM: Schema has been set to ''' || x_dem_schema || ''' at the SITE level');
594:
595: /*Setting global parameter */
596: C_MSD_DEM_SCHEMA := x_dem_schema ;

Line 640: x_success := fnd_profile.save ('MSD_DEM_VERSION', x_dem_version, 'SITE');

636: EXECUTE IMMEDIATE x_get_dem_ver_sql into x_dem_version ;
637:
638: x_dem_version := SUBSTR(x_dem_version, 1, INSTR(x_dem_version, '.', 1, 2)-1) ;
639:
640: x_success := fnd_profile.save ('MSD_DEM_VERSION', x_dem_version, 'SITE');
641: log_message ('Profile MSD_DEM: Version has been set to ''' || x_dem_version || ''' at the SITE level');
642:
643: /* Set the ExternalLogoutUrl parameter in demantra schema to the applications home page */ -- nallkuma 16-feb-2009
644: /* 1st IF condtion :- This is only for demantra 7.3.X & above versions */ -- bug#7458724

Line 649: x_appl_home_page_mode := fnd_profile.value('APPLICATIONS_HOME_PAGE') ;

645: /* 2nd IF condtion :- Sets the ExternalLogoutUrl parameter to appl home page only if the appl home page mode is set "FWD" or else it will be null */
646:
647: IF (TO_NUMBER(x_dem_version) >= 7.3)
648: THEN
649: x_appl_home_page_mode := fnd_profile.value('APPLICATIONS_HOME_PAGE') ;
650: IF (x_appl_home_page_mode = 'FWK' OR x_appl_home_page_mode is null)
651: THEN
652: x_appl_home_page_url := fnd_profile.value('APPS_FRAMEWORK_AGENT') ;
653: x_appl_home_page_url := trim(x_appl_home_page_url) || '/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE';

Line 652: x_appl_home_page_url := fnd_profile.value('APPS_FRAMEWORK_AGENT') ;

648: THEN
649: x_appl_home_page_mode := fnd_profile.value('APPLICATIONS_HOME_PAGE') ;
650: IF (x_appl_home_page_mode = 'FWK' OR x_appl_home_page_mode is null)
651: THEN
652: x_appl_home_page_url := fnd_profile.value('APPS_FRAMEWORK_AGENT') ;
653: x_appl_home_page_url := trim(x_appl_home_page_url) || '/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE';
654: x_ext_logout_url_sql := ' Update '|| x_dem_schema || '.sys_params' ||
655: ' Set pval = ''' || x_appl_home_page_url ||
656: ''' Where pname like ''ExternalLogoutUrl'' ' ;

Line 1171: select fnd_profile.value('MSD_DEM_SCHEMA')

1167: and lookup_code = p_lookup_code
1168: and language = 'US';
1169:
1170: cursor get_schema_name is
1171: select fnd_profile.value('MSD_DEM_SCHEMA')
1172: from dual;
1173:
1174: CURSOR c_is_mdp_matrix_present (p_schema_name VARCHAR2)
1175: IS

Line 2168: IF (nvl(fnd_profile.value('MSD_DEM_SITE_CODE_FORMAT'), 2) = 2)

2164: BEGIN
2165:
2166: IF (LG_VAR_SITE_CODE_FORMAT IS NULL)
2167: THEN
2168: IF (nvl(fnd_profile.value('MSD_DEM_SITE_CODE_FORMAT'), 2) = 2)
2169: THEN
2170: LG_VAR_SITE_CODE_FORMAT := 0;
2171: ELSE
2172: LG_VAR_SITE_CODE_FORMAT := 1;

Line 2198: EXECUTE IMMEDIATE 'SELECT count(1) FROM ' || FND_PROFILE.VALUE('MSD_DEM_SCHEMA') ||

2194: x_present NUMBER := NULL;
2195:
2196: BEGIN
2197:
2198: EXECUTE IMMEDIATE 'SELECT count(1) FROM ' || FND_PROFILE.VALUE('MSD_DEM_SCHEMA') ||
2199: '.VERSION_DETAILS ' ||
2200: ' WHERE version LIKE ''7.2%'''
2201: INTO x_present;
2202:

Line 2244: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');

2240: WHERE lookup_type = p_lookup_type
2241: AND lookup_code = p_lookup_code;
2242:
2243: x_dem_version VARCHAR2(10) := GET_DEMANTRA_VERSION;
2244: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');
2245: x_sql VARCHAR2(2000) := NULL;
2246: x_lk_meaning VARCHAR2(500) := NULL;
2247: x_lk_attribute1 VARCHAR2(500) := NULL;
2248: x_lk_attribute2 VARCHAR2(500) := NULL;

Line 2354: x_dmtra_version number(10) := to_number(fnd_profile.value('MSD_DEM_VERSION')) ;

2350: x_create_synonym_sql VARCHAR2(200) := NULL;
2351: x_create_table_sql VARCHAR2(3000) := NULL;
2352: x_create_view_sql VARCHAR2(2000) := NULL;
2353: x_small_sql VARCHAR2(1000) := NULL;
2354: x_dmtra_version number(10) := to_number(fnd_profile.value('MSD_DEM_VERSION')) ;
2355: x_syn_base VARCHAR2(50) := 'MSD_DEM_BIEO_OBI_MV_DUMMY';
2356: var_boolean boolean;
2357: var_dummy1 varchar2(100);
2358: var_dummy2 varchar2(100);

Line 3020: dem_schema := fnd_profile.value('MSD_DEM_SCHEMA');

3016: RETURN;
3017: END IF;
3018: /* END - Parameters Validation */
3019:
3020: dem_schema := fnd_profile.value('MSD_DEM_SCHEMA');
3021:
3022: IF fnd_profile.value('MSD_DEM_SCHEMA') IS NOT NULL
3023: THEN
3024:

Line 3022: IF fnd_profile.value('MSD_DEM_SCHEMA') IS NOT NULL

3018: /* END - Parameters Validation */
3019:
3020: dem_schema := fnd_profile.value('MSD_DEM_SCHEMA');
3021:
3022: IF fnd_profile.value('MSD_DEM_SCHEMA') IS NOT NULL
3023: THEN
3024:
3025: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID',
3026: 'COMP_DM',

Line 3053: l_url := fnd_profile.value('MSD_DEM_HOST_URL');

3049:
3050:
3051: IF l_user_name IS NOT NULL
3052: THEN
3053: l_url := fnd_profile.value('MSD_DEM_HOST_URL');
3054: l_schema_name := trim(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', p_workflow_lookup_code, 1, 'schema_name'));
3055: l_sql := null;
3056: l_sql := 'SELECT utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual';
3057:

Line 3376: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');

3372: p_param_value IN VARCHAR2 DEFAULT NULL )
3373: IS
3374: /*--- local variables ---*/
3375: x_sql VARCHAR2(500) := NULL;
3376: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');
3377: x_is_exists NUMBER(1);
3378:
3379: vd_synchrangestart DATE;
3380: vd_synchrangeend DATE;