USP_DATAFORMTEMPLATE_PRELOAD_ADD_RECEIPTINGPROCESS_3

The load procedure used by the edit dataform template "Receipting Process Add Form 3"

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUERECORDTYPEID	uniqueidentifier	INOUT
@BUSINESSPROCESSOUTPUTDATALISTIDS	xml	INOUT
@EXCLUSIONS	xml	INOUT	Exclusions
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@REQUIREDEXCLUSIONS	xml	INOUT	Required exclusions
@BUSINESSPROCESSOUTPUTVIEWS	xml	INOUT
@RECEIPTSTACKID	uniqueidentifier	INOUT	Receipt stack
@RERECEIPTPAYMENTS	bit	INOUT
@SAMENUMBERONRERECEIPT	bit	INOUT
@DUPLICATENUMBERACTIONCODE	tinyint	INOUT	If new receipt ID is a duplicate
@SITEREQUIRED	bit	INOUT	Site Required
@SITEID	uniqueidentifier	INOUT	Site

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_RECEIPTINGPROCESS_3
(
  @REVENUERECORDTYPEID uniqueidentifier = null output,
  @BUSINESSPROCESSOUTPUTDATALISTIDS xml = null output,
  @EXCLUSIONS xml = null output,
  @CURRENTAPPUSERID uniqueidentifier,
  @REQUIREDEXCLUSIONS xml = null output,
  @BUSINESSPROCESSOUTPUTVIEWS xml = null output,
  --@EXCLUDEDECEASED bit = null output,

  --@EXCLUDEINACTIVE bit = null output

  @RECEIPTSTACKID uniqueidentifier = null output,
  @RERECEIPTPAYMENTS bit = null output,
  @SAMENUMBERONRERECEIPT bit = null output,
  @DUPLICATENUMBERACTIONCODE tinyint = null output,
  @SITEREQUIRED bit = null output,
  @SITEID uniqueidentifier = null output
)
as
begin            
  set nocount on;

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

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

  set @EXCLUSIONS = dbo.UFN_BUSINESSPROCESSCOMMPREF_GETDEFAULTEXCLUSIONS_TOITEMLISTXML(@CURRENTAPPUSERID)
  set @REQUIREDEXCLUSIONS = dbo.UFN_SOLICITCODE_GETREQUIRED_TOITEMLISTXML();
  --select top 1 

  --    @EXCLUDEDECEASED = EXCLUDEDECEASED,

  --    @EXCLUDEINACTIVE = EXCLUDEINACTIVE

  --from dbo.EXCLUSIONSETTINGS;


  select  @RECEIPTSTACKID = ID from RECEIPTSTACKINFO where ISDEFAULT = 1 

  select @RERECEIPTPAYMENTS = RERECEIPTPAYMENTS from RECEIPTPREFERENCEINFO

  select @SAMENUMBERONRERECEIPT = SAMENUMBERONRERECEIPT from RECEIPTPREFERENCEINFO

  if exists (select * from dbo.CONDITIONSETTING where NAME = N'RegulatedReceipting' )
    set @DUPLICATENUMBERACTIONCODE = 0
  else 
    set @DUPLICATENUMBERACTIONCODE = 1

  select 
    @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID),
    @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
  return 0;
end