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 408: FROM wsh_new_deliveries wnd,

404: -- bug# 6908504 (replenishment project), Changed the cursor definition. Now it returns planned_flag value from WND table.
405: CURSOR c_assigned(c_delivery_detail_id number) is
406: SELECT wnd.delivery_id,
407: wnd.planned_flag
408: FROM wsh_new_deliveries wnd,
409: wsh_delivery_details wdd,
410: wsh_delivery_assignments_v wda
411: WHERE wdd.delivery_detail_id = c_delivery_detail_id
412: AND wda.delivery_id = wnd.delivery_id

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

1576: --
1577: -- Debug Statements
1578: --
1579: IF l_debug_on THEN
1580: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1581: END IF;
1582: --
1583: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

1579: IF l_debug_on THEN
1580: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1581: END IF;
1582: --
1583: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id));
1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1585: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1586: END IF;
1587: end if;