DBA Data[Home] [Help]

APPS.OKL_PQV_PVT dependencies on OKL_PRODUCTS_V

Line 314: FROM okl_products_v

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;

Line 315: WHERE okl_products_v.id = p_id;

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;