DBA Data[Home] [Help]

APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_INTERFACE_ERRORS

Line 2255: DELETE FROM wsh_interface_errors

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');

Line 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: --

Line 2266: DELETE FROM wsh_interface_errors

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');

Line 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: --