[Home] [Help]
PACKAGE: APPS.OKL_LA_STREAM_PUB
Source
1 Package OKL_LA_STREAM_PUB AUTHID CURRENT_USER as
2 /* $Header: OKLPSGAS.pls 120.2 2006/04/20 15:27:05 kthiruva noship $ */
3
4
5 subtype yields_rec_type is OKL_LA_STREAM_PVT.yields_rec_type;
6
7 -- Global variables for user hooks
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LA_STREAM_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10
11
12 Procedure generate_streams(
13 p_api_version IN NUMBER,
14 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
15 p_chr_id IN VARCHAR2,
16 p_generation_context IN VARCHAR2,
17 p_skip_prc_engine IN VARCHAR2,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 x_request_id OUT NOCOPY NUMBER,
22 x_trans_status OUT NOCOPY VARCHAR2);
23
24 Procedure update_contract_yields(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_chr_id IN VARCHAR2,
31 p_chr_yields IN yields_rec_type);
32
33 Procedure extract_params_lease(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
36 p_chr_id IN VARCHAR2,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,
41 x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
42 x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
43 x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
44 x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
45 x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
46 x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type);
47
48 Procedure extract_params_loan(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
51 p_chr_id IN VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
56 x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
57 x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
58 x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
59 x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
60 x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
61 x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type);
62
63 Procedure GEN_INTR_EXTR_STREAM (
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
70 p_generation_ctx_code IN VARCHAR2,
71 x_trx_number OUT NOCOPY NUMBER,
72 x_trx_status OUT NOCOPY VARCHAR2);
73
74 Procedure extract_params_loan_paydown(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
77 p_chr_id IN VARCHAR2,
78 p_deal_type IN VARCHAR2,
79 p_paydown_type IN VARCHAR2,
80 p_paydown_date IN DATE,
81 p_paydown_amount IN NUMBER,
82 p_balance_type_code IN VARCHAR2,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
87 x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
88 x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
89 x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
90 x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
91 x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
92 x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type);
93
94 --Added by kthiruva for bug 5161075
95 Procedure extract_params_loan_reamort(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
98 p_chr_id IN VARCHAR2,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
103 x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
104 x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
105 x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
106 x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
107 x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
108 x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type);
109
110 End OKL_LA_STREAM_PUB;