534: -- dkagrawa Added cursor to validate khr_id on 29-Jul-05 - Start
535: CURSOR khr_csr (p_khr_id NUMBER)
536: IS
537: SELECT ID 538: FROM okl_k_headers 539: WHERE id = p_khr_id;
540:
541: l_khr_id NUMBER := NULL;
542: l_row_notfound BOOLEAN :=TRUE;