USP_IMPORTSELECTIONPROCESS_EDIT_SAVE

Saves information for the import selection process.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@IDFIELD	nvarchar(255)	IN
@IDTYPECODE	tinyint	IN
@ALTERNATELOOKUPIDTYPECODEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_IMPORTSELECTIONPROCESS_EDIT_SAVE]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @IDFIELD nvarchar(255),
  @IDTYPECODE tinyint = 0,
  @ALTERNATELOOKUPIDTYPECODEID uniqueidentifier = null
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

  begin try
    if @CHANGEAGENTID is null
      exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    set @CURRENTDATE = getdate();

    --Update the import selection process information and reset the status to pending import...

    update dbo.[IMPORTSELECTIONPROCESS] set
      [IDFIELD] = @IDFIELD,
      [IDTYPECODE] = @IDTYPECODE,
      [ALTERNATELOOKUPIDTYPECODEID] = @ALTERNATELOOKUPIDTYPECODEID,
      [STATUSCODE] = 0,  --pending import

      [CHANGEDBYID] = @CHANGEAGENTID,
      [DATECHANGED] = @CURRENTDATE
    where [ID] = @ID;
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch

  return 0;