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_OBJ_ANALYSIS_OPTIONS_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 362: bsc_kpi_analysis_measures_b km,

358: CURSOR c_Is_YTD_Valid(p_AO0 NUMBER,p_AO1 NUMBER, p_AO2 NUMBER) IS
359: SELECT
360: COUNT(1)
361: FROM
362: bsc_kpi_analysis_measures_b km,
363: bsc_sys_dataset_calc bd
364: WHERE
365: km.indicator = p_Indicator AND
366: km.dataset_id = bd.dataset_id AND

Line 457: l_Series_Id bsc_kpi_analysis_measures_b.series_id%TYPE := 0;

453:
454: l_Old_Default_Value bsc_kpi_analysis_groups.default_value%TYPE;
455: l_commit VARCHAR2(1) := FND_API.G_FALSE;
456: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
457: l_Series_Id bsc_kpi_analysis_measures_b.series_id%TYPE := 0;
458: l_Budget_Flag bsc_kpi_analysis_measures_b.budget_flag%TYPE := 1;
459: CURSOR c_Old_Default_Value IS
460: SELECT
461: default_value

Line 458: l_Budget_Flag bsc_kpi_analysis_measures_b.budget_flag%TYPE := 1;

454: l_Old_Default_Value bsc_kpi_analysis_groups.default_value%TYPE;
455: l_commit VARCHAR2(1) := FND_API.G_FALSE;
456: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
457: l_Series_Id bsc_kpi_analysis_measures_b.series_id%TYPE := 0;
458: l_Budget_Flag bsc_kpi_analysis_measures_b.budget_flag%TYPE := 1;
459: CURSOR c_Old_Default_Value IS
460: SELECT
461: default_value
462: FROM

Line 471: bsc_kpi_analysis_Measures_b

467: CURSOR c_Default_Series_Id (p_AO0 NUMBER, p_AO1 NUMBER, p_AO2 NUMBER) IS
468: SELECT
469: series_id,budget_flag
470: FROM
471: bsc_kpi_analysis_Measures_b
472: WHERE
473: analysis_option0 = p_AO0 AND
474: analysis_option1 = p_AO1 AND
475: analysis_option2 = p_AO2 AND

Line 964: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;

960: ,x_return_status OUT NOCOPY VARCHAR2
961: ,x_msg_count OUT NOCOPY NUMBER
962: ,x_msg_data OUT NOCOPY VARCHAR2
963: ) IS
964: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
965: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;
966: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;
967:
968: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

Line 965: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;

961: ,x_msg_count OUT NOCOPY NUMBER
962: ,x_msg_data OUT NOCOPY VARCHAR2
963: ) IS
964: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
965: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;
966: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;
967:
968: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
969: l_Bsc_AnaOpt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

Line 966: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;

962: ,x_msg_data OUT NOCOPY VARCHAR2
963: ) IS
964: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
965: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;
966: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;
967:
968: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
969: l_Bsc_AnaOpt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
970: l_Count NUMBER := 0;

Line 979: l_old_data_set_id bsc_kpi_analysis_measures_b.dataset_id%TYPE;

975: l_config_type bsc_kpis_b.config_type%TYPE;
976: l_indicator_type bsc_kpis_b.indicator_type%TYPE;
977:
978: l_old_DimSet_id bsc_kpi_analysis_options_b.dim_set_id%TYPE;
979: l_old_data_set_id bsc_kpi_analysis_measures_b.dataset_id%TYPE;
980:
981: l_temp_Parent_Id NUMBER := NULL;
982: l_temp_GrandParent_Id NUMBER := NULL;
983: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

Line 996: BSC_KPI_ANALYSIS_MEASURES_B

992: CURSOR c_old_data_set_id(p_AO0 VARCHAR2, p_AO1 VARCHAR2, p_AO2 VARCHAR2) IS
993: SELECT
994: dataset_id
995: FROM
996: BSC_KPI_ANALYSIS_MEASURES_B
997: WHERE indicator = p_Indicator
998: AND analysis_option0 = p_AO0
999: AND analysis_option1 = p_AO1
1000: AND analysis_option2 = p_AO2;

Line 1599: l_sql := 'DELETE FROM bsc_kpi_analysis_measures_b ' || l_criteria;

1595: l_criteria := l_criteria || ' AND analysis_option'|| p_Grandparent_Group_Id || ' = '|| l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id;
1596: END IF;
1597: END IF;
1598:
1599: l_sql := 'DELETE FROM bsc_kpi_analysis_measures_b ' || l_criteria;
1600: BSC_APPS.Execute_Immediate(l_sql);
1601:
1602: l_sql := 'DELETE FROM bsc_kpi_analysis_measures_tl ' || l_criteria;
1603: BSC_APPS.Execute_Immediate(l_sql);

Line 1705: l_sql := 'UPDATE bsc_kpi_analysis_measures_b SET analysis_option'|| p_Anal_Opt_Rec.Bsc_Analysis_Group_Id || '=' || l_cur_index;

1701: END IF;
1702: END IF;
1703:
1704: IF l_option_id <> l_cur_index THEN
1705: l_sql := 'UPDATE bsc_kpi_analysis_measures_b SET analysis_option'|| p_Anal_Opt_Rec.Bsc_Analysis_Group_Id || '=' || l_cur_index;
1706: l_sql := l_sql || l_criteria_measures;
1707: BSC_APPS.Execute_Immediate(l_sql);
1708:
1709: l_sql := 'UPDATE bsc_kpi_analysis_measures_tl SET analysis_option'|| p_Anal_Opt_Rec.Bsc_Analysis_Group_Id || '=' || l_cur_index;

Line 2739: -- This API generates entries in bsc_kpi_analysis_measures by taking into

2735: /************************************************************************************
2736: -- API name : Generate_Analysis_Meas_Combs
2737: -- Type : Public
2738: -- Function :
2739: -- This API generates entries in bsc_kpi_analysis_measures by taking into
2740: -- consideration the dependency relationships between groups
2741: -- This is specially required when the groups have an independent relationship
2742: --
2743: ************************************************************************************/

Line 2771: bsc_kpi_analysis_measures_b

2767: CURSOR c_Exists_Ana_Opt IS
2768: SELECT
2769: COUNT(1)
2770: FROM
2771: bsc_kpi_analysis_measures_b
2772: WHERE
2773: indicator = p_Indicator AND
2774: analysis_option0 = p_Analysis_Option0 AND
2775: analysis_option1 = p_Analysis_Option1 AND

Line 2996: l_Analysis_Opt0 bsc_kpi_analysis_measures_b.Analysis_Option0%TYPE := 0;

2992: ,x_return_status OUT NOCOPY VARCHAR2
2993: ,x_msg_count OUT NOCOPY NUMBER
2994: ,x_msg_data OUT NOCOPY VARCHAR2
2995: )IS
2996: l_Analysis_Opt0 bsc_kpi_analysis_measures_b.Analysis_Option0%TYPE := 0;
2997: l_Analysis_Opt1 bsc_kpi_analysis_measures_b.Analysis_Option1%TYPE := 0;
2998: l_Analysis_Opt2 bsc_kpi_analysis_measures_b.Analysis_Option2%TYPE := 0;
2999:
3000: l_Dependency_01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

Line 2997: l_Analysis_Opt1 bsc_kpi_analysis_measures_b.Analysis_Option1%TYPE := 0;

2993: ,x_msg_count OUT NOCOPY NUMBER
2994: ,x_msg_data OUT NOCOPY VARCHAR2
2995: )IS
2996: l_Analysis_Opt0 bsc_kpi_analysis_measures_b.Analysis_Option0%TYPE := 0;
2997: l_Analysis_Opt1 bsc_kpi_analysis_measures_b.Analysis_Option1%TYPE := 0;
2998: l_Analysis_Opt2 bsc_kpi_analysis_measures_b.Analysis_Option2%TYPE := 0;
2999:
3000: l_Dependency_01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3001: l_Dependency_12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

Line 2998: l_Analysis_Opt2 bsc_kpi_analysis_measures_b.Analysis_Option2%TYPE := 0;

2994: ,x_msg_data OUT NOCOPY VARCHAR2
2995: )IS
2996: l_Analysis_Opt0 bsc_kpi_analysis_measures_b.Analysis_Option0%TYPE := 0;
2997: l_Analysis_Opt1 bsc_kpi_analysis_measures_b.Analysis_Option1%TYPE := 0;
2998: l_Analysis_Opt2 bsc_kpi_analysis_measures_b.Analysis_Option2%TYPE := 0;
2999:
3000: l_Dependency_01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3001: l_Dependency_12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3002: l_commit VARCHAR2(2) := FND_API.G_FALSE;

Line 3448: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE := NULL;

3444: TYPE c_ref_cursor IS REF CURSOR;
3445: c_Weighted_Kpi c_ref_cursor;
3446: c_kpi_full_name c_ref_cursor;
3447: c_NumOptions c_ref_cursor;
3448: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE := NULL;
3449: l_kpi_full_name VARCHAR2(1024) := NULL;
3450: l_NumOptions NUMBER := 0;
3451: l_criteria VARCHAR2(2000);
3452: l_sql VARCHAR2(2000);

Line 3552: l_sql := l_sql || ' AND weight > 0 INTERSECT SELECT kpi_measure_id FROM bsc_kpi_analysis_measures_b ';

3548: l_criteria := l_criteria || ' AND analysis_option'|| l_GrandParent_Group_Id || ' = '|| l_GrandParent_Id;
3549: END IF;
3550: END IF;
3551: l_sql := 'SELECT kpi_measure_id FROM bsc_kpi_measure_weights WHERE indicator = ' || p_Indicator;
3552: l_sql := l_sql || ' AND weight > 0 INTERSECT SELECT kpi_measure_id FROM bsc_kpi_analysis_measures_b ';
3553: l_sql := l_sql || l_criteria;
3554:
3555: OPEN c_Weighted_Kpi FOR l_sql;
3556: FETCH c_Weighted_Kpi INTO l_kpi_measure_id;

Line 3684: bsc_kpi_analysis_measures_b

3680: CURSOR c_dataset_id(p_AO0 NUMBER , p_AO1 NUMBER, p_AO2 NUMBER) IS
3681: SELECT
3682: dataset_id
3683: FROM
3684: bsc_kpi_analysis_measures_b
3685: WHERE
3686: indicator = p_Indicator AND
3687: analysis_option0 = p_AO0 AND
3688: analysis_option1 = p_AO1 AND

Line 3695: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;

3691:
3692: l_Indicator_Type bsc_kpis_b.indicator_type%TYPE;
3693: l_Is_Leaf_Node VARCHAR2(1);
3694: l_Next_Group_Id NUMBER;
3695: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;
3696: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;
3697: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;
3698: l_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;
3699: -- l_source bsc_sys_datasets_b.source%TYPE;

Line 3696: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;

3692: l_Indicator_Type bsc_kpis_b.indicator_type%TYPE;
3693: l_Is_Leaf_Node VARCHAR2(1);
3694: l_Next_Group_Id NUMBER;
3695: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;
3696: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;
3697: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;
3698: l_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;
3699: -- l_source bsc_sys_datasets_b.source%TYPE;
3700:

Line 3697: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;

3693: l_Is_Leaf_Node VARCHAR2(1);
3694: l_Next_Group_Id NUMBER;
3695: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;
3696: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;
3697: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;
3698: l_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;
3699: -- l_source bsc_sys_datasets_b.source%TYPE;
3700:
3701: BEGIN

Line 3791: bsc_kpi_analysis_measures_b

3787: CURSOR c_Series_Default_Plan(p_AO0 NUMBER, p_AO1 NUMBER, p_AO2 NUMBER) IS
3788: SELECT
3789: COUNT(1)
3790: FROM
3791: bsc_kpi_analysis_measures_b
3792: WHERE
3793: indicator = p_indicator AND
3794: analysis_option0 = p_AO0 AND
3795: analysis_option1 = p_AO1 AND

Line 4219: bsc_kpi_analysis_measures_b

4215: CURSOR c_kpi_measure_id(p_AO0 NUMBER , p_AO1 NUMBER, p_AO2 NUMBER) IS
4216: SELECT
4217: kpi_measure_id
4218: FROM
4219: bsc_kpi_analysis_measures_b
4220: WHERE
4221: indicator = p_Indicator AND
4222: analysis_option0 = p_AO0 AND
4223: analysis_option1 = p_AO1 AND

Line 4229: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;

4225: series_id = 0;
4226:
4227: l_Indicator_Type bsc_kpis_b.indicator_type%TYPE;
4228: l_Next_Group_Id NUMBER;
4229: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;
4230: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;
4231: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;
4232: l_kpi_measure_id bsc_sys_datasets_b.dataset_id%TYPE;
4233: l_Property_Value NUMBER;

Line 4230: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;

4226:
4227: l_Indicator_Type bsc_kpis_b.indicator_type%TYPE;
4228: l_Next_Group_Id NUMBER;
4229: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;
4230: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;
4231: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;
4232: l_kpi_measure_id bsc_sys_datasets_b.dataset_id%TYPE;
4233: l_Property_Value NUMBER;
4234:

Line 4231: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;

4227: l_Indicator_Type bsc_kpis_b.indicator_type%TYPE;
4228: l_Next_Group_Id NUMBER;
4229: l_AO0 bsc_kpi_analysis_measures_b.analysis_option0%TYPE := 0;
4230: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE := 0;
4231: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE := 0;
4232: l_kpi_measure_id bsc_sys_datasets_b.dataset_id%TYPE;
4233: l_Property_Value NUMBER;
4234:
4235: BEGIN

Line 4276: bsc_kpi_analysis_measures_b

4272: dataset_id
4273: INTO
4274: l_Property_Value
4275: FROM
4276: bsc_kpi_analysis_measures_b
4277: WHERE
4278: indicator = p_Indicator
4279: AND kpi_measure_id = l_kpi_measure_id;
4280: ELSIF p_Property_Name = 'DEFAULT_CALCULATION' THEN