使用API进行销售订单的Pick Release和Pick Confirm

最新推荐文章于 2021-04-11 22:09:55 发布

李逍遥L11

最新推荐文章于 2021-04-11 22:09:55 发布

阅读量2.8k

点赞数

分类专栏： OM 文章标签： oracle ebs api 测试demo

本文链接：https://blog.csdn.net/chosen1brain/article/details/46547883

版权

该博客演示了如何在Oracle电子商务套件（EBS）中通过API自动化执行销售订单的Pick Release和Pick Confirm操作。首先，通过查询特定条件的订单详情，然后初始化必要的环境参数，接着调用WSH_DELIVERY_DETAILS_PUB API 创建交付，再调用WSH_DELIVERIES_PUB API 进行Pick Release。最后，如果所有步骤成功，则确认Pick Confirm流程完成。

摘要由CSDN通过智能技术生成

DECLARE

  x_return_status      VARCHAR2(2);
  x_msg_count          NUMBER;
  x_msg_data           VARCHAR2(2000);
  p_api_version_number NUMBER := 1.0;
  init_msg_list        VARCHAR2(200);
  x_msg_details        VARCHAR2(3000);
  x_msg_summary        VARCHAR2(3000);
  p_line_rows          wsh_util_core.id_tab_type;
  x_del_rows           wsh_util_core.id_tab_type;
  l_ship_method_code   VARCHAR2(100);
  i                    NUMBER;
  l_commit             VARCHAR2(30);
  p_delivery_id        NUMBER;
  p_delivery_name      VARCHAR2(30);
  x_trip_id            VARCHAR2(30);
  x_trip_name          VARCHAR2(30);
  exep_api EXCEPTION;
  l_picked_flag   VARCHAR2(10);
  l_return_status VARCHAR2(1000);
  l_msg_count     NUMBER;
  l_msg_data      VARCHAR2(1000);
  l_user_id       NUMBER;
  l_resp_id       NUMBER;
  l_appl_id       NUMBER;

  CURSOR c_ord_details IS
  
    SELECT oha.order_number sales_order
          ,oha.org_id
          ,ola.line_number
          ,ola.shipment_number
          ,ola.flow_status_code
          ,wdd.delivery_detail_id
          ,wdd.inv_interfaced_flag
          ,wdd.oe_interfaced_flag
          ,wdd.released_status
      FROM apps.oe_order_headers_all oha
          ,apps.oe_order_lines_all   ola
          ,apps.wsh_delivery_details wdd
     WHERE oha.header_id = ola.header_id
       AND oha.org_id = ola.org_id
       AND oha.header_id = wdd.source_header_id
       AND ola.line_id = wdd.source_line_id
       AND oha.booked_flag = 'Y'
       AND nvl(ola.cancelled_flag, 'N') <> 'Y'
       AND wdd.released_status IN ('R', 'B')
       AND ola.flow_status_code = 'AWAITING_SHIPPING'
       AND oha.order_number = 1506764261
       AND oha.org_id = 121;
  --
  v_user_id      NUMBER;
  v_resp_id      NUMBER;
  v_resp_appl_id NUMBER;
  --    

BEGIN

  --
  /* To get the user id details */
  SELECT user_id INTO v_user_id FROM fnd_user WHERE user_name = 'SETUP0