CREATE OR REPLACE PACKAGE shipping_api
AS
PROCEDURE xx_create_trip (
      x_return_status   OUT   VARCHAR2,
      x_msg_count       OUT   NUMBER,
      x_msg_data        OUT   VARCHAR2,
      x_trip_id         OUT   NUMBER,
      x_trip_name       OUT   VARCHAR2
      );
END shipping_api;

CREATE OR REPLACE PACKAGE BODY shipping_api
AS
   PROCEDURE xx_create_trip (
      x_return_status   OUT   VARCHAR2,
      x_msg_count       OUT   NUMBER,
      x_msg_data        OUT   VARCHAR2,
      x_trip_id         OUT   NUMBER,
      x_trip_name       OUT   VARCHAR2
     )
     
   IS
    p_trip_info         wsh_trips_pub.trip_pub_rec_type ;
      
   BEGIN
      p_trip_info.trip_id := 123;
      p_trip_info.NAME := 'ABC';
      wsh_trips_pub.create_update_trip ('1.0',
                                        fnd_api.g_false,
                                        x_return_status,
                                        x_msg_count,
                                        x_msg_data,
                                        'CREATE',
                                        p_trip_info,
                                        'ABC',
                                        x_trip_id,
                                        x_trip_name
                                       );
--Harmonizing Project **heali
      DBMS_OUTPUT.put_line ('Return_Status' || ' ' || x_return_status);
      DBMS_OUTPUT.put_line ('Msg_Count' || ' ' || x_msg_count);
      DBMS_OUTPUT.put_line ('Msg_Data' || ' ' || x_msg_data);
      DBMS_OUTPUT.put_line ('trip_id' || ' ' || x_trip_id);
      DBMS_OUTPUT.put_line ('trip_name' || ' ' || x_trip_name);
   END xx_create_trip;
END shipping_api;