USP_DATAFORMTEMPLATE_EDIT_PREPROCESS_PAPERLESSMANDATESINSTRUCTION

Old procedure to edit the preprocess form for a paperless mandate instruction.

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.
@PROCESSDATETYPECODE tinyint IN Processing date
@PROCESSDATE datetime IN Processing date
@PROCESSDAYSAFTER int IN Days after this process runs
@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

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PREPROCESS_PAPERLESSMANDATESINSTRUCTION
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @PROCESSDATETYPECODE tinyint,
                @PROCESSDATE datetime,
                @PROCESSDAYSAFTER integer,
                @APPENDLINEFEED bit,
                @CREATEOUTPUTIDSET bit,
                @OUTPUTIDSETNAME nvarchar(100), 
                @OVERWRITEOUTPUTIDSET bit
            )
            as

            set nocount on;

            declare @REQUESTAUDITTRAIL bit;

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

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_PREPROCESS_PAPERLESSMANDATESINSTRUCTION_2
                @ID=@ID,
                @CHANGEAGENTID=@CHANGEAGENTID,
                @PROCESSDATETYPECODE=@PROCESSDATETYPECODE,
                @PROCESSDATE=@PROCESSDATE,
                @PROCESSDAYSAFTER=@PROCESSDAYSAFTER,
                @APPENDLINEFEED=@APPENDLINEFEED,
                @CREATEOUTPUTIDSET=@CREATEOUTPUTIDSET,
                @OUTPUTIDSETNAME=@OUTPUTIDSETNAME,
                @OVERWRITEOUTPUTIDSET=@OVERWRITEOUTPUTIDSET,
                @REQUESTAUDITTRAIL=@REQUESTAUDITTRAIL;

            return 0;