APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on DBMS_LOB

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

850: where element_id = p_element_id
851: and language = USERENV('LANG')
852: for update;
853:
854: DBMS_LOB.TRIM(l_clob2, 0);
855: DBMS_LOB.COPY(l_clob2, l_clob1, DBMS_LOB.GETLENGTH(l_clob1));
856:
857: JTF_NOTES_PKG.DELETE_ROW(p_note_id);
858:

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

851: and language = USERENV('LANG')
852: for update;
853:
854: DBMS_LOB.TRIM(l_clob2, 0);
855: DBMS_LOB.COPY(l_clob2, l_clob1, DBMS_LOB.GETLENGTH(l_clob1));
856:
857: JTF_NOTES_PKG.DELETE_ROW(p_note_id);
858:
859: EXCEPTION

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

873: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id
874: and cs_kb_elements_tl.language = USERENV('LANG');
875:
876: BEGIN
877: dbms_lob.CREATETEMPORARY(l_clob_loc, TRUE, DBMS_LOB.session);
878: DBMS_LOB.TRIM(l_clob_loc, 0);
879:
880: open c1(p_set_id);
881: loop

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

874: and cs_kb_elements_tl.language = USERENV('LANG');
875:
876: BEGIN
877: dbms_lob.CREATETEMPORARY(l_clob_loc, TRUE, DBMS_LOB.session);
878: DBMS_LOB.TRIM(l_clob_loc, 0);
879:
880: open c1(p_set_id);
881: loop
882: fetch c1 INTO l_temp_CLOB_LOC;

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

880: open c1(p_set_id);
881: loop
882: fetch c1 INTO l_temp_CLOB_LOC;
883: exit when c1%NOTFOUND;
884: dbms_lob.append(l_clob_loc, l_temp_clob_loc);
885: dbms_lob.writeappend(l_clob_loc, 1, ' ');
886: end loop;
887: close c1;
888: return l_clob_loc;

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

881: loop
882: fetch c1 INTO l_temp_CLOB_LOC;
883: exit when c1%NOTFOUND;
884: dbms_lob.append(l_clob_loc, l_temp_clob_loc);
885: dbms_lob.writeappend(l_clob_loc, 1, ' ');
886: end loop;
887: close c1;
888: return l_clob_loc;
889: END Get_Concatenated_Elmt_Details;

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

3215: THEN
3216: RETURN;
3217: END IF;
3218:
3219: x_sourceLength := DBMS_LOB.getlength(p_clob);
3220:
3221: IF (x_sourceLength = 0)
3222: THEN
3223: RETURN;

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

3222: THEN
3223: RETURN;
3224: END IF;
3225:
3226: chunkSize := DBMS_LOB.GETCHUNKSIZE(p_clob);
3227: -- BugFix 3995241 21-Apr-2005 MK
3228: -- chunksize reduced to allow for expansion after Encode_Text api call
3229: IF (chunkSize > 6553)
3230: THEN

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

3236: -- read in chunks
3237: WHILE (chunkPos<= x_sourceLength) AND
3238: ((x_sourceLength-chunkPos) >= chunkSize)
3239: LOOP
3240: DBMS_LOB.READ(p_clob, chunkSize, chunkPos, x_Buf);
3241: FND_FILE.PUT(p_file, Encode_Text(x_Buf));
3242: chunkPos := chunkPos + chunkSize;
3243: END LOOP;
3244:

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

3244:
3245: -- read the rest of CLOB
3246: IF ((x_sourceLength-chunkPos) < chunkSize) THEN
3247: amt := x_sourceLength-chunkPos+1;
3248: DBMS_LOB.READ(p_clob, amt, chunkPos, x_Buf);
3249: FND_FILE.PUT(p_file, Encode_Text(x_Buf));
3250: END IF;
3251:
3252: END Write_Clob_To_File;