USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFTSTATUS_2
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN | |
@CHANGEAGENTID | uniqueidentifier | IN | |
@STATUSCODE | tinyint | IN | |
@REASONCODEID | uniqueidentifier | IN | |
@INSTALLMENTS | xml | IN | |
@SKIPPEDINSTALLMENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFTSTATUS_2
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@STATUSCODE tinyint,
@REASONCODEID uniqueidentifier,
@INSTALLMENTS xml,
@SKIPPEDINSTALLMENTID uniqueidentifier
)
as
begin
set nocount on
begin try
/*this SP is used by both this form and the SetRecurringGiftStatus.GlobalChange global change.
Any changes to "the work" done when changing
the status on a recurring gift should be done in USP_RECURRINGGIFT_EDITSTATUS so both the form and the global change pick up
the changes. */
exec dbo.USP_RECURRINGGIFT_EDITSTATUS @ID, @STATUSCODE, @CHANGEAGENTID, null, @REASONCODEID, @INSTALLMENTS, @SKIPPEDINSTALLMENTID;
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch
return 0
end