CZ_LOCALIZED_TEXTS_T2
BEFORE UPDATE OR INSERT
ON "CZ"."CZ_LOCALIZED_TEXTS#"
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
BEGIN
IF INSERTING THEN
IF :new.MODEL_ID IS NULL THEN
raise_application_error(-20101, ' CZ_LOCALIZED_TEXTS.MODEL_ID CANNOT BE NULL on INSERT');
END IF;
END IF;
IF UPDATING AND :new.deleted_flag = '0' THEN
IF :new.MODEL_ID IS NULL THEN
raise_application_error(-20101, ' CZ_LOCALIZED_TEXTS.MODEL_ID CANNOT BE NULL on UPDATE');
END IF;
END IF;
END;