USP_DATAFORMTEMPLATE_ADD_MKTVENDORCONTACT_PRELOAD

The load procedure used by the edit dataform template "Marketing Vendor Contact Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@VENDORID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@VENDORNAME	nvarchar(154)	INOUT	Vendor name
@CONTACT_ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@CONSTITUENTTYPE	int	INOUT
@DEFAULT_COUNTRYID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTVENDORCONTACT_PRELOAD]
(
  @VENDORID uniqueidentifier,
  @VENDORNAME nvarchar(154) = null output,
  @CONTACT_ADDRESS_COUNTRYID uniqueidentifier = null output,
  @CONSTITUENTTYPE int = null output,
  @DEFAULT_COUNTRYID uniqueidentifier = null output
)
as
  set nocount on;

  select @VENDORNAME = [CONSTITUENT].[NAME]
  from dbo.[CONSTITUENT]
  where [ID] = @VENDORID;

  set @CONTACT_ADDRESS_COUNTRYID = dbo.[UFN_COUNTRY_GETDEFAULT]();
  set @DEFAULT_COUNTRYID = dbo.[UFN_COUNTRY_GETDEFAULT]();

  set @CONSTITUENTTYPE = 1;

  return 0;