12:
13: procedure draw_buttons
14: is
15: begin
16: uiutil.a_href_gen(c_link => 'etrm_search.search'
17: , c_display => 'Home');
18: -- uiutil.a_href_gen(c_link => 'https://login-stage.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_logout?p_done_url=https://etrm-test.us.oracle.com'
19: -- , c_display => 'Sign out');
20: uiutil.a_javascript_gen(c_link => 'etrm_search.help'
14: is
15: begin
16: uiutil.a_href_gen(c_link => 'etrm_search.search'
17: , c_display => 'Home');
18: -- uiutil.a_href_gen(c_link => 'https://login-stage.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_logout?p_done_url=https://etrm-test.us.oracle.com'
19: -- , c_display => 'Sign out');
20: uiutil.a_javascript_gen(c_link => 'etrm_search.help'
21: , c_display => 'Help');
22: end draw_buttons;
16: uiutil.a_href_gen(c_link => 'etrm_search.search'
17: , c_display => 'Home');
18: -- uiutil.a_href_gen(c_link => 'https://login-stage.oracle.com/pls/orasso/orasso.wwsso_app_admin.ls_logout?p_done_url=https://etrm-test.us.oracle.com'
19: -- , c_display => 'Sign out');
20: uiutil.a_javascript_gen(c_link => 'etrm_search.help'
21: , c_display => 'Help');
22: end draw_buttons;
23:
24: procedure draw_tabs
44:
45:
46:
47:
48: -- uiutil.render_tab(c_url => 'etrm_search.search'
49: -- , c_title => 'Search'
50: -- , c_position => 'LEFT'
51: -- , c_state => 'SELECTED');
52:
49: -- , c_title => 'Search'
50: -- , c_position => 'LEFT'
51: -- , c_state => 'SELECTED');
52:
53: uiutil.render_tab(c_url => v_fndnav_url
54: , c_title => 'FND'
55: , c_position => 'LEFT'
56: , c_state => 'ENABLED'
57: , b_prior_selected => TRUE);
55: , c_position => 'LEFT'
56: , c_state => 'ENABLED'
57: , b_prior_selected => TRUE);
58:
59: uiutil.render_tab(c_url => v_pnav_url
60: , c_title => 'DBA'
61: , c_position => 'RIGHT'
62: , c_state => 'ENABLED');
63:
227: v_type := 'TABLE';
228: end if;
229:
230: htp.p('
260: begin
261: htp.p('
365: -- Send some value to the target cookie for the next browser call
366: owa_cookie.send('etrm_search_context', v_search);
367:
368: owa_util.http_header_close;
369: uiutil.cabo1;
370: uiutil.cabo2a;
371: draw_buttons;
372: uiutil.cabo2b;
373: draw_tabs;
366: owa_cookie.send('etrm_search_context', v_search);
367:
368: owa_util.http_header_close;
369: uiutil.cabo1;
370: uiutil.cabo2a;
371: draw_buttons;
372: uiutil.cabo2b;
373: draw_tabs;
374: uiutil.cabo3;
368: owa_util.http_header_close;
369: uiutil.cabo1;
370: uiutil.cabo2a;
371: draw_buttons;
372: uiutil.cabo2b;
373: draw_tabs;
374: uiutil.cabo3;
375:
376:
370: uiutil.cabo2a;
371: draw_buttons;
372: uiutil.cabo2b;
373: draw_tabs;
374: uiutil.cabo3;
375:
376:
377: v_pieces := utl_http.request_pieces(etrm_static.index_url);
378: for i in 1 .. v_pieces.count loop
380: htp.prn(v_menu);
381: end loop;
382:
383:
384: uiutil.cabo4;
385: quick_list;
386: uiutil.cabo5;
387: htp.p(etrm_static.etrm_home1);
388: -- draw_form(c_search);
382:
383:
384: uiutil.cabo4;
385: quick_list;
386: uiutil.cabo5;
387: htp.p(etrm_static.etrm_home1);
388: -- draw_form(c_search);
389: if c_search is NULL then
390: htp.p(etrm_static.etrm_home2);
395:
396: for o_rec in cur_object(replace(v_search, ' ', '')) loop
397: v_items_found := v_items_found + 1;
398: htp.p('
410:
411: for a_rec in cur_app(replace(v_search, ' ', '')) loop
412: v_items_found := v_items_found + 1;
413: htp.p('
436: if v_items_found = 0 then
437: htp.p('Your search: '||FND_CSS_PKG.Encode(c_search)||' did not match any table, view or
438: column description in this database.');
439: end if;
440: uiutil.cabo6;
441: end search;
442:
443: procedure help is
444: begin
441: end search;
442:
443: procedure help is
444: begin
445: uiutil.cabo1(c_title => 'eTRM Help');
446: htp.p('
446: htp.p('
');