APPS.MSD_DEM_TIME_DATA dependencies on FND_PROFILE

Line 305: l_stmt := 'begin ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.Integration_1_Load_Calendars' ||

301: END IF;
302: end loop;
303:
304:
305: l_stmt := 'begin ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.Integration_1_Load_Calendars' ||
306: '(''' || fnd_profile.value('MSD_DEM_FISCAL_CALENDAR') || ''')' ||'; end;';
307:
308: msd_dem_common_utilities.log_debug(l_stmt);
309:

Line 306: '(''' || fnd_profile.value('MSD_DEM_FISCAL_CALENDAR') || ''')' ||'; end;';

302: end loop;
303:
304:
305: l_stmt := 'begin ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.Integration_1_Load_Calendars' ||
306: '(''' || fnd_profile.value('MSD_DEM_FISCAL_CALENDAR') || ''')' ||'; end;';
307:
308: msd_dem_common_utilities.log_debug(l_stmt);
309:
310: execute immediate 'alter session set current_schema=' || fnd_profile.value('MSD_DEM_SCHEMA');

Line 310: execute immediate 'alter session set current_schema=' || fnd_profile.value('MSD_DEM_SCHEMA');

306: '(''' || fnd_profile.value('MSD_DEM_FISCAL_CALENDAR') || ''')' ||'; end;';
307:
308: msd_dem_common_utilities.log_debug(l_stmt);
309:
310: execute immediate 'alter session set current_schema=' || fnd_profile.value('MSD_DEM_SCHEMA');
311:
312: execute immediate l_stmt;
313:
314: l_stmt := 'alter session set current_schema=APPS';