158: )
159: IS
160:
161: l_user_id NUMBER;
162: l_dim_level_view BISBV_DIMENSION_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
163: l_database_object VARCHAR2(30);
164: l_dim_level_short_name BISBV_DIMENSION_LEVELS.DIMENSION_LEVEL_SHORT_NAME%TYPE;
165: counter NUMBER := 0;
166: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
160:
161: l_user_id NUMBER;
162: l_dim_level_view BISBV_DIMENSION_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
163: l_database_object VARCHAR2(30);
164: l_dim_level_short_name BISBV_DIMENSION_LEVELS.DIMENSION_LEVEL_SHORT_NAME%TYPE;
165: counter NUMBER := 0;
166: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
167:
168: CURSOR c_views IS