USP_DATAFORMTEMPLATE_ADD_GENERATESTEPUPDATEBATCHPROCESS_PRELOAD
The load procedure used by the edit dataform template "Generate Step Update Batch Process Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @CANCHANGEBATCHNUMBERS | bit | INOUT | |
| @RECORDTYPEID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_GENERATESTEPUPDATEBATCHPROCESS_PRELOAD
(
@CURRENTAPPUSERID uniqueidentifier,
@CANCHANGEBATCHNUMBERS bit = null output,
@RECORDTYPEID uniqueidentifier = null output
)
as
set nocount on;
set @CANCHANGEBATCHNUMBERS = dbo.UFN_SECURITY_APPUSER_GRANTED_CHANGEBATCHNUMBER(@CURRENTAPPUSERID, null);
select
@RECORDTYPEID = ID
from dbo.RECORDTYPE
where upper(NAME) = 'STEWARDSHIP PLAN STEP';
return 0;