APPS.MSC_BI2EBS_PKG dependencies on FND_PROFILE

Line 113: and category_set_id = fnd_profile.value('MSC_HUB_CAT_SET_ID_1')

109:
110: cursor c_category_id(p_sr_instance_id number, p_category_name varchar2) is
111: select sr_category_id from msc_phub_categories_mv
112: where CATEGORY_NAME = p_category_name
113: and category_set_id = fnd_profile.value('MSC_HUB_CAT_SET_ID_1')
114: and sr_instance_id = nvl(p_sr_instance_id, sr_instance_id);
115:
116: cursor c_item_id(p_plan_id number,p_item_name varchar2) is
117: select unique inventory_item_id from msc_system_items

Line 165: l_cat_set_id := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

161:
162: l_dept_list := p_params.dept_list;
163: l_cat_set_id := p_params.cat_set_id;
164: if (l_cat_set_id is null) then
165: l_cat_set_id := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
166: end if;
167:
168: l_order_type_id_list := p_params.order_type_id_list;
169:

Line 452: select fnd_profile.value('MSD_DEM_SCHEMA') into l_schema from dual;

448:
449: l_unassigned := fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED');
450:
451: begin
452: select fnd_profile.value('MSD_DEM_SCHEMA') into l_schema from dual;
453: exception
454: when others then
455: null;
456: end;

Line 528: /* x_url :=Fnd_profile.value('MSD_DEM_HOST_URL') || '/portal/prelogin.jsp?redirectUrl=partnerLogin.jsp?'

524: close c_remember_cur;
525: end if;
526: end loop;
527: end if;
528: /* x_url :=Fnd_profile.value('MSD_DEM_HOST_URL') || '/portal/prelogin.jsp?redirectUrl=partnerLogin.jsp?'
529: || l_url_string || '&submitUrl=loginCheck.jsp&loginUrl=loginpage.jsp&source=0&component=sop&componentowner=yes';
530: */
531:
532: -- dbms_output.put_line('before=' || l_url_string);