USP_DATAFORMTEMPLATE_PRELOAD_ADD_REVALUECOMMITMENTSBUSINESS

The load procedure used by the edit dataform template "Revalue Foreign-Denominated Commitments Business Process Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	INOUT	Record type ID
@TIMEZONEENTRYID	uniqueidentifier	INOUT	Time zone
@ADJUSTMENTDATE	date	INOUT	Adjustment date
@ADJUSTMENTPOSTDATE	date	INOUT	Adjustment post date
@SITEID	uniqueidentifier	INOUT	Site
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_REVALUECOMMITMENTSBUSINESS
                (
                    @RECORDTYPEID uniqueidentifier = null output,
                    @TIMEZONEENTRYID uniqueidentifier = null output,
                    @ADJUSTMENTDATE date = null output,
                    @ADJUSTMENTPOSTDATE date = null output,
                    @SITEID uniqueidentifier = null output,
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        @RECORDTYPEID = RECORDTYPE.ID
                    from
                        dbo.RECORDTYPE
                    where
                        upper(RECORDTYPE.NAME) = N'REVENUE';

                    set @TIMEZONEENTRYID = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULT();

                    set @ADJUSTMENTDATE = cast(getdate() as date);
                    set @ADJUSTMENTPOSTDATE = cast(getdate() as date);

                    select @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)

                    return 0;