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 HTP

Line 80: htp.p('

eTRM Version '||v_version||'

');

76: for v_rec in cur_version loop
77: v_version := v_rec.release_name;
78: end loop;
79:
80: htp.p('

eTRM Version '||v_version||'

');
81:
82:
83: end quick_list;
84:

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 101: htp.p('
Enter a search condition then press ''Search''
');

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

Search results for: '||FND_CSS_PKG.Encode(c_search)||'

');
104: end if;
105:

Line 103: htp.p('
Search results for: '||FND_CSS_PKG.Encode(c_search)||'
');

99:
100: if c_search is null then
101: htp.p('

Enter a search condition then press ''Search''

');
102: else
103: htp.p('
Search results for: '||FND_CSS_PKG.Encode(c_search)||'
');
104: end if;
105:
106:
107: htp.p('');

Line 107: htp.p('

');

103: htp.p('

Search results for: '||FND_CSS_PKG.Encode(c_search)||'

');
104: end if;
105:
106:
107: htp.p('

');
108:
109: htp.p('');
110: htp.p('');
110: htp.p('');

Line 110: htp.p('

');

112: ||FND_CSS_PKG.Encode(c_search)
113: ||'" NAME="c_search" SIZE="50" maxlength="180">');
114:
115: htp.p('

');
116: htp.p('');
117: htp.p('

111: ');
108:
109: htp.p('

111:

106:
107: htp.p('');
108:
109: htp.p('');
110: htp.p('');
114:

Line 115: htp.p('
');

111: ');
114:
115: htp.p('
');
116: htp.p('');
117: htp.p('

111:
');
118: htp.p('');
119:

Line 116: htp.p('

');
118: htp.p('');
119:
120:

Line 117: htp.p('');

113: ||'" NAME="c_search" SIZE="50" maxlength="180">');
114:
115: htp.p('');
116: htp.p('');
117: htp.p('');
118: htp.p('');
119:
120:
121: end draw_form;

Line 118: htp.p('');

114:
115: htp.p('');
116: htp.p('');
117: htp.p('');
118: htp.p('');
119:
120:
121: end draw_form;
122:

Line 230: htp.p('
');

226: v_display_text := v_table_name;
227: v_type := 'TABLE';
228: end if;
229:
230: htp.p('

');
231: uiutil.a_javascript_gen(c_type => v_type
232: , c_link => 'etrm_fndnav.show_object?n_appid=' ||vl_application_id(i)
233: ||'&n_tabid=' ||vl_table_id(i)
234: ||'&c_type='||v_type

Line 237: htp.p('

');

233: ||'&n_tabid=' ||vl_table_id(i)
234: ||'&c_type='||v_type
235: , c_display => v_display_text);
236:
237: htp.p('');
238: if v_description is not null then
239: htp.p('

');
240: htp.p(v_description);
241: htp.p('

');

Line 239: htp.p('
');

235: , c_display => v_display_text);
236:
237: htp.p('');
238: if v_description is not null then
239: htp.p('

');
240: htp.p(v_description);
241: htp.p('

');
242: end if;
243:

Line 240: htp.p(v_description);

236:
237: htp.p('');
238: if v_description is not null then
239: htp.p('

');
240: htp.p(v_description);
241: htp.p('

');
242: end if;
243:
244: end loop;

Line 241: htp.p('');

237: htp.p('');
238: if v_description is not null then
239: htp.p('

');
240: htp.p(v_description);
241: htp.p('

');
242: end if;
243:
244: end loop;
245: rollback;

Line 261: htp.p('

Documents

');

257: where catsearch(title, c_search, null) > 0
258: order by application, title;
259:
260: begin
261: htp.p('

Documents

');
262: for t_rec in cur_find(c_search) loop
263: htp.p('

');
264: uiutil.a_javascript_gen(c_type => 'APP'
265: , c_link => 'etrm_fndnav.show_file?n_file_id='

Line 263: htp.p('
');

259:
260: begin
261: htp.p('

Documents

');
262: for t_rec in cur_find(c_search) loop
263: htp.p('

');
264: uiutil.a_javascript_gen(c_type => 'APP'
265: , c_link => 'etrm_fndnav.show_file?n_file_id='
266: ||t_rec.file_id
267: , c_display => ''||t_rec.application||': '|| t_rec.title);

Line 268: htp.p('

');

264: uiutil.a_javascript_gen(c_type => 'APP'
265: , c_link => 'etrm_fndnav.show_file?n_file_id='
266: ||t_rec.file_id
267: , c_display => ''||t_rec.application||': '|| t_rec.title);
268: htp.p('');
269:
270: end loop;
271: end find_help_text;
272:

Line 295: htp.p('Content-type: '||lob_rec.file_content_type);

291:
292: begin
293: for lob_rec in cur_get_lob(n_file_id) loop
294: lob_bytes_remaining := dbms_lob.getlength(lob_rec.file_data);
295: htp.p('Content-type: '||lob_rec.file_content_type);
296: htp.p('Content-Disposition: attachement; filename='||lob_rec.file_name);
297: htp.p('Content-Transfer-Encoding: base64');
298: -- htp.p('Content-Disposition: inline; filename='||lob_rec.file_name);
299: htp.p('');

Line 296: htp.p('Content-Disposition: attachement; filename='||lob_rec.file_name);

292: begin
293: for lob_rec in cur_get_lob(n_file_id) loop
294: lob_bytes_remaining := dbms_lob.getlength(lob_rec.file_data);
295: htp.p('Content-type: '||lob_rec.file_content_type);
296: htp.p('Content-Disposition: attachement; filename='||lob_rec.file_name);
297: htp.p('Content-Transfer-Encoding: base64');
298: -- htp.p('Content-Disposition: inline; filename='||lob_rec.file_name);
299: htp.p('');
300:

Line 297: htp.p('Content-Transfer-Encoding: base64');

293: for lob_rec in cur_get_lob(n_file_id) loop
294: lob_bytes_remaining := dbms_lob.getlength(lob_rec.file_data);
295: htp.p('Content-type: '||lob_rec.file_content_type);
296: htp.p('Content-Disposition: attachement; filename='||lob_rec.file_name);
297: htp.p('Content-Transfer-Encoding: base64');
298: -- htp.p('Content-Disposition: inline; filename='||lob_rec.file_name);
299: htp.p('');
300:
301: chunksize := dbms_lob.getchunksize(lob_rec.file_data);

Line 298: -- htp.p('Content-Disposition: inline; filename='||lob_rec.file_name);

294: lob_bytes_remaining := dbms_lob.getlength(lob_rec.file_data);
295: htp.p('Content-type: '||lob_rec.file_content_type);
296: htp.p('Content-Disposition: attachement; filename='||lob_rec.file_name);
297: htp.p('Content-Transfer-Encoding: base64');
298: -- htp.p('Content-Disposition: inline; filename='||lob_rec.file_name);
299: htp.p('');
300:
301: chunksize := dbms_lob.getchunksize(lob_rec.file_data);
302: if (chunksize < 32767) then

Line 299: htp.p('');

295: htp.p('Content-type: '||lob_rec.file_content_type);
296: htp.p('Content-Disposition: attachement; filename='||lob_rec.file_name);
297: htp.p('Content-Transfer-Encoding: base64');
298: -- htp.p('Content-Disposition: inline; filename='||lob_rec.file_name);
299: htp.p('');
300:
301: chunksize := dbms_lob.getchunksize(lob_rec.file_data);
302: if (chunksize < 32767) then
303: amount := (32767 / chunksize) * chunksize;

Line 312: htp.prn(utl_raw.cast_to_varchar2(buffer));

308: if (lob_bytes_remaining < amount) then
309: amount := lob_bytes_remaining;
310: end if;
311: dbms_lob.read(lob_rec.file_data, amount, position, buffer);
312: htp.prn(utl_raw.cast_to_varchar2(buffer));
313: position := position + amount;
314: lob_bytes_remaining := lob_bytes_remaining - amount;
315: end loop;
316: dbms_lob.close(lob_rec.file_data);

Line 380: htp.prn(v_menu);

376:
377: v_pieces := utl_http.request_pieces(etrm_static.index_url);
378: for i in 1 .. v_pieces.count loop
379: v_menu := v_pieces(i);
380: htp.prn(v_menu);
381: end loop;
382:
383:
384: uiutil.cabo4;

Line 387: htp.p(etrm_static.etrm_home1);

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);
391: else

Line 390: htp.p(etrm_static.etrm_home2);

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);
391: else
392: htp.p('

');
393: v_search := upper(c_search);
394: v_items_found := 0;

Line 392: htp.p('
');

388: -- draw_form(c_search);
389: if c_search is NULL then
390: htp.p(etrm_static.etrm_home2);
391: else
392: htp.p('

');
');
399: uiutil.a_javascript_gen(c_type => o_rec.object_type
400: , c_link => 'etrm_pnav.show_object?c_name=' ||o_rec.object_name
401: ||'&c_owner=' ||o_rec.owner
402: ||'&c_type=' ||o_rec.object_type

Line 405: htp.p(': ');
407: htp.p(o_rec.object_type || ' in the '|| o_rec.owner || ' schema.');
408: htp.p('; ');; ');
407: htp.p(o_rec.object_type || ' in the '|| o_rec.owner || ' schema.');
408: htp.p('; ');
407: htp.p(o_rec.object_type || ' in the '|| o_rec.owner || ' schema.');
408: htp.p('; ');
407: htp.p(o_rec.object_type || ' in the '|| o_rec.owner || ' schema.');
408: htp.p('
');
');
414: -- uiutil.a_href_gen(c_type => 'ROOT'
415: -- , c_link => 'etrm_fndnav.ls_object?n_appid=' ||a_rec.application_id
416: -- , c_display => a_rec.product_name);
417:

Line 418: htp.p(': ');
420: htp.p('Oracle Applications product.');
421: htp.p('; ');; ');
420: htp.p('Oracle Applications product.');
421: htp.p('; ');
420: htp.p('Oracle Applications product.');
421: htp.p('; ');
420: htp.p('Oracle Applications product.');
421: htp.p('

');

427: v_search := rtrim(v_search);
428:
429: v_search := replace(v_search, '|', '{|}'); -- escape '|' (OR) characters to prevent http 404
430: v_items_found := v_items_found + find_table(v_search);
431: htp.p('

');
432: if v_items_found < 20 then
433: v_items_found := v_items_found + find_table(replace(v_search, chr(32), '{|}'));
434: end if;
435: end if;

Line 437: htp.p('Your search: '||FND_CSS_PKG.Encode(c_search)||' did not match any table, view or

433: v_items_found := v_items_found + find_table(replace(v_search, chr(32), '{|}'));
434: end if;
435: end if;
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;

Line 446: htp.p('');

442:
443: procedure help is
444: begin
445: uiutil.cabo1(c_title => 'eTRM Help');
446: htp.p('');
447: htp.p(' Oracle
448:

');
449: htp.p(etrm_static.help_text);
450: uiutil.prn_copyright;

Line 447: htp.p('

443: procedure help is
444: begin
445: uiutil.cabo1(c_title => 'eTRM Help');
446: htp.p('');
447: htp.p('
448:

');
449: htp.p(etrm_static.help_text);
450: uiutil.prn_copyright;
451: htp.p('');

Line 449: htp.p(etrm_static.help_text);

445: uiutil.cabo1(c_title => 'eTRM Help');
446: htp.p('');
447: htp.p(' Oracle
448:

');
449: htp.p(etrm_static.help_text);
450: uiutil.prn_copyright;
451: htp.p('');
452: htp.p('');
453: end help;

Line 451: htp.p('');

447: htp.p(' Oracle
448:

');
449: htp.p(etrm_static.help_text);
450: uiutil.prn_copyright;
451: htp.p('');
452: htp.p('');
453: end help;
454:
455: end etrm_search;

Line 452: htp.p('');

448:

');
449: htp.p(etrm_static.help_text);
450: uiutil.prn_copyright;
451: htp.p('');
452: htp.p('');
453: end help;
454:
455: end etrm_search;

APPS.ETRM_SEARCH dependencies on HTP

Line 80: htp.p('

eTRM Version '||v_version||'

eTRM Version '||v_version||'

Line 98: htp.p('');

Line 101: htp.p('Enter a search condition then press ''Search''');

Line 103: htp.p('Search results for: '||FND_CSS_PKG.Encode(c_search)||'');

Line 107: htp.p('

Line 110: htp.p('

Line 115: htp.p('

Line 116: htp.p('

Line 117: htp.p('');

Line 118: htp.p('');

Line 230: htp.p('');

Line 237: htp.p('

Line 239: htp.p('');

Line 240: htp.p(v_description);

Line 241: htp.p('');

Line 261: htp.p('

Documents

Documents

Line 263: htp.p('');

Documents

Line 268: htp.p('

Line 295: htp.p('Content-type: '||lob_rec.file_content_type);

Line 296: htp.p('Content-Disposition: attachement; filename='||lob_rec.file_name);

Line 297: htp.p('Content-Transfer-Encoding: base64');

Line 298: -- htp.p('Content-Disposition: inline; filename='||lob_rec.file_name);

Line 299: htp.p('');

Line 312: htp.prn(utl_raw.cast_to_varchar2(buffer));

Line 380: htp.prn(v_menu);

Line 387: htp.p(etrm_static.etrm_home1);

Line 390: htp.p(etrm_static.etrm_home2);

Line 392: htp.p('');

Line 398: htp.p('');

Line 405: htp.p('

Line 406: htp.p('');

Line 407: htp.p(o_rec.object_type || ' in the '|| o_rec.owner || ' schema.');

Line 408: htp.p('');

Line 413: htp.p('');

Line 418: htp.p('

Line 419: htp.p('');

Line 420: htp.p('Oracle Applications product.');

Line 421: htp.p('');

Line 431: htp.p('

Line 437: htp.p('Your search: '||FND_CSS_PKG.Encode(c_search)||' did not match any table, view or

Line 447: htp.p('

Line 449: htp.p(etrm_static.help_text);

Line 451: htp.p('');

Line 452: htp.p('');

Line 98: htp.p('
');

Line 101: htp.p('
Enter a search condition then press ''Search''
');

Line 103: htp.p('
Search results for: '||FND_CSS_PKG.Encode(c_search)||'
');

Line 230: htp.p('
');

Line 239: htp.p('
');

Line 263: htp.p('
');

Line 392: htp.p('
');

Line 398: htp.p('
');

Line 406: htp.p('
');

Line 413: htp.p('
');

Line 419: htp.p('
');