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_GROUPS

Line 100: , p_dim_old_index BSC_KPI_DIM_GROUPS.Dim_Group_Index%TYPE

96: /*********************************************************************************/
97: TYPE Dim_Index_Type IS Record
98: ( p_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE
99: , p_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE
100: , p_dim_old_index BSC_KPI_DIM_GROUPS.Dim_Group_Index%TYPE
101: );
102: TYPE Dim_Index_Table_Type IS TABLE OF Dim_Index_Type INDEX BY BINARY_INTEGER;
103:
104: /*******************************************************************/

Line 630: FROM BSC_KPI_DIM_GROUPS A

626: CURSOR c_dim_index IS
627: SELECT A.Dim_Group_Id
628: , A.Dim_Group_Index
629: , B.Short_Name
630: FROM BSC_KPI_DIM_GROUPS A
631: , BSC_SYS_DIM_GROUPS_VL B
632: WHERE A.Indicator = p_kpi_id
633: AND A.Dim_Set_Id = p_dim_set_id
634: AND A.Dim_Group_ID = B.Dim_Group_ID

Line 1163: FROM BSC_KPI_DIM_GROUPS

1159: l_temp_var VARCHAR2(32000);
1160:
1161: CURSOR c_dim_set_ind IS
1162: SELECT DISTINCT dim_group_id
1163: FROM BSC_KPI_DIM_GROUPS
1164: WHERE Dim_Set_Id = p_dim_set_id
1165: AND Indicator = p_Kpi_Id;
1166:
1167: CURSOR cr_bsc_dim IS

Line 1987: FROM BSC_KPI_DIM_GROUPS

1983:
1984: CURSOR p_unassign_dim_names IS
1985: SELECT short_name FROM BSC_SYS_DIM_GROUPS_VL
1986: WHERE dim_group_id IN (SELECT dim_group_id
1987: FROM BSC_KPI_DIM_GROUPS
1988: WHERE dim_set_id = p_dim_set_id
1989: AND indicator = p_kpi_id);
1990: BEGIN
1991: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set procedure');

Line 2482: FROM BSC_KPI_DIM_GROUPS

2478: FOR cd IN c_kpi_ids LOOP
2479: l_bsc_dimset_rec.Bsc_Kpi_Id := cd.indicator;
2480: --dbms_output.PUT_LINE('Within Shared Indicator Loop KPI_ID is <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');
2481: SELECT COUNT(*) INTO l_count
2482: FROM BSC_KPI_DIM_GROUPS
2483: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2484: AND dim_set_id = p_dim_set_id;
2485: IF (l_count <> 0) THEN
2486: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

Line 2693: FROM BSC_KPI_DIM_GROUPS

2689: RAISE FND_API.G_EXC_ERROR;
2690: END IF;
2691:
2692: SELECT COUNT(*) INTO l_count
2693: FROM BSC_KPI_DIM_GROUPS
2694: WHERE dim_group_id = (SELECT dim_group_id FROM BSC_SYS_DIM_GROUPS_VL WHERE Short_Name = l_dim_short_name)
2695: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
2696: AND indicator = l_bsc_dimset_rec.Bsc_Kpi_Id;
2697: IF (l_count = 0) THEN

Line 3142: FROM BSC_KPI_DIM_GROUPS A

3138: AND Prototype_Flag <> 2;
3139:
3140: CURSOR c_dim_index IS
3141: SELECT B.Short_Name
3142: FROM BSC_KPI_DIM_GROUPS A
3143: , BSC_SYS_DIM_GROUPS_VL B
3144: WHERE A.Indicator = p_kpi_id
3145: AND A.Dim_Set_Id = p_dim_set_id
3146: AND A.Dim_Group_ID = B.Dim_Group_ID

Line 3217: , BSC_KPI_DIM_GROUPS B

3213: , p_dim_short_name => l_dim_short_name)
3214: ) LOOP
3215: SELECT COUNT(*) INTO l_count
3216: FROM BSC_SYS_DIM_GROUPS_VL A
3217: , BSC_KPI_DIM_GROUPS B
3218: WHERE A.short_name = l_dim_short_name
3219: AND A.Dim_Group_Id = B.Dim_Group_Id
3220: AND B.Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3221: AND B.Dim_Set_Id = p_dim_set_id;

Line 3271: , BSC_KPI_DIM_GROUPS B

3267: , p_dim_short_name => l_dim_short_name)
3268: ) LOOP
3269: SELECT COUNT(*) INTO l_count
3270: FROM BSC_SYS_DIM_GROUPS_VL A
3271: , BSC_KPI_DIM_GROUPS B
3272: WHERE A.short_name = l_dim_short_name
3273: AND A.Dim_Group_Id = B.Dim_Group_Id
3274: AND B.Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3275: AND B.Dim_Set_Id = p_dim_set_id;

Line 3494: FROM BSC_KPI_DIM_GROUPS A

3490: WHILE (Is_More( p_dim_short_names => l_dim_short_names
3491: , p_dim_short_name => l_dim_short_name)
3492: ) LOOP
3493: SELECT COUNT(*) INTO l_count
3494: FROM BSC_KPI_DIM_GROUPS A
3495: , BSC_SYS_DIM_GROUPS_VL B
3496: WHERE A.Dim_Group_Id = B.Dim_Group_Id
3497: AND A.Indicator = l_bsc_dimset_rec.bsc_kpi_id
3498: AND A.Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id

Line 3506: FROM BSC_KPI_DIM_GROUPS

3502: --l_bsc_dimset_rec.Bsc_Level_Name := BSC_PMF_UI_API_PUB.get_Dim_Level_View_Name(cd.short_name);
3503: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Level_Name <'||l_bsc_dimset_rec.Bsc_Level_Name||'>');
3504: SELECT NVL(MAX(Dim_Group_Index) + 1, 0)
3505: INTO l_bsc_dimset_rec.Bsc_Dim_Level_Group_Index
3506: FROM BSC_KPI_DIM_GROUPS
3507: WHERE indicator = l_bsc_dimset_rec.bsc_kpi_id
3508: AND dim_set_id = l_bsc_dimset_rec.bsc_dim_set_id;
3509:
3510: SELECT dim_group_id

Line 3528: BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset--insert into BSC_KPI_DIM_GROUPS

3524: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP Failed: at Create_Dim_Grp_Lev_In_Dset');
3525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3526: END IF;
3527: -- END : Granular Locking
3528: BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset--insert into BSC_KPI_DIM_GROUPS
3529: ( p_commit => FND_API.G_FALSE
3530: , p_Dim_Set_Rec => l_bsc_dimset_rec
3531: , p_create_Dim_Lev_Grp => FALSE
3532: , x_return_status => x_return_status

Line 5596: BSC_KPI_DIM_GROUPS

5592: CURSOR c_dim_group_id IS
5593: SELECT
5594: dim_group_id
5595: FROM
5596: BSC_KPI_DIM_GROUPS
5597: WHERE
5598: Dim_Set_Id = p_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id AND
5599: Indicator = p_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5600:

Line 6332: FROM BSC_KPI_DIM_GROUPS

6328: AND Prototype_Flag <> 2;
6329:
6330: CURSOR c_dim_group_id IS
6331: SELECT Dim_Group_ID
6332: FROM BSC_KPI_DIM_GROUPS
6333: WHERE Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
6334: AND Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
6335: ORDER BY Dim_Group_Index;
6336:

Line 6391: FROM BSC_KPI_DIM_GROUPS KPI_GROUP

6387: l_count := 0;
6388: SELECT MAX(NUM) INTO l_count
6389: FROM (SELECT COUNT(SYS_DIM_LEL.Dim_Group_Id) NUM
6390: , SYS_DIM_LEL.Dim_Level_Id
6391: FROM BSC_KPI_DIM_GROUPS KPI_GROUP
6392: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL
6393: WHERE KPI_GROUP.Dim_Group_Id = SYS_DIM_LEL.Dim_Group_Id
6394: AND KPI_GROUP.Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
6395: AND KPI_GROUP.Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id

Line 6507: FROM BSC_KPI_DIM_GROUPS KPI_GROUP

6503: l_bsc_dimset_rec.Bsc_Kpi_Id := cm.indicator;
6504: SELECT MAX(NUM) INTO l_count
6505: FROM (SELECT COUNT(SYS_DIM_LEL.Dim_Group_Id) NUM
6506: , SYS_DIM_LEL.Dim_Level_Id
6507: FROM BSC_KPI_DIM_GROUPS KPI_GROUP
6508: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL
6509: WHERE KPI_GROUP.Dim_Group_Id = SYS_DIM_LEL.Dim_Group_Id
6510: AND KPI_GROUP.Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
6511: AND KPI_GROUP.Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id

Line 6668: FROM BSC_KPI_DIM_GROUPS

6664: AND Prototype_Flag <> 2;
6665:
6666: CURSOR c_dim_group_id IS
6667: SELECT Dim_Group_ID
6668: FROM BSC_KPI_DIM_GROUPS
6669: WHERE Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
6670: AND Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
6671: ORDER BY Dim_Group_Index;
6672:

Line 6873: FROM BSC_KPI_DIM_GROUPS

6869: RETURN NULL;
6870: END IF;
6871: IF (p_Dim_Set_ID IS NOT NULL) THEN
6872: SELECT COUNT(*) INTO l_Count
6873: FROM BSC_KPI_DIM_GROUPS
6874: WHERE Indicator = p_Kpi_ID
6875: AND Dim_Set_Id = p_Dim_Set_ID;
6876: IF (l_Count = 0) THEN
6877: RETURN NULL;

Line 6959: , BSC_KPI_DIM_GROUPS B

6955: CURSOR c_Old_Dimensions IS
6956: SELECT A.Short_Name
6957: , B.Dim_Group_Index
6958: FROM BSC_SYS_DIM_GROUPS_VL A
6959: , BSC_KPI_DIM_GROUPS B
6960: WHERE A.Dim_Group_Id = B.Dim_Group_Id
6961: AND B.Indicator = p_Kpi_ID
6962: AND B.Dim_Set_ID = p_Dim_Set_ID
6963: ORDER BY B.Dim_Group_Index;

Line 7139: , BSC_KPI_DIM_GROUPS B

7135:
7136: CURSOR cr_Old_Dimensions IS
7137: SELECT A.Short_Name
7138: FROM BSC_SYS_DIM_GROUPS_VL A
7139: , BSC_KPI_DIM_GROUPS B
7140: WHERE A.Dim_Group_Id = B.Dim_Group_Id
7141: AND B.Indicator = p_Kpi_ID
7142: AND B.Dim_Set_ID = p_Dim_Set_ID
7143: ORDER BY B.Dim_Group_Index;