USP_DATAFORMTEMPLATE_EDIT_REVALUECOMMITMENTSBUSINESS_2

The save procedure used by the edit dataform template "Revalue Foreign-Denominated Commitments Business Process Edit Form".

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.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEID	uniqueidentifier	IN	Site

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_REVALUECOMMITMENTSBUSINESS_2
(
    @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,
    @CURRENTAPPUSERID uniqueidentifier,
    @SITEID uniqueidentifier
)

as
  set nocount on;

    declare @INCLUDEINSTALLMENTPLANS bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVALUECOMMITMENTSBUSINESS
        @ID = @ID,
        @INCLUDEINSTALLMENTPLANS = @INCLUDEINSTALLMENTPLANS output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVALUECOMMITMENTSBUSINESS_3
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @REVALUEBYTYPECODE,
        @INCLUDEGRANTAWARDS,
        @INCLUDEPLANNEDGIFTS,
        @INCLUDEPLEDGES,
        @INCLUDERECURRINGGIFTS,
        @IDSETREGISTERID,
        @CURRENCYEXCHANGERATEASOFTYPECODE,
        @CURRENCYEXCHANGERATEASOFDATE,
        @CURRENCYEXCHANGERATEASOFTIME,
        @TIMEZONEENTRYID,
        @CURRENCYEXCHANGERATESOURCECODEID,
        @ADJUSTMENTDATE,
        @ADJUSTMENTPOSTDATE,
        @ADJUSTMENTPOSTSTATUSCODE,
        @ADJUSTMENTREASONCODEID,
        @ADJUSTMENTREASON,
        @CREATEOUTPUTIDSET,
        @OUTPUTIDSETRECORDTYPEID,
        @OUTPUTIDSETNAME,
        @OVERWRITEOUTPUTIDSET,
        @CREATEEXCEPTIONIDSET,
        @EXCEPTIONIDSETNAME,
        @OVERWRITEEXCEPTIONIDSET,
        @USEEXCHANGERATEDATEFORADJUSTMENTDATES,
        @CURRENTAPPUSERID,
        @SITEID,
        @INCLUDEINSTALLMENTPLANS

  return 0;