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_PRICING_UTILS_PVT

Line 1: PACKAGE BODY OKL_PRICING_UTILS_PVT AS

1: PACKAGE BODY OKL_PRICING_UTILS_PVT AS
2: /* $Header: OKLRPIUB.pls 120.75 2008/05/16 11:26:32 rgooty noship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 280: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.get_so_hdr';

276: -- Local Variables
277: l_api_version CONSTANT NUMBER DEFAULT 1.0;
278: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_so_hdr';
279: l_return_status VARCHAR2(1);
280: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.get_so_hdr';
281: l_debug_enabled VARCHAR2(10);
282: is_debug_procedure_on BOOLEAN;
283: is_debug_statement_on BOOLEAN;
284: BEGIN

Line 771: := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.get_qq_fin_adjustments';

767: l_api_version CONSTANT NUMBER DEFAULT 1.0;
768: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_qq_fin_adj_details';
769: l_return_status VARCHAR2(1);
770: l_module CONSTANT fnd_log_messages.module%TYPE
771: := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.get_qq_fin_adjustments';
772: l_debug_enabled VARCHAR2(10);
773: is_debug_procedure_on BOOLEAN;
774: is_debug_statement_on BOOLEAN;
775:

Line 1732: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.gen_so_cf_strm_elements';

1728: -- Local Variables
1729: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1730: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'gen_so_cf_strm_elements';
1731: l_return_status VARCHAR2(1);
1732: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.gen_so_cf_strm_elements';
1733: l_debug_enabled VARCHAR2(10);
1734: is_debug_procedure_on BOOLEAN;
1735: is_debug_statement_on BOOLEAN;
1736: l_period_start_date DATE;

Line 1894: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.GEN_SO_CF_STRMS';

1890: l_temp_cf_strms_tbl cash_inflows_tbl_type;
1891: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1892: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'gen_so_cf_strms';
1893: l_return_status VARCHAR2(1);
1894: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.GEN_SO_CF_STRMS';
1895: l_debug_enabled VARCHAR2(10);
1896: is_debug_procedure_on BOOLEAN;
1897: is_debug_statement_on BOOLEAN;
1898: -- Local Variables

Line 8266: 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.distribute_fin_amount_lq';

8262: l_api_version CONSTANT NUMBER DEFAULT 1.0;
8263: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'distribute_fin_amount_lq';
8264: l_return_status VARCHAR2(1);
8265: l_module CONSTANT fnd_log_messages.module%TYPE :=
8266: 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.distribute_fin_amount_lq';
8267: l_debug_enabled VARCHAR2(10);
8268: is_debug_procedure_on BOOLEAN;
8269: is_debug_statement_on BOOLEAN;
8270: -- Cursor to fetch the Lease Quote Header details

Line 8780: l_srt_details okl_pricing_utils_pvt.srt_details_rec_type;

8776: l_day_count_method VARCHAR2(30);
8777: l_days_in_month VARCHAR2(30);
8778: l_days_in_year VARCHAR2(30);
8779: l_currency VARCHAR2(30);
8780: l_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
8781: l_ast_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
8782: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
8783: x_iir NUMBER;
8784: l_initial_guess NUMBER := 0.1;

Line 8781: l_ast_srt_details okl_pricing_utils_pvt.srt_details_rec_type;

8777: l_days_in_month VARCHAR2(30);
8778: l_days_in_year VARCHAR2(30);
8779: l_currency VARCHAR2(30);
8780: l_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
8781: l_ast_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
8782: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
8783: x_iir NUMBER;
8784: l_initial_guess NUMBER := 0.1;
8785: x_payment NUMBER;

Line 8782: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;

8778: l_days_in_year VARCHAR2(30);
8779: l_currency VARCHAR2(30);
8780: l_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
8781: l_ast_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
8782: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
8783: x_iir NUMBER;
8784: l_initial_guess NUMBER := 0.1;
8785: x_payment NUMBER;
8786: -- Cash flow and Cash flow level variables

Line 8789: l_cash_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;

8785: x_payment NUMBER;
8786: -- Cash flow and Cash flow level variables
8787: l_cash_flow_rec so_cash_flows_rec_type;
8788: l_cash_flow_det_tbl so_cash_flow_details_tbl_type;
8789: l_cash_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
8790: l_residual_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
8791: cfl_index BINARY_INTEGER;
8792: res_index BINARY_INTEGER;
8793: l_eot_date DATE; -- Effective To of the quote

Line 8790: l_residual_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;

8786: -- Cash flow and Cash flow level variables
8787: l_cash_flow_rec so_cash_flows_rec_type;
8788: l_cash_flow_det_tbl so_cash_flow_details_tbl_type;
8789: l_cash_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
8790: l_residual_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
8791: cfl_index BINARY_INTEGER;
8792: res_index BINARY_INTEGER;
8793: l_eot_date DATE; -- Effective To of the quote
8794: l_cf_dpp NUMBER;

Line 10730: l_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;

10726: l_day_count_method VARCHAR2(30);
10727: l_days_in_month VARCHAR2(30);
10728: l_days_in_year VARCHAR2(30);
10729: l_currency VARCHAR2(30);
10730: l_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
10731: l_ast_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
10732: x_iir NUMBER;
10733: l_initial_guess NUMBER := 0.1;
10734: x_payment NUMBER;

Line 10731: l_ast_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;

10727: l_days_in_month VARCHAR2(30);
10728: l_days_in_year VARCHAR2(30);
10729: l_currency VARCHAR2(30);
10730: l_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
10731: l_ast_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
10732: x_iir NUMBER;
10733: l_initial_guess NUMBER := 0.1;
10734: x_payment NUMBER;
10735: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object

Line 10735: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object

10731: l_ast_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
10732: x_iir NUMBER;
10733: l_initial_guess NUMBER := 0.1;
10734: x_payment NUMBER;
10735: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
10736: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
10737: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
10738: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

Line 10736: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels

10732: x_iir NUMBER;
10733: l_initial_guess NUMBER := 0.1;
10734: x_payment NUMBER;
10735: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
10736: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
10737: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
10738: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

Line 10737: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams

10733: l_initial_guess NUMBER := 0.1;
10734: x_payment NUMBER;
10735: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
10736: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
10737: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
10738: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10741: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

Line 10738: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

10734: x_payment NUMBER;
10735: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
10736: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
10737: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
10738: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10741: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10742: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

Line 10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

10735: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
10736: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
10737: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
10738: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10741: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10742: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10743: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

Line 10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

10736: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
10737: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
10738: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10741: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10742: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10743: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10744: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;

Line 10741: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

10737: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
10738: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10741: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10742: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10743: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10744: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
10745: l_overridden BOOLEAN;

Line 10742: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

10738: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10741: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10742: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10743: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10744: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
10745: l_overridden BOOLEAN;
10746: l_non_overiding_assets_tbl OKL_STREAMS_UTIL.NumberTabTyp;

Line 10743: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

10739: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10741: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10742: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10743: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10744: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
10745: l_overridden BOOLEAN;
10746: l_non_overiding_assets_tbl OKL_STREAMS_UTIL.NumberTabTyp;
10747: l_noa_pp_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

Line 10744: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;

10740: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10741: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10742: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10743: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10744: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
10745: l_overridden BOOLEAN;
10746: l_non_overiding_assets_tbl OKL_STREAMS_UTIL.NumberTabTyp;
10747: l_noa_pp_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10748: lnoa_index BINARY_INTEGER;

Line 10747: l_noa_pp_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

10743: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10744: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
10745: l_overridden BOOLEAN;
10746: l_non_overiding_assets_tbl OKL_STREAMS_UTIL.NumberTabTyp;
10747: l_noa_pp_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
10748: lnoa_index BINARY_INTEGER;
10749: ppfs_index BINARY_INTEGER;
10750: l_eot_date DATE;
10751: l_cf_dpp NUMBER;

Line 10761: l_lq_pp_noa_dts OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

10757: l_iir_noa_dts NUMBER; -- IIR @ LQ level for Non-overriding assets considering
10758: -- Downpayment/Subsidy/Trade-In
10759: l_iir_noa NUMBER; -- IIR @ LQ level for Non-overriding assets with out
10760: -- considering Downpayment/Subsidy/Trade-In
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;

Line 10762: l_lq_pp_noa OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

10758: -- Downpayment/Subsidy/Trade-In
10759: l_iir_noa NUMBER; -- IIR @ LQ level for Non-overriding assets with out
10760: -- considering Downpayment/Subsidy/Trade-In
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;

Line 10768: l_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;

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;
10770: x_lease_qte_rec OKL_LEASE_QUOTE_PVT.lease_qte_rec_type;
10771: l_lq_payment_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
10772: l_lq_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

Line 10776: l_noa_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type;

10772: l_lq_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10773: l_cfo_exists_at_lq VARCHAR2(30);
10774: l_cfo_exists_at_noa VARCHAR2(30);
10775: l_tot_noa_oec NUMBER;
10776: l_noa_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type;
10777: l_noa_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type;
10778: l_noa_payment_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
10779: l_noa_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10780: l_fee_outflow_caf_rec so_cash_flows_rec_type;

Line 10777: l_noa_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type;

10773: l_cfo_exists_at_lq VARCHAR2(30);
10774: l_cfo_exists_at_noa VARCHAR2(30);
10775: l_tot_noa_oec NUMBER;
10776: l_noa_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type;
10777: l_noa_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type;
10778: l_noa_payment_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
10779: l_noa_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10780: l_fee_outflow_caf_rec so_cash_flows_rec_type;
10781: l_fee_outflow_cfl_tbl so_cash_flow_details_tbl_type;

Line 10788: l_lq_details_prc_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

10784: l_adj_type VARCHAR2(30);
10785: l_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
10786: l_sp_for_assets BOOLEAN;
10787: l_an_ass_follow_lq BOOLEAN;
10788: l_lq_details_prc_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
10789: l_rent_sty_id OKL_STRM_TYPE_B.ID%TYPE;
10790: l_asset_caf_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
10791: l_asset_cfl_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10792: l_ast_level_fin_amt NUMBER;

Line 14539: END OKL_PRICING_UTILS_PVT;

14535: x_msg_count => x_msg_count,
14536: x_msg_data => x_msg_data,
14537: p_api_type => g_api_type);
14538: END price_standard_quote;
14539: END OKL_PRICING_UTILS_PVT;