APPS.MSD_DEM_COLLECT_UOMS dependencies on FND_PROFILE

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

14: and lookup_code = p_lookup_code
15: and language = 'US';
16:
17: cursor get_schema_name is
18: select fnd_profile.value('MSD_DEM_SCHEMA')
19: from dual;
20:
21: l_lookup_value varchar2(200);
22: l_schema_name varchar2(200);

Line 264: if fnd_profile.value('MSD_DEM_SCHEMA') is not null then

260: end if;
261:
262: close get_uom_metadata;
263:
264: if fnd_profile.value('MSD_DEM_SCHEMA') is not null then
265: l_stmt := 'update ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.' || l_table_name || ' tei ';
266: else
267: l_stmt := 'update ' || l_table_name || ' tei ';
268: end if;

Line 265: l_stmt := 'update ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.' || l_table_name || ' tei ';

261:
262: close get_uom_metadata;
263:
264: if fnd_profile.value('MSD_DEM_SCHEMA') is not null then
265: l_stmt := 'update ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.' || l_table_name || ' tei ';
266: else
267: l_stmt := 'update ' || l_table_name || ' tei ';
268: end if;
269: