eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_EMAIL_GENERATE dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 111: l_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;

107: l_org_id NUMBER;
108: x_orgid NUMBER;
109: l_un_number PO_UN_NUMBERS.UN_NUMBER%TYPE;
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:

Line 113: l_item_short_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;

109: l_un_number PO_UN_NUMBERS.UN_NUMBER%TYPE;
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;

Line 654: select short_text into l_text from fnd_documents_short_text

650:
651:
652:
653: if (l_datatype_id = 1) then
654: select short_text into l_text from fnd_documents_short_text
655: where media_id = l_media_id;
656:
657:
658: if (l_attachments_text is null) then

Line 713: select short_text into l_text from fnd_documents_short_text

709:
710:
711:
712: if (l_datatype_id = 1) then
713: select short_text into l_text from fnd_documents_short_text
714: where media_id = l_media_id;
715:
716:
717: if (l_attachments_text is null) then

Line 991: select short_text into l_item_short_text from fnd_documents_short_text

987:
988: -- Bug 3129802. Should use PRE tag as the text is pre formatted
989:
990: if (l_datatype_id = 1) then
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

Line 1038: select short_text into l_text from fnd_documents_short_text

1034: exit when attachments_cursor%NOTFOUND;
1035:
1036:
1037: if (l_datatype_id = 1) then
1038: select short_text into l_text from fnd_documents_short_text
1039: where media_id = l_media_id;
1040:
1041: l_document := l_document || '
' ||
1042: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1088: select short_text into l_text from fnd_documents_short_text

1084: exit when attachments_from_ga_cursor%NOTFOUND;
1085:
1086:
1087: if (l_datatype_id = 1) then
1088: select short_text into l_text from fnd_documents_short_text
1089: where media_id = l_media_id;
1090:
1091: l_document := l_document || '
' ||
1092: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1121: select short_text into l_text from fnd_documents_short_text

1117: exit when attachments_from_ga_cursor%NOTFOUND;
1118:
1119:
1120: if (l_datatype_id = 1) then
1121: select short_text into l_text from fnd_documents_short_text
1122: where media_id = l_media_id;
1123:
1124: l_document := l_document || '
' ||
1125: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1298: select short_text into l_text from fnd_documents_short_text

1294: exit when attachments_cursor%NOTFOUND;
1295:
1296:
1297: if (l_datatype_id = 1) then
1298: select short_text into l_text from fnd_documents_short_text
1299: where media_id = l_media_id;
1300:
1301: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
1302:

Line 1583: select short_text into l_text from fnd_documents_short_text

1579: fetch attachments_cursor into l_datatype_id, l_media_id;
1580: exit when attachments_cursor%NOTFOUND;
1581:
1582: if (l_datatype_id = 1) then
1583: select short_text into l_text from fnd_documents_short_text
1584: where media_id = l_media_id;
1585:
1586: l_document := l_document || '
' ||
1587: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||

Line 1810: select short_text into l_text from fnd_documents_short_text

1806: exit when attachments_cursor%NOTFOUND;
1807:
1808:
1809: if (l_datatype_id = 1) then
1810: select short_text into l_text from fnd_documents_short_text
1811: where media_id = l_media_id;
1812:
1813: if (length(l_attachments_text) = 0) then
1814:

Line 1867: select short_text into l_text from fnd_documents_short_text

1863:
1864:
1865:
1866: if (l_datatype_id = 1) then
1867: select short_text into l_text from fnd_documents_short_text
1868: where media_id = l_media_id;
1869:
1870:
1871: if (l_attachments_text is null) then

Line 1988: select short_text into l_item_short_text from fnd_documents_short_text

1984:
1985: -- Bug 3129802 Need to add PRE tag as the text is preformatted
1986:
1987: if (l_datatype_id = 1) then
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

Line 2044: select short_text into l_text from fnd_documents_short_text

2040: exit when attachments_cursor%NOTFOUND;
2041:
2042:
2043: if (l_datatype_id = 1) then
2044: select short_text into l_text from fnd_documents_short_text
2045: where media_id = l_media_id;
2046:
2047: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2048:

Line 2087: select short_text into l_text from fnd_documents_short_text

2083: exit when attachments_from_ga_cursor%NOTFOUND;
2084:
2085:
2086: if (l_datatype_id = 1) then
2087: select short_text into l_text from fnd_documents_short_text
2088: where media_id = l_media_id;
2089:
2090: l_document := l_document || '
' ||
2091: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 2121: select short_text into l_text from fnd_documents_short_text

2117: exit when attachments_from_ga_cursor%NOTFOUND;
2118:
2119:
2120: if (l_datatype_id = 1) then
2121: select short_text into l_text from fnd_documents_short_text
2122: where media_id = l_media_id;
2123:
2124: l_document := l_document || '
' ||
2125: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 2204: select short_text into l_text from fnd_documents_short_text

2200: exit when attachments_cursor%NOTFOUND;
2201:
2202:
2203: if (l_datatype_id = 1) then
2204: select short_text into l_text from fnd_documents_short_text
2205: where media_id = l_media_id;
2206:
2207: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2208: