SP_GET_ITEMDETAIL.sql 758 B

1234567891011121314151617181920212223
  1. create or replace procedure SP_GET_ITEMDETAIL(P_ORDER_ID IN STRING,P_ITEM_DETAIL_STR OUT STRING) is
  2. /**
  3. * 快递计费 获取发货单明细
  4. * 2016-03-04 scrazy
  5. */
  6. CURSOR CUR_ITEM_DETAILS IS
  7. SELECT * FROM WMS_DELIVER_DOCUMENT_DETAIL D WHERE D.ORDER_ID = P_ORDER_ID;
  8. R_ITEM_DETAIL CUR_ITEM_DETAILS%ROWTYPE;
  9. begin
  10. P_ITEM_DETAIL_STR := NULL;
  11. OPEN CUR_ITEM_DETAILS;
  12. LOOP
  13. FETCH CUR_ITEM_DETAILS INTO R_ITEM_DETAIL;
  14. IF CUR_ITEM_DETAILS%NOTFOUND THEN
  15. EXIT;
  16. END IF;
  17. P_ITEM_DETAIL_STR := P_ITEM_DETAIL_STR||','||R_ITEM_DETAIL.ITEM_NAME ||':'||R_ITEM_DETAIL.QUANTITY;
  18. END LOOP;
  19. CLOSE CUR_ITEM_DETAILS;
  20. IF P_ITEM_DETAIL_STR IS NOT NULL THEN
  21. P_ITEM_DETAIL_STR := SUBSTR(P_ITEM_DETAIL_STR,2);
  22. END IF;
  23. end SP_GET_ITEMDETAIL;