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

Line: 69

  update ben_enrt_bnft
  set
  enrt_bnft_id                = p_rec.enrt_bnft_id
 ,dflt_flag                   = p_rec.dflt_flag
 ,val_has_bn_prortd_flag      = p_rec.val_has_bn_prortd_flag
 ,bndry_perd_cd               = p_rec.bndry_perd_cd
 ,val                         = p_rec.val
 ,nnmntry_uom                 = p_rec.nnmntry_uom
 ,bnft_typ_cd                 = p_rec.bnft_typ_cd
 ,entr_val_at_enrt_flag       = p_rec.entr_val_at_enrt_flag
 ,mn_val                      = p_rec.mn_val
 ,mx_val                      = p_rec.mx_val
 ,incrmt_val                  = p_rec.incrmt_val
 ,dflt_val                    = p_rec.dflt_val
 ,rt_typ_cd                   = p_rec.rt_typ_cd
 ,cvg_mlt_cd                  = p_rec.cvg_mlt_cd
 ,ctfn_rqd_flag               = p_rec.ctfn_rqd_flag
 ,ordr_num                    = p_rec.ordr_num
 ,crntly_enrld_flag           = p_rec.crntly_enrld_flag
 ,elig_per_elctbl_chc_id      = p_rec.elig_per_elctbl_chc_id
 ,prtt_enrt_rslt_id           = p_rec.prtt_enrt_rslt_id
 ,comp_lvl_fctr_id            = p_rec.comp_lvl_fctr_id
 ,business_group_id           = p_rec.business_group_id
 ,enb_attribute_category      = p_rec.enb_attribute_category
 ,enb_attribute1              = p_rec.enb_attribute1
 ,enb_attribute2              = p_rec.enb_attribute2
 ,enb_attribute3              = p_rec.enb_attribute3
 ,enb_attribute4              = p_rec.enb_attribute4
 ,enb_attribute5              = p_rec.enb_attribute5
 ,enb_attribute6              = p_rec.enb_attribute6
 ,enb_attribute7              = p_rec.enb_attribute7
 ,enb_attribute8              = p_rec.enb_attribute8
 ,enb_attribute9              = p_rec.enb_attribute9
 ,enb_attribute10             = p_rec.enb_attribute10
 ,enb_attribute11             = p_rec.enb_attribute11
 ,enb_attribute12             = p_rec.enb_attribute12
 ,enb_attribute13             = p_rec.enb_attribute13
 ,enb_attribute14             = p_rec.enb_attribute14
 ,enb_attribute15             = p_rec.enb_attribute15
 ,enb_attribute16             = p_rec.enb_attribute16
 ,enb_attribute17             = p_rec.enb_attribute17
 ,enb_attribute18             = p_rec.enb_attribute18
 ,enb_attribute19             = p_rec.enb_attribute19
 ,enb_attribute20             = p_rec.enb_attribute20
 ,enb_attribute21             = p_rec.enb_attribute21
 ,enb_attribute22             = p_rec.enb_attribute22
 ,enb_attribute23             = p_rec.enb_attribute23
 ,enb_attribute24             = p_rec.enb_attribute24
 ,enb_attribute25             = p_rec.enb_attribute25
 ,enb_attribute26             = p_rec.enb_attribute26
 ,enb_attribute27             = p_rec.enb_attribute27
 ,enb_attribute28             = p_rec.enb_attribute28
 ,enb_attribute29             = p_rec.enb_attribute29
 ,enb_attribute30             = p_rec.enb_attribute30
 ,request_id                  = p_rec.request_id
 ,program_application_id      = p_rec.program_application_id
 ,program_id                  = p_rec.program_id
 ,mx_wout_ctfn_val            = p_rec.mx_wout_ctfn_val
 ,mx_wo_ctfn_flag             = p_rec.mx_wo_ctfn_flag
 ,program_update_date         = p_rec.program_update_date
 ,object_version_number       = p_rec.object_version_number
 where enrt_bnft_id = p_rec.enrt_bnft_id;

Line: 155

End update_dml;

Line: 189

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

Line: 197

End pre_update;

Line: 231

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

Line: 244

    ben_enb_rku.after_update
 (
  p_enrt_bnft_id                =>p_rec.enrt_bnft_id
 ,p_dflt_flag                   =>p_rec.dflt_flag
 ,p_val_has_bn_prortd_flag      =>p_rec.val_has_bn_prortd_flag
 ,p_bndry_perd_cd               =>p_rec.bndry_perd_cd
 ,p_val                         =>p_rec.val
 ,p_nnmntry_uom                 =>p_rec.nnmntry_uom
 ,p_bnft_typ_cd                 =>p_rec.bnft_typ_cd
 ,p_entr_val_at_enrt_flag       =>p_rec.entr_val_at_enrt_flag
 ,p_mn_val                      =>p_rec.mn_val
 ,p_mx_val                      =>p_rec.mx_val
 ,p_incrmt_val                  =>p_rec.incrmt_val
 ,p_dflt_val                    =>p_rec.dflt_val
 ,p_rt_typ_cd                   =>p_rec.rt_typ_cd
 ,p_cvg_mlt_cd                  =>p_rec.cvg_mlt_cd
 ,p_ctfn_rqd_flag               =>p_rec.ctfn_rqd_flag
 ,p_ordr_num                    =>p_rec.ordr_num
 ,p_crntly_enrld_flag           =>p_rec.crntly_enrld_flag
 ,p_elig_per_elctbl_chc_id      =>p_rec.elig_per_elctbl_chc_id
 ,p_prtt_enrt_rslt_id           =>p_rec.prtt_enrt_rslt_id
 ,p_comp_lvl_fctr_id            =>p_rec.comp_lvl_fctr_id
 ,p_business_group_id           =>p_rec.business_group_id
 ,p_enb_attribute_category      =>p_rec.enb_attribute_category
 ,p_enb_attribute1              =>p_rec.enb_attribute1
 ,p_enb_attribute2              =>p_rec.enb_attribute2
 ,p_enb_attribute3              =>p_rec.enb_attribute3
 ,p_enb_attribute4              =>p_rec.enb_attribute4
 ,p_enb_attribute5              =>p_rec.enb_attribute5
 ,p_enb_attribute6              =>p_rec.enb_attribute6
 ,p_enb_attribute7              =>p_rec.enb_attribute7
 ,p_enb_attribute8              =>p_rec.enb_attribute8
 ,p_enb_attribute9              =>p_rec.enb_attribute9
 ,p_enb_attribute10             =>p_rec.enb_attribute10
 ,p_enb_attribute11             =>p_rec.enb_attribute11
 ,p_enb_attribute12             =>p_rec.enb_attribute12
 ,p_enb_attribute13             =>p_rec.enb_attribute13
 ,p_enb_attribute14             =>p_rec.enb_attribute14
 ,p_enb_attribute15             =>p_rec.enb_attribute15
 ,p_enb_attribute16             =>p_rec.enb_attribute16
 ,p_enb_attribute17             =>p_rec.enb_attribute17
 ,p_enb_attribute18             =>p_rec.enb_attribute18
 ,p_enb_attribute19             =>p_rec.enb_attribute19
 ,p_enb_attribute20             =>p_rec.enb_attribute20
 ,p_enb_attribute21             =>p_rec.enb_attribute21
 ,p_enb_attribute22             =>p_rec.enb_attribute22
 ,p_enb_attribute23             =>p_rec.enb_attribute23
 ,p_enb_attribute24             =>p_rec.enb_attribute24
 ,p_enb_attribute25             =>p_rec.enb_attribute25
 ,p_enb_attribute26             =>p_rec.enb_attribute26
 ,p_enb_attribute27             =>p_rec.enb_attribute27
 ,p_enb_attribute28             =>p_rec.enb_attribute28
 ,p_enb_attribute29             =>p_rec.enb_attribute29
 ,p_enb_attribute30             =>p_rec.enb_attribute30
 ,p_request_id                  =>p_rec.request_id
 ,p_program_application_id      =>p_rec.program_application_id
 ,p_program_id                  =>p_rec.program_id
 ,p_mx_wout_ctfn_val            =>p_rec.mx_wout_ctfn_val
 ,p_mx_wo_ctfn_flag             =>p_rec.mx_wo_ctfn_flag
 ,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_dflt_flag_o                 =>ben_enb_shd.g_old_rec.dflt_flag
 ,p_val_has_bn_prortd_flag_o    =>ben_enb_shd.g_old_rec.val_has_bn_prortd_flag
 ,p_bndry_perd_cd_o             =>ben_enb_shd.g_old_rec.bndry_perd_cd
 ,p_val_o                       =>ben_enb_shd.g_old_rec.val
 ,p_nnmntry_uom_o               =>ben_enb_shd.g_old_rec.nnmntry_uom
 ,p_bnft_typ_cd_o               =>ben_enb_shd.g_old_rec.bnft_typ_cd
 ,p_entr_val_at_enrt_flag_o     =>ben_enb_shd.g_old_rec.entr_val_at_enrt_flag
 ,p_mn_val_o                    =>ben_enb_shd.g_old_rec.mn_val
 ,p_mx_val_o                    =>ben_enb_shd.g_old_rec.mx_val
 ,p_incrmt_val_o                =>ben_enb_shd.g_old_rec.incrmt_val
 ,p_dflt_val_o                  =>ben_enb_shd.g_old_rec.dflt_val
 ,p_rt_typ_cd_o                 =>ben_enb_shd.g_old_rec.rt_typ_cd
 ,p_cvg_mlt_cd_o                =>ben_enb_shd.g_old_rec.cvg_mlt_cd
 ,p_ctfn_rqd_flag_o             =>ben_enb_shd.g_old_rec.ctfn_rqd_flag
 ,p_ordr_num_o                  =>ben_enb_shd.g_old_rec.ordr_num
 ,p_crntly_enrld_flag_o         =>ben_enb_shd.g_old_rec.crntly_enrld_flag
 ,p_elig_per_elctbl_chc_id_o    =>ben_enb_shd.g_old_rec.elig_per_elctbl_chc_id
 ,p_prtt_enrt_rslt_id_o         =>ben_enb_shd.g_old_rec.prtt_enrt_rslt_id
 ,p_comp_lvl_fctr_id_o          =>ben_enb_shd.g_old_rec.comp_lvl_fctr_id
 ,p_business_group_id_o         =>ben_enb_shd.g_old_rec.business_group_id
 ,p_enb_attribute_category_o    =>ben_enb_shd.g_old_rec.enb_attribute_category
 ,p_enb_attribute1_o            =>ben_enb_shd.g_old_rec.enb_attribute1
 ,p_enb_attribute2_o            =>ben_enb_shd.g_old_rec.enb_attribute2
 ,p_enb_attribute3_o            =>ben_enb_shd.g_old_rec.enb_attribute3
 ,p_enb_attribute4_o            =>ben_enb_shd.g_old_rec.enb_attribute4
 ,p_enb_attribute5_o            =>ben_enb_shd.g_old_rec.enb_attribute5
 ,p_enb_attribute6_o            =>ben_enb_shd.g_old_rec.enb_attribute6
 ,p_enb_attribute7_o            =>ben_enb_shd.g_old_rec.enb_attribute7
 ,p_enb_attribute8_o            =>ben_enb_shd.g_old_rec.enb_attribute8
 ,p_enb_attribute9_o            =>ben_enb_shd.g_old_rec.enb_attribute9
 ,p_enb_attribute10_o           =>ben_enb_shd.g_old_rec.enb_attribute10
 ,p_enb_attribute11_o           =>ben_enb_shd.g_old_rec.enb_attribute11
 ,p_enb_attribute12_o           =>ben_enb_shd.g_old_rec.enb_attribute12
 ,p_enb_attribute13_o           =>ben_enb_shd.g_old_rec.enb_attribute13
 ,p_enb_attribute14_o           =>ben_enb_shd.g_old_rec.enb_attribute14
 ,p_enb_attribute15_o           =>ben_enb_shd.g_old_rec.enb_attribute15
 ,p_enb_attribute16_o           =>ben_enb_shd.g_old_rec.enb_attribute16
 ,p_enb_attribute17_o           =>ben_enb_shd.g_old_rec.enb_attribute17
 ,p_enb_attribute18_o           =>ben_enb_shd.g_old_rec.enb_attribute18
 ,p_enb_attribute19_o           =>ben_enb_shd.g_old_rec.enb_attribute19
 ,p_enb_attribute20_o           =>ben_enb_shd.g_old_rec.enb_attribute20
 ,p_enb_attribute21_o           =>ben_enb_shd.g_old_rec.enb_attribute21
 ,p_enb_attribute22_o           =>ben_enb_shd.g_old_rec.enb_attribute22
 ,p_enb_attribute23_o           =>ben_enb_shd.g_old_rec.enb_attribute23
 ,p_enb_attribute24_o           =>ben_enb_shd.g_old_rec.enb_attribute24
 ,p_enb_attribute25_o           =>ben_enb_shd.g_old_rec.enb_attribute25
 ,p_enb_attribute26_o           =>ben_enb_shd.g_old_rec.enb_attribute26
 ,p_enb_attribute27_o           =>ben_enb_shd.g_old_rec.enb_attribute27
 ,p_enb_attribute28_o           =>ben_enb_shd.g_old_rec.enb_attribute28
 ,p_enb_attribute29_o           =>ben_enb_shd.g_old_rec.enb_attribute29
 ,p_enb_attribute30_o           =>ben_enb_shd.g_old_rec.enb_attribute30
 ,p_request_id_o                =>ben_enb_shd.g_old_rec.request_id
 ,p_program_application_id_o    =>ben_enb_shd.g_old_rec.program_application_id
 ,p_program_id_o                =>ben_enb_shd.g_old_rec.program_id
 ,p_mx_wout_ctfn_val_o          =>ben_enb_shd.g_old_rec.mx_wout_ctfn_val
 ,p_mx_wo_ctfn_flag_o           =>ben_enb_shd.g_old_rec.mx_wo_ctfn_flag
 ,p_program_update_date_o       =>ben_enb_shd.g_old_rec.program_update_date
 ,p_object_version_number_o     =>ben_enb_shd.g_old_rec.object_version_number
);

Line: 380

End post_update;

Line: 635

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

Line: 701

  ben_enb_bus.update_validate
    (p_rec
     ,p_effective_date
    );

Line: 708

  pre_update(p_rec);

Line: 712

  update_dml(p_rec);

Line: 716

  post_update(p_effective_date,p_rec);

Line: 783

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

Line: 856

   ,p_program_update_date
   ,p_object_version_number
  );