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

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

Line: 334


procedure update_assignment_extra_info
  (p_validate                      in     boolean  default false
  ,p_assignment_extra_info_id      in     number
  ,p_object_version_number         in out nocopy number
  ,p_aei_attribute_category        in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute1                in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute2                in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute3                in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute4                in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute5                in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute6                in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute7                in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute8                in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute9                in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute10               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute11               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute12               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute13               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute14               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute15               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute16               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute17               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute18               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute19               in     varchar2 default hr_api.g_varchar2
  ,p_aei_attribute20               in     varchar2 default hr_api.g_varchar2
  ,p_aei_information_category      in     varchar2 default hr_api.g_varchar2
  ,p_aei_information1              in     varchar2 default hr_api.g_varchar2
  ,p_aei_information2              in     varchar2 default hr_api.g_varchar2
  ,p_aei_information3              in     varchar2 default hr_api.g_varchar2
  ,p_aei_information4              in     varchar2 default hr_api.g_varchar2
  ,p_aei_information5              in     varchar2 default hr_api.g_varchar2
  ,p_aei_information6              in     varchar2 default hr_api.g_varchar2
  ,p_aei_information7              in     varchar2 default hr_api.g_varchar2
  ,p_aei_information8              in     varchar2 default hr_api.g_varchar2
  ,p_aei_information9              in     varchar2 default hr_api.g_varchar2
  ,p_aei_information10             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information11             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information12             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information13             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information14             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information15             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information16             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information17             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information18             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information19             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information20             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information21             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information22             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information23             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information24             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information25             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information26             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information27             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information28             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information29             in     varchar2 default hr_api.g_varchar2
  ,p_aei_information30             in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_assignment_extra_info';

Line: 404


  savepoint update_assignment_extra_info;

Line: 409


	hr_assignment_extra_info_bk2.update_assignment_extra_info_b
		(
		p_assignment_extra_info_id	=>	p_assignment_extra_info_id,
		p_aei_attribute_category	=>	p_aei_attribute_category,
		p_aei_attribute1		=>	p_aei_attribute1,
		p_aei_attribute2		=>	p_aei_attribute2,
		p_aei_attribute3		=>	p_aei_attribute3,
		p_aei_attribute4		=>	p_aei_attribute4,
		p_aei_attribute5		=>	p_aei_attribute5,
		p_aei_attribute6		=>	p_aei_attribute6,
		p_aei_attribute7		=>	p_aei_attribute7,
		p_aei_attribute8		=>	p_aei_attribute8,
		p_aei_attribute9		=>	p_aei_attribute9,
		p_aei_attribute10		=>	p_aei_attribute10,
		p_aei_attribute11		=>	p_aei_attribute11,
		p_aei_attribute12		=>	p_aei_attribute12,
		p_aei_attribute13		=>	p_aei_attribute13,
		p_aei_attribute14		=>	p_aei_attribute14,
		p_aei_attribute15		=>	p_aei_attribute15,
		p_aei_attribute16		=>	p_aei_attribute16,
		p_aei_attribute17		=>	p_aei_attribute17,
		p_aei_attribute18		=>	p_aei_attribute18,
		p_aei_attribute19		=>	p_aei_attribute19,
		p_aei_attribute20		=>	p_aei_attribute20,
		p_aei_information_category	=>	p_aei_information_category,
		p_aei_information1		=>	p_aei_information1,
		p_aei_information2		=>	p_aei_information2,
		p_aei_information3		=>	p_aei_information3,
		p_aei_information4		=>	p_aei_information4,
		p_aei_information5		=>	p_aei_information5,
		p_aei_information6		=>	p_aei_information6,
		p_aei_information7		=>	p_aei_information7,
		p_aei_information8		=>	p_aei_information8,
		p_aei_information9		=>	p_aei_information9,
		p_aei_information10		=>	p_aei_information10,
		p_aei_information11		=>	p_aei_information11,
		p_aei_information12		=>	p_aei_information12,
		p_aei_information13		=>	p_aei_information13,
		p_aei_information14		=>	p_aei_information14,
		p_aei_information15		=>	p_aei_information15,
		p_aei_information16		=>	p_aei_information16,
		p_aei_information17		=>	p_aei_information17,
		p_aei_information18		=>	p_aei_information18,
		p_aei_information19		=>	p_aei_information19,
		p_aei_information20		=>	p_aei_information20,
		p_aei_information21		=>	p_aei_information21,
		p_aei_information22		=>	p_aei_information22,
		p_aei_information23		=>	p_aei_information23,
		p_aei_information24		=>	p_aei_information24,
		p_aei_information25		=>	p_aei_information25,
		p_aei_information26		=>	p_aei_information26,
		p_aei_information27		=>	p_aei_information27,
		p_aei_information28		=>	p_aei_information28,
		p_aei_information29		=>	p_aei_information29,
		p_aei_information30		=>	p_aei_information30,
		p_object_version_number		=>	p_object_version_number
		);

Line: 469


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

Line: 546


	hr_assignment_extra_info_bk2.update_assignment_extra_info_a
		(
		p_assignment_extra_info_id	=>	p_assignment_extra_info_id,
		p_aei_attribute_category	=>	p_aei_attribute_category,
		p_aei_attribute1		=>	p_aei_attribute1,
		p_aei_attribute2		=>	p_aei_attribute2,
		p_aei_attribute3		=>	p_aei_attribute3,
		p_aei_attribute4		=>	p_aei_attribute4,
		p_aei_attribute5		=>	p_aei_attribute5,
		p_aei_attribute6		=>	p_aei_attribute6,
		p_aei_attribute7		=>	p_aei_attribute7,
		p_aei_attribute8		=>	p_aei_attribute8,
		p_aei_attribute9		=>	p_aei_attribute9,
		p_aei_attribute10		=>	p_aei_attribute10,
		p_aei_attribute11		=>	p_aei_attribute11,
		p_aei_attribute12		=>	p_aei_attribute12,
		p_aei_attribute13		=>	p_aei_attribute13,
		p_aei_attribute14		=>	p_aei_attribute14,
		p_aei_attribute15		=>	p_aei_attribute15,
		p_aei_attribute16		=>	p_aei_attribute16,
		p_aei_attribute17		=>	p_aei_attribute17,
		p_aei_attribute18		=>	p_aei_attribute18,
		p_aei_attribute19		=>	p_aei_attribute19,
		p_aei_attribute20		=>	p_aei_attribute20,
		p_aei_information_category	=>	p_aei_information_category,
		p_aei_information1		=>	p_aei_information1,
		p_aei_information2		=>	p_aei_information2,
		p_aei_information3		=>	p_aei_information3,
		p_aei_information4		=>	p_aei_information4,
		p_aei_information5		=>	p_aei_information5,
		p_aei_information6		=>	p_aei_information6,
		p_aei_information7		=>	p_aei_information7,
		p_aei_information8		=>	p_aei_information8,
		p_aei_information9		=>	p_aei_information9,
		p_aei_information10		=>	p_aei_information10,
		p_aei_information11		=>	p_aei_information11,
		p_aei_information12		=>	p_aei_information12,
		p_aei_information13		=>	p_aei_information13,
		p_aei_information14		=>	p_aei_information14,
		p_aei_information15		=>	p_aei_information15,
		p_aei_information16		=>	p_aei_information16,
		p_aei_information17		=>	p_aei_information17,
		p_aei_information18		=>	p_aei_information18,
		p_aei_information19		=>	p_aei_information19,
		p_aei_information20		=>	p_aei_information20,
		p_aei_information21		=>	p_aei_information21,
		p_aei_information22		=>	p_aei_information22,
		p_aei_information23		=>	p_aei_information23,
		p_aei_information24		=>	p_aei_information24,
		p_aei_information25		=>	p_aei_information25,
		p_aei_information26		=>	p_aei_information26,
		p_aei_information27		=>	p_aei_information27,
		p_aei_information28		=>	p_aei_information28,
		p_aei_information29		=>	p_aei_information29,
		p_aei_information30		=>	p_aei_information30,
		p_object_version_number		=>	p_object_version_number
		);

Line: 606


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

Line: 624


    ROLLBACK TO update_assignment_extra_info;

Line: 642


  ROLLBACK TO update_assignment_extra_info;

Line: 646


end update_assignment_extra_info;

Line: 653


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

Line: 668


  savepoint delete_assignment_extra_info;

Line: 673


	hr_assignment_extra_info_bk3.delete_assignment_extra_info_b
		(
			p_assignment_extra_info_id	=>	p_assignment_extra_info_id,
			p_object_version_number		=>	p_object_version_number
		);

Line: 681


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

Line: 701


	hr_assignment_extra_info_bk3.delete_assignment_extra_info_a
		(
			p_assignment_extra_info_id	=>	p_assignment_extra_info_id,
			p_object_version_number		=>	p_object_version_number
		);

Line: 709


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

Line: 727


    ROLLBACK TO delete_assignment_extra_info;

Line: 737


  ROLLBACK TO delete_assignment_extra_info;

Line: 741


end delete_assignment_extra_info;