USP_RECORDOPERATION_RECURRINGGIFTINSTALLMENTUNDOSKIP

Parameters

Parameter Parameter Type Mode Description
@ID nvarchar(85) IN
@CHANGEAGENTID uniqueidentifier IN

Definition

Copy


                CREATE procedure dbo.USP_RECORDOPERATION_RECURRINGGIFTINSTALLMENTUNDOSKIP
                (
                    @ID nvarchar(85),
                    @CHANGEAGENTID uniqueidentifier
                )
                as
                    set nocount on

                    begin try

                        declare @REVENUEID uniqueidentifier = cast(substring(@ID,1,36) as uniqueidentifier);    
                        declare @INSTALLMENTDATE date = cast(substring(@ID,38,10) as date);    
                        declare @INSTALLMENTID uniqueidentifier = cast(substring(@ID,49,36) as uniqueidentifier);  

                        exec dbo.USP_RECURRINGGIFTINSTALLMENTUNDOSKIP
                          @REVENUEID,
                          @INSTALLMENTDATE,
                          @INSTALLMENTID,
                          1,
                          @CHANGEAGENTID
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1;
                    end catch

                    return 0;