APPS.BSC_DIMENSION_SETS_PUB dependencies on BSC_KPI_DIM_LEVELS_VL

Line 1404: FROM BSC_KPI_DIM_LEVELS_VL

1400: CURSOR set_correct_index IS
1401: SELECT DIM_LEVEL_INDEX,
1402: PARENT_LEVEL_INDEX,
1403: PARENT_LEVEL_INDEX2
1404: FROM BSC_KPI_DIM_LEVELS_VL
1405: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1406: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1407: ORDER BY DIM_LEVEL_INDEX;
1408:

Line 1791: FROM BSC_KPI_DIM_LEVELS_VL

1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789: -- 09/16 adrao added for bug# 3141813
1790: SELECT COUNT(0) INTO l_count
1791: FROM BSC_KPI_DIM_LEVELS_VL
1792: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1793: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1794: AND Level_Source = 'BSC';
1795: IF (l_count > BSC_UTILITY.MAX_DIM_IN_DIM_SET) THEN

Line 1807: FROM BSC_KPI_DIM_LEVELS_VL

1803: -- added to relax checking for mixed type of Dimension Objects within a Dimension
1804: -- for Autogenerated reports and removing the disctiction, BSC 5.3
1805: IF (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE) THEN
1806: SELECT COUNT(DISTINCT(Level_Source)) INTO l_count
1807: FROM BSC_KPI_DIM_LEVELS_VL
1808: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1809: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1810: AND Level_Source IS NOT NULL;
1811: IF (l_count > 1) THEN

Line 1820: FROM BSC_KPI_DIM_LEVELS_VL

1816: END IF;
1817:
1818: -- 09/20 adrao added for bug# 3152590
1819: SELECT COUNT(0) INTO l_count
1820: FROM BSC_KPI_DIM_LEVELS_VL
1821: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1822: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1823: AND DEFAULT_VALUE = 'C'
1824: AND Level_Source = 'BSC';

Line 1968: FROM BSC_KPI_DIM_LEVELS_VL

1964: -- added to relax checking for mixed type of Dimension Objects within a Dimension
1965: -- for Autogenerated reports and removing the disctiction, BSC 5.3
1966: IF (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE) THEN
1967: SELECT COUNT(DISTINCT(Level_Source)) INTO l_count
1968: FROM BSC_KPI_DIM_LEVELS_VL
1969: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1970: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1971: AND Level_Source IS NOT NULL;
1972: IF (l_count > 1) THEN

Line 1981: FROM BSC_KPI_DIM_LEVELS_VL

1977: END IF;
1978:
1979: -- 09/16 adrao added for bug# 3141813
1980: SELECT COUNT(0) INTO l_count
1981: FROM BSC_KPI_DIM_LEVELS_VL
1982: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1983: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1984: AND Level_Source = 'BSC';
1985: IF (l_count > BSC_UTILITY.MAX_DIM_IN_DIM_SET) THEN

Line 1993: FROM BSC_KPI_DIM_LEVELS_VL

1989: RAISE FND_API.G_EXC_ERROR;
1990: END IF;
1991:
1992: SELECT COUNT(0) INTO l_count
1993: FROM BSC_KPI_DIM_LEVELS_VL
1994: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1995: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1996: AND DEFAULT_VALUE= 'C';
1997: IF (l_count > 1) THEN -- not more that 1 DimObj can be in comparison within a Dimension Set.