APPS.FTE_ACS_TRIP_PKG dependencies on WSH_NEW_DELIVERIES

Line 61: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

57: x_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
58: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
59: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
60: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
61: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
62: K_CREATE CONSTANT VARCHAR2(30) := 'CREATE';
63: l_commit VARCHAR2(100) := FND_API.G_FALSE;
64: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
65: l_api_version_number NUMBER := 1.0;

Line 105: FROM WSH_NEW_DELIVERIES

101: , shipping_control
102: , weight_uom_code
103: , volume_uom_code
104: , nvl(ignore_for_planning,'N') ignore_for_planning
105: FROM WSH_NEW_DELIVERIES
106: WHERE delivery_id = p_delivery_id;
107:
108: /*CURSOR c_dlvy_weight_volume_csr (p_delivery_id IN NUMBER) IS
109: SELECT weight_uom_code

Line 111: FROM wsh_new_deliveries

107:
108: /*CURSOR c_dlvy_weight_volume_csr (p_delivery_id IN NUMBER) IS
109: SELECT weight_uom_code
110: ,volume_uom_code
111: FROM wsh_new_deliveries
112: WHERE delivery_id = p_delivery_id;*/
113: BEGIN
114: --{
115: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;