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

Line: 69


  update ben_enrt_prem
  set
  enrt_prem_id                      = p_rec.enrt_prem_id,
  val                               = p_rec.val,
  uom                               = p_rec.uom,
  elig_per_elctbl_chc_id            = p_rec.elig_per_elctbl_chc_id,
  enrt_bnft_id                      = p_rec.enrt_bnft_id,
  actl_prem_id                      = p_rec.actl_prem_id,
  business_group_id                 = p_rec.business_group_id,
  epr_attribute_category            = p_rec.epr_attribute_category,
  epr_attribute1                    = p_rec.epr_attribute1,
  epr_attribute2                    = p_rec.epr_attribute2,
  epr_attribute3                    = p_rec.epr_attribute3,
  epr_attribute4                    = p_rec.epr_attribute4,
  epr_attribute5                    = p_rec.epr_attribute5,
  epr_attribute6                    = p_rec.epr_attribute6,
  epr_attribute7                    = p_rec.epr_attribute7,
  epr_attribute8                    = p_rec.epr_attribute8,
  epr_attribute9                    = p_rec.epr_attribute9,
  epr_attribute10                   = p_rec.epr_attribute10,
  epr_attribute11                   = p_rec.epr_attribute11,
  epr_attribute12                   = p_rec.epr_attribute12,
  epr_attribute13                   = p_rec.epr_attribute13,
  epr_attribute14                   = p_rec.epr_attribute14,
  epr_attribute15                   = p_rec.epr_attribute15,
  epr_attribute16                   = p_rec.epr_attribute16,
  epr_attribute17                   = p_rec.epr_attribute17,
  epr_attribute18                   = p_rec.epr_attribute18,
  epr_attribute19                   = p_rec.epr_attribute19,
  epr_attribute20                   = p_rec.epr_attribute20,
  epr_attribute21                   = p_rec.epr_attribute21,
  epr_attribute22                   = p_rec.epr_attribute22,
  epr_attribute23                   = p_rec.epr_attribute23,
  epr_attribute24                   = p_rec.epr_attribute24,
  epr_attribute25                   = p_rec.epr_attribute25,
  epr_attribute26                   = p_rec.epr_attribute26,
  epr_attribute27                   = p_rec.epr_attribute27,
  epr_attribute28                   = p_rec.epr_attribute28,
  epr_attribute29                   = p_rec.epr_attribute29,
  epr_attribute30                   = p_rec.epr_attribute30,
  object_version_number             = p_rec.object_version_number,
  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
  where enrt_prem_id = p_rec.enrt_prem_id;

Line: 139


End update_dml;

Line: 173


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

Line: 181


End pre_update;

Line: 215


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

Line: 227


    ben_epr_rku.after_update
      (
  p_enrt_prem_id                  =>p_rec.enrt_prem_id
 ,p_val                           =>p_rec.val
 ,p_uom                           =>p_rec.uom
 ,p_elig_per_elctbl_chc_id        =>p_rec.elig_per_elctbl_chc_id
 ,p_enrt_bnft_id                  =>p_rec.enrt_bnft_id
 ,p_actl_prem_id                  =>p_rec.actl_prem_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_epr_attribute_category        =>p_rec.epr_attribute_category
 ,p_epr_attribute1                =>p_rec.epr_attribute1
 ,p_epr_attribute2                =>p_rec.epr_attribute2
 ,p_epr_attribute3                =>p_rec.epr_attribute3
 ,p_epr_attribute4                =>p_rec.epr_attribute4
 ,p_epr_attribute5                =>p_rec.epr_attribute5
 ,p_epr_attribute6                =>p_rec.epr_attribute6
 ,p_epr_attribute7                =>p_rec.epr_attribute7
 ,p_epr_attribute8                =>p_rec.epr_attribute8
 ,p_epr_attribute9                =>p_rec.epr_attribute9
 ,p_epr_attribute10               =>p_rec.epr_attribute10
 ,p_epr_attribute11               =>p_rec.epr_attribute11
 ,p_epr_attribute12               =>p_rec.epr_attribute12
 ,p_epr_attribute13               =>p_rec.epr_attribute13
 ,p_epr_attribute14               =>p_rec.epr_attribute14
 ,p_epr_attribute15               =>p_rec.epr_attribute15
 ,p_epr_attribute16               =>p_rec.epr_attribute16
 ,p_epr_attribute17               =>p_rec.epr_attribute17
 ,p_epr_attribute18               =>p_rec.epr_attribute18
 ,p_epr_attribute19               =>p_rec.epr_attribute19
 ,p_epr_attribute20               =>p_rec.epr_attribute20
 ,p_epr_attribute21               =>p_rec.epr_attribute21
 ,p_epr_attribute22               =>p_rec.epr_attribute22
 ,p_epr_attribute23               =>p_rec.epr_attribute23
 ,p_epr_attribute24               =>p_rec.epr_attribute24
 ,p_epr_attribute25               =>p_rec.epr_attribute25
 ,p_epr_attribute26               =>p_rec.epr_attribute26
 ,p_epr_attribute27               =>p_rec.epr_attribute27
 ,p_epr_attribute28               =>p_rec.epr_attribute28
 ,p_epr_attribute29               =>p_rec.epr_attribute29
 ,p_epr_attribute30               =>p_rec.epr_attribute30
 ,p_object_version_number         =>p_rec.object_version_number
 ,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_val_o                         =>ben_epr_shd.g_old_rec.val
 ,p_uom_o                         =>ben_epr_shd.g_old_rec.uom
 ,p_elig_per_elctbl_chc_id_o      =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
 ,p_enrt_bnft_id_o                =>ben_epr_shd.g_old_rec.enrt_bnft_id
 ,p_actl_prem_id_o                =>ben_epr_shd.g_old_rec.actl_prem_id
 ,p_business_group_id_o           =>ben_epr_shd.g_old_rec.business_group_id
 ,p_epr_attribute_category_o      =>ben_epr_shd.g_old_rec.epr_attribute_category
 ,p_epr_attribute1_o              =>ben_epr_shd.g_old_rec.epr_attribute1
 ,p_epr_attribute2_o              =>ben_epr_shd.g_old_rec.epr_attribute2
 ,p_epr_attribute3_o              =>ben_epr_shd.g_old_rec.epr_attribute3
 ,p_epr_attribute4_o              =>ben_epr_shd.g_old_rec.epr_attribute4
 ,p_epr_attribute5_o              =>ben_epr_shd.g_old_rec.epr_attribute5
 ,p_epr_attribute6_o              =>ben_epr_shd.g_old_rec.epr_attribute6
 ,p_epr_attribute7_o              =>ben_epr_shd.g_old_rec.epr_attribute7
 ,p_epr_attribute8_o              =>ben_epr_shd.g_old_rec.epr_attribute8
 ,p_epr_attribute9_o              =>ben_epr_shd.g_old_rec.epr_attribute9
 ,p_epr_attribute10_o             =>ben_epr_shd.g_old_rec.epr_attribute10
 ,p_epr_attribute11_o             =>ben_epr_shd.g_old_rec.epr_attribute11
 ,p_epr_attribute12_o             =>ben_epr_shd.g_old_rec.epr_attribute12
 ,p_epr_attribute13_o             =>ben_epr_shd.g_old_rec.epr_attribute13
 ,p_epr_attribute14_o             =>ben_epr_shd.g_old_rec.epr_attribute14
 ,p_epr_attribute15_o             =>ben_epr_shd.g_old_rec.epr_attribute15
 ,p_epr_attribute16_o             =>ben_epr_shd.g_old_rec.epr_attribute16
 ,p_epr_attribute17_o             =>ben_epr_shd.g_old_rec.epr_attribute17
 ,p_epr_attribute18_o             =>ben_epr_shd.g_old_rec.epr_attribute18
 ,p_epr_attribute19_o             =>ben_epr_shd.g_old_rec.epr_attribute19
 ,p_epr_attribute20_o             =>ben_epr_shd.g_old_rec.epr_attribute20
 ,p_epr_attribute21_o             =>ben_epr_shd.g_old_rec.epr_attribute21
 ,p_epr_attribute22_o             =>ben_epr_shd.g_old_rec.epr_attribute22
 ,p_epr_attribute23_o             =>ben_epr_shd.g_old_rec.epr_attribute23
 ,p_epr_attribute24_o             =>ben_epr_shd.g_old_rec.epr_attribute24
 ,p_epr_attribute25_o             =>ben_epr_shd.g_old_rec.epr_attribute25
 ,p_epr_attribute26_o             =>ben_epr_shd.g_old_rec.epr_attribute26
 ,p_epr_attribute27_o             =>ben_epr_shd.g_old_rec.epr_attribute27
 ,p_epr_attribute28_o             =>ben_epr_shd.g_old_rec.epr_attribute28
 ,p_epr_attribute29_o             =>ben_epr_shd.g_old_rec.epr_attribute29
 ,p_epr_attribute30_o             =>ben_epr_shd.g_old_rec.epr_attribute30
 ,p_object_version_number_o       =>ben_epr_shd.g_old_rec.object_version_number
 ,p_request_id_o                  =>ben_epr_shd.g_old_rec.request_id
 ,p_program_application_id_o      =>ben_epr_shd.g_old_rec.program_application_id
 ,p_program_id_o                  =>ben_epr_shd.g_old_rec.program_id
 ,p_program_update_date_o         =>ben_epr_shd.g_old_rec.program_update_date
      );

Line: 330


End post_update;

Line: 548


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

Line: 585


  ben_epr_bus.update_validate(p_rec);

Line: 589


  pre_update(p_rec);

Line: 593


  update_dml(p_rec);

Line: 597


  post_update(p_rec);

Line: 647


  p_program_update_date          in date             default hr_api.g_date
  ) is
--
  l_rec	  ben_epr_shd.g_rec_type;

Line: 704


  p_program_update_date
  );