The following triggers are available in the database.
Trigger
Name: TRG_DICO_UPDATE
Content:
CREATE OR REPLACE TRIGGER TRG_DICO_UPDATE BEFORE UPDATE ON DICO FOR EACH ROW BEGIN IF ((:new.VALUE < 0) OR (:old.STATUS > 1 AND :new.VALUE < :old.VALUE AND :old.TYPE = 0) OR (:old.STATUS > 1 AND :new.VALUE > :old.VALUE AND :old.TYPE = 1)) THEN RAISE_APPLICATION_ERROR (num=> -20107, msg=> 'The DICO value cannot be lower than 0 or DICO status is NOT_USABLE'); END IF; END TRG_DICO_UPDATE; /
Trigger
Name: TRG_DICO_CREDIT_UPDATE
Content:
CREATE OR REPLACE TRIGGER TRG_DICO_CREDIT_UPDATE AFTER UPDATE ON DICO FOR EACH ROW BEGIN IF (:new.TYPE = 1) THEN INSERT INTO DICO_TEMP VALUES(:new.COUN_KEY, :new.HOLD_OID, :new.VALUE); END IF; END TRG_DICO_CREDIT_UPDATE; /
