APPS.ETRM_FNDNAV dependencies on ETRM_FNDNAV

Line 1: PACKAGE BODY "ETRM_FNDNAV" as

1: PACKAGE BODY "ETRM_FNDNAV" as
2:
3: ----------------------------------------------------------------------------
4: -- Copyright ?? 2001, 2014, Oracle and/or its affiliates. All rights reserved.
5: -- eTRM: Oracle Applications repository browser and dependency report

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 179: -- htp.p('

FND Navigator Home');

175: and c_type = '%') then
176: htp.p('

Browse the FND Tables in an Applications database

FND Navigator Home');
180: end if;
181:
182:
183:

Line 186: htp.p('

');

182:
183:
184:
185:
186: htp.p('');
187: htp.p('');
188:
189: htp.p(' ');
190: htp.p('');
954: htp.p('');
999: htp.p('

Product:	'); Line 326: , c_link => 'etrm_fndnav.ls_object?c_name=' 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, '*'), '%', '*') 330: , c_display => get_appname(n_appid)); Line 342: , c_link => 'etrm_fndnav.ls_object?c_name=' 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 346: ||'&c_type=TABLE' Line 354: , c_link => 'etrm_fndnav.ls_object?c_name=' 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 358: ||'&c_type=VIEW' Line 366: , c_link => 'etrm_fndnav.ls_object?c_name=' 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 370: ||'&c_type=CONCURRENT' Line 378: , c_link => 'etrm_fndnav.ls_object?c_name=' 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 382: ||'&c_type=LOOKUP' Line 390: , c_link => 'etrm_fndnav.ls_object?c_name=' 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 394: ||'&c_type=FILE' Line 402: , c_link => 'etrm_fndnav.ls_object?c_name=' 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 406: ||'&c_type=EVENT' Line 449: htp.p(' ' 445: 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 Line 567: htp.p(' ' 563: uiutil.cabo3; 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: -- ||'' Line 576: , c_link => 'etrm_fndnav.ls_object?n_appid='||n_appid 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(''); 580: Line 586: , c_link => 'etrm_fndnav.show_object?n_appid=' 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 590: ||'&c_type=TABLE' Line 599: , c_link => 'etrm_fndnav.show_object?n_appid=' 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 603: ||'&c_type=VIEW' Line 612: , c_link => 'etrm_fndnav.show_object?n_appid=' 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 616: ||'&c_type=CONCURRENT' Line 625: , c_link => 'etrm_fndnav.show_object?n_appid=' 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 629: ||'&c_type=LOOKUP' Line 639: , c_link => 'etrm_fndnav.show_object?n_appid=' 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 643: ||'&c_type=FILE' Line 653: , c_link => 'etrm_fndnav.show_object?n_appid=' 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 657: ||'&c_type=EVENT' Line 667: , c_link => 'etrm_fndnav.show_object?n_appid=' 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 671: ||'&c_type=' Line 956: , c_link => 'etrm_fndnav.show_object?n_appid=' 952: ||uiutil.el_image('FK') 953: || '	'); 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 960: ||'&c_type=TABLE' Line 1001: , c_link => 'etrm_fndnav.show_object?n_appid=' 997: 998: 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 1005: ||'&c_type=TABLE' Line 1626: , c_link => 'etrm_fndnav.show_file?n_file_id=' 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'); 1630: htp.p(' in current window'); Line 1739: , c_link => 'etrm_fndnav.ls_object?c_name=*' 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); 1743: Line 1774: owa_cookie.send('etrm_fndnav_context', v_context); 1770: -- This wraps the following packages in an HTTP header 1771: owa_util.mime_header('text/html', FALSE); 1772: 1773: -- Send some value to the target cookie for the next browser call 1774: owa_cookie.send('etrm_fndnav_context', v_context); 1775: 1776: -- Note: The following would cause the target cookie to expire 1777: -- owa_cookie.remove('etrm_fndnav_context'); 1778: Line 1777: -- owa_cookie.remove('etrm_fndnav_context'); 1773: -- Send some value to the target cookie for the next browser call 1774: owa_cookie.send('etrm_fndnav_context', v_context); 1775: 1776: -- Note: The following would cause the target cookie to expire 1777: -- owa_cookie.remove('etrm_fndnav_context'); 1778: 1779: owa_util.http_header_close; 1780: 1781: if (c_type not in ('TABLE', 'VIEW', 'CONCURRENT', 'LOOKUP', 'FILE', 'EVENT', '%', '*')) then Line 1905: end etrm_fndnav; 1901: end if; 1902: return v_return_value; 1903: end get_owner; 1904: 1905: end etrm_fndnav;