USP_CONSTITUENTRECOGNITIONDECLINEDLEVEL_DELETE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@PROGRAMANDCONSTITUENTID	nvarchar(72)	IN

Definition

Copy



          CREATE procedure dbo.USP_CONSTITUENTRECOGNITIONDECLINEDLEVEL_DELETE
          (
              @ID uniqueidentifier,
              @CHANGEAGENTID uniqueidentifier,
            @PROGRAMANDCONSTITUENTID nvarchar(72) = ''
          )
          as begin


           if @PROGRAMANDCONSTITUENTID <> ''
            begin
              declare @CONSTITUENTID uniqueidentifier
              declare @RECOGNITIONPROGRAMID uniqueidentifier
                set    @RECOGNITIONPROGRAMID = cast(substring(@PROGRAMANDCONSTITUENTID ,1,36) as uniqueidentifier)
                set @CONSTITUENTID = cast(substring(@PROGRAMANDCONSTITUENTID ,37,72) as uniqueidentifier)
              delete from dbo.CONSTITUENTRECOGNITIONDECLINEDLEVEL where CONSTITUENTID=@CONSTITUENTID and RECOGNITIONPROGRAMID = @RECOGNITIONPROGRAMID
            end


            if exists (select ID from dbo.CONSTITUENTRECOGNITIONDECLINEDLEVEL where ID=@ID)
            begin
              exec USP_CONSTITUENTRECOGNITIONDECLINEDLEVEL_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
            end
            else
            begin
             exec USP_CONSTITUENTRECOGNITIONDECLINEDPROGRAM_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID 
            end

              return 0;

          end