UFN_ISAPPEALMAILINGACTIVATING

Checks if the given appeal mailing is in the middle of the segmentation activation process.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_ISAPPEALMAILINGACTIVATING
(
    @SEGMENTATIONID uniqueidentifier
)
returns bit
with execute as caller
as begin

    declare @STATUSCODE as tinyint;
    declare @RETVAL as bit = 0;

    select top 1
        @STATUSCODE = BUSINESSPROCESSSTATUS.STATUSCODE
    from dbo.MKTSEGMENTATIONACTIVATEPROCESS
    inner join dbo.MKTSEGMENTATIONACTIVATEPROCESSSTATUS 
        on MKTSEGMENTATIONACTIVATEPROCESSSTATUS.PARAMETERSETID = MKTSEGMENTATIONACTIVATEPROCESS.ID
    inner join dbo.BUSINESSPROCESSSTATUS 
        on BUSINESSPROCESSSTATUS.ID = MKTSEGMENTATIONACTIVATEPROCESSSTATUS.ID
    where MKTSEGMENTATIONACTIVATEPROCESS.SEGMENTATIONID = @SEGMENTATIONID
    order by BUSINESSPROCESSSTATUS.STARTEDON desc;

    if @STATUSCODE = 1
        set @RETVAL = 1;

    return @RETVAL;        
end