USP_DATAFORMTEMPLATE_EDITLOAD_RECEIPTINGPROCESS_2

The load procedure used by the edit dataform template "Receipting Process Edit Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@IDSETREGISTERID	uniqueidentifier	INOUT	Selection
@DESCRIPTION	nvarchar(255)	INOUT	Description
@CREATEOUTPUTIDSET	bit	INOUT	Create selection from results
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	INOUT	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@REVENUERECORDTYPEID	uniqueidentifier	INOUT
@MARKRECEIPTED	bit	INOUT	Mark revenue 'Receipted' when process completes
@BUSINESSPROCESSVIEWID	uniqueidentifier	INOUT	Output format
@QUERYID	uniqueidentifier	INOUT
@QUERYTYPE	nvarchar(10)	INOUT
@LETTERFILE	varbinary	INOUT	File
@LETTERFILENAME	nvarchar(255)	INOUT	Word template
@DISPLAYEDLETTERFILENAME	nvarchar(255)	INOUT	File
@LETTERFILECHANGED	bit	INOUT	Letter file changed?
@LABELFILE	varbinary	INOUT	Label File
@LABELFILENAME	nvarchar(255)	INOUT	Label File
@DISPLAYEDLABELFILENAME	nvarchar(255)	INOUT	Label file
@LABELFILECHANGED	bit	INOUT	Label File changed?
@BUSINESSPROCESSOUTPUTDATALISTIDS	xml	INOUT
@RECEIPTDATETYPECODE	tinyint	INOUT	Receipt date
@RECEIPTDATE	datetime	INOUT	Receipt date
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@OWNERID	uniqueidentifier	INOUT
@EXCLUSIONDATETYPECODE	tinyint	INOUT	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	INOUT	Consider exclusions as of
@EXCLUDEDECEASED	bit	INOUT	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	INOUT	Exclude inactive constituents
@EXCLUSIONS	xml	INOUT	Exclusions
@CUSTOMPARAMETERDATAFORMITEM	xml	INOUT
@RECEIPTTYPECODE	tinyint	INOUT	Receipt type
@REQUIREDEXCLUSIONS	xml	INOUT	Required exclusions
@BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	INOUT
@BUSINESSPROCESSOUTPUTVIEWS	xml	INOUT
@EXPORTDEFINITIONID	uniqueidentifier	INOUT	Export definition
@RECEIPTSTACKID	uniqueidentifier	INOUT	Receipt Stack
@RERECEIPTSAMENUMBER	bit	INOUT	Include re-receipt payments that use the same receipt number
@RERECEIPTNEWNUMBER	bit	INOUT	Include re-receipt payments that receive a new receipt number
@RERECEIPTPAYMENTS	bit	INOUT
@SAMENUMBERONRERECEIPT	bit	INOUT
@DUPLICATENUMBERACTIONCODE	tinyint	INOUT	If new receipt ID is a duplicate
@STARTINGNUMBERCREATESGAPACTIONCODE	tinyint	INOUT	If new receipt ID leaves a gap
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site Required
@SITEID	uniqueidentifier	INOUT	Site

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECEIPTINGPROCESS_2
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,                                            
  @NAME nvarchar(100) = null output, 
  @IDSETREGISTERID uniqueidentifier = null output, 
  @DESCRIPTION nvarchar(255) = null output, 
  @CREATEOUTPUTIDSET bit = null output,
  @OUTPUTIDSETRECORDTYPEID uniqueidentifier = null output, 
  @OUTPUTIDSETNAME nvarchar(100) = null output, 
  @OVERWRITEOUTPUTIDSET bit = null output,                    
  @REVENUERECORDTYPEID uniqueidentifier = null output,                    
  @MARKRECEIPTED bit = null output,        
  @BUSINESSPROCESSVIEWID uniqueidentifier = null output,
  @QUERYID uniqueidentifier = null output,
  @QUERYTYPE nvarchar(10) = null output,
  @LETTERFILE varbinary(max) = null output,
  @LETTERFILENAME nvarchar(255) = null output,
  @DISPLAYEDLETTERFILENAME nvarchar(255) = null output,
  @LETTERFILECHANGED bit = null output,
  @LABELFILE varbinary(max) = null output,
  @LABELFILENAME nvarchar(255) = null output,
  @DISPLAYEDLABELFILENAME nvarchar(255) = null output,
  @LABELFILECHANGED bit = null output,
  @BUSINESSPROCESSOUTPUTDATALISTIDS xml = null output,
  @RECEIPTDATETYPECODE tinyint = null output,
  @RECEIPTDATE datetime = null output,
  @TSLONG bigint = 0 output,
  @OWNERID uniqueidentifier = null output,
  @EXCLUSIONDATETYPECODE tinyint = null output,
  @EXCLUSIONASOFDATE datetime = null output,
  @EXCLUDEDECEASED bit = null output,
  @EXCLUDEINACTIVE bit = null output,
  @EXCLUSIONS xml = null output,
  @CUSTOMPARAMETERDATAFORMITEM xml = null output,
  @RECEIPTTYPECODE tinyint = null output,
  --@OVERRIDEREQUIREDEXCLUSIONS bit = null output,

  @REQUIREDEXCLUSIONS xml = null output,
  @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null output,
  @BUSINESSPROCESSOUTPUTVIEWS xml = null output,
  @EXPORTDEFINITIONID uniqueidentifier = null output,
  @RECEIPTSTACKID uniqueidentifier = null output,
  @RERECEIPTSAMENUMBER bit = null output,
  @RERECEIPTNEWNUMBER bit = null output,
  @RERECEIPTPAYMENTS bit = null output,
  @SAMENUMBERONRERECEIPT bit = null output,
  @DUPLICATENUMBERACTIONCODE tinyint = null output,
  @STARTINGNUMBERCREATESGAPACTIONCODE tinyint = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SITEREQUIRED bit = null output,
  @SITEID uniqueidentifier = null output
)
as
begin
  set nocount on

  set @DATALOADED = 0;
  set @TSLONG = 0;
  set @BUSINESSPROCESSPARAMETERSETID = @ID;

  declare @BUSINESSPROCESSCATALOGID uniqueidentifier = '83048DED-208E-45c9-852C-E7D5C7317882';

  select
    @DATALOADED = 1,
    @NAME = RECEIPTINGPROCESS.NAME, 
    @IDSETREGISTERID = RECEIPTINGPROCESS.IDSETREGISTERID, 
    @DESCRIPTION = RECEIPTINGPROCESS.DESCRIPTION, 
    @CREATEOUTPUTIDSET = RECEIPTINGPROCESS.CREATEOUTPUTIDSET,
    @OUTPUTIDSETRECORDTYPEID = RECEIPTINGPROCESS.OUTPUTIDSETRECORDTYPEID, 
    @OUTPUTIDSETNAME = RECEIPTINGPROCESS.OUTPUTIDSETNAME, 
    @OVERWRITEOUTPUTIDSET = RECEIPTINGPROCESS.OVERWRITEOUTPUTIDSET,        
    @MARKRECEIPTED = RECEIPTINGPROCESS.MARKRECEIPTED,        
    @BUSINESSPROCESSVIEWID = RECEIPTINGPROCESS.BUSINESSPROCESSVIEWID,
    @LETTERFILENAME = RECEIPTINGPROCESS.LETTERFILENAME,
    @LABELFILENAME = RECEIPTINGPROCESS.LABELFILENAME,    
    @DISPLAYEDLETTERFILENAME = RECEIPTINGPROCESS.LETTERFILENAME,
    @DISPLAYEDLABELFILENAME = RECEIPTINGPROCESS.LABELFILENAME,    
    @RECEIPTDATETYPECODE = RECEIPTINGPROCESS.RECEIPTDATETYPECODE,
    @RECEIPTDATE = RECEIPTINGPROCESS.RECEIPTDATE,
    @TSLONG = RECEIPTINGPROCESS.TSLONG,
    @OWNERID = BUSINESSPROCESSINSTANCE.OWNERID,
    @CUSTOMPARAMETERDATAFORMITEM = RECEIPTINGPROCESS.CUSTOMPARAMETERDATAFORMITEM,
    @RECEIPTTYPECODE = RECEIPTINGPROCESS.RECEIPTTYPECODE,
    @EXPORTDEFINITIONID = RECEIPTINGPROCESS.EXPORTDEFINITIONID,
    @RECEIPTSTACKID = RECEIPTINGPROCESS.RECEIPTSTACKINFOID,
    @RERECEIPTSAMENUMBER = RECEIPTINGPROCESS.RERECEIPTSAMENUMBER,
    @RERECEIPTNEWNUMBER = RECEIPTINGPROCESS.RERECEIPTNEWNUMBER,
    @DUPLICATENUMBERACTIONCODE = RECEIPTINGPROCESS.DUPLICATENUMBERACTIONCODE,
    @STARTINGNUMBERCREATESGAPACTIONCODE = RECEIPTINGPROCESS.STARTINGNUMBERCREATESGAPACTIONCODE,
    @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID),
    @SITEID = BUSINESSPROCESSINSTANCE.SITEID
  from dbo.RECEIPTINGPROCESS
  left join dbo.BUSINESSPROCESSINSTANCE 
    on  BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID = RECEIPTINGPROCESS.ID
    and BUSINESSPROCESSINSTANCE.BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID
  where
    RECEIPTINGPROCESS.ID = @ID;

  select @REVENUERECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'REVENUE';                    

  select @QUERYID = dbo.UFN_IDSET_GETQUERYID(@IDSETREGISTERID);
  select @QUERYTYPE = dbo.UFN_IDSET_GETQUERYTYPE(@IDSETREGISTERID);
  select @BUSINESSPROCESSOUTPUTDATALISTIDS = dbo.UFN_BUSINESSPROCESS_GETBUSINESSPROCESSVIEWANDDATALIST_TOITEMLISTXML('ReceiptingProcessOutputDataListID');
  select @BUSINESSPROCESSOUTPUTVIEWS = dbo.UFN_BUSINESSPROCESS_GETBUSINESSPROCESSOUTPUTVIEWS_TOITEMLISTXML(N'83048DED-208E-45c9-852C-E7D5C7317882');

  select @EXCLUSIONDATETYPECODE = DATETYPECODE,
    @EXCLUSIONASOFDATE = ASOFDATE,
    @EXCLUDEDECEASED = EXCLUDEDECEASED,
    @EXCLUDEINACTIVE = EXCLUDEINACTIVE,
    @EXCLUSIONS = dbo.UFN_BUSINESSPROCESSCOMMPREF_GETEXCLUSIONS_TOITEMLISTXML(@ID)
    --@OVERRIDEREQUIREDEXCLUSIONS = OVERRIDEREQUIREDEXCLUSIONS

  from dbo.BUSINESSPROCESSCOMMPREF
  where BUSINESSPROCESSPARAMETERSETID = @ID;

  set @REQUIREDEXCLUSIONS = dbo.UFN_SOLICITCODE_GETREQUIRED_TOITEMLISTXML();
  --if @OVERRIDEREQUIREDEXCLUSIONS = 1

  --    set @REQUIREDEXCLUSIONS = dbo.UFN_BUSINESSPROCESSCOMMPREF_GETREQUIREDEXCLUSIONS_TOITEMLISTXML(@ID)

  --else

  --    select top 1 

  --        @EXCLUDEDECEASED = EXCLUDEDECEASED,

  --        @EXCLUDEINACTIVE = EXCLUDEINACTIVE,

  --        @REQUIREDEXCLUSIONS = dbo.UFN_SOLICITCODE_GETREQUIRED_TOITEMLISTXML()

  --    from dbo.EXCLUSIONSETTINGS;


  select @RERECEIPTPAYMENTS = RERECEIPTPAYMENTS, @SAMENUMBERONRERECEIPT = SAMENUMBERONRERECEIPT  from RECEIPTPREFERENCEINFO

  if @RECEIPTSTACKID is null
    select @RECEIPTSTACKID = ID from RECEIPTSTACKINFO where ISDEFAULT = 1;

  return 0
end