USP_DATAFORMTEMPLATE_EDIT_BANK

The save procedure used by the edit dataform template "Bank Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DEFAULTROUTINGNUMBER	nvarchar(9)	IN	Routing number
@DEFAULTSORTCODE	nvarchar(6)	IN	Sort code

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BANK
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DEFAULTROUTINGNUMBER nvarchar(9),
    @DEFAULTSORTCODE nvarchar(6)
)

as
  set nocount on;

  declare @DEFAULTBANKINGSYSTEMID uniqueidentifier;
  declare @DEFAULTBIC nvarchar(11);
  declare @DEFAULTBANKCODE nvarchar(25);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BANK
        @ID = @ID,
        @DEFAULTBANKINGSYSTEMID = @DEFAULTBANKINGSYSTEMID output,
        @DEFAULTBIC = @DEFAULTBIC output,
        @DEFAULTBANKCODE = @DEFAULTBANKCODE output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BANK_2
        @ID,
        @CHANGEAGENTID,
        @DEFAULTROUTINGNUMBER,
        @DEFAULTSORTCODE,
        @DEFAULTBANKINGSYSTEMID,
        @DEFAULTBIC,
        @DEFAULTBANKCODE;

  return 0;