The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
document_extra_info_id
,person_id
,document_type_id
,document_number
,date_from
,date_to
,issued_by
,issued_at
,issued_date
,issuing_authority
,verified_by
,verified_date
,related_object_name
,related_object_id_col
,related_object_id
,dei_attribute_category
,dei_attribute1
,dei_attribute2
,dei_attribute3
,dei_attribute4
,dei_attribute5
,dei_attribute6
,dei_attribute7
,dei_attribute8
,dei_attribute9
,dei_attribute10
,dei_attribute11
,dei_attribute12
,dei_attribute13
,dei_attribute14
,dei_attribute15
,dei_attribute16
,dei_attribute17
,dei_attribute18
,dei_attribute19
,dei_attribute20
,dei_attribute21
,dei_attribute22
,dei_attribute23
,dei_attribute24
,dei_attribute25
,dei_attribute26
,dei_attribute27
,dei_attribute28
,dei_attribute29
,dei_attribute30
,dei_information_category
,dei_information1
,dei_information2
,dei_information3
,dei_information4
,dei_information5
,dei_information6
,dei_information7
,dei_information8
,dei_information9
,dei_information10
,dei_information11
,dei_information12
,dei_information13
,dei_information14
,dei_information15
,dei_information16
,dei_information17
,dei_information18
,dei_information19
,dei_information20
,dei_information21
,dei_information22
,dei_information23
,dei_information24
,dei_information25
,dei_information26
,dei_information27
,dei_information28
,dei_information29
,dei_information30
,request_id
,program_application_id
,program_id
,program_update_date
,object_version_number
from hr_document_extra_info
where document_extra_info_id = p_document_extra_info_id;
select
document_extra_info_id
,person_id
,document_type_id
,document_number
,date_from
,date_to
,issued_by
,issued_at
,issued_date
,issuing_authority
,verified_by
,verified_date
,related_object_name
,related_object_id_col
,related_object_id
,dei_attribute_category
,dei_attribute1
,dei_attribute2
,dei_attribute3
,dei_attribute4
,dei_attribute5
,dei_attribute6
,dei_attribute7
,dei_attribute8
,dei_attribute9
,dei_attribute10
,dei_attribute11
,dei_attribute12
,dei_attribute13
,dei_attribute14
,dei_attribute15
,dei_attribute16
,dei_attribute17
,dei_attribute18
,dei_attribute19
,dei_attribute20
,dei_attribute21
,dei_attribute22
,dei_attribute23
,dei_attribute24
,dei_attribute25
,dei_attribute26
,dei_attribute27
,dei_attribute28
,dei_attribute29
,dei_attribute30
,dei_information_category
,dei_information1
,dei_information2
,dei_information3
,dei_information4
,dei_information5
,dei_information6
,dei_information7
,dei_information8
,dei_information9
,dei_information10
,dei_information11
,dei_information12
,dei_information13
,dei_information14
,dei_information15
,dei_information16
,dei_information17
,dei_information18
,dei_information19
,dei_information20
,dei_information21
,dei_information22
,dei_information23
,dei_information24
,dei_information25
,dei_information26
,dei_information27
,dei_information28
,dei_information29
,dei_information30
,request_id
,program_application_id
,program_id
,program_update_date
,object_version_number
from hr_document_extra_info
where document_extra_info_id = p_document_extra_info_id
for update nowait;
,p_program_update_date in date
,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;