存储过程7

jar_java

于 2011-02-20 19:05:00 发布

阅读量74

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/jar_java/article/details/83842426

-- update info
        IF V_RESULT_FLAG = 1 THEN
          --if Telesales forecast/CST forecast ,then change the proc_status = 1
          --and move the data to history table
          IF (V_SOURCE_TYPE_CODE IN ('4', '5')) THEN
            UPDATE INT_ERP_PO_INFO
               SET ERP_PO_STATUS = 1, PROC_DATE = SYSDATE, PROC_STATUS = 1
             WHERE REFERENCE_NUM = V_REFERENCE_NUM;

            INSERT INTO INT_ERP_PO_INFO_HIS
              (SELECT *
                 FROM INT_ERP_PO_INFO
                WHERE REFERENCE_NUM = V_REFERENCE_NUM);

            DELETE FROM INT_ERP_PO_INFO
             WHERE REFERENCE_NUM = V_REFERENCE_NUM;

          ELSE

            UPDATE INT_ERP_PO_INFO
               SET ERP_PO_STATUS = 1, PROC_DATE = SYSDATE, PROC_STATUS = 0
             WHERE REFERENCE_NUM = V_REFERENCE_NUM;
          END IF;
        ELSE