340: ,x_return_status OUT NOCOPY VARCHAR2)
341: IS
342: CURSOR okl_optv_pk_csr (p_id IN NUMBER) IS
343: SELECT '1'
344: FROM okl_options_v
345: WHERE okl_options_v.id = p_id;
346:
347: l_opt_status VARCHAR2(1);
348: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
341: IS
342: CURSOR okl_optv_pk_csr (p_id IN NUMBER) IS
343: SELECT '1'
344: FROM okl_options_v
345: WHERE okl_options_v.id = p_id;
346:
347: l_opt_status VARCHAR2(1);
348: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
349: l_row_notfound BOOLEAN := TRUE;