[Home] [Help]
1266: c_dim_object_rec refCursorType;
1267:
1268: l_dim_objects_sql VARCHAR2(1000) :=
1269: 'SELECT bis_lvl.short_name, bis_lvl.name
1270: FROM bis_dimensions bis_dim, bsc_sys_dim_groups_vl bsc_dim, bis_levels_vl bis_lvl, bsc_sys_dim_levels_b bsc_lvl, bsc_sys_dim_levels_by_group lvl_by_grp
1271: WHERE bis_dim.dim_grp_id = bsc_dim.dim_group_id
1272: AND bis_lvl.short_name = bsc_lvl.short_name
1273: AND bsc_dim.dim_group_id = lvl_by_grp.dim_group_id
1274: AND bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id
1531: l_view_name_rec c_view_name%ROWTYPE;
1532:
1533: CURSOR c_all_enabled IS
1534: SELECT total_flag
1535: FROM bsc_sys_dim_levels_b bsc_lvl, bis_dimensions bis_dim, bsc_sys_dim_levels_by_group lvl_by_grp
1536: WHERE bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id
1537: AND bis_dim.dim_grp_id = lvl_by_grp.dim_group_id
1538: AND bsc_lvl.short_name = p_dim_object
1539: AND bis_dim.short_name = p_dimension;
2447: l_num NUMBER;
2448:
2449: CURSOR c_dim_plus_dimlevel_rel_cursor(l_dim VARCHAR2, l_dim_level VARCHAR2) IS
2450: SELECT 1
2451: FROM bsc_sys_dim_groups_vl sys_dim_group, bsc_sys_dim_levels_vl sys_dim_levels, bsc_sys_dim_levels_by_group sys_dim_level_group, bis_levels bis_level, bis_dimensions bis_dim
2452: WHERE sys_dim_group.dim_group_id = sys_dim_level_group.dim_group_id
2453: AND sys_dim_levels.dim_level_id = sys_dim_level_group.dim_level_id
2454: AND sys_dim_group.dim_group_id = bis_dim.dim_grp_id
2455: AND sys_dim_levels.short_name = bis_level.short_name
2747: l_dim_names VARCHAR2(5000);
2748: CURSOR c_dimensions IS
2749: SELECT dim_group.name
2750: FROM
2751: bsc_sys_dim_levels_by_group dim_lev_by_group,
2752: bsc_sys_dim_levels_vl dim_lev,
2753: bsc_sys_dim_groups_vl dim_group
2754: WHERE
2755: dim_lev.short_name=p_dim_lev_short_name