eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ETRM_FNDNAV dependencies on DBA_OBJECTS

Line 152: , c_name in dba_objects.object_name%type := '%'

148:
149: end quick_list;
150:
151: procedure draw_form(n_appid in number := NULL
152: , c_name in dba_objects.object_name%type := '%'
153: , c_type in dba_objects.object_type%type := '%')
154: is
155:
156: cursor cur_apps

Line 153: , c_type in dba_objects.object_type%type := '%')

149: end quick_list;
150:
151: procedure draw_form(n_appid in number := NULL
152: , c_name in dba_objects.object_name%type := '%'
153: , c_type in dba_objects.object_type%type := '%')
154: is
155:
156: cursor cur_apps
157: is

Line 236: , c_name in dba_objects.object_name%type := '%'

232: end draw_form;
233:
234:
235: procedure ls_app_itemcount(n_appid in number := NULL
236: , c_name in dba_objects.object_name%type := '%'
237: , c_type in dba_objects.object_type%type := '%') is
238:
239:
240: cursor cur_tables(c_name in dba_objects.object_name%type := '%'

Line 237: , c_type in dba_objects.object_type%type := '%') is

233:
234:
235: procedure ls_app_itemcount(n_appid in number := NULL
236: , c_name in dba_objects.object_name%type := '%'
237: , c_type in dba_objects.object_type%type := '%') is
238:
239:
240: cursor cur_tables(c_name in dba_objects.object_name%type := '%'
241: , n_appid in number) is

Line 240: cursor cur_tables(c_name in dba_objects.object_name%type := '%'

236: , c_name in dba_objects.object_name%type := '%'
237: , c_type in dba_objects.object_type%type := '%') is
238:
239:
240: cursor cur_tables(c_name in dba_objects.object_name%type := '%'
241: , n_appid in number) is
242: select count(t.table_id) id_count
243: from fnd_tables t
244: where t.application_id = n_appid

Line 248: cursor cur_files(c_name in dba_objects.object_name%type := '%'

244: where t.application_id = n_appid
245: and t.table_name like c_name ESCAPE '\';
246:
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

Line 255: cursor cur_views(c_name in dba_objects.object_name%type := '%'

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 := '%'
256: , n_appid in number) is
257: select count(v.view_id) id_count
258: from fnd_views v
259: where v.application_id = n_appid

Line 262: cursor cur_concurrent(c_name in dba_objects.object_name%type := '%'

258: from fnd_views v
259: where v.application_id = n_appid
260: and v.view_name like c_name ESCAPE '\';
261:
262: cursor cur_concurrent(c_name in dba_objects.object_name%type := '%'
263: , n_appid in number) is
264: select count(c.application_id) id_count
265: from fnd_concurrent_programs c
266: where c.application_id = n_appid

Line 269: cursor cur_lookup(c_name in dba_objects.object_name%type := '%'

265: from fnd_concurrent_programs c
266: where c.application_id = n_appid
267: and c.concurrent_program_name like c_name ESCAPE '\';
268:
269: cursor cur_lookup(c_name in dba_objects.object_name%type := '%'
270: , n_appid in number) is
271: select count(c.application_id) id_count
272: from fnd_lookup_types c
273: where c.application_id = n_appid

Line 276: cursor cur_event(c_name in dba_objects.object_name%type := '%'

272: from fnd_lookup_types c
273: where c.application_id = n_appid
274: and c.lookup_type like c_name ESCAPE '\';
275:
276: cursor cur_event(c_name in dba_objects.object_name%type := '%'
277: , n_appid in number) is
278: select count(e.name) id_count
279: from wf_events e
280: , fnd_application a

Line 418: , c_name in dba_objects.object_name%type := '%'

414:
415: end ls_app_itemcount;
416:
417: procedure ls_count(n_appid in number := NULL
418: , c_name in dba_objects.object_name%type := '%'
419: , c_type in dba_objects.object_type%type := '%') is
420:
421: cursor cur_apps is
422: select application_id

Line 419: , c_type in dba_objects.object_type%type := '%') is

415: end ls_app_itemcount;
416:
417: procedure ls_count(n_appid in number := NULL
418: , c_name in dba_objects.object_name%type := '%'
419: , c_type in dba_objects.object_type%type := '%') is
420:
421: cursor cur_apps is
422: select application_id
423: from fnd_application

Line 433: v_owner dba_objects.owner%type;

429:
430:
431:
432: v_name varchar2(80);
433: v_owner dba_objects.owner%type;
434: v_type dba_objects.object_type%type;
435: l_method varchar2(100) := 'ls_count';
436:
437:

Line 434: v_type dba_objects.object_type%type;

430:
431:
432: v_name varchar2(80);
433: v_owner dba_objects.owner%type;
434: v_type dba_objects.object_type%type;
435: l_method varchar2(100) := 'ls_count';
436:
437:
438: begin

Line 476: , c_name in dba_objects.object_name%type := '%'

472: uiutil.cabo6;
473: end ls_count;
474:
475: procedure ls_product(n_appid in number := NULL
476: , c_name in dba_objects.object_name%type := '%'
477: , c_type in dba_objects.object_type%type := '%') is
478:
479: cursor cur_tables(c_name in dba_objects.object_name%type := '%'
480: , n_appid in number) is

Line 477: , c_type in dba_objects.object_type%type := '%') is

473: end ls_count;
474:
475: procedure ls_product(n_appid in number := NULL
476: , c_name in dba_objects.object_name%type := '%'
477: , c_type in dba_objects.object_type%type := '%') is
478:
479: cursor cur_tables(c_name in dba_objects.object_name%type := '%'
480: , n_appid in number) is
481: select t.table_id id

Line 479: cursor cur_tables(c_name in dba_objects.object_name%type := '%'

475: procedure ls_product(n_appid in number := NULL
476: , c_name in dba_objects.object_name%type := '%'
477: , c_type in dba_objects.object_type%type := '%') is
478:
479: cursor cur_tables(c_name in dba_objects.object_name%type := '%'
480: , n_appid in number) is
481: select t.table_id id
482: , t.table_name name
483: from fnd_tables t

Line 489: cursor cur_views(c_name in dba_objects.object_name%type := '%'

485: and t.table_name like c_name ESCAPE '\'
486: order by table_name;
487:
488:
489: cursor cur_views(c_name in dba_objects.object_name%type := '%'
490: , n_appid in number) is
491: select v.view_id id
492: , v.view_name name
493: from fnd_views v

Line 498: cursor cur_files(c_name in dba_objects.object_name%type := '%'

494: where v.application_id = n_appid
495: and v.view_name like c_name ESCAPE '\'
496: order by view_name;
497:
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

Line 507: cursor cur_concurrent(c_name in dba_objects.object_name%type := '%'

503: where f.application_id = n_appid
504: and upper(f.file_name) like c_name ESCAPE '\'
505: order by file_name;
506:
507: cursor cur_concurrent(c_name in dba_objects.object_name%type := '%'
508: , n_appid in number) is
509: select c.concurrent_program_id id
510: , c.concurrent_program_name name
511: from fnd_concurrent_programs c

Line 516: cursor cur_lookup(c_name in dba_objects.object_name%type := '%'

512: where c.application_id = n_appid
513: and c.concurrent_program_name like c_name ESCAPE '\'
514: order by c.concurrent_program_name;
515:
516: cursor cur_lookup(c_name in dba_objects.object_name%type := '%'
517: , n_appid in number) is
518: select v.lookup_type id
519: , v.lookup_type name
520: from fnd_lookup_types v

Line 525: cursor cur_event(c_name in dba_objects.object_name%type := '%'

521: where v.application_id = n_appid
522: and v.lookup_type like c_name ESCAPE '\'
523: order by lookup_type;
524:
525: cursor cur_event(c_name in dba_objects.object_name%type := '%'
526: , n_appid in number) is
527: select e.name
528: , e.guid id
529: from wf_events e

Line 536: cursor cur_tables_and_views(c_name in dba_objects.object_name%type := '%'

532: and e.owner_tag = a.application_short_name
533: and e.name like c_name ESCAPE '\';
534:
535:
536: cursor cur_tables_and_views(c_name in dba_objects.object_name%type := '%'
537: , n_appid in number) is
538: select t.table_id id
539: , t.table_name name
540: , 'TABLE' o_type

Line 1754: , c_name in dba_objects.object_name%type := '%'

1750: -- draw_form;
1751: uiutil.cabo6;
1752: end ls_apps;
1753: procedure ls_object(n_appid in number := NULL
1754: , c_name in dba_objects.object_name%type := '%'
1755: , c_type in dba_objects.object_type%type := '%') is
1756:
1757: v_context varchar2(1024);
1758: v_name dba_objects.object_name%type;

Line 1755: , c_type in dba_objects.object_type%type := '%') is

1751: uiutil.cabo6;
1752: end ls_apps;
1753: procedure ls_object(n_appid in number := NULL
1754: , c_name in dba_objects.object_name%type := '%'
1755: , c_type in dba_objects.object_type%type := '%') is
1756:
1757: v_context varchar2(1024);
1758: v_name dba_objects.object_name%type;
1759: v_type dba_objects.object_type%type;

Line 1758: v_name dba_objects.object_name%type;

1754: , c_name in dba_objects.object_name%type := '%'
1755: , c_type in dba_objects.object_type%type := '%') is
1756:
1757: v_context varchar2(1024);
1758: v_name dba_objects.object_name%type;
1759: v_type dba_objects.object_type%type;
1760: l_method varchar2(100) := 'ls_object';
1761: begin
1762:

Line 1759: v_type dba_objects.object_type%type;

1755: , c_type in dba_objects.object_type%type := '%') is
1756:
1757: v_context varchar2(1024);
1758: v_name dba_objects.object_name%type;
1759: v_type dba_objects.object_type%type;
1760: l_method varchar2(100) := 'ls_object';
1761: begin
1762:
1763: v_context := 'n_appid=' ||n_appid||

Line 1819: , c_type in dba_objects.object_type%type := '%')

1815: end ls_object;
1816:
1817: procedure show_object(n_tabid in varchar2
1818: , n_appid in number
1819: , c_type in dba_objects.object_type%type := '%')
1820: -- n_tabid datatype is varchar because lookup types do not have a numeric id
1821: is
1822: begin
1823: uiutil.cabo1(c_title=>'FND Design Data');

Line 1850: function get_owner(c_name in dba_objects.object_name%type

1846: uiutil.prn_copyright;
1847: htp.p('');
1848: end show_object;
1849:
1850: function get_owner(c_name in dba_objects.object_name%type
1851: , c_type in dba_objects.object_type%type)
1852: return varchar2 is
1853:
1854: cursor cur_table(c_name in dba_objects.object_name%type)

Line 1851: , c_type in dba_objects.object_type%type)

1847: htp.p('');
1848: end show_object;
1849:
1850: function get_owner(c_name in dba_objects.object_name%type
1851: , c_type in dba_objects.object_type%type)
1852: return varchar2 is
1853:
1854: cursor cur_table(c_name in dba_objects.object_name%type)
1855: is

Line 1854: cursor cur_table(c_name in dba_objects.object_name%type)

1850: function get_owner(c_name in dba_objects.object_name%type
1851: , c_type in dba_objects.object_type%type)
1852: return varchar2 is
1853:
1854: cursor cur_table(c_name in dba_objects.object_name%type)
1855: is
1856: select decode(app.application_short_name, 'SQLAP', 'AP'
1857: , 'SQLGL', 'GL'
1858: , app.application_short_name) application_short_name

Line 1865: cursor cur_view(c_name in dba_objects.object_name%type)

1861: where table_name = c_name
1862: and t.application_id = app.application_id;
1863:
1864:
1865: cursor cur_view(c_name in dba_objects.object_name%type)
1866: is
1867: select decode(app.application_short_name, 'SQLAP', 'AP'
1868: , 'SQLGL', 'GL'
1869: , app.application_short_name) application_short_name