APPS.BSC_DIMENSION_SETS_PVT dependencies on BSC_SYS_DIM_LEVELS_B

Line 1134: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B'

1130: end if;
1131:
1132: -- Check that valid Level Id was entered.
1133: if p_Dim_Set_Rec.Bsc_Level_Id is not null then
1134: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B'
1135: ,'dim_level_id'
1136: ,p_Dim_Set_Rec.Bsc_Level_Id);
1137: if l_count = 0 then
1138: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

Line 1772: from BSC_SYS_DIM_LEVELS_B

1768: -- Check that valid Level name was entered.
1769: if p_Dim_Set_Rec.Bsc_Level_Name is not null then
1770: select count(distinct dim_level_id)
1771: into l_count
1772: from BSC_SYS_DIM_LEVELS_B
1773: where upper(level_table_name) = upper(p_Dim_Set_Rec.Bsc_Level_Name);
1774: if l_count = 0 then
1775: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');
1776: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Set_Rec.Bsc_Level_Name);

Line 2011: AND (LEVEL_TABLE_NAME = (SELECT LEVEL_TABLE_NAME FROM BSC_SYS_DIM_LEVELS_B

2007: CURSOR c_dim_index IS
2008: SELECT DIM_LEVEL_INDEX FROM BSC_KPI_DIM_LEVELS_B
2009: WHERE DIM_SET_ID = p_Dim_Set_Rec.Bsc_Dim_Set_Id
2010: AND INDICATOR = p_Dim_Set_Rec.Bsc_Kpi_Id
2011: AND (LEVEL_TABLE_NAME = (SELECT LEVEL_TABLE_NAME FROM BSC_SYS_DIM_LEVELS_B
2012: WHERE DIM_LEVEL_ID = p_Dim_Set_Rec.Bsc_Level_Id)
2013: OR LEVEL_TABLE_NAME = 'XXX')
2014: ORDER BY DIM_LEVEL_INDEX DESC;
2015: begin