USP_DATAFORMTEMPLATE_ADD_PLANNEDGIFTADDITION_PRELOAD

The load procedure used by the edit dataform template "Planned Gift Addition Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency
@CONSTITUENTLOOKUPID	nvarchar(36)	INOUT
@CONSTITUENTFIRSTNAME	nvarchar(50)	INOUT
@CONSTITUENTKEYNAME	nvarchar(100)	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@DONOTRECEIPT	bit	INOUT	Do not receipt
@DONOTRECEIPT_LOCKED	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PLANNEDGIFTADDITION_PRELOAD
(
  @PLANNEDGIFTID uniqueidentifier,
  @BASECURRENCYID uniqueidentifier = null output,
  @TRANSACTIONCURRENCYID uniqueidentifier = null output,
  @CONSTITUENTLOOKUPID nvarchar(36) = null output,
  @CONSTITUENTFIRSTNAME nvarchar(50) = null output,
  @CONSTITUENTKEYNAME nvarchar(100) = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @CONSTITUENTID uniqueidentifier = null output,
  @DONOTRECEIPT bit = null output,
  @DONOTRECEIPT_LOCKED bit = null output
)
as
  set nocount on;

  select
    @TRANSACTIONCURRENCYID = TRANSACTIONCURRENCYID,
    @BASECURRENCYID = BASECURRENCYID,
    @DONOTRECEIPT = DONOTRECEIPT,
    @DONOTRECEIPT_LOCKED =
      case when ISREVOCABLE != 0 or TRUSTHELDOUTSIDE != 0 or dbo.UFN_PLANNEDGIFT_ISRECEIPTABLE(PLANNEDGIFT.VEHICLECODE) = 0
        then 1
        else 0
      end
  from
    dbo.PLANNEDGIFT
  where
  ID = @PLANNEDGIFTID;

  select
    @CONSTITUENTLOOKUPID = C.LOOKUPID,
    @CONSTITUENTFIRSTNAME = C.FIRSTNAME,
    @CONSTITUENTKEYNAME = C.KEYNAME,
    @CONSTITUENTID = C.ID
  from
    dbo.PLANNEDGIFT
    inner join dbo.CONSTITUENT C on C.ID = PLANNEDGIFT.CONSTITUENTID
  where
    PLANNEDGIFT.ID = @PLANNEDGIFTID;

  return 0;