USP_DATAFORMTEMPLATE_ADD_PROSPECTSEARCH_ADDRE_INDIVIDUAL_PRELOAD

Parameters

Parameter	Parameter Type	Mode
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT
@ORGANIZATION_COUNTRYID	uniqueidentifier	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@CONSTITUENTTYPE	int	INOUT
@FULLNAME	nvarchar(100)	INOUT
@TITLECODE_DESC	nvarchar(100)	INOUT
@SUFFIXCODE_DESC	nvarchar(100)	INOUT
@TITLE2CODE_DESC	nvarchar(100)	INOUT
@SUFFIX2CODE_DESC	nvarchar(100)	INOUT
@ADDRESS_STATE_DESC	nvarchar(100)	INOUT
@ADDRESS_STATE_ABBREV	nvarchar(5)	INOUT
@ADDRESS_COUNTRY_DESC	nvarchar(100)	INOUT
@ADDRESS_COUNTRY_ABBREV	nvarchar(5)	INOUT
@SPOUSE_TITLECODE_DESC	nvarchar(100)	INOUT
@SPOUSE_SUFFIXCODE_DESC	nvarchar(100)	INOUT
@SPOUSE_TITLE2CODE_DESC	nvarchar(100)	INOUT
@SPOUSE_SUFFIX2CODE_DESC	nvarchar(100)	INOUT
@ADDRESS_TYPE_DESC	nvarchar(100)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROSPECTSEARCH_ADDRE_INDIVIDUAL_PRELOAD
(
  @ADDRESS_COUNTRYID uniqueidentifier = null output,
  @ORGANIZATION_COUNTRYID uniqueidentifier = null output,
  @VALIDATIONCOUNTRIES xml = null output,
  @ZIPLOOKUPCOUNTRIES xml = null output,
  @CONSTITUENTTYPE int = null output,
  @FULLNAME nvarchar(100) = null output,
  @TITLECODE_DESC nvarchar(100) = null output,
  @SUFFIXCODE_DESC nvarchar(100) = null output,
  @TITLE2CODE_DESC nvarchar(100) = null output,
  @SUFFIX2CODE_DESC nvarchar(100) = null output,
  @ADDRESS_STATE_DESC nvarchar(100) = null output,
  @ADDRESS_STATE_ABBREV nvarchar(5) = null output,
  @ADDRESS_COUNTRY_DESC nvarchar(100) = null output,
  @ADDRESS_COUNTRY_ABBREV nvarchar(5) = null output,
  @SPOUSE_TITLECODE_DESC nvarchar(100) = null output,
  @SPOUSE_SUFFIXCODE_DESC nvarchar(100) = null output,
  @SPOUSE_TITLE2CODE_DESC nvarchar(100) = null output,
  @SPOUSE_SUFFIX2CODE_DESC nvarchar(100) = null output,
  @ADDRESS_TYPE_DESC nvarchar(100) = 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