USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESSPREPROCESS_2

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.
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@STARTINGRECEIPTNUMBER	int	IN	Use starting receipt number
@MARKRECEIPTED	bit	IN	Mark revenue 'Receipted' when process completes
@RECEIPTDATETYPECODE	tinyint	IN	Receipt date
@RECEIPTDATE	datetime	IN	Receipt date
@EXCLUSIONDATETYPECODE	tinyint	IN	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	IN	Consider exclusions as of
@EXCLUDEDECEASED	bit	IN	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	IN	Exclude inactive constituents
@EXCLUSIONS	xml	IN	Exclusions
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESSPREPROCESS_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETRECORDTYPEID uniqueidentifier,
    @OUTPUTIDSETNAME nvarchar(100),
    @OVERWRITEOUTPUTIDSET bit,
    @STARTINGRECEIPTNUMBER int,
    @MARKRECEIPTED bit,
    @RECEIPTDATETYPECODE tinyint,
    @RECEIPTDATE datetime,
    @EXCLUSIONDATETYPECODE tinyint,
    @EXCLUSIONASOFDATE datetime,
    @EXCLUDEDECEASED bit,
    @EXCLUDEINACTIVE bit,
    @EXCLUSIONS xml,--@OVERRIDEREQUIREDEXCLUSIONS bit,--@REQUIREDEXCLUSIONS xml,

    @CURRENTAPPUSERID uniqueidentifier = null
)

as
  set nocount on;

    declare @DUPLICATENUMBERACTIONCODE tinyint;
    declare @STARTINGNUMBERCREATESGAPACTIONCODE tinyint;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECEIPTINGPROCESSPREPROCESS_2
        @ID = @ID,
        @DUPLICATENUMBERACTIONCODE = @DUPLICATENUMBERACTIONCODE output,
        @STARTINGNUMBERCREATESGAPACTIONCODE = @STARTINGNUMBERCREATESGAPACTIONCODE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESSPREPROCESS_3
        @ID,
        @CHANGEAGENTID,
        @CREATEOUTPUTIDSET,
        @OUTPUTIDSETRECORDTYPEID,
        @OUTPUTIDSETNAME,
        @OVERWRITEOUTPUTIDSET,
        @STARTINGRECEIPTNUMBER,
        @MARKRECEIPTED,
        @RECEIPTDATETYPECODE,
        @RECEIPTDATE,
        @EXCLUSIONDATETYPECODE,
        @EXCLUSIONASOFDATE,
        @EXCLUDEDECEASED,
        @EXCLUDEINACTIVE,
        @EXCLUSIONS,
        --@OVERRIDEREQUIREDEXCLUSIONS,

        --@REQUIREDEXCLUSIONS,

        @CURRENTAPPUSERID,
        @DUPLICATENUMBERACTIONCODE,
        @STARTINGNUMBERCREATESGAPACTIONCODE

  return 0;