USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESS_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@IDSETREGISTERID	uniqueidentifier	IN
@DESCRIPTION	nvarchar(255)	IN
@CREATEOUTPUTIDSET	bit	IN
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN
@OUTPUTIDSETNAME	nvarchar(100)	IN
@OVERWRITEOUTPUTIDSET	bit	IN
@MARKRECEIPTED	bit	IN
@BUSINESSPROCESSVIEWID	uniqueidentifier	IN
@LETTERFILE	varbinary	IN
@LETTERFILENAME	nvarchar(255)	IN
@DISPLAYEDLETTERFILENAME	nvarchar(255)	IN
@LETTERFILECHANGED	bit	IN
@LABELFILE	varbinary	IN
@LABELFILENAME	nvarchar(255)	IN
@DISPLAYEDLABELFILENAME	nvarchar(255)	IN
@LABELFILECHANGED	bit	IN
@RECEIPTDATETYPECODE	tinyint	IN
@RECEIPTDATE	datetime	IN
@EXCLUSIONDATETYPECODE	tinyint	IN
@EXCLUSIONASOFDATE	datetime	IN
@EXCLUDEDECEASED	bit	IN
@EXCLUDEINACTIVE	bit	IN
@EXCLUSIONS	xml	IN
@CUSTOMPARAMETERDATAFORMITEM	xml	IN
@RECEIPTTYPECODE	tinyint	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@EXPORTDEFINITIONID	uniqueidentifier	IN

Definition

Copy



create procedure USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESS_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @IDSETREGISTERID uniqueidentifier,
    @DESCRIPTION nvarchar(255),
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETRECORDTYPEID uniqueidentifier,
    @OUTPUTIDSETNAME nvarchar(100),
    @OVERWRITEOUTPUTIDSET bit,
    @MARKRECEIPTED bit,
    @BUSINESSPROCESSVIEWID uniqueidentifier,
    @LETTERFILE varbinary(max),
    @LETTERFILENAME nvarchar(255),
    @DISPLAYEDLETTERFILENAME nvarchar(255),
    @LETTERFILECHANGED bit,
    @LABELFILE varbinary(max),
    @LABELFILENAME nvarchar(255),
    @DISPLAYEDLABELFILENAME nvarchar(255),
    @LABELFILECHANGED bit,
    @RECEIPTDATETYPECODE tinyint,
    @RECEIPTDATE datetime,
    @EXCLUSIONDATETYPECODE tinyint,
    @EXCLUSIONASOFDATE datetime,
    @EXCLUDEDECEASED bit,
    @EXCLUDEINACTIVE bit,
    @EXCLUSIONS xml,
    @CUSTOMPARAMETERDATAFORMITEM xml,
    @RECEIPTTYPECODE tinyint,--@OVERRIDEREQUIREDEXCLUSIONS bit,--@REQUIREDEXCLUSIONS xml,

    @CURRENTAPPUSERID uniqueidentifier = null,
    @EXPORTDEFINITIONID uniqueidentifier
)

as
  set nocount on;

    declare @RECEIPTSTACKID uniqueidentifier;
    declare @RERECEIPTSAMENUMBER bit;
    declare @RERECEIPTNEWNUMBER bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECEIPTINGPROCESS_2
        @ID = @ID,
        @RECEIPTSTACKID = @RECEIPTSTACKID output,
        @RERECEIPTSAMENUMBER = @RERECEIPTSAMENUMBER output,
        @RERECEIPTNEWNUMBER = @RERECEIPTNEWNUMBER output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESS_4
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @IDSETREGISTERID,
        @DESCRIPTION,
        @CREATEOUTPUTIDSET,
        @OUTPUTIDSETRECORDTYPEID,
        @OUTPUTIDSETNAME,
        @OVERWRITEOUTPUTIDSET,
        @MARKRECEIPTED,
        @BUSINESSPROCESSVIEWID,
        @LETTERFILE,
        @LETTERFILENAME,
        @DISPLAYEDLETTERFILENAME,
        @LETTERFILECHANGED,
        @LABELFILE,
        @LABELFILENAME,
        @DISPLAYEDLABELFILENAME,
        @LABELFILECHANGED,
        @RECEIPTDATETYPECODE,
        @RECEIPTDATE,
        @EXCLUSIONDATETYPECODE,
        @EXCLUSIONASOFDATE,
        @EXCLUDEDECEASED,
        @EXCLUDEINACTIVE,
        @EXCLUSIONS,
        @CUSTOMPARAMETERDATAFORMITEM,
        @RECEIPTTYPECODE,
        --@OVERRIDEREQUIREDEXCLUSIONS,

        --@REQUIREDEXCLUSIONS,

        @CURRENTAPPUSERID,
        @EXPORTDEFINITIONID,
        @RECEIPTSTACKID,
        @RERECEIPTSAMENUMBER,
        @RERECEIPTNEWNUMBER

  return 0;