The following lines contain the word 'select', 'insert', 'update' or 'delete':
update per_addresses
set address_line1 = l_kr_address
where person_id = p_person_id
and business_group_id = p_business_group_id
and address_id = p_address_id;
end update_address_line1_ai;
procedure update_address_line1_au(
p_address_id in number
,p_business_group_id_o in number
,p_person_id_o in number
,p_style_o in varchar2
,p_add_information17 in varchar2)
is
begin
update_address_line1_ai(p_address_id => p_address_id
,p_business_group_id => p_business_group_id_o
,p_person_id => p_person_id_o
,p_style => p_style_o
,p_add_information17 => p_add_information17);
end update_address_line1_au;
end per_kr_address_update_hook_pkg;