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

Line: 69


  update ben_ext_dfn
  set
  ext_dfn_id                        = p_rec.ext_dfn_id,
  name                              = p_rec.name,
  xml_tag_name                      = p_rec.xml_tag_name,
  xdo_template_id                   = p_rec.xdo_template_id,
  data_typ_cd                       = p_rec.data_typ_cd,
  ext_typ_cd                        = p_rec.ext_typ_cd,
  output_name                       = p_rec.output_name,
  output_type                       = p_rec.output_type,
  apnd_rqst_id_flag                 = p_rec.apnd_rqst_id_flag,
  prmy_sort_cd                      = p_rec.prmy_sort_cd,
  scnd_sort_cd                      = p_rec.scnd_sort_cd,
  strt_dt                           = p_rec.strt_dt,
  end_dt                            = p_rec.end_dt,
  ext_crit_prfl_id                  = p_rec.ext_crit_prfl_id,
  ext_file_id                       = p_rec.ext_file_id,
  business_group_id                 = p_rec.business_group_id,
  legislation_code                  = p_rec.legislation_code,
  xdf_attribute_category            = p_rec.xdf_attribute_category,
  xdf_attribute1                    = p_rec.xdf_attribute1,
  xdf_attribute2                    = p_rec.xdf_attribute2,
  xdf_attribute3                    = p_rec.xdf_attribute3,
  xdf_attribute4                    = p_rec.xdf_attribute4,
  xdf_attribute5                    = p_rec.xdf_attribute5,
  xdf_attribute6                    = p_rec.xdf_attribute6,
  xdf_attribute7                    = p_rec.xdf_attribute7,
  xdf_attribute8                    = p_rec.xdf_attribute8,
  xdf_attribute9                    = p_rec.xdf_attribute9,
  xdf_attribute10                   = p_rec.xdf_attribute10,
  xdf_attribute11                   = p_rec.xdf_attribute11,
  xdf_attribute12                   = p_rec.xdf_attribute12,
  xdf_attribute13                   = p_rec.xdf_attribute13,
  xdf_attribute14                   = p_rec.xdf_attribute14,
  xdf_attribute15                   = p_rec.xdf_attribute15,
  xdf_attribute16                   = p_rec.xdf_attribute16,
  xdf_attribute17                   = p_rec.xdf_attribute17,
  xdf_attribute18                   = p_rec.xdf_attribute18,
  xdf_attribute19                   = p_rec.xdf_attribute19,
  xdf_attribute20                   = p_rec.xdf_attribute20,
  xdf_attribute21                   = p_rec.xdf_attribute21,
  xdf_attribute22                   = p_rec.xdf_attribute22,
  xdf_attribute23                   = p_rec.xdf_attribute23,
  xdf_attribute24                   = p_rec.xdf_attribute24,
  xdf_attribute25                   = p_rec.xdf_attribute25,
  xdf_attribute26                   = p_rec.xdf_attribute26,
  xdf_attribute27                   = p_rec.xdf_attribute27,
  xdf_attribute28                   = p_rec.xdf_attribute28,
  xdf_attribute29                   = p_rec.xdf_attribute29,
  xdf_attribute30                   = p_rec.xdf_attribute30,
  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,
  drctry_name                       = p_rec.drctry_name,
  kickoff_wrt_prc_flag              = p_rec.kickoff_wrt_prc_flag,
  upd_cm_sent_dt_flag               = p_rec.upd_cm_sent_dt_flag,
  spcl_hndl_flag                    = p_rec.spcl_hndl_flag,
  ext_global_flag                   = p_rec.ext_global_flag,
  cm_display_flag                   = p_rec.cm_display_flag,
  use_eff_dt_for_chgs_flag          = p_rec.use_eff_dt_for_chgs_flag,
  ext_post_prcs_rl                  = p_rec.ext_post_prcs_rl
  where ext_dfn_id = p_rec.ext_dfn_id;

Line: 156


End update_dml;

Line: 190


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

Line: 198


End pre_update;

Line: 232


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

Line: 245


    ben_xdf_rku.after_update
      (
  p_ext_dfn_id                    =>p_rec.ext_dfn_id
 ,p_name                          =>p_rec.name
 ,p_xml_tag_name                  =>p_rec.xml_tag_name
 ,p_xdo_template_id               =>p_rec.xdo_template_id
 ,p_data_typ_cd                   =>p_rec.data_typ_cd
 ,p_ext_typ_cd                    =>p_rec.ext_typ_cd
 ,p_output_name                   =>p_rec.output_name
 ,p_output_type                   =>p_rec.output_type
 ,p_apnd_rqst_id_flag             =>p_rec.apnd_rqst_id_flag
 ,p_prmy_sort_cd                  =>p_rec.prmy_sort_cd
 ,p_scnd_sort_cd                  =>p_rec.scnd_sort_cd
 ,p_strt_dt                       =>p_rec.strt_dt
 ,p_end_dt                        =>p_rec.end_dt
 ,p_ext_crit_prfl_id              =>p_rec.ext_crit_prfl_id
 ,p_ext_file_id                   =>p_rec.ext_file_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_legislation_code              =>p_rec.legislation_code
 ,p_xdf_attribute_category        =>p_rec.xdf_attribute_category
 ,p_xdf_attribute1                =>p_rec.xdf_attribute1
 ,p_xdf_attribute2                =>p_rec.xdf_attribute2
 ,p_xdf_attribute3                =>p_rec.xdf_attribute3
 ,p_xdf_attribute4                =>p_rec.xdf_attribute4
 ,p_xdf_attribute5                =>p_rec.xdf_attribute5
 ,p_xdf_attribute6                =>p_rec.xdf_attribute6
 ,p_xdf_attribute7                =>p_rec.xdf_attribute7
 ,p_xdf_attribute8                =>p_rec.xdf_attribute8
 ,p_xdf_attribute9                =>p_rec.xdf_attribute9
 ,p_xdf_attribute10               =>p_rec.xdf_attribute10
 ,p_xdf_attribute11               =>p_rec.xdf_attribute11
 ,p_xdf_attribute12               =>p_rec.xdf_attribute12
 ,p_xdf_attribute13               =>p_rec.xdf_attribute13
 ,p_xdf_attribute14               =>p_rec.xdf_attribute14
 ,p_xdf_attribute15               =>p_rec.xdf_attribute15
 ,p_xdf_attribute16               =>p_rec.xdf_attribute16
 ,p_xdf_attribute17               =>p_rec.xdf_attribute17
 ,p_xdf_attribute18               =>p_rec.xdf_attribute18
 ,p_xdf_attribute19               =>p_rec.xdf_attribute19
 ,p_xdf_attribute20               =>p_rec.xdf_attribute20
 ,p_xdf_attribute21               =>p_rec.xdf_attribute21
 ,p_xdf_attribute22               =>p_rec.xdf_attribute22
 ,p_xdf_attribute23               =>p_rec.xdf_attribute23
 ,p_xdf_attribute24               =>p_rec.xdf_attribute24
 ,p_xdf_attribute25               =>p_rec.xdf_attribute25
 ,p_xdf_attribute26               =>p_rec.xdf_attribute26
 ,p_xdf_attribute27               =>p_rec.xdf_attribute27
 ,p_xdf_attribute28               =>p_rec.xdf_attribute28
 ,p_xdf_attribute29               =>p_rec.xdf_attribute29
 ,p_xdf_attribute30               =>p_rec.xdf_attribute30
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_drctry_name                   =>p_rec.drctry_name
 ,p_kickoff_wrt_prc_flag          =>p_rec.kickoff_wrt_prc_flag
 ,p_upd_cm_sent_dt_flag           =>p_rec.upd_cm_sent_dt_flag
 ,p_spcl_hndl_flag                =>p_rec.spcl_hndl_flag
 ,p_ext_global_flag               =>p_rec.ext_global_flag
 ,p_cm_display_flag               =>p_rec.cm_display_flag
 ,p_use_eff_dt_for_chgs_flag      =>p_rec.use_eff_dt_for_chgs_flag
 ,p_ext_post_prcs_rl              =>p_rec.ext_post_prcs_rl
 ,p_effective_date                =>p_effective_date
 ,p_name_o                        =>ben_xdf_shd.g_old_rec.name
 ,p_xml_tag_name_o                =>ben_xdf_shd.g_old_rec.xml_tag_name
 ,p_xdo_template_id_o             =>ben_xdf_shd.g_old_rec.xdo_template_id
 ,p_data_typ_cd_o                 =>ben_xdf_shd.g_old_rec.data_typ_cd
 ,p_ext_typ_cd_o                  =>ben_xdf_shd.g_old_rec.ext_typ_cd
 ,p_output_name_o                 =>ben_xdf_shd.g_old_rec.output_name
 ,p_output_type_o                 =>ben_xdf_shd.g_old_rec.output_type
 ,p_apnd_rqst_id_flag_o           =>ben_xdf_shd.g_old_rec.apnd_rqst_id_flag
 ,p_prmy_sort_cd_o                =>ben_xdf_shd.g_old_rec.prmy_sort_cd
 ,p_scnd_sort_cd_o                =>ben_xdf_shd.g_old_rec.scnd_sort_cd
 ,p_strt_dt_o                     =>ben_xdf_shd.g_old_rec.strt_dt
 ,p_end_dt_o                      =>ben_xdf_shd.g_old_rec.end_dt
 ,p_ext_crit_prfl_id_o            =>ben_xdf_shd.g_old_rec.ext_crit_prfl_id
 ,p_ext_file_id_o                 =>ben_xdf_shd.g_old_rec.ext_file_id
 ,p_business_group_id_o           =>ben_xdf_shd.g_old_rec.business_group_id
 ,p_legislation_code_o            =>ben_xdf_shd.g_old_rec.legislation_code
 ,p_xdf_attribute_category_o      =>ben_xdf_shd.g_old_rec.xdf_attribute_category
 ,p_xdf_attribute1_o              =>ben_xdf_shd.g_old_rec.xdf_attribute1
 ,p_xdf_attribute2_o              =>ben_xdf_shd.g_old_rec.xdf_attribute2
 ,p_xdf_attribute3_o              =>ben_xdf_shd.g_old_rec.xdf_attribute3
 ,p_xdf_attribute4_o              =>ben_xdf_shd.g_old_rec.xdf_attribute4
 ,p_xdf_attribute5_o              =>ben_xdf_shd.g_old_rec.xdf_attribute5
 ,p_xdf_attribute6_o              =>ben_xdf_shd.g_old_rec.xdf_attribute6
 ,p_xdf_attribute7_o              =>ben_xdf_shd.g_old_rec.xdf_attribute7
 ,p_xdf_attribute8_o              =>ben_xdf_shd.g_old_rec.xdf_attribute8
 ,p_xdf_attribute9_o              =>ben_xdf_shd.g_old_rec.xdf_attribute9
 ,p_xdf_attribute10_o             =>ben_xdf_shd.g_old_rec.xdf_attribute10
 ,p_xdf_attribute11_o             =>ben_xdf_shd.g_old_rec.xdf_attribute11
 ,p_xdf_attribute12_o             =>ben_xdf_shd.g_old_rec.xdf_attribute12
 ,p_xdf_attribute13_o             =>ben_xdf_shd.g_old_rec.xdf_attribute13
 ,p_xdf_attribute14_o             =>ben_xdf_shd.g_old_rec.xdf_attribute14
 ,p_xdf_attribute15_o             =>ben_xdf_shd.g_old_rec.xdf_attribute15
 ,p_xdf_attribute16_o             =>ben_xdf_shd.g_old_rec.xdf_attribute16
 ,p_xdf_attribute17_o             =>ben_xdf_shd.g_old_rec.xdf_attribute17
 ,p_xdf_attribute18_o             =>ben_xdf_shd.g_old_rec.xdf_attribute18
 ,p_xdf_attribute19_o             =>ben_xdf_shd.g_old_rec.xdf_attribute19
 ,p_xdf_attribute20_o             =>ben_xdf_shd.g_old_rec.xdf_attribute20
 ,p_xdf_attribute21_o             =>ben_xdf_shd.g_old_rec.xdf_attribute21
 ,p_xdf_attribute22_o             =>ben_xdf_shd.g_old_rec.xdf_attribute22
 ,p_xdf_attribute23_o             =>ben_xdf_shd.g_old_rec.xdf_attribute23
 ,p_xdf_attribute24_o             =>ben_xdf_shd.g_old_rec.xdf_attribute24
 ,p_xdf_attribute25_o             =>ben_xdf_shd.g_old_rec.xdf_attribute25
 ,p_xdf_attribute26_o             =>ben_xdf_shd.g_old_rec.xdf_attribute26
 ,p_xdf_attribute27_o             =>ben_xdf_shd.g_old_rec.xdf_attribute27
 ,p_xdf_attribute28_o             =>ben_xdf_shd.g_old_rec.xdf_attribute28
 ,p_xdf_attribute29_o             =>ben_xdf_shd.g_old_rec.xdf_attribute29
 ,p_xdf_attribute30_o             =>ben_xdf_shd.g_old_rec.xdf_attribute30
 ,p_object_version_number_o       =>ben_xdf_shd.g_old_rec.object_version_number
 ,p_drctry_name_o                 =>ben_xdf_shd.g_old_rec.drctry_name
 ,p_kickoff_wrt_prc_flag_o        =>ben_xdf_shd.g_old_rec.kickoff_wrt_prc_flag
 ,p_upd_cm_sent_dt_flag_o         =>ben_xdf_shd.g_old_rec.upd_cm_sent_dt_flag
 ,p_spcl_hndl_flag_o              =>ben_xdf_shd.g_old_rec.spcl_hndl_flag
 ,p_ext_global_flag_o             =>ben_xdf_shd.g_old_rec.ext_global_flag
 ,p_cm_display_flag_o             =>ben_xdf_shd.g_old_rec.cm_display_flag
 ,p_use_eff_dt_for_chgs_flag_o    =>ben_xdf_shd.g_old_rec.use_eff_dt_for_chgs_flag
 ,p_ext_post_prcs_rl_o            =>ben_xdf_shd.g_old_rec.ext_post_prcs_rl
      );

Line: 377


End post_update;

Line: 691


  ben_xdf_bus.update_validate(p_rec
  ,p_effective_date);

Line: 700


  pre_update(p_rec);

Line: 704


  update_dml(p_rec);

Line: 708


  post_update(
p_effective_date,p_rec);

Line: 766


  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,
  p_drctry_name                  in varchar2         default hr_api.g_varchar2,
  p_kickoff_wrt_prc_flag         in varchar2         default hr_api.g_varchar2,
  p_upd_cm_sent_dt_flag          in varchar2         default hr_api.g_varchar2,
  p_spcl_hndl_flag               in varchar2         default hr_api.g_varchar2,
  p_ext_global_flag              in varchar2         default hr_api.g_varchar2,
  p_cm_display_flag              in varchar2         default hr_api.g_varchar2,
  p_use_eff_dt_for_chgs_flag     in varchar2         default hr_api.g_varchar2,
  p_ext_post_prcs_rl             in number           default hr_api.g_number
  ) is
--
  l_rec	  ben_xdf_shd.g_rec_type;

Line: 842


  p_last_update_date ,
  p_creation_date    ,
  p_last_updated_by  ,
  p_last_update_login,
  p_created_by       ,
  p_object_version_number,
  p_drctry_name,
  p_kickoff_wrt_prc_flag,
  p_upd_cm_sent_dt_flag,
  p_spcl_hndl_flag,
  p_ext_global_flag,
  p_cm_display_flag,
  p_use_eff_dt_for_chgs_flag,
  p_ext_post_prcs_rl
  );