UFN_NAMEFORMATPARAMETER_CANDELETE

Returns true if the given option does not exist on any existing processes.
Return

Return Type
bit
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
Definition

Copy


            create function dbo.UFN_NAMEFORMATPARAMETER_CANDELETE(
                @ID uniqueidentifier
            ) returns bit with execute as caller
            as
            begin
                declare @CANDELETE bit;

                set @CANDELETE = 1;

                WITH XMLNAMESPACES ('bb_appfx_dataforms' AS DFI)

                select @CANDELETE = 0 
                where exists(
                select ID
                from dbo.CORRESPONDENCEPROCESS
                where
                CUSTOMPARAMETERDATAFORMITEM.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="NAMEFORMATPARAMETERID"]/DFI:Value)[1]','uniqueidentifier') = @ID
                union all
                select ID
                from dbo.LETTERCODE
                where
                CUSTOMPARAMETERDATAFORMITEM.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="NAMEFORMATPARAMETERID"]/DFI:Value)[1]','uniqueidentifier') = @ID
                UNION ALL
                select ID
                from dbo.PLANNEDGIFTLETTERCODE
                where
                CUSTOMPARAMETERDATAFORMITEM.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="NAMEFORMATPARAMETERID"]/DFI:Value)[1]','uniqueidentifier') = @ID
                UNION ALL
                select ID
                from dbo.PLEDGEREMINDERPROCESS
                where
                CUSTOMPARAMETERDATAFORMITEM.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="NAMEFORMATPARAMETERID"]/DFI:Value)[1]','uniqueidentifier') = @ID
                UNION ALL
                select ID
                from dbo.RECEIPTINGPROCESS
                where
                CUSTOMPARAMETERDATAFORMITEM.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="NAMEFORMATPARAMETERID"]/DFI:Value)[1]','uniqueidentifier') = @ID
                UNION ALL
                select ID
                from dbo.TRIBUTELETTERCODE
                where
                CUSTOMPARAMETERDATAFORMITEM.value('data(/DFI:DataFormItem/DFI:Values/DFI:fv[@ID="NAMEFORMATPARAMETERID"]/DFI:Value)[1]','uniqueidentifier') = @ID
                )

                return @CANDELETE
            end