APPS.HR_AHC_UPD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 54

Procedure update_dml(p_rec in out nocopy hr_ahc_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 69

  update hr_api_hook_calls
  set
  api_hook_call_id                  = p_rec.api_hook_call_id,
  api_hook_id                       = p_rec.api_hook_id,
  api_hook_call_type                = p_rec.api_hook_call_type,
  legislation_code                  = p_rec.legislation_code,
  sequence                          = p_rec.sequence,
  enabled_flag                      = p_rec.enabled_flag,
  call_package                      = p_rec.call_package,
  call_procedure                    = p_rec.call_procedure,
  pre_processor_date                = p_rec.pre_processor_date,
  encoded_error                     = p_rec.encoded_error,
  status                            = p_rec.status,
  object_version_number             = p_rec.object_version_number,
  application_id                    = p_rec.application_id,
  app_install_status                = p_rec.app_install_status
  where api_hook_call_id = p_rec.api_hook_call_id;

Line: 110

End update_dml;

Line: 144

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

Line: 152

End pre_update;

Line: 186

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

Line: 194

End post_update;

Line: 335

  hr_ahc_bus.update_validate(p_rec, p_effective_date);

Line: 339

  pre_update(p_rec);

Line: 343

  update_dml(p_rec);

Line: 347

  post_update(p_rec);