APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_NEW_DELIVERIES

Line 189: wsh_new_deliveries dl,

185: , dl.status_code
186: FROM wsh_delivery_Details dd,
187: wsh_delivery_assignments_v da ,
188: wsh_delivery_legs dg,
189: wsh_new_deliveries dl,
190: wsh_trip_stops st
191: WHERE st.stop_id = dg.pick_up_stop_id AND
192: st.stop_id = p_stop_id AND
193: st.stop_location_id = dl.initial_pickup_location_id AND

Line 419: FROM wsh_new_deliveries wnd,

415: SELECT wnd.delivery_id,
416: wnd.planned_flag,
417: wdd.source_code,
418: wdd.source_line_id
419: FROM wsh_new_deliveries wnd,
420: wsh_delivery_details wdd,
421: wsh_delivery_assignments_v wda
422: WHERE wdd.delivery_detail_id = c_delivery_detail_id
423: AND wda.delivery_id = wnd.delivery_id (+)

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

1764: --
1765: -- Debug Statements
1766: --
1767: IF l_debug_on THEN
1768: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1769: END IF;
1770: --
1771: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1772: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1771: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));

1767: IF l_debug_on THEN
1768: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1769: END IF;
1770: --
1771: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1772: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1773: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1774: END IF;
1775: end if;