522: -- cache site salt value
523: l_site_salt := IBY_SECURITY_PKG.Get_Site_Salt;
524:
525: BEGIN
526: ad_parallel_updates_pkg.initialize_rowid_range(
527: ad_parallel_updates_pkg.ROWID_RANGE,
528: l_table_owner,
529: l_table_name,
530: l_script_name,
523: l_site_salt := IBY_SECURITY_PKG.Get_Site_Salt;
524:
525: BEGIN
526: ad_parallel_updates_pkg.initialize_rowid_range(
527: ad_parallel_updates_pkg.ROWID_RANGE,
528: l_table_owner,
529: l_table_name,
530: l_script_name,
531: x_worker_id,
531: x_worker_id,
532: x_num_workers,
533: x_batch_size, 0);
534:
535: ad_parallel_updates_pkg.get_rowid_range(
536: l_start_rowid,
537: l_end_rowid,
538: l_any_rows_to_process,
539: x_batch_size,
564: fnd_file.put_line(fnd_file.OUTPUT,'No. of credit card records updated = '|| l_rows_processed);
565: iby_debug_pub.add('Time taken = '|| (t2-t1),
566: iby_debug_pub.G_LEVEL_INFO,l_module_name);
567:
568: ad_parallel_updates_pkg.processed_rowid_range(
569: l_rows_processed,
570: l_end_rowid);
571:
572: COMMIT;
570: l_end_rowid);
571:
572: COMMIT;
573:
574: ad_parallel_updates_pkg.get_rowid_range(
575: l_start_rowid,
576: l_end_rowid,
577: l_any_rows_to_process,
578: x_batch_size,
739: -- cache site salt value
740: l_site_salt := IBY_SECURITY_PKG.Get_Site_Salt;
741:
742: BEGIN
743: ad_parallel_updates_pkg.initialize_rowid_range(
744: ad_parallel_updates_pkg.ROWID_RANGE,
745: l_table_owner,
746: l_table_name,
747: l_script_name,
740: l_site_salt := IBY_SECURITY_PKG.Get_Site_Salt;
741:
742: BEGIN
743: ad_parallel_updates_pkg.initialize_rowid_range(
744: ad_parallel_updates_pkg.ROWID_RANGE,
745: l_table_owner,
746: l_table_name,
747: l_script_name,
748: x_worker_id,
748: x_worker_id,
749: x_num_workers,
750: x_batch_size, 0);
751:
752: ad_parallel_updates_pkg.get_rowid_range(
753: l_start_rowid,
754: l_end_rowid,
755: l_any_rows_to_process,
756: x_batch_size,
784: iby_debug_pub.add('Time taken = '|| (t2-t1),
785: iby_debug_pub.G_LEVEL_INFO,l_module_name);
786: fnd_file.put_line(fnd_file.OUTPUT,'No. of bank account records updated = '|| l_rows_processed);
787:
788: ad_parallel_updates_pkg.processed_rowid_range(
789: l_rows_processed,
790: l_end_rowid);
791:
792: COMMIT;
790: l_end_rowid);
791:
792: COMMIT;
793:
794: ad_parallel_updates_pkg.get_rowid_range(
795: l_start_rowid,
796: l_end_rowid,
797: l_any_rows_to_process,
798: x_batch_size,