290:
291: BEGIN
292: SELECT term_id
293: INTO l_var
294: FROM ap_terms
295: WHERE upper(name) = upper(p_termid);
296: EXCEPTION
297: WHEN OTHERs THEN
298: ITG_MSG.missing_element_value('TERMID', p_termid);
571: l_syncind := UPPER(p_syncind);
572: IF p_termid IS NOT NULL THEN
573: SELECT term_id
574: INTO l_term_id
575: FROM ap_terms
576: WHERE upper(name) = upper(p_termid);
577: ELSE
578: l_term_id := null;
579: END IF;