USP_PAYMENT_EDIT_2

Stored procedure to save a payment.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN
@DATE	datetime	IN
@AMOUNT	money	IN
@RECEIPTAMOUNT	money	IN
@REVENUESTREAMS	xml	IN
@SOURCECODE	nvarchar(50)	IN
@APPEALID	uniqueidentifier	IN
@BENEFITS	xml	IN
@BENEFITSWAIVED	bit	IN
@GIVENANONYMOUSLY	bit	IN
@MAILINGID	uniqueidentifier	IN
@CHANNELCODEID	uniqueidentifier	IN
@DONOTRECEIPT	bit	IN
@REFERENCE	nvarchar(255)	IN
@DONOTACKNOWLEDGE	bit	IN
@SPLITSDECLININGGIFTAID	xml	INOUT
@PERCENTAGEBENEFITS	xml	INOUT
@GIFTAIDSPONSORSHIPSPLITS	xml	INOUT
@BASEEXCHANGERATEID	uniqueidentifier	INOUT
@EXCHANGERATE	decimal(20, 8)	IN
@OLDSPOTRATEID	uniqueidentifier	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure [dbo].[USP_PAYMENT_EDIT_2]
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CURRENTDATE datetime,
                @DATE datetime,
                @AMOUNT money,
                @RECEIPTAMOUNT money ,
                @REVENUESTREAMS xml ,
                @SOURCECODE nvarchar(50),
                @APPEALID uniqueidentifier,
                @BENEFITS xml,
                @BENEFITSWAIVED bit,
                @GIVENANONYMOUSLY bit,
                @MAILINGID uniqueidentifier,
                @CHANNELCODEID uniqueidentifier,
                @DONOTRECEIPT bit,
                @REFERENCE nvarchar(255),
                @DONOTACKNOWLEDGE bit = 0,
                @SPLITSDECLININGGIFTAID xml = null output,
                @PERCENTAGEBENEFITS xml = null output,
                @GIFTAIDSPONSORSHIPSPLITS xml = null output,
                @BASEEXCHANGERATEID uniqueidentifier = null output,
                @EXCHANGERATE decimal(20,8) = null,
                @OLDSPOTRATEID uniqueidentifier = null output,
                @CURRENTAPPUSERID uniqueidentifier = null
            )
            as
            begin
            set nocount on;

            exec [dbo].[USP_PAYMENT_EDIT_3]
                @ID
                ,@CHANGEAGENTID
                ,@CURRENTDATE
                ,@DATE
                ,@AMOUNT
                ,@RECEIPTAMOUNT
                ,@REVENUESTREAMS
                ,@SOURCECODE
                ,@APPEALID
                ,@BENEFITS
                ,@BENEFITSWAIVED
                ,@GIVENANONYMOUSLY
                ,@MAILINGID
                ,@CHANNELCODEID
                ,@DONOTRECEIPT
                ,@REFERENCE
                ,@DONOTACKNOWLEDGE
                ,@SPLITSDECLININGGIFTAID output
                ,@PERCENTAGEBENEFITS output
                ,@GIFTAIDSPONSORSHIPSPLITS output
                ,@BASEEXCHANGERATEID output
                ,@EXCHANGERATE
                ,@OLDSPOTRATEID output
                ,@CURRENTAPPUSERID

            end