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_LEASE_QUOTE_ASSET_PVT

Line 8312: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;

8308: l_overridden BOOLEAN;
8309: tot_oec_percentage NUMBER;
8310: i NUMBER;
8311: lq_level_fin_amt NUMBER;
8312: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;
8313: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8314: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8315: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8316: BEGIN

Line 8313: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;

8309: tot_oec_percentage NUMBER;
8310: i NUMBER;
8311: lq_level_fin_amt NUMBER;
8312: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;
8313: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8314: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8315: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8316: BEGIN
8317: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 8314: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;

8310: i NUMBER;
8311: lq_level_fin_amt NUMBER;
8312: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;
8313: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8314: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8315: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8316: BEGIN
8317: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8318: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

Line 8315: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;

8311: lq_level_fin_amt NUMBER;
8312: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;
8313: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8314: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8315: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8316: BEGIN
8317: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8318: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
8319: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

Line 8408: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');

8404: 'Updated l_component_tbl(1).unit_cost = ' || l_component_tbl(1).unit_cost );
8405: END LOOP;
8406: -- Call the update api to store back the calculated OEC of the Asset!
8407: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
8408: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
8409: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
8410: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
8411: p_api_version => p_api_version,
8412: p_init_msg_list => p_init_msg_list,

Line 8409: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset

8405: END LOOP;
8406: -- Call the update api to store back the calculated OEC of the Asset!
8407: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
8408: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
8409: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
8410: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
8411: p_api_version => p_api_version,
8412: p_init_msg_list => p_init_msg_list,
8413: p_transaction_control => 'T',

Line 8410: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (

8406: -- Call the update api to store back the calculated OEC of the Asset!
8407: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
8408: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
8409: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
8410: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
8411: p_api_version => p_api_version,
8412: p_init_msg_list => p_init_msg_list,
8413: p_transaction_control => 'T',
8414: p_asset_rec => l_asset_tbl(t),

Line 8422: 'After OKL_LEASE_QUOTE_ASSET_PVT.update_asset ' || l_return_status );

8418: x_return_status => l_return_status,
8419: x_msg_count => x_msg_count,
8420: x_msg_data => x_msg_data);
8421: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8422: 'After OKL_LEASE_QUOTE_ASSET_PVT.update_asset ' || l_return_status );
8423: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8424: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8425: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
8426: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 8802: l_ass_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;

8798: l_adj_mat_cat_rec adj_mat_cat_rec;
8799: -- Variables used for storing back the pricing results !
8800: lx_asset_rec okl_ass_pvt.assv_rec_type;
8801: lx_fee_rec okl_fee_pvt.feev_rec_type;
8802: l_ass_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
8803: l_cf_source VARCHAR2(30);
8804: l_fee_yn VARCHAR2(1) := 'N';
8805: l_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
8806: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

Line 8807: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;

8803: l_cf_source VARCHAR2(30);
8804: l_fee_yn VARCHAR2(1) := 'N';
8805: l_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
8806: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
8807: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;
8808: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8809: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8810: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8811: l_cfo_exists VARCHAR2(30);

Line 8808: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;

8804: l_fee_yn VARCHAR2(1) := 'N';
8805: l_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
8806: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
8807: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;
8808: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8809: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8810: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8811: l_cfo_exists VARCHAR2(30);
8812: l_eot_percentage NUMBER;

Line 8809: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;

8805: l_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
8806: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
8807: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;
8808: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8809: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8810: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8811: l_cfo_exists VARCHAR2(30);
8812: l_eot_percentage NUMBER;
8813: l_eot_amount NUMBER;

Line 8810: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;

8806: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
8807: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;
8808: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8809: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8810: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8811: l_cfo_exists VARCHAR2(30);
8812: l_eot_percentage NUMBER;
8813: l_eot_amount NUMBER;
8814: l_rate_card_id NUMBER;

Line 9778: -- Need to change here to call the okl_lease_quote_asset_pvt.update_asset

9774: THEN
9775: lx_asset_rec.id := p_ast_id;
9776: IF (l_fee_yn = 'N')
9777: THEN
9778: -- Need to change here to call the okl_lease_quote_asset_pvt.update_asset
9779: l_asset_rec.id := p_ast_id;
9780: l_asset_rec.oec := lx_pricing_parameter_rec.financed_amount;
9781: FOR t_rec IN c_asset_comp_csr( p_asset_id => p_ast_id )
9782: LOOP

Line 9791: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');

9787: 'Updated l_component_tbl(1).unit_cost = ' || l_component_tbl(1).unit_cost );
9788: END LOOP;
9789: -- Call the update api to store back the calculated OEC of the Asset!
9790: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9791: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
9792: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
9793: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
9794: p_api_version => p_api_version,
9795: p_init_msg_list => p_init_msg_list,

Line 9792: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset

9788: END LOOP;
9789: -- Call the update api to store back the calculated OEC of the Asset!
9790: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9791: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
9792: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
9793: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
9794: p_api_version => p_api_version,
9795: p_init_msg_list => p_init_msg_list,
9796: p_transaction_control => 'T',

Line 9793: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (

9789: -- Call the update api to store back the calculated OEC of the Asset!
9790: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9791: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
9792: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
9793: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
9794: p_api_version => p_api_version,
9795: p_init_msg_list => p_init_msg_list,
9796: p_transaction_control => 'T',
9797: p_asset_rec => l_asset_rec,

Line 9805: 'After OKL_LEASE_QUOTE_ASSET_PVT.update_asset ' || l_return_status );

9801: x_return_status => l_return_status,
9802: x_msg_count => x_msg_count,
9803: x_msg_data => x_msg_data);
9804: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9805: 'After OKL_LEASE_QUOTE_ASSET_PVT.update_asset ' || l_return_status );
9806: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9808: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
9809: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 9857: okl_lease_quote_asset_pvt.create_adjustment(

9853: p_token3_value => l_asset_number);
9854: --Bug 5121548 dpsingh end
9855: RAISE okl_api.g_exception_error;
9856: END IF;
9857: okl_lease_quote_asset_pvt.create_adjustment(
9858: p_api_version => p_api_version,
9859: p_init_msg_list => p_init_msg_list,
9860: p_transaction_control => FND_API.G_TRUE,
9861: p_asset_adj_tbl => l_ass_adj_tbl,

Line 10765: l_ass_adj_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_adjustment_tbl_type;

10761: l_lq_pp_noa_dts OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10762: l_lq_pp_noa OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10763: l_iir_temp NUMBER;
10764: l_adj_mat_cat_rec adj_mat_cat_rec;
10765: l_ass_adj_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_adjustment_tbl_type;
10766: l_cash_flow_rec so_cash_flows_rec_type;
10767: l_cash_flow_det_tbl so_cash_flow_details_tbl_type;
10768: l_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
10769: l_lease_qte_rec OKL_LEASE_QUOTE_PVT.lease_qte_rec_type;

Line 12473: okl_lease_quote_asset_pvt.create_adjustment(

12469: round( l_noa_pp_tbl(t_index).down_payment , 4 ) || ' | ' ||
12470: round( l_noa_pp_tbl(t_index).subsidy , 4 ) || ' | ' ||
12471: round( l_noa_pp_tbl(t_index).trade_in , 4 ) );
12472: -- Create/Update the Solved Financial Adjustment
12473: okl_lease_quote_asset_pvt.create_adjustment(
12474: p_api_version => p_api_version,
12475: p_init_msg_list => p_init_msg_list,
12476: p_transaction_control => FND_API.G_TRUE,
12477: p_asset_adj_tbl => l_ass_adj_tbl,