The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
ler_extra_info_id,
information_type,
ler_id,
request_id,
program_application_id,
program_id,
program_update_date,
lri_attribute_category,
lri_attribute1,
lri_attribute2,
lri_attribute3,
lri_attribute4,
lri_attribute5,
lri_attribute6,
lri_attribute7,
lri_attribute8,
lri_attribute9,
lri_attribute10,
lri_attribute11,
lri_attribute12,
lri_attribute13,
lri_attribute14,
lri_attribute15,
lri_attribute16,
lri_attribute17,
lri_attribute18,
lri_attribute19,
lri_attribute20,
lri_information_category,
lri_information1,
lri_information2,
lri_information3,
lri_information4,
lri_information5,
lri_information6,
lri_information7,
lri_information8,
lri_information9,
lri_information10,
lri_information11,
lri_information12,
lri_information13,
lri_information14,
lri_information15,
lri_information16,
lri_information17,
lri_information18,
lri_information19,
lri_information20,
lri_information21,
lri_information22,
lri_information23,
lri_information24,
lri_information25,
lri_information26,
lri_information27,
lri_information28,
lri_information29,
lri_information30,
object_version_number
from BEN_ler_extra_info
where ler_extra_info_id = p_ler_extra_info_id;
select ler_extra_info_id,
information_type,
ler_id,
request_id,
program_application_id,
program_id,
program_update_date,
lri_attribute_category,
lri_attribute1,
lri_attribute2,
lri_attribute3,
lri_attribute4,
lri_attribute5,
lri_attribute6,
lri_attribute7,
lri_attribute8,
lri_attribute9,
lri_attribute10,
lri_attribute11,
lri_attribute12,
lri_attribute13,
lri_attribute14,
lri_attribute15,
lri_attribute16,
lri_attribute17,
lri_attribute18,
lri_attribute19,
lri_attribute20,
lri_information_category,
lri_information1,
lri_information2,
lri_information3,
lri_information4,
lri_information5,
lri_information6,
lri_information7,
lri_information8,
lri_information9,
lri_information10,
lri_information11,
lri_information12,
lri_information13,
lri_information14,
lri_information15,
lri_information16,
lri_information17,
lri_information18,
lri_information19,
lri_information20,
lri_information21,
lri_information22,
lri_information23,
lri_information24,
lri_information25,
lri_information26,
lri_information27,
lri_information28,
lri_information29,
lri_information30,
object_version_number
from ben_ler_extra_info
where ler_extra_info_id = p_ler_extra_info_id
for update nowait;
p_program_update_date in date,
p_lri_attribute_category in varchar2,
p_lri_attribute1 in varchar2,
p_lri_attribute2 in varchar2,
p_lri_attribute3 in varchar2,
p_lri_attribute4 in varchar2,
p_lri_attribute5 in varchar2,
p_lri_attribute6 in varchar2,
p_lri_attribute7 in varchar2,
p_lri_attribute8 in varchar2,
p_lri_attribute9 in varchar2,
p_lri_attribute10 in varchar2,
p_lri_attribute11 in varchar2,
p_lri_attribute12 in varchar2,
p_lri_attribute13 in varchar2,
p_lri_attribute14 in varchar2,
p_lri_attribute15 in varchar2,
p_lri_attribute16 in varchar2,
p_lri_attribute17 in varchar2,
p_lri_attribute18 in varchar2,
p_lri_attribute19 in varchar2,
p_lri_attribute20 in varchar2,
p_lri_information_category in varchar2,
p_lri_information1 in varchar2,
p_lri_information2 in varchar2,
p_lri_information3 in varchar2,
p_lri_information4 in varchar2,
p_lri_information5 in varchar2,
p_lri_information6 in varchar2,
p_lri_information7 in varchar2,
p_lri_information8 in varchar2,
p_lri_information9 in varchar2,
p_lri_information10 in varchar2,
p_lri_information11 in varchar2,
p_lri_information12 in varchar2,
p_lri_information13 in varchar2,
p_lri_information14 in varchar2,
p_lri_information15 in varchar2,
p_lri_information16 in varchar2,
p_lri_information17 in varchar2,
p_lri_information18 in varchar2,
p_lri_information19 in varchar2,
p_lri_information20 in varchar2,
p_lri_information21 in varchar2,
p_lri_information22 in varchar2,
p_lri_information23 in varchar2,
p_lri_information24 in varchar2,
p_lri_information25 in varchar2,
p_lri_information26 in varchar2,
p_lri_information27 in varchar2,
p_lri_information28 in varchar2,
p_lri_information29 in varchar2,
p_lri_information30 in varchar2,
p_object_version_number in number
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.program_update_date := p_program_update_date;