DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on FND_CURRENCY

Line 629: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_unit);

625:
626: -- l_currency_code := PO_CORE_S2.get_base_currency;
627:
628: -- Bug fix 2257742
629: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_unit);
630:
631:
632: /* Bug# 2737371: kagarwal
633: ** Desc: Adding the

 tag when adding the attachment text to

Line 1433: l_document := l_document || '' || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ''|| NL;

1429:
1430: l_document := l_document || '' || nvl(l_line_loc.uom, ' ') || '' || NL;
1431: /*
1432:
1433: l_document := l_document || '' || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ''|| NL;
1434: */
1435: l_document := l_document || '' ||
1436: '(' || l_currency_code || ')' || l_line_loc.unit_price || '
' ||
1437: NL;

Line 1464: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085

1460: if (l_document_type <> 'PA') then
1461:
1462:
1463: l_document := l_document || '' || '(' || l_currency_code || ')' ||
1464: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
1465: || '
' || NL;
1466: else
1467:
1468: l_document := l_document || '   '|| NL;

Line 1676: l_document := l_document || '' || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ''|| NL;

1672:
1673: l_document := l_document || '' || nvl(l_line_loc.uom, ' ') || '' || NL;
1674: /*
1675:
1676: l_document := l_document || '' || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ''|| NL;
1677:
1678: */
1679: l_document := l_document || '' ||
1680: '(' || l_currency_code || ')' || l_line_loc.unit_price ||

Line 1712: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085

1708:
1709:
1710: l_document := l_document || '' ||
1711: '(' || l_currency_code || ')' ||
1712: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
1713: || '
' || NL;
1714: else
1715:
1716: l_document := l_document || '   '|| NL;

Line 1759: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085

1755: l_document := l_document || ' ' || NL;
1756: l_document := l_document || '' || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || '    ' || NL;
1757:
1758: l_document := l_document || '' || '(' || l_currency_code || ')' ||
1759: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
1760: || NL;
1761: l_document := l_document || '
';
1762: end if;
1763:

Line 2286: l_document := l_document || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ', ';

2282: l_document := l_document || nvl(l_line_loc.uom, ' ') || ' , ';
2283:
2284: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': ';
2285: /*
2286: l_document := l_document || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ', ';
2287: */
2288: l_document := l_document || '(' || l_currency_code || ')' ||
2289: l_line_loc.unit_price || ' , ' ;
2290: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || ': ';

Line 2303: l_document := l_document || nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ' , ';

2299: end if;
2300:
2301: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || ': ';
2302: /*
2303: l_document := l_document || nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ' , ';
2304: */
2305: l_document := l_document || '(' || l_currency_code || ')' ||
2306: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2307: || ' , ';

Line 2306: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085

2302: /*
2303: l_document := l_document || nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ' , ';
2304: */
2305: l_document := l_document || '(' || l_currency_code || ')' ||
2306: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2307: || ' , ';
2308:
2309:
2310:

Line 2334: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085

2330: if l_document is null then
2331: l_document := l_document || NL;
2332: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || ': ';
2333: l_document := l_document || '(' || l_currency_code || ')' ||
2334: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2335: || NL;
2336: l_document := l_document || NL;
2337: WF_NOTIFICATION.WriteToClob(document, l_document);
2338: end if;