USP_DATAFORMTEMPLATE_ADD_GENERATEBATCHPROCESS_PRELOAD

The load procedure used by the edit dataform template "Generate 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
@REVENUERECORDTYPEID	uniqueidentifier	INOUT
@DISPLAYTOTALAMOUNT	bit	INOUT
@SITEID	uniqueidentifier	INOUT

Definition

Copy



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

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

    select @REVENUERECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'REVENUE';

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

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

    return 0;