USP_DATAFORMTEMPLATE_ADD_RECURRINGGIFTSTATUSUPDATEPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@PAYMENTMETHODVALUE	xml	IN
@FREQUENCYVALUE	xml	IN
@IDSETREGISTERID	uniqueidentifier	IN
@PASTDUECODE	tinyint	IN
@DAYSPASTDUE	smallint	IN
@LAPSEDCODE	tinyint	IN
@LAPSEDINSTALLMENTSPASTDUE	smallint	IN
@LAPSEDINSTALLMENTSDAYSPAST	smallint	IN
@TERMINATEDCODE	tinyint	IN
@TERMINATEDINSTALLMENTSPASTDUE	smallint	IN
@TERMINATEDINSTALLMENTSDAYSPAST	smallint	IN
@OTHERPAYMENTMETHODS	xml	IN

Definition

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RECURRINGGIFTSTATUSUPDATEPROCESS
          (
              @ID uniqueidentifier = null output,
              @CHANGEAGENTID uniqueidentifier = null,
              @NAME nvarchar(100),
              @DESCRIPTION nvarchar(255) ='',
              @CURRENTAPPUSERID uniqueidentifier,
              @PAYMENTMETHODVALUE xml = null,
              @FREQUENCYVALUE xml = null,
              @IDSETREGISTERID uniqueidentifier = null,
              @PASTDUECODE tinyint = 1,
              @DAYSPASTDUE smallint = 30,
              @LAPSEDCODE tinyint = 1,
              @LAPSEDINSTALLMENTSPASTDUE smallint = 2,
              @LAPSEDINSTALLMENTSDAYSPAST smallint = 60,
              @TERMINATEDCODE tinyint = 1,
              @TERMINATEDINSTALLMENTSPASTDUE smallint = 3,
              @TERMINATEDINSTALLMENTSDAYSPAST smallint = 90,
              @OTHERPAYMENTMETHODS xml = null
          )
          as
              set nocount on;
              declare @CURRENTDATE datetime;

              if @ID is null
                  set @ID = newid();

              if @CHANGEAGENTID is null  
                  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

              set @CURRENTDATE = getdate();

              declare @CHECKLEGACYHELD bit = 0;

              if exists(select top 1 'x' from dbo.UFN_SELECTION_REVENUE_LEGACYHELDRECURRINGGIFTS())
                set @CHECKLEGACYHELD = 1;

              begin try
                  insert into dbo.RECURRINGGIFTSTATUSUPDATEPROCESS
                  (
                    ID, 
                    NAME, 
                    DESCRIPTION, 
                    PAYMENTMETHODVALUE, 
                    FREQUENCYVALUE, 
                    IDSETREGISTERID, 
                    PASTDUECODE,
                    DAYSPASTDUE,
                    LAPSEDCODE,
                    LAPSEDINSTALLMENTSPASTDUE,
                    LAPSEDINSTALLMENTSDAYSPAST,
                    TERMINATEDCODE,
                    TERMINATEDINSTALLMENTSPASTDUE,
                    TERMINATEDINSTALLMENTSDAYSPAST,
                    OTHERPAYMENTMETHODS,
                    CHECKLEGACYHELD,
                    ADDEDBYID, 
                    CHANGEDBYID, 
                    DATEADDED, 
                    DATECHANGED
                  )
                  values
                  (
                    @ID, 
                    @NAME, 
                    @DESCRIPTION, 
                    @PAYMENTMETHODVALUE, 
                    @FREQUENCYVALUE, 
                    @IDSETREGISTERID, 
                    @PASTDUECODE,
                    @DAYSPASTDUE,
                    @LAPSEDCODE,
                    @LAPSEDINSTALLMENTSPASTDUE,
                    @LAPSEDINSTALLMENTSDAYSPAST,
                    @TERMINATEDCODE,
                    @TERMINATEDINSTALLMENTSPASTDUE,
                    @TERMINATEDINSTALLMENTSDAYSPAST,
                    @OTHERPAYMENTMETHODS,
                    @CHECKLEGACYHELD,
                    @CHANGEAGENTID, 
                    @CHANGEAGENTID, 
                    @CURRENTDATE, 
                    @CURRENTDATE);

                  exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD 
                      @CHANGEAGENTID = @CHANGEAGENTID, 
                      @BUSINESSPROCESSCATALOGID = '2a13ea65-e2a3-4edc-8407-ab09ac62d7bb', 
                      @BUSINESSPROCESSPARAMETERSETID = @ID, 
                      @OWNERID = @CURRENTAPPUSERID;
              end try

              begin catch
                  exec dbo.USP_RAISE_ERROR;
                  return 1;
              end catch

              return 0;