APPS.JTF_NOTES_UTIL_PVT dependencies on DBMS_LOB

Line 163: chunksize := DBMS_LOB.getchunksize(l_notes_detail);

159: FETCH c_get_notes_detail
160: INTO l_notes_detail;
161: CLOSE c_get_notes_detail;
162:
163: chunksize := DBMS_LOB.getchunksize(l_notes_detail);
164:
165: If chunksize is not null then
166:
167: if chunksize < 32767 then

Line 171: dbms_lob.read(l_notes_detail,amount,position,buffer);

167: if chunksize < 32767 then
168: amount := (32767/chunksize) * chunksize;
169: end if;
170:
171: dbms_lob.read(l_notes_detail,amount,position,buffer);
172:
173: end if;
174:
175: RETURN buffer;

Line 224: SELECT DECODE(DBMS_LOB.SUBSTR(notes_detail,1,1),NULL,'N','Y') hasCLOB

220: CURSOR c_note
221: (
222: p_note_id VARCHAR2
223: ) IS
224: SELECT DECODE(DBMS_LOB.SUBSTR(notes_detail,1,1),NULL,'N','Y') hasCLOB
225: FROM jtf_notes_tl
226: WHERE jtf_note_id = p_note_id
227: AND language = userenv('LANG');
228: