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