USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEPRODUCTINSTANCE_3

Parameters

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

Definition

Copy



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

                set nocount on;
                declare @LOOKUPITEMS xml
                exec USP_DATAFORMTEMPLATE_EDITLOAD_MERCHANDISEPRODUCTINSTANCE_2 
                    @ID,
                    @LOOKUPITEMS = @LOOKUPITEMS output;

                exec USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEPRODUCTINSTANCE_4
                    @ID,
                    @CHANGEAGENTID,
                    @SALEPRICE,
                    @PRODUCTINSTANCEOPTIONS,
                    @LOOKUPCODE,
                    @COST,
                    @LOOKUPITEMS;

                return 0;