USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTLISTBYSELECTION_1

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@SEGMENTCATEGORYCODEID	uniqueidentifier	IN
@CODE	nvarchar(10)	IN
@CODEVALUEID	uniqueidentifier	IN
@ALLOWCODEUPDATE	bit	IN
@SELECTIONS	xml	IN
@RENTALQUANTITY	int	IN
@RENTALCOSTADJUSTMENT	money	IN
@RENTALCOSTBASISCODE	tinyint	IN
@EXCHANGEQUANTITY	int	IN
@EXCHANGECOSTADJUSTMENT	money	IN
@EXCHANGECOSTBASISCODE	tinyint	IN
@GROUPS	xml	IN

Definition

Copy



create procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTLISTBYSELECTION_1]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255),
  @SEGMENTCATEGORYCODEID uniqueidentifier,
  @CODE nvarchar(10),
  @CODEVALUEID uniqueidentifier,
  @ALLOWCODEUPDATE bit,
  @SELECTIONS xml,
  @RENTALQUANTITY int,
  @RENTALCOSTADJUSTMENT money,
  @RENTALCOSTBASISCODE tinyint,
  @EXCHANGEQUANTITY int,
  @EXCHANGECOSTADJUSTMENT money,
  @EXCHANGECOSTBASISCODE tinyint,
  @GROUPS xml
)
as
  set nocount on;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTLISTBYSELECTION_2]
    @ID,
    @CHANGEAGENTID,
    @NAME,
    @DESCRIPTION,
    @SEGMENTCATEGORYCODEID,
    @CODE,
    @CODEVALUEID,
    @ALLOWCODEUPDATE,
    @SELECTIONS,
    @RENTALQUANTITY,
    @RENTALCOSTADJUSTMENT,
    @RENTALCOSTBASISCODE,
    @EXCHANGEQUANTITY,
    @EXCHANGECOSTADJUSTMENT,
    @EXCHANGECOSTBASISCODE,
    @GROUPS,
    null;

  return 0;