347: -- build time dependencies as the processing could potentially reference
348: -- some tables that could be obsoleted in the current release
349: BEGIN -- AB1
350:
351: ad_parallel_updates_pkg.initialize_rowid_range(
352: ad_parallel_updates_pkg.ROWID_RANGE,
353: l_table_owner,
354: l_table_name,
355: l_update_name,
348: -- some tables that could be obsoleted in the current release
349: BEGIN -- AB1
350:
351: ad_parallel_updates_pkg.initialize_rowid_range(
352: ad_parallel_updates_pkg.ROWID_RANGE,
353: l_table_owner,
354: l_table_name,
355: l_update_name,
356: x_worker_id,
356: x_worker_id,
357: x_num_workers,
358: x_batch_size, 0);
359:
360: ad_parallel_updates_pkg.get_rowid_range(
361: l_start_rowid,
362: l_end_rowid,
363: l_any_rows_to_process,
364: x_batch_size,
904: CLOSE c_sr_current;
905:
906: l_rows_processed := l_loop_counter;
907:
908: ad_parallel_updates_pkg.processed_rowid_range(
909: l_rows_processed,
910: l_end_rowid);
911: COMMIT;
912:
912:
913: --
914: -- get new range of rowids
915: --
916: ad_parallel_updates_pkg.get_rowid_range(
917: l_start_rowid,
918: l_end_rowid,
919: l_any_rows_to_process,
920: x_batch_size,