[Home] [Help]
451:
452: l_Sync_Flag BOOLEAN;
453:
454: l_bis_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
455: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
456:
457: l_bis_dim_level_rec BIS_LEVELS%ROWTYPE;
458:
459: CURSOR c_Bis_Levels IS
885: , x_msg_count OUT NOCOPY NUMBER
886: , x_msg_data OUT NOCOPY VARCHAR2
887: ) IS
888: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
889: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
890: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
891:
892: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
893: l_application_id BIS_DIMENSIONS.Application_Id%TYPE;
2544: , x_msg_count OUT NOCOPY NUMBER
2545: , x_msg_data OUT NOCOPY VARCHAR2
2546: )IS
2547: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
2548: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2549: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
2550: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
2551: l_application_id BIS_DIMENSIONS.Application_Id%TYPE;
2552: l_bis_create BOOLEAN := FALSE;
3313: ) IS
3314:
3315: l_delete BOOLEAN := TRUE;
3316: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
3317: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3318: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
3319: l_Dim_Obj_Short_Name BIS_LEVELS.Short_Name%TYPE;
3320: l_count NUMBER;
3321: l_delete_count NUMBER := 0;
4542: l_true := FALSE;
4543:
4544: -- added to relax checking for mixed type of Dimension Objects within a Dimension
4545: -- for Autogenerated reports and removing the disctiction, BSC 5.3
4546: IF (p_Restrict_Dim_Validate IS NOT NULL OR BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE) THEN
4547: SELECT count(distinct(source))
4548: INTO l_diff_source_cnt
4549: FROM bsc_sys_dim_levels_vl
4550: WHERE INSTR(','||p_dim_short_names ||',',','||short_name||',') > 0;