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.BSC_KPI_SERIES_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 31: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;

27: ,x_msg_data OUT NOCOPY VARCHAR2
28: ) IS
29:
30: l_kpi_measure_props_rec bsc_kpi_measure_props_pub.kpi_measure_props_rec;
31: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
32: l_A0_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
33: l_A1_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
34: l_A2_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
35: l_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';

Line 32: l_A0_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;

28: ) IS
29:
30: l_kpi_measure_props_rec bsc_kpi_measure_props_pub.kpi_measure_props_rec;
31: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
32: l_A0_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
33: l_A1_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
34: l_A2_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
35: l_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';
36:

Line 33: l_A1_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;

29:
30: l_kpi_measure_props_rec bsc_kpi_measure_props_pub.kpi_measure_props_rec;
31: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
32: l_A0_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
33: l_A1_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
34: l_A2_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
35: l_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';
36:
37: CURSOR c_kpi_measure_id IS

Line 34: l_A2_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;

30: l_kpi_measure_props_rec bsc_kpi_measure_props_pub.kpi_measure_props_rec;
31: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
32: l_A0_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
33: l_A1_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
34: l_A2_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
35: l_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';
36:
37: CURSOR c_kpi_measure_id IS
38: SELECT

Line 41: bsc_kpi_analysis_measures_b km

37: CURSOR c_kpi_measure_id IS
38: SELECT
39: km.kpi_measure_id
40: FROM
41: bsc_kpi_analysis_measures_b km
42: WHERE km.indicator = p_Indicator AND
43: km.analysis_option0 = p_Analysis_Option0 AND
44: km.analysis_option1 = p_Analysis_Option1 AND
45: km.analysis_option2 = p_Analysis_Option2 AND

Line 182: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;

178: ,x_msg_data OUT NOCOPY VARCHAR2
179: ) IS
180:
181: l_kpi_measure_props_rec bsc_kpi_measure_props_pub.kpi_measure_props_rec;
182: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
183: l_color_rollup_type bsc_kpis_b.color_rollup_type%TYPE;
184:
185: CURSOR c_kpi_measure_id IS
186: SELECT

Line 189: bsc_kpi_analysis_measures_b km

185: CURSOR c_kpi_measure_id IS
186: SELECT
187: km.kpi_measure_id
188: FROM
189: bsc_kpi_analysis_measures_b km
190: WHERE km.indicator = p_Indicator AND
191: km.analysis_option0 = p_Analysis_Option0 AND
192: km.analysis_option1 = p_Analysis_Option1 AND
193: km.analysis_option2 = p_Analysis_Option2 AND

Line 336: l_First_Series_Id bsc_kpi_analysis_measures_b.series_id%TYPE := 0;

332:
333: l_AnaOpt0_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
334: l_AnaOpt1_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
335: l_AnaOpt2_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
336: l_First_Series_Id bsc_kpi_analysis_measures_b.series_id%TYPE := 0;
337:
338: CURSOR c_Preselected_Series(p_Analysis_Option0 NUMBER,p_Analysis_Option1 NUMBER,p_Analysis_Option2 NUMBER) IS
339: SELECT
340: series_id

Line 342: bsc_kpi_analysis_measures_b

338: CURSOR c_Preselected_Series(p_Analysis_Option0 NUMBER,p_Analysis_Option1 NUMBER,p_Analysis_Option2 NUMBER) IS
339: SELECT
340: series_id
341: FROM
342: bsc_kpi_analysis_measures_b
343: WHERE
344: indicator = p_Indicator AND
345: analysis_option0 = p_Analysis_Option0 AND
346: analysis_option1 = p_Analysis_Option1 AND

Line 367: bsc_kpi_analysis_measures_b

363:
364: OPEN c_Preselected_Series (l_AnaOpt0_Default,l_AnaOpt1_Default,l_AnaOpt2_Default);
365: FETCH c_Preselected_Series INTO l_First_Series_Id;
366: UPDATE
367: bsc_kpi_analysis_measures_b
368: SET
369: default_value = 0
370: WHERE indicator = p_Indicator AND
371: analysis_option0 = l_AnaOpt0_Default AND

Line 377: bsc_kpi_analysis_measures_b

373: analysis_option2 = l_AnaOpt2_Default AND
374: series_id <> l_First_Series_Id;
375:
376: UPDATE
377: bsc_kpi_analysis_measures_b
378: SET
379: default_value = 1
380: WHERE indicator = p_Indicator AND
381: analysis_option0 = l_AnaOpt0_Default AND

Line 487: l_Color_Value bsc_kpi_analysis_measures_b.series_color%TYPE := 0;

483: p_Color_Values IN FND_TABLE_OF_NUMBER := NULL
484: ,p_Get_Actual_Color IN VARCHAR2 := FND_API.G_TRUE
485: ) RETURN NUMBER IS
486:
487: l_Color_Value bsc_kpi_analysis_measures_b.series_color%TYPE := 0;
488: l_bm_id bsc_sys_benchmarks_b.bm_id%TYPE;
489: i NUMBER := 0;
490: found BOOLEAN := FALSE;
491: BEGIN

Line 544: l_old_default_kpi bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;

540: ) IS
541: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
542: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
543: l_Count NUMBER := 0;
544: l_old_default_kpi bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
545:
546: CURSOR c_shared_objs IS
547: SELECT
548: indicator

Line 792: l_old_default_kpi bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;

788: l_Count NUMBER := 0;
789: l_Measure_Source bsc_sys_datasets_vl.source%TYPE;
790: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := 0;
791: l_Option_Name bsc_kpi_analysis_options_vl.name%TYPE;
792: l_old_default_kpi bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
793:
794: CURSOR c_shared_objs IS
795: SELECT
796: indicator

Line 1082: l_old_default_kpi bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;

1078: ) IS
1079: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1080: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1081: l_Count NUMBER := 0;
1082: l_old_default_kpi bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1083: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1084: l_Reset_Default BOOLEAN := FALSE;
1085:
1086: CURSOR c_shared_objs IS

Line 1083: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;

1079: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1080: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1081: l_Count NUMBER := 0;
1082: l_old_default_kpi bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1083: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1084: l_Reset_Default BOOLEAN := FALSE;
1085:
1086: CURSOR c_shared_objs IS
1087: SELECT

Line 1131: bsc_kpi_analysis_measures_b

1127: kpi_measure_id
1128: INTO
1129: l_kpi_measure_id
1130: FROM
1131: bsc_kpi_analysis_measures_b
1132: WHERE
1133: indicator = p_Indicator AND
1134: analysis_option0 = p_Analysis_Option0 AND
1135: analysis_option1 = p_Analysis_Option1 AND

Line 1502: l_Series_DataSet_Id bsc_kpi_analysis_measures_b.dataset_id%TYPE;

1498: l_All_Comb_Map_Old Bsc_Dim_Dataset_Table;
1499: l_All_Comb_Map_New Bsc_Dim_Dataset_Table;
1500: l_AO_Comb_Map Bsc_Dim_Dataset_Table;
1501:
1502: l_Series_DataSet_Id bsc_kpi_analysis_measures_b.dataset_id%TYPE;
1503: l_Series_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE;
1504: l_Combination_Cnt NUMBER;
1505: l_Found BOOLEAN;
1506: i NUMBER;