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_ELEMENTS_PKG dependencies on DBMS_LOB

Line 218: DBMS_LOB.getlength(x_description)>0) THEN

214: AND t.language = l.language_code);
215:
216: --INSERT given clob INTO clob_locator FOR all languages.
217: IF(x_description IS NOT NULL AND
218: DBMS_LOB.getlength(x_description)>0) THEN
219:
220: l_srclen := DBMS_LOB.getlength(x_description);
221:
222: FOR rectl IN c_tl(x_element_id) LOOP

Line 220: l_srclen := DBMS_LOB.getlength(x_description);

216: --INSERT given clob INTO clob_locator FOR all languages.
217: IF(x_description IS NOT NULL AND
218: DBMS_LOB.getlength(x_description)>0) THEN
219:
220: l_srclen := DBMS_LOB.getlength(x_description);
221:
222: FOR rectl IN c_tl(x_element_id) LOOP
223:
224: DBMS_LOB.copy(rectl.description, x_description, l_srclen, 1,1);

Line 224: DBMS_LOB.copy(rectl.description, x_description, l_srclen, 1,1);

220: l_srclen := DBMS_LOB.getlength(x_description);
221:
222: FOR rectl IN c_tl(x_element_id) LOOP
223:
224: DBMS_LOB.copy(rectl.description, x_description, l_srclen, 1,1);
225:
226: END LOOP;
227:
228: END IF;

Line 396: DBMS_LOB.compare(x_description, tlinfo.description,

392: IF (tlinfo.baselang = 'Y') THEN
393: IF ( ((tlinfo.name = x_name)
394: OR ((tlinfo.name IS NULL) AND (x_name IS NULL)))
395: AND ((
396: DBMS_LOB.compare(x_description, tlinfo.description,
397: DBMS_LOB.getlength(x_description),1,1)=0 )
398: OR ((tlinfo.description IS NULL) AND (x_description IS NULL)))
399: ) THEN
400: NULL;

Line 397: DBMS_LOB.getlength(x_description),1,1)=0 )

393: IF ( ((tlinfo.name = x_name)
394: OR ((tlinfo.name IS NULL) AND (x_name IS NULL)))
395: AND ((
396: DBMS_LOB.compare(x_description, tlinfo.description,
397: DBMS_LOB.getlength(x_description),1,1)=0 )
398: OR ((tlinfo.description IS NULL) AND (x_description IS NULL)))
399: ) THEN
400: NULL;
401: ELSE

Line 531: DBMS_LOB.getlength(x_description)>0) THEN

527: WHERE element_id = x_element_id
528: AND USERENV('LANG') IN (language, source_lang);
529:
530: IF(x_description IS NOT NULL AND
531: DBMS_LOB.getlength(x_description)>0) THEN
532: l_srclen := DBMS_LOB.getlength(x_description);
533:
534: FOR rectl IN c_tl(x_element_id) LOOP
535: DBMS_LOB.copy(rectl.description, x_description, l_srclen, 1,1);

Line 532: l_srclen := DBMS_LOB.getlength(x_description);

528: AND USERENV('LANG') IN (language, source_lang);
529:
530: IF(x_description IS NOT NULL AND
531: DBMS_LOB.getlength(x_description)>0) THEN
532: l_srclen := DBMS_LOB.getlength(x_description);
533:
534: FOR rectl IN c_tl(x_element_id) LOOP
535: DBMS_LOB.copy(rectl.description, x_description, l_srclen, 1,1);
536: END LOOP;

Line 535: DBMS_LOB.copy(rectl.description, x_description, l_srclen, 1,1);

531: DBMS_LOB.getlength(x_description)>0) THEN
532: l_srclen := DBMS_LOB.getlength(x_description);
533:
534: FOR rectl IN c_tl(x_element_id) LOOP
535: DBMS_LOB.copy(rectl.description, x_description, l_srclen, 1,1);
536: END LOOP;
537:
538: END IF;
539:

Line 597: OR DBMS_LOB.compare(subb.description, subt.description,

593: AND subb.language = subt.source_lang
594: AND (subb.name <> subt.name
595: OR (subb.name IS NULL AND subt.name IS NOT NULL)
596: OR (subb.name IS NOT NULL AND subt.name IS NULL)
597: OR DBMS_LOB.compare(subb.description, subt.description,
598: DBMS_LOB.getlength(subb.description), 1,1)<>0
599: OR (subb.description IS NULL AND subt.description IS NOT NULL)
600: OR (subb.description IS NOT NULL AND subt.description IS NULL)
601: ));

Line 598: DBMS_LOB.getlength(subb.description), 1,1)<>0

594: AND (subb.name <> subt.name
595: OR (subb.name IS NULL AND subt.name IS NOT NULL)
596: OR (subb.name IS NOT NULL AND subt.name IS NULL)
597: OR DBMS_LOB.compare(subb.description, subt.description,
598: DBMS_LOB.getlength(subb.description), 1,1)<>0
599: OR (subb.description IS NULL AND subt.description IS NOT NULL)
600: OR (subb.description IS NOT NULL AND subt.description IS NULL)
601: ));
602:

Line 665: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);

661:
662: BEGIN
663: -- write desc to temporary clob
664: IF(x_description IS NOT NULL ) THEN
665: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);
666: l_offset := 1;
667: l_amt := length(x_description);
668: DBMS_LOB.write(l_clob, l_amt, l_offset, x_description);
669: END IF;

Line 668: DBMS_LOB.write(l_clob, l_amt, l_offset, x_description);

664: IF(x_description IS NOT NULL ) THEN
665: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);
666: l_offset := 1;
667: l_amt := length(x_description);
668: DBMS_LOB.write(l_clob, l_amt, l_offset, x_description);
669: END IF;
670:
671: -- UPDATE translated non-clob portions FOR specified language
672: UPDATE CS_KB_ELEMENTS_TL SET

Line 685: DBMS_LOB.getlength(l_clob)>0) THEN

681: --copy given clob INTO clob_locator FOR current language.
682: FOR rectl IN c_tl(x_element_id) LOOP
683: l_srclen := 0;
684: IF(x_description IS NOT NULL AND
685: DBMS_LOB.getlength(l_clob)>0) THEN
686: l_srclen := DBMS_LOB.getlength(l_clob);
687: END IF;
688:
689: l_destlen := DBMS_LOB.getlength(rectl.description);

Line 686: l_srclen := DBMS_LOB.getlength(l_clob);

682: FOR rectl IN c_tl(x_element_id) LOOP
683: l_srclen := 0;
684: IF(x_description IS NOT NULL AND
685: DBMS_LOB.getlength(l_clob)>0) THEN
686: l_srclen := DBMS_LOB.getlength(l_clob);
687: END IF;
688:
689: l_destlen := DBMS_LOB.getlength(rectl.description);
690:

Line 689: l_destlen := DBMS_LOB.getlength(rectl.description);

685: DBMS_LOB.getlength(l_clob)>0) THEN
686: l_srclen := DBMS_LOB.getlength(l_clob);
687: END IF;
688:
689: l_destlen := DBMS_LOB.getlength(rectl.description);
690:
691: IF(l_destlen > l_srclen) THEN
692: DBMS_LOB.trim(rectl.description, l_srclen);
693: END IF;

Line 692: DBMS_LOB.trim(rectl.description, l_srclen);

688:
689: l_destlen := DBMS_LOB.getlength(rectl.description);
690:
691: IF(l_destlen > l_srclen) THEN
692: DBMS_LOB.trim(rectl.description, l_srclen);
693: END IF;
694:
695: IF(x_description IS NOT NULL AND
696: DBMS_LOB.getlength(l_clob)>0) THEN

Line 696: DBMS_LOB.getlength(l_clob)>0) THEN

692: DBMS_LOB.trim(rectl.description, l_srclen);
693: END IF;
694:
695: IF(x_description IS NOT NULL AND
696: DBMS_LOB.getlength(l_clob)>0) THEN
697: --DBMS_LOB.copy(rectl.description, l_clob, DBMS_LOB.lobmaxsize, 1,1);
698: DBMS_LOB.copy(rectl.description, l_clob, l_srclen, 1,1);
699: END IF;
700: END LOOP;

Line 697: --DBMS_LOB.copy(rectl.description, l_clob, DBMS_LOB.lobmaxsize, 1,1);

693: END IF;
694:
695: IF(x_description IS NOT NULL AND
696: DBMS_LOB.getlength(l_clob)>0) THEN
697: --DBMS_LOB.copy(rectl.description, l_clob, DBMS_LOB.lobmaxsize, 1,1);
698: DBMS_LOB.copy(rectl.description, l_clob, l_srclen, 1,1);
699: END IF;
700: END LOOP;
701:

Line 698: DBMS_LOB.copy(rectl.description, l_clob, l_srclen, 1,1);

694:
695: IF(x_description IS NOT NULL AND
696: DBMS_LOB.getlength(l_clob)>0) THEN
697: --DBMS_LOB.copy(rectl.description, l_clob, DBMS_LOB.lobmaxsize, 1,1);
698: DBMS_LOB.copy(rectl.description, l_clob, l_srclen, 1,1);
699: END IF;
700: END LOOP;
701:
702: IF(x_description IS NOT NULL) THEN

Line 703: DBMS_LOB.freetemporary(l_clob);

699: END IF;
700: END LOOP;
701:
702: IF(x_description IS NOT NULL) THEN
703: DBMS_LOB.freetemporary(l_clob);
704: END IF;
705:
706: EXCEPTION
707: WHEN NO_DATA_FOUND THEN

Line 743: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);

739: -- write desc to clob
740:
741: IF( x_description IS NOT NULL) THEN
742:
743: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);
744: l_offset := 1;
745: l_amt := length(x_description);
746: DBMS_LOB.write(l_clob, l_amt, l_offset, x_description);
747:

Line 746: DBMS_LOB.write(l_clob, l_amt, l_offset, x_description);

742:
743: DBMS_LOB.createtemporary(l_clob, true, DBMS_LOB.session);
744: l_offset := 1;
745: l_amt := length(x_description);
746: DBMS_LOB.write(l_clob, l_amt, l_offset, x_description);
747:
748: END IF;
749:
750: Update_Row(

Line 788: DBMS_LOB.freetemporary(l_clob);

784: x_locked_by => NULL,
785: x_lock_date => NULL);
786:
787: IF(x_description IS NOT NULL) THEN
788: DBMS_LOB.freetemporary(l_clob);
789: END IF;
790:
791: END Load_Row;
792:

Line 843: dbms_lob.getlength(l_clob)>0) THEN

839: FOR recTL IN C_TL LOOP
840: l_srclen := 0;
841: IF (l_clob IS NOT NULL AND
842:
843: dbms_lob.getlength(l_clob)>0) THEN
844: l_srclen := dbms_lob.getlength(l_clob);
845: dbms_lob.copy(recTL.description, l_clob, l_srclen, 1,1);
846:
847: END IF;

Line 844: l_srclen := dbms_lob.getlength(l_clob);

840: l_srclen := 0;
841: IF (l_clob IS NOT NULL AND
842:
843: dbms_lob.getlength(l_clob)>0) THEN
844: l_srclen := dbms_lob.getlength(l_clob);
845: dbms_lob.copy(recTL.description, l_clob, l_srclen, 1,1);
846:
847: END IF;
848:

Line 845: dbms_lob.copy(recTL.description, l_clob, l_srclen, 1,1);

841: IF (l_clob IS NOT NULL AND
842:
843: dbms_lob.getlength(l_clob)>0) THEN
844: l_srclen := dbms_lob.getlength(l_clob);
845: dbms_lob.copy(recTL.description, l_clob, l_srclen, 1,1);
846:
847: END IF;
848:
849: END LOOP;