USP_DATAFORMTEMPLATE_EDIT_CREDITCARDPROCESSINGPREPROCESS_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@BATCHID	uniqueidentifier	IN
@IDSETREGISTERID	uniqueidentifier	IN
@CUTOFFDATE	datetime	IN
@BATCHTEMPLATEID	uniqueidentifier	IN
@TRANSACTIONTYPECODE	tinyint	IN
@OWNERID	uniqueidentifier	IN
@DUEDATETYPECODE	tinyint	IN
@DAYSAFTER	int	IN
@CONSOLIDATEPAYMENTS	bit	IN
@VALIDATEPROJECTEDBATCHTOTALS	bit	IN

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CREDITCARDPROCESSINGPREPROCESS_3
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @NAME nvarchar(100),
                        @DESCRIPTION nvarchar(255),
                        @BATCHID uniqueidentifier,
                        @IDSETREGISTERID uniqueidentifier,
                        @CUTOFFDATE datetime,
                        @BATCHTEMPLATEID uniqueidentifier,
                        @TRANSACTIONTYPECODE tinyint,
                        @OWNERID uniqueidentifier,
                        @DUEDATETYPECODE tinyint,
                        @DAYSAFTER integer,
                        @CONSOLIDATEPAYMENTS bit,
                        @VALIDATEPROJECTEDBATCHTOTALS bit
                    )
                    as
                    set nocount on;

                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                    declare @DATE as datetime;
                        set @DATE = getdate();

                    begin try
                        update dbo.CREDITCARDPROCESSING
                        set NAME = @NAME,
                            DESCRIPTION = @DESCRIPTION,
                            BATCHID = @BATCHID,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @DATE,
                            IDSETREGISTERID = @IDSETREGISTERID,
                            CUTOFFDATE = @CUTOFFDATE,
                            BATCHTEMPLATEID = @BATCHTEMPLATEID,
                            TRANSACTIONTYPECODE = @TRANSACTIONTYPECODE,
                            OWNERID = @OWNERID,
                            DUEDATETYPECODE = @DUEDATETYPECODE,
                            DAYSAFTER = @DAYSAFTER,
                            CONSOLIDATEPAYMENTS = @CONSOLIDATEPAYMENTS,
                            VALIDATEPROJECTEDBATCHTOTALS = @VALIDATEPROJECTEDBATCHTOTALS
                        where ID = @ID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;