544: p_chr_id IN VARCHAR2,
545: x_return_status OUT NOCOPY VARCHAR2,
546: x_msg_count OUT NOCOPY NUMBER,
547: x_msg_data OUT NOCOPY VARCHAR2,
548: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
549: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
550: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
551: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
552: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
545: x_return_status OUT NOCOPY VARCHAR2,
546: x_msg_count OUT NOCOPY NUMBER,
547: x_msg_data OUT NOCOPY VARCHAR2,
548: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
549: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
550: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
551: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
552: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
553: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
546: x_msg_count OUT NOCOPY NUMBER,
547: x_msg_data OUT NOCOPY VARCHAR2,
548: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
549: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
550: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
551: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
552: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
553: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
554: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type);
547: x_msg_data OUT NOCOPY VARCHAR2,
548: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
549: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
550: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
551: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
552: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
553: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
554: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type);
555:
548: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
549: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
550: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
551: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
552: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
553: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
554: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type);
555:
556: Procedure extract_params_loan(
549: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
550: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
551: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
552: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
553: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
554: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type);
555:
556: Procedure extract_params_loan(
557: p_api_version IN NUMBER,
550: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
551: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
552: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
553: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
554: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type);
555:
556: Procedure extract_params_loan(
557: p_api_version IN NUMBER,
558: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
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);
570:
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);
570:
571: Procedure GEN_INTR_EXTR_STREAM (
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);
570:
571: Procedure GEN_INTR_EXTR_STREAM (
572: p_api_version IN NUMBER,
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);
570:
571: Procedure GEN_INTR_EXTR_STREAM (
572: p_api_version IN NUMBER,
573: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
608: p_cle_id IN OKC_K_LINES_B.ID%TYPE,
609: x_return_status OUT NOCOPY VARCHAR2,
610: x_msg_count OUT NOCOPY NUMBER,
611: x_msg_data OUT NOCOPY VARCHAR2,
612: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
613: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
614: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_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,
609: x_return_status OUT NOCOPY VARCHAR2,
610: x_msg_count OUT NOCOPY NUMBER,
611: x_msg_data OUT NOCOPY VARCHAR2,
612: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
613: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
614: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_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,
610: x_msg_count OUT NOCOPY NUMBER,
611: x_msg_data OUT NOCOPY VARCHAR2,
612: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
613: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
614: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_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,
611: x_msg_data OUT NOCOPY VARCHAR2,
612: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
613: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
614: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_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,
612: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
613: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
614: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_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,
613: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
614: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_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);
614: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_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:
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);
643:
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);
643:
644: --Added by kthiruva for Bug 5161075
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);
643:
644: --Added by kthiruva for Bug 5161075
645: Procedure extract_params_loan_reamort(
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);
643:
644: --Added by kthiruva for Bug 5161075
645: Procedure extract_params_loan_reamort(
646: p_api_version IN 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);
659:
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);
659:
660: --Added by srsreeni for bug 5699923
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);
659:
660: --Added by srsreeni for bug 5699923
661: PROCEDURE RECREATE_TMT_LN_STRMS(
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);
659:
660: --Added by srsreeni for bug 5699923
661: PROCEDURE RECREATE_TMT_LN_STRMS(
662: p_api_version IN NUMBER,