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_KPIS_B

Line 40: bsc_kpis_b

36: CURSOR c_shared_objs IS
37: SELECT
38: indicator
39: FROM
40: bsc_kpis_b
41: WHERE
42: source_indicator = p_Indicator AND
43: prototype_flag <> 2 AND
44: share_flag = 2;

Line 483: bsc_kpis_b

479: CURSOR c_shared_objs IS
480: SELECT
481: indicator
482: FROM
483: bsc_kpis_b
484: WHERE
485: source_indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND
486: prototype_flag <> 2 AND
487: share_flag = 2;

Line 875: bsc_kpis_b

871: CURSOR c_shared_objs IS
872: SELECT
873: indicator
874: FROM
875: bsc_kpis_b
876: WHERE
877: source_indicator = p_Indicator AND
878: prototype_flag <> 2 AND
879: share_flag = 2;

Line 975: l_config_type bsc_kpis_b.config_type%TYPE;

971: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := 0;
972: l_Measure_Source bsc_sys_datasets_vl.source%TYPE;
973: l_commit VARCHAR2(2) := FND_API.G_FALSE;
974:
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;

Line 976: l_indicator_type bsc_kpis_b.indicator_type%TYPE;

972: l_Measure_Source bsc_sys_datasets_vl.source%TYPE;
973: l_commit VARCHAR2(2) := FND_API.G_FALSE;
974:
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:

Line 1017: bsc_kpis_b

1013: CURSOR c_shared_objs IS
1014: SELECT
1015: indicator
1016: FROM
1017: bsc_kpis_b
1018: WHERE
1019: source_indicator = p_Indicator AND
1020: prototype_flag <> 2 AND
1021: share_flag = 2;

Line 1028: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1024: SAVEPOINT Update_Analayis_Option_PUB;
1025: -- Check that the indicator id passed is Valid
1026: IF NOT FND_API.To_Boolean(p_Create_Flow) THEN
1027: IF p_Indicator IS NOT NULL THEN
1028: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1029: ,'indicator'
1030: , p_Indicator);
1031: IF l_Count = 0 THEN
1032: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1058: FROM bsc_kpis_b

1054: END IF;
1055:
1056: SELECT indicator_type,config_type
1057: INTO l_indicator_type,l_config_type
1058: FROM bsc_kpis_b
1059: WHERE indicator = p_Indicator;
1060:
1061: IF NOT FND_API.To_Boolean(p_Create_Flow) THEN
1062: Get_Current_Dim_DataSet_Map (

Line 1915: bsc_kpis_b

1911: CURSOR c_shared_objs IS
1912: SELECT
1913: indicator
1914: FROM
1915: bsc_kpis_b
1916: WHERE
1917: source_indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND
1918: prototype_flag <> 2 AND
1919: share_flag = 2;

Line 2335: bsc_kpis_b

2331: CURSOR c_Shared_Objs IS
2332: SELECT
2333: indicator
2334: FROM
2335: bsc_kpis_b
2336: WHERE
2337: source_indicator = p_Indicator AND
2338: prototype_flag <> 2 AND
2339: share_flag = 2;

Line 2345: bsc_kpis_b kpi,

2341: CURSOR c_imported_dims IS
2342: SELECT
2343: kpi_dim.dim_set_id
2344: FROM
2345: bsc_kpis_b kpi,
2346: bsc_kpi_dim_groups kpi_dim,
2347: bsc_sys_dim_groups_vl sys_dim,
2348: bsc_kpi_analysis_options_b kpi_opt
2349: WHERE

Line 2362: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2358: BEGIN
2359: SAVEPOINT Delete_Analysis_Opt_UI_PVT;
2360: -- Check that the indicator id passed is Valid
2361: IF p_Indicator IS NOT NULL THEN
2362: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2363: ,'indicator'
2364: , p_Indicator);
2365: IF l_Count = 0 THEN
2366: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3158: bsc_kpis_b

3154: CURSOR c_shared_objs IS
3155: SELECT
3156: indicator
3157: FROM
3158: bsc_kpis_b
3159: WHERE
3160: source_indicator = p_Indicator AND
3161: prototype_flag <> 2 AND
3162: share_flag = 2;

Line 3169: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3165: BEGIN
3166: SAVEPOINT Create_Analayis_OptionObjPUB;
3167: -- Check that the indicator id passed is Valid
3168: IF p_Indicator IS NOT NULL THEN
3169: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3170: ,'indicator'
3171: , p_Indicator);
3172: IF l_Count = 0 THEN
3173: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3677: bsc_kpis_b

3673: CURSOR c_Indicator_Type IS
3674: SELECT
3675: indicator_type
3676: FROM
3677: bsc_kpis_b
3678: WHERE indicator = p_Indicator;
3679:
3680: CURSOR c_dataset_id(p_AO0 NUMBER , p_AO1 NUMBER, p_AO2 NUMBER) IS
3681: SELECT

Line 3692: l_Indicator_Type bsc_kpis_b.indicator_type%TYPE;

3688: analysis_option1 = p_AO1 AND
3689: analysis_option2 = p_AO2 AND
3690: series_id = 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;

Line 3756: bsc_kpis_b bk, bsc_sys_bm_groups bg,bsc_sys_benchmarks_b be

3752: CURSOR c_Ind_BenchMark_Grp IS
3753: SELECT
3754: bk.bm_group_id
3755: FROM
3756: bsc_kpis_b bk, bsc_sys_bm_groups bg,bsc_sys_benchmarks_b be
3757: WHERE
3758: bk.bm_group_id = bg.bm_group_id AND
3759: be.bm_id = bg.bm_id AND
3760: be.data_type = 1 AND

Line 3840: bsc_kpis_b

3836: CURSOR c_Kpi_Info IS
3837: SELECT
3838: indicator_type,config_type
3839: FROM
3840: bsc_kpis_b
3841: WHERE
3842: indicator = p_Indicator;
3843:
3844: CURSOR c_All_KPIs IS

Line 3848: bsc_kpis_b

3844: CURSOR c_All_KPIs IS
3845: SELECT
3846: indicator
3847: FROM
3848: bsc_kpis_b
3849: WHERE
3850: indicator = p_Indicator OR
3851: (source_indicator = p_Indicator AND prototype_flag <> 2);
3852: l_indicator_type bsc_kpis_b.indicator_type%TYPE;

Line 3852: l_indicator_type bsc_kpis_b.indicator_type%TYPE;

3848: bsc_kpis_b
3849: WHERE
3850: indicator = p_Indicator OR
3851: (source_indicator = p_Indicator AND prototype_flag <> 2);
3852: l_indicator_type bsc_kpis_b.indicator_type%TYPE;
3853: l_config_type bsc_kpis_b.config_type%TYPE;
3854: l_apply_color bsc_kpis_b.apply_color_flag%TYPE;
3855: BEGIN
3856: SAVEPOINT Set_Apply_Color_PVT;

Line 3853: l_config_type bsc_kpis_b.config_type%TYPE;

3849: WHERE
3850: indicator = p_Indicator OR
3851: (source_indicator = p_Indicator AND prototype_flag <> 2);
3852: l_indicator_type bsc_kpis_b.indicator_type%TYPE;
3853: l_config_type bsc_kpis_b.config_type%TYPE;
3854: l_apply_color bsc_kpis_b.apply_color_flag%TYPE;
3855: BEGIN
3856: SAVEPOINT Set_Apply_Color_PVT;
3857: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3854: l_apply_color bsc_kpis_b.apply_color_flag%TYPE;

3850: indicator = p_Indicator OR
3851: (source_indicator = p_Indicator AND prototype_flag <> 2);
3852: l_indicator_type bsc_kpis_b.indicator_type%TYPE;
3853: l_config_type bsc_kpis_b.config_type%TYPE;
3854: l_apply_color bsc_kpis_b.apply_color_flag%TYPE;
3855: BEGIN
3856: SAVEPOINT Set_Apply_Color_PVT;
3857: x_return_status := FND_API.G_RET_STS_SUCCESS;
3858: FND_MSG_PUB.Initialize;

Line 3877: UPDATE bsc_kpis_b

3873: NULL;
3874: END IF;
3875: END IF;
3876: FOR cd in c_All_KPIs LOOP
3877: UPDATE bsc_kpis_b
3878: SET apply_color_flag = l_apply_color
3879: WHERE indicator = cd.indicator;
3880:
3881: BSC_DESIGNER_PVT.ActionFlag_Change (

Line 4212: bsc_kpis_b

4208: CURSOR c_Indicator_Type IS
4209: SELECT
4210: indicator_type
4211: FROM
4212: bsc_kpis_b
4213: WHERE indicator = p_Indicator;
4214:
4215: CURSOR c_kpi_measure_id(p_AO0 NUMBER , p_AO1 NUMBER, p_AO2 NUMBER) IS
4216: SELECT

Line 4227: l_Indicator_Type bsc_kpis_b.indicator_type%TYPE;

4223: analysis_option1 = p_AO1 AND
4224: analysis_option2 = p_AO2 AND
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;