APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on FND_PROFILE

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

594: var_usage_ff_until_date date := NULL;
595:
596: x_version NUMBER := NULL;
597: x_sql VARCHAR2(2000) := NULL;
598: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');
599:
600: -- Bug#12675064
601: x_profile_id number := null;
602: x_srs_id number := null;

Line 2275: var_url := FND_PROFILE.VALUE('MSD_DEM_HOST_URL');

2271: RETURN;
2272: END IF;
2273:
2274: /* Get base Demantra URL */
2275: var_url := FND_PROFILE.VALUE('MSD_DEM_HOST_URL');
2276:
2277: IF (var_url IS NULL)
2278: THEN
2279: retcode := -1;

Line 3083: x_dem_url := fnd_profile.value('MSD_DEM_HOST_URL');

3079: if( p_load_sales_fcst = G_NO ) then
3080: msd_dem_common_utilities.log_message('Load Sales Forecast not selected. Exiting.');
3081: msd_dem_common_utilities.log_debug('Load Sales Forecast not selected. Exiting.');
3082: else
3083: x_dem_url := fnd_profile.value('MSD_DEM_HOST_URL');
3084:
3085: /* check if demantra schema and host url are set */
3086: if( g_schema is null ) then
3087: raise_application_error(-20002, 'Demantra schema not set');

Line 7140: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');

7136: BEGIN
7137:
7138: msd_dem_common_utilities.log_debug ('Entering: msd_spf_collect_history_data.purge_spf_gl_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
7139:
7140: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
7141:
7142: /*Deleting records from T_EP_SPF table */
7143: msd_dem_common_utilities.log_message('Deleting data from T_EP_SPF');
7144: x_sql := 'DELETE FROM ' || x_schema || '.t_ep_spf WHERE t_ep_spf_id <> 0 ';