DBA Data[Home] [Help]

APPS.WSH_DELIVERIES_GRP dependencies on WSH_FREIGHT_COSTS

Line 1941: DELETE FROM WSH_FREIGHT_COSTS

1937: --delete freight cost record, delivery leg is deleted
1938: --when delivery unassigned from trip, no need to delete the leg's freight cost
1939: IF l_delivery_id_tab.COUNT > 0 THEN
1940: FORALL i IN l_delivery_id_tab.FIRST..l_delivery_id_tab.LAST
1941: DELETE FROM WSH_FREIGHT_COSTS
1942: WHERE delivery_id = l_delivery_id_tab(i);
1943: END IF;
1944: EXIT; --exit loop once an include for delivery is found because this trip will only need to be processed once
1945: END IF; --ignore for planning check