DBA Data[Home] [Help]

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

  update hr_quest_answers
  set
  questionnaire_answer_id           = p_rec.questionnaire_answer_id,
  questionnaire_template_id         = p_rec.questionnaire_template_id,
  type                              = p_rec.type,
  type_object_id                    = p_rec.type_object_id,
  business_group_id                 = p_rec.business_group_id
  where questionnaire_answer_id = p_rec.questionnaire_answer_id;
Line: 92

End update_dml;
Line: 126

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

End pre_update;
Line: 168

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

End post_update;
Line: 284

  hr_qsa_bus.update_validate(p_rec, p_effective_date);
Line: 288

  pre_update(p_rec);
Line: 292

  update_dml(p_rec);
Line: 296

  post_update(p_rec);