USP_DATAFORMTEMPLATE_PRELOAD_REGISTRANTBATCH_ADD

The load procedure used by the edit dataform template "RegistrantBatchTemplate Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DISPLAYTOTALAMOUNT	bit	INOUT
@CANCHANGEBATCHNUMBERS	bit	INOUT	Can change batch numbers

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_REGISTRANTBATCH_ADD
(          
    @CURRENTAPPUSERID uniqueidentifier
    , @DISPLAYTOTALAMOUNT bit = null output
    , @CANCHANGEBATCHNUMBERS bit = null output
)
as
    set nocount on;

    set @DISPLAYTOTALAMOUNT = 0;

    select top 1
        @DISPLAYTOTALAMOUNT = 1
    from
        dbo.BATCHTEMPLATE
        inner join BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
    where
        (len(BATCHTYPECATALOG.AMOUNTCOLUMN) > 0)
        and (dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHPROCESSOR(@CURRENTAPPUSERID, BATCHTEMPLATE.ID) = 1);

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

    return 0;