   nb_counting integer;
 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';
   SELECT INTO the_id_synthese id_synthese
   FROM gn_synthese.synthese
   WHERE id_source = the_id_source AND entity_source_pk_value = to_char(OLD.id_counting_occtax, 'FM9999');

  occurrence RECORD;
  counting RECORD;
BEGIN
  SELECT INTO the_id_source id_source FROM gn_synthese.t_sources WHERE name_source = 'occtax';
    FOR occurrence IN SELECT * FROM pr_occtax.t_occurrences_occtax WHERE id_releve_occtax = OLD.id_releve_occtax LOOP
      FOR counting IN SELECT * FROM pr_occtax.cor_counting_occtax WHERE id_occurrence_occtax = occurrence.id_occurrence_occtax LOOP
        SELECT INTO the_id_synthese id_synthese

BEGIN

  -- recupération de l'id_source
  SELECT INTO the_id_source id_source FROM gn_synthese.t_sources WHERE name_source ILIKE 'occtax';
  -- update dans la synthese
  UPDATE gn_synthese.synthese
  SET
