-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de DELETE: tdb_sga_llamados_mesa
-- BEFORE DELETE
-- Tabla: sga_llamados_mesa
-- Version: 3.0.0
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-- DROP FUNCTION ftdb_sga_llamados_mesa ();
CREATE OR REPLACE FUNCTION ftdb_sga_llamados_mesa () RETURNS trigger AS 
$BODY$
   
BEGIN
   -- Borro las evaluaciones Automáticas
   DELETE FROM sga_evaluaciones 
      WHERE entidad = OLD.entidad
      AND evaluacion_tipo IN (SELECT evaluacion_tipo 
                                FROM sga_evaluaciones_tipos 
                               WHERE aplica_a = 'M' 
                                 AND automatica = 'S');
   
   RETURN OLD;
END;
$BODY$
LANGUAGE 'plpgsql';

-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de DELETE sobre sga_llamados_mesa
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- DROP TRIGGER tdb_sga_llamados_mesa ON sga_llamados_mesa RESTRICT;
CREATE TRIGGER tdb_sga_llamados_mesa
       BEFORE DELETE ON sga_llamados_mesa 
       FOR EACH ROW EXECUTE PROCEDURE ftdb_sga_llamados_mesa();