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 UIUTIL

Line 39: uiutil.a_href_gen(c_link => 'etrm_search.search'

35:
36: procedure draw_buttons
37: is
38: begin
39: uiutil.a_href_gen(c_link => 'etrm_search.search'
40: , c_display => 'Home');
41: -- uiutil.a_href_gen(c_link => 'https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_logout?p_done_url=http://etrm.oracle.com/'
42: -- , c_display => 'Sign out');
43: uiutil.a_javascript_gen(c_link => 'etrm_search.help'

Line 41: -- uiutil.a_href_gen(c_link => 'https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_logout?p_done_url=http://etrm.oracle.com/'

37: is
38: begin
39: uiutil.a_href_gen(c_link => 'etrm_search.search'
40: , c_display => 'Home');
41: -- uiutil.a_href_gen(c_link => 'https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_logout?p_done_url=http://etrm.oracle.com/'
42: -- , c_display => 'Sign out');
43: uiutil.a_javascript_gen(c_link => 'etrm_search.help'
44: , c_display => 'Help');
45: end draw_buttons;

Line 43: uiutil.a_javascript_gen(c_link => 'etrm_search.help'

39: uiutil.a_href_gen(c_link => 'etrm_search.search'
40: , c_display => 'Home');
41: -- uiutil.a_href_gen(c_link => 'https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_logout?p_done_url=http://etrm.oracle.com/'
42: -- , c_display => 'Sign out');
43: uiutil.a_javascript_gen(c_link => 'etrm_search.help'
44: , c_display => 'Help');
45: end draw_buttons;
46:
47: procedure draw_tabs

Line 70: -- uiutil.render_tab(c_url => v_search_url

66: end if;
67:
68:
69:
70: -- uiutil.render_tab(c_url => v_search_url
71: -- , c_title => 'Search'
72: -- , c_position => 'LEFT'
73: -- , c_state => 'ENABLED');
74:

Line 75: uiutil.render_tab(c_url => v_fndnav_url

71: -- , c_title => 'Search'
72: -- , c_position => 'LEFT'
73: -- , c_state => 'ENABLED');
74:
75: uiutil.render_tab(c_url => v_fndnav_url
76: , c_title => 'FND'
77: , c_position => 'LEFT'
78: , c_state => 'ENABLED');
79:

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 274: uiutil.a_href_gen(c_type => o_rec.object_type

270: from dba_objects
271: where object_id = n_object_id;
272: begin
273: for o_rec in cur_object(n_object_id) loop
274: uiutil.a_href_gen(c_type => o_rec.object_type
275: , c_link => 'etrm_pnav.show_object?c_name='
276: ||replace(o_rec.object_name,'+','%2B')
277: ||'&c_owner='
278: ||o_rec.owner

Line 312: uiutil.cabo1;

308: v_counter number(8) := 0;
309:
310:
311: begin
312: uiutil.cabo1;
313: uiutil.cabo2a;
314: etrm_pnav.draw_buttons;
315: uiutil.cabo2b;
316: etrm_pnav.draw_tabs;

Line 313: uiutil.cabo2a;

309:
310:
311: begin
312: uiutil.cabo1;
313: uiutil.cabo2a;
314: etrm_pnav.draw_buttons;
315: uiutil.cabo2b;
316: etrm_pnav.draw_tabs;
317: uiutil.cabo3;

Line 315: uiutil.cabo2b;

311: begin
312: uiutil.cabo1;
313: uiutil.cabo2a;
314: etrm_pnav.draw_buttons;
315: uiutil.cabo2b;
316: etrm_pnav.draw_tabs;
317: uiutil.cabo3;
318: -- htp.p('

Objects

');
319:

Line 317: uiutil.cabo3;

313: uiutil.cabo2a;
314: etrm_pnav.draw_buttons;
315: uiutil.cabo2b;
316: etrm_pnav.draw_tabs;
317: uiutil.cabo3;
318: -- htp.p('

Objects

');
319:
320: v_owner := 'foRce_mE_to_diff';
321: v_name := replace(c_name, '*', '%'); -- http drops trailing %

Line 337: uiutil.a_href_gen(c_type => 'SCHEMA'

333: null;
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

Line 348: uiutil.a_href_gen(c_type => a_rec.object_type

344: , c_display => a_rec.owner);
345: htp.p('

');
346: end if;
347: 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

Line 367: uiutil.cabo4;

363: end loop;
364: htp.p('

'||v_counter ||' objects

');
365: htp.p('');
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;

Line 369: uiutil.cabo5;

365: htp.p('');
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;
373:

Line 371: uiutil.cabo6;

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;
373:
374: procedure ls_object_type(c_name in dba_objects.object_name%type := '%'
375: , c_owner in dba_objects.owner%type := '%'

Line 400: uiutil.cabo1;

396:
397:
398:
399: begin
400: uiutil.cabo1;
401: uiutil.cabo2a;
402: etrm_pnav.draw_buttons;
403: uiutil.cabo2b;
404: etrm_pnav.draw_tabs;

Line 401: uiutil.cabo2a;

397:
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;

Line 403: uiutil.cabo2b;

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||'

');
407: v_owner := 'foRce_mE_to_diff';

Line 405: uiutil.cabo3;

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 %
409: v_name := replace(v_name, '%23', '#');

Line 426: uiutil.a_href_gen(c_type => 'SCHEMA'

422: null;
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

Line 437: uiutil.a_javascript_gen(c_type => c_type

433: , c_display => a_rec.owner);
434: htp.p('

');
435: end if;
436: 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

Line 451: uiutil.cabo4;

447: end loop;
448: htp.p('

'||v_counter ||' objects

');
449: htp.p('');
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;

Line 453: uiutil.cabo5;

449: htp.p('');
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;
457:

Line 455: uiutil.cabo6;

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;
457:
458:
459: function dba_object_info(c_name in dba_objects.object_name%type

Line 536: uiutil.a_href_gen(c_type => 'TABLE'

532: htp.prn(' FND Design Data: ');
533: else
534: htp.p('
');
535: end if;
536: uiutil.a_href_gen(c_type => 'TABLE'
537: , c_link => 'etrm_fndnav.show_object?n_tabid='
538: ||t_rec.table_id
539: ||'&n_appid='
540: ||t_rec.application_id

Line 553: uiutil.a_href_gen(c_type => 'VIEW'

549: htp.prn(' FND Design Data: ');
550: else
551: htp.p('
');
552: end if;
553: uiutil.a_href_gen(c_type => 'VIEW'
554: , c_link => 'etrm_fndnav.show_object?n_tabid='
555: ||t_rec.view_id
556: ||'&n_appid='
557: ||t_rec.application_id

Line 589: uiutil.a_href_gen(c_type => 'EXCEPTION'

585: htp.prn(' Status: ');
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

Line 681: uiutil.a_href_gen(c_type => 'TABLE'

677: ||' '<br>
678: ||etrm_pnav.get_object_name(key_rec.cons_id, 'CONS')<br>
679: || ' ');
680: htp.p('');
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')

Line 726: uiutil.a_href_gen(c_type => 'TABLE'

722:
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')

Line 879: uiutil.txt_prn(c_rec.comments);

875: BEGIN
876: --
877:
878: for c_rec in cur_comment(c_name, c_owner) loop
879: uiutil.txt_prn(c_rec.comments);
880: end loop;
881:
882: v_first := TRUE;
883: FOR tab_rec IN cur_table_dets(c_name, c_owner) LOOP

Line 898: || uiutil.el_image('TS')|| tab_rec.tablespace_name||'');

894: htp.p(' 895: summary="dba_tables information">');
896:
897: htp.p('');
899: htp.p('');
901: htp.p('');
Line 915: || uiutil.el_image('COL')

911: htp.p('
');
912: v_pk_name := key_rec.constraint_name;
913: for key_col in cur_list_cons_columns(key_rec.constraint_name, c_owner) loop
914: htp.p('
'
915: || uiutil.el_image('COL')
916: ||key_col.column_name
917: ||'
');
918: end loop;
919: htp.p('
');
Line 927: || uiutil.el_image('COL')

923: htp.p('
Unique Key: '|| key_rec.constraint_name || '
');
924: htp.p('
');
925: for key_col in cur_list_cons_columns(key_rec.constraint_name, c_owner) loop
926: htp.p('
'
927: || uiutil.el_image('COL')
928: ||key_col.column_name
929: ||'
');
930: end loop;
931: htp.p('
');
Line 964: htp.p(uiutil.el_image('TS')||ind_rec.tablespace_name);

960: htp.p('');
961:
962:
963: htp.p('
');
966:
967:
968:
Line 979: htp.p(uiutil.el_image('COL')||ind_col_rec.column_expression);

975: v_first2 := FALSE;
976: else
977: htp.p('
');
978: end if;
979: htp.p(uiutil.el_image('COL')||ind_col_rec.column_expression);
980: end loop;
981: else
982: for ind_col_rec in cur_index_col(ind_rec.index_name, ind_rec.owner) loop
983: IF v_first2 Then

Line 988: htp.p(uiutil.el_image('COL')||ind_col_rec.column_name);

984: v_first2 := FALSE;
985: else
986: htp.p('
');
987: end if;
988: htp.p(uiutil.el_image('COL')||ind_col_rec.column_name);
989: end loop;
990: end if;
991: htp.p('
');
992: end loop;
Line 1186: uiutil.txt_prn(c_rec.comments);

1182:
Tablespace: '
898: || uiutil.el_image('TS')|| tab_rec.tablespace_name||'

PCT Free: '
900: ||tab_rec.pct_free||'
PCT Used: '
902: || tab_rec.pct_used||'

');
964: htp.p(uiutil.el_image('TS')||ind_rec.tablespace_name);
965: htp.p('

');
1183: end loop;
1184:
1185: for c_rec in cur_comment(c_name, c_owner) loop
1186: uiutil.txt_prn(c_rec.comments);
1187: end loop;
1188:
1189: for d_rec in cur_dtree(c_name=>c_name, c_owner =>c_owner) loop
1190: if vfirst then

Tablespace:	' 898: \|\| uiutil.el_image('TS')\|\| tab_rec.tablespace_name\|\|'
PCT Free:	' 900: \|\|tab_rec.pct_free\|\|'
PCT Used:	' 902: \|\| tab_rec.pct_used\|\|'
'); 964: htp.p(uiutil.el_image('TS')\|\|ind_rec.tablespace_name); 965: htp.p('

Line 1224: uiutil.a_href_gen(c_type => t_rec.base_object_type

1220: '

Trigger Details

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);

Line 1256: uiutil.a_href_gen(c_type => t_rec.table_type

1252: '

Index Details

1253: 1254: summary="dba_types information">
1255:
1465:
1466:
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);

Line 1468: uiutil.a_href_gen(c_type => 'TYPE'

1464: ||c_rec.coll_type||'

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);

Line 1503: uiutil.a_href_gen(c_type => 'TYPE'

1499:

'
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);

Line 1623: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');

1619: else
1620: v_owner := a_rec.owner;
1621: htp.p('

');
1622: if a_rec.owner is not null then
1623: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');
1624: end if;
1625: htp.p('

');
1626: end if;
1627:

Line 1633: uiutil.a_href_gen(c_type => 'NONE'

1629: htp.p('

');
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')

Line 1671: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');

1667: else
1668: v_owner := a_rec.owner;
1669: htp.p('

');
1670: if a_rec.owner is not null then
1671: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');
1672: end if;
1673: htp.p('

');
1674: end if;
1675:

Line 1680: uiutil.a_href_gen(c_type => 'NONE'

1676: htp.p('

');
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')

Line 1793: uiutil.txt_p(t_rec.line||' '||t_rec.text);

1789: end loop;
1790: else
1791: htp.p('

');

1792:     for t_rec in cur_source(c_name, c_type, c_owner) loop

1793:       uiutil.txt_p(t_rec.line||' '||t_rec.text);

1794:     end loop;

1795:     htp.p('

');
1796: end if;
1797:

Line 1904: uiutil.cabo1;

1900: procedure ls_apps is
1901:
1902: begin
1903:
1904: uiutil.cabo1;
1905: uiutil.cabo2a;
1906: etrm_pnav.draw_buttons;
1907: uiutil.cabo2b;
1908: etrm_pnav.draw_tabs;

Line 1905: uiutil.cabo2a;

1901:
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;

Line 1907: uiutil.cabo2b;

1903:
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

');

Line 1909: uiutil.cabo3;

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('

');
1913:

Line 1915: uiutil.a_href_gen(c_type => 'APP'

1911: htp.p('

DBA Objects

');
1912: 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('
'); Line 1920: 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('
');
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('

');
1926:
1927: uiutil.cabo4;
1928: etrm_pnav.quick_list;
1929: uiutil.cabo5;
1930: -- draw_form;
1931: uiutil.cabo6;

Line 1929: uiutil.cabo5;

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;
1933:

Line 1931: uiutil.cabo6;

1927: uiutil.cabo4;
1928: etrm_pnav.quick_list;
1929: uiutil.cabo5;
1930: -- draw_form;
1931: uiutil.cabo6;
1932: end ls_apps;
1933:
1934:
1935:

Line 1986: uiutil.cabo1;

1982: vapps_installation := TRUE;
1983: end if;
1984: end loop;
1985:
1986: uiutil.cabo1;
1987: uiutil.cabo2a;
1988: etrm_pnav.draw_buttons;
1989: uiutil.cabo2b;
1990: etrm_pnav.draw_tabs;

Line 1987: uiutil.cabo2a;

1983: end if;
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;

Line 1989: uiutil.cabo2b;

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
1993:

Line 1991: uiutil.cabo3;

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 2003: uiutil.a_href_gen(c_type => 'APP' 1999: fetch fnd_cv into fnd_name, fnd_title; 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:

Line 2021: uiutil.a_href_gen(c_type => 'APP'

2017: Database Schemas
');
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);

Line 2031: uiutil.cabo4;

2027: htp.p('

');
2030: end if;
2031: uiutil.cabo4;
2032: etrm_pnav.quick_list;
2033: uiutil.cabo5;
2034: -- draw_form;
2035: uiutil.cabo6;

Line 2033: uiutil.cabo5;

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;
2037:

Line 2035: uiutil.cabo6;

2031: uiutil.cabo4;
2032: etrm_pnav.quick_list;
2033: uiutil.cabo5;
2034: -- draw_form;
2035: uiutil.cabo6;
2036: end ls_apps;
2037:
2038:
2039:

Line 2101: uiutil.cabo1(c_title=> FND_CSS_PKG.Encode(c_type) ||' - '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name));

2097: , c_type in dba_objects.object_type%type) is
2098:
2099: v_object_id dba_objects.object_id%type;
2100: begin
2101: uiutil.cabo1(c_title=> FND_CSS_PKG.Encode(c_type) ||' - '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name));
2102: htp.p('');
2103: htp.p('');
2104: htp.p('

DBA Data [Home] [Help]
2105: [Dependency Information]

Line 2207: uiutil.prn_copyright;

2203:
2204:
2205:
2206: htp.p('

');
2207: uiutil.prn_copyright;
2208: htp.p('');
2209: end show_object;
2210:
2211: procedure show_details(c_name in dba_objects.object_name%type

Line 2219: uiutil.cabo1(c_title=> c_type ||' - '||c_owner||'.'||c_name);

2215: begin
2216: if c_detail_type = 'download'
2217: then download_source(c_name, c_type, c_owner);
2218: else
2219: uiutil.cabo1(c_title=> c_type ||' - '||c_owner||'.'||c_name);
2220: htp.p(' DBA Data [Home] [Help]
2221:

');
2222:
2223: htp.p('');

Line 2236: uiutil.prn_copyright;

2232: else
2233: htp.p('

No further details are available

');
2234: end if;
2235:
2236: uiutil.prn_copyright;
2237: htp.p('');
2238: end if;
2239: end show_details;
2240:

Line 2267: uiutil.cabo1(c_title=> c_name || ' dependencies');

2263: v_first boolean := TRUE;
2264:
2265: begin
2266: v_string := '%'||upper(c_name)||'%';
2267: uiutil.cabo1(c_title=> c_name || ' dependencies');
2268: htp.p(' DBA Data [Home] [Help]
2269:

');
2270:
2271: htp.p('

'||get_object_name(n_object_id)||' dependencies on '||FND_CSS_PKG.Encode(c_name)||'

');

Line 2275: uiutil.txt_prn1('

Line '||t_rec.line||': '||t_rec.source||'

');

2271: htp.p('

'||get_object_name(n_object_id)||' dependencies on '||FND_CSS_PKG.Encode(c_name)||'

');
2272: for t_rec in cur_find_line(n_object_id, v_string) loop
2273: v_first := FALSE;
2274: v_line := t_rec.line;
2275: uiutil.txt_prn1('
Line '||t_rec.line||': '||t_rec.source||'
');
2276: htp.p('

');
2277: for l_rec in cur_print_line(n_object_id, v_line) loop
2278: if l_rec.line = v_line then
2279: uiutil.txt_prn1(''||l_rec.line||': '||l_rec.source||'');

Line 2279: uiutil.txt_prn1(''||l_rec.line||': '||l_rec.source||'');

2275: uiutil.txt_prn1('

Line '||t_rec.line||': '||t_rec.source||'

');
2276: htp.p('

');
2277: for l_rec in cur_print_line(n_object_id, v_line) loop
2278: if l_rec.line = v_line then
2279: uiutil.txt_prn1(''||l_rec.line||': '||l_rec.source||'');
2280: else
2281: uiutil.txt_prn1(l_rec.line||': '||l_rec.source);
2282: end if;
2283: end loop;

Line 2281: uiutil.txt_prn1(l_rec.line||': '||l_rec.source);

2277: for l_rec in cur_print_line(n_object_id, v_line) loop
2278: if l_rec.line = v_line then
2279: uiutil.txt_prn1(''||l_rec.line||': '||l_rec.source||'');
2280: else
2281: uiutil.txt_prn1(l_rec.line||': '||l_rec.source);
2282: end if;
2283: end loop;
2284: htp.p('

');
2285: end loop;

Line 2321: uiutil.cabo1(c_title=> ' SQL Statements');

2317: type line_table is table of line_rec index by binary_integer;
2318: v_select_stmt line_table;
2319: v_stmt_count binary_integer;
2320: begin
2321: uiutil.cabo1(c_title=> ' SQL Statements');
2322: htp.p(' DBA Data [Home] [Help]
2323:

');
2324: htp.p('

'||get_object_name(n_object_id)||' SQL Statements

');
2325: htp.p('

The following lines contain the word ''select'', ''insert'', ''update'' or ''delete'':

');

Line 2429: uiutil.a_javascript_gen(c_type => c_type

2425: else
2426: htp.p('
');
2427: end if;
2428:
2429: uiutil.a_javascript_gen(c_type => c_type
2430: , c_link => 'etrm_pnav.show_object?c_name='
2431: || a_rec.object_name
2432: ||'&c_owner='
2433: ||a_rec.owner

APPS.ETRM_PNAV dependencies on UIUTIL

Line 39: uiutil.a_href_gen(c_link => 'etrm_search.search'

Line 41: -- uiutil.a_href_gen(c_link => 'https://login.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_logout?p_done_url=http://etrm.oracle.com/'

Line 43: uiutil.a_javascript_gen(c_link => 'etrm_search.help'

Line 70: -- uiutil.render_tab(c_url => v_search_url

Line 75: uiutil.render_tab(c_url => v_fndnav_url

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

Line 274: uiutil.a_href_gen(c_type => o_rec.object_type

Line 312: uiutil.cabo1;

Line 313: uiutil.cabo2a;

Line 315: uiutil.cabo2b;

Objects

Line 317: uiutil.cabo3;

Objects

Line 337: uiutil.a_href_gen(c_type => 'SCHEMA'

Line 348: uiutil.a_href_gen(c_type => a_rec.object_type

Line 367: uiutil.cabo4;

Line 369: uiutil.cabo5;

Line 371: uiutil.cabo6;

Line 400: uiutil.cabo1;

Line 401: uiutil.cabo2a;

Line 403: uiutil.cabo2b;

'||c_type||'

Line 405: uiutil.cabo3;

'||c_type||'

Line 426: uiutil.a_href_gen(c_type => 'SCHEMA'

Line 437: uiutil.a_javascript_gen(c_type => c_type

Line 451: uiutil.cabo4;

Line 453: uiutil.cabo5;

Line 455: uiutil.cabo6;

Line 536: uiutil.a_href_gen(c_type => 'TABLE'

Line 553: uiutil.a_href_gen(c_type => 'VIEW'

Line 589: uiutil.a_href_gen(c_type => 'EXCEPTION'

Line 681: uiutil.a_href_gen(c_type => 'TABLE'

Line 726: uiutil.a_href_gen(c_type => 'TABLE'

Line 879: uiutil.txt_prn(c_rec.comments);

Line 898: || uiutil.el_image('TS')|| tab_rec.tablespace_name||'');

Line 915: || uiutil.el_image('COL')

Line 927: || uiutil.el_image('COL')

Unique Key: '|| key_rec.constraint_name || '

Line 964: htp.p(uiutil.el_image('TS')||ind_rec.tablespace_name);

Line 979: htp.p(uiutil.el_image('COL')||ind_col_rec.column_expression);

Line 988: htp.p(uiutil.el_image('COL')||ind_col_rec.column_name);

Line 1186: uiutil.txt_prn(c_rec.comments);

Line 1224: uiutil.a_href_gen(c_type => t_rec.base_object_type

Trigger Details

Line 1256: uiutil.a_href_gen(c_type => t_rec.table_type

Index Details

Line 1468: uiutil.a_href_gen(c_type => 'TYPE'

Line 1503: uiutil.a_href_gen(c_type => 'TYPE'

Line 1623: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');

Line 1633: uiutil.a_href_gen(c_type => 'NONE'

Line 1671: htp.p(uiutil.el_image('SCHEMA')||''||a_rec.owner||'');

Line 1680: uiutil.a_href_gen(c_type => 'NONE'

Line 1793: uiutil.txt_p(t_rec.line||' '||t_rec.text);

Line 1904: uiutil.cabo1;

Line 1905: uiutil.cabo2a;

Line 1907: uiutil.cabo2b;

DBA Objects

Line 1909: uiutil.cabo3;

DBA Objects

Line 1915: uiutil.a_href_gen(c_type => 'APP'

DBA Objects

Line 1920: uiutil.a_href_gen(c_type => 'APP'

Line 1927: uiutil.cabo4;

Line 1929: uiutil.cabo5;

Line 1931: uiutil.cabo6;

Line 1986: uiutil.cabo1;

Line 1987: uiutil.cabo2a;

Line 1989: uiutil.cabo2b;

Line 1991: uiutil.cabo3;

Line 2003: uiutil.a_href_gen(c_type => 'APP'

Line 2021: uiutil.a_href_gen(c_type => 'APP'

Line 2031: uiutil.cabo4;

Line 2033: uiutil.cabo5;

Line 2035: uiutil.cabo6;

Line 2101: uiutil.cabo1(c_title=> FND_CSS_PKG.Encode(c_type) ||' - '||FND_CSS_PKG.Encode(c_owner)||'.'||FND_CSS_PKG.Encode(c_name));

Line 2207: uiutil.prn_copyright;

Line 2219: uiutil.cabo1(c_title=> c_type ||' - '||c_owner||'.'||c_name);

Line 2236: uiutil.prn_copyright;