USP_REVENUEAPPEAL_UPDATE

CREATE procedure dbo.USP_REVENUEAPPEAL_UPDATE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @GIFTREVENUEID uniqueidentifier,
    @PAYMENTREVENUEID uniqueidentifier = '00000000-0000-0000-0000-000000000000'
)
as 
begin

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @EMPTYGUID uniqueidentifier = '00000000-0000-0000-0000-000000000000'                        
    declare @CHANGEDATE datetime

    set @CHANGEDATE = getdate()

    begin try
        if @PAYMENTREVENUEID <> @EMPTYGUID
            update dbo.REVENUE set 
            APPEALID = @ID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
            where ID in (@GIFTREVENUEID,@PAYMENTREVENUEID)
        else
            update dbo.REVENUE set 
            APPEALID = @ID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
            where ID = @GIFTREVENUEID;

    -- Add any business units attached to appeal

    if @PAYMENTREVENUEID <> @EMPTYGUID
        exec dbo.USP_REVENUESPLIT_APPLYBUSINESSUNITS @PAYMENTREVENUEID, @CHANGEAGENTID, @CHANGEDATE;

    exec dbo.USP_REVENUESPLIT_APPLYBUSINESSUNITS @GIFTREVENUEID, @CHANGEAGENTID, @CHANGEDATE;

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch            
    return 0;

end