DBA Data[Home] [Help]

APPS.OKL_PIT_PVT dependencies on OKL_PRODUCTS_V

Line 386: CURSOR okl_pdt_pk_csr (p_id IN OKL_PRODUCTS_V.id%TYPE) IS

382: l_dummy VARCHAR2(1) := '?';
383: l_row_not_found BOOLEAN := FALSE;
384:
385: -- Cursor For OKL_PRODUCTS - Foreign Key Constraint
386: CURSOR okl_pdt_pk_csr (p_id IN OKL_PRODUCTS_V.id%TYPE) IS
387: SELECT '1'
388: FROM OKL_PRODUCTS_V
389: WHERE OKL_PRODUCTS_V.id = p_id;
390:

Line 388: FROM OKL_PRODUCTS_V

384:
385: -- Cursor For OKL_PRODUCTS - Foreign Key Constraint
386: CURSOR okl_pdt_pk_csr (p_id IN OKL_PRODUCTS_V.id%TYPE) IS
387: SELECT '1'
388: FROM OKL_PRODUCTS_V
389: WHERE OKL_PRODUCTS_V.id = p_id;
390:
391: BEGIN
392: -- initialize return status

Line 389: WHERE OKL_PRODUCTS_V.id = p_id;

385: -- Cursor For OKL_PRODUCTS - Foreign Key Constraint
386: CURSOR okl_pdt_pk_csr (p_id IN OKL_PRODUCTS_V.id%TYPE) IS
387: SELECT '1'
388: FROM OKL_PRODUCTS_V
389: WHERE OKL_PRODUCTS_V.id = p_id;
390:
391: BEGIN
392: -- initialize return status
393: x_return_status := Okc_Api.G_RET_STS_SUCCESS;