销售订单 出库 发运确认

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