USP_DATAFORMTEMPLATE_EDIT_BANK_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DEFAULTROUTINGNUMBER	nvarchar(9)	IN
@DEFAULTSORTCODE	nvarchar(6)	IN
@DEFAULTBANKINGSYSTEMID	uniqueidentifier	IN
@DEFAULTBIC	nvarchar(11)	IN
@DEFAULTBANKCODE	nvarchar(25)	IN

Definition

Copy


                    create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BANK_2 (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @DEFAULTROUTINGNUMBER nvarchar(9),
                        @DEFAULTSORTCODE nvarchar(6),
                        @DEFAULTBANKINGSYSTEMID uniqueidentifier,
                        @DEFAULTBIC nvarchar(11),
                        @DEFAULTBANKCODE nvarchar(25)
                    )
                    as

                        set nocount on;

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

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

                        begin try

                            -- handle updating the data
                            update dbo.BANK 
                            set
                                DEFAULTBANKINGSYSTEMID = @DEFAULTBANKINGSYSTEMID,
                                DEFAULTROUTINGNUMBER = @DEFAULTROUTINGNUMBER,
                                DEFAULTSORTCODE = @DEFAULTSORTCODE,
                                DEFAULTBIC = @DEFAULTBIC,
                                DEFAULTBANKCODE = @DEFAULTBANKCODE,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                            where 
                                ID = @ID;
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                    return 0;