USP_DATAFORMTEMPLATE_EDIT_BATCH2TEMPLATE_3
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN | |
@CHANGEAGENTID | uniqueidentifier | IN | |
@NAME | nvarchar(60) | IN | |
@DESCRIPTION | nvarchar(1000) | IN | |
@BATCHWORKFLOWID | uniqueidentifier | IN | |
@AUTOSAVEONROWCHANGE | bit | IN | |
@NUMBERINGSCHEMEID | uniqueidentifier | IN | |
@BATCHFIELDS | xml | IN | |
@VALIDATEBATCH | bit | IN | |
@CHECKFORDUPLICATERECORDS | bit | IN | |
@PURGEBATCH | bit | IN | |
@CREATEEXCEPTIONBATCH | bit | IN | |
@CREATECONTROLREPORT | bit | IN | |
@BATCHTYPECATALOGID | uniqueidentifier | IN | |
@IMPORTONLY | bit | IN | |
@TEMPLATEPERMISSIONS | xml | IN | |
@CUSTOMIZEPERMISSIONS | xml | IN | |
@SITEID | uniqueidentifier | IN | |
@TEMPLATEUSECODE | tinyint | IN | |
@AUTOMATCHTHRESHOLD | int | IN | |
@OVERALLMATCHTHRESHOLD | int | IN | |
@PARAMETERSXML | xml | IN |
Definition
Copy
CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BATCH2TEMPLATE_3
(
@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, @AUTOMATCHTHRESHOLD int, @OVERALLMATCHTHRESHOLD int, @PARAMETERSXML xml
)
as
set nocount on;
declare @USEGLOBALMATCHSETTINGS bit;
exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCH2TEMPLATE
@ID = @ID,
@USEGLOBALMATCHSETTINGS = @USEGLOBALMATCHSETTINGS output
exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCH2TEMPLATE_4
@ID,
@CHANGEAGENTID,
@NAME,
@DESCRIPTION,
@BATCHWORKFLOWID,
@AUTOSAVEONROWCHANGE,
@NUMBERINGSCHEMEID,
@BATCHFIELDS,
@VALIDATEBATCH,
@CHECKFORDUPLICATERECORDS,
@PURGEBATCH,
@CREATEEXCEPTIONBATCH,
@CREATECONTROLREPORT,
@BATCHTYPECATALOGID,
@IMPORTONLY,
@TEMPLATEPERMISSIONS,
@CUSTOMIZEPERMISSIONS,
@SITEID,
@TEMPLATEUSECODE,
@AUTOMATCHTHRESHOLD,
@OVERALLMATCHTHRESHOLD,
@PARAMETERSXML,
@USEGLOBALMATCHSETTINGS
return 0;