CZ_PS_NODES_T6
BEFORE UPDATE OF name ON 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.name IS NULL) <> (:new.name IS NULL)) OR (:old.name <> :new.name))THEN
UPDATE CZ_DEVL_PROJECTS SET
post_migr_change_flag = DECODE(post_migr_change_flag, 'N', 'R', 'Z', 'R', post_migr_change_flag)
WHERE
DEVL_PROJECT_ID=:new.DEVL_PROJECT_ID;
END IF;
END;