USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFTSTATUSUPDATEPROCESS

Parameters

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

Definition

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFTSTATUSUPDATEPROCESS
          (
              @ID uniqueidentifier,
              @DATALOADED bit = 0 output,
              @NAME nvarchar(100) = null output,
              @DESCRIPTION nvarchar(255) = null output,
              @TSLONG bigint = 0 output,
              @REVENUERECORDTYPEID uniqueidentifier = null output,
              @PAYMENTMETHODVALUE xml = null output,
              @FREQUENCYVALUE xml = null output,
              @IDSETREGISTERID uniqueidentifier = null output,
              @PASTDUECODE tinyint = null output,
              @DAYSPASTDUE smallint = null output,
              @LAPSEDCODE tinyint = null output,
              @LAPSEDINSTALLMENTSPASTDUE smallint = null output,
              @LAPSEDINSTALLMENTSDAYSPAST smallint = null output,
              @TERMINATEDCODE tinyint = null output,
              @TERMINATEDINSTALLMENTSPASTDUE smallint = null output,
              @TERMINATEDINSTALLMENTSDAYSPAST smallint = null output,
              @OTHERPAYMENTMETHODS xml = null output
          )
      as
          set nocount on;

          set @DATALOADED = 0;
          set @TSLONG = 0;

          select
              @DATALOADED = 1,
              @NAME = NAME,
              @DESCRIPTION = DESCRIPTION,
              @TSLONG = TSLONG,
              @PAYMENTMETHODVALUE = PAYMENTMETHODVALUE,
              @FREQUENCYVALUE = FREQUENCYVALUE,
              @IDSETREGISTERID = IDSETREGISTERID,
              @PASTDUECODE = PASTDUECODE,
              @DAYSPASTDUE = DAYSPASTDUE,
              @LAPSEDCODE = LAPSEDCODE,
              @LAPSEDINSTALLMENTSPASTDUE = LAPSEDINSTALLMENTSPASTDUE,
              @LAPSEDINSTALLMENTSDAYSPAST = LAPSEDINSTALLMENTSDAYSPAST,
              @TERMINATEDCODE = TERMINATEDCODE,
              @TERMINATEDINSTALLMENTSPASTDUE = TERMINATEDINSTALLMENTSPASTDUE,
              @TERMINATEDINSTALLMENTSDAYSPAST = TERMINATEDINSTALLMENTSDAYSPAST,
              @OTHERPAYMENTMETHODS = OTHERPAYMENTMETHODS
          from
              dbo.RECURRINGGIFTSTATUSUPDATEPROCESS
          where
              ID = @ID;

          if @PAYMENTMETHODVALUE is null
              set @PAYMENTMETHODVALUE =
                  (   select PAYMENTMETHODCODE
                      from (values (0), (1), (2), (98), (3), (11), (10), (9), (101), (102)) as X(PAYMENTMETHODCODE)
                      for xml raw('ITEM'),type,elements,root('PAYMENTMETHODVALUE'),BINARY BASE64
                  );

          if @FREQUENCYVALUE is null
              set @FREQUENCYVALUE =
                  (   select FREQUENCYCODE
                      from (values (0), (1), (2), (3), (6), (7), (8), (9), (10)) as X(FREQUENCYCODE)
                      for xml raw('ITEM'),type,elements,root('FREQUENCYVALUE'),BINARY BASE64
                  );

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