APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_FREIGHT_COSTS

Line 7418: WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs(

7414:
7415: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND l_dd_id.count > 0
7416: AND NVL(p_action_prms.caller,'!!!!') NOT LIKE '%' || WSH_UTIL_CORE.C_SPLIT_DLVY_SUFFIX
7417: THEN
7418: WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs(
7419: p_delivery_details_tab => l_dd_id,
7420: x_return_status => l_return_status) ;
7421: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
7422: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 12449: DELETE FROM WSH_FREIGHT_COSTS

12445:
12446: -- Bug#3670261
12447: -- Deleting the Freight Costs associated with the delivery details selected for Consolidation
12448: FORALL i IN 1..l_cons_dd_ids.COUNT
12449: DELETE FROM WSH_FREIGHT_COSTS
12450: WHERE delivery_detail_id = l_cons_dd_ids(i);
12451: IF l_debug_on THEN
12452: WSH_DEBUG_SV.log(l_module_name,'Freight Cost Rows deleted',SQL%ROWCOUNT);
12453: END IF;

Line 13168: DELETE FROM WSH_FREIGHT_COSTS

13164:
13165: -- Bug#3670261
13166: -- Deleting the Freight Costs associated with the delivery details selected for Consolidation
13167: FORALL i IN 1..l_freight_detail_ids.COUNT
13168: DELETE FROM WSH_FREIGHT_COSTS
13169: WHERE delivery_detail_id = l_freight_detail_ids(i);
13170: IF l_debug_on THEN
13171: WSH_DEBUG_SV.log(l_module_name,'Freight Cost Rows deleted',SQL%ROWCOUNT);
13172: END IF;