USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTATIONASKLADDEROVERRIDE_PRELOAD

The load procedure used by the edit dataform template "Marketing Effort Ask Ladder Override Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SEGMENTATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ASKLADDERID	uniqueidentifier	INOUT	Ask ladder
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@MAILINGTYPECODE	tinyint	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTATIONASKLADDEROVERRIDE_PRELOAD]
(
  @CURRENTAPPUSERID uniqueidentifier,
  @SEGMENTATIONID uniqueidentifier,
  @ASKLADDERID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @MAILINGTYPECODE tinyint = null output
)
as
  set nocount on;

  select top 1
    @ASKLADDERID = [ID]
  from dbo.[MKTASKLADDER]
  where [ISACTIVE] = 1;

  select
    @BASECURRENCYID = [BASECURRENCYID],
    @MAILINGTYPECODE = [MAILINGTYPECODE]
  from dbo.[MKTSEGMENTATION]
  where [ID] = @SEGMENTATIONID;

  return 0;