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:
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:
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') || ': '
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:
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;
1831: l_document := l_document || '
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
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);