USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEPRODUCTINSTANCE_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SALEPRICE	money	IN
@PRODUCTINSTANCEOPTIONS	xml	IN
@LOOKUPCODE	nvarchar(25)	IN

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEPRODUCTINSTANCE_2 (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @SALEPRICE money,
                    @PRODUCTINSTANCEOPTIONS xml,
                    @LOOKUPCODE nvarchar(25)
                )
                as

                set nocount on;
                declare @COST money
                exec USP_DATAFORMTEMPLATE_EDITLOAD_MERCHANDISEPRODUCTINSTANCE_2 
                            @ID,
                            @COST = @COST output

                exec USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEPRODUCTINSTANCE_3
                            @ID,
                            @CHANGEAGENTID,
                            @SALEPRICE,
                            @PRODUCTINSTANCEOPTIONS,
                            @LOOKUPCODE,
                            @COST

                return 0;