USP_BATCH2_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@BATCHNUMBER	nvarchar(100)	IN
@DESCRIPTION	nvarchar(1000)	IN
@OWNERID	uniqueidentifier	IN
@BATCHTEMPLATEID	uniqueidentifier	IN
@BATCHWORKFLOWSTATEID	uniqueidentifier	IN
@FORMDEFINITIONXML	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ORIGINATINGBATCHID	uniqueidentifier	IN
@AUTOSAVEONROWCHANGE	bit	IN
@AUTOMATCHTHRESHOLD	decimal(20, 4)	IN
@OVERALLMATCHTHRESHOLD	decimal(20, 4)	IN
@PARAMETERSXML	xml	IN
@PROJECTEDNUMBEROFRECORDS	int	IN
@PROJECTEDTOTALAMOUNT	money	IN
@DISABLEADDNEWROW	bit	IN
@CHECKFORDUPLICATES	bit	IN

Definition

Copy



CREATE procedure dbo.USP_BATCH2_ADD  
(  
    @ID uniqueidentifier = null,   
    @BATCHNUMBER nvarchar(100) = '',  
    @DESCRIPTION nvarchar(1000) = '',  
    @OWNERID uniqueidentifier = null,              
    @BATCHTEMPLATEID uniqueidentifier,
    @BATCHWORKFLOWSTATEID uniqueidentifier, 
    @FORMDEFINITIONXML xml = null,
    @CHANGEAGENTID uniqueidentifier = null,  
    @ORIGINATINGBATCHID uniqueidentifier = null,      
    @AUTOSAVEONROWCHANGE bit = 0,  
    @AUTOMATCHTHRESHOLD decimal(20, 4) = 0,  
    @OVERALLMATCHTHRESHOLD decimal(20, 4) = 0,  
    @PARAMETERSXML xml = null, 
    @PROJECTEDNUMBEROFRECORDS int = 0,  
    @PROJECTEDTOTALAMOUNT money = 0,  
    @DISABLEADDNEWROW bit = 0,
    @CHECKFORDUPLICATES bit = null   
)  
as  
    set nocount on;  

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

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

    declare @CREATEEXCEPTIONBATCH bit ;  
    declare @PURGEBATCH bit ;  
    declare @CREATECONTROLREPORT bit;  
    declare @VALIDATEBATCH bit;  
    declare @CHECKFORDUPLICATERECORDS bit;  

    select  
      @CREATEEXCEPTIONBATCH = BATCHTEMPLATE.DEFAULTCREATEEXCEPTIONBATCH,  
      @CREATECONTROLREPORT = BATCHTEMPLATE.DEFAULTCREATECONTROLREPORT,  
      @VALIDATEBATCH = BATCHTEMPLATE.DEFAULTVALIDATEBEFORECOMMIT,  
      @PURGEBATCH = BATCHTEMPLATE.DEFAULTDELETEBATCHAFTERCOMMIT,  
      @CHECKFORDUPLICATERECORDS = BATCHTEMPLATE.DEFAULTCHECKFORDUPLICATES  
    from  
      dbo.BATCHTEMPLATE  
    where  
      BATCHTEMPLATE.ID = @BATCHTEMPLATEID;  

      -- BAL 11.29.2011 Allow passing in this value  

    if @CHECKFORDUPLICATES is not null  
        set @CHECKFORDUPLICATERECORDS = @CHECKFORDUPLICATES; 

      insert into dbo.BATCH (  
      ID,  
      BATCHNUMBER,  
      DESCRIPTION,  
      PROJECTEDNUMBEROFRECORDS,  
      PROJECTEDTOTALAMOUNT,  
      BATCHTEMPLATEID,  
      APPUSERID,  
      BATCHWORKFLOWSTATEID,  
      ORIGINATINGBATCHID,  
      FORMDEFINITIONXML,  
      AUTOSAVEONROWCHANGE,  
      VALIDATEBATCH,  
      CHECKFORDUPLICATERECORDS,  
      CREATEEXCEPTIONBATCH,  
      PURGEBATCH,  
      CREATECONTROLREPORT,  
      ADDEDBYID,  
      CHANGEDBYID,  
      DATEADDED,  
      DATECHANGED,  
      AUTOMATCHTHRESHOLD,  
      OVERALLMATCHTHRESHOLD,  
      PARAMETERSXML,  
    DISABLEADDNEWROW  
    )  
    values (  
      @ID,  
      @BATCHNUMBER,  
      @DESCRIPTION,  
      coalesce(@PROJECTEDNUMBEROFRECORDS, 0),  
      @PROJECTEDTOTALAMOUNT,  
      @BATCHTEMPLATEID,  
      @OWNERID,  
      @BATCHWORKFLOWSTATEID,  
      @ORIGINATINGBATCHID,  
      @FORMDEFINITIONXML,  
      coalesce(@AUTOSAVEONROWCHANGE, 0),  
      @VALIDATEBATCH,  
      @CHECKFORDUPLICATERECORDS,  
      @CREATEEXCEPTIONBATCH,  
      @PURGEBATCH,  
      @CREATECONTROLREPORT,  
      @CHANGEAGENTID,  
      @CHANGEAGENTID,  
      @CHANGEDATE,  
      @CHANGEDATE,  
      @AUTOMATCHTHRESHOLD,  
      @OVERALLMATCHTHRESHOLD,  
      @PARAMETERSXML,  
    @DISABLEADDNEWROW  
    );  

    if @BATCHWORKFLOWSTATEID is not null  
      insert into dbo.BATCHWORKFLOWSTATUS (  
        BATCHID,  
        APPUSERID,  
        BATCHWORKFLOWSTATEID,  
        ADDEDBYID,  
        CHANGEDBYID,  
        DATEADDED,  
        DATECHANGED,  
        APPUSERNAME  
      )  
      values (  
        @ID,  
        @OWNERID,  
        @BATCHWORKFLOWSTATEID,  
        @CHANGEAGENTID,  
        @CHANGEAGENTID,  
        @CHANGEDATE,  
        @CHANGEDATE,  
        COALESCE(dbo.UFN_APPUSER_GETNAME(@OWNERID),'')  
      ); 

      return 0;