USP_DATAFORMTEMPLATE_ADD_INTERACTIONWITHOUTCONSTITUENT_PRELOAD

create procedure dbo.USP_DATAFORMTEMPLATE_ADD_INTERACTIONWITHOUTCONSTITUENT_PRELOAD
(
    @CURRENTAPPUSERID uniqueidentifier,
    @SITEREQUIRED bit = null output,
    @SITES xml = null output
)
as 
begin
    set nocount on;

    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