CZ_PSNODE_PROPCOMPAT_GENS_T1
BEFORE UPDATE OR INSERT
ON CZ_PSNODE_PROPCOMPAT_GENS
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
Type
BEFORE EACH ROW
Event
INSERT OR UPDATE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
DECLARE
VAR_USER_ID INTEGER;
BEGIN
VAR_USER_ID:=CZ_UTILS.SPX_UID;
IF INSERTING THEN
:new.CREATED_BY:=VAR_USER_ID;
:new.LAST_UPDATED_BY:=VAR_USER_ID;
:new.CREATION_DATE:=SYSDATE;
:new.LAST_UPDATE_DATE:=SYSDATE;
END IF;
IF UPDATING THEN
:new.LAST_UPDATED_BY:=VAR_USER_ID;
:new.LAST_UPDATE_DATE:=SYSDATE;
END IF;
END;