PROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2)IS–Standard Parameters.p_api_version NUMBER := 1.0;p_init_msg_list VARCHAR2(30);–Parameters for WSH_DELIVERIES_PUB.Delivery_Action. p_action_code VARCHAR2(15);p_delivery_id NUMBER:= p_delivery_id_s;p_delivery_name VARCHAR2(30);p_asg_trip_id NUMBER:=p_trip_id;p_asg_trip_name VARCHAR2(30);p_asg_pickup_stop_id NUMBER;p_asg_pickup_loc_id 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_loc_code…
Read More