CZ_END_USER_GROUPS_T1
BEFORE INSERT
ON CZ_END_USER_GROUPS
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
Type
BEFORE EACH ROW
Event
INSERT
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;