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

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

Line: 202


PROCEDURE update_configuration_value
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_business_group_id            in     number
  ,p_configuration_value_id       in     number
  ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute_category       in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute1               in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute2               in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute3               in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute4               in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute5               in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute6               in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute7               in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute8               in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute9               in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute10              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute11              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute12              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute13              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute14              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute15              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute16              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute17              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute18              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute19              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_attribute20              in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information1             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information2             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information3             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information4             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information5             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information6             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information7             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information8             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information9             in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information10            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information11            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information12            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information13            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information14            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information15            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information16            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information17            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information18            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information19            in     varchar2  default hr_api.g_varchar2
  ,p_pcv_information20            in     varchar2  default hr_api.g_varchar2
  ,p_configuration_name           in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 262


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

Line: 268


  savepoint update_configuration_value_swi;

Line: 289


  pqp_pcv_api.update_configuration_value
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_business_group_id            => p_business_group_id
    ,p_configuration_value_id       => p_configuration_value_id
    ,p_legislation_code             => p_legislation_code
    ,p_pcv_attribute_category       => p_pcv_attribute_category
    ,p_pcv_attribute1               => p_pcv_attribute1
    ,p_pcv_attribute2               => p_pcv_attribute2
    ,p_pcv_attribute3               => p_pcv_attribute3
    ,p_pcv_attribute4               => p_pcv_attribute4
    ,p_pcv_attribute5               => p_pcv_attribute5
    ,p_pcv_attribute6               => p_pcv_attribute6
    ,p_pcv_attribute7               => p_pcv_attribute7
    ,p_pcv_attribute8               => p_pcv_attribute8
    ,p_pcv_attribute9               => p_pcv_attribute9
    ,p_pcv_attribute10              => p_pcv_attribute10
    ,p_pcv_attribute11              => p_pcv_attribute11
    ,p_pcv_attribute12              => p_pcv_attribute12
    ,p_pcv_attribute13              => p_pcv_attribute13
    ,p_pcv_attribute14              => p_pcv_attribute14
    ,p_pcv_attribute15              => p_pcv_attribute15
    ,p_pcv_attribute16              => p_pcv_attribute16
    ,p_pcv_attribute17              => p_pcv_attribute17
    ,p_pcv_attribute18              => p_pcv_attribute18
    ,p_pcv_attribute19              => p_pcv_attribute19
    ,p_pcv_attribute20              => p_pcv_attribute20
    ,p_pcv_information_category     => p_pcv_information_category
    ,p_pcv_information1             => p_pcv_information1
    ,p_pcv_information2             => p_pcv_information2
    ,p_pcv_information3             => p_pcv_information3
    ,p_pcv_information4             => p_pcv_information4
    ,p_pcv_information5             => p_pcv_information5
    ,p_pcv_information6             => p_pcv_information6
    ,p_pcv_information7             => p_pcv_information7
    ,p_pcv_information8             => p_pcv_information8
    ,p_pcv_information9             => p_pcv_information9
    ,p_pcv_information10            => p_pcv_information10
    ,p_pcv_information11            => p_pcv_information11
    ,p_pcv_information12            => p_pcv_information12
    ,p_pcv_information13            => p_pcv_information13
    ,p_pcv_information14            => p_pcv_information14
    ,p_pcv_information15            => p_pcv_information15
    ,p_pcv_information16            => p_pcv_information16
    ,p_pcv_information17            => p_pcv_information17
    ,p_pcv_information18            => p_pcv_information18
    ,p_pcv_information19            => p_pcv_information19
    ,p_pcv_information20            => p_pcv_information20
    ,p_object_version_number        => p_object_version_number
    ,p_configuration_name           => p_configuration_name

    );

Line: 363


    rollback to update_configuration_value_swi;

Line: 378


    rollback to update_configuration_value_swi;

Line: 389


end update_configuration_value;

Line: 393


PROCEDURE delete_configuration_value
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_business_group_id            in     number
  ,p_configuration_value_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: 407


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

Line: 413


  savepoint delete_configuration_value_swi;

Line: 433


  pqp_pcv_api.delete_configuration_value
    (p_validate                     => l_validate
    ,p_business_group_id            => p_business_group_id
    ,p_configuration_value_id       => p_configuration_value_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 461


    rollback to delete_configuration_value_swi;

Line: 475


    rollback to delete_configuration_value_swi;

Line: 485


end delete_configuration_value;