USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFTSTATUSUPDATEPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	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_EDIT_RECURRINGGIFTSTATUSUPDATEPROCESS
          (
              @ID uniqueidentifier,
              @CHANGEAGENTID uniqueidentifier = null,
              @NAME nvarchar(100), 
              @DESCRIPTION nvarchar(255),
              @PAYMENTMETHODVALUE xml,
              @FREQUENCYVALUE xml,
              @IDSETREGISTERID uniqueidentifier,
              @PASTDUECODE tinyint,
              @DAYSPASTDUE smallint,
              @LAPSEDCODE tinyint,
              @LAPSEDINSTALLMENTSPASTDUE smallint,
              @LAPSEDINSTALLMENTSDAYSPAST smallint,
              @TERMINATEDCODE tinyint,
              @TERMINATEDINSTALLMENTSPASTDUE smallint,
              @TERMINATEDINSTALLMENTSDAYSPAST smallint,
              @OTHERPAYMENTMETHODS xml
          )
      as
          set nocount on;

          declare @CURRENTDATE datetime;
          set @CURRENTDATE = getdate();

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

          begin try
              update
                  dbo.RECURRINGGIFTSTATUSUPDATEPROCESS
              set
                  NAME = @NAME,
                  DESCRIPTION = @DESCRIPTION,
                  PAYMENTMETHODVALUE = @PAYMENTMETHODVALUE,
                  FREQUENCYVALUE = @FREQUENCYVALUE,
                  IDSETREGISTERID = @IDSETREGISTERID,
                  PASTDUECODE = @PASTDUECODE,
                  DAYSPASTDUE = @DAYSPASTDUE,
                  LAPSEDCODE = @LAPSEDCODE,
                  LAPSEDINSTALLMENTSPASTDUE = @LAPSEDINSTALLMENTSPASTDUE,
                  LAPSEDINSTALLMENTSDAYSPAST = @LAPSEDINSTALLMENTSDAYSPAST,
                  TERMINATEDCODE = @TERMINATEDCODE,
                  TERMINATEDINSTALLMENTSPASTDUE = @TERMINATEDINSTALLMENTSPASTDUE,
                  TERMINATEDINSTALLMENTSDAYSPAST = @TERMINATEDINSTALLMENTSDAYSPAST,
                  CHANGEDBYID = @CHANGEAGENTID,
                  DATECHANGED = @CURRENTDATE,
                  OTHERPAYMENTMETHODS = @OTHERPAYMENTMETHODS
              where
                  ID = @ID;
          end try

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

          return 0;