USP_DATAFORMTEMPLATE_EDIT_BATCH2TEMPLATE

The save procedure used by the edit dataform template "Batch Template 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.
@NAME	nvarchar(60)	IN	Batch template name
@DESCRIPTION	nvarchar(1000)	IN	Description
@BATCHWORKFLOWID	uniqueidentifier	IN	Workflow name
@AUTOSAVEONROWCHANGE	bit	IN	Enable auto-save
@NUMBERINGSCHEMEID	uniqueidentifier	IN	Numbering scheme
@BATCHFIELDS	xml	IN	Selected fields for the batch
@VALIDATEBATCH	bit	IN	Validate batch before committing
@CHECKFORDUPLICATERECORDS	bit	IN	Check for duplicate constituents
@PURGEBATCH	bit	IN	Delete batch after committing
@CREATEEXCEPTIONBATCH	bit	IN	Create exception batch
@CREATECONTROLREPORT	bit	IN	Create control report
@BATCHTYPECATALOGID	uniqueidentifier	IN	Select a batch type
@IMPORTONLY	bit	IN	This template is only used for importing data
@TEMPLATEPERMISSIONS	xml	IN	Assign batch template administrator permissions
@CUSTOMIZEPERMISSIONS	xml	IN	Assign permissions to customize batch field options
@SITEID	uniqueidentifier	IN	Site
@TEMPLATEUSECODE	tinyint	IN	Template use

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCH2TEMPLATE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(60),
  @DESCRIPTION nvarchar(1000),
  @BATCHWORKFLOWID uniqueidentifier,
  @AUTOSAVEONROWCHANGE bit,
  @NUMBERINGSCHEMEID uniqueidentifier,
  @BATCHFIELDS xml,
  @VALIDATEBATCH bit,
  @CHECKFORDUPLICATERECORDS bit,
  @PURGEBATCH bit,
  @CREATEEXCEPTIONBATCH bit,
  @CREATECONTROLREPORT bit,
  @BATCHTYPECATALOGID uniqueidentifier,
  @IMPORTONLY bit,
  @TEMPLATEPERMISSIONS xml,
  @CUSTOMIZEPERMISSIONS xml,
  @SITEID uniqueidentifier,
  @TEMPLATEUSECODE tinyint
)
as

    declare @AUTOMATCHTHRESHOLD bit;
    declare @OVERALLMATCHTHRESHOLD bit;

    begin try
        exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCH2TEMPLATE
            @ID = @ID, 
            @AUTOMATCHTHRESHOLD = @AUTOMATCHTHRESHOLD output,
            @OVERALLMATCHTHRESHOLD = @OVERALLMATCHTHRESHOLD output

        exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCH2TEMPLATE
            @ID = @ID,
            @CHANGEAGENTID = @CHANGEAGENTID,
            @NAME = @NAME,
            @DESCRIPTION = @DESCRIPTION,
            @BATCHWORKFLOWID = @BATCHWORKFLOWID,
            @AUTOSAVEONROWCHANGE = @AUTOSAVEONROWCHANGE,
            @NUMBERINGSCHEMEID = @NUMBERINGSCHEMEID,
            @BATCHFIELDS = @BATCHFIELDS,
            @VALIDATEBATCH = @VALIDATEBATCH,
            @CHECKFORDUPLICATERECORDS = @CHECKFORDUPLICATERECORDS,
            @PURGEBATCH = @PURGEBATCH,
            @CREATEEXCEPTIONBATCH = @CREATEEXCEPTIONBATCH,
            @CREATECONTROLREPORT = @CREATECONTROLREPORT,
            @BATCHTYPECATALOGID = @BATCHTYPECATALOGID,
            @IMPORTONLY = @IMPORTONLY,
            @TEMPLATEPERMISSIONS = @TEMPLATEPERMISSIONS,
            @CUSTOMIZEPERMISSIONS = @CUSTOMIZEPERMISSIONS,
            @SITEID = @SITEID,
            @TEMPLATEUSECODE = @TEMPLATEUSECODE,
            @AUTOMATCHTHRESHOLD = @AUTOMATCHTHRESHOLD,
            @OVERALLMATCHTHRESHOLD = @OVERALLMATCHTHRESHOLD
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch
    return 0;

return 0