993: l_dummy VARCHAR2(1) := '?';
994: l_row_not_found BOOLEAN := FALSE;
995:
996: -- Cursor For OKL_K_HEADERS - Foreign Key Constraint
997: CURSOR okl_Khr_pk_csr (p_id IN OKL_K_HEADERS_V.id%TYPE) IS
998: SELECT '1'
999: FROM OKL_K_HEADERS_V
1000: WHERE OKL_K_HEADERS_V.id = p_id;
1001:
995:
996: -- Cursor For OKL_K_HEADERS - Foreign Key Constraint
997: CURSOR okl_Khr_pk_csr (p_id IN OKL_K_HEADERS_V.id%TYPE) IS
998: SELECT '1'
999: FROM OKL_K_HEADERS_V
1000: WHERE OKL_K_HEADERS_V.id = p_id;
1001:
1002: BEGIN
1003: -- initialize return status
996: -- Cursor For OKL_K_HEADERS - Foreign Key Constraint
997: CURSOR okl_Khr_pk_csr (p_id IN OKL_K_HEADERS_V.id%TYPE) IS
998: SELECT '1'
999: FROM OKL_K_HEADERS_V
1000: WHERE OKL_K_HEADERS_V.id = p_id;
1001:
1002: BEGIN
1003: -- initialize return status
1004: x_return_status := Okc_Api.G_RET_STS_SUCCESS;