DBA Data[Home] [Help]

APPS.MRP_UPDATE_MRP_INFO_PK dependencies on MRP_SCHEDULE_DATES

Line 211: mrp_schedule_dates dates

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

Line 279: 'TABLE', 'mrp_schedule_dates', 'N');

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:

Line 287: DELETE FROM mrp_schedule_dates dates

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: