392: return short_note;
393: elsif header_note_datatype_id = 2 then
394: select long_text
395: into long_note
396: from fnd_documents_long_text
397: where media_id = header_note_media_id;
398: return long_note;
399: else
400: return 'Attachment is not a Text format';
414: return short_note;
415: elsif line_note_datatype_id = 2 then
416: select long_text
417: into long_note
418: from fnd_documents_long_text
419: where media_id = line_note_media_id;
420: return long_note;
421: else
422: return 'Attachment is not a Text format';
436: return short_note;
437: elsif item_note_datatype_id = 2 then
438: select long_text
439: into long_note
440: from fnd_documents_long_text
441: where media_id = item_note_media_id;
442: return long_note;
443: else
444: return 'Attachment is not a Text format';