USP_RECOGNITIONLEVELAMOUNT_DELETE

Executes the "Recognition Level Amount: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



          CREATE procedure dbo.USP_RECOGNITIONLEVELAMOUNT_DELETE
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier
          )
          as begin
            declare @PARENTRECOGNITIONLEVELID uniqueidentifier;
            select @PARENTRECOGNITIONLEVELID = RECOGNITIONLEVELID
            from dbo.RECOGNITIONLEVELAMOUNT
            where ID = @ID;

            if not exists
            (
              select RECOGNITIONLEVELID
              from dbo.RECOGNITIONLEVELAMOUNT
              where
                RECOGNITIONLEVELID = @PARENTRECOGNITIONLEVELID and
                ID <> @ID
            )
            begin
              raiserror('ERR_ONLYMINIMUMAMOUNT_DELETE', 13, 1);
            end

            exec USP_RECOGNITIONLEVELAMOUNT_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
            return 0;
          end