USP_GETTASKSTATUS_ACKNOWLEDGEMENTSANDRECEIPTS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STATUS | tinyint | INOUT | |
| @DESCRIPTION | nvarchar(max) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_GETTASKSTATUS_ACKNOWLEDGEMENTSANDRECEIPTS
(
@STATUS tinyint = null output,
@DESCRIPTION nvarchar(max) = null output
)
as begin
declare @TEMPLATEID uniqueidentifier = 'FE95CA52-7862-45D0-9676-1A655A7279F0';
declare @LETTERS integer = (select count(*) from UFN_ACKNOWLEDGEMENTANDRECEIPTING_GETLETTERS(@TEMPLATEID));
declare @OPTIONS integer = (select count(*) from dbo.MKTACKNOWLEDGEMENTMAILINGTEMPLATEEMAILOPTIONS where ACKNOWLEDGEMENTMAILINGTEMPLATEID=@TEMPLATEID)
if @LETTERS > 0 and @OPTIONS > 0
set @STATUS = 2;
else if @LETTERS > 0 or @OPTIONS > 0
set @STATUS = 1;
end