APPS.WSH_DELIVERY_LEGS_PVT dependencies on WSH_NEW_DELIVERIES

Line 513: wsh_new_deliveries wnd,

509: wt.name trip_name,
510: wdl.delivery_id --J-IB-HEALI
511: FROM wsh_delivery_legs wdl,
512: wsh_trip_stops wts1,
513: wsh_new_deliveries wnd,
514: wsh_trips wt
515: WHERE delivery_leg_id = p_delivery_leg_id
516: AND wdl.pick_up_stop_id = wts1.stop_id
517: AND wdl.delivery_id = wnd.delivery_id

Line 545: wsh_new_deliveries wnd

541: CURSOR dlvy_csr (p_stop_id IN NUMBER)
542: IS
543: SELECT 1
544: FROM wsh_delivery_legs wdl,
545: wsh_new_deliveries wnd
546: WHERE wdl.delivery_id = wnd.delivery_id
547: AND wnd.status_code IN ('IT','CL')
548: AND ( wdl.pick_up_stop_id = p_stop_id or wdl.drop_off_stop_id = p_stop_id)
549: AND rownum = 1;

Line 1581: FROM wsh_new_deliveries

1577: ) IS
1578:
1579: CURSOR get_delivery_status(x_delivery_id NUMBER) IS
1580: SELECT status_code, planned_flag
1581: FROM wsh_new_deliveries
1582: WHERE delivery_id = x_delivery_id;
1583:
1584: CURSOR get_leg_status(x_leg_id NUMBER) IS
1585: SELECT delivery_id, pick_up_stop_id, drop_off_stop_id

Line 1910: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);

1906: END IF;
1907: EXCEPTION
1908: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
1909: IF p_delivery_id IS NOT NULL THEN
1910: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
1911: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_DEL_LEG_LOCK');
1912: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
1913: wsh_util_Core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1914: IF l_debug_on THEN