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_EPO_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_epo_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_elig_per_opt_f
    set
    elig_per_opt_id                 = p_rec.elig_per_opt_id,
    elig_per_id                     = p_rec.elig_per_id,
    prtn_ovridn_flag                = p_rec.prtn_ovridn_flag,
    prtn_ovridn_thru_dt             = p_rec.prtn_ovridn_thru_dt,
    no_mx_prtn_ovrid_thru_flag      = p_rec.no_mx_prtn_ovrid_thru_flag,
    elig_flag                       = p_rec.elig_flag,
    prtn_strt_dt                    = p_rec.prtn_strt_dt,
    prtn_end_dt                     = p_rec.prtn_end_dt,
    wait_perd_cmpltn_date             = p_rec.wait_perd_cmpltn_date,
    wait_perd_strt_dt               = p_rec.wait_perd_strt_dt,
    prtn_ovridn_rsn_cd              = p_rec.prtn_ovridn_rsn_cd,
    pct_fl_tm_val                   = p_rec.pct_fl_tm_val,
    opt_id                          = p_rec.opt_id,
    per_in_ler_id                   = p_rec.per_in_ler_id,
    rt_comp_ref_amt                 = p_rec.rt_comp_ref_amt,
    rt_cmbn_age_n_los_val           = p_rec.rt_cmbn_age_n_los_val,
    rt_comp_ref_uom                 = p_rec.rt_comp_ref_uom,
    rt_age_val                      = p_rec.rt_age_val,
    rt_los_val                      = p_rec.rt_los_val,
    rt_hrs_wkd_val                  = p_rec.rt_hrs_wkd_val,
    rt_hrs_wkd_bndry_perd_cd        = p_rec.rt_hrs_wkd_bndry_perd_cd,
    rt_age_uom                      = p_rec.rt_age_uom,
    rt_los_uom                      = p_rec.rt_los_uom,
    rt_pct_fl_tm_val                = p_rec.rt_pct_fl_tm_val,
    rt_frz_los_flag                 = p_rec.rt_frz_los_flag,
    rt_frz_age_flag                 = p_rec.rt_frz_age_flag,
    rt_frz_cmp_lvl_flag             = p_rec.rt_frz_cmp_lvl_flag,
    rt_frz_pct_fl_tm_flag           = p_rec.rt_frz_pct_fl_tm_flag,
    rt_frz_hrs_wkd_flag             = p_rec.rt_frz_hrs_wkd_flag,
    rt_frz_comb_age_and_los_flag    = p_rec.rt_frz_comb_age_and_los_flag,
    comp_ref_amt                    = p_rec.comp_ref_amt,
    cmbn_age_n_los_val              = p_rec.cmbn_age_n_los_val,
    comp_ref_uom                    = p_rec.comp_ref_uom,
    age_val                         = p_rec.age_val,
    los_val                         = p_rec.los_val,
    hrs_wkd_val                     = p_rec.hrs_wkd_val,
    hrs_wkd_bndry_perd_cd           = p_rec.hrs_wkd_bndry_perd_cd,
    age_uom                         = p_rec.age_uom,
    los_uom                         = p_rec.los_uom,
    frz_los_flag                    = p_rec.frz_los_flag,
    frz_age_flag                    = p_rec.frz_age_flag,
    frz_cmp_lvl_flag                = p_rec.frz_cmp_lvl_flag,
    frz_pct_fl_tm_flag              = p_rec.frz_pct_fl_tm_flag,
    frz_hrs_wkd_flag                = p_rec.frz_hrs_wkd_flag,
    frz_comb_age_and_los_flag       = p_rec.frz_comb_age_and_los_flag,
    ovrid_svc_dt                    = p_rec.ovrid_svc_dt,
    inelg_rsn_cd                    = p_rec.inelg_rsn_cd,
    once_r_cntug_cd                 = p_rec.once_r_cntug_cd,
    oipl_ordr_num                   = p_rec.oipl_ordr_num,
    business_group_id               = p_rec.business_group_id,
    epo_attribute_category          = p_rec.epo_attribute_category,
    epo_attribute1                  = p_rec.epo_attribute1,
    epo_attribute2                  = p_rec.epo_attribute2,
    epo_attribute3                  = p_rec.epo_attribute3,
    epo_attribute4                  = p_rec.epo_attribute4,
    epo_attribute5                  = p_rec.epo_attribute5,
    epo_attribute6                  = p_rec.epo_attribute6,
    epo_attribute7                  = p_rec.epo_attribute7,
    epo_attribute8                  = p_rec.epo_attribute8,
    epo_attribute9                  = p_rec.epo_attribute9,
    epo_attribute10                 = p_rec.epo_attribute10,
    epo_attribute11                 = p_rec.epo_attribute11,
    epo_attribute12                 = p_rec.epo_attribute12,
    epo_attribute13                 = p_rec.epo_attribute13,
    epo_attribute14                 = p_rec.epo_attribute14,
    epo_attribute15                 = p_rec.epo_attribute15,
    epo_attribute16                 = p_rec.epo_attribute16,
    epo_attribute17                 = p_rec.epo_attribute17,
    epo_attribute18                 = p_rec.epo_attribute18,
    epo_attribute19                 = p_rec.epo_attribute19,
    epo_attribute20                 = p_rec.epo_attribute20,
    epo_attribute21                 = p_rec.epo_attribute21,
    epo_attribute22                 = p_rec.epo_attribute22,
    epo_attribute23                 = p_rec.epo_attribute23,
    epo_attribute24                 = p_rec.epo_attribute24,
    epo_attribute25                 = p_rec.epo_attribute25,
    epo_attribute26                 = p_rec.epo_attribute26,
    epo_attribute27                 = p_rec.epo_attribute27,
    epo_attribute28                 = p_rec.epo_attribute28,
    epo_attribute29                 = p_rec.epo_attribute29,
    epo_attribute30                 = p_rec.epo_attribute30,
    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   elig_per_opt_id = p_rec.elig_per_opt_id
    and     effective_start_date = p_validation_start_date
    and     effective_end_date   = p_validation_end_date;

Line: 200


End dt_update_dml;

Line: 233


Procedure update_dml
    (p_rec              in out nocopy ben_epo_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: 245


  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: 252


End update_dml;

Line: 297


Procedure dt_pre_update
    (p_rec              in out nocopy    ben_epo_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: 322


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

Line: 328


      ben_epo_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: 339


    ben_epo_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: 347


End dt_pre_update;

Line: 382


Procedure pre_update
    (p_rec              in out nocopy    ben_epo_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: 396


  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: 404


End pre_update;

Line: 438


Procedure post_update
    (p_rec              in ben_epo_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: 455


    ben_epo_rku.after_update
      (
  p_elig_per_opt_id               =>p_rec.elig_per_opt_id
 ,p_elig_per_id                   =>p_rec.elig_per_id
 ,p_effective_start_date          =>p_rec.effective_start_date
 ,p_effective_end_date            =>p_rec.effective_end_date
 ,p_prtn_ovridn_flag              =>p_rec.prtn_ovridn_flag
 ,p_prtn_ovridn_thru_dt           =>p_rec.prtn_ovridn_thru_dt
 ,p_no_mx_prtn_ovrid_thru_flag    =>p_rec.no_mx_prtn_ovrid_thru_flag
 ,p_elig_flag                     =>p_rec.elig_flag
 ,p_prtn_strt_dt                  =>p_rec.prtn_strt_dt
 ,p_prtn_end_dt                   =>p_rec.prtn_end_dt
 ,p_wait_perd_cmpltn_date           =>p_rec.wait_perd_cmpltn_date
 ,p_wait_perd_strt_dt             =>p_rec.wait_perd_strt_dt
 ,p_prtn_ovridn_rsn_cd            =>p_rec.prtn_ovridn_rsn_cd
 ,p_pct_fl_tm_val                 =>p_rec.pct_fl_tm_val
 ,p_opt_id                        =>p_rec.opt_id
 ,p_per_in_ler_id                 =>p_rec.per_in_ler_id
 ,p_rt_comp_ref_amt               =>p_rec.rt_comp_ref_amt
 ,p_rt_cmbn_age_n_los_val         =>p_rec.rt_cmbn_age_n_los_val
 ,p_rt_comp_ref_uom               =>p_rec.rt_comp_ref_uom
 ,p_rt_age_val                    =>p_rec.rt_age_val
 ,p_rt_los_val                    =>p_rec.rt_los_val
 ,p_rt_hrs_wkd_val                =>p_rec.rt_hrs_wkd_val
 ,p_rt_hrs_wkd_bndry_perd_cd      =>p_rec.rt_hrs_wkd_bndry_perd_cd
 ,p_rt_age_uom                    =>p_rec.rt_age_uom
 ,p_rt_los_uom                    =>p_rec.rt_los_uom
 ,p_rt_pct_fl_tm_val              =>p_rec.rt_pct_fl_tm_val
 ,p_rt_frz_los_flag               =>p_rec.rt_frz_los_flag
 ,p_rt_frz_age_flag               =>p_rec.rt_frz_age_flag
 ,p_rt_frz_cmp_lvl_flag           =>p_rec.rt_frz_cmp_lvl_flag
 ,p_rt_frz_pct_fl_tm_flag         =>p_rec.rt_frz_pct_fl_tm_flag
 ,p_rt_frz_hrs_wkd_flag           =>p_rec.rt_frz_hrs_wkd_flag
 ,p_rt_frz_comb_age_and_los_flag  =>p_rec.rt_frz_comb_age_and_los_flag
 ,p_comp_ref_amt                  =>p_rec.comp_ref_amt
 ,p_cmbn_age_n_los_val            =>p_rec.cmbn_age_n_los_val
 ,p_comp_ref_uom                  =>p_rec.comp_ref_uom
 ,p_age_val                       =>p_rec.age_val
 ,p_los_val                       =>p_rec.los_val
 ,p_hrs_wkd_val                   =>p_rec.hrs_wkd_val
 ,p_hrs_wkd_bndry_perd_cd         =>p_rec.hrs_wkd_bndry_perd_cd
 ,p_age_uom                       =>p_rec.age_uom
 ,p_los_uom                       =>p_rec.los_uom
 ,p_frz_los_flag                  =>p_rec.frz_los_flag
 ,p_frz_age_flag                  =>p_rec.frz_age_flag
 ,p_frz_cmp_lvl_flag              =>p_rec.frz_cmp_lvl_flag
 ,p_frz_pct_fl_tm_flag            =>p_rec.frz_pct_fl_tm_flag
 ,p_frz_hrs_wkd_flag              =>p_rec.frz_hrs_wkd_flag
 ,p_frz_comb_age_and_los_flag     =>p_rec.frz_comb_age_and_los_flag
 ,p_ovrid_svc_dt                  =>p_rec.ovrid_svc_dt
 ,p_inelg_rsn_cd                  =>p_rec.inelg_rsn_cd
 ,p_once_r_cntug_cd               =>p_rec.once_r_cntug_cd
 ,p_oipl_ordr_num                 =>p_rec.oipl_ordr_num
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_epo_attribute_category        =>p_rec.epo_attribute_category
 ,p_epo_attribute1                =>p_rec.epo_attribute1
 ,p_epo_attribute2                =>p_rec.epo_attribute2
 ,p_epo_attribute3                =>p_rec.epo_attribute3
 ,p_epo_attribute4                =>p_rec.epo_attribute4
 ,p_epo_attribute5                =>p_rec.epo_attribute5
 ,p_epo_attribute6                =>p_rec.epo_attribute6
 ,p_epo_attribute7                =>p_rec.epo_attribute7
 ,p_epo_attribute8                =>p_rec.epo_attribute8
 ,p_epo_attribute9                =>p_rec.epo_attribute9
 ,p_epo_attribute10               =>p_rec.epo_attribute10
 ,p_epo_attribute11               =>p_rec.epo_attribute11
 ,p_epo_attribute12               =>p_rec.epo_attribute12
 ,p_epo_attribute13               =>p_rec.epo_attribute13
 ,p_epo_attribute14               =>p_rec.epo_attribute14
 ,p_epo_attribute15               =>p_rec.epo_attribute15
 ,p_epo_attribute16               =>p_rec.epo_attribute16
 ,p_epo_attribute17               =>p_rec.epo_attribute17
 ,p_epo_attribute18               =>p_rec.epo_attribute18
 ,p_epo_attribute19               =>p_rec.epo_attribute19
 ,p_epo_attribute20               =>p_rec.epo_attribute20
 ,p_epo_attribute21               =>p_rec.epo_attribute21
 ,p_epo_attribute22               =>p_rec.epo_attribute22
 ,p_epo_attribute23               =>p_rec.epo_attribute23
 ,p_epo_attribute24               =>p_rec.epo_attribute24
 ,p_epo_attribute25               =>p_rec.epo_attribute25
 ,p_epo_attribute26               =>p_rec.epo_attribute26
 ,p_epo_attribute27               =>p_rec.epo_attribute27
 ,p_epo_attribute28               =>p_rec.epo_attribute28
 ,p_epo_attribute29               =>p_rec.epo_attribute29
 ,p_epo_attribute30               =>p_rec.epo_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_program_update_date          =>p_rec.program_update_date
 ,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_elig_per_id_o                 =>ben_epo_shd.g_old_rec.elig_per_id
 ,p_effective_start_date_o        =>ben_epo_shd.g_old_rec.effective_start_date
 ,p_effective_end_date_o          =>ben_epo_shd.g_old_rec.effective_end_date
 ,p_prtn_ovridn_flag_o            =>ben_epo_shd.g_old_rec.prtn_ovridn_flag
 ,p_prtn_ovridn_thru_dt_o         =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
 ,p_no_mx_prtn_ovrid_thru_flag_o  =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
 ,p_elig_flag_o                   =>ben_epo_shd.g_old_rec.elig_flag
 ,p_prtn_strt_dt_o                =>ben_epo_shd.g_old_rec.prtn_strt_dt
 ,p_prtn_end_dt_o                 =>ben_epo_shd.g_old_rec.prtn_end_dt
 ,p_wait_perd_cmpltn_date_o         =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
 ,p_wait_perd_strt_dt_o           =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
 ,p_prtn_ovridn_rsn_cd_o          =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
 ,p_pct_fl_tm_val_o               =>ben_epo_shd.g_old_rec.pct_fl_tm_val
 ,p_opt_id_o                      =>ben_epo_shd.g_old_rec.opt_id
 ,p_per_in_ler_id_o               =>ben_epo_shd.g_old_rec.per_in_ler_id
 ,p_rt_comp_ref_amt_o             =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
 ,p_rt_cmbn_age_n_los_val_o       =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
 ,p_rt_comp_ref_uom_o             =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
 ,p_rt_age_val_o                  =>ben_epo_shd.g_old_rec.rt_age_val
 ,p_rt_los_val_o                  =>ben_epo_shd.g_old_rec.rt_los_val
 ,p_rt_hrs_wkd_val_o              =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
 ,p_rt_hrs_wkd_bndry_perd_cd_o    =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
 ,p_rt_age_uom_o                  =>ben_epo_shd.g_old_rec.rt_age_uom
 ,p_rt_los_uom_o                  =>ben_epo_shd.g_old_rec.rt_los_uom
 ,p_rt_pct_fl_tm_val_o            =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
 ,p_rt_frz_los_flag_o             =>ben_epo_shd.g_old_rec.rt_frz_los_flag
 ,p_rt_frz_age_flag_o             =>ben_epo_shd.g_old_rec.rt_frz_age_flag
 ,p_rt_frz_cmp_lvl_flag_o         =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
 ,p_rt_frz_pct_fl_tm_flag_o       =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
 ,p_rt_frz_hrs_wkd_flag_o         =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
 ,p_rt_frz_comb_age_and_los_fl_o  =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
 ,p_comp_ref_amt_o                =>ben_epo_shd.g_old_rec.comp_ref_amt
 ,p_cmbn_age_n_los_val_o          =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
 ,p_comp_ref_uom_o                =>ben_epo_shd.g_old_rec.comp_ref_uom
 ,p_age_val_o                     =>ben_epo_shd.g_old_rec.age_val
 ,p_los_val_o                     =>ben_epo_shd.g_old_rec.los_val
 ,p_hrs_wkd_val_o                 =>ben_epo_shd.g_old_rec.hrs_wkd_val
 ,p_hrs_wkd_bndry_perd_cd_o       =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
 ,p_age_uom_o                     =>ben_epo_shd.g_old_rec.age_uom
 ,p_los_uom_o                     =>ben_epo_shd.g_old_rec.los_uom
 ,p_frz_los_flag_o                =>ben_epo_shd.g_old_rec.frz_los_flag
 ,p_frz_age_flag_o                =>ben_epo_shd.g_old_rec.frz_age_flag
 ,p_frz_cmp_lvl_flag_o            =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
 ,p_frz_pct_fl_tm_flag_o          =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
 ,p_frz_hrs_wkd_flag_o            =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
 ,p_frz_comb_age_and_los_flag_o   =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
 ,p_ovrid_svc_dt_o                =>ben_epo_shd.g_old_rec.ovrid_svc_dt
 ,p_inelg_rsn_cd_o                =>ben_epo_shd.g_old_rec.inelg_rsn_cd
 ,p_once_r_cntug_cd_o             =>ben_epo_shd.g_old_rec.once_r_cntug_cd
 ,p_oipl_ordr_num_o               =>ben_epo_shd.g_old_rec.oipl_ordr_num
 ,p_business_group_id_o           =>ben_epo_shd.g_old_rec.business_group_id
 ,p_epo_attribute_category_o      =>ben_epo_shd.g_old_rec.epo_attribute_category
 ,p_epo_attribute1_o              =>ben_epo_shd.g_old_rec.epo_attribute1
 ,p_epo_attribute2_o              =>ben_epo_shd.g_old_rec.epo_attribute2
 ,p_epo_attribute3_o              =>ben_epo_shd.g_old_rec.epo_attribute3
 ,p_epo_attribute4_o              =>ben_epo_shd.g_old_rec.epo_attribute4
 ,p_epo_attribute5_o              =>ben_epo_shd.g_old_rec.epo_attribute5
 ,p_epo_attribute6_o              =>ben_epo_shd.g_old_rec.epo_attribute6
 ,p_epo_attribute7_o              =>ben_epo_shd.g_old_rec.epo_attribute7
 ,p_epo_attribute8_o              =>ben_epo_shd.g_old_rec.epo_attribute8
 ,p_epo_attribute9_o              =>ben_epo_shd.g_old_rec.epo_attribute9
 ,p_epo_attribute10_o             =>ben_epo_shd.g_old_rec.epo_attribute10
 ,p_epo_attribute11_o             =>ben_epo_shd.g_old_rec.epo_attribute11
 ,p_epo_attribute12_o             =>ben_epo_shd.g_old_rec.epo_attribute12
 ,p_epo_attribute13_o             =>ben_epo_shd.g_old_rec.epo_attribute13
 ,p_epo_attribute14_o             =>ben_epo_shd.g_old_rec.epo_attribute14
 ,p_epo_attribute15_o             =>ben_epo_shd.g_old_rec.epo_attribute15
 ,p_epo_attribute16_o             =>ben_epo_shd.g_old_rec.epo_attribute16
 ,p_epo_attribute17_o             =>ben_epo_shd.g_old_rec.epo_attribute17
 ,p_epo_attribute18_o             =>ben_epo_shd.g_old_rec.epo_attribute18
 ,p_epo_attribute19_o             =>ben_epo_shd.g_old_rec.epo_attribute19
 ,p_epo_attribute20_o             =>ben_epo_shd.g_old_rec.epo_attribute20
 ,p_epo_attribute21_o             =>ben_epo_shd.g_old_rec.epo_attribute21
 ,p_epo_attribute22_o             =>ben_epo_shd.g_old_rec.epo_attribute22
 ,p_epo_attribute23_o             =>ben_epo_shd.g_old_rec.epo_attribute23
 ,p_epo_attribute24_o             =>ben_epo_shd.g_old_rec.epo_attribute24
 ,p_epo_attribute25_o             =>ben_epo_shd.g_old_rec.epo_attribute25
 ,p_epo_attribute26_o             =>ben_epo_shd.g_old_rec.epo_attribute26
 ,p_epo_attribute27_o             =>ben_epo_shd.g_old_rec.epo_attribute27
 ,p_epo_attribute28_o             =>ben_epo_shd.g_old_rec.epo_attribute28
 ,p_epo_attribute29_o             =>ben_epo_shd.g_old_rec.epo_attribute29
 ,p_epo_attribute30_o             =>ben_epo_shd.g_old_rec.epo_attribute30
 ,p_request_id_o          =>ben_epo_shd.g_old_rec.request_id
 ,p_program_application_id_o      =>ben_epo_shd.g_old_rec.program_application_id
 ,p_program_id_o          =>ben_epo_shd.g_old_rec.program_id
 ,p_program_update_date_o      =>ben_epo_shd.g_old_rec.program_update_date
 ,p_object_version_number_o       =>ben_epo_shd.g_old_rec.object_version_number
      );

Line: 652


End post_update;

Line: 1042


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

Line: 1090


  ben_epo_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: 1099


  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: 1108


  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: 1117


  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);

Line: 1216


  p_program_update_date          in date             default hr_api.g_date,
  p_object_version_number        in out nocopy number,
  p_effective_date         in date,
  p_datetrack_mode         in varchar2
  ) is
--
  l_rec        ben_epo_shd.g_rec_type;

Line: 1320


  p_program_update_date,
  p_object_version_number
  );