USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPBATCHHOUSEHOLD_PRELOAD

The load procedure used by the edit dataform template "Sponsorship 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

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPBATCHHOUSEHOLD_PRELOAD 
                (
                    @ADDRESS_COUNTRYID uniqueidentifier = null output,
                    @ZIPLOOKUPCOUNTRIES xml = null output,
                    @HOUSEHOLDSCANBEDONORS bit = null output,
                    @VALIDATIONCOUNTRIES xml = 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()

                return 0;