USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNT_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ACCOUNTNAME	nvarchar(100)	IN
@ACCOUNTNUMBER	nvarchar(50)	IN
@ROUTINGNUMBER	nvarchar(9)	IN
@ACCOUNTTYPECODE	tinyint	IN
@MINIMUMBALANCE	decimal(19, 4)	IN
@DEFAULTCASHACCOUNTTYPECODE	tinyint	IN
@GLACCOUNTID	uniqueidentifier	IN
@PDACCOUNTSEGMENTVALUEID	uniqueidentifier	IN
@USERNUMBER	nvarchar(24)	IN
@CLIENTNAME	nvarchar(100)	IN
@SORTCODE	nvarchar(6)	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BANKINGSYSTEMID	uniqueidentifier	IN
@BIC	nvarchar(11)	IN
@BANKCODE	nvarchar(25)	IN

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNT_3(
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @ACCOUNTNAME nvarchar(100),
                        @ACCOUNTNUMBER nvarchar(50),
                        @ROUTINGNUMBER nvarchar(9),
                        @ACCOUNTTYPECODE tinyint,
                        @MINIMUMBALANCE decimal(19, 4),
                        @DEFAULTCASHACCOUNTTYPECODE tinyint,
                        @GLACCOUNTID uniqueidentifier,
                        @PDACCOUNTSEGMENTVALUEID uniqueidentifier,
                        @USERNUMBER nvarchar(24),
                        @CLIENTNAME nvarchar(100),
                        @SORTCODE nvarchar(6),
                        @PDACCOUNTSYSTEMID uniqueidentifier,
                        @TRANSACTIONCURRENCYID uniqueidentifier,
                        @BANKINGSYSTEMID uniqueidentifier,
                        @BIC nvarchar(11),
                        @BANKCODE nvarchar(25)
                    )
                    as

                        set nocount on;

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

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        if @DEFAULTCASHACCOUNTTYPECODE = 0
                            set @PDACCOUNTSEGMENTVALUEID = null;

                        if @DEFAULTCASHACCOUNTTYPECODE = 1
                            set @GLACCOUNTID = null;

                        begin try
                            exec USP_GET_KEY_ACCESS;

                            -- handle updating the data
                            update dbo.BANKACCOUNT set
                                ACCOUNTNAME = @ACCOUNTNAME,
                                ACCOUNTNUMBER = EncryptByKey(key_GUID('sym_BBInfinity'), @ACCOUNTNUMBER),
                                ROUTINGNUMBER = @ROUTINGNUMBER,
                                ACCOUNTTYPECODE = @ACCOUNTTYPECODE,
                                MINIMUMBALANCE = @MINIMUMBALANCE,
                                DEFAULTCASHACCOUNTTYPECODE = @DEFAULTCASHACCOUNTTYPECODE,
                                GLACCOUNTID = @GLACCOUNTID,
                                PDACCOUNTSEGMENTVALUEID = @PDACCOUNTSEGMENTVALUEID,
                                USERNUMBER = @USERNUMBER,
                                CLIENTNAME = @CLIENTNAME,
                                SORTCODE = @SORTCODE,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE,
                                TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID,
                                BANKINGSYSTEMID = @BANKINGSYSTEMID,
                                BIC = @BIC,
                                BANKCODE = @BANKCODE
                            where 
                                ID = @ID;

                        exec USP_CLOSE_KEY_ACCESS;

                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                    return 0;