The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_qa_results(
p_from_vendor_id NUMBER,
p_to_vendor_id NUMBER) IS
BEGIN
--
-- Quality only stores vendor ID, not vendor site, nor party
-- therefore updating vendor ID only. This UPDATE statement
-- is potentially long running. The customer is advised to
-- create a custom index on QA_RESULTS.VENDOR_ID to make it
-- more performing if this operation is run frequently.
--
UPDATE qa_results
SET vendor_id = p_to_vendor_id
WHERE vendor_id = p_from_vendor_id;
END update_qa_results;
update_qa_results(
p_from_vendor_id => p_dup_vendor_id,
p_to_vendor_id => p_vendor_id);