559: p_chr_id IN VARCHAR2,
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
564: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
565: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
566: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
567: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
564: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
565: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
566: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
567: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
568: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
564: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
565: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
566: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
567: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
568: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
569: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type);
615: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
616: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
617: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
618: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
619: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
620: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
621: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type);
622:
623: --Added new procedure for the Variable Rate Project
616: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
617: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
618: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
619: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
620: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
621: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type);
622:
623: --Added new procedure for the Variable Rate Project
624: Procedure extract_params_loan_paydown(
617: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
618: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
619: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
620: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
621: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type);
622:
623: --Added new procedure for the Variable Rate Project
624: Procedure extract_params_loan_paydown(
625: p_api_version IN NUMBER,
632: p_balance_type_code IN VARCHAR2,
633: x_return_status OUT NOCOPY VARCHAR2,
634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2,
636: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
637: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
638: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
639: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
640: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
633: x_return_status OUT NOCOPY VARCHAR2,
634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2,
636: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
637: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
638: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
639: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
640: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
641: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2,
636: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
637: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
638: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
639: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
640: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
641: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
642: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type);
648: p_chr_id IN VARCHAR2,
649: x_return_status OUT NOCOPY VARCHAR2,
650: x_msg_count OUT NOCOPY NUMBER,
651: x_msg_data OUT NOCOPY VARCHAR2,
652: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
653: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
654: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
655: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
656: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
649: x_return_status OUT NOCOPY VARCHAR2,
650: x_msg_count OUT NOCOPY NUMBER,
651: x_msg_data OUT NOCOPY VARCHAR2,
652: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
653: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
654: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
655: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
656: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
657: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
650: x_msg_count OUT NOCOPY NUMBER,
651: x_msg_data OUT NOCOPY VARCHAR2,
652: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
653: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
654: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
655: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
656: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
657: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
658: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type);