APPS.BSC_DIMENSION_LEVELS_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 75: from BSC_SYS_DIM_LEVELS_B

71: -- Check to see that dimension level has not been created. If it has not then create it
72: -- else do nothing.
73: select count(1)
74: into l_count
75: from BSC_SYS_DIM_LEVELS_B
76: where short_name = l_Dim_Level_Rec.Bsc_Level_Short_Name;
77:
78: if l_count = 0 then
79:

Line 131: l_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_LEVELS_B'

127:
128:
129: --Get the next id for this level.
130: IF ( l_Dim_Level_Rec.Bsc_Level_Id IS NULL) THEN
131: l_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_LEVELS_B'
132: ,'DIM_LEVEL_ID');
133: END IF;
134:
135: IF(p_create_tables) THEN

Line 1781: l_level_view_name BSC_SYS_DIM_LEVELS_B.Level_View_Name%TYPE;

1777: ,x_msg_data OUT NOCOPY VARCHAR2
1778: )
1779: IS
1780: l_bsc_dim_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1781: l_level_view_name BSC_SYS_DIM_LEVELS_B.Level_View_Name%TYPE;
1782: l_count NUMBER;
1783: l_table_type BSC_SYS_DIM_LEVELS_B.Table_Type%TYPE;
1784: l_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_Pk_Col%TYPE;
1785:

Line 1783: l_table_type BSC_SYS_DIM_LEVELS_B.Table_Type%TYPE;

1779: IS
1780: l_bsc_dim_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1781: l_level_view_name BSC_SYS_DIM_LEVELS_B.Level_View_Name%TYPE;
1782: l_count NUMBER;
1783: l_table_type BSC_SYS_DIM_LEVELS_B.Table_Type%TYPE;
1784: l_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_Pk_Col%TYPE;
1785:
1786: BEGIN
1787: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1784: l_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_Pk_Col%TYPE;

1780: l_bsc_dim_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1781: l_level_view_name BSC_SYS_DIM_LEVELS_B.Level_View_Name%TYPE;
1782: l_count NUMBER;
1783: l_table_type BSC_SYS_DIM_LEVELS_B.Table_Type%TYPE;
1784: l_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_Pk_Col%TYPE;
1785:
1786: BEGIN
1787: x_return_status := FND_API.G_RET_STS_SUCCESS;
1788:

Line 1799: FROM bsc_sys_dim_levels_b

1795: INTO l_Bsc_Dim_Rec.Bsc_Level_Id
1796: , l_level_view_name
1797: , l_table_type
1798: , l_level_pk_col
1799: FROM bsc_sys_dim_levels_b
1800: WHERE short_name = p_dim_level_rec.Bsc_Level_Short_Name;
1801: EXCEPTION
1802: WHEN NO_DATA_FOUND THEN
1803: l_Bsc_Dim_Rec.Bsc_Level_Id := NULL;