APPS.BEN_XRS_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_xrs_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 69

  update ben_ext_rslt
  set
  ext_rslt_id                       = p_rec.ext_rslt_id,
  run_strt_dt                       = p_rec.run_strt_dt,
  run_end_dt                        = p_rec.run_end_dt,
  ext_stat_cd                       = p_rec.ext_stat_cd,
  tot_rec_num                       = p_rec.tot_rec_num,
  tot_per_num                       = p_rec.tot_per_num,
  tot_err_num                       = p_rec.tot_err_num,
  eff_dt                            = p_rec.eff_dt,
  ext_strt_dt                       = p_rec.ext_strt_dt,
  ext_end_dt                        = p_rec.ext_end_dt,
  output_name                       = p_rec.output_name,
  drctry_name                       = p_rec.drctry_name,
  ext_dfn_id                        = p_rec.ext_dfn_id,
  business_group_id                 = p_rec.business_group_id,
  program_application_id            = p_rec.program_application_id,
  program_id                        = p_rec.program_id,
  program_update_date               = p_rec.program_update_date,
  request_id                        = p_rec.request_id,
  output_type                       = p_rec.output_type,
  xdo_template_id                   = p_rec.xdo_template_id,
  object_version_number             = p_rec.object_version_number
  where ext_rslt_id = p_rec.ext_rslt_id;

Line: 117

End update_dml;

Line: 151

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

Line: 159

End pre_update;

Line: 193

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

Line: 206

    ben_xrs_rku.after_update
      (
  p_ext_rslt_id                   =>p_rec.ext_rslt_id
 ,p_run_strt_dt                   =>p_rec.run_strt_dt
 ,p_run_end_dt                    =>p_rec.run_end_dt
 ,p_ext_stat_cd                   =>p_rec.ext_stat_cd
 ,p_tot_rec_num                   =>p_rec.tot_rec_num
 ,p_tot_per_num                   =>p_rec.tot_per_num
 ,p_tot_err_num                   =>p_rec.tot_err_num
 ,p_eff_dt                        =>p_rec.eff_dt
 ,p_ext_strt_dt                   =>p_rec.ext_strt_dt
 ,p_ext_end_dt                    =>p_rec.ext_end_dt
 ,p_output_name                   =>p_rec.output_name
 ,p_drctry_name                   =>p_rec.drctry_name
 ,p_ext_dfn_id                    =>p_rec.ext_dfn_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_program_application_id        =>p_rec.program_application_id
 ,p_program_id                    =>p_rec.program_id
 ,p_program_update_date           =>p_rec.program_update_date
 ,p_request_id                    =>p_rec.request_id
 ,p_output_type                   =>p_rec.output_type
 ,p_xdo_template_id               =>p_rec.xdo_template_id
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_run_strt_dt_o                 =>ben_xrs_shd.g_old_rec.run_strt_dt
 ,p_run_end_dt_o                  =>ben_xrs_shd.g_old_rec.run_end_dt
 ,p_ext_stat_cd_o                 =>ben_xrs_shd.g_old_rec.ext_stat_cd
 ,p_tot_rec_num_o                 =>ben_xrs_shd.g_old_rec.tot_rec_num
 ,p_tot_per_num_o                 =>ben_xrs_shd.g_old_rec.tot_per_num
 ,p_tot_err_num_o                 =>ben_xrs_shd.g_old_rec.tot_err_num
 ,p_eff_dt_o                      =>ben_xrs_shd.g_old_rec.eff_dt
 ,p_ext_strt_dt_o                 =>ben_xrs_shd.g_old_rec.ext_strt_dt
 ,p_ext_end_dt_o                  =>ben_xrs_shd.g_old_rec.ext_end_dt
 ,p_output_name_o                 =>ben_xrs_shd.g_old_rec.output_name
 ,p_drctry_name_o                 =>ben_xrs_shd.g_old_rec.drctry_name
 ,p_ext_dfn_id_o                  =>ben_xrs_shd.g_old_rec.ext_dfn_id
 ,p_business_group_id_o           =>ben_xrs_shd.g_old_rec.business_group_id
 ,p_program_application_id_o      =>ben_xrs_shd.g_old_rec.program_application_id
 ,p_program_id_o                  =>ben_xrs_shd.g_old_rec.program_id
 ,p_program_update_date_o         =>ben_xrs_shd.g_old_rec.program_update_date
 ,p_request_id_o                  =>ben_xrs_shd.g_old_rec.request_id
 ,p_output_type_o                 =>ben_xrs_shd.g_old_rec.output_type
 ,p_xdo_template_id_o             =>ben_xrs_shd.g_old_rec.xdo_template_id
 ,p_object_version_number_o       =>ben_xrs_shd.g_old_rec.object_version_number
      );

Line: 266

End post_update;

Line: 384

  If (p_rec.program_update_date = hr_api.g_date) then
    p_rec.program_update_date :=
    ben_xrs_shd.g_old_rec.program_update_date;

Line: 437

  ben_xrs_bus.update_validate(p_rec
  ,p_effective_date);

Line: 442

  pre_update(p_rec);

Line: 446

  update_dml(p_rec);

Line: 450

  post_update(
p_effective_date,p_rec);

Line: 476

  p_program_update_date          in date             default hr_api.g_date,
  p_request_id                   in number           default hr_api.g_number,
  p_output_type                  in varchar2         default hr_api.g_varchar2,
  p_xdo_template_id              in number           default hr_api.g_number,
  p_object_version_number        in out nocopy number
  ) is
--
  l_rec	  ben_xrs_shd.g_rec_type;

Line: 511

  p_program_update_date,
  p_request_id,
  p_output_type,
  p_xdo_template_id ,
  p_object_version_number
  );