USP_DATAFORMTEMPLATE_ADD_GENERATECONSTITUENTUPDATEBATCHPROCESS_PRELOAD

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@CANCHANGEBATCHNUMBERS	bit	INOUT
@CONSTITUENTRECORDTYPEID	uniqueidentifier	INOUT
@SITEID	uniqueidentifier	INOUT

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_ADD_GENERATECONSTITUENTUPDATEBATCHPROCESS_PRELOAD
(
        @CURRENTAPPUSERID uniqueidentifier,
        @CANCHANGEBATCHNUMBERS bit = null output,
        @CONSTITUENTRECORDTYPEID uniqueidentifier = null output,
        @SITEID uniqueidentifier = null output
)
as
    set nocount on;

        set @CANCHANGEBATCHNUMBERS = dbo.UFN_SECURITY_APPUSER_GRANTED_CHANGEBATCHNUMBER(@CURRENTAPPUSERID, null);

        select @CONSTITUENTRECORDTYPEID = ID from dbo.RECORDTYPE where NAME = 'CONSTITUENT';

        set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);

        return 0;