APPS.BEN_BBP_UPD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 54

Procedure update_dml(p_rec in out nocopy ben_bbp_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 69

  update ben_batch_parameter
  set
  batch_parameter_id                = p_rec.batch_parameter_id,
  batch_exe_cd                      = p_rec.batch_exe_cd,
  thread_cnt_num                    = p_rec.thread_cnt_num,
  max_err_num                       = p_rec.max_err_num,
  chunk_size                        = p_rec.chunk_size,
  business_group_id                 = p_rec.business_group_id,
  object_version_number             = p_rec.object_version_number
  where batch_parameter_id = p_rec.batch_parameter_id;

Line: 103

End update_dml;

Line: 137

Procedure pre_update(p_rec in ben_bbp_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 145

End pre_update;

Line: 179

Procedure post_update(p_effective_date in date,
                      p_rec in ben_bbp_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 192

    ben_bbp_rku.after_update
      (p_batch_parameter_id      =>p_rec.batch_parameter_id
      ,p_batch_exe_cd            =>p_rec.batch_exe_cd
      ,p_thread_cnt_num          =>p_rec.thread_cnt_num
      ,p_max_err_num             =>p_rec.max_err_num
      ,p_chunk_size              =>p_rec.chunk_size
      ,p_business_group_id       =>p_rec.business_group_id
      ,p_object_version_number   =>p_rec.object_version_number
      ,p_effective_date          =>p_effective_date
      ,p_batch_exe_cd_o          =>ben_bbp_shd.g_old_rec.batch_exe_cd
      ,p_thread_cnt_num_o        =>ben_bbp_shd.g_old_rec.thread_cnt_num
      ,p_max_err_num_o           =>ben_bbp_shd.g_old_rec.max_err_num
      ,p_chunk_size_o            =>ben_bbp_shd.g_old_rec.chunk_size
      ,p_business_group_id_o     =>ben_bbp_shd.g_old_rec.business_group_id
      ,p_object_version_number_o =>ben_bbp_shd.g_old_rec.object_version_number);

Line: 222

End post_update;

Line: 335

  ben_bbp_bus.update_validate(p_rec,p_effective_date);

Line: 339

  pre_update(p_rec);

Line: 343

  update_dml(p_rec);

Line: 347

  post_update(p_effective_date,p_rec);