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;