DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 452: l_purchase_amount:=Okl_Accounting_Util.ROUND_AMOUNT (l_purchase_amount * l_line_oec/l_contract_oec , l_curr_code );

448: IF l_contract_oec <> 0 THEN
449: -- l_purchase_amount := l_purchase_amount * l_line_oec/l_contract_oec;
450: --sosharma bug 10100863
451: IF l_curr_code is not NULL then
452: l_purchase_amount:=Okl_Accounting_Util.ROUND_AMOUNT (l_purchase_amount * l_line_oec/l_contract_oec , l_curr_code );
453:
454: else
455: l_purchase_amount := l_purchase_amount * l_line_oec/l_contract_oec;
456: end if;

Line 4796: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back

4792: l_converted_amount NUMBER;
4793:
4794: -- Since we do not use the amount or converted amount
4795: -- set a hardcoded value for the amount (and pass to to
4796: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back
4797: -- conversion values )
4798: l_hard_coded_amount NUMBER := 100;
4799: -- bug 12765251
4800: l_invoice_amount_total NUMBER;

Line 4894: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');

4890:
4891: -- Get the functional currency from AM_Util
4892: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency();
4893: IF (is_debug_statement_on) THEN
4894: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
4895: END IF;
4896: -- Get the currency conversion details from ACCOUNTING_Util
4897: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
4898: p_khr_id => p_term_rec.p_contract_id,

Line 4897: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(

4893: IF (is_debug_statement_on) THEN
4894: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_ACCOUNTING_UTIL.convert_to_functional_currency');
4895: END IF;
4896: -- Get the currency conversion details from ACCOUNTING_Util
4897: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
4898: p_khr_id => p_term_rec.p_contract_id,
4899: p_to_currency => l_functional_currency_code,
4900: p_transaction_date => l_quote_accpt_date, -- rmunjulu EDAT
4901: p_amount => l_hard_coded_amount,

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

4905: x_currency_conversion_rate => l_currency_conversion_rate,
4906: x_currency_conversion_date => l_currency_conversion_date,
4907: x_converted_amount => l_converted_amount);
4908: IF (is_debug_statement_on) THEN
4909: 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);
4910: END IF;
4911:
4912: -- Set some of the taiv rec attributes
4913: l_taiv_rec.currency_code := l_contract_currency_code;

Line 5197: l_formatted_inv_amt := OKL_ACCOUNTING_UTIL.format_amount(

5193: --ansethur 23-FEB-2007 commented for R12 B Billing Architecture Ends
5194: */
5195: --ansethur 23-FEB-2007 Added for R12 B Billing Architecture End Changes
5196: -- Format the invoice amt
5197: l_formatted_inv_amt := OKL_ACCOUNTING_UTIL.format_amount(
5198: p_amount => l_invoice_amount,
5199: p_currency_code => l_curr_code);
5200:
5201: -- Asset ASSET_NUMBER of Contract CONTRACT_NUMBER is invoiced with amount AMOUNT.

Line 5446: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back

5442: l_converted_amount NUMBER;
5443:
5444: -- Since we do not use the amount or converted amount
5445: -- set a hardcoded value for the amount (and pass to to
5446: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back
5447: -- conversion values )
5448: l_hard_coded_amount NUMBER := 100;
5449:
5450: -- RMUNJULU 3596626

Line 5729: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(

5725: -- Get the functional currency from AM_Util
5726: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;
5727:
5728: -- Get the currency conversion details from ACCOUNTING_Util
5729: OKL_ACCOUNTING_UTIL.convert_to_functional_currency(
5730: p_khr_id => p_term_rec.p_contract_id,
5731: p_to_currency => l_functional_currency_code,
5732: p_transaction_date => l_quote_accpt_date, -- rmunjulu EDAT
5733: p_amount => l_hard_coded_amount,

Line 5742: -- If error from OKL_ACCOUNTING_UTIL

5738: x_currency_conversion_date => l_currency_conversion_date,
5739: x_converted_amount => l_converted_amount);
5740:
5741:
5742: -- If error from OKL_ACCOUNTING_UTIL
5743: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5744:
5745: -- Error occurred when creating accounting entries for
5746: -- transaction TRX_TYPE.

Line 6045: l_formatted_adj_amt := OKL_ACCOUNTING_UTIL.format_amount(

6041: -- Set all success messages for all balances
6042: FOR k_bal_lns_rec IN k_bal_lns_csr ( p_term_rec.p_contract_id, l_quote_eff_date) LOOP -- rmunjulu EDAT
6043:
6044: -- Format the adjustment amt
6045: l_formatted_adj_amt := OKL_ACCOUNTING_UTIL.format_amount(
6046: k_bal_lns_rec.amount,
6047: l_currency_code);
6048:
6049: -- Append adjustment amt with currency code

Line 6097: l_formatted_bal_amt := OKL_ACCOUNTING_UTIL.format_amount(l_total_amount_due,l_currency_code);

6093: -- Get the currency code for contract
6094: l_currency_code := OKL_AM_UTIL_PVT.get_chr_currency(p_term_rec.p_contract_id);
6095:
6096: -- Format the balance amt
6097: l_formatted_bal_amt := OKL_ACCOUNTING_UTIL.format_amount(l_total_amount_due,l_currency_code);
6098:
6099: -- Append balance amt with currency code
6100: l_formatted_bal_amt := l_formatted_bal_amt || ' ' ||l_currency_code;
6101:

Line 6103: l_formatted_tol_amt := OKL_ACCOUNTING_UTIL.format_amount(l_tolerance_amt,l_currency_code);

6099: -- Append balance amt with currency code
6100: l_formatted_bal_amt := l_formatted_bal_amt || ' ' ||l_currency_code;
6101:
6102: -- Format the tolerance amt
6103: l_formatted_tol_amt := OKL_ACCOUNTING_UTIL.format_amount(l_tolerance_amt,l_currency_code);
6104:
6105: -- Append tolerance amt with currency code
6106: l_formatted_tol_amt := l_formatted_tol_amt || ' ' ||l_currency_code;
6107:

Line 6384: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back

6380: l_converted_amount NUMBER;
6381:
6382: -- Since we do not use the amount or converted amount
6383: -- set a hardcoded value for the amount (and pass to to
6384: -- OKL_ACCOUNTING_UTIL.convert_to_functional_currency and get back
6385: -- conversion values )
6386: l_hard_coded_amount NUMBER := 100;
6387:
6388: -- Bug 2902876

Line 6735: l_valid_gl_date := okl_accounting_util.get_valid_gl_date(p_gl_date => l_quote_accpt_date); -- rmunjulu EDAT

6731: lip_tmpl_identify_rec.memo_yn := g_no;
6732: lip_tmpl_identify_rec.prior_year_yn := g_no;
6733:
6734: -- Bug 2902876 Added to get the valid GL date
6735: l_valid_gl_date := okl_accounting_util.get_valid_gl_date(p_gl_date => l_quote_accpt_date); -- rmunjulu EDAT
6736:
6737: IF (is_debug_statement_on) THEN
6738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_securitization_pvt.check_khr_ia_associated');
6739: END IF;

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

6811: THEN
6812: --akrangan Bug 6147049 code fix end
6813: -- Get the currency conversion details from ACCOUNTING_Util
6814: IF (is_debug_statement_on) THEN
6815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_accounting_util.convert_to_functional_currency');
6816: END IF;
6817: okl_accounting_util.convert_to_functional_currency(
6818: p_khr_id => p_term_rec.p_contract_id,
6819: p_to_currency => l_functional_currency_code,

Line 6817: okl_accounting_util.convert_to_functional_currency(

6813: -- Get the currency conversion details from ACCOUNTING_Util
6814: IF (is_debug_statement_on) THEN
6815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_accounting_util.convert_to_functional_currency');
6816: END IF;
6817: okl_accounting_util.convert_to_functional_currency(
6818: p_khr_id => p_term_rec.p_contract_id,
6819: p_to_currency => l_functional_currency_code,
6820: p_transaction_date => l_quote_accpt_date, -- rmunjulu EDAT
6821: p_amount => l_hard_coded_amount,

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

6826: x_currency_conversion_date => l_currency_conversion_date,
6827: x_converted_amount => l_converted_amount
6828: );
6829: IF (is_debug_statement_on) THEN
6830: 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);
6831: END IF;
6832: -- If error from OKL_ACCOUNTING_UTIL
6833: IF l_return_status <> okl_api.g_ret_sts_success
6834: THEN

Line 6832: -- If error from OKL_ACCOUNTING_UTIL

6828: );
6829: IF (is_debug_statement_on) THEN
6830: 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);
6831: END IF;
6832: -- If error from OKL_ACCOUNTING_UTIL
6833: IF l_return_status <> okl_api.g_ret_sts_success
6834: THEN
6835:
6836: -- Error occurred when creating accounting entries for

Line 7086: lip_tcnv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id();

7082: --call the update trx contract api to update amount per stream type
7083: lip_tcnv_rec := px_tcnv_rec;
7084: --set all the necessary attributes of the record type
7085: lip_tcnv_rec.amount := 0;
7086: lip_tcnv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id();
7087: --akrangan bug 6147049 fix start
7088: lip_tcnv_rec.currency_conversion_rate := l_currency_conversion_rate;
7089: lip_tcnv_rec.currency_conversion_type := l_currency_conversion_type;
7090: lip_tcnv_rec.currency_conversion_date := l_currency_conversion_date;

Line 7234: okl_accounting_util.get_period_info(l_quote_eff_date,l_acc_period_name, l_acc_period_start_date,l_acc_period_end_date);

7230:
7231: -- asahoo bug 13259692 derive the period in which termination is falling first and then
7232: -- derive the current or next period based on Check_Accrual_Till_Previous_Month flag
7233:
7234: okl_accounting_util.get_period_info(l_quote_eff_date,l_acc_period_name, l_acc_period_start_date,l_acc_period_end_date);
7235:
7236: -- asahoo bug 13259692 now that we have derived the GL Period use the GL Period Start Date or End Date to derive the reversal date
7237:
7238: IF nvl(l_accrual_previous_mnth_yn, 'N') = 'N'

Line 7391: l_sob_id_rep := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(

7387: -- MGAAP 7263041 start
7388:
7389: IF (l_multi_gaap_yn = 'Y') THEN
7390:
7391: l_sob_id_rep := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
7392: p_representation_type => 'SECONDARY');
7393:
7394: l_valid_gl_date_rep :=
7395: okl_accounting_util.get_valid_gl_date (

Line 7395: okl_accounting_util.get_valid_gl_date (

7391: l_sob_id_rep := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
7392: p_representation_type => 'SECONDARY');
7393:
7394: l_valid_gl_date_rep :=
7395: okl_accounting_util.get_valid_gl_date (
7396: p_gl_date => l_quote_accpt_date,
7397: p_ledger_id => l_sob_id_rep
7398: );
7399:

Line 8207: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;

8203: FETCH c_asset_ret_dtls INTO l_asset_ret_dtls;
8204: CLOSE c_asset_ret_dtls;
8205: l_oec := l_asset_ret_dtls.asset_fmv_amount;
8206:
8207: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;
8208:
8209: /*IF (p_tax_book_2 IS NOT NULL AND p_tax_book_2 <> OKL_API.G_MISS_CHAR)
8210: THEN
8211: l_max_books := 3;

Line 8821: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;

8817: FETCH c_asset_ret_dtls INTO l_asset_ret_dtls;
8818: CLOSE c_asset_ret_dtls;
8819: l_oec := l_asset_ret_dtls.asset_fmv_amount;
8820:
8821: l_set_of_books_id := OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID;
8822:
8823: /*IF (p_tax_book_2 IS NOT NULL AND p_tax_book_2 <> OKL_API.G_MISS_CHAR)
8824: THEN
8825: l_max_books := 3;

Line 9658: okl_accounting_util.convert_to_functional_currency(

9654: l_contract_curr_code := okl_am_util_pvt.get_chr_currency( p_chr_id => p_term_rec.p_contract_id);
9655:
9656: IF l_contract_curr_code <> l_func_curr_code THEN
9657: -- convert amount to functional currency
9658: okl_accounting_util.convert_to_functional_currency(
9659: p_khr_id => p_term_rec.p_contract_id,
9660: p_to_currency => l_func_curr_code,
9661: p_transaction_date => l_quote_accpt_date , --px_tcnv_rec.date_transaction_occurred, -- rmunjulu EDAT
9662: p_amount => l_proceeds_of_sale,