APPS.WSH_INBOUND_UTIL_PKG dependencies on WSH_NEW_DELIVERIES

Line 1266: FROM wsh_new_deliveries wnd

1262: nvl(shipment_direction,'O') shipment_direction,
1263: name,
1264: initial_pickup_location_id,
1265: status_code
1266: FROM wsh_new_deliveries wnd
1267: WHERE delivery_id = p_delivery_id;
1268: --
1269: --
1270: l_dlvy_rec dlvy_csr%ROWTYPE;

Line 1321: l_delivery_rec WSH_NEW_DELIVERIES_PVT.delivery_rec_type;

1317: l_rowid VARCHAR2(32767);
1318:
1319: l_query_count NUMBER;
1320: --
1321: l_delivery_rec WSH_NEW_DELIVERIES_PVT.delivery_rec_type;
1322: l_leg_id_tbl wsh_util_core.id_tab_type;
1323: l_line_tbl wsh_util_core.id_tab_type;
1324: l_entity_ids wsh_util_core.id_tab_type;
1325: l_dlvy_freight_terms_code VARCHAR2(30);

Line 1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.clone',WSH_DEBUG_SV.C_PROC_LEVEL);

1414: l_delivery_rec.wv_frozen_flag := 'N';
1415: l_delivery_rec.routing_response_id := FND_API.G_MISS_NUM ;
1416:
1417: IF l_debug_on THEN
1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.clone',WSH_DEBUG_SV.C_PROC_LEVEL);
1419: END IF;
1420: --
1421: -- Clone the input delivery
1422: --

Line 1423: WSH_NEW_DELIVERIES_PVT.clone

1419: END IF;
1420: --
1421: -- Clone the input delivery
1422: --
1423: WSH_NEW_DELIVERIES_PVT.clone
1424: (
1425: p_delivery_rec => l_delivery_rec,
1426: p_delivery_id => p_delivery_id,
1427: p_copy_legs => 'Y',

Line 2483: wsh_new_deliveries wnd

2479: pu_stop.trip_id trip_id
2480: FROM wsh_trip_stops pu_stop,
2481: wsh_trip_stops do_stop,
2482: wsh_delivery_legs wdl,
2483: wsh_new_deliveries wnd
2484: WHERE wnd.delivery_id = p_delivery_id
2485: AND wdl.delivery_id = wnd.delivery_id
2486: AND NVL(wnd.shipment_direction,'O') NOT IN ('O','IO')
2487: AND wdl.pick_up_stop_id = pu_stop.stop_id

Line 2509: wsh_new_deliveries wnd

2505: wsh_trip_stops next_leg_pu_stop,
2506: wsh_trip_stops curr_leg_do_stop,
2507: wsh_delivery_legs next_leg,
2508: wsh_delivery_legs curr_leg,
2509: wsh_new_deliveries wnd
2510: WHERE next_leg.drop_off_stop_id = next_leg_do_stop.stop_id
2511: --AND st1.status_code = 'OP'
2512: AND next_leg.pick_up_stop_id = next_leg_pu_stop.stop_id
2513: AND next_leg_pu_stop.stop_location_id = curr_leg_do_stop.stop_location_id

Line 2526: FROM wsh_new_deliveries wnd

2522: CURSOR dlvy_csr (p_delivery_id IN NUMBER)
2523: IS
2524: SELECT NVL(wnd.planned_flag,'N') planned_flag,
2525: NVL(ignore_for_planning,'N') ignore_for_planning
2526: FROM wsh_new_deliveries wnd
2527: WHERE wnd.delivery_id = p_delivery_id;
2528: --
2529:
2530:

Line 3411: FROM wsh_new_deliveries wnd,

3407: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Is_Routing_Response_Send';
3408:
3409: CURSOR get_routing_response IS
3410: SELECT wnd.routing_response_id
3411: FROM wsh_new_deliveries wnd,
3412: wsh_delivery_assignments_v wda
3413: WHERE wnd.delivery_id = wda.delivery_id
3414: AND wda.delivery_detail_id = p_delivery_detail_id
3415: AND wnd.routing_response_id IS NOT NULL;