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 3385: fnd_currency.get_info(p_currency_code, l_precision,

3381: l_mask varchar2(100);
3382:
3383: begin
3384: -- Get the Currency info
3385: fnd_currency.get_info(p_currency_code, l_precision,
3386: l_ext_precision, l_min_acct_unit);
3387:
3388: -- Find the field width
3389: l_field_length := length(p_amount) + 40;

Line 3397: fnd_currency.build_format_mask(l_mask, l_field_length,

3393: l_precision := l_precision_amt;
3394: end if;
3395:
3396: -- Build custom format mask
3397: fnd_currency.build_format_mask(l_mask, l_field_length,
3398: l_precision, l_min_acct_unit);
3399:
3400: -- Convert the Amount
3401: return to_char(p_amount,l_mask);