USP_DATAFORMTEMPLATE_EDIT_BBNCRECURRINGGIFTPAYMENTDETAILS

The save procedure used by the edit dataform template "Recurring Gift Payment Details Edit Form BBNC".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@AUTOPAY	bit	IN	Pay automatically by:
@CARDHOLDERNAME	nvarchar(255)	IN	Name on card
@CREDITCARDNUMBER	nvarchar(20)	IN	Card number
@CREDITTYPECODEID	uniqueidentifier	IN	Card type
@EXPIRESON	UDT_FUZZYDATE	IN	Expires on
@REFERENCEDATE	UDT_FUZZYDATE	IN	Reference date
@REFERENCENUMBER	nvarchar(20)	IN	Reference number
@ACCOUNTID	uniqueidentifier	IN	Account
@CREDITCARDTOKEN	uniqueidentifier	IN	Card token
@STANDINGORDERSETUP	bit	IN	Standing order has been setup
@STANDINGORDERSETUPDATE	datetime	IN	Setup on
@DDISOURCECODEID	uniqueidentifier	IN	DDI source
@DDISOURCEDATE	date	IN	DDI source date
@SENDPMINSTRUCTION	bit	IN	Send instruction
@PMINSTRUCTIONTOSENDCODE	tinyint	IN	Send instruction
@PMINSTRUCTIONDATE_NEW	date	IN	New instruction sent
@PMINSTRUCTIONDATE_CANCEL	date	IN	Cancel instruction sent
@PMINSTRUCTIONDATE_SETUP	date	IN	Set-up instruction sent
@PMADVANCENOTICESENTDATE	date	IN	Advance notice sent
@UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD	bit	IN	Update other transactions to use new credit card

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCRECURRINGGIFTPAYMENTDETAILS (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @PAYMENTMETHODCODE tinyint,
                    @AUTOPAY bit,
                    @CARDHOLDERNAME nvarchar(255),
                    @CREDITCARDNUMBER nvarchar(20),
                    @CREDITTYPECODEID uniqueidentifier,
                    @EXPIRESON dbo.UDT_FUZZYDATE,
                    @REFERENCEDATE dbo.UDT_FUZZYDATE,
                    @REFERENCENUMBER nvarchar(20),
                    @ACCOUNTID uniqueidentifier,
                    @CREDITCARDTOKEN uniqueidentifier,
                    @STANDINGORDERSETUP bit,
                    @STANDINGORDERSETUPDATE datetime,
                    @DDISOURCECODEID uniqueidentifier,
                    @DDISOURCEDATE date,
                    @SENDPMINSTRUCTION bit,
                    @PMINSTRUCTIONTOSENDCODE tinyint,
                    @PMINSTRUCTIONDATE_NEW date,
                    @PMINSTRUCTIONDATE_CANCEL date,
                    @PMINSTRUCTIONDATE_SETUP date,
                    @PMADVANCENOTICESENTDATE date,
                    @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD bit
                )
                as
                    set nocount on;

                    begin try
                        exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFTPAYMENTDETAILS_4
                            @ID,
                            @CHANGEAGENTID,
                            @PAYMENTMETHODCODE,
                            @AUTOPAY,
                            @CARDHOLDERNAME,
                            @CREDITCARDNUMBER,
                            @CREDITTYPECODEID,
                            @EXPIRESON,
                            @REFERENCEDATE,
                            @REFERENCENUMBER,
                            @ACCOUNTID,
                            @CREDITCARDTOKEN,
                            @STANDINGORDERSETUP,
                            @STANDINGORDERSETUPDATE,
                            @DDISOURCECODEID,
                            @DDISOURCEDATE,
                            @SENDPMINSTRUCTION,
                            @PMINSTRUCTIONTOSENDCODE,
                            @PMINSTRUCTIONDATE_NEW,
                            @PMINSTRUCTIONDATE_CANCEL,
                            @PMINSTRUCTIONDATE_SETUP,
                            @PMADVANCENOTICESENTDATE,
                            @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                    return 0;