USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTLISTBYSELECTIONCOPY_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTIDTOCOPY	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@SEGMENTCATEGORYCODEID	uniqueidentifier	INOUT	Category
@CODE	nvarchar(10)	INOUT	Code
@CODEVALUEID	uniqueidentifier	INOUT	Code value ID
@PARENTSEGMENTNAME	nvarchar(100)	INOUT	Segment
@SELECTIONRECORDTYPEID	uniqueidentifier	INOUT	Record type ID
@SELECTIONRECORDTYPE	nvarchar(50)	INOUT	Record type
@SELECTIONQUERYVIEWCATALOGID	uniqueidentifier	INOUT	Query view catalog ID
@SELECTIONQUERYVIEWISROOT	bit	INOUT	Query view is root
@SELECTIONS	xml	INOUT	Selections
@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
@RENTALQUANTITY	int	INOUT	Rental quantity
@RENTALCOSTADJUSTMENT	money	INOUT	Rental cost adjustment
@RENTALCOSTBASISCODE	tinyint	INOUT	Rental cost basis code
@EXCHANGEQUANTITY	int	INOUT	Exchange quantity
@EXCHANGECOSTADJUSTMENT	money	INOUT	Exchange cost adjustment
@EXCHANGECOSTBASISCODE	tinyint	INOUT	Exchange cost basis code
@GROUPS	xml	INOUT	Groups
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@SITEID	uniqueidentifier	INOUT	Site
@SITEREQUIRED	bit	INOUT	Site required?

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTLISTBYSELECTIONCOPY_PRELOAD]
(
  @SEGMENTIDTOCOPY uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @NAME nvarchar(100) = null output,
  @DESCRIPTION nvarchar(255) = null output,
  @SEGMENTCATEGORYCODEID uniqueidentifier = null output,
  @CODE nvarchar(10) = null output,
  @CODEVALUEID uniqueidentifier = null output,
  @PARENTSEGMENTNAME nvarchar(100) = null output,
  @SELECTIONRECORDTYPEID uniqueidentifier = null output,
  @SELECTIONRECORDTYPE nvarchar(50) = null output,
  @SELECTIONQUERYVIEWCATALOGID uniqueidentifier = null output,
  @SELECTIONQUERYVIEWISROOT bit = null output,
  @SELECTIONS xml = null output,
  @BASERENTALCOST money = null output,
  @BASERENTALCOSTBASISCODE tinyint = null output,
  @BASEEXCHANGECOST money = null output,
  @BASEEXCHANGECOSTBASISCODE money = null output,
  @RENTALQUANTITY int = null output,
  @RENTALCOSTADJUSTMENT money = null output,
  @RENTALCOSTBASISCODE tinyint = null output,
  @EXCHANGEQUANTITY int = null output,
  @EXCHANGECOSTADJUSTMENT money = null output,
  @EXCHANGECOSTBASISCODE tinyint = null output,
  @GROUPS xml = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @SITEID uniqueidentifier = null output,
  @SITEREQUIRED bit = null output
)
as
  set nocount on;

  declare @DATALOADED bit;
  declare @ALLOWCODEUPDATE bit;
  declare @TSLONG bigint;

  --Load the segment to copy...

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTLISTBYSELECTION]
    @SEGMENTIDTOCOPY,
    @CURRENTAPPUSERID,
    @DATALOADED output,
    @NAME output,
    @DESCRIPTION output,
    @SEGMENTCATEGORYCODEID output,
    @CODE output,
    @CODEVALUEID output,
    @ALLOWCODEUPDATE output,
    @PARENTSEGMENTNAME output,
    @SELECTIONRECORDTYPEID output,
    @SELECTIONRECORDTYPE output,
    @SELECTIONQUERYVIEWCATALOGID output,
    @SELECTIONQUERYVIEWISROOT output,
    @SELECTIONS output,
    @BASERENTALCOST output,
    @BASERENTALCOSTBASISCODE output,
    @BASEEXCHANGECOST output,
    @BASEEXCHANGECOSTBASISCODE output,
    @RENTALQUANTITY output,
    @RENTALCOSTADJUSTMENT output,
    @RENTALCOSTBASISCODE output,
    @EXCHANGEQUANTITY output,
    @EXCHANGECOSTADJUSTMENT output,
    @EXCHANGECOSTBASISCODE output,
    @GROUPS output,
    @TSLONG output,
    @BASECURRENCYID output,
    @SITEID output,
    null;

  --Get a unique name for the copy...

  set @NAME = dbo.[UFN_MKTSEGMENT_GETUNIQUENAME](@SEGMENTIDTOCOPY, @NAME, null);

  if dbo.[UFN_MKTSOURCECODEPARTDEFINITIONVALUE_GETAUTOINCREMENTSETTING](@CODEVALUEID) = 1
    set @CODE = dbo.[UFN_MKTSOURCECODE_AUTOINCREMENTCODE](@CODEVALUEID, 0);

  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, '92461E42-E8B1-4533-B463-E7C6B4D04915', 1);

  return 0;