207:
208: CURSOR dates_cursor IS
209: SELECT dates.rowid
210: FROM
211: mrp_schedule_dates dates
212: WHERE dates.schedule_quantity >= 0
213: AND dates.original_schedule_quantity >= 0
214: AND dates.schedule_level = PSEUDO_SCHEDULE
215: AND dates.schedule_origination_type = NULL_VALUE
275:
276:
277: var_watch_id := mrp_print_pk.start_watch(
278: 'GEN-deleted from table', arg_request_id, arg_user_id,
279: 'TABLE', 'mrp_schedule_dates', 'N');
280: var_row_count := 0;
281: OPEN dates_cursor;
282: LOOP
283:
283:
284: FETCH dates_cursor INTO var_rowid;
285: exit when dates_cursor%notfound;
286:
287: DELETE FROM mrp_schedule_dates dates
288: WHERE rowid = var_rowid;
289:
290: var_row_count := var_row_count + NVL(SQL%ROWCOUNT, 0);
291: