3629: -- get delivery_leg_interface_id, stop_interface_id, trip_interface_id
3630:
3631: SELECT
3632: WSH_DEL_LEGS_INTERFACE_S.nextval,
3633: WSH_TRIP_STOPS_INTERFACE_S.nextval,
3634: WSH_TRIPS_INTERFACE_S.nextval
3635: INTO l_del_leg_interface_id,
3636: l_pickup_stop_interface_id,
3637: l_trip_interface_id
3637: l_trip_interface_id
3638: FROM dual;
3639:
3640: SELECT
3641: WSH_TRIP_STOPS_INTERFACE_S.nextval
3642: INTO l_dropoff_stop_interface_id
3643: FROM dual;
3644:
3645: -- insert record into wsh_del_legs_interface