DBA Data[Home] [Help]

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 490: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));

486: /* setting amount for notification subject */
487: l_amount_approval_currency := (p_total_amount/l_denominator_rate) * l_numerator_rate;
488:
489: l_amount_disp := TO_CHAR(l_amount_approval_currency,
490: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
491: x_amount_for_subject := l_amount_disp || ' ' || l_approval_currency;
492:
493: /* setting amount for header attribute */
494: l_amount_approval_currency := (p_req_amount/l_denominator_rate) * l_numerator_rate;

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

493: /* setting amount for header attribute */
494: l_amount_approval_currency := (p_req_amount/l_denominator_rate) * l_numerator_rate;
495:
496: l_amount_disp := TO_CHAR(l_amount_approval_currency,
497: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
498:
499: l_progress := 'getReqAmountInfo:' || l_amount_disp;
500: IF (g_po_wf_debug = 'Y') THEN
501: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

506:
507: l_amount_approval_currency := (p_tax_amount/l_denominator_rate) * l_numerator_rate;
508:
509: l_amount_disp := TO_CHAR(l_amount_approval_currency,
510: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
511:
512: x_amount_for_tax := p_tax_amount_disp || ' ' || p_function_currency;
513: x_amount_for_tax := x_amount_for_tax || ' (' || l_amount_disp || ' ' || l_approval_currency || ')';
514:

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

4681: WHERE requisition_header_id = l_req_header_id
4682: AND NVL(cancel_flag,'N') = 'N'
4683: AND NVL(modified_by_agent_flag, 'N') = 'N';
4684:
4685: l_req_amount_dsp := TO_CHAR(l_req_amount,FND_CURRENCY.GET_FORMAT_MASK(
4686: l_currency_code, g_currency_format_mask));
4687:
4688: --Modified by Xiao and Eric for IL PO Notification on 30-Mar-2009, Begin
4689: ------------------------------------------------------------------------------------

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

4711: END IF;--(lv_tax_region ='JAI')
4712: ------------------------------------------------------------------------------------
4713: --Modified by Xiao and Eric for IL PO Notification on 30-Mar-2009, End
4714:
4715: l_tax_amount_dsp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
4716: l_currency_code, g_currency_format_mask));
4717: l_total_amount := l_req_amount + l_tax_amount;
4718:
4719: l_total_amount_dsp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK(

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

4715: l_tax_amount_dsp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
4716: l_currency_code, g_currency_format_mask));
4717: l_total_amount := l_req_amount + l_tax_amount;
4718:
4719: l_total_amount_dsp := TO_CHAR(l_total_amount,FND_CURRENCY.GET_FORMAT_MASK(
4720: l_currency_code, g_currency_format_mask));
4721:
4722: x_progress :='StartPOChangeWF:008';
4723:

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

6552: the workflow definition is modified such that
6553: currency atribute is removed from the subject.
6554: */
6555: l_total_amount_disp := to_char(l_new_tax_amount+l_new_req_amount,
6556: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6557: l_req_amount_disp := to_char(l_new_req_amount,
6558: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6559: l_tax_amount_disp := to_char(l_new_tax_amount,
6560: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));

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

6554: */
6555: l_total_amount_disp := to_char(l_new_tax_amount+l_new_req_amount,
6556: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6557: l_req_amount_disp := to_char(l_new_req_amount,
6558: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6559: l_tax_amount_disp := to_char(l_new_tax_amount,
6560: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6561:
6562: getReqAmountInfo(itemtype => itemtype,

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

6556: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6557: l_req_amount_disp := to_char(l_new_req_amount,
6558: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6559: l_tax_amount_disp := to_char(l_new_tax_amount,
6560: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,g_currency_format_mask));
6561:
6562: getReqAmountInfo(itemtype => itemtype,
6563: itemkey => itemkey,
6564: p_function_currency => l_currency_code,

Line 8113: 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));

8109: total with currency;
8110: the workflow definition is modified such that
8111: currency atribute is removed from the subject.
8112: */
8113: 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));
8114: l_req_amount_disp := to_char(l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
8115: l_tax_amount_disp := to_char(l_new_tax_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
8116:
8117:

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

8110: the workflow definition is modified such that
8111: currency atribute is removed from the subject.
8112: */
8113: 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));
8114: l_req_amount_disp := to_char(l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
8115: l_tax_amount_disp := to_char(l_new_tax_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
8116:
8117:
8118: getReqAmountInfo(itemtype => itemtype,

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

8111: currency atribute is removed from the subject.
8112: */
8113: 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));
8114: l_req_amount_disp := to_char(l_new_amount_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
8115: l_tax_amount_disp := to_char(l_new_tax_currency, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
8116:
8117:
8118: getReqAmountInfo(itemtype => itemtype,
8119: itemkey => itemkey,

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

8226: WHERE requisition_header_id = l_document_id
8227: AND NVL(cancel_flag,'N') = 'N'
8228: AND NVL(modified_by_agent_flag, 'N') = 'N';
8229:
8230: l_req_amount_disp := TO_CHAR(l_req_amount,FND_CURRENCY.GET_FORMAT_MASK(
8231: l_functional_currency, g_currency_format_mask));
8232:
8233: -- get new tax and tax disp
8234: --Modified by Xiao and Eric for IL PO Notification on Apr-2-2009, Begin

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

8255: END IF;--(lv_tax_region ='JAI')
8256: ------------------------------------------------------------------------
8257: --Modified by Xiao and Eric for IL PO Notification on Apr-2-2009, End
8258:
8259: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
8260: l_functional_currency, g_currency_format_mask));
8261:
8262: l_total_amount_disp := to_char(l_req_amount+l_tax_amount, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
8263:

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

8258:
8259: l_tax_amount_disp := TO_CHAR(l_tax_amount,FND_CURRENCY.GET_FORMAT_MASK(
8260: l_functional_currency, g_currency_format_mask));
8261:
8262: l_total_amount_disp := to_char(l_req_amount+l_tax_amount, FND_CURRENCY.GET_FORMAT_MASK(l_functional_currency,g_currency_format_mask));
8263:
8264: getReqAmountInfo(itemtype => itemtype,
8265: itemkey => itemkey,
8266: p_function_currency => l_functional_currency,

Line 10040: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,

10036: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10037: itemkey => itemkey,
10038: aname => 'OLD_ORD_TOTAL_CURRENCY_DSP',
10039: avalue => to_char(l_old_total,
10040: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,
10041: g_currency_format_mask))
10042: || ' ' ||l_po_currency);
10043: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10044: itemkey => itemkey,

Line 10047: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,

10043: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10044: itemkey => itemkey,
10045: aname => 'NEW_ORD_TOTAL_CURRENCY_DSP',
10046: avalue => to_char(l_new_total,
10047: FND_CURRENCY.GET_FORMAT_MASK(l_po_currency,
10048: g_currency_format_mask))
10049: || ' ' ||l_po_currency );
10050:
10051: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 05';

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

10747: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10748: itemkey => itemkey,
10749: aname => 'OLD_PO_TOTAL',
10750: avalue =>
10751: to_char(l_old_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);
10752:
10753: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10754: itemkey => itemkey,
10755: aname => 'NEW_PO_TOTAL',

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

10753: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
10754: itemkey => itemkey,
10755: aname => 'NEW_PO_TOTAL',
10756: avalue =>
10757: to_char(l_new_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || ' ' || l_po_currency);
10758:
10759: EXCEPTION when others THEN
10760: wf_core.context('PO_ReqChangeRequestWF_PVT','Set_Buyer_FYI_Notif_Attributes',l_progress);
10761: raise;

Line 11520: fnd_currency.get_format_mask(l_po_currency,

11516: l_total_trunc := trunc(l_total);
11517:
11518: -- add the unformatted integer portion to the formatted fractional portion of the number and return the same
11519: return (l_total_trunc + to_number(to_char(l_total - l_total_trunc,
11520: fnd_currency.get_format_mask(l_po_currency,
11521: g_currency_format_mask))));
11522:
11523: END get_formatted_total;
11524: