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_CASHFLOW_PVT

Line 8805: l_cashflow_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_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;
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;

Line 8806: l_cashflow_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_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;
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;

Line 9610: okl_lease_quote_cashflow_pvt.delete_cashflows (

9606: -- IF cash flows exists delete the existing ones and create afresh ..
9607: IF l_cfo_exists = 'YES'
9608: THEN
9609: -- Delete the Cash Flow Levels which may be already created by Pricing ..
9610: okl_lease_quote_cashflow_pvt.delete_cashflows (
9611: p_api_version => p_api_version,
9612: p_init_msg_list => p_init_msg_list,
9613: p_transaction_control => NULL,
9614: p_source_object_code => l_cashflow_header_rec.parent_object_code,

Line 9734: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(

9730: l_cashflow_level_tbl(i).record_mode := 'CREATE';
9731: END LOOP;
9732: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
9733: 'Before calling create_cash_flow ' );
9734: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(
9735: p_api_version => p_api_version,
9736: p_init_msg_list => p_init_msg_list,
9737: p_transaction_control => NULL,
9738: p_cashflow_header_rec => l_cashflow_header_rec,

Line 10296: x_caf_rec OUT NOCOPY OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type,

10292: x_return_status OUT NOCOPY VARCHAR2,
10293: x_msg_count OUT NOCOPY NUMBER,
10294: x_msg_data OUT NOCOPY VARCHAR2,
10295: p_id IN NUMBER,
10296: x_caf_rec OUT NOCOPY OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type,
10297: x_cfl_tbl OUT NOCOPY OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type,
10298: x_solved OUT NOCOPY VARCHAR2)
10299: IS
10300: -- Cursor to fetch all the Assets in a Lease Quote

Line 10297: x_cfl_tbl OUT NOCOPY OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type,

10293: x_msg_count OUT NOCOPY NUMBER,
10294: x_msg_data OUT NOCOPY VARCHAR2,
10295: p_id IN NUMBER,
10296: x_caf_rec OUT NOCOPY OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type,
10297: x_cfl_tbl OUT NOCOPY OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type,
10298: x_solved OUT NOCOPY VARCHAR2)
10299: IS
10300: -- Cursor to fetch all the Assets in a Lease Quote
10301: CURSOR all_assets_csr( p_qte_id IN okl_lease_quotes_b.id%TYPE)

Line 10353: l_caf_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;

10349: is_debug_procedure_on BOOLEAN;
10350: is_debug_statement_on BOOLEAN;
10351: i NUMBER;
10352: l_first BOOLEAN;
10353: l_caf_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
10354: l_cfl_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10355: l_solved VARCHAR2(30);
10356: BEGIN
10357: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 10354: l_cfl_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

10350: is_debug_statement_on BOOLEAN;
10351: i NUMBER;
10352: l_first BOOLEAN;
10353: l_caf_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;
10354: l_cfl_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10355: l_solved VARCHAR2(30);
10356: BEGIN
10357: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10358: l_debug_enabled := OKL_DEBUG_PUB.check_log_enabled;

Line 10771: l_lq_payment_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_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;
10773: l_cfo_exists_at_lq VARCHAR2(30);
10774: l_cfo_exists_at_noa VARCHAR2(30);
10775: l_tot_noa_oec NUMBER;

Line 10772: l_lq_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_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;
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;

Line 10778: l_noa_payment_header_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_type;

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;
10782: l_fee_inflow_caf_rec so_cash_flows_rec_type;

Line 10779: l_noa_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

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;
10782: l_fee_inflow_caf_rec so_cash_flows_rec_type;
10783: l_fee_inflow_cfl_tbl so_cash_flow_details_tbl_type;

Line 10790: l_asset_caf_rec OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_header_rec_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;
10793: l_lq_level_fin_amt NUMBER;
10794: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;

Line 10791: l_asset_cfl_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

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;
10793: l_lq_level_fin_amt NUMBER;
10794: l_quote_type_code OKL_LEASE_QUOTES_B.PARENT_OBJECT_CODE%TYPE;
10795: l_solved VARCHAR2(30);

Line 10800: l_rnd_sum_assets_pmnts_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

10796: l_tmp_amount NUMBER;
10797: l_lq_con_cash_inflows cash_inflows_tbl_type;
10798: l_iir NUMBER;
10799: l_miss_payment NUMBER;
10800: l_rnd_sum_assets_pmnts_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10801: l_rnd_lq_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10802: l_sum_of_noa_oec_percent NUMBER;
10803: -- Bug 6622178 : Start
10804: l_disp_sf_msg BOOLEAN;

Line 10801: l_rnd_lq_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;

10797: l_lq_con_cash_inflows cash_inflows_tbl_type;
10798: l_iir NUMBER;
10799: l_miss_payment NUMBER;
10800: l_rnd_sum_assets_pmnts_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10801: l_rnd_lq_payment_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
10802: l_sum_of_noa_oec_percent NUMBER;
10803: -- Bug 6622178 : Start
10804: l_disp_sf_msg BOOLEAN;
10805: -- Bug 6622178 : End

Line 11320: okl_lease_quote_cashflow_pvt.delete_cashflows (

11316: l_lq_details_prc_rec := l_lq_pricing_parameter_rec;
11317: IF l_cfo_exists_at_lq = 'YES'
11318: THEN
11319: -- Delete the Cash Flow Levels which may be already created by Pricing ..
11320: okl_lease_quote_cashflow_pvt.delete_cashflows (
11321: p_api_version => p_api_version,
11322: p_init_msg_list => p_init_msg_list,
11323: p_transaction_control => NULL,
11324: p_source_object_code => 'LEASE_QUOTE',

Line 11343: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(

11339: l_lq_payment_level_tbl(cfl_index).record_mode := 'CREATE';
11340: END LOOP;
11341: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11342: 'Before creating the cash flows call' );
11343: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(
11344: p_api_version => p_api_version,
11345: p_init_msg_list => p_init_msg_list,
11346: p_transaction_control => NULL,
11347: p_cashflow_header_rec => l_lq_payment_header_rec,

Line 11915: okl_lease_quote_cashflow_pvt.delete_cashflows (

11911: THEN
11912: IF l_cfo_exists_at_lq = 'YES'
11913: THEN
11914: -- Delete the Cash Flow Levels which may be already created by Pricing ..
11915: okl_lease_quote_cashflow_pvt.delete_cashflows (
11916: p_api_version => p_api_version,
11917: p_init_msg_list => p_init_msg_list,
11918: p_transaction_control => NULL,
11919: p_source_object_code => 'LEASE_QUOTE',

Line 11939: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(

11935: END LOOP;
11936: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11937: 'Before creating the cash flows call ' || 'Sty_id ' || l_lq_payment_header_rec.stream_type_id
11938: || 'Status_code ' || l_lq_payment_header_rec.status_code );
11939: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(
11940: p_api_version => p_api_version,
11941: p_init_msg_list => p_init_msg_list,
11942: p_transaction_control => NULL,
11943: p_cashflow_header_rec => l_lq_payment_header_rec,

Line 12501: okl_lease_quote_cashflow_pvt.delete_cashflows (

12497: THEN
12498: IF l_cfo_exists_at_lq = 'YES'
12499: THEN
12500: -- Delete the Cash Flow Levels which may be already created by Pricing ..
12501: okl_lease_quote_cashflow_pvt.delete_cashflows (
12502: p_api_version => p_api_version,
12503: p_init_msg_list => p_init_msg_list,
12504: p_transaction_control => NULL,
12505: p_source_object_code => 'LEASE_QUOTE',

Line 12525: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(

12521: END LOOP;
12522: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
12523: 'Before creating the cash flows call ' || 'Sty_id ' || l_lq_payment_header_rec.stream_type_id
12524: || 'Status_code ' || l_lq_payment_header_rec.status_code );
12525: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(
12526: p_api_version => p_api_version,
12527: p_init_msg_list => p_init_msg_list,
12528: p_transaction_control => NULL,
12529: p_cashflow_header_rec => l_lq_payment_header_rec,

Line 13164: 'Before OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow l_lq_payment_header_rec '

13160: IF l_cfo_exists_at_lq = 'YES'
13161: THEN
13162: -- Update the CFL Table
13163: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13164: 'Before OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow l_lq_payment_header_rec '
13165: || l_lq_payment_header_rec.stream_type_id
13166: || ' status_code ' || l_lq_payment_header_rec.status_code );
13167: OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
13168: p_api_version => G_API_VERSION,

Line 13167: OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (

13163: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13164: 'Before OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow l_lq_payment_header_rec '
13165: || l_lq_payment_header_rec.stream_type_id
13166: || ' status_code ' || l_lq_payment_header_rec.status_code );
13167: OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
13168: p_api_version => G_API_VERSION,
13169: p_init_msg_list => p_init_msg_list,
13170: p_transaction_control => G_FALSE,
13171: p_cashflow_header_rec => l_lq_payment_header_rec,

Line 13177: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow ' || l_return_status );

13173: x_return_status => l_return_status,
13174: x_msg_count => x_msg_count,
13175: x_msg_data => x_msg_data);
13176: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13177: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow ' || l_return_status );
13178: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13179: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow l_lq_payment_header_rec '
13180: || l_lq_payment_header_rec.stream_type_id
13181: || ' status_code ' || l_lq_payment_header_rec.status_code );

Line 13179: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow l_lq_payment_header_rec '

13175: x_msg_data => x_msg_data);
13176: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13177: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow ' || l_return_status );
13178: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13179: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow l_lq_payment_header_rec '
13180: || l_lq_payment_header_rec.stream_type_id
13181: || ' status_code ' || l_lq_payment_header_rec.status_code );
13182: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
13183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 13189: 'Before OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow l_lq_payment_header_rec '

13185: RAISE OKL_API.G_EXCEPTION_ERROR;
13186: END IF;
13187: ELSE
13188: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13189: 'Before OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow l_lq_payment_header_rec '
13190: || l_lq_payment_header_rec.stream_type_id
13191: || ' status_code ' || l_lq_payment_header_rec.status_code );
13192: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
13193: p_api_version => p_api_version,

Line 13192: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (

13188: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13189: 'Before OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow l_lq_payment_header_rec '
13190: || l_lq_payment_header_rec.stream_type_id
13191: || ' status_code ' || l_lq_payment_header_rec.status_code );
13192: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
13193: p_api_version => p_api_version,
13194: p_init_msg_list => p_init_msg_list,
13195: p_transaction_control => G_FALSE,
13196: p_cashflow_header_rec => l_lq_payment_header_rec,

Line 13202: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow ' || l_return_status );

13198: x_return_status => l_return_status,
13199: x_msg_count => x_msg_count,
13200: x_msg_data => x_msg_data);
13201: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13202: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow ' || l_return_status );
13203: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13204: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow l_lq_payment_header_rec '
13205: || l_lq_payment_header_rec.stream_type_id
13206: || ' status_code ' || l_lq_payment_header_rec.status_code );

Line 13204: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow l_lq_payment_header_rec '

13200: x_msg_data => x_msg_data);
13201: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13202: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow ' || l_return_status );
13203: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13204: 'After OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow l_lq_payment_header_rec '
13205: || l_lq_payment_header_rec.stream_type_id
13206: || ' status_code ' || l_lq_payment_header_rec.status_code );
13207: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
13208: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 14312: okl_lease_quote_cashflow_pvt.delete_cashflows (

14308: THEN
14309: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
14310: ' Deleting already existing CFO ' );
14311: -- Delete the Cash Flow Levels which may be already created by Pricing ..
14312: okl_lease_quote_cashflow_pvt.delete_cashflows (
14313: p_api_version => p_api_version,
14314: p_init_msg_list => p_init_msg_list,
14315: p_transaction_control => NULL,
14316: p_source_object_code => 'QUOTED_ASSET',

Line 14386: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(

14382: l_asset_cfl_tbl(i).stub_days || ' | ' || l_asset_cfl_tbl(i).stub_amount|| ' | ' || l_asset_cfl_tbl(i).periods|| ' | ' ||
14383: l_asset_cfl_tbl(i).periodic_amount || ' | ' || l_asset_cfl_tbl(i).start_Date );
14384: END LOOP;
14385: -- Create the Cash flows for the Asset
14386: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(
14387: p_api_version => p_api_version,
14388: p_init_msg_list => p_init_msg_list,
14389: p_transaction_control => NULL,
14390: p_cashflow_header_rec => l_asset_caf_rec,

Line 14418: okl_lease_quote_cashflow_pvt.delete_cashflows (

14414: END LOOP;
14415: IF l_cfo_exists_at_lq = 'YES'
14416: THEN
14417: -- Delete the Payment structure already derieved by pricing
14418: okl_lease_quote_cashflow_pvt.delete_cashflows (
14419: p_api_version => p_api_version,
14420: p_init_msg_list => p_init_msg_list,
14421: p_transaction_control => NULL,
14422: p_source_object_code => 'LEASE_QUOTE_CONSOLIDATED',

Line 14487: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(

14483: l_lq_payment_header_rec.frequency_code || ' | ' || l_lq_payment_header_rec.arrears_flag || ' | ' || l_lq_payment_level_tbl(i).rate|| ' | ' ||
14484: l_lq_payment_level_tbl(i).stub_days || ' | ' || l_lq_payment_level_tbl(i).stub_amount|| ' | ' || l_lq_payment_level_tbl(i).periods|| ' | ' ||
14485: l_lq_payment_level_tbl(i).periodic_amount || ' | ' || l_lq_payment_level_tbl(i).start_Date );
14486: END LOOP;
14487: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow(
14488: p_api_version => p_api_version,
14489: p_init_msg_list => p_init_msg_list,
14490: p_transaction_control => NULL,
14491: p_cashflow_header_rec => l_lq_payment_header_rec,