139:
140: l_debug_stmt := 'Deleting from BSC_SYS_MEASURES table';
141: Delete From BSC_SYS_MEASURES where MEASURE_ID <> -1;
142:
143: l_debug_stmt := 'Deleting from BSC_SYS_DIM_LEVELS_BY_GROUP table';
144: Delete From BSC_SYS_DIM_LEVELS_BY_GROUP;
145:
146: l_debug_stmt := 'Deleting from BSC_SYS_DIM_GROUPS_TL table';
147: Delete From BSC_SYS_DIM_GROUPS_TL;
140: l_debug_stmt := 'Deleting from BSC_SYS_MEASURES table';
141: Delete From BSC_SYS_MEASURES where MEASURE_ID <> -1;
142:
143: l_debug_stmt := 'Deleting from BSC_SYS_DIM_LEVELS_BY_GROUP table';
144: Delete From BSC_SYS_DIM_LEVELS_BY_GROUP;
145:
146: l_debug_stmt := 'Deleting from BSC_SYS_DIM_GROUPS_TL table';
147: Delete From BSC_SYS_DIM_GROUPS_TL;
148:
154:
155: l_debug_stmt := 'Deleting from BSC_SYS_DIM_LEVELS_TL table';
156: Delete From BSC_SYS_DIM_LEVELS_TL;
157:
158: l_debug_stmt := 'Deleting from BSC_SYS_DIM_LEVELS_B table';
159: Delete From BSC_SYS_DIM_LEVELS_B;
160:
161: l_debug_stmt := 'Deleting from BSC_SYS_DIM_LEVEL_COLS table';
162: Delete From BSC_SYS_DIM_LEVEL_COLS;
155: l_debug_stmt := 'Deleting from BSC_SYS_DIM_LEVELS_TL table';
156: Delete From BSC_SYS_DIM_LEVELS_TL;
157:
158: l_debug_stmt := 'Deleting from BSC_SYS_DIM_LEVELS_B table';
159: Delete From BSC_SYS_DIM_LEVELS_B;
160:
161: l_debug_stmt := 'Deleting from BSC_SYS_DIM_LEVEL_COLS table';
162: Delete From BSC_SYS_DIM_LEVEL_COLS;
163: