   counting RECORD;
 BEGIN
   -- recupération de l'id_source
-  SELECT INTO the_id_source id_source FROM gn_synthese.t_sources WHERE name_source = 'occtax';
+  SELECT INTO the_id_source id_source FROM gn_synthese.t_sources WHERE name_source ILIKE 'occtax';
   -- suppression dans la synthese
   FOR counting IN SELECT * FROM pr_occtax.cor_counting_occtax WHERE id_occurrence_occtax = OLD.id_occurrence_occtax LOOP
     SELECT INTO the_id_synthese id_synthese

BEGIN

-- recupération de l'id_source
  SELECT INTO the_id_source s.id_source FROM gn_synthese.t_sources s WHERE name_source = 'occtax';
  -- récupération des id_counting à partir de l'id_releve
  SELECT INTO the_id_countings pr_occtax.get_id_counting_from_id_releve(NEW.id_releve_occtax::integer);
  IF the_id_countings IS NOT NULL THEN

  id_source,
  new_count.id_counting_occtax,
  releve.id_dataset,
  --nature de l'objet geo: id_nomenclature_geo_object_nature Le taxon observé est présent quelque part dans l'objet géographique - NSP par défault
  pr_occtax.get_default_nomenclature_value('NAT_OBJ_GEO'),
  releve.id_nomenclature_grp_typ,
  occurrence.id_nomenclature_obs_meth,
  releve.id_nomenclature_obs_technique,
