USP_DATAFORMTEMPLATE_EDITLOAD_PROSPECTSEARCHCUSTOMIZETILES

Parameters

Parameter Parameter Type Mode Description
@CURRENTAPPUSERID uniqueidentifier IN
@DATALOADED bit INOUT
@AVAILABLETILES xml INOUT
@SELECTEDTILES xml INOUT

Definition

Copy

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PROSPECTSEARCHCUSTOMIZETILES
(
        @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @AVAILABLETILES xml = null output,
    @SELECTEDTILES xml = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

  set @AVAILABLETILES = dbo.UFN_PROSPECTSEARCH_GET_AVAILABLETILES_TOITEMLISTXML();
  set @SELECTEDTILES = dbo.UFN_PROSPECTSEARCH_GET_SELECTEDTILES_TOITEMLISTXML(@CURRENTAPPUSERID);

    set @DATALOADED = 1;

    return 0;