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:
114:
115: htp.p('
226: v_display_text := v_table_name;
227: v_type := 'TABLE';
228: end if;
229:
230: htp.p('
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
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('
235: , c_display => v_display_text);
236:
237: htp.p('');
238: if v_description is not null then
239: htp.p('
241: htp.p('');
242: end if;
243:
236:
237: htp.p('');
238: if v_description is not null then
239: htp.p('
237: htp.p('');
238: if v_description is not null then
239: htp.p('
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('
259:
260: begin
261: 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:
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('');
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:
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);
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
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;
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);
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;
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
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('
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;
395:
396: for o_rec in cur_object(replace(v_search, ' ', '')) loop
394: v_items_found := 0;
395:
396: for o_rec in cur_object(replace(v_search, ' ', '')) loop
397: v_items_found := v_items_found + 1;
398: htp.p('
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
401: ||'&c_owner=' ||o_rec.owner
402: ||'&c_type=' ||o_rec.object_type
403: , c_display => o_rec.object_name);
404:
405: htp.p('');
406: htp.p('
402: ||'&c_type=' ||o_rec.object_type
403: , c_display => o_rec.object_name);
404:
405: htp.p('');
406: htp.p('
408: htp.p('');
409: end loop;
410:
403: , c_display => o_rec.object_name);
404:
405: htp.p('');
406: htp.p('
404:
405: htp.p('');
406: htp.p('
409: end loop;
410:
411: for a_rec in cur_app(replace(v_search, ' ', '')) loop
412: v_items_found := v_items_found + 1;
413: htp.p('
415: -- , c_link => 'etrm_fndnav.ls_object?n_appid=' ||a_rec.application_id
416: -- , c_display => a_rec.product_name);
417:
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:
418: htp.p('');
419: htp.p('
415: -- , c_link => 'etrm_fndnav.ls_object?n_appid=' ||a_rec.application_id
416: -- , c_display => a_rec.product_name);
417:
418: htp.p('');
419: htp.p('
421: htp.p('');
422: end loop;
423:
416: -- , c_display => a_rec.product_name);
417:
418: htp.p('');
419: htp.p('
417:
418: htp.p('');
419: 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;
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;
442:
443: procedure help is
444: begin
445: uiutil.cabo1(c_title => 'eTRM Help');
446: htp.p('');
447: htp.p('
448:
443: procedure help is
444: begin
445: uiutil.cabo1(c_title => 'eTRM Help');
446: htp.p('
445: uiutil.cabo1(c_title => 'eTRM Help');
446: htp.p('
447: htp.p('
448:
');
452: htp.p('