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

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

Line: 338


procedure update_pgm_extra_info
  (p_validate                     in     boolean  default false
  ,p_pgm_extra_info_id            in     number
  ,p_object_version_number        in out nocopy number
  ,p_pgi_attribute_category       in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute1               in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute2               in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute3               in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute4               in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute5               in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute6               in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute7               in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute8               in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute9               in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute10              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute11              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute12              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute13              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute14              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute15              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute16              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute17              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute18              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute19              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_attribute20              in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information_category     in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information1             in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information2             in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information3             in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information4             in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information5             in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information6             in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information7             in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information8             in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information9             in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information10            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information11            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information12            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information13            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information14            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information15            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information16            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information17            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information18            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information19            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information20            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information21            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information22            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information23            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information24            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information25            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information26            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information27            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information28            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information29            in     varchar2 default hr_api.g_varchar2
  ,p_pgi_information30            in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_pgm_extra_info';

Line: 407


  savepoint update_pgm_extra_info;

Line: 412


	ben_pgm_extra_info_bk2.update_pgm_extra_info_b
		(
		p_pgm_extra_info_id		=>	p_pgm_extra_info_id,
		p_pgi_attribute_category	=>	p_pgi_attribute_category,
		p_pgi_attribute1		=>	p_pgi_attribute1,
		p_pgi_attribute2		=>	p_pgi_attribute2,
		p_pgi_attribute3		=>	p_pgi_attribute3,
		p_pgi_attribute4		=>	p_pgi_attribute4,
		p_pgi_attribute5		=>	p_pgi_attribute5,
		p_pgi_attribute6		=>	p_pgi_attribute6,
		p_pgi_attribute7		=>	p_pgi_attribute7,
		p_pgi_attribute8		=>	p_pgi_attribute8,
		p_pgi_attribute9		=>	p_pgi_attribute9,
		p_pgi_attribute10		=>	p_pgi_attribute10,
		p_pgi_attribute11		=>	p_pgi_attribute11,
		p_pgi_attribute12		=>	p_pgi_attribute12,
		p_pgi_attribute13		=>	p_pgi_attribute13,
		p_pgi_attribute14		=>	p_pgi_attribute14,
		p_pgi_attribute15		=>	p_pgi_attribute15,
		p_pgi_attribute16		=>	p_pgi_attribute16,
		p_pgi_attribute17		=>	p_pgi_attribute17,
		p_pgi_attribute18		=>	p_pgi_attribute18,
		p_pgi_attribute19		=>	p_pgi_attribute19,
		p_pgi_attribute20		=>	p_pgi_attribute20,
		p_pgi_information_category	=>	p_pgi_information_category,
		p_pgi_information1		=>	p_pgi_information1,
		p_pgi_information2		=>	p_pgi_information2,
		p_pgi_information3		=>	p_pgi_information3,
		p_pgi_information4		=>	p_pgi_information4,
		p_pgi_information5		=>	p_pgi_information5,
		p_pgi_information6		=>	p_pgi_information6,
		p_pgi_information7		=>	p_pgi_information7,
		p_pgi_information8		=>	p_pgi_information8,
		p_pgi_information9		=>	p_pgi_information9,
		p_pgi_information10		=>	p_pgi_information10,
		p_pgi_information11		=>	p_pgi_information11,
		p_pgi_information12		=>	p_pgi_information12,
		p_pgi_information13		=>	p_pgi_information13,
		p_pgi_information14		=>	p_pgi_information14,
		p_pgi_information15		=>	p_pgi_information15,
		p_pgi_information16		=>	p_pgi_information16,
		p_pgi_information17		=>	p_pgi_information17,
		p_pgi_information18		=>	p_pgi_information18,
		p_pgi_information19		=>	p_pgi_information19,
		p_pgi_information20		=>	p_pgi_information20,
		p_pgi_information21		=>	p_pgi_information21,
		p_pgi_information22		=>	p_pgi_information22,
		p_pgi_information23		=>	p_pgi_information23,
		p_pgi_information24		=>	p_pgi_information24,
		p_pgi_information25		=>	p_pgi_information25,
		p_pgi_information26		=>	p_pgi_information26,
		p_pgi_information27		=>	p_pgi_information27,
		p_pgi_information28		=>	p_pgi_information28,
		p_pgi_information29		=>	p_pgi_information29,
		p_pgi_information30		=>	p_pgi_information30,
		p_object_version_number		=>	p_object_version_number
		);

Line: 472


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

Line: 550


	ben_pgm_extra_info_bk2.update_pgm_extra_info_a
		(
		p_pgm_extra_info_id		=>	p_pgm_extra_info_id,
		p_pgi_attribute_category	=>	p_pgi_attribute_category,
		p_pgi_attribute1		=>	p_pgi_attribute1,
		p_pgi_attribute2		=>	p_pgi_attribute2,
		p_pgi_attribute3		=>	p_pgi_attribute3,
		p_pgi_attribute4		=>	p_pgi_attribute4,
		p_pgi_attribute5		=>	p_pgi_attribute5,
		p_pgi_attribute6		=>	p_pgi_attribute6,
		p_pgi_attribute7		=>	p_pgi_attribute7,
		p_pgi_attribute8		=>	p_pgi_attribute8,
		p_pgi_attribute9		=>	p_pgi_attribute9,
		p_pgi_attribute10		=>	p_pgi_attribute10,
		p_pgi_attribute11		=>	p_pgi_attribute11,
		p_pgi_attribute12		=>	p_pgi_attribute12,
		p_pgi_attribute13		=>	p_pgi_attribute13,
		p_pgi_attribute14		=>	p_pgi_attribute14,
		p_pgi_attribute15		=>	p_pgi_attribute15,
		p_pgi_attribute16		=>	p_pgi_attribute16,
		p_pgi_attribute17		=>	p_pgi_attribute17,
		p_pgi_attribute18		=>	p_pgi_attribute18,
		p_pgi_attribute19		=>	p_pgi_attribute19,
		p_pgi_attribute20		=>	p_pgi_attribute20,
		p_pgi_information_category	=>	p_pgi_information_category,
		p_pgi_information1		=>	p_pgi_information1,
		p_pgi_information2		=>	p_pgi_information2,
		p_pgi_information3		=>	p_pgi_information3,
		p_pgi_information4		=>	p_pgi_information4,
		p_pgi_information5		=>	p_pgi_information5,
		p_pgi_information6		=>	p_pgi_information6,
		p_pgi_information7		=>	p_pgi_information7,
		p_pgi_information8		=>	p_pgi_information8,
		p_pgi_information9		=>	p_pgi_information9,
		p_pgi_information10		=>	p_pgi_information10,
		p_pgi_information11		=>	p_pgi_information11,
		p_pgi_information12		=>	p_pgi_information12,
		p_pgi_information13		=>	p_pgi_information13,
		p_pgi_information14		=>	p_pgi_information14,
		p_pgi_information15		=>	p_pgi_information15,
		p_pgi_information16		=>	p_pgi_information16,
		p_pgi_information17		=>	p_pgi_information17,
		p_pgi_information18		=>	p_pgi_information18,
		p_pgi_information19		=>	p_pgi_information19,
		p_pgi_information20		=>	p_pgi_information20,
		p_pgi_information21		=>	p_pgi_information21,
		p_pgi_information22		=>	p_pgi_information22,
		p_pgi_information23		=>	p_pgi_information23,
		p_pgi_information24		=>	p_pgi_information24,
		p_pgi_information25		=>	p_pgi_information25,
		p_pgi_information26		=>	p_pgi_information26,
		p_pgi_information27		=>	p_pgi_information27,
		p_pgi_information28		=>	p_pgi_information28,
		p_pgi_information29		=>	p_pgi_information29,
		p_pgi_information30		=>	p_pgi_information30,
		p_object_version_number		=>	p_object_version_number
		);

Line: 610


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

Line: 628


    ROLLBACK TO update_pgm_extra_info;

Line: 644


  ROLLBACK TO update_pgm_extra_info;

Line: 652


end update_pgm_extra_info;

Line: 659


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

Line: 674


  savepoint delete_pgm_extra_info;

Line: 679


	ben_pgm_extra_info_bk3.delete_pgm_extra_info_b
		(
		p_pgm_extra_info_id		=>	p_pgm_extra_info_id,
		p_object_version_number		=>	p_object_version_number
		);

Line: 687


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

Line: 707


	ben_pgm_extra_info_bk3.delete_pgm_extra_info_a
		(
		p_pgm_extra_info_id		=>	p_pgm_extra_info_id,
		p_object_version_number		=>	p_object_version_number
		);

Line: 715


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

Line: 733


    ROLLBACK TO delete_pgm_extra_info;

Line: 743


  ROLLBACK TO delete_pgm_extra_info;

Line: 747


end delete_pgm_extra_info;