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 8646: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;

8642: l_overridden BOOLEAN;
8643: tot_oec_percentage NUMBER;
8644: i NUMBER;
8645: lq_level_fin_amt NUMBER;
8646: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;
8647: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8648: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8649: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8650: BEGIN

Line 8647: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;

8643: tot_oec_percentage NUMBER;
8644: i NUMBER;
8645: lq_level_fin_amt NUMBER;
8646: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;
8647: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8648: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8649: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8650: BEGIN
8651: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 8648: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;

8644: i NUMBER;
8645: lq_level_fin_amt NUMBER;
8646: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;
8647: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8648: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8649: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8650: BEGIN
8651: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8652: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

Line 8649: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;

8645: lq_level_fin_amt NUMBER;
8646: l_asset_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_tbl_type;
8647: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
8648: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
8649: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
8650: BEGIN
8651: l_return_status := OKL_API.G_RET_STS_SUCCESS;
8652: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;
8653: is_debug_procedure_on := OKL_DEBUG_PUB.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

Line 8742: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');

8738: 'Updated l_component_tbl(1).unit_cost = ' || l_component_tbl(1).unit_cost );
8739: END LOOP;
8740: -- Call the update api to store back the calculated OEC of the Asset!
8741: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
8742: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
8743: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
8744: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
8745: p_api_version => p_api_version,
8746: p_init_msg_list => p_init_msg_list,

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

8739: END LOOP;
8740: -- Call the update api to store back the calculated OEC of the Asset!
8741: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
8742: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
8743: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
8744: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
8745: p_api_version => p_api_version,
8746: p_init_msg_list => p_init_msg_list,
8747: p_transaction_control => 'T',

Line 8744: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (

8740: -- Call the update api to store back the calculated OEC of the Asset!
8741: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
8742: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
8743: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
8744: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
8745: p_api_version => p_api_version,
8746: p_init_msg_list => p_init_msg_list,
8747: p_transaction_control => 'T',
8748: p_asset_rec => l_asset_tbl(t),

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

8752: x_return_status => l_return_status,
8753: x_msg_count => x_msg_count,
8754: x_msg_data => x_msg_data);
8755: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
8756: 'After OKL_LEASE_QUOTE_ASSET_PVT.update_asset ' || l_return_status );
8757: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8759: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
8760: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 9142: l_ass_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;

9138: l_adj_mat_cat_rec adj_mat_cat_rec;
9139: -- Variables used for storing back the pricing results !
9140: lx_asset_rec okl_ass_pvt.assv_rec_type;
9141: lx_fee_rec okl_fee_pvt.feev_rec_type;
9142: l_ass_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
9143: l_cf_source VARCHAR2(30);
9144: l_fee_yn VARCHAR2(1) := 'N';
9145: l_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
9146: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

Line 9147: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;

9143: l_cf_source VARCHAR2(30);
9144: l_fee_yn VARCHAR2(1) := 'N';
9145: l_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
9146: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
9147: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;
9148: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
9149: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
9150: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
9151: l_cfo_exists VARCHAR2(30);

Line 9148: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;

9144: l_fee_yn VARCHAR2(1) := 'N';
9145: l_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
9146: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
9147: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;
9148: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
9149: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
9150: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
9151: l_cfo_exists VARCHAR2(30);
9152: l_eot_percentage NUMBER;

Line 9149: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;

9145: l_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
9146: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
9147: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;
9148: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
9149: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
9150: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
9151: l_cfo_exists VARCHAR2(30);
9152: l_eot_percentage NUMBER;
9153: l_eot_amount NUMBER;

Line 9150: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;

9146: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
9147: l_asset_rec OKL_LEASE_QUOTE_ASSET_PVT.asset_rec_type;
9148: l_component_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_component_tbl_type;
9149: l_cf_hdr_rec OKL_LEASE_QUOTE_ASSET_PVT.cashflow_hdr_rec_type;
9150: l_cf_level_tbl OKL_LEASE_QUOTE_ASSET_PVT.cashflow_level_tbl_type;
9151: l_cfo_exists VARCHAR2(30);
9152: l_eot_percentage NUMBER;
9153: l_eot_amount NUMBER;
9154: l_rate_card_id NUMBER;

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

10120: THEN
10121: lx_asset_rec.id := p_ast_id;
10122: IF (l_fee_yn = 'N')
10123: THEN
10124: -- Need to change here to call the okl_lease_quote_asset_pvt.update_asset
10125: l_asset_rec.id := p_ast_id;
10126: l_asset_rec.oec := lx_pricing_parameter_rec.financed_amount;
10127: FOR t_rec IN c_asset_comp_csr( p_asset_id => p_ast_id )
10128: LOOP

Line 10137: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');

10133: 'Updated l_component_tbl(1).unit_cost = ' || l_component_tbl(1).unit_cost );
10134: END LOOP;
10135: -- Call the update api to store back the calculated OEC of the Asset!
10136: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
10137: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
10138: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
10139: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
10140: p_api_version => p_api_version,
10141: p_init_msg_list => p_init_msg_list,

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

10134: END LOOP;
10135: -- Call the update api to store back the calculated OEC of the Asset!
10136: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
10137: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
10138: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
10139: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
10140: p_api_version => p_api_version,
10141: p_init_msg_list => p_init_msg_list,
10142: p_transaction_control => 'T',

Line 10139: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (

10135: -- Call the update api to store back the calculated OEC of the Asset!
10136: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
10137: 'Before OKL_LEASE_QUOTE_ASSET_PVT.update_asset ');
10138: -- Instead we need to use the OKL_LEASE_QUOTE_ASSET_PVT.update_asset
10139: OKL_LEASE_QUOTE_ASSET_PVT.update_asset (
10140: p_api_version => p_api_version,
10141: p_init_msg_list => p_init_msg_list,
10142: p_transaction_control => 'T',
10143: p_asset_rec => l_asset_rec,

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

10147: x_return_status => l_return_status,
10148: x_msg_count => x_msg_count,
10149: x_msg_data => x_msg_data);
10150: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
10151: 'After OKL_LEASE_QUOTE_ASSET_PVT.update_asset ' || l_return_status );
10152: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
10153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10154: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
10155: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 10203: okl_lease_quote_asset_pvt.create_adjustment(

10199: p_token3_value => l_asset_number);
10200: --Bug 5121548 dpsingh end
10201: RAISE okl_api.g_exception_error;
10202: END IF;
10203: okl_lease_quote_asset_pvt.create_adjustment(
10204: p_api_version => p_api_version,
10205: p_init_msg_list => p_init_msg_list,
10206: p_transaction_control => FND_API.G_TRUE,
10207: p_asset_adj_tbl => l_ass_adj_tbl,

Line 11759: l_ass_adj_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_adjustment_tbl_type;

11755: l_lq_pp_noa_dts OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11756: l_lq_pp_noa OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11757: l_iir_temp NUMBER;
11758: l_adj_mat_cat_rec adj_mat_cat_rec;
11759: l_ass_adj_tbl OKL_LEASE_QUOTE_ASSET_PVT.asset_adjustment_tbl_type;
11760: l_cash_flow_rec so_cash_flows_rec_type;
11761: l_cash_flow_det_tbl so_cash_flow_details_tbl_type;
11762: l_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
11763: l_lease_qte_rec OKL_LEASE_QUOTE_PVT.lease_qte_rec_type;

Line 13599: okl_lease_quote_asset_pvt.create_adjustment(

13595: round( l_noa_pp_tbl(t_index).down_payment , 4 ) || ' | ' ||
13596: round( l_noa_pp_tbl(t_index).subsidy , 4 ) || ' | ' ||
13597: round( l_noa_pp_tbl(t_index).trade_in , 4 ) );
13598: -- Create/Update the Solved Financial Adjustment
13599: okl_lease_quote_asset_pvt.create_adjustment(
13600: p_api_version => p_api_version,
13601: p_init_msg_list => p_init_msg_list,
13602: p_transaction_control => FND_API.G_TRUE,
13603: p_asset_adj_tbl => l_ass_adj_tbl,