USP_DATAFORMTEMPLATE_ADD_FUNDINGPLANPRELOAD
The load procedure used by the edit dataform template "Funding Plan Add Form"
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
@SITEID | uniqueidentifier | INOUT | Site |
@SITEREQUIRED | bit | INOUT | |
@BASECURRENCYID | uniqueidentifier | INOUT | Base currency |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FUNDINGPLANPRELOAD
(
@CURRENTAPPUSERID uniqueidentifier,
@SITEID uniqueidentifier = null output,
@SITEREQUIRED bit = null output,
@BASECURRENCYID uniqueidentifier = null output
)
as
set nocount on;
set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);
set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
set @BASECURRENCYID = dbo.UFN_APPUSER_GETBASECURRENCY(@CURRENTAPPUSERID);
return 0;