create or replace NONEDITIONABLE TRIGGER "M_POGODBE_TIP_POGODBE_TRG"
BEFORE INSERT OR UPDATE ON M_POGODBE
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
:NEW.TIP_POGODBE:='6';
IF NVL(:NEW.DATUM_KONCA,:NEW.DATUM_ZACETKA) - :NEW.DATUM_ZACETKA +1 < 150 THEN :NEW.TIP_POGODBE:='T'; END IF;
IF NVL(:NEW.DATUM_KONCA,:NEW.DATUM_ZACETKA) - :NEW.DATUM_ZACETKA +1 >= 365 THEN :NEW.TIP_POGODBE:='1'; END IF;
END;