USP_VENDOR_PHONE_ADD

Wraps inserting initial Phones to Constituents as used by Vendors

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN
@PHONETYPECODEID	uniqueidentifier	IN
@PHONE_NUMBER	nvarchar(100)	IN

Definition

Copy



create procedure dbo.USP_VENDOR_PHONE_ADD
(
  @ID uniqueidentifier
  ,@CHANGEAGENTID uniqueidentifier
  ,@CURRENTDATE datetime

  ,@PHONETYPECODEID uniqueidentifier = null
  ,@PHONE_NUMBER nvarchar(100) = ''
)
as
begin
    if (@PHONETYPECODEID is not null) or (coalesce(@PHONE_NUMBER,'') <> '')
    insert into dbo.PHONE
    (
        CONSTITUENTID,
        PHONETYPECODEID,
        NUMBER,
        ISPRIMARY,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED
    )
    values
    (
        @ID,
        @PHONETYPECODEID,
        @PHONE_NUMBER,
        1,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
    );
end