DBA Data[Home] [Help]

APPS.ETRM_FNDNAV dependencies on UIUTIL

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

81:
82: procedure draw_buttons
83: is
84: begin
85: uiutil.a_href_gen(c_link => 'etrm_search.search'
86: , c_display => 'Home');
87: -- 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/'
88: -- , c_display => 'Sign out');
89: uiutil.a_javascript_gen(c_link => 'etrm_search.help'

Line 87: -- 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/'

83: is
84: begin
85: uiutil.a_href_gen(c_link => 'etrm_search.search'
86: , c_display => 'Home');
87: -- 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/'
88: -- , c_display => 'Sign out');
89: uiutil.a_javascript_gen(c_link => 'etrm_search.help'
90: , c_display => 'Help');
91: end draw_buttons;

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

85: uiutil.a_href_gen(c_link => 'etrm_search.search'
86: , c_display => 'Home');
87: -- 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/'
88: -- , c_display => 'Sign out');
89: uiutil.a_javascript_gen(c_link => 'etrm_search.help'
90: , c_display => 'Help');
91: end draw_buttons;
92:
93: procedure draw_tabs

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

111: v_search_url := 'etrm_search.search';
112: end if;
113:
114:
115: -- uiutil.render_tab(c_url => v_search_url
116: -- , c_title => 'Search'
117: -- , c_position => 'LEFT'
118: -- , c_state => 'ENABLED');
119:

Line 120: uiutil.render_tab(c_url => 'etrm_fndnav.ls_apps'

116: -- , c_title => 'Search'
117: -- , c_position => 'LEFT'
118: -- , c_state => 'ENABLED');
119:
120: uiutil.render_tab(c_url => 'etrm_fndnav.ls_apps'
121: , c_title => 'FND'
122: , c_position => 'LEFT'
123: , c_state => 'SELECTED');
124:

Line 125: uiutil.render_tab(c_url => v_pnav_url

121: , c_title => 'FND'
122: , c_position => 'LEFT'
123: , c_state => 'SELECTED');
124:
125: uiutil.render_tab(c_url => v_pnav_url
126: , c_title => 'DBA'
127: , c_position => 'RIGHT'
128: , c_state => 'ENABLED'
129: , b_prior_selected => TRUE);

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

321:
322: if (v_counter >0) then
323:
324: htp.p('

');
325: uiutil.a_href_gen(c_type => 'APP'
326: , c_link => 'etrm_fndnav.ls_object?c_name='
327: ||replace(c_name, '%', '*')
328: ||'&n_appid='||n_appid
329: ||'&c_type=' ||replace(nvl(c_type, '*'), '%', '*')

Line 333: -- htp.p('
'||uiutil.el_image('APP')

329: ||'&c_type=' ||replace(nvl(c_type, '*'), '%', '*')
330: , c_display => get_appname(n_appid));
331: htp.p('

');
332: -- else
333: -- htp.p('
'||uiutil.el_image('APP')
334: -- ||get_appname(n_appid)
335: -- ||'
');
336: -- htp.p('
No documented items
');
337: end if;

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

337: end if;
338:
339: if vtable_count > 0 then
340: htp.p('

');
341: uiutil.a_href_gen(c_type => 'TABLE'
342: , c_link => 'etrm_fndnav.ls_object?c_name='
343: ||replace(c_name, '%', '*')
344: ||'&n_appid='
345: ||n_appid

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

349: end if;
350:
351: if vview_count > 0 then
352: htp.p('

');
353: uiutil.a_href_gen(c_type => 'VIEW'
354: , c_link => 'etrm_fndnav.ls_object?c_name='
355: ||replace(c_name, '%', '*')
356: ||'&n_appid='
357: ||n_appid

Line 365: uiutil.a_href_gen(c_type => 'CONCURRENT'

361: end if;
362:
363: if vconcurrent_count > 0 then
364: htp.p('

');
365: uiutil.a_href_gen(c_type => 'CONCURRENT'
366: , c_link => 'etrm_fndnav.ls_object?c_name='
367: ||replace(c_name, '%', '*')
368: ||'&n_appid='
369: ||n_appid

Line 377: uiutil.a_href_gen(c_type => 'LOOKUP'

373: end if;
374:
375: if vlookup_count > 0 then
376: htp.p('

');
377: uiutil.a_href_gen(c_type => 'LOOKUP'
378: , c_link => 'etrm_fndnav.ls_object?c_name='
379: ||replace(c_name, '%', '*')
380: ||'&n_appid='
381: ||n_appid

Line 389: uiutil.a_href_gen(c_type => 'FILE'

385: end if;
386:
387: if vfile_count > 0 then
388: htp.p('

');
389: uiutil.a_href_gen(c_type => 'FILE'
390: , c_link => 'etrm_fndnav.ls_object?c_name='
391: ||replace(c_name, '%', '*')
392: ||'&n_appid='
393: ||n_appid

Line 401: uiutil.a_href_gen(c_type => 'EVENT'

397: end if;
398:
399: if vevent_count > 0 then
400: htp.p('

');
401: uiutil.a_href_gen(c_type => 'EVENT'
402: , c_link => 'etrm_fndnav.ls_object?c_name='
403: ||replace(c_name, '%', '*')
404: ||'&n_appid='
405: ||n_appid

Line 439: uiutil.cabo1;

435: l_method varchar2(100) := 'ls_count';
436:
437:
438: begin
439: uiutil.cabo1;
440: uiutil.cabo2a;
441: draw_buttons;
442: uiutil.cabo2b;
443: draw_tabs;

Line 440: uiutil.cabo2a;

436:
437:
438: begin
439: uiutil.cabo1;
440: uiutil.cabo2a;
441: draw_buttons;
442: uiutil.cabo2b;
443: draw_tabs;
444: uiutil.cabo3;

Line 442: uiutil.cabo2b;

438: begin
439: uiutil.cabo1;
440: uiutil.cabo2a;
441: draw_buttons;
442: uiutil.cabo2b;
443: draw_tabs;
444: uiutil.cabo3;
445:
446: v_name := replace(c_name, '*', '%'); -- http drops trailing %

Line 444: uiutil.cabo3;

440: uiutil.cabo2a;
441: draw_buttons;
442: uiutil.cabo2b;
443: draw_tabs;
444: uiutil.cabo3;
445:
446: v_name := replace(c_name, '*', '%'); -- http drops trailing %
447: v_type := replace(c_type, '*', '%');
448: htp.p('

');

Line 450: ||uiutil.el_image('ROOT')

446: v_name := replace(c_name, '*', '%'); -- http drops trailing %
447: v_type := replace(c_type, '*', '%');
448: htp.p('

');
449: htp.p('
'
450: ||uiutil.el_image('ROOT')
451: ||'
');
452:
453: if n_appid is NULL then
454: for a_rec in cur_apps loop

Line 468: uiutil.cabo4;

464:
465:
466: htp.p('

');
467:
468: uiutil.cabo4;
469: quick_list;
470: uiutil.cabo5;
471: -- draw_form(n_appid => n_appid, c_name => c_name, c_type => c_type);
472: uiutil.cabo6;

Line 470: uiutil.cabo5;

466: htp.p('

');
467:
468: uiutil.cabo4;
469: quick_list;
470: uiutil.cabo5;
471: -- draw_form(n_appid => n_appid, c_name => c_name, c_type => c_type);
472: uiutil.cabo6;
473: end ls_count;
474:

Line 472: uiutil.cabo6;

468: uiutil.cabo4;
469: quick_list;
470: uiutil.cabo5;
471: -- draw_form(n_appid => n_appid, c_name => c_name, c_type => c_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 := '%'

Line 558: uiutil.cabo1;

554: v_counter integer := 0;
555:
556:
557: begin
558: uiutil.cabo1;
559: uiutil.cabo2a;
560: draw_buttons;
561: uiutil.cabo2b;
562: draw_tabs;

Line 559: uiutil.cabo2a;

555:
556:
557: begin
558: uiutil.cabo1;
559: uiutil.cabo2a;
560: draw_buttons;
561: uiutil.cabo2b;
562: draw_tabs;
563: uiutil.cabo3;

Line 561: uiutil.cabo2b;

557: begin
558: uiutil.cabo1;
559: uiutil.cabo2a;
560: draw_buttons;
561: uiutil.cabo2b;
562: draw_tabs;
563: uiutil.cabo3;
564:
565: v_name := replace(c_name, '*', '%'); -- http drops trailing %

Line 563: uiutil.cabo3;

559: uiutil.cabo2a;
560: draw_buttons;
561: uiutil.cabo2b;
562: draw_tabs;
563: uiutil.cabo3;
564:
565: v_name := replace(c_name, '*', '%'); -- http drops trailing %
566: htp.p('

');
567: htp.p('
'

Line 568: ||uiutil.el_image('ROOT')

564:
565: v_name := replace(c_name, '*', '%'); -- http drops trailing %
566: htp.p('

');
567: htp.p('
'
568: ||uiutil.el_image('ROOT')
569: ||'');
570: -- htp.p(uiutil.el_image('APP')
571: -- ||''
572: -- ||get_appname(n_appid)

Line 570: -- htp.p(uiutil.el_image('APP')

566: htp.p('

');
567: htp.p('
'
568: ||uiutil.el_image('ROOT')
569: ||'');
570: -- htp.p(uiutil.el_image('APP')
571: -- ||''
572: -- ||get_appname(n_appid)
573: -- ||'
');
574:

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

571: -- ||''
572: -- ||get_appname(n_appid)
573: -- ||'

');
574:
575: uiutil.a_href_gen(c_type => 'APP'
576: , c_link => 'etrm_fndnav.ls_object?n_appid='||n_appid
577: || '&c_name=*&c_type=*'
578: , c_display => get_appname(n_appid));
579: htp.p('
');

Line 585: uiutil.a_javascript_gen(c_type => 'TABLE'

581:
582: if c_type = 'TABLE' then
583: for a_rec in cur_tables(v_name, n_appid) loop
584: htp.p('

');
585: uiutil.a_javascript_gen(c_type => 'TABLE'
586: , c_link => 'etrm_fndnav.show_object?n_appid='
587: || n_appid
588: ||'&n_tabid='
589: ||a_rec.id

Line 598: uiutil.a_javascript_gen(c_type => 'VIEW'

594: end loop;
595: elsif c_type = 'VIEW' then
596: for a_rec in cur_views(v_name, n_appid) loop
597: htp.p('

');
598: uiutil.a_javascript_gen(c_type => 'VIEW'
599: , c_link => 'etrm_fndnav.show_object?n_appid='
600: || n_appid
601: ||'&n_tabid='
602: ||a_rec.id

Line 611: uiutil.a_javascript_gen(c_type => 'CONCURRENT'

607: end loop;
608: elsif c_type = 'CONCURRENT' then
609: for a_rec in cur_concurrent(v_name, n_appid) loop
610: htp.p('

');
611: uiutil.a_javascript_gen(c_type => 'CONCURRENT'
612: , c_link => 'etrm_fndnav.show_object?n_appid='
613: || n_appid
614: ||'&n_tabid='
615: ||a_rec.id

Line 624: uiutil.a_javascript_gen(c_type => 'LOOKUP'

620: end loop;
621: elsif c_type = 'LOOKUP' then
622: for a_rec in cur_lookup(v_name, n_appid) loop
623: htp.p('

');
624: uiutil.a_javascript_gen(c_type => 'LOOKUP'
625: , c_link => 'etrm_fndnav.show_object?n_appid='
626: || n_appid
627: ||'&n_tabid='
628: ||a_rec.id

Line 638: uiutil.a_javascript_gen(c_type => 'FILE'

634:
635: elsif c_type = 'FILE' then
636: for a_rec in cur_files(v_name, n_appid) loop
637: htp.p('

');
638: uiutil.a_javascript_gen(c_type => 'FILE'
639: , c_link => 'etrm_fndnav.show_object?n_appid='
640: || n_appid
641: ||'&n_tabid='
642: ||a_rec.id

Line 652: uiutil.a_javascript_gen(c_type => 'EVENT'

648:
649: elsif c_type = 'EVENT' then
650: for a_rec in cur_event(v_name, n_appid) loop
651: htp.p('

');
652: uiutil.a_javascript_gen(c_type => 'EVENT'
653: , c_link => 'etrm_fndnav.show_object?n_appid='
654: || n_appid
655: ||'&n_tabid='
656: ||a_rec.id

Line 666: uiutil.a_javascript_gen(c_type => rtrim(a_rec.o_type)

662:
663: elsif c_type in ('%', '*') then
664: for a_rec in cur_tables_and_views(v_name, n_appid) loop
665: htp.p('

');
666: uiutil.a_javascript_gen(c_type => rtrim(a_rec.o_type)
667: , c_link => 'etrm_fndnav.show_object?n_appid='
668: || n_appid
669: ||'&n_tabid='
670: ||a_rec.id

Line 685: uiutil.cabo4;

681:
682: htp.p('

'||v_counter ||' objects
');
683: htp.p('
');
684:
685: uiutil.cabo4;
686: quick_list;
687: uiutil.cabo5;
688: -- draw_form(n_appid => n_appid, c_name=> c_name, c_type => c_type);
689: htp.p('
');

Line 687: uiutil.cabo5;

683: htp.p('');
684:
685: uiutil.cabo4;
686: quick_list;
687: uiutil.cabo5;
688: -- draw_form(n_appid => n_appid, c_name=> c_name, c_type => c_type);
689: htp.p('
');
690: uiutil.cabo6;
691: end ls_product;

Line 690: uiutil.cabo6;

686: quick_list;
687: uiutil.cabo5;
688: -- draw_form(n_appid => n_appid, c_name=> c_name, c_type => c_type);
689: htp.p('
');
690: uiutil.cabo6;
691: end ls_product;
692:
693:
694:

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

917: for key_col in cur_pk_columns(n_appid => n_appid
918: , n_tabid => n_tabid
919: , n_keyid => key_rec.primary_key_id) loop
920: htp.p('

  • '
    921: || uiutil.el_image('COL')
    922: ||key_col.column_name
    923: ||'
    • ');
    924: end loop;
    925: htp.p('');

    Line 952: ||uiutil.el_image('FK')

    948: htp.p(''
    949: ||v_tablename
    950: ||'');
    951: htp.p(''
    952: ||uiutil.el_image('FK')
    953: || '');
    954: htp.p('');
    955: uiutil.a_href_gen(c_type => 'TABLE'
    956: , c_link => 'etrm_fndnav.show_object?n_appid='

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

    951: htp.p(''
    952: ||uiutil.el_image('FK')
    953: || '');
    954: htp.p('');
    955: uiutil.a_href_gen(c_type => 'TABLE'
    956: , c_link => 'etrm_fndnav.show_object?n_appid='
    957: ||key_rec.primary_key_application_id
    958: ||'&n_tabid='
    959: ||key_rec.primary_key_table_id

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

    996: end if;
    997:
    998: htp.p('');
    999: htp.p('');
    1000: uiutil.a_href_gen(c_type => 'TABLE'
    1001: , c_link => 'etrm_fndnav.show_object?n_appid='
    1002: ||key_rec.application_id
    1003: ||'&n_tabid='
    1004: ||key_rec.table_id

    Line 1010: ||uiutil.el_image('FK')

    1006: , c_display => get_tablename(n_appid => key_rec.application_id
    1007: , n_tabid => key_rec.table_id));
    1008: htp.p('');
    1009: htp.p(''
    1010: ||uiutil.el_image('FK')
    1011: ||'');
    1012: htp.p('');
    1013: htp.p(v_tablename||'');
    1014:

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

    1056: htp.p('

      ');
      1057: v_first := FALSE;
      1058: end if;
      1059: htp.p('
    1. '
      1060: ||uiutil.el_image('COL')
      1061: ||ind_col_rec.column_name
      1062: ||'
      2. ');
      1063: end loop;
      1064:

      Line 1606: || uiutil.byte_format(c_rec.file_length)

      1602: htp.p('File Type: '
      1603: || c_rec.file_type||'');
      1604:
      1605: htp.p('Size: '
      1606: || uiutil.byte_format(c_rec.file_length)
      1607: ||'');
      1608:
      1609:
      1610: if (c_rec.description is null

      Line 1625: uiutil.a_href_gen(c_type => 'FILE'

      1621:
      1622: htp.p('

      ');
      1623: htp.p('
      Action:
      ');
      1624: htp.p('
      ');
      1625: uiutil.a_href_gen(c_type => 'FILE'
      1626: , c_link => 'etrm_fndnav.show_file?n_file_id='
      1627: ||n_fileid
      1628: ||'&c_mode=INLINE'
      1629: , c_display => 'View file');

      Line 1727: uiutil.cabo1;

      1723:
      1724: begin
      1725:
      1726:
      1727: uiutil.cabo1;
      1728: uiutil.cabo2a;
      1729: draw_buttons;
      1730: uiutil.cabo2b;
      1731: draw_tabs;

      Line 1728: uiutil.cabo2a;

      1724: begin
      1725:
      1726:
      1727: uiutil.cabo1;
      1728: uiutil.cabo2a;
      1729: draw_buttons;
      1730: uiutil.cabo2b;
      1731: draw_tabs;
      1732: uiutil.cabo3;

      Line 1730: uiutil.cabo2b;

      1726:
      1727: uiutil.cabo1;
      1728: uiutil.cabo2a;
      1729: draw_buttons;
      1730: uiutil.cabo2b;
      1731: draw_tabs;
      1732: uiutil.cabo3;
      1733: htp.p('

      Products

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

      Line 1732: uiutil.cabo3;

      1728: uiutil.cabo2a;
      1729: draw_buttons;
      1730: uiutil.cabo2b;
      1731: draw_tabs;
      1732: uiutil.cabo3;
      1733: htp.p('

      Products

      ');
      1734: htp.p('
      ');
      1735: for s_rec in cur_apps loop
      1736:

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

      1734: htp.p('

      ');
      1735: for s_rec in cur_apps loop
      1736:
      1737: htp.p('
      ');
      1738: uiutil.a_href_gen(c_type => 'APP'
      1739: , c_link => 'etrm_fndnav.ls_object?c_name=*'
      1740: ||'&n_appid='
      1741: ||s_rec.application_id
      1742: , c_display => s_rec.product_name);

      Line 1747: uiutil.cabo4;

      1743:
      1744: htp.p('

      ');
      1745: end loop;
      1746: htp.p('
      ');
      1747: uiutil.cabo4;
      1748: quick_list;
      1749: uiutil.cabo5;
      1750: -- draw_form;
      1751: uiutil.cabo6;

      Line 1749: uiutil.cabo5;

      1745: end loop;
      1746: htp.p('

      ');
      1747: uiutil.cabo4;
      1748: quick_list;
      1749: uiutil.cabo5;
      1750: -- draw_form;
      1751: uiutil.cabo6;
      1752: end ls_apps;
      1753: procedure ls_object(n_appid in number := NULL

      Line 1751: uiutil.cabo6;

      1747: uiutil.cabo4;
      1748: quick_list;
      1749: uiutil.cabo5;
      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

      Line 1782: uiutil.cabo1;

      1778:
      1779: owa_util.http_header_close;
      1780:
      1781: if (c_type not in ('TABLE', 'VIEW', 'CONCURRENT', 'LOOKUP', 'FILE', 'EVENT', '%', '*')) then
      1782: uiutil.cabo1;
      1783: uiutil.cabo2a;
      1784: draw_buttons;
      1785: uiutil.cabo2b;
      1786: draw_tabs;

      Line 1783: uiutil.cabo2a;

      1779: owa_util.http_header_close;
      1780:
      1781: if (c_type not in ('TABLE', 'VIEW', 'CONCURRENT', 'LOOKUP', 'FILE', 'EVENT', '%', '*')) then
      1782: uiutil.cabo1;
      1783: uiutil.cabo2a;
      1784: draw_buttons;
      1785: uiutil.cabo2b;
      1786: draw_tabs;
      1787: uiutil.cabo3;

      Line 1785: uiutil.cabo2b;

      1781: if (c_type not in ('TABLE', 'VIEW', 'CONCURRENT', 'LOOKUP', 'FILE', 'EVENT', '%', '*')) then
      1782: uiutil.cabo1;
      1783: uiutil.cabo2a;
      1784: draw_buttons;
      1785: uiutil.cabo2b;
      1786: draw_tabs;
      1787: uiutil.cabo3;
      1788: htp.p('

      Application does not support objects of given type
      ');
      1789: uiutil.cabo4;

      Line 1787: uiutil.cabo3;

      1783: uiutil.cabo2a;
      1784: draw_buttons;
      1785: uiutil.cabo2b;
      1786: draw_tabs;
      1787: uiutil.cabo3;
      1788: htp.p('

      Application does not support objects of given type
      ');
      1789: uiutil.cabo4;
      1790: quick_list;
      1791: uiutil.cabo5;

      Line 1789: uiutil.cabo4;

      1785: uiutil.cabo2b;
      1786: draw_tabs;
      1787: uiutil.cabo3;
      1788: htp.p('

      Application does not support objects of given type
      ');
      1789: uiutil.cabo4;
      1790: quick_list;
      1791: uiutil.cabo5;
      1792: -- draw_form(n_appid => n_appid, c_name => c_name, c_type => c_type);
      1793: uiutil.cabo6;

      Line 1791: uiutil.cabo5;

      1787: uiutil.cabo3;
      1788: htp.p('

      Application does not support objects of given type
      ');
      1789: uiutil.cabo4;
      1790: quick_list;
      1791: uiutil.cabo5;
      1792: -- draw_form(n_appid => n_appid, c_name => c_name, c_type => c_type);
      1793: uiutil.cabo6;
      1794: elsif (v_name = '%'
      1795: and n_appid is NULL)

      Line 1793: uiutil.cabo6;

      1789: uiutil.cabo4;
      1790: quick_list;
      1791: uiutil.cabo5;
      1792: -- draw_form(n_appid => n_appid, c_name => c_name, c_type => c_type);
      1793: uiutil.cabo6;
      1794: elsif (v_name = '%'
      1795: and n_appid is NULL)
      1796: then ls_apps;
      1797: elsif (v_name != '%'

      Line 1823: uiutil.cabo1(c_title=>'FND Design Data');

      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');
      1824: htp.p('');
      1825: htp.p('FND Design Data [Home] [Help]
      1826:

      ');
      1827:

      Line 1846: uiutil.prn_copyright;

      1842: htp.p(FND_CSS_PKG.Encode(c_type) ||' objects are not currently supported');
      1843: end if;
      1844:
      1845: htp.p('

      ');
      1846: uiutil.prn_copyright;
      1847: htp.p('');
      1848: end show_object;
      1849:
      1850: function get_owner(c_name in dba_objects.object_name%type