APPS.FTE_TP_GRP dependencies on FTE_TRIP_MOVES_INTERFACE

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