APPS.GHR_PRE_UPD SQL Statements

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

Line: 48

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

Line: 61

  update ghr_pa_remarks
  set
  pa_remark_id                     = p_rec.pa_remark_id,
  description                      = p_rec.description,
  remark_code_information1         = p_rec.remark_code_information1,
  remark_code_information2         = p_rec.remark_code_information2,
  remark_code_information3         = p_rec.remark_code_information3,
  remark_code_information4         = p_rec.remark_code_information4,
  remark_code_information5         = p_rec.remark_code_information5,
  object_version_number            = p_rec.object_version_number
  where pa_remark_id = p_rec.pa_remark_id;

Line: 91

End update_dml;

Line: 125

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

Line: 133

End pre_update;

Line: 167

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

Line: 177

     ghr_pre_rku.after_update	(
      p_pa_remark_id               =>  p_rec.pa_remark_id,
      p_pa_request_id              =>  p_rec.pa_request_id,
      p_remark_id                  =>  p_rec.remark_id,
      p_description                =>  p_rec.description,
      p_remark_code_information1   =>  p_rec.remark_code_information1,
      p_remark_code_information2   =>  p_rec.remark_code_information2,
      p_remark_code_information3   =>  p_rec.remark_code_information3,
      p_remark_code_information4   =>  p_rec.remark_code_information4,
      p_remark_code_information5   =>  p_rec.remark_code_information5,
      p_object_version_number      =>  p_rec.object_version_number   ,
      p_pa_request_id_o            =>  ghr_pre_shd.g_old_rec.pa_request_id,
      p_remark_id_o                =>  ghr_pre_shd.g_old_rec.remark_id,
      p_description_o              =>  ghr_pre_shd.g_old_rec.description,
      p_remark_code_information1_o =>
                                ghr_pre_shd.g_old_rec.remark_code_information1,
      p_remark_code_information2_o =>
                                ghr_pre_shd.g_old_rec.remark_code_information2,
      p_remark_code_information3_o =>
                                ghr_pre_shd.g_old_rec.remark_code_information3,
      p_remark_code_information4_o =>
                                ghr_pre_shd.g_old_rec.remark_code_information4,
      p_remark_code_information5_o =>
                                ghr_pre_shd.g_old_rec.remark_code_information5,
      p_object_version_number_o    =>
                                ghr_pre_shd.g_old_rec.object_version_number
      );

Line: 214

End post_update;

Line: 329

  ghr_pre_bus.update_validate(p_rec);

Line: 333

  pre_update(p_rec);

Line: 337

  update_dml(p_rec);

Line: 341

  post_update(p_rec);