APPS.HR_ADI_DOCUMENT_API dependencies on FND_LOBS

Line 207: -- function to convert a specified binary file in the fnd_lobs

203: -- ----------------------------------------------------------------------------
204: -- |---------------------------< DOCUMENT_TO_TEXT >---------------------------|
205: -- ----------------------------------------------------------------------------
206:
207: -- function to convert a specified binary file in the fnd_lobs
208: -- table to be converted into a clob
209: --
210: function document_to_text(p_file_id in varchar2, p_text_or_html varchar2) return clob is
211: --

Line 216: from fnd_lobs

212: l_clob clob;
213: --
214: cursor csr_file_exists(p_file_id varchar2) is
215: select rowid
216: from fnd_lobs
217: where file_id = p_file_id;
218: --
219: l_rowid rowid;
220: text boolean;

Line 238: --ctx_doc.filter(index_name => 'APPLSYS.FND_LOBS_CTX',

234: -- bug 3544676
235: -- disabled due to schema naming used directly
236: -- search feature not implemented via UI
237: --
238: --ctx_doc.filter(index_name => 'APPLSYS.FND_LOBS_CTX',
239: -- textkey => p_file_id,
240: -- restab => l_clob,
241: -- plaintext => text);
242: end if;

Line 251: -- Procedure to search for term in binary files stored in FND_LOBS

247: -- ----------------------------------------------------------------------------
248: -- |----------------------------< SEARCH_FOR_TERM >---------------------------|
249: -- ----------------------------------------------------------------------------
250: --
251: -- Procedure to search for term in binary files stored in FND_LOBS
252: -- the return value is a comma delimited string of the file_ids of the files
253: -- which contain the search term.
254: --
255: -- If no file type is specified a wildcard value is assumed.

Line 261: TYPE file_id IS TABLE OF fnd_lobs.file_id%type index by binary_integer;

257: function search_for_term(p_search_term in varchar2,
258: p_document_type in varchar2 default null)
259: return varchar2 is
260: --
261: TYPE file_id IS TABLE OF fnd_lobs.file_id%type index by binary_integer;
262: l_file_id file_id;
263:
264: -- Cursors
265: cursor csr_get_files(p_file_type varchar2) is

Line 267: from fnd_lobs

263:
264: -- Cursors
265: cursor csr_get_files(p_file_type varchar2) is
266: select file_id
267: from fnd_lobs
268: where program_name = 'HRMS_ADI'
269: and program_tag = upper(nvl(p_file_type, program_tag));
270:
271: -- Local variables