APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_FREIGHT_COSTS_INTERFACE

Line 2125: DELETE wsh_freight_costs_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
2125: DELETE wsh_freight_costs_interface
2126: WHERE delivery_leg_interface_id = ids_rec.delivery_leg_interface_id
2127: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2128:
2129: DELETE wsh_trip_stops_interface

Line 2137: DELETE wsh_freight_costs_interface

2133: )
2134: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2135:
2136: --Added for bug 7615007
2137: DELETE wsh_freight_costs_interface
2138: WHERE stop_interface_id IN
2139: (ids_rec.pick_up_stop_interface_id,
2140: ids_rec.drop_off_stop_interface_id
2141: )

Line 2149: DELETE wsh_freight_costs_interface

2145: WHERE trip_interface_id = ids_rec.trip_interface_id
2146: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2147:
2148: --Added for bug 7615007
2149: DELETE wsh_freight_costs_interface
2150: WHERE trip_interface_id = ids_rec.trip_interface_id
2151: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2152:
2153: END LOOP; -- End of FOR IDs_Rec IN IDs LOOP

Line 2162: DELETE wsh_freight_costs_interface

2158: WHERE delivery_detail_interface_id = detail_interface_ids_rec.delivery_detail_interface_id
2159: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2160:
2161: --Added for bug 7615007
2162: DELETE wsh_freight_costs_interface
2163: WHERE delivery_detail_interface_id = detail_interface_ids_rec.delivery_detail_interface_id
2164: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2165:
2166: DELETE wsh_del_assgn_interface

Line 2176: DELETE wsh_freight_costs_interface

2172: WHERE delivery_interface_id = p_delivery_interface_id
2173: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2174:
2175: --Added for bug 7615007
2176: DELETE wsh_freight_costs_interface
2177: WHERE delivery_interface_id = p_delivery_interface_id
2178: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2179:
2180: x_return_status := wsh_util_core.g_ret_sts_success;