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;
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;
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;
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) := '';
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:
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:
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;' || l_item_long_text ||'
'|| NL;
1191: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1192: '
'|| l_text ||'
'|| NL;
1241: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1242: '
'|| l_text ||'
'|| NL;
1274: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1275: '
'|| l_text ||'
'|| NL;
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:
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') ||
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:
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:
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;'|| l_item_long_text ||'
'|| NL;
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:
2294: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2295: '
'|| l_text ||'
'|| NL;
2328: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2329: '
'|| l_text ||'
'|| NL;
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: