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;