USP_DATAFORMTEMPLATE_VIEW_REVALUECOMMITMENTSBUSINESSPROCESSPROFILE

The load procedure used by the view dataform template "Revalue Foreign-Denominated Commitments Business Process Profile View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@REVALUEBYTYPECODE	tinyint	INOUT	Revalue by
@REVALUEBYTYPE	nvarchar(50)	INOUT	Revalue by
@INCLUDEGRANTAWARDS	bit	INOUT	Grant awards
@INCLUDEPLANNEDGIFTS	bit	INOUT	Planned gifts
@INCLUDEPLEDGES	bit	INOUT	Pledges
@INCLUDERECURRINGGIFTS	bit	INOUT	Recurring gifts
@IDSETREGISTERNAME	nvarchar(300)	INOUT	Selection
@CURRENCYEXCHANGERATEASOFDATETIMEOFFSET	datetimeoffset	INOUT	Date
@TIMEZONEENTRYNAME	nvarchar(200)	INOUT	Time zone
@CURRENCYEXCHANGERATESOURCECODEDESCRIPTION	nvarchar(100)	INOUT	Source
@ADJUSTMENTDATE	date	INOUT	Adjustment date
@ADJUSTMENTPOSTDATE	date	INOUT	Adjustment post date
@ADJUSTMENTPOSTSTATUSCODE	tinyint	INOUT	Adjustment post status
@ADJUSTMENTPOSTSTATUS	nvarchar(50)	INOUT	Adjustment post status
@ADJUSTMENTREASONCODETRANSLATION	nvarchar(63)	INOUT	Adjustment reason
@ADJUSTMENTREASON	nvarchar(300)	INOUT	Adjustment details
@CREATEOUTPUTIDSET	bit	INOUT	Create selection from results
@OUTPUTIDSETRECORDTYPENAME	nvarchar(50)	INOUT	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@CREATEEXCEPTIONIDSET	bit	INOUT	Create selection of exceptions
@EXCEPTIONIDSETNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEEXCEPTIONIDSET	bit	INOUT	Overwrite existing selection
@USEEXCHANGERATEDATEFORADJUSTMENTDATES	bit	INOUT	Default dates to the same date from which exchange rates will be selected.
@INCLUDEINSTALLMENTPLANS	bit	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REVALUECOMMITMENTSBUSINESSPROCESSPROFILE
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @REVALUEBYTYPECODE tinyint = null output,
                    @REVALUEBYTYPE nvarchar(50) = null output,
                    @INCLUDEGRANTAWARDS bit = null output,
                    @INCLUDEPLANNEDGIFTS bit = null output,
                    @INCLUDEPLEDGES bit = null output,
                    @INCLUDERECURRINGGIFTS bit = null output,
                    @IDSETREGISTERNAME nvarchar(300) = null output,
                    @CURRENCYEXCHANGERATEASOFDATETIMEOFFSET datetimeoffset(3) = null output,
                    @TIMEZONEENTRYNAME nvarchar(200) = null output,
                    @CURRENCYEXCHANGERATESOURCECODEDESCRIPTION nvarchar(100) = null output,
                    @ADJUSTMENTDATE date = null output,
                    @ADJUSTMENTPOSTDATE date = null output,
                    @ADJUSTMENTPOSTSTATUSCODE tinyint = null output,
                    @ADJUSTMENTPOSTSTATUS nvarchar(50) = null output,
                    @ADJUSTMENTREASONCODETRANSLATION nvarchar(63) = null output,
                    @ADJUSTMENTREASON nvarchar(300) = null output,
                    @CREATEOUTPUTIDSET bit = null output,
                    @OUTPUTIDSETRECORDTYPENAME nvarchar(50) = null output,
                    @OUTPUTIDSETNAME nvarchar(100) = null output,
                    @OVERWRITEOUTPUTIDSET bit = null output,
                    @CREATEEXCEPTIONIDSET bit = null output,
                    @EXCEPTIONIDSETNAME nvarchar(100) = null output,
                    @OVERWRITEEXCEPTIONIDSET bit = null output,
                    @USEEXCHANGERATEDATEFORADJUSTMENTDATES bit = null output,
                    @INCLUDEINSTALLMENTPLANS bit = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @NAME = REVALUECOMMITMENTSPROCESS.NAME,
                        @DESCRIPTION = REVALUECOMMITMENTSPROCESS.DESCRIPTION,
                        @REVALUEBYTYPECODE = REVALUECOMMITMENTSPROCESS.REVALUEBYTYPECODE,
                        @REVALUEBYTYPE = REVALUECOMMITMENTSPROCESS.REVALUEBYTYPE,
                        @INCLUDEGRANTAWARDS = REVALUECOMMITMENTSPROCESS.INCLUDEGRANTAWARDS,
                        @INCLUDEPLANNEDGIFTS = REVALUECOMMITMENTSPROCESS.INCLUDEPLANNEDGIFTS,
                        @INCLUDEPLEDGES = REVALUECOMMITMENTSPROCESS.INCLUDEPLEDGES,
                        @INCLUDERECURRINGGIFTS = REVALUECOMMITMENTSPROCESS.INCLUDERECURRINGGIFTS,
                        @IDSETREGISTERNAME = (select IDSETREGISTER.NAME from dbo.IDSETREGISTER where IDSETREGISTER.ID = REVALUECOMMITMENTSPROCESS.IDSETREGISTERID),
                        @CURRENCYEXCHANGERATEASOFDATETIMEOFFSET = REVALUECOMMITMENTSPROCESS.CURRENCYEXCHANGERATEASOFDATETIMEOFFSET,
                        @TIMEZONEENTRYNAME = (select TIMEZONEENTRY.NAME from dbo.TIMEZONEENTRY where TIMEZONEENTRY.ID = REVALUECOMMITMENTSPROCESS.TIMEZONEENTRYID),
                        @CURRENCYEXCHANGERATESOURCECODEDESCRIPTION = (select CURRENCYEXCHANGERATESOURCECODE.DESCRIPTION from dbo.CURRENCYEXCHANGERATESOURCECODE where CURRENCYEXCHANGERATESOURCECODE.ID = REVALUECOMMITMENTSPROCESS.CURRENCYEXCHANGERATESOURCECODEID),
                        @ADJUSTMENTDATE = REVALUECOMMITMENTSPROCESS.ADJUSTMENTDATE,
                        @ADJUSTMENTPOSTDATE = REVALUECOMMITMENTSPROCESS.ADJUSTMENTPOSTDATE,
                        @ADJUSTMENTPOSTSTATUSCODE = REVALUECOMMITMENTSPROCESS.ADJUSTMENTPOSTSTATUSCODE,
                        @ADJUSTMENTPOSTSTATUS = REVALUECOMMITMENTSPROCESS.ADJUSTMENTPOSTSTATUS,
                        @ADJUSTMENTREASONCODETRANSLATION = dbo.UFN_ADJUSTMENTREASONCODE_TRANSLATE(REVALUECOMMITMENTSPROCESS.ADJUSTMENTREASONCODEID),
                        @ADJUSTMENTREASON = REVALUECOMMITMENTSPROCESS.ADJUSTMENTREASON,
                        @CREATEOUTPUTIDSET = REVALUECOMMITMENTSPROCESS.CREATEOUTPUTIDSET,
                        @OUTPUTIDSETRECORDTYPENAME = dbo.UFN_RECORDTYPE_GETNAMEBYID(REVALUECOMMITMENTSPROCESS.OUTPUTIDSETRECORDTYPEID),
                        @OUTPUTIDSETNAME = REVALUECOMMITMENTSPROCESS.OUTPUTIDSETNAME,
                        @OVERWRITEOUTPUTIDSET = REVALUECOMMITMENTSPROCESS.OVERWRITEOUTPUTIDSET,
                        @CREATEEXCEPTIONIDSET = REVALUECOMMITMENTSPROCESS.CREATEEXCEPTIONIDSET,
                        @EXCEPTIONIDSETNAME = REVALUECOMMITMENTSPROCESS.EXCEPTIONIDSETNAME,
                        @OVERWRITEEXCEPTIONIDSET = REVALUECOMMITMENTSPROCESS.OVERWRITEEXCEPTIONIDSET,
                        @USEEXCHANGERATEDATEFORADJUSTMENTDATES = REVALUECOMMITMENTSPROCESS.USEEXCHANGERATEDATEFORADJUSTMENTDATES,
                        @INCLUDEINSTALLMENTPLANS = REVALUECOMMITMENTSPROCESS.INCLUDEINSTALLMENTPLANS
                    from 
                        dbo.REVALUECOMMITMENTSPROCESS
                    where
                        REVALUECOMMITMENTSPROCESS.ID = @ID;

                    return 0;