TRIGGER: APPS.IGI_RPI_COMPONENT_PERIODS_T1

Source

Description

IGI_RPI_COMPONENT_PERIODS_T1
BEFORE  UPDATE  ON IGI_RPI_COMPONENT_PERIODS
REFERENCING
 NEW AS NEW
 OLD AS OLD
FOR EACH ROW

Type

BEFORE EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

Begin
   if :old.period_name <> :new.period_name then
      update igi_rpi_bill_charge_periods
      set    billing_period_name = :new.period_name
      where  billing_period_name = :old.period_name
      ;
      update igi_rpi_bill_charge_periods
      set    charge_period_name = :new.period_name
      where  charge_period_name = :old.period_name
      ;

   else
      null;
   end if;
End;