APPS.JTF_NOTES_PKG dependencies on DBMS_LOB

Line 290: AND ((DBMS_LOB.COMPARE(tlinfo.NOTES_DETAIL , X_NOTES_DETAIL,DBMS_LOB.GETLENGTH(X_NOTES_DETAIL),1,1) = 0)

286: for tlinfo in c1 loop
287: if (tlinfo.BASELANG = 'Y') then
288: if (tlinfo.NOTES = X_NOTES) then
289: /*
290: AND ((DBMS_LOB.COMPARE(tlinfo.NOTES_DETAIL , X_NOTES_DETAIL,DBMS_LOB.GETLENGTH(X_NOTES_DETAIL),1,1) = 0)
291: OR ((tlinfo.NOTES_DETAIL is null) AND (X_NOTES_DETAIL is null)))
292: )then */
293: null;
294: else

Line 433: or (( DBMS_LOB.COMPARE(SUBB.NOTES_DETAIL, SUBT.NOTES_DETAIL,DBMS_LOB.GETLENGTH(SUBB.NOTES_DETAIL),1,1)) <> 0)

429: from JTF_NOTES_TL SUBB, JTF_NOTES_TL SUBT
430: where SUBB.JTF_NOTE_ID = SUBT.JTF_NOTE_ID
431: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
432: and (SUBB.NOTES <> SUBT.NOTES
433: or (( DBMS_LOB.COMPARE(SUBB.NOTES_DETAIL, SUBT.NOTES_DETAIL,DBMS_LOB.GETLENGTH(SUBB.NOTES_DETAIL),1,1)) <> 0)
434: or (SUBB.NOTES_DETAIL is null and SUBT.NOTES_DETAIL is not null)
435: or (SUBB.NOTES_DETAIL is not null and SUBT.NOTES_DETAIL is null)
436: ));
437: **/

Line 527: DBMS_LOB.WRITE(i.notes_detail,length(X_BUFFER),position,x_buffer);

523: Begin
524:
525: for i in c1
526: loop
527: DBMS_LOB.WRITE(i.notes_detail,length(X_BUFFER),position,x_buffer);
528: end loop;
529: End WriteDataToLob;
530:
531: FUNCTION get_note_context_value( p_note_context_type IN VARCHAR2