USP_DATAFORMTEMPLATE_EDIT_REVENUE_INSTALLMENTS_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@AMOUNT	money	IN
@RESCHEDULEBALANCE	money	IN
@FREQUENCYCODE	tinyint	IN
@NUMBEROFINSTALLMENTS	int	IN
@STARTDATE	datetime	IN
@INSTALLMENTS	xml	IN
@ADJPAYMENT_DATE	datetime	IN
@ADJPAYMENT_POSTDATE	datetime	IN
@ADJPAYMENT_REASONCODEID	uniqueidentifier	IN
@ADJPAYMENT_DETAILS	nvarchar(255)	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUE_INSTALLMENTS_2
(
  @ID uniqueidentifier
  ,@CHANGEAGENTID uniqueidentifier = null
  ,@AMOUNT money
  ,@RESCHEDULEBALANCE money
  ,@FREQUENCYCODE tinyint
  ,@NUMBEROFINSTALLMENTS int
  ,@STARTDATE datetime
  ,@INSTALLMENTS xml
  ,@ADJPAYMENT_DATE datetime
  ,@ADJPAYMENT_POSTDATE datetime
  ,@ADJPAYMENT_REASONCODEID uniqueidentifier
  ,@ADJPAYMENT_DETAILS nvarchar(255)
  )
as
  set nocount on;

    declare @INSTALLMENTAMOUNT money;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUE_INSTALLMENTS_2
        @ID = @ID,
        @INSTALLMENTAMOUNT = @INSTALLMENTAMOUNT output

  exec USP_DATAFORMTEMPLATE_EDIT_REVENUE_INSTALLMENTS_3
    @ID 
    ,@CHANGEAGENTID
    ,@AMOUNT
    ,@RESCHEDULEBALANCE
    ,@FREQUENCYCODE
    ,@NUMBEROFINSTALLMENTS
    ,@STARTDATE
    ,@INSTALLMENTS
    ,@ADJPAYMENT_DATE
    ,@ADJPAYMENT_POSTDATE
    ,@ADJPAYMENT_REASONCODEID
    ,@ADJPAYMENT_DETAILS 
    ,@INSTALLMENTAMOUNT

   return 0;