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
使用API进行销售订单的Pick Release和Pick Confirm
最新推荐文章于 2024-08-22 09:21:50 发布
该博客演示了如何在Oracle电子商务套件(EBS)中通过API自动化执行销售订单的Pick Release和Pick Confirm操作。首先,通过查询特定条件的订单详情,然后初始化必要的环境参数,接着调用WSH_DELIVERY_DETAILS_PUB API 创建交付,再调用WSH_DELIVERIES_PUB API 进行Pick Release。最后,如果所有步骤成功,则确认Pick Confirm流程完成。
摘要由CSDN通过智能技术生成