265:
266: END get_noa_descriptor;
267:
268: FUNCTION get_remark_descriptor(
269: p_remark_id IN ghr_remarks.remark_id%TYPE)
270: RETURN VARCHAR2 IS
271:
272: l_ret_val ghr_remarks.description%TYPE := NULL;
273:
268: FUNCTION get_remark_descriptor(
269: p_remark_id IN ghr_remarks.remark_id%TYPE)
270: RETURN VARCHAR2 IS
271:
272: l_ret_val ghr_remarks.description%TYPE := NULL;
273:
274: CURSOR cur_rem IS
275: SELECT rem.description
276: FROM ghr_remarks rem
272: l_ret_val ghr_remarks.description%TYPE := NULL;
273:
274: CURSOR cur_rem IS
275: SELECT rem.description
276: FROM ghr_remarks rem
277: WHERE rem.remark_id = p_remark_id;
278:
279: BEGIN
280: FOR cur_rem_rec IN cur_rem LOOP