USP_EDIT_RECURRINGGIFTDETAILS_2

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@CHANGEAGENTID uniqueidentifier IN
@AMOUNT money IN
@SPLITS xml IN
@FREQUENCYCODE tinyint IN
@ENDDATE datetime IN
@STARTDATE datetime IN
@NEXTINSTALLMENTID uniqueidentifier IN
@USEEXISTINGCURRENCY bit IN

Definition

Copy


  CREATE procedure dbo.USP_EDIT_RECURRINGGIFTDETAILS_2
   @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @AMOUNT money,
                    @SPLITS xml,
                    @FREQUENCYCODE tinyint,
                    @ENDDATE datetime,
                    @STARTDATE datetime,
                    @NEXTINSTALLMENTID uniqueidentifier,
          @USEEXISTINGCURRENCY bit

  as
  begin

  declare @INSTALLMENTBEGINDATE datetime

  exec USP_EDITLOAD_RECURRINGGIFTDETAILS @ID =@ID, @INSTALLMENTBEGINDATE = @INSTALLMENTBEGINDATE output

  exec USP_EDIT_RECURRINGGIFTDETAILS_3 @ID,
  @CHANGEAGENTID,
  @AMOUNT,
  @SPLITS,
  @FREQUENCYCODE,
  @ENDDATE,
  @STARTDATE,
  @NEXTINSTALLMENTID,
  @USEEXISTINGCURRENCY,
  @INSTALLMENTBEGINDATE

  end