APPS.WSH_FREIGHT_COSTS_GRP dependencies on WSH_TRIPS

Line 280: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;

276: l_debug_on BOOLEAN;
277: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DISABLED_LIST';
278:
279: l_disabled_list WSH_UTIL_CORE.column_tab_type;
280: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;
281: l_return_status VARCHAR2(30);
282: l_field_name VARCHAR2(100);
283: l_conversion_type VARCHAR2(100); --Bugfix 8736256
284:

Line 726: FROM wsh_trips

722: load_tender_status, -- R12 Select Carrier dependent change
723: lane_id,
724: shipments_type_flag,
725: NVL(ignore_for_planning, 'N') --OTM R12,glog proj
726: FROM wsh_trips
727: WHERE trip_id = v_trip_id;
728:
729: CURSOR c_stop_rec(v_stop_id NUMBER ) IS
730: SELECT stop_id,

Line 1054: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,

1050: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record and display warning
1051: IF p_in_rec.caller = 'PLSQL' THEN
1052: BEGIN
1053: SELECT 'Y',wt.name into l_status,l_name
1054: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1055: wsh_delivery_assignments wda, wsh_delivery_details wdd
1056: WHERE wt.trip_id = l_trip_id
1057: AND wts.trip_id = wt.trip_id
1058: AND wdl.pick_up_stop_id = wts.stop_id

Line 1085: FROM wsh_trips

1081: --Bugfix 6816437 End
1082:
1083: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1084: SELECT COUNT(*) INTO l_counts
1085: FROM wsh_trips
1086: WHERE trip_id = l_trip_id
1087: AND ROWNUM = 1;
1088:
1089: IF (l_counts = 0) THEN