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;