TRIGGER: APPS.CZ_PS_NODES_T3

Source

Description

CZ_PS_NODES_T3
BEFORE UPDATE OF accumulator_flag
    ON "CZ"."CZ_PS_NODES#"
 REFERENCING OLD AS OLD NEW AS NEW
 FOR EACH ROW

Type

BEFORE EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
 IF (((:old.accumulator_flag IS NULL) <> (:new.accumulator_flag IS NULL)) OR
     (:old.accumulator_flag <> :new.accumulator_flag))THEN

   UPDATE CZ_DEVL_PROJECTS SET LAST_UPDATE_DATE = SYSDATE
   WHERE DEVL_PROJECT_ID=:new.DEVL_PROJECT_ID;
 END IF;
END;