USP_DATAFORMTEMPLATE_VIEW_PAPERLESSMANDATESCONFIGURATION

The load procedure used by the view dataform template "Paperless Mandates Configuration View Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ENABLED	bit	INOUT	Use paperless mandates
@DAYSADVANCEDNOTICE	int	INOUT	Days of advanced notice

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PAPERLESSMANDATESCONFIGURATION
            (
                @DATALOADED bit = 0 output,
                @ENABLED bit = null output,
                @DAYSADVANCEDNOTICE integer = null output
            )
            as
                set nocount on;

                set @DATALOADED = 1;
                set @ENABLED = 0;

                select top(1)
                    @ENABLED = 1,
                    @DAYSADVANCEDNOTICE = DAYSADVANCEDNOTICE    
                from dbo.PAPERLESSMANDATESCONFIGURATION

                return 0;