APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_SYS_DIM_LEVELS_VL

Line 1537: l_dim_obj_sht_name BSC_SYS_DIM_LEVELS_VL.Short_Name%TYPE;

1533:
1534: l_valid_Assign BOOLEAN := FALSE;
1535: l_do_not_cascade BOOLEAN := TRUE;
1536:
1537: l_dim_obj_sht_name BSC_SYS_DIM_LEVELS_VL.Short_Name%TYPE;
1538: l_Dim_Obj_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
1539: l_Dim_Obj_Name BSC_SYS_DIM_LEVELS_TL.Name%TYPE;
1540: l_Rolling_Period NUMBER;
1541:

Line 1558: BSC_SYS_DIM_LEVELS_VL C

1554: , C.Source
1555: , C.Name
1556: FROM BSC_SYS_DIM_LEVELS_BY_GROUP B,
1557: BSC_SYS_DIM_GROUPS_VL V,
1558: BSC_SYS_DIM_LEVELS_VL C
1559: WHERE V.Dim_Group_Id = B.Dim_Group_Id
1560: AND B.Dim_Level_Id = C.Dim_Level_Id
1561: AND V.Short_Name = p_Dim_Short_Name;
1562:

Line 4531: FROM bsc_sys_dim_levels_vl

4527: IS
4528:
4529: CURSOR C_SOURCE_DIM IS
4530: SELECT source,name
4531: FROM bsc_sys_dim_levels_vl
4532: WHERE INSTR(','||p_dim_short_names ||',' , ','||short_name||',') > 0;
4533:
4534: l_source VARCHAR2(20);
4535: l_true BOOLEAN;

Line 4549: FROM bsc_sys_dim_levels_vl

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;
4551:
4552: IF(l_diff_source_cnt > 1) THEN
4553: l_true := TRUE;

Line 4581: FROM bsc_sys_dim_levels_vl

4577: FND_MSG_PUB.ADD;
4578: ELSE
4579: SELECT distinct(NVL(source, 'BSC'))
4580: INTO x_dim_type
4581: FROM bsc_sys_dim_levels_vl
4582: WHERE INSTR(','||p_dim_short_names ||',',','||short_name||',') > 0;
4583: END IF;
4584: END IF;
4585: