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.WSH_INTERFACE_GRP dependencies on WSH_TRIPS

Line 152: wsh_trips wt

148: SELECT wt.ship_method_code
149: FROM wsh_new_deliveries del,
150: wsh_delivery_legs dlg,
151: wsh_trip_stops st,
152: wsh_trips wt
153: WHERE del.delivery_id = dlg.delivery_id
154: AND dlg.pick_up_stop_id = st.stop_id
155: AND del.initial_pickup_location_id = st.stop_location_id
156: AND st.trip_id = wt.trip_id

Line 1590: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,

1586: ( p_api_version_number IN NUMBER,
1587: p_init_msg_list IN VARCHAR2,
1588: p_commit IN VARCHAR2,
1589: p_entity_id_tab IN wsh_util_core.id_tab_type,
1590: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
1591: x_trip_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripActionOutRecType,
1592: x_return_status OUT NOCOPY VARCHAR2,
1593: x_msg_count OUT NOCOPY NUMBER,
1594: x_msg_data OUT NOCOPY VARCHAR2)

Line 1591: x_trip_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripActionOutRecType,

1587: p_init_msg_list IN VARCHAR2,
1588: p_commit IN VARCHAR2,
1589: p_entity_id_tab IN wsh_util_core.id_tab_type,
1590: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
1591: x_trip_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripActionOutRecType,
1592: x_return_status OUT NOCOPY VARCHAR2,
1593: x_msg_count OUT NOCOPY NUMBER,
1594: x_msg_data OUT NOCOPY VARCHAR2)
1595: IS

Line 1597: l_rec_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1593: x_msg_count OUT NOCOPY NUMBER,
1594: x_msg_data OUT NOCOPY VARCHAR2)
1595: IS
1596:
1597: l_rec_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1598: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
1599: l_num_warning NUMBER := 0;
1600: l_num_errors NUMBER := 0;
1601: l_next NUMBER;

Line 1598: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

1594: x_msg_data OUT NOCOPY VARCHAR2)
1595: IS
1596:
1597: l_rec_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1598: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
1599: l_num_warning NUMBER := 0;
1600: l_num_errors NUMBER := 0;
1601: l_next NUMBER;
1602: l_index NUMBER;

Line 1604: l_status_code wsh_trips.status_code%TYPE;

1600: l_num_errors NUMBER := 0;
1601: l_next NUMBER;
1602: l_index NUMBER;
1603: l_trip_id NUMBER;
1604: l_status_code wsh_trips.status_code%TYPE;
1605: l_planned_flag wsh_trips.planned_flag%TYPE;
1606: l_lane_id wsh_trips.lane_id%TYPE;
1607: l_load_tender_status wsh_trips.load_tender_status%TYPE;
1608: l_shipments_type_flag VARCHAR2(30);

Line 1605: l_planned_flag wsh_trips.planned_flag%TYPE;

1601: l_next NUMBER;
1602: l_index NUMBER;
1603: l_trip_id NUMBER;
1604: l_status_code wsh_trips.status_code%TYPE;
1605: l_planned_flag wsh_trips.planned_flag%TYPE;
1606: l_lane_id wsh_trips.lane_id%TYPE;
1607: l_load_tender_status wsh_trips.load_tender_status%TYPE;
1608: l_shipments_type_flag VARCHAR2(30);
1609: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

Line 1606: l_lane_id wsh_trips.lane_id%TYPE;

1602: l_index NUMBER;
1603: l_trip_id NUMBER;
1604: l_status_code wsh_trips.status_code%TYPE;
1605: l_planned_flag wsh_trips.planned_flag%TYPE;
1606: l_lane_id wsh_trips.lane_id%TYPE;
1607: l_load_tender_status wsh_trips.load_tender_status%TYPE;
1608: l_shipments_type_flag VARCHAR2(30);
1609: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
1610: l_return_status VARCHAR2(1000);

Line 1607: l_load_tender_status wsh_trips.load_tender_status%TYPE;

1603: l_trip_id NUMBER;
1604: l_status_code wsh_trips.status_code%TYPE;
1605: l_planned_flag wsh_trips.planned_flag%TYPE;
1606: l_lane_id wsh_trips.lane_id%TYPE;
1607: l_load_tender_status wsh_trips.load_tender_status%TYPE;
1608: l_shipments_type_flag VARCHAR2(30);
1609: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
1610: l_return_status VARCHAR2(1000);
1611: l_ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE; --OTM R12, glog proj

Line 1609: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

1605: l_planned_flag wsh_trips.planned_flag%TYPE;
1606: l_lane_id wsh_trips.lane_id%TYPE;
1607: l_load_tender_status wsh_trips.load_tender_status%TYPE;
1608: l_shipments_type_flag VARCHAR2(30);
1609: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
1610: l_return_status VARCHAR2(1000);
1611: l_ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE; --OTM R12, glog proj
1612:
1613: l_debug_on BOOLEAN;

Line 1611: l_ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE; --OTM R12, glog proj

1607: l_load_tender_status wsh_trips.load_tender_status%TYPE;
1608: l_shipments_type_flag VARCHAR2(30);
1609: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
1610: l_return_status VARCHAR2(1000);
1611: l_ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE; --OTM R12, glog proj
1612:
1613: l_debug_on BOOLEAN;
1614: l_def_rec WSH_TRIPS_GRP.default_parameters_rectype;
1615: --

Line 1614: l_def_rec WSH_TRIPS_GRP.default_parameters_rectype;

1610: l_return_status VARCHAR2(1000);
1611: l_ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE; --OTM R12, glog proj
1612:
1613: l_debug_on BOOLEAN;
1614: l_def_rec WSH_TRIPS_GRP.default_parameters_rectype;
1615: --
1616: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
1617: || 'TRIP_ACTION WRAPPER';
1618:

Line 1627: FROM WSH_TRIPS

1623: ,load_tender_status
1624: ,status_code
1625: ,shipments_type_flag
1626: ,ignore_for_planning -- OTM R12, glog proj
1627: FROM WSH_TRIPS
1628: WHERE trip_id = p_trip_id;
1629:
1630:
1631: BEGIN

Line 1702: WSH_TRIPS_GRP.Trip_Action

1698:
1699: l_index := p_entity_id_tab.NEXT(l_index);
1700: END LOOP;
1701:
1702: WSH_TRIPS_GRP.Trip_Action
1703: ( p_api_version_number => p_api_version_number,
1704: p_init_msg_list => p_init_msg_list,
1705: p_commit => p_commit,
1706: p_action_prms => l_action_prms,

Line 1770: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',

1766: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1767: WSH_DEBUG_SV.pop(l_module_name);
1768: END IF;
1769: WHEN OTHERS THEN
1770: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1771: l_module_name);
1772: FND_MSG_PUB.Count_And_Get
1773: ( p_count => x_msg_count
1774: , p_data => x_msg_data

Line 2228: p_in_rec IN WSH_TRIPS_PVT.trip_rec_type,

2224: END Create_Update_Stop;
2225:
2226:
2227: PROCEDURE Rtrim_trips_blank_space (
2228: p_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
2229: p_out_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type) IS
2230: l_debug_on BOOLEAN;
2231: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||
2232: G_PKG_NAME || '.' || 'Rtrim_trips_blank_space';

Line 2229: p_out_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type) IS

2225:
2226:
2227: PROCEDURE Rtrim_trips_blank_space (
2228: p_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
2229: p_out_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type) IS
2230: l_debug_on BOOLEAN;
2231: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||
2232: G_PKG_NAME || '.' || 'Rtrim_trips_blank_space';
2233: BEGIN

Line 2325: -- COMMENT : This calls Core API WSH_TRIPS_GRP.Create_Update_Trip.

2321: -- p_IN_rec Input Attributes for the trip entity
2322: -- p_OUT_rec Table of output Attributes for the trip entity
2323: -- VERSION : current version 1.0
2324: -- initial version 1.0
2325: -- COMMENT : This calls Core API WSH_TRIPS_GRP.Create_Update_Trip.
2326: --========================================================================
2327: PROCEDURE Create_Update_Trip(
2328: p_api_version_number IN NUMBER,
2329: p_init_msg_list IN VARCHAR2,

Line 2334: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

2330: p_commit IN VARCHAR2,
2331: x_return_status OUT NOCOPY VARCHAR2,
2332: x_msg_count OUT NOCOPY NUMBER,
2333: x_msg_data OUT NOCOPY VARCHAR2,
2334: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
2335: p_In_rec IN WSH_TRIPS_GRP.tripInRecType,
2336: x_Out_Tab OUT NOCOPY WSH_TRIPS_GRP.trip_Out_Tab_Type) IS
2337:
2338: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2335: p_In_rec IN WSH_TRIPS_GRP.tripInRecType,

2331: x_return_status OUT NOCOPY VARCHAR2,
2332: x_msg_count OUT NOCOPY NUMBER,
2333: x_msg_data OUT NOCOPY VARCHAR2,
2334: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
2335: p_In_rec IN WSH_TRIPS_GRP.tripInRecType,
2336: x_Out_Tab OUT NOCOPY WSH_TRIPS_GRP.trip_Out_Tab_Type) IS
2337:
2338: l_api_version_number CONSTANT NUMBER := 1.0;
2339: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Trip';

Line 2336: x_Out_Tab OUT NOCOPY WSH_TRIPS_GRP.trip_Out_Tab_Type) IS

2332: x_msg_count OUT NOCOPY NUMBER,
2333: x_msg_data OUT NOCOPY VARCHAR2,
2334: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
2335: p_In_rec IN WSH_TRIPS_GRP.tripInRecType,
2336: x_Out_Tab OUT NOCOPY WSH_TRIPS_GRP.trip_Out_Tab_Type) IS
2337:
2338: l_api_version_number CONSTANT NUMBER := 1.0;
2339: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Trip';
2340: l_debug_on BOOLEAN;

Line 2346: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2342: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP';
2343:
2344: l_num_warnings NUMBER := 0;
2345: l_num_errors NUMBER := 0;
2346: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2347: l_In_rec WSH_TRIPS_GRP.tripInRecType;
2348:
2349: BEGIN
2350: --

Line 2347: l_In_rec WSH_TRIPS_GRP.tripInRecType;

2343:
2344: l_num_warnings NUMBER := 0;
2345: l_num_errors NUMBER := 0;
2346: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2347: l_In_rec WSH_TRIPS_GRP.tripInRecType;
2348:
2349: BEGIN
2350: --
2351: --

Line 2380: WSH_TRIPS_GRP.Create_Update_Trip(

2376: l_trip_info_tab(l_index));
2377: l_index := p_trip_info_tab.NEXT(l_index);
2378: END LOOP;
2379:
2380: WSH_TRIPS_GRP.Create_Update_Trip(
2381: p_api_version_number => p_api_version_number,
2382: p_init_msg_list => p_init_msg_list,
2383: p_commit => p_commit,
2384: x_return_status => x_return_status,