22: x_return_status OUT NOCOPY VARCHAR2
23: ) IS
24:
25: CURSOR get_next_move IS
26: SELECT fte_moves_s.nextval
27: FROM sys.dual;
28:
29: l_temp_id NUMBER;
30: EMPTY_MOVE_TYPE_CODE EXCEPTION;
135:
136: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
137:
138:
139: UPDATE FTE_MOVES SET
140: MOVE_TYPE_CODE =decode(p_move_info.MOVE_TYPE_CODE,
141: NULL,MOVE_TYPE_CODE,
142: FND_API.G_MISS_CHAR,MOVE_TYPE_CODE,
143: p_move_info.MOVE_TYPE_CODE),