APPS.WSH_OTM_OUTBOUND dependencies on WSH_NEW_DELIVERIES

Line 959: FROM wsh_new_deliveries

955: --6922924 : (begin) : Update tms_interface_flag for error Deliveries
956: CURSOR get_errored_dlvys(c_dlvy_id NUMBER) IS
957: SELECT delivery_id, decode(tms_interface_flag, 'CP', 'CR', 'UP', 'UR', 'DP',
958: 'DR', tms_interface_flag ) tms_iface_new_status
959: FROM wsh_new_deliveries
960: WHERE delivery_id = c_dlvy_id
961: FOR UPDATE OF tms_interface_flag NOWAIT;
962:
963: begin

Line 1056: ||' from wsh_new_deliveries wnd, wsh_delivery_details wdd , wsh_delivery_assignments wda'

1052: ||'wdd.container_flag,'
1053: ||'wda.parent_delivery_detail_id,'
1054: ||'wdd.cust_po_number,'
1055: ||'wdd.source_header_number,''CUST_PO'',''SO_NUM'', wda.delivery_id,nvl(wdd.NET_WEIGHT,0))'
1056: ||' from wsh_new_deliveries wnd, wsh_delivery_details wdd , wsh_delivery_assignments wda'
1057: ||' where wdd.delivery_detail_id(+) = wda.delivery_detail_id '
1058: ||' and wnd.delivery_id = wda.delivery_id(+) '
1059: ||' and wnd.delivery_id in (';
1060: --Bug 7408338

Line 1161: -- If customer_id is null in wsh_new_deliveries

1157: IF l_internal_org_location_id is NOT NULL THEN
1158: l_dlv_tab(i).ULTIMATE_DROPOFF_LOCATION_ID := l_internal_org_location_id;
1159: ELSE
1160: --{
1161: -- If customer_id is null in wsh_new_deliveries
1162: IF l_customer_id is NULL THEN
1163: open get_customer_id(l_dlv_tab(i).delivery_id);
1164: fetch get_customer_id into l_customer_id,l_cnt;
1165: close get_customer_id;

Line 1540: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');

1536: CLOSE get_errored_dlvys;
1537: IF l_upd_err_dlvys.COUNT > 0 THEN
1538: --{
1539: IF l_debug_on THEN
1540: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
1541: END IF;
1542: --
1543: WSH_NEW_DELIVERIES_PVT.Update_Tms_interface_flag
1544: ( p_delivery_id_tab => l_upd_err_dlvys,

Line 1543: WSH_NEW_DELIVERIES_PVT.Update_Tms_interface_flag

1539: IF l_debug_on THEN
1540: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
1541: END IF;
1542: --
1543: WSH_NEW_DELIVERIES_PVT.Update_Tms_interface_flag
1544: ( p_delivery_id_tab => l_upd_err_dlvys,
1545: p_tms_interface_flag_tab => l_upd_tms_interface_flags,
1546: x_return_status => l_return_status );
1547: --

Line 1706: select TMS_INTERFACE_FLAG,status_code,nvl(ignore_for_planning,'N') from wsh_new_deliveries

1702: INVALID_NEW_INTF_STATUS EXCEPTION;
1703:
1704: -- define the cursor to get the current TMS_INTERFACE_FLAG status of delivery
1705: cursor get_del_tms_interface_flag(c_delivery_id NUMBER) IS
1706: select TMS_INTERFACE_FLAG,status_code,nvl(ignore_for_planning,'N') from wsh_new_deliveries
1707: where delivery_id = c_delivery_id;
1708:
1709: -- define the cursor to get all trip stops for the given trip id.
1710: cursor get_trip_stops(c_trip_id NUMBER) IS

Line 1905: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG

1901: WSH_DEBUG_SV.log(l_sub_module_name,'Processing Delivery Calling WSH API to update status-Del-Count',l_id_tab.COUNT);
1902: END IF;
1903: --{
1904: --Call WSH API to update the new status
1905: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG
1906: (P_DELIVERY_ID_TAB=>l_id_tab,
1907: P_TMS_INTERFACE_FLAG_TAB =>l_status_tab,
1908: X_RETURN_STATUS =>l_return_status);
1909: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then