USP_DATAFORMTEMPLATE_PRELOAD_JOBWITHCURRENCYCONTEXT

The load procedure used by the edit dataform template "Job Add Form (With Currency Context)"

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTCURRENCYID	nvarchar(36)	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site Required
@SITEID	uniqueidentifier	INOUT	Site
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_JOBWITHCURRENCYCONTEXT]
(
  @CONTEXTCURRENCYID nvarchar(36),
  @CURRENTAPPUSERID uniqueidentifier,
  @SITEREQUIRED bit = null output,
  @SITEID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output
)
as
begin
  set nocount on;

  select 
    @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSER](@CURRENTAPPUSERID),
    @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);

  if @CONTEXTCURRENCYID is null or len(@CONTEXTCURRENCYID) = 0
    set @BASECURRENCYID = dbo.[UFN_APPUSER_GETBASECURRENCY](@CURRENTAPPUSERID);
  else
    set @BASECURRENCYID = convert(uniqueidentifier, @CONTEXTCURRENCYID);

  return 0;
end