APPS.HR_FMP_INS SQL Statements

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

Line: 53

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

Line: 67

  insert into hr_form_properties
      (form_property_id
      ,object_version_number
      ,application_id
      ,form_id
      ,form_template_id
      ,help_target
      ,information_category
      ,information1
      ,information2
      ,information3
      ,information4
      ,information5
      ,information6
      ,information7
      ,information8
      ,information9
      ,information10
      ,information11
      ,information12
      ,information13
      ,information14
      ,information15
      ,information16
      ,information17
      ,information18
      ,information19
      ,information20
      ,information21
      ,information22
      ,information23
      ,information24
      ,information25
      ,information26
      ,information27
      ,information28
      ,information29
      ,information30
      )
  Values
    (p_rec.form_property_id
    ,p_rec.object_version_number
    ,p_rec.application_id
    ,p_rec.form_id
    ,p_rec.form_template_id
    ,p_rec.help_target
    ,p_rec.information_category
    ,p_rec.information1
    ,p_rec.information2
    ,p_rec.information3
    ,p_rec.information4
    ,p_rec.information5
    ,p_rec.information6
    ,p_rec.information7
    ,p_rec.information8
    ,p_rec.information9
    ,p_rec.information10
    ,p_rec.information11
    ,p_rec.information12
    ,p_rec.information13
    ,p_rec.information14
    ,p_rec.information15
    ,p_rec.information16
    ,p_rec.information17
    ,p_rec.information18
    ,p_rec.information19
    ,p_rec.information20
    ,p_rec.information21
    ,p_rec.information22
    ,p_rec.information23
    ,p_rec.information24
    ,p_rec.information25
    ,p_rec.information26
    ,p_rec.information27
    ,p_rec.information28
    ,p_rec.information29
    ,p_rec.information30
    );

Line: 168

End insert_dml;

Line: 207

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

Line: 213

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

Line: 226

End pre_insert;

Line: 260

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

Line: 270

    hr_fmp_rki.after_insert
      (p_form_property_id
      => p_rec.form_property_id
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_application_id
      => p_rec.application_id
      ,p_form_id
      => p_rec.form_id
      ,p_form_template_id
      => p_rec.form_template_id
      ,p_help_target
      => p_rec.help_target
      ,p_information_category
      => p_rec.information_category
      ,p_information1
      => p_rec.information1
      ,p_information2
      => p_rec.information2
      ,p_information3
      => p_rec.information3
      ,p_information4
      => p_rec.information4
      ,p_information5
      => p_rec.information5
      ,p_information6
      => p_rec.information6
      ,p_information7
      => p_rec.information7
      ,p_information8
      => p_rec.information8
      ,p_information9
      => p_rec.information9
      ,p_information10
      => p_rec.information10
      ,p_information11
      => p_rec.information11
      ,p_information12
      => p_rec.information12
      ,p_information13
      => p_rec.information13
      ,p_information14
      => p_rec.information14
      ,p_information15
      => p_rec.information15
      ,p_information16
      => p_rec.information16
      ,p_information17
      => p_rec.information17
      ,p_information18
      => p_rec.information18
      ,p_information19
      => p_rec.information19
      ,p_information20
      => p_rec.information20
      ,p_information21
      => p_rec.information21
      ,p_information22
      => p_rec.information22
      ,p_information23
      => p_rec.information23
      ,p_information24
      => p_rec.information24
      ,p_information25
      => p_rec.information25
      ,p_information26
      => p_rec.information26
      ,p_information27
      => p_rec.information27
      ,p_information28
      => p_rec.information28
      ,p_information29
      => p_rec.information29
      ,p_information30
      => p_rec.information30
      );

Line: 358

End post_insert;

Line: 374

  hr_fmp_bus.insert_validate
     (p_rec
     );

Line: 380

  hr_fmp_ins.pre_insert(p_rec);

Line: 384

  hr_fmp_ins.insert_dml(p_rec);

Line: 388

  hr_fmp_ins.post_insert
     (p_rec
     );