513: -- dkagrawa Added cursor to validate khr_id on 29-Jul-05 - Start
514: CURSOR khr_csr (p_khr_id NUMBER)
515: IS
516: SELECT ID 517: FROM okl_k_headers 518: WHERE id = p_khr_id;
519:
520: l_khr_id NUMBER := NULL;
521: l_row_notfound BOOLEAN :=TRUE;