APPS.PQH_ROLE_EXTRA_INFO_API SQL Statements

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

Line: 375

procedure update_role_extra_info
  (p_validate                     in     boolean
  ,p_role_extra_info_id            in     number
  ,p_object_version_number        in out nocopy number
  ,p_attribute_category       in     varchar2
  ,p_attribute1               in     varchar2
  ,p_attribute2               in     varchar2
  ,p_attribute3               in     varchar2
  ,p_attribute4               in     varchar2
  ,p_attribute5               in     varchar2
  ,p_attribute6               in     varchar2
  ,p_attribute7               in     varchar2
  ,p_attribute8               in     varchar2
  ,p_attribute9               in     varchar2
  ,p_attribute10              in     varchar2
  ,p_attribute11              in     varchar2
  ,p_attribute12              in     varchar2
  ,p_attribute13              in     varchar2
  ,p_attribute14              in     varchar2
  ,p_attribute15              in     varchar2
  ,p_attribute16              in     varchar2
  ,p_attribute17              in     varchar2
  ,p_attribute18              in     varchar2
  ,p_attribute19              in     varchar2
  ,p_attribute20              in     varchar2
  ,p_attribute21              in     varchar2
  ,p_attribute22              in     varchar2
  ,p_attribute23              in     varchar2
  ,p_attribute24              in     varchar2
  ,p_attribute25              in     varchar2
  ,p_attribute26              in     varchar2
  ,p_attribute27              in     varchar2
  ,p_attribute28              in     varchar2
  ,p_attribute29              in     varchar2
  ,p_attribute30              in     varchar2
  ,p_information_category     in     varchar2
  ,p_information1             in     varchar2
  ,p_information2             in     varchar2
  ,p_information3             in     varchar2
  ,p_information4             in     varchar2
  ,p_information5             in     varchar2
  ,p_information6             in     varchar2
  ,p_information7             in     varchar2
  ,p_information8             in     varchar2
  ,p_information9             in     varchar2
  ,p_information10            in     varchar2
  ,p_information11            in     varchar2
  ,p_information12            in     varchar2
  ,p_information13            in     varchar2
  ,p_information14            in     varchar2
  ,p_information15            in     varchar2
  ,p_information16            in     varchar2
  ,p_information17            in     varchar2
  ,p_information18            in     varchar2
  ,p_information19            in     varchar2
  ,p_information20            in     varchar2
  ,p_information21            in     varchar2
  ,p_information22            in     varchar2
  ,p_information23            in     varchar2
  ,p_information24            in     varchar2
  ,p_information25            in     varchar2
  ,p_information26            in     varchar2
  ,p_information27            in     varchar2
  ,p_information28            in     varchar2
  ,p_information29            in     varchar2
  ,p_information30            in     varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_role_extra_info';

Line: 453

  savepoint update_role_extra_info;

Line: 458

	pqh_role_extra_info_bk2.update_role_extra_info_b
		(
		p_role_extra_info_id	=>	p_role_extra_info_id,
		p_attribute_category	=>	p_attribute_category,
		p_attribute1		=>	p_attribute1,
		p_attribute2		=>	p_attribute2,
		p_attribute3		=>	p_attribute3,
		p_attribute4		=>	p_attribute4,
		p_attribute5		=>	p_attribute5,
		p_attribute6		=>	p_attribute6,
		p_attribute7		=>	p_attribute7,
		p_attribute8		=>	p_attribute8,
		p_attribute9		=>	p_attribute9,
		p_attribute10		=>	p_attribute10,
		p_attribute11		=>	p_attribute11,
		p_attribute12		=>	p_attribute12,
		p_attribute13		=>	p_attribute13,
		p_attribute14		=>	p_attribute14,
		p_attribute15		=>	p_attribute15,
		p_attribute16		=>	p_attribute16,
		p_attribute17		=>	p_attribute17,
		p_attribute18		=>	p_attribute18,
		p_attribute19		=>	p_attribute19,
		p_attribute20		=>	p_attribute20,
		p_attribute21		=>	p_attribute21,
		p_attribute22		=>	p_attribute22,
		p_attribute23		=>	p_attribute23,
		p_attribute24		=>	p_attribute24,
		p_attribute25		=>	p_attribute25,
		p_attribute26		=>	p_attribute26,
		p_attribute27		=>	p_attribute27,
		p_attribute28		=>	p_attribute28,
		p_attribute29		=>	p_attribute29,
		p_attribute30		=>	p_attribute30,
		p_information_category	=>	p_information_category,
		p_information1		=>	p_information1,
		p_information2		=>	p_information2,
		p_information3		=>	p_information3,
		p_information4		=>	p_information4,
		p_information5		=>	p_information5,
		p_information6		=>	p_information6,
		p_information7		=>	p_information7,
		p_information8		=>	p_information8,
		p_information9		=>	p_information9,
		p_information10		=>	p_information10,
		p_information11		=>	p_information11,
		p_information12		=>	p_information12,
		p_information13		=>	p_information13,
		p_information14		=>	p_information14,
		p_information15		=>	p_information15,
		p_information16		=>	p_information16,
		p_information17		=>	p_information17,
		p_information18		=>	p_information18,
		p_information19		=>	p_information19,
		p_information20		=>	p_information20,
		p_information21		=>	p_information21,
		p_information22		=>	p_information22,
		p_information23		=>	p_information23,
		p_information24		=>	p_information24,
		p_information25		=>	p_information25,
		p_information26		=>	p_information26,
		p_information27		=>	p_information27,
		p_information28		=>	p_information28,
		p_information29		=>	p_information29,
		p_information30		=>	p_information30,
		p_object_version_number		=>	p_object_version_number
		);

Line: 528

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

Line: 616

	pqh_role_extra_info_bk2.update_role_extra_info_a
		(
		p_role_extra_info_id		=>	p_role_extra_info_id,
		p_attribute_category	=>	p_attribute_category,
		p_attribute1		=>	p_attribute1,
		p_attribute2		=>	p_attribute2,
		p_attribute3		=>	p_attribute3,
		p_attribute4		=>	p_attribute4,
		p_attribute5		=>	p_attribute5,
		p_attribute6		=>	p_attribute6,
		p_attribute7		=>	p_attribute7,
		p_attribute8		=>	p_attribute8,
		p_attribute9		=>	p_attribute9,
		p_attribute10		=>	p_attribute10,
		p_attribute11		=>	p_attribute11,
		p_attribute12		=>	p_attribute12,
		p_attribute13		=>	p_attribute13,
		p_attribute14		=>	p_attribute14,
		p_attribute15		=>	p_attribute15,
		p_attribute16		=>	p_attribute16,
		p_attribute17		=>	p_attribute17,
		p_attribute18		=>	p_attribute18,
		p_attribute19		=>	p_attribute19,
		p_attribute20		=>	p_attribute20,
		p_attribute21		=>	p_attribute21,
		p_attribute22		=>	p_attribute22,
		p_attribute23		=>	p_attribute23,
		p_attribute24		=>	p_attribute24,
		p_attribute25		=>	p_attribute25,
		p_attribute26		=>	p_attribute26,
		p_attribute27		=>	p_attribute27,
		p_attribute28		=>	p_attribute28,
		p_attribute29		=>	p_attribute29,
		p_attribute30		=>	p_attribute30,
		p_information_category	=>	p_information_category,
		p_information1		=>	p_information1,
		p_information2		=>	p_information2,
		p_information3		=>	p_information3,
		p_information4		=>	p_information4,
		p_information5		=>	p_information5,
		p_information6		=>	p_information6,
		p_information7		=>	p_information7,
		p_information8		=>	p_information8,
		p_information9		=>	p_information9,
		p_information10		=>	p_information10,
		p_information11		=>	p_information11,
		p_information12		=>	p_information12,
		p_information13		=>	p_information13,
		p_information14		=>	p_information14,
		p_information15		=>	p_information15,
		p_information16		=>	p_information16,
		p_information17		=>	p_information17,
		p_information18		=>	p_information18,
		p_information19		=>	p_information19,
		p_information20		=>	p_information20,
		p_information21		=>	p_information21,
		p_information22		=>	p_information22,
		p_information23		=>	p_information23,
		p_information24		=>	p_information24,
		p_information25		=>	p_information25,
		p_information26		=>	p_information26,
		p_information27		=>	p_information27,
		p_information28		=>	p_information28,
		p_information29		=>	p_information29,
		p_information30		=>	p_information30,
		p_object_version_number		=>	p_object_version_number
		);

Line: 686

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

Line: 704

    ROLLBACK TO update_role_extra_info;

Line: 722

  ROLLBACK TO update_role_extra_info;

Line: 726

end update_role_extra_info;

Line: 733

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

Line: 748

  savepoint delete_role_extra_info;

Line: 753

	pqh_role_extra_info_bk3.delete_role_extra_info_b
		(
		p_role_extra_info_id		=>	p_role_extra_info_id,
		p_object_version_number		=>	p_object_version_number
		);

Line: 761

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

Line: 781

	pqh_role_extra_info_bk3.delete_role_extra_info_a
		(
		p_role_extra_info_id		=>	p_role_extra_info_id,
		p_object_version_number		=>	p_object_version_number
		);

Line: 789

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

Line: 807

    ROLLBACK TO delete_role_extra_info;

Line: 817

  ROLLBACK TO delete_role_extra_info;

Line: 821

end delete_role_extra_info;