APPS.GHR_POSITION_EXTRA_INFO_API SQL Statements

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

Line: 82

    SELECT business_group_id
    FROM   per_positions
    WHERE  position_id = p_position_id;

Line: 175

    ghr_history_api.post_update_process;

Line: 218

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_effective_date                 in     date
  ,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: 285

    SELECT pos.business_group_id
    FROM   per_positions pos, per_position_extra_info poi
    WHERE  pos.position_id = poi.position_id
    AND    poi.position_extra_info_id = p_position_extra_info_id;

Line: 296

    savepoint ghr_update_position_extra_info;

Line: 319

	hr_position_extra_info_api.update_position_extra_info
		(
		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: 379

    ghr_history_api.post_update_process;

Line: 395

    ROLLBACK TO ghr_update_position_extra_info;

Line: 405

   ROLLBACK TO ghr_update_position_extra_info;

Line: 412

end update_position_extra_info;