USP_DATAFORMTEMPLATE_ADD_REVENUEBATCHHOUSEHOLD_PRELOAD

The load procedure used by the edit dataform template "Revenue Batch Household Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@HOUSEHOLDSCANBEDONORS	bit	INOUT	Can households be donors
@VALIDATIONCOUNTRIES	xml	INOUT
@CONSTITUENTTYPE	int	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_REVENUEBATCHHOUSEHOLD_PRELOAD 
                (
                    @ADDRESS_COUNTRYID uniqueidentifier = null output,
                    @ZIPLOOKUPCOUNTRIES xml = null output,
                    @HOUSEHOLDSCANBEDONORS bit = null output,
                    @VALIDATIONCOUNTRIES xml = null output,
                    @CONSTITUENTTYPE int = null output
                ) 
                as
                    set nocount on;

                    exec @ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;

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

                    set @HOUSEHOLDSCANBEDONORS = dbo.UFN_INSTALLATIONINFO_GETHOUSEHOLDSCANBEDONORS();

                    set @CONSTITUENTTYPE = 0;

                return 0;