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

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

Line: 338


procedure update_person_extra_info
  (p_validate                      in     boolean  default false
  ,p_person_extra_info_id          in     number
  ,p_object_version_number         in out nocopy number
  ,p_pei_attribute_category        in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute1                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute2                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute3                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute4                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute5                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute6                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute7                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute8                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute9                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute10               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute11               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute12               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute13               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute14               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute15               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute16               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute17               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute18               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute19               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute20               in     varchar2 default hr_api.g_varchar2
  ,p_pei_information_category      in     varchar2 default hr_api.g_varchar2
  ,p_pei_information1              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information2              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information3              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information4              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information5              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information6              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information7              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information8              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information9              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information10             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information11             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information12             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information13             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information14             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information15             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information16             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information17             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information18             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information19             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information20             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information21             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information22             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information23             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information24             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information25             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information26             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information27             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information28             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information29             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information30             in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_person_extra_info';

Line: 407


  savepoint update_person_extra_info;

Line: 412


    hr_person_extra_info_bk2.update_person_extra_info_b
     (p_person_extra_info_id         => p_person_extra_info_id,
      p_pei_attribute_category     => p_pei_attribute_category,
      p_pei_attribute1             => p_pei_attribute1,
      p_pei_attribute2             => p_pei_attribute2,
      p_pei_attribute3             => p_pei_attribute3,
      p_pei_attribute4             => p_pei_attribute4,
      p_pei_attribute5             => p_pei_attribute5,
      p_pei_attribute6             => p_pei_attribute6,
      p_pei_attribute7             => p_pei_attribute7,
      p_pei_attribute8             => p_pei_attribute8,
      p_pei_attribute9             => p_pei_attribute9,
      p_pei_attribute10            => p_pei_attribute10,
      p_pei_attribute11            => p_pei_attribute11,
      p_pei_attribute12            => p_pei_attribute12,
      p_pei_attribute13            => p_pei_attribute13,
      p_pei_attribute14            => p_pei_attribute14,
      p_pei_attribute15            => p_pei_attribute15,
      p_pei_attribute16            => p_pei_attribute16,
      p_pei_attribute17            => p_pei_attribute17,
      p_pei_attribute18            => p_pei_attribute18,
      p_pei_attribute19            => p_pei_attribute19,
      p_pei_attribute20            => p_pei_attribute20,
      p_pei_information_category   => p_pei_information_category,
      p_pei_information1           => p_pei_information1,
      p_pei_information2           => p_pei_information2,
      p_pei_information3           => p_pei_information3,
      p_pei_information4           => p_pei_information4,
      p_pei_information5           => p_pei_information5,
      p_pei_information6           => p_pei_information6,
      p_pei_information7           => p_pei_information7,
      p_pei_information8           => p_pei_information8,
      p_pei_information9           => p_pei_information9,
      p_pei_information10          => p_pei_information10,
      p_pei_information11          => p_pei_information11,
      p_pei_information12          => p_pei_information12,
      p_pei_information13          => p_pei_information13,
      p_pei_information14          => p_pei_information14,
      p_pei_information15          => p_pei_information15,
      p_pei_information16          => p_pei_information16,
      p_pei_information17          => p_pei_information17,
      p_pei_information18          => p_pei_information18,
      p_pei_information19          => p_pei_information19,
      p_pei_information20          => p_pei_information20,
      p_pei_information21          => p_pei_information21,
      p_pei_information22          => p_pei_information22,
      p_pei_information23          => p_pei_information23,
      p_pei_information24          => p_pei_information24,
      p_pei_information25          => p_pei_information25,
      p_pei_information26          => p_pei_information26,
      p_pei_information27          => p_pei_information27,
      p_pei_information28          => p_pei_information28,
      p_pei_information29          => p_pei_information29,
      p_pei_information30          => p_pei_information30,
      p_object_version_number      => p_object_version_number
      );

Line: 471


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

Line: 550


    hr_person_extra_info_bk2.update_person_extra_info_a
     (p_person_extra_info_id       => p_person_extra_info_id,
      p_pei_attribute_category     => p_pei_attribute_category,
      p_pei_attribute1             => p_pei_attribute1,
      p_pei_attribute2             => p_pei_attribute2,
      p_pei_attribute3             => p_pei_attribute3,
      p_pei_attribute4             => p_pei_attribute4,
      p_pei_attribute5             => p_pei_attribute5,
      p_pei_attribute6             => p_pei_attribute6,
      p_pei_attribute7             => p_pei_attribute7,
      p_pei_attribute8             => p_pei_attribute8,
      p_pei_attribute9             => p_pei_attribute9,
      p_pei_attribute10            => p_pei_attribute10,
      p_pei_attribute11            => p_pei_attribute11,
      p_pei_attribute12            => p_pei_attribute12,
      p_pei_attribute13            => p_pei_attribute13,
      p_pei_attribute14            => p_pei_attribute14,
      p_pei_attribute15            => p_pei_attribute15,
      p_pei_attribute16            => p_pei_attribute16,
      p_pei_attribute17            => p_pei_attribute17,
      p_pei_attribute18            => p_pei_attribute18,
      p_pei_attribute19            => p_pei_attribute19,
      p_pei_attribute20            => p_pei_attribute20,
      p_pei_information_category   => p_pei_information_category,
      p_pei_information1           => p_pei_information1,
      p_pei_information2           => p_pei_information2,
      p_pei_information3           => p_pei_information3,
      p_pei_information4           => p_pei_information4,
      p_pei_information5           => p_pei_information5,
      p_pei_information6           => p_pei_information6,
      p_pei_information7           => p_pei_information7,
      p_pei_information8           => p_pei_information8,
      p_pei_information9           => p_pei_information9,
      p_pei_information10          => p_pei_information10,
      p_pei_information11          => p_pei_information11,
      p_pei_information12          => p_pei_information12,
      p_pei_information13          => p_pei_information13,
      p_pei_information14          => p_pei_information14,
      p_pei_information15          => p_pei_information15,
      p_pei_information16          => p_pei_information16,
      p_pei_information17          => p_pei_information17,
      p_pei_information18          => p_pei_information18,
      p_pei_information19          => p_pei_information19,
      p_pei_information20          => p_pei_information20,
      p_pei_information21          => p_pei_information21,
      p_pei_information22          => p_pei_information22,
      p_pei_information23          => p_pei_information23,
      p_pei_information24          => p_pei_information24,
      p_pei_information25          => p_pei_information25,
      p_pei_information26          => p_pei_information26,
      p_pei_information27          => p_pei_information27,
      p_pei_information28          => p_pei_information28,
      p_pei_information29          => p_pei_information29,
      p_pei_information30          => p_pei_information30,
      p_object_version_number      => p_object_version_number
      );

Line: 609


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

Line: 629


    ROLLBACK TO update_person_extra_info;

Line: 645


    ROLLBACK TO update_person_extra_info;

Line: 653


end update_person_extra_info;

Line: 660


procedure delete_person_extra_info
  (p_validate                      in     boolean  default false
  ,p_person_extra_info_id          in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_person_extra_info';

Line: 675


  savepoint delete_person_extra_info;

Line: 680


    hr_person_extra_info_bk3.delete_person_extra_info_b
      (p_person_extra_info_id       => p_person_extra_info_id,
       p_object_version_number      => p_object_version_number
      );

Line: 687


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

Line: 709


    hr_person_extra_info_bk3.delete_person_extra_info_a
      (p_person_extra_info_id      => p_person_extra_info_id,
       p_object_version_number     => p_object_version_number
      );

Line: 716


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

Line: 736


    ROLLBACK TO delete_person_extra_info;

Line: 746


    ROLLBACK TO delete_person_extra_info;

Line: 750


end delete_person_extra_info;