USP_DATAFORMTEMPLATE_ADD_AUCTIONITEMBATCHINDIVIDUAL_PRELOAD

The load procedure used by the edit dataform template "Auction Item Batch Individual Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ISORGANIZATION	bit	INOUT
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@BUSINESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT
@CONSTITUENTTYPE	int	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_AUCTIONITEMBATCHINDIVIDUAL_PRELOAD(
                        @ISORGANIZATION bit = null output,
                        @ADDRESS_COUNTRYID uniqueidentifier = null output,
                        @BUSINESS_COUNTRYID uniqueidentifier = null output,
                        @ZIPLOOKUPCOUNTRIES xml = null output,
                        @VALIDATIONCOUNTRIES xml = null output,
                        @CONSTITUENTTYPE int = null output
                    ) as
                        set nocount on;
                        exec @ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;
                        set @BUSINESS_COUNTRYID = @ADDRESS_COUNTRYID;

                        select @ZIPLOOKUPCOUNTRIES = dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES_TOITEMLISTXML();
                        select @VALIDATIONCOUNTRIES = dbo.UFN_COUNTRY_GETVALIDATIONCOUNTRIES_TOITEMLISTXML();

                        set @ISORGANIZATION = 0;
                        set @CONSTITUENTTYPE = 0;

                    return 0;