USP_DATAFORMTEMPLATE_ADD_SPONSORSHIP_LOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@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
@REVENUEDEVELOPMENTFUNCTIONCODEID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIP_LOAD
(
    @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,
    @REVENUEDEVELOPMENTFUNCTIONCODEID uniqueidentifier = null output
)
as
    set nocount on;

    set @FORMTITLE = 'Add a sponsorship';
    set @BASECURRENCYID = dbo.UFN_APPUSER_GETBASECURRENCY(@CURRENTAPPUSERID);
    set @TRANSACTIONCURRENCYID = @BASECURRENCYID;
    set @EXCHANGERATE = 1;

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

    return 0;