APPS.AS_OPP_MERGE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 54

	   	   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;

Line: 67

	   	   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;

Line: 81

	   	   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;

Line: 95

	   	   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;

Line: 112

		   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;

Line: 125

		   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;

Line: 138

		   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;

Line: 151

		   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;

Line: 164

		   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;

Line: 177

		   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;

Line: 193

	   	   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;

Line: 206

	   	   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;

Line: 219

		   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;

Line: 235

		   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;

Line: 249

		   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;

Line: 263

		   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;

Line: 276

		   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;

Line: 289

		   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;

Line: 302

		   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;

Line: 317

		   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;

Line: 333

		   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;

Line: 348

		   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;