DBA Data[Home] [Help]

APPS.PO_POXPRREQ_XMLP_PKG dependencies on FND_DOCUMENTS_LONG_TEXT

Line 143: from fnd_documents_long_text

139: return short_note;
140: elsif line_note_datatype_id = 2 then
141: select long_text
142: into long_note
143: from fnd_documents_long_text
144: where media_id = line_note_media_id;
145: return long_note;
146: else
147: return 'Attachment is not a Text format';

Line 165: from fnd_documents_long_text

161: return short_note;
162: elsif item_note_datatype_id = 2 then
163: select long_text
164: into long_note
165: from fnd_documents_long_text
166: where media_id = item_note_media_id;
167: return long_note;
168: else
169: return 'Attachment is not a Text format';

Line 190: from fnd_documents_long_text

186: elsif header_note_datatype_id = 2 then
187: IF (header_note_media_id IS NOT NULL)THEN
188: select long_text
189: into long_note
190: from fnd_documents_long_text
191: where media_id = header_note_media_id;
192: END IF;
193: return long_note;
194: else