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.CS_KB_KWIC_UTIL dependencies on DBMS_LOB

Line 195: dbms_lob.read(p_document,

191: WHILE (i IS NOT NULL) LOOP
192: l_open_positions(i) := l_restab(i).offset;
193: l_close_positions(i) := l_restab(i).offset + l_restab(i).length;
194:
195: dbms_lob.read(p_document,
196: l_restab(i).length,
197: l_restab(i).offset,
198: l_word );
199:

Line 231: dbms_lob.read(p_document,

227: -- read the current keyword
228: l_word_start := l_open_positions(closeIdx);
229: l_word_end := l_close_positions(closeIdx);
230: l_len := l_word_end - l_word_start;
231: dbms_lob.read(p_document,
232: l_len,
233: l_word_start,
234: l_word );
235: --dbms_output.put_line(l_word_start || ' ' || l_word_end || ' [' || l_word || ']');

Line 276: l_len := dbms_lob.getlength(p_document);

272: l_pre_segment_start := 1;
273: end if;
274: -- find the post segment end position
275: l_post_segment_end := l_best_segment_end + SEGMENT_PADDING;
276: l_len := dbms_lob.getlength(p_document);
277: if(l_post_segment_end > l_len) then
278: l_post_segment_end := l_len + 1; --last position + 1
279: end if;
280:

Line 283: dbms_lob.read(p_document,

279: end if;
280:
281: -- get the middle segment (the one with the densest keywords)
282: l_len := l_best_segment_end - l_best_segment_start;
283: dbms_lob.read(p_document,
284: l_len,
285: l_best_segment_start,
286: l_best_segment );
287:

Line 291: dbms_lob.read(p_document,

287:
288: -- now get the prefix segment
289: l_len := l_best_segment_start - l_pre_segment_start;
290: if(l_len > 0) then
291: dbms_lob.read(p_document,
292: l_len,
293: l_pre_segment_start,
294: l_pre_segment );
295: end if;

Line 300: dbms_lob.read(p_document,

296:
297: -- now get the postfix segment
298: l_len := l_post_segment_end - l_best_segment_end;
299: if(l_len > 0) then
300: dbms_lob.read(p_document,
301: l_len,
302: l_best_segment_end,
303: l_post_segment );
304: end if;

Line 445: dbms_lob.createtemporary(l_document, TRUE, dbms_lob.call);

441: AND note_status <> 'P'; -- IN ('E', 'I'); ignore private notes
442:
443: BEGIN
444: --Synthesize the document out of SR notes
445: dbms_lob.createtemporary(l_document, TRUE, dbms_lob.call);
446: FOR element IN get_sr_notes( p_sr_id ) LOOP
447: --append the note (VARCHAR)
448: l_data := element.notes;
449: IF(l_data IS NOT NULL AND

Line 451: dbms_lob.writeappend(l_document, length(l_data)+3, '...' || l_data);

447: --append the note (VARCHAR)
448: l_data := element.notes;
449: IF(l_data IS NOT NULL AND
450: length (l_data) > 0) then
451: dbms_lob.writeappend(l_document, length(l_data)+3, '...' || l_data);
452: END IF;
453:
454: --append the note detail (CLOB)
455: IF(element.notes_detail IS NOT NULL AND

Line 456: dbms_lob.getlength(element.notes_detail) > 0)

452: END IF;
453:
454: --append the note detail (CLOB)
455: IF(element.notes_detail IS NOT NULL AND
456: dbms_lob.getlength(element.notes_detail) > 0)
457: THEN
458: dbms_lob.writeappend(l_document, 3, '...');
459: dbms_lob.append(l_document, element.notes_detail);
460: END IF;

Line 458: dbms_lob.writeappend(l_document, 3, '...');

454: --append the note detail (CLOB)
455: IF(element.notes_detail IS NOT NULL AND
456: dbms_lob.getlength(element.notes_detail) > 0)
457: THEN
458: dbms_lob.writeappend(l_document, 3, '...');
459: dbms_lob.append(l_document, element.notes_detail);
460: END IF;
461:
462: END LOOP;

Line 459: dbms_lob.append(l_document, element.notes_detail);

455: IF(element.notes_detail IS NOT NULL AND
456: dbms_lob.getlength(element.notes_detail) > 0)
457: THEN
458: dbms_lob.writeappend(l_document, 3, '...');
459: dbms_lob.append(l_document, element.notes_detail);
460: END IF;
461:
462: END LOOP;
463:

Line 464: -- dbms_output.put_line('DOC_LENGTH = ' || dbms_lob.getlength(l_document));

460: END IF;
461:
462: END LOOP;
463:
464: -- dbms_output.put_line('DOC_LENGTH = ' || dbms_lob.getlength(l_document));
465: -- dbms_output.put_line(substr(l_document,1,255));
466:
467: return get_segment_kwic(p_text_query, p_starttag, p_endtag, l_document);
468:

Line 508: dbms_lob.createtemporary(l_document, TRUE, dbms_lob.call);

504: AND e.access_level >= Cs_Kb_Security_Pvt.GET_STMT_VISIBILITY_POSITION;
505:
506: BEGIN
507: --Synthesize the document out of solution statements
508: dbms_lob.createtemporary(l_document, TRUE, dbms_lob.call);
509:
510: FOR element IN get_element_content( p_set_id ) LOOP
511: --append the statement
512: l_data := element.name;

Line 515: dbms_lob.writeappend(l_document, length(l_data)+3, '...' || l_data);

511: --append the statement
512: l_data := element.name;
513: IF(l_data IS NOT NULL AND
514: length (l_data) > 0) then
515: dbms_lob.writeappend(l_document, length(l_data)+3, '...' || l_data);
516: END IF;
517:
518: --append the description (CLOB)
519: IF(element.description IS NOT NULL AND

Line 520: dbms_lob.getlength(element.description) > 0)

516: END IF;
517:
518: --append the description (CLOB)
519: IF(element.description IS NOT NULL AND
520: dbms_lob.getlength(element.description) > 0)
521: THEN
522: dbms_lob.writeappend(l_document, 3, '...');
523: dbms_lob.append(l_document, element.description);
524: END IF;

Line 522: dbms_lob.writeappend(l_document, 3, '...');

518: --append the description (CLOB)
519: IF(element.description IS NOT NULL AND
520: dbms_lob.getlength(element.description) > 0)
521: THEN
522: dbms_lob.writeappend(l_document, 3, '...');
523: dbms_lob.append(l_document, element.description);
524: END IF;
525:
526: END LOOP;

Line 523: dbms_lob.append(l_document, element.description);

519: IF(element.description IS NOT NULL AND
520: dbms_lob.getlength(element.description) > 0)
521: THEN
522: dbms_lob.writeappend(l_document, 3, '...');
523: dbms_lob.append(l_document, element.description);
524: END IF;
525:
526: END LOOP;
527:

Line 528: -- dbms_output.put_line('DOC_LENGTH = ' || dbms_lob.getlength(l_document));

524: END IF;
525:
526: END LOOP;
527:
528: -- dbms_output.put_line('DOC_LENGTH = ' || dbms_lob.getlength(l_document));
529: -- dbms_output.put_line(substr(l_document,1,255));
530:
531: return get_segment_kwic(p_text_query, p_starttag, p_endtag, l_document);
532: