USP_RECORDOPERATION_CHANGERECONCILIATIONSTATUS
Provides the prompt for the "Reconciliation Change Status" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @NEWSTATUS | nvarchar(10) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_RECORDOPERATION_CHANGERECONCILIATIONSTATUS
(
@ID uniqueidentifier,
@NEWSTATUS nvarchar(10) = null output
)
as
set nocount on;
declare @STATUSCODE integer
select @STATUSCODE = STATUSCODE
from dbo.RECONCILIATION
where ID = @ID;
set @NEWSTATUS = case @STATUSCODE
when 1 then [dbo].[UFN_RECONCILIATION_STATUSCODE_GETDESCRIPTION](2)
when 2 then [dbo].[UFN_RECONCILIATION_STATUSCODE_GETDESCRIPTION](1)
end;
return 0;