IF v_status_id = 81
         THEN
            SELECT   id,
                     itemnumber,
                     createdate,
                     lastdate,
                     parvalue,
                     price,
                     money,
                     status_id,
                     send,
                     sendcount,
                     sendtime,
                     air,
                     offer_id,
                     agent_id,
                     refundmentnumber,
                     v_orderid,
                     stat_agent_date,
                     stat_sky_date
              INTO   v_item_id,
                     v_itemnumber,
                     v_createdate,
                     v_lastdate,
                     v_parvalue,
                     v_price,
                     v_money,
                     v_status_id,
                     v_send,
                     v_sendcount,
                     v_sendtime,
                     v_air,
                     v_offer_id,
                     v_agent_id,
                     v_refundmentnumber,
                     v_orderid,
                     v_stat_agent_date,
                     v_stat_sky_date
              FROM   tab_topup_orderitem o
             WHERE   o.itemnumber = c_itemnumber;

            INSERT INTO TAB_DATA_CORRECTION_RECORD (ID,
                                                    CREATEDATE,
                                                    LASTDATE,
                                                    ITEMNUMBER,
                                                    PARVALUE,
                                                    PRICE,
                                                    SEND,
                                                    SENDCOUNT,
                                                    SENDTIME,
                                                    MONEY,
                                                    STATUS_ID,
                                                    AIR,
                                                    OFFER_ID,
                                                    AGENT_ID,
                                                    REFUNDMENTNUMBER,
                                                    CORRECTIONDATE)
              VALUES   (SEQ_DATA_CORRECTION_RECORD.NEXTVAL,
                        v_createdate,
                        v_lastdate,
                        v_itemnumber,
                        v_parvalue,
                        v_price,
                        v_send,
                        v_sendcount,
                        v_sendtime,
                        v_money,
                        v_status_id,
                        v_air,
                        v_offer_id,
                        v_agent_id,
                        v_refundmentnumber,
                        SYSDATE);

            COMMIT;

            UPDATE   tab_topup_orderitem
               SET   price = parvalue, status_id = 82, llprice = parvalue
             WHERE   itemnumber = c_itemnumber;

            COMMIT;

            UPDATE   tab_topup_orderitem
               SET   successdate = SYSDATE
             WHERE   itemnumber = c_itemnumber;

            COMMIT;

            UPDATE   tab_base_moneylist
               SET   money = 0
             WHERE   serialnumber = v_refundmentnumber;

            COMMIT;

            --检查订单有否有对应的代充商,没有则指定代充商
            --空充需要指定代充商,卡充不需要指定代充商
            /*
            ------------------------------------------Start here-----------------------------------
            SELECT   '%' || O_LOGOGRAM || '%' INTO v_offername FROM DUAL;

            SELECT   id
              INTO   v_group_id
              FROM   tab_base_group
             WHERE   CTYPE = 'Supply' AND logogram LIKE v_offername;

            IF v_group_id = 2283 AND v_offer_id IS NULL
            THEN
               UPDATE   tab_topup_orderitem
                  SET   LIANLIAN = 1, AIR = 1, OFFER_ID = 2283, FFERRES = 1
                WHERE   itemnumber = c_itemnumber;

               COMMIT;
            ELSIF v_group_id != 2283 AND v_offer_id IS NULL
            THEN
               UPDATE   tab_topup_orderitem
                  SET   AIR = 1, OFFER_ID = v_group_id, FFERRES = 1
                WHERE   itemnumber = c_itemnumber;

               COMMIT;
            END IF;
            */

            ------------------------------------------End here---------------------------------------

            --如果订单在资金流水中没有向代充商支付的记录，则加入支付记录
            ------------------------------------------Start here-------------------------------
            SELECT   COUNT ( * )
              INTO   v_count
              FROM   tab_base_moneylist a,
                     tab_topup_moneylist b,
                     tab_topup_orderitem o
             WHERE       a.id = b.moneylist_id
                     AND o.id = b.item_id
                     AND a.tradetype_id = 338
                     AND o.itemnumber = c_itemnumber;

            IF v_count IS NULL
            THEN
               v_count := 0;
            END IF;

            IF v_count < 1
            THEN
               SP_MONEYLIST_ADD_PAYRECORD (c_itemnumber, O_MONEY);
            END IF;

            ------------------------------------------End here------------------------------------

            -- 如果订单之前有成功或失败过,并且在报表中已经统计过,需要改失败或成功的,则需要在订正表中插入一笔记录
            IF v_stat_agent_date IS NOT NULL OR v_stat_sky_date IS NOT NULL
            THEN
               INSERT INTO tab_topup_auditorderitem (id,
                                                     status_id,
                                                     employee_id,
                                                     itemnumber,
                                                     orderid,
                                                     price,
                                                     refundmoney,
                                                     operator_id,
                                                     mobile,
                                                     createdate,
                                                     lastdate,
                                                     auditt,
                                                     item_id,
                                                     auditor_id,
                                                     auditdate,
                                                     checkdate,
                                                     checked,
                                                     statdate,
                                                     refundprice,
                                                     agent_id)
                 VALUES   (seq_tab_topup_auditorderitem.NEXTVAL,
                           O_NSTATUS,
                           NULL,
                           O_ITEMNUMBER,
                           v_orderid,
                           v_parvalue,
                           v_parvalue,
                           12887,
                           '15814462718',
                           SYSDATE,
                           SYSDATE,
                           1,
                           v_item_id,
                           12887,
                           SYSDATE,
                           NULL,
                           0,
                           TRUNC (SYSDATE),
                           v_money,
                           v_offer_id);

               COMMIT;
            END IF;
         END IF;
      --异常处理部分
      --------------------------------------------------------------------------------------------------
      --充值金额大于充值面额,返回:NG001
      --充值到账类型为全部到账且充值金额不等于面额,返回:NG002
      --充值到账类型为部分到账且充值金额不小于面额,返回:NG003
      --充值到账类型为没有到账且充值金额不等于零,返回:NG004
      --------------------------------------------------------------------------------------------------

      ----------------------------------------start here------------------------------------------------
      WHEN O_MONEY > O_PARVALUE                         --充值金额大于充值面额
      THEN
         raise_application_error (
            -20001,
            'Rechargeable amount more than rechargeable denomination, please check!'
         );
      WHEN P_ACCOUNTTYPE = '全部到账' AND O_MONEY != O_PARVALUE
      --充值到账类型为全部到账且充值金额不等于面额
      THEN
         raise_application_error (
            -20001,
            'Top up to account for all types of the account, rechargeable amount is not equal to the amount!'
         );
      WHEN P_ACCOUNTTYPE = '部分到账' AND O_MONEY >= O_PARVALUE
      --充值到账类型为部分到账且充值金额不小于面额
      THEN
         raise_application_error (
            -20001,
            'Top up to account for part of the type to account, rechargeable amount not less than denomination!'
         );
      WHEN P_ACCOUNTTYPE = '没有到账' AND O_MONEY != 0
      --充值到账类型为没有到账且充值金额不等于零
      THEN
         raise_application_error (
            -20001,
            'Top up to account for the type of no account, rechargeable amount is not equal to zero!'
         );
   ----------------------------------------the end--------------------------------------------------------

   END CASE; ------------------------------------------End here--------------------------------------------------------
EXCEPTION
   WHEN OTHERS
   THEN
      ROLLBACK;
      raise_application_error (
         -20001,
         'Input parameter does not meet the process requirements, please contact the database administrator!'
      );
END;
/