172: --{
173: CURSOR check_other_segments_cur
174: IS
175: SELECT 1
176: FROM fte_wsh_trips a, wsh_trips b
177: WHERE a.fte_trip_id = p_trip_id
178: AND a.wsh_trip_id <> p_trip_segment_id
179: AND a.wsh_trip_id = b.trip_id
180: AND b.status_code IN ('OP','IT');
221: --
222: CURSOR get_next_segment_cur
223: IS
224: SELECT wsh_trip_id
225: FROM fte_wsh_trips
226: WHERE fte_trip_id = p_trip_id
227: AND sequence_number = ( select min(sequence_number)
228: from fte_wsh_trips
229: where fte_trip_id = p_trip_id
224: SELECT wsh_trip_id
225: FROM fte_wsh_trips
226: WHERE fte_trip_id = p_trip_id
227: AND sequence_number = ( select min(sequence_number)
228: from fte_wsh_trips
229: where fte_trip_id = p_trip_id
230: and sequence_number > p_sequence_number );
231: --}
232: BEGIN
334: --
335: CURSOR get_previous_segment_cur
336: IS
337: SELECT wsh_trip_id
338: FROM fte_wsh_trips
339: WHERE fte_trip_id = p_trip_id
340: AND sequence_number = ( select max(sequence_number)
341: from fte_wsh_trips
342: where fte_trip_id = p_trip_id
337: SELECT wsh_trip_id
338: FROM fte_wsh_trips
339: WHERE fte_trip_id = p_trip_id
340: AND sequence_number = ( select max(sequence_number)
341: from fte_wsh_trips
342: where fte_trip_id = p_trip_id
343: and sequence_number < p_sequence_number );
344: --}
345: BEGIN