USP_DATAFORMTEMPLATE_EDIT_PRENOTIFICATIONPROCESS

The save procedure used by the edit dataform template "Prenotification Process 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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@DATETYPECODE	tinyint	IN	Financial processing date
@DATE	datetime	IN	Specific date
@SPONSORINGINSTITUTIONID	uniqueidentifier	IN	Sponsoring institution
@BANKACCOUNTID	uniqueidentifier	IN	Bank account
@IMMEDIATEDESTINATIONNAME	nvarchar(23)	IN	Immediate destination name
@CREATECREDITOFFSETTRANSACTION	bit	IN	Create credit offset transaction
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PRENOTIFICATIONPROCESS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @IDSETREGISTERID uniqueidentifier,
    @DATETYPECODE tinyint,
    @DATE datetime,
    @SPONSORINGINSTITUTIONID uniqueidentifier,
    @BANKACCOUNTID uniqueidentifier,
    @IMMEDIATEDESTINATIONNAME nvarchar(23),
    @CREATECREDITOFFSETTRANSACTION bit,
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETNAME nvarchar(100),
    @OVERWRITEOUTPUTIDSET bit
)

as
  set nocount on;

    declare @CURRENTAPPUSERID uniqueidentifier;
    declare @SITEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PRENOTIFICATIONPROCESS
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID output,
        @SITEID = @SITEID output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PRENOTIFICATIONPROCESS_2
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @IDSETREGISTERID,
        @DATETYPECODE,
        @DATE,
        @SPONSORINGINSTITUTIONID,
        @BANKACCOUNTID,
        @IMMEDIATEDESTINATIONNAME,
        @CREATECREDITOFFSETTRANSACTION,
        @CREATEOUTPUTIDSET,
        @OUTPUTIDSETNAME,
        @OVERWRITEOUTPUTIDSET,
        @CURRENTAPPUSERID,
        @SITEID;

  return 0;