USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTLISTBYSELECTION_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@PARENTSEGMENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PARENTSEGMENTNAME	nvarchar(100)	INOUT	Segment
@SELECTIONRECORDTYPEID	uniqueidentifier	INOUT	Record type ID
@SELECTIONRECORDTYPE	nvarchar(50)	INOUT	Record type
@SELECTIONQUERYVIEWCATALOGID	uniqueidentifier	INOUT	Query view catalog ID
@BASERENTALCOST	money	INOUT	Base rental cost
@BASERENTALCOSTBASISCODE	tinyint	INOUT	Base rental cost basis code
@BASEEXCHANGECOST	money	INOUT	Base exchange cost
@BASEEXCHANGECOSTBASISCODE	money	INOUT	Base exchange cost basis code
@RENTALCOSTADJUSTMENT	money	INOUT	Rental cost adjustment
@RENTALCOSTBASISCODE	tinyint	INOUT	Rental cost basis code
@EXCHANGECOSTADJUSTMENT	money	INOUT	Exchange cost adjustment
@EXCHANGECOSTBASISCODE	tinyint	INOUT	Exchange cost basis code
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEID	uniqueidentifier	INOUT	Site
@SITEREQUIRED	bit	INOUT	Site required?

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTLISTBYSELECTION_PRELOAD]
(
  @PARENTSEGMENTID uniqueidentifier,
  @PARENTSEGMENTNAME nvarchar(100) = null output,
  @SELECTIONRECORDTYPEID uniqueidentifier = null output,
  @SELECTIONRECORDTYPE nvarchar(50) = null output,
  @SELECTIONQUERYVIEWCATALOGID uniqueidentifier = null output,
  @BASERENTALCOST money = null output,
  @BASERENTALCOSTBASISCODE tinyint = null output,
  @BASEEXCHANGECOST money = null output,
  @BASEEXCHANGECOSTBASISCODE money = null output,
  @RENTALCOSTADJUSTMENT money = null output,
  @RENTALCOSTBASISCODE tinyint = null output,
  @EXCHANGECOSTADJUSTMENT money = null output,
  @EXCHANGECOSTBASISCODE tinyint = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SITEID uniqueidentifier = null output,
  @SITEREQUIRED bit = null output
)
as
  set nocount on;

  select
    @PARENTSEGMENTNAME = [MKTSEGMENT].[NAME],
    @SELECTIONRECORDTYPEID = [RECORDTYPE].[ID],
    @SELECTIONRECORDTYPE = [RECORDTYPE].[NAME],
    @SELECTIONQUERYVIEWCATALOGID = [MKTSEGMENTLIST].[QUERYVIEWCATALOGID],
    @BASERENTALCOST = [MKTLIST].[BASERENTALCOST],
    @BASERENTALCOSTBASISCODE = [MKTLIST].[BASERENTALCOSTBASISCODE],
    @BASEEXCHANGECOST = [MKTLIST].[BASEEXCHANGECOST],
    @BASEEXCHANGECOSTBASISCODE = [MKTLIST].[BASEEXCHANGECOSTBASISCODE],
    @RENTALCOSTADJUSTMENT = [MKTSEGMENTLIST].[RENTALCOSTADJUSTMENT],
    @RENTALCOSTBASISCODE = [MKTSEGMENTLIST].[RENTALCOSTBASISCODE],
    @EXCHANGECOSTADJUSTMENT = [MKTSEGMENTLIST].[EXCHANGECOSTADJUSTMENT],
    @EXCHANGECOSTBASISCODE = [MKTSEGMENTLIST].[EXCHANGECOSTBASISCODE],
    @BASECURRENCYID = [MKTLIST].[BASECURRENCYID],
    @SITEID = [MKTSEGMENT].[SITEID]
  from dbo.[MKTSEGMENT]
  inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENT].[CURRENTSEGMENTLISTID]
  inner join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [MKTSEGMENTLIST].[IDSETRECORDTYPEID]
  inner join dbo.[MKTLIST] on [MKTLIST].[ID] = [MKTSEGMENTLIST].[LISTID]
  where [MKTSEGMENT].[ID] = @PARENTSEGMENTID;

  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, '3E81EDD8-92A2-441A-AF36-374D874F2123', 1);

  return 0;