232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
233: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
234: END IF;
235:
236: -- delete corresponding entries from FTE_TRIP_MOVES
237: DELETE FROM FTE_TRIP_MOVES
238: WHERE MOVE_ID = p_move_id;
239:
240:
233: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
234: END IF;
235:
236: -- delete corresponding entries from FTE_TRIP_MOVES
237: DELETE FROM FTE_TRIP_MOVES
238: WHERE MOVE_ID = p_move_id;
239:
240:
241: EXCEPTION
256:
257:
258: cursor get_trips_from_move_cur( c_move_id NUMBER) is
259: SELECT trip_id
260: FROM fte_trip_moves
261: WHERE move_id = c_move_id;
262:
263:
264: l_return_status VARCHAR2(32767);