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_REQAPPROVAL_INIT1 dependencies on FND_CURRENCY

Line 10: --in FND_CURRENCY.GET_FORMAT_MASK

6: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
7: g_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
8: --Bug#3497033
9: --g_currency_format_mask declared to pass in as the second parameter
10: --in FND_CURRENCY.GET_FORMAT_MASK
11: g_currency_format_mask NUMBER := 60;
12: /*=======================================================================+
13: | FILENAME
14: | POXWPA1B.pls

Line 4554: l_amount_disp := TO_CHAR(l_amount_approval_currency, FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));

4550: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4551: END IF;
4552: /* setting amount for notification subject */
4553: l_amount_approval_currency := (p_total_amount/l_denominator_rate) * l_numerator_rate;
4554: l_amount_disp := TO_CHAR(l_amount_approval_currency, FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
4555: x_amount_for_subject := l_amount_disp || ' ' || l_approval_currency;
4556: /* setting amount for header attribute */
4557: l_amount_approval_currency := (p_req_amount/l_denominator_rate) * l_numerator_rate;
4558: l_amount_disp := TO_CHAR(l_amount_approval_currency, FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));

Line 4558: l_amount_disp := TO_CHAR(l_amount_approval_currency, FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));

4554: l_amount_disp := TO_CHAR(l_amount_approval_currency, FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
4555: x_amount_for_subject := l_amount_disp || ' ' || l_approval_currency;
4556: /* setting amount for header attribute */
4557: l_amount_approval_currency := (p_req_amount/l_denominator_rate) * l_numerator_rate;
4558: l_amount_disp := TO_CHAR(l_amount_approval_currency, FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
4559: l_progress := 'getReqAmountInfo:' || l_amount_disp;
4560: IF (g_po_wf_debug = 'Y') THEN
4561: /* DEBUG */
4562: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 4567: l_amount_disp := TO_CHAR(l_amount_approval_currency, FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));

4563: END IF;
4564: x_amount_for_header := p_req_amount_disp || ' ' || p_function_currency;
4565: x_amount_for_header := x_amount_for_header || ' (' || l_amount_disp || ' ' || l_approval_currency || ')';
4566: l_amount_approval_currency := (p_tax_amount/l_denominator_rate) * l_numerator_rate;
4567: l_amount_disp := TO_CHAR(l_amount_approval_currency, FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
4568: x_amount_for_tax := p_tax_amount_disp || ' ' || p_function_currency;
4569: x_amount_for_tax := x_amount_for_tax || ' (' || l_amount_disp || ' ' || l_approval_currency || ')';
4570: EXCEPTION
4571: WHEN gl_currency_api.no_rate THEN

Line 4823: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_acct_unit);

4819: */
4820: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4821: l_currency_code := PO_CORE_S2.get_base_currency;
4822: /*Start Bug#3406460 - call to fnd function to get precision */
4823: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_acct_unit);
4824: /* End Bug#3406460*/
4825: OPEN req_total_csr(l_doc_id,l_precision); --Bug#3406460 added parameter X_precision
4826: FETCH req_total_csr INTO l_req_amount;
4827:

Line 4833: l_req_amount_disp := TO_CHAR(l_req_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask));

4829: /* For REQUISITIONS, since every line could have a different currency, then
4830: ** will show the total in the BASE/FUNCTIONAL currency.
4831: ** For POs, we will show it in the Document currency specified by the user.
4832: */
4833: l_req_amount_disp := TO_CHAR(l_req_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask));
4834: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'FUNCTIONAL_CURRENCY', avalue => l_currency_code);
4835: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'REQ_AMOUNT_DSP', avalue => l_req_amount_disp);
4836: --Modified by Eric Ma for IL PO Notification on Apr-13,2009,Begin
4837: ---------------------------------------------------------------------------

Line 4852: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask));

4848: CLOSE req_tax_csr;
4849: END IF; --(lv_tax_region ='JAI')
4850: ---------------------------------------------------------------------------
4851: --Modified by Eric Ma for IL PO Notification on Apr-13,2009,End
4852: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask));
4853: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TAX_AMOUNT_DSP', avalue => l_tax_amount_disp);
4854: l_total_amount := l_req_amount + l_tax_amount;
4855: l_total_amount_disp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask));
4856: /* bug 3105327

Line 4855: l_total_amount_disp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask));

4851: --Modified by Eric Ma for IL PO Notification on Apr-13,2009,End
4852: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask));
4853: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TAX_AMOUNT_DSP', avalue => l_tax_amount_disp);
4854: l_total_amount := l_req_amount + l_tax_amount;
4855: l_total_amount_disp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK( l_currency_code, g_currency_format_mask));
4856: /* bug 3105327
4857: support approval currency in notification header and subject
4858: because TOTAL_AMOUNT_DSP is only used in notification,
4859: this bug fix changes the meaning of this attribute from total to