[Home] [Help]
PACKAGE: APPS.OKL_CREATE_STREAMS_PVT
Source
1 PACKAGE Okl_Create_Streams_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRCSMS.pls 120.11.12010000.5 2009/08/10 14:37:36 rgooty ship $ */
3 ------------------------------------------------------------------------------
4 -- Global Variables
5 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
6 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
7 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
9 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
10 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
11 G_EXCEPTION_ERROR EXCEPTION;
12 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
13 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREATE_STREAMS_PVT';
15 G_OKC_APP CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16 G_NO_DATA_FOUND CONSTANT VARCHAR2(200) := 'OKL_NOT_FOUND';
17 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
21 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
22 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
23 G_OKL_CSM_PENDING CONSTANT VARCHAR2(15) := 'OKL_CSM_PENDING';
24 G_OKL_MULTIPLE_TARGET_VALUES CONSTANT VARCHAR2(26) := 'OKL_MULTIPLE_TARGET_VALUES';
25 G_SIS_HDR_INSERTED CONSTANT VARCHAR2(20) := 'HDR_INSERTED';
26 G_SIS_DATA_ENTERED CONSTANT VARCHAR2(20) := 'DATA_ENTERED';
27 G_SIS_PROCESS_COMPLETE CONSTANT VARCHAR2(20) := 'PROCESS_COMPLETE';
28 G_SIS_PROCESSING_FAILED CONSTANT VARCHAR2(20) := 'PROCESSING_FAILED';
29 G_SIS_PROCESSING_REQUEST CONSTANT VARCHAR2(20) := 'PROCESSING_REQUEST';
30 G_SIS_PROCESS_ABORTED CONSTANT VARCHAR2(20) := 'PROCESS_ABORTED';
31 G_SIS_SERVER_NA CONSTANT VARCHAR2(20) := 'SERVER_NA';
32 G_SIS_TIME_OUT CONSTANT VARCHAR2(20) := 'TIME_OUT';
33 G_SIS_PROCESS_COMPLETE_ERRORS CONSTANT VARCHAR2(30) := 'PROCESS_COMPLETE_ERRORS';
34 G_SIS_RET_DATA_RECEIVED CONSTANT VARCHAR2(30) := 'RET_DATA_RECEIVED';
35 G_CURRENT_STREAM CONSTANT VARCHAR2(10) := 'CURR';
36 G_SFE_TYPE_ONE_OFF CONSTANT VARCHAR2(30) := OKL_SFE_PVT.G_SFE_TYPE_ONE_OFF;
37 G_SFE_TYPE_PERIODIC_EXPENSE CONSTANT VARCHAR2(30) := OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_EXPENSE;
38 G_SFE_TYPE_RENT CONSTANT VARCHAR2(30) := OKL_SFE_PVT.G_SFE_TYPE_RENT;
39 G_SFE_TYPE_PERIODIC_INCOME CONSTANT VARCHAR2(30) := OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME;
40 G_SFE_TYPE_LOAN CONSTANT VARCHAR2(30) := OKL_SFE_PVT.G_SFE_TYPE_LOAN;
41 --smahapat for fee type soln
42 G_SFE_TYPE_SECURITY_DEPOSIT CONSTANT VARCHAR2(30) := OKL_SFE_PVT.G_SFE_TYPE_SECURITY_DEPOSIT;
43 ---SGORANTL ADDED FOR SUBSIDY
44 G_SFE_TYPE_SUBSIDY CONSTANT VARCHAR2(30) := OKL_SFE_PVT.G_SFE_TYPE_SUBSIDY;
45 G_SIL_TYPE_LEASE CONSTANT VARCHAR2(10) := Okl_Sil_Pvt.G_SIL_TYPE_LEASE;
46 G_SIL_TYPE_LOAN CONSTANT VARCHAR2(10) := Okl_Sil_Pvt.G_SIL_TYPE_LOAN;
47 -- mvasudev , sno changes
48 G_SIY_TYPE_YIELD CONSTANT VARCHAR2(3) := OKL_SIY_PVT.G_SIY_TYPE_YIELD;
49 G_SIY_TYPE_INTEREST_RATE CONSTANT VARCHAR2(3) := OKL_SIY_PVT.G_SIY_TYPE_INTEREST_RATE;
50 G_EXPENSE CONSTANT VARCHAR2(10) := 'EXPENSE';
51 G_INCOME CONSTANT VARCHAR2(10) := 'INCOME';
52 G_ADVANCE CONSTANT VARCHAR2(10) := 'ADVANCE';
53 G_ARREARS CONSTANT VARCHAR2(10) := 'ARREARS';
54 G_FND_YES CONSTANT VARCHAR2(1) := 'Y';
55 G_FND_NO CONSTANT VARCHAR2(1) := 'N';
56 G_CSM_TRUE CONSTANT VARCHAR2(10) := 'true';
57 G_CSM_FALSE CONSTANT VARCHAR2(10) := 'false';
58 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
59 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
60 G_ORP_CODE_BOOKING CONSTANT VARCHAR2(4) := 'AUTH';
61 G_ORP_CODE_RESTRUCTURE_AM CONSTANT VARCHAR2(4) := 'RSAM';
62 G_ORP_CODE_RESTRUCTURE_CS CONSTANT VARCHAR2(4) := 'RSCS';
63 G_ORP_CODE_UPGRADE CONSTANT VARCHAR2(10) := 'UPGRADE';
64 -- mvasudev , sno, changed "QUOT" to "QUOTE"
65 G_ORP_CODE_QUOTE CONSTANT VARCHAR2(4) := 'QUOT';
66 G_ORP_CODE_VARIABLE_INTEREST CONSTANT VARCHAR2(4) := 'VIRP';
67 G_ORP_CODE_RENEWAL CONSTANT VARCHAR2(4) := 'RENW';
68 -- 04/26/2002 -- mvasudev
69 /*
70 -- Commenting in favor of referring to OKL_INVOKE_PRICING_ENGINE_PVT directly
71 G_XMLG_TRX_TYPE CONSTANT VARCHAR2(30) := OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_TYPE;
72 G_XMLG_TRX_SUBTYPE_LEASE_BOOK CONSTANT VARCHAR2(30) := OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LEASE_BOOK;
73 G_XMLG_TRX_SUBTYPE_LOAN_BOOK CONSTANT VARCHAR2(30) := OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LOAN_BOOK;
74 G_XMLG_TRX_SUBTYPE_LEASE_RESTR CONSTANT VARCHAR2(30) := OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LEASE_RESTR;
75 G_XMLG_TRX_SUBTYPE_LOAN_RESTR CONSTANT VARCHAR2(30) := OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LOAN_RESTR;
76 */
77 -- end,04/26/2002 -- mvasudev
78 G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := 'AMOUNT';
79 G_LOCK_RATE CONSTANT VARCHAR2(10) := 'RATE';
80 G_LOCK_BOTH CONSTANT VARCHAR2(10) := 'BOTH';
81 G_MODE_LESSOR CONSTANT VARCHAR2(10) := 'LESSOR';
82 G_MODE_LENDER CONSTANT VARCHAR2(10) := 'LENDER';
83 G_MODE_BOTH CONSTANT VARCHAR2(10) := 'BOTH';
84 G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := 'PAYMENT';
85 G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := 'INTEREST';
86 G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := 'PRINCIPAL';
87 G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := 'FUNDING';
88 -- added akjain 07/26
89 G_ADJUST CONSTANT VARCHAR2(10) := 'Rent';
90 -- changed smahapat bug 4170057
91 G_ADJUST_LOAN CONSTANT VARCHAR2(30) := 'Loan: payments => rates';
92 G_ADJUSTMENT_METHOD CONSTANT VARCHAR2(20) := 'Proportional';
93 G_AK_REGION_NAME CONSTANT VARCHAR2(40) := 'OKL_LP_CREATE_STREAMS';
94 -- smahapat multi-gaap 11/10/02 addition
95 G_PURPOSE_CODE_REPORT CONSTANT VARCHAR2(10) := 'REPORT';
96 ------------------------------------------------------------------------------
97 --kthiruva VR build
98 G_BALANCE_RATE CONSTANT VARCHAR2(20) := 'BALANCE_RATE';
99 G_BALANCE_PAYMENT CONSTANT VARCHAR2(20) := 'BALANCE_PAYMENT';
100 G_BALANCE_TERM CONSTANT VARCHAR2(20) := 'BALANCE_TERM';
101 G_BALANCE_FUNDING CONSTANT VARCHAR2(20) := 'BALANCE_FUNDING';
102 G_PAYDOWN_TYPE_PPD CONSTANT VARCHAR2(20) := 'PPD';
103 G_PAYDOWN_TYPE_LPD CONSTANT VARCHAR2(20) := 'LPD';
104
105 --gboomina added for Bug 4659724
106 G_OKL_INT_PRIC_RESTR_NA CONSTANT VARCHAR2(30) := 'OKL_INT_PRICING_RESTR_QUOTE_NA' ;
107
108 SUBTYPE sifv_rec_type IS Okl_Stream_Interfaces_Pub.sifv_rec_type;
109 SUBTYPE sifv_tbl_type IS Okl_Stream_Interfaces_Pub.sifv_tbl_type;
110 SUBTYPE silv_rec_type IS Okl_Sif_Lines_Pub.silv_rec_type;
111 SUBTYPE silv_tbl_type IS Okl_Sif_Lines_Pub.silv_tbl_type;
112 SUBTYPE sfev_rec_type IS Okl_Sif_Fees_Pub.sfev_rec_type;
113 SUBTYPE sfev_tbl_type IS Okl_Sif_Fees_Pub.sfev_tbl_type;
114 SUBTYPE siyv_rec_type IS Okl_Sif_Yields_Pub.siyv_rec_type;
115 SUBTYPE siyv_tbl_type IS Okl_Sif_Yields_Pub.siyv_tbl_type;
116 SUBTYPE sitv_rec_type IS Okl_Sif_Stream_Types_Pub.sitv_rec_type;
117 SUBTYPE sitv_tbl_type IS Okl_Sif_Stream_Types_Pub.sitv_tbl_type;
118 /* ONE OFF FEES */
119 /*
120 -- One-off Fees (Single or Multiple ) can occur both at Header as well as Line Levels
121 -- In the abscence of "KLE_ID" it is assumed to be in the Header
122 -- else it will be assigned to the corresponding KLE_ID / Line
123 */
124 TYPE csm_one_off_fee_rec_type IS RECORD(
125 description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126 ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127 ,amount NUMBER := OKC_API.G_MISS_NUM
128 ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129 ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130 ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131 ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132 ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133 ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134 -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
135 ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
136 ,other_type_id NUMBER := OKC_API.G_MISS_NUM --SGORANTL ADDED FOR subsidy
137 ,other_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR subsidy
138 ,rate NUMBER := OKC_API.G_MISS_NUM
139 -- add reference to the external ID
140 ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
141 );
142
143 TYPE csm_one_off_fee_tbl_type IS TABLE OF csm_one_off_fee_rec_type
144 INDEX BY BINARY_INTEGER;
145 /* PERIODIC FEES */
146 /*
147 -- Periodic Fees (Always Multiple) can occur both at Header as well as Line Levels
148 -- In the abscence of "KLE_ID" it is assumed to be in the Header
149 -- else it will be assigned to the corresponding KLE_ID / Line
150 */
151 TYPE csm_periodic_expenses_rec_type IS RECORD(
152 -- Common Details
153 description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
154 ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE --smahapat fee type soln interpreted as en accrual for stub payment
155 ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
156 -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157 ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
158 -- Per-Record Details
159 ,level_index_number NUMBER := OKC_API.G_MISS_NUM
160 ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161 ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162 ,amount NUMBER := OKC_API.G_MISS_NUM
163 ,rate NUMBER := OKC_API.G_MISS_NUM
164 ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165 ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166 ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167 ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168 ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169 -- 04/29/2002, mvasudev
170 -- added for "Restructure" requirements
171 ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172 -- 06/13/2002
173 ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174 ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175 ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176 ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177 ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178 ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179 ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
180 -- add reference to the external ID
181 ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
182 );
183 TYPE csm_periodic_expenses_tbl_type IS TABLE OF csm_periodic_expenses_rec_type
184 INDEX BY BINARY_INTEGER;
185 /* Stream Types*/
186 TYPE csm_yields_rec_type IS RECORD(
187 yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
188 method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
189 array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190 roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
191 roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
192 compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
193 target_value NUMBER := OKC_API.G_MISS_NUM,
194 nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
195 -- 04/29/2002, mvasudev
196 -- added for "Restructure" requirements
197 pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
198 -- 06/24/2002, mvasudev
199 -- added for "sno" requirements
200 siy_type OKL_SIF_YIELDS_V.SIY_TYPE%TYPE := OKC_API.G_MISS_CHAR
201 );
202 TYPE csm_yields_tbl_type IS TABLE OF csm_yields_rec_type
203 INDEX BY BINARY_INTEGER;
204 /* Stream Types*/
205 TYPE csm_stream_types_rec_type IS RECORD(
206 stream_type_id NUMBER := OKC_API.G_MISS_NUM
207 ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
208 ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
209 ,pricing_name OKL_SIF_STREAM_TYPES_V.PRICING_NAME%type := OKC_API.G_MISS_CHAR
210 );
211 TYPE csm_stream_types_tbl_type IS TABLE OF csm_stream_types_rec_type
212 INDEX BY BINARY_INTEGER;
213 /* -- "Lease" Specific Definitions -- */
214 /* Line Level Details Record */
215 TYPE csm_line_details_rec_type IS RECORD(
216 kle_asset_id NUMBER := OKC_API.G_MISS_NUM
217 ,state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
218 ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219 ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220 ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221 ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222 ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223 ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224 ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225 ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226 ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227 ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228 ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229 ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230 ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231 ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232 ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233 ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234 ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235 ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236 ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237 ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238 ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239 ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240 ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241 ,book_term NUMBER := OKC_API.G_MISS_NUM
242 ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243 ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244 ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245 ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246 ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247 ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248 -- stream_interface_attribute01 => guarantee_type
249 ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250 ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
251 ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
252 -- add reference to the external ID
253 ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
254 );
255 TYPE csm_line_details_tbl_type IS TABLE OF csm_line_details_rec_type
256 INDEX BY BINARY_INTEGER;
257 /* Lease Type - Header */
258 TYPE csm_lease_rec_type IS RECORD(
259 -- Common Details
260 jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
261 ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262 ,khr_id NUMBER := OKC_API.G_MISS_NUM
263 ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264 ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265 ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266 ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267 ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268 ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269 ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270 ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271 ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272 ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273 ,term NUMBER := OKC_API.G_MISS_NUM
274 ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275 -- Lease Type Details
276 ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277 ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278 ,implicit_interest_rate NUMBER DEFAULT NULL
279 ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280 ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
281 -- mvasudev, Bug#2650599
282 ,sif_id NUMBER := OKC_API.G_MISS_NUM
283 ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
284 -- end, mvasudev, Bug#2650599
285 );
286 -- 04/21/2002
287 /* Loan Lines */
288 TYPE csm_loan_line_rec_type IS RECORD(
289 kle_loan_id NUMBER := OKC_API.G_MISS_NUM
290 --Added by kthiruva on 15-Nov-2005 for the Down Payment CR
291 --Bug 4738011 - Start of Changes
292 ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
293 ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
294 ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
295 --Bug 4738011 - End of Changes
296 );
297 TYPE csm_loan_line_tbl_type IS TABLE OF csm_loan_line_rec_type
298 INDEX BY BINARY_INTEGER;
299 /* Loan Levels */
300 TYPE csm_loan_level_rec_type IS RECORD(
301 -- Common Details
302 description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
303 ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE
304 ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305 -- Per-Record Details
306 ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307 ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308 ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309 ,amount NUMBER := OKC_API.G_MISS_NUM
310 ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311 ,rate NUMBER := OKC_API.G_MISS_NUM
312 ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313 ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314 ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315 -- 06/13/2002
316 ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317 -- added for "Restructure" requirements akjain 08/20/02
318 ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319 ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320 ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321 ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322 ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
323 -- add reference to external id
324 ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
325 );
326 TYPE csm_loan_level_tbl_type IS TABLE OF csm_loan_level_rec_type
327 INDEX BY BINARY_INTEGER;
328 -- end,04/21/2002
329 /* Loan Type - Header */
330 TYPE csm_loan_rec_type IS RECORD(
331 -- Common Details
332 jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
333 ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334 ,khr_id NUMBER := OKC_API.G_MISS_NUM
335 ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336 ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337 ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338 ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339 ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340 ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341 ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342 -- Loan Type Details
343 ,total_lending NUMBER := OKC_API.G_MISS_NUM
344 ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
345 ,lending_rate NUMBER DEFAULT NULL
346 -- mvasudev, Bug#2650599
347 ,sif_id NUMBER := OKC_API.G_MISS_NUM
348 ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
349 -- end, mvasudev, Bug#2650599
350 -- added for Loan Quote requirements smahapat 10/30/03
351 ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
352 ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
353 );
354 /* For Fees and Asset Index */
355 TYPE index_rec_type IS RECORD
356 (
357 id NUMBER,
358 idx NUMBER
359 );
360 TYPE index_tbl_type IS TABLE OF index_rec_type INDEX BY BINARY_INTEGER;
361 g_asset_ids index_tbl_type;
362 /* For Perioidic Expenses Index */
363 TYPE periodic_index_rec_type IS RECORD
364 (
365 description VARCHAR2(1995),
366 idx NUMBER
367 );
368 TYPE periodic_index_tbl_type IS TABLE OF periodic_index_rec_type INDEX BY BINARY_INTEGER;
369 g_periodic_expenses_indexes periodic_index_tbl_type;
370 g_periodic_incomes_indexes periodic_index_tbl_type;
371 g_rents_indexes periodic_index_tbl_type;
372 g_siy_names periodic_index_tbl_type;
373 /* For Cross-Referencing SFE IDs with corresponding KLE Fee IDs*/
374 TYPE sfe_id_rec_type IS RECORD
375 (
376 kle_fee_id NUMBER,
377 sfe_id NUMBER,
378 stream_type_id NUMBER -- smahapat added for fee type solution
379 );
380 TYPE sfe_id_tbl_type IS TABLE OF sfe_id_rec_type INDEX BY BINARY_INTEGER;
381 g_sfe_ids sfe_id_tbl_type;
382 /* For Cross-Referencing SIL IDs with corresponding KLE Asset IDs*/
383 TYPE sil_id_rec_type IS RECORD
384 (
385 kle_asset_id NUMBER,
386 sil_id NUMBER
387 );
388 TYPE sil_id_tbl_type IS TABLE OF sil_id_rec_type INDEX BY BINARY_INTEGER;
389 g_sil_ids sil_id_tbl_type;
390 -- Procedure to Create Streams for Lease Type Contract
391 PROCEDURE Create_Streams_Lease_Book (
392 p_api_version IN NUMBER
393 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
394 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
395 ,p_csm_lease_header IN csm_lease_rec_type
396 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
397 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
398 ,p_csm_yields_tbl IN csm_yields_tbl_type
399 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
400 ,p_csm_line_details_tbl IN csm_line_details_tbl_type
401 ,p_rents_tbl IN csm_periodic_expenses_tbl_type
402 ,x_trans_id OUT NOCOPY NUMBER
403 ,x_trans_status OUT NOCOPY VARCHAR2
404 ,x_return_status OUT NOCOPY VARCHAR2
405 ,x_msg_count OUT NOCOPY NUMBER
406 ,x_msg_data OUT NOCOPY VARCHAR2
407 );
408 -- Procedure to Create Streams for Loan Type Contract
409 PROCEDURE Create_Streams_Loan_Book (
410 p_api_version IN NUMBER
411 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
412 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
413 ,p_csm_loan_header IN csm_loan_rec_type
414 -- 04/21/2002
415 ,p_csm_loan_lines_tbl IN csm_loan_line_tbl_type
416 ,p_csm_loan_levels_tbl IN csm_loan_level_tbl_type
417 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
418 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
419 -- end, 04/21/2002
420 ,p_csm_yields_tbl IN csm_yields_tbl_type
421 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
422 ,x_trans_id OUT NOCOPY NUMBER
423 ,x_trans_status OUT NOCOPY VARCHAR2
424 ,x_return_status OUT NOCOPY VARCHAR2
425 ,x_msg_count OUT NOCOPY NUMBER
426 ,x_msg_data OUT NOCOPY VARCHAR2
427
428 );
429 PROCEDURE Invoke_Pricing_Engine(
430 p_api_version IN NUMBER
431 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
432 ,p_sifv_rec IN sifv_rec_type
433 ,x_sifv_rec OUT NOCOPY sifv_rec_type
434 ,x_return_status OUT NOCOPY VARCHAR2
435 ,x_msg_count OUT NOCOPY NUMBER
436 ,x_msg_data OUT NOCOPY VARCHAR2
437 );
438
439 -- 04/30/2002
440 -- Procedure to Create Streams for Lease Type Contract - Restructure
441 PROCEDURE Create_Streams_Lease_Restr (
442 p_api_version IN NUMBER
443 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
444 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
445 ,p_csm_lease_header IN csm_lease_rec_type
446 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
447 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
448 ,p_csm_yields_tbl IN csm_yields_tbl_type
449 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
450 ,p_csm_line_details_tbl IN csm_line_details_tbl_type
451 ,p_rents_tbl IN csm_periodic_expenses_tbl_type
452 ,x_trans_id OUT NOCOPY NUMBER
453 ,x_trans_status OUT NOCOPY VARCHAR2
454 ,x_return_status OUT NOCOPY VARCHAR2
455 ,x_msg_count OUT NOCOPY NUMBER
456 ,x_msg_data OUT NOCOPY VARCHAR2
457 );
458 -- Procedure to Create Streams for Loan Type Contract
459
460 PROCEDURE Create_Streams_Loan_Restr (
461 p_api_version IN NUMBER
462 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
463 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
464 ,p_csm_loan_header IN csm_loan_rec_type
465 ,p_csm_loan_lines_tbl IN csm_loan_line_tbl_type
466 ,p_csm_loan_levels_tbl IN csm_loan_level_tbl_type
467 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
468 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
469 ,p_csm_yields_tbl IN csm_yields_tbl_type
470 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
471 ,x_trans_id OUT NOCOPY NUMBER
472 ,x_trans_status OUT NOCOPY VARCHAR2
473 ,x_return_status OUT NOCOPY VARCHAR2
474 ,x_msg_count OUT NOCOPY NUMBER
475 ,x_msg_data OUT NOCOPY VARCHAR2
476 );
477 -- end, 04/30/2002
478 -- Procedure to Create Streams for Quote
479 PROCEDURE Create_Streams_Lease_Quote (
480 p_api_version IN NUMBER
481 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
482 ,p_skip_prc_engine IN VARCHAR2 DEFAULT G_FALSE
483 ,p_csm_lease_header IN csm_lease_rec_type
484 ,p_csm_one_off_fee_tbl IN csm_one_off_fee_tbl_type
485 ,p_csm_periodic_expenses_tbl IN csm_periodic_expenses_tbl_type
486 ,p_csm_yields_tbl IN csm_yields_tbl_type
487 ,p_csm_stream_types_tbl IN csm_stream_types_tbl_type
488 ,p_csm_line_details_tbl IN csm_line_details_tbl_type
489 ,p_rents_tbl IN csm_periodic_expenses_tbl_type
490 ,x_trans_id OUT NOCOPY NUMBER
491 ,x_trans_status OUT NOCOPY VARCHAR2
492 ,x_return_status OUT NOCOPY VARCHAR2
493 ,x_msg_count OUT NOCOPY NUMBER
494 ,x_msg_data OUT NOCOPY VARCHAR2
495 );
496
497 --kthiruva VR build
498 PROCEDURE add_balance_information(x_sfev_tbl IN OUT NOCOPY sfev_tbl_type,
499 x_return_status OUT NOCOPY VARCHAR2);
500
501 END Okl_Create_Streams_Pvt;