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_VAR_INT_REAMORT_PVT dependencies on OKL_CREATE_STREAMS_PVT

Line 162: p_csm_line_details_tbl IN okl_create_streams_pvt.csm_line_details_tbl_type) IS

158:
159:
160:
161: PROCEDURE print_lease_tables(p_rents_tbl_in IN Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type,
162: p_csm_line_details_tbl IN okl_create_streams_pvt.csm_line_details_tbl_type) IS
163: l_api_name CONSTANT VARCHAR2(30) := 'print_lease_tables';
164: i NUMBER;
165: l_source Number;
166: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

Line 167: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;

163: l_api_name CONSTANT VARCHAR2(30) := 'print_lease_tables';
164: i NUMBER;
165: l_source Number;
166: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
167: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
168: BEGIN
169: l_rents_tbl_in := p_rents_tbl_in;
170: l_csm_line_details_tbl := p_csm_line_details_tbl;
171: OKL_VARIABLE_INTEREST_PVT.print_debug('******************************************');

Line 1473: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

1469: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1470: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1471: --l_rents_prin_tbl used for loan processing
1472: l_rents_prin_tbl OKL_VARIABLE_INTEREST_PVT.csm_periodic_expenses_tbl_type;
1473: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
1474: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1475: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1476: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
1477: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

Line 1474: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

1470: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1471: --l_rents_prin_tbl used for loan processing
1472: l_rents_prin_tbl OKL_VARIABLE_INTEREST_PVT.csm_periodic_expenses_tbl_type;
1473: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
1474: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1475: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1476: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
1477: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1478: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;

Line 1475: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

1471: --l_rents_prin_tbl used for loan processing
1472: l_rents_prin_tbl OKL_VARIABLE_INTEREST_PVT.csm_periodic_expenses_tbl_type;
1473: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
1474: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1475: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1476: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
1477: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1478: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
1479: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

Line 1481: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;

1477: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1478: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
1479: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1480: l_csm_loan_levels_tbl_in OKL_VARIABLE_INTEREST_PVT.csm_loan_level_tbl_type;
1481: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;
1482: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
1483: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1484:
1485: l_index NUMBER := 0;

Line 1482: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;

1478: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
1479: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1480: l_csm_loan_levels_tbl_in OKL_VARIABLE_INTEREST_PVT.csm_loan_level_tbl_type;
1481: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;
1482: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
1483: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1484:
1485: l_index NUMBER := 0;
1486: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1576: l_tmp_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;

1572: AND STS.STE_CODE = 'TERMINATED';
1573:
1574: l_asset_term_flag VARCHAR2(1):= 'N';
1575: l_line_count NUMBER;
1576: l_tmp_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
1577: j NUMBER;
1578: l_tmp_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1579: l_tmp_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1580: --end bkatraga for bug 14811647

Line 1578: l_tmp_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

1574: l_asset_term_flag VARCHAR2(1):= 'N';
1575: l_line_count NUMBER;
1576: l_tmp_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
1577: j NUMBER;
1578: l_tmp_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1579: l_tmp_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1580: --end bkatraga for bug 14811647
1581:
1582: --dkagrawa changed query to use view okl_prod_qlty_val_uv than okl_product_parameters_v for performance

Line 1579: l_tmp_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

1575: l_line_count NUMBER;
1576: l_tmp_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
1577: j NUMBER;
1578: l_tmp_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1579: l_tmp_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1580: --end bkatraga for bug 14811647
1581:
1582: --dkagrawa changed query to use view okl_prod_qlty_val_uv than okl_product_parameters_v for performance
1583: CURSOR c_chr_id (cp_khr_id VARCHAR2) IS