DBA Data[Home] [Help]

APPS.OKL_LTE_CHRG_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

46: l_sec_rec_inv_id OKL_CNSLD_AR_STRMS_V.ID%TYPE;
47: l_error_flag BOOLEAN := FALSE;
48:
49: --start code pgomes 12/18/2002
50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
51: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
52: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
53: l_late_policy okl_late_policies_v.name%TYPE;
54: l_prev_late_policy okl_late_policies_v.name%TYPE;

Line 692: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

688: LOOP
689: --start code pgomes 12/18/2002
690: IF (l_func_currency <> NVL(l_contract_currency, '000')) THEN
691: --convert late_chrg_amount to contract currency
692: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
693: p_khr_id => l_khr_id,
694: p_from_currency => l_func_currency,
695: p_transaction_date => sysdate,
696: p_amount => l_lpo_cur.late_chrg_amount,

Line 703: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);

699: x_currency_conversion_rate => l_currency_conversion_rate,
700: x_currency_conversion_date => l_currency_conversion_date,
701: x_converted_amount => l_late_chrg_amount);
702:
703: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);
704:
705: --convert minimum_late_charge to contract currency
706: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
707: p_khr_id => l_khr_id,

Line 706: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

702:
703: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);
704:
705: --convert minimum_late_charge to contract currency
706: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
707: p_khr_id => l_khr_id,
708: p_from_currency => l_func_currency,
709: p_transaction_date => sysdate,
710: p_amount => l_lpo_cur.minimum_late_charge,

Line 717: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);

713: x_currency_conversion_rate => l_currency_conversion_rate,
714: x_currency_conversion_date => l_currency_conversion_date,
715: x_converted_amount => l_minimum_late_charge);
716:
717: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);
718:
719: --convert maximum_late_charge to contract currency
720: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
721: p_khr_id => l_khr_id,

Line 720: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

716:
717: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);
718:
719: --convert maximum_late_charge to contract currency
720: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
721: p_khr_id => l_khr_id,
722: p_from_currency => l_func_currency,
723: p_transaction_date => sysdate,
724: p_amount => l_lpo_cur.maximum_late_charge,

Line 731: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);

727: x_currency_conversion_rate => l_currency_conversion_rate,
728: x_currency_conversion_date => l_currency_conversion_date,
729: x_converted_amount => l_maximum_late_charge);
730:
731: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);
732:
733: --convert late_chrg_minimum_balance to contract currency
734: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
735: p_khr_id => l_khr_id,

Line 734: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

730:
731: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);
732:
733: --convert late_chrg_minimum_balance to contract currency
734: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
735: p_khr_id => l_khr_id,
736: p_from_currency => l_func_currency,
737: p_transaction_date => sysdate,
738: p_amount => l_lpo_cur.late_chrg_minimum_balance,

Line 745: l_late_chrg_minimum_balance := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_minimum_balance, l_contract_currency);

741: x_currency_conversion_rate => l_currency_conversion_rate,
742: x_currency_conversion_date => l_currency_conversion_date,
743: x_converted_amount => l_late_chrg_minimum_balance);
744:
745: l_late_chrg_minimum_balance := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_minimum_balance, l_contract_currency);
746: ELSE
747: l_late_chrg_amount := l_lpo_cur.late_chrg_amount;
748: l_minimum_late_charge := l_lpo_cur.minimum_late_charge;
749: l_maximum_late_charge := l_lpo_cur.maximum_late_charge;

Line 776: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);

772: IF(l_late_chrg_fixed_yn = 'Y') THEN
773: l_late_charge_amt := l_late_chrg_amount;
774: l_investor_disb_flag := 'N';
775: ELSE --IF(l_lpo_cur.LATE_CHRG_FIXED_YN = 'N') THEN
776: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
777: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);
778:
779: IF(l_amount < nvl(l_minimum_late_charge,0)) THEN
780: l_late_charge_amt := l_minimum_late_charge;

Line 1190: l_selv_rec.AMOUNT := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(cur_sec_strm.amount_due_remaining*(l_late_chrg_rate/100), l_contract_currency);

1186: l_selv_rec.stm_id := l_stm_id;
1187: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;
1188: l_selv_rec.STREAM_ELEMENT_DATE := sysdate;
1189: --Added by bkatraga for bug 5601733
1190: l_selv_rec.AMOUNT := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(cur_sec_strm.amount_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
1191: --end bkatraga
1192: l_selv_rec.COMMENTS := 'INVESTOR LATE FEE PAYABLE ELEMENTS';
1193: l_selv_rec.ACCRUED_YN := 'Y';
1194: l_selv_rec.sel_id := l_sel_id;

Line 1389: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

1385: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Functional currency : ' || l_func_currency || ' Contract currency : ' || l_contract_currency);
1386: IF (l_func_currency <> NVL(l_contract_currency, '000')) THEN
1387: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Converting late charge amounts from functional to contract.');
1388: --convert late_chrg_amount to contract currency
1389: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1390: p_khr_id => l_khr_id,
1391: p_from_currency => l_func_currency,
1392: p_transaction_date => sysdate,
1393: p_amount => l_lpo_cur.late_chrg_amount,

Line 1400: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);

1396: x_currency_conversion_rate => l_currency_conversion_rate,
1397: x_currency_conversion_date => l_currency_conversion_date,
1398: x_converted_amount => l_late_chrg_amount);
1399:
1400: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);
1401:
1402: --convert minimum_late_charge to contract currency
1403: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1404: p_khr_id => l_khr_id,

Line 1403: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

1399:
1400: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);
1401:
1402: --convert minimum_late_charge to contract currency
1403: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1404: p_khr_id => l_khr_id,
1405: p_from_currency => l_func_currency,
1406: p_transaction_date => sysdate,
1407: p_amount => l_lpo_cur.minimum_late_charge,

Line 1414: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);

1410: x_currency_conversion_rate => l_currency_conversion_rate,
1411: x_currency_conversion_date => l_currency_conversion_date,
1412: x_converted_amount => l_minimum_late_charge);
1413:
1414: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);
1415:
1416: --convert maximum_late_charge to contract currency
1417: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1418: p_khr_id => l_khr_id,

Line 1417: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

1413:
1414: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);
1415:
1416: --convert maximum_late_charge to contract currency
1417: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1418: p_khr_id => l_khr_id,
1419: p_from_currency => l_func_currency,
1420: p_transaction_date => sysdate,
1421: p_amount => l_lpo_cur.maximum_late_charge,

Line 1428: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);

1424: x_currency_conversion_rate => l_currency_conversion_rate,
1425: x_currency_conversion_date => l_currency_conversion_date,
1426: x_converted_amount => l_maximum_late_charge);
1427:
1428: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);
1429:
1430: --convert late_chrg_minimum_balance to contract currency
1431: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1432: p_khr_id => l_khr_id,

Line 1431: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

1427:
1428: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);
1429:
1430: --convert late_chrg_minimum_balance to contract currency
1431: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1432: p_khr_id => l_khr_id,
1433: p_from_currency => l_func_currency,
1434: p_transaction_date => sysdate,
1435: p_amount => l_lpo_cur.late_chrg_minimum_balance,

Line 1442: l_late_chrg_minimum_balance := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_minimum_balance, l_contract_currency);

1438: x_currency_conversion_rate => l_currency_conversion_rate,
1439: x_currency_conversion_date => l_currency_conversion_date,
1440: x_converted_amount => l_late_chrg_minimum_balance);
1441:
1442: l_late_chrg_minimum_balance := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_minimum_balance, l_contract_currency);
1443: ELSE
1444: l_late_chrg_amount := l_lpo_cur.late_chrg_amount;
1445: l_minimum_late_charge := l_lpo_cur.minimum_late_charge;
1446: l_maximum_late_charge := l_lpo_cur.maximum_late_charge;

Line 1475: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);

1471: IF(l_late_chrg_fixed_yn = 'Y') THEN
1472: l_late_charge_amt := l_late_chrg_amount;
1473: l_investor_disb_flag := 'N';
1474: ELSE --(l_lpo_cur.LATE_CHRG_FIXED_YN = 'N') THEN
1475: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
1476: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);
1477:
1478: IF(l_amount < nvl(l_minimum_late_charge,0)) THEN
1479: l_late_charge_amt := l_minimum_late_charge;

Line 1901: l_selv_rec.AMOUNT := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(cur_sec_strm.amount_due_remaining*(l_late_chrg_rate/100), l_contract_currency);

1897: l_selv_rec.stm_id := l_stm_id;
1898: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;
1899: l_selv_rec.STREAM_ELEMENT_DATE := sysdate;
1900: --Added by bkatraga for bug 5601733
1901: l_selv_rec.AMOUNT := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(cur_sec_strm.amount_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
1902: --end bkatraga
1903: l_selv_rec.COMMENTS := 'INVESTOR LATE FEE PAYABLE ELEMENTS';
1904: l_selv_rec.ACCRUED_YN := 'Y';
1905: l_selv_rec.sel_id := l_sel_id;