igi_exp_tran_unit_def_all_t1
BEFORE INSERT OR UPDATE
OF trans_unit_num
ON igi_exp_tran_unit_def_all
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
Type
BEFORE EACH ROW
Event
INSERT OR UPDATE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN
IF igi_gen.is_req_installed('EXP') THEN
IF inserting THEN
IF :NEW.ACT_NUMBER IS NULL THEN
:NEW.ACT_NUMBER :=:NEW.TRANS_UNIT_NUM;
END IF;
ELSIF updating THEN
IF :NEW.ACT_NUMBER IS NOT NULL THEN
:NEW.LEGAL_NUMBER :=:NEW.TRANS_UNIT_NUM;
END IF;
END IF ;
END IF ;
END;