DBA Data[Home] [Help]

APPS.INV_MEANING_SEL dependencies on RA_TERMS

Line 204: FUNCTION C_RA_TERMS(term_id_val in NUMBER) RETURN varchar2 IS

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

Line 210: from ra_terms

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);

Line 221: end C_RA_TERMS;

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