USP_DATALIST_AUCTIONITEMBATCHGROUPRELATIONSHIPTREE

Returns the relationship tree for a given constituent in an auction item batch.
Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
Definition

Copy


                    CREATE procedure dbo.USP_DATALIST_AUCTIONITEMBATCHGROUPRELATIONSHIPTREE
                (
                    @CONSTITUENTID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier
                 ) as
                    set nocount on;                    

                    select @CONSTITUENTID = EXISTINGCONSTITUENTID from dbo.BATCHAUCTIONITEMCONSTITUENT
                    where ID = @CONSTITUENTID and EXISTINGCONSTITUENTID is not null

                    -- Determine if the ID passed in is an actual constituent ID or an ID from BATCHAUCTIONITEMCONSTITUENT.

                    -- Revenue batch uses this list for the edit group screen.

                    if exists (select ID from dbo.CONSTITUENT where ID = @CONSTITUENTID)
                    begin
                        -- Check security for this constituent.  Using UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT

                        -- since this form's security is implied through other forms.

                        declare @ISADMIN bit;
                        declare @APPUSER_IN_NONRACROLE bit;
                        declare @APPUSER_IN_NOSECGROUPROLE bit;
                        declare @APPUSER_IN_NONSITEROLE bit;
                        declare @APPUSER_IN_NOSITEROLE bit;

                        set @ISADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);

                        if @ISADMIN = 0
                            set @APPUSER_IN_NONRACROLE = dbo.UFN_SECURITY_APPUSER_IN_NONRACROLE(@CURRENTAPPUSERID);

                        if @ISADMIN = 0 and @APPUSER_IN_NONRACROLE = 0
                            set @APPUSER_IN_NOSECGROUPROLE = dbo.UFN_SECURITY_APPUSER_IN_NO_SECURITY_GROUP_ROLE(@CURRENTAPPUSERID);

                        set @APPUSER_IN_NONSITEROLE = dbo.UFN_SECURITY_APPUSER_IN_NONSITEROLE(@CURRENTAPPUSERID);
                        set @APPUSER_IN_NOSITEROLE = dbo.UFN_SECURITY_APPUSER_IN_NO_SITE_ROLE(@CURRENTAPPUSERID);

                        if (@ISADMIN = 0 and 
                                (
                                    (@APPUSER_IN_NONRACROLE = 0 and
                                    dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT(@CURRENTAPPUSERID, @CONSTITUENTID, @APPUSER_IN_NOSECGROUPROLE) = 0)
                                    or
                                    (@APPUSER_IN_NONSITEROLE = 0 and
                                    dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT_BYSITE(@CURRENTAPPUSERID, @CONSTITUENTID, @APPUSER_IN_NOSITEROLE) = 0)
                                )
                            )
                            raiserror('BBERR_DB_RECORDSECURITY_PERMISSION_DENIED', 13, 1)
                    end

                    exec dbo.USP_RELATIONSHIPTREE_GET @CONSTITUENTID, @CURRENTAPPUSERID