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_DIMENSION_PUB dependencies on BSC_SYS_DIM_GROUPS_VL

Line 210: FROM BSC_SYS_DIM_GROUPS_VL

206: l_dim_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
207:
208: CURSOR c_Dim_Group_Id IS
209: SELECT Dim_Group_ID
210: FROM BSC_SYS_DIM_GROUPS_VL
211: WHERE Short_Name = p_Short_Name;
212: BEGIN
213: IF (c_Dim_Group_Id%ISOPEN) THEN
214: CLOSE c_Dim_Group_Id;

Line 262: FROM BSC_SYS_DIM_GROUPS_VL

258: l_dim_name BSC_SYS_DIM_GROUPS_TL.Name%TYPE;
259:
260: CURSOR c_Dim_Group_Name IS
261: SELECT Name
262: FROM BSC_SYS_DIM_GROUPS_VL
263: WHERE Short_Name = p_Short_Name;
264: BEGIN
265: IF (c_Dim_Group_Name%ISOPEN) THEN
266: CLOSE c_Dim_Group_Name;

Line 474: FROM BSC_SYS_DIM_GROUPS_VL

470: ORDER BY Dim_Level_Index DESC;
471:
472: CURSOR c_Dim_Short_Name IS
473: SELECT Short_Name
474: FROM BSC_SYS_DIM_GROUPS_VL
475: WHERE Dim_Group_Id = l_Bsc_Group_ID;
476:
477: CURSOR c_Dim_Level_Info IS
478: SELECT LEVEL_ID

Line 936: FROM BSC_SYS_DIM_GROUPS_VL

932: l_temp_var := l_dim_short_name;
933: WHILE (l_flag) LOOP
934: SELECT COUNT(1) INTO l_count
935: FROM (SELECT COUNT(1) rec_count
936: FROM BSC_SYS_DIM_GROUPS_VL
937: WHERE UPPER(Short_Name) = UPPER(l_temp_var)
938: UNION
939: SELECT COUNT(1) rec_count
940: FROM BIS_DIMENSIONS_VL

Line 1045: FROM BSC_SYS_DIM_GROUPS_VL

1041:
1042: ELSE
1043:
1044: SELECT COUNT(1) INTO l_count
1045: FROM BSC_SYS_DIM_GROUPS_VL
1046: WHERE UPPER(name) = UPPER(p_display_name);
1047: IF (l_count <> 0) THEN
1048: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1049: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));

Line 1120: FROM BSC_SYS_DIM_GROUPS_VL

1116: END IF;
1117: --assign values to bis records -This is not required
1118: SELECT dim_group_id
1119: INTO l_bis_dimension_rec.Dim_Grp_Id
1120: FROM BSC_SYS_DIM_GROUPS_VL
1121: WHERE Short_Name = l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name;
1122:
1123: l_bis_dimension_rec.Dimension_Short_Name := l_dim_short_name;
1124: l_bis_dimension_rec.Dimension_Name := l_pmf_disp_name;

Line 1237: l_dim_group_id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;

1233: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
1234: l_MTab_DimRels1 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1235: l_MTab_DimRels2 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1236:
1237: l_dim_group_id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
1238: l_count NUMBER;
1239: l_count1 NUMBER;
1240: l_flag BOOLEAN;
1241: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

Line 1255: FROM BSC_SYS_DIM_GROUPS_VL

1251: FROM BSC_SYS_DIM_LEVELS_B B
1252: , BSC_SYS_DIM_LEVELS_BY_GROUP A
1253: WHERE A.dim_group_id =
1254: ( SELECT dim_group_id
1255: FROM BSC_SYS_DIM_GROUPS_VL
1256: WHERE Short_Name = p_dim_short_name
1257: )
1258: AND A.Dim_Level_Id = B.Dim_Level_Id
1259: ORDER BY A.Dim_Level_Index;

Line 1263: FROM BSC_SYS_DIM_GROUPS_VL

1259: ORDER BY A.Dim_Level_Index;
1260:
1261: CURSOR cr_bsc_dim_id IS
1262: SELECT dim_group_id
1263: FROM BSC_SYS_DIM_GROUPS_VL
1264: WHERE short_name = p_dim_short_name;
1265:
1266: CURSOR cr_bsc_dim_obj_id IS
1267: SELECT Dim_Level_Id

Line 1547: SELECT dim_group_id FROM BSC_SYS_DIM_GROUPS_VL

1543: SELECT dim_level_id FROM BSC_SYS_DIM_LEVELS_B
1544: WHERE short_name = p_dim_obj_short_name;
1545:
1546: CURSOR cr_bsc_dim_id IS
1547: SELECT dim_group_id FROM BSC_SYS_DIM_GROUPS_VL
1548: WHERE short_name = p_dim_short_name;
1549:
1550: /* Fix for the bug 3129610 */
1551: CURSOR cr_bsc_dim_obj_count IS

Line 1557: BSC_SYS_DIM_GROUPS_VL V,

1553: , C.Short_Name
1554: , C.Source
1555: , C.Name
1556: FROM BSC_SYS_DIM_LEVELS_BY_GROUP B,
1557: BSC_SYS_DIM_GROUPS_VL V,
1558: BSC_SYS_DIM_LEVELS_VL C
1559: WHERE V.Dim_Group_Id = B.Dim_Group_Id
1560: AND B.Dim_Level_Id = C.Dim_Level_Id
1561: AND V.Short_Name = p_Dim_Short_Name;

Line 2042: FROM BSC_SYS_DIM_GROUPS_VL

2038: l_index NUMBER := 0;
2039: -- END Granular Locking Declaration added by Aditya
2040: CURSOR cr_bsc_dimension_id IS
2041: SELECT Dim_Group_Id
2042: FROM BSC_SYS_DIM_GROUPS_VL
2043: WHERE Short_Name = p_dim_short_name;
2044:
2045: CURSOR cr_bsc_dim_obj_id IS
2046: SELECT Dim_Level_Id

Line 2563: FROM BSC_SYS_DIM_GROUPS_VL

2559:
2560:
2561: CURSOR cr_bsc_dim_id IS
2562: SELECT name, dim_group_id
2563: FROM BSC_SYS_DIM_GROUPS_VL
2564: WHERE short_name = l_dim_short_name;
2565:
2566: CURSOR cr_bis_dim_id IS
2567: SELECT name, description, dimension_id

Line 2744: FROM BSC_SYS_DIM_GROUPS_VL

2740: --this call will be moved to CRUD APIs later
2741: UPDATE BIS_DIMENSIONS
2742: SET Dim_Grp_ID =
2743: ( SELECT dim_group_id
2744: FROM BSC_SYS_DIM_GROUPS_VL
2745: WHERE Short_Name = l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name
2746: );
2747: ELSE
2748: l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name := p_display_name;

Line 2861: FROM BSC_SYS_DIM_GROUPS_VL

2857: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
2858:
2859: CURSOR cr_bsc_dim_id IS
2860: SELECT dim_group_id
2861: FROM BSC_SYS_DIM_GROUPS_VL
2862: WHERE short_name = p_dim_short_name;
2863:
2864: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
2865: l_dim_obj_names VARCHAR2(32000);

Line 2925: FROM BSC_SYS_DIM_GROUPS_VL

2921: -- Enh#4172034: Validations
2922: IF (l_dim_type = 'PMF') THEN
2923:
2924: SELECT COUNT(1) INTO l_count
2925: FROM BSC_SYS_DIM_GROUPS_VL
2926: WHERE UPPER(short_name) <> UPPER(p_dim_short_name)
2927: AND UPPER(name) = UPPER(p_display_name); -- already trimmed from JAVA
2928: IF (l_count <> 0) THEN
2929: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

Line 3123: FROM BSC_SYS_DIM_GROUPS_VL WHERE short_name = p_dim_short_name;

3119: l_is_kpi_affected BOOLEAN;
3120:
3121: CURSOR cr_bsc_dim_id IS
3122: SELECT dim_group_id
3123: FROM BSC_SYS_DIM_GROUPS_VL WHERE short_name = p_dim_short_name;
3124:
3125: CURSOR cr_bsc_dim IS
3126: SELECT short_name
3127: FROM BSC_SYS_DIM_LEVELS_B

Line 3334: FROM BSC_SYS_DIM_GROUPS_VL

3330:
3331: CURSOR cr_bsc_dimension_id IS
3332: SELECT dim_group_id
3333: , name
3334: FROM BSC_SYS_DIM_GROUPS_VL
3335: WHERE short_name = p_dim_short_name;
3336:
3337: CURSOR cr_bis_dim_ids IS
3338: SELECT Short_Name

Line 3808: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;

3804: l_new_default_Value BSC_SYS_DIM_LEVELS_BY_GROUP.Default_Value%TYPE;
3805: l_Prod_Mode BSC_SYS_INIT.Property_Value%TYPE;
3806: l_Struct_Flag BOOLEAN := FALSE;
3807: l_kpi_names VARCHAR2(32000);
3808: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
3809: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
3810: l_indicator_list VARCHAR2(32000);
3811: l_obj_name bsc_kpis_vl.name%TYPE;
3812: l_ind bsc_kpis_vl.indicator%TYPE;

Line 3821: , BSC_SYS_DIM_GROUPS_VL B

3817: SELECT A.Default_Value
3818: , A.Dim_Group_ID
3819: , C.Source
3820: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
3821: , BSC_SYS_DIM_GROUPS_VL B
3822: , BSC_SYS_DIM_LEVELS_B C
3823: WHERE A.Dim_Group_Id = B.Dim_Group_Id
3824: AND A.Dim_Level_Id = C.Dim_Level_Id
3825: AND B.Short_Name = p_Dim_Short_Name

Line 3977: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;

3973: l_msg_count NUMBER;
3974:
3975: l_Dim_Obj_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;
3976: l_Dim_Obj_Old_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;
3977: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
3978: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
3979:
3980: l_old_dim_objects VARCHAR2(8000) := NULL;
3981: l_temp_dim_objcts VARCHAR2(8000);

Line 3994: FROM BSC_SYS_DIM_GROUPS_VL A

3990: SELECT C.Short_Name
3991: , B.Dim_Level_Index
3992: , A.Dim_Group_Id
3993: , C.Source
3994: FROM BSC_SYS_DIM_GROUPS_VL A
3995: , BSC_SYS_DIM_LEVELS_BY_GROUP B
3996: , BSC_SYS_DIM_LEVELS_B C
3997: WHERE A.Dim_Group_Id = B.Dim_Group_Id
3998: AND C.Dim_Level_Id = B.Dim_Level_Id

Line 4006: , BSC_SYS_DIM_GROUPS_VL C

4002: CURSOR c_dim_set_kpi IS
4003: SELECT DISTINCT B.Name||'['||B.Indicator||']' INDICATOR
4004: FROM BSC_KPI_DIM_GROUPS A
4005: , BSC_KPIS_VL B
4006: , BSC_SYS_DIM_GROUPS_VL C
4007: WHERE A.INDICATOR = B.INDICATOR
4008: AND B.share_flag <> 2
4009: AND A.Dim_Group_Id = C.Dim_Group_Id
4010: AND C.Short_Name = p_Dim_Short_Name;

Line 4155: , BSC_SYS_DIM_GROUPS_VL B

4151: CURSOR cr_kpidimset_dim IS
4152: SELECT A. INDICATOR
4153: , A.DIM_SET_ID
4154: FROM BSC_KPI_DIM_GROUPS A
4155: , BSC_SYS_DIM_GROUPS_VL B
4156: WHERE A.DIM_GROUP_ID = B.DIM_GROUP_ID
4157: AND B.SHORT_NAME = p_Dim_Short_Name;
4158:
4159: CURSOR cr_dimobj_in_dimset IS

Line 4170: ,BSC_SYS_DIM_GROUPS_VL VL

4166:
4167: CURSOR cr_dimobjs_in_dim IS
4168: SELECT BL.SHORT_NAME
4169: FROM BSC_SYS_DIM_LEVELS_BY_GROUP B
4170: ,BSC_SYS_DIM_GROUPS_VL VL
4171: ,BSC_SYS_DIM_LEVELS_B BL
4172: WHERE VL.DIM_GROUP_ID = B.DIM_GROUP_ID
4173: AND BL.DIM_LEVEL_ID = B.DIM_LEVEL_ID
4174: AND VL.SHORT_NAME = p_Dim_Short_Name;

Line 4612: BSC_SYS_DIM_GROUPS_VL G

4608: l_count NUMBER;
4609: BEGIN
4610: SELECT COUNT(1) INTO l_count
4611: FROM BSC_KPI_DIM_GROUPS KG,
4612: BSC_SYS_DIM_GROUPS_VL G
4613: WHERE KG.DIM_GROUP_ID = G.DIM_GROUP_ID
4614: AND G.SHORT_NAME = p_dim_short_name;
4615:
4616: IF (l_count = 0) THEN