337: ELSIF p_application_id = 201 then
338: l_table_name :='PO_HEADERS_ALL';
339: END IF;
340:
341: ad_parallel_updates_pkg.initialize_rowid_range(
342: ad_parallel_updates_pkg.ROWID_RANGE,
343: l_table_owner,
344: l_table_name,
345: p_script_name,
338: l_table_name :='PO_HEADERS_ALL';
339: END IF;
340:
341: ad_parallel_updates_pkg.initialize_rowid_range(
342: ad_parallel_updates_pkg.ROWID_RANGE,
343: l_table_owner,
344: l_table_name,
345: p_script_name,
346: X_worker_id,
346: X_worker_id,
347: X_num_workers,
348: X_batch_size, 0);
349:
350: ad_parallel_updates_pkg.get_rowid_range(
351: l_start_rowid,
352: l_end_rowid,
353: l_any_rows_to_process,
354: X_batch_size,
397:
398:
399: l_rows_processed := x_rows_processed ;
400:
401: ad_parallel_updates_pkg.processed_rowid_range(
402: l_rows_processed,
403: l_end_rowid);
404:
405: COMMIT;
403: l_end_rowid);
404:
405: COMMIT;
406:
407: ad_parallel_updates_pkg.get_rowid_range(
408: l_start_rowid,
409: l_end_rowid,
410: l_any_rows_to_process,
411: X_batch_size,