APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_FREIGHT_COSTS

Line 7582: WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs(

7578:
7579: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND l_dd_id.count > 0
7580: AND NVL(p_action_prms.caller,'!!!!') NOT LIKE '%' || WSH_UTIL_CORE.C_SPLIT_DLVY_SUFFIX
7581: THEN
7582: WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs(
7583: p_delivery_details_tab => l_dd_id,
7584: x_return_status => l_return_status) ;
7585: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
7586: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 12925: DELETE FROM WSH_FREIGHT_COSTS

12921:
12922: -- Bug#3670261
12923: -- Deleting the Freight Costs associated with the delivery details selected for Consolidation
12924: FORALL i IN 1..l_cons_dd_ids.COUNT
12925: DELETE FROM WSH_FREIGHT_COSTS
12926: WHERE delivery_detail_id = l_cons_dd_ids(i);
12927: IF l_debug_on THEN
12928: WSH_DEBUG_SV.log(l_module_name,'Freight Cost Rows deleted',SQL%ROWCOUNT);
12929: END IF;

Line 13859: DELETE FROM WSH_FREIGHT_COSTS

13855:
13856: -- Bug#3670261
13857: -- Deleting the Freight Costs associated with the delivery details selected for Consolidation
13858: FORALL i IN 1..l_freight_detail_ids.COUNT
13859: DELETE FROM WSH_FREIGHT_COSTS
13860: WHERE delivery_detail_id = l_freight_detail_ids(i);
13861: IF l_debug_on THEN
13862: WSH_DEBUG_SV.log(l_module_name,'Freight Cost Rows deleted',SQL%ROWCOUNT);
13863: END IF;