USP_DATAFORMTEMPLATE_EDIT_MKTVENDORCONTACT

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONTACT_LASTNAME	nvarchar(100)	IN	Last name
@CONTACT_FIRSTNAME	nvarchar(50)	IN	First name
@CONTACT_MIDDLENAME	nvarchar(50)	IN	Middle name
@CONTACT_TITLECODEID	uniqueidentifier	IN	Title
@CONTACT_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@CONTACT_NICKNAME	nvarchar(50)	IN	Nickname
@CONTACT_ADDRESS_TYPECODEID	uniqueidentifier	IN	Address type
@CONTACT_ADDRESS_COUNTRYID	uniqueidentifier	IN	Country
@CONTACT_ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@CONTACT_ADDRESS_CITY	nvarchar(50)	IN	City
@CONTACT_ADDRESS_STATEID	uniqueidentifier	IN	State
@CONTACT_ADDRESS_POSTCODE	nvarchar(12)	IN	Post code
@CONTACT_ADDRESS_DONOTMAIL	bit	IN	Do not send mail to this address
@CONTACT_ADDRESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@CONTACT_PHONE_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@CONTACT_PHONE_NUMBER	nvarchar(100)	IN	Phone number
@CONTACT_EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@CONTACT_EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@CONTACT_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@CONTACT_RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact type
@CONTACT_POSITION	nvarchar(50)	IN	Position
@ISPRIMARYCONTACT	bit	IN	Set as primary contact

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTVENDORCONTACT]
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CONTACT_LASTNAME nvarchar(100),
    @CONTACT_FIRSTNAME nvarchar(50),
    @CONTACT_MIDDLENAME nvarchar(50),
    @CONTACT_TITLECODEID uniqueidentifier,
    @CONTACT_SUFFIXCODEID uniqueidentifier,
    @CONTACT_NICKNAME nvarchar(50),
    @CONTACT_ADDRESS_TYPECODEID uniqueidentifier,
    @CONTACT_ADDRESS_COUNTRYID uniqueidentifier,
    @CONTACT_ADDRESS_ADDRESSBLOCK nvarchar(150),
    @CONTACT_ADDRESS_CITY nvarchar(50),
    @CONTACT_ADDRESS_STATEID uniqueidentifier,
    @CONTACT_ADDRESS_POSTCODE nvarchar(12),
    @CONTACT_ADDRESS_DONOTMAIL bit,
    @CONTACT_ADDRESS_DONOTMAILREASONCODEID uniqueidentifier,
    @CONTACT_PHONE_PHONETYPECODEID uniqueidentifier,
    @CONTACT_PHONE_NUMBER nvarchar(100),
    @CONTACT_EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier,
    @CONTACT_EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @CONTACT_RELATIONSHIPTYPECODEID uniqueidentifier,
    @CONTACT_RECIPROCALTYPECODEID uniqueidentifier,
    @CONTACTTYPECODEID uniqueidentifier,
    @CONTACT_POSITION nvarchar(50),
    @ISPRIMARYCONTACT bit
)
as
    set nocount on;

    declare @TITLE2CODEID uniqueidentifier;
    declare @SUFFIX2CODEID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MKTVENDORCONTACT
        @ID = @ID,
        @TITLE2CODEID = @TITLE2CODEID output,
        @SUFFIX2CODEID = @SUFFIX2CODEID output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_MKTVENDORCONTACT_2
        @ID,
        @CHANGEAGENTID,
        @CONTACT_LASTNAME,
        @CONTACT_FIRSTNAME,
        @CONTACT_MIDDLENAME,
        @CONTACT_TITLECODEID,
        @CONTACT_SUFFIXCODEID,
        @CONTACT_NICKNAME,
        @CONTACT_ADDRESS_TYPECODEID,
        @CONTACT_ADDRESS_COUNTRYID,
        @CONTACT_ADDRESS_ADDRESSBLOCK,
        @CONTACT_ADDRESS_CITY,
        @CONTACT_ADDRESS_STATEID,
        @CONTACT_ADDRESS_POSTCODE,
        @CONTACT_ADDRESS_DONOTMAIL,
        @CONTACT_ADDRESS_DONOTMAILREASONCODEID,
        @CONTACT_PHONE_PHONETYPECODEID,
        @CONTACT_PHONE_NUMBER,
        @CONTACT_EMAILADDRESS_EMAILADDRESSTYPECODEID,
        @CONTACT_EMAILADDRESS_EMAILADDRESS,
        @CONTACT_RELATIONSHIPTYPECODEID,
        @CONTACT_RECIPROCALTYPECODEID,
        @CONTACTTYPECODEID,
        @CONTACT_POSITION,
        @ISPRIMARYCONTACT,
        @TITLE2CODEID,
        @SUFFIX2CODEID;

    return 0;