The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
veh_repos_extra_info_id
,vehicle_repository_id
,information_type
,vrei_attribute_category
,vrei_attribute1
,vrei_attribute2
,vrei_attribute3
,vrei_attribute4
,vrei_attribute5
,vrei_attribute6
,vrei_attribute7
,vrei_attribute8
,vrei_attribute9
,vrei_attribute10
,vrei_attribute11
,vrei_attribute12
,vrei_attribute13
,vrei_attribute14
,vrei_attribute15
,vrei_attribute16
,vrei_attribute17
,vrei_attribute18
,vrei_attribute19
,vrei_attribute20
,vrei_information_category
,vrei_information1
,vrei_information2
,vrei_information3
,vrei_information4
,vrei_information5
,vrei_information6
,vrei_information7
,vrei_information8
,vrei_information9
,vrei_information10
,vrei_information11
,vrei_information12
,vrei_information13
,vrei_information14
,vrei_information15
,vrei_information16
,vrei_information17
,vrei_information18
,vrei_information19
,vrei_information20
,vrei_information21
,vrei_information22
,vrei_information23
,vrei_information24
,vrei_information25
,vrei_information26
,vrei_information27
,vrei_information28
,vrei_information29
,vrei_information30
,object_version_number
,request_id
,program_application_id
,program_id
,program_update_date
from pqp_veh_repos_extra_info
where veh_repos_extra_info_id = p_veh_repos_extra_info_id;
select
veh_repos_extra_info_id
,vehicle_repository_id
,information_type
,vrei_attribute_category
,vrei_attribute1
,vrei_attribute2
,vrei_attribute3
,vrei_attribute4
,vrei_attribute5
,vrei_attribute6
,vrei_attribute7
,vrei_attribute8
,vrei_attribute9
,vrei_attribute10
,vrei_attribute11
,vrei_attribute12
,vrei_attribute13
,vrei_attribute14
,vrei_attribute15
,vrei_attribute16
,vrei_attribute17
,vrei_attribute18
,vrei_attribute19
,vrei_attribute20
,vrei_information_category
,vrei_information1
,vrei_information2
,vrei_information3
,vrei_information4
,vrei_information5
,vrei_information6
,vrei_information7
,vrei_information8
,vrei_information9
,vrei_information10
,vrei_information11
,vrei_information12
,vrei_information13
,vrei_information14
,vrei_information15
,vrei_information16
,vrei_information17
,vrei_information18
,vrei_information19
,vrei_information20
,vrei_information21
,vrei_information22
,vrei_information23
,vrei_information24
,vrei_information25
,vrei_information26
,vrei_information27
,vrei_information28
,vrei_information29
,vrei_information30
,object_version_number
,request_id
,program_application_id
,program_id
,program_update_date
from pqp_veh_repos_extra_info
where veh_repos_extra_info_id = p_veh_repos_extra_info_id
for update nowait;
,p_program_update_date in date
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.program_update_date := p_program_update_date;