eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TPP_UPD SQL Statements

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

Line: 54


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

Line: 68


  update hr_tab_page_properties_b
    set
     tab_page_property_id            = p_rec.tab_page_property_id
    ,object_version_number           = p_rec.object_version_number
    ,form_tab_page_id                = p_rec.form_tab_page_id
    ,template_tab_page_id            = p_rec.template_tab_page_id
    ,navigation_direction            = p_rec.navigation_direction
    ,visible                         = p_rec.visible
    ,information_category            = p_rec.information_category
    ,information1                    = p_rec.information1
    ,information2                    = p_rec.information2
    ,information3                    = p_rec.information3
    ,information4                    = p_rec.information4
    ,information5                    = p_rec.information5
    ,information6                    = p_rec.information6
    ,information7                    = p_rec.information7
    ,information8                    = p_rec.information8
    ,information9                    = p_rec.information9
    ,information10                   = p_rec.information10
    ,information11                   = p_rec.information11
    ,information12                   = p_rec.information12
    ,information13                   = p_rec.information13
    ,information14                   = p_rec.information14
    ,information15                   = p_rec.information15
    ,information16                   = p_rec.information16
    ,information17                   = p_rec.information17
    ,information18                   = p_rec.information18
    ,information19                   = p_rec.information19
    ,information20                   = p_rec.information20
    ,information21                   = p_rec.information21
    ,information22                   = p_rec.information22
    ,information23                   = p_rec.information23
    ,information24                   = p_rec.information24
    ,information25                   = p_rec.information25
    ,information26                   = p_rec.information26
    ,information27                   = p_rec.information27
    ,information28                   = p_rec.information28
    ,information29                   = p_rec.information29
    ,information30                   = p_rec.information30
    where tab_page_property_id = p_rec.tab_page_property_id;

Line: 132


End update_dml;

Line: 166


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

Line: 176


End pre_update;

Line: 210


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

Line: 221


    hr_tpp_rku.after_update
      (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
      ,p_form_tab_page_id_o
      => hr_tpp_shd.g_old_rec.form_tab_page_id
      ,p_template_tab_page_id_o
      => hr_tpp_shd.g_old_rec.template_tab_page_id
      ,p_object_version_number_o
      => hr_tpp_shd.g_old_rec.object_version_number
      ,p_navigation_direction_o
      => hr_tpp_shd.g_old_rec.navigation_direction
      ,p_visible_o
      => hr_tpp_shd.g_old_rec.visible
      ,p_information_category_o
      => hr_tpp_shd.g_old_rec.information_category
      ,p_information1_o
      => hr_tpp_shd.g_old_rec.information1
      ,p_information2_o
      => hr_tpp_shd.g_old_rec.information2
      ,p_information3_o
      => hr_tpp_shd.g_old_rec.information3
      ,p_information4_o
      => hr_tpp_shd.g_old_rec.information4
      ,p_information5_o
      => hr_tpp_shd.g_old_rec.information5
      ,p_information6_o
      => hr_tpp_shd.g_old_rec.information6
      ,p_information7_o
      => hr_tpp_shd.g_old_rec.information7
      ,p_information8_o
      => hr_tpp_shd.g_old_rec.information8
      ,p_information9_o
      => hr_tpp_shd.g_old_rec.information9
      ,p_information10_o
      => hr_tpp_shd.g_old_rec.information10
      ,p_information11_o
      => hr_tpp_shd.g_old_rec.information11
      ,p_information12_o
      => hr_tpp_shd.g_old_rec.information12
      ,p_information13_o
      => hr_tpp_shd.g_old_rec.information13
      ,p_information14_o
      => hr_tpp_shd.g_old_rec.information14
      ,p_information15_o
      => hr_tpp_shd.g_old_rec.information15
      ,p_information16_o
      => hr_tpp_shd.g_old_rec.information16
      ,p_information17_o
      => hr_tpp_shd.g_old_rec.information17
      ,p_information18_o
      => hr_tpp_shd.g_old_rec.information18
      ,p_information19_o
      => hr_tpp_shd.g_old_rec.information19
      ,p_information20_o
      => hr_tpp_shd.g_old_rec.information20
      ,p_information21_o
      => hr_tpp_shd.g_old_rec.information21
      ,p_information22_o
      => hr_tpp_shd.g_old_rec.information22
      ,p_information23_o
      => hr_tpp_shd.g_old_rec.information23
      ,p_information24_o
      => hr_tpp_shd.g_old_rec.information24
      ,p_information25_o
      => hr_tpp_shd.g_old_rec.information25
      ,p_information26_o
      => hr_tpp_shd.g_old_rec.information26
      ,p_information27_o
      => hr_tpp_shd.g_old_rec.information27
      ,p_information28_o
      => hr_tpp_shd.g_old_rec.information28
      ,p_information29_o
      => hr_tpp_shd.g_old_rec.information29
      ,p_information30_o
      => hr_tpp_shd.g_old_rec.information30
      );

Line: 382


End post_update;

Line: 608


  hr_tpp_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 615


  hr_tpp_upd.pre_update(p_rec);

Line: 619


  hr_tpp_upd.update_dml(p_rec);

Line: 623


  hr_tpp_upd.post_update
     (p_effective_date
     ,p_rec
     );