4: FOR EACH ROW
5: BEGIN
6:
7: IF igi_gen.is_req_installed('EXP') THEN
8: igi_exp_holds.l_TableRow := 0;
9: igi_exp_holds.l_TableRow := igi_exp_holds.l_TableRow + 1;
10: igi_exp_holds.l_InvoiceIdTable(igi_exp_holds.l_TableRow) :=
11: :NEW.invoice_id;
12: igi_exp_holds.l_UpdatedByTable(igi_exp_holds.l_TableRow) :=
5: BEGIN
6:
7: IF igi_gen.is_req_installed('EXP') THEN
8: igi_exp_holds.l_TableRow := 0;
9: igi_exp_holds.l_TableRow := igi_exp_holds.l_TableRow + 1;
10: igi_exp_holds.l_InvoiceIdTable(igi_exp_holds.l_TableRow) :=
11: :NEW.invoice_id;
12: igi_exp_holds.l_UpdatedByTable(igi_exp_holds.l_TableRow) :=
13: :NEW.last_updated_by ;
6:
7: IF igi_gen.is_req_installed('EXP') THEN
8: igi_exp_holds.l_TableRow := 0;
9: igi_exp_holds.l_TableRow := igi_exp_holds.l_TableRow + 1;
10: igi_exp_holds.l_InvoiceIdTable(igi_exp_holds.l_TableRow) :=
11: :NEW.invoice_id;
12: igi_exp_holds.l_UpdatedByTable(igi_exp_holds.l_TableRow) :=
13: :NEW.last_updated_by ;
14: END IF;
8: igi_exp_holds.l_TableRow := 0;
9: igi_exp_holds.l_TableRow := igi_exp_holds.l_TableRow + 1;
10: igi_exp_holds.l_InvoiceIdTable(igi_exp_holds.l_TableRow) :=
11: :NEW.invoice_id;
12: igi_exp_holds.l_UpdatedByTable(igi_exp_holds.l_TableRow) :=
13: :NEW.last_updated_by ;
14: END IF;
15: END;