DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on PO_WF_REQ_NOTIFICATION

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

648: */
649: -- Bug 3547777. Added the nvl clauses to unit_price and line_
650: -- amount so that box is still displayed even if value is null.
651: l_document := l_document || '' ||
652: nvl(PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)),' ') || '' || NL; --
653:
654: l_document := l_document || '' ||
655: nvl(TO_CHAR(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(
656: l_currency_code, 30)),' ') || '' || NL;

Line 764: nvl(PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(

760: ** We will not format the unit price on the lines in notifications
761: */
762:
763: l_document := l_document || '' ||
764: nvl(PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(
765: l_currency_code,l_unit_price_tbl(i)),' ') || '' || NL; --
766:
767: l_document := l_document || ''
768: || nvl(l_location_tbl(i), ' ') || '' || NL;

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

860: ** We will not format the unit price on the lines in notifications
861: */
862:
863: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
864: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
865: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
866: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;
867:
868: -- < BUG 7006113 START >

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

920: ** We will not format the unit price on the lines in notifications
921: */
922:
923: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
924: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
925: -- bug 4950850
926: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
927: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
928: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;