43: BEGIN
44: --Initialize return status
45: l_return_status := OKC_API.G_RET_STS_SUCCESS;
46:
47: -- Standard START OF API SAVEPOINT
48: DBMS_TRANSACTION.SAVEPOINT(l_api_name || '_PVT');
49:
50: --Get the retry count from events table
51: IF p_msgid IS NOT NULL THEN
246: select name
247: from okc_actions_v
248: where correlation = p_corrid;
249: BEGIN
250: -- Standard START OF API SAVEPOINT
251: DBMS_TRANSACTION.SAVEPOINT(l_api_name || '_PVT');
252:
253: --Initialize return status
254: l_return_status := OKC_API.G_RET_STS_SUCCESS;