APPS.MSC_PHUB_UTIL dependencies on FND_PROFILE

Line 47: g_rpt_curr_code := nvl(FND_PROFILE.VALUE('MSC_HUB_CUR_CODE_RPT'),'USD');

43:
44: function get_reporting_currency_code return varchar2 is
45: begin
46: if g_rpt_curr_code is null then
47: g_rpt_curr_code := nvl(FND_PROFILE.VALUE('MSC_HUB_CUR_CODE_RPT'),'USD');
48: end if;
49:
50: return g_rpt_curr_code;
51: end get_reporting_currency_code;

Line 306: l_debug number := fnd_profile.value('MSC_APCC_DEBUG_MODE');

302:
303: procedure init_log is
304: l_log_dir varchar2(1024) := null;
305: l_log_file varchar2(20) := 'apcc.log';
306: l_debug number := fnd_profile.value('MSC_APCC_DEBUG_MODE');
307: l_sql varchar2(1000);
308: begin
309: if (l_debug = 1) then
310: l_sql :=

Line 530: l_category_set_id number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

526: function decode_category_key(p_staging_table varchar2, p_st_transaction_id number)
527: return number
528: is
529: l_sql varchar2(1000);
530: l_category_set_id number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
531: begin
532: l_sql :=
533: ' update '||p_staging_table||' f set (error_code, category_set_id, category_instance_id) ='||
534: ' (select 0, '||l_category_set_id||', d.instance_id from msc_apps_instances d'||

Line 884: if (fnd_profile.value('MSD_DEM_VERSION') is not null) then

880: end msc_schema;
881:
882: function demantra_schema return varchar2 is
883: begin
884: if (fnd_profile.value('MSD_DEM_VERSION') is not null) then
885: return fnd_profile.value('MSD_DEM_SCHEMA');
886: end if;
887: return null;
888: end demantra_schema;

Line 885: return fnd_profile.value('MSD_DEM_SCHEMA');

881:
882: function demantra_schema return varchar2 is
883: begin
884: if (fnd_profile.value('MSD_DEM_VERSION') is not null) then
885: return fnd_profile.value('MSD_DEM_SCHEMA');
886: end if;
887: return null;
888: end demantra_schema;
889:

Line 1067: l_profile_value := fnd_profile.value(p_table_type);

1063: if (l_schema is null) then
1064: l_schema := msc_schema;
1065: end if;
1066:
1067: l_profile_value := fnd_profile.value(p_table_type);
1068: if (l_profile_value = 1) then
1069: if (p_partition_id is not null) then
1070: l_partition_name := get_partition_name(p_table, p_partition_id);
1071: fnd_stats.gather_table_stats(