APPS.IBW_MERGE_PVT SQL Statements

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

Line: 72

		UPDATE IBW_PAGE_VIEWS SET
				party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
        party_relationship_id =  DECODE(  party_relationship_id,p_from_fk_id,p_to_fk_id,  party_relationship_id),
	visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end, /* Bug 5624186*/
				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
				Where party_id = p_from_fk_id
                    OR party_relationship_id = p_from_fk_id ;

Line: 90

          fnd_message.set_token('DESC',' IBW_PAGE_VIEWS Rows updated :'||to_char(l_count)  );

Line: 191

		UPDATE IBW_SITE_VISITS SET
				party_id = DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id),
				visitant_id = case when visitant_id like 'p%' then 'p'||DECODE(party_id,p_from_fk_id,p_to_fk_id,party_id) else visitant_id end,  /* Bug 5624186*/
        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
				Where party_id = p_from_fk_id	;

Line: 206

          fnd_message.set_token('DESC',' IBW_SITE_VISITS Rows updated :'||to_char(l_count)  );