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_LA_STREAM_PVT dependencies on OKL_LA_STREAM_PVT

Line 1: Package body OKL_LA_STREAM_PVT as

1: Package body OKL_LA_STREAM_PVT as
2: /* $Header: OKLRSGAB.pls 120.180.12020000.9 2013/01/31 11:08:33 bkatraga ship $ */
3: -------------------------------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------

Line 3617: -- okl_stream_generator_pvt.generate_streams, which calls OKL_LA_STREAM_PVT.GEN_PASSTHRU_SERV_EXP_STREAMS

3613:
3614: --sechawla 15-SEP-2010 10045043 : begin
3615: -- Generate passthru service expense accrual streams for ESG
3616: -- ISG call for generating these streams is in
3617: -- okl_stream_generator_pvt.generate_streams, which calls OKL_LA_STREAM_PVT.GEN_PASSTHRU_SERV_EXP_STREAMS
3618: GEN_PASSTHRU_SERV_EXP_STREAMS
3619: (
3620: p_api_version => p_api_version
3621: ,p_init_msg_list => p_init_msg_list

Line 4118: -- okl_la_stream_pvt.adjust_passthrough_streams. For ISG, this procedure is called from

4114: --
4115: -- Procedure Name : GEN_PASSTHRU_SERV_EXP_STREAMS
4116: -- Description : This procedure creats passthrough service expense accrual streams which
4117: -- will be used for both ISG and ESG. For ESG, this procedure is called from
4118: -- okl_la_stream_pvt.adjust_passthrough_streams. For ISG, this procedure is called from
4119: -- okl_stream_generator_pvt.generate_streams
4120: -- Business Rules :
4121: -- Version : 1.0
4122: -- History : SECHAWLA 15-Sep-2010 - Bug# 10045043 Added new procedure GEN_PASSTHRU_SERV_EXP_STREAMS

Line 6361: -- This copy over logic is actually handled in okl_la_stream_pvt.RECREATE_TMT_LN_STRMS

6357: -- Requirement:
6358: -- For the Terminated Assets, Advance Rental Streams which are
6359: -- <= Termination Date should be copied over, rather than re-generating it again.
6360: --
6361: -- This copy over logic is actually handled in okl_la_stream_pvt.RECREATE_TMT_LN_STRMS
6362: -- This API currently copies all the Streams generated using ESG for the Terminated Assets
6363: -- As part of this bug 7653893, we will be modifying the okl_la_stream_pvt.RECREATE_TMT_LN_STRMS
6364: -- to consider the Advance_Rent streams also to copy over [as its currently ignoring those]
6365: -- Also modifying the create_advance_rental_streams API not to worry about the

Line 6363: -- As part of this bug 7653893, we will be modifying the okl_la_stream_pvt.RECREATE_TMT_LN_STRMS

6359: -- <= Termination Date should be copied over, rather than re-generating it again.
6360: --
6361: -- This copy over logic is actually handled in okl_la_stream_pvt.RECREATE_TMT_LN_STRMS
6362: -- This API currently copies all the Streams generated using ESG for the Terminated Assets
6363: -- As part of this bug 7653893, we will be modifying the okl_la_stream_pvt.RECREATE_TMT_LN_STRMS
6364: -- to consider the Advance_Rent streams also to copy over [as its currently ignoring those]
6365: -- Also modifying the create_advance_rental_streams API not to worry about the
6366: -- Advance Rental Streams Generation for the Terminated Assets in ESG contract.
6367: NULL;

Line 19626: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: Begin(+)');

19622: p_msg_name => 'OKL_LLA_REPSTRMS_EXTR_FAILED');
19623: raise OKL_API.G_EXCEPTION_ERROR;
19624: End If;
19625:
19626: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: Begin(+)');
19627: IF l_csm_line_details_tbl.COUNT > 0 THEN
19628: FOR z IN l_csm_line_details_tbl.FIRST..l_csm_line_details_tbl.LAST
19629: LOOP
19630: IF l_csm_line_details_tbl.exists(z) THEN

Line 19631: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').description :' || l_csm_line_details_tbl(z).description);

19627: IF l_csm_line_details_tbl.COUNT > 0 THEN
19628: FOR z IN l_csm_line_details_tbl.FIRST..l_csm_line_details_tbl.LAST
19629: LOOP
19630: IF l_csm_line_details_tbl.exists(z) THEN
19631: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').description :' || l_csm_line_details_tbl(z).description);
19632: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').date_start :' || l_csm_line_details_tbl(z).date_start);
19633: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').kle_loan_id :' || l_csm_line_details_tbl(z).kle_loan_id);
19634: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_index_number :' || l_csm_line_details_tbl(z).level_index_number);
19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);

Line 19632: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').date_start :' || l_csm_line_details_tbl(z).date_start);

19628: FOR z IN l_csm_line_details_tbl.FIRST..l_csm_line_details_tbl.LAST
19629: LOOP
19630: IF l_csm_line_details_tbl.exists(z) THEN
19631: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').description :' || l_csm_line_details_tbl(z).description);
19632: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').date_start :' || l_csm_line_details_tbl(z).date_start);
19633: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').kle_loan_id :' || l_csm_line_details_tbl(z).kle_loan_id);
19634: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_index_number :' || l_csm_line_details_tbl(z).level_index_number);
19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);
19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);

Line 19633: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').kle_loan_id :' || l_csm_line_details_tbl(z).kle_loan_id);

19629: LOOP
19630: IF l_csm_line_details_tbl.exists(z) THEN
19631: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').description :' || l_csm_line_details_tbl(z).description);
19632: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').date_start :' || l_csm_line_details_tbl(z).date_start);
19633: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').kle_loan_id :' || l_csm_line_details_tbl(z).kle_loan_id);
19634: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_index_number :' || l_csm_line_details_tbl(z).level_index_number);
19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);
19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);
19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);

Line 19634: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_index_number :' || l_csm_line_details_tbl(z).level_index_number);

19630: IF l_csm_line_details_tbl.exists(z) THEN
19631: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').description :' || l_csm_line_details_tbl(z).description);
19632: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').date_start :' || l_csm_line_details_tbl(z).date_start);
19633: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').kle_loan_id :' || l_csm_line_details_tbl(z).kle_loan_id);
19634: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_index_number :' || l_csm_line_details_tbl(z).level_index_number);
19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);
19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);
19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);
19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);

Line 19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);

19631: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').description :' || l_csm_line_details_tbl(z).description);
19632: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').date_start :' || l_csm_line_details_tbl(z).date_start);
19633: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').kle_loan_id :' || l_csm_line_details_tbl(z).kle_loan_id);
19634: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_index_number :' || l_csm_line_details_tbl(z).level_index_number);
19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);
19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);
19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);
19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);
19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);

Line 19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);

19632: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').date_start :' || l_csm_line_details_tbl(z).date_start);
19633: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').kle_loan_id :' || l_csm_line_details_tbl(z).kle_loan_id);
19634: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_index_number :' || l_csm_line_details_tbl(z).level_index_number);
19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);
19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);
19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);
19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);
19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);
19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);

Line 19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);

19633: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').kle_loan_id :' || l_csm_line_details_tbl(z).kle_loan_id);
19634: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_index_number :' || l_csm_line_details_tbl(z).level_index_number);
19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);
19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);
19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);
19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);
19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);
19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);
19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);

Line 19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);

19634: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_index_number :' || l_csm_line_details_tbl(z).level_index_number);
19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);
19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);
19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);
19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);
19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);
19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);
19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);
19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);

Line 19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);

19635: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').level_type :' || l_csm_line_details_tbl(z).level_type);
19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);
19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);
19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);
19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);
19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);
19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);
19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);
19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);

Line 19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);

19636: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').number_of_periods :' || l_csm_line_details_tbl(z).number_of_periods);
19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);
19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);
19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);
19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);
19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);
19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);
19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);
19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);

Line 19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);

19637: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').amount :' || l_csm_line_details_tbl(z).amount);
19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);
19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);
19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);
19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);
19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);
19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);
19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);
19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);

Line 19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);

19638: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').lock_level_step :' || l_csm_line_details_tbl(z).lock_level_step);
19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);
19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);
19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);
19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);
19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);
19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);
19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);
19646: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_year :' || l_csm_line_details_tbl(z).days_in_year);

Line 19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);

19639: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').rate :' || l_csm_line_details_tbl(z).rate);
19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);
19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);
19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);
19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);
19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);
19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);
19646: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_year :' || l_csm_line_details_tbl(z).days_in_year);
19647: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').balance_type_code :' || l_csm_line_details_tbl(z).balance_type_code);

Line 19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);

19640: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').period :' || l_csm_line_details_tbl(z).period);
19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);
19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);
19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);
19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);
19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);
19646: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_year :' || l_csm_line_details_tbl(z).days_in_year);
19647: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').balance_type_code :' || l_csm_line_details_tbl(z).balance_type_code);
19648: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').payment_type :' || l_csm_line_details_tbl(z).payment_type);

Line 19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);

19641: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').advance_or_arrears :' || l_csm_line_details_tbl(z).advance_or_arrears);
19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);
19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);
19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);
19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);
19646: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_year :' || l_csm_line_details_tbl(z).days_in_year);
19647: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').balance_type_code :' || l_csm_line_details_tbl(z).balance_type_code);
19648: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').payment_type :' || l_csm_line_details_tbl(z).payment_type);
19649: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').orig_contract_line_id :' || l_csm_line_details_tbl(z).orig_contract_line_id);

Line 19646: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_year :' || l_csm_line_details_tbl(z).days_in_year);

19642: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').income_or_expense :' || l_csm_line_details_tbl(z).income_or_expense);
19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);
19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);
19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);
19646: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_year :' || l_csm_line_details_tbl(z).days_in_year);
19647: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').balance_type_code :' || l_csm_line_details_tbl(z).balance_type_code);
19648: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').payment_type :' || l_csm_line_details_tbl(z).payment_type);
19649: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').orig_contract_line_id :' || l_csm_line_details_tbl(z).orig_contract_line_id);
19650: END IF;

Line 19647: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').balance_type_code :' || l_csm_line_details_tbl(z).balance_type_code);

19643: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').structure :' || l_csm_line_details_tbl(z).structure);
19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);
19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);
19646: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_year :' || l_csm_line_details_tbl(z).days_in_year);
19647: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').balance_type_code :' || l_csm_line_details_tbl(z).balance_type_code);
19648: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').payment_type :' || l_csm_line_details_tbl(z).payment_type);
19649: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').orig_contract_line_id :' || l_csm_line_details_tbl(z).orig_contract_line_id);
19650: END IF;
19651: END LOOP;

Line 19648: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').payment_type :' || l_csm_line_details_tbl(z).payment_type);

19644: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').query_level_yn :' || l_csm_line_details_tbl(z).query_level_yn);
19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);
19646: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_year :' || l_csm_line_details_tbl(z).days_in_year);
19647: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').balance_type_code :' || l_csm_line_details_tbl(z).balance_type_code);
19648: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').payment_type :' || l_csm_line_details_tbl(z).payment_type);
19649: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').orig_contract_line_id :' || l_csm_line_details_tbl(z).orig_contract_line_id);
19650: END IF;
19651: END LOOP;
19652: END IF;

Line 19649: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').orig_contract_line_id :' || l_csm_line_details_tbl(z).orig_contract_line_id);

19645: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_month :' || l_csm_line_details_tbl(z).days_in_month);
19646: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').days_in_year :' || l_csm_line_details_tbl(z).days_in_year);
19647: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').balance_type_code :' || l_csm_line_details_tbl(z).balance_type_code);
19648: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').payment_type :' || l_csm_line_details_tbl(z).payment_type);
19649: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').orig_contract_line_id :' || l_csm_line_details_tbl(z).orig_contract_line_id);
19650: END IF;
19651: END LOOP;
19652: END IF;
19653: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: End(-)');

Line 19653: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: End(-)');

19649: write_to_log(' okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(' || z || ').orig_contract_line_id :' || l_csm_line_details_tbl(z).orig_contract_line_id);
19650: END IF;
19651: END LOOP;
19652: END IF;
19653: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: End(-)');
19654:
19655: --Added by NIKSHAH for bug 9103807 :START
19656: l_total_amount := 0;
19657: l_index_flag := -1;

Line 19684: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_index_flag: ' || l_index_flag);

19680: l_diff_amount := l_funded_amount - l_total_amount;
19681: l_csm_line_details_tbl(l_index_flag).amount := l_csm_line_details_tbl(l_index_flag).amount + l_diff_amount;
19682: END IF;
19683: --Added by NIKSHAH for bug 9103807 :END
19684: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_index_flag: ' || l_index_flag);
19685: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_diff_amount: ' || l_diff_amount);
19686: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_funded_amount: ' || l_funded_amount);
19687: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_total_amount: ' || l_total_amount);
19688: --Commented by bkatraga for bug 13093818

Line 19685: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_diff_amount: ' || l_diff_amount);

19681: l_csm_line_details_tbl(l_index_flag).amount := l_csm_line_details_tbl(l_index_flag).amount + l_diff_amount;
19682: END IF;
19683: --Added by NIKSHAH for bug 9103807 :END
19684: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_index_flag: ' || l_index_flag);
19685: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_diff_amount: ' || l_diff_amount);
19686: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_funded_amount: ' || l_funded_amount);
19687: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_total_amount: ' || l_total_amount);
19688: --Commented by bkatraga for bug 13093818
19689: --write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(l_index_flag).amount: ' || l_csm_line_details_tbl(l_index_flag).amount);

Line 19686: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_funded_amount: ' || l_funded_amount);

19682: END IF;
19683: --Added by NIKSHAH for bug 9103807 :END
19684: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_index_flag: ' || l_index_flag);
19685: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_diff_amount: ' || l_diff_amount);
19686: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_funded_amount: ' || l_funded_amount);
19687: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_total_amount: ' || l_total_amount);
19688: --Commented by bkatraga for bug 13093818
19689: --write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(l_index_flag).amount: ' || l_csm_line_details_tbl(l_index_flag).amount);
19690:

Line 19687: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_total_amount: ' || l_total_amount);

19683: --Added by NIKSHAH for bug 9103807 :END
19684: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_index_flag: ' || l_index_flag);
19685: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_diff_amount: ' || l_diff_amount);
19686: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_funded_amount: ' || l_funded_amount);
19687: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_total_amount: ' || l_total_amount);
19688: --Commented by bkatraga for bug 13093818
19689: --write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(l_index_flag).amount: ' || l_csm_line_details_tbl(l_index_flag).amount);
19690:
19691: x_csm_loan_header := l_csm_loan_header;

Line 19689: --write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(l_index_flag).amount: ' || l_csm_line_details_tbl(l_index_flag).amount);

19685: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_diff_amount: ' || l_diff_amount);
19686: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_funded_amount: ' || l_funded_amount);
19687: write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_total_amount: ' || l_total_amount);
19688: --Commented by bkatraga for bug 13093818
19689: --write_to_log('okl_la_stream_pvt.extract_params_ppd_rebook: l_csm_line_details_tbl(l_index_flag).amount: ' || l_csm_line_details_tbl(l_index_flag).amount);
19690:
19691: x_csm_loan_header := l_csm_loan_header;
19692: x_csm_loan_lines_tbl := l_csm_loan_levels_tbl;
19693: x_csm_loan_levels_tbl := l_csm_line_details_tbl;

Line 26779: End OKL_LA_STREAM_PVT;

26775: END upgrade_esg_khr_for_prb;
26776:
26777:
26778: -- End modification 11i10 bakuchib
26779: End OKL_LA_STREAM_PVT;