USP_DATAFORMTEMPLATE_ADD_MKTLIST_PRELOAD

The load procedure used by the edit dataform template "List Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDSOURCEID	uniqueidentifier	INOUT	Record source
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@SITEID	uniqueidentifier	INOUT	Site
@SITEREQUIRED	bit	INOUT	Site required?
@LISTPARTDEFINITIONID	uniqueidentifier	INOUT

Definition

Copy



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

  if (select count([ID]) from dbo.[MKTRECORDSOURCE] where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTRECORDSOURCE].[ID]) = 1) = 1
    select top 1 @RECORDSOURCEID = [ID] from dbo.[MKTRECORDSOURCE] where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTRECORDSOURCE].[ID]) = 1;

  set @BASECURRENCYID = dbo.[UFN_APPUSER_GETBASECURRENCY](@CURRENTAPPUSERID);
  set @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);
  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, 'FF7F1D23-3238-45CB-BB42-9D47C3238A1D', 1);

  select @LISTPARTDEFINITIONID = [ID] from dbo.[MKTSOURCECODEPARTDEFINITION] where [ITEMTYPECODE] = 6;

  return 0;