APPS.HR_ADI_DOCUMENT_API dependencies on HR_ADI_DOCUMENT_API

Line 1: Package Body HR_ADI_DOCUMENT_API as

1: Package Body HR_ADI_DOCUMENT_API as
2: /* $Header: hrlobapi.pkb 115.3 2004/03/31 06:21:37 menderby noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'HR_ADI_DOCUMENT_API.';

2: /* $Header: hrlobapi.pkb 115.3 2004/03/31 06:21:37 menderby noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'HR_ADI_DOCUMENT_API.';
7:
8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< CREATE_DOCUMENT >---------------------------|
10: -- ----------------------------------------------------------------------------

Line 287: l_clob := hr_adi_document_api.document_to_text(l_file_id(i), 'text');

283:
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;

Line 301: end HR_ADI_DOCUMENT_API;

297:
298: return l_foundlist;
299: end;
300:
301: end HR_ADI_DOCUMENT_API;