USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYOPPORTUNITIESTILE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@OPPORTUNITIES	xml	INOUT
@ISPROSPECT	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYOPPORTUNITIESTILE
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @OPPORTUNITIES xml = null output,
  @ISPROSPECT bit = null output
)
as
  set nocount on;

  set @ISPROSPECT = dbo.UFN_CONSTITUENT_ISPROSPECT(@ID);
  set @OPPORTUNITIES = dbo.UFN_CONSTITUENT_GETOPPORTUNITIES_TOITEMLISTXML(@ID,@CURRENTAPPUSERID,'34918f75-add3-4a6e-bd9f-0cdba9307af4',1);

  set @DATALOADED = 0;
  if exists(select 1 from dbo.CONSTITUENT where ID = @ID)
    set @DATALOADED = 1;

  return 0;