UFN_PAPERLESSMANDATES_ENABLED_FORREVENUE

Returns a flag indicating if paperless mandates are enabled for a given revenue.

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@REVENUEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_PAPERLESSMANDATES_ENABLED_FORREVENUE(@REVENUEID uniqueidentifier = null)
            returns integer
            with execute as caller
            as begin
                declare @ENABLED integer;
                set @ENABLED = 0;

                select distinct 
                    @ENABLED = dbo.UFN_PAPERLESSMANDATES_ENABLED_FORSITE(SITEID)
                from
                    dbo.UFN_SITEID_MAPFROM_REVENUEID(@REVENUEID)

                -- Something is really wrong. Set enabled to error state.

                if @@ROWCOUNT > 1
                    set @ENABLED = -1;

                return @ENABLED;
            end