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.

[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on FND_DOCUMENTS_SHORT_TEXT

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

111: l_org_id NUMBER;
112: x_orgid NUMBER;
113: l_un_number PO_UN_NUMBERS.UN_NUMBER%TYPE;
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:

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

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

Line 735: select short_text into l_text from fnd_documents_short_text

731:
732:
733:
734: if (l_datatype_id = 1) then
735: select short_text into l_text from fnd_documents_short_text
736: where media_id = l_media_id;
737:
738:
739: if (l_attachments_text is null) then

Line 794: select short_text into l_text from fnd_documents_short_text

790:
791:
792:
793: if (l_datatype_id = 1) then
794: select short_text into l_text from fnd_documents_short_text
795: where media_id = l_media_id;
796:
797:
798: if (l_attachments_text is null) then

Line 1140: select short_text into l_item_short_text from fnd_documents_short_text

1136:
1137: -- Bug 3129802. Should use PRE tag as the text is pre formatted
1138:
1139: if (l_datatype_id = 1) then
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

Line 1187: select short_text into l_text from fnd_documents_short_text

1183: exit when attachments_cursor%NOTFOUND;
1184:
1185:
1186: if (l_datatype_id = 1) then
1187: select short_text into l_text from fnd_documents_short_text
1188: where media_id = l_media_id;
1189:
1190: l_document := l_document || '
' ||
1191: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1237: select short_text into l_text from fnd_documents_short_text

1233: exit when attachments_from_ga_cursor%NOTFOUND;
1234:
1235:
1236: if (l_datatype_id = 1) then
1237: select short_text into l_text from fnd_documents_short_text
1238: where media_id = l_media_id;
1239:
1240: l_document := l_document || '
' ||
1241: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1270: select short_text into l_text from fnd_documents_short_text

1266: exit when attachments_from_ga_cursor%NOTFOUND;
1267:
1268:
1269: if (l_datatype_id = 1) then
1270: select short_text into l_text from fnd_documents_short_text
1271: where media_id = l_media_id;
1272:
1273: l_document := l_document || '
' ||
1274: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 1465: select short_text into l_text from fnd_documents_short_text

1461: exit when attachments_cursor%NOTFOUND;
1462:
1463:
1464: if (l_datatype_id = 1) then
1465: select short_text into l_text from fnd_documents_short_text
1466: where media_id = l_media_id;
1467:
1468: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
1469:

Line 1773: select short_text into l_text from fnd_documents_short_text

1769: fetch attachments_cursor into l_datatype_id, l_media_id;
1770: exit when attachments_cursor%NOTFOUND;
1771:
1772: if (l_datatype_id = 1) then
1773: select short_text into l_text from fnd_documents_short_text
1774: where media_id = l_media_id;
1775:
1776: l_document := l_document || '
' ||
1777: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||

Line 2010: select short_text into l_text from fnd_documents_short_text

2006: exit when attachments_cursor%NOTFOUND;
2007:
2008:
2009: if (l_datatype_id = 1) then
2010: select short_text into l_text from fnd_documents_short_text
2011: where media_id = l_media_id;
2012:
2013: if (length(l_attachments_text) = 0) then
2014:

Line 2067: select short_text into l_text from fnd_documents_short_text

2063:
2064:
2065:
2066: if (l_datatype_id = 1) then
2067: select short_text into l_text from fnd_documents_short_text
2068: where media_id = l_media_id;
2069:
2070:
2071: if (l_attachments_text is null) then

Line 2189: select short_text into l_item_short_text from fnd_documents_short_text

2185:
2186: -- Bug 3129802 Need to add PRE tag as the text is preformatted
2187:
2188: if (l_datatype_id = 1) then
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

Line 2247: select short_text into l_text from fnd_documents_short_text

2243: exit when attachments_cursor%NOTFOUND;
2244:
2245:
2246: if (l_datatype_id = 1) then
2247: select short_text into l_text from fnd_documents_short_text
2248: where media_id = l_media_id;
2249:
2250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2251:

Line 2290: select short_text into l_text from fnd_documents_short_text

2286: exit when attachments_from_ga_cursor%NOTFOUND;
2287:
2288:
2289: if (l_datatype_id = 1) then
2290: select short_text into l_text from fnd_documents_short_text
2291: where media_id = l_media_id;
2292:
2293: l_document := l_document || '
' ||
2294: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 2324: select short_text into l_text from fnd_documents_short_text

2320: exit when attachments_from_ga_cursor%NOTFOUND;
2321:
2322:
2323: if (l_datatype_id = 1) then
2324: select short_text into l_text from fnd_documents_short_text
2325: where media_id = l_media_id;
2326:
2327: l_document := l_document || '
' ||
2328: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

Line 2425: select short_text into l_text from fnd_documents_short_text

2421: exit when attachments_cursor%NOTFOUND;
2422:
2423:
2424: if (l_datatype_id = 1) then
2425: select short_text into l_text from fnd_documents_short_text
2426: where media_id = l_media_id;
2427:
2428: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2429: