672:
673: x_success_count := 0;
674: x_failure_count := 0;
675:
676: l_batch_size := nvl(nvl(p_batch_size, fa_cache_pkg.fa_batch_size), 1000);
677:
678: open c_trans;
679: loop
680:
3188:
3189: x_success_count := 0;
3190: x_failure_count := 0;
3191:
3192: l_batch_size := nvl(nvl(p_batch_size, fa_cache_pkg.fa_batch_size), 1000);
3193:
3194: open c_trans;
3195: loop
3196:
4265:
4266: x_success_count := 0;
4267: x_failure_count := 0;
4268:
4269: l_batch_size := nvl(nvl(p_batch_size, fa_cache_pkg.fa_batch_size), 1000);
4270:
4271: -- Select upg_batch_id
4272: select xla_upg_batches_s.nextval
4273: into l_upg_batch_id
6573:
6574: x_success_count := 0;
6575: x_failure_count := 0;
6576:
6577: l_batch_size := nvl(nvl(p_batch_size, fa_cache_pkg.fa_batch_size), 1000);
6578:
6579: -- Select upg_batch_id
6580: select xla_upg_batches_s.nextval
6581: into l_upg_batch_id
8416:
8417: x_success_count := 0;
8418: x_failure_count := 0;
8419:
8420: l_batch_size := nvl(nvl(p_batch_size, fa_cache_pkg.fa_batch_size), 1000);
8421:
8422: open c_deferred_deprn;
8423:
8424: loop