310: ,x_return_status OUT NOCOPY VARCHAR2)
311: IS
312: CURSOR okl_pdtv_pk_csr (p_id IN NUMBER) IS
313: SELECT '1'
314: FROM okl_products_v
315: WHERE okl_products_v.id = p_id;
316:
317: l_pdt_status VARCHAR2(1);
318: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
311: IS
312: CURSOR okl_pdtv_pk_csr (p_id IN NUMBER) IS
313: SELECT '1'
314: FROM okl_products_v
315: WHERE okl_products_v.id = p_id;
316:
317: l_pdt_status VARCHAR2(1);
318: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
319: l_row_notfound BOOLEAN := TRUE;