DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on FND_CURRENCY

Line 193: fnd_currency.get_info( l_currency_code,

189: END IF; --(lv_document_type = 'RELEASE')
190: ELSE
191: --original tax calc code
192:
193: fnd_currency.get_info( l_currency_code,
194: X_precision,
195: X_ext_precision,
196: X_min_acct_unit);
197:

Line 252: l_document := l_document || '' || l_currency_code || ' ' || nvl(TO_CHAR(l_po_amount_numeric, FND_CURRENCY.GET_FORMAT_MASK(

248: fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_AMOUNT') ||
249: '  ' || NL;
250:
251: -- 12396408 Formatting the total amount
252: l_document := l_document || '' || l_currency_code || ' ' || nvl(TO_CHAR(l_po_amount_numeric, FND_CURRENCY.GET_FORMAT_MASK(
253: l_currency_code, 30)),' ') || '' || NL;
254:
255: if l_tax_amt > 0 then
256:

Line 261: l_document := l_document || '' || l_currency_code || ' ' || nvl(TO_CHAR(l_tax_amount_numeric , FND_CURRENCY.GET_FORMAT_MASK(

257: l_document := l_document || '' ||
258: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT') ||
259: '  ' || NL;
260: --bug 12396408 formatting the tax
261: l_document := l_document || '' || l_currency_code || ' ' || nvl(TO_CHAR(l_tax_amount_numeric , FND_CURRENCY.GET_FORMAT_MASK(
262: l_currency_code, 30)),' ') ||
263: '

' || NL;
264:
265: else

Line 894: nvl(TO_CHAR(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(

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;
896:
897: l_document := l_document || '' || NL;
898:

Line 1016: nvl(TO_CHAR(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(

1012: || to_char(l_need_by_date_tbl(i) ,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1013: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || '''') || '' || NL;
1014: /* bug 4950850 */
1015: l_document := l_document || '' ||
1016: nvl(TO_CHAR(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(
1017: l_currency_code, 30)),' ') || '' || NL;
1018: l_document := l_document || '' || NL;
1019:
1020: --

Line 1123: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;

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 >
1126: -- curr_len := lengthb(l_document);
1127:

Line 1184: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;

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;
1186: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
1187: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1188: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN') || '''') || NL || NL;