224: procedure clean_layer_style_shts
225: is
226: cursor c1( start_id NUMBER ) is
227: select LAYER_STYLE_SHEET_ID, rowid
228: from CSF_MD_LYR_STYLE_SHTS
229: where LAYER_STYLE_SHEET_ID >= start_id
230: order by LAYER_STYLE_SHEET_ID;
231: r1 c1%ROWTYPE;
232:
247: exit;
248: end if;
249:
250: if ( min_start_id = r1.LAYER_STYLE_SHEET_ID ) then
251: delete from CSF_MD_LYR_STYLE_SHTS where rowid = r1.rowid;
252: else
253: min_start_id := r1.LAYER_STYLE_SHEET_ID;
254: end if;
255: