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

Line: 69


  update ben_rptg_grp
  set
  rptg_grp_id                       = p_rec.rptg_grp_id,
  name                              = p_rec.name,
  business_group_id                 = p_rec.business_group_id,
  rptg_prps_cd                      = p_rec.rptg_prps_cd,
  rpg_desc                          = p_rec.rpg_desc,
  bnr_attribute_category            = p_rec.bnr_attribute_category,
  bnr_attribute1                    = p_rec.bnr_attribute1,
  bnr_attribute2                    = p_rec.bnr_attribute2,
  bnr_attribute3                    = p_rec.bnr_attribute3,
  bnr_attribute4                    = p_rec.bnr_attribute4,
  bnr_attribute5                    = p_rec.bnr_attribute5,
  bnr_attribute6                    = p_rec.bnr_attribute6,
  bnr_attribute7                    = p_rec.bnr_attribute7,
  bnr_attribute8                    = p_rec.bnr_attribute8,
  bnr_attribute9                    = p_rec.bnr_attribute9,
  bnr_attribute10                   = p_rec.bnr_attribute10,
  bnr_attribute11                   = p_rec.bnr_attribute11,
  bnr_attribute12                   = p_rec.bnr_attribute12,
  bnr_attribute13                   = p_rec.bnr_attribute13,
  bnr_attribute14                   = p_rec.bnr_attribute14,
  bnr_attribute15                   = p_rec.bnr_attribute15,
  bnr_attribute16                   = p_rec.bnr_attribute16,
  bnr_attribute17                   = p_rec.bnr_attribute17,
  bnr_attribute18                   = p_rec.bnr_attribute18,
  bnr_attribute19                   = p_rec.bnr_attribute19,
  bnr_attribute20                   = p_rec.bnr_attribute20,
  bnr_attribute21                   = p_rec.bnr_attribute21,
  bnr_attribute22                   = p_rec.bnr_attribute22,
  bnr_attribute23                   = p_rec.bnr_attribute23,
  bnr_attribute24                   = p_rec.bnr_attribute24,
  bnr_attribute25                   = p_rec.bnr_attribute25,
  bnr_attribute26                   = p_rec.bnr_attribute26,
  bnr_attribute27                   = p_rec.bnr_attribute27,
  bnr_attribute28                   = p_rec.bnr_attribute28,
  bnr_attribute29                   = p_rec.bnr_attribute29,
  bnr_attribute30                   = p_rec.bnr_attribute30,
  function_code                     = p_rec.function_code,
  legislation_code                  = p_rec.legislation_code,
  object_version_number             = p_rec.object_version_number,
  ordr_num                          = p_rec.ordr_num                      --iRec
  where rptg_grp_id = p_rec.rptg_grp_id;

Line: 115


   update ben_rptg_grp_tl
   set name   = p_rec.name,
       function_code = p_rec.function_code,
   last_update_date  = sysdate,
   last_updated_by   = fnd_global.user_id,
   last_update_login = fnd_global.login_id,
   source_lang = userenv('LANG')
   where rptg_grp_id = p_rec.rptg_grp_id
   and   userenv('LANG') in (language, source_lang);

Line: 148


End update_dml;

Line: 182


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

Line: 190


End pre_update;

Line: 224


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

Line: 237


    ben_bnr_rku.after_update
      (
  p_rptg_grp_id                   =>p_rec.rptg_grp_id
 ,p_name                          =>p_rec.name
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_rptg_prps_cd                  =>p_rec.rptg_prps_cd
 ,p_rpg_desc                      =>p_rec.rpg_desc
 ,p_bnr_attribute_category        =>p_rec.bnr_attribute_category
 ,p_bnr_attribute1                =>p_rec.bnr_attribute1
 ,p_bnr_attribute2                =>p_rec.bnr_attribute2
 ,p_bnr_attribute3                =>p_rec.bnr_attribute3
 ,p_bnr_attribute4                =>p_rec.bnr_attribute4
 ,p_bnr_attribute5                =>p_rec.bnr_attribute5
 ,p_bnr_attribute6                =>p_rec.bnr_attribute6
 ,p_bnr_attribute7                =>p_rec.bnr_attribute7
 ,p_bnr_attribute8                =>p_rec.bnr_attribute8
 ,p_bnr_attribute9                =>p_rec.bnr_attribute9
 ,p_bnr_attribute10               =>p_rec.bnr_attribute10
 ,p_bnr_attribute11               =>p_rec.bnr_attribute11
 ,p_bnr_attribute12               =>p_rec.bnr_attribute12
 ,p_bnr_attribute13               =>p_rec.bnr_attribute13
 ,p_bnr_attribute14               =>p_rec.bnr_attribute14
 ,p_bnr_attribute15               =>p_rec.bnr_attribute15
 ,p_bnr_attribute16               =>p_rec.bnr_attribute16
 ,p_bnr_attribute17               =>p_rec.bnr_attribute17
 ,p_bnr_attribute18               =>p_rec.bnr_attribute18
 ,p_bnr_attribute19               =>p_rec.bnr_attribute19
 ,p_bnr_attribute20               =>p_rec.bnr_attribute20
 ,p_bnr_attribute21               =>p_rec.bnr_attribute21
 ,p_bnr_attribute22               =>p_rec.bnr_attribute22
 ,p_bnr_attribute23               =>p_rec.bnr_attribute23
 ,p_bnr_attribute24               =>p_rec.bnr_attribute24
 ,p_bnr_attribute25               =>p_rec.bnr_attribute25
 ,p_bnr_attribute26               =>p_rec.bnr_attribute26
 ,p_bnr_attribute27               =>p_rec.bnr_attribute27
 ,p_bnr_attribute28               =>p_rec.bnr_attribute28
 ,p_bnr_attribute29               =>p_rec.bnr_attribute29
 ,p_bnr_attribute30               =>p_rec.bnr_attribute30
 ,p_function_code                 =>p_rec.function_code
 ,p_legislation_code              =>p_rec.legislation_code
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_ordr_num                      =>p_rec.ordr_num                      --iRec
 ,p_effective_date                =>p_effective_date
 ,p_name_o                        =>ben_bnr_shd.g_old_rec.name
 ,p_business_group_id_o           =>ben_bnr_shd.g_old_rec.business_group_id
 ,p_rptg_prps_cd_o                =>ben_bnr_shd.g_old_rec.rptg_prps_cd
 ,p_rpg_desc_o                    =>ben_bnr_shd.g_old_rec.rpg_desc
 ,p_bnr_attribute_category_o      =>ben_bnr_shd.g_old_rec.bnr_attribute_category
 ,p_bnr_attribute1_o              =>ben_bnr_shd.g_old_rec.bnr_attribute1
 ,p_bnr_attribute2_o              =>ben_bnr_shd.g_old_rec.bnr_attribute2
 ,p_bnr_attribute3_o              =>ben_bnr_shd.g_old_rec.bnr_attribute3
 ,p_bnr_attribute4_o              =>ben_bnr_shd.g_old_rec.bnr_attribute4
 ,p_bnr_attribute5_o              =>ben_bnr_shd.g_old_rec.bnr_attribute5
 ,p_bnr_attribute6_o              =>ben_bnr_shd.g_old_rec.bnr_attribute6
 ,p_bnr_attribute7_o              =>ben_bnr_shd.g_old_rec.bnr_attribute7
 ,p_bnr_attribute8_o              =>ben_bnr_shd.g_old_rec.bnr_attribute8
 ,p_bnr_attribute9_o              =>ben_bnr_shd.g_old_rec.bnr_attribute9
 ,p_bnr_attribute10_o             =>ben_bnr_shd.g_old_rec.bnr_attribute10
 ,p_bnr_attribute11_o             =>ben_bnr_shd.g_old_rec.bnr_attribute11
 ,p_bnr_attribute12_o             =>ben_bnr_shd.g_old_rec.bnr_attribute12
 ,p_bnr_attribute13_o             =>ben_bnr_shd.g_old_rec.bnr_attribute13
 ,p_bnr_attribute14_o             =>ben_bnr_shd.g_old_rec.bnr_attribute14
 ,p_bnr_attribute15_o             =>ben_bnr_shd.g_old_rec.bnr_attribute15
 ,p_bnr_attribute16_o             =>ben_bnr_shd.g_old_rec.bnr_attribute16
 ,p_bnr_attribute17_o             =>ben_bnr_shd.g_old_rec.bnr_attribute17
 ,p_bnr_attribute18_o             =>ben_bnr_shd.g_old_rec.bnr_attribute18
 ,p_bnr_attribute19_o             =>ben_bnr_shd.g_old_rec.bnr_attribute19
 ,p_bnr_attribute20_o             =>ben_bnr_shd.g_old_rec.bnr_attribute20
 ,p_bnr_attribute21_o             =>ben_bnr_shd.g_old_rec.bnr_attribute21
 ,p_bnr_attribute22_o             =>ben_bnr_shd.g_old_rec.bnr_attribute22
 ,p_bnr_attribute23_o             =>ben_bnr_shd.g_old_rec.bnr_attribute23
 ,p_bnr_attribute24_o             =>ben_bnr_shd.g_old_rec.bnr_attribute24
 ,p_bnr_attribute25_o             =>ben_bnr_shd.g_old_rec.bnr_attribute25
 ,p_bnr_attribute26_o             =>ben_bnr_shd.g_old_rec.bnr_attribute26
 ,p_bnr_attribute27_o             =>ben_bnr_shd.g_old_rec.bnr_attribute27
 ,p_bnr_attribute28_o             =>ben_bnr_shd.g_old_rec.bnr_attribute28
 ,p_bnr_attribute29_o             =>ben_bnr_shd.g_old_rec.bnr_attribute29
 ,p_bnr_attribute30_o             =>ben_bnr_shd.g_old_rec.bnr_attribute30
 ,p_function_code_o               =>ben_bnr_shd.g_old_rec.function_code
 ,p_legislation_code_o            =>ben_bnr_shd.g_old_rec.legislation_code
 ,p_object_version_number_o       =>ben_bnr_shd.g_old_rec.object_version_number
 ,p_ordr_num_o                    =>ben_bnr_shd.g_old_rec.ordr_num                      --iRec
      );

Line: 335


End post_update;

Line: 573


  ben_bnr_bus.update_validate(p_rec
  ,p_effective_date);

Line: 578


  pre_update(p_rec);

Line: 582


  update_dml(p_rec);

Line: 586


  post_update(
p_effective_date,p_rec);