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

Line: 69


  update ben_crt_ordr_cvrd_per
  set
  crt_ordr_cvrd_per_id              = p_rec.crt_ordr_cvrd_per_id,
  crt_ordr_id                       = p_rec.crt_ordr_id,
  person_id                         = p_rec.person_id,
  business_group_id                 = p_rec.business_group_id,
  crd_attribute_category            = p_rec.crd_attribute_category,
  crd_attribute1                    = p_rec.crd_attribute1,
  crd_attribute2                    = p_rec.crd_attribute2,
  crd_attribute3                    = p_rec.crd_attribute3,
  crd_attribute4                    = p_rec.crd_attribute4,
  crd_attribute5                    = p_rec.crd_attribute5,
  crd_attribute6                    = p_rec.crd_attribute6,
  crd_attribute7                    = p_rec.crd_attribute7,
  crd_attribute8                    = p_rec.crd_attribute8,
  crd_attribute9                    = p_rec.crd_attribute9,
  crd_attribute10                   = p_rec.crd_attribute10,
  crd_attribute11                   = p_rec.crd_attribute11,
  crd_attribute12                   = p_rec.crd_attribute12,
  crd_attribute13                   = p_rec.crd_attribute13,
  crd_attribute14                   = p_rec.crd_attribute14,
  crd_attribute15                   = p_rec.crd_attribute15,
  crd_attribute16                   = p_rec.crd_attribute16,
  crd_attribute17                   = p_rec.crd_attribute17,
  crd_attribute18                   = p_rec.crd_attribute18,
  crd_attribute19                   = p_rec.crd_attribute19,
  crd_attribute20                   = p_rec.crd_attribute20,
  crd_attribute21                   = p_rec.crd_attribute21,
  crd_attribute22                   = p_rec.crd_attribute22,
  crd_attribute23                   = p_rec.crd_attribute23,
  crd_attribute24                   = p_rec.crd_attribute24,
  crd_attribute25                   = p_rec.crd_attribute25,
  crd_attribute26                   = p_rec.crd_attribute26,
  crd_attribute27                   = p_rec.crd_attribute27,
  crd_attribute28                   = p_rec.crd_attribute28,
  crd_attribute29                   = p_rec.crd_attribute29,
  crd_attribute30                   = p_rec.crd_attribute30,
  object_version_number             = p_rec.object_version_number
  where crt_ordr_cvrd_per_id = p_rec.crt_ordr_cvrd_per_id;

Line: 132


End update_dml;

Line: 166


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

Line: 174


End pre_update;

Line: 208


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

Line: 220


    ben_crd_rku.after_update
      (
  p_crt_ordr_cvrd_per_id          =>p_rec.crt_ordr_cvrd_per_id
 ,p_crt_ordr_id                   =>p_rec.crt_ordr_id
 ,p_person_id                     =>p_rec.person_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_crd_attribute_category        =>p_rec.crd_attribute_category
 ,p_crd_attribute1                =>p_rec.crd_attribute1
 ,p_crd_attribute2                =>p_rec.crd_attribute2
 ,p_crd_attribute3                =>p_rec.crd_attribute3
 ,p_crd_attribute4                =>p_rec.crd_attribute4
 ,p_crd_attribute5                =>p_rec.crd_attribute5
 ,p_crd_attribute6                =>p_rec.crd_attribute6
 ,p_crd_attribute7                =>p_rec.crd_attribute7
 ,p_crd_attribute8                =>p_rec.crd_attribute8
 ,p_crd_attribute9                =>p_rec.crd_attribute9
 ,p_crd_attribute10               =>p_rec.crd_attribute10
 ,p_crd_attribute11               =>p_rec.crd_attribute11
 ,p_crd_attribute12               =>p_rec.crd_attribute12
 ,p_crd_attribute13               =>p_rec.crd_attribute13
 ,p_crd_attribute14               =>p_rec.crd_attribute14
 ,p_crd_attribute15               =>p_rec.crd_attribute15
 ,p_crd_attribute16               =>p_rec.crd_attribute16
 ,p_crd_attribute17               =>p_rec.crd_attribute17
 ,p_crd_attribute18               =>p_rec.crd_attribute18
 ,p_crd_attribute19               =>p_rec.crd_attribute19
 ,p_crd_attribute20               =>p_rec.crd_attribute20
 ,p_crd_attribute21               =>p_rec.crd_attribute21
 ,p_crd_attribute22               =>p_rec.crd_attribute22
 ,p_crd_attribute23               =>p_rec.crd_attribute23
 ,p_crd_attribute24               =>p_rec.crd_attribute24
 ,p_crd_attribute25               =>p_rec.crd_attribute25
 ,p_crd_attribute26               =>p_rec.crd_attribute26
 ,p_crd_attribute27               =>p_rec.crd_attribute27
 ,p_crd_attribute28               =>p_rec.crd_attribute28
 ,p_crd_attribute29               =>p_rec.crd_attribute29
 ,p_crd_attribute30               =>p_rec.crd_attribute30
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_crt_ordr_id_o                 =>ben_crd_shd.g_old_rec.crt_ordr_id
 ,p_person_id_o                   =>ben_crd_shd.g_old_rec.person_id
 ,p_business_group_id_o           =>ben_crd_shd.g_old_rec.business_group_id
 ,p_crd_attribute_category_o      =>ben_crd_shd.g_old_rec.crd_attribute_category
 ,p_crd_attribute1_o              =>ben_crd_shd.g_old_rec.crd_attribute1
 ,p_crd_attribute2_o              =>ben_crd_shd.g_old_rec.crd_attribute2
 ,p_crd_attribute3_o              =>ben_crd_shd.g_old_rec.crd_attribute3
 ,p_crd_attribute4_o              =>ben_crd_shd.g_old_rec.crd_attribute4
 ,p_crd_attribute5_o              =>ben_crd_shd.g_old_rec.crd_attribute5
 ,p_crd_attribute6_o              =>ben_crd_shd.g_old_rec.crd_attribute6
 ,p_crd_attribute7_o              =>ben_crd_shd.g_old_rec.crd_attribute7
 ,p_crd_attribute8_o              =>ben_crd_shd.g_old_rec.crd_attribute8
 ,p_crd_attribute9_o              =>ben_crd_shd.g_old_rec.crd_attribute9
 ,p_crd_attribute10_o             =>ben_crd_shd.g_old_rec.crd_attribute10
 ,p_crd_attribute11_o             =>ben_crd_shd.g_old_rec.crd_attribute11
 ,p_crd_attribute12_o             =>ben_crd_shd.g_old_rec.crd_attribute12
 ,p_crd_attribute13_o             =>ben_crd_shd.g_old_rec.crd_attribute13
 ,p_crd_attribute14_o             =>ben_crd_shd.g_old_rec.crd_attribute14
 ,p_crd_attribute15_o             =>ben_crd_shd.g_old_rec.crd_attribute15
 ,p_crd_attribute16_o             =>ben_crd_shd.g_old_rec.crd_attribute16
 ,p_crd_attribute17_o             =>ben_crd_shd.g_old_rec.crd_attribute17
 ,p_crd_attribute18_o             =>ben_crd_shd.g_old_rec.crd_attribute18
 ,p_crd_attribute19_o             =>ben_crd_shd.g_old_rec.crd_attribute19
 ,p_crd_attribute20_o             =>ben_crd_shd.g_old_rec.crd_attribute20
 ,p_crd_attribute21_o             =>ben_crd_shd.g_old_rec.crd_attribute21
 ,p_crd_attribute22_o             =>ben_crd_shd.g_old_rec.crd_attribute22
 ,p_crd_attribute23_o             =>ben_crd_shd.g_old_rec.crd_attribute23
 ,p_crd_attribute24_o             =>ben_crd_shd.g_old_rec.crd_attribute24
 ,p_crd_attribute25_o             =>ben_crd_shd.g_old_rec.crd_attribute25
 ,p_crd_attribute26_o             =>ben_crd_shd.g_old_rec.crd_attribute26
 ,p_crd_attribute27_o             =>ben_crd_shd.g_old_rec.crd_attribute27
 ,p_crd_attribute28_o             =>ben_crd_shd.g_old_rec.crd_attribute28
 ,p_crd_attribute29_o             =>ben_crd_shd.g_old_rec.crd_attribute29
 ,p_crd_attribute30_o             =>ben_crd_shd.g_old_rec.crd_attribute30
 ,p_object_version_number_o       =>ben_crd_shd.g_old_rec.object_version_number
      );

Line: 309


End post_update;

Line: 537


  ben_crd_bus.update_validate(p_rec);

Line: 541


  pre_update(p_rec);

Line: 545


  update_dml(p_rec);

Line: 549


  post_update(p_rec);