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 1594: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,

1590: ( p_api_version_number IN NUMBER,
1591: p_init_msg_list IN VARCHAR2,
1592: p_commit IN VARCHAR2,
1593: p_entity_id_tab IN wsh_util_core.id_tab_type,
1594: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
1595: x_trip_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripActionOutRecType,
1596: x_return_status OUT NOCOPY VARCHAR2,
1597: x_msg_count OUT NOCOPY NUMBER,
1598: x_msg_data OUT NOCOPY VARCHAR2)

Line 1595: x_trip_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripActionOutRecType,

1591: p_init_msg_list IN VARCHAR2,
1592: p_commit IN VARCHAR2,
1593: p_entity_id_tab IN wsh_util_core.id_tab_type,
1594: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
1595: x_trip_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripActionOutRecType,
1596: x_return_status OUT NOCOPY VARCHAR2,
1597: x_msg_count OUT NOCOPY NUMBER,
1598: x_msg_data OUT NOCOPY VARCHAR2)
1599: IS

Line 1601: l_rec_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1597: x_msg_count OUT NOCOPY NUMBER,
1598: x_msg_data OUT NOCOPY VARCHAR2)
1599: IS
1600:
1601: l_rec_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1602: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
1603: l_num_warning NUMBER := 0;
1604: l_num_errors NUMBER := 0;
1605: l_next NUMBER;

Line 1602: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

1598: x_msg_data OUT NOCOPY VARCHAR2)
1599: IS
1600:
1601: l_rec_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1602: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
1603: l_num_warning NUMBER := 0;
1604: l_num_errors NUMBER := 0;
1605: l_next NUMBER;
1606: l_index NUMBER;

Line 1608: l_status_code wsh_trips.status_code%TYPE;

1604: l_num_errors NUMBER := 0;
1605: l_next NUMBER;
1606: l_index NUMBER;
1607: l_trip_id NUMBER;
1608: l_status_code wsh_trips.status_code%TYPE;
1609: l_planned_flag wsh_trips.planned_flag%TYPE;
1610: l_lane_id wsh_trips.lane_id%TYPE;
1611: l_load_tender_status wsh_trips.load_tender_status%TYPE;
1612: l_shipments_type_flag VARCHAR2(30);

Line 1609: l_planned_flag wsh_trips.planned_flag%TYPE;

1605: l_next NUMBER;
1606: l_index NUMBER;
1607: l_trip_id NUMBER;
1608: l_status_code wsh_trips.status_code%TYPE;
1609: l_planned_flag wsh_trips.planned_flag%TYPE;
1610: l_lane_id wsh_trips.lane_id%TYPE;
1611: l_load_tender_status wsh_trips.load_tender_status%TYPE;
1612: l_shipments_type_flag VARCHAR2(30);
1613: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

Line 1610: l_lane_id wsh_trips.lane_id%TYPE;

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

Line 1611: l_load_tender_status wsh_trips.load_tender_status%TYPE;

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

Line 1613: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

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

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

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

Line 1618: l_def_rec WSH_TRIPS_GRP.default_parameters_rectype;

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

Line 1631: FROM WSH_TRIPS

1627: ,load_tender_status
1628: ,status_code
1629: ,shipments_type_flag
1630: ,ignore_for_planning -- OTM R12, glog proj
1631: FROM WSH_TRIPS
1632: WHERE trip_id = p_trip_id;
1633:
1634:
1635: BEGIN

Line 1706: WSH_TRIPS_GRP.Trip_Action

1702:
1703: l_index := p_entity_id_tab.NEXT(l_index);
1704: END LOOP;
1705:
1706: WSH_TRIPS_GRP.Trip_Action
1707: ( p_api_version_number => p_api_version_number,
1708: p_init_msg_list => p_init_msg_list,
1709: p_commit => p_commit,
1710: p_action_prms => l_action_prms,

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

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

Line 2232: p_in_rec IN WSH_TRIPS_PVT.trip_rec_type,

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

Line 2233: p_out_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type) IS

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

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

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

Line 2338: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

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

Line 2339: p_In_rec IN WSH_TRIPS_GRP.tripInRecType,

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

Line 2340: x_Out_Tab OUT NOCOPY WSH_TRIPS_GRP.trip_Out_Tab_Type) IS

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

Line 2350: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

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

Line 2351: l_In_rec WSH_TRIPS_GRP.tripInRecType;

2347:
2348: l_num_warnings NUMBER := 0;
2349: l_num_errors NUMBER := 0;
2350: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2351: l_In_rec WSH_TRIPS_GRP.tripInRecType;
2352:
2353: BEGIN
2354: --
2355: --

Line 2384: WSH_TRIPS_GRP.Create_Update_Trip(

2380: l_trip_info_tab(l_index));
2381: l_index := p_trip_info_tab.NEXT(l_index);
2382: END LOOP;
2383:
2384: WSH_TRIPS_GRP.Create_Update_Trip(
2385: p_api_version_number => p_api_version_number,
2386: p_init_msg_list => p_init_msg_list,
2387: p_commit => p_commit,
2388: x_return_status => x_return_status,