USP_DATAFORMTEMPLATE_EDIT_PLEDGEPAYMENTDETAILS_2

Saves pledge payment details.

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
@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

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEPAYMENTDETAILS_2
            (
                @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
            )    
            as
            set nocount on;

                declare @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD bit
                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLEDGEPAYMENTDETAILS_2    @ID = @ID, 
                                                                                @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD = @UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD output

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEPAYMENTDETAILS_3    @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