APPS.HR_QSF_INS SQL Statements

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

Line: 74

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

Line: 85

  insert into hr_quest_fields
  (  field_id,
  questionnaire_template_id,
  name,
  type,
  html_text,
  sql_required_flag,
  sql_text,
  object_version_number
  ,validation_type
  ,validation_detail
  ,display_sequence
  )
  Values
  (  p_rec.field_id,
  p_rec.questionnaire_template_id,
  p_rec.name,
  p_rec.type,
  p_rec.html_text,
  p_rec.sql_required_flag,
  p_rec.sql_text,
  p_rec.object_version_number
  ,p_rec.validation_type
  ,p_rec.validation_detail
  ,p_rec.display_sequence
  );

Line: 129

End insert_dml;

Line: 168

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

Line: 173

  Cursor C_Sel1 is select hr_quest_fields_s.nextval from sys.dual;

Line: 176

         select null
                from hr_quest_fields
                where field_id = hr_qsf_ins.g_field_id_i;

Line: 215

End pre_insert;

Line: 249

Procedure post_insert(p_rec in hr_qsf_shd.g_rec_type
         ,p_effective_date in date
         ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 259

    hr_qsf_rki.after_insert
       (p_field_id      => p_rec.field_id
       ,p_questionnaire_template_id  => p_rec.questionnaire_template_id
       ,p_name        => p_rec.name
       ,p_type        => p_rec.type
       ,p_html_text      => p_rec.html_text
       ,p_sql_required_flag    => p_rec.sql_required_flag
       ,p_sql_text      => p_rec.sql_text
       ,p_object_version_number    => p_rec.object_version_number
       ,p_effective_date    => p_effective_date
       ,p_validation_type    =>  p_rec.validation_type
       ,p_validation_detail  =>  p_rec.validation_detail
       ,p_display_sequence   =>  p_rec.display_sequence
       );

Line: 282

End post_insert;

Line: 300

  hr_qsf_bus.insert_validate(p_rec, p_effective_date);

Line: 305

  pre_insert(p_rec);

Line: 309

  insert_dml(p_rec);

Line: 313

  post_insert(p_rec, p_effective_date);