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

Line: 69

  update ben_ptnl_ler_for_per
  set
  ptnl_ler_for_per_id               = p_rec.ptnl_ler_for_per_id,
  csd_by_ptnl_ler_for_per_id        = p_rec.csd_by_ptnl_ler_for_per_id,
  lf_evt_ocrd_dt                    = p_rec.lf_evt_ocrd_dt,
  trgr_table_pk_id                  = p_rec.trgr_table_pk_id,
  ptnl_ler_for_per_stat_cd          = p_rec.ptnl_ler_for_per_stat_cd,
  ptnl_ler_for_per_src_cd           = p_rec.ptnl_ler_for_per_src_cd,
  mnl_dt                            = p_rec.mnl_dt,
  enrt_perd_id                      = p_rec.enrt_perd_id,
  ntfn_dt                           = p_rec.ntfn_dt,
  dtctd_dt                          = p_rec.dtctd_dt,
  procd_dt                          = p_rec.procd_dt,
  unprocd_dt                        = p_rec.unprocd_dt,
  voidd_dt                          = p_rec.voidd_dt,
  mnlo_dt                           = p_rec.mnlo_dt,
  ler_id                            = p_rec.ler_id,
  person_id                         = p_rec.person_id,
  business_group_id                 = p_rec.business_group_id,
  request_id                        = p_rec.request_id,
  program_application_id            = p_rec.program_application_id,
  program_id                        = p_rec.program_id,
  program_update_date               = p_rec.program_update_date,
  object_version_number             = p_rec.object_version_number
  where ptnl_ler_for_per_id = p_rec.ptnl_ler_for_per_id;

Line: 118

End update_dml;

Line: 152

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

Line: 160

End pre_update;

Line: 194

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

Line: 207

    ben_ppl_rku.after_update
      (
  p_ptnl_ler_for_per_id           =>p_rec.ptnl_ler_for_per_id
 ,p_csd_by_ptnl_ler_for_per_id    =>p_rec.csd_by_ptnl_ler_for_per_id
 ,p_lf_evt_ocrd_dt                =>p_rec.lf_evt_ocrd_dt
 ,p_trgr_table_pk_id              =>p_rec.trgr_table_pk_id
 ,p_ptnl_ler_for_per_stat_cd      =>p_rec.ptnl_ler_for_per_stat_cd
 ,p_ptnl_ler_for_per_src_cd       =>p_rec.ptnl_ler_for_per_src_cd
 ,p_mnl_dt                        =>p_rec.mnl_dt
 ,p_enrt_perd_id                  =>p_rec.enrt_perd_id
 ,p_ntfn_dt                       =>p_rec.ntfn_dt
 ,p_dtctd_dt                      =>p_rec.dtctd_dt
 ,p_procd_dt                      =>p_rec.procd_dt
 ,p_unprocd_dt                    =>p_rec.unprocd_dt
 ,p_voidd_dt                      =>p_rec.voidd_dt
 ,p_mnlo_dt                       =>p_rec.mnlo_dt
 ,p_ler_id                        =>p_rec.ler_id
 ,p_person_id                     =>p_rec.person_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_request_id                    =>p_rec.request_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_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_csd_by_ptnl_ler_for_per_id_o  =>ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id
 ,p_lf_evt_ocrd_dt_o              =>ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt
 ,p_trgr_table_pk_id_o            =>ben_ppl_shd.g_old_rec.trgr_table_pk_id
 ,p_ptnl_ler_for_per_stat_cd_o    =>ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd
 ,p_ptnl_ler_for_per_src_cd_o     =>ben_ppl_shd.g_old_rec.ptnl_ler_for_per_src_cd
 ,p_mnl_dt_o                      =>ben_ppl_shd.g_old_rec.mnl_dt
 ,p_enrt_perd_id_o                =>ben_ppl_shd.g_old_rec.enrt_perd_id
 ,p_ntfn_dt_o                     =>ben_ppl_shd.g_old_rec.ntfn_dt
 ,p_dtctd_dt_o                    =>ben_ppl_shd.g_old_rec.dtctd_dt
 ,p_procd_dt_o                    =>ben_ppl_shd.g_old_rec.procd_dt
 ,p_unprocd_dt_o                  =>ben_ppl_shd.g_old_rec.unprocd_dt
 ,p_voidd_dt_o                    =>ben_ppl_shd.g_old_rec.voidd_dt
 ,p_mnlo_dt_o                     =>ben_ppl_shd.g_old_rec.mnlo_dt
 ,p_ler_id_o                      =>ben_ppl_shd.g_old_rec.ler_id
 ,p_person_id_o                   =>ben_ppl_shd.g_old_rec.person_id
 ,p_business_group_id_o           =>ben_ppl_shd.g_old_rec.business_group_id
 ,p_request_id_o                  =>ben_ppl_shd.g_old_rec.request_id
 ,p_program_application_id_o      =>ben_ppl_shd.g_old_rec.program_application_id
 ,p_program_id_o                  =>ben_ppl_shd.g_old_rec.program_id
 ,p_program_update_date_o         =>ben_ppl_shd.g_old_rec.program_update_date
 ,p_object_version_number_o       =>ben_ppl_shd.g_old_rec.object_version_number
      );

Line: 269

End post_update;

Line: 403

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

Line: 442

  ben_ppl_bus.update_validate(p_rec,p_effective_date);

Line: 446

  pre_update(p_rec);

Line: 450

  update_dml(p_rec);

Line: 454

  post_update(p_effective_date,p_rec);

Line: 484

  p_program_update_date          in date             default hr_api.g_date,
  p_object_version_number        in out nocopy number
  ) is
--
  l_rec	  ben_ppl_shd.g_rec_type;

Line: 520

  p_program_update_date,
  p_object_version_number
  );