USP_DATAFORMTEMPLATE_EDIT_DISBURSEMENTPROCESSTEMPLATE_RESULTSSETTINGS

The save procedure used by the edit dataform template "Disbursement Process Template Results Settings Edit Data 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.
@DISBURSEMENTDATENUMBEROFDAYS	int	IN	Number of days
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATENUMBEROFDAYS	int	IN	Number of days
@CREATESELECTIONFROMRESULT	bit	IN	Create selection from results
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DISBURSEMENTPROCESSTEMPLATE_RESULTSSETTINGS (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DISBURSEMENTDATENUMBEROFDAYS integer,
    @POSTSTATUSCODE tinyint,
    @POSTDATENUMBEROFDAYS integer,
  @CREATESELECTIONFROMRESULT bit,
  @OUTPUTIDSETRECORDTYPEID uniqueidentifier,
  @OUTPUTIDSETNAME nvarchar(100),
  @OVERWRITEOUTPUTIDSET bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data

        update dbo.DISBURSEMENTPROCESSTEMPLATE set
            DISBURSEMENTDATENUMBEROFDAYS = @DISBURSEMENTDATENUMBEROFDAYS,
            POSTSTATUSCODE = @POSTSTATUSCODE,
            POSTDATENUMBEROFDAYS = @POSTDATENUMBEROFDAYS,
      CREATESELECTIONFROMRESULT = @CREATESELECTIONFROMRESULT,
      OUTPUTIDSETRECORDTYPEID = @OUTPUTIDSETRECORDTYPEID,
      OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
      OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;