eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on FND_CURRENCY

Line 13: --in FND_CURRENCY.GET_FORMAT_MASK

9: g_debug_stmt CONSTANT BOOLEAN := po_debug.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := po_debug.is_debug_unexp_on;
11: --Bug#3497033
12: --g_currency_format_mask declared to pass in as the second parameter
13: --in FND_CURRENCY.GET_FORMAT_MASK
14: g_currency_format_mask NUMBER := 60;
15:
16: g_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
17:

Line 473: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));

469: /* setting amount for notification subject */
470: l_amount_approval_currency := (p_total_amount/l_denominator_rate) * l_numerator_rate;
471:
472: l_amount_disp := TO_CHAR(l_amount_approval_currency,
473: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
474: x_amount_for_subject := l_amount_disp || ' ' || l_approval_currency;
475:
476: /* setting amount for header attribute */
477: l_amount_approval_currency := (p_req_amount/l_denominator_rate) * l_numerator_rate;

Line 480: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));

476: /* setting amount for header attribute */
477: l_amount_approval_currency := (p_req_amount/l_denominator_rate) * l_numerator_rate;
478:
479: l_amount_disp := TO_CHAR(l_amount_approval_currency,
480: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
481:
482: l_progress := 'getReqAmountInfo:' || l_amount_disp;
483: IF (g_po_wf_debug = 'Y') THEN
484: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 493: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));

489:
490: l_amount_approval_currency := (p_tax_amount/l_denominator_rate) * l_numerator_rate;
491:
492: l_amount_disp := TO_CHAR(l_amount_approval_currency,
493: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
494:
495: x_amount_for_tax := p_tax_amount_disp || ' ' || p_function_currency;
496: x_amount_for_tax := x_amount_for_tax || ' (' || l_amount_disp || ' ' || l_approval_currency || ')';
497:

Line 4525: l_req_amount_dsp := TO_CHAR(l_req_amount,FND_CURRENCY.GET_FORMAT_MASK(

4521: WHERE requisition_header_id = l_req_header_id
4522: AND NVL(cancel_flag,'N') = 'N'
4523: AND NVL(modified_by_agent_flag, 'N') = 'N';
4524:
4525: l_req_amount_dsp := TO_CHAR(l_req_amount,FND_CURRENCY.GET_FORMAT_MASK(
4526: l_currency_code, g_currency_format_mask));
4527:
4528: -- get old tax and tax dsp
4529: SELECT nvl(sum(nonrecoverable_tax), 0)

Line 4538: l_tax_amount_dsp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(

4534: AND rd.requisition_line_id = rl.requisition_line_id
4535: AND NVL(rl.cancel_flag,'N') = 'N'
4536: AND NVL(rl.modified_by_agent_flag, 'N') = 'N';
4537:
4538: l_tax_amount_dsp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
4539: l_currency_code, g_currency_format_mask));
4540: l_total_amount := l_req_amount + l_tax_amount;
4541:
4542: l_total_amount_dsp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK(

Line 4542: l_total_amount_dsp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK(

4538: l_tax_amount_dsp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
4539: l_currency_code, g_currency_format_mask));
4540: l_total_amount := l_req_amount + l_tax_amount;
4541:
4542: l_total_amount_dsp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK(
4543: l_currency_code, g_currency_format_mask));
4544:
4545: x_progress :='StartPOChangeWF:008';
4546:

Line 6337: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));

6333: the workflow definition is modified such that
6334: currency atribute is removed from the subject.
6335: */
6336: l_total_amount_disp := to_char(l_new_tax_amount+l_new_req_amount,
6337: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6338: l_req_amount_disp := to_char(l_new_req_amount,
6339: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6340: l_tax_amount_disp := to_char(l_new_tax_amount,
6341: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));

Line 6339: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));

6335: */
6336: l_total_amount_disp := to_char(l_new_tax_amount+l_new_req_amount,
6337: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6338: l_req_amount_disp := to_char(l_new_req_amount,
6339: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6340: l_tax_amount_disp := to_char(l_new_tax_amount,
6341: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6342:
6343: getReqAmountInfo(itemtype => itemtype,

Line 6341: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));

6337: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6338: l_req_amount_disp := to_char(l_new_req_amount,
6339: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6340: l_tax_amount_disp := to_char(l_new_tax_amount,
6341: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6342:
6343: getReqAmountInfo(itemtype => itemtype,
6344: itemkey => itemkey,
6345: p_function_currency => l_currency_code,

Line 7840: l_total_amount_disp := to_char(l_new_tax_currency+l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));

7836: total with currency;
7837: the workflow definition is modified such that
7838: currency atribute is removed from the subject.
7839: */
7840: l_total_amount_disp := to_char(l_new_tax_currency+l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7841: l_req_amount_disp := to_char(l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7842: l_tax_amount_disp := to_char(l_new_tax_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7843:
7844:

Line 7841: l_req_amount_disp := to_char(l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));

7837: the workflow definition is modified such that
7838: currency atribute is removed from the subject.
7839: */
7840: l_total_amount_disp := to_char(l_new_tax_currency+l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7841: l_req_amount_disp := to_char(l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7842: l_tax_amount_disp := to_char(l_new_tax_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7843:
7844:
7845: getReqAmountInfo(itemtype => itemtype,

Line 7842: l_tax_amount_disp := to_char(l_new_tax_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));

7838: currency atribute is removed from the subject.
7839: */
7840: l_total_amount_disp := to_char(l_new_tax_currency+l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7841: l_req_amount_disp := to_char(l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7842: l_tax_amount_disp := to_char(l_new_tax_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7843:
7844:
7845: getReqAmountInfo(itemtype => itemtype,
7846: itemkey => itemkey,

Line 7944: l_req_amount_disp := TO_CHAR(l_req_amount,FND_CURRENCY.GET_FORMAT_MASK(

7940: WHERE requisition_header_id = l_document_id
7941: AND NVL(cancel_flag,'N') = 'N'
7942: AND NVL(modified_by_agent_flag, 'N') = 'N';
7943:
7944: l_req_amount_disp := TO_CHAR(l_req_amount,FND_CURRENCY.GET_FORMAT_MASK(
7945: l_functional_currency, g_currency_format_mask));
7946:
7947: -- get new tax and tax disp
7948: SELECT nvl(sum(nonrecoverable_tax), 0)

Line 7957: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(

7953: AND rd.requisition_line_id = rl.requisition_line_id
7954: AND NVL(rl.cancel_flag,'N') = 'N'
7955: AND NVL(rl.modified_by_agent_flag, 'N') = 'N';
7956:
7957: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
7958: l_functional_currency, g_currency_format_mask));
7959:
7960: l_total_amount_disp := to_char(l_req_amount+l_tax_amount, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7961:

Line 7960: l_total_amount_disp := to_char(l_req_amount+l_tax_amount, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));

7956:
7957: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
7958: l_functional_currency, g_currency_format_mask));
7959:
7960: l_total_amount_disp := to_char(l_req_amount+l_tax_amount, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
7961:
7962: getReqAmountInfo(itemtype => itemtype,
7963: itemkey => itemkey,
7964: p_function_currency => l_functional_currency,

Line 9653: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,

9649: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
9650: itemkey => itemkey,
9651: aname => 'OLD_ORD_TOTAL_CURRENCY_DSP',
9652: avalue => to_char(l_old_total,
9653: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,
9654: g_currency_format_mask))
9655: || ' ' ||l_po_currency);
9656: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
9657: itemkey => itemkey,

Line 9660: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,

9656: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
9657: itemkey => itemkey,
9658: aname => 'NEW_ORD_TOTAL_CURRENCY_DSP',
9659: avalue => to_char(l_new_total,
9660: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,
9661: g_currency_format_mask))
9662: || ' ' ||l_po_currency );
9663:
9664: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 05';

Line 10361: to_char(l_old_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);

10357: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10358: itemkey => itemkey,
10359: aname => 'OLD_PO_TOTAL',
10360: avalue =>
10361: to_char(l_old_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);
10362:
10363: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10364: itemkey => itemkey,
10365: aname => 'NEW_PO_TOTAL',

Line 10367: to_char(l_new_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);

10363: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10364: itemkey => itemkey,
10365: aname => 'NEW_PO_TOTAL',
10366: avalue =>
10367: to_char(l_new_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);
10368:
10369: EXCEPTION when others THEN
10370: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_FYI_Notif_Attributes',l_progress);
10371: raise;

Line 11116: fnd_currency.get_format_mask(l_po_currency,

11112: l_total_trunc := trunc(l_total);
11113:
11114: -- add the unformatted integer portion to the formatted fractional portion of the number and return the same
11115: return (l_total_trunc + to_number(to_char(l_total - l_total_trunc,
11116: fnd_currency.get_format_mask(l_po_currency,
11117: g_currency_format_mask))));
11118:
11119: END get_formatted_total;
11120: