-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de DELETE: td_sga_acciones_operacion
-- Tabla: sga_acciones_operacion
-- Version: 3.0.0
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-- DROP FUNCTION ftdb_sga_acciones_operacion ();
CREATE OR REPLACE FUNCTION ftdb_sga_acciones_operacion () RETURNS trigger AS 
$BODY$
   
BEGIN

   -- Borro tabla de configuracion de requisitos por operacion para los requisitos de la acción.
   DELETE FROM sga_requisitos_conf_x_oper
     WHERE operacion = OLD.operacion
       AND requisito_accion IN 
        (SELECT sga_requisitos_x_accion.requisito_accion 
           FROM  sga_requisitos_grupos, sga_requisitos_x_accion   
         WHERE sga_requisitos_grupos.grupo_requisito = sga_requisitos_x_accion.grupo_requisito
           AND sga_requisitos_grupos.accion = OLD.accion);

   RETURN OLD;
END;
$BODY$
LANGUAGE 'plpgsql';


-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de DELETE sobre sga_acciones_operacion
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- DROP TRIGGER tdb_sga_acciones_operacion ON sga_acciones_operacion RESTRICT;
CREATE TRIGGER tdb_sga_acciones_operacion
       BEFORE DELETE ON sga_acciones_operacion 
       FOR EACH ROW EXECUTE PROCEDURE ftdb_sga_acciones_operacion();