[Home] [Help]
1: Package OKL_LA_STREAM_PVT as
2: /* $Header: OKLRSGAS.pls 120.13.12010000.2 2008/10/01 21:59:02 rkuttiya ship $ */
3: -- Global variables
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LA_STREAM_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
6:
7: -- Store the yields types
8: TYPE yields_type IS RECORD (
9: pre_Tax_yield okl_k_headers.pre_tax_yield%type,
486: TYPE strmele_tbl_type IS TABLE OF l_strmele_csr%ROWTYPE INDEX BY BINARY_INTEGER;
487:
488: Procedure allocate_streams(
489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
491: x_return_status OUT NOCOPY VARCHAR2,
492: x_msg_count OUT NOCOPY NUMBER,
493: x_msg_data OUT NOCOPY VARCHAR2,
494: p_chr_id IN NUMBER) ;
494: p_chr_id IN NUMBER) ;
495:
496: Procedure generate_reporting_streams(
497: p_api_version IN NUMBER,
498: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
499: p_chr_id IN VARCHAR2,
500: p_report_deal_type IN VARCHAR2,
501: p_generation_context IN VARCHAR2,
502: p_skip_prc_engine IN VARCHAR2,
507: x_trans_status OUT NOCOPY VARCHAR2);
508:
509: Procedure generate_streams(
510: p_api_version IN NUMBER,
511: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
512: p_chr_id IN VARCHAR2,
513: p_generation_context IN VARCHAR2,
514: p_skip_prc_engine IN VARCHAR2,
515: x_return_status OUT NOCOPY VARCHAR2,
519: x_trans_status OUT NOCOPY VARCHAR2);
520:
521: Procedure process_streams(
522: p_api_version IN NUMBER,
523: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
524: x_return_status OUT NOCOPY VARCHAR2,
525: x_msg_count OUT NOCOPY NUMBER,
526: x_msg_data OUT NOCOPY VARCHAR2,
527: p_chr_id IN VARCHAR2,
530: p_source_call IN VARCHAR2 DEFAULT 'ESG');
531:
532: Procedure update_contract_yields(
533: p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
535: x_return_status OUT NOCOPY VARCHAR2,
536: x_msg_count OUT NOCOPY NUMBER,
537: x_msg_data OUT NOCOPY VARCHAR2,
538: p_chr_id IN VARCHAR2,
539: p_chr_yields IN yields_rec_type);
540:
541: Procedure extract_params_lease(
542: p_api_version IN NUMBER,
543: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
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,
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,
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,
602: x_start_date OUT NOCOPY DATE);
603:
604: PROCEDURE extract_params_so(
605: p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
607: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
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,
622:
623: --Added new procedure for the Variable Rate Project
624: Procedure extract_params_loan_paydown(
625: p_api_version IN NUMBER,
626: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
627: p_chr_id IN VARCHAR2,
628: p_deal_type IN VARCHAR2,
629: p_paydown_type IN VARCHAR2,
630: p_paydown_date IN DATE,
643:
644: --Added by kthiruva for Bug 5161075
645: Procedure extract_params_loan_reamort(
646: p_api_version IN NUMBER,
647: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
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,
659:
660: --Added by srsreeni for bug 5699923
661: PROCEDURE RECREATE_TMT_LN_STRMS(
662: p_api_version IN NUMBER,
663: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
664: x_return_status OUT NOCOPY VARCHAR2,
665: x_msg_count OUT NOCOPY NUMBER,
666: x_msg_data OUT NOCOPY VARCHAR2,
667: p_chr_id IN VARCHAR2,