APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_DEL_LEGS_INTERFACE

Line 1621: UPDATE wsh_del_legs_interface

1617: WHERE delivery_interface_id = p_delivery_interface_id;
1618:
1619: -- TPW - Distributed changes
1620: IF nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') in ('TPW', 'CMS') THEN
1621: UPDATE wsh_del_legs_interface
1622: SET delivery_id = l_dlvy_id
1623: WHERE delivery_interface_id = p_delivery_interface_id;
1624: END IF;
1625: END IF;

Line 2083: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi

2079: IS
2080: SELECT wdli.delivery_leg_interface_id,
2081: wdli.pick_up_stop_interface_id,
2082: wdli.drop_off_stop_interface_id, wtsi.trip_interface_id
2083: FROM wsh_del_legs_interface wdli, wsh_trip_stops_interface wtsi
2084: WHERE wdli.delivery_interface_id = p_delivery_interface_id
2085: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
2086: AND wdli.INTERFACE_ACTION_CODE = '94X_INBOUND'
2087: AND wtsi.INTERFACE_ACTION_CODE = '94X_INBOUND';

Line 2120: DELETE wsh_del_legs_interface

2116: THEN
2117: FOR ids_rec IN ids
2118: LOOP
2119:
2120: DELETE wsh_del_legs_interface
2121: WHERE delivery_leg_interface_id = ids_rec.delivery_leg_interface_id
2122: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2123:
2124: --Added for bug 7615007