DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_API

Line 5: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

1: Package OKL_LA_STREAM_PVT AUTHID CURRENT_USER as
2: /* $Header: OKLRSGAS.pls 120.22.12020000.3 2012/12/07 06:12:44 bkatraga 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,

Line 540: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

536: TYPE strmele_tbl_type IS TABLE OF l_strmele_csr%ROWTYPE INDEX BY BINARY_INTEGER;
537:
538: Procedure allocate_streams(
539: p_api_version IN NUMBER,
540: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
543: x_msg_data OUT NOCOPY VARCHAR2,
544: p_chr_id IN NUMBER) ;

Line 548: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

544: p_chr_id IN NUMBER) ;
545:
546: Procedure generate_reporting_streams(
547: p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
549: p_chr_id IN VARCHAR2,
550: p_report_deal_type IN VARCHAR2,
551: p_generation_context IN VARCHAR2,
552: p_skip_prc_engine IN VARCHAR2,

Line 562: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

558: p_orp_code IN VARCHAR2);
559:
560: Procedure generate_streams(
561: p_api_version IN NUMBER,
562: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
563: p_chr_id IN VARCHAR2,
564: p_generation_context IN VARCHAR2,
565: p_skip_prc_engine IN VARCHAR2,
566: x_return_status OUT NOCOPY VARCHAR2,

Line 574: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

570: x_trans_status OUT NOCOPY VARCHAR2);
571:
572: Procedure process_streams(
573: p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
575: x_return_status OUT NOCOPY VARCHAR2,
576: x_msg_count OUT NOCOPY NUMBER,
577: x_msg_data OUT NOCOPY VARCHAR2,
578: p_chr_id IN VARCHAR2,

Line 585: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

581: p_source_call IN VARCHAR2 DEFAULT 'ESG');
582:
583: Procedure update_contract_yields(
584: p_api_version IN NUMBER,
585: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
586: x_return_status OUT NOCOPY VARCHAR2,
587: x_msg_count OUT NOCOPY NUMBER,
588: x_msg_data OUT NOCOPY VARCHAR2,
589: p_chr_id IN VARCHAR2,

Line 594: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

590: p_chr_yields IN yields_rec_type);
591:
592: Procedure extract_params_lease(
593: p_api_version IN NUMBER,
594: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
595: p_chr_id IN VARCHAR2,
596: x_return_status OUT NOCOPY VARCHAR2,
597: x_msg_count OUT NOCOPY NUMBER,
598: x_msg_data OUT NOCOPY VARCHAR2,

Line 610: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

606: p_orp_code IN VARCHAR2 DEFAULT NULL );
607:
608: Procedure extract_params_loan(
609: p_api_version IN NUMBER,
610: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
611: p_chr_id IN VARCHAR2,
612: x_return_status OUT NOCOPY VARCHAR2,
613: x_msg_count OUT NOCOPY NUMBER,
614: x_msg_data OUT NOCOPY VARCHAR2,

Line 659: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

655: x_start_date OUT NOCOPY DATE);
656:
657: PROCEDURE extract_params_so(
658: p_api_version IN NUMBER,
659: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
660: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
661: p_cle_id IN OKC_K_LINES_B.ID%TYPE,
662: x_return_status OUT NOCOPY VARCHAR2,
663: x_msg_count OUT NOCOPY NUMBER,

Line 679: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

675:
676: --Added new procedure for the Variable Rate Project
677: Procedure extract_params_loan_paydown(
678: p_api_version IN NUMBER,
679: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
680: p_chr_id IN VARCHAR2,
681: p_deal_type IN VARCHAR2,
682: p_paydown_type IN VARCHAR2,
683: p_paydown_date IN DATE,

Line 700: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

696:
697: --Added by kthiruva for Bug 5161075
698: Procedure extract_params_loan_reamort(
699: p_api_version IN NUMBER,
700: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
701: p_chr_id IN VARCHAR2,
702: x_return_status OUT NOCOPY VARCHAR2,
703: x_msg_count OUT NOCOPY NUMBER,
704: x_msg_data OUT NOCOPY VARCHAR2,

Line 716: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

712:
713: --Added by srsreeni for bug 5699923
714: PROCEDURE RECREATE_TMT_LN_STRMS(
715: p_api_version IN NUMBER,
716: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
717: x_return_status OUT NOCOPY VARCHAR2,
718: x_msg_count OUT NOCOPY NUMBER,
719: x_msg_data OUT NOCOPY VARCHAR2,
720: p_chr_id IN VARCHAR2,

Line 754: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

750: * For ISG and ESG contracts --Bug 8624532 by NIKSHAH
751: *************************************************************************/
752: PROCEDURE GENERATE_PASSTHRU_EXP_STREAMS(
753: p_api_version IN NUMBER
754: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
755: ,P_CHR_ID IN NUMBER
756: ,P_PURPOSE_CODE IN VARCHAR2
757: ,x_return_status OUT NOCOPY VARCHAR2
758: ,x_msg_count OUT NOCOPY NUMBER

Line 773: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

769:
770: PROCEDURE GEN_PASSTHRU_SERV_EXP_STREAMS
771: (
772: p_api_version IN NUMBER,
773: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
774: P_CHR_ID IN NUMBER,
775: P_PURPOSE_CODE IN VARCHAR2,
776: x_return_status OUT NOCOPY VARCHAR2,
777: x_msg_count OUT NOCOPY NUMBER,