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 699: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

695: LOOP
696: --start code pgomes 12/18/2002
697: IF (l_func_currency <> NVL(l_contract_currency, '000')) THEN
698: --convert late_chrg_amount to contract currency
699: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
700: p_khr_id => l_khr_id,
701: p_from_currency => l_func_currency,
702: p_transaction_date => sysdate,
703: p_amount => l_lpo_cur.late_chrg_amount,

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

706: x_currency_conversion_rate => l_currency_conversion_rate,
707: x_currency_conversion_date => l_currency_conversion_date,
708: x_converted_amount => l_late_chrg_amount);
709:
710: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);
711:
712: --convert minimum_late_charge to contract currency
713: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
714: p_khr_id => l_khr_id,

Line 713: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

709:
710: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);
711:
712: --convert minimum_late_charge to contract currency
713: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
714: p_khr_id => l_khr_id,
715: p_from_currency => l_func_currency,
716: p_transaction_date => sysdate,
717: p_amount => l_lpo_cur.minimum_late_charge,

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

720: x_currency_conversion_rate => l_currency_conversion_rate,
721: x_currency_conversion_date => l_currency_conversion_date,
722: x_converted_amount => l_minimum_late_charge);
723:
724: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);
725:
726: --convert maximum_late_charge to contract currency
727: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
728: p_khr_id => l_khr_id,

Line 727: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

723:
724: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);
725:
726: --convert maximum_late_charge to contract currency
727: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
728: p_khr_id => l_khr_id,
729: p_from_currency => l_func_currency,
730: p_transaction_date => sysdate,
731: p_amount => l_lpo_cur.maximum_late_charge,

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

734: x_currency_conversion_rate => l_currency_conversion_rate,
735: x_currency_conversion_date => l_currency_conversion_date,
736: x_converted_amount => l_maximum_late_charge);
737:
738: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);
739:
740: --convert late_chrg_minimum_balance to contract currency
741: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
742: p_khr_id => l_khr_id,

Line 741: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

737:
738: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);
739:
740: --convert late_chrg_minimum_balance to contract currency
741: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
742: p_khr_id => l_khr_id,
743: p_from_currency => l_func_currency,
744: p_transaction_date => sysdate,
745: p_amount => l_lpo_cur.late_chrg_minimum_balance,

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

748: x_currency_conversion_rate => l_currency_conversion_rate,
749: x_currency_conversion_date => l_currency_conversion_date,
750: x_converted_amount => l_late_chrg_minimum_balance);
751:
752: l_late_chrg_minimum_balance := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_minimum_balance, l_contract_currency);
753: ELSE
754: l_late_chrg_amount := l_lpo_cur.late_chrg_amount;
755: l_minimum_late_charge := l_lpo_cur.minimum_late_charge;
756: l_maximum_late_charge := l_lpo_cur.maximum_late_charge;

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

779: IF(l_late_chrg_fixed_yn = 'Y') THEN
780: l_late_charge_amt := l_late_chrg_amount;
781: l_investor_disb_flag := 'N';
782: ELSE --IF(l_lpo_cur.LATE_CHRG_FIXED_YN = 'N') THEN
783: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
784: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);
785:
786: IF(l_amount < nvl(l_minimum_late_charge,0)) THEN
787: l_late_charge_amt := l_minimum_late_charge;

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

1193: l_selv_rec.stm_id := l_stm_id;
1194: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;
1195: l_selv_rec.STREAM_ELEMENT_DATE := sysdate;
1196: --Added by bkatraga for bug 5601733
1197: 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);
1198: --end bkatraga
1199: l_selv_rec.COMMENTS := 'INVESTOR LATE FEE PAYABLE ELEMENTS';
1200: l_selv_rec.ACCRUED_YN := 'Y';
1201: l_selv_rec.sel_id := l_sel_id;

Line 1397: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

1393: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Functional currency : ' || l_func_currency || ' Contract currency : ' || l_contract_currency);
1394: IF (l_func_currency <> NVL(l_contract_currency, '000')) THEN
1395: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Converting late charge amounts from functional to contract.');
1396: --convert late_chrg_amount to contract currency
1397: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1398: p_khr_id => l_khr_id,
1399: p_from_currency => l_func_currency,
1400: p_transaction_date => sysdate,
1401: p_amount => l_lpo_cur.late_chrg_amount,

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

1404: x_currency_conversion_rate => l_currency_conversion_rate,
1405: x_currency_conversion_date => l_currency_conversion_date,
1406: x_converted_amount => l_late_chrg_amount);
1407:
1408: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);
1409:
1410: --convert minimum_late_charge to contract currency
1411: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1412: p_khr_id => l_khr_id,

Line 1411: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

1407:
1408: l_late_chrg_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_amount, l_contract_currency);
1409:
1410: --convert minimum_late_charge to contract currency
1411: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1412: p_khr_id => l_khr_id,
1413: p_from_currency => l_func_currency,
1414: p_transaction_date => sysdate,
1415: p_amount => l_lpo_cur.minimum_late_charge,

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

1418: x_currency_conversion_rate => l_currency_conversion_rate,
1419: x_currency_conversion_date => l_currency_conversion_date,
1420: x_converted_amount => l_minimum_late_charge);
1421:
1422: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);
1423:
1424: --convert maximum_late_charge to contract currency
1425: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1426: p_khr_id => l_khr_id,

Line 1425: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

1421:
1422: l_minimum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_minimum_late_charge, l_contract_currency);
1423:
1424: --convert maximum_late_charge to contract currency
1425: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1426: p_khr_id => l_khr_id,
1427: p_from_currency => l_func_currency,
1428: p_transaction_date => sysdate,
1429: p_amount => l_lpo_cur.maximum_late_charge,

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

1432: x_currency_conversion_rate => l_currency_conversion_rate,
1433: x_currency_conversion_date => l_currency_conversion_date,
1434: x_converted_amount => l_maximum_late_charge);
1435:
1436: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);
1437:
1438: --convert late_chrg_minimum_balance to contract currency
1439: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1440: p_khr_id => l_khr_id,

Line 1439: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(

1435:
1436: l_maximum_late_charge := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_maximum_late_charge, l_contract_currency);
1437:
1438: --convert late_chrg_minimum_balance to contract currency
1439: OKL_ACCOUNTING_UTIL.convert_to_contract_currency(
1440: p_khr_id => l_khr_id,
1441: p_from_currency => l_func_currency,
1442: p_transaction_date => sysdate,
1443: p_amount => l_lpo_cur.late_chrg_minimum_balance,

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

1446: x_currency_conversion_rate => l_currency_conversion_rate,
1447: x_currency_conversion_date => l_currency_conversion_date,
1448: x_converted_amount => l_late_chrg_minimum_balance);
1449:
1450: l_late_chrg_minimum_balance := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_late_chrg_minimum_balance, l_contract_currency);
1451: ELSE
1452: l_late_chrg_amount := l_lpo_cur.late_chrg_amount;
1453: l_minimum_late_charge := l_lpo_cur.minimum_late_charge;
1454: l_maximum_late_charge := l_lpo_cur.maximum_late_charge;

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

1479: IF(l_late_chrg_fixed_yn = 'Y') THEN
1480: l_late_charge_amt := l_late_chrg_amount;
1481: l_investor_disb_flag := 'N';
1482: ELSE --(l_lpo_cur.LATE_CHRG_FIXED_YN = 'N') THEN
1483: l_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(l_amt_due_remaining*(l_late_chrg_rate/100), l_contract_currency);
1484: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Calculated late charge => '||l_amount);
1485:
1486: IF(l_amount < nvl(l_minimum_late_charge,0)) THEN
1487: l_late_charge_amt := l_minimum_late_charge;

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

1905: l_selv_rec.stm_id := l_stm_id;
1906: l_selv_rec.SE_LINE_NUMBER := l_se_line_number;
1907: l_selv_rec.STREAM_ELEMENT_DATE := sysdate;
1908: --Added by bkatraga for bug 5601733
1909: 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);
1910: --end bkatraga
1911: l_selv_rec.COMMENTS := 'INVESTOR LATE FEE PAYABLE ELEMENTS';
1912: l_selv_rec.ACCRUED_YN := 'Y';
1913: l_selv_rec.sel_id := l_sel_id;