USP_UPDATE_SALESORDERITEMMEMBERSHIP

Parameters

Parameter	Parameter Type	Mode
@RECORDID	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
@MEMBERSHIPADDONS	xml	IN
@NUMBEROFCHILDREN	tinyint	IN

Definition

Copy



            create procedure dbo.USP_UPDATE_SALESORDERITEMMEMBERSHIP(
                        @RECORDID uniqueidentifier,
                        @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,
                        @MEMBERSHIPADDONS xml,
                        @NUMBEROFCHILDREN tinyint
                    )
                    as
                        set nocount on;

                        begin try
                            exec dbo.USP_SALESORDERITEMMEMBERSHIP_ONLINE_GENERIC_UPDATE
                                @RECORDID,
                                null,
                                @SALESORDERID,
                                @DESCRIPTION,
                                @QUANTITY,
                                @AMOUNT,
                                @DATA,
                                @OPTIONS,
                                @CALLBACKURL,
                                @SYSTEMTYPENAME,
                                @ASSEMBLYNAME,
                                @ATTRIBUTES,
                                @CATEGORYNAME,
                                @ACKNOWLEDGEMENT,
                                @MEMBERSHIPID,
                                @MEMBERSHIPPROGRAMID,
                                @MEMBERSHIPLEVELID,
                                @MEMBERSHIPLEVELTERMID,
                                @MEMBERSHIPLEVELTYPEID,
                                @MEMBERSHIPADDONS,
                                @NUMBEROFCHILDREN;
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;