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