DBA Data[Home] [Help]

APPS.FTE_MOVES_PVT dependencies on FTE_TRIP_MOVES

Line 236: -- delete corresponding entries from FTE_TRIP_MOVES

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:

Line 237: DELETE FROM FTE_TRIP_MOVES

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

Line 260: FROM fte_trip_moves

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);