APPS.HR_QSA_INS SQL Statements

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

Line: 73

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

Line: 83

  insert into hr_quest_answers
  (  questionnaire_answer_id,
  questionnaire_template_id,
  type,
  type_object_id,
  business_group_id
  )
  Values
  (  p_rec.questionnaire_answer_id,
  p_rec.questionnaire_template_id,
  p_rec.type,
  p_rec.type_object_id,
  p_rec.business_group_id
  );

Line: 114

End insert_dml;

Line: 153

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

Line: 158

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

Line: 161

         select null
                from hr_quest_answers
                where questionnaire_answer_id = hr_qsa_ins.g_questionnaire_answer_id_i;

Line: 200

End pre_insert;

Line: 234

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

Line: 244

  hr_qsa_rki.after_insert
    (p_questionnaire_answer_id   => p_rec.questionnaire_answer_id
    ,p_questionnaire_template_id => p_rec.questionnaire_template_id
    ,p_type           => p_rec.type
    ,p_type_object_id       => p_rec.type_object_id
    ,p_business_group_id       => p_rec.business_group_id
    ,p_effective_date        => p_effective_date
    );

Line: 261

End post_insert;

Line: 279

  hr_qsa_bus.insert_validate(p_rec, p_effective_date);

Line: 283

  pre_insert(p_rec);

Line: 287

  insert_dml(p_rec);

Line: 291

  post_insert(p_rec, p_effective_date);