USP_DATAFORMTEMPLATE_EDIT_PHONEFINDERSUBMITPROCESS_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@IDSETREGISTERID	uniqueidentifier	IN
@CREATEOUTPUTIDSET	bit	IN
@OUTPUTIDSETNAME	nvarchar(300)	IN
@OVERWRITEOUTPUTIDSET	bit	IN
@INDIVIDUALADDRESSINCLUDECODE	tinyint	IN
@INDIVIDUALADDRESSTYPECODEID	uniqueidentifier	IN
@ORGANIZATIONADDRESSINCLUDECODE	tinyint	IN
@ORGANIZATIONADDRESSTYPECODEID	uniqueidentifier	IN
@INDIVIDUALPHONENUMBERINCLUDECODE	tinyint	IN
@INDIVIDUALPHONETYPECODEID	uniqueidentifier	IN
@ORGANIZATIONPHONENUMBERINCLUDECODE	tinyint	IN
@ORGANIZATIONPHONETYPECODEID	uniqueidentifier	IN
@INCLUDEINACTIVE	bit	IN
@INCLUDEINCOMPLETEADDRESSES	bit	IN
@INCLUDECONSTITUENTDNM	bit	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PHONEFINDERSUBMITPROCESS_2
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @IDSETREGISTERID uniqueidentifier,
  @CREATEOUTPUTIDSET bit,
  @OUTPUTIDSETNAME nvarchar(300),
  @OVERWRITEOUTPUTIDSET bit,
  @INDIVIDUALADDRESSINCLUDECODE tinyint,
  @INDIVIDUALADDRESSTYPECODEID uniqueidentifier,
  @ORGANIZATIONADDRESSINCLUDECODE tinyint,
  @ORGANIZATIONADDRESSTYPECODEID uniqueidentifier,
  @INDIVIDUALPHONENUMBERINCLUDECODE tinyint,
  @INDIVIDUALPHONETYPECODEID uniqueidentifier,
  @ORGANIZATIONPHONENUMBERINCLUDECODE tinyint,
  @ORGANIZATIONPHONETYPECODEID uniqueidentifier,
  @INCLUDEINACTIVE bit,
  @INCLUDEINCOMPLETEADDRESSES bit,
  @INCLUDECONSTITUENTDNM bit
)
as
begin
  set nocount on;

  if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  declare @CURRENTDATE datetime = getdate();

  begin try
    update dbo.PHONEFINDERSUBMITPROCESS
    set
      IDSETREGISTERID = @IDSETREGISTERID,
      CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
      OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
      OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
      INDIVIDUALADDRESSINCLUDECODE = @INDIVIDUALADDRESSINCLUDECODE,
      INDIVIDUALADDRESSTYPECODEID = @INDIVIDUALADDRESSTYPECODEID,
      ORGANIZATIONADDRESSINCLUDECODE = @ORGANIZATIONADDRESSINCLUDECODE,
      ORGANIZATIONADDRESSTYPECODEID = @ORGANIZATIONADDRESSTYPECODEID,
      CHANGEDBYID = @CHANGEAGENTID,
      DATECHANGED = @CURRENTDATE,
      INDIVIDUALPHONENUMBERINCLUDECODE = @INDIVIDUALPHONENUMBERINCLUDECODE,
      INDIVIDUALPHONETYPECODEID = @INDIVIDUALPHONETYPECODEID,
      ORGANIZATIONPHONENUMBERINCLUDECODE = @ORGANIZATIONPHONENUMBERINCLUDECODE,
      ORGANIZATIONPHONETYPECODEID = @ORGANIZATIONPHONETYPECODEID,
      INCLUDEINACTIVE = @INCLUDEINACTIVE,
      INCLUDEINCOMPLETEADDRESSES = @INCLUDEINCOMPLETEADDRESSES,
      INCLUDECONSTITUENTDNM = @INCLUDECONSTITUENTDNM
    where
      ID = @ID;

  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;
end