eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ANALYSIS_PKG dependencies on MSC_ANALYSIS_PKG

Line 1: PACKAGE BODY MSC_ANALYSIS_PKG AS

1: PACKAGE BODY MSC_ANALYSIS_PKG AS
2: /* $Header: MSCANLSB.pls 120.17 2007/12/21 22:20:41 minduvad ship $ */
3:
4: g_plan_viewby CONSTANT NUMBER :=0;
5: g_org_viewby CONSTANT NUMBER :=1;

Line 419: ' round(sum(mfq1.NUMBER8)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||' ), '||

415: l_mfq_insert := ' SELECT '||l_seq_id2 ||' , sysdate, -1, sysdate, -1, '||
416: ' round(sum(mfq1.NUMBER5), '|| l_round || ' ), '||
417: ' round(sum(mfq1.NUMBER6), '|| l_round ||'), '||
418: ' round(sum(mfq1.NUMBER7), '|| l_round ||' ), '||
419: ' round(sum(mfq1.NUMBER8)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||' ), '||
420: ' round(sum(mfq1.NUMBER9)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||' ), '||
421: ' round(sum(mfq1.NUMBER10)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||'), ';
422:
423: l_mfq_from := ' from msc_form_query mfq1 ';

Line 420: ' round(sum(mfq1.NUMBER9)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||' ), '||

416: ' round(sum(mfq1.NUMBER5), '|| l_round || ' ), '||
417: ' round(sum(mfq1.NUMBER6), '|| l_round ||'), '||
418: ' round(sum(mfq1.NUMBER7), '|| l_round ||' ), '||
419: ' round(sum(mfq1.NUMBER8)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||' ), '||
420: ' round(sum(mfq1.NUMBER9)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||' ), '||
421: ' round(sum(mfq1.NUMBER10)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||'), ';
422:
423: l_mfq_from := ' from msc_form_query mfq1 ';
424:

Line 421: ' round(sum(mfq1.NUMBER10)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||'), ';

417: ' round(sum(mfq1.NUMBER6), '|| l_round ||'), '||
418: ' round(sum(mfq1.NUMBER7), '|| l_round ||' ), '||
419: ' round(sum(mfq1.NUMBER8)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||' ), '||
420: ' round(sum(mfq1.NUMBER9)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||' ), '||
421: ' round(sum(mfq1.NUMBER10)/MSC_ANALYSIS_PKG.get_num_periods(mfq1.NUMBER1, '||l_calendar_type||'), '|| l_round ||'), ';
422:
423: l_mfq_from := ' from msc_form_query mfq1 ';
424:
425: l_mfq_plan_insert := ' mfq1.number1, mfq1.char1, '||

Line 825: l_plan_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 0), ';

821: l_item_groupby := ' GROUP BY plan_id, plan_name, inventory_item_id, item_name ';
822: l_demand_class_groupby := ' GROUP BY plan_id, plan_name, demand_class ';
823: l_pr_groupby := ' GROUP BY detail_date, period_type, detail_level, period_type_url, plan_id, plan_name ';
824:
825: l_plan_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 0), ';
826: l_org_dflt_insert := ' to_number(null), ';
827: l_cate_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 6, null, '||
828: ' null, null, null, null, null, category_id), ';
829: l_item_dflt_insert := ' to_number(null), ';

Line 827: l_cate_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 6, null, '||

823: l_pr_groupby := ' GROUP BY detail_date, period_type, detail_level, period_type_url, plan_id, plan_name ';
824:
825: l_plan_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 0), ';
826: l_org_dflt_insert := ' to_number(null), ';
827: l_cate_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 6, null, '||
828: ' null, null, null, null, null, category_id), ';
829: l_item_dflt_insert := ' to_number(null), ';
830: l_demand_class_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 4, null, null, '||
831: ' null, demand_class, null, null, null), ';

Line 830: l_demand_class_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 4, null, null, '||

826: l_org_dflt_insert := ' to_number(null), ';
827: l_cate_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 6, null, '||
828: ' null, null, null, null, null, category_id), ';
829: l_item_dflt_insert := ' to_number(null), ';
830: l_demand_class_dflt_insert := ' msc_analysis_pkg.get_dflt_value(plan_id, null, 4, null, null, '||
831: ' null, demand_class, null, null, null), ';
832: l_pr_dflt_insert := ' to_number(null), ';
833:
834: --where clause stmt begins

Line 1031: v_tp_cost := msc_analysis_pkg.get_plan_service_level(arg_plan, g_tp_cost, arg_instance, arg_org, arg_item, l_prev_date, l_next_date);

1027: elsif (l_next_date is null or trunc(l_next_date) > trunc(plan_end_date) ) then
1028: l_next_date := plan_end_date;
1029: end if;
1030:
1031: v_tp_cost := msc_analysis_pkg.get_plan_service_level(arg_plan, g_tp_cost, arg_instance, arg_org, arg_item, l_prev_date, l_next_date);
1032:
1033: return round(v_tp_cost,2);
1034: end get_tp_cost;
1035:

Line 1339: select sum(nvl(MSC_ANALYSIS_PKG.get_tp_cost(mbid.period_type,

1335: and mbp.adjustment_period_flag ='N'
1336: order by mbp.start_date;
1337: /*
1338: CURSOR c_tp_cost (p_plan_id in number, p_inst_id in number, p_org_id in number) IS
1339: select sum(nvl(MSC_ANALYSIS_PKG.get_tp_cost(mbid.period_type,
1340: mbid.detail_level, mbid.plan_id, mbid.sr_instance_id,
1341: mbid.organization_id, mbid.inventory_item_id, mbid.detail_date),0))
1342: FROM msc_bis_inv_detail mbid
1343: WHERE mbid.plan_id = p_plan_id

Line 1436: l_attained := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_attained_sl);

1432: -- l_attained := Msc_Get_Bis_Values.get_service_level(l_plan_id, null, null, null, null, null, -1);
1433: -- l_target := Msc_Get_Bis_Values.get_target_service_level(l_plan_id, null, null, null);
1434: --l_tp_cost := nvl(msc_get_bis_values.get_tp_cost(l_plan_id, null, null, null),0);
1435:
1436: l_attained := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_attained_sl);
1437: l_target := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_target_sl);
1438:
1439: l_tp_cost := 0;
1440:

Line 1437: l_target := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_target_sl);

1433: -- l_target := Msc_Get_Bis_Values.get_target_service_level(l_plan_id, null, null, null);
1434: --l_tp_cost := nvl(msc_get_bis_values.get_tp_cost(l_plan_id, null, null, null),0);
1435:
1436: l_attained := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_attained_sl);
1437: l_target := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_target_sl);
1438:
1439: l_tp_cost := 0;
1440:
1441: open c_tp_cost_new(l_plan_id, l_otype1, l_otype2, l_otype3);

Line 1743: l_cate_set_id := msc_analysis_pkg.get_cat_set_id(p_plan_id);

1739: and nvl(sr_category_id,-1) = nvl(p_cate_id,-1)
1740: order by definition_level desc;
1741:
1742: begin
1743: l_cate_set_id := msc_analysis_pkg.get_cat_set_id(p_plan_id);
1744:
1745: if (p_definition_level = 0) then
1746: l_dflt := msc_analysis_pkg.get_plan_dflt_value(p_plan_id);
1747: else

Line 1746: l_dflt := msc_analysis_pkg.get_plan_dflt_value(p_plan_id);

1742: begin
1743: l_cate_set_id := msc_analysis_pkg.get_cat_set_id(p_plan_id);
1744:
1745: if (p_definition_level = 0) then
1746: l_dflt := msc_analysis_pkg.get_plan_dflt_value(p_plan_id);
1747: else
1748: open c_dflt_with_level;
1749: fetch c_dflt_with_level into l_dflt;
1750: close c_dflt_with_level;

Line 1856: END MSC_ANALYSIS_PKG;

1852: close c_dflt;
1853: */
1854: end get_dflt_value;
1855:
1856: END MSC_ANALYSIS_PKG;