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_UTILS_PVT dependencies on OKL_STREAM_GENERATOR_PVT

Line 1772: -- okl_stream_generator_pvt.get_months_factor handle if frequence is passed one among M/Q/S/A

1768: ELSE
1769: -- This is a regular periodic Payment
1770: n_periods := p_periods;
1771: -- Get the month Factor
1772: -- okl_stream_generator_pvt.get_months_factor handle if frequence is passed one among M/Q/S/A
1773: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1774: 'p_frequency_passed'||p_frequency);
1775:
1776: If ( nvl(p_frequency, 'X') = 'X') Then

Line 1788: l_months_factor := okl_stream_generator_pvt.get_months_factor(

1784: RAISE OKL_API.G_EXCEPTION_ERROR;
1785:
1786: End If;
1787:
1788: l_months_factor := okl_stream_generator_pvt.get_months_factor(
1789: p_frequency => p_frequency,
1790: x_return_status => l_return_status);
1791: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1792: 'p_months_factor'||l_months_factor);

Line 1810: okl_stream_generator_pvt.get_sel_date(

1806: -- Bug 6660626 : End
1807: -- Get the Stream Element date after i months from the p_start_date
1808: -- when the payments are ADVANCE
1809: -- Added parameter p_recurrence_date by Durga Janaswamy for bug 6007644
1810: okl_stream_generator_pvt.get_sel_date(
1811: p_start_date => p_start_date,
1812: p_advance_or_arrears => 'N',
1813: p_periods_after => i,
1814: p_months_per_period => l_months_factor,

Line 1826: okl_stream_generator_pvt.get_sel_date(

1822: END IF;
1823: -- Get the Stream Element date after i months from the p_start_date
1824: -- when the payments are ARREARS
1825: -- Added parameter p_recurrence_date by Durga Janaswamy for bug 6007644
1826: okl_stream_generator_pvt.get_sel_date(
1827: p_start_date => p_start_date,
1828: p_advance_or_arrears => 'Y',
1829: p_periods_after => i,
1830: p_months_per_period => l_months_factor,

Line 2653: okl_stream_generator_pvt.add_months_new(

2649: IF p_day_count_method <> 'THIRTY'
2650: THEN
2651: -- Calculating the cf_dpp for the residual values
2652: l_period_end_date := l_residuals_tbl(res_index).cf_date;
2653: okl_stream_generator_pvt.add_months_new(
2654: p_start_date => l_period_end_date,
2655: p_months_after => -12 / l_residuals_tbl(res_index).cf_ppy, -- Will get the frequency for us
2656: x_date => l_period_start_date,
2657: x_return_status => l_return_status);

Line 5315: okl_stream_generator_pvt.add_months_new(

5311: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
5312: 'Advance/Arrears Flag for Rents Considered: ' || l_is_arrears );
5313: -- Fetch the end date
5314: /*
5315: okl_stream_generator_pvt.add_months_new(
5316: p_start_date => l_start_date,
5317: p_months_after => p_term,
5318: x_date => l_k_end_date,
5319: x_return_status => l_return_status);

Line 6224: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

6220: -- Store the Item Category details in the PL/SQL table to return back ..
6221: l_item_cat_cf_tbl(i).cash_flow_rec.due_arrears_yn := l_lrs_details.arrears_yn;
6222: l_item_cat_cf_tbl(i).cash_flow_rec.start_date := p_qq_hdr_rec.expected_start_date;
6223: -- Get the Months factor!
6224: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
6225: p_frequency => l_lrs_details.frq_code,
6226: x_return_status => l_return_status);
6227: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
6228: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6244: okl_stream_generator_pvt.add_months_new(

6240: l_item_cat_cf_tbl(i).cash_flow_level_tbl(cf_index).amount := ( l_lrs_levels(t).lease_rate_factor + nvl(l_adj_factor,0) ) * l_asset_fin_amt;
6241: l_item_cat_cf_tbl(i).cash_flow_level_tbl(cf_index).is_stub := 'N';
6242: l_item_cat_cf_tbl(i).cash_flow_level_tbl(cf_index).rate := l_lrs_levels(t).lease_rate_factor;
6243: -- Need to populate the start date per line .. !!
6244: okl_stream_generator_pvt.add_months_new(
6245: p_start_date => p_qq_hdr_rec.expected_start_date,
6246: p_months_after => l_months_after,
6247: x_date => l_item_cat_cf_tbl(i).cash_flow_level_tbl(cf_index).start_date,
6248: x_return_status => l_return_status);

Line 6271: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

6267: -- sales team will populate the LRF in OKL_QUICK_QUOTE_LINES_B.
6268: -- Hence, pricing can just fetch the LRF in OKL_QUICK_QUOTE_LINES_B and
6269: -- then build the cash flows from that ..
6270: -- Get the Months factor!
6271: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
6272: p_frequency => p_qq_hdr_rec.target_frequency,
6273: x_return_status => l_return_status);
6274: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
6275: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6555: l_months_factor := okl_stream_generator_pvt.get_months_factor(

6551: l_cash_flow_det_tbl(1).fqy_code := p_qq_hdr_rec.target_frequency;
6552: l_cash_flow_det_tbl(1).rate := p_qq_hdr_rec.target_rate; -- Rate is being stored as Percentage
6553: l_cash_flow_det_tbl(1).is_stub := 'N';
6554: l_cash_flow_det_tbl(1).start_date := p_qq_hdr_rec.expected_start_date;
6555: l_months_factor := okl_stream_generator_pvt.get_months_factor(
6556: p_frequency => p_qq_hdr_rec.target_frequency,
6557: x_return_status => x_return_status);
6558: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
6559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6938: l_months_factor := okl_stream_generator_pvt.get_months_factor(

6934: l_cash_flow_det_tbl(1).is_stub := 'N';
6935: l_cash_flow_det_tbl(1).start_date := quote_rec.expected_start_date;
6936: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6937: 'GET_LQ p_frequency_passed' || l_srt_details.frequency_code);
6938: l_months_factor := okl_stream_generator_pvt.get_months_factor(
6939: p_frequency => l_srt_details.frequency_code,
6940: x_return_status => l_return_status);
6941: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6942: 'p_months_factor'||l_months_factor);

Line 7531: okl_stream_generator_pvt.add_months_new(

7527: -- Build the Residuals Table
7528: IF l_item_cat_tbl IS NOT NULL AND
7529: l_item_cat_tbl.COUNT > 0
7530: THEN
7531: okl_stream_generator_pvt.add_months_new(
7532: p_start_date => l_hdr_rec.expected_start_date,
7533: p_months_after => l_hdr_rec.term,
7534: x_date => l_eot_date,
7535: x_return_status => l_return_status);

Line 9211: okl_stream_generator_pvt.add_months_new(

9207: l_pricing_method := quote_rec.pricing_method;
9208: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9209: 'Fetched the Lease Quote Details ' || p_qte_id);
9210: -- Derieve the End of Term Date of the Lease Quote
9211: okl_stream_generator_pvt.add_months_new(
9212: p_start_date => quote_rec.expected_start_date,
9213: p_months_after => quote_rec.term,
9214: x_date => l_eot_date,
9215: x_return_status => l_return_status);

Line 9662: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

9658: END IF;
9659: END IF;
9660: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9661: 'Adjustment Factor ' || l_adj_factor );
9662: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
9663: p_frequency => l_lrs_details.frq_code,
9664: x_return_status => l_return_status);
9665: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 9687: okl_stream_generator_pvt.add_months_new(

9683: ( lx_pricing_parameter_rec.financed_amount - NVL(lx_pricing_parameter_rec.subsidy +
9684: lx_pricing_parameter_rec.down_payment + lx_pricing_parameter_rec.trade_in,0 ) );
9685: l_cash_flow_det_tbl(cf_index).is_stub := 'N';
9686: -- Need to populate the start date per line .. !!
9687: okl_stream_generator_pvt.add_months_new(
9688: p_start_date => quote_rec.expected_start_date,
9689: p_months_after => l_months_after,
9690: x_date => l_cash_flow_det_tbl(cf_index).start_date,
9691: x_return_status => l_return_status);

Line 9711: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

9707: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9708: 'lease rate factor | Frequency | Arrears ' );
9709: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9710: l_lease_rate_factor || ' | ' || l_target_frequency || ' | ' || l_target_arrears_yn );
9711: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
9712: p_frequency => l_target_frequency,
9713: x_return_status => l_return_status);
9714: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9715: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 11895: okl_stream_generator_pvt.add_months_new(

11891: '!!!!!!!!!!!!Pricing of ' || quote_rec.reference_number || '!!!!!!!!!!!! ');
11892: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11893: '!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ');
11894: -- Derieve the End of Term Date of the Lease Quote
11895: okl_stream_generator_pvt.add_months_new(
11896: p_start_date => quote_rec.expected_start_date,
11897: p_months_after => quote_rec.term,
11898: x_date => l_eot_date,
11899: x_return_status => l_return_status);