APPS.HR_QSV_DEL SQL Statements

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

Line: 51

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

Line: 60

  delete from hr_quest_answer_values
  where quest_answer_val_id = p_rec.quest_answer_val_id;

Line: 72

End delete_dml;

Line: 106

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

Line: 114

End pre_delete;

Line: 148

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

Line: 156

    hr_qsv_rkd.after_delete
      (p_quest_answer_val_id   => p_rec.quest_answer_val_id
      ,p_questionnaire_answer_id_o
   => hr_qsv_shd.g_old_rec.questionnaire_answer_id
      ,p_field_id_o
   => hr_qsv_shd.g_old_rec.field_id
      ,p_object_version_number_o
   => hr_qsv_shd.g_old_rec.object_version_number
      ,p_value_o
   => hr_qsv_shd.g_old_rec.value
      );

Line: 176

End post_delete;

Line: 201

  hr_qsv_bus.delete_validate(p_rec);

Line: 205

  pre_delete(p_rec);

Line: 209

  delete_dml(p_rec);

Line: 213

  post_delete(p_rec);