USP_DATAFORMTEMPLATE_PRELOAD_ADD_GRANTAWARDPAYMENT

Stored procedure used to load the grant award payment add form.

Parameters

Parameter	Parameter Type	Mode
@APPLICATIONID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	INOUT
@HOUSEHOLDSCANBEDONORS	bit	INOUT
@VIEWFORMID	uniqueidentifier	INOUT
@DATE	datetime	INOUT
@TRANSACTIONTYPECODE	tinyint	INOUT
@GIFTINKINDUSEAPPRAISALTHRESHOLD	bit	INOUT
@GIFTINKINDAPPRAISALTHRESHOLD	money	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT
@SHOWACCOUNTSYSTEM	bit	INOUT
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT
@BASEEXCHANGERATEID	uniqueidentifier	INOUT
@EXCHANGERATE	decimal(20, 8)	INOUT

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_GRANTAWARDPAYMENT
            (
                @APPLICATIONID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier = null output,
                @HOUSEHOLDSCANBEDONORS bit = null output,
                @VIEWFORMID uniqueidentifier = null output,
                @DATE datetime = null output,
                @TRANSACTIONTYPECODE tinyint = null output,
                @GIFTINKINDUSEAPPRAISALTHRESHOLD bit = null output,
                @GIFTINKINDAPPRAISALTHRESHOLD money = null output,
                @CURRENTAPPUSERID uniqueidentifier = null,
                @PDACCOUNTSYSTEMID uniqueidentifier = null output,
                @SHOWACCOUNTSYSTEM bit = null output,
                @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                @BASEEXCHANGERATEID uniqueidentifier = null output,
                @EXCHANGERATE decimal(20,8) = null output
            )
            as
                set nocount on;

                select @CONSTITUENTID = CONSTITUENTID from dbo.REVENUE where ID = @APPLICATIONID;

                set @HOUSEHOLDSCANBEDONORS = dbo.UFN_INSTALLATIONINFO_GETHOUSEHOLDSCANBEDONORS()
                set @VIEWFORMID = '3AFDF279-6EF0-43CB-BB84-86BDCA72E4E0';
                set @DATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());
                set @TRANSACTIONTYPECODE = 6;
                select top 1
                    @GIFTINKINDUSEAPPRAISALTHRESHOLD = USEAPPRAISALTHRESHOLD,
                    @GIFTINKINDAPPRAISALTHRESHOLD = APPRAISALTHRESHOLD
                from
                    dbo.GIFTINKINDAPPRAISALSETTINGS;

                exec dbo.USP_PAYMENT_APPLICATIONPAYMENTLOADCURRENCY
                    @APPLICATIONID,
                    @DATE,
                    @CURRENTAPPUSERID,
                    @PDACCOUNTSYSTEMID output,
                    @SHOWACCOUNTSYSTEM output,
                    @TRANSACTIONCURRENCYID output,
                    @BASEEXCHANGERATEID output,
                    @EXCHANGERATE output;

            return 0;