USP_PLANNEDGIFTASREVENUE_ADD

Executes the "Planned Gift Add As Revenue" record operation.
Parameters

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

Copy


                    CREATE procedure dbo.USP_PLANNEDGIFTASREVENUE_ADD(@ID uniqueidentifier, @CHANGEAGENTID uniqueidentifier)
                    as begin
                        set nocount on;
                        declare @CURRENTDATE datetime;    
                        declare @VEHICLECODE tinyint;
                        declare @GIFTAMOUNT money;
                        declare @REMAINDERVALUE money;
                        declare @PAYOUTAMOUNT money;
                        declare @RECEIPTAMOUNT money;
                        declare @GIFTDATE datetime;
                        declare @RVDATE datetime;
                        declare @DATE datetime;
                        declare @AMOUNT money;

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

                        set @CURRENTDATE = getdate();          

                        select @VEHICLECODE = VEHICLECODE,
                            @GIFTAMOUNT = GIFTAMOUNT,
                            @GIFTDATE = GIFTDATE,
                            @REMAINDERVALUE = REMAINDERVALUE,
                            @RVDATE = REMAINDERVALUEDATE,
                            @PAYOUTAMOUNT = PAYOUTAMOUNT
                        from dbo.PLANNEDGIFT
                        where ID = @ID;

                        set @AMOUNT = @GIFTAMOUNT;
                        set @DATE = @CURRENTDATE;
                        set @RECEIPTAMOUNT = @GIFTAMOUNT;

                        if @VEHICLECODE = 1 or @VEHICLECODE = 2 
                            begin
                                set @AMOUNT = @REMAINDERVALUE;
                                set @RECEIPTAMOUNT = @REMAINDERVALUE;
                            end

                        if @VEHICLECODE = 3 or @VEHICLECODE = 4 
                            begin
                                set @AMOUNT = @PAYOUTAMOUNT;
                                set @RECEIPTAMOUNT = @PAYOUTAMOUNT;
                            end

                        if @VEHICLECODE = 5
                            set @RECEIPTAMOUNT = @REMAINDERVALUE;

                        exec USP_ADDPLANNEDGIFTREVENUE @ID, @AMOUNT, @DATE, @RECEIPTAMOUNT, @CHANGEAGENTID;

                        return 0;
                    end