USP_DATAFORMTEMPLATE_EDIT_CREDITCARDPROCESSING_3

The save procedure used by the edit dataform template "Credit Card Processing Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@BATCHID	uniqueidentifier	IN	Batch
@MERCHANTACCOUNTID	uniqueidentifier	IN	Account
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@CUTOFFDATE	datetime	IN	Include transactions on or before
@BATCHTEMPLATEID	uniqueidentifier	IN	Payment batch template
@TRANSACTIONTYPECODE	tinyint	IN	Transaction types
@OWNERID	uniqueidentifier	IN	Payment batch owner
@DUEDATETYPECODE	tinyint	IN	Payments due on or before
@DAYSAFTER	int	IN	Days after this process runs
@MERCHANTACCOUNTS	xml	IN	Accounts
@CONSOLIDATEPAYMENTS	bit	IN	Consolidate multiple commitments to a single payment by constituent

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CREDITCARDPROCESSING_3
(
    @ID uniqueidentifier,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @BATCHID uniqueidentifier,
    @MERCHANTACCOUNTID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @IDSETREGISTERID uniqueidentifier,
    @CUTOFFDATE datetime,
    @BATCHTEMPLATEID uniqueidentifier,
    @TRANSACTIONTYPECODE tinyint,
    @OWNERID uniqueidentifier,
    @DUEDATETYPECODE tinyint,
    @DAYSAFTER integer,
    @MERCHANTACCOUNTS xml,
    @CONSOLIDATEPAYMENTS bit
)

as
    set nocount on;

    declare @PERMANENTREJECTIONBEHAVIORTYPECODE tinyint;
    declare @PROVISIONALREJECTIONBEHAVIORTYPECODE tinyint;
    declare @PERMANENTREJECTIONEXPORTDEFINITIONID uniqueidentifier;
    declare @CREATEPERMANENTREJECTIONIDSET bit;
    declare @PERMANENTREJECTIONIDSETNAME nvarchar(100);
    declare @OVERWRITEPERMANENTREJECTIONIDSET bit;
    declare @PROVISIONALREJECTIONMAXATTEMPTS tinyint;
    declare @VALIDATEPROJECTEDBATCHTOTALS bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CREDITCARDPROCESSING
        @ID = @ID,
        @CURRENTAPPUSERID = null,
        @PERMANENTREJECTIONBEHAVIORTYPECODE = @PERMANENTREJECTIONBEHAVIORTYPECODE output,
        @PROVISIONALREJECTIONBEHAVIORTYPECODE = @PROVISIONALREJECTIONBEHAVIORTYPECODE output,
        @PERMANENTREJECTIONEXPORTDEFINITIONID = @PERMANENTREJECTIONEXPORTDEFINITIONID output,
        @CREATEPERMANENTREJECTIONIDSET = @CREATEPERMANENTREJECTIONIDSET output,
        @PERMANENTREJECTIONIDSETNAME = @PERMANENTREJECTIONIDSETNAME output,
        @OVERWRITEPERMANENTREJECTIONIDSET = @OVERWRITEPERMANENTREJECTIONIDSET output,
        @PROVISIONALREJECTIONMAXATTEMPTS = @PROVISIONALREJECTIONMAXATTEMPTS output,
        @VALIDATEPROJECTEDBATCHTOTALS = @VALIDATEPROJECTEDBATCHTOTALS output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_CREDITCARDPROCESSING_4
        @ID,
        @NAME,
        @DESCRIPTION,
        @BATCHID,
        @MERCHANTACCOUNTID,
        @CHANGEAGENTID,
        @IDSETREGISTERID,
        @CUTOFFDATE,
        @BATCHTEMPLATEID,
        @TRANSACTIONTYPECODE,
        @OWNERID,
        @DUEDATETYPECODE,
        @DAYSAFTER,
        @MERCHANTACCOUNTS,
        @CONSOLIDATEPAYMENTS,
        @PERMANENTREJECTIONBEHAVIORTYPECODE,
        @PROVISIONALREJECTIONBEHAVIORTYPECODE,
        @PERMANENTREJECTIONEXPORTDEFINITIONID,
        @CREATEPERMANENTREJECTIONIDSET,
        @PERMANENTREJECTIONIDSETNAME,
        @OVERWRITEPERMANENTREJECTIONIDSET,
        @PROVISIONALREJECTIONMAXATTEMPTS,
        @VALIDATEPROJECTEDBATCHTOTALS

    return 0;