USP_REVENUE_GETBENEFITS_UPDATEFROMXML

Used to update a set of records defined by UFN_REVENUE_GETBENEFITS from the given xml string.

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@XML	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE PROCEDURE [dbo].[USP_REVENUE_GETBENEFITS_UPDATEFROMXML] 
            (
            @REVENUEID uniqueidentifier,
            @XML xml,
            @CHANGEAGENTID uniqueidentifier = null,
            @CHANGEDATE datetime = null
            )
            as
                declare @TRANSACTIONCURRENCYID uniqueidentifier = null;
                declare @BASECURRENCYID uniqueidentifier = null;

                select
                    @TRANSACTIONCURRENCYID = FINANCIALTRANSACTION.TRANSACTIONCURRENCYID,
                    @BASECURRENCYID = isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, CURRENCYSET.BASECURRENCYID)
                from dbo.FINANCIALTRANSACTION
                    inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                    left join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
                    left join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
                where FINANCIALTRANSACTION.ID = @REVENUEID;

                if @BASECURRENCYID is null
                    set @BASECURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                if @TRANSACTIONCURRENCYID is null
                    set @TRANSACTIONCURRENCYID = @BASECURRENCYID;

                set @XML = dbo.UFN_REVENUEBENEFIT_CONVERTAMOUNTSINXML_2(@XML,@TRANSACTIONCURRENCYID,@BASECURRENCYID);

                exec USP_REVENUE_GETBENEFITS_4_UPDATEFROMXML @REVENUEID,@XML,@CHANGEAGENTID,@CHANGEDATE,default;