APPS.ETRM_FNDNAV dependencies on FND_ETRM_FILES

Line 251: from fnd_etrm_files f

247:
248: cursor cur_files(c_name in dba_objects.object_name%type := '%'
249: , n_appid in number) is
250: select count(f.file_id) id_count
251: from fnd_etrm_files f
252: where f.application_id = n_appid
253: and upper(f.file_name) like c_name ESCAPE '\';
254:
255: cursor cur_views(c_name in dba_objects.object_name%type := '%'

Line 502: from fnd_etrm_files f

498: cursor cur_files(c_name in dba_objects.object_name%type := '%'
499: , n_appid in number) is
500: select f.file_id id
501: , f.file_name name
502: from fnd_etrm_files f
503: where f.application_id = n_appid
504: and upper(f.file_name) like c_name ESCAPE '\'
505: order by file_name;
506:

Line 1581: from fnd_etrm_files

1577: , FILE_NAME
1578: , FILE_TYPE
1579: , DESCRIPTION
1580: , dbms_lob.getlength(FILE_CONTENT) file_length
1581: from fnd_etrm_files
1582: where file_id = n_fileid;
1583:
1584:
1585:

Line 1640: PROCEDURE show_file(n_file_id IN fnd_etrm_files.file_id%type

1636:
1637: -----------------------------------------------------------------------------
1638: -- Public Procedures
1639: -----------------------------------------------------------------------------
1640: PROCEDURE show_file(n_file_id IN fnd_etrm_files.file_id%type
1641: , c_mode in varchar2 := 'ATTACH')
1642: is
1643: cursor cur_get_lob(n_file_id IN fnd_etrm_files.file_id%type)
1644: is

Line 1643: cursor cur_get_lob(n_file_id IN fnd_etrm_files.file_id%type)

1639: -----------------------------------------------------------------------------
1640: PROCEDURE show_file(n_file_id IN fnd_etrm_files.file_id%type
1641: , c_mode in varchar2 := 'ATTACH')
1642: is
1643: cursor cur_get_lob(n_file_id IN fnd_etrm_files.file_id%type)
1644: is
1645: select file_content
1646: , file_name
1647: , file_content_type

Line 1648: from fnd_etrm_files

1644: is
1645: select file_content
1646: , file_name
1647: , file_content_type
1648: from fnd_etrm_files
1649: where file_id = n_file_id;
1650:
1651: buffer raw(32767);
1652: amount binary_integer := 32767;