200: when Others then
201: return(SQLCODE);
202: end C_RA_RULES;
203:
204: FUNCTION C_RA_TERMS(term_id_val in NUMBER) RETURN varchar2 IS
205: ret_string varchar2(15);
206: begin
207: if (term_id_val is NOT NULL) then
208: select name
206: begin
207: if (term_id_val is NOT NULL) then
208: select name
209: into ret_string
210: from ra_terms
211: where term_id = term_id_val;
212: return (ret_string);
213: else
214: return(NULL);
217: when NO_DATA_FOUND then
218: return(NULL);
219: when Others then
220: return(SQLCODE);
221: end C_RA_TERMS;
222:
223: FUNCTION C_FND_LOOKUP_VL(lookup_code_val in varchar2,lookup_type_val in varchar2) RETURN varchar2 IS
224: temp varchar2(80);
225: begin