APPS.FTE_TP_GRP dependencies on FTE_MOVES_INTERFACE

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