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.

[Home] [Help]

APPS.OKL_PRICING_PVT dependencies on FND_PROFILE

Line 267: l_iir_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IIR_LIMIT')), 1000)/100;

263: interest_payment loan_tbl;
264: pre_tax_income loan_tbl;
265: termination_val loan_tbl;
266:
267: l_iir_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IIR_LIMIT')), 1000)/100;
268:
269: l_start_date DATE;
270: l_sll_start_date DATE;
271: l_end_date DATE;

Line 1377: l_iir_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IIR_LIMIT')), 1000)/100;

1373: interest_payment loan_tbl;
1374: pre_tax_income loan_tbl;
1375: termination_val loan_tbl;
1376:
1377: l_iir_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IIR_LIMIT')), 1000)/100;
1378:
1379: l_start_date DATE;
1380: l_sll_start_date DATE;
1381: l_end_date DATE;

Line 2846: l_irr_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000)/100;

2842: l_periods NUMBER;
2843: l_irr NUMBER := 0;
2844: l_npv_rate NUMBER;
2845: l_npv_pay NUMBER;
2846: l_irr_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000)/100;
2847: l_prev_npv_pay NUMBER;
2848: l_prev_npv_sign_pay NUMBER;
2849: l_crossed_zero_pay VARCHAR2(1) := 'N';
2850: l_increment_pay NUMBER := 0.1; -- 10% increment

Line 3722: l_irr_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;

3718: RAISE OKL_API.G_EXCEPTION_ERROR;
3719: END IF;
3720: CLOSE get_curr_code_pre;
3721: -- Setting the IRR limit
3722: l_irr_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;
3723: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3724: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'l_irr_limit ' ||l_irr_limit);
3725: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'b4 getting into the loop '|| x_return_status);
3726: END IF;

Line 4562: l_irr_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000)/100;

4558: i BINARY_INTEGER := 0;
4559: l_irr NUMBER := nvl( p_initial_irr, 0 );
4560: l_npv NUMBER;
4561:
4562: l_irr_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000)/100;
4563:
4564: l_prev_npv NUMBER;
4565: l_prev_npv_sign NUMBER;
4566:

Line 5129: l_irr_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;

5125:
5126:
5127: l_precision := 4;
5128:
5129: l_irr_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;
5130:
5131:
5132: -- Added for IRR Approximation
5133: -- Appr. IRR based on Simple Interest Calculation

Line 5915: l_iir_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IIR_LIMIT')), 1000)/100;

5911: l_payment_amount NUMBER := 0.1;
5912:
5913: l_investment NUMBER;
5914:
5915: l_iir_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IIR_LIMIT')), 1000)/100;
5916:
5917: l_start_date DATE;
5918: l_end_date DATE;
5919: l_interim_days NUMBER;

Line 6281: l_irr_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000)/100;

6277: l_periods NUMBER;
6278: l_irr NUMBER := 0;
6279: l_npv_rate NUMBER;
6280: l_npv_pay NUMBER;
6281: l_irr_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000)/100;
6282: l_prev_npv_pay NUMBER;
6283: l_prev_npv_sign_pay NUMBER;
6284: l_crossed_zero_pay VARCHAR2(1) := 'N';
6285: l_increment_pay NUMBER := 0.1; -- 10% increment

Line 6728: l_irr_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;

6724: END IF;
6725: CLOSE get_curr_code_pre;
6726:
6727: -- Setting the IRR limit
6728: l_irr_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;
6729: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6730: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'l_irr_limit ' || l_irr_limit);
6731: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'b4 getting into the loop '|| x_return_status);
6732: END IF;

Line 8506: l_iir_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000)/100;

8502: i BINARY_INTEGER := 0;
8503: l_iir NUMBER := nvl(p_initial_iir, 0);
8504:
8505: l_npv NUMBER;
8506: l_iir_limit NUMBER := NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000)/100;
8507:
8508: l_prev_npv NUMBER;
8509: l_prev_npv_sign NUMBER;
8510:

Line 8967: l_iir_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;

8963: INTO l_precision
8964: FROM fnd_currencies
8965: WHERE currency_code = l_currency_code;
8966:
8967: l_iir_limit := ROUND(NVL(ABS(fnd_profile.value('OKL_PRE_TAX_IRR_LIMIT')), 1000), 0)/100;
8968: --print( 'Initial iir estimated ' || l_iir );
8969: LOOP
8970: i := i + 1;
8971: l_npv := -(l_time_zero_cost);