DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on FND_CURRENCY

Line 182: l_total_amount_disp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK(

178: CLOSE req_tax_csr;
179:
180: l_total_amount := l_req_amount + l_tax_amount;
181:
182: l_total_amount_disp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK(
183: p_currency_code,30));
184: return l_total_amount_disp;
185: end;
186:

Line 1341: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30))

1337: l_line.txn_curr_code is not null AND
1338: l_currency_code <> l_line.txn_curr_code) THEN
1339:
1340: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1341: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30))
1342: || ' ' || l_currency_code || ' ('
1343: || to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30))
1344: || ' ' || l_line.txn_curr_code || ')' || NL;
1345:

Line 1343: || to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30))

1339:
1340: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1341: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30))
1342: || ' ' || l_currency_code || ' ('
1343: || to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30))
1344: || ' ' || l_line.txn_curr_code || ')' || NL;
1345:
1346: ELSE
1347: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '

Line 1348: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;

1344: || ' ' || l_line.txn_curr_code || ')' || NL;
1345:
1346: ELSE
1347: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1348: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
1349: END IF;
1350:
1351:
1352:

Line 1354: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;

1350:
1351:
1352:
1353: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1354: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;
1355:
1356: exit when i = 5;
1357:
1358: end loop;

Line 1835: TO_CHAR(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||

1831: l_document := l_document || '' ||
1832: PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_line.unit_price ) || '' || NL;
1833:
1834: l_document := l_document || '' ||
1835: TO_CHAR(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) ||
1836: '' || NL;
1837:
1838: l_document := l_document || '' || NL;
1839:

Line 3700: fnd_currency.get_info(p_currency_code, l_precision,

3696:
3697:
3698: begin
3699: -- Get the Currency info
3700: fnd_currency.get_info(p_currency_code, l_precision,
3701: l_ext_precision, l_min_acct_unit);
3702:
3703: -- Find the field width
3704: -- Bug#8373802 - Round p_amount to 15 precision as unit_price and currency_unit_price

Line 3730: fnd_currency.build_format_mask(l_mask, l_field_length,

3726: end if;
3727:
3728:
3729: -- Build custom format mask
3730: fnd_currency.build_format_mask(l_mask, l_field_length,
3731: l_precision, l_min_acct_unit);
3732:
3733: -- Convert the Amount
3734: return to_char(l_amount,l_mask);