USP_DATAFORMTEMPLATE_EDIT_REVALUECOMMITMENTSBUSINESS

Edits a Revalue Commitment business process.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@REVALUEBYTYPECODE	tinyint	IN	Revalue by:
@INCLUDEGRANTAWARDS	bit	IN	Grant awards
@INCLUDEPLANNEDGIFTS	bit	IN	Planned gifts
@INCLUDEPLEDGES	bit	IN	Pledges
@INCLUDERECURRINGGIFTS	bit	IN	Recurring gifts
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@CURRENCYEXCHANGERATEASOFTYPECODE	tinyint	IN	Use rates as of:
@CURRENCYEXCHANGERATEASOFDATE	date	IN	Date
@CURRENCYEXCHANGERATEASOFTIME	time	IN	Time
@TIMEZONEENTRYID	uniqueidentifier	IN	Time zone
@CURRENCYEXCHANGERATESOURCECODEID	uniqueidentifier	IN	Source
@ADJUSTMENTDATE	date	IN	Adjustment date
@ADJUSTMENTPOSTDATE	date	IN	Adjustment post date
@ADJUSTMENTPOSTSTATUSCODE	tinyint	IN	Adjustment post status
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment details
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@CREATEEXCEPTIONIDSET	bit	IN	Create selection of exceptions
@EXCEPTIONIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEEXCEPTIONIDSET	bit	IN	Overwrite existing selection
@USEEXCHANGERATEDATEFORADJUSTMENTDATES	bit	IN	Default dates to the same date from which exchange rates will be selected.

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVALUECOMMITMENTSBUSINESS
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @NAME nvarchar(100),
                @DESCRIPTION nvarchar(255),
                @REVALUEBYTYPECODE tinyint,
                @INCLUDEGRANTAWARDS bit,
                @INCLUDEPLANNEDGIFTS bit,
                @INCLUDEPLEDGES bit,
                @INCLUDERECURRINGGIFTS bit,
                @IDSETREGISTERID uniqueidentifier,
                @CURRENCYEXCHANGERATEASOFTYPECODE tinyint,
                @CURRENCYEXCHANGERATEASOFDATE date,
                @CURRENCYEXCHANGERATEASOFTIME time(0),
                @TIMEZONEENTRYID uniqueidentifier,
                @CURRENCYEXCHANGERATESOURCECODEID uniqueidentifier,
                @ADJUSTMENTDATE date,
                @ADJUSTMENTPOSTDATE date,
                @ADJUSTMENTPOSTSTATUSCODE tinyint,
                @ADJUSTMENTREASONCODEID uniqueidentifier,
                @ADJUSTMENTREASON nvarchar(300),
                @CREATEOUTPUTIDSET bit,
                @OUTPUTIDSETRECORDTYPEID uniqueidentifier,
                @OUTPUTIDSETNAME nvarchar(100),
                @OVERWRITEOUTPUTIDSET bit,
                @CREATEEXCEPTIONIDSET bit,
                @EXCEPTIONIDSETNAME nvarchar(100),
                @OVERWRITEEXCEPTIONIDSET bit,
                @USEEXCHANGERATEDATEFORADJUSTMENTDATES bit
            )
            as
            begin
                set nocount on;

                declare @CURRENTDATE datetime;

                if @ID is null
                    set @ID = newid();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                set @CURRENTDATE = getdate();

                begin try
                    declare @CURRENCYEXCHANGERATEASOFDATETIME datetime = (cast(@CURRENCYEXCHANGERATEASOFDATE as datetime) + cast(@CURRENCYEXCHANGERATEASOFTIME as datetime));
                    declare @CURRENCYEXCHANGERATEASOFDATETIMEOFFSET datetimeoffset(3) = todatetimeoffset(@CURRENCYEXCHANGERATEASOFDATETIME, dbo.UFN_TIMEZONEENTRY_GETTIMEZONEOFFSETFROMUTC(@TIMEZONEENTRYID, @CURRENCYEXCHANGERATEASOFDATETIME, 0));

                    update dbo.REVALUECOMMITMENTSPROCESS set
                        REVALUECOMMITMENTSPROCESS.NAME = @NAME,
                        REVALUECOMMITMENTSPROCESS.DESCRIPTION = @DESCRIPTION,
                        REVALUECOMMITMENTSPROCESS.REVALUEBYTYPECODE = @REVALUEBYTYPECODE,
                        REVALUECOMMITMENTSPROCESS.INCLUDEGRANTAWARDS = @INCLUDEGRANTAWARDS,
                        REVALUECOMMITMENTSPROCESS.INCLUDEPLANNEDGIFTS = @INCLUDEPLANNEDGIFTS,
                        REVALUECOMMITMENTSPROCESS.INCLUDEPLEDGES = @INCLUDEPLEDGES,
                        REVALUECOMMITMENTSPROCESS.INCLUDERECURRINGGIFTS = @INCLUDERECURRINGGIFTS,
                        REVALUECOMMITMENTSPROCESS.IDSETREGISTERID = @IDSETREGISTERID,
                        REVALUECOMMITMENTSPROCESS.CURRENCYEXCHANGERATEASOFTYPECODE = @CURRENCYEXCHANGERATEASOFTYPECODE,
                        REVALUECOMMITMENTSPROCESS.CURRENCYEXCHANGERATEASOFDATETIMEOFFSET = @CURRENCYEXCHANGERATEASOFDATETIMEOFFSET,
                        REVALUECOMMITMENTSPROCESS.TIMEZONEENTRYID = @TIMEZONEENTRYID,
                        REVALUECOMMITMENTSPROCESS.CURRENCYEXCHANGERATESOURCECODEID = @CURRENCYEXCHANGERATESOURCECODEID,
                        REVALUECOMMITMENTSPROCESS.ADJUSTMENTDATE = @ADJUSTMENTDATE,
                        REVALUECOMMITMENTSPROCESS.ADJUSTMENTPOSTDATE = @ADJUSTMENTPOSTDATE,
                        REVALUECOMMITMENTSPROCESS.ADJUSTMENTPOSTSTATUSCODE = @ADJUSTMENTPOSTSTATUSCODE,
                        REVALUECOMMITMENTSPROCESS.ADJUSTMENTREASONCODEID = @ADJUSTMENTREASONCODEID,
                        REVALUECOMMITMENTSPROCESS.ADJUSTMENTREASON = coalesce(@ADJUSTMENTREASON, N''),
                        REVALUECOMMITMENTSPROCESS.CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
                        REVALUECOMMITMENTSPROCESS.OUTPUTIDSETRECORDTYPEID = @OUTPUTIDSETRECORDTYPEID,
                        REVALUECOMMITMENTSPROCESS.OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
                        REVALUECOMMITMENTSPROCESS.OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
                        REVALUECOMMITMENTSPROCESS.CREATEEXCEPTIONIDSET = @CREATEEXCEPTIONIDSET,
                        REVALUECOMMITMENTSPROCESS.EXCEPTIONIDSETNAME = @EXCEPTIONIDSETNAME,
                        REVALUECOMMITMENTSPROCESS.OVERWRITEEXCEPTIONIDSET = @OVERWRITEEXCEPTIONIDSET,
                        REVALUECOMMITMENTSPROCESS.CHANGEDBYID = @CHANGEAGENTID,
                        REVALUECOMMITMENTSPROCESS.DATECHANGED = @CURRENTDATE,
                        REVALUECOMMITMENTSPROCESS.USEEXCHANGERATEDATEFORADJUSTMENTDATES = @USEEXCHANGERATEDATEFORADJUSTMENTDATES
                    where
                        REVALUECOMMITMENTSPROCESS.ID = @ID;
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;
            end