The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_preference(p_contact_preference_id IN NUMBER,
p_preference_code IN VARCHAR2,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
p_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
hz_contact_preference_v2pub.update_contact_preference(FND_API.G_TRUE,p_contact_preference_rec,p_object_version_number,x_return_status,x_msg_count,x_msg_data);
end update_preference;