USP_ATTRIBUTECATEGORY_VALIDATECATEGORYDELETE

            CREATE procedure dbo.USP_ATTRIBUTECATEGORY_VALIDATECATEGORYDELETE
            (
                @ATTRIBUTECATEGORYID uniqueidentifier
            )
            with execute as caller
            as        
                declare @CATEGORYCANBEDELETED bit
                declare @REASON nvarchar(250)

                set @CATEGORYCANBEDELETED = 1

                if @ATTRIBUTECATEGORYID is not null begin
                    exec dbo.USP_ATTRIBUTECATEGORY_VERIFYDELETEVALIDITY @ATTRIBUTECATEGORYID, @CATEGORYCANBEDELETED output, @REASON output                    
                end

                if @CATEGORYCANBEDELETED = 0 begin
                    raiserror(@REASON, 13, 1);    
                    return 1;
                end