USP_DATAFORMTEMPLATE_EDIT_PLEDGEPAYMENTDETAILS_4

Saves pledge payment details.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@PAYMENTMETHODCODE	tinyint	IN
@AUTOPAY	bit	IN
@CARDHOLDERNAME	nvarchar(100)	IN
@CREDITCARDNUMBER	nvarchar(20)	IN
@CREDITTYPECODEID	uniqueidentifier	IN
@EXPIRESON	UDT_FUZZYDATE	IN
@REFERENCEDATE	UDT_FUZZYDATE	IN
@REFERENCENUMBER	nvarchar(20)	IN
@ACCOUNTID	uniqueidentifier	IN
@CREDITCARDTOKEN	uniqueidentifier	IN
@STANDINGORDERSETUP	bit	IN
@STANDINGORDERSETUPDATE	datetime	IN
@DDISOURCECODEID	uniqueidentifier	IN
@DDISOURCEDATE	date	IN
@SENDPMINSTRUCTION	bit	IN
@PMINSTRUCTIONTOSENDCODE	tinyint	IN
@PMINSTRUCTIONDATE_NEW	date	IN
@PMINSTRUCTIONDATE_CANCEL	date	IN
@PMINSTRUCTIONDATE_SETUP	date	IN
@PMADVANCENOTICESENTDATE	date	IN
@UPDATEOTHERTRANSACTIONSTOUSENEWCREDITCARD	bit	IN
@USESYSTEMGENERATEDREFERENCENUMBER	bit	IN
@STANDINGORDERREFERENCENUMBER	nvarchar(18)	IN

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEPAYMENTDETAILS_4
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @PAYMENTMETHODCODE tinyint,
    @AUTOPAY bit,
    @CARDHOLDERNAME nvarchar(100),
    @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,
    @USESYSTEMGENERATEDREFERENCENUMBER bit,
    @STANDINGORDERREFERENCENUMBER nvarchar(18)
)

as
    set nocount on;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLEDGEPAYMENTDETAILS_2
        @ID = @ID

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEPAYMENTDETAILS_5
        @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,
        @USESYSTEMGENERATEDREFERENCENUMBER,
        @STANDINGORDERREFERENCENUMBER

    return 0;