APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_DIMENSION_LEVELS_PVT

Line 1069: --l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_GROUPS_TL', 'DIM_GROUP_ID');

1065:
1066: END IF;
1067:
1068: --assign values to bsc records
1069: --l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_GROUPS_TL', 'DIM_GROUP_ID');
1070: l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name := p_display_name;
1071: l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name := l_dim_short_name;
1072: l_bsc_dimension_rec.Bsc_Dim_Level_Index := 1;
1073: l_bsc_dimension_rec.Bsc_Group_Level_Comp_Flag := -1;

Line 1091: l_Dim_Obj_Tab(l_index) := NVL(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);

1087: l_dim_obj_names := p_dim_obj_short_names ;
1088: WHILE (is_more( p_dim_obj_short_names => l_dim_obj_names
1089: , p_dim_obj_name => l_dim_obj_name)
1090: ) LOOP
1091: l_Dim_Obj_Tab(l_index) := NVL(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);
1092: l_index := l_index + 1;
1093: END LOOP;
1094: -- Lock all the Dimension Objects to be assigned to the Dimension
1095: BSC_BIS_LOCKS_PUB.Lock_Create_Dimension

Line 2088: l_Dim_Obj_Tab(l_index) := nvl(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);

2084: l_dim_obj_names := p_dim_obj_short_names;
2085: WHILE (is_more( p_dim_obj_short_names => l_dim_obj_names
2086: , p_dim_obj_name => l_dim_obj_name)
2087: ) LOOP
2088: l_Dim_Obj_Tab(l_index) := nvl(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);
2089: l_index := l_index + 1;
2090: END LOOP;
2091: BSC_BIS_LOCKS_PUB.Lock_Update_Dimension
2092: ( p_dimension_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id

Line 2959: l_Dim_Obj_Tab(l_index) := NVL(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);

2955: WHILE (is_more( p_dim_obj_short_names => l_dim_obj_names
2956: , p_dim_obj_name => l_dim_obj_name)
2957: ) LOOP
2958:
2959: l_Dim_Obj_Tab(l_index) := NVL(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);
2960: l_index := l_index + 1;
2961: END LOOP;
2962: END IF;
2963: -- Lock all the object that would be un-assigned to the Dimension

Line 2970: l_Dim_Obj_Tab(l_index) := NVL(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);

2966: l_dim_obj_names := p_unassign_dim_obj_names ;
2967: WHILE (is_more( p_dim_obj_short_names => l_dim_obj_names
2968: , p_dim_obj_name => l_dim_obj_name)
2969: ) LOOP
2970: l_Dim_Obj_Tab(l_index) := NVL(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);
2971: l_index := l_index + 1;
2972: END LOOP;
2973: END IF;
2974: -- Lock all the Dimension Objects to be assigned/unassigned to the Dimension