DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on FND_CURRENCY

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

706:
707: -- l_currency_code := PO_CORE_S2.get_base_currency;
708:
709: -- Bug fix 2257742
710: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_unit);
711:
712:
713: /* Bug# 2737371: kagarwal
714: ** Desc: Adding the

 tag when adding the attachment text to

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

1601:
1602: l_document := l_document || '' || nvl(l_line_loc.uom, ' ') || '' || NL;
1603: /*
1604:
1605: l_document := l_document || '' || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ''|| NL;
1606: */
1607: l_document := l_document || '' ||
1608: '(' || l_currency_code || ')' || l_line_loc.unit_price || '
' ||
1609: NL;

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

1632: if (l_document_type <> 'PA') then
1633:
1634:
1635: l_document := l_document || '' || '(' || l_currency_code || ')' ||
1636: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
1637: || '
' || NL;
1638: else
1639:
1640: l_document := l_document || '   '|| NL;

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

1866:
1867: l_document := l_document || '' || nvl(l_line_loc.uom, ' ') || '' || NL;
1868: /*
1869:
1870: l_document := l_document || '' || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ''|| NL;
1871:
1872: */
1873: l_document := l_document || '' ||
1874: '(' || l_currency_code || ')' || l_line_loc.unit_price ||

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

1902:
1903:
1904: l_document := l_document || '' ||
1905: '(' || l_currency_code || ')' ||
1906: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
1907: || '
' || NL;
1908: else
1909:
1910: l_document := l_document || '   '|| NL;

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

1949: l_document := l_document || ' ' || NL;
1950: l_document := l_document || '' || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || '    ' || NL;
1951:
1952: l_document := l_document || '' || '(' || l_currency_code || ')' ||
1953: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
1954: || NL;
1955: l_document := l_document || '
';
1956: end if;
1957:

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

2503: l_document := l_document || nvl(l_line_loc.uom, ' ') || ' , ';
2504:
2505: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': ';
2506: /*
2507: l_document := l_document || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ', ';
2508: */
2509: l_document := l_document || '(' || l_currency_code || ')' ||
2510: l_line_loc.unit_price || ' , ' ;
2511: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || ': ';

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

2520: end if;
2521:
2522: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || ': ';
2523: /*
2524: l_document := l_document || nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ' , ';
2525: */
2526: l_document := l_document || '(' || l_currency_code || ')' ||
2527: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2528: || ' , ';

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

2523: /*
2524: l_document := l_document || nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ' , ';
2525: */
2526: l_document := l_document || '(' || l_currency_code || ')' ||
2527: nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2528: || ' , ';
2529:
2530:
2531:

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

2551: if l_document is null then
2552: l_document := l_document || NL;
2553: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || ': ';
2554: l_document := l_document || '(' || l_currency_code || ')' ||
2555: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2556: || NL;
2557: l_document := l_document || NL;
2558: WF_NOTIFICATION.WriteToClob(document, l_document);
2559: end if;