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_BIS_DIM_OBJ_PUB dependencies on BSC_SYS_DIM_LEVELS_BY_GROUP

Line 431: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP

427: CLOSE c_Bis_Levels;
428: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);
429: l_Bsc_Dim_Obj_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
430:
431: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
432: SET Total_Flag = p_All_Enabled
433: WHERE Dim_Level_Id = l_Bsc_Dim_Obj_ID
434: AND Dim_Group_Id = l_Bsc_Group_ID;
435: END IF;

Line 531: UPDATE bsc_sys_dim_levels_by_group

527: SAVEPOINT SyncBSCAllInPMD;
528:
529: IF ((p_All_Enabled IS NOT NULL) AND (p_All_Enabled = 0)) THEN
530: IF (p_Dim_Short_Name IS NOT NULL) THEN -- Update Mode
531: UPDATE bsc_sys_dim_levels_by_group
532: SET total_flag = p_All_Enabled
533: WHERE dim_level_id = BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name)
534: AND dim_group_id = BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(p_Dim_Short_Name);
535: ELSE -- Create Mode

Line 536: UPDATE bsc_sys_dim_levels_by_group

532: SET total_flag = p_All_Enabled
533: WHERE dim_level_id = BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name)
534: AND dim_group_id = BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(p_Dim_Short_Name);
535: ELSE -- Create Mode
536: UPDATE bsc_sys_dim_levels_by_group
537: SET total_flag = p_All_Enabled
538: WHERE dim_level_id = BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
539: END IF;
540: END IF;

Line 1587: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A

1583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1584: END IF;
1585: -- Granular Locking - Set the timestamp of Dimension Group
1586: SELECT COUNT(1) INTO l_count
1587: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
1588: , BSC_SYS_DIM_LEVELS_B B
1589: WHERE A.Dim_Group_Id = l_dim_grp_id
1590: AND A.Dim_Level_Id = B.Dim_Level_Id
1591: AND B.Short_Name = p_dim_obj_short_name;

Line 1761: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A

1757: , p_dim_name => l_assign)
1758: ) LOOP
1759: SELECT COUNT(1)
1760: INTO l_count
1761: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
1762: ,BSC_SYS_DIM_LEVELS_B L
1763: ,BSC_SYS_DIM_GROUPS_TL D
1764: WHERE D.SHORT_NAME = l_assign
1765: AND L.SHORT_NAME = p_dim_obj_short_name

Line 2086: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

2082: CURSOR c_dimension_names IS
2083: SELECT short_name
2084: FROM BSC_SYS_DIM_GROUPS_VL
2085: WHERE dim_group_id IN (SELECT dim_group_id
2086: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
2087: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id);
2088:
2089: CURSOR c_kpi_dim_set IS
2090: SELECT DISTINCT A.indicator Indicator

Line 3031: l_dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.dim_level_id%TYPE;

3027: , x_return_status OUT NOCOPY VARCHAR2
3028: , x_msg_count OUT NOCOPY NUMBER
3029: , x_msg_data OUT NOCOPY VARCHAR2
3030: ) IS
3031: l_dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.dim_level_id%TYPE;
3032: l_unas_dim_short_names VARCHAR2(32000);
3033:
3034:
3035: CURSOR cr_bsc_dim_obj IS

Line 3044: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

3040: CURSOR c_dimension_names IS
3041: SELECT short_name
3042: FROM BSC_SYS_DIM_GROUPS_VL
3043: WHERE dim_group_id IN (SELECT dim_group_id
3044: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
3045: WHERE dim_level_id = l_dim_level_id);
3046:
3047: BEGIN
3048: FND_MSG_PUB.Initialize;

Line 3484: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

3480: END IF;*/
3481:
3482: --check if the dimension is associated with any group, if so raise an exception
3483: SELECT COUNT(1) INTO l_count
3484: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
3485: WHERE Dim_Level_Id = l_bsc_dim_id
3486: AND Dim_Group_Id <> l_dim_Group_id;
3487: IF (l_count > 0) THEN
3488: FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIM_OBJ_GRPS');

Line 3555: BSC_SYS_DIM_LEVELS_BY_GROUP B

3551:
3552: CURSOR c_dimesnion_names IS
3553: SELECT V.NAME
3554: FROM BSC_SYS_DIM_LEVELS_VL V,
3555: BSC_SYS_DIM_LEVELS_BY_GROUP B
3556: WHERE V.DIM_LEVEL_ID = B.DIM_LEVEL_ID
3557: AND B.DIM_GROUP_ID = p_group_id
3558: ORDER BY B.DIM_LEVEL_INDEX;
3559: BEGIN

Line 3589: , BSC_SYS_DIM_LEVELS_BY_GROUP B

3585:
3586: CURSOR c_dimension_obj_name IS
3587: SELECT A.name
3588: FROM BSC_SYS_DIM_LEVELS_VL A
3589: , BSC_SYS_DIM_LEVELS_BY_GROUP B
3590: WHERE A.dim_level_id = B.dim_level_id
3591: AND B.dim_group_id = (SELECT dim_group_id
3592: FROM BSC_SYS_DIM_GROUPS_VL
3593: WHERE Short_Name = p_dim_short_name);

Line 5550: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

5546: SELECT Short_Name
5547: FROM BSC_SYS_DIM_GROUPS_VL
5548: WHERE dim_group_id IN
5549: (SELECT dim_group_id
5550: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
5551: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id);
5552:
5553: CURSOR c_Kpi_Dim_Set IS
5554: SELECT DISTINCT C.Name||'['||C.Indicator||']' Name

Line 5645: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A

5641: , p_dim_name => l_dim_Grp_name
5642: )) LOOP
5643: SELECT COUNT(0)
5644: INTO l_count
5645: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
5646: , BSC_SYS_DIM_GROUPS_VL B
5647: WHERE A.Dim_Level_Id = l_bsc_dim_obj_rec.Bsc_Level_Id
5648: AND B.Short_Name = l_dim_Grp_name
5649: AND B.Dim_Group_Id = A.Dim_Group_Id;

Line 6754: BSC_SYS_DIM_LEVELS_BY_GROUP GRP

6750:
6751: CURSOR C_SOURCE_DIM_OBJS IS
6752: SELECT SYS.SOURCE,SYS.SHORT_NAME,SYS.NAME
6753: FROM BSC_SYS_DIM_LEVELS_VL SYS,
6754: BSC_SYS_DIM_LEVELS_BY_GROUP GRP
6755: WHERE SYS.dim_level_id = GRP.dim_level_id
6756: AND GRP.dim_group_id = l_dim_grp_id;
6757:
6758: BEGIN

Line 6771: FROM BSC_SYS_DIM_LEVELS_BY_GROUP GRP

6767: l_dim_grp_id := CTYPE.DIM_ID;
6768: l_dim_short_name := CTYPE.SHORT_NAME;
6769:
6770: SELECT COUNT(1) into l_count
6771: FROM BSC_SYS_DIM_LEVELS_BY_GROUP GRP
6772: WHERE GRP.dim_group_id = l_dim_grp_id;
6773:
6774: SELECT COUNT(1) into l_exist
6775: FROM BSC_SYS_DIM_LEVELS_VL SYS,

Line 6776: BSC_SYS_DIM_LEVELS_BY_GROUP GRP

6772: WHERE GRP.dim_group_id = l_dim_grp_id;
6773:
6774: SELECT COUNT(1) into l_exist
6775: FROM BSC_SYS_DIM_LEVELS_VL SYS,
6776: BSC_SYS_DIM_LEVELS_BY_GROUP GRP
6777: WHERE SYS.dim_level_id = GRP.dim_level_id
6778: AND GRP.dim_group_id = l_dim_grp_id
6779: AND SYS.SHORT_NAME = p_dim_obj_short_name;
6780:

Line 7260: bsc_sys_dim_levels_by_group

7256: LOOP
7257: FETCH c_dim_groups INTO l_Dim_Short_Name;
7258: EXIT WHEN c_dim_groups%NOTFOUND;
7259: UPDATE
7260: bsc_sys_dim_levels_by_group
7261: SET
7262: total_flag = p_All_Flag
7263: WHERE
7264: dim_level_id = BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name)