DBA Data[Home] [Help]

APPS.FTE_TP_GRP dependencies on FTE_MOVES_PVT

Line 119: x_move_rec OUT NOCOPY FTE_MOVES_PVT.move_rec_type,

115:
116: PROCEDURE lookup_move (
117: p_move_id IN NUMBER,
118: p_lock_flag IN VARCHAR2,
119: x_move_rec OUT NOCOPY FTE_MOVES_PVT.move_rec_type,
120: x_locked OUT NOCOPY VARCHAR2,
121: x_return_status OUT NOCOPY VARCHAR2)
122: IS
123: --

Line 416: l_move_rec FTE_MOVES_PVT.move_rec_type;

412: --
413: i NUMBER;
414: l_return_status VARCHAR2(1);
415: l_int_cm_info_rec c_cm_info%ROWTYPE;
416: l_move_rec FTE_MOVES_PVT.move_rec_type;
417: l_locked VARCHAR2(1);
418: move_error EXCEPTION;
419: BEGIN
420: SAVEPOINT before_trip_callback;

Line 484: fte_moves_pvt.update_move(

480: l_move_rec.planned_flag := 'N';
481: l_move_rec.last_updated_by := FND_GLOBAL.user_id;
482: l_move_rec.last_update_date := SYSDATE;
483:
484: fte_moves_pvt.update_move(
485: p_move_info => l_move_rec,
486: x_return_status => l_return_status);
487:
488: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 507: fte_moves_pvt.delete_move(

503: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
504: RAISE move_error;
505: END IF;
506:
507: fte_moves_pvt.delete_move(
508: p_move_id => l_int_cm_info_rec.move_id,
509: p_validate_flag => 'Y',
510: x_return_status => l_return_status);
511: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 712: l_move_rec FTE_MOVES_PVT.move_rec_type;

708: WHERE move_id = x_move_id;
709:
710:
711:
712: l_move_rec FTE_MOVES_PVT.move_rec_type;
713: l_cm_info c_cm_info%ROWTYPE;
714: l_locked VARCHAR2(1);
715: l_return_status VARCHAR2(1);
716:

Line 1197: l_move_rec FTE_MOVES_PVT.move_rec_type;

1193: l_m_index NUMBER;
1194: l_tm_index NUMBER;
1195: l_id NUMBER;
1196: l_return_status VARCHAR2(1);
1197: l_move_rec FTE_MOVES_PVT.move_rec_type;
1198: l_trip_move_rec FTE_TRIP_MOVES_PVT.trip_moves_rec_type;
1199:
1200:
1201: BEGIN

Line 1233: fte_moves_pvt.delete_move(

1229: IF x_obsoleted_trip_moves(l_tm_index).trip_move_id IS NULL
1230: AND x_obsoleted_trip_moves(l_tm_index).move_id IS NOT NULL THEN
1231:
1232: -- delete the move
1233: fte_moves_pvt.delete_move(
1234: p_move_id => x_obsoleted_trip_moves(l_tm_index).move_id,
1235: p_validate_flag => 'Y',
1236: x_return_status => l_return_status);
1237: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 1304: fte_moves_pvt.create_move(

1300: l_move_rec.cm_trip_number := x_plan_moves(l_m_index).cm_trip_number;
1301: l_move_rec.tp_plan_name := x_plan_moves(l_m_index).tp_plan_name;
1302:
1303: IF x_plan_moves(l_m_index).move_id IS NULL THEN
1304: fte_moves_pvt.create_move(
1305: p_move_info => l_move_rec,
1306: x_move_id => l_id,
1307: x_return_status => l_return_status);
1308: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1324: fte_moves_pvt.update_move(

1320: RETURN;
1321: END IF;
1322: x_plan_moves(l_m_index).move_id := l_id;
1323: ELSE
1324: fte_moves_pvt.update_move(
1325: p_move_info => l_move_rec,
1326: x_return_status => l_return_status);
1327: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1459: l_move_rec FTE_MOVES_PVT.move_rec_type;

1455: l_debug_on BOOLEAN;
1456: --
1457: l_m_index NUMBER;
1458: l_return_status VARCHAR2(1);
1459: l_move_rec FTE_MOVES_PVT.move_rec_type;
1460:
1461: BEGIN
1462: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1463: --

Line 1496: fte_moves_pvt.update_move(

1492: l_move_rec.planned_flag := x_plan_moves(l_m_index).planned_flag;
1493: l_move_rec.cm_trip_number := x_plan_moves(l_m_index).cm_trip_number;
1494: l_move_rec.tp_plan_name := x_plan_moves(l_m_index).tp_plan_name;
1495:
1496: fte_moves_pvt.update_move(
1497: p_move_info => l_move_rec,
1498: x_return_status => l_return_status);
1499: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;