DBA Data[Home] [Help]

APPS.ETRM_SEARCH dependencies on FND_LOBS

Line 276: PROCEDURE show_file(n_file_id IN fnd_lobs.file_id%type)

272:
273: -----------------------------------------------------------------------------
274: -- Public Procedures
275: -----------------------------------------------------------------------------
276: PROCEDURE show_file(n_file_id IN fnd_lobs.file_id%type)
277: is
278: cursor cur_get_lob(n_file_id IN fnd_lobs.file_id%type)
279: is
280: select file_data

Line 278: cursor cur_get_lob(n_file_id IN fnd_lobs.file_id%type)

274: -- Public Procedures
275: -----------------------------------------------------------------------------
276: PROCEDURE show_file(n_file_id IN fnd_lobs.file_id%type)
277: is
278: cursor cur_get_lob(n_file_id IN fnd_lobs.file_id%type)
279: is
280: select file_data
281: , file_name
282: , file_content_type

Line 283: from fnd_lobs

279: is
280: select file_data
281: , file_name
282: , file_content_type
283: from fnd_lobs
284: where file_id = n_file_id;
285:
286: buffer raw(32767);
287: amount binary_integer := 32767;