USP_DATAFORMTEMPLATE_PRELOAD_RECURRINGGIFTFROMCONSTITUENT_PAYMENT

The load procedure used by the edit dataform template "Recurring Gift From Constituent Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SINGLEDESIGNATIONID	uniqueidentifier	INOUT	Designation
@HOUSEHOLDSCANBEDONORS	bit	INOUT	Households can be donors
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@BASECURRENCYDECIMALDIGITS	tinyint	INOUT	Base currency decimal digits
@BASECURRENCYROUNDINGTYPECODE	tinyint	INOUT	Base currency rounding type code
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_RECURRINGGIFTFROMCONSTITUENT_PAYMENT
(
  @SINGLEDESIGNATIONID uniqueidentifier = null output,
  @HOUSEHOLDSCANBEDONORS bit = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @BASECURRENCYDECIMALDIGITS tinyint = null output,
  @BASECURRENCYROUNDINGTYPECODE tinyint = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @CONTEXTID uniqueidentifier
)
as
  set nocount on;

  -- Leaving SINGLEDESIGNATIONID as null.  No value needs to be set for it since

  -- it existed as a readonly field before the load SP was added.


  set @HOUSEHOLDSCANBEDONORS = dbo.UFN_INSTALLATIONINFO_GETHOUSEHOLDSCANBEDONORS();
  set @BASECURRENCYID = dbo.UFN_APPUSER_GETBASECURRENCY(@CURRENTAPPUSERID);

  select
    @BASECURRENCYDECIMALDIGITS = DECIMALDIGITS,
    @BASECURRENCYROUNDINGTYPECODE = ROUNDINGTYPECODE
  from dbo.CURRENCY
  where ID = @BASECURRENCYID;

  return 0;