APPS.GHR_PERSON_EXTRA_INFO_API SQL Statements

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

Line: 154

  ghr_history_api.post_update_process;

Line: 190

procedure update_person_extra_info
  (p_validate                      in     boolean  default false
  ,p_person_extra_info_id          in     number
  ,p_object_version_number         in out NOCOPY number
  ,p_effective_date                in     date
  ,p_pei_attribute_category        in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute1                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute2                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute3                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute4                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute5                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute6                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute7                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute8                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute9                in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute10               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute11               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute12               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute13               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute14               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute15               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute16               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute17               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute18               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute19               in     varchar2 default hr_api.g_varchar2
  ,p_pei_attribute20               in     varchar2 default hr_api.g_varchar2
  ,p_pei_information_category      in     varchar2 default hr_api.g_varchar2
  ,p_pei_information1              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information2              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information3              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information4              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information5              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information6              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information7              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information8              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information9              in     varchar2 default hr_api.g_varchar2
  ,p_pei_information10             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information11             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information12             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information13             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information14             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information15             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information16             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information17             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information18             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information19             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information20             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information21             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information22             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information23             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information24             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information25             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information26             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information27             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information28             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information29             in     varchar2 default hr_api.g_varchar2
  ,p_pei_information30             in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_person_extra_info';

Line: 259

    savepoint ghr_update_person_extra_info;

Line: 265

  hr_person_extra_info_api.update_person_extra_info
		(
		p_person_extra_info_id		=>	p_person_extra_info_id	,
            p_pei_attribute_category	=>	p_pei_attribute_category,
		p_pei_attribute1			=>	p_pei_attribute1		,
		p_pei_attribute2			=>	p_pei_attribute2		,
		p_pei_attribute3			=>	p_pei_attribute3		,
		p_pei_attribute4			=>	p_pei_attribute4		,
		p_pei_attribute5			=>	p_pei_attribute5		,
		p_pei_attribute6			=>	p_pei_attribute6		,
		p_pei_attribute7			=>	p_pei_attribute7		,
		p_pei_attribute8			=>	p_pei_attribute8		,
		p_pei_attribute9			=>	p_pei_attribute9		,
		p_pei_attribute10			=>	p_pei_attribute10		,
		p_pei_attribute11			=>	p_pei_attribute11		,
		p_pei_attribute12			=>	p_pei_attribute12		,
		p_pei_attribute13			=>	p_pei_attribute13		,
		p_pei_attribute14			=>	p_pei_attribute14		,
		p_pei_attribute15			=>	p_pei_attribute15		,
		p_pei_attribute16			=>	p_pei_attribute16		,
		p_pei_attribute17			=>	p_pei_attribute17		,
		p_pei_attribute18			=>	p_pei_attribute18		,
		p_pei_attribute19			=>	p_pei_attribute19		,
		p_pei_attribute20			=>	p_pei_attribute20		,
		p_pei_information_category	=>	p_pei_information_category	,
		p_pei_information1		=>	p_pei_information1	,
		p_pei_information2		=>	p_pei_information2	,
		p_pei_information3		=>	p_pei_information3	,
		p_pei_information4		=>	p_pei_information4	,
		p_pei_information5		=>	p_pei_information5	,
		p_pei_information6		=>	p_pei_information6	,
		p_pei_information7		=>	p_pei_information7	,
		p_pei_information8		=>	p_pei_information8	,
		p_pei_information9		=>	p_pei_information9	,
		p_pei_information10		=>	p_pei_information10	,
		p_pei_information11		=>	p_pei_information11	,
		p_pei_information12		=>	p_pei_information12	,
		p_pei_information13		=>	p_pei_information13	,
		p_pei_information14		=>	p_pei_information14	,
		p_pei_information15		=>	p_pei_information15	,
		p_pei_information16		=>	p_pei_information16	,
		p_pei_information17		=>	p_pei_information17	,
		p_pei_information18		=>	p_pei_information18	,
		p_pei_information19		=>	p_pei_information19	,
		p_pei_information20		=>	p_pei_information20	,
		p_pei_information21		=>	p_pei_information21	,
		p_pei_information22		=>	p_pei_information22	,
		p_pei_information23		=>	p_pei_information23	,
		p_pei_information24		=>	p_pei_information24	,
		p_pei_information25		=>	p_pei_information25	,
		p_pei_information26		=>	p_pei_information26	,
		p_pei_information27		=>	p_pei_information27	,
		p_pei_information28		=>	p_pei_information28	,
		p_pei_information29		=>	p_pei_information29	,
		p_pei_information30		=>	p_pei_information30	,
		p_object_version_number		=>	p_object_version_number
		);

Line: 326

  ghr_history_api.post_update_process;

Line: 339

    ROLLBACK TO ghr_update_person_extra_info;

Line: 349

    ROLLBACK TO ghr_update_person_extra_info;

Line: 351

end update_person_extra_info;