2251: x_return_status := wsh_util_core.g_ret_sts_success;
2252: --
2253: IF (p_det_error_interface_id_tbl.COUNT > 0) THEN
2254: FORALL i in p_det_error_interface_id_tbl.FIRST..p_det_error_interface_id_tbl.LAST
2255: DELETE FROM wsh_interface_errors
2256: WHERE interface_error_id = p_det_error_interface_id_tbl(i);
2257: --
2258: IF l_debug_on THEN
2259: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_interface_errors');
2255: DELETE FROM wsh_interface_errors
2256: WHERE interface_error_id = p_det_error_interface_id_tbl(i);
2257: --
2258: IF l_debug_on THEN
2259: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_interface_errors');
2260: END IF;
2261: --
2262: END IF;
2263: --
2262: END IF;
2263: --
2264: IF (p_del_error_interface_id_tbl.COUNT > 0) THEN
2265: FORALL i in p_del_error_interface_id_tbl.FIRST..p_del_error_interface_id_tbl.LAST
2266: DELETE FROM wsh_interface_errors
2267: WHERE interface_error_id = p_del_error_interface_id_tbl(i);
2268: --
2269: IF l_debug_on THEN
2270: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_interface_errors');
2266: DELETE FROM wsh_interface_errors
2267: WHERE interface_error_id = p_del_error_interface_id_tbl(i);
2268: --
2269: IF l_debug_on THEN
2270: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_interface_errors');
2271: END IF;
2272: --
2273: END IF;
2274: --