USP_DATAFORMTEMPLATE_PRELOAD_ADD_REVENUEBATCHCONSTITUENTACCOUNT

The load procedure used by the edit dataform template "Revenue Batch Constituent Financial Account Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@BYPASSCLIENTUNIQUECHECK	bit	INOUT	Bypass client-component unique check

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_REVENUEBATCHCONSTITUENTACCOUNT
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @BYPASSCLIENTUNIQUECHECK bit = null output
                    )
                    as
                        set nocount on

                        -- Determine if the constituent is a standard constituent or a revenue batch constituent

                        if exists(select 1 from dbo.CONSTITUENT where ID = @CONSTITUENTID)
                        begin
                            -- Check constituent security

                            if (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 0) and
                               (dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_FORCONSTIT(@CURRENTAPPUSERID, '9FD35458-E734-4a26-8D9D-089C0FEDB726', @CONSTITUENTID) = 0)
                            begin
                                raiserror('BBERR_DB_RECORDSECURITY_PERMISSION_DENIED', 13, 1)
                                return 1
                            end
                        end

                        set @BYPASSCLIENTUNIQUECHECK = 1