TRIGGER: APPS.IGI_EXP_AP_HOLDS_T1

Source

Description

igi_exp_ap_holds_t1
AFTER UPDATE
ON ap_holds_all
FOR EACH ROW

Type

AFTER EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN

   IF igi_gen.is_req_installed('EXP') THEN
      igi_exp_holds.l_TableRow := 0;
      igi_exp_holds.l_TableRow := igi_exp_holds.l_TableRow + 1;
      igi_exp_holds.l_InvoiceIdTable(igi_exp_holds.l_TableRow) :=
                                           :NEW.invoice_id;
      igi_exp_holds.l_UpdatedByTable(igi_exp_holds.l_TableRow) :=
                                           :NEW.last_updated_by ;
   END IF;
END;