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