349: ) IS
350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
351: CURSOR okl_pdt_opts_foreign2 (p_foreign OKL_PDT_OPTS.PDT_ID%TYPE) IS
352: SELECT ID
353: FROM OKL_PRODUCTS_V
354: WHERE OKL_PRODUCTS_V.ID = p_foreign;
355:
356: l_foreign_key OKL_PDT_OPTS_V.PDT_ID%TYPE;
357:
350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
351: CURSOR okl_pdt_opts_foreign2 (p_foreign OKL_PDT_OPTS.PDT_ID%TYPE) IS
352: SELECT ID
353: FROM OKL_PRODUCTS_V
354: WHERE OKL_PRODUCTS_V.ID = p_foreign;
355:
356: l_foreign_key OKL_PDT_OPTS_V.PDT_ID%TYPE;
357:
358: