APPS.MSD_DEM_PROCESS_SALES_DATA dependencies on FND_PROFILE

Line 10: v_debug BOOLEAN := nvl(FND_PROFILE.VALUE('MRP_DEBUG'),'N') = 'Y';

6: G_ERROR CONSTANT NUMBER := 2;
7: G_WARNING CONSTANT NUMBER := 1;
8:
9: v_sql_stmt PLS_INTEGER;
10: v_debug BOOLEAN := nvl(FND_PROFILE.VALUE('MRP_DEBUG'),'N') = 'Y';
11:
12: PROCEDURE LOG_MESSAGE(p_error_text IN VARCHAR2)
13: IS
14: BEGIN

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

28: IS
29:
30: /* bug#8367504 -- nallkuma
31: cursor get_schema_name is
32: select fnd_profile.value('MSD_DEM_SCHEMA')
33: from dual;
34: */
35:
36: l_schema_name VARCHAR2(100);

Line 96: l_dem_version := fnd_profile.value('MSD_DEM_VERSION');

92: , instr(msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE'), '.')-1) ;
93:
94: LOG_MESSAGE('Fetched the schema name as : '||l_schema_name);
95:
96: l_dem_version := fnd_profile.value('MSD_DEM_VERSION');
97:
98: /*if l_dem_version is null then
99: LOG_MESSAGE('MSD_DEM_VERSION profile is null.');
100: return;