APPS.MSD_DEM_COMMON_UTILITIES dependencies on FND_PROFILE

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

388: x_grant_execute_sql := 'GRANT EXECUTE ON MSD_DEM_UPLOAD_FORECAST TO ' || x_dem_schema;
389: EXECUTE IMMEDIATE x_grant_execute_sql;
390:
391: /* Set the profile MSD_DEM_SCHEMA if not set */
392: x_curr_val := fnd_profile.value('MSD_DEM_SCHEMA');
393:
394: IF (nvl(x_curr_val, '$$$') <> x_dem_schema)
395: THEN
396: x_success := fnd_profile.save ('MSD_DEM_SCHEMA', x_dem_schema, 'SITE');

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

392: x_curr_val := fnd_profile.value('MSD_DEM_SCHEMA');
393:
394: IF (nvl(x_curr_val, '$$$') <> x_dem_schema)
395: THEN
396: x_success := fnd_profile.save ('MSD_DEM_SCHEMA', x_dem_schema, 'SITE');
397: END IF;
398:
399: END IF;
400: commit;

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

628: and lookup_code = p_lookup_code
629: and language = 'US';
630:
631: cursor get_schema_name is
632: select fnd_profile.value('MSD_DEM_SCHEMA')
633: from dual;
634:
635: CURSOR c_is_mdp_matrix_present (p_schema_name VARCHAR2)
636: IS