APPS.MSD_DEM_COLLECT_LEVEL_TYPES dependencies on FND_PROFILE

Line 27: x_dem_schema varchar2(100) := FND_PROFILE.value('MSD_DEM_SCHEMA');

23: RETURN varchar2
24:
25: IS
26: x_sql varchar2(1000) := null ;
27: x_dem_schema varchar2(100) := FND_PROFILE.value('MSD_DEM_SCHEMA');
28: flag_720_ic NUMBER;
29: flag_720_id NUMBER;
30: flag_720_ia NUMBER;
31: flag_dm_active NUMBER;

Line 173: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

169: elsif p_collect_level_type = 2 then
170:
171: msd_dem_query_utilities.get_query(retcode, l_stmt, 'ITEM_GTT', p_instance_id, l_sales_staging_table);
172:
173: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
174:
175: if retcode = -1 then
176: return;
177: end if;

Line 524: var_schema VARCHAR2(100) DEFAULT fnd_profile.value('MSD_DEM_SCHEMA');

520: retcode OUT NOCOPY VARCHAR2,
521: p_for_spf IN NUMBER )
522: IS
523:
524: var_schema VARCHAR2(100) DEFAULT fnd_profile.value('MSD_DEM_SCHEMA');
525: var_count NUMBER DEFAULT 0;
526:
527: var_org_type_code VARCHAR2(255) DEFAULT NULL;
528: var_org_type_desc VARCHAR2(255) DEFAULT NULL;

Line 623: x_dem_schema VARCHAR2(100) DEFAULT fnd_profile.value('MSD_DEM_SCHEMA');

619: PROCEDURE populate_item_type(errbuf OUT NOCOPY VARCHAR2,
620: retcode OUT NOCOPY NUMBER )
621: AS
622:
623: x_dem_schema VARCHAR2(100) DEFAULT fnd_profile.value('MSD_DEM_SCHEMA');
624: x_sql VARCHAR2(500);
625: x_count NUMBER(1) := 0 ;
626:
627: