USP_DATAFORMTEMPLATE_EDIT_ASSIGNLETTERCODESPREPROCESS

The save procedure used by the edit dataform template "Assign Letters Preprocess Edit Form".

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.
@DATELASTRUN	datetime	IN	Specific date
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing Selection
@USEDATEFILTER	bit	IN	Only consider revenue or recognition credit added since:
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_ASSIGNLETTERCODESPREPROCESS]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @DATELASTRUN datetime,
  @CREATEOUTPUTIDSET bit,
  @OUTPUTIDSETNAME nvarchar(100), 
  @OVERWRITEOUTPUTIDSET bit,
  @USEDATEFILTER bit,
  @OUTPUTIDSETRECORDTYPEID uniqueidentifier
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

  set @CURRENTDATE = getdate();

  if @ID is null set @ID = newid();

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

begin try
    update dbo.[ASSIGNLETTERCODESPROCESS] set
      [DATELASTRUN] = @DATELASTRUN,
      [CREATEOUTPUTIDSET] = @CREATEOUTPUTIDSET,
      [OUTPUTIDSETNAME] = @OUTPUTIDSETNAME, 
      [OVERWRITEOUTPUTIDSET] = @OVERWRITEOUTPUTIDSET,
      [USEDATEFILTER] = @USEDATEFILTER,
      [OUTPUTIDSETRECORDTYPEID] = @OUTPUTIDSETRECORDTYPEID,
      [CHANGEDBYID] = @CHANGEAGENTID,
      [DATECHANGED] = @CURRENTDATE
    where [ID] = @ID;
  end try

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

  return 0;