DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on FND_PROFILE

Line 2952: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')

2948: cursor category_id_c is
2949: select sr_category_id
2950: from msc_item_categories
2951: where category_name = p_category_name
2952: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
2953: and rownum =1 ;
2954:
2955:
2956: cursor category_id_c1 is

Line 2960: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')

2956: cursor category_id_c1 is
2957: select sr_category_id
2958: from msc_item_categories
2959: where category_name = p_category_name
2960: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
2961: and organization_id=p_org_id
2962: and sr_instance_id=p_inst_id
2963: and rownum =1 ;
2964: l_category_id number;

Line 4319: l_value := fnd_profile.value('MSC_SRA_CATEGORY_SET');

4315: open c_default_cat;
4316: fetch c_default_cat into l_value;
4317: close c_default_cat;
4318: if l_value is null then
4319: l_value := fnd_profile.value('MSC_SRA_CATEGORY_SET');
4320: end if;
4321: else
4322: l_key := null;
4323: open pref_def_c;