USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTEXPENSEPACKAGE

The load procedure used by the edit dataform template "Marketing Package Expense Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site required?
@SITEID	uniqueidentifier	INOUT	Site
@BASECURRENCYID	uniqueidentifier	INOUT	Currency
@PACKAGEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTEXPENSEPACKAGE]
(
  @CURRENTAPPUSERID uniqueidentifier,
  @SITEREQUIRED bit = null output,
  @SITEID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @PACKAGEID uniqueidentifier
)
as
  set nocount on;

  set @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);
  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, 'bf8933d8-bfbc-4ab1-97e9-71bd263c505c', 1);

  select 
    @BASECURRENCYID = [BASECURRENCYID]
  from dbo.[MKTPACKAGE] 
  where [ID] = @PACKAGEID;

  return 0;