APPS.MSC_BI2EBS_PKG dependencies on FND_PROFILE

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

100:
101: cursor c_category_id(p_category_name varchar2) is
102: select sr_category_id from msc_phub_categories_mv
103: where CATEGORY_NAME = p_category_name
104: and category_set_id = fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
105:
106: cursor c_item_id(p_plan_id number,p_item_name varchar2) is
107: select unique inventory_item_id from msc_system_items
108: where item_name=p_item_name

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

361:
362: begin
363:
364: begin
365: select fnd_profile.value('MSD_DEM_SCHEMA') into l_schema from dual;
366: exception
367: when others then
368: null;
369: end;

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

435: close c_remember_cur;
436: end if;
437: end loop;
438: end if;
439: /* x_url :=Fnd_profile.value('MSD_DEM_HOST_URL') || '/portal/prelogin.jsp?redirectUrl=partnerLogin.jsp?'
440: || l_url_string || '&submitUrl=loginCheck.jsp&loginUrl=loginpage.jsp&source=0&component=sop&componentowner=yes';
441: */
442:
443: -- dbms_output.put_line('before=' || l_url_string);