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

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

Line: 335


procedure update_position_extra_info
  (p_validate                      in     boolean  default false
  ,p_position_extra_info_id        in     number
  ,p_object_version_number         in out nocopy number
  ,p_poei_attribute_category       in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute1               in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute2               in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute3               in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute4               in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute5               in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute6               in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute7               in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute8               in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute9               in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute10              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute11              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute12              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute13              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute14              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute15              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute16              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute17              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute18              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute19              in     varchar2 default hr_api.g_varchar2
  ,p_poei_attribute20              in     varchar2 default hr_api.g_varchar2
  ,p_poei_information_category     in     varchar2 default hr_api.g_varchar2
  ,p_poei_information1             in     varchar2 default hr_api.g_varchar2
  ,p_poei_information2             in     varchar2 default hr_api.g_varchar2
  ,p_poei_information3             in     varchar2 default hr_api.g_varchar2
  ,p_poei_information4             in     varchar2 default hr_api.g_varchar2
  ,p_poei_information5             in     varchar2 default hr_api.g_varchar2
  ,p_poei_information6             in     varchar2 default hr_api.g_varchar2
  ,p_poei_information7             in     varchar2 default hr_api.g_varchar2
  ,p_poei_information8             in     varchar2 default hr_api.g_varchar2
  ,p_poei_information9             in     varchar2 default hr_api.g_varchar2
  ,p_poei_information10            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information11            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information12            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information13            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information14            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information15            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information16            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information17            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information18            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information19            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information20            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information21            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information22            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information23            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information24            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information25            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information26            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information27            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information28            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information29            in     varchar2 default hr_api.g_varchar2
  ,p_poei_information30            in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_position_extra_info';

Line: 404


  savepoint update_position_extra_info;

Line: 409


	hr_position_extra_info_bk2.update_position_extra_info_b
		(
		p_position_extra_info_id	=>	p_position_extra_info_id,
		p_poei_attribute_category	=>	p_poei_attribute_category,
		p_poei_attribute1		=>	p_poei_attribute1,
		p_poei_attribute2		=>	p_poei_attribute2,
		p_poei_attribute3		=>	p_poei_attribute3,
		p_poei_attribute4		=>	p_poei_attribute4,
		p_poei_attribute5		=>	p_poei_attribute5,
		p_poei_attribute6		=>	p_poei_attribute6,
		p_poei_attribute7		=>	p_poei_attribute7,
		p_poei_attribute8		=>	p_poei_attribute8,
		p_poei_attribute9		=>	p_poei_attribute9,
		p_poei_attribute10		=>	p_poei_attribute10,
		p_poei_attribute11		=>	p_poei_attribute11,
		p_poei_attribute12		=>	p_poei_attribute12,
		p_poei_attribute13		=>	p_poei_attribute13,
		p_poei_attribute14		=>	p_poei_attribute14,
		p_poei_attribute15		=>	p_poei_attribute15,
		p_poei_attribute16		=>	p_poei_attribute16,
		p_poei_attribute17		=>	p_poei_attribute17,
		p_poei_attribute18		=>	p_poei_attribute18,
		p_poei_attribute19		=>	p_poei_attribute19,
		p_poei_attribute20		=>	p_poei_attribute20,
		p_poei_information_category	=>	p_poei_information_category,
		p_poei_information1		=>	p_poei_information1,
		p_poei_information2		=>	p_poei_information2,
		p_poei_information3		=>	p_poei_information3,
		p_poei_information4		=>	p_poei_information4,
		p_poei_information5		=>	p_poei_information5,
		p_poei_information6		=>	p_poei_information6,
		p_poei_information7		=>	p_poei_information7,
		p_poei_information8		=>	p_poei_information8,
		p_poei_information9		=>	p_poei_information9,
		p_poei_information10		=>	p_poei_information10,
		p_poei_information11		=>	p_poei_information11,
		p_poei_information12		=>	p_poei_information12,
		p_poei_information13		=>	p_poei_information13,
		p_poei_information14		=>	p_poei_information14,
		p_poei_information15		=>	p_poei_information15,
		p_poei_information16		=>	p_poei_information16,
		p_poei_information17		=>	p_poei_information17,
		p_poei_information18		=>	p_poei_information18,
		p_poei_information19		=>	p_poei_information19,
		p_poei_information20		=>	p_poei_information20,
		p_poei_information21		=>	p_poei_information21,
		p_poei_information22		=>	p_poei_information22,
		p_poei_information23		=>	p_poei_information23,
		p_poei_information24		=>	p_poei_information24,
		p_poei_information25		=>	p_poei_information25,
		p_poei_information26		=>	p_poei_information26,
		p_poei_information27		=>	p_poei_information27,
		p_poei_information28		=>	p_poei_information28,
		p_poei_information29		=>	p_poei_information29,
		p_poei_information30		=>	p_poei_information30,
		p_object_version_number		=>	p_object_version_number
		);

Line: 469


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

Line: 547


	hr_position_extra_info_bk2.update_position_extra_info_a
		(
		p_position_extra_info_id	=>	p_position_extra_info_id,
		p_poei_attribute_category	=>	p_poei_attribute_category,
		p_poei_attribute1		=>	p_poei_attribute1,
		p_poei_attribute2		=>	p_poei_attribute2,
		p_poei_attribute3		=>	p_poei_attribute3,
		p_poei_attribute4		=>	p_poei_attribute4,
		p_poei_attribute5		=>	p_poei_attribute5,
		p_poei_attribute6		=>	p_poei_attribute6,
		p_poei_attribute7		=>	p_poei_attribute7,
		p_poei_attribute8		=>	p_poei_attribute8,
		p_poei_attribute9		=>	p_poei_attribute9,
		p_poei_attribute10		=>	p_poei_attribute10,
		p_poei_attribute11		=>	p_poei_attribute11,
		p_poei_attribute12		=>	p_poei_attribute12,
		p_poei_attribute13		=>	p_poei_attribute13,
		p_poei_attribute14		=>	p_poei_attribute14,
		p_poei_attribute15		=>	p_poei_attribute15,
		p_poei_attribute16		=>	p_poei_attribute16,
		p_poei_attribute17		=>	p_poei_attribute17,
		p_poei_attribute18		=>	p_poei_attribute18,
		p_poei_attribute19		=>	p_poei_attribute19,
		p_poei_attribute20		=>	p_poei_attribute20,
		p_poei_information_category	=>	p_poei_information_category,
		p_poei_information1		=>	p_poei_information1,
		p_poei_information2		=>	p_poei_information2,
		p_poei_information3		=>	p_poei_information3,
		p_poei_information4		=>	p_poei_information4,
		p_poei_information5		=>	p_poei_information5,
		p_poei_information6		=>	p_poei_information6,
		p_poei_information7		=>	p_poei_information7,
		p_poei_information8		=>	p_poei_information8,
		p_poei_information9		=>	p_poei_information9,
		p_poei_information10		=>	p_poei_information10,
		p_poei_information11		=>	p_poei_information11,
		p_poei_information12		=>	p_poei_information12,
		p_poei_information13		=>	p_poei_information13,
		p_poei_information14		=>	p_poei_information14,
		p_poei_information15		=>	p_poei_information15,
		p_poei_information16		=>	p_poei_information16,
		p_poei_information17		=>	p_poei_information17,
		p_poei_information18		=>	p_poei_information18,
		p_poei_information19		=>	p_poei_information19,
		p_poei_information20		=>	p_poei_information20,
		p_poei_information21		=>	p_poei_information21,
		p_poei_information22		=>	p_poei_information22,
		p_poei_information23		=>	p_poei_information23,
		p_poei_information24		=>	p_poei_information24,
		p_poei_information25		=>	p_poei_information25,
		p_poei_information26		=>	p_poei_information26,
		p_poei_information27		=>	p_poei_information27,
		p_poei_information28		=>	p_poei_information28,
		p_poei_information29		=>	p_poei_information29,
		p_poei_information30		=>	p_poei_information30,
		p_object_version_number		=>	p_object_version_number
		);

Line: 607


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

Line: 626


    ROLLBACK TO update_position_extra_info;

Line: 643


    ROLLBACK TO update_position_extra_info;

Line: 647


end update_position_extra_info;

Line: 654


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

Line: 669


  savepoint delete_position_extra_info;

Line: 674


	hr_position_extra_info_bk3.delete_position_extra_info_b
		(
		p_position_extra_info_id	=>	p_position_extra_info_id,
		p_object_version_number		=>	p_object_version_number
		);

Line: 682


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

Line: 704


	hr_position_extra_info_bk3.delete_position_extra_info_a
		(
		p_position_extra_info_id	=>	p_position_extra_info_id,
		p_object_version_number		=>	p_object_version_number
		);

Line: 712


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

Line: 730


    ROLLBACK TO delete_position_extra_info;

Line: 740


    ROLLBACK TO delete_position_extra_info;

Line: 744


end delete_position_extra_info;