DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on FND_DOCUMENTS_LONG_TEXT

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

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;

Line 116: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_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;
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;

Line 144: l_header_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%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;

Line 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) := '';

Line 671: select long_text into l_long_text from fnd_documents_long_text

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:

Line 730: select long_text into l_long_text from fnd_documents_long_text

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:

Line 995: select long_text into l_item_long_text from fnd_documents_long_text

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;
994: elsif (l_datatype_id = 2) then
995: select long_text into l_item_long_text from fnd_documents_long_text
996: where media_id = l_media_id;
997: l_document := l_document || '
' || l_item_long_text ||'
'|| NL;
998: else
999: null;

Line 1046: select long_text into l_long_text from fnd_documents_long_text

1042: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1043: '

'|| l_text ||'
'|| NL;
1044:
1045: elsif (l_datatype_id = 2) then
1046: select long_text into l_long_text from fnd_documents_long_text
1047: where media_id = l_media_id;
1048:
1049: l_document := l_document || '
' ||
1050: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1096: select long_text into l_long_text from fnd_documents_long_text

1092: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1093: '

'|| l_text ||'
'|| NL;
1094:
1095: elsif (l_datatype_id = 2) then
1096: select long_text into l_long_text from fnd_documents_long_text
1097: where media_id = l_media_id;
1098:
1099: l_document := l_document || '
' ||
1100: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1129: select long_text into l_long_text from fnd_documents_long_text

1125: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1126: '

'|| l_text ||'
'|| NL;
1127:
1128: elsif (l_datatype_id = 2) then
1129: select long_text into l_long_text from fnd_documents_long_text
1130: where media_id = l_media_id;
1131:
1132: l_document := l_document || '
' ||
1133: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1304: select long_text into l_long_text from fnd_documents_long_text

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:

Line 1591: select long_text into l_long_text from fnd_documents_long_text

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') ||

Line 1827: select long_text into l_long_text from fnd_documents_long_text

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:

Line 1884: select long_text into l_long_text from fnd_documents_long_text

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:

Line 1992: select long_text into l_item_long_text from fnd_documents_long_text

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;
1991: elsif (l_datatype_id = 2) then
1992: select long_text into l_item_long_text from fnd_documents_long_text
1993: where media_id = l_media_id;
1994: l_document := l_document ||'
'|| l_item_long_text ||'
'|| NL;
1995: else
1996: null;

Line 2050: select long_text into l_long_text from fnd_documents_long_text

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:

Line 2095: select long_text into l_long_text from fnd_documents_long_text

2091: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2092: '

'|| l_text ||'
'|| NL;
2093:
2094: elsif (l_datatype_id = 2) then
2095: select long_text into l_long_text from fnd_documents_long_text
2096: where media_id = l_media_id;
2097:
2098: l_document := l_document || '
' ||
2099: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 2129: select long_text into l_long_text from fnd_documents_long_text

2125: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2126: '

'|| l_text ||'
'|| NL;
2127:
2128: elsif (l_datatype_id = 2) then
2129: select long_text into l_long_text from fnd_documents_long_text
2130: where media_id = l_media_id;
2131:
2132: l_document := l_document || '
' ||
2133: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 2210: select long_text into l_long_text from fnd_documents_long_text

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: