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_PNAV dependencies on ETRM_PNAV

Line 1: package body etrm_pnav as

1: package body etrm_pnav as
2: ----------------------------------------------------------------------------
3: -- Copyright A? 2001, 2014, Oracle and/or its affiliates. All rights reserved.
4: -- eTRM: Oracle Applications repository browser and dependency report
5: -- Author: Peter Goldthorp 9 October 2001

Line 80: uiutil.render_tab(c_url => 'etrm_pnav.ls_apps'

76: , c_title => 'FND'
77: , c_position => 'LEFT'
78: , c_state => 'ENABLED');
79:
80: uiutil.render_tab(c_url => 'etrm_pnav.ls_apps'
81: , c_title => 'DBA'
82: , c_position => 'RIGHT'
83: , c_state => 'SELECTED');
84: -- htp.p('
');

Line 119: -- htp.p('
DBA Navigator Home');

115: and c_status = '%') then
116: htp.p('

Browse the online data dictionary of an Applications database

');
117: else
118: null;
119: -- htp.p('

DBA Navigator Home');
120: end if;
121:
122: htp.p('

');
123: htp.p('');

Line 122: htp.p('');

118: null;
119: -- htp.p('

Home DBA Navigator Home');
120: end if;
121:
122: htp.p('');
123: htp.p('

');
124:
125: htp.p(' ');
126: htp.p('');
669:
670: end if;
671: htp.p('');
675:
676: htp.p('');
675:
676: htp.p('');
680: htp.p('');
680: htp.p('');
680: htp.p('');

Line 694: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')

690:
691: v_first2 := TRUE;
692: htp.p('

');

Line 737: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')

733:
734: htp.p('');
735: htp.p('

');
739: htp.p('');

Line 740: htp.p(etrm_pnav.get_object_name(n_object_id, 'RAW'));

736: ||' ' 
737: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS') 
738: || ' ');
739: htp.p('

');
742: htp.p('');
743:
744: v_first2 := TRUE;

Line 747: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')

743:
744: v_first2 := TRUE;
745: htp.p('

Object Name like:

');

322: v_name := replace(v_name, '%23', '#');
323: v_httpname := replace(c_name, '%', '*');
324: v_httpname := replace(v_httpname, '#', '%23');
325: htp.p('

326: htp.p('
');

Line 338: , c_link => 'etrm_pnav.ls_object?c_name='

334: else
335: v_owner := a_rec.owner;
336: htp.p('

');
337: uiutil.a_href_gen(c_type => 'SCHEMA'
338: , c_link => 'etrm_pnav.ls_object?c_name='
339: || v_httpname
340: ||'&c_owner='
341: ||a_rec.owner
342: ||'&c_status='

Line 349: , c_link => 'etrm_pnav.ls_object?c_name='

345: htp.p('

');
348: uiutil.a_href_gen(c_type => a_rec.object_type
349: , c_link => 'etrm_pnav.ls_object?c_name='
350: || v_httpname
351: ||'&c_owner='
352: ||a_rec.owner
353: ||'&c_type='

Line 368: etrm_pnav.quick_list;

364: htp.p('

'||v_counter ||' objects

');
366:
367: uiutil.cabo4;
368: etrm_pnav.quick_list;
369: uiutil.cabo5;
370: -- draw_form(c_name, c_owner, c_type, c_status);
371: uiutil.cabo6;
372: end ls_count;

Line 402: etrm_pnav.draw_buttons;

398:
399: begin
400: uiutil.cabo1;
401: uiutil.cabo2a;
402: etrm_pnav.draw_buttons;
403: uiutil.cabo2b;
404: etrm_pnav.draw_tabs;
405: uiutil.cabo3;
406: htp.p('

'||c_type||'

');

Line 404: etrm_pnav.draw_tabs;

400: uiutil.cabo1;
401: uiutil.cabo2a;
402: etrm_pnav.draw_buttons;
403: uiutil.cabo2b;
404: etrm_pnav.draw_tabs;
405: uiutil.cabo3;
406: htp.p('

'||c_type||'

');
407: v_owner := 'foRce_mE_to_diff';
408: v_name := replace(c_name, '*', '%'); -- http drops trailing %

Line 415: htp.p('
');

411: v_httpname := replace(v_httpname, '#', '%23');
412:
413:
414: htp.p('

415: htp.p('
');

Line 427: , c_link => 'etrm_pnav.ls_object?c_name='

423: else
424: v_owner := a_rec.owner;
425: htp.p('

');
426: uiutil.a_href_gen(c_type => 'SCHEMA'
427: , c_link => 'etrm_pnav.ls_object?c_name='
428: || v_httpname
429: ||'&c_owner='
430: ||a_rec.owner
431: ||'&c_status='

Line 438: , c_link => 'etrm_pnav.show_object?c_name='

434: htp.p('

');
437: uiutil.a_javascript_gen(c_type => c_type
438: , c_link => 'etrm_pnav.show_object?c_name='
439: || replace(replace(a_rec.object_name, '#', '%23'),'+', '%2B')
440: ||'&c_owner='
441: ||a_rec.owner
442: ||'&c_type='

Line 452: etrm_pnav.quick_list;

448: htp.p('

'||v_counter ||' objects

');
450:
451: uiutil.cabo4;
452: etrm_pnav.quick_list;
453: uiutil.cabo5;
454: -- draw_form(c_name, c_owner, c_type, c_status);
455: uiutil.cabo6;
456: end ls_object_type;

Line 590: , c_link => 'etrm_pnav.show_details?c_name='

586:
587: if o_rec.status = 'INVALID' then
588: htp.p('

');
589: uiutil.a_href_gen(c_type => 'EXCEPTION'
590: , c_link => 'etrm_pnav.show_details?c_name='
591: ||c_name
592: ||'&c_owner='
593: ||c_owner
594: ||'&c_type='

Line 623: select etrm_pnav.get_object_name(robj#, 'RAW') table_name

619: -- fk details from sys.cdef$ because dba_constraints id slow
620:
621:
622: cursor cur_fk(n_object_id in dba_objects.object_id%type) is
623: select etrm_pnav.get_object_name(robj#, 'RAW') table_name
624: , robj# object_id
625: , con# cons_id
626: from sys.cdef$
627: where obj# = n_object_id

Line 629: order by etrm_pnav.get_object_name(robj#);

625: , con# cons_id
626: from sys.cdef$
627: where obj# = n_object_id
628: and robj# is not null
629: order by etrm_pnav.get_object_name(robj#);
630:
631: cursor cur_fk2(n_object_id in dba_objects.object_id%type) is
632: select etrm_pnav.get_object_name(obj#, 'RAW') table_name
633: , obj# object_id

Line 632: select etrm_pnav.get_object_name(obj#, 'RAW') table_name

628: and robj# is not null
629: order by etrm_pnav.get_object_name(robj#);
630:
631: cursor cur_fk2(n_object_id in dba_objects.object_id%type) is
632: select etrm_pnav.get_object_name(obj#, 'RAW') table_name
633: , obj# object_id
634: , con# cons_id
635: from sys.cdef$
636: where robj# = n_object_id

Line 637: order by etrm_pnav.get_object_name(obj#);

633: , obj# object_id
634: , con# cons_id
635: from sys.cdef$
636: where robj# = n_object_id
637: order by etrm_pnav.get_object_name(obj#);
638:
639:
640: cursor cur_list_cons_columns(cv_cons_name in dba_cons_columns.constraint_name%type
641: , c_owner in dba_objects.owner%type)

Line 672: v_table_name := etrm_pnav.get_object_name(n_object_id, 'RAW');

668:

Foreign Key Column

');
672: v_table_name := etrm_pnav.get_object_name(n_object_id, 'RAW');
673: htp.p(v_table_name);
674: htp.p('

Line 678: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')

674: htp.p('

'
677: ||' ' 
678: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS') 
679: || '

');
681: uiutil.a_href_gen(c_type => 'TABLE'
682: , c_link => 'etrm_pnav.show_object?c_name='

Line 682: , c_link => 'etrm_pnav.show_object?c_name='

678: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')
679: || '">

');
681: uiutil.a_href_gen(c_type => 'TABLE'
682: , c_link => 'etrm_pnav.show_object?c_name='
683: || etrm_pnav.get_object_name(key_rec.object_id, 'RAW')
684: ||'&c_owner='
685: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')
686: ||'&c_type=TABLE'

Line 683: || etrm_pnav.get_object_name(key_rec.object_id, 'RAW')

679: || '">

');
681: uiutil.a_href_gen(c_type => 'TABLE'
682: , c_link => 'etrm_pnav.show_object?c_name='
683: || etrm_pnav.get_object_name(key_rec.object_id, 'RAW')
684: ||'&c_owner='
685: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')
686: ||'&c_type=TABLE'
687: , c_display => key_rec.table_name);

Line 685: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')

681: uiutil.a_href_gen(c_type => 'TABLE'
682: , c_link => 'etrm_pnav.show_object?c_name='
683: || etrm_pnav.get_object_name(key_rec.object_id, 'RAW')
684: ||'&c_owner='
685: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')
686: ||'&c_type=TABLE'
687: , c_display => key_rec.table_name);
688:
689: htp.p('

');
693: for key_col in cur_list_cons_columns(
694: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')
695: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop
696: if v_first2 = TRUE
697: then v_first2 := FALSE;
698: else

Line 695: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop

691: v_first2 := TRUE;
692: htp.p('

');
693: for key_col in cur_list_cons_columns(
694: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')
695: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop
696: if v_first2 = TRUE
697: then v_first2 := FALSE;
698: else
699: htp.p('
');

Line 727: , c_link => 'etrm_pnav.show_object?c_name='

723:
724: htp.p('

');
725: v_table_name := key_rec.table_name;
726: uiutil.a_href_gen(c_type => 'TABLE'
727: , c_link => 'etrm_pnav.show_object?c_name='
728: || etrm_pnav.get_object_name(key_rec.object_id, 'ITEM')
729: ||'&c_owner='
730: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')
731: ||'&c_type=TABLE'

Line 728: || etrm_pnav.get_object_name(key_rec.object_id, 'ITEM')

724: htp.p('

');
725: v_table_name := key_rec.table_name;
726: uiutil.a_href_gen(c_type => 'TABLE'
727: , c_link => 'etrm_pnav.show_object?c_name='
728: || etrm_pnav.get_object_name(key_rec.object_id, 'ITEM')
729: ||'&c_owner='
730: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')
731: ||'&c_type=TABLE'
732: , c_display => key_rec.table_name);

Line 730: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')

726: uiutil.a_href_gen(c_type => 'TABLE'
727: , c_link => 'etrm_pnav.show_object?c_name='
728: || etrm_pnav.get_object_name(key_rec.object_id, 'ITEM')
729: ||'&c_owner='
730: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')
731: ||'&c_type=TABLE'
732: , c_display => key_rec.table_name);
733:
734: htp.p('

'
736: ||' ' 
737: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS') 
738: || '

');
740: htp.p(etrm_pnav.get_object_name(n_object_id, 'RAW'));
741: htp.p('

');
740: htp.p(etrm_pnav.get_object_name(n_object_id, 'RAW'));
741: htp.p('

');
746: for key_col in cur_list_cons_columns(
747: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')
748: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop
749: if v_first2 = TRUE
750: then v_first2 := FALSE;
751: else

Line 748: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop

744: v_first2 := TRUE;
745: htp.p('

');
746: for key_col in cur_list_cons_columns(
747: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')
748: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop
749: if v_first2 = TRUE
750: then v_first2 := FALSE;
751: else
752: htp.p('
');

Line 1225: , c_link => 'etrm_pnav.show_object?c_name='|| t_rec.table_name

1221: 1222: summary="dba_types information">
1223:
Base Object: ');
1224: uiutil.a_href_gen(c_type => t_rec.base_object_type
1225: , c_link => 'etrm_pnav.show_object?c_name='|| t_rec.table_name
1226: ||'&c_owner='|| t_rec.table_owner
1227: ||'&c_type='|| t_rec.base_object_type
1228: , c_display => t_rec.table_owner||'.'||t_rec.table_name);
1229:

Line 1257: , c_link => 'etrm_pnav.show_object?c_name='|| t_rec.table_name

1253: 1254: summary="dba_types information">
1255:
1501:
Base Object: ');
1256: uiutil.a_href_gen(c_type => t_rec.table_type
1257: , c_link => 'etrm_pnav.show_object?c_name='|| t_rec.table_name
1258: ||'&c_owner='|| t_rec.table_owner
1259: ||'&c_type='|| t_rec.table_type
1260: , c_display => t_rec.table_owner||'.'||t_rec.table_name);
1261:

Line 1469: , c_link => 'etrm_pnav.show_object?c_name='|| c_rec.elem_type_name

1465:
1466:
Element Type: ');
1467: if c_rec.elem_type_owner is not null then
1468: uiutil.a_href_gen(c_type => 'TYPE'
1469: , c_link => 'etrm_pnav.show_object?c_name='|| c_rec.elem_type_name
1470: ||'&c_owner='||c_rec.ELEM_TYPE_OWNER
1471: ||'&c_type=TYPE'
1472: , c_display => c_rec.elem_type_name);
1473: else

Line 1504: , c_link => 'etrm_pnav.show_object?c_name='|| a_rec.attr_type_name

1500: ||a_rec.attr_name||'
');
1502: if a_rec.ATTR_TYPE_OWNER is not null then
1503: uiutil.a_href_gen(c_type => 'TYPE'
1504: , c_link => 'etrm_pnav.show_object?c_name='|| a_rec.attr_type_name
1505: ||'&c_owner='||a_rec.ATTR_TYPE_OWNER
1506: ||'&c_type=TYPE'
1507: , c_display => a_rec.attr_type_name);
1508: else

Line 1586: , etrm_pnav.get_object_name(d_obj#, 'USER') owner

1582:
1583:
1584: cursor cur_depend(n_object_id IN dba_objects.object_id%type)
1585: is select d_obj# object_id
1586: , etrm_pnav.get_object_name(d_obj#, 'USER') owner
1587: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item
1588: from sys.dependency$
1589: where p_obj# = n_object_id
1590: order by etrm_pnav.get_object_name(d_obj#);

Line 1587: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item

1583:
1584: cursor cur_depend(n_object_id IN dba_objects.object_id%type)
1585: is select d_obj# object_id
1586: , etrm_pnav.get_object_name(d_obj#, 'USER') owner
1587: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item
1588: from sys.dependency$
1589: where p_obj# = n_object_id
1590: order by etrm_pnav.get_object_name(d_obj#);
1591: --

Line 1590: order by etrm_pnav.get_object_name(d_obj#);

1586: , etrm_pnav.get_object_name(d_obj#, 'USER') owner
1587: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item
1588: from sys.dependency$
1589: where p_obj# = n_object_id
1590: order by etrm_pnav.get_object_name(d_obj#);
1591: --
1592: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)
1593: is select p_obj# object_id
1594: , etrm_pnav.get_object_name(p_obj#, 'USER') owner

Line 1594: , etrm_pnav.get_object_name(p_obj#, 'USER') owner

1590: order by etrm_pnav.get_object_name(d_obj#);
1591: --
1592: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)
1593: is select p_obj# object_id
1594: , etrm_pnav.get_object_name(p_obj#, 'USER') owner
1595: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item
1596: from sys.dependency$
1597: where d_obj# = n_object_id
1598: order by etrm_pnav.get_object_name(p_obj#);

Line 1595: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item

1591: --
1592: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)
1593: is select p_obj# object_id
1594: , etrm_pnav.get_object_name(p_obj#, 'USER') owner
1595: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item
1596: from sys.dependency$
1597: where d_obj# = n_object_id
1598: order by etrm_pnav.get_object_name(p_obj#);
1599:

Line 1598: order by etrm_pnav.get_object_name(p_obj#);

1594: , etrm_pnav.get_object_name(p_obj#, 'USER') owner
1595: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item
1596: from sys.dependency$
1597: where d_obj# = n_object_id
1598: order by etrm_pnav.get_object_name(p_obj#);
1599:
1600: v_first boolean;
1601: v_owner dba_objects.owner%type;
1602:

Line 1611: htp.p(''||etrm_pnav.get_object_name(n_object_id)

1607:
[top of page]
');
1608:
1609: for a_rec in cur_depend2(n_object_id) loop
1610: IF v_first Then
1611: htp.p(''||etrm_pnav.get_object_name(n_object_id)
1612: || ' references the following:
');
1613: htp.p('
');
1614: v_first := FALSE;
1615: end if;

Line 1634: , c_link => 'etrm_pnav.show_dependent_code?n_object_id='

1630: a_href_gen(a_rec.object_id);
1631: if get_object_name(a_rec.object_id, 'TYPE') in ('PACKAGE', 'PACKAGE BODY', 'PROCEDURE')
1632: then htp.prn(' - ');
1633: uiutil.a_href_gen(c_type => 'NONE'
1634: , c_link => 'etrm_pnav.show_dependent_code?n_object_id='
1635: || n_object_id
1636: || '&c_name='
1637: || get_object_name(a_rec.object_id, 'ITEM')
1638: , c_display => ' show dependent code');

Line 1647: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');

1643: end loop;
1644:
1645:
1646: IF v_first Then
1647: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');
1648: else
1649: htp.p('
');
1650: v_first := TRUE;
1651: end if;

Line 1659: htp.p(''||etrm_pnav.get_object_name(n_object_id)

1655: v_owner := 'foRce_mE_to_diff';
1656:
1657: for a_rec in cur_depend(n_object_id) loop
1658: IF v_first Then
1659: htp.p(''||etrm_pnav.get_object_name(n_object_id)
1660: || ' is referenced by following:
');
1661: htp.p('
');
1662: v_first := FALSE;
1663: end if;

Line 1681: , c_link => 'etrm_pnav.show_dependent_code?n_object_id='

1677: a_href_gen(a_rec.object_id);
1678: if get_object_name(a_rec.object_id, 'TYPE') in ('PACKAGE', 'PACKAGE BODY', 'PROCEDURE')
1679: then htp.prn(' - ');
1680: uiutil.a_href_gen(c_type => 'NONE'
1681: , c_link => 'etrm_pnav.show_dependent_code?n_object_id='
1682: || a_rec.object_id
1683: || '&c_name='
1684: || get_object_name(n_object_id, 'ITEM')
1685: , c_display => ' show dependent code');

Line 1693: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');

1689: end loop;
1690:
1691:
1692: IF v_first Then
1693: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');
1694: else
1695: htp.p('
');
1696: v_first := TRUE;
1697: end if;

Line 1906: etrm_pnav.draw_buttons;

1902: begin
1903:
1904: uiutil.cabo1;
1905: uiutil.cabo2a;
1906: etrm_pnav.draw_buttons;
1907: uiutil.cabo2b;
1908: etrm_pnav.draw_tabs;
1909: uiutil.cabo3;
1910:

Line 1908: etrm_pnav.draw_tabs;

1904: uiutil.cabo1;
1905: uiutil.cabo2a;
1906: etrm_pnav.draw_buttons;
1907: uiutil.cabo2b;
1908: etrm_pnav.draw_tabs;
1909: uiutil.cabo3;
1910:
1911: htp.p('
DBA Objects
');
1912: htp.p('
');

Line 1916: , c_link => 'etrm_pnav.ls_apps?c_mode=APPS'

1912: htp.p('
');
1913:
1914: htp.p('
');
1915: uiutil.a_href_gen(c_type => 'APP'
1916: , c_link => 'etrm_pnav.ls_apps?c_mode=APPS'
1917: , c_display => 'Applications Product Prefixes');
1918: htp.p('
');
1919: htp.p('
');
1920: uiutil.a_href_gen(c_type => 'APP'

Line 1921: , c_link => 'etrm_pnav.ls_apps?c_mode=USER'

1917: , c_display => 'Applications Product Prefixes');
1918: htp.p('
');
1919: htp.p('
');
1920: uiutil.a_href_gen(c_type => 'APP'
1921: , c_link => 'etrm_pnav.ls_apps?c_mode=USER'
1922: , c_display => 'Database Schemas');
1923: htp.p('
');
1924:
1925: htp.p('
');

Line 1928: etrm_pnav.quick_list;

1924:
1925: htp.p('
');
1926:
1927: uiutil.cabo4;
1928: etrm_pnav.quick_list;
1929: uiutil.cabo5;
1930: -- draw_form;
1931: uiutil.cabo6;
1932: end ls_apps;

Line 1988: etrm_pnav.draw_buttons;

1984: end loop;
1985:
1986: uiutil.cabo1;
1987: uiutil.cabo2a;
1988: etrm_pnav.draw_buttons;
1989: uiutil.cabo2b;
1990: etrm_pnav.draw_tabs;
1991: uiutil.cabo3;
1992: if vapps_installation then

Line 1990: etrm_pnav.draw_tabs;

1986: uiutil.cabo1;
1987: uiutil.cabo2a;
1988: etrm_pnav.draw_buttons;
1989: uiutil.cabo2b;
1990: etrm_pnav.draw_tabs;
1991: uiutil.cabo3;
1992: if vapps_installation then
1993:
1994: htp.p('
');

Line 1995: htp.p('

1991: uiutil.cabo3;
1992: if vapps_installation then
1993:
1994: htp.p('
');
1995: htp.p('

1996: Applications Product Prefixes
');
1997: open fnd_cv for sql_stmt;
1998: loop
1999: fetch fnd_cv into fnd_name, fnd_title;

Line 2004: , c_link => 'etrm_pnav.ls_object?c_name='

2000: exit when fnd_cv%NOTFOUND;
2001: vsearch_name := fnd_name ||'\_*';
2002: htp.p('
');
2003: uiutil.a_href_gen(c_type => 'APP'
2004: , c_link => 'etrm_pnav.ls_object?c_name='
2005: || vsearch_name
2006: , c_display => fnd_name||' - '||fnd_title);
2007:
2008: htp.p('
');

Line 2016: htp.p('

2012: htp.p('
');
2013: else
2014:
2015: htp.p('
');
2016: htp.p('

2017: Database Schemas
');
2018: for s_rec in cur_schema loop
2019:
2020: htp.p('
');

Line 2022: , c_link => 'etrm_pnav.ls_object?c_name=*'

2018: for s_rec in cur_schema loop
2019:
2020: htp.p('
');
2021: uiutil.a_href_gen(c_type => 'APP'
2022: , c_link => 'etrm_pnav.ls_object?c_name=*'
2023: ||'&c_owner='
2024: ||s_rec.username
2025: , c_display => s_rec.username);
2026:

Line 2032: etrm_pnav.quick_list;

2028: end loop;
2029: htp.p('
');
2030: end if;
2031: uiutil.cabo4;
2032: etrm_pnav.quick_list;
2033: uiutil.cabo5;
2034: -- draw_form;
2035: uiutil.cabo6;
2036: end ls_apps;

Line 2070: owa_cookie.send('etrm_pnav_context', v_context);

2066: -- This wraps the following packages in an HTTP header
2067: owa_util.mime_header('text/html', FALSE);
2068:
2069: -- Send some value to the target cookie for the next browser call
2070: owa_cookie.send('etrm_pnav_context', v_context);
2071:
2072: -- Note: The following would cause the target cookie to expire
2073: -- owa_cookie.remove('etrm_pnav_context');
2074:

Line 2073: -- owa_cookie.remove('etrm_pnav_context');

2069: -- Send some value to the target cookie for the next browser call
2070: owa_cookie.send('etrm_pnav_context', v_context);
2071:
2072: -- Note: The following would cause the target cookie to expire
2073: -- owa_cookie.remove('etrm_pnav_context');
2074:
2075: owa_util.http_header_close;
2076:
2077: if (v_name = '%'

Line 2118: htp.p('

Line 2124: htp.p('[Package]');
2124: htp.p(' 2129: ||'&c_detail_type=source">[Package Body]');
2130: htp.p('[SQL Statements]');
2133: htp.p('
');
2134:

Line 2139: htp.p('');
2146: elsif (c_type = 'TABLE')
2147: then
2148: ls_table(c_name, c_owner);
2149: etrm_pnav.ls_table(v_object_id);
2150: ls_columns(c_name, c_owner);
2151: elsif (c_type = 'VIEW')
2152: then ls_table(c_name, c_owner);
2153: htp.p('
2152: then ls_table(c_name, c_owner);
2153: htp.p('
2162: then
2163: ls_mview(c_name, c_owner);
2164: htp.p('
2173: then
2174: ls_trigger(c_name, c_owner);
2175: htp.p('

APPS.ETRM_PNAV dependencies on ETRM_PNAV

Line 1: package body etrm_pnav as

Line 80: uiutil.render_tab(c_url => 'etrm_pnav.ls_apps'

Line 119: -- htp.p('DBA Navigator Home');

Line 122: htp.p('');

Line 338: , c_link => 'etrm_pnav.ls_object?c_name='

Line 349: , c_link => 'etrm_pnav.ls_object?c_name='

Line 368: etrm_pnav.quick_list;

Line 402: etrm_pnav.draw_buttons;

'||c_type||'

Line 404: etrm_pnav.draw_tabs;

'||c_type||'

Line 415: htp.p('');

Line 427: , c_link => 'etrm_pnav.ls_object?c_name='

Line 438: , c_link => 'etrm_pnav.show_object?c_name='

Line 452: etrm_pnav.quick_list;

Line 590: , c_link => 'etrm_pnav.show_details?c_name='

Line 623: select etrm_pnav.get_object_name(robj#, 'RAW') table_name

Line 629: order by etrm_pnav.get_object_name(robj#);

Line 632: select etrm_pnav.get_object_name(obj#, 'RAW') table_name

Line 637: order by etrm_pnav.get_object_name(obj#);

Line 672: v_table_name := etrm_pnav.get_object_name(n_object_id, 'RAW');

Line 678: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')

Line 682: , c_link => 'etrm_pnav.show_object?c_name='

Line 683: || etrm_pnav.get_object_name(key_rec.object_id, 'RAW')

Line 685: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')

Line 694: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')

Line 695: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop

Line 727: , c_link => 'etrm_pnav.show_object?c_name='

Line 728: || etrm_pnav.get_object_name(key_rec.object_id, 'ITEM')

Line 730: || etrm_pnav.get_object_name(key_rec.object_id, 'USER')

Line 737: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')

Line 740: htp.p(etrm_pnav.get_object_name(n_object_id, 'RAW'));

Line 747: cv_cons_name => etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')

Line 748: , c_owner=>etrm_pnav.get_object_name(key_rec.object_id, 'USER')) loop

Line 1225: , c_link => 'etrm_pnav.show_object?c_name='|| t_rec.table_name

Line 1257: , c_link => 'etrm_pnav.show_object?c_name='|| t_rec.table_name

Line 1469: , c_link => 'etrm_pnav.show_object?c_name='|| c_rec.elem_type_name

Line 1504: , c_link => 'etrm_pnav.show_object?c_name='|| a_rec.attr_type_name

Line 1586: , etrm_pnav.get_object_name(d_obj#, 'USER') owner

Line 1587: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item

Line 1590: order by etrm_pnav.get_object_name(d_obj#);

Line 1594: , etrm_pnav.get_object_name(p_obj#, 'USER') owner

Line 1595: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item

Line 1598: order by etrm_pnav.get_object_name(p_obj#);

Line 1611: htp.p(''||etrm_pnav.get_object_name(n_object_id)

Line 1634: , c_link => 'etrm_pnav.show_dependent_code?n_object_id='

Line 1647: htp.p(''||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object');

Line 1659: htp.p(''||etrm_pnav.get_object_name(n_object_id)

Line 1681: , c_link => 'etrm_pnav.show_dependent_code?n_object_id='

Line 1693: htp.p(''||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object');

Line 1906: etrm_pnav.draw_buttons;

Line 1908: etrm_pnav.draw_tabs;

DBA Objects

Line 1916: , c_link => 'etrm_pnav.ls_apps?c_mode=APPS'

Line 1921: , c_link => 'etrm_pnav.ls_apps?c_mode=USER'

Line 1928: etrm_pnav.quick_list;

Line 1988: etrm_pnav.draw_buttons;

Line 1990: etrm_pnav.draw_tabs;

Line 1995: htp.p('

Line 2004: , c_link => 'etrm_pnav.ls_object?c_name='

Line 2016: htp.p('

Line 2022: , c_link => 'etrm_pnav.ls_object?c_name=*'

Line 2032: etrm_pnav.quick_list;

Line 2070: owa_cookie.send('etrm_pnav_context', v_context);

Line 2073: -- owa_cookie.remove('etrm_pnav_context');

Line 119: -- htp.p('
DBA Navigator Home');

Line 415: htp.p('
');

Line 1647: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' does not reference any database object
');

Line 1693: htp.p('
'||etrm_pnav.get_object_name(n_object_id)|| ' is not referenced by any database object
');