USP_DATAFORMTEMPLATE_ADD_MOBILE_INTERACTION_PRELOAD

create procedure dbo.USP_DATAFORMTEMPLATE_ADD_MOBILE_INTERACTION_PRELOAD
(
    @CONSTITUENTID uniqueidentifier,
    @CONSTITUENTNAME nvarchar(700) = null output,
    @CURRENTAPPUSERID uniqueidentifier,
    @SITEREQUIRED bit = null output,
    @SITES xml = null output,
    @FUNDRAISERID uniqueidentifier = null output
)
as 
begin
    set nocount on;

    select
        @CONSTITUENTNAME = NF.NAME
    from
        dbo.UFN_CONSTITUENT_DISPLAYNAME(@CONSTITUENTID) NF

    select
        @FUNDRAISERID = CONSTITUENTID
    from dbo.APPUSER
    where ID = @CURRENTAPPUSERID


    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID)

    declare @USERSITEID uniqueidentifier = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
    if @USERSITEID is not null
    begin
        set @SITES = (
            select newid() ID, @USERSITEID SITEID
            for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64
        )
    end
end