DECLARE
--PARAMETER FOR "WSH_DELIVERIES_PUB.Delivery_Action"
p_api_version_number NUMBER := 1.0;
p_init_msg_list VARCHAR2(30);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
p_action_code VARCHAR2(15) := 'CONFIRM';
p_delivery_id NUMBER := 93024;
p_delivery_name VARCHAR2(30) := '93024';
p_asg_trip_id NUMBER;
p_asg_trip_name VARCHAR2(30);
p_asg_pickup_stop_id NUMBER;
p_asg_pickup_loc_id NUMBER;
p_asg_pickup_stop_seq NUMBER;
p_asg_pickup_loc_code VARCHAR2(30);
p_asg_pickup_arr_date DATE;
p_asg_pickup_dep_date DATE;
p_asg_dropoff_stop_id NUMBER;
p_asg_dropoff_loc_id NUMBER;
p_asg_dropoff_stop_seq NUMBER;
p_asg_dropoff_loc_code VARCHAR2(30);
p_asg_dropoff_arr_date DATE;
p_asg_dropoff_dep_date DATE;
p_sc_action_flag VARCHAR2(10) := 'S';
p_sc_intransit_flag VARCHAR2(10) := 'Y';
p_sc_close_trip_flag VARCHAR2(10) := 'Y';
p_sc_create_bol_flag VARCHAR2(10) := 'N';
p_sc_stage_del_flag VARCHAR2(10) := 'Y';
p_sc_trip
销售订单 出库 发运确认
最新推荐文章于 2023-12-27 16:56:52 发布
这段PL/SQL代码演示了如何使用Oracle Web Services Handler (WSH) 库来确认销售订单的出库。通过调用`WSH_DELIVERIES_PUB.Delivery_Action`和`WSH_SHIP_CONFIRM_ACTIONS.Interface_ALL`接口,进行出库确认、状态更新及相关操作。
摘要由CSDN通过智能技术生成