APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on FND_PROFILE

Line 150: -- SELECT fnd_profile.value('MSR_BUDGET_CATEGORY_SET') INTO l_cat_set_id FROM dual;

146: l_def_pref_id number;
147: l_plan_type number;
148: BEGIN
149: -- Get category set from profile option for IO
150: -- SELECT fnd_profile.value('MSR_BUDGET_CATEGORY_SET') INTO l_cat_set_id FROM dual;
151: l_plan_type := get_plan_type(p_plan_id);
152: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
153: l_cat_set_id:= msc_get_name.GET_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
154: return l_cat_set_id;

Line 2956: g_period_setname := fnd_profile.value('MSC_IO_UI_PERSETNAME');

2952: END IF;
2953:
2954: g_user_id := fnd_global.user_id;
2955:
2956: g_period_setname := fnd_profile.value('MSC_IO_UI_PERSETNAME');
2957: --if profile not set default to Accounting as before
2958: if(g_period_setname is null) then
2959: g_period_setname := 'Accounting';
2960: end if;

Line 2962: perf_profile := fnd_profile.value('MSC_IO_UI_PERF_TUNE');

2958: if(g_period_setname is null) then
2959: g_period_setname := 'Accounting';
2960: end if;
2961:
2962: perf_profile := fnd_profile.value('MSC_IO_UI_PERF_TUNE');
2963: if(perf_profile is null OR perf_profile ='N') then
2964: g_perf_prof_on := false;
2965: else
2966: g_perf_prof_on := true;

Line 2971: lv_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');

2967: end if;
2968:
2969: select count(*) into l_temp from sys.all_tab_partitions where table_name = 'MSC_ANALYSIS_AGGREGATE'
2970: AND PARTITION_NAME = 'ANALYSIS_AGGREGATE_'||P_PLAN_ID;
2971: lv_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
2972:
2973: if (l_temp = 0 and lv_share_partition <> 'Y')then --create partition
2974: l_part_retval := manage_partitions(p_plan_id, 1);
2975: if (l_part_retval <> 0) then