181: return(SQLCODE);
182: end C_ORG_NAME;
183:
184:
185: FUNCTION C_RA_RULES(rule_id_val in NUMBER) RETURN varchar2 IS
186: ret_string varchar2(30);
187: begin
188: if (rule_id_val is NOT NULL) then
189: select name
187: begin
188: if (rule_id_val is NOT NULL) then
189: select name
190: into ret_string
191: from ra_rules
192: where rule_id = rule_id_val;
193: return (ret_string);
194: else
195: return(NULL);
198: when NO_DATA_FOUND then
199: return(NULL);
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