1 PACKAGE OKL_AM_SECURITIZATION_PVT AS
2 /* $Header: OKLRASZS.pls 120.4 2008/02/01 06:24:36 sosharma ship $ */
3
4 /*=======================================================================+
5 | GLOBAL VARIABLES
6 +=======================================================================*/
7
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_SECURITIZATION_PVT';
9 G_APP_NAME CONSTANT VARCHAR2(50) := OKC_API.G_APP_NAME;
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
12 G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
13 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17
18 G_RET_STS_SUCCESS CONSTANT VARCHAR2(100) := OKL_API.G_RET_STS_SUCCESS;
19 G_RET_STS_ERROR CONSTANT VARCHAR2(100) := OKL_API.G_RET_STS_ERROR;
20 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(100) := OKL_API.G_RET_STS_UNEXP_ERROR;
21
22 G_NO CONSTANT VARCHAR2(1) := 'N';
23 G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
24
25 -- new globals to support changes to OKL_STREAMS table
26 G_INV_AGG_ID NUMBER;
27 G_SOURCE_TABLE CONSTANT VARCHAR2(100):= 'OKL_K_HEADERS';
28
29 /*=======================================================================+
30 | GLOBAL DATASTRUCTURES
31 +=======================================================================*/
32
33 SUBTYPE quot_rec_type IS OKL_TRX_QUOTES_PUB.qtev_rec_type;
34 SUBTYPE tqlv_tbl_type IS OKL_TXL_QUOTE_LINES_PUB.tqlv_tbl_type;
35
36
37 TYPE qte_asset_type IS RECORD (
38 p_khr_id NUMBER,
39 p_kle_id NUMBER,
40 p_sty_id NUMBER,
41 p_amount NUMBER,
42 p_qlt_code VARCHAR2(30),
43 p_secured VARCHAR2(1));
44
45
46 TYPE asset_tbl_type IS TABLE OF qte_asset_type INDEX BY BINARY_INTEGER;
47
48 /*=======================================================================+
49 | PROCEDURES
50 +=======================================================================*/
51
52
53 /*========================================================================
54 | PUBLIC PROCEDURE PROCESS_SECURITIZED_STREAMS
55 |
56 | DESCRIPTION
57 | Main procedure, determines if securitized items existif so,
58 | disbursements are created.
59 |
60 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
61 | Called externally from Termination Quote Acceptance workflow (OKLAMPPT).
62 | The associated workflow PACKAGE.procedure name is,
63 | OKL_AM_QUOTES_WF.chk_securitization.
64 |
65 | Called externally from Asset Dsiposition PACKAGE.procedure name is,
66 | OKL_AM_ASSET_DISPOSE_PVT.dispose_asset.
67 |
68 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
69 |
70 | PARAMETERS
71 | p_api_version IN Standard in parameter
72 | p_init_msg_list IN Standard in parameter
73 | x_return_status OUT Standard out parameter
74 | x_msg_count OUT Standard out parameter
75 | x_msg_data OUT Standard out parameter
76 | p_quote_id IN Termination Quote Identifier when called from
77 | termincation quote acceptance.
78 | p_kle_id IN Asset Line identifier pased when called from
79 | asset disposition.
80 | p_khr_id IN Contract Header identifier passed when called
81 | from asset disposition
82 | p_sale_price IN Disposition Amount passed when called from
83 | asset disposition.
84 | p_call_origin IN Used internally to identify where the has been
85 | made from.
86 |
87 | KNOWN ISSUES
88 |
89 | NOTES
90 |
91 | MODIFICATION HISTORY
92 | Date Author Description of Changes
93 | DD-MON-YYYY Name Bug #####, modified amount ..
94 | 09-OCT-2003 MDokal Created.
95 | 06-Oct-2004 rmunjulu EDAT Added Parameters to get transaction
96 | date and effective date and do processing
97 | based on those
98 |
99 *=======================================================================*/
100 PROCEDURE process_securitized_streams(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_quote_id IN NUMBER DEFAULT NULL,
107 p_kle_id IN NUMBER DEFAULT NULL,
108 p_khr_id IN NUMBER DEFAULT NULL,
109 p_sale_price IN NUMBER DEFAULT NULL,
110 p_effective_date IN DATE DEFAULT NULL, -- rmunjulu EDAT
111 p_transaction_date IN DATE DEFAULT NULL, -- rmunjulu EDAT
112 p_call_origin IN VARCHAR2);
113
114 /*========================================================================
115 | PUBLIC PROCEDURE DISBURSE_INVESTOR_RENT
116 |
117 | DESCRIPTION
118 | Processes invester disbursement for rent.
119 |
120 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
121 | Called from PROCESS_SECURITIZED_STREAMS
122 |
123 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
124 |
125 | PARAMETERS
126 | p_api_version IN Standard in parameter
127 | p_init_msg_list IN Standard in parameter
128 | x_return_status OUT Standard out parameter
129 | x_msg_count OUT Standard out parameter
130 | x_msg_data OUT Standard out parameter
131 | p_asset_tbl IN Table of asset(s) records for processing
132 |
133 | KNOWN ISSUES
134 |
135 | NOTES
136 |
137 | MODIFICATION HISTORY
138 | Date Author Description of Changes
139 | DD-MON-YYYY Name Bug #####, modified amount ..
140 | 09-OCT-2003 MDokal Created.
141 | 24-Sep-2004 rmunjulu 3910833 Set p_ia_id as parameter
142 | 06-Oct-2004 rmunjulu EDAT Added Parameters to get transaction
143 | date and effective date and do processing
144 | based on those
145 |
146 *=======================================================================*/
147 PROCEDURE disburse_investor_rent(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_ia_id IN NUMBER, -- rmunjulu 3910833
154 p_effective_date IN DATE DEFAULT NULL, -- rmunjulu EDAT
155 p_transaction_date IN DATE DEFAULT NULL, -- rmunjulu EDAT
156 p_asset_tbl IN asset_tbl_type);
157
158 /*========================================================================
159 | PUBLIC PROCEDURE DISBURSE_INVESTOR_RV
160 |
161 | DESCRIPTION
162 | Processes invester disbursement for residual value.
163 |
164 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
165 | Called from PROCESS_SECURITIZED_STREAMS
166 |
167 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
168 |
169 | PARAMETERS
170 | p_api_version IN Standard in parameter
171 | p_init_msg_list IN Standard in parameter
172 | x_return_status OUT Standard out parameter
173 | x_msg_count OUT Standard out parameter
174 | x_msg_data OUT Standard out parameter
175 | p_kle_id IN Asset Line identifier
176 | p_khr_id IN Contract Header identifier
177 | p_sale_price IN Disposition Amount
178 |
179 | KNOWN ISSUES
180 |
181 | NOTES
182 |
183 | MODIFICATION HISTORY
184 | Date Author Description of Changes
185 | DD-MON-YYYY Name Bug #####, modified amount ..
186 | 09-OCT-2003 MDokal Created.
187 | 24-Sep-2004 rmunjulu 3910833 Set p_ia_id as parameter
188 | 06-Oct-2004 rmunjulu EDAT Added Parameters to get transaction
189 | date and effective date and do processing
190 | based on those
191 |
192 *=======================================================================*/
193 PROCEDURE disburse_investor_rv(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_khr_id IN NUMBER,
200 p_kle_id IN NUMBER,
201 p_ia_id IN NUMBER, -- rmunjulu 3910833
202 p_effective_date IN DATE DEFAULT NULL, -- rmunjulu EDAT
203 p_transaction_date IN DATE DEFAULT NULL, -- rmunjulu EDAT
204 p_sale_price IN NUMBER );
205
206 /*========================================================================
207 | PUBLIC PROCEDURE CREATE_POOL_TRANSACTION
208 |
209 | DESCRIPTION
210 | Create the pool transaction and makes pool modifications
211 |
212 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
213 | Called from PROCESS_SECURITIZED_STREAMS
214 |
215 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
216 |
217 | PARAMETERS
218 | p_api_version IN Standard in parameter
219 | p_init_msg_list IN Standard in parameter
220 | x_return_status OUT Standard out parameter
221 | x_msg_count OUT Standard out parameter
222 | x_msg_data OUT Standard out parameter
223 | p_asset_tbl IN Contains a list of assets for pool transactions
224 | p_transaction_reason IN Reason required for creating pool transaction
225 | p_kle_id IN Asset for pool transaction
226 | p_khr_id IN Contract for pool transaction
227 | p_disb_type IN Identifies the subclass, RESIDUAL or RENT
228 |
229 | KNOWN ISSUES
230 |
231 | NOTES
232 |
233 | MODIFICATION HISTORY
234 | Date Author Description of Changes
235 | DD-MON-YYYY Name Bug #####, modified amount ..
236 | 09-OCT-2003 MDokal Created.
237 | 06-Oct-2004 rmunjulu EDAT Added Parameters to get transaction
238 | date and effective date and do processing
239 | based on those
240 |
241 *=======================================================================*/
242 PROCEDURE create_pool_transaction(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_asset_tbl IN asset_tbl_type,
249 p_transaction_reason IN VARCHAR2,
250 p_khr_id IN NUMBER,
251 p_kle_id IN NUMBER,
252 p_effective_date IN DATE DEFAULT NULL, -- rmunjulu EDAT
253 p_transaction_date IN DATE DEFAULT NULL, -- rmunjulu EDAT
254 p_disb_type IN VARCHAR2);
255
256 /* sosharma 17-01-2008
257 modifications to include loans in Investor agreement
258 Start Changes
259 */
260
261 PROCEDURE disburse_investor_loan_payment(
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_ia_id IN NUMBER,
268 p_effective_date IN DATE DEFAULT NULL,
269 p_transaction_date IN DATE DEFAULT NULL,
270 p_asset_tbl IN asset_tbl_type);
271
272 /* sosharma end changes*/
273
274
275 END OKL_AM_SECURITIZATION_PVT;