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_GET_NAME

Line 75: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);

71: l_mfq_query_id constant number := -99;
72: l_plan_type number;
73: BEGIN
74: l_plan_type := p_plan_type;
75: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
76: l_cat_set_id:= msc_get_name.GET_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
77:
78: update msc_form_query
79: set number1 = l_cat_set_id,

Line 76: l_cat_set_id:= msc_get_name.GET_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);

72: l_plan_type number;
73: BEGIN
74: l_plan_type := p_plan_type;
75: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
76: l_cat_set_id:= msc_get_name.GET_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
77:
78: update msc_form_query
79: set number1 = l_cat_set_id,
80: number2 = p_plan_type

Line 125: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);

121: l_plan_type number;
122: begin
123:
124: l_plan_type := get_plan_type(arg_plan_id);
125: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
126: l_round := msc_get_name.GET_preference('SUMMARY_DECIMAL_PLACES',l_def_pref_id, l_plan_type);
127:
128: if (l_round is null) then
129: return 6;

Line 126: l_round := msc_get_name.GET_preference('SUMMARY_DECIMAL_PLACES',l_def_pref_id, l_plan_type);

122: begin
123:
124: l_plan_type := get_plan_type(arg_plan_id);
125: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
126: l_round := msc_get_name.GET_preference('SUMMARY_DECIMAL_PLACES',l_def_pref_id, l_plan_type);
127:
128: if (l_round is null) then
129: return 6;
130: end if;

Line 145: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);

141: l_def_pref_id number;
142: l_plan_type number;
143: BEGIN
144: l_plan_type := get_plan_type_for_planlist(arg_plan_list);
145: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
146: l_cat_set_id:= msc_get_name.GET_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
147:
148: return l_cat_set_id;
149: END get_cat_set_id;

Line 146: l_cat_set_id:= msc_get_name.GET_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);

142: l_plan_type number;
143: BEGIN
144: l_plan_type := get_plan_type_for_planlist(arg_plan_list);
145: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
146: l_cat_set_id:= msc_get_name.GET_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
147:
148: return l_cat_set_id;
149: END get_cat_set_id;
150:

Line 518: msc_get_name.execute_dsql(l_sql_stmt);

514:
515: if (arg_viewby = g_plan_viewby) then
516: l_sql_stmt := l_select||l_insert||l_plan_insert||l_from||l_where||l_plan_groupby;
517: put_line('plan view -intermediate'||l_sql_stmt);
518: msc_get_name.execute_dsql(l_sql_stmt);
519: --arg_ret_val := l_seq_id;
520: l_mfq_sql_stmt := l_mfq_select||l_mfq_insert||l_mfq_plan_insert||l_mfq_from||l_mfq_where||l_mfq_plan_groupby;
521: put_line('plan view'||l_mfq_sql_stmt);
522: msc_get_name.execute_dsql(l_mfq_sql_stmt);

Line 522: msc_get_name.execute_dsql(l_mfq_sql_stmt);

518: msc_get_name.execute_dsql(l_sql_stmt);
519: --arg_ret_val := l_seq_id;
520: l_mfq_sql_stmt := l_mfq_select||l_mfq_insert||l_mfq_plan_insert||l_mfq_from||l_mfq_where||l_mfq_plan_groupby;
521: put_line('plan view'||l_mfq_sql_stmt);
522: msc_get_name.execute_dsql(l_mfq_sql_stmt);
523: arg_ret_val := l_seq_id2;
524: return;
525:
526: elsif (arg_viewby = g_org_viewby) then

Line 529: msc_get_name.execute_dsql(l_sql_stmt);

525:
526: elsif (arg_viewby = g_org_viewby) then
527: l_sql_stmt := l_select||l_insert||l_org_insert||l_from||l_where||l_org_groupby;
528: put_line('org view-intermediate'||l_sql_stmt);
529: msc_get_name.execute_dsql(l_sql_stmt);
530: --arg_ret_val := l_seq_id;
531: --return;
532: l_mfq_sql_stmt := l_mfq_select||l_mfq_insert||l_mfq_org_insert||l_mfq_from||l_mfq_where||l_mfq_org_groupby;
533: put_line('org view'||l_mfq_sql_stmt);

Line 534: msc_get_name.execute_dsql(l_mfq_sql_stmt);

530: --arg_ret_val := l_seq_id;
531: --return;
532: l_mfq_sql_stmt := l_mfq_select||l_mfq_insert||l_mfq_org_insert||l_mfq_from||l_mfq_where||l_mfq_org_groupby;
533: put_line('org view'||l_mfq_sql_stmt);
534: msc_get_name.execute_dsql(l_mfq_sql_stmt);
535: arg_ret_val := l_seq_id2;
536: return;
537:
538: elsif (arg_viewby = g_category_viewby) then

Line 541: msc_get_name.execute_dsql(l_sql_stmt);

537:
538: elsif (arg_viewby = g_category_viewby) then
539: l_sql_stmt := l_select||l_insert||l_cate_insert||l_from||l_where||l_cate_groupby;
540: put_line('category view-intermediate'||l_sql_stmt);
541: msc_get_name.execute_dsql(l_sql_stmt);
542: --arg_ret_val := l_seq_id;
543: --return;
544: l_mfq_sql_stmt := l_mfq_select||l_mfq_insert||l_mfq_cate_insert||l_mfq_from||
545: l_mfq_where||l_mfq_cate_groupby;

Line 547: msc_get_name.execute_dsql(l_mfq_sql_stmt);

543: --return;
544: l_mfq_sql_stmt := l_mfq_select||l_mfq_insert||l_mfq_cate_insert||l_mfq_from||
545: l_mfq_where||l_mfq_cate_groupby;
546: put_line('category view'||l_mfq_sql_stmt);
547: msc_get_name.execute_dsql(l_mfq_sql_stmt);
548: arg_ret_val := l_seq_id2;
549: return;
550:
551: elsif (arg_viewby = g_period_viewby) then

Line 554: msc_get_name.execute_dsql(l_sql_stmt);

550:
551: elsif (arg_viewby = g_period_viewby) then
552: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;
553: put_line('period view'||l_sql_stmt);
554: msc_get_name.execute_dsql(l_sql_stmt);
555: arg_ret_val := l_seq_id;
556: return;
557: elsif (arg_viewby = g_week_viewby) then
558: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;

Line 560: msc_get_name.execute_dsql(l_sql_stmt);

556: return;
557: elsif (arg_viewby = g_week_viewby) then
558: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;
559: put_line('week view'||l_sql_stmt);
560: msc_get_name.execute_dsql(l_sql_stmt);
561: arg_ret_val := l_seq_id;
562: return;
563: elsif (arg_viewby = g_plan_org_cate_viewby) then
564: l_sql_stmt := l_select||l_insert||l_plan_org_cate_insert||l_from||l_where||l_plan_org_cate_groupby;

Line 566: msc_get_name.execute_dsql(l_sql_stmt);

562: return;
563: elsif (arg_viewby = g_plan_org_cate_viewby) then
564: l_sql_stmt := l_select||l_insert||l_plan_org_cate_insert||l_from||l_where||l_plan_org_cate_groupby;
565: put_line('plan org cate view-intermediate'||l_sql_stmt);
566: msc_get_name.execute_dsql(l_sql_stmt);
567: --arg_ret_val := l_seq_id;
568: --return;
569: l_mfq_sql_stmt := l_mfq_select||l_mfq_insert||l_mfq_plan_org_cate_insert||
570: l_mfq_from||l_mfq_where||l_mfq_plan_org_cate_groupby;

Line 572: msc_get_name.execute_dsql(l_mfq_sql_stmt);

568: --return;
569: l_mfq_sql_stmt := l_mfq_select||l_mfq_insert||l_mfq_plan_org_cate_insert||
570: l_mfq_from||l_mfq_where||l_mfq_plan_org_cate_groupby;
571: put_line('plan org cate view'||l_mfq_sql_stmt);
572: msc_get_name.execute_dsql(l_mfq_sql_stmt);
573: arg_ret_val := l_seq_id2;
574: return;
575:
576: end if;

Line 930: msc_get_name.execute_dsql(l_sql_stmt);

926: --where clause stmt ends
927: if (arg_viewby = g_plan_viewby) then
928: l_sql_stmt := l_select||l_insert||l_plan_dflt_insert||l_plan_insert||l_from||l_where||l_plan_groupby;
929: put_line(l_sql_stmt);
930: msc_get_name.execute_dsql(l_sql_stmt);
931: arg_ret_val := l_seq_id;
932: return;
933: elsif (arg_viewby = g_org_viewby) then
934: l_sql_stmt := l_select||l_insert||l_org_dflt_insert||l_org_insert||l_from||l_where||l_org_groupby;

Line 936: msc_get_name.execute_dsql(l_sql_stmt);

932: return;
933: elsif (arg_viewby = g_org_viewby) then
934: l_sql_stmt := l_select||l_insert||l_org_dflt_insert||l_org_insert||l_from||l_where||l_org_groupby;
935: put_line('plan view'||l_sql_stmt);
936: msc_get_name.execute_dsql(l_sql_stmt);
937: arg_ret_val := l_seq_id;
938:
939: return;
940: elsif (arg_viewby = g_category_viewby) then

Line 943: msc_get_name.execute_dsql(l_sql_stmt);

939: return;
940: elsif (arg_viewby = g_category_viewby) then
941: l_sql_stmt := l_select||l_insert||l_cate_dflt_insert||l_cate_insert||l_from||l_where||l_cate_groupby;
942: put_line('category view'||l_sql_stmt);
943: msc_get_name.execute_dsql(l_sql_stmt);
944: arg_ret_val := l_seq_id;
945: return;
946: elsif (arg_viewby = g_item_viewby) then
947: l_sql_stmt := l_select||l_insert||l_item_dflt_insert||l_item_insert||l_from||l_where||l_item_groupby;

Line 949: msc_get_name.execute_dsql(l_sql_stmt);

945: return;
946: elsif (arg_viewby = g_item_viewby) then
947: l_sql_stmt := l_select||l_insert||l_item_dflt_insert||l_item_insert||l_from||l_where||l_item_groupby;
948: put_line('item view'||l_sql_stmt);
949: msc_get_name.execute_dsql(l_sql_stmt);
950: arg_ret_val := l_seq_id;
951: return;
952: elsif (arg_viewby = g_demand_class_viewby) then
953: l_sql_stmt := l_select||l_insert||l_demand_class_dflt_insert

Line 956: msc_get_name.execute_dsql(l_sql_stmt);

952: elsif (arg_viewby = g_demand_class_viewby) then
953: l_sql_stmt := l_select||l_insert||l_demand_class_dflt_insert
954: ||l_demand_class_insert||l_from||l_where||l_demand_class_groupby;
955: put_line('demand class'||l_sql_stmt);
956: msc_get_name.execute_dsql(l_sql_stmt);
957: arg_ret_val := l_seq_id;
958: return;
959: elsif (arg_viewby = g_period_viewby) then
960: l_sql_stmt := l_select||l_insert||l_pr_dflt_insert||l_pr_insert||l_from||l_where||l_pr_groupby;

Line 962: msc_get_name.execute_dsql(l_sql_stmt);

958: return;
959: elsif (arg_viewby = g_period_viewby) then
960: l_sql_stmt := l_select||l_insert||l_pr_dflt_insert||l_pr_insert||l_from||l_where||l_pr_groupby;
961: put_line('period view '||l_sql_stmt);
962: msc_get_name.execute_dsql(l_sql_stmt);
963: arg_ret_val := l_seq_id;
964: return;
965: elsif (arg_viewby = g_week_viewby) then
966: l_sql_stmt := l_select||l_insert||l_pr_dflt_insert||l_pr_insert||l_from||l_where||l_pr_groupby;

Line 968: msc_get_name.execute_dsql(l_sql_stmt);

964: return;
965: elsif (arg_viewby = g_week_viewby) then
966: l_sql_stmt := l_select||l_insert||l_pr_dflt_insert||l_pr_insert||l_from||l_where||l_pr_groupby;
967: put_line(' week view '||l_sql_stmt);
968: msc_get_name.execute_dsql(l_sql_stmt);
969: arg_ret_val := l_seq_id;
970: return;
971: end if;
972:

Line 1265: msc_get_name.execute_dsql(l_sql_stmt);

1261: else
1262: l_sql_stmt := l_select||l_insert||l_plan_insert||l_from_maa||l_where|| ' and record_type=4 ' ||l_plan_groupby;
1263: put_line('plan view for plan search only'||l_sql_stmt);
1264: end if;
1265: msc_get_name.execute_dsql(l_sql_stmt);
1266: arg_ret_val := l_seq_id;
1267: return;
1268: elsif (arg_viewby = g_org_viewby) then
1269: l_sql_stmt := l_select||l_insert||l_org_insert||l_from||l_where||l_org_groupby;

Line 1271: msc_get_name.execute_dsql(l_sql_stmt);

1267: return;
1268: elsif (arg_viewby = g_org_viewby) then
1269: l_sql_stmt := l_select||l_insert||l_org_insert||l_from||l_where||l_org_groupby;
1270: put_line('org view '||l_sql_stmt);
1271: msc_get_name.execute_dsql(l_sql_stmt);
1272: arg_ret_val := l_seq_id;
1273: return;
1274: elsif (arg_viewby = g_category_viewby) then
1275: if(arg_org_list <> 'NULL' or arg_category_list <> 'NULL' or arg_year_from is not null or g_perf_profile_on=FALSE) then

Line 1282: msc_get_name.execute_dsql(l_sql_stmt);

1278: else
1279: l_sql_stmt := l_select||l_insert||l_cate_insert||l_from_maa||l_where|| ' and record_type=4 ' ||l_cate_groupby;
1280: put_line('cat view for plan search only '||l_sql_stmt);
1281: end if;
1282: msc_get_name.execute_dsql(l_sql_stmt);
1283: arg_ret_val := l_seq_id;
1284: return;
1285: elsif (arg_viewby = g_item_viewby) then
1286: l_sql_stmt := l_select||l_insert||l_item_insert||l_from||l_where||l_item_groupby;

Line 1288: msc_get_name.execute_dsql(l_sql_stmt);

1284: return;
1285: elsif (arg_viewby = g_item_viewby) then
1286: l_sql_stmt := l_select||l_insert||l_item_insert||l_from||l_where||l_item_groupby;
1287: put_line('item view '||l_sql_stmt);
1288: msc_get_name.execute_dsql(l_sql_stmt);
1289: arg_ret_val := l_seq_id;
1290: return;
1291: elsif (arg_viewby = g_period_viewby) then
1292: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;

Line 1294: msc_get_name.execute_dsql(l_sql_stmt);

1290: return;
1291: elsif (arg_viewby = g_period_viewby) then
1292: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;
1293: put_line('period view '||l_sql_stmt);
1294: msc_get_name.execute_dsql(l_sql_stmt);
1295: arg_ret_val := l_seq_id;
1296: return;
1297: elsif (arg_viewby = g_week_viewby) then
1298: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;

Line 1300: msc_get_name.execute_dsql(l_sql_stmt);

1296: return;
1297: elsif (arg_viewby = g_week_viewby) then
1298: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;
1299: put_line('week view '||l_sql_stmt);
1300: msc_get_name.execute_dsql(l_sql_stmt);
1301: arg_ret_val := l_seq_id;
1302: return;
1303: end if;
1304: arg_ret_val := -99;

Line 1438: l_plan_name := msc_get_name.plan_name(l_plan_id);

1434: FETCH c1 INTO l_plnd_prod_cost, l_plnd_carr_cost, l_plnd_purc_cost, l_plnd_tot_cost,
1435: l_plnd_rev, l_plnd_gross_profit, l_plnd_gross_profit_pct, l_inv_value, l_plan_id,
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;