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.PAY_AIF_UPD SQL Statements

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

Line: 54


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

Line: 70


  update pay_action_information
    set
     action_information_id           = p_rec.action_information_id
    ,object_version_number           = p_rec.object_version_number
    ,action_information1             = p_rec.action_information1
    ,action_information2             = p_rec.action_information2
    ,action_information3             = p_rec.action_information3
    ,action_information4             = p_rec.action_information4
    ,action_information5             = p_rec.action_information5
    ,action_information6             = p_rec.action_information6
    ,action_information7             = p_rec.action_information7
    ,action_information8             = p_rec.action_information8
    ,action_information9             = p_rec.action_information9
    ,action_information10            = p_rec.action_information10
    ,action_information11            = p_rec.action_information11
    ,action_information12            = p_rec.action_information12
    ,action_information13            = p_rec.action_information13
    ,action_information14            = p_rec.action_information14
    ,action_information15            = p_rec.action_information15
    ,action_information16            = p_rec.action_information16
    ,action_information17            = p_rec.action_information17
    ,action_information18            = p_rec.action_information18
    ,action_information19            = p_rec.action_information19
    ,action_information20            = p_rec.action_information20
    ,action_information21            = p_rec.action_information21
    ,action_information22            = p_rec.action_information22
    ,action_information23            = p_rec.action_information23
    ,action_information24            = p_rec.action_information24
    ,action_information25            = p_rec.action_information25
    ,action_information26            = p_rec.action_information26
    ,action_information27            = p_rec.action_information27
    ,action_information28            = p_rec.action_information28
    ,action_information29            = p_rec.action_information29
    ,action_information30            = p_rec.action_information30
    where action_information_id = p_rec.action_information_id;

Line: 129


End update_dml;

Line: 163


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

Line: 173


End pre_update;

Line: 207


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

Line: 217


    pay_aif_rku.after_update
      (p_action_information_id
      => p_rec.action_information_id
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_action_information1
      => p_rec.action_information1
      ,p_action_information2
      => p_rec.action_information2
      ,p_action_information3
      => p_rec.action_information3
      ,p_action_information4
      => p_rec.action_information4
      ,p_action_information5
      => p_rec.action_information5
      ,p_action_information6
      => p_rec.action_information6
      ,p_action_information7
      => p_rec.action_information7
      ,p_action_information8
      => p_rec.action_information8
      ,p_action_information9
      => p_rec.action_information9
      ,p_action_information10
      => p_rec.action_information10
      ,p_action_information11
      => p_rec.action_information11
      ,p_action_information12
      => p_rec.action_information12
      ,p_action_information13
      => p_rec.action_information13
      ,p_action_information14
      => p_rec.action_information14
      ,p_action_information15
      => p_rec.action_information15
      ,p_action_information16
      => p_rec.action_information16
      ,p_action_information17
      => p_rec.action_information17
      ,p_action_information18
      => p_rec.action_information18
      ,p_action_information19
      => p_rec.action_information19
      ,p_action_information20
      => p_rec.action_information20
      ,p_action_information21
      => p_rec.action_information21
      ,p_action_information22
      => p_rec.action_information22
      ,p_action_information23
      => p_rec.action_information23
      ,p_action_information24
      => p_rec.action_information24
      ,p_action_information25
      => p_rec.action_information25
      ,p_action_information26
      => p_rec.action_information26
      ,p_action_information27
      => p_rec.action_information27
      ,p_action_information28
      => p_rec.action_information28
      ,p_action_information29
      => p_rec.action_information29
      ,p_action_information30
      => p_rec.action_information30
      ,p_action_context_id_o
      => pay_aif_shd.g_old_rec.action_context_id
      ,p_action_context_type_o
      => pay_aif_shd.g_old_rec.action_context_type
      ,p_tax_unit_id_o
      => pay_aif_shd.g_old_rec.tax_unit_id
      ,p_jurisdiction_code_o
      => pay_aif_shd.g_old_rec.jurisdiction_code
      ,p_source_id_o
      => pay_aif_shd.g_old_rec.source_id
      ,p_source_text_o
      => pay_aif_shd.g_old_rec.source_text
      ,p_tax_group_o
      => pay_aif_shd.g_old_rec.tax_group
      ,p_object_version_number_o
      => pay_aif_shd.g_old_rec.object_version_number
      ,p_effective_date_o
      => pay_aif_shd.g_old_rec.effective_date
      ,p_assignment_id_o
      => pay_aif_shd.g_old_rec.assignment_id
      ,p_action_information_categor_o
      => pay_aif_shd.g_old_rec.action_information_category
      ,p_action_information1_o
      => pay_aif_shd.g_old_rec.action_information1
      ,p_action_information2_o
      => pay_aif_shd.g_old_rec.action_information2
      ,p_action_information3_o
      => pay_aif_shd.g_old_rec.action_information3
      ,p_action_information4_o
      => pay_aif_shd.g_old_rec.action_information4
      ,p_action_information5_o
      => pay_aif_shd.g_old_rec.action_information5
      ,p_action_information6_o
      => pay_aif_shd.g_old_rec.action_information6
      ,p_action_information7_o
      => pay_aif_shd.g_old_rec.action_information7
      ,p_action_information8_o
      => pay_aif_shd.g_old_rec.action_information8
      ,p_action_information9_o
      => pay_aif_shd.g_old_rec.action_information9
      ,p_action_information10_o
      => pay_aif_shd.g_old_rec.action_information10
      ,p_action_information11_o
      => pay_aif_shd.g_old_rec.action_information11
      ,p_action_information12_o
      => pay_aif_shd.g_old_rec.action_information12
      ,p_action_information13_o
      => pay_aif_shd.g_old_rec.action_information13
      ,p_action_information14_o
      => pay_aif_shd.g_old_rec.action_information14
      ,p_action_information15_o
      => pay_aif_shd.g_old_rec.action_information15
      ,p_action_information16_o
      => pay_aif_shd.g_old_rec.action_information16
      ,p_action_information17_o
      => pay_aif_shd.g_old_rec.action_information17
      ,p_action_information18_o
      => pay_aif_shd.g_old_rec.action_information18
      ,p_action_information19_o
      => pay_aif_shd.g_old_rec.action_information19
      ,p_action_information20_o
      => pay_aif_shd.g_old_rec.action_information20
      ,p_action_information21_o
      => pay_aif_shd.g_old_rec.action_information21
      ,p_action_information22_o
      => pay_aif_shd.g_old_rec.action_information22
      ,p_action_information23_o
      => pay_aif_shd.g_old_rec.action_information23
      ,p_action_information24_o
      => pay_aif_shd.g_old_rec.action_information24
      ,p_action_information25_o
      => pay_aif_shd.g_old_rec.action_information25
      ,p_action_information26_o
      => pay_aif_shd.g_old_rec.action_information26
      ,p_action_information27_o
      => pay_aif_shd.g_old_rec.action_information27
      ,p_action_information28_o
      => pay_aif_shd.g_old_rec.action_information28
      ,p_action_information29_o
      => pay_aif_shd.g_old_rec.action_information29
      ,p_action_information30_o
      => pay_aif_shd.g_old_rec.action_information30
      );

Line: 377


End post_update;

Line: 622


  pay_aif_bus.update_validate
     (p_rec
     );

Line: 632


  pay_aif_upd.pre_update(p_rec);

Line: 636


  pay_aif_upd.update_dml(p_rec);

Line: 640


  pay_aif_upd.post_update
     (p_rec
     );