190: item_not_found_error EXCEPTION;
191: l_row_notfound BOOLEAN := TRUE;
192: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
193: SELECT '1'
194: FROM Okc_Timevalues
195: WHERE okc_timevalues.id = p_id;
196: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
197: BEGIN
198: x_return_status := OKC_API.G_RET_STS_SUCCESS;
191: l_row_notfound BOOLEAN := TRUE;
192: CURSOR okc_tvev_pk_csr (p_id IN NUMBER) IS
193: SELECT '1'
194: FROM Okc_Timevalues
195: WHERE okc_timevalues.id = p_id;
196: l_okc_tvev_pk okc_tvev_pk_csr%ROWTYPE;
197: BEGIN
198: x_return_status := OKC_API.G_RET_STS_SUCCESS;
199: IF (p_rtvv_rec.TVE_ID IS NOT NULL AND