USP_DELETE_NAMINGOPPORTUNITYREVENUERECOGNITION

Executes the "Naming Opportunity Revenue Recognition 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_DELETE_NAMINGOPPORTUNITYREVENUERECOGNITION
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as
                    set nocount on;

                    begin try
                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        declare @RECOGNITIONID uniqueidentifier;

                        select
                            @RECOGNITIONID = NAMINGOPPORTUNITYRECOGNITIONID 
                        from dbo.NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT
                        where ID = @ID;

                        exec dbo.USP_NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

                        declare @LINKCOUNT int;
                        select @LINKCOUNT = count(ID) from dbo.NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT where NAMINGOPPORTUNITYRECOGNITIONID = @RECOGNITIONID;

                        if @LINKCOUNT = 0
                            select @LINKCOUNT = count(ID) from dbo.NAMINGOPPORTUNITYRECOGNITIONMGLINK where NAMINGOPPORTUNITYRECOGNITIONID = @RECOGNITIONID;

                        if @LINKCOUNT = 0
                            exec dbo.USP_NAMINGOPPORTUNITYRECOGNITION_DELETEBYID_WITHCHANGEAGENTID @RECOGNITIONID, @CHANGEAGENTID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;