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 186: dbms_lob.read(p_document,

182: WHILE (i IS NOT NULL) LOOP
183: l_open_positions(i) := l_restab(i).offset;
184: l_close_positions(i) := l_restab(i).offset + l_restab(i).length;
185:
186: dbms_lob.read(p_document,
187: l_restab(i).length,
188: l_restab(i).offset,
189: l_word );
190:

Line 222: dbms_lob.read(p_document,

218: -- read the current keyword
219: l_word_start := l_open_positions(closeIdx);
220: l_word_end := l_close_positions(closeIdx);
221: l_len := l_word_end - l_word_start;
222: dbms_lob.read(p_document,
223: l_len,
224: l_word_start,
225: l_word );
226: --dbms_output.put_line(l_word_start || ' ' || l_word_end || ' [' || l_word || ']');

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

263: l_pre_segment_start := 1;
264: end if;
265: -- find the post segment end position
266: l_post_segment_end := l_best_segment_end + SEGMENT_PADDING;
267: l_len := dbms_lob.getlength(p_document);
268: if(l_post_segment_end > l_len) then
269: l_post_segment_end := l_len + 1; --last position + 1
270: end if;
271:

Line 274: dbms_lob.read(p_document,

270: end if;
271:
272: -- get the middle segment (the one with the densest keywords)
273: l_len := l_best_segment_end - l_best_segment_start;
274: dbms_lob.read(p_document,
275: l_len,
276: l_best_segment_start,
277: l_best_segment );
278:

Line 282: dbms_lob.read(p_document,

278:
279: -- now get the prefix segment
280: l_len := l_best_segment_start - l_pre_segment_start;
281: if(l_len > 0) then
282: dbms_lob.read(p_document,
283: l_len,
284: l_pre_segment_start,
285: l_pre_segment );
286: end if;

Line 291: dbms_lob.read(p_document,

287:
288: -- now get the postfix segment
289: l_len := l_post_segment_end - l_best_segment_end;
290: if(l_len > 0) then
291: dbms_lob.read(p_document,
292: l_len,
293: l_best_segment_end,
294: l_post_segment );
295: end if;

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

416: AND note_status <> 'P'; -- IN ('E', 'I'); ignore private notes
417:
418: BEGIN
419: --Synthesize the document out of SR notes
420: dbms_lob.createtemporary(l_document, TRUE, dbms_lob.call);
421: FOR element IN get_sr_notes( p_sr_id ) LOOP
422: --append the note (VARCHAR)
423: l_data := element.notes;
424: IF(l_data IS NOT NULL AND

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

422: --append the note (VARCHAR)
423: l_data := element.notes;
424: IF(l_data IS NOT NULL AND
425: length (l_data) > 0) then
426: dbms_lob.writeappend(l_document, length(l_data)+3, '...' || l_data);
427: END IF;
428:
429: --append the note detail (CLOB)
430: IF(element.notes_detail IS NOT NULL AND

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

427: END IF;
428:
429: --append the note detail (CLOB)
430: IF(element.notes_detail IS NOT NULL AND
431: dbms_lob.getlength(element.notes_detail) > 0)
432: THEN
433: dbms_lob.writeappend(l_document, 3, '...');
434: dbms_lob.append(l_document, element.notes_detail);
435: END IF;

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

429: --append the note detail (CLOB)
430: IF(element.notes_detail IS NOT NULL AND
431: dbms_lob.getlength(element.notes_detail) > 0)
432: THEN
433: dbms_lob.writeappend(l_document, 3, '...');
434: dbms_lob.append(l_document, element.notes_detail);
435: END IF;
436:
437: END LOOP;

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

430: IF(element.notes_detail IS NOT NULL AND
431: dbms_lob.getlength(element.notes_detail) > 0)
432: THEN
433: dbms_lob.writeappend(l_document, 3, '...');
434: dbms_lob.append(l_document, element.notes_detail);
435: END IF;
436:
437: END LOOP;
438:

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

435: END IF;
436:
437: END LOOP;
438:
439: -- dbms_output.put_line('DOC_LENGTH = ' || dbms_lob.getlength(l_document));
440: -- dbms_output.put_line(substr(l_document,1,255));
441:
442: return get_segment_kwic(p_text_query, p_starttag, p_endtag, l_document);
443:

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

479: AND e.access_level >= Cs_Kb_Security_Pvt.GET_STMT_VISIBILITY_POSITION;
480:
481: BEGIN
482: --Synthesize the document out of solution statements
483: dbms_lob.createtemporary(l_document, TRUE, dbms_lob.call);
484:
485: FOR element IN get_element_content( p_set_id ) LOOP
486: --append the statement
487: l_data := element.name;

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

486: --append the statement
487: l_data := element.name;
488: IF(l_data IS NOT NULL AND
489: length (l_data) > 0) then
490: dbms_lob.writeappend(l_document, length(l_data)+3, '...' || l_data);
491: END IF;
492:
493: --append the description (CLOB)
494: IF(element.description IS NOT NULL AND

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

491: END IF;
492:
493: --append the description (CLOB)
494: IF(element.description IS NOT NULL AND
495: dbms_lob.getlength(element.description) > 0)
496: THEN
497: dbms_lob.writeappend(l_document, 3, '...');
498: dbms_lob.append(l_document, element.description);
499: END IF;

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

493: --append the description (CLOB)
494: IF(element.description IS NOT NULL AND
495: dbms_lob.getlength(element.description) > 0)
496: THEN
497: dbms_lob.writeappend(l_document, 3, '...');
498: dbms_lob.append(l_document, element.description);
499: END IF;
500:
501: END LOOP;

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

494: IF(element.description IS NOT NULL AND
495: dbms_lob.getlength(element.description) > 0)
496: THEN
497: dbms_lob.writeappend(l_document, 3, '...');
498: dbms_lob.append(l_document, element.description);
499: END IF;
500:
501: END LOOP;
502:

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

499: END IF;
500:
501: END LOOP;
502:
503: -- dbms_output.put_line('DOC_LENGTH = ' || dbms_lob.getlength(l_document));
504: -- dbms_output.put_line(substr(l_document,1,255));
505:
506: return get_segment_kwic(p_text_query, p_starttag, p_endtag, l_document);
507: