73: WHERE TAB_ID = p_Tab_Id
74: AND DIM_LEVEL_INDEX >= v_Index;
75: l_deleted_rows := sql%rowcount;
76: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels l_deleted_rows = ' ||l_deleted_rows);
77: -- Delete Records from BSC_USER_LIST_ACCESS that not apply any more
78: DELETE FROM BSC_USER_LIST_ACCESS
79: WHERE TAB_ID = p_Tab_Id
80: AND DIM_LEVEL_INDEX >= v_Index;
81:
74: AND DIM_LEVEL_INDEX >= v_Index;
75: l_deleted_rows := sql%rowcount;
76: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels l_deleted_rows = ' ||l_deleted_rows);
77: -- Delete Records from BSC_USER_LIST_ACCESS that not apply any more
78: DELETE FROM BSC_USER_LIST_ACCESS
79: WHERE TAB_ID = p_Tab_Id
80: AND DIM_LEVEL_INDEX >= v_Index;
81:
82: x_return_status := 'DISABLE';