USP_DATAFORMTEMPLATE_ADD_AUCTIONPACKAGETOAUCTION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@EVENTAUCTIONID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@AUCTIONITEMCATEGORYID	uniqueidentifier	IN
@AUCTIONITEMSUBCATEGORYID	uniqueidentifier	IN
@MINIMUMBID	money	IN
@EXPIRATIONDATE	datetime	IN
@BASECURRENCYID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN

Definition

Copy


                    create procedure dbo.USP_DATAFORMTEMPLATE_ADD_AUCTIONPACKAGETOAUCTION
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @EVENTAUCTIONID uniqueidentifier,
                        @NAME nvarchar(100) = '',
                        @DESCRIPTION nvarchar(255) = '',
                        @AUCTIONITEMCATEGORYID uniqueidentifier = null,
                        @AUCTIONITEMSUBCATEGORYID uniqueidentifier = null,
                        @MINIMUMBID money = null,
                        @EXPIRATIONDATE datetime = null,
                        @BASECURRENCYID uniqueidentifier = null,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null
                    )
                    as

                    set nocount on;

                    exec dbo.USP_DATAFORMTEMPLATE_ADD_AUCTIONPACKAGE 
                        @ID = @ID output, 
                        @CHANGEAGENTID = @CHANGEAGENTID,
                        @NAME = @NAME,
                        @DESCRIPTION = @DESCRIPTION,
                        @AUCTIONITEMCATEGORYID = @AUCTIONITEMCATEGORYID,
                        @AUCTIONITEMSUBCATEGORYID = @AUCTIONITEMSUBCATEGORYID,
                        @MINIMUMBID = @MINIMUMBID,
                        @EXPIRATIONDATE = @EXPIRATIONDATE,
                        @EVENTAUCTIONID = @EVENTAUCTIONID,
                        @BASECURRENCYID = @BASECURRENCYID,
                        @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID;

                    return 0;