APPS.WSH_OTM_OUTBOUND dependencies on WSH_NEW_DELIVERIES

Line 964: FROM wsh_new_deliveries

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

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

1060: ||'wdd.container_flag,'
1061: ||'wda.parent_delivery_detail_id,'
1062: ||'wdd.cust_po_number,'
1063: ||'wdd.source_header_number,''CUST_PO'',''SO_NUM'', wda.delivery_id,nvl(wdd.NET_WEIGHT,0))'
1064: ||' from wsh_new_deliveries wnd, wsh_delivery_details wdd , wsh_delivery_assignments wda , '
1065: ||' hz_cust_acct_sites_all ca , hz_cust_site_uses_all su '
1066: ||' where ca.cust_acct_site_id(+) = su.cust_acct_site_id '
1067: ||' and su.site_use_id(+) = wdd.ship_to_site_use_id '
1068: ||' and wdd.delivery_detail_id(+) = wda.delivery_detail_id '

Line 1172: -- If customer_id is null in wsh_new_deliveries

1168: IF l_internal_org_location_id is NOT NULL THEN
1169: l_dlv_tab(i).ULTIMATE_DROPOFF_LOCATION_ID := l_internal_org_location_id;
1170: ELSE
1171: --{
1172: -- If customer_id is null in wsh_new_deliveries
1173: IF l_customer_id is NULL THEN
1174: open get_customer_id(l_dlv_tab(i).delivery_id);
1175: fetch get_customer_id into l_customer_id,l_cnt;
1176: close get_customer_id;

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

1547: CLOSE get_errored_dlvys;
1548: IF l_upd_err_dlvys.COUNT > 0 THEN
1549: --{
1550: IF l_debug_on THEN
1551: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
1552: END IF;
1553: --
1554: WSH_NEW_DELIVERIES_PVT.Update_Tms_interface_flag
1555: ( p_delivery_id_tab => l_upd_err_dlvys,

Line 1554: WSH_NEW_DELIVERIES_PVT.Update_Tms_interface_flag

1550: IF l_debug_on THEN
1551: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
1552: END IF;
1553: --
1554: WSH_NEW_DELIVERIES_PVT.Update_Tms_interface_flag
1555: ( p_delivery_id_tab => l_upd_err_dlvys,
1556: p_tms_interface_flag_tab => l_upd_tms_interface_flags,
1557: x_return_status => l_return_status );
1558: --

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

1713: INVALID_NEW_INTF_STATUS EXCEPTION;
1714:
1715: -- define the cursor to get the current TMS_INTERFACE_FLAG status of delivery
1716: cursor get_del_tms_interface_flag(c_delivery_id NUMBER) IS
1717: select TMS_INTERFACE_FLAG,status_code,nvl(ignore_for_planning,'N') from wsh_new_deliveries
1718: where delivery_id = c_delivery_id;
1719:
1720: -- define the cursor to get all trip stops for the given trip id.
1721: cursor get_trip_stops(c_trip_id NUMBER) IS

Line 1917: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG

1913: WSH_DEBUG_SV.log(l_sub_module_name,'Processing Delivery Calling WSH API to update status-Del-Count',l_id_tab.COUNT);
1914: END IF;
1915: --{
1916: --Call WSH API to update the new status
1917: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG
1918: (P_DELIVERY_ID_TAB=>l_id_tab,
1919: P_TMS_INTERFACE_FLAG_TAB =>l_status_tab,
1920: X_RETURN_STATUS =>l_return_status);
1921: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then