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.

[Home] [Help]

APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 161: bsc_kpi_dim_levels_b kd,

157: d.dim_level_id
158: INTO
159: l_dim_level_id
160: FROM
161: bsc_kpi_dim_levels_b kd,
162: bsc_sys_dim_levels_b d
163: WHERE
164: kd.indicator = p_indicator
165: AND kd.level_table_name = d.level_table_name

Line 174: --Update bsc_kpi_dim_levels_b with the default_key_value

170: l_Dim_Set_Rec.Bsc_Dim_Set_Id := p_dim_set_id;
171: l_Dim_Set_Rec.Bsc_Level_Name := p_level_table_name;
172: l_Dim_Set_Rec.Bsc_Level_Id := l_dim_level_id;
173:
174: --Update bsc_kpi_dim_levels_b with the default_key_value
175: BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels (
176: p_Dim_Set_Rec => l_Dim_Set_Rec
177: ,x_Dim_Set_Rec => l_Dim_Set_Rec
178: ,x_return_status => x_return_status

Line 414: FROM BSC_KPI_DIM_LEVELS_B

410: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id;
411: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id;
412:
413: SELECT COUNT(*) INTO l_Count
414: FROM BSC_KPI_DIM_LEVELS_B
415: WHERE Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
416: AND Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
417: IF (l_Count = 0) THEN
418: -- Bug #3343860 if l_Count = 0, it means create default entry in BSC_KPI_DIM_LEVELS_B

Line 418: -- Bug #3343860 if l_Count = 0, it means create default entry in BSC_KPI_DIM_LEVELS_B

414: FROM BSC_KPI_DIM_LEVELS_B
415: WHERE Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
416: AND Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
417: IF (l_Count = 0) THEN
418: -- Bug #3343860 if l_Count = 0, it means create default entry in BSC_KPI_DIM_LEVELS_B
419: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Grp_Lev_In_Dset
420: ( p_commit => FND_API.G_FALSE
421: , p_kpi_id => l_bsc_dimset_rec.Bsc_Kpi_Id
422: , p_dim_set_id => l_bsc_dimset_rec.Bsc_Dim_Set_Id

Line 522: --remove the default entry 'XXX' from BSC_KPI_DIM_LEVELS_B if exists

518:
519: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id;
520: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id;
521:
522: --remove the default entry 'XXX' from BSC_KPI_DIM_LEVELS_B if exists
523: BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels
524: ( p_commit => FND_API.G_FALSE
525: , p_Dim_Set_Rec => l_bsc_dimset_rec
526: , x_return_status => x_return_status

Line 1737: FROM BSC_KPI_DIM_LEVELS_B

1733: Check no of independent dimension objects in dimension set
1734: ********************************************************/
1735:
1736: SELECT COUNT(0) INTO l_count_independent_dim_obj
1737: FROM BSC_KPI_DIM_LEVELS_B
1738: WHERE INDICATOR = p_kpi_id
1739: AND DIM_SET_ID = l_bsc_dimset_rec.bsc_dim_set_id;
1740:
1741: IF(l_count_independent_dim_obj > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

Line 1892: FROM BSC_KPI_DIM_LEVELS_B

1888: Check no of independent dimension objects in dimension set
1889: ********************************************************/
1890:
1891: SELECT COUNT(0) INTO l_count_independent_dim_obj
1892: FROM BSC_KPI_DIM_LEVELS_B
1893: WHERE INDICATOR = p_kpi_id
1894: AND DIM_SET_ID = p_dim_set_id;
1895:
1896: IF(l_count_independent_dim_obj > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

Line 2597: bsc_kpi_dim_levels_b

2593: CURSOR c_Dim_Levels IS
2594: SELECT
2595: level_table_name
2596: FROM
2597: bsc_kpi_dim_levels_b
2598: WHERE
2599: indicator = p_kpi_id
2600: AND dim_set_id = p_dim_set_id
2601: INTERSECT

Line 2630: bsc_kpi_dim_levels_b

2626: BULK COLLECT INTO
2627: l_level_table_names,
2628: l_key_item_values
2629: FROM
2630: bsc_kpi_dim_levels_b
2631: WHERE
2632: indicator = p_kpi_id
2633: AND dim_set_id = p_dim_set_id
2634: AND default_key_value IS NOT NULL;

Line 2644: --BSC_KPI_DIM_LEVELS_B.indicator

2640: INTO l_count
2641: FROM BSC_KPIS_B
2642: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
2643: IF (l_count <> 2) THEN
2644: --BSC_KPI_DIM_LEVELS_B.indicator
2645: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id; --number
2646: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Dim_Set_Id <'||l_bsc_dimset_rec.Bsc_Dim_Set_Id||'>');
2647: -- BSC_KPI_DIM_LEVELS_TL.total_disp_name
2648: l_bsc_dimset_rec.Bsc_New_Dset := 'N'; --varchar2(45)

Line 2663: --remove the default entry 'XXX' from BSC_KPI_DIM_LEVELS_B if exists

2659: FND_MSG_PUB.ADD;
2660: RAISE FND_API.G_EXC_ERROR;
2661: END IF;
2662:
2663: --remove the default entry 'XXX' from BSC_KPI_DIM_LEVELS_B if exists
2664: BSC_BIS_KPI_MEAS_PUB.Delete_Default_Kpi_Dim_Object
2665: ( p_commit => FND_API.G_FALSE
2666: , p_kpi_id => p_kpi_id
2667: , p_dim_set_id => p_dim_set_id

Line 2930: bsc_kpi_dim_levels_b

2926: CURSOR c_Dim_Levels IS
2927: SELECT
2928: level_table_name
2929: FROM
2930: bsc_kpi_dim_levels_b
2931: WHERE
2932: indicator = p_kpi_id
2933: AND dim_set_id = p_dim_set_id
2934: INTERSECT

Line 2965: bsc_kpi_dim_levels_b

2961: BULK COLLECT INTO
2962: l_level_table_names,
2963: l_key_item_values
2964: FROM
2965: bsc_kpi_dim_levels_b
2966: WHERE
2967: indicator = p_kpi_id
2968: AND dim_set_id = p_dim_set_id
2969: AND default_key_value IS NOT NULL;

Line 3568: FROM BSC_KPI_DIM_LEVELS_B

3564: ELSE
3565: IF (l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
3566: SELECT COUNT(*)
3567: INTO l_count
3568: FROM BSC_KPI_DIM_LEVELS_B
3569: WHERE INDICATOR = l_bsc_dimset_rec.Bsc_Kpi_Id
3570: AND DIM_SET_ID = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3571: l_bsc_dimset_rec.Bsc_Dset_Dim_Level_Index := l_count + 1;
3572: END IF;

Line 6420: --remove the default entry 'XXX' from BSC_KPI_DIM_LEVELS_B if exists

6416: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_DIMENSION_SETS_PUB.Delete_Dim_Objs_In_DSet');
6417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6418: END IF;
6419: END IF;
6420: --remove the default entry 'XXX' from BSC_KPI_DIM_LEVELS_B if exists
6421: BSC_BIS_KPI_MEAS_PUB.Delete_Default_Kpi_Dim_Object
6422: ( p_commit => FND_API.G_FALSE
6423: , p_kpi_id => p_kpi_id
6424: , p_dim_set_id => p_dim_set_id

Line 6789: --create the default entry 'XXX' from BSC_KPI_DIM_LEVELS_B if exists

6785: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET <'||x_msg_data||'>');
6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6787: END IF;
6788: END LOOP;
6789: --create the default entry 'XXX' from BSC_KPI_DIM_LEVELS_B if exists
6790: BSC_BIS_KPI_MEAS_PUB.Create_Default_Kpi_Dim_Object
6791: ( p_commit => FND_API.G_FALSE
6792: , p_kpi_id => p_kpi_id
6793: , p_dim_set_id => p_dim_set_id