DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on PO_WF_REQ_NOTIFICATION

Line 891: nvl(PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)),' ') || '' || NL; --

887: */
888: -- Bug 3547777. Added the nvl clauses to unit_price and line_
889: -- amount so that box is still displayed even if value is null.
890: l_document := l_document || '' ||
891: nvl(PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)),' ') || '' || NL; --
892:
893: l_document := l_document || '' ||
894: nvl(TO_CHAR(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(
895: l_currency_code, 30)),' ') || '' || NL;

Line 1004: nvl(PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(

1000: ** We will not format the unit price on the lines in notifications
1001: */
1002:
1003: l_document := l_document || '' ||
1004: nvl(PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(
1005: l_currency_code,l_unit_price_tbl(i)),' ') || '' || NL; --
1006:
1007: l_document := l_document || ''
1008: || nvl(l_location_tbl(i), ' ') || '' || NL;

Line 1121: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;

1117: ** We will not format the unit price on the lines in notifications
1118: */
1119:
1120: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1121: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
1122: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1123: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;
1124:
1125: -- < BUG 7006113 START >

Line 1181: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;

1177: ** We will not format the unit price on the lines in notifications
1178: */
1179:
1180: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1181: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
1182: -- bug 4950850
1183: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
1184: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
1185: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;