DBA Data[Home] [Help]

APPS.WSH_DELIVERIES_GRP dependencies on WSH_FREIGHT_COSTS

Line 1886: DELETE FROM WSH_FREIGHT_COSTS

1882: --delete freight cost record, delivery leg is deleted
1883: --when delivery unassigned from trip, no need to delete the leg's freight cost
1884: IF l_delivery_id_tab.COUNT > 0 THEN
1885: FORALL i IN l_delivery_id_tab.FIRST..l_delivery_id_tab.LAST
1886: DELETE FROM WSH_FREIGHT_COSTS
1887: WHERE delivery_id = l_delivery_id_tab(i);
1888: END IF;
1889: EXIT; --exit loop once an include for delivery is found because this trip will only need to be processed once
1890: END IF; --ignore for planning check