USP_BATCHTEMPLATE_UPDATEDEFAULTS

Sets the defaults for a Batch Template.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NUMBERINGSCHEMEID	uniqueidentifier	IN
@AUTOSAVEONROWCHANGE	bit	IN
@VALIDATEBATCH	bit	IN
@CHECKFORDUPLICATERECORDS	bit	IN
@PURGEBATCH	bit	IN
@CREATEEXCEPTIONBATCH	bit	IN
@CREATECONTROLREPORT	bit	IN
@IMPORTONLY	bit	IN
@TEMPLATEUSECODE	tinyint	IN

Definition

Copy



create procedure dbo.USP_BATCHTEMPLATE_UPDATEDEFAULTS 
(
  @ID uniqueidentifier
  , @CHANGEAGENTID uniqueidentifier
  , @NUMBERINGSCHEMEID uniqueidentifier = null
  , @AUTOSAVEONROWCHANGE bit = 0
  , @VALIDATEBATCH bit = 0
  , @CHECKFORDUPLICATERECORDS bit = 1
  , @PURGEBATCH bit = 0
  , @CREATEEXCEPTIONBATCH bit = 1
  , @CREATECONTROLREPORT bit = 0
  , @IMPORTONLY bit = 0
  , @TEMPLATEUSECODE tinyint = 0
)
as
begin

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

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

  update BATCHTEMPLATE set 
    BATCHNUMBERINGSCHEMEID = @NUMBERINGSCHEMEID
    , DEFAULTVALIDATEBEFORECOMMIT = @VALIDATEBATCH
    , DEFAULTCHECKFORDUPLICATES = @CHECKFORDUPLICATERECORDS
    , DEFAULTDELETEBATCHAFTERCOMMIT = @PURGEBATCH
    , DEFAULTCREATEEXCEPTIONBATCH = @CREATEEXCEPTIONBATCH
    , DEFAULTCREATECONTROLREPORT = @CREATECONTROLREPORT
    , AUTOSAVEONROWCHANGE = @AUTOSAVEONROWCHANGE
    , IMPORTONLY  = @IMPORTONLY
    , CHANGEDBYID = @CHANGEAGENTID
    , DATECHANGED = @CURRENTDATE
    , TEMPLATEUSECODE = @TEMPLATEUSECODE
  where ID = @ID;

end;