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_TRIP_MOVES

Line 17: FTE_TRIP_MOVES ftm

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';
21:

Line 203: FROM FTE_TRIP_MOVES ftm

199: FOR UPDATE NOWAIT;
200:
201: CURSOR c_lock_trip_moves(x_move_id NUMBER) IS
202: SELECT ftm.trip_move_id
203: FROM FTE_TRIP_MOVES ftm
204: WHERE ftm.move_id = x_move_id
205: FOR UPDATE NOWAIT;
206:
207: BEGIN

Line 671: fte_trip_moves_interface ftmi,

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
675: AND ftmi.trip_interface_id = wti.trip_interface_id

Line 689: FROM fte_trip_moves_interface ftmi

685: ftmi.move_id,
686: ftmi.trip_interface_id,
687: ftmi.trip_id,
688: ftmi.sequence_number
689: FROM fte_trip_moves_interface ftmi
690: WHERE ftmi.move_interface_id = x_move_interface_id
691: AND ftmi.interface_action_code = G_TP_RELEASE_CODE
692: ORDER BY ftmi.sequence_number;
693:

Line 699: FROM fte_trip_moves ftm

695: SELECT ftm.move_id,
696: ftm.trip_move_id,
697: ftm.trip_id,
698: ftm.sequence_number
699: FROM fte_trip_moves ftm
700: WHERE ftm.move_id = x_move_id
701: ORDER BY ftm.sequence_number;
702:
703:

Line 707: FROM fte_trip_moves

703:
704: -- Looks for trips in obsoleted moves.
705: CURSOR c_obsoleted_move_trips(x_move_id IN NUMBER) IS
706: SELECT trip_id
707: FROM fte_trip_moves
708: WHERE move_id = x_move_id;
709:
710:
711:

Line 847: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',

843:
844: IF l_trip_index IS NULL THEN
845: WSH_TP_RELEASE_INT.stamp_interface_error(
846: p_group_id => x_context.group_id,
847: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',
848: p_entity_interface_id => itripmove.trip_move_interface_id,
849: p_message_name => 'WSH_TP_F_TRIP_NOT_MAPPED',
850: p_token_1_name => 'PLAN_CM_NUM',
851: p_token_1_value => x_plan_moves(l_new_index).cm_trip_number,

Line 1198: l_trip_move_rec FTE_TRIP_MOVES_PVT.trip_moves_rec_type;

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
1202: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 1259: fte_trip_moves_pvt.delete_trip_moves(

1255:
1256: ELSIF x_obsoleted_trip_moves(l_tm_index).move_id IS NOT NULL THEN
1257:
1258: -- delete the trip_move segment
1259: fte_trip_moves_pvt.delete_trip_moves(
1260: p_trip_move_id => x_obsoleted_trip_moves(l_tm_index).trip_move_id,
1261: x_return_status => l_return_status);
1262: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1263: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1354: fte_trip_moves_pvt.create_trip_moves(

1350: l_trip_move_rec.sequence_number := x_plan_trip_moves(l_tm_index).sequence_number;
1351: l_trip_move_rec.trip_move_id := x_plan_trip_moves(l_tm_index).trip_move_id;
1352:
1353: IF x_plan_trip_moves(l_tm_index).trip_move_id IS NULL THEN
1354: fte_trip_moves_pvt.create_trip_moves(
1355: p_trip_moves_info => l_trip_move_rec,
1356: x_trip_move_id => l_id,
1357: x_return_status => l_return_status);
1358: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 1362: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',

1358: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1359: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1360: WSH_TP_RELEASE_INT.stamp_interface_error(
1361: p_group_id => x_context.group_id,
1362: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',
1363: p_entity_interface_id => x_plan_trip_moves(l_tm_index).trip_move_interface_id,
1364: p_message_name => 'WSH_TP_F_CREATE_TRIP_MOVE',
1365: x_errors_tab => x_errors_tab,
1366: x_return_status => l_return_status);

Line 1374: fte_trip_moves_pvt.update_trip_moves(

1370: RETURN;
1371: END IF;
1372: x_plan_trip_moves(l_tm_index).trip_move_id := l_id;
1373: ELSE
1374: fte_trip_moves_pvt.update_trip_moves(
1375: p_trip_moves_info => l_trip_move_rec,
1376: x_return_status => l_return_status);
1377: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1381: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',

1377: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1379: WSH_TP_RELEASE_INT.stamp_interface_error(
1380: p_group_id => x_context.group_id,
1381: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',
1382: p_entity_interface_id => x_plan_trip_moves(l_tm_index).trip_move_interface_id,
1383: p_message_name => 'WSH_TP_F_UPDATE_TRIP_MOVE',
1384: x_errors_tab => x_errors_tab,
1385: x_return_status => l_return_status);

Line 1557: -- FTE_TRIP_MOVES_INTERFACE

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,
1561: x_return_status OUT NOCOPY VARCHAR2)

Line 1593: from fte_trip_moves_interface ftmi,

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
1595: where wti.group_id = p_group_ids(i)
1596: and wti.interface_action_code = G_TP_RELEASE_CODE
1597: and ftmi.trip_interface_id = wti.trip_interface_id

Line 1603: delete from fte_trip_moves_interface ftmi

1599: and fmi.interface_action_code = G_TP_RELEASE_CODE;
1600:
1601:
1602: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
1603: delete from fte_trip_moves_interface ftmi
1604: where ftmi.trip_move_interface_id in (
1605: select ftmi2.trip_move_interface_id
1606: from fte_trip_moves_interface ftmi2,
1607: wsh_trips_interface wti

Line 1606: from fte_trip_moves_interface ftmi2,

1602: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
1603: delete from fte_trip_moves_interface ftmi
1604: where ftmi.trip_move_interface_id in (
1605: select ftmi2.trip_move_interface_id
1606: from fte_trip_moves_interface ftmi2,
1607: wsh_trips_interface wti
1608: where wti.group_id = p_group_ids(i)
1609: and wti.interface_action_code = G_TP_RELEASE_CODE
1610: and ftmi2.trip_interface_id = wti.trip_interface_id