52: begin
53:
54: v_cookie := owa_cookie.get('etrm_fndnav_context');
55: if (v_cookie.num_vals >0) THEN
56: v_fndnav_url := 'etrm_fndnav.ls_object?'||utl_url.escape(v_cookie.vals(1));
57: else
58: v_fndnav_url := 'etrm_fndnav.ls_apps';
59: end if;
60:
59: end if;
60:
61: v_cookie := owa_cookie.get('etrm_search_context');
62: if (v_cookie.num_vals >0) THEN
63: v_search_url := 'etrm_search.search?c_search='||utl_url.escape(v_cookie.vals(1));
64: else
65: v_search_url := 'etrm_search.search';
66: end if;
67:
2115: then
2116: htp.p('
');
2117:
2118: htp.p('[Package]');
2117:
2118: htp.p('[Package]');
2124: htp.p('[Package]');
2124: htp.p('[Package Body]');
2123: ||'&c_detail_type=source">[Package]');
2124: htp.p('[Package Body]');
2130: htp.p('
2140: ||utl_url.escape(c_name)
2141: ||" &c_owner="
2142: ||utl_url.escape(c_owner)
2143: ||" &c_type="||c_type
2144: ||" &c_detail_type="source"">[Source]');
2138: htp.p('
');
2139: htp.p('[Source]');
2145: htp.p('
2150: ls_columns(c_name, c_owner);
2151: elsif (c_type = 'VIEW')
2152: then ls_table(c_name, c_owner);
2153: htp.p('
2161: elsif (c_type = 'MATERIALIZED VIEW')
2162: then
2163: ls_mview(c_name, c_owner);
2164: htp.p('
2174: ls_trigger(c_name, c_owner);
2175: htp.p('