[Home] [Help]
PACKAGE: APPS.OKL_CREATE_STREAMS_PUB
Source
1 PACKAGE Okl_Create_Streams_Pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPCSMS.pls 120.1.12010000.2 2009/08/10 14:39:35 rgooty ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
8 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
9
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_CREATE_STREAMS_PUB';
12
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
16
17
18 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
19 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
20 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
21 G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
22 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
23 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
24 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
25
26
27 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
28 G_EXCEPTION_ERROR EXCEPTION;
29 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
30
31 G_ORP_CODE_BOOKING CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_BOOKING;
32 G_ORP_CODE_RESTRUCTURE_AM CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_AM;
33 G_ORP_CODE_RESTRUCTURE_CS CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RESTRUCTURE_CS;
34 G_ORP_CODE_UPGRADE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ORP_CODE_UPGRADE;
35 -- mvasudev , sno, changed "QUOT" to "QUOTE"
36 G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_QUOTE;
37 G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_VARIABLE_INTEREST;
38 G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := Okl_Create_Streams_Pvt.G_ORP_CODE_RENEWAL;
39
40 G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
41 G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
42 G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
43 G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
44 G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
45 G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
46 G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
47 G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
48
49 G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
50 G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
51 G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
52 G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
53 G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
54 G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
55 G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
56 G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
57 G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
58 G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
59 G_ADJUST CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADJUST;
60 G_ADJUST_LOAN CONSTANT VARCHAR2(30) := Okl_Create_Streams_Pvt.G_ADJUST_LOAN;
61 G_ADJUSTMENT_METHOD CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_ADJUSTMENT_METHOD;
62
63
64 SUBTYPE sifv_rec_type IS okl_stream_interfaces_pub.sifv_rec_type;
65 SUBTYPE csm_lease_rec_type IS Okl_Create_Streams_Pvt.csm_lease_rec_type;
66 SUBTYPE csm_one_off_fee_tbl_type IS Okl_Create_Streams_Pvt.csm_one_off_fee_tbl_type;
67 SUBTYPE csm_periodic_expenses_tbl_type IS Okl_Create_Streams_Pvt.csm_periodic_expenses_tbl_type;
68 SUBTYPE csm_yields_tbl_type IS Okl_Create_Streams_Pvt.csm_yields_tbl_type;
69 SUBTYPE csm_stream_types_tbl_type IS Okl_Create_Streams_Pvt.csm_stream_types_tbl_type;
70 SUBTYPE csm_line_details_tbl_type IS Okl_Create_Streams_Pvt.csm_line_details_tbl_type;
71
72 SUBTYPE csm_loan_rec_type IS Okl_Create_Streams_Pvt.csm_loan_rec_type;
73 SUBTYPE csm_loan_line_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_line_tbl_type;
74 SUBTYPE csm_loan_level_tbl_type IS Okl_Create_Streams_Pvt.csm_loan_level_tbl_type;
75
76 PROCEDURE Create_Streams_Lease_Book(
77 p_api_version IN NUMBER
78 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
79 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
80 ,p_csm_lease_header IN csm_lease_rec_type
81 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
82 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
83 ,p_csm_yields_tbl IN csm_yields_tbl_type
84 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
85 ,p_csm_line_details_tbl IN csm_line_details_tbl_type
86 ,p_rents_tbl IN csm_periodic_expenses_tbl_type
87 ,x_trans_id OUT NOCOPY NUMBER
88 ,x_trans_status OUT NOCOPY VARCHAR2
89 ,x_return_status OUT NOCOPY VARCHAR2
90 ,x_msg_count OUT NOCOPY NUMBER
91 ,x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94
95 PROCEDURE Create_Streams_Loan_Book(
96 p_api_version IN NUMBER
97 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
98 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
99 ,p_csm_loan_header IN csm_loan_rec_type
100 ,p_csm_loan_lines_tbl IN csm_loan_line_tbl_type
101 ,p_csm_loan_levels_tbl IN csm_loan_level_tbl_type
102 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
103 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
104 ,p_csm_yields_tbl IN csm_yields_tbl_type
105 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
106 ,x_trans_id OUT NOCOPY NUMBER
107 ,x_trans_status OUT NOCOPY VARCHAR2
108 ,x_return_status OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY NUMBER
110 ,x_msg_data OUT NOCOPY VARCHAR2
111 );
112
113
114 PROCEDURE invoke_pricing_engine(
115 p_api_version IN NUMBER
116 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
117 ,p_sifv_rec IN sifv_rec_type
118 ,x_sifv_rec OUT NOCOPY sifv_rec_type
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_msg_count OUT NOCOPY NUMBER
121 ,x_msg_data OUT NOCOPY VARCHAR2
122 );
123
124 -- 04/30/2002
125 -- Procedure to Create Streams for Lease Type Contract - Restructure
126 PROCEDURE Create_Streams_Lease_Restr (
127 p_api_version IN NUMBER
128 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
129 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
130 ,p_csm_lease_header IN csm_lease_rec_type
131 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
132 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
133 ,p_csm_yields_tbl IN csm_yields_tbl_type
134 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
135 ,p_csm_line_details_tbl IN csm_line_details_tbl_type
136 ,p_rents_tbl IN csm_periodic_expenses_tbl_type
137 ,x_trans_id OUT NOCOPY NUMBER
138 ,x_trans_status OUT NOCOPY VARCHAR2
139 ,x_return_status OUT NOCOPY VARCHAR2
140 ,x_msg_count OUT NOCOPY NUMBER
141 ,x_msg_data OUT NOCOPY VARCHAR2
142 );
143
144 -- Procedure to Create Streams for Loan Type Contract
145 PROCEDURE Create_Streams_Loan_Restr (
146 p_api_version IN NUMBER
147 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
148 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
149 ,p_csm_loan_header IN csm_loan_rec_type
150 ,p_csm_loan_lines_tbl IN csm_loan_line_tbl_type
151 ,p_csm_loan_levels_tbl IN csm_loan_level_tbl_type
152 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
153 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
154 ,p_csm_yields_tbl IN csm_yields_tbl_type
155 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
156 ,x_trans_id OUT NOCOPY NUMBER
157 ,x_trans_status OUT NOCOPY VARCHAR2
158 ,x_return_status OUT NOCOPY VARCHAR2
159 ,x_msg_count OUT NOCOPY NUMBER
160 ,x_msg_data OUT NOCOPY VARCHAR2
161 );
162
163 -- end, 04/30/2002
164
165 PROCEDURE Create_Streams_Lease_Quote(
166 p_api_version IN NUMBER
167 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
168 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
169 ,p_csm_lease_header IN csm_lease_rec_type
170 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
171 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
172 ,p_csm_yields_tbl IN csm_yields_tbl_type
173 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
174 ,p_csm_line_details_tbl IN csm_line_details_tbl_type
175 ,p_rents_tbl IN csm_periodic_expenses_tbl_type
176 ,x_trans_id OUT NOCOPY NUMBER
177 ,x_trans_status OUT NOCOPY VARCHAR2
178 ,x_return_status OUT NOCOPY VARCHAR2
179 ,x_msg_count OUT NOCOPY NUMBER
180 ,x_msg_data OUT NOCOPY VARCHAR2);
181
182
183 END Okl_Create_Streams_Pub;