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_SEARCH dependencies on ETRM_SEARCH

Line 1: package body etrm_search as

1: package body etrm_search as
2: ----------------------------------------------------------------------------
3: -- Copyright ? 2001, 2014, Oracle and/or its affiliates. All rights reserved.
4: -- eTRM: Oracle Applications repository browser and dependency report
5: -- Author: Peter Goldthorp 9 October 2001

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

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'

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

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

Line 48: -- uiutil.render_tab(c_url => 'etrm_search.search'

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:

Line 98: htp.p('
');

94: where app.application_id = tl.application_id
95: order by app.application_short_name;
96:
97: begin
98: htp.p('');
99:
100: if c_search is null then
101: htp.p('

Enter a search condition then press ''Search''

');
102: else

Line 145: from fnd_etrm_search_tmp

141:
142:
143: cursor cur_search is
144: select app_id, obj_id, obj_type, count(*) hits
145: from fnd_etrm_search_tmp
146: group by app_id, obj_id, obj_type
147: order by count(*) desc;
148:
149:

Line 152: type va_table_id is table of fnd_etrm_search_tmp.obj_id%type;

148:
149:
150:
151:
152: type va_table_id is table of fnd_etrm_search_tmp.obj_id%type;
153: type va_application_id is table of fnd_etrm_search_tmp.app_id%type;
154: type va_obj_type is table of fnd_etrm_search_tmp.obj_type%type;
155: type va_col_count is table of number(8);
156:

Line 153: type va_application_id is table of fnd_etrm_search_tmp.app_id%type;

149:
150:
151:
152: type va_table_id is table of fnd_etrm_search_tmp.obj_id%type;
153: type va_application_id is table of fnd_etrm_search_tmp.app_id%type;
154: type va_obj_type is table of fnd_etrm_search_tmp.obj_type%type;
155: type va_col_count is table of number(8);
156:
157:

Line 154: type va_obj_type is table of fnd_etrm_search_tmp.obj_type%type;

150:
151:
152: type va_table_id is table of fnd_etrm_search_tmp.obj_id%type;
153: type va_application_id is table of fnd_etrm_search_tmp.app_id%type;
154: type va_obj_type is table of fnd_etrm_search_tmp.obj_type%type;
155: type va_col_count is table of number(8);
156:
157:
158: vl_table_id va_table_id;

Line 177: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)

173: v_stmt varchar2(32000);
174:
175: begin
176: v_stmt :=
177: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
178: select application_id, table_id, ''COL''
179: from fnd_columns c1
180: where catsearch(c1.description, :search, null) > 0';
181:

Line 185: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)

181:
182: execute immediate v_stmt using c_search;
183:
184: v_stmt :=
185: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
186: select application_id, table_id, ''TAB''
187: from fnd_tables c1
188: where catsearch(c1.description, :search, null) > 0';
189:

Line 193: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)

189:
190: execute immediate v_stmt using c_search;
191:
192: v_stmt :=
193: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
194: select application_id, view_id, ''VW''
195: from fnd_views c1
196: where catsearch(c1.description, :search, null) > 0';
197:

Line 366: owa_cookie.send('etrm_search_context', v_search);

362: -- This wraps the following packages in an HTTP header
363: owa_util.mime_header('text/html', FALSE);
364:
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;

Line 455: end etrm_search;

451: htp.p('');
452: htp.p('');
453: end help;
454:
455: end etrm_search;