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.OKL_AM_QUOTES_WF dependencies on OKL_ACCOUNTING_UTIL

Line 518: l_formatted_qte_tot := OKL_ACCOUNTING_UTIL.format_amount(

514: FOR l_quote_rec in okl_approval_quote_csr(l_trx_id) LOOP
515:
516: IF NOT l_header_done THEN
517:
518: l_formatted_qte_tot := OKL_ACCOUNTING_UTIL.format_amount(
519: l_quote_rec.quote_total,
520: l_quote_rec.currency);
521: l_message :=
522: '

Quote Number: '||l_quote_rec.quote_number||'
'||

Line 1123: l_formatted_qte_tot := OKL_ACCOUNTING_UTIL.format_amount(

1119: FOR okl_approval_quote_rec in okl_approval_quote_csr(l_trx_id) LOOP
1120:
1121: IF NOT l_header_done THEN
1122:
1123: l_formatted_qte_tot := OKL_ACCOUNTING_UTIL.format_amount(
1124: okl_approval_quote_rec.quote_total,
1125: okl_approval_quote_rec.currency);
1126: l_message :=
1127: '

Quote Number: '||okl_approval_quote_rec.quote_number||'
'||

Line 1222: OKL_ACCOUNTING_UTIL.format_amount(SUM(NVL(OTL.AMOUNT,0)),OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID))||' '||OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,

1218: CURSOR l_message_csr ( p_qte_id IN NUMBER) IS
1219: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
1220: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
1221: TO_CHAR(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
1222: OKL_ACCOUNTING_UTIL.format_amount(SUM(NVL(OTL.AMOUNT,0)),OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID))||' '||OKL_AM_UTIL_PVT.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
1223: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
1224: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
1225: TO_CHAR(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
1226: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,

Line 4347: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,

4343: IS
4344: SELECT to_char(sysdate, 'DD-MON-RRRR') system_date,
4345: OTQ.quote_number quote_number,
4346: to_char(OTQ.date_effective_to, 'DD-MON-RRRR') effective_to,
4347: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
4348: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
4349: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
4350: to_char(OTQ.creation_date, 'DD-MON-RRRR') quote_creation_date,
4351: nvl2 (qp.cpl_id, okl_am_util_pvt.get_jtf_object_name (pr.jtot_object1_code, pr.object1_id1, pr.object1_id2), okl_am_util_pvt.get_jtf_object_name (qp.party_jtot_object1_code, qp.party_object1_id1,qp.party_object1_id2)) recipient_name,

Line 4686: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,

4682: IS
4683: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
4684: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
4685: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
4686: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
4687: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
4688: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
4689: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
4690: AD.CONTRACT_NUMBER CONTRACT_NUMBER,

Line 4742: 'Projected Gain/Loss:'||okl_accounting_util.format_amount((l_quote_rec.gain_loss),okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID)||'
'||

4738:
4739: l_message := '

Quote Number:'||l_quote_rec.quote_number||'
'||
4740: 'Quote Effective To Date:'||l_quote_rec.effective_to||'
'||
4741: 'Total:'||l_quote_rec.quote_total||'
'||
4742: 'Projected Gain/Loss:'||okl_accounting_util.format_amount((l_quote_rec.gain_loss),okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(l_quote_rec.KHR_ID)||'
'||
4743: '

A Quote of type '||l_quote_rec.quote_type||' was requested for Contract '||l_quote_rec.contract_number||' on
'||
4744: l_quote_rec.quote_creation_date||' for the following reason: '||l_quote_rec.quote_reason||'.

'||
4745: '

Comments:
'||
4746: l_quote_rec.comments||'

'||

Line 5190: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,

5186: IS
5187: SELECT TO_CHAR(SYSDATE, 'DD-MON-RRRR') SYSTEM_DATE,
5188: OTQ.QUOTE_NUMBER QUOTE_NUMBER,
5189: to_char(OTQ.DATE_EFFECTIVE_TO, 'DD-MON-RRRR') EFFECTIVE_TO,
5190: okl_accounting_util.format_amount(SUM(NVL(OTL.AMOUNT,0)),okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID))||' '||okl_am_util_pvt.get_chr_currency(OTQ.KHR_ID) QUOTE_TOTAL,
5191: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_REASON',OTQ.qrs_code,'N')QUOTE_REASON ,
5192: OKL_AM_UTIL_PVT.get_lookup_meaning('OKL_QUOTE_TYPE',OTQ.qtp_code,'N') QUOTE_TYPE,
5193: to_char(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
5194: AD.CONTRACT_NUMBER CONTRACT_NUMBER,

Line 8780: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling okl_accounting_util.convert_to_functional_currency');

8776: /* Bug 6736148 start */
8777: IF (l_assets.CURRENCY_CODE <> l_func_curr_code) THEN
8778:
8779: IF (is_debug_statement_on) THEN
8780: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling okl_accounting_util.convert_to_functional_currency');
8781: END IF;
8782:
8783: okl_accounting_util.convert_to_functional_currency(
8784: p_khr_id => l_contract_id,

Line 8783: okl_accounting_util.convert_to_functional_currency(

8779: IF (is_debug_statement_on) THEN
8780: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling okl_accounting_util.convert_to_functional_currency');
8781: END IF;
8782:
8783: okl_accounting_util.convert_to_functional_currency(
8784: p_khr_id => l_contract_id,
8785: p_to_currency => l_func_curr_code,
8786: p_transaction_date => l_assets.DATE_EFFECTIVE_FROM,
8787: p_amount => l_asset_return_value,

Line 8796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, l_return_status: ' || l_return_status);

8792: x_currency_conversion_date => lx_currency_conversion_date,
8793: x_converted_amount => lx_converted_amount );
8794:
8795: IF (is_debug_statement_on) THEN
8796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, l_return_status: ' || l_return_status);
8797: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
8798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
8799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
8800: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);