USP_DATAFORMTEMPLATE_EDIT_PAPERLESSMANDATESINSTRUCTION

Old version of the form to save paperless mandate instruction processes.

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
@PROCESSDATETYPECODE	tinyint	IN	Processing date
@PROCESSDATE	datetime	IN	Processing date
@PROCESSDAYSAFTER	int	IN	Days after this process runs
@SPONSORINGINSTITUTIONID	uniqueidentifier	IN	Sponsoring institution
@APPENDLINEFEED	bit	IN	Append line breaks between records
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@BANKACCOUNTID	uniqueidentifier	IN	Bank account

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PAPERLESSMANDATESINSTRUCTION
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @NAME nvarchar(100), 
                @DESCRIPTION nvarchar(255), 
                @IDSETREGISTERID uniqueidentifier,
                @PROCESSDATETYPECODE tinyint,
                @PROCESSDATE datetime,
                @PROCESSDAYSAFTER integer,
                @SPONSORINGINSTITUTIONID uniqueidentifier ,
                @APPENDLINEFEED bit,
                @CREATEOUTPUTIDSET bit,
                @OUTPUTIDSETNAME nvarchar(100), 
                @OVERWRITEOUTPUTIDSET bit,
                @BANKACCOUNTID uniqueidentifier
            )
            as

            set nocount on;

            declare @REQUESTAUDITTRAIL bit;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PAPERLESSMANDATESINSTRUCTION @ID=@ID, @REQUESTAUDITTRAIL=@REQUESTAUDITTRAIL output;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_PAPERLESSMANDATESINSTRUCTION_2
                @ID=@ID,
                @CHANGEAGENTID=@CHANGEAGENTID,
                @NAME=@NAME,
                @DESCRIPTION=@DESCRIPTION,
                @IDSETREGISTERID=@IDSETREGISTERID,
                @PROCESSDATETYPECODE=@PROCESSDATETYPECODE,
                @PROCESSDATE=@PROCESSDATE,
                @PROCESSDAYSAFTER=@PROCESSDAYSAFTER,
                @SPONSORINGINSTITUTIONID=@SPONSORINGINSTITUTIONID,
                @APPENDLINEFEED=@APPENDLINEFEED,
                @CREATEOUTPUTIDSET=@CREATEOUTPUTIDSET,
                @OUTPUTIDSETNAME=@OUTPUTIDSETNAME,
                @OVERWRITEOUTPUTIDSET=@OVERWRITEOUTPUTIDSET,
                @BANKACCOUNTID=@BANKACCOUNTID,
                @REQUESTAUDITTRAIL=@REQUESTAUDITTRAIL;

            return 0;