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_UTILITY

Line 1073: l_pmf_disp_name := BSC_UTILITY.get_Next_DispName(l_pmf_disp_name);

1069: SELECT COUNT(1) INTO l_count
1070: FROM BIS_LEVELS_VL
1071: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
1072: WHILE(l_count > 0) LOOP
1073: l_pmf_disp_name := BSC_UTILITY.get_Next_DispName(l_pmf_disp_name);
1074: SELECT COUNT(1) INTO l_count
1075: FROM BIS_LEVELS_VL
1076: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
1077: END LOOP;

Line 1784: BSC_UTILITY.Enable_Dimensions_Entity(

1780: ELSE
1781: l_assign_dim := l_assign_dim ||','||p_unassign_dim_short_names;
1782: END IF;
1783: END IF;
1784: BSC_UTILITY.Enable_Dimensions_Entity(
1785: p_Entity_Type => BSC_UTILITY.c_DIMENSION
1786: , p_Entity_Short_Names => l_assign_dim
1787: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1788: , x_Return_Status => x_return_status

Line 1785: p_Entity_Type => BSC_UTILITY.c_DIMENSION

1781: l_assign_dim := l_assign_dim ||','||p_unassign_dim_short_names;
1782: END IF;
1783: END IF;
1784: BSC_UTILITY.Enable_Dimensions_Entity(
1785: p_Entity_Type => BSC_UTILITY.c_DIMENSION
1786: , p_Entity_Short_Names => l_assign_dim
1787: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1788: , x_Return_Status => x_return_status
1789: , x_Msg_Count => x_msg_count

Line 1787: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE

1783: END IF;
1784: BSC_UTILITY.Enable_Dimensions_Entity(
1785: p_Entity_Type => BSC_UTILITY.c_DIMENSION
1786: , p_Entity_Short_Names => l_assign_dim
1787: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1788: , x_Return_Status => x_return_status
1789: , x_Msg_Count => x_msg_count
1790: , x_Msg_Data => x_msg_data
1791: );

Line 1859: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(l_unassign||'+'||p_dim_obj_short_name);

1855: END IF;
1856:
1857: IF (l_unassign <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN
1858:
1859: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(l_unassign||'+'||p_dim_obj_short_name);
1860: IF(l_regions IS NOT NULL) THEN
1861: SELECT DIM_NAME
1862: INTO l_dim_name
1863: FROM BSC_BIS_DIM_VL

Line 2236: l_pmf_disp_name := BSC_UTILITY.get_Next_DispName(l_pmf_disp_name);

2232: WHERE UPPER(short_name) <> UPPER(l_dim_obj_name)
2233: AND UPPER(name) = UPPER(l_pmf_disp_name);
2234:
2235: WHILE(l_count > 0) LOOP
2236: l_pmf_disp_name := BSC_UTILITY.get_Next_DispName(l_pmf_disp_name);
2237: SELECT COUNT(1) INTO l_count
2238: FROM BIS_LEVELS_VL
2239: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
2240: END LOOP;

Line 3865: -- Bug 3751932 -- AND (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Name))) THEN

3861:
3862:
3863: IF (p_Dim_Level_Rec.Source = 'OLTP') THEN
3864: IF ((p_Dim_Level_Rec.Bsc_Level_Name IS NOT NULL)) THEN
3865: -- Bug 3751932 -- AND (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Name))) THEN
3866: p_Dim_Level_Rec.Bsc_Level_Name_Column := 'VALUE';
3867: p_Dim_Level_Rec.Bsc_Level_Pk_Key := 'ID';
3868: ELSE
3869: l_flag := FALSE;

Line 3872: IF (BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Name)) THEN

3868: ELSE
3869: l_flag := FALSE;
3870: END IF;
3871: ELSE -- IF EDW THEN
3872: IF (BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Name)) THEN
3873: p_Dim_Level_Rec.Bsc_Level_Name_Column := 'VALUE';
3874: p_Dim_Level_Rec.Bsc_Level_Pk_Key := 'ID';
3875: ELSIF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Short_Name||'_LTC')) THEN
3876: IF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Short_Name)) THEN

Line 3875: ELSIF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Short_Name||'_LTC')) THEN

3871: ELSE -- IF EDW THEN
3872: IF (BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Name)) THEN
3873: p_Dim_Level_Rec.Bsc_Level_Name_Column := 'VALUE';
3874: p_Dim_Level_Rec.Bsc_Level_Pk_Key := 'ID';
3875: ELSIF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Short_Name||'_LTC')) THEN
3876: IF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Short_Name)) THEN
3877: l_prefix := '%PK_KEY%';
3878: ELSE
3879: p_Dim_Level_Rec.Bsc_Level_Name := p_Dim_Level_Rec.Bsc_Level_Short_Name;

Line 3876: IF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Short_Name)) THEN

3872: IF (BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Name)) THEN
3873: p_Dim_Level_Rec.Bsc_Level_Name_Column := 'VALUE';
3874: p_Dim_Level_Rec.Bsc_Level_Pk_Key := 'ID';
3875: ELSIF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Short_Name||'_LTC')) THEN
3876: IF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_Short_Name)) THEN
3877: l_prefix := '%PK_KEY%';
3878: ELSE
3879: p_Dim_Level_Rec.Bsc_Level_Name := p_Dim_Level_Rec.Bsc_Level_Short_Name;
3880: IF (allTabCol1%ISOPEN) THEN

Line 3912: p_Dim_Level_Rec.Bsc_Level_View_Name := bsc_utility.get_valid_bsc_master_tbl_name(p_Dim_Level_Rec.Bsc_Level_Short_Name);

3908: END IF;
3909: END IF;
3910: --p_Dim_Level_Rec.Bsc_Level_View_Name will be NULL only in Create Case
3911: IF (p_Dim_Level_Rec.Bsc_Level_View_Name IS NULL) THEN
3912: p_Dim_Level_Rec.Bsc_Level_View_Name := bsc_utility.get_valid_bsc_master_tbl_name(p_Dim_Level_Rec.Bsc_Level_Short_Name);
3913: END IF;
3914: IF (NOT is_Valid_Identifier(p_Dim_Level_Rec.Bsc_Level_View_Name)) THEN
3915: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SQL_IDENTIFIER');
3916: FND_MESSAGE.SET_TOKEN('SQL_IDENT', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_VIEW_NAME'), TRUE);

Line 4162: IF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_View_Name)) THEN

4158: EXCEPTION
4159: --if exception, it means PMF View does not exists,
4160: --in this case update Table_Type = -1, which is a indication of view does not exists
4161: WHEN OTHERS THEN
4162: IF (NOT BSC_UTILITY.is_Table_View_Exists(p_Dim_Level_Rec.Bsc_Level_View_Name)) THEN
4163: UPDATE BSC_SYS_DIM_LEVELS_B
4164: SET Table_Type = -1
4165: WHERE Short_Name = p_Dim_Level_Rec.Bsc_Level_Short_Name;
4166: END IF;

Line 5591: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN

5587: FND_MSG_PUB.Initialize;
5588: IF ((p_dim_obj_short_name IS NULL) AND (p_Source IS NULL)) THEN
5589: RETURN NULL;
5590: END IF;
5591: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN
5592: RETURN NULL;
5593: END IF;
5594:
5595: IF (p_dim_obj_short_name IS NOT NULL) THEN

Line 6282: IF( l_count > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

6278: OPEN cr_kpi_dimset_dimobj;
6279: LOOP
6280: FETCH cr_kpi_dimset_dimobj INTO l_kpi_id,l_dim_set_id,l_count;
6281: EXIT WHEN cr_kpi_dimset_dimobj%NOTFOUND;
6282: IF( l_count > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
6283: l_indp_dimobj := 0;
6284: l_indp_dimobj := bsc_utility.get_nof_independent_dimobj
6285: ( p_Kpi_Id => l_kpi_id
6286: , p_Dim_Set_Id => l_dim_set_id

Line 6284: l_indp_dimobj := bsc_utility.get_nof_independent_dimobj

6280: FETCH cr_kpi_dimset_dimobj INTO l_kpi_id,l_dim_set_id,l_count;
6281: EXIT WHEN cr_kpi_dimset_dimobj%NOTFOUND;
6282: IF( l_count > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
6283: l_indp_dimobj := 0;
6284: l_indp_dimobj := bsc_utility.get_nof_independent_dimobj
6285: ( p_Kpi_Id => l_kpi_id
6286: , p_Dim_Set_Id => l_dim_set_id
6287: );
6288: IF(l_indp_dimobj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

Line 6288: IF(l_indp_dimobj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

6284: l_indp_dimobj := bsc_utility.get_nof_independent_dimobj
6285: ( p_Kpi_Id => l_kpi_id
6286: , p_Dim_Set_Id => l_dim_set_id
6287: );
6288: IF(l_indp_dimobj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
6289: SELECT NAME INTO l_kpi_name
6290: FROM BSC_KPIS_VL
6291: WHERE INDICATOR = l_kpi_id;
6292:

Line 6781: IF (l_count >= bsc_utility.MAX_DIM_IN_DIM_SET AND l_exist = 0 AND p_dim_obj_source = 'BSC' AND CTYPE.SOURCE = 'BSC') THEN

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:
6781: IF (l_count >= bsc_utility.MAX_DIM_IN_DIM_SET AND l_exist = 0 AND p_dim_obj_source = 'BSC' AND CTYPE.SOURCE = 'BSC') THEN
6782: FND_MESSAGE.SET_NAME('BSC','BSC_DIM_SHUTTLE_OVERFLOW');
6783: FND_MSG_PUB.ADD;
6784: return TRUE;
6785: END IF;

Line 6787: IF(CTYPE.SOURCE <> p_dim_obj_source AND BSC_UTILITY.Is_Internal_Dimension(l_dim_short_name) = FND_API.G_FALSE) THEN

6783: FND_MSG_PUB.ADD;
6784: return TRUE;
6785: END IF;
6786:
6787: IF(CTYPE.SOURCE <> p_dim_obj_source AND BSC_UTILITY.Is_Internal_Dimension(l_dim_short_name) = FND_API.G_FALSE) THEN
6788: l_true := TRUE;
6789: FOR CD IN C_SOURCE_DIM_OBJS LOOP
6790: l_dim_obj_name := cd.name;
6791: IF(l_source IS NULL) THEN

Line 7017: AND R.SOURCE = BSC_UTILITY.c_PMF

7013: FROM BSC_SYS_DIM_LEVEL_RELS_V R
7014: WHERE R.DIM_LEVEL_ID = R.PARENT_DIM_LEVEL_ID
7015: AND R.SHORT_NAME = p_Short_Name
7016: AND R.PARENT_SHORT_NAME = p_Short_Name
7017: AND R.SOURCE = BSC_UTILITY.c_PMF
7018: AND R.PARENT_SOURCE = BSC_UTILITY.c_PMF;
7019: BEGIN
7020: l_Count := 0;
7021:

Line 7018: AND R.PARENT_SOURCE = BSC_UTILITY.c_PMF;

7014: WHERE R.DIM_LEVEL_ID = R.PARENT_DIM_LEVEL_ID
7015: AND R.SHORT_NAME = p_Short_Name
7016: AND R.PARENT_SHORT_NAME = p_Short_Name
7017: AND R.SOURCE = BSC_UTILITY.c_PMF
7018: AND R.PARENT_SOURCE = BSC_UTILITY.c_PMF;
7019: BEGIN
7020: l_Count := 0;
7021:
7022: FOR cRE IN c_Rels LOOP

Line 7185: IF (l_source = BSC_UTILITY.c_PMF) THEN

7181: FROM bsc_sys_dim_levels_vl bsc, bis_levels_vl bis
7182: WHERE bsc.short_name = bis.short_name
7183: AND bsc.short_name = p_Dim_Obj_Short_Name;
7184:
7185: IF (l_source = BSC_UTILITY.c_PMF) THEN
7186: BSC_BIS_DIM_OBJ_PUB.Validate_PMF_Views(
7187: p_Dim_Obj_Short_Name => p_Dim_Obj_Short_Name
7188: ,p_Dim_Obj_View_Name => l_Dim_Obj_View_Name
7189: ,x_Return_Status => x_Return_Status