DBA Data[Home] [Help]

APPS.BEN_XCT_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_xct_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';
Line: 69

  update ben_ext_crit_typ
  set
  ext_crit_typ_id                   = p_rec.ext_crit_typ_id,
  crit_typ_cd                       = p_rec.crit_typ_cd,
  ext_crit_prfl_id                  = p_rec.ext_crit_prfl_id,
  business_group_id                 = p_rec.business_group_id,
  legislation_code                  = p_rec.legislation_code,
  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,
  excld_flag                        = p_rec.excld_flag
  where ext_crit_typ_id = p_rec.ext_crit_typ_id;
Line: 106

End update_dml;
Line: 140

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

End pre_update;
Line: 182

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

    ben_xct_rku.after_update
      (
  p_ext_crit_typ_id               =>p_rec.ext_crit_typ_id
 ,p_crit_typ_cd                   =>p_rec.crit_typ_cd
 ,p_ext_crit_prfl_id              =>p_rec.ext_crit_prfl_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_legislation_code              =>p_rec.legislation_code
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_excld_flag                    =>p_rec.excld_flag
 ,p_crit_typ_cd_o                 =>ben_xct_shd.g_old_rec.crit_typ_cd
 ,p_ext_crit_prfl_id_o            =>ben_xct_shd.g_old_rec.ext_crit_prfl_id
 ,p_business_group_id_o           =>ben_xct_shd.g_old_rec.business_group_id
 ,p_legislation_code_o            =>ben_xct_shd.g_old_rec.legislation_code
 ,p_object_version_number_o       =>ben_xct_shd.g_old_rec.object_version_number
 ,p_excld_flag_o                  =>ben_xct_shd.g_old_rec.excld_flag
      );
Line: 227

End post_update;
Line: 340

  ben_xct_bus.update_validate(p_rec
  ,p_effective_date);
Line: 345

  pre_update(p_rec);
Line: 349

  update_dml(p_rec);
Line: 353

  post_update(
p_effective_date,p_rec);
Line: 368

  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_excld_flag                   in varchar2         default hr_api.g_varchar2
  ) is
--
  l_rec	  ben_xct_shd.g_rec_type;
Line: 394

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