APPS.MSC_DEMANTRA_PKG dependencies on FND_PROFILE

Line 24: and daio.organization_id=fnd_profile.value('MSD_DEM_MASTER_ORG')

20: msd_dp_ascp_scenarios_v p
21: where o.partner_type=3
22: and o.sr_instance_id=decode(sign(p.sr_instance_id), -1, o.sr_instance_id, p.sr_instance_id)
23: and o.organization_code=daio.organization_code
24: and daio.organization_id=fnd_profile.value('MSD_DEM_MASTER_ORG')
25: and p.scenario_id=p_plan_id;
26: exception
27: when others then
28: null;

Line 82: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))

78: to_number(-23453) sr_category_id,
79: t.consensus_fcst,
80: t.consensus_fcst*t.price consensus_fcst_value,
81: t.consensus_fcst*t.price * decode(t.currency_code,
82: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))
83: consensus_fcst_value2,
84: t.consensus_fcst_cum,
85: t.priority,
86: fnd_global.user_id, sysdate,

Line 138: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')

134: and k.demand_class = f.demand_class(+)
135: and k.start_date = f.start_date(+)) t,
136: msc_currency_conv_mv mcc,
137: msc_phub_customers_mv mpc
138: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
139: and mcc.from_currency(+) = t.currency_code
140: and mcc.calendar_date(+) = t.start_date
141: and mpc.customer_id = t.customer_id
142: and mpc.customer_site_id = t.customer_site_id

Line 178: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

174:
175: procedure populate_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,
176: p_plan_id number, p_plan_run_id number)
177: is
178: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
179: begin
180: -- level 1
181: insert into msc_demantra_f (
182: ods_plan_id, plan_id, plan_run_id,