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_PEN_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_pen_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_prtt_enrt_rslt_f
    set
    prtt_enrt_rslt_id               = p_rec.prtt_enrt_rslt_id,
    business_group_id               = p_rec.business_group_id,
    oipl_id                         = p_rec.oipl_id,
    person_id                       = p_rec.person_id,
    assignment_id                   = p_rec.assignment_id,
    pgm_id                          = p_rec.pgm_id,
    pl_id                           = p_rec.pl_id,
    rplcs_sspndd_rslt_id            = p_rec.rplcs_sspndd_rslt_id,
    ptip_id                         = p_rec.ptip_id,
    pl_typ_id                       = p_rec.pl_typ_id,
    ler_id                          = p_rec.ler_id,
    sspndd_flag                     = p_rec.sspndd_flag,
    prtt_is_cvrd_flag               = p_rec.prtt_is_cvrd_flag,
    bnft_amt                        = p_rec.bnft_amt,
    uom                             = p_rec.uom     ,
    orgnl_enrt_dt                   = p_rec.orgnl_enrt_dt,
    enrt_mthd_cd                    = p_rec.enrt_mthd_cd,
    no_lngr_elig_flag               = p_rec.no_lngr_elig_flag,
    enrt_ovridn_flag                = p_rec.enrt_ovridn_flag,
    enrt_ovrid_rsn_cd               = p_rec.enrt_ovrid_rsn_cd,
    erlst_deenrt_dt                 = p_rec.erlst_deenrt_dt,
    enrt_cvg_strt_dt                = p_rec.enrt_cvg_strt_dt,
    enrt_cvg_thru_dt                = p_rec.enrt_cvg_thru_dt,
    enrt_ovrid_thru_dt              = p_rec.enrt_ovrid_thru_dt,
    pl_ordr_num                     = p_rec.pl_ordr_num,
    plip_ordr_num                   = p_rec.plip_ordr_num,
    ptip_ordr_num                   = p_rec.ptip_ordr_num,
    oipl_ordr_num                   = p_rec.oipl_ordr_num,
    pen_attribute_category          = p_rec.pen_attribute_category,
    pen_attribute1                  = p_rec.pen_attribute1,
    pen_attribute2                  = p_rec.pen_attribute2,
    pen_attribute3                  = p_rec.pen_attribute3,
    pen_attribute4                  = p_rec.pen_attribute4,
    pen_attribute5                  = p_rec.pen_attribute5,
    pen_attribute6                  = p_rec.pen_attribute6,
    pen_attribute7                  = p_rec.pen_attribute7,
    pen_attribute8                  = p_rec.pen_attribute8,
    pen_attribute9                  = p_rec.pen_attribute9,
    pen_attribute10                 = p_rec.pen_attribute10,
    pen_attribute11                 = p_rec.pen_attribute11,
    pen_attribute12                 = p_rec.pen_attribute12,
    pen_attribute13                 = p_rec.pen_attribute13,
    pen_attribute14                 = p_rec.pen_attribute14,
    pen_attribute15                 = p_rec.pen_attribute15,
    pen_attribute16                 = p_rec.pen_attribute16,
    pen_attribute17                 = p_rec.pen_attribute17,
    pen_attribute18                 = p_rec.pen_attribute18,
    pen_attribute19                 = p_rec.pen_attribute19,
    pen_attribute20                 = p_rec.pen_attribute20,
    pen_attribute21                 = p_rec.pen_attribute21,
    pen_attribute22                 = p_rec.pen_attribute22,
    pen_attribute23                 = p_rec.pen_attribute23,
    pen_attribute24                 = p_rec.pen_attribute24,
    pen_attribute25                 = p_rec.pen_attribute25,
    pen_attribute26                 = p_rec.pen_attribute26,
    pen_attribute27                 = p_rec.pen_attribute27,
    pen_attribute28                 = p_rec.pen_attribute28,
    pen_attribute29                 = p_rec.pen_attribute29,
    pen_attribute30                 = p_rec.pen_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,
    per_in_ler_id                   = p_rec.per_in_ler_id,
    bnft_typ_cd                     = p_rec.bnft_typ_cd,
    bnft_ordr_num                   = p_rec.bnft_ordr_num,
    prtt_enrt_rslt_stat_cd          = p_rec.prtt_enrt_rslt_stat_cd,
    bnft_nnmntry_uom                = p_rec.bnft_nnmntry_uom,
    comp_lvl_cd                     = p_rec.comp_lvl_cd
    where   prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id
    and     effective_start_date = p_validation_start_date
    and     effective_end_date   = p_validation_end_date;

Line: 184


End dt_update_dml;

Line: 217


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


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


End update_dml;

Line: 281


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


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

Line: 332


      ben_pen_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: 343


    ben_pen_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: 351


End dt_pre_update;

Line: 386


Procedure pre_update
    (p_rec 			         in out nocopy ben_pen_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
--
  cursor c1 is
   select elig_per_elctbl_chc_id, object_version_number
   from ben_elig_per_elctbl_chc
   where prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id;

Line: 401


  l_proc	varchar2(72) := g_package||'pre_update';

Line: 407


select rowid, effective_start_date, effective_end_date
from ben_prtt_enrt_rslt_f
where prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id
and p_effective_date between
effective_start_date and effective_end_date;

Line: 414


select rowid
from ben_prtt_enrt_rslt_f
where prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id
and p_effective_date -1 between
effective_start_date and effective_end_date;

Line: 435


      ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC
        (p_validate                => FALSE
        ,p_elig_per_elctbl_chc_id  => l_chc_id
        ,p_prtt_enrt_rslt_id       => NULL
        ,p_object_version_number   => l_chc_ovn
        ,p_effective_date          => p_effective_date
        );

Line: 445


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


End pre_update;

Line: 517


Procedure post_update
    (p_rec 			         in ben_pen_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: 533


    ben_pen_rku.after_update
      (
  p_prtt_enrt_rslt_id         =>p_rec.prtt_enrt_rslt_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_oipl_id                   =>p_rec.oipl_id
 ,p_person_id                 =>p_rec.person_id
 ,p_assignment_id             =>p_rec.assignment_id
 ,p_pgm_id                    =>p_rec.pgm_id
 ,p_pl_id                     =>p_rec.pl_id
 ,p_rplcs_sspndd_rslt_id      =>p_rec.rplcs_sspndd_rslt_id
 ,p_ptip_id                   =>p_rec.ptip_id
 ,p_pl_typ_id                 =>p_rec.pl_typ_id
 ,p_ler_id                    =>p_rec.ler_id
 ,p_sspndd_flag               =>p_rec.sspndd_flag
 ,p_prtt_is_cvrd_flag         =>p_rec.prtt_is_cvrd_flag
 ,p_bnft_amt                  =>p_rec.bnft_amt
 ,p_uom                       =>p_rec.uom
 ,p_orgnl_enrt_dt             =>p_rec.orgnl_enrt_dt
 ,p_enrt_mthd_cd              =>p_rec.enrt_mthd_cd
 ,p_no_lngr_elig_flag         =>p_rec.no_lngr_elig_flag
 ,p_enrt_ovridn_flag          =>p_rec.enrt_ovridn_flag
 ,p_enrt_ovrid_rsn_cd         =>p_rec.enrt_ovrid_rsn_cd
 ,p_erlst_deenrt_dt           =>p_rec.erlst_deenrt_dt
 ,p_enrt_cvg_strt_dt          =>p_rec.enrt_cvg_strt_dt
 ,p_enrt_cvg_thru_dt          =>p_rec.enrt_cvg_thru_dt
 ,p_enrt_ovrid_thru_dt        =>p_rec.enrt_ovrid_thru_dt
 ,p_pl_ordr_num               =>p_rec.pl_ordr_num
 ,p_plip_ordr_num             =>p_rec.plip_ordr_num
 ,p_ptip_ordr_num             =>p_rec.ptip_ordr_num
 ,p_oipl_ordr_num             =>p_rec.oipl_ordr_num
 ,p_pen_attribute_category    =>p_rec.pen_attribute_category
 ,p_pen_attribute1            =>p_rec.pen_attribute1
 ,p_pen_attribute2            =>p_rec.pen_attribute2
 ,p_pen_attribute3            =>p_rec.pen_attribute3
 ,p_pen_attribute4            =>p_rec.pen_attribute4
 ,p_pen_attribute5            =>p_rec.pen_attribute5
 ,p_pen_attribute6            =>p_rec.pen_attribute6
 ,p_pen_attribute7            =>p_rec.pen_attribute7
 ,p_pen_attribute8            =>p_rec.pen_attribute8
 ,p_pen_attribute9            =>p_rec.pen_attribute9
 ,p_pen_attribute10           =>p_rec.pen_attribute10
 ,p_pen_attribute11           =>p_rec.pen_attribute11
 ,p_pen_attribute12           =>p_rec.pen_attribute12
 ,p_pen_attribute13           =>p_rec.pen_attribute13
 ,p_pen_attribute14           =>p_rec.pen_attribute14
 ,p_pen_attribute15           =>p_rec.pen_attribute15
 ,p_pen_attribute16           =>p_rec.pen_attribute16
 ,p_pen_attribute17           =>p_rec.pen_attribute17
 ,p_pen_attribute18           =>p_rec.pen_attribute18
 ,p_pen_attribute19           =>p_rec.pen_attribute19
 ,p_pen_attribute20           =>p_rec.pen_attribute20
 ,p_pen_attribute21           =>p_rec.pen_attribute21
 ,p_pen_attribute22           =>p_rec.pen_attribute22
 ,p_pen_attribute23           =>p_rec.pen_attribute23
 ,p_pen_attribute24           =>p_rec.pen_attribute24
 ,p_pen_attribute25           =>p_rec.pen_attribute25
 ,p_pen_attribute26           =>p_rec.pen_attribute26
 ,p_pen_attribute27           =>p_rec.pen_attribute27
 ,p_pen_attribute28           =>p_rec.pen_attribute28
 ,p_pen_attribute29           =>p_rec.pen_attribute29
 ,p_pen_attribute30           =>p_rec.pen_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_per_in_ler_id             =>p_rec.per_in_ler_id
 ,p_bnft_typ_cd               =>p_rec.bnft_typ_cd
 ,p_bnft_ordr_num             =>p_rec.bnft_ordr_num
 ,p_prtt_enrt_rslt_stat_cd    =>p_rec.prtt_enrt_rslt_stat_cd
 ,p_bnft_nnmntry_uom          =>p_rec.bnft_nnmntry_uom
 ,p_comp_lvl_cd               =>p_rec.comp_lvl_cd
 ,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_pen_shd.g_old_rec.effective_start_date
 ,p_effective_end_date_o      =>ben_pen_shd.g_old_rec.effective_end_date
 ,p_business_group_id_o       =>ben_pen_shd.g_old_rec.business_group_id
 ,p_oipl_id_o                 =>ben_pen_shd.g_old_rec.oipl_id
 ,p_person_id_o               =>ben_pen_shd.g_old_rec.person_id
 ,p_assignment_id_o           =>ben_pen_shd.g_old_rec.assignment_id
 ,p_pgm_id_o                  =>ben_pen_shd.g_old_rec.pgm_id
 ,p_pl_id_o                   =>ben_pen_shd.g_old_rec.pl_id
 ,p_rplcs_sspndd_rslt_id_o    =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
 ,p_ptip_id_o                 =>ben_pen_shd.g_old_rec.ptip_id
 ,p_pl_typ_id_o               =>ben_pen_shd.g_old_rec.pl_typ_id
 ,p_ler_id_o                  =>ben_pen_shd.g_old_rec.ler_id
 ,p_sspndd_flag_o             =>ben_pen_shd.g_old_rec.sspndd_flag
 ,p_prtt_is_cvrd_flag_o       =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
 ,p_bnft_amt_o                =>ben_pen_shd.g_old_rec.bnft_amt
 ,p_uom_o                     =>ben_pen_shd.g_old_rec.uom
 ,p_orgnl_enrt_dt_o           =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
 ,p_enrt_mthd_cd_o            =>ben_pen_shd.g_old_rec.enrt_mthd_cd
 ,p_no_lngr_elig_flag_o       =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
 ,p_enrt_ovridn_flag_o        =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
 ,p_enrt_ovrid_rsn_cd_o       =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
 ,p_erlst_deenrt_dt_o         =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
 ,p_enrt_cvg_strt_dt_o        =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
 ,p_enrt_cvg_thru_dt_o        =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
 ,p_enrt_ovrid_thru_dt_o      =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
 ,p_pl_ordr_num_o             =>ben_pen_shd.g_old_rec.pl_ordr_num
 ,p_plip_ordr_num_o           =>ben_pen_shd.g_old_rec.plip_ordr_num
 ,p_ptip_ordr_num_o           =>ben_pen_shd.g_old_rec.ptip_ordr_num
 ,p_oipl_ordr_num_o           =>ben_pen_shd.g_old_rec.oipl_ordr_num
 ,p_pen_attribute_category_o  =>ben_pen_shd.g_old_rec.pen_attribute_category
 ,p_pen_attribute1_o          =>ben_pen_shd.g_old_rec.pen_attribute1
 ,p_pen_attribute2_o          =>ben_pen_shd.g_old_rec.pen_attribute2
 ,p_pen_attribute3_o          =>ben_pen_shd.g_old_rec.pen_attribute3
 ,p_pen_attribute4_o          =>ben_pen_shd.g_old_rec.pen_attribute4
 ,p_pen_attribute5_o          =>ben_pen_shd.g_old_rec.pen_attribute5
 ,p_pen_attribute6_o          =>ben_pen_shd.g_old_rec.pen_attribute6
 ,p_pen_attribute7_o          =>ben_pen_shd.g_old_rec.pen_attribute7
 ,p_pen_attribute8_o          =>ben_pen_shd.g_old_rec.pen_attribute8
 ,p_pen_attribute9_o          =>ben_pen_shd.g_old_rec.pen_attribute9
 ,p_pen_attribute10_o         =>ben_pen_shd.g_old_rec.pen_attribute10
 ,p_pen_attribute11_o         =>ben_pen_shd.g_old_rec.pen_attribute11
 ,p_pen_attribute12_o         =>ben_pen_shd.g_old_rec.pen_attribute12
 ,p_pen_attribute13_o         =>ben_pen_shd.g_old_rec.pen_attribute13
 ,p_pen_attribute14_o         =>ben_pen_shd.g_old_rec.pen_attribute14
 ,p_pen_attribute15_o         =>ben_pen_shd.g_old_rec.pen_attribute15
 ,p_pen_attribute16_o         =>ben_pen_shd.g_old_rec.pen_attribute16
 ,p_pen_attribute17_o         =>ben_pen_shd.g_old_rec.pen_attribute17
 ,p_pen_attribute18_o         =>ben_pen_shd.g_old_rec.pen_attribute18
 ,p_pen_attribute19_o         =>ben_pen_shd.g_old_rec.pen_attribute19
 ,p_pen_attribute20_o         =>ben_pen_shd.g_old_rec.pen_attribute20
 ,p_pen_attribute21_o         =>ben_pen_shd.g_old_rec.pen_attribute21
 ,p_pen_attribute22_o         =>ben_pen_shd.g_old_rec.pen_attribute22
 ,p_pen_attribute23_o         =>ben_pen_shd.g_old_rec.pen_attribute23
 ,p_pen_attribute24_o         =>ben_pen_shd.g_old_rec.pen_attribute24
 ,p_pen_attribute25_o         =>ben_pen_shd.g_old_rec.pen_attribute25
 ,p_pen_attribute26_o         =>ben_pen_shd.g_old_rec.pen_attribute26
 ,p_pen_attribute27_o         =>ben_pen_shd.g_old_rec.pen_attribute27
 ,p_pen_attribute28_o         =>ben_pen_shd.g_old_rec.pen_attribute28
 ,p_pen_attribute29_o         =>ben_pen_shd.g_old_rec.pen_attribute29
 ,p_pen_attribute30_o         =>ben_pen_shd.g_old_rec.pen_attribute30
 ,p_request_id_o              =>ben_pen_shd.g_old_rec.request_id
 ,p_program_application_id_o  =>ben_pen_shd.g_old_rec.program_application_id
 ,p_program_id_o              =>ben_pen_shd.g_old_rec.program_id
 ,p_program_update_date_o     =>ben_pen_shd.g_old_rec.program_update_date
 ,p_object_version_number_o   =>ben_pen_shd.g_old_rec.object_version_number
 ,p_per_in_ler_id_o           =>ben_pen_shd.g_old_rec.per_in_ler_id
 ,p_bnft_typ_cd_o             =>ben_pen_shd.g_old_rec.bnft_typ_cd
 ,p_bnft_ordr_num_o           =>ben_pen_shd.g_old_rec.bnft_ordr_num
 ,p_prtt_enrt_rslt_stat_cd_o  =>ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd
 ,p_bnft_nnmntry_uom_o        =>ben_pen_shd.g_old_rec.bnft_nnmntry_uom
 ,p_comp_lvl_cd_o             =>ben_pen_shd.g_old_rec.comp_lvl_cd
 );

Line: 695


End post_update;

Line: 997


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

Line: 1069


  ben_pen_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: 1078


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


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


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


      hr_utility.set_location(' Logging PEN update event'||l_proc, 5);

Line: 1120


      hri_opl_ben_elig_enrl_eq.update_event (
                 p_rec              => p_rec ,
                 p_effective_date   => p_effective_date,
                 p_datetrack_mode   => p_datetrack_mode );

Line: 1197


  p_program_update_date          in date          default hr_api.g_date,
  p_object_version_number        in out nocopy number,
  p_per_in_ler_id                in number        default hr_api.g_number,
  p_bnft_typ_cd                  in varchar2      default hr_api.g_varchar2,
  p_bnft_ordr_num                in number        default hr_api.g_number,
  p_prtt_enrt_rslt_stat_cd       in varchar2      default hr_api.g_varchar2,
  p_bnft_nnmntry_uom             in varchar2      default hr_api.g_varchar2,
  p_comp_lvl_cd                  in varchar2      default hr_api.g_varchar2,
  p_effective_date		 in date,
  p_datetrack_mode		 in varchar2
  ) is
--
  l_rec		ben_pen_shd.g_rec_type;

Line: 1285


  p_program_update_date,
  p_object_version_number,
  p_per_in_ler_id,
  p_bnft_typ_cd,
  p_bnft_ordr_num,
  p_prtt_enrt_rslt_stat_cd,
  p_bnft_nnmntry_uom,
  p_comp_lvl_cd
  );