DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on FND_DOCUMENTS_LONG_TEXT

Line 118: l_item_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;

114: l_hazard_class PO_HAZARD_CLASSES.HAZARD_CLASS%TYPE;
115: l_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
116:
117: l_item_short_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
118: l_item_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
119:
120: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
121: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;

Line 120: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;

116:
117: l_item_short_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
118: l_item_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
119:
120: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
121: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;

Line 148: l_header_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;

144: --
145: l_global_flag po_headers_all.global_agreement_flag%type;
146:
147: -- PO_WF_NOTIF_HEADER_NOTE
148: l_header_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;
149:
150:
151: -- PO_WF_NOTIF_SHIPMENT_NOTE
152: l_shipment_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;

Line 152: l_shipment_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;

148: l_header_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;
149:
150:
151: -- PO_WF_NOTIF_SHIPMENT_NOTE
152: l_shipment_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;
153:
154:
155: -- variable to hold html string for attachments
156: l_attachments_text varchar2(32000) := '';

Line 752: select long_text into l_long_text from fnd_documents_long_text

748: end if;
749:
750: elsif (l_datatype_id = 2) then
751:
752: select long_text into l_long_text from fnd_documents_long_text
753: where media_id = l_media_id;
754:
755: if (l_attachments_text is null) then
756:

Line 811: select long_text into l_long_text from fnd_documents_long_text

807: end if;
808:
809: elsif (l_datatype_id = 2) then
810:
811: select long_text into l_long_text from fnd_documents_long_text
812: where media_id = l_media_id;
813:
814: if (l_attachments_text is null) then
815:

Line 1144: select long_text into l_item_long_text from fnd_documents_long_text

1140: select short_text into l_item_short_text from fnd_documents_short_text
1141: where media_id = l_media_id;
1142: l_document := l_document || '

' || l_item_short_text ||'
'|| NL;
1143: elsif (l_datatype_id = 2) then
1144: select long_text into l_item_long_text from fnd_documents_long_text
1145: where media_id = l_media_id;
1146: l_document := l_document || '
' || l_item_long_text ||'
'|| NL;
1147: else
1148: null;

Line 1195: select long_text into l_long_text from fnd_documents_long_text

1191: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1192: '

'|| l_text ||'
'|| NL;
1193:
1194: elsif (l_datatype_id = 2) then
1195: select long_text into l_long_text from fnd_documents_long_text
1196: where media_id = l_media_id;
1197:
1198: l_document := l_document || '
' ||
1199: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1245: select long_text into l_long_text from fnd_documents_long_text

1241: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1242: '

'|| l_text ||'
'|| NL;
1243:
1244: elsif (l_datatype_id = 2) then
1245: select long_text into l_long_text from fnd_documents_long_text
1246: where media_id = l_media_id;
1247:
1248: l_document := l_document || '
' ||
1249: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1278: select long_text into l_long_text from fnd_documents_long_text

1274: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1275: '

'|| l_text ||'
'|| NL;
1276:
1277: elsif (l_datatype_id = 2) then
1278: select long_text into l_long_text from fnd_documents_long_text
1279: where media_id = l_media_id;
1280:
1281: l_document := l_document || '
' ||
1282: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1471: select long_text into l_long_text from fnd_documents_long_text

1467:
1468: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
1469:
1470: elsif (l_datatype_id = 2) then
1471: select long_text into l_long_text from fnd_documents_long_text
1472: where media_id = l_media_id;
1473:
1474: l_document := l_document || '
' || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_long_text || NL;
1475:

Line 1781: select long_text into l_long_text from fnd_documents_long_text

1777: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||
1778: ' ' || l_text || NL;
1779:
1780: elsif (l_datatype_id = 2) then
1781: select long_text into l_long_text from fnd_documents_long_text
1782: where media_id = l_media_id;
1783:
1784: l_document := l_document || '
' || ' ' ||
1785: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||

Line 2027: select long_text into l_long_text from fnd_documents_long_text

2023: end if;
2024:
2025: elsif (l_datatype_id = 2) then
2026:
2027: select long_text into l_long_text from fnd_documents_long_text
2028: where media_id = l_media_id;
2029:
2030: if (length(l_attachments_text) = 0) then
2031:

Line 2084: select long_text into l_long_text from fnd_documents_long_text

2080: end if;
2081:
2082: elsif (l_datatype_id = 2) then
2083:
2084: select long_text into l_long_text from fnd_documents_long_text
2085: where media_id = l_media_id;
2086:
2087: if (l_attachments_text is null) then
2088:

Line 2193: select long_text into l_item_long_text from fnd_documents_long_text

2189: select short_text into l_item_short_text from fnd_documents_short_text
2190: where media_id = l_media_id;
2191: l_document := l_document ||'

'|| l_item_short_text ||'
'|| NL;
2192: elsif (l_datatype_id = 2) then
2193: select long_text into l_item_long_text from fnd_documents_long_text
2194: where media_id = l_media_id;
2195: l_document := l_document ||'
'|| l_item_long_text ||'
'|| NL;
2196: else
2197: null;

Line 2253: select long_text into l_long_text from fnd_documents_long_text

2249:
2250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2251:
2252: elsif (l_datatype_id = 2) then
2253: select long_text into l_long_text from fnd_documents_long_text
2254: where media_id = l_media_id;
2255:
2256: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2257:

Line 2298: select long_text into l_long_text from fnd_documents_long_text

2294: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2295: '

'|| l_text ||'
'|| NL;
2296:
2297: elsif (l_datatype_id = 2) then
2298: select long_text into l_long_text from fnd_documents_long_text
2299: where media_id = l_media_id;
2300:
2301: l_document := l_document || '
' ||
2302: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 2332: select long_text into l_long_text from fnd_documents_long_text

2328: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2329: '

'|| l_text ||'
'|| NL;
2330:
2331: elsif (l_datatype_id = 2) then
2332: select long_text into l_long_text from fnd_documents_long_text
2333: where media_id = l_media_id;
2334:
2335: l_document := l_document || '
' ||
2336: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 2431: select long_text into l_long_text from fnd_documents_long_text

2427:
2428: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2429:
2430: elsif (l_datatype_id = 2) then
2431: select long_text into l_long_text from fnd_documents_long_text
2432: where media_id = l_media_id;
2433:
2434: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2435: