USP_DATAFORMTEMPLATE_VIEW_OPPORTUNITYPAGEDATA

The load procedure used by the view dataform template "Opportunity Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PROSPECTID	uniqueidentifier	INOUT	PROSPECTID
@PROSPECT	nvarchar(154)	INOUT	PROSPECT
@ISACTIVEPROSPECT	bit	INOUT	ISACTIVEPROSPECT
@PROSPECTPLANID	uniqueidentifier	INOUT	PROSPECTPLANID
@PROSPECTPLAN	nvarchar(100)	INOUT	PROSPECTPLAN
@AMOUNT	money	INOUT	AMOUNT
@STATUS	nvarchar(100)	INOUT	STATUS
@STATUSCODE	tinyint	INOUT	STATUSCODE
@ISGROUP	bit	INOUT	ISGROUP
@CANADDPAYMENT	bit	INOUT	CANADDPAYMENT
@ATTRIBUTEDEFINED	bit	INOUT	ATTRIBUTEDEFINED
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	TRANSACTIONCURRENCYID
@TRANSACTIONAMOUNT	money	INOUT	TRANSACTIONAMOUNT
@HASAVAILABLESOLICITORS	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_OPPORTUNITYPAGEDATA
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @PROSPECTID uniqueidentifier = null output,
  @PROSPECT nvarchar(154) = null output,
  @ISACTIVEPROSPECT bit = null output,
  @PROSPECTPLANID uniqueidentifier = null output,
  @PROSPECTPLAN nvarchar(100) = null output,
  @AMOUNT money = null output,
  @STATUS nvarchar(100) = null output,
  @STATUSCODE tinyint = null output,
  @ISGROUP bit = null output,
  @CANADDPAYMENT bit = null output,
  @ATTRIBUTEDEFINED bit = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @TRANSACTIONCURRENCYID uniqueidentifier = null output,
  @TRANSACTIONAMOUNT money = null output,
  @HASAVAILABLESOLICITORS bit = null output
)
as begin
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @PROSPECTID = PP.PROSPECTID,
    @PROSPECT = C.NAME,
    @ISACTIVEPROSPECT = dbo.UFN_CONSTITUENT_ISPROSPECT(PP.PROSPECTID),
    @PROSPECTPLANID = PP.ID,
    @PROSPECTPLAN = STC.DESCRIPTION,
    @AMOUNT = O.AMOUNT,
    @STATUS = O.STATUS,
    @STATUSCODE = O.STATUSCODE,
    @ISGROUP = C.ISGROUP,
    @CANADDPAYMENT = 0,
    @TRANSACTIONCURRENCYID = O.TRANSACTIONCURRENCYID,
    @TRANSACTIONAMOUNT = O.TRANSACTIONAMOUNT
  from
    dbo.OPPORTUNITY O
  inner join
    dbo.PROSPECTPLAN PP on PP.ID = O.PROSPECTPLANID
  inner join
    dbo.CONSTITUENT C on C.ID = PP.PROSPECTID
  inner join
    dbo.PROSPECTPLANTYPECODE STC on STC.ID = PP.PROSPECTPLANTYPECODEID
  where
    O.ID = @ID;

  set @CANADDPAYMENT = 0;

  if exists(select top 1 ID from dbo.OPPORTUNITYDESIGNATION where OPPORTUNITYID = @ID)
    set @CANADDPAYMENT = 1;

  set @HASAVAILABLESOLICITORS = 0;

  if exists(select top 1 1 from dbo.UFN_OPPORTUNITY_GETSOLICITORS(@ID, 0))
    set @HASAVAILABLESOLICITORS = 1;

  set @ATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE_FORAPPUSER('Opportunity',@CURRENTAPPUSERID);

  return 0;
end