APPS.MSC_DEMANTRA_PKG dependencies on FND_PROFILE

Line 145: l_item_hierarchy varchar2(100) := fnd_profile.value_specific('MSC_APCC_DMTRA_ITEM_HIERS', -1);

141: end staging_table;
142:
143: procedure build_custom_hierarchy
144: is
145: l_item_hierarchy varchar2(100) := fnd_profile.value_specific('MSC_APCC_DMTRA_ITEM_HIERS', -1);
146: l_sql varchar2(16384);
147: l_sql2 varchar2(16384);
148: l_n number;
149: begin

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

322: to_number(-23453) sr_category_id,
323: t.consensus_fcst,
324: t.consensus_fcst*t.price consensus_fcst_value,
325: t.consensus_fcst*t.price * decode(t.currency_code,
326: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))
327: consensus_fcst_value2,
328: t.consensus_fcst_cum,
329: t.priority,
330: fnd_global.user_id, sysdate,

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

397: and k.inventory_item_id = f.inventory_item_id(+)
398: and k.demand_class = f.demand_class(+)
399: and k.start_date = f.start_date(+)) t,
400: msc_currency_conv_mv mcc
401: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
402: and mcc.from_currency(+) = t.currency_code
403: and mcc.calendar_date(+) = t.start_date;
404:
405: msc_phub_util.log('msc_demantra_pkg.populate_details: insert='||sql%rowcount);

Line 585: l_rpt_cur varchar2(120) := ' * decode(t.currency_code, fnd_profile.value(''MSC_HUB_CUR_CODE_RPT''), 1, nvl(mcc.conv_rate, 0))';

581: is
582: t msc_apcc_measure_map_table := msc_apcc_measure_map_table();
583:
584: l_value varchar2(20) := ' * t.price';
585: l_rpt_cur varchar2(120) := ' * decode(t.currency_code, fnd_profile.value(''MSC_HUB_CUR_CODE_RPT''), 1, nvl(mcc.conv_rate, 0))';
586: l_value2 varchar2(120) := l_value||l_rpt_cur;
587: l_over varchar2(200) := ' over(partition by t.sr_instance_id, t.organization_id, t.owning_org_id, t.inventory_item_id, t.customer_id, t.customer_site_id, t.region_id, t.demand_class order by t.sdate)';
588: l_projected_backlog varchar2(1024) := 'sum(decode(t.future_start, 1, t.total_backlog, 0))'||l_over||' + sum(decode(t.record_type, 1, null, nvl(t.fcst_booking, 0) - nvl(t.fcst_shipment, 0)))'||l_over;
589: l_booking_history varchar2(60) := 'decode(t.record_type, 1, t.ebs_bh_book_qty_bd, null)';

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

820: end find_dimension_columns;
821:
822: procedure summarize(p_plan_id number, p_plan_run_id number, p_fact_type number)
823: is
824: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
825: l_sql varchar2(16384);
826: begin
827: msc_phub_util.log('msc_demantra_pkg.summarize');
828:

Line 971: l_sr_instance_id number := fnd_profile.value('MSD_DEM_SR_INSTANCE_FOR_GLOBAL_FCST');

967: l_dkey_site_column varchar2(30);
968: l_zone_column varchar2(30);
969:
970: l_owning_currency_code varchar2(20) := msc_phub_util.get_owning_currency_code(0);
971: l_sr_instance_id number := fnd_profile.value('MSD_DEM_SR_INSTANCE_FOR_GLOBAL_FCST');
972:
973: l_target_table varchar2(30) := fact_table(p_fact_type);
974: l_publish_mode number := publish_mode(p_publisher);
975:

Line 1166: ' where mcc.to_currency(+)=fnd_profile.value(''MSC_HUB_CUR_CODE_RPT'')'||LF||

1162: ' t.future_start,'||LF||
1163: ' t.dummy'||LF||
1164: ' ) t,'||LF||
1165: ' msc_currency_conv_mv mcc'||LF||
1166: ' where mcc.to_currency(+)=fnd_profile.value(''MSC_HUB_CUR_CODE_RPT'')'||LF||
1167: ' and mcc.from_currency(+)=t.currency_code'||LF||
1168: ' and mcc.calendar_date(+)=t.sdate';
1169:
1170: msc_phub_util.log_sql(l_sql);

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

1316:
1317: procedure summarize_demantra_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
1318: p_plan_id number, p_plan_run_id number)
1319: is
1320: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
1321: begin
1322: msc_phub_util.log('msc_demantra_pkg.summarize_demantra_f');
1323: retcode := 0;
1324: errbuf := '';