APPS.FTE_WSH_INTERFACE_PKG dependencies on WSH_TRIP_STOPS

Line 68: p_current_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

64: --
65: PROCEDURE get_segment_stops
66: (
67: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
68: p_current_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
69: p_action_type IN VARCHAR2,
70: x_trip_stop_tab OUT NOCOPY trip_stop_tab_type,
71: x_current_stop_index OUT NOCOPY NUMBER,
72: x_curr_stop_old_position OUT NOCOPY VARCHAR2,

Line 103: FROM wsh_trip_stops

99: STOP_SEQUENCE_NUMBER,
100: PLANNED_ARRIVAL_DATE,
101: PLANNED_DEPARTURE_DATE,
102: G_NO_CHANGE ACTION_TYPE
103: FROM wsh_trip_stops
104: WHERE trip_id = p_segment_id
105: UNION ALL
106: SELECT
107: l_current_stop_id stop_id,

Line 1148: p_old_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

1144: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
1145: P_trip_stop_tab IN Trip_Stop_Tab_type,
1146: p_current_stop_index IN NUMBER,
1147: p_curr_stop_old_position IN VARCHAR2,
1148: p_old_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
1149: p_schedule_start_datetime IN DATE,
1150: p_schedule_end_datetime IN DATE,
1151: x_return_status OUT NOCOPY VARCHAR2
1152: )

Line 1177: wsh_trip_stops st

1173: SELECT
1174: dg.delivery_id, dl.name
1175: FROM wsh_new_deliveries dl,
1176: wsh_delivery_legs dg,
1177: wsh_trip_stops st
1178: WHERE dg.delivery_id = dl.delivery_id
1179: AND st.stop_location_id = dl.initial_pickup_location_id
1180: AND st.stop_id = dg.pick_up_stop_id
1181: AND st.stop_id = p_stop_id;

Line 1852: P_old_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

1848: X_return_status OUT NOCOPY VARCHAR2,
1849: X_msg_count OUT NOCOPY NUMBER,
1850: X_msg_data OUT NOCOPY VARCHAR2,
1851: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
1852: P_old_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
1853: P_new_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
1854: p_segmentStopChangeInRec IN segmentStopChangeInRecType,
1855: p_segmentStopChangeOutRec OUT NOCOPY segmentStopChangeOutRecType
1856: )

Line 1853: P_new_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

1849: X_msg_count OUT NOCOPY NUMBER,
1850: X_msg_data OUT NOCOPY VARCHAR2,
1851: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
1852: P_old_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
1853: P_new_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
1854: p_segmentStopChangeInRec IN segmentStopChangeInRecType,
1855: p_segmentStopChangeOutRec OUT NOCOPY segmentStopChangeOutRecType
1856: )
1857: IS

Line 1864: l_current_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

1860: l_api_version CONSTANT NUMBER := 1.0;
1861: --
1862: --
1863: l_trip_stop_tab Trip_Stop_tab_Type;
1864: l_current_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
1865: l_stop_full_valid_ctrl_rec stop_validation_ctrl_rec_type;
1866: --
1867: --
1868: l_current_stop_index NUMBER;

Line 2960: FROM WSH_TRIP_STOPS

2956: ELSIF (p_entity_type = 'STOP')
2957: THEN
2958: BEGIN
2959: SELECT TRIP_ID INTO l_trip_id
2960: FROM WSH_TRIP_STOPS
2961: WHERE STOP_ID = p_entity_id;
2962:
2963: IF (SQL%NOTFOUND) THEN
2964: RAISE NO_DATA_FOUND;