USP_DATAFORMTEMPLATE_EDIT_MKTASKLADDER

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@CURRENCYSYMBOL	nvarchar(3)	IN	Currency symbol
@RECORDSOURCEID	uniqueidentifier	IN	Record source
@OBJECTKEY	nvarchar(400)	IN	Amount field
@ITEMLIST	xml	IN	Ask ladder
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTASKLADDER]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @CURRENCYSYMBOL nvarchar(3),
  @RECORDSOURCEID uniqueidentifier,
  @OBJECTKEY nvarchar(400),
  @ITEMLIST xml,
  @CURRENTAPPUSERID uniqueidentifier
)
as
  set nocount on;

    declare @SITEID uniqueidentifier;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTASKLADDER]
        @ID = @ID,
        @SITEID = @SITEID output;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTASKLADDER_2]
    @ID, 
    @CHANGEAGENTID, 
    @NAME, 
    @CURRENCYSYMBOL, 
    @RECORDSOURCEID, 
    @OBJECTKEY, 
    @ITEMLIST, 
    @CURRENTAPPUSERID, 
    @SITEID;