480: set transaction_status = l_transaction_status(i)
481: where mass_external_transfer_id = l_mass_external_transfer_id(i);
482: end;
483:
484: FND_CONCURRENT.AF_COMMIT;
485:
486: if (l_mass_external_transfer_id.count = 0) then
487: -- Exit worker
488: return;
534: set transaction_status = l_transaction_status(i)
535: where mass_external_transfer_id = l_mass_external_transfer_id(i);
536: end;
537:
538: FND_CONCURRENT.AF_COMMIT;
539:
540: if (l_counter <> 0) then
541: -- Set the max id only if rows were fetched
542: px_max_mass_ext_transfer_id :=
691: update fa_mass_external_transfers
692: set worker_id = l_worker_id(i)
693: where mass_external_transfer_id = l_mass_external_transfer_id(i);
694:
695: FND_CONCURRENT.AF_COMMIT;
696:
697: exit when tfr_lines%NOTFOUND;
698:
699: end loop;