APPS.HR_ADI_DOCUMENT_API dependencies on DBMS_LOB

Line 288: if (dbms_lob.instr(l_clob, p_search_term, 1, 1) > 0) then

284: -- for each file of the designated type, convert the binary file into
285: -- plain text, then search for term.
286: for i in 1..l_rowcount loop
287: l_clob := hr_adi_document_api.document_to_text(l_file_id(i), 'text');
288: if (dbms_lob.instr(l_clob, p_search_term, 1, 1) > 0) then
289: l_foundlist := l_foundlist || l_file_id(i) || ', ';
290: end if;
291: end loop;
292: