289: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
290:
291: CURSOR okl_opt_values_foreign (p_foreign OKL_OPT_VALUES.OPT_ID%TYPE) IS
292: SELECT ID
293: FROM OKL_OPTIONS_V
294: WHERE OKL_OPTIONS_V.ID = p_foreign;
295:
296: l_foreign_key OKL_OPT_VALUES_V.OPT_ID%TYPE;
297:
290:
291: CURSOR okl_opt_values_foreign (p_foreign OKL_OPT_VALUES.OPT_ID%TYPE) IS
292: SELECT ID
293: FROM OKL_OPTIONS_V
294: WHERE OKL_OPTIONS_V.ID = p_foreign;
295:
296: l_foreign_key OKL_OPT_VALUES_V.OPT_ID%TYPE;
297:
298: BEGIN