USP_DATAFORMTEMPLATE_ADD_INDIVIDUALFUNDRAISER_PRELOAD

The load procedure used by the edit dataform template "Individual Fundraiser Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ORGANIZATION_COUNTRYID	uniqueidentifier	INOUT	Country
@VALIDATIONCOUNTRIES	xml	INOUT
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@CONSTITUENTTYPE	int	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_INDIVIDUALFUNDRAISER_PRELOAD
(
  @ADDRESS_COUNTRYID uniqueidentifier = null output,
  @ORGANIZATION_COUNTRYID uniqueidentifier = null output,
  @VALIDATIONCOUNTRIES xml = null output,
  @ZIPLOOKUPCOUNTRIES xml = null output,
  @CONSTITUENTTYPE int = null output
)
as
begin
  set nocount on;

  exec @ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;
  set @ORGANIZATION_COUNTRYID = @ADDRESS_COUNTRYID;
  set @VALIDATIONCOUNTRIES = dbo.UFN_COUNTRY_GETVALIDATIONCOUNTRIES_TOITEMLISTXML();
  set @ZIPLOOKUPCOUNTRIES = dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES_TOITEMLISTXML();
  set @CONSTITUENTTYPE = 0;

  return 0;
end