USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFTPAYMENTHANDLING

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@FIRSTINSTALLMENTCODE	tinyint	INOUT
@INSTALLMENTUNDERPAYMENTCODE	tinyint	INOUT
@APPLYTOPASTINSTALLMENTS	tinyint	INOUT
@PASTBALANCEUNDERPAYMENTCODE	tinyint	INOUT
@OVERPAYMENTCODE	tinyint	INOUT
@ISRGPAYMENTHANDLINGBATCH	bit	INOUT

Definition

Copy


  CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFTPAYMENTHANDLING
  (
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @FIRSTINSTALLMENTCODE tinyint = null output,
    @INSTALLMENTUNDERPAYMENTCODE tinyint = null output,
    @APPLYTOPASTINSTALLMENTS tinyint = null output,
    @PASTBALANCEUNDERPAYMENTCODE tinyint = null output,
    @OVERPAYMENTCODE tinyint = null output,
    @ISRGPAYMENTHANDLINGBATCH bit =  null output

  )
  as

    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select
      @DATALOADED = 1,
      @TSLONG = TSLONG,
      @FIRSTINSTALLMENTCODE = FIRSTINSTALLMENTCODE,
      @INSTALLMENTUNDERPAYMENTCODE = INSTALLMENTUNDERPAYMENTCODE,
      @APPLYTOPASTINSTALLMENTS= APPLYTOPASTINSTALLMENTS,
      @PASTBALANCEUNDERPAYMENTCODE = PASTBALANCEUNDERPAYMENTCODE,
      @OVERPAYMENTCODE = OVERPAYMENTCODE,
      @ISRGPAYMENTHANDLINGBATCH = ISRGPAYMENTHANDLINGBATCH
    from dbo.UFN_RECURRINGGIFTSETTING_GETCURRENT();

    return 0;