APPS.FTE_TP_GRP dependencies on WSH_TRIPS_INTERFACE

Line 672: wsh_trips_interface wti

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
676: AND ftmi.interface_action_code = G_TP_RELEASE_CODE

Line 1000: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

996: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
997: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
998: WSH_TP_RELEASE_INT.stamp_interface_error(
999: p_group_id => x_context.group_id,
1000: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
1001: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,
1002: p_message_name => 'WSH_TP_F_MOVE_LOOKUP',
1003: p_token_1_name => 'PLAN_TRIP_NUM',
1004: p_token_1_value => x_plan_trips(l_trip_index).tp_trip_number,

Line 1064: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

1060: (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1061: -- move or one of its trip_moves cannot be locked or some other error happened.
1062: WSH_TP_RELEASE_INT.stamp_interface_error(
1063: p_group_id => x_context.group_id,
1064: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
1065: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,
1066: p_message_name => 'WSH_TP_F_NO_LOCK_OBS_MOVE',
1067: p_token_1_name => 'MOVE_ID',
1068: p_token_1_value => l_cm_info.move_id,

Line 1083: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

1079: IF NVL(l_move_rec.planned_flag, 'N') <> 'N' THEN
1080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1081: WSH_TP_RELEASE_INT.stamp_interface_error(
1082: p_group_id => x_context.group_id,
1083: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
1084: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,
1085: p_message_name => 'WSH_TP_F_FIRM_MOVE_NO_MATCH',
1086: p_token_1_name => 'PLAN_TRIP_NUM',
1087: p_token_1_value => x_plan_trips(l_trip_index).tp_trip_number,

Line 1550: -- FTE interface tables (based on WSH_TRIPS_INTERFACE.GROUP_ID)

1546: --
1547: -- Procedure: purge_interface_tables
1548: -- Parameters:
1549: -- p_group_ids list of group_ids to purge
1550: -- FTE interface tables (based on WSH_TRIPS_INTERFACE.GROUP_ID)
1551: -- x_return_status return status
1552: --
1553: -- Description:
1554: -- Part of TP release process

Line 1594: wsh_trips_interface wti

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
1598: and ftmi.interface_action_code = G_TP_RELEASE_CODE)

Line 1607: wsh_trips_interface wti

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
1611: and ftmi2.interface_action_code = G_TP_RELEASE_CODE)