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.19 2009/12/24 00:21:42 minduvad ship $ */
3:
4: g_plan_viewby CONSTANT NUMBER :=0;
5: g_org_viewby CONSTANT NUMBER :=1;

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

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

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

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

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

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

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

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

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

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

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

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

Line 1030: 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);

1026: elsif (l_next_date is null or trunc(l_next_date) > trunc(plan_end_date) ) then
1027: l_next_date := plan_end_date;
1028: end if;
1029:
1030: 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);
1031:
1032: return round(v_tp_cost,2);
1033: end get_tp_cost;
1034:

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

1436: l_ext_repair_cost, l_int_repair_cost;
1437: EXIT WHEN c1%NOTFOUND;
1438: l_plan_name := msc_get_name.plan_name(l_plan_id);
1439:
1440: l_attained := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_attained_sl);
1441: l_target := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_target_sl);
1442: l_tp_cost := 0;
1443:
1444: if(g_perf_profile_on <> TRUE) then

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

1437: EXIT WHEN c1%NOTFOUND;
1438: l_plan_name := msc_get_name.plan_name(l_plan_id);
1439:
1440: l_attained := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_attained_sl);
1441: l_target := msc_analysis_pkg.get_plan_service_level(l_plan_id, g_target_sl);
1442: l_tp_cost := 0;
1443:
1444: if(g_perf_profile_on <> TRUE) then
1445: open c_tp_cost_new(l_plan_id, l_otype1, l_otype2, l_otype3);

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

1753: and nvl(sr_category_id,-1) = nvl(p_cate_id,-1)
1754: order by definition_level desc;
1755:
1756: begin
1757: l_cate_set_id := msc_analysis_pkg.get_cat_set_id(p_plan_id);
1758:
1759: if (p_definition_level = 0) then
1760: l_dflt := msc_analysis_pkg.get_plan_dflt_value(p_plan_id);
1761: else

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

1756: begin
1757: l_cate_set_id := msc_analysis_pkg.get_cat_set_id(p_plan_id);
1758:
1759: if (p_definition_level = 0) then
1760: l_dflt := msc_analysis_pkg.get_plan_dflt_value(p_plan_id);
1761: else
1762: open c_dflt_with_level;
1763: fetch c_dflt_with_level into l_dflt;
1764: close c_dflt_with_level;

Line 1870: END MSC_ANALYSIS_PKG;

1866: close c_dflt;
1867: */
1868: end get_dflt_value;
1869:
1870: END MSC_ANALYSIS_PKG;