"APPS"."IGI_EXP_DIAL_UNIT_DEF_ALL_T1"
BEFORE INSERT OR UPDATE
OF dial_unit_num
ON "IGI"."IGI_EXP_DIAL_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.DIAL_UNIT_NUM;
END IF;
ELSIF updating THEN
IF :NEW.ACT_NUMBER IS NOT NULL THEN
:NEW.LEGAL_NUMBER :=:NEW.DIAL_UNIT_NUM;
END IF;
END IF;
END IF ;
END;