813: end if;
814: l_segment_sequencenum_prev:=l_trip_segments.sequence_number;
815:
816:
817: fte_mls_util.get_first_stop_location_id(
818: P_trip_segment_id =>l_trip_segments.wsh_trip_id,
819: x_trip_segment_name =>l_trip_segment_name,
820: x_first_stop_location_id =>l_segment_origin,
821: x_return_status =>x_return_status
905: );
906: return;
907: end if;
908:
909: fte_mls_util.get_last_stop_location_id(
910: P_trip_segment_id =>l_trip_segments.wsh_trip_id,
911: x_trip_segment_name =>l_trip_segment_name,
912: x_last_stop_location_id =>l_segment_dest,
913: x_return_status =>x_return_status
1493: --
1494: --
1495: l_pickup_location := NULL;
1496:
1497: FTE_MLS_UTIL.get_location_info(l_pickup_location_id,
1498: l_pickup_location,x_return_status);
1499:
1500: IF (l_loop_count = 1)
1501: THEN