USP_DATAFORMTEMPLATE_ADD_INDIVIDUALSPOUSEBUSINESS_PRELOAD_WRAPPED2

The load procedure used by the edit dataform template "Individual, Spouse, Business Add Form (Wrapped - Owner Name, Mailing Address)"

Parameters

Parameter	Parameter Type	Mode	Description
@RESULTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ORGANIZATION_COUNTRYID	uniqueidentifier	INOUT	Country
@VALIDATIONCOUNTRIES	xml	INOUT
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@CONSTITUENTTYPE	int	INOUT
@FIRSTNAME	nvarchar(50)	INOUT	First name
@LASTNAME	nvarchar(100)	INOUT	Last name
@MIDDLENAME	nvarchar(50)	INOUT	Middle name
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@ADDRESS_CITY	nvarchar(50)	INOUT	City
@ADDRESS_POSTCODE	nvarchar(12)	INOUT	ZIP
@ADDRESS_STATEID	uniqueidentifier	INOUT	State
@SPOUSE_FIRSTNAME	nvarchar(50)	INOUT	First name
@SPOUSE_LASTNAME	nvarchar(100)	INOUT	Last name
@SPOUSE_MIDDLENAME	nvarchar(50)	INOUT	Middle name
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	INOUT	Reciprocal relationship type
@SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	INOUT	Relationship type
@ADDRESS_INFOSOURCECODEID	uniqueidentifier	INOUT	Information source

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_INDIVIDUALSPOUSEBUSINESS_PRELOAD_WRAPPED2 
(
    @RESULTID uniqueidentifier,
    @ADDRESS_COUNTRYID uniqueidentifier = null output,
    @ORGANIZATION_COUNTRYID uniqueidentifier = null output,
    @VALIDATIONCOUNTRIES xml = null output,
    @ZIPLOOKUPCOUNTRIES xml = null output,
    @CONSTITUENTTYPE int = null output,
    @FIRSTNAME nvarchar(50) = null output,
    @LASTNAME nvarchar(100) = null output,
    @MIDDLENAME nvarchar(50) = null output,
    @ADDRESS_ADDRESSBLOCK nvarchar(150) = null output,
    @ADDRESS_CITY nvarchar(50) = null output,
    @ADDRESS_POSTCODE nvarchar(12) = null output,
    @ADDRESS_STATEID uniqueidentifier = null output,
    @SPOUSE_FIRSTNAME nvarchar(50) = null output,
    @SPOUSE_LASTNAME nvarchar(100) = null output,
    @SPOUSE_MIDDLENAME nvarchar(50) = null output,
    @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier = null output,
    @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier = null output,
    @ADDRESS_INFOSOURCECODEID uniqueidentifier = null output
)


as

set nocount on;

/* Handle any custom "pre-load" logic here */

declare @r int
exec @r = dbo.USP_DATAFORMTEMPLATE_ADD_INDIVIDUALSPOUSEBUSINESS_PRELOAD 
  @ADDRESS_COUNTRYID = @ADDRESS_COUNTRYID output, 
  @ORGANIZATION_COUNTRYID = @ORGANIZATION_COUNTRYID output, 
  @VALIDATIONCOUNTRIES = @VALIDATIONCOUNTRIES output, 
  @ZIPLOOKUPCOUNTRIES = @ZIPLOOKUPCOUNTRIES output, 
  @CONSTITUENTTYPE = @CONSTITUENTTYPE output

/* Handle any custom "after-load" logic here */
select @ADDRESS_COUNTRYID = ID from dbo.COUNTRY where ABBREVIATION = 'USA'

select
    @FIRSTNAME = PISR.FIRSTNAME,
    @LASTNAME = PISR.KEYNAME,
    @MIDDLENAME = PISR.MIDDLENAME,
    @SPOUSE_FIRSTNAME = PISR.SPOUSE_FIRSTNAME,
    @SPOUSE_MIDDLENAME = PISR.SPOUSE_MIDDLENAME,
    @SPOUSE_LASTNAME = PISR.SPOUSE_KEYNAME,
    @SPOUSE_RELATIONSHIPTYPECODEID = PISR.SPOUSE_RELATIONSHIPTYPECODEID,
    @SPOUSE_RECIPROCALTYPECODEID = PISR.SPOUSE_RECIPROCALTYPECODEID,
    @ADDRESS_ADDRESSBLOCK = dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(PISR.MAILINGADDRESSBLOCK, PISR.MAILINGUNITNUMBER, '', '', ''),
    @ADDRESS_CITY = PISR.MAILINGCITY,
    @ADDRESS_POSTCODE = PISR.MAILINGPOSTCODE,
    @ADDRESS_STATEID = dbo.UFN_STATE_GETID(@ADDRESS_COUNTRYID, PISR.MAILINGSTATE, 1)
from
    dbo.PARTIALINFORMATIONSEARCHRESULT_REALESTATE PISR
where ID = @RESULTID

declare @CHANGEAGENTID uniqueidentifier
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

select @ADDRESS_INFOSOURCECODEID = ID from dbo.INFOSOURCECODE where DESCRIPTION = 'CoreLogic'
if @ADDRESS_INFOSOURCECODEID is null begin
    insert into dbo.INFOSOURCECODE
    (
        DESCRIPTION,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED
    )
    values
    (
        'CoreLogic',
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
    )
    select @ADDRESS_INFOSOURCECODEID = ID from dbo.INFOSOURCECODE where DESCRIPTION = 'CoreLogic'
end

if @@error <> 0 
    begin
        if @r <> 0 return @r
        return 1;
    end

return @r;