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

Line: 69


  update ben_elctbl_chc_ctfn
  set
  elctbl_chc_ctfn_id                = p_rec.elctbl_chc_ctfn_id,
  enrt_ctfn_typ_cd                  = p_rec.enrt_ctfn_typ_cd,
  rqd_flag                          = p_rec.rqd_flag,
  elig_per_elctbl_chc_id            = p_rec.elig_per_elctbl_chc_id,
  enrt_bnft_id                      = p_rec.enrt_bnft_id,
  business_group_id                 = p_rec.business_group_id,
  ecc_attribute_category            = p_rec.ecc_attribute_category,
  ecc_attribute1                    = p_rec.ecc_attribute1,
  ecc_attribute2                    = p_rec.ecc_attribute2,
  ecc_attribute3                    = p_rec.ecc_attribute3,
  ecc_attribute4                    = p_rec.ecc_attribute4,
  ecc_attribute5                    = p_rec.ecc_attribute5,
  ecc_attribute6                    = p_rec.ecc_attribute6,
  ecc_attribute7                    = p_rec.ecc_attribute7,
  ecc_attribute8                    = p_rec.ecc_attribute8,
  ecc_attribute9                    = p_rec.ecc_attribute9,
  ecc_attribute10                   = p_rec.ecc_attribute10,
  ecc_attribute11                   = p_rec.ecc_attribute11,
  ecc_attribute12                   = p_rec.ecc_attribute12,
  ecc_attribute13                   = p_rec.ecc_attribute13,
  ecc_attribute14                   = p_rec.ecc_attribute14,
  ecc_attribute15                   = p_rec.ecc_attribute15,
  ecc_attribute16                   = p_rec.ecc_attribute16,
  ecc_attribute17                   = p_rec.ecc_attribute17,
  ecc_attribute18                   = p_rec.ecc_attribute18,
  ecc_attribute19                   = p_rec.ecc_attribute19,
  ecc_attribute20                   = p_rec.ecc_attribute20,
  ecc_attribute21                   = p_rec.ecc_attribute21,
  ecc_attribute22                   = p_rec.ecc_attribute22,
  ecc_attribute23                   = p_rec.ecc_attribute23,
  ecc_attribute24                   = p_rec.ecc_attribute24,
  ecc_attribute25                   = p_rec.ecc_attribute25,
  ecc_attribute26                   = p_rec.ecc_attribute26,
  ecc_attribute27                   = p_rec.ecc_attribute27,
  ecc_attribute28                   = p_rec.ecc_attribute28,
  ecc_attribute29                   = p_rec.ecc_attribute29,
  ecc_attribute30                   = p_rec.ecc_attribute30,
  susp_if_ctfn_not_prvd_flag        = p_rec.susp_if_ctfn_not_prvd_flag,
  ctfn_determine_cd                 = p_rec.ctfn_determine_cd,
  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 elctbl_chc_ctfn_id = p_rec.elctbl_chc_ctfn_id;

Line: 140


End update_dml;

Line: 174


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

Line: 182


End pre_update;

Line: 216


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

Line: 229


    ben_ecc_rku.after_update
      (
  p_elctbl_chc_ctfn_id            =>p_rec.elctbl_chc_ctfn_id
 ,p_enrt_ctfn_typ_cd              =>p_rec.enrt_ctfn_typ_cd
 ,p_rqd_flag                      =>p_rec.rqd_flag
 ,p_elig_per_elctbl_chc_id        =>p_rec.elig_per_elctbl_chc_id
 ,p_enrt_bnft_id                  =>p_rec.enrt_bnft_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_ecc_attribute_category        =>p_rec.ecc_attribute_category
 ,p_ecc_attribute1                =>p_rec.ecc_attribute1
 ,p_ecc_attribute2                =>p_rec.ecc_attribute2
 ,p_ecc_attribute3                =>p_rec.ecc_attribute3
 ,p_ecc_attribute4                =>p_rec.ecc_attribute4
 ,p_ecc_attribute5                =>p_rec.ecc_attribute5
 ,p_ecc_attribute6                =>p_rec.ecc_attribute6
 ,p_ecc_attribute7                =>p_rec.ecc_attribute7
 ,p_ecc_attribute8                =>p_rec.ecc_attribute8
 ,p_ecc_attribute9                =>p_rec.ecc_attribute9
 ,p_ecc_attribute10               =>p_rec.ecc_attribute10
 ,p_ecc_attribute11               =>p_rec.ecc_attribute11
 ,p_ecc_attribute12               =>p_rec.ecc_attribute12
 ,p_ecc_attribute13               =>p_rec.ecc_attribute13
 ,p_ecc_attribute14               =>p_rec.ecc_attribute14
 ,p_ecc_attribute15               =>p_rec.ecc_attribute15
 ,p_ecc_attribute16               =>p_rec.ecc_attribute16
 ,p_ecc_attribute17               =>p_rec.ecc_attribute17
 ,p_ecc_attribute18               =>p_rec.ecc_attribute18
 ,p_ecc_attribute19               =>p_rec.ecc_attribute19
 ,p_ecc_attribute20               =>p_rec.ecc_attribute20
 ,p_ecc_attribute21               =>p_rec.ecc_attribute21
 ,p_ecc_attribute22               =>p_rec.ecc_attribute22
 ,p_ecc_attribute23               =>p_rec.ecc_attribute23
 ,p_ecc_attribute24               =>p_rec.ecc_attribute24
 ,p_ecc_attribute25               =>p_rec.ecc_attribute25
 ,p_ecc_attribute26               =>p_rec.ecc_attribute26
 ,p_ecc_attribute27               =>p_rec.ecc_attribute27
 ,p_ecc_attribute28               =>p_rec.ecc_attribute28
 ,p_ecc_attribute29               =>p_rec.ecc_attribute29
 ,p_ecc_attribute30               =>p_rec.ecc_attribute30
 ,p_susp_if_ctfn_not_prvd_flag    =>p_rec.susp_if_ctfn_not_prvd_flag
 ,p_ctfn_determine_cd             =>p_rec.ctfn_determine_cd
 ,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_enrt_ctfn_typ_cd_o            =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
 ,p_rqd_flag_o                    =>ben_ecc_shd.g_old_rec.rqd_flag
 ,p_elig_per_elctbl_chc_id_o      =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
 ,p_enrt_bnft_id_o                =>ben_ecc_shd.g_old_rec.enrt_bnft_id
 ,p_business_group_id_o           =>ben_ecc_shd.g_old_rec.business_group_id
 ,p_ecc_attribute_category_o      =>ben_ecc_shd.g_old_rec.ecc_attribute_category
 ,p_ecc_attribute1_o              =>ben_ecc_shd.g_old_rec.ecc_attribute1
 ,p_ecc_attribute2_o              =>ben_ecc_shd.g_old_rec.ecc_attribute2
 ,p_ecc_attribute3_o              =>ben_ecc_shd.g_old_rec.ecc_attribute3
 ,p_ecc_attribute4_o              =>ben_ecc_shd.g_old_rec.ecc_attribute4
 ,p_ecc_attribute5_o              =>ben_ecc_shd.g_old_rec.ecc_attribute5
 ,p_ecc_attribute6_o              =>ben_ecc_shd.g_old_rec.ecc_attribute6
 ,p_ecc_attribute7_o              =>ben_ecc_shd.g_old_rec.ecc_attribute7
 ,p_ecc_attribute8_o              =>ben_ecc_shd.g_old_rec.ecc_attribute8
 ,p_ecc_attribute9_o              =>ben_ecc_shd.g_old_rec.ecc_attribute9
 ,p_ecc_attribute10_o             =>ben_ecc_shd.g_old_rec.ecc_attribute10
 ,p_ecc_attribute11_o             =>ben_ecc_shd.g_old_rec.ecc_attribute11
 ,p_ecc_attribute12_o             =>ben_ecc_shd.g_old_rec.ecc_attribute12
 ,p_ecc_attribute13_o             =>ben_ecc_shd.g_old_rec.ecc_attribute13
 ,p_ecc_attribute14_o             =>ben_ecc_shd.g_old_rec.ecc_attribute14
 ,p_ecc_attribute15_o             =>ben_ecc_shd.g_old_rec.ecc_attribute15
 ,p_ecc_attribute16_o             =>ben_ecc_shd.g_old_rec.ecc_attribute16
 ,p_ecc_attribute17_o             =>ben_ecc_shd.g_old_rec.ecc_attribute17
 ,p_ecc_attribute18_o             =>ben_ecc_shd.g_old_rec.ecc_attribute18
 ,p_ecc_attribute19_o             =>ben_ecc_shd.g_old_rec.ecc_attribute19
 ,p_ecc_attribute20_o             =>ben_ecc_shd.g_old_rec.ecc_attribute20
 ,p_ecc_attribute21_o             =>ben_ecc_shd.g_old_rec.ecc_attribute21
 ,p_ecc_attribute22_o             =>ben_ecc_shd.g_old_rec.ecc_attribute22
 ,p_ecc_attribute23_o             =>ben_ecc_shd.g_old_rec.ecc_attribute23
 ,p_ecc_attribute24_o             =>ben_ecc_shd.g_old_rec.ecc_attribute24
 ,p_ecc_attribute25_o             =>ben_ecc_shd.g_old_rec.ecc_attribute25
 ,p_ecc_attribute26_o             =>ben_ecc_shd.g_old_rec.ecc_attribute26
 ,p_ecc_attribute27_o             =>ben_ecc_shd.g_old_rec.ecc_attribute27
 ,p_ecc_attribute28_o             =>ben_ecc_shd.g_old_rec.ecc_attribute28
 ,p_ecc_attribute29_o             =>ben_ecc_shd.g_old_rec.ecc_attribute29
 ,p_ecc_attribute30_o             =>ben_ecc_shd.g_old_rec.ecc_attribute30
 ,p_susp_if_ctfn_not_prvd_flag_o  =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
 ,p_ctfn_determine_cd_o           =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
 ,p_request_id_o                  =>ben_ecc_shd.g_old_rec.request_id
 ,p_program_application_id_o      =>ben_ecc_shd.g_old_rec.program_application_id
 ,p_program_id_o                  =>ben_ecc_shd.g_old_rec.program_id
 ,p_program_update_date_o         =>ben_ecc_shd.g_old_rec.program_update_date
 ,p_object_version_number_o       =>ben_ecc_shd.g_old_rec.object_version_number
      );

Line: 335


End post_update;

Line: 557


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

Line: 596


  ben_ecc_bus.update_validate(p_rec
  ,p_effective_date);

Line: 601


  pre_update(p_rec);

Line: 605


  update_dml(p_rec);

Line: 609


  post_update(
p_effective_date,p_rec);

Line: 661


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

Line: 719


  p_program_update_date,
  p_object_version_number
  );