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_MLS_WRAPPER dependencies on WSH_TRIP_STOPS

Line 12: -- COMMENT : Wrapper around WSH_TRIP_STOPS_GRP.Create_Update

8: -------------
9: --========================================================================
10: -- PROCEDURE : Create_Update_Stop FTE wrapper
11: --
12: -- COMMENT : Wrapper around WSH_TRIP_STOPS_GRP.Create_Update
13: -- Passes in all the parameters reqd (record type input changed to
14: -- number of parameters which are collected, assigned to a record
15: -- and call WSH_TRIP_STOPS_GRP.Create_Update
16: --========================================================================

Line 15: -- and call WSH_TRIP_STOPS_GRP.Create_Update

11: --
12: -- COMMENT : Wrapper around WSH_TRIP_STOPS_GRP.Create_Update
13: -- Passes in all the parameters reqd (record type input changed to
14: -- number of parameters which are collected, assigned to a record
15: -- and call WSH_TRIP_STOPS_GRP.Create_Update
16: --========================================================================
17:
18: PROCEDURE Create_Update_Stop
19: (

Line 114: p_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;

110:
111: ) IS
112:
113: --
114: p_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
115: p_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
116: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
117: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
118:

Line 115: p_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

111: ) IS
112:
113: --
114: p_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
115: p_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
116: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
117: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
118:
119: l_stop_seq_rec FTE_MLS_WRAPPER.stop_seq_rec;

Line 116: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

112:
113: --
114: p_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
115: p_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
116: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
117: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
118:
119: l_stop_seq_rec FTE_MLS_WRAPPER.stop_seq_rec;
120: p_commit VARCHAR2(1);

Line 117: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

113: --
114: p_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
115: p_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
116: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
117: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
118:
119: l_stop_seq_rec FTE_MLS_WRAPPER.stop_seq_rec;
120: p_commit VARCHAR2(1);
121: l_stop_seq NUMBER;

Line 263: UPDATE WSH_TRIP_STOPS

259: );
260:
261: -- update carrier est dates
262: IF (p_action_code = 'UPDATE') THEN
263: UPDATE WSH_TRIP_STOPS
264: SET CARRIER_EST_DEPARTURE_DATE = pp_CARRIER_EST_DEPARTURE_DATE,
265: CARRIER_EST_ARRIVAL_DATE = pp_CARRIER_EST_ARRIVAL_DATE
266: WHERE STOP_ID = pp_STOP_ID;
267: END IF;

Line 404: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;

400: p_defer_interface_flag IN VARCHAR2 DEFAULT 'Y')
401:
402: IS
403:
404: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
405:
406: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
407: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
408: p_commit VARCHAR2(1);

Line 406: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

402: IS
403:
404: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
405:
406: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
407: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
408: p_commit VARCHAR2(1);
409:
410: --

Line 599: wsh_trip_stops wts

595: CURSOR delivery_leg_cur
596: IS
597: SELECT delivery_leg_id, sequence_number
598: FROM wsh_delivery_legs wdl,
599: wsh_trip_stops wts
600: WHERE wts.trip_id = p_asg_trip_id
601: AND wts.stop_id = wdl.pick_up_stop_id
602: AND wdl.pick_up_stop_id = p_asg_pickup_stop_id
603: AND wdl.delivery_id = p_delivery_id;

Line 1816: WSH_TRIP_STOPS ST

1812:
1813: CURSOR c_numberOfDel(p_TripID NUMBER) IS
1814: SELECT COUNT(LEGS.DELIVERY_ID)
1815: FROM WSH_DELIVERY_LEGS LEGS,
1816: WSH_TRIP_STOPS ST
1817: WHERE
1818: ST.STOP_ID = LEGS.PICK_UP_STOP_ID
1819: AND ST.TRIP_ID = p_TripID;
1820:

Line 2020: FROM WSH_TRIP_STOPS

2016:
2017: --OUTBOUND TripStops
2018: CURSOR c_tripStops (p_tripID NUMBER) IS
2019: SELECT STOP_LOCATION_ID
2020: FROM WSH_TRIP_STOPS
2021: WHERE TRIP_ID = p_tripID
2022: ORDER BY PLANNED_ARRIVAL_DATE,
2023: STOP_SEQUENCE_NUMBER,
2024: STOP_ID;

Line 2029: FROM WSH_TRIP_STOPS

2025:
2026: --INBOUND Trip Stops
2027: CURSOR c_tripStopsIB (p_tripID NUMBER) IS
2028: SELECT STOP_LOCATION_ID
2029: FROM WSH_TRIP_STOPS
2030: WHERE TRIP_ID = p_tripID
2031: ORDER BY PLANNED_ARRIVAL_DATE DESC,
2032: STOP_SEQUENCE_NUMBER DESC,
2033: STOP_ID DESC;

Line 2039: FROM WSH_TRIP_STOPS

2035: --INBOUND Trip Stops
2036: CURSOR c_getStops (p_tripID NUMBER) IS
2037: SELECT stop_id,
2038: departure_gross_weight,departure_volume,weight_uom_code,volume_uom_code
2039: FROM WSH_TRIP_STOPS
2040: WHERE TRIP_ID = p_tripID
2041: ORDER BY PLANNED_ARRIVAL_DATE DESC,
2042: STOP_SEQUENCE_NUMBER DESC,
2043: STOP_ID DESC;

Line 3121: l_wsh_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;

3117: x_msg_data OUT NOCOPY VARCHAR2
3118: ) IS
3119:
3120:
3121: l_wsh_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
3122: l_wsh_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
3123: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;
3124: l_commit VARCHAR2(1);
3125:

Line 3122: l_wsh_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

3118: ) IS
3119:
3120:
3121: l_wsh_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
3122: l_wsh_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
3123: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;
3124: l_commit VARCHAR2(1);
3125:
3126:

Line 3475: l_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;

3471: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3472: --
3473: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'PROCESS_STOPS';
3474:
3475: l_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
3476: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
3477: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3478: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3479:

Line 3476: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

3472: --
3473: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'PROCESS_STOPS';
3474:
3475: l_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
3476: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
3477: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3478: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3479:
3480: l_index NUMBER;

Line 3477: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

3473: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'PROCESS_STOPS';
3474:
3475: l_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
3476: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
3477: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3478: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3479:
3480: l_index NUMBER;
3481:

Line 3478: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

3474:
3475: l_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
3476: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
3477: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3478: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3479:
3480: l_index NUMBER;
3481:
3482: l_action_code VARCHAR2(30);

Line 3729: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,

3725: PROCEDURE CREATE_UPDATE_STOP(
3726: p_api_version_number IN NUMBER,
3727: p_init_msg_list IN VARCHAR2,
3728: p_commit IN VARCHAR2,
3729: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
3730: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
3731: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
3732: x_return_status OUT NOCOPY VARCHAR2,
3733: x_msg_count OUT NOCOPY NUMBER,

Line 3730: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

3726: p_api_version_number IN NUMBER,
3727: p_init_msg_list IN VARCHAR2,
3728: p_commit IN VARCHAR2,
3729: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
3730: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
3731: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
3732: x_return_status OUT NOCOPY VARCHAR2,
3733: x_msg_count OUT NOCOPY NUMBER,
3734: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 3731: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,

3727: p_init_msg_list IN VARCHAR2,
3728: p_commit IN VARCHAR2,
3729: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
3730: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
3731: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
3732: x_return_status OUT NOCOPY VARCHAR2,
3733: x_msg_count OUT NOCOPY NUMBER,
3734: x_msg_data OUT NOCOPY VARCHAR2) IS
3735:

Line 3740: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

3736: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3737: --
3738: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_STOP';
3739:
3740: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3741: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3742:
3743: l_number_of_warnings NUMBER;
3744: l_number_of_errors NUMBER;

Line 3741: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

3737: --
3738: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_STOP';
3739:
3740: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3741: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3742:
3743: l_number_of_warnings NUMBER;
3744: l_number_of_errors NUMBER;
3745: l_return_status VARCHAR2(32767);

Line 4597: FROM wsh_trip_stops

4593:
4594: CURSOR stop_info (p_tripId NUMBER)
4595: IS
4596: SELECT stop_id, trip_id, planned_arrival_Date,planned_departure_date
4597: FROM wsh_trip_stops
4598: WHERE trip_id = p_tripId;
4599:
4600: BEGIN
4601: