The following lines contain the word 'select', 'insert', 'update' or 'delete':
select merge_reason_code into l_merge_reason_code
from HZ_MERGE_BATCH
where batch_id = p_batch_id;
UPDATE AS_LEADS_ALL
set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where customer_id = p_from_fk_id;
UPDATE AS_LEADS_ALL
set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where close_competitor_id = p_from_fk_id;
UPDATE AS_LEADS_ALL
set object_version_number = nvl(object_version_number,0) + 1, end_user_customer_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where end_user_customer_id = p_from_fk_id;
UPDATE AS_LEADS_ALL
set object_version_number = nvl(object_version_number,0) + 1, incumbent_partner_party_id = p_to_fk_id,
incumbent_partner_resource_id=( select resource_id
from jtf_rs_resource_extns
where category = 'PARTNER'
and source_id = p_to_fk_id),
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where incumbent_partner_party_id = p_from_fk_id;
UPDATE AS_LEAD_COMPETITORS
set object_version_number = nvl(object_version_number,0) + 1, competitor_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where competitor_id = p_from_fk_id;
UPDATE AS_LEAD_CONTACTS_ALL
set object_version_number = nvl(object_version_number,0) + 1, contact_party_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where contact_party_id = p_from_fk_id;
UPDATE AS_LEAD_CONTACTS_ALL
set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where customer_id = p_from_fk_id;
UPDATE AS_SALES_CREDITS
set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where partner_customer_id = p_from_fk_id;
UPDATE AS_SALES_CREDITS_DENORM
set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where partner_customer_id = p_from_fk_id;
UPDATE AS_SALES_CREDITS_DENORM
set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where customer_id = p_from_fk_id;
UPDATE AS_LEADS_LOG
set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id
--last_update_date = hz_utility_pub.last_update_date,
--last_updated_by = hz_utility_pub.user_id,
--last_update_login = hz_utility_pub.last_update_login
--request_id = hz_utility_pub.request_id,
--program_application_id = hz_utility_pub.program_application_id,
--program_id = hz_utility_pub.program_id,
--program_update_date = sysdate
where customer_id = p_from_fk_id;
UPDATE AS_LEADS_LOG
set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id
--last_update_date = hz_utility_pub.last_update_date,
--last_updated_by = hz_utility_pub.user_id,
--last_update_login = hz_utility_pub.last_update_login,
--request_id = hz_utility_pub.request_id,
--program_application_id = hz_utility_pub.program_application_id,
--program_id = hz_utility_pub.program_id,
--program_update_date = sysdate
where close_competitor_id = p_from_fk_id;
UPDATE AS_SALES_CREDITS_DENORM
set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where close_competitor_id = p_from_fk_id;
UPDATE AS_LEADS_ALL
set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where address_id = p_from_fk_id;
UPDATE AS_LEADS_ALL
set object_version_number = nvl(object_version_number,0) + 1, end_user_address_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where end_user_address_id = p_from_fk_id;
UPDATE AS_LEAD_CONTACTS_ALL
set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where address_id = p_from_fk_id;
UPDATE AS_SALES_CREDITS
set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where partner_address_id = p_from_fk_id;
UPDATE AS_SALES_CREDITS_DENORM
set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where partner_address_id = p_from_fk_id;
UPDATE AS_SALES_CREDITS_DENORM
set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where address_id = p_from_fk_id;
UPDATE AS_LEADS_LOG
set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id
--last_update_date = hz_utility_pub.last_update_date,
--last_updated_by = hz_utility_pub.user_id,
--last_update_login = hz_utility_pub.last_update_login,
--request_id = hz_utility_pub.request_id,
--program_application_id = hz_utility_pub.program_application_id,
--program_id = hz_utility_pub.program_id,
--program_update_date = sysdate
where address_id = p_from_fk_id;
UPDATE AS_LEAD_CONTACTS_ALL
set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where contact_id = p_from_fk_id;
UPDATE AS_LEAD_CONTACTS_ALL
set object_version_number = nvl(object_version_number,0) + 1, phone_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
where phone_id = p_from_fk_id;