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 519: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 523: msc_get_name.execute_dsql(l_mfq_sql_stmt);

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

Line 530: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 535: msc_get_name.execute_dsql(l_mfq_sql_stmt);

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

Line 542: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 548: msc_get_name.execute_dsql(l_mfq_sql_stmt);

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

Line 555: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 561: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 567: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 573: msc_get_name.execute_dsql(l_mfq_sql_stmt);

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

Line 931: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 937: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 944: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 950: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 957: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 963: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 969: msc_get_name.execute_dsql(l_sql_stmt);

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

Line 1251: msc_get_name.execute_dsql(l_sql_stmt);

1247:
1248: if (arg_viewby = g_plan_viewby) then
1249: l_sql_stmt := l_select||l_insert||l_plan_insert||l_from||l_where||l_plan_groupby;
1250: put_line('plan view '||l_sql_stmt);
1251: msc_get_name.execute_dsql(l_sql_stmt);
1252: arg_ret_val := l_seq_id;
1253: return;
1254: elsif (arg_viewby = g_org_viewby) then
1255: l_sql_stmt := l_select||l_insert||l_org_insert||l_from||l_where||l_org_groupby;

Line 1257: msc_get_name.execute_dsql(l_sql_stmt);

1253: return;
1254: elsif (arg_viewby = g_org_viewby) then
1255: l_sql_stmt := l_select||l_insert||l_org_insert||l_from||l_where||l_org_groupby;
1256: put_line('org view '||l_sql_stmt);
1257: msc_get_name.execute_dsql(l_sql_stmt);
1258: arg_ret_val := l_seq_id;
1259: return;
1260: elsif (arg_viewby = g_category_viewby) then
1261: l_sql_stmt := l_select||l_insert||l_cate_insert||l_from||l_where||l_cate_groupby;

Line 1263: msc_get_name.execute_dsql(l_sql_stmt);

1259: return;
1260: elsif (arg_viewby = g_category_viewby) then
1261: l_sql_stmt := l_select||l_insert||l_cate_insert||l_from||l_where||l_cate_groupby;
1262: put_line('cat view '||l_sql_stmt);
1263: msc_get_name.execute_dsql(l_sql_stmt);
1264: arg_ret_val := l_seq_id;
1265: return;
1266: elsif (arg_viewby = g_item_viewby) then
1267: l_sql_stmt := l_select||l_insert||l_item_insert||l_from||l_where||l_item_groupby;

Line 1269: msc_get_name.execute_dsql(l_sql_stmt);

1265: return;
1266: elsif (arg_viewby = g_item_viewby) then
1267: l_sql_stmt := l_select||l_insert||l_item_insert||l_from||l_where||l_item_groupby;
1268: put_line('item view '||l_sql_stmt);
1269: msc_get_name.execute_dsql(l_sql_stmt);
1270: arg_ret_val := l_seq_id;
1271: return;
1272: elsif (arg_viewby = g_period_viewby) then
1273: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;

Line 1275: msc_get_name.execute_dsql(l_sql_stmt);

1271: return;
1272: elsif (arg_viewby = g_period_viewby) then
1273: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;
1274: put_line('period view '||l_sql_stmt);
1275: msc_get_name.execute_dsql(l_sql_stmt);
1276: arg_ret_val := l_seq_id;
1277: return;
1278: elsif (arg_viewby = g_week_viewby) then
1279: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;

Line 1281: msc_get_name.execute_dsql(l_sql_stmt);

1277: return;
1278: elsif (arg_viewby = g_week_viewby) then
1279: l_sql_stmt := l_select||l_insert||l_pr_insert||l_from||l_where||l_pr_groupby;
1280: put_line('week view '||l_sql_stmt);
1281: msc_get_name.execute_dsql(l_sql_stmt);
1282: arg_ret_val := l_seq_id;
1283: return;
1284: end if;
1285: arg_ret_val := -99;

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

1427: FETCH c1 INTO l_plnd_prod_cost, l_plnd_carr_cost, l_plnd_purc_cost, l_plnd_tot_cost,
1428: l_plnd_rev, l_plnd_gross_profit, l_plnd_gross_profit_pct, l_inv_value, l_plan_id,
1429: l_ext_repair_cost, l_int_repair_cost;
1430: EXIT WHEN c1%NOTFOUND;
1431: l_plan_name := msc_get_name.plan_name(l_plan_id);
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: