UFN_ASSIGNLETTERCODESPROCESS_VALIDATELETTEREXISTS_2

Validates whether or not at least one letter is present in the given assign letter process.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ASSIGNLETTERCODESPROCESSID	uniqueidentifier	IN
@OWNERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_ASSIGNLETTERCODESPROCESS_VALIDATELETTEREXISTS_2
            (
                @ASSIGNLETTERCODESPROCESSID uniqueidentifier = null,
                @OWNERID uniqueidentifier = null
            )
            returns bit
            as
            begin
                declare @COUNT int;
                declare @VALID bit;

                if @ASSIGNLETTERCODESPROCESSID is null
                    begin
                        select
                            @COUNT = count(LETTERCODE.ID)
                        from 
                            dbo.LETTERCODE 
                        where
                            LETTERCODE.ISACTIVE = 1
                            and dbo.UFN_LETTERCODE_USERHASSITEACCESS(@OWNERID, LETTERCODE.ID) = 1;
                    end
                else
                    begin
                        select 
                            @COUNT = count(PLC.ID)
                        from 
                            dbo.ASSIGNLETTERCODESPROCESSLETTERCODES PLC
                        inner join
                            dbo.LETTERCODE on PLC.LETTERCODEID = LETTERCODE.ID
                        where 
                            ASSIGNLETTERCODESPROCESSID = @ASSIGNLETTERCODESPROCESSID
                            and LETTERCODE.ISACTIVE = 1
                            and dbo.UFN_LETTERCODE_USERHASSITEACCESS(@OWNERID, LETTERCODE.ID) = 1;
                    end

                if @COUNT = 0
                    set @VALID = 0;
                else
                    set @VALID = 1;

                return @VALID;
            end