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 2631: okl_stream_generator_pvt.add_months_new(

2627: IF p_day_count_method <> 'THIRTY'
2628: THEN
2629: -- Calculating the cf_dpp for the residual values
2630: l_period_end_date := l_residuals_tbl(res_index).cf_date;
2631: okl_stream_generator_pvt.add_months_new(
2632: p_start_date => l_period_end_date,
2633: p_months_after => -12 / l_residuals_tbl(res_index).cf_ppy, -- Will get the frequency for us
2634: x_date => l_period_start_date,
2635: x_return_status => l_return_status);

Line 5256: okl_stream_generator_pvt.add_months_new(

5252: l_bk_yield := nvl( p_initial_guess, 0.1 );
5253: l_increment := 0.1;
5254: l_is_arrears := l_cf_inflows(1).is_arrears;
5255: -- Fetch the end date
5256: okl_stream_generator_pvt.add_months_new(
5257: p_start_date => l_start_date,
5258: p_months_after => p_term,
5259: x_date => l_k_end_date,
5260: x_return_status => l_return_status);

Line 5891: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

5887: -- Store the Item Category details in the PL/SQL table to return back ..
5888: l_item_cat_cf_tbl(i).cash_flow_rec.due_arrears_yn := l_lrs_details.arrears_yn;
5889: l_item_cat_cf_tbl(i).cash_flow_rec.start_date := p_qq_hdr_rec.expected_start_date;
5890: -- Get the Months factor!
5891: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
5892: p_frequency => l_lrs_details.frq_code,
5893: x_return_status => l_return_status);
5894: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5895: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5911: okl_stream_generator_pvt.add_months_new(

5907: 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;
5908: l_item_cat_cf_tbl(i).cash_flow_level_tbl(cf_index).is_stub := 'N';
5909: l_item_cat_cf_tbl(i).cash_flow_level_tbl(cf_index).rate := l_lrs_levels(t).lease_rate_factor;
5910: -- Need to populate the start date per line .. !!
5911: okl_stream_generator_pvt.add_months_new(
5912: p_start_date => p_qq_hdr_rec.expected_start_date,
5913: p_months_after => l_months_after,
5914: x_date => l_item_cat_cf_tbl(i).cash_flow_level_tbl(cf_index).start_date,
5915: x_return_status => l_return_status);

Line 5938: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

5934: -- sales team will populate the LRF in OKL_QUICK_QUOTE_LINES_B.
5935: -- Hence, pricing can just fetch the LRF in OKL_QUICK_QUOTE_LINES_B and
5936: -- then build the cash flows from that ..
5937: -- Get the Months factor!
5938: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
5939: p_frequency => p_qq_hdr_rec.target_frequency,
5940: x_return_status => l_return_status);
5941: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5942: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6222: l_months_factor := okl_stream_generator_pvt.get_months_factor(

6218: l_cash_flow_det_tbl(1).fqy_code := p_qq_hdr_rec.target_frequency;
6219: l_cash_flow_det_tbl(1).rate := p_qq_hdr_rec.target_rate; -- Rate is being stored as Percentage
6220: l_cash_flow_det_tbl(1).is_stub := 'N';
6221: l_cash_flow_det_tbl(1).start_date := p_qq_hdr_rec.expected_start_date;
6222: l_months_factor := okl_stream_generator_pvt.get_months_factor(
6223: p_frequency => p_qq_hdr_rec.target_frequency,
6224: x_return_status => x_return_status);
6225: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
6226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6605: l_months_factor := okl_stream_generator_pvt.get_months_factor(

6601: l_cash_flow_det_tbl(1).is_stub := 'N';
6602: l_cash_flow_det_tbl(1).start_date := quote_rec.expected_start_date;
6603: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6604: 'GET_LQ p_frequency_passed' || l_srt_details.frequency_code);
6605: l_months_factor := okl_stream_generator_pvt.get_months_factor(
6606: p_frequency => l_srt_details.frequency_code,
6607: x_return_status => l_return_status);
6608: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6609: 'p_months_factor'||l_months_factor);

Line 7197: okl_stream_generator_pvt.add_months_new(

7193: -- Build the Residuals Table
7194: IF l_item_cat_tbl IS NOT NULL AND
7195: l_item_cat_tbl.COUNT > 0
7196: THEN
7197: okl_stream_generator_pvt.add_months_new(
7198: p_start_date => l_hdr_rec.expected_start_date,
7199: p_months_after => l_hdr_rec.term,
7200: x_date => l_eot_date,
7201: x_return_status => l_return_status);

Line 8871: okl_stream_generator_pvt.add_months_new(

8867: l_pricing_method := quote_rec.pricing_method;
8868: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
8869: 'Fetched the Lease Quote Details ' || p_qte_id);
8870: -- Derieve the End of Term Date of the Lease Quote
8871: okl_stream_generator_pvt.add_months_new(
8872: p_start_date => quote_rec.expected_start_date,
8873: p_months_after => quote_rec.term,
8874: x_date => l_eot_date,
8875: x_return_status => l_return_status);

Line 9322: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

9318: END IF;
9319: END IF;
9320: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9321: 'Adjustment Factor ' || l_adj_factor );
9322: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
9323: p_frequency => l_lrs_details.frq_code,
9324: x_return_status => l_return_status);
9325: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 9347: okl_stream_generator_pvt.add_months_new(

9343: ( lx_pricing_parameter_rec.financed_amount - NVL(lx_pricing_parameter_rec.subsidy +
9344: lx_pricing_parameter_rec.down_payment + lx_pricing_parameter_rec.trade_in,0 ) );
9345: l_cash_flow_det_tbl(cf_index).is_stub := 'N';
9346: -- Need to populate the start date per line .. !!
9347: okl_stream_generator_pvt.add_months_new(
9348: p_start_date => quote_rec.expected_start_date,
9349: p_months_after => l_months_after,
9350: x_date => l_cash_flow_det_tbl(cf_index).start_date,
9351: x_return_status => l_return_status);

Line 9371: l_months_per_period := okl_stream_generator_pvt.get_months_factor(

9367: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9368: 'lease rate factor | Frequency | Arrears ' );
9369: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9370: l_lease_rate_factor || ' | ' || l_target_frequency || ' | ' || l_target_arrears_yn );
9371: l_months_per_period := okl_stream_generator_pvt.get_months_factor(
9372: p_frequency => l_target_frequency,
9373: x_return_status => l_return_status);
9374: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 10852: okl_stream_generator_pvt.add_months_new(

10848: '!!!!!!!!!!!!Pricing of ' || quote_rec.reference_number || '!!!!!!!!!!!! ');
10849: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
10850: '!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ');
10851: -- Derieve the End of Term Date of the Lease Quote
10852: okl_stream_generator_pvt.add_months_new(
10853: p_start_date => quote_rec.expected_start_date,
10854: p_months_after => quote_rec.term,
10855: x_date => l_eot_date,
10856: x_return_status => l_return_status);