DBA Data[Home] [Help]

APPS.GHR_ASSIGNMENT_EXTRA_INFO_API SQL Statements

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

Line: 156

  ghr_history_api.post_update_process;
Line: 194

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

    savepoint ghr_update_asg_extra_info;
Line: 273

	hr_assignment_extra_info_api.update_assignment_extra_info
		(
		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: 335

  ghr_history_api.post_update_process;
Line: 349

    ROLLBACK TO ghr_update_asg_extra_info;
Line: 359

    ROLLBACK TO ghr_update_asg_extra_info;
Line: 361

end update_assignment_extra_info;