The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
address_id,
business_group_id,
person_id,
date_from,
primary_flag,
style,
address_line1,
address_line2,
address_line3,
address_type,
comments,
country,
date_to,
postal_code,
region_1,
region_2,
region_3,
telephone_number_1,
telephone_number_2,
telephone_number_3,
town_or_city,
request_id,
program_application_id,
program_id,
program_update_date,
addr_attribute_category,
addr_attribute1,
addr_attribute2,
addr_attribute3,
addr_attribute4,
addr_attribute5,
addr_attribute6,
addr_attribute7,
addr_attribute8,
addr_attribute9,
addr_attribute10,
addr_attribute11,
addr_attribute12,
addr_attribute13,
addr_attribute14,
addr_attribute15,
addr_attribute16,
addr_attribute17,
addr_attribute18,
addr_attribute19,
addr_attribute20,
object_version_number
from per_addresses
where address_id = p_address_id;
select address_id,
business_group_id,
person_id,
date_from,
primary_flag,
style,
address_line1,
address_line2,
address_line3,
address_type,
comments,
country,
date_to,
postal_code,
region_1,
region_2,
region_3,
telephone_number_1,
telephone_number_2,
telephone_number_3,
town_or_city,
request_id,
program_application_id,
program_id,
program_update_date,
addr_attribute_category,
addr_attribute1,
addr_attribute2,
addr_attribute3,
addr_attribute4,
addr_attribute5,
addr_attribute6,
addr_attribute7,
addr_attribute8,
addr_attribute9,
addr_attribute10,
addr_attribute11,
addr_attribute12,
addr_attribute13,
addr_attribute14,
addr_attribute15,
addr_attribute16,
addr_attribute17,
addr_attribute18,
addr_attribute19,
addr_attribute20,
object_version_number
from per_addresses
where address_id = p_address_id
for update nowait;
p_program_update_date in date,
p_addr_attribute_category in varchar2,
p_addr_attribute1 in varchar2,
p_addr_attribute2 in varchar2,
p_addr_attribute3 in varchar2,
p_addr_attribute4 in varchar2,
p_addr_attribute5 in varchar2,
p_addr_attribute6 in varchar2,
p_addr_attribute7 in varchar2,
p_addr_attribute8 in varchar2,
p_addr_attribute9 in varchar2,
p_addr_attribute10 in varchar2,
p_addr_attribute11 in varchar2,
p_addr_attribute12 in varchar2,
p_addr_attribute13 in varchar2,
p_addr_attribute14 in varchar2,
p_addr_attribute15 in varchar2,
p_addr_attribute16 in varchar2,
p_addr_attribute17 in varchar2,
p_addr_attribute18 in varchar2,
p_addr_attribute19 in varchar2,
p_addr_attribute20 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;