APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_DEL_LEGS_INTERFACE

Line 1352: UPDATE wsh_del_legs_interface

1348: initial_pickup_location_id = l_initial_pickup_location_id,
1349: ultimate_dropoff_location_id = l_ultimate_dropoff_location_id
1350: WHERE delivery_interface_id = p_delivery_interface_id;
1351:
1352: UPDATE wsh_del_legs_interface
1353: SET delivery_id = l_dlvy_id
1354: WHERE delivery_interface_id = p_delivery_interface_id;
1355: END IF;
1356:

Line 1736: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi

1732: IS
1733: SELECT wdli.delivery_leg_interface_id,
1734: wdli.pick_up_stop_interface_id,
1735: wdli.drop_off_stop_interface_id, wtsi.trip_interface_id
1736: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi
1737: WHERE wdli.delivery_interface_id = p_delivery_interface_id
1738: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
1739: AND wdli.INTERFACE_ACTION_CODE = '94X_INBOUND'
1740: AND wtsi.INTERFACE_ACTION_CODE = '94X_INBOUND';

Line 1773: DELETE wsh_del_legs_interface

1769: THEN
1770: FOR ids_rec IN ids
1771: LOOP
1772:
1773: DELETE wsh_del_legs_interface
1774: WHERE delivery_leg_interface_id = ids_rec.delivery_leg_interface_id
1775: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1776:
1777: DELETE wsh_trip_stops_interface