The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
offer_id
,offer_version
,latest_offer
,offer_status
,discretionary_job_title
,offer_extended_method
,respondent_id
,expiry_date
,proposed_start_date
,offer_letter_tracking_code
,offer_postal_service
,offer_shipping_date
,vacancy_id
,applicant_assignment_id
,offer_assignment_id
,address_id
,template_id
,offer_letter_file_type
,offer_letter_file_name
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
from irc_offers
where offer_id = p_offer_id;
select
offer_id
,offer_version
,latest_offer
,offer_status
,discretionary_job_title
,offer_extended_method
,respondent_id
,expiry_date
,proposed_start_date
,offer_letter_tracking_code
,offer_postal_service
,offer_shipping_date
,vacancy_id
,applicant_assignment_id
,offer_assignment_id
,address_id
,template_id
,offer_letter_file_type
,offer_letter_file_name
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
from irc_offers
where offer_id = p_offer_id
for update nowait;
update irc_offers
set offer_letter = p_offer_letter
where offer_id = p_offer_id;