-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- TRIGGER BEFORE INSERT
-- Tabla: sga_insc_cursada
-- Version 3.0.0
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-- DROP FUNCTION ftib_sga_insc_cursada();
CREATE OR REPLACE FUNCTION ftib_sga_insc_cursada() RETURNS TRIGGER AS $BODY$
  BEGIN
   IF NEW.nro_transaccion IS NULL THEN
    -- Si las inscripciones son por prioridad, el nro de transacción ya se generó.
    -- Genera un nro de Transaccion. 
    NEW.nro_transaccion := f_nro_transaccion();
   END IF; 
   
   RETURN NEW;
  END;
$BODY$ LANGUAGE plpgsql;


-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- Trigger de INSERT sobre sga_insc_cursada
-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- DROP TRIGGER tib_sga_insc_cursada ON sga_insc_cursada RESTRICT;
CREATE TRIGGER tib_sga_insc_cursada BEFORE INSERT ON sga_insc_cursada
    FOR EACH ROW EXECUTE PROCEDURE ftib_sga_insc_cursada();