APPS.HR_WNP_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_wnp_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 68

  update hr_window_properties_b
    set
     window_property_id              = p_rec.window_property_id
    ,form_window_id                  = p_rec.form_window_id
    ,template_window_id              = p_rec.template_window_id
    ,height                          = p_rec.height
    ,width                           = p_rec.width
    ,x_position                      = p_rec.x_position
    ,y_position                      = p_rec.y_position
    ,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 window_property_id = p_rec.window_property_id;

Line: 133

End update_dml;

Line: 167

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

Line: 177

End pre_update;

Line: 211

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

Line: 221

    hr_wnp_rku.after_update
      (p_window_property_id
      => p_rec.window_property_id
      ,p_form_window_id
      => p_rec.form_window_id
      ,p_template_window_id
      => p_rec.template_window_id
      ,p_height
      => p_rec.height
      ,p_width
      => p_rec.width
      ,p_x_position
      => p_rec.x_position
      ,p_y_position
      => p_rec.y_position
      ,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_window_id_o
      => hr_wnp_shd.g_old_rec.form_window_id
      ,p_template_window_id_o
      => hr_wnp_shd.g_old_rec.template_window_id
      ,p_height_o
      => hr_wnp_shd.g_old_rec.height
      ,p_width_o
      => hr_wnp_shd.g_old_rec.width
      ,p_x_position_o
      => hr_wnp_shd.g_old_rec.x_position
      ,p_y_position_o
      => hr_wnp_shd.g_old_rec.y_position
      ,p_information_category_o
      => hr_wnp_shd.g_old_rec.information_category
      ,p_information1_o
      => hr_wnp_shd.g_old_rec.information1
      ,p_information2_o
      => hr_wnp_shd.g_old_rec.information2
      ,p_information3_o
      => hr_wnp_shd.g_old_rec.information3
      ,p_information4_o
      => hr_wnp_shd.g_old_rec.information4
      ,p_information5_o
      => hr_wnp_shd.g_old_rec.information5
      ,p_information6_o
      => hr_wnp_shd.g_old_rec.information6
      ,p_information7_o
      => hr_wnp_shd.g_old_rec.information7
      ,p_information8_o
      => hr_wnp_shd.g_old_rec.information8
      ,p_information9_o
      => hr_wnp_shd.g_old_rec.information9
      ,p_information10_o
      => hr_wnp_shd.g_old_rec.information10
      ,p_information11_o
      => hr_wnp_shd.g_old_rec.information11
      ,p_information12_o
      => hr_wnp_shd.g_old_rec.information12
      ,p_information13_o
      => hr_wnp_shd.g_old_rec.information13
      ,p_information14_o
      => hr_wnp_shd.g_old_rec.information14
      ,p_information15_o
      => hr_wnp_shd.g_old_rec.information15
      ,p_information16_o
      => hr_wnp_shd.g_old_rec.information16
      ,p_information17_o
      => hr_wnp_shd.g_old_rec.information17
      ,p_information18_o
      => hr_wnp_shd.g_old_rec.information18
      ,p_information19_o
      => hr_wnp_shd.g_old_rec.information19
      ,p_information20_o
      => hr_wnp_shd.g_old_rec.information20
      ,p_information21_o
      => hr_wnp_shd.g_old_rec.information21
      ,p_information22_o
      => hr_wnp_shd.g_old_rec.information22
      ,p_information23_o
      => hr_wnp_shd.g_old_rec.information23
      ,p_information24_o
      => hr_wnp_shd.g_old_rec.information24
      ,p_information25_o
      => hr_wnp_shd.g_old_rec.information25
      ,p_information26_o
      => hr_wnp_shd.g_old_rec.information26
      ,p_information27_o
      => hr_wnp_shd.g_old_rec.information27
      ,p_information28_o
      => hr_wnp_shd.g_old_rec.information28
      ,p_information29_o
      => hr_wnp_shd.g_old_rec.information29
      ,p_information30_o
      => hr_wnp_shd.g_old_rec.information30
      );

Line: 385

End post_update;

Line: 617

  hr_wnp_bus.update_validate
     (p_rec
     );

Line: 623

  hr_wnp_upd.pre_update(p_rec);

Line: 627

  hr_wnp_upd.update_dml(p_rec);

Line: 631

  hr_wnp_upd.post_update
     (p_rec
     );