DBA Data[Home] [Help]

APPS.PO_POXPRREQ_XMLP_PKG dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 137: from fnd_documents_short_text

133: begin
134: if line_note_datatype_id = 1 then
135: select short_text
136: into short_note
137: from fnd_documents_short_text
138: where media_id = line_note_media_id;
139: return short_note;
140: elsif line_note_datatype_id = 2 then
141: select long_text

Line 159: from fnd_documents_short_text

155: begin
156: if item_note_datatype_id = 1 then
157: select short_text
158: into short_note
159: from fnd_documents_short_text
160: where media_id = item_note_media_id;
161: return short_note;
162: elsif item_note_datatype_id = 2 then
163: select long_text

Line 182: from fnd_documents_short_text

178: if header_note_datatype_id = 1 then
179: IF (header_note_media_id IS NOT NULL)THEN
180: select short_text
181: into short_note
182: from fnd_documents_short_text
183: where media_id = header_note_media_id;
184: END IF;
185: return short_note;
186: elsif header_note_datatype_id = 2 then