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:
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
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;