TRIGGER: APPS.IGI_EXP_DIAL_UNIT_DEF_ALL_T1

Source

Description

igi_exp_dial_unit_def_all_t1
BEFORE INSERT OR UPDATE
  OF dial_unit_num
ON 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;