APPS.HR_TPP_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_tpp_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 67

  insert into hr_tab_page_properties_b
      (tab_page_property_id
      ,object_version_number
      ,form_tab_page_id
      ,template_tab_page_id
      ,navigation_direction
      ,visible
      ,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.tab_page_property_id
    ,p_rec.object_version_number
    ,p_rec.form_tab_page_id
    ,p_rec.template_tab_page_id
    ,p_rec.navigation_direction
    ,p_rec.visible
    ,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_tpp_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 213

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

Line: 226

End pre_insert;

Line: 260

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

Line: 271

    hr_tpp_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_tab_page_property_id
      => p_rec.tab_page_property_id
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_form_tab_page_id
      => p_rec.form_tab_page_id
      ,p_template_tab_page_id
      => p_rec.template_tab_page_id
      ,p_navigation_direction
      => p_rec.navigation_direction
      ,p_visible
      => p_rec.visible
      ,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: 360

End post_insert;

Line: 377

  hr_tpp_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 384

  hr_tpp_ins.pre_insert(p_rec);

Line: 388

  hr_tpp_ins.insert_dml(p_rec);

Line: 392

  hr_tpp_ins.post_insert
     (p_effective_date
     ,p_rec
     );