USP_REVENUE_SPLIT_EDIT_SAVE

Provides a common method to save data for revenue detail split edit forms.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@REVENUEAMOUNT	money	IN
@SPLITS	xml	IN

Definition

Copy



            CREATE procedure dbo.USP_REVENUE_SPLIT_EDIT_SAVE
            (
                @ID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null,
                @REVENUEAMOUNT money = null,
                @SPLITS xml
            )
            as 
                set nocount on;

                begin try
                    declare @TRANSACTIONTYPECODE int;
                    select @TRANSACTIONTYPECODE = TRANSACTIONTYPECODE from dbo.REVENUE where ID = @ID;

                    -- JamesWill 03/13/2006 CR237716-031306

                    exec dbo.USP_REVENUESPLIT_VALIDATESPLITS @SPLITS, @REVENUEAMOUNT, @TRANSACTIONTYPECODE, @ID;

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

                    if @CHANGEDATE is null
                        set @CHANGEDATE = getdate()

                    exec dbo.USP_REVENUE_GETSPLITS_UPDATEFROMXML @ID, @SPLITS, @CHANGEAGENTID, @CHANGEDATE;

                end try

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

                return 0;