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);
569: l_syncind := UPPER(p_syncind);
570: IF p_termid IS NOT NULL THEN
571: SELECT term_id
572: INTO l_term_id
573: FROM ap_terms
574: WHERE upper(name) = upper(p_termid);
575: ELSE
576: l_term_id := null;
577: END IF;