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

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

Line: 179


PROCEDURE update_config_information
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_config_information_id        in     number
  ,p_configuration_code             in   varchar2
  ,p_config_information_category  in     varchar2
  ,p_config_sequence              in     number    default hr_api.g_number
  ,p_config_information1          in     varchar2  default hr_api.g_varchar2
  ,p_config_information2          in     varchar2  default hr_api.g_varchar2
  ,p_config_information3          in     varchar2  default hr_api.g_varchar2
  ,p_config_information4          in     varchar2  default hr_api.g_varchar2
  ,p_config_information5          in     varchar2  default hr_api.g_varchar2
  ,p_config_information6          in     varchar2  default hr_api.g_varchar2
  ,p_config_information7          in     varchar2  default hr_api.g_varchar2
  ,p_config_information8          in     varchar2  default hr_api.g_varchar2
  ,p_config_information9          in     varchar2  default hr_api.g_varchar2
  ,p_config_information10         in     varchar2  default hr_api.g_varchar2
  ,p_config_information11         in     varchar2  default hr_api.g_varchar2
  ,p_config_information12         in     varchar2  default hr_api.g_varchar2
  ,p_config_information13         in     varchar2  default hr_api.g_varchar2
  ,p_config_information14         in     varchar2  default hr_api.g_varchar2
  ,p_config_information15         in     varchar2  default hr_api.g_varchar2
  ,p_config_information16         in     varchar2  default hr_api.g_varchar2
  ,p_config_information17         in     varchar2  default hr_api.g_varchar2
  ,p_config_information18         in     varchar2  default hr_api.g_varchar2
  ,p_config_information19         in     varchar2  default hr_api.g_varchar2
  ,p_config_information20         in     varchar2  default hr_api.g_varchar2
  ,p_config_information21         in     varchar2  default hr_api.g_varchar2
  ,p_config_information22         in     varchar2  default hr_api.g_varchar2
  ,p_config_information23         in     varchar2  default hr_api.g_varchar2
  ,p_config_information24         in     varchar2  default hr_api.g_varchar2
  ,p_config_information25         in     varchar2  default hr_api.g_varchar2
  ,p_config_information26         in     varchar2  default hr_api.g_varchar2
  ,p_config_information27         in     varchar2  default hr_api.g_varchar2
  ,p_config_information28         in     varchar2  default hr_api.g_varchar2
  ,p_config_information29         in     varchar2  default hr_api.g_varchar2
  ,p_config_information30         in     varchar2  default hr_api.g_varchar2
  ,p_language_code                in     varchar2  default hr_api.g_varchar2
  ,p_effective_date               in     date
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 228


  l_proc    varchar2(72) := g_package ||'update_config_information';

Line: 234


  savepoint update_config_information_swi;

Line: 255


  per_ri_config_information_api.update_config_information
    (p_validate                     => l_validate
    ,p_config_information_id        => p_config_information_id
    ,p_configuration_code             => p_configuration_code
    ,p_config_information_category  => p_config_information_category
    ,p_config_sequence              => p_config_sequence
    ,p_config_information1          => p_config_information1
    ,p_config_information2          => p_config_information2
    ,p_config_information3          => p_config_information3
    ,p_config_information4          => p_config_information4
    ,p_config_information5          => p_config_information5
    ,p_config_information6          => p_config_information6
    ,p_config_information7          => p_config_information7
    ,p_config_information8          => p_config_information8
    ,p_config_information9          => p_config_information9
    ,p_config_information10         => p_config_information10
    ,p_config_information11         => p_config_information11
    ,p_config_information12         => p_config_information12
    ,p_config_information13         => p_config_information13
    ,p_config_information14         => p_config_information14
    ,p_config_information15         => p_config_information15
    ,p_config_information16         => p_config_information16
    ,p_config_information17         => p_config_information17
    ,p_config_information18         => p_config_information18
    ,p_config_information19         => p_config_information19
    ,p_config_information20         => p_config_information20
    ,p_config_information21         => p_config_information21
    ,p_config_information22         => p_config_information22
    ,p_config_information23         => p_config_information23
    ,p_config_information24         => p_config_information24
    ,p_config_information25         => p_config_information25
    ,p_config_information26         => p_config_information26
    ,p_config_information27         => p_config_information27
    ,p_config_information28         => p_config_information28
    ,p_config_information29         => p_config_information29
    ,p_config_information30         => p_config_information30
    ,p_language_code                => p_language_code
    ,p_effective_date               => p_effective_date
    ,p_object_version_number        => p_object_version_number
    );

Line: 317


    rollback to update_config_information_swi;

Line: 332


    rollback to update_config_information_swi;

Line: 343


end update_config_information;

Line: 347


PROCEDURE delete_config_information
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_config_information_id        in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 360


  l_proc    varchar2(72) := g_package ||'delete_config_information';

Line: 366


  savepoint delete_config_information_swi;

Line: 386


  per_ri_config_information_api.delete_config_information
    (p_validate                     => l_validate
    ,p_config_information_id        => p_config_information_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 413


    rollback to delete_config_information_swi;

Line: 427


    rollback to delete_config_information_swi;

Line: 437


end delete_config_information;