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_PRICING_PVT dependencies on OKL_PRICING_UTILS_PVT

Line 370: OKL_PRICING_UTILS_PVT.get_day_convention(

366: CLOSE c_rent_slls;
367:
368: l_start_date := l_rent_sll.start_date;
369: -- Fetch the day convention ..
370: OKL_PRICING_UTILS_PVT.get_day_convention(
371: p_id => p_khr_id,
372: p_source => 'ISG',
373: x_days_in_month => l_day_convention_month,
374: x_days_in_year => l_day_convention_year,

Line 395: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

391:
392: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
393: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'rent flow start date ' || l_rent_flow.se_date );
394: END IF;
395: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
396: p_days_in_month => l_day_convention_month,
397: p_days_in_year => l_day_convention_year,
398: p_end_date => l_rent_flow.se_date,
399: p_arrears => l_rent_flow.se_arrears,

Line 424: l_interim_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_asset_start_date,

420: End If;
421:
422: END LOOP;
423:
424: l_interim_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_asset_start_date,
425: p_end_date => l_rent_sll.start_date,
426: p_days_in_month => l_day_convention_month,
427: p_days_in_year => l_day_convention_year,
428: p_arrears => 'N',

Line 670: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

666: IF TRUNC(LAST_DAY(l_se_date)) <> TRUNC(LAST_DAY(l_start_date)) THEN -- NON payment month
667:
668: l_end_date := LAST_DAY(l_start_date);
669:
670: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
671: p_days_in_month => l_day_convention_month,
672: p_days_in_year => l_day_convention_year,
673: p_end_date => l_end_date,
674: p_arrears => 'Y',

Line 710: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

706: -- first half of payment month
707:
708: l_end_date := l_se_date;
709:
710: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
711: p_days_in_month => l_day_convention_month,
712: p_days_in_year => l_day_convention_year,
713: p_end_date => l_end_date,
714: p_arrears => l_rent_sll.arrears_yn,

Line 767: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

763: ELSE
764: l_end_date := l_k_end_date;
765: END IF;
766:
767: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
768: p_days_in_month => l_day_convention_month,
769: p_days_in_year => l_day_convention_year,
770: p_end_date => l_end_date,
771: p_arrears => 'Y',

Line 842: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

838: l_start_date := TRUNC(l_end_date);
839: l_end_date := TRUNC(NVL(l_sll_start_date,l_end_Date));
840: l_se_date := TRUNC(NVL(l_sll_start_date,l_end_Date));
841:
842: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
843: p_days_in_month => l_day_convention_month,
844: p_days_in_year => l_day_convention_year,
845: p_end_date => l_end_date,
846: p_arrears => l_rent_sll.arrears_yn,

Line 886: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

882: l_end_date := LAST_DAY(l_start_date);
883: ELSE
884: l_end_date := l_k_end_date;
885: END IF;
886: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
887: p_days_in_month => l_day_convention_month,
888: p_days_in_year => l_day_convention_year,
889: p_end_date => l_end_date,
890: p_arrears => 'Y',

Line 943: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

939: l_start_date := TRUNC(l_end_date);
940: l_end_date := TRUNC(asset_rents(k).se_date);
941: l_se_date := TRUNC(asset_rents(k).se_date);
942:
943: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
944: p_days_in_month => l_day_convention_month,
945: p_days_in_year => l_day_convention_year,
946: p_end_date => l_end_date,
947: p_arrears => l_rent_sll.arrears_yn,

Line 996: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

992: ELSE
993: l_end_date := l_k_end_date;
994: END IF;
995:
996: l_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
997: p_days_in_month => l_day_convention_month,
998: p_days_in_year => l_day_convention_year,
999: p_end_date => l_end_date,
1000: p_arrears => 'Y',

Line 1501: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;

1497: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_loan_amortization';
1498: l_day_count_method VARCHAR2(30);
1499: x_msg_count NUMBER;
1500: x_msg_data VARCHAR2(4000);
1501: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
1502: l_cf_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
1503: l_residuals okl_pricing_utils_pvt.cash_inflows_tbl_type;
1504: l_termination_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;
1505: l_pre_tax_inc_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;

Line 1502: l_cf_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;

1498: l_day_count_method VARCHAR2(30);
1499: x_msg_count NUMBER;
1500: x_msg_data VARCHAR2(4000);
1501: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
1502: l_cf_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
1503: l_residuals okl_pricing_utils_pvt.cash_inflows_tbl_type;
1504: l_termination_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;
1505: l_pre_tax_inc_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;
1506: -- End: Modifications done for the Prospective Rebooking Enhancement

Line 1503: l_residuals okl_pricing_utils_pvt.cash_inflows_tbl_type;

1499: x_msg_count NUMBER;
1500: x_msg_data VARCHAR2(4000);
1501: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
1502: l_cf_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
1503: l_residuals okl_pricing_utils_pvt.cash_inflows_tbl_type;
1504: l_termination_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;
1505: l_pre_tax_inc_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;
1506: -- End: Modifications done for the Prospective Rebooking Enhancement
1507:

Line 1504: l_termination_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;

1500: x_msg_data VARCHAR2(4000);
1501: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
1502: l_cf_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
1503: l_residuals okl_pricing_utils_pvt.cash_inflows_tbl_type;
1504: l_termination_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;
1505: l_pre_tax_inc_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;
1506: -- End: Modifications done for the Prospective Rebooking Enhancement
1507:
1508: -- Variables declared for Prospective Rebooking

Line 1505: l_pre_tax_inc_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;

1501: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
1502: l_cf_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
1503: l_residuals okl_pricing_utils_pvt.cash_inflows_tbl_type;
1504: l_termination_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;
1505: l_pre_tax_inc_tbl okl_pricing_utils_pvt.cash_inflows_tbl_type;
1506: -- End: Modifications done for the Prospective Rebooking Enhancement
1507:
1508: -- Variables declared for Prospective Rebooking
1509: -- Cursor to get the Original Contract Id and Line Id Details

Line 1560: l_orig_income_streams okl_pricing_utils_pvt.cash_inflows_tbl_type;

1556: l_orig_khr_id NUMBER;
1557: l_orig_kle_id NUMBER;
1558: cf_index NUMBER;
1559: l_flip_prb_rbk_reason VARCHAR2(100);
1560: l_orig_income_streams okl_pricing_utils_pvt.cash_inflows_tbl_type;
1561: l_rebook_type VARCHAR2(100);
1562: -- Bug 10207847
1563: slope NUMBER := 1;
1564:

Line 1594: OKL_PRICING_UTILS_PVT.get_day_convention(

1590: FETCH fee_type_csr INTO fee_type_rec;
1591: CLOSE fee_type_csr;
1592:
1593: -- Fetch the day convention ..
1594: OKL_PRICING_UTILS_PVT.get_day_convention(
1595: p_id => p_khr_id,
1596: p_source => 'ISG',
1597: x_days_in_month => l_day_convention_month,
1598: x_days_in_year => l_day_convention_year,

Line 1670: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

1666: -- Bug 6274342 DJANASWA end
1667:
1668:
1669: -- print( l_prog_name, 'rent flow start date ' || l_rent_flow.se_date );
1670: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
1671: p_days_in_month => l_day_convention_month,
1672: p_days_in_year => l_day_convention_year,
1673: p_end_date => l_rent_flow.se_date,
1674: p_arrears => l_rent_flow.se_arrears,

Line 1709: l_interim_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_asset_start_date,

1705: End If;
1706:
1707: END LOOP;
1708:
1709: l_interim_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_asset_start_date,
1710: p_days_in_month => l_day_convention_month,
1711: p_days_in_year => l_day_convention_year,
1712: p_end_date => l_rent_sll.start_date,
1713: p_arrears => 'N',

Line 1766: l_days := OKL_PRICING_UTILS_PVT.get_day_count(

1762:
1763: -- udhenuko Bug 5046430 Fix -start for get_loan_amortization
1764: -- terminal value of the asset considered in the calculation of IIR
1765: l_payment := l_residual_value;
1766: l_days := OKL_PRICING_UTILS_PVT.get_day_count(
1767: p_start_date => asset_rents(asset_rents.LAST).se_date,
1768: p_days_in_month => l_day_convention_month,
1769: p_days_in_year => l_day_convention_year,
1770: p_end_date => l_k_end_date,

Line 1986: -- the okl_pricing_utils_pvt.compute_bk_yield API to calculate the

1982: || p_khr_id || ' | ' || p_kle_id || ' ) ' );
1983: -- Modifications done as part of the Prospective Rebooking Enhancement
1984: -- Logic:
1985: -- Instead of calling the following peice of code, switching to call
1986: -- the okl_pricing_utils_pvt.compute_bk_yield API to calculate the
1987: -- Booking Yield as well as to return the Pre-Tax Income and Termination
1988: -- value streams.
1989: -- Step 1:
1990: -- Need to populate the following in the px_pricing_parameter_rec :

Line 2035: okl_pricing_utils_pvt.get_day_count_method(

2031: lx_pricing_parameter_rec.residual_inflows := l_residuals;
2032: -- Step 2:
2033: -- Get the Day Convention Method, as we have days in year and days in month
2034: -- Validations here ..
2035: okl_pricing_utils_pvt.get_day_count_method(
2036: p_days_in_month => l_day_convention_month,
2037: p_days_in_year => l_day_convention_year,
2038: x_day_count_method => l_day_count_method,
2039: x_return_status => lx_return_status );

Line 2154: print( l_prog_name, 'Before calling okl_pricing_utils_pvt.compute_bk_yield: ');

2150: print( l_prog_name, '!!! **** Reason : ' || l_flip_prb_rbk_reason );
2151: l_prosp_rebook_flag := 'N'; -- Use Retrospective Booking Logic only
2152: END IF;
2153: END IF;
2154: print( l_prog_name, 'Before calling okl_pricing_utils_pvt.compute_bk_yield: ');
2155: print( l_prog_name, 'p_start_date = ' || l_rent_sll.start_date );
2156: print( l_prog_name, 'l_day_count_method = ' || l_day_count_method );
2157: print( l_prog_name, 'p_bkg_yield_guess = ' || p_bkg_yield_guess );
2158: print( l_prog_name, 'p_term_duration = ' || p_term_duration );

Line 2164: okl_pricing_utils_pvt.compute_bk_yield(

2160: print( l_prog_name, 'p_rebook_date = ' || l_rebook_date);
2161: print( l_prog_name, 'l_orig_income_streams.count= ' || l_orig_income_streams.count);
2162: -- Call the Pricing API to calculate the Booking Yield
2163: -- and generate the Income Streams
2164: okl_pricing_utils_pvt.compute_bk_yield(
2165: p_api_version => l_api_version
2166: ,p_init_msg_list => 'T'
2167: ,x_return_status => lx_return_status
2168: ,x_msg_count => x_msg_count

Line 2184: print( l_prog_name, 'After okl_pricing_utils_pvt.compute_bk_yield: ' || lx_return_status);

2180: ,p_prosp_rebook_flag => l_prosp_rebook_flag
2181: ,p_rebook_date => l_rebook_date
2182: ,p_orig_income_streams => l_orig_income_streams
2183: );
2184: print( l_prog_name, 'After okl_pricing_utils_pvt.compute_bk_yield: ' || lx_return_status);
2185: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2187: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR) THEN
2188: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2437: OKL_PRICING_UTILS_PVT.get_day_convention(

2433: l_line_type := 'SO_PAYMENT';
2434: End If;
2435:
2436: -- Fetch the day convention ..
2437: OKL_PRICING_UTILS_PVT.get_day_convention(
2438: p_id => p_khr_id,
2439: p_source => 'ISG',
2440: x_days_in_month => l_day_convention_month,
2441: x_days_in_year => l_day_convention_year,

Line 2480: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(

2476: FOR l_rent_flow IN c_rent_flows(p_khr_id => p_khr_id,
2477: p_kle_id => p_kle_id,
2478: p_line_type => l_line_type) LOOP
2479: k := k + 1;
2480: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(
2481: p_start_date => l_start_date,
2482: p_days_in_month => l_day_convention_month,
2483: p_days_in_year => l_day_convention_year,
2484: p_end_date => l_rent_flow.se_date,

Line 2559: l_days := OKL_PRICING_UTILS_PVT.get_day_count(

2555: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'l_start_date '||TO_CHAR(l_start_date));
2556: END IF;
2557: IF LAST_DAY(l_se_date) <> LAST_DAY(l_start_date) THEN
2558: l_end_date := LAST_DAY(l_start_date);
2559: l_days := OKL_PRICING_UTILS_PVT.get_day_count(
2560: p_start_date => l_start_date,
2561: p_days_in_month => l_day_convention_month,
2562: p_days_in_year => l_day_convention_year,
2563: p_end_date => l_end_date,

Line 2584: l_days := OKL_PRICING_UTILS_PVT.get_day_count(

2580: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2581: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || ' Status 6 '||x_return_status);
2582: END IF;
2583: l_end_date := l_se_date;
2584: l_days := OKL_PRICING_UTILS_PVT.get_day_count(
2585: p_start_date => l_start_date,
2586: p_days_in_month => l_day_convention_month,
2587: p_days_in_year => l_day_convention_year,
2588: p_end_date => l_end_date,

Line 2616: l_days := OKL_PRICING_UTILS_PVT.get_day_count(

2612: l_end_date := LAST_DAY(l_start_date);
2613: ELSE
2614: l_end_date := l_k_end_date;
2615: END IF;
2616: l_days := OKL_PRICING_UTILS_PVT.get_day_count(
2617: p_start_date => l_start_date,
2618: p_days_in_month => l_day_convention_month,
2619: p_days_in_year => l_day_convention_year,
2620: p_end_date => l_end_date,

Line 2658: l_days := OKL_PRICING_UTILS_PVT.get_day_count(

2654: LAST_DAY(asset_rents(k).se_date) = LAST_DAY(asset_rents(k+1).se_date) THEN
2655: k := k + 1;
2656: l_se_date := trunc(asset_rents(k).se_date);
2657: l_end_date := l_se_date;
2658: l_days := OKL_PRICING_UTILS_PVT.get_day_count(
2659: p_start_date => l_start_date,
2660: p_days_in_month => l_day_convention_month,
2661: p_days_in_year => l_day_convention_year,
2662: p_end_date => l_end_date,

Line 3257: OKL_PRICING_UTILS_PVT.get_day_convention(

3253: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3254: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'check if the target is correctly given - done');
3255: END IF;
3256: -- Fetch the day convention ..
3257: OKL_PRICING_UTILS_PVT.get_day_convention(
3258: p_id => p_khr_id,
3259: p_source => 'ISG',
3260: x_days_in_month => l_day_convention_month,
3261: x_days_in_year => l_day_convention_year,

Line 3348: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

3344: inflow_tbl(n).rate := l_inflow.rate;
3345: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3346: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || ' start date::end date ' || l_inflow.start_date || '::' || l_inflow.cf_date|| x_return_status);
3347: END IF;
3348: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
3349: p_start_date => l_inflow.start_date,
3350: p_days_in_month => l_day_convention_month,
3351: p_days_in_year => l_day_convention_year,
3352: p_end_date => l_inflow.cf_date,

Line 3386: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

3382: inflow_tbl(n).rate := l_inflow.rate;
3383: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3384: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || ' start date::end date ' || l_inflow.start_date || '::' || l_inflow.cf_date|| x_return_status);
3385: END IF;
3386: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
3387: p_start_date => l_inflow.start_date,
3388: p_days_in_month => l_day_convention_month,
3389: p_days_in_year => l_day_convention_year,
3390: p_end_date => l_inflow.cf_date,

Line 3463: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

3459: p_token1_value => 'Rate');
3460: x_return_status := OKL_API.G_RET_STS_ERROR;
3461: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
3462: END IF;
3463: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
3464: p_start_date => ld_res_pay_start_date,
3465: p_days_in_month => l_day_convention_month,
3466: p_days_in_year => l_day_convention_year,
3467: p_end_date => rv_tbl(p).cf_date,

Line 3515: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

3511: p_token1_value => 'Rate');
3512: x_return_status := OKL_API.G_RET_STS_ERROR;
3513: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
3514: END IF;
3515: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
3516: p_start_date => l_outflow.start_date,
3517: p_days_in_month => l_day_convention_month,
3518: p_days_in_year => l_day_convention_year,
3519: p_end_date => l_outflow.start_date,

Line 3578: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

3574: p_token1_value => 'Rate');
3575: x_return_status := OKL_API.G_RET_STS_ERROR;
3576: RAISE OKL_API.G_EXCEPTION_ERROR;
3577: END IF;
3578: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
3579: p_start_date => ld_asset_start_date,
3580: p_days_in_month => l_day_convention_month,
3581: p_days_in_year => l_day_convention_year,
3582: p_end_date => ld_asset_start_date,

Line 3614: pass_th_tbl(r).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

3610: p_token1_value => 'Rate');
3611: x_return_status := OKL_API.G_RET_STS_ERROR;
3612: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
3613: END IF;
3614: pass_th_tbl(r).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
3615: p_start_date => l_pass_th.start_date,
3616: p_days_in_month => l_day_convention_month,
3617: p_days_in_year => l_day_convention_year,
3618: p_end_date => l_pass_th.cf_date,

Line 3664: rec_exp_tbl(s).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

3660: p_token1_value => 'Rate');
3661: x_return_status := OKL_API.G_RET_STS_ERROR;
3662: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
3663: END IF;
3664: rec_exp_tbl(s).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
3665: p_start_date => l_rec_exp.start_date,
3666: p_days_in_month => l_day_convention_month,
3667: p_days_in_year => l_day_convention_year,
3668: p_end_date => rec_exp_tbl(s).cf_date,

Line 3872: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_khr_start_date,

3868: OPEN c_security_deposit;
3869: FETCH c_security_deposit INTO l_security_deposit;
3870: If ( c_security_deposit%FOUND ) Then
3871:
3872: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_khr_start_date,
3873: p_days_in_month => l_day_convention_month,
3874: p_days_in_year => l_day_convention_year,
3875: p_end_date => l_security_deposit.cf_date,
3876: p_arrears => 'N' ,

Line 3894: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_khr_start_date,

3890: l_npv_rate := l_npv_rate +
3891: (l_security_deposit.cf_amount / POWER((1 + l_irr/l_security_deposit.periods_per_year), l_periods));
3892: End If;
3893:
3894: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_khr_start_date,
3895: p_days_in_month => l_day_convention_month,
3896: p_days_in_year => l_day_convention_year,
3897: p_end_date => l_security_deposit.end_date,
3898: p_arrears => 'N' ,

Line 4650: OKL_PRICING_UTILS_PVT.get_day_convention(

4646: x_return_status := G_RET_STS_SUCCESS;
4647:
4648: lx_return_status := G_RET_STS_ERROR;
4649: -- Fetch the day convention ..
4650: OKL_PRICING_UTILS_PVT.get_day_convention(
4651: p_id => p_khr_id,
4652: p_source => 'ISG',
4653: x_days_in_month => l_day_convention_month,
4654: x_days_in_year => l_day_convention_year,

Line 4709: hdr_inflow_tbl(m).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

4705: hdr_inflow_tbl(m).cf_purpose := l_hdr_inflow.cf_purpose;
4706: hdr_inflow_tbl(m).cf_dpp := l_hdr_inflow.days_per_period;
4707: hdr_inflow_tbl(m).cf_ppy := l_hdr_inflow.periods_per_year;
4708:
4709: hdr_inflow_tbl(m).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
4710: p_days_in_month => l_day_convention_month,
4711: p_days_in_year => l_day_convention_year,
4712: p_end_date => l_hdr_inflow.cf_date,
4713: p_arrears => l_hdr_inflow.cf_arrear,

Line 4746: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

4742: inflow_tbl(n).cf_purpose := l_inflow.cf_purpose;
4743: inflow_tbl(n).cf_dpp := l_inflow.days_per_period;
4744: inflow_tbl(n).cf_ppy := l_inflow.periods_per_year;
4745:
4746: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
4747: p_days_in_month => l_day_convention_month,
4748: p_days_in_year => l_day_convention_year,
4749: p_end_date => l_inflow.cf_date,
4750: p_arrears => l_inflow.cf_arrear,

Line 4776: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

4772: rv_tbl(p).cf_amount := OKL_AM_UTIL_PVT.get_actual_asset_residual(p_khr_id => p_khr_id,
4773: p_kle_id => l_asset_rv.id); --bug# 4184579
4774: rv_tbl(p).cf_date := l_asset_rv.date_terminated;
4775:
4776: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
4777: p_days_in_month => l_day_convention_month,
4778: p_days_in_year => l_day_convention_year,
4779: p_end_date => l_asset_rv.date_terminated,
4780: p_arrears => 'Y',

Line 4793: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

4789: Else
4790: rv_tbl(p).cf_amount := l_asset_rv.cf_amount;
4791: rv_tbl(p).cf_date := l_end_date;
4792:
4793: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
4794: p_days_in_month => l_day_convention_month,
4795: p_days_in_year => l_day_convention_year,
4796: p_end_date => l_end_date,
4797: p_arrears => 'Y',

Line 4829: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

4825: outflow_tbl(q).cf_date := l_outflow.start_date;
4826: outflow_tbl(q).cf_dpp := 1;
4827: outflow_tbl(q).cf_ppy := 360;
4828:
4829: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
4830: p_days_in_month => l_day_convention_month,
4831: p_days_in_year => l_day_convention_year,
4832: p_end_date => l_outflow.start_date,
4833: p_arrears => 'N',

Line 4867: OKL_PRICING_UTILS_PVT.get_day_count(

4863: outflow_tbl(q).cf_date := nvl(l_outflow.date_funding_expected, l_outflow.start_date);
4864: outflow_tbl(q).cf_dpp := l_outflow.days_per_period;
4865: outflow_tbl(q).cf_ppy := l_outflow.periods_per_year;
4866: outflow_tbl(q).cf_days :=
4867: OKL_PRICING_UTILS_PVT.get_day_count(
4868: p_start_date => p_start_date,
4869: p_days_in_month => l_day_convention_month,
4870: p_days_in_year => l_day_convention_year,
4871: p_end_date => outflow_tbl(q).cf_date,

Line 4895: OKL_PRICING_UTILS_PVT.get_day_count(

4891: outflow_tbl(q).cf_date := l_outflow.date_funding_expected;
4892: outflow_tbl(q).cf_dpp := l_outflow.days_per_period;
4893: outflow_tbl(q).cf_ppy := l_outflow.periods_per_year;
4894: outflow_tbl(q).cf_days :=
4895: OKL_PRICING_UTILS_PVT.get_day_count(
4896: p_start_date => l_outflow.date_funding_expected,
4897: p_days_in_month => l_day_convention_month,
4898: p_days_in_year => l_day_convention_year,
4899: p_end_date => p_start_date,

Line 4943: subsidies_tbl(1).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

4939: subsidies_tbl(1).cf_date := p_start_date;
4940: subsidies_tbl(1).cf_dpp := 1;
4941: subsidies_tbl(1).cf_ppy := 360;
4942:
4943: subsidies_tbl(1).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
4944: p_days_in_month => l_day_convention_month,
4945: p_days_in_year => l_day_convention_year,
4946: p_end_date => p_start_date,
4947: p_arrears => 'N',

Line 5026: pass_th_tbl(r).cf_days :=OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

5022: pass_th_tbl(r).cf_purpose := l_pass_th.cf_purpose;
5023: pass_th_tbl(r).cf_dpp := l_pass_th.days_per_period;
5024: pass_th_tbl(r).cf_ppy := l_pass_th.periods_per_year;
5025:
5026: pass_th_tbl(r).cf_days :=OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
5027: p_days_in_month => l_day_convention_month,
5028: p_days_in_year => l_day_convention_year,
5029: p_end_date => l_pass_th.cf_date,
5030: p_arrears => l_pass_th.cf_arrear,

Line 5053: rec_exp_tbl(s).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

5049: rec_exp_tbl(s).cf_date := ADD_MONTHS(l_rec_exp.start_date, (s1 -1)*l_rec_exp.cf_mpp);
5050: rec_exp_tbl(s).cf_dpp := l_rec_exp.cf_dpp;
5051: rec_exp_tbl(s).cf_ppy := l_rec_exp.cf_ppy;
5052:
5053: rec_exp_tbl(s).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
5054: p_days_in_month => l_day_convention_month,
5055: p_days_in_year => l_day_convention_year,
5056: p_end_date => rec_exp_tbl(s).cf_date,
5057: p_arrears => 'N',

Line 5405: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

5401: CLOSE c_deposit_date;
5402:
5403: IF l_deposit_date IS NOT NULL THEN
5404:
5405: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
5406: p_days_in_month => l_day_convention_month,
5407: p_days_in_year => l_day_convention_year,
5408: p_end_date => l_deposit_date,
5409: p_arrears => l_cf_arrear,

Line 5420: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

5416: END IF;
5417:
5418: ELSE
5419:
5420: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
5421: p_days_in_month => l_day_convention_month,
5422: p_days_in_year => l_day_convention_year,
5423: p_end_date => l_end_date,
5424: p_arrears => l_cf_arrear,

Line 5502: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

5498: CLOSE c_deposit_date;
5499:
5500: IF l_deposit_date IS NOT NULL THEN
5501:
5502: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
5503: p_days_in_month => l_day_convention_month,
5504: p_days_in_year => l_day_convention_year,
5505: p_end_date => l_deposit_date,
5506: p_arrears => l_cf_arrear,

Line 5517: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

5513: END IF;
5514:
5515: ELSE
5516:
5517: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
5518: p_days_in_month => l_day_convention_month,
5519: p_days_in_year => l_day_convention_year,
5520: p_end_date => l_end_date,
5521: p_arrears => l_cf_arrear,

Line 5970: OKL_PRICING_UTILS_PVT.get_day_convention(

5966: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );
5967:
5968: END IF;
5969: -- Fetch the day convention ..
5970: OKL_PRICING_UTILS_PVT.get_day_convention(
5971: p_id => p_khr_id,
5972: p_source => 'ISG',
5973: x_days_in_month => l_day_convention_month,
5974: x_days_in_year => l_day_convention_year,

Line 6005: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

6001: FOR l_rent_flow IN c_rent_flows LOOP
6002:
6003: k := k + 1;
6004:
6005: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
6006: p_days_in_month => l_day_convention_month,
6007: p_days_in_year => l_day_convention_year,
6008: p_end_date => l_rent_flow.se_date,
6009: p_arrears => l_rent_flow.se_arrears,

Line 6030: l_interim_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_kle.start_date,

6026: END IF;
6027:
6028: END LOOP;
6029:
6030: l_interim_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_kle.start_date,
6031: p_days_in_month => l_day_convention_month,
6032: p_days_in_year => l_day_convention_year,
6033: p_end_date => l_rent_sll.start_date,
6034: p_arrears => 'N',

Line 6460: OKL_PRICING_UTILS_PVT.get_day_convention(

6456: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'check if the target is correctly given' || ' ' || p_target );
6457:
6458: END IF;
6459: -- Fetch the day convention ..
6460: OKL_PRICING_UTILS_PVT.get_day_convention(
6461: p_id => p_khr_id,
6462: p_source => 'ISG',
6463: x_days_in_month => l_day_convention_month,
6464: x_days_in_year => l_day_convention_year,

Line 6547: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

6543: inflow_tbl(n).cf_purpose := l_inflow.cf_purpose;
6544: inflow_tbl(n).cf_dpp := l_inflow.days_per_period;
6545: inflow_tbl(n).cf_ppy := l_inflow.periods_per_year;
6546: inflow_tbl(n).rate := l_inflow.rate;
6547: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
6548: p_start_date => l_inflow.start_date,
6549: p_days_in_month => l_day_convention_month,
6550: p_days_in_year => l_day_convention_year,
6551: p_end_date => l_inflow.cf_date,

Line 6615: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

6611: p_token1_value => 'Rate');
6612: x_return_status := OKL_API.G_RET_STS_ERROR;
6613: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
6614: END IF;
6615: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
6616: p_start_date => ld_res_pay_start_date,
6617: p_days_in_month => l_day_convention_month,
6618: p_days_in_year => l_day_convention_year,
6619: p_end_date => rv_tbl(p).cf_date,

Line 6677: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

6673: p_token1_value => 'Rate');
6674: x_return_status := OKL_API.G_RET_STS_ERROR;
6675: RAISE OKL_API.G_EXCEPTION_ERROR;
6676: END IF;
6677: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
6678: p_start_date => ld_asset_start_date,
6679: p_days_in_month => l_day_convention_month,
6680: p_days_in_year => l_day_convention_year,
6681: p_end_date => ld_asset_start_date,

Line 7946: OKL_PRICING_UTILS_PVT.get_day_convention(

7942: END IF;
7943: x_return_status := G_RET_STS_SUCCESS;
7944:
7945: -- Fetch the day convention ..
7946: OKL_PRICING_UTILS_PVT.get_day_convention(
7947: p_id => p_khr_id,
7948: p_source => 'ISG',
7949: x_days_in_month => l_day_convention_month,
7950: x_days_in_year => l_day_convention_year,

Line 8023: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_ppd_date,

8019: END IF;
8020:
8021: l_npv := l_npv - NVL(l_principal_balance, 0);
8022:
8023: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_ppd_date,
8024: p_days_in_month => l_day_convention_month,
8025: p_days_in_year => l_day_convention_year,
8026: p_end_date => p_pay_start_date,
8027: p_arrears => 'N',

Line 8075: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_ppd_date,

8071: END IF;
8072: FOR i in lx_selv_tbl.FIRST..lx_selv_tbl.LAST
8073: LOOP
8074:
8075: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_ppd_date,
8076: p_days_in_month => l_day_convention_month,
8077: p_days_in_year => l_day_convention_year,
8078: p_end_date => lx_selv_tbl(i).stream_element_date,
8079: p_arrears => p_arrears_yn,

Line 8551: OKL_PRICING_UTILS_PVT.get_day_convention(

8547: END IF;
8548: x_return_status := G_RET_STS_SUCCESS;
8549:
8550: -- Fetch the day convention ..
8551: OKL_PRICING_UTILS_PVT.get_day_convention(
8552: p_id => p_khr_id,
8553: p_source => 'ISG',
8554: x_days_in_month => l_day_convention_month,
8555: x_days_in_year => l_day_convention_year,

Line 8609: hdr_inflow_tbl(m).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

8605: hdr_inflow_tbl(m).cf_purpose := l_hdr_inflow.cf_purpose;
8606: hdr_inflow_tbl(m).cf_dpp := l_hdr_inflow.days_per_period;
8607: hdr_inflow_tbl(m).cf_ppy := l_hdr_inflow.periods_per_year;
8608:
8609: hdr_inflow_tbl(m).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
8610: p_days_in_month => l_day_convention_month,
8611: p_days_in_year => l_day_convention_year,
8612: p_end_date => l_hdr_inflow.cf_date,
8613: p_arrears => l_hdr_inflow.cf_arrear,

Line 8634: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

8630: inflow_tbl(n).cf_date := l_inflow.cf_date;
8631: inflow_tbl(n).cf_purpose := l_inflow.cf_purpose;
8632: inflow_tbl(n).cf_dpp := l_inflow.days_per_period;
8633: inflow_tbl(n).cf_ppy := l_inflow.periods_per_year;
8634: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
8635: p_days_in_month => l_day_convention_month,
8636: p_days_in_year => l_day_convention_year,
8637: p_end_date => l_inflow.cf_date,
8638: p_arrears => l_inflow.cf_arrear,

Line 8670: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

8666: inflow_tbl(n).cf_purpose := l_fee_inflow.cf_purpose;
8667: inflow_tbl(n).cf_dpp := l_fee_inflow.days_per_period;
8668: inflow_tbl(n).cf_ppy := l_fee_inflow.periods_per_year;
8669:
8670: inflow_tbl(n).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
8671: p_days_in_month => l_day_convention_month,
8672: p_days_in_year => l_day_convention_year,
8673: p_end_date => l_fee_inflow.cf_date,
8674: p_arrears => l_fee_inflow.cf_arrear,

Line 8701: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

8697: If l_asset_rv.sts_code = 'TERMINATED' Then
8698: rv_tbl(p).cf_amount := OKL_AM_UTIL_PVT.get_actual_asset_residual(p_khr_id => p_khr_id,
8699: p_kle_id => l_asset_rv.id); --bug# 4184579
8700: rv_tbl(p).cf_date := l_asset_rv.date_terminated;
8701: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
8702: p_days_in_month => l_day_convention_month,
8703: p_days_in_year => l_day_convention_year,
8704: p_end_date => l_asset_rv.date_terminated,
8705: p_arrears => 'Y',

Line 8716: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

8712: ELSE
8713: rv_tbl(p).cf_amount := l_asset_rv.cf_amount;
8714: rv_tbl(p).cf_date := l_end_date;
8715:
8716: rv_tbl(p).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
8717: p_days_in_month => l_day_convention_month,
8718: p_days_in_year => l_day_convention_year,
8719: p_end_date => l_end_date,
8720: p_arrears => 'Y',

Line 8758: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

8754: outflow_tbl(q).cf_date := l_outflow.start_date;
8755: outflow_tbl(q).cf_dpp := 1;
8756: outflow_tbl(q).cf_ppy := 360;
8757:
8758: outflow_tbl(q).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
8759: p_days_in_month => l_day_convention_month,
8760: p_days_in_year => l_day_convention_year,
8761: p_end_date => l_outflow.start_date,
8762: p_arrears => 'N',

Line 8796: OKL_PRICING_UTILS_PVT.get_day_count(

8792: outflow_tbl(q).cf_date := nvl(l_outflow.date_funding_expected, l_outflow.start_date);
8793: outflow_tbl(q).cf_dpp := l_outflow.days_per_period;
8794: outflow_tbl(q).cf_ppy := l_outflow.periods_per_year;
8795: outflow_tbl(q).cf_days :=
8796: OKL_PRICING_UTILS_PVT.get_day_count(
8797: p_start_date => p_start_date,
8798: p_days_in_month => l_day_convention_month,
8799: p_days_in_year => l_day_convention_year,
8800: p_end_date => outflow_tbl(q).cf_date,

Line 8824: OKL_PRICING_UTILS_PVT.get_day_count(

8820: outflow_tbl(q).cf_date := l_outflow.date_funding_expected;
8821: outflow_tbl(q).cf_dpp := l_outflow.days_per_period;
8822: outflow_tbl(q).cf_ppy := l_outflow.periods_per_year;
8823: outflow_tbl(q).cf_days :=
8824: OKL_PRICING_UTILS_PVT.get_day_count(
8825: p_start_date => l_outflow.date_funding_expected,
8826: p_days_in_month => l_day_convention_month,
8827: p_days_in_year => l_day_convention_year,
8828: p_end_date => p_start_date,

Line 8872: subsidies_tbl(1).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(

8868: subsidies_tbl(1).cf_date := p_start_date;
8869: subsidies_tbl(1).cf_dpp := 1;
8870: subsidies_tbl(1).cf_ppy := 360;
8871:
8872: subsidies_tbl(1).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(
8873: p_days_in_month => l_day_convention_month,
8874: p_days_in_year => l_day_convention_year,
8875: p_start_date => p_start_date,
8876: p_end_date => p_start_date,

Line 8903: rec_exp_tbl(s).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

8899: rec_exp_tbl(s).cf_date := ADD_MONTHS(l_rec_exp.start_date, (s1 -1)*l_rec_exp.cf_mpp);
8900: rec_exp_tbl(s).cf_dpp := l_rec_exp.cf_dpp;
8901: rec_exp_tbl(s).cf_ppy := l_rec_exp.cf_ppy;
8902:
8903: rec_exp_tbl(s).cf_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
8904: p_days_in_month => l_day_convention_month,
8905: p_days_in_year => l_day_convention_year,
8906: p_end_date => rec_exp_tbl(s).cf_date,
8907: p_arrears => 'N',

Line 9086: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

9082: CLOSE c_deposit_date;
9083:
9084: IF l_deposit_date IS NOT NULL THEN
9085:
9086: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
9087: p_days_in_month => l_day_convention_month,
9088: p_days_in_year => l_day_convention_year,
9089: p_end_date => l_deposit_date,
9090: p_arrears => l_cf_arrear,

Line 9101: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

9097: END IF;
9098:
9099: ELSE
9100:
9101: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
9102: p_days_in_month => l_day_convention_month,
9103: p_days_in_year => l_day_convention_year,
9104: p_end_date => l_end_date,
9105: p_arrears => l_cf_arrear,

Line 9175: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

9171: CLOSE c_deposit_date;
9172:
9173: IF l_deposit_date IS NOT NULL THEN
9174:
9175: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
9176: p_days_in_month => l_day_convention_month,
9177: p_days_in_year => l_day_convention_year,
9178: p_end_date => l_deposit_date,
9179: p_arrears => l_cf_arrear,

Line 9190: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,

9186: END IF;
9187:
9188: ELSE
9189:
9190: l_days_in_future := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => p_start_date,
9191: p_days_in_month => l_day_convention_month,
9192: p_days_in_year => l_day_convention_year,
9193: p_end_date => l_end_date,
9194: p_arrears => l_cf_arrear,

Line 10460: OKL_PRICING_UTILS_PVT.get_day_convention(

10456: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
10457: RAISE okl_api.g_exception_error;
10458: END IF;
10459: -- Fetch the day convention ..
10460: OKL_PRICING_UTILS_PVT.get_day_convention(
10461: p_id => p_khr_id,
10462: p_source => 'ISG',
10463: x_days_in_month => l_day_convention_month,
10464: x_days_in_year => l_day_convention_year,

Line 10552: ln_int_ppd_days := OKL_PRICING_UTILS_PVT.get_day_count(

10548:
10549:
10550: FOR j IN l_selv_tbl.FIRST..l_selv_tbl.LAST LOOP
10551:
10552: ln_int_ppd_days := OKL_PRICING_UTILS_PVT.get_day_count(
10553: p_start_date => l_start_date,
10554: p_days_in_month => l_day_convention_month,
10555: p_days_in_year => l_day_convention_year,
10556: p_end_date => l_selv_tbl(j).stream_element_date,

Line 10589: l_intrm_days := OKL_PRICING_UTILS_PVT.get_day_count(

10585: l_pay_level(l_pay_level.FIRST).start_date <> okl_api.g_miss_date) AND
10586: (p_ppd_date IS NOT NULL OR
10587: p_ppd_date <> okl_api.g_miss_date) AND
10588: l_pay_level(l_pay_level.FIRST).start_date > p_ppd_date THEN
10589: l_intrm_days := OKL_PRICING_UTILS_PVT.get_day_count(
10590: p_start_date => p_ppd_date,
10591: p_days_in_month => l_day_convention_month,
10592: p_days_in_year => l_day_convention_year,
10593: p_end_date => l_pay_level(l_pay_level.FIRST).start_date,

Line 10920: OKL_PRICING_UTILS_PVT.get_day_convention(

10916: fetch get_precision into l_precision;
10917: close get_precision;
10918:
10919: -- Fetch the day convention ..
10920: OKL_PRICING_UTILS_PVT.get_day_convention(
10921: p_id => p_khr_id,
10922: p_source => 'ISG',
10923: x_days_in_month => l_day_convention_month,
10924: x_days_in_year => l_day_convention_year,

Line 10956: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,

10952: k := k + 1;
10953:
10954: print( l_prog_name, 'l_start_date :' || l_start_date );
10955:
10956: asset_rents(k).se_days := OKL_PRICING_UTILS_PVT.get_day_count(p_start_date => l_start_date,
10957: p_days_in_month => l_day_convention_month,
10958: p_days_in_year => l_day_convention_year,
10959: p_end_date => l_rent_flow.se_date,
10960: p_arrears => l_rent_flow.se_arrears,