538: -- Worker Processing
539: --
540:
541: BEGIN
542: ad_parallel_updates_pkg.initialize_rowid_range
543: (
544: ad_parallel_updates_pkg.ROWID_RANGE
545: , l_table_owner
546: , l_table_name
540:
541: BEGIN
542: ad_parallel_updates_pkg.initialize_rowid_range
543: (
544: ad_parallel_updates_pkg.ROWID_RANGE
545: , l_table_owner
546: , l_table_name
547: , l_update_name
548: , x_worker_id
550: , x_batch_size
551: , 0
552: );
553:
554: ad_parallel_updates_pkg.get_rowid_range
555: (
556: l_start_rowid
557: , l_end_rowid
558: , l_any_rows_to_process
572: ;
573:
574: l_rows_processed := SQL%ROWCOUNT;
575:
576: ad_parallel_updates_pkg.processed_rowid_range
577: (
578: l_rows_processed
579: , l_end_rowid
580: );
580: );
581:
582: COMMIT;
583:
584: ad_parallel_updates_pkg.get_rowid_range
585: (
586: l_start_rowid
587: , l_end_rowid
588: , l_any_rows_to_process