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.80.12020000.5 2012/11/24 04:22:54 rpillay ship $ */
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 8600: 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.distribute_fin_amount_lq';

8596: l_api_version CONSTANT NUMBER DEFAULT 1.0;
8597: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'distribute_fin_amount_lq';
8598: l_return_status VARCHAR2(1);
8599: l_module CONSTANT fnd_log_messages.module%TYPE :=
8600: 'LEASE.ACCOUNTING.PRICING.OKL_PRICING_UTILS_PVT.distribute_fin_amount_lq';
8601: l_debug_enabled VARCHAR2(10);
8602: is_debug_procedure_on BOOLEAN;
8603: is_debug_statement_on BOOLEAN;
8604: -- Cursor to fetch the Lease Quote Header details

Line 9120: l_srt_details okl_pricing_utils_pvt.srt_details_rec_type;

9116: l_day_count_method VARCHAR2(30);
9117: l_days_in_month VARCHAR2(30);
9118: l_days_in_year VARCHAR2(30);
9119: l_currency VARCHAR2(30);
9120: l_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
9121: l_ast_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
9122: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
9123: x_iir NUMBER;
9124: l_initial_guess NUMBER := 0.1;

Line 9121: l_ast_srt_details okl_pricing_utils_pvt.srt_details_rec_type;

9117: l_days_in_month VARCHAR2(30);
9118: l_days_in_year VARCHAR2(30);
9119: l_currency VARCHAR2(30);
9120: l_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
9121: l_ast_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
9122: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
9123: x_iir NUMBER;
9124: l_initial_guess NUMBER := 0.1;
9125: x_payment NUMBER;

Line 9122: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;

9118: l_days_in_year VARCHAR2(30);
9119: l_currency VARCHAR2(30);
9120: l_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
9121: l_ast_srt_details okl_pricing_utils_pvt.srt_details_rec_type;
9122: lx_pricing_parameter_rec okl_pricing_utils_pvt.pricing_parameter_rec_type;
9123: x_iir NUMBER;
9124: l_initial_guess NUMBER := 0.1;
9125: x_payment NUMBER;
9126: -- Cash flow and Cash flow level variables

Line 9129: l_cash_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;

9125: x_payment NUMBER;
9126: -- Cash flow and Cash flow level variables
9127: l_cash_flow_rec so_cash_flows_rec_type;
9128: l_cash_flow_det_tbl so_cash_flow_details_tbl_type;
9129: l_cash_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
9130: l_residual_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
9131: cfl_index BINARY_INTEGER;
9132: res_index BINARY_INTEGER;
9133: l_eot_date DATE; -- Effective To of the quote

Line 9130: l_residual_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;

9126: -- Cash flow and Cash flow level variables
9127: l_cash_flow_rec so_cash_flows_rec_type;
9128: l_cash_flow_det_tbl so_cash_flow_details_tbl_type;
9129: l_cash_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
9130: l_residual_inflows okl_pricing_utils_pvt.cash_inflows_tbl_type;
9131: cfl_index BINARY_INTEGER;
9132: res_index BINARY_INTEGER;
9133: l_eot_date DATE; -- Effective To of the quote
9134: l_cf_dpp NUMBER;

Line 11158: p_pricing_param_tbl IN OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type

11154: x_msg_data OUT NOCOPY VARCHAR2,
11155: p_quote_id IN NUMBER,
11156: p_quote_type IN VARCHAR2,
11157: p_currency IN VARCHAR2,
11158: p_pricing_param_tbl IN OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type
11159: ) IS
11160:
11161: l_return_status VARCHAR2(1):= G_RET_STS_SUCCESS;
11162: l_sty_id OKL_STRM_TYPE_B.ID%TYPE;

Line 11164: l_pricing_param_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

11160:
11161: l_return_status VARCHAR2(1):= G_RET_STS_SUCCESS;
11162: l_sty_id OKL_STRM_TYPE_B.ID%TYPE;
11163: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'insert_quote_streams';
11164: l_pricing_param_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11165: l_stm_id NUMBER;
11166: l_sel_id NUMBER;
11167: l_residual_sty_id OKL_STRM_TYPE_B.ID%TYPE;
11168: l_residual_count NUMBER;

Line 11724: l_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;

11720: l_day_count_method VARCHAR2(30);
11721: l_days_in_month VARCHAR2(30);
11722: l_days_in_year VARCHAR2(30);
11723: l_currency VARCHAR2(30);
11724: l_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
11725: l_ast_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
11726: x_iir NUMBER;
11727: l_initial_guess NUMBER := 0.1;
11728: x_payment NUMBER;

Line 11725: l_ast_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;

11721: l_days_in_month VARCHAR2(30);
11722: l_days_in_year VARCHAR2(30);
11723: l_currency VARCHAR2(30);
11724: l_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
11725: l_ast_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
11726: x_iir NUMBER;
11727: l_initial_guess NUMBER := 0.1;
11728: x_payment NUMBER;
11729: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object

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

11725: l_ast_srt_details OKL_PRICING_UTILS_PVT.srt_details_rec_type;
11726: x_iir NUMBER;
11727: l_initial_guess NUMBER := 0.1;
11728: x_payment NUMBER;
11729: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
11730: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
11731: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
11732: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

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

11726: x_iir NUMBER;
11727: l_initial_guess NUMBER := 0.1;
11728: x_payment NUMBER;
11729: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
11730: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
11731: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
11732: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

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

11727: l_initial_guess NUMBER := 0.1;
11728: x_payment NUMBER;
11729: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
11730: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
11731: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
11732: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11735: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

Line 11732: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

11728: x_payment NUMBER;
11729: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
11730: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
11731: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
11732: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11735: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11736: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

Line 11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

11729: l_lq_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type; -- Quote Level Cash Flow Object
11730: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
11731: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
11732: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11735: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11736: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11737: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

Line 11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

11730: l_lq_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type; -- Quote Level Cash Flow levels
11731: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
11732: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11735: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11736: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11737: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11738: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;

Line 11735: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

11731: l_lq_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type; -- Lease Quote level Streams
11732: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11735: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11736: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11737: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11738: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
11739: l_overridden BOOLEAN;

Line 11736: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

11732: l_lq_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11735: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11736: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11737: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11738: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
11739: l_overridden BOOLEAN;
11740: l_non_overiding_assets_tbl OKL_STREAMS_UTIL.NumberTabTyp;

Line 11737: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

11733: l_tmp_pricing_parameter_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11735: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11736: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11737: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11738: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
11739: l_overridden BOOLEAN;
11740: l_non_overiding_assets_tbl OKL_STREAMS_UTIL.NumberTabTyp;
11741: l_noa_pp_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

Line 11738: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;

11734: l_pricing_parameter_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11735: l_pp_non_sub_iir_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11736: l_pp_non_sub_irr_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11737: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11738: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
11739: l_overridden BOOLEAN;
11740: l_non_overiding_assets_tbl OKL_STREAMS_UTIL.NumberTabTyp;
11741: l_noa_pp_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11742: lnoa_index BINARY_INTEGER;

Line 11741: l_noa_pp_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;

11737: l_pp_lq_fee_srv_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11738: l_lq_residual_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;
11739: l_overridden BOOLEAN;
11740: l_non_overiding_assets_tbl OKL_STREAMS_UTIL.NumberTabTyp;
11741: l_noa_pp_tbl OKL_PRICING_UTILS_PVT.pricing_parameter_tbl_type;
11742: lnoa_index BINARY_INTEGER;
11743: ppfs_index BINARY_INTEGER;
11744: l_eot_date DATE;
11745: l_cf_dpp NUMBER;

Line 11755: l_lq_pp_noa_dts OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

11751: l_iir_noa_dts NUMBER; -- IIR @ LQ level for Non-overriding assets considering
11752: -- Downpayment/Subsidy/Trade-In
11753: l_iir_noa NUMBER; -- IIR @ LQ level for Non-overriding assets with out
11754: -- considering Downpayment/Subsidy/Trade-In
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;

Line 11756: l_lq_pp_noa OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

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

Line 11762: l_cash_inflows OKL_PRICING_UTILS_PVT.cash_inflows_tbl_type;

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;
11764: x_lease_qte_rec OKL_LEASE_QUOTE_PVT.lease_qte_rec_type;
11765: l_lq_payment_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
11766: l_lq_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

Line 11770: l_noa_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type;

11766: l_lq_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
11767: l_cfo_exists_at_lq VARCHAR2(30);
11768: l_cfo_exists_at_noa VARCHAR2(30);
11769: l_tot_noa_oec NUMBER;
11770: l_noa_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type;
11771: l_noa_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type;
11772: l_noa_payment_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
11773: l_noa_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
11774: l_fee_outflow_caf_rec so_cash_flows_rec_type;

Line 11771: l_noa_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type;

11767: l_cfo_exists_at_lq VARCHAR2(30);
11768: l_cfo_exists_at_noa VARCHAR2(30);
11769: l_tot_noa_oec NUMBER;
11770: l_noa_cash_flow_rec OKL_PRICING_UTILS_PVT.so_cash_flows_rec_type;
11771: l_noa_cash_flow_det_tbl OKL_PRICING_UTILS_PVT.so_cash_flow_details_tbl_type;
11772: l_noa_payment_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
11773: l_noa_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
11774: l_fee_outflow_caf_rec so_cash_flows_rec_type;
11775: l_fee_outflow_cfl_tbl so_cash_flow_details_tbl_type;

Line 11782: l_lq_details_prc_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;

11778: l_adj_type VARCHAR2(30);
11779: l_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
11780: l_sp_for_assets BOOLEAN;
11781: l_an_ass_follow_lq BOOLEAN;
11782: l_lq_details_prc_rec OKL_PRICING_UTILS_PVT.pricing_parameter_rec_type;
11783: l_rent_sty_id OKL_STRM_TYPE_B.ID%TYPE;
11784: l_asset_caf_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
11785: l_asset_cfl_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
11786: l_ast_level_fin_amt NUMBER;

Line 16036: END OKL_PRICING_UTILS_PVT;

16032: x_msg_count => x_msg_count,
16033: x_msg_data => x_msg_data,
16034: p_api_type => g_api_type);
16035: END price_standard_quote;
16036: END OKL_PRICING_UTILS_PVT;