USP_EDIT_RECURRINGGIFTDETAILS
The save procedure used by the edit dataform template "recurring Gift Details Edit Data Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter indicating the ID of the record being edited. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @AMOUNT | money | IN | amount |
| @SPLITS | xml | IN | Designations |
| @FREQUENCYCODE | tinyint | IN | Frequency |
| @ENDDATE | datetime | IN | endDate |
| @STARTDATE | datetime | IN | startDate |
| @NEXTINSTALLMENTID | uniqueidentifier | IN | next installment id |
Definition
Copy
CREATE procedure dbo.USP_EDIT_RECURRINGGIFTDETAILS
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@AMOUNT money,
@SPLITS xml,
@FREQUENCYCODE tinyint,
@ENDDATE datetime,
@STARTDATE datetime,
@NEXTINSTALLMENTID uniqueidentifier
as
begin
-- do work
declare @USEEXISTINGCURRENCY bit
exec USP_EDITLOAD_RECURRINGGIFTDETAILS @ID =@ID, @USEEXISTINGCURRENCY = @USEEXISTINGCURRENCY output
exec USP_EDIT_RECURRINGGIFTDETAILS_2 @ID,
@CHANGEAGENTID,
@AMOUNT,
@SPLITS,
@FREQUENCYCODE,
@ENDDATE,
@STARTDATE,
@NEXTINSTALLMENTID,
@USEEXISTINGCURRENCY
end