959: ) RETURN VARCHAR2 IS
960: item_not_found_error EXCEPTION;
961: CURSOR oks_khrv_chrv_fk1_csr (p_id IN NUMBER) IS
962: SELECT 'x'
963: FROM Okc_K_Headers_V
964: WHERE okc_k_headers_v.id = p_id;
965: l_oks_khrv_chrv_fk1 oks_khrv_chrv_fk1_csr%ROWTYPE;
966:
967: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
960: item_not_found_error EXCEPTION;
961: CURSOR oks_khrv_chrv_fk1_csr (p_id IN NUMBER) IS
962: SELECT 'x'
963: FROM Okc_K_Headers_V
964: WHERE okc_k_headers_v.id = p_id;
965: l_oks_khrv_chrv_fk1 oks_khrv_chrv_fk1_csr%ROWTYPE;
966:
967: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
968: l_row_notfound BOOLEAN := TRUE;