TRIGGER: APPS.XNP_NRE_BRI

Source

Description

XNP_NRE_BRI
BEFORE INSERT ON XNP_NUMBER_RANGES
FOR EACH ROW

Type

BEFORE EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
   IF :NEW.POOLED_FLAG = 'Y' THEN
      IF :NEW.ASSIGNED_SP_ID IS NOT NULL THEN
         :NEW.ASSIGNED_SP_ID := '';
      END IF;
   ELSE
      IF :NEW.ASSIGNED_SP_ID <> :NEW.OWNING_SP_ID THEN
         :NEW.ASSIGNED_SP_ID := :NEW.OWNING_SP_ID;
      END IF;
   END IF;
END;