USP_DATAFORMTEMPLATE_ADD_SPONSORSHIP_LOAD_WRAPPED

The load procedure used by the edit dataform template "Constituent Sponsorship Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@FORMTITLE	nvarchar(100)	INOUT
@REVENUECONSTITUENTID	uniqueidentifier	INOUT	Financial sponsor
@SPONSORSHIPCONSTITUENTID	uniqueidentifier	INOUT	Corresponding sponsor
@SPONSORSHIPREASONID	uniqueidentifier	INOUT	Reason
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency
@BASECURRENCYID	uniqueidentifier	INOUT
@BASEAMOUNT	money	INOUT	Base amount
@EXCHANGERATE	decimal(20, 8)	INOUT	Exchange rate
@BASECURRENCYDECIMALDIGITS	tinyint	INOUT	Base currency decimal digits
@BASECURRENCYROUNDINGTYPECODE	tinyint	INOUT	Base currency rounding type code

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIP_LOAD_WRAPPED
(
  @CONTEXTID uniqueidentifier,
  @FORMTITLE nvarchar(100) = null output,
  @REVENUECONSTITUENTID uniqueidentifier = null output,
  @SPONSORSHIPCONSTITUENTID uniqueidentifier = null output,
  @SPONSORSHIPREASONID uniqueidentifier = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @TRANSACTIONCURRENCYID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @BASEAMOUNT money = null output,
  @EXCHANGERATE decimal(20,8) = null output,
  @BASECURRENCYDECIMALDIGITS tinyint = null output,
  @BASECURRENCYROUNDINGTYPECODE tinyint = null output
)
as
  set nocount on;

  declare @r int
  exec @r = dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIP_LOAD 
    @FORMTITLE = @FORMTITLE output, 
    @REVENUECONSTITUENTID = @REVENUECONSTITUENTID output, 
    @SPONSORSHIPCONSTITUENTID = @SPONSORSHIPCONSTITUENTID output, 
    @SPONSORSHIPREASONID = @SPONSORSHIPREASONID output,
    @CURRENTAPPUSERID = @CURRENTAPPUSERID,
    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
    @BASECURRENCYID = @BASECURRENCYID output,
    @BASEAMOUNT = @BASEAMOUNT output,
    @EXCHANGERATE = @EXCHANGERATE output,
    @BASECURRENCYDECIMALDIGITS = @BASECURRENCYDECIMALDIGITS output,
    @BASECURRENCYROUNDINGTYPECODE = @BASECURRENCYROUNDINGTYPECODE output

  set @SPONSORSHIPCONSTITUENTID = @CONTEXTID
  set @REVENUECONSTITUENTID = @CONTEXTID

  if @@error <> 0 
    begin
      if @r <> 0 return @r
      return 1;
    end

  return @r;