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

Line: 69


  update ben_ext_data_elmt
  set
  ext_data_elmt_id                  = p_rec.ext_data_elmt_id,
  name                              = p_rec.name,
  xml_tag_name                      = p_rec.xml_tag_name ,
  data_elmt_typ_cd                  = p_rec.data_elmt_typ_cd,
  data_elmt_rl                      = p_rec.data_elmt_rl,
  frmt_mask_cd                      = p_rec.frmt_mask_cd,
  string_val                        = p_rec.string_val,
  dflt_val                          = p_rec.dflt_val,
  max_length_num                    = p_rec.max_length_num,
  just_cd                          = p_rec.just_cd,
	ttl_fnctn_cd		   =p_rec.ttl_fnctn_cd,
	ttl_cond_oper_cd	=p_rec.ttl_cond_oper_cd,
	ttl_cond_val		=p_rec.ttl_cond_val,
	ttl_sum_ext_data_elmt_id		=p_rec.ttl_sum_ext_data_elmt_id,
	ttl_cond_ext_data_elmt_id		=p_rec.ttl_cond_ext_data_elmt_id ,
  ext_fld_id                        = p_rec.ext_fld_id,
  business_group_id                 = p_rec.business_group_id,
  legislation_code                  = p_rec.legislation_code,
  xel_attribute_category            = p_rec.xel_attribute_category,
  xel_attribute1                    = p_rec.xel_attribute1,
  xel_attribute2                    = p_rec.xel_attribute2,
  xel_attribute3                    = p_rec.xel_attribute3,
  xel_attribute4                    = p_rec.xel_attribute4,
  xel_attribute5                    = p_rec.xel_attribute5,
  xel_attribute6                    = p_rec.xel_attribute6,
  xel_attribute7                    = p_rec.xel_attribute7,
  xel_attribute8                    = p_rec.xel_attribute8,
  xel_attribute9                    = p_rec.xel_attribute9,
  xel_attribute10                   = p_rec.xel_attribute10,
  xel_attribute11                   = p_rec.xel_attribute11,
  xel_attribute12                   = p_rec.xel_attribute12,
  xel_attribute13                   = p_rec.xel_attribute13,
  xel_attribute14                   = p_rec.xel_attribute14,
  xel_attribute15                   = p_rec.xel_attribute15,
  xel_attribute16                   = p_rec.xel_attribute16,
  xel_attribute17                   = p_rec.xel_attribute17,
  xel_attribute18                   = p_rec.xel_attribute18,
  xel_attribute19                   = p_rec.xel_attribute19,
  xel_attribute20                   = p_rec.xel_attribute20,
  xel_attribute21                   = p_rec.xel_attribute21,
  xel_attribute22                   = p_rec.xel_attribute22,
  xel_attribute23                   = p_rec.xel_attribute23,
  xel_attribute24                   = p_rec.xel_attribute24,
  xel_attribute25                   = p_rec.xel_attribute25,
  xel_attribute26                   = p_rec.xel_attribute26,
  xel_attribute27                   = p_rec.xel_attribute27,
  xel_attribute28                   = p_rec.xel_attribute28,
  xel_attribute29                   = p_rec.xel_attribute29,
  xel_attribute30                   = p_rec.xel_attribute30,
  defined_balance_id                = p_rec.defined_balance_id,
  last_update_date                  = p_rec.last_update_date,
  last_updated_by                   = p_rec.last_updated_by,
  last_update_login                 = p_rec.last_update_login,
  object_version_number             = p_rec.object_version_number
  where ext_data_elmt_id = p_rec.ext_data_elmt_id;

Line: 150


End update_dml;

Line: 184


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

Line: 192


End pre_update;

Line: 226


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

Line: 239


    ben_xel_rku.after_update
      (
  p_ext_data_elmt_id              =>p_rec.ext_data_elmt_id
 ,p_name                          =>p_rec.name
 ,p_xml_tag_name                  =>p_rec.xml_tag_name
 ,p_data_elmt_typ_cd              =>p_rec.data_elmt_typ_cd
 ,p_data_elmt_rl                  =>p_rec.data_elmt_rl
 ,p_frmt_mask_cd                  =>p_rec.frmt_mask_cd
 ,p_string_val                    =>p_rec.string_val
 ,p_dflt_val                      =>p_rec.dflt_val
 ,p_max_length_num                =>p_rec.max_length_num
 ,p_just_cd                      =>p_rec.just_cd
	,p_ttl_fnctn_cd		   =>p_rec.ttl_fnctn_cd,
	p_ttl_cond_oper_cd	=>p_rec.ttl_cond_oper_cd,
	p_ttl_cond_val		=>p_rec.ttl_cond_val,
	p_ttl_sum_ext_data_elmt_id		=>p_rec.ttl_sum_ext_data_elmt_id,
	p_ttl_cond_ext_data_elmt_id		=>p_rec.ttl_cond_ext_data_elmt_id ,
 p_ext_fld_id                    =>p_rec.ext_fld_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_legislation_code              =>p_rec.legislation_code
 ,p_xel_attribute_category        =>p_rec.xel_attribute_category
 ,p_xel_attribute1                =>p_rec.xel_attribute1
 ,p_xel_attribute2                =>p_rec.xel_attribute2
 ,p_xel_attribute3                =>p_rec.xel_attribute3
 ,p_xel_attribute4                =>p_rec.xel_attribute4
 ,p_xel_attribute5                =>p_rec.xel_attribute5
 ,p_xel_attribute6                =>p_rec.xel_attribute6
 ,p_xel_attribute7                =>p_rec.xel_attribute7
 ,p_xel_attribute8                =>p_rec.xel_attribute8
 ,p_xel_attribute9                =>p_rec.xel_attribute9
 ,p_xel_attribute10               =>p_rec.xel_attribute10
 ,p_xel_attribute11               =>p_rec.xel_attribute11
 ,p_xel_attribute12               =>p_rec.xel_attribute12
 ,p_xel_attribute13               =>p_rec.xel_attribute13
 ,p_xel_attribute14               =>p_rec.xel_attribute14
 ,p_xel_attribute15               =>p_rec.xel_attribute15
 ,p_xel_attribute16               =>p_rec.xel_attribute16
 ,p_xel_attribute17               =>p_rec.xel_attribute17
 ,p_xel_attribute18               =>p_rec.xel_attribute18
 ,p_xel_attribute19               =>p_rec.xel_attribute19
 ,p_xel_attribute20               =>p_rec.xel_attribute20
 ,p_xel_attribute21               =>p_rec.xel_attribute21
 ,p_xel_attribute22               =>p_rec.xel_attribute22
 ,p_xel_attribute23               =>p_rec.xel_attribute23
 ,p_xel_attribute24               =>p_rec.xel_attribute24
 ,p_xel_attribute25               =>p_rec.xel_attribute25
 ,p_xel_attribute26               =>p_rec.xel_attribute26
 ,p_xel_attribute27               =>p_rec.xel_attribute27
 ,p_xel_attribute28               =>p_rec.xel_attribute28
 ,p_xel_attribute29               =>p_rec.xel_attribute29
 ,p_xel_attribute30               =>p_rec.xel_attribute30
 ,p_defined_balance_id            =>p_rec.defined_balance_id
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_name_o                        =>ben_xel_shd.g_old_rec.name
 ,p_xml_tag_name_o                =>ben_xel_shd.g_old_rec.xml_tag_name
 ,p_data_elmt_typ_cd_o            =>ben_xel_shd.g_old_rec.data_elmt_typ_cd
 ,p_data_elmt_rl_o                =>ben_xel_shd.g_old_rec.data_elmt_rl
 ,p_frmt_mask_cd_o                =>ben_xel_shd.g_old_rec.frmt_mask_cd
 ,p_string_val_o                  =>ben_xel_shd.g_old_rec.string_val
 ,p_dflt_val_o                    =>ben_xel_shd.g_old_rec.dflt_val
 ,p_max_length_num_o              =>ben_xel_shd.g_old_rec.max_length_num
 ,p_just_cd_o                    =>ben_xel_shd.g_old_rec.just_cd
	,p_ttl_fnctn_cd_o		   =>ben_xel_shd.g_old_rec.ttl_fnctn_cd,
	p_ttl_cond_oper_cd_o	=>ben_xel_shd.g_old_rec.ttl_cond_oper_cd,
	p_ttl_cond_val_o		=>ben_xel_shd.g_old_rec.ttl_cond_val,
	p_ttl_sum_ext_data_elmt_id_o		=>ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,
       p_ttl_cond_ext_data_elmt_id_o		=>ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id ,
 p_ext_fld_id_o                  =>ben_xel_shd.g_old_rec.ext_fld_id
 ,p_business_group_id_o           => ben_xel_shd.g_old_rec.business_group_id
 ,p_legislation_code_o            => ben_xel_shd.g_old_rec.legislation_code
 ,p_xel_attribute_category_o      =>ben_xel_shd.g_old_rec.xel_attribute_category
 ,p_xel_attribute1_o              =>ben_xel_shd.g_old_rec.xel_attribute1
 ,p_xel_attribute2_o              =>ben_xel_shd.g_old_rec.xel_attribute2
 ,p_xel_attribute3_o              =>ben_xel_shd.g_old_rec.xel_attribute3
 ,p_xel_attribute4_o              =>ben_xel_shd.g_old_rec.xel_attribute4
 ,p_xel_attribute5_o              =>ben_xel_shd.g_old_rec.xel_attribute5
 ,p_xel_attribute6_o              =>ben_xel_shd.g_old_rec.xel_attribute6
 ,p_xel_attribute7_o              =>ben_xel_shd.g_old_rec.xel_attribute7
 ,p_xel_attribute8_o              =>ben_xel_shd.g_old_rec.xel_attribute8
 ,p_xel_attribute9_o              =>ben_xel_shd.g_old_rec.xel_attribute9
 ,p_xel_attribute10_o             =>ben_xel_shd.g_old_rec.xel_attribute10
 ,p_xel_attribute11_o             =>ben_xel_shd.g_old_rec.xel_attribute11
 ,p_xel_attribute12_o             =>ben_xel_shd.g_old_rec.xel_attribute12
 ,p_xel_attribute13_o             =>ben_xel_shd.g_old_rec.xel_attribute13
 ,p_xel_attribute14_o             =>ben_xel_shd.g_old_rec.xel_attribute14
 ,p_xel_attribute15_o             =>ben_xel_shd.g_old_rec.xel_attribute15
 ,p_xel_attribute16_o             =>ben_xel_shd.g_old_rec.xel_attribute16
 ,p_xel_attribute17_o             =>ben_xel_shd.g_old_rec.xel_attribute17
 ,p_xel_attribute18_o             =>ben_xel_shd.g_old_rec.xel_attribute18
 ,p_xel_attribute19_o             =>ben_xel_shd.g_old_rec.xel_attribute19
 ,p_xel_attribute20_o             =>ben_xel_shd.g_old_rec.xel_attribute20
 ,p_xel_attribute21_o             =>ben_xel_shd.g_old_rec.xel_attribute21
 ,p_xel_attribute22_o             =>ben_xel_shd.g_old_rec.xel_attribute22
 ,p_xel_attribute23_o             =>ben_xel_shd.g_old_rec.xel_attribute23
 ,p_xel_attribute24_o             =>ben_xel_shd.g_old_rec.xel_attribute24
 ,p_xel_attribute25_o             =>ben_xel_shd.g_old_rec.xel_attribute25
 ,p_xel_attribute26_o             =>ben_xel_shd.g_old_rec.xel_attribute26
 ,p_xel_attribute27_o             =>ben_xel_shd.g_old_rec.xel_attribute27
 ,p_xel_attribute28_o             =>ben_xel_shd.g_old_rec.xel_attribute28
 ,p_xel_attribute29_o             =>ben_xel_shd.g_old_rec.xel_attribute29
 ,p_xel_attribute30_o             =>ben_xel_shd.g_old_rec.xel_attribute30
 ,p_defined_balance_id_o          =>ben_xel_shd.g_old_rec.defined_balance_id
 ,p_object_version_number_o       =>ben_xel_shd.g_old_rec.object_version_number
      );

Line: 359


End post_update;

Line: 650


  ben_xel_bus.update_validate(p_rec
  ,p_effective_date);

Line: 659


  pre_update(p_rec);

Line: 663


  update_dml(p_rec);

Line: 667


  post_update(
p_effective_date,p_rec);

Line: 727


  p_last_update_date             in date             default hr_api.g_date,
  p_creation_date                in date             default hr_api.g_date,
  p_last_updated_by              in number           default hr_api.g_number,
  p_last_update_login            in number           default hr_api.g_number,
  p_created_by                   in number           default hr_api.g_number,
  p_object_version_number        in out nocopy number
  ) is
--
  l_rec	  ben_xel_shd.g_rec_type;

Line: 797


  p_last_update_date ,
  p_creation_date    ,
  p_last_updated_by  ,
  p_last_update_login,
  p_created_by       ,
  p_object_version_number
  );