[Home] [Help]
1555: , Created_By
1556: , Last_Updated_By
1557: , Last_Update_Date
1558: , Last_Update_Login
1559: FROM BSC_SYS_DIM_GROUPS_VL;
1560:
1561: CURSOR dim_obj_short_name IS
1562: SELECT A.short_name short_name
1563: FROM BIS_LEVELS A
1579: WHERE short_name IS NULL;
1580:
1581: FOR cd IN c_bis_dims LOOP
1582: SELECT COUNT(1) INTO l_count
1583: FROM BSC_SYS_DIM_GROUPS_VL
1584: WHERE short_name = cd.Short_Name;
1585:
1586: IF (l_count = 0) THEN
1587: IF (cd.Dimension_Id <> -1) THEN
1648: SELECT COUNT(1) INTO l_count
1649: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
1650: WHERE dim_level_id = l_cn_dim_level_id
1651: AND dim_group_id = (SELECT Dim_Group_Id
1652: FROM BSC_SYS_DIM_GROUPS_VL WHERE SHORT_NAME = cd.Short_Name);
1653:
1654: IF (l_count = 0) THEN
1655: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object
1656: (
2737: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2738:
2739: CURSOR c_bsc_rel is
2740: SELECT bsc_lvl.short_name, bis_dim.dimension_id
2741: FROM bsc_sys_dim_groups_vl bsc_dim,
2742: bsc_sys_dim_levels_b bsc_lvl,
2743: bsc_sys_dim_levels_by_group lvl_by_grp,
2744: bis_dimensions bis_dim
2745: WHERE bsc_dim.dim_group_id = lvl_by_grp.dim_group_id
2834: FUNCTION Hide_Unused_Import_Dim(
2835: x_error_msg OUT NOCOPY VARCHAR2
2836: ) RETURN BOOLEAN
2837: IS
2838: TYPE t_short_names IS TABLE OF BSC_SYS_DIM_GROUPS_VL.SHORT_NAME%TYPE INDEX BY BINARY_INTEGER;
2839: l_dim_short_names t_short_names;
2840: l_row_count NUMBER := 0;
2841: l_region_count NUMBER;
2842:
2847: CURSOR cr_pmf_import_dims IS
2848: SELECT
2849: short_name
2850: FROM
2851: bsc_sys_dim_groups_vl grp
2852: WHERE
2853: bsc_bis_dimension_pub.get_dimension_source(short_name)='PMF' AND
2854: short_name LIKE 'DGRP_%' AND
2855: name = short_name AND