APPS.PER_CNI_UPD SQL Statements

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

Line: 54

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

Line: 69

  update per_ri_config_information
    set
     configuration_code              = p_rec.configuration_code
    ,config_information_category     = p_rec.config_information_category
    ,config_information1             = p_rec.config_information1
    ,config_information2             = p_rec.config_information2
    ,config_information3             = p_rec.config_information3
    ,config_information4             = p_rec.config_information4
    ,config_information5             = p_rec.config_information5
    ,config_information6             = p_rec.config_information6
    ,config_information7             = p_rec.config_information7
    ,config_information8             = p_rec.config_information8
    ,config_information9             = p_rec.config_information9
    ,config_information10            = p_rec.config_information10
    ,config_information11            = p_rec.config_information11
    ,config_information12            = p_rec.config_information12
    ,config_information13            = p_rec.config_information13
    ,config_information14            = p_rec.config_information14
    ,config_information15            = p_rec.config_information15
    ,config_information16            = p_rec.config_information16
    ,config_information17            = p_rec.config_information17
    ,config_information18            = p_rec.config_information18
    ,config_information19            = p_rec.config_information19
    ,config_information20            = p_rec.config_information20
    ,config_information21            = p_rec.config_information21
    ,config_information22            = p_rec.config_information22
    ,config_information23            = p_rec.config_information23
    ,config_information24            = p_rec.config_information24
    ,config_information25            = p_rec.config_information25
    ,config_information26            = p_rec.config_information26
    ,config_information27            = p_rec.config_information27
    ,config_information28            = p_rec.config_information28
    ,config_information29            = p_rec.config_information29
    ,config_information30            = p_rec.config_information30
    ,config_information_id           = p_rec.config_information_id
    ,config_sequence                 = p_rec.config_sequence
    ,object_version_number           = p_rec.object_version_number
    where config_information_id = p_rec.config_information_id;

Line: 131

End update_dml;

Line: 165

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

Line: 175

End pre_update;

Line: 209

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

Line: 220

    per_cni_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_configuration_code
      => p_rec.configuration_code
      ,p_config_information_category
      => p_rec.config_information_category
      ,p_config_information1
      => p_rec.config_information1
      ,p_config_information2
      => p_rec.config_information2
      ,p_config_information3
      => p_rec.config_information3
      ,p_config_information4
      => p_rec.config_information4
      ,p_config_information5
      => p_rec.config_information5
      ,p_config_information6
      => p_rec.config_information6
      ,p_config_information7
      => p_rec.config_information7
      ,p_config_information8
      => p_rec.config_information8
      ,p_config_information9
      => p_rec.config_information9
      ,p_config_information10
      => p_rec.config_information10
      ,p_config_information11
      => p_rec.config_information11
      ,p_config_information12
      => p_rec.config_information12
      ,p_config_information13
      => p_rec.config_information13
      ,p_config_information14
      => p_rec.config_information14
      ,p_config_information15
      => p_rec.config_information15
      ,p_config_information16
      => p_rec.config_information16
      ,p_config_information17
      => p_rec.config_information17
      ,p_config_information18
      => p_rec.config_information18
      ,p_config_information19
      => p_rec.config_information19
      ,p_config_information20
      => p_rec.config_information20
      ,p_config_information21
      => p_rec.config_information21
      ,p_config_information22
      => p_rec.config_information22
      ,p_config_information23
      => p_rec.config_information23
      ,p_config_information24
      => p_rec.config_information24
      ,p_config_information25
      => p_rec.config_information25
      ,p_config_information26
      => p_rec.config_information26
      ,p_config_information27
      => p_rec.config_information27
      ,p_config_information28
      => p_rec.config_information28
      ,p_config_information29
      => p_rec.config_information29
      ,p_config_information30
      => p_rec.config_information30
      ,p_config_information_id
      => p_rec.config_information_id
      ,p_config_sequence
      => p_rec.config_sequence
      ,p_configuration_code_o
      => per_cni_shd.g_old_rec.configuration_code
      ,p_config_information_categor_o
      => per_cni_shd.g_old_rec.config_information_category
      ,p_config_information1_o
      => per_cni_shd.g_old_rec.config_information1
      ,p_config_information2_o
      => per_cni_shd.g_old_rec.config_information2
      ,p_config_information3_o
      => per_cni_shd.g_old_rec.config_information3
      ,p_config_information4_o
      => per_cni_shd.g_old_rec.config_information4
      ,p_config_information5_o
      => per_cni_shd.g_old_rec.config_information5
      ,p_config_information6_o
      => per_cni_shd.g_old_rec.config_information6
      ,p_config_information7_o
      => per_cni_shd.g_old_rec.config_information7
      ,p_config_information8_o
      => per_cni_shd.g_old_rec.config_information8
      ,p_config_information9_o
      => per_cni_shd.g_old_rec.config_information9
      ,p_config_information10_o
      => per_cni_shd.g_old_rec.config_information10
      ,p_config_information11_o
      => per_cni_shd.g_old_rec.config_information11
      ,p_config_information12_o
      => per_cni_shd.g_old_rec.config_information12
      ,p_config_information13_o
      => per_cni_shd.g_old_rec.config_information13
      ,p_config_information14_o
      => per_cni_shd.g_old_rec.config_information14
      ,p_config_information15_o
      => per_cni_shd.g_old_rec.config_information15
      ,p_config_information16_o
      => per_cni_shd.g_old_rec.config_information16
      ,p_config_information17_o
      => per_cni_shd.g_old_rec.config_information17
      ,p_config_information18_o
      => per_cni_shd.g_old_rec.config_information18
      ,p_config_information19_o
      => per_cni_shd.g_old_rec.config_information19
      ,p_config_information20_o
      => per_cni_shd.g_old_rec.config_information20
      ,p_config_information21_o
      => per_cni_shd.g_old_rec.config_information21
      ,p_config_information22_o
      => per_cni_shd.g_old_rec.config_information22
      ,p_config_information23_o
      => per_cni_shd.g_old_rec.config_information23
      ,p_config_information24_o
      => per_cni_shd.g_old_rec.config_information24
      ,p_config_information25_o
      => per_cni_shd.g_old_rec.config_information25
      ,p_config_information26_o
      => per_cni_shd.g_old_rec.config_information26
      ,p_config_information27_o
      => per_cni_shd.g_old_rec.config_information27
      ,p_config_information28_o
      => per_cni_shd.g_old_rec.config_information28
      ,p_config_information29_o
      => per_cni_shd.g_old_rec.config_information29
      ,p_config_information30_o
      => per_cni_shd.g_old_rec.config_information30
      ,p_config_sequence_o
      => per_cni_shd.g_old_rec.config_sequence
      );

Line: 369

End post_update;

Line: 587

  per_cni_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 597

  per_cni_upd.pre_update(p_rec);

Line: 601

  per_cni_upd.update_dml(p_rec);

Line: 605

  per_cni_upd.post_update
     (p_effective_date
     ,p_rec
     );