USP_DATAFORMTEMPLATE_ADD_HOUSEHOLD_PRELOAD

The load procedure used by the edit dataform template "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
@MARRIAGEOPTIONSSET	bit	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_HOUSEHOLD_PRELOAD 
                (
                    @ADDRESS_COUNTRYID uniqueidentifier = null output,
                    @ZIPLOOKUPCOUNTRIES xml = null output,
                    @HOUSEHOLDSCANBEDONORS bit = null output,
                    @VALIDATIONCOUNTRIES xml = null output,
                    @CONSTITUENTTYPE int = null output,
                    @MARRIAGEOPTIONSSET bit = 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;

                    select @MARRIAGEOPTIONSSET = RULESSET from dbo.UFN_MARRIAGEOPTION_GETRULES();

                return 0;