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_API SQL Statements

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

Line: 318


procedure update_configuration_value
  (p_validate                       in     boolean  default false
  ,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_object_version_number          in out nocopy number
  ,p_configuration_name             in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number  number;

Line: 374


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

Line: 380


  savepoint update_configuration_value;

Line: 395


    pqp_pcv_bk2.update_configuration_value_b
      (p_configuration_value_id         =>     p_configuration_value_id
      ,p_effective_date                 =>     l_effective_date
      ,p_object_version_number          =>     l_object_version_number
      ,p_business_group_id              =>     p_business_group_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_configuration_name		=>     p_configuration_name

      );

Line: 449


        (p_module_name => 'update_configuration_value'
        ,p_hook_type   => 'BP'
        );

Line: 517


    pqp_pcv_bk2.update_configuration_value_a
      (p_configuration_value_id         =>     p_configuration_value_id
      ,p_effective_date                 =>     l_effective_date
      ,p_object_version_number          =>     l_object_version_number
      ,p_business_group_id              =>     p_business_group_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_configuration_name		=>     p_configuration_name

      );

Line: 571


        (p_module_name => 'update_configuration_value'
        ,p_hook_type   => 'AP'
        );

Line: 593


    rollback to update_configuration_value;

Line: 605


    rollback to update_configuration_value;

Line: 613


end update_configuration_value;

Line: 620


procedure delete_configuration_value
  (p_validate                       in     boolean  default false
  ,p_business_group_id              in     number
  ,p_configuration_value_id         in     number
  ,p_object_version_number          in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number  number;

Line: 630


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

Line: 636


  savepoint delete_configuration_value;

Line: 646


    pqp_pcv_bk3.delete_configuration_value_b
      (p_configuration_value_id         =>     p_configuration_value_id
      ,p_object_version_number          =>     p_object_version_number
      );

Line: 653


        (p_module_name => 'delete_configuration_value'
        ,p_hook_type   => 'BP'
        );

Line: 675


    pqp_pcv_bk3.delete_configuration_value_a
      (p_configuration_value_id         =>     p_configuration_value_id
      ,p_object_version_number          =>     p_object_version_number
      );

Line: 682


        (p_module_name => 'delete_configuration_value'
        ,p_hook_type   => 'AP'
        );

Line: 704


    rollback to delete_configuration_value;

Line: 716


    rollback to delete_configuration_value;

Line: 724


end delete_configuration_value;