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