APPS.MSC_SUPPLY_PKG dependencies on FND_PROFILE

Line 98: l_pegging_granularity := nvl(fnd_profile.value('MSC_APCC_END_ITEM_ENABLED'), 2);

94: from msc_plan_runs
95: where plan_run_id = p_plan_run_id;
96:
97: if (l_plan_type=1) then
98: l_pegging_granularity := nvl(fnd_profile.value('MSC_APCC_END_ITEM_ENABLED'), 2);
99: end if;
100:
101:
102: msc_phub_util.log('msc_supply_pkg.populate_details: '||

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

206: sum(supply_tbl.po_count) po_count,
207: sum(supply_tbl.po_cancel_count) po_cancel_count,
208: sum(supply_tbl.buy_order_value) buy_order_value,
209: sum(supply_tbl.buy_order_value * decode(supply_tbl.currency_code,
210: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))) buy_order_value2,
211: sum(supply_tbl.buy_order_count) buy_order_count,
212: sum(case when l_plan_type <>5 then supply_tbl.drp_supply_as_demand else to_number(null) end ) drp_supply_as_demand,
213: sum(case when l_plan_type <>5 then supply_tbl.return_order_qty else to_number(null) end ) return_order_qty,
214: sum(case when l_plan_type <>5 then supply_tbl.return_fcst else to_number(null) end ) return_fcst,

Line 446: and mcc.to_currency(+)=fnd_profile.value('MSC_HUB_CUR_CODE_RPT')

442: nvl(msi.vmi_flag,0)
443: ) supply_tbl,
444: msc_currency_conv_mv mcc
445: where mcc.from_currency(+)=supply_tbl.currency_code
446: and mcc.to_currency(+)=fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
447: and mcc.calendar_date(+)=supply_tbl.supply_date
448: group by
449: decode(l_plan_type,4,1,9,1,0),
450: supply_tbl.sr_instance_id,

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

606:
607: procedure summarize_supplies_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
608: p_plan_id number, p_plan_run_id number)
609: is
610: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
611: begin
612: msc_phub_util.log('msc_supply_pkg.summarize_supplies_f');
613: retcode := 0;
614: errbuf := '';

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

917:
918: procedure summarize_item_wips_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
919: p_plan_id number, p_plan_run_id number)
920: is
921: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
922: begin
923: msc_phub_util.log('msc_supply_pkg.summarize_item_wips_f');
924: retcode := 0;
925: errbuf := '';