APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on DBMS_LOB

Line 845: DBMS_LOB.TRIM(l_clob2, 0);

841: where element_id = p_element_id
842: and language = USERENV('LANG')
843: for update;
844:
845: DBMS_LOB.TRIM(l_clob2, 0);
846: DBMS_LOB.COPY(l_clob2, l_clob1, DBMS_LOB.GETLENGTH(l_clob1));
847:
848: JTF_NOTES_PKG.DELETE_ROW(p_note_id);
849:

Line 846: DBMS_LOB.COPY(l_clob2, l_clob1, DBMS_LOB.GETLENGTH(l_clob1));

842: and language = USERENV('LANG')
843: for update;
844:
845: DBMS_LOB.TRIM(l_clob2, 0);
846: DBMS_LOB.COPY(l_clob2, l_clob1, DBMS_LOB.GETLENGTH(l_clob1));
847:
848: JTF_NOTES_PKG.DELETE_ROW(p_note_id);
849:
850: EXCEPTION

Line 868: dbms_lob.CREATETEMPORARY(l_clob_loc, TRUE, DBMS_LOB.session);

864: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id
865: and cs_kb_elements_tl.language = USERENV('LANG');
866:
867: BEGIN
868: dbms_lob.CREATETEMPORARY(l_clob_loc, TRUE, DBMS_LOB.session);
869: DBMS_LOB.TRIM(l_clob_loc, 0);
870:
871: open c1(p_set_id);
872: loop

Line 869: DBMS_LOB.TRIM(l_clob_loc, 0);

865: and cs_kb_elements_tl.language = USERENV('LANG');
866:
867: BEGIN
868: dbms_lob.CREATETEMPORARY(l_clob_loc, TRUE, DBMS_LOB.session);
869: DBMS_LOB.TRIM(l_clob_loc, 0);
870:
871: open c1(p_set_id);
872: loop
873: fetch c1 INTO l_temp_CLOB_LOC;

Line 875: dbms_lob.append(l_clob_loc, l_temp_clob_loc);

871: open c1(p_set_id);
872: loop
873: fetch c1 INTO l_temp_CLOB_LOC;
874: exit when c1%NOTFOUND;
875: dbms_lob.append(l_clob_loc, l_temp_clob_loc);
876: dbms_lob.writeappend(l_clob_loc, 1, ' ');
877: end loop;
878: close c1;
879: return l_clob_loc;

Line 876: dbms_lob.writeappend(l_clob_loc, 1, ' ');

872: loop
873: fetch c1 INTO l_temp_CLOB_LOC;
874: exit when c1%NOTFOUND;
875: dbms_lob.append(l_clob_loc, l_temp_clob_loc);
876: dbms_lob.writeappend(l_clob_loc, 1, ' ');
877: end loop;
878: close c1;
879: return l_clob_loc;
880: END Get_Concatenated_Elmt_Details;

Line 3209: x_sourceLength := DBMS_LOB.getlength(p_clob);

3205: THEN
3206: RETURN;
3207: END IF;
3208:
3209: x_sourceLength := DBMS_LOB.getlength(p_clob);
3210:
3211: IF (x_sourceLength = 0)
3212: THEN
3213: RETURN;

Line 3216: chunkSize := DBMS_LOB.GETCHUNKSIZE(p_clob);

3212: THEN
3213: RETURN;
3214: END IF;
3215:
3216: chunkSize := DBMS_LOB.GETCHUNKSIZE(p_clob);
3217: -- BugFix 3995241 21-Apr-2005 MK
3218: -- chunksize reduced to allow for expansion after Encode_Text api call
3219: IF (chunkSize > 6553)
3220: THEN

Line 3230: DBMS_LOB.READ(p_clob, chunkSize, chunkPos, x_Buf);

3226: -- read in chunks
3227: WHILE (chunkPos<= x_sourceLength) AND
3228: ((x_sourceLength-chunkPos) >= chunkSize)
3229: LOOP
3230: DBMS_LOB.READ(p_clob, chunkSize, chunkPos, x_Buf);
3231: FND_FILE.PUT(p_file, Encode_Text(x_Buf));
3232: chunkPos := chunkPos + chunkSize;
3233: END LOOP;
3234:

Line 3238: DBMS_LOB.READ(p_clob, amt, chunkPos, x_Buf);

3234:
3235: -- read the rest of CLOB
3236: IF ((x_sourceLength-chunkPos) < chunkSize) THEN
3237: amt := x_sourceLength-chunkPos+1;
3238: DBMS_LOB.READ(p_clob, amt, chunkPos, x_Buf);
3239: FND_FILE.PUT(p_file, Encode_Text(x_Buf));
3240: END IF;
3241:
3242: END Write_Clob_To_File;