DBA Data[Home] [Help]

APPS.PER_JOB_EXTRA_INFO_API SQL Statements

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

Line: 337

procedure update_job_extra_info
  (p_validate                     in     boolean  default false
  ,p_job_extra_info_id            in     number
  ,p_object_version_number        in out nocopy number
  ,p_jei_attribute_category       in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute1               in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute2               in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute3               in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute4               in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute5               in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute6               in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute7               in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute8               in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute9               in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute10              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute11              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute12              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute13              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute14              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute15              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute16              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute17              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute18              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute19              in     varchar2 default hr_api.g_varchar2
  ,p_jei_attribute20              in     varchar2 default hr_api.g_varchar2
  ,p_jei_information_category     in     varchar2 default hr_api.g_varchar2
  ,p_jei_information1             in     varchar2 default hr_api.g_varchar2
  ,p_jei_information2             in     varchar2 default hr_api.g_varchar2
  ,p_jei_information3             in     varchar2 default hr_api.g_varchar2
  ,p_jei_information4             in     varchar2 default hr_api.g_varchar2
  ,p_jei_information5             in     varchar2 default hr_api.g_varchar2
  ,p_jei_information6             in     varchar2 default hr_api.g_varchar2
  ,p_jei_information7             in     varchar2 default hr_api.g_varchar2
  ,p_jei_information8             in     varchar2 default hr_api.g_varchar2
  ,p_jei_information9             in     varchar2 default hr_api.g_varchar2
  ,p_jei_information10            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information11            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information12            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information13            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information14            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information15            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information16            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information17            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information18            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information19            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information20            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information21            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information22            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information23            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information24            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information25            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information26            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information27            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information28            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information29            in     varchar2 default hr_api.g_varchar2
  ,p_jei_information30            in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_job_extra_info';
Line: 406

  savepoint update_job_extra_info;
Line: 411

	per_job_extra_info_bk2.update_job_extra_info_b
		(
		p_job_extra_info_id		=>	p_job_extra_info_id,
		p_jei_attribute_category	=>	p_jei_attribute_category,
		p_jei_attribute1		=>	p_jei_attribute1,
		p_jei_attribute2		=>	p_jei_attribute2,
		p_jei_attribute3		=>	p_jei_attribute3,
		p_jei_attribute4		=>	p_jei_attribute4,
		p_jei_attribute5		=>	p_jei_attribute5,
		p_jei_attribute6		=>	p_jei_attribute6,
		p_jei_attribute7		=>	p_jei_attribute7,
		p_jei_attribute8		=>	p_jei_attribute8,
		p_jei_attribute9		=>	p_jei_attribute9,
		p_jei_attribute10		=>	p_jei_attribute10,
		p_jei_attribute11		=>	p_jei_attribute11,
		p_jei_attribute12		=>	p_jei_attribute12,
		p_jei_attribute13		=>	p_jei_attribute13,
		p_jei_attribute14		=>	p_jei_attribute14,
		p_jei_attribute15		=>	p_jei_attribute15,
		p_jei_attribute16		=>	p_jei_attribute16,
		p_jei_attribute17		=>	p_jei_attribute17,
		p_jei_attribute18		=>	p_jei_attribute18,
		p_jei_attribute19		=>	p_jei_attribute19,
		p_jei_attribute20		=>	p_jei_attribute20,
		p_jei_information_category	=>	p_jei_information_category,
		p_jei_information1		=>	p_jei_information1,
		p_jei_information2		=>	p_jei_information2,
		p_jei_information3		=>	p_jei_information3,
		p_jei_information4		=>	p_jei_information4,
		p_jei_information5		=>	p_jei_information5,
		p_jei_information6		=>	p_jei_information6,
		p_jei_information7		=>	p_jei_information7,
		p_jei_information8		=>	p_jei_information8,
		p_jei_information9		=>	p_jei_information9,
		p_jei_information10		=>	p_jei_information10,
		p_jei_information11		=>	p_jei_information11,
		p_jei_information12		=>	p_jei_information12,
		p_jei_information13		=>	p_jei_information13,
		p_jei_information14		=>	p_jei_information14,
		p_jei_information15		=>	p_jei_information15,
		p_jei_information16		=>	p_jei_information16,
		p_jei_information17		=>	p_jei_information17,
		p_jei_information18		=>	p_jei_information18,
		p_jei_information19		=>	p_jei_information19,
		p_jei_information20		=>	p_jei_information20,
		p_jei_information21		=>	p_jei_information21,
		p_jei_information22		=>	p_jei_information22,
		p_jei_information23		=>	p_jei_information23,
		p_jei_information24		=>	p_jei_information24,
		p_jei_information25		=>	p_jei_information25,
		p_jei_information26		=>	p_jei_information26,
		p_jei_information27		=>	p_jei_information27,
		p_jei_information28		=>	p_jei_information28,
		p_jei_information29		=>	p_jei_information29,
		p_jei_information30		=>	p_jei_information30,
		p_object_version_number		=>	p_object_version_number
		);
Line: 471

				(p_module_name	=> 'update_job_extra_info',
				 p_hook_type	=> 'BP'
				);
Line: 549

	per_job_extra_info_bk2.update_job_extra_info_a
		(
		p_job_extra_info_id		=>	p_job_extra_info_id,
		p_jei_attribute_category	=>	p_jei_attribute_category,
		p_jei_attribute1		=>	p_jei_attribute1,
		p_jei_attribute2		=>	p_jei_attribute2,
		p_jei_attribute3		=>	p_jei_attribute3,
		p_jei_attribute4		=>	p_jei_attribute4,
		p_jei_attribute5		=>	p_jei_attribute5,
		p_jei_attribute6		=>	p_jei_attribute6,
		p_jei_attribute7		=>	p_jei_attribute7,
		p_jei_attribute8		=>	p_jei_attribute8,
		p_jei_attribute9		=>	p_jei_attribute9,
		p_jei_attribute10		=>	p_jei_attribute10,
		p_jei_attribute11		=>	p_jei_attribute11,
		p_jei_attribute12		=>	p_jei_attribute12,
		p_jei_attribute13		=>	p_jei_attribute13,
		p_jei_attribute14		=>	p_jei_attribute14,
		p_jei_attribute15		=>	p_jei_attribute15,
		p_jei_attribute16		=>	p_jei_attribute16,
		p_jei_attribute17		=>	p_jei_attribute17,
		p_jei_attribute18		=>	p_jei_attribute18,
		p_jei_attribute19		=>	p_jei_attribute19,
		p_jei_attribute20		=>	p_jei_attribute20,
		p_jei_information_category	=>	p_jei_information_category,
		p_jei_information1		=>	p_jei_information1,
		p_jei_information2		=>	p_jei_information2,
		p_jei_information3		=>	p_jei_information3,
		p_jei_information4		=>	p_jei_information4,
		p_jei_information5		=>	p_jei_information5,
		p_jei_information6		=>	p_jei_information6,
		p_jei_information7		=>	p_jei_information7,
		p_jei_information8		=>	p_jei_information8,
		p_jei_information9		=>	p_jei_information9,
		p_jei_information10		=>	p_jei_information10,
		p_jei_information11		=>	p_jei_information11,
		p_jei_information12		=>	p_jei_information12,
		p_jei_information13		=>	p_jei_information13,
		p_jei_information14		=>	p_jei_information14,
		p_jei_information15		=>	p_jei_information15,
		p_jei_information16		=>	p_jei_information16,
		p_jei_information17		=>	p_jei_information17,
		p_jei_information18		=>	p_jei_information18,
		p_jei_information19		=>	p_jei_information19,
		p_jei_information20		=>	p_jei_information20,
		p_jei_information21		=>	p_jei_information21,
		p_jei_information22		=>	p_jei_information22,
		p_jei_information23		=>	p_jei_information23,
		p_jei_information24		=>	p_jei_information24,
		p_jei_information25		=>	p_jei_information25,
		p_jei_information26		=>	p_jei_information26,
		p_jei_information27		=>	p_jei_information27,
		p_jei_information28		=>	p_jei_information28,
		p_jei_information29		=>	p_jei_information29,
		p_jei_information30		=>	p_jei_information30,
		p_object_version_number		=>	p_object_version_number
		);
Line: 609

				(p_module_name	=> 'update_job_extra_info',
				 p_hook_type	=> 'AP'
				);
Line: 627

    ROLLBACK TO update_job_extra_info;
Line: 643

  ROLLBACK TO update_job_extra_info;
Line: 651

end update_job_extra_info;
Line: 658

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

  savepoint delete_job_extra_info;
Line: 678

	per_job_extra_info_bk3.delete_job_extra_info_b
		(
		p_job_extra_info_id		=>	p_job_extra_info_id,
		p_object_version_number		=>	p_object_version_number
		);
Line: 686

				(p_module_name	=> 'delete_job_extra_info',
				 p_hook_type	=> 'BP'
				);
Line: 706

	per_job_extra_info_bk3.delete_job_extra_info_a
		(
		p_job_extra_info_id		=>	p_job_extra_info_id,
		p_object_version_number		=>	p_object_version_number
		);
Line: 714

				(p_module_name	=> 'delete_job_extra_info',
				 p_hook_type	=> 'AP'
				);
Line: 732

    ROLLBACK TO delete_job_extra_info;
Line: 742

  ROLLBACK TO delete_job_extra_info;
Line: 746

end delete_job_extra_info;