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_DEMANTRA_UTILITIES dependencies on FND_PROFILE

Line 56: EXECUTE IMMEDIATE 'SELECT FND_PROFILE.VALUE (''MSD_DEM_SCHEMA'') FROM DUAL ' INTO g_demantra_schema_name;

52: RETURN 0;
53: END IF;
54:
55: x_count := 0;
56: EXECUTE IMMEDIATE 'SELECT FND_PROFILE.VALUE (''MSD_DEM_SCHEMA'') FROM DUAL ' INTO g_demantra_schema_name;
57:
58: IF (g_demantra_schema_name IS NULL)
59: THEN
60: RETURN -1;

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

1563: x_grant_sql := 'GRANT SELECT ON ' || x_msd_schema || '.MSD_DEM_CTO_BOM TO ' || x_dem_schema;
1564: execute immediate x_grant_sql;
1565:
1566: /* Set the profile MSD_DEM_SCHEMA if not set */
1567: x_curr_val := fnd_profile.value('MSD_DEM_SCHEMA');
1568:
1569: IF (nvl(x_curr_val, '$$$') <> x_dem_schema)
1570: THEN
1571: x_success := fnd_profile.save ('MSD_DEM_SCHEMA', x_dem_schema, 'SITE');

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

1567: x_curr_val := fnd_profile.value('MSD_DEM_SCHEMA');
1568:
1569: IF (nvl(x_curr_val, '$$$') <> x_dem_schema)
1570: THEN
1571: x_success := fnd_profile.save ('MSD_DEM_SCHEMA', x_dem_schema, 'SITE');
1572: log_message ('Profile MSD_DEM: Schema has been set to ''' || x_dem_schema || ''' at the SITE level');
1573:
1574: /*Setting global parameter */
1575: C_MSD_DEM_SCHEMA := x_dem_schema ;

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

1616: EXECUTE IMMEDIATE x_get_dem_ver_sql into x_dem_version ;
1617:
1618: x_dem_version := SUBSTR(x_dem_version, 1, INSTR(x_dem_version, '.', 1, 2)-1) ;
1619:
1620: x_success := fnd_profile.save ('MSD_DEM_VERSION', x_dem_version, 'SITE');
1621: log_message ('Profile MSD_DEM: Version has been set to ''' || x_dem_version || ''' at the SITE level');
1622:
1623: /* Set the ExternalLogoutUrl parameter in demantra schema to the applications home page */ -- nallkuma 16-feb-2009
1624: /* 1st IF condtion :- This is only for demantra 7.3.X & above versions */ -- bug#7458724

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

1625: /* 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 */
1626:
1627: IF (TO_NUMBER(x_dem_version) >= 7.3)
1628: THEN
1629: x_appl_home_page_mode := fnd_profile.value('APPLICATIONS_HOME_PAGE') ;
1630: IF (x_appl_home_page_mode = 'FWK' OR x_appl_home_page_mode is null)
1631: THEN
1632: x_appl_home_page_url := fnd_profile.value('APPS_FRAMEWORK_AGENT') ;
1633: x_appl_home_page_url := trim(x_appl_home_page_url) || '/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE';

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

1628: THEN
1629: x_appl_home_page_mode := fnd_profile.value('APPLICATIONS_HOME_PAGE') ;
1630: IF (x_appl_home_page_mode = 'FWK' OR x_appl_home_page_mode is null)
1631: THEN
1632: x_appl_home_page_url := fnd_profile.value('APPS_FRAMEWORK_AGENT') ;
1633: x_appl_home_page_url := trim(x_appl_home_page_url) || '/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE';
1634: x_ext_logout_url_sql := ' Update '|| x_dem_schema || '.sys_params' ||
1635: ' Set pval = ''' || x_appl_home_page_url ||
1636: ''' Where pname like ''ExternalLogoutUrl'' ' ;