eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CPP_UPD SQL Statements

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

Line: 57


Procedure dt_update_dml
	(p_rec 			 in out nocopy ben_cpp_shd.g_rec_type,
	 p_effective_date	 in	date,
	 p_datetrack_mode	 in	varchar2,
	 p_validation_start_date in	date,
	 p_validation_end_date	 in	date) is
--
  l_proc	varchar2(72) := g_package||'dt_update_dml';

Line: 85


    update  ben_plip_f
    set
        plip_id                         = p_rec.plip_id,
    business_group_id               = p_rec.business_group_id,
    pgm_id                          = p_rec.pgm_id,
    pl_id                           = p_rec.pl_id,
    cmbn_plip_id                    = p_rec.cmbn_plip_id,
    dflt_flag                       = p_rec.dflt_flag,
    plip_stat_cd                    = p_rec.plip_stat_cd,
    dflt_enrt_cd                    = p_rec.dflt_enrt_cd,
    dflt_enrt_det_rl                = p_rec.dflt_enrt_det_rl,
    ordr_num                        = p_rec.ordr_num,
    alws_unrstrctd_enrt_flag        = p_rec.alws_unrstrctd_enrt_flag,
    auto_enrt_mthd_rl               = p_rec.auto_enrt_mthd_rl,
    enrt_cd                         = p_rec.enrt_cd,
    enrt_mthd_cd                    = p_rec.enrt_mthd_cd,
    enrt_rl                         = p_rec.enrt_rl,
    ivr_ident                       = p_rec.ivr_ident,
    url_ref_name                    = p_rec.url_ref_name,
    enrt_cvg_strt_dt_cd             = p_rec.enrt_cvg_strt_dt_cd,
    enrt_cvg_strt_dt_rl             = p_rec.enrt_cvg_strt_dt_rl,
    enrt_cvg_end_dt_cd              = p_rec.enrt_cvg_end_dt_cd,
    enrt_cvg_end_dt_rl              = p_rec.enrt_cvg_end_dt_rl,
    rt_strt_dt_cd                   = p_rec.rt_strt_dt_cd,
    rt_strt_dt_rl                   = p_rec.rt_strt_dt_rl,
    rt_end_dt_cd                    = p_rec.rt_end_dt_cd,
    rt_end_dt_rl                    = p_rec.rt_end_dt_rl,
    drvbl_fctr_apls_rts_flag        = p_rec.drvbl_fctr_apls_rts_flag,
    drvbl_fctr_prtn_elig_flag       = p_rec.drvbl_fctr_prtn_elig_flag,
    elig_apls_flag                  = p_rec.elig_apls_flag,
    prtn_elig_ovrid_alwd_flag       = p_rec.prtn_elig_ovrid_alwd_flag,
    trk_inelig_per_flag             = p_rec.trk_inelig_per_flag,
    postelcn_edit_rl                = p_rec.postelcn_edit_rl,
    dflt_to_asn_pndg_ctfn_cd        = p_rec.dflt_to_asn_pndg_ctfn_cd,
    dflt_to_asn_pndg_ctfn_rl        = p_rec.dflt_to_asn_pndg_ctfn_rl,
    mn_cvg_amt                      = p_rec.mn_cvg_amt,
    mn_cvg_rl                       = p_rec.mn_cvg_rl,
    mx_cvg_alwd_amt                 = p_rec.mx_cvg_alwd_amt,
    mx_cvg_incr_alwd_amt            = p_rec.mx_cvg_incr_alwd_amt,
    mx_cvg_incr_wcf_alwd_amt        = p_rec.mx_cvg_incr_wcf_alwd_amt,
    mx_cvg_mlt_incr_num             = p_rec.mx_cvg_mlt_incr_num,
    mx_cvg_mlt_incr_wcf_num         = p_rec.mx_cvg_mlt_incr_wcf_num,
    mx_cvg_rl                       = p_rec.mx_cvg_rl,
    mx_cvg_wcfn_amt                 = p_rec.mx_cvg_wcfn_amt,
    mx_cvg_wcfn_mlt_num             = p_rec.mx_cvg_wcfn_mlt_num,
    no_mn_cvg_amt_apls_flag         = p_rec.no_mn_cvg_amt_apls_flag,
    no_mn_cvg_incr_apls_flag        = p_rec.no_mn_cvg_incr_apls_flag,
    no_mx_cvg_amt_apls_flag         = p_rec.no_mx_cvg_amt_apls_flag,
    no_mx_cvg_incr_apls_flag        = p_rec.no_mx_cvg_incr_apls_flag,
    unsspnd_enrt_cd                 = p_rec.unsspnd_enrt_cd,
    prort_prtl_yr_cvg_rstrn_cd      = p_rec.prort_prtl_yr_cvg_rstrn_cd,
    prort_prtl_yr_cvg_rstrn_rl      = p_rec.prort_prtl_yr_cvg_rstrn_rl,
    cvg_incr_r_decr_only_cd         = p_rec.cvg_incr_r_decr_only_cd,
    bnft_or_option_rstrctn_cd       = p_rec.bnft_or_option_rstrctn_cd,
    per_cvrd_cd                     = p_rec.per_cvrd_cd ,
    short_name                     = p_rec.short_name ,
    short_code                     = p_rec.short_code ,
        legislation_code                     = p_rec.legislation_code ,
        legislation_subgroup                     = p_rec.legislation_subgroup ,
    vrfy_fmly_mmbr_rl               = p_rec.vrfy_fmly_mmbr_rl  ,
    vrfy_fmly_mmbr_cd               = p_rec.vrfy_fmly_mmbr_cd,
    use_csd_rsd_prccng_cd           = p_rec.use_csd_rsd_prccng_cd,
    cpp_attribute_category          = p_rec.cpp_attribute_category,
    cpp_attribute1                  = p_rec.cpp_attribute1,
    cpp_attribute2                  = p_rec.cpp_attribute2,
    cpp_attribute3                  = p_rec.cpp_attribute3,
    cpp_attribute4                  = p_rec.cpp_attribute4,
    cpp_attribute5                  = p_rec.cpp_attribute5,
    cpp_attribute6                  = p_rec.cpp_attribute6,
    cpp_attribute7                  = p_rec.cpp_attribute7,
    cpp_attribute8                  = p_rec.cpp_attribute8,
    cpp_attribute9                  = p_rec.cpp_attribute9,
    cpp_attribute10                 = p_rec.cpp_attribute10,
    cpp_attribute11                 = p_rec.cpp_attribute11,
    cpp_attribute12                 = p_rec.cpp_attribute12,
    cpp_attribute13                 = p_rec.cpp_attribute13,
    cpp_attribute14                 = p_rec.cpp_attribute14,
    cpp_attribute15                 = p_rec.cpp_attribute15,
    cpp_attribute16                 = p_rec.cpp_attribute16,
    cpp_attribute17                 = p_rec.cpp_attribute17,
    cpp_attribute18                 = p_rec.cpp_attribute18,
    cpp_attribute19                 = p_rec.cpp_attribute19,
    cpp_attribute20                 = p_rec.cpp_attribute20,
    cpp_attribute21                 = p_rec.cpp_attribute21,
    cpp_attribute22                 = p_rec.cpp_attribute22,
    cpp_attribute23                 = p_rec.cpp_attribute23,
    cpp_attribute24                 = p_rec.cpp_attribute24,
    cpp_attribute25                 = p_rec.cpp_attribute25,
    cpp_attribute26                 = p_rec.cpp_attribute26,
    cpp_attribute27                 = p_rec.cpp_attribute27,
    cpp_attribute28                 = p_rec.cpp_attribute28,
    cpp_attribute29                 = p_rec.cpp_attribute29,
    cpp_attribute30                 = p_rec.cpp_attribute30,
    object_version_number           = p_rec.object_version_number
    where   plip_id = p_rec.plip_id
    and     effective_start_date = p_validation_start_date
    and     effective_end_date   = p_validation_end_date;

Line: 206


End dt_update_dml;

Line: 239


Procedure update_dml
	(p_rec 			 in out nocopy ben_cpp_shd.g_rec_type,
	 p_effective_date	 in	date,
	 p_datetrack_mode	 in	varchar2,
	 p_validation_start_date in	date,
	 p_validation_end_date	 in	date) is
--
  l_proc	varchar2(72) := g_package||'update_dml';

Line: 251


  dt_update_dml(p_rec			=> p_rec,
		p_effective_date	=> p_effective_date,
		p_datetrack_mode	=> p_datetrack_mode,
       		p_validation_start_date	=> p_validation_start_date,
		p_validation_end_date	=> p_validation_end_date);

Line: 258


End update_dml;

Line: 303


Procedure dt_pre_update
	(p_rec 			 in out nocopy ben_cpp_shd.g_rec_type,
	 p_effective_date	 in	date,
	 p_datetrack_mode	 in	varchar2,
	 p_validation_start_date in	date,
	 p_validation_end_date	 in	date) is
--
  l_proc	         varchar2(72) := g_package||'dt_pre_update';

Line: 328


    If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
      hr_utility.set_location(l_proc, 15);

Line: 334


      ben_cpp_del.delete_dml
        (p_rec			 => p_rec,
	 p_effective_date	 => p_effective_date,
	 p_datetrack_mode	 => p_datetrack_mode,
	 p_validation_start_date => p_validation_start_date,
	 p_validation_end_date   => p_validation_end_date);

Line: 345


    ben_cpp_ins.insert_dml
      (p_rec			=> p_rec,
       p_effective_date		=> p_effective_date,
       p_datetrack_mode		=> p_datetrack_mode,
       p_validation_start_date	=> p_validation_start_date,
       p_validation_end_date	=> p_validation_end_date);

Line: 353


End dt_pre_update;

Line: 388


Procedure pre_update
	(p_rec 			 in out nocopy ben_cpp_shd.g_rec_type,
	 p_effective_date	 in	date,
	 p_datetrack_mode	 in	varchar2,
	 p_validation_start_date in	date,
	 p_validation_end_date	 in	date) is
--
  l_proc	varchar2(72) := g_package||'pre_update';

Line: 402


  dt_pre_update
    (p_rec 		     => p_rec,
     p_effective_date	     => p_effective_date,
     p_datetrack_mode	     => p_datetrack_mode,
     p_validation_start_date => p_validation_start_date,
     p_validation_end_date   => p_validation_end_date);

Line: 410


End pre_update;

Line: 444


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

Line: 470


    ben_cpp_rku.after_update
      (
  p_plip_id                       =>p_rec.plip_id
 ,p_effective_start_date          =>p_rec.effective_start_date
 ,p_effective_end_date            =>p_rec.effective_end_date
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_pgm_id                        =>p_rec.pgm_id
 ,p_pl_id                         =>p_rec.pl_id
 ,p_cmbn_plip_id                  =>p_rec.cmbn_plip_id
 ,p_dflt_flag                     =>p_rec.dflt_flag
 ,p_plip_stat_cd                  =>p_rec.plip_stat_cd
 ,p_dflt_enrt_cd                  =>p_rec.dflt_enrt_cd
 ,p_dflt_enrt_det_rl              =>p_rec.dflt_enrt_det_rl
 ,p_ordr_num                      =>p_rec.ordr_num
 ,p_alws_unrstrctd_enrt_flag      =>p_rec.alws_unrstrctd_enrt_flag
 ,p_auto_enrt_mthd_rl             =>p_rec.auto_enrt_mthd_rl
 ,p_enrt_cd                       =>p_rec.enrt_cd
 ,p_enrt_mthd_cd                  =>p_rec.enrt_mthd_cd
 ,p_enrt_rl                       =>p_rec.enrt_rl
 ,p_ivr_ident                     =>p_rec.ivr_ident
 ,p_url_ref_name                  =>p_rec.url_ref_name
 ,p_enrt_cvg_strt_dt_cd           =>p_rec.enrt_cvg_strt_dt_cd
 ,p_enrt_cvg_strt_dt_rl           =>p_rec.enrt_cvg_strt_dt_rl
 ,p_enrt_cvg_end_dt_cd            =>p_rec.enrt_cvg_end_dt_cd
 ,p_enrt_cvg_end_dt_rl            =>p_rec.enrt_cvg_end_dt_rl
 ,p_rt_strt_dt_cd                 =>p_rec.rt_strt_dt_cd
 ,p_rt_strt_dt_rl                 =>p_rec.rt_strt_dt_rl
 ,p_rt_end_dt_cd                  =>p_rec.rt_end_dt_cd
 ,p_rt_end_dt_rl                  =>p_rec.rt_end_dt_rl
 ,p_drvbl_fctr_apls_rts_flag      =>p_rec.drvbl_fctr_apls_rts_flag
 ,p_drvbl_fctr_prtn_elig_flag     =>p_rec.drvbl_fctr_prtn_elig_flag
 ,p_elig_apls_flag                =>p_rec.elig_apls_flag
 ,p_prtn_elig_ovrid_alwd_flag     =>p_rec.prtn_elig_ovrid_alwd_flag
 ,p_trk_inelig_per_flag           =>p_rec.trk_inelig_per_flag
 ,p_postelcn_edit_rl              =>p_rec.postelcn_edit_rl
 ,p_dflt_to_asn_pndg_ctfn_cd      =>p_rec.dflt_to_asn_pndg_ctfn_cd
 ,p_dflt_to_asn_pndg_ctfn_rl      =>p_rec.dflt_to_asn_pndg_ctfn_rl
 ,p_mn_cvg_amt                    =>p_rec.mn_cvg_amt
 ,p_mn_cvg_rl                     => p_rec.mn_cvg_rl
 ,p_mx_cvg_alwd_amt               => p_rec.mx_cvg_alwd_amt
 ,p_mx_cvg_incr_alwd_amt          =>p_rec.mx_cvg_incr_alwd_amt
 ,p_mx_cvg_incr_wcf_alwd_amt      =>p_rec.mx_cvg_incr_wcf_alwd_amt
 ,p_mx_cvg_mlt_incr_num           =>p_rec.mx_cvg_mlt_incr_num
 ,p_mx_cvg_mlt_incr_wcf_num       =>p_rec.mx_cvg_mlt_incr_wcf_num
 ,p_mx_cvg_rl                     =>p_rec.mx_cvg_rl
 ,p_mx_cvg_wcfn_amt               =>p_rec.mx_cvg_wcfn_amt
 ,p_mx_cvg_wcfn_mlt_num           =>p_rec.mx_cvg_wcfn_mlt_num
 ,p_no_mn_cvg_amt_apls_flag       =>p_rec.no_mn_cvg_amt_apls_flag
 ,p_no_mn_cvg_incr_apls_flag      =>p_rec.no_mn_cvg_incr_apls_flag
 ,p_no_mx_cvg_amt_apls_flag       =>p_rec.no_mx_cvg_amt_apls_flag
 ,p_no_mx_cvg_incr_apls_flag      =>p_rec.no_mx_cvg_incr_apls_flag
 ,p_unsspnd_enrt_cd               =>p_rec.unsspnd_enrt_cd
 ,p_prort_prtl_yr_cvg_rstrn_cd    =>p_rec.prort_prtl_yr_cvg_rstrn_cd
 ,p_prort_prtl_yr_cvg_rstrn_rl    =>p_rec.prort_prtl_yr_cvg_rstrn_rl
 ,p_cvg_incr_r_decr_only_cd       =>p_rec.cvg_incr_r_decr_only_cd
 ,p_bnft_or_option_rstrctn_cd     =>p_rec.bnft_or_option_rstrctn_cd
 ,p_per_cvrd_cd                   =>p_rec.per_cvrd_cd
 ,p_short_name                   =>p_rec.short_name
 ,p_short_code                   =>p_rec.short_code
  ,p_legislation_code                   =>p_rec.legislation_code
  ,p_legislation_subgroup                   =>p_rec.legislation_subgroup
 ,p_vrfy_fmly_mmbr_rl             =>p_rec.vrfy_fmly_mmbr_rl
 ,p_vrfy_fmly_mmbr_cd             =>p_rec.vrfy_fmly_mmbr_cd
 ,p_use_csd_rsd_prccng_cd         =>p_rec.use_csd_rsd_prccng_cd
 ,p_cpp_attribute_category        =>p_rec.cpp_attribute_category
 ,p_cpp_attribute1                =>p_rec.cpp_attribute1
 ,p_cpp_attribute2                =>p_rec.cpp_attribute2
 ,p_cpp_attribute3                =>p_rec.cpp_attribute3
 ,p_cpp_attribute4                =>p_rec.cpp_attribute4
 ,p_cpp_attribute5                =>p_rec.cpp_attribute5
 ,p_cpp_attribute6                =>p_rec.cpp_attribute6
 ,p_cpp_attribute7                =>p_rec.cpp_attribute7
 ,p_cpp_attribute8                =>p_rec.cpp_attribute8
 ,p_cpp_attribute9                =>p_rec.cpp_attribute9
 ,p_cpp_attribute10               =>p_rec.cpp_attribute10
 ,p_cpp_attribute11               =>p_rec.cpp_attribute11
 ,p_cpp_attribute12               =>p_rec.cpp_attribute12
 ,p_cpp_attribute13               =>p_rec.cpp_attribute13
 ,p_cpp_attribute14               =>p_rec.cpp_attribute14
 ,p_cpp_attribute15               =>p_rec.cpp_attribute15
 ,p_cpp_attribute16               =>p_rec.cpp_attribute16
 ,p_cpp_attribute17               =>p_rec.cpp_attribute17
 ,p_cpp_attribute18               =>p_rec.cpp_attribute18
 ,p_cpp_attribute19               =>p_rec.cpp_attribute19
 ,p_cpp_attribute20               =>p_rec.cpp_attribute20
 ,p_cpp_attribute21               =>p_rec.cpp_attribute21
 ,p_cpp_attribute22               =>p_rec.cpp_attribute22
 ,p_cpp_attribute23               =>p_rec.cpp_attribute23
 ,p_cpp_attribute24               =>p_rec.cpp_attribute24
 ,p_cpp_attribute25               =>p_rec.cpp_attribute25
 ,p_cpp_attribute26               =>p_rec.cpp_attribute26
 ,p_cpp_attribute27               =>p_rec.cpp_attribute27
 ,p_cpp_attribute28               =>p_rec.cpp_attribute28
 ,p_cpp_attribute29               =>p_rec.cpp_attribute29
 ,p_cpp_attribute30               =>p_rec.cpp_attribute30
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_datetrack_mode                =>p_datetrack_mode
 ,p_validation_start_date         =>p_validation_start_date
 ,p_validation_end_date           =>p_validation_end_date
 ,p_effective_start_date_o        =>ben_cpp_shd.g_old_rec.effective_start_date
 ,p_effective_end_date_o          =>ben_cpp_shd.g_old_rec.effective_end_date
 ,p_business_group_id_o           =>ben_cpp_shd.g_old_rec.business_group_id
 ,p_pgm_id_o                      =>ben_cpp_shd.g_old_rec.pgm_id
 ,p_pl_id_o                       =>ben_cpp_shd.g_old_rec.pl_id
 ,p_cmbn_plip_id_o                =>ben_cpp_shd.g_old_rec.cmbn_plip_id
 ,p_dflt_flag_o                   =>ben_cpp_shd.g_old_rec.dflt_flag
 ,p_plip_stat_cd_o                =>ben_cpp_shd.g_old_rec.plip_stat_cd
 ,p_dflt_enrt_cd_o                =>ben_cpp_shd.g_old_rec.dflt_enrt_cd
 ,p_dflt_enrt_det_rl_o            =>ben_cpp_shd.g_old_rec.dflt_enrt_det_rl
 ,p_ordr_num_o                    =>ben_cpp_shd.g_old_rec.ordr_num
 ,p_alws_unrstrctd_enrt_flag_o    =>ben_cpp_shd.g_old_rec.alws_unrstrctd_enrt_flag
 ,p_auto_enrt_mthd_rl_o           =>ben_cpp_shd.g_old_rec.auto_enrt_mthd_rl
 ,p_enrt_cd_o                     =>ben_cpp_shd.g_old_rec.enrt_cd
 ,p_enrt_mthd_cd_o                =>ben_cpp_shd.g_old_rec.enrt_mthd_cd
 ,p_enrt_rl_o                     =>ben_cpp_shd.g_old_rec.enrt_rl
 ,p_ivr_ident_o                   =>ben_cpp_shd.g_old_rec.ivr_ident
 ,p_url_ref_name_o                =>ben_cpp_shd.g_old_rec.url_ref_name
 ,p_enrt_cvg_strt_dt_cd_o         =>ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_cd
 ,p_enrt_cvg_strt_dt_rl_o         =>ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_rl
 ,p_enrt_cvg_end_dt_cd_o          =>ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_cd
 ,p_enrt_cvg_end_dt_rl_o          =>ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_rl
 ,p_rt_strt_dt_cd_o               =>ben_cpp_shd.g_old_rec.rt_strt_dt_cd
 ,p_rt_strt_dt_rl_o               =>ben_cpp_shd.g_old_rec.rt_strt_dt_rl
 ,p_rt_end_dt_cd_o                =>ben_cpp_shd.g_old_rec.rt_end_dt_cd
 ,p_rt_end_dt_rl_o                =>ben_cpp_shd.g_old_rec.rt_end_dt_rl
 ,p_drvbl_fctr_apls_rts_flag_o    =>ben_cpp_shd.g_old_rec.drvbl_fctr_apls_rts_flag
 ,p_drvbl_fctr_prtn_elig_flag_o   =>ben_cpp_shd.g_old_rec.drvbl_fctr_prtn_elig_flag
 ,p_elig_apls_flag_o              =>ben_cpp_shd.g_old_rec.elig_apls_flag
 ,p_prtn_elig_ovrid_alwd_flag_o   =>ben_cpp_shd.g_old_rec.prtn_elig_ovrid_alwd_flag
 ,p_trk_inelig_per_flag_o         =>ben_cpp_shd.g_old_rec.trk_inelig_per_flag
 ,p_postelcn_edit_rl_o            =>ben_cpp_shd.g_old_rec.postelcn_edit_rl
 ,p_dflt_to_asn_pndg_ctfn_cd_o    =>ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
 ,p_dflt_to_asn_pndg_ctfn_rl_o    =>ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
 ,p_mn_cvg_amt_o                  =>ben_cpp_shd.g_old_rec.mn_cvg_amt
 ,p_mn_cvg_rl_o                   =>ben_cpp_shd.g_old_rec.mn_cvg_rl
 ,p_mx_cvg_alwd_amt_o             =>ben_cpp_shd.g_old_rec.mx_cvg_alwd_amt
 ,p_mx_cvg_incr_alwd_amt_o        =>ben_cpp_shd.g_old_rec.mx_cvg_incr_alwd_amt
 ,p_mx_cvg_incr_wcf_alwd_amt_o    =>ben_cpp_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
 ,p_mx_cvg_mlt_incr_num_o         =>ben_cpp_shd.g_old_rec.mx_cvg_mlt_incr_num
 ,p_mx_cvg_mlt_incr_wcf_num_o     =>ben_cpp_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
 ,p_mx_cvg_rl_o                   =>ben_cpp_shd.g_old_rec.mx_cvg_rl
 ,p_mx_cvg_wcfn_amt_o             =>ben_cpp_shd.g_old_rec.mx_cvg_wcfn_amt
 ,p_mx_cvg_wcfn_mlt_num_o         =>ben_cpp_shd.g_old_rec.mx_cvg_wcfn_mlt_num
 ,p_no_mn_cvg_amt_apls_flag_o     =>ben_cpp_shd.g_old_rec.no_mn_cvg_amt_apls_flag
 ,p_no_mn_cvg_incr_apls_flag_o    =>ben_cpp_shd.g_old_rec.no_mn_cvg_incr_apls_flag
 ,p_no_mx_cvg_amt_apls_flag_o     =>ben_cpp_shd.g_old_rec.no_mx_cvg_amt_apls_flag
 ,p_no_mx_cvg_incr_apls_flag_o    =>ben_cpp_shd.g_old_rec.no_mx_cvg_incr_apls_flag
 ,p_unsspnd_enrt_cd_o             =>ben_cpp_shd.g_old_rec.unsspnd_enrt_cd
 ,p_prort_prtl_yr_cvg_rstrn_cd_o  =>ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_cd
 ,p_prort_prtl_yr_cvg_rstrn_rl_o  =>ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_rl
 ,p_cvg_incr_r_decr_only_cd_o     =>ben_cpp_shd.g_old_rec.cvg_incr_r_decr_only_cd
 ,p_bnft_or_option_rstrctn_cd_o   =>ben_cpp_shd.g_old_rec.bnft_or_option_rstrctn_cd
 ,p_per_cvrd_cd_o                 =>ben_cpp_shd.g_old_rec.per_cvrd_cd
 ,p_short_name_o                 =>ben_cpp_shd.g_old_rec.short_name
 ,p_short_code_o                 =>ben_cpp_shd.g_old_rec.short_code
  ,p_legislation_code_o                 =>ben_cpp_shd.g_old_rec.legislation_code
  ,p_legislation_subgroup_o                 =>ben_cpp_shd.g_old_rec.legislation_subgroup
 ,p_vrfy_fmly_mmbr_rl_o           =>ben_cpp_shd.g_old_rec.vrfy_fmly_mmbr_rl
 ,p_vrfy_fmly_mmbr_cd_o           =>ben_cpp_shd.g_old_rec.vrfy_fmly_mmbr_cd
 ,p_use_csd_rsd_prccng_cd_o       =>ben_cpp_shd.g_old_rec.use_csd_rsd_prccng_cd
 ,p_cpp_attribute_category_o      =>ben_cpp_shd.g_old_rec.cpp_attribute_category
 ,p_cpp_attribute1_o              =>ben_cpp_shd.g_old_rec.cpp_attribute1
 ,p_cpp_attribute2_o              =>ben_cpp_shd.g_old_rec.cpp_attribute2
 ,p_cpp_attribute3_o              =>ben_cpp_shd.g_old_rec.cpp_attribute3
 ,p_cpp_attribute4_o              =>ben_cpp_shd.g_old_rec.cpp_attribute4
 ,p_cpp_attribute5_o              =>ben_cpp_shd.g_old_rec.cpp_attribute5
 ,p_cpp_attribute6_o              =>ben_cpp_shd.g_old_rec.cpp_attribute6
 ,p_cpp_attribute7_o              =>ben_cpp_shd.g_old_rec.cpp_attribute7
 ,p_cpp_attribute8_o              =>ben_cpp_shd.g_old_rec.cpp_attribute8
 ,p_cpp_attribute9_o              =>ben_cpp_shd.g_old_rec.cpp_attribute9
 ,p_cpp_attribute10_o             =>ben_cpp_shd.g_old_rec.cpp_attribute10
 ,p_cpp_attribute11_o             =>ben_cpp_shd.g_old_rec.cpp_attribute11
 ,p_cpp_attribute12_o             =>ben_cpp_shd.g_old_rec.cpp_attribute12
 ,p_cpp_attribute13_o             =>ben_cpp_shd.g_old_rec.cpp_attribute13
 ,p_cpp_attribute14_o             =>ben_cpp_shd.g_old_rec.cpp_attribute14
 ,p_cpp_attribute15_o             =>ben_cpp_shd.g_old_rec.cpp_attribute15
 ,p_cpp_attribute16_o             =>ben_cpp_shd.g_old_rec.cpp_attribute16
 ,p_cpp_attribute17_o             =>ben_cpp_shd.g_old_rec.cpp_attribute17
 ,p_cpp_attribute18_o             =>ben_cpp_shd.g_old_rec.cpp_attribute18
 ,p_cpp_attribute19_o             =>ben_cpp_shd.g_old_rec.cpp_attribute19
 ,p_cpp_attribute20_o             =>ben_cpp_shd.g_old_rec.cpp_attribute20
 ,p_cpp_attribute21_o             =>ben_cpp_shd.g_old_rec.cpp_attribute21
 ,p_cpp_attribute22_o             =>ben_cpp_shd.g_old_rec.cpp_attribute22
 ,p_cpp_attribute23_o             =>ben_cpp_shd.g_old_rec.cpp_attribute23
 ,p_cpp_attribute24_o             =>ben_cpp_shd.g_old_rec.cpp_attribute24
 ,p_cpp_attribute25_o             =>ben_cpp_shd.g_old_rec.cpp_attribute25
 ,p_cpp_attribute26_o             =>ben_cpp_shd.g_old_rec.cpp_attribute26
 ,p_cpp_attribute27_o             =>ben_cpp_shd.g_old_rec.cpp_attribute27
 ,p_cpp_attribute28_o             =>ben_cpp_shd.g_old_rec.cpp_attribute28
 ,p_cpp_attribute29_o             =>ben_cpp_shd.g_old_rec.cpp_attribute29
 ,p_cpp_attribute30_o             =>ben_cpp_shd.g_old_rec.cpp_attribute30
 ,p_object_version_number_o       =>ben_cpp_shd.g_old_rec.object_version_number
      );

Line: 679


End post_update;

Line: 1170


  ben_cpp_bus.update_validate
	(p_rec			 => p_rec,
	 p_effective_date	 => p_effective_date,
	 p_datetrack_mode  	 => p_datetrack_mode,
	 p_validation_start_date => l_validation_start_date,
	 p_validation_end_date	 => l_validation_end_date);

Line: 1179


  pre_update
	(p_rec			 => p_rec,
	 p_effective_date	 => p_effective_date,
	 p_datetrack_mode	 => p_datetrack_mode,
	 p_validation_start_date => l_validation_start_date,
	 p_validation_end_date	 => l_validation_end_date);

Line: 1188


  update_dml
	(p_rec			 => p_rec,
	 p_effective_date	 => p_effective_date,
	 p_datetrack_mode	 => p_datetrack_mode,
	 p_validation_start_date => l_validation_start_date,
	 p_validation_end_date	 => l_validation_end_date);

Line: 1197


  post_update
	(p_rec			 => p_rec,
	 p_effective_date	 => p_effective_date,
	 p_datetrack_mode	 => p_datetrack_mode,
	 p_validation_start_date => l_validation_start_date,
	 p_validation_end_date	 => l_validation_end_date);