110: l_hazard_class PO_HAZARD_CLASSES.HAZARD_CLASS%TYPE;
111: l_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
112:
113: l_item_short_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
114: l_item_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
115:
116: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
117: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
118: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
112:
113: l_item_short_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
114: l_item_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
115:
116: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
117: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
118: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
119: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
120: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
140: --
141: l_global_flag po_headers_all.global_agreement_flag%type;
142:
143: -- PO_WF_NOTIF_HEADER_NOTE
144: l_header_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;
145:
146:
147: -- PO_WF_NOTIF_SHIPMENT_NOTE
148: l_shipment_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;
144: l_header_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;
145:
146:
147: -- PO_WF_NOTIF_SHIPMENT_NOTE
148: l_shipment_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;
149:
150:
151: -- variable to hold html string for attachments
152: l_attachments_text varchar2(32000) := '';
667: end if;
668:
669: elsif (l_datatype_id = 2) then
670:
671: select long_text into l_long_text from fnd_documents_long_text
672: where media_id = l_media_id;
673:
674: if (l_attachments_text is null) then
675:
726: end if;
727:
728: elsif (l_datatype_id = 2) then
729:
730: select long_text into l_long_text from fnd_documents_long_text
731: where media_id = l_media_id;
732:
733: if (l_attachments_text is null) then
734:
991: select short_text into l_item_short_text from fnd_documents_short_text
992: where media_id = l_media_id;
993: l_document := l_document || '
' || l_item_short_text ||'
'|| NL;' || l_item_long_text ||'
'|| NL;
1042: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1043: '
'|| l_text ||'
'|| NL;
1092: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1093: '
'|| l_text ||'
'|| NL;
1125: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1126: '
'|| l_text ||'
'|| NL;
1300:
1301: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
1302:
1303: elsif (l_datatype_id = 2) then
1304: select long_text into l_long_text from fnd_documents_long_text
1305: where media_id = l_media_id;
1306:
1307: l_document := l_document || '
' || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_long_text || NL;
1308:
1587: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||
1588: ' ' || l_text || NL;
1589:
1590: elsif (l_datatype_id = 2) then
1591: select long_text into l_long_text from fnd_documents_long_text
1592: where media_id = l_media_id;
1593:
1594: l_document := l_document || '
' || ' ' ||
1595: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||
1823: end if;
1824:
1825: elsif (l_datatype_id = 2) then
1826:
1827: select long_text into l_long_text from fnd_documents_long_text
1828: where media_id = l_media_id;
1829:
1830: if (length(l_attachments_text) = 0) then
1831:
1880: end if;
1881:
1882: elsif (l_datatype_id = 2) then
1883:
1884: select long_text into l_long_text from fnd_documents_long_text
1885: where media_id = l_media_id;
1886:
1887: if (l_attachments_text is null) then
1888:
1988: select short_text into l_item_short_text from fnd_documents_short_text
1989: where media_id = l_media_id;
1990: l_document := l_document ||'
'|| l_item_short_text ||'
'|| NL;'|| l_item_long_text ||'
'|| NL;
2046:
2047: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2048:
2049: elsif (l_datatype_id = 2) then
2050: select long_text into l_long_text from fnd_documents_long_text
2051: where media_id = l_media_id;
2052:
2053: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2054:
2091: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2092: '
'|| l_text ||'
'|| NL;
2125: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2126: '
'|| l_text ||'
'|| NL;
2206:
2207: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2208:
2209: elsif (l_datatype_id = 2) then
2210: select long_text into l_long_text from fnd_documents_long_text
2211: where media_id = l_media_id;
2212:
2213: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2214: