APPS.OZF_VENDORMERGE_GRP SQL Statements

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

Line: 50

		UPDATE OZF_CLAIMS_ALL
		SET     vendor_id = p_vendor_id,
				vendor_site_id = p_vendor_site_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,
				program_application_id = hz_utility_pub.program_application_id,
				program_id = hz_utility_pub.program_id,
				program_update_date = sysdate
		WHERE   vendor_id = p_dup_vendor_id
				AND vendor_site_id = p_dup_vendor_site_id;

Line: 71

		FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

Line: 83

			UPDATE OZF_CLAIMS_HISTORY_ALL
			SET     vendor_id = p_vendor_id,
					vendor_site_id = p_vendor_site_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,
					program_application_id = hz_utility_pub.program_application_id,
					program_id = hz_utility_pub.program_id,
					program_update_date = sysdate
			WHERE   vendor_id = p_dup_vendor_id
					AND vendor_site_id = p_dup_vendor_site_id;

Line: 104

			FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

Line: 115

			UPDATE OZF_CLAIMS_INT_ALL
			SET     vendor_id = p_vendor_id,
					vendor_site_id = p_vendor_site_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,
					program_application_id = hz_utility_pub.program_application_id,
					program_id = hz_utility_pub.program_id,
					program_update_date = sysdate
			WHERE   vendor_id = p_dup_vendor_id
					AND vendor_site_id = p_dup_vendor_site_id;

Line: 136

			FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

Line: 147

			UPDATE OZF_CUST_TRD_PRFLS_ALL
			SET     vendor_id = p_vendor_id,
					vendor_site_id = p_vendor_site_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,
					program_application_id = hz_utility_pub.program_application_id,
					program_id = hz_utility_pub.program_id,
					program_update_date = sysdate
			WHERE   vendor_id = p_dup_vendor_id
					AND vendor_site_id = p_dup_vendor_site_id;

Line: 168

			FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);