USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMMEMBERSHIP_ONLINE_GENERIC

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SALESORDERID	uniqueidentifier	IN
@DESCRIPTION	nvarchar(255)	IN
@QUANTITY	decimal(18, 0)	IN
@AMOUNT	money	IN
@DATA	xml	IN
@OPTIONS	xml	IN
@CALLBACKURL	nvarchar(255)	IN
@SYSTEMTYPENAME	nvarchar(255)	IN
@ASSEMBLYNAME	nvarchar(255)	IN
@ATTRIBUTES	xml	IN
@CATEGORYNAME	nvarchar(255)	IN
@ACKNOWLEDGEMENT	nvarchar(max)	IN
@MEMBERSHIPID	uniqueidentifier	IN
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@MEMBERSHIPLEVELID	uniqueidentifier	IN
@MEMBERSHIPLEVELTERMID	uniqueidentifier	IN
@MEMBERSHIPLEVELTYPEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMMEMBERSHIP_ONLINE_GENERIC
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SALESORDERID uniqueidentifier,
    @DESCRIPTION nvarchar(255),
    @QUANTITY decimal,
    @AMOUNT money,
    @DATA xml,
    @OPTIONS xml,
    @CALLBACKURL nvarchar(255),
    @SYSTEMTYPENAME nvarchar(255),
    @ASSEMBLYNAME nvarchar(255),
    @ATTRIBUTES xml,
    @CATEGORYNAME nvarchar(255),
    @ACKNOWLEDGEMENT nvarchar(max),
    @MEMBERSHIPID uniqueidentifier,
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @MEMBERSHIPLEVELID uniqueidentifier,
    @MEMBERSHIPLEVELTERMID uniqueidentifier,
    @MEMBERSHIPLEVELTYPEID uniqueidentifier
)

as
    set nocount on;

    exec dbo.USP_SALESORDERITEMMEMBERSHIP_ONLINE_GENERIC_UPDATE
        @ID,
        @CHANGEAGENTID,
        @SALESORDERID,
        @DESCRIPTION,
        @QUANTITY,
        @AMOUNT,
        @DATA,
        @OPTIONS,
        @CALLBACKURL,
        @SYSTEMTYPENAME,
        @ASSEMBLYNAME,
        @ATTRIBUTES,
        @CATEGORYNAME,
        @ACKNOWLEDGEMENT,
        @MEMBERSHIPID,
        @MEMBERSHIPPROGRAMID,
        @MEMBERSHIPLEVELID,
        @MEMBERSHIPLEVELTERMID,
        @MEMBERSHIPLEVELTYPEID,
        null

    return 0;