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

Line: 69


  update ben_enrt_rt_ctfn
  set
  enrt_rt_ctfn_id                = p_rec.enrt_rt_ctfn_id,
  enrt_ctfn_typ_cd                  = p_rec.enrt_ctfn_typ_cd,
  rqd_flag                          = p_rec.rqd_flag,
  enrt_rt_id            = p_rec.enrt_rt_id,
  business_group_id                 = p_rec.business_group_id,
  erc_attribute_category            = p_rec.erc_attribute_category,
  erc_attribute1                    = p_rec.erc_attribute1,
  erc_attribute2                    = p_rec.erc_attribute2,
  erc_attribute3                    = p_rec.erc_attribute3,
  erc_attribute4                    = p_rec.erc_attribute4,
  erc_attribute5                    = p_rec.erc_attribute5,
  erc_attribute6                    = p_rec.erc_attribute6,
  erc_attribute7                    = p_rec.erc_attribute7,
  erc_attribute8                    = p_rec.erc_attribute8,
  erc_attribute9                    = p_rec.erc_attribute9,
  erc_attribute10                   = p_rec.erc_attribute10,
  erc_attribute11                   = p_rec.erc_attribute11,
  erc_attribute12                   = p_rec.erc_attribute12,
  erc_attribute13                   = p_rec.erc_attribute13,
  erc_attribute14                   = p_rec.erc_attribute14,
  erc_attribute15                   = p_rec.erc_attribute15,
  erc_attribute16                   = p_rec.erc_attribute16,
  erc_attribute17                   = p_rec.erc_attribute17,
  erc_attribute18                   = p_rec.erc_attribute18,
  erc_attribute19                   = p_rec.erc_attribute19,
  erc_attribute20                   = p_rec.erc_attribute20,
  erc_attribute21                   = p_rec.erc_attribute21,
  erc_attribute22                   = p_rec.erc_attribute22,
  erc_attribute23                   = p_rec.erc_attribute23,
  erc_attribute24                   = p_rec.erc_attribute24,
  erc_attribute25                   = p_rec.erc_attribute25,
  erc_attribute26                   = p_rec.erc_attribute26,
  erc_attribute27                   = p_rec.erc_attribute27,
  erc_attribute28                   = p_rec.erc_attribute28,
  erc_attribute29                   = p_rec.erc_attribute29,
  erc_attribute30                   = p_rec.erc_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 enrt_rt_ctfn_id = p_rec.enrt_rt_ctfn_id;

Line: 137


End update_dml;

Line: 171


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

Line: 179


End pre_update;

Line: 213


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

Line: 226


    ben_erc_rku.after_update
      (
  p_enrt_rt_ctfn_id            =>p_rec.enrt_rt_ctfn_id
 ,p_enrt_ctfn_typ_cd              =>p_rec.enrt_ctfn_typ_cd
 ,p_rqd_flag                      =>p_rec.rqd_flag
 ,p_enrt_rt_id        =>p_rec.enrt_rt_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_erc_attribute_category        =>p_rec.erc_attribute_category
 ,p_erc_attribute1                =>p_rec.erc_attribute1
 ,p_erc_attribute2                =>p_rec.erc_attribute2
 ,p_erc_attribute3                =>p_rec.erc_attribute3
 ,p_erc_attribute4                =>p_rec.erc_attribute4
 ,p_erc_attribute5                =>p_rec.erc_attribute5
 ,p_erc_attribute6                =>p_rec.erc_attribute6
 ,p_erc_attribute7                =>p_rec.erc_attribute7
 ,p_erc_attribute8                =>p_rec.erc_attribute8
 ,p_erc_attribute9                =>p_rec.erc_attribute9
 ,p_erc_attribute10               =>p_rec.erc_attribute10
 ,p_erc_attribute11               =>p_rec.erc_attribute11
 ,p_erc_attribute12               =>p_rec.erc_attribute12
 ,p_erc_attribute13               =>p_rec.erc_attribute13
 ,p_erc_attribute14               =>p_rec.erc_attribute14
 ,p_erc_attribute15               =>p_rec.erc_attribute15
 ,p_erc_attribute16               =>p_rec.erc_attribute16
 ,p_erc_attribute17               =>p_rec.erc_attribute17
 ,p_erc_attribute18               =>p_rec.erc_attribute18
 ,p_erc_attribute19               =>p_rec.erc_attribute19
 ,p_erc_attribute20               =>p_rec.erc_attribute20
 ,p_erc_attribute21               =>p_rec.erc_attribute21
 ,p_erc_attribute22               =>p_rec.erc_attribute22
 ,p_erc_attribute23               =>p_rec.erc_attribute23
 ,p_erc_attribute24               =>p_rec.erc_attribute24
 ,p_erc_attribute25               =>p_rec.erc_attribute25
 ,p_erc_attribute26               =>p_rec.erc_attribute26
 ,p_erc_attribute27               =>p_rec.erc_attribute27
 ,p_erc_attribute28               =>p_rec.erc_attribute28
 ,p_erc_attribute29               =>p_rec.erc_attribute29
 ,p_erc_attribute30               =>p_rec.erc_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_enrt_ctfn_typ_cd_o            =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
 ,p_rqd_flag_o                    =>ben_erc_shd.g_old_rec.rqd_flag
 ,p_enrt_rt_id_o      =>ben_erc_shd.g_old_rec.enrt_rt_id
 ,p_business_group_id_o           =>ben_erc_shd.g_old_rec.business_group_id
 ,p_erc_attribute_category_o      =>ben_erc_shd.g_old_rec.erc_attribute_category
 ,p_erc_attribute1_o              =>ben_erc_shd.g_old_rec.erc_attribute1
 ,p_erc_attribute2_o              =>ben_erc_shd.g_old_rec.erc_attribute2
 ,p_erc_attribute3_o              =>ben_erc_shd.g_old_rec.erc_attribute3
 ,p_erc_attribute4_o              =>ben_erc_shd.g_old_rec.erc_attribute4
 ,p_erc_attribute5_o              =>ben_erc_shd.g_old_rec.erc_attribute5
 ,p_erc_attribute6_o              =>ben_erc_shd.g_old_rec.erc_attribute6
 ,p_erc_attribute7_o              =>ben_erc_shd.g_old_rec.erc_attribute7
 ,p_erc_attribute8_o              =>ben_erc_shd.g_old_rec.erc_attribute8
 ,p_erc_attribute9_o              =>ben_erc_shd.g_old_rec.erc_attribute9
 ,p_erc_attribute10_o             =>ben_erc_shd.g_old_rec.erc_attribute10
 ,p_erc_attribute11_o             =>ben_erc_shd.g_old_rec.erc_attribute11
 ,p_erc_attribute12_o             =>ben_erc_shd.g_old_rec.erc_attribute12
 ,p_erc_attribute13_o             =>ben_erc_shd.g_old_rec.erc_attribute13
 ,p_erc_attribute14_o             =>ben_erc_shd.g_old_rec.erc_attribute14
 ,p_erc_attribute15_o             =>ben_erc_shd.g_old_rec.erc_attribute15
 ,p_erc_attribute16_o             =>ben_erc_shd.g_old_rec.erc_attribute16
 ,p_erc_attribute17_o             =>ben_erc_shd.g_old_rec.erc_attribute17
 ,p_erc_attribute18_o             =>ben_erc_shd.g_old_rec.erc_attribute18
 ,p_erc_attribute19_o             =>ben_erc_shd.g_old_rec.erc_attribute19
 ,p_erc_attribute20_o             =>ben_erc_shd.g_old_rec.erc_attribute20
 ,p_erc_attribute21_o             =>ben_erc_shd.g_old_rec.erc_attribute21
 ,p_erc_attribute22_o             =>ben_erc_shd.g_old_rec.erc_attribute22
 ,p_erc_attribute23_o             =>ben_erc_shd.g_old_rec.erc_attribute23
 ,p_erc_attribute24_o             =>ben_erc_shd.g_old_rec.erc_attribute24
 ,p_erc_attribute25_o             =>ben_erc_shd.g_old_rec.erc_attribute25
 ,p_erc_attribute26_o             =>ben_erc_shd.g_old_rec.erc_attribute26
 ,p_erc_attribute27_o             =>ben_erc_shd.g_old_rec.erc_attribute27
 ,p_erc_attribute28_o             =>ben_erc_shd.g_old_rec.erc_attribute28
 ,p_erc_attribute29_o             =>ben_erc_shd.g_old_rec.erc_attribute29
 ,p_erc_attribute30_o             =>ben_erc_shd.g_old_rec.erc_attribute30
 ,p_request_id_o                  =>ben_erc_shd.g_old_rec.request_id
 ,p_program_application_id_o      =>ben_erc_shd.g_old_rec.program_application_id
 ,p_program_id_o                  =>ben_erc_shd.g_old_rec.program_id
 ,p_program_update_date_o         =>ben_erc_shd.g_old_rec.program_update_date
 ,p_object_version_number_o       =>ben_erc_shd.g_old_rec.object_version_number
      );

Line: 326


End post_update;

Line: 536


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

Line: 575


  ben_erc_bus.update_validate(p_rec
  ,p_effective_date);

Line: 580


  pre_update(p_rec);

Line: 584


  update_dml(p_rec);

Line: 588


  post_update(
p_effective_date,p_rec);

Line: 637


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

Line: 692


  p_program_update_date,
  p_object_version_number
  );