eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_TP_GRP dependencies on FTE_MOVES

Line 16: FROM FTE_MOVES fm,

12: SELECT fm.move_id,
13: fm.cm_trip_number,
14: fm.planned_flag,
15: ftm.sequence_number
16: FROM FTE_MOVES fm,
17: FTE_TRIP_MOVES ftm
18: WHERE ftm.trip_id = x_trip_id
19: AND fm.move_id = ftm.move_id
20: AND fm.move_type_code = 'CONTINUOUS';

Line 107: -- x_move_rec record from FTE_MOVES

103: -- Procedure: lookup_move
104: -- Parameters:
105: -- p_move_id move identifier
106: -- p_lock_flag 'Y' - lock move and its trip_moves; 'N' - do not lock
107: -- x_move_rec record from FTE_MOVES
108: -- x_locked 'Y' - locked by other session; 'N' - no exception raised
109: -- x_return_status return status
110: --
111: -- Description:

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 161: FROM FTE_MOVES fm

157: fm.attribute12,
158: fm.attribute13,
159: fm.attribute14,
160: fm.attribute15
161: FROM FTE_MOVES fm
162: WHERE fm.move_id = x_move_id;
163:
164: CURSOR c_lock_move(x_move_id NUMBER) IS
165: SELECT fm.move_id,

Line 197: FROM FTE_MOVES fm

193: fm.attribute12,
194: fm.attribute13,
195: fm.attribute14,
196: fm.attribute15
197: FROM FTE_MOVES fm
198: WHERE fm.move_id = x_move_id
199: FOR UPDATE NOWAIT;
200:
201: CURSOR c_lock_trip_moves(x_move_id NUMBER) IS

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 670: FROM fte_moves_interface fmi,

666: fmi.service_level,
667: fmi.planned_flag,
668: fmi.tp_plan_name,
669: fmi.cm_trip_number
670: FROM fte_moves_interface fmi,
671: fte_trip_moves_interface ftmi,
672: wsh_trips_interface wti
673: WHERE wti.group_id = x_group_id
674: AND wti.interface_action_code = G_TP_RELEASE_CODE

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 790: p_entity_table_name => 'FTE_MOVES_INTERFACE',

786: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
787: -- move or one of its trip_moves cannot be locked or some other error happened.
788: WSH_TP_RELEASE_INT.stamp_interface_error(
789: p_group_id => x_context.group_id,
790: p_entity_table_name => 'FTE_MOVES_INTERFACE',
791: p_entity_interface_id => imove.move_interface_id,
792: p_message_name => 'WSH_TP_F_NO_LOCK_MOVE',
793: p_token_1_name => 'MOVE_ID',
794: p_token_1_value => x_plan_moves(l_new_index).move_id,

Line 946: p_entity_table_name => 'FTE_MOVES_INTERFACE',

942: IF x_plan_moves(l_new_index).fte_planned_flag <> 'N' THEN
943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
944: WSH_TP_RELEASE_INT.stamp_interface_error(
945: p_group_id => x_context.group_id,
946: p_entity_table_name => 'FTE_MOVES_INTERFACE',
947: p_entity_interface_id => x_plan_moves(l_new_index).move_interface_id,
948: p_message_name => 'WSH_TP_F_FIRM_MOVE_DIFF',
949: p_token_1_name => 'PLAN_TRIP_NUM',
950: p_token_1_value => x_plan_trips(1).tp_trip_number,

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 1312: p_entity_table_name => 'FTE_MOVES_INTERFACE',

1308: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1310: WSH_TP_RELEASE_INT.stamp_interface_error(
1311: p_group_id => x_context.group_id,
1312: p_entity_table_name => 'FTE_MOVES_INTERFACE',
1313: p_entity_interface_id => x_plan_moves(l_m_index).move_interface_id,
1314: p_message_name => 'WSH_TP_F_CREATE_MOVE',
1315: x_errors_tab => x_errors_tab,
1316: x_return_status => l_return_status);

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 1331: p_entity_table_name => 'FTE_MOVES_INTERFACE',

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;
1329: WSH_TP_RELEASE_INT.stamp_interface_error(
1330: p_group_id => x_context.group_id,
1331: p_entity_table_name => 'FTE_MOVES_INTERFACE',
1332: p_entity_interface_id => x_plan_moves(l_m_index).move_interface_id,
1333: p_message_name => 'WSH_TP_F_UPDATE_MOVE',
1334: p_token_1_name => 'MOVE_ID',
1335: p_token_1_value => x_plan_moves(l_m_index).move_id,

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;

Line 1503: p_entity_table_name => 'FTE_MOVES_INTERFACE',

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;
1501: WSH_TP_RELEASE_INT.stamp_interface_error(
1502: p_group_id => x_context.group_id,
1503: p_entity_table_name => 'FTE_MOVES_INTERFACE',
1504: p_entity_interface_id => x_plan_moves(l_m_index).move_interface_id,
1505: p_message_name => 'WSH_TP_F_FIRM_MOVE',
1506: p_token_1_name => 'MOVE_ID',
1507: p_token_1_value => x_plan_moves(l_m_index).move_id,

Line 1556: -- FTE_MOVES_INTERFACE

1552: --
1553: -- Description:
1554: -- Part of TP release process
1555: -- Delete the records from FTE interface tables:
1556: -- FTE_MOVES_INTERFACE
1557: -- FTE_TRIP_MOVES_INTERFACE
1558: --
1559: PROCEDURE purge_interface_tables(
1560: p_group_ids IN WSH_TP_RELEASE_GRP.ID_TAB_TYPE,

Line 1590: delete from fte_moves_interface fmi

1586: -- The tables must be deleted in the right order so that their
1587: -- records can be identified correctly.
1588:
1589: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
1590: delete from fte_moves_interface fmi
1591: where fmi.move_interface_id in (
1592: select distinct ftmi.move_interface_id
1593: from fte_trip_moves_interface ftmi,
1594: wsh_trips_interface wti