USP_EDIT_RECURRINGGIFTDETAILS_2
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN | |
@CHANGEAGENTID | uniqueidentifier | IN | |
@AMOUNT | money | IN | |
@SPLITS | xml | IN | |
@FREQUENCYCODE | tinyint | IN | |
@ENDDATE | datetime | IN | |
@STARTDATE | datetime | IN | |
@NEXTINSTALLMENTID | uniqueidentifier | IN | |
@USEEXISTINGCURRENCY | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_EDIT_RECURRINGGIFTDETAILS_2
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@AMOUNT money,
@SPLITS xml,
@FREQUENCYCODE tinyint,
@ENDDATE datetime,
@STARTDATE datetime,
@NEXTINSTALLMENTID uniqueidentifier,
@USEEXISTINGCURRENCY bit
as
begin
declare @INSTALLMENTBEGINDATE datetime
exec USP_EDITLOAD_RECURRINGGIFTDETAILS @ID =@ID, @INSTALLMENTBEGINDATE = @INSTALLMENTBEGINDATE output
exec USP_EDIT_RECURRINGGIFTDETAILS_3 @ID,
@CHANGEAGENTID,
@AMOUNT,
@SPLITS,
@FREQUENCYCODE,
@ENDDATE,
@STARTDATE,
@NEXTINSTALLMENTID,
@USEEXISTINGCURRENCY,
@INSTALLMENTBEGINDATE
end