[Home] [Help]
PACKAGE: APPS.OKL_KLE_PVT
Source
1 Package OKL_KLE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSKLES.pls 120.6.12020000.3 2013/02/21 21:19:57 rpillay ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6
7 TYPE kle_rec_type IS RECORD (
8 ID NUMBER := OKL_API.G_MISS_NUM,
9 KLE_ID NUMBER := OKL_API.G_MISS_NUM,
10 STY_ID NUMBER := OKL_API.G_MISS_NUM,
11 OBJECT_VERSION_NUMBER NUMBER := OKL_API.G_MISS_NUM,
12 LAO_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
13 FEE_CHARGE NUMBER := OKL_API.G_MISS_NUM,
14 TITLE_DATE OKL_K_LINES.TITLE_DATE%TYPE := OKL_API.G_MISS_DATE,
15 DATE_RESIDUAL_LAST_REVIEW OKL_K_LINES.DATE_RESIDUAL_LAST_REVIEW%TYPE := OKL_API.G_MISS_DATE,
16 DATE_LAST_REAMORTISATION OKL_K_LINES.DATE_LAST_REAMORTISATION%TYPE := OKL_API.G_MISS_DATE,
17 TERMINATION_PURCHASE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
18 DATE_LAST_CLEANUP OKL_K_LINES.DATE_LAST_CLEANUP%TYPE := OKL_API.G_MISS_DATE,
19 REMARKETED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
20 DATE_REMARKETED OKL_K_LINES.DATE_REMARKETED%TYPE := OKL_API.G_MISS_DATE,
21 REMARKET_MARGIN NUMBER := OKL_API.G_MISS_NUM,
22 REPURCHASED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
23 DATE_REPURCHASED OKL_K_LINES.DATE_REPURCHASED%TYPE := OKL_API.G_MISS_DATE,
24 GAIN_LOSS NUMBER := OKL_API.G_MISS_NUM,
25 FLOOR_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
26 PREVIOUS_CONTRACT OKL_K_LINES.PREVIOUS_CONTRACT%TYPE := OKL_API.G_MISS_CHAR,
27 TRACKED_RESIDUAL NUMBER := OKL_API.G_MISS_NUM,
28 DATE_TITLE_RECEIVED OKL_K_LINES.DATE_TITLE_RECEIVED%TYPE := OKL_API.G_MISS_DATE,
29 ESTIMATED_OEC NUMBER := OKL_API.G_MISS_NUM,
30 RESIDUAL_PERCENTAGE NUMBER := OKL_API.G_MISS_NUM,
31 CAPITAL_REDUCTION NUMBER := OKL_API.G_MISS_NUM,
32 VENDOR_ADVANCE_PAID NUMBER := OKL_API.G_MISS_NUM,
33 TRADEIN_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
34 DELIVERED_DATE OKL_K_LINES.DELIVERED_DATE%TYPE := OKL_API.G_MISS_DATE,
35 YEAR_OF_MANUFACTURE OKL_K_LINES.YEAR_OF_MANUFACTURE%TYPE := OKL_API.G_MISS_CHAR,
36 INITIAL_DIRECT_COST NUMBER := OKL_API.G_MISS_NUM,
37 OCCUPANCY NUMBER := OKL_API.G_MISS_NUM,
38 DATE_LAST_INSPECTION OKL_K_LINES.DATE_LAST_INSPECTION%TYPE := OKL_API.G_MISS_DATE,
39 DATE_NEXT_INSPECTION_DUE OKL_K_LINES.DATE_NEXT_INSPECTION_DUE%TYPE := OKL_API.G_MISS_DATE,
40 WEIGHTED_AVERAGE_LIFE NUMBER := OKL_API.G_MISS_NUM,
41 BOND_EQUIVALENT_YIELD NUMBER := OKL_API.G_MISS_NUM,
42 REFINANCE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
43 YEAR_BUILT NUMBER := OKL_API.G_MISS_NUM,
44 COVERAGE_RATIO NUMBER := OKL_API.G_MISS_NUM,
45 GROSS_SQUARE_FOOTAGE NUMBER := OKL_API.G_MISS_NUM,
46 NET_RENTABLE NUMBER := OKL_API.G_MISS_NUM,
47 DATE_LETTER_ACCEPTANCE OKL_K_LINES.DATE_LETTER_ACCEPTANCE%TYPE := OKL_API.G_MISS_DATE,
48 DATE_COMMITMENT_EXPIRATION OKL_K_LINES.DATE_COMMITMENT_EXPIRATION%TYPE := OKL_API.G_MISS_DATE,
49 DATE_APPRAISAL OKL_K_LINES.DATE_APPRAISAL%TYPE := OKL_API.G_MISS_DATE,
50 APPRAISAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
51 RESIDUAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
52 PERCENT NUMBER := OKL_API.G_MISS_NUM,
53 COVERAGE NUMBER := OKL_API.G_MISS_NUM,
54 LRV_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
55 AMOUNT NUMBER := OKL_API.G_MISS_NUM,
56 LRS_PERCENT NUMBER := OKL_API.G_MISS_NUM,
57 EVERGREEN_PERCENT NUMBER := OKL_API.G_MISS_NUM,
58 PERCENT_STAKE NUMBER := OKL_API.G_MISS_NUM,
59 AMOUNT_STAKE NUMBER := OKL_API.G_MISS_NUM,
60 DATE_SOLD OKL_K_LINES.DATE_SOLD%TYPE := OKL_API.G_MISS_DATE,
61 STY_ID_FOR NUMBER := OKL_API.G_MISS_NUM,
62 ATTRIBUTE_CATEGORY OKL_K_LINES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
63 ATTRIBUTE1 OKL_K_LINES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
64 ATTRIBUTE2 OKL_K_LINES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
65 ATTRIBUTE3 OKL_K_LINES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
66 ATTRIBUTE4 OKL_K_LINES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
67 ATTRIBUTE5 OKL_K_LINES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
68 ATTRIBUTE6 OKL_K_LINES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
69 ATTRIBUTE7 OKL_K_LINES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
70 ATTRIBUTE8 OKL_K_LINES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
71 ATTRIBUTE9 OKL_K_LINES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
72 ATTRIBUTE10 OKL_K_LINES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
73 ATTRIBUTE11 OKL_K_LINES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
74 ATTRIBUTE12 OKL_K_LINES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
75 ATTRIBUTE13 OKL_K_LINES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
76 ATTRIBUTE14 OKL_K_LINES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
77 ATTRIBUTE15 OKL_K_LINES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
78 CREATED_BY NUMBER := OKL_API.G_MISS_NUM,
79 CREATION_DATE OKL_K_LINES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
80 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
81 LAST_UPDATE_DATE OKL_K_LINES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
82 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM,
83 NTY_CODE OKL_K_LINES.NTY_CODE%TYPE := OKL_API.G_MISS_CHAR,
84 FCG_CODE OKL_K_LINES.FCG_CODE%TYPE := OKL_API.G_MISS_CHAR,
85 PRC_CODE OKL_K_LINES.PRC_CODE%TYPE := OKL_API.G_MISS_CHAR,
86 RE_LEASE_YN OKL_K_LINES.RE_LEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
87 PRESCRIBED_ASSET_YN OKL_K_LINES.PRESCRIBED_ASSET_YN%TYPE := OKL_API.G_MISS_CHAR,
88 CREDIT_TENANT_YN OKL_K_LINES.CREDIT_TENANT_YN%TYPE := OKL_API.G_MISS_CHAR,
89 SECURED_DEAL_YN OKL_K_LINES.SECURED_DEAL_YN%TYPE := OKL_API.G_MISS_CHAR,
90 CLG_ID NUMBER := OKL_API.G_MISS_NUM,
91 DATE_FUNDING OKL_K_LINES.DATE_FUNDING%TYPE := OKL_API.G_MISS_DATE,
92 DATE_FUNDING_REQUIRED OKL_K_LINES.DATE_FUNDING_REQUIRED%TYPE := OKL_API.G_MISS_DATE,
93 DATE_ACCEPTED OKL_K_LINES.DATE_ACCEPTED%TYPE := OKL_API.G_MISS_DATE,
94 DATE_DELIVERY_EXPECTED OKL_K_LINES.DATE_DELIVERY_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
95 OEC NUMBER := OKL_API.G_MISS_NUM,
96 CAPITAL_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
97 RESIDUAL_GRNTY_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
98 RESIDUAL_CODE OKL_K_LINES.RESIDUAL_CODE%TYPE := OKL_API.G_MISS_CHAR,
99 RVI_PREMIUM NUMBER := OKL_API.G_MISS_NUM,
100 CREDIT_NATURE OKL_K_LINES.CREDIT_NATURE%TYPE := OKL_API.G_MISS_CHAR,
101 CAPITALIZED_INTEREST NUMBER := OKL_API.G_MISS_NUM,
102 CAPITAL_REDUCTION_PERCENT NUMBER := OKL_API.G_MISS_NUM,
103 --Bug# 2697681 11.5.9
104 DATE_PAY_INVESTOR_START OKL_K_LINES.DATE_PAY_INVESTOR_START%TYPE := OKL_API.G_MISS_DATE,
105 PAY_INVESTOR_FREQUENCY OKL_K_LINES.PAY_INVESTOR_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
106 PAY_INVESTOR_EVENT OKL_K_LINES.PAY_INVESTOR_EVENT%TYPE := OKL_API.G_MISS_CHAR,
107 PAY_INVESTOR_REMITTANCE_DAYS NUMBER := OKL_API.G_MISS_NUM,
108 FEE_TYPE OKL_K_LINES.FEE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
109 --Bug# 3143522 :11.5.10
110 --subsidy
111 SUBSIDY_ID NUMBER := OKL_API.G_MISS_NUM,
112 --SUBSIDIZED_OEC NUMBER := OKL_API.G_MISS_NUM,
113 --SUBSIDIZED_CAP_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
114 SUBSIDY_OVERRIDE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
115 --financed fee
116 PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
117 AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
118 IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
119 IMPLICIT_NON_IDC_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
120 PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
121 AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
122 --quote
123 SUB_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
124 SUB_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
125 SUB_IMPL_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
126 SUB_IMPL_NON_IDC_INT_RATE NUMBER := OKL_API.G_MISS_NUM,
127 SUB_PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
128 SUB_AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
129 --Bug# 2994971
130 ITEM_INSURANCE_CATEGORY NUMBER := OKL_API.G_MISS_NUM,
131 --Bug# 3973640 :11.5.10+
132 QTE_ID NUMBER := OKL_API.G_MISS_NUM,
133 FUNDING_DATE OKL_K_LINES.FUNDING_DATE%TYPE := OKL_API.G_MISS_DATE,
134 STREAM_TYPE_SUBCLASS OKL_K_LINES.STREAM_TYPE_SUBCLASS%TYPE := OKL_API.G_MISS_CHAR,
135 --Bug#4419339
136 DATE_FUNDING_EXPECTED OKL_K_LINES.DATE_FUNDING_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
137 MANUFACTURER_NAME OKL_K_LINES.MANUFACTURER_NAME%TYPE := OKL_API.G_MISS_CHAR,
138 MODEL_NUMBER OKL_K_LINES.MODEL_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
139 DOWN_PAYMENT_RECEIVER_CODE OKL_K_LINES.DOWN_PAYMENT_RECEIVER_CODE%TYPE := OKL_API.G_MISS_CHAR,
140 CAPITALIZE_DOWN_PAYMENT_YN OKL_K_LINES.CAPITALIZE_DOWN_PAYMENT_YN%TYPE := OKL_API.G_MISS_CHAR,
141 --Bug#4373029
142 FEE_PURPOSE_CODE OKL_K_LINES.FEE_PURPOSE_CODE%TYPE := OKL_API.G_MISS_CHAR,
143 TERMINATION_VALUE NUMBER := OKL_API.G_MISS_NUM,
144 --Bug# 4631549
145 EXPECTED_ASSET_COST NUMBER := OKL_API.G_MISS_NUM,
146 ORIG_CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM,
147 --Added by JJUNEJA
148 ORIGINATION_INCOME NUMBER := OKL_API.G_MISS_NUM,
149 --ENd of addition by JJUNEJA
150 AMOUNT_BALANCE_LEGACY NUMBER := OKL_API.G_MISS_NUM,
151 DT_EFFECTIVE_BALANCE_LEGACY OKL_K_LINES.DT_EFFECTIVE_BALANCE_LEGACY%TYPE := OKL_API.G_MISS_DATE
152 );
153
154 g_miss_kle_rec kle_rec_type;
155
156 TYPE kle_tbl_type IS TABLE OF kle_rec_type INDEX BY BINARY_INTEGER;
157
158 TYPE okl_k_lines_h_rec_type IS RECORD (
159 ID NUMBER := OKL_API.G_MISS_NUM,
160 MAJOR_VERSION NUMBER := OKL_API.G_MISS_NUM,
161 KLE_ID NUMBER := OKL_API.G_MISS_NUM,
162 STY_ID NUMBER := OKL_API.G_MISS_NUM,
163 OBJECT_VERSION_NUMBER NUMBER := OKL_API.G_MISS_NUM,
164 LAO_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
165 FEE_CHARGE NUMBER := OKL_API.G_MISS_NUM,
166 TITLE_DATE OKL_K_LINES_H.TITLE_DATE%TYPE := OKL_API.G_MISS_DATE,
167 DATE_RESIDUAL_LAST_REVIEW OKL_K_LINES_H.DATE_RESIDUAL_LAST_REVIEW%TYPE := OKL_API.G_MISS_DATE,
168 DATE_LAST_REAMORTISATION OKL_K_LINES_H.DATE_LAST_REAMORTISATION%TYPE := OKL_API.G_MISS_DATE,
169 TERMINATION_PURCHASE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
170 DATE_LAST_CLEANUP OKL_K_LINES_H.DATE_LAST_CLEANUP%TYPE := OKL_API.G_MISS_DATE,
171 REMARKETED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
172 DATE_REMARKETED OKL_K_LINES_H.DATE_REMARKETED%TYPE := OKL_API.G_MISS_DATE,
173 REMARKET_MARGIN NUMBER := OKL_API.G_MISS_NUM,
174 REPURCHASED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
175 DATE_REPURCHASED OKL_K_LINES_H.DATE_REPURCHASED%TYPE := OKL_API.G_MISS_DATE,
176 GAIN_LOSS NUMBER := OKL_API.G_MISS_NUM,
177 FLOOR_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
178 PREVIOUS_CONTRACT OKL_K_LINES_H.PREVIOUS_CONTRACT%TYPE := OKL_API.G_MISS_CHAR,
179 TRACKED_RESIDUAL NUMBER := OKL_API.G_MISS_NUM,
180 DATE_TITLE_RECEIVED OKL_K_LINES_H.DATE_TITLE_RECEIVED%TYPE := OKL_API.G_MISS_DATE,
181 ESTIMATED_OEC NUMBER := OKL_API.G_MISS_NUM,
182 RESIDUAL_PERCENTAGE NUMBER := OKL_API.G_MISS_NUM,
183 CAPITAL_REDUCTION NUMBER := OKL_API.G_MISS_NUM,
184 VENDOR_ADVANCE_PAID NUMBER := OKL_API.G_MISS_NUM,
185 TRADEIN_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
186 DELIVERED_DATE OKL_K_LINES_H.DELIVERED_DATE%TYPE := OKL_API.G_MISS_DATE,
187 YEAR_OF_MANUFACTURE OKL_K_LINES_H.YEAR_OF_MANUFACTURE%TYPE := OKL_API.G_MISS_CHAR,
188 INITIAL_DIRECT_COST NUMBER := OKL_API.G_MISS_NUM,
189 OCCUPANCY NUMBER := OKL_API.G_MISS_NUM,
190 DATE_LAST_INSPECTION OKL_K_LINES_H.DATE_LAST_INSPECTION%TYPE := OKL_API.G_MISS_DATE,
191 DATE_NEXT_INSPECTION_DUE OKL_K_LINES_H.DATE_NEXT_INSPECTION_DUE%TYPE := OKL_API.G_MISS_DATE,
192 WEIGHTED_AVERAGE_LIFE NUMBER := OKL_API.G_MISS_NUM,
193 BOND_EQUIVALENT_YIELD NUMBER := OKL_API.G_MISS_NUM,
194 REFINANCE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
195 YEAR_BUILT NUMBER := OKL_API.G_MISS_NUM,
196 COVERAGE_RATIO NUMBER := OKL_API.G_MISS_NUM,
197 GROSS_SQUARE_FOOTAGE NUMBER := OKL_API.G_MISS_NUM,
198 NET_RENTABLE NUMBER := OKL_API.G_MISS_NUM,
199 DATE_LETTER_ACCEPTANCE OKL_K_LINES_H.DATE_LETTER_ACCEPTANCE%TYPE := OKL_API.G_MISS_DATE,
200 DATE_COMMITMENT_EXPIRATION OKL_K_LINES_H.DATE_COMMITMENT_EXPIRATION%TYPE := OKL_API.G_MISS_DATE,
201 DATE_APPRAISAL OKL_K_LINES_H.DATE_APPRAISAL%TYPE := OKL_API.G_MISS_DATE,
202 APPRAISAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
203 RESIDUAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
204 PERCENT NUMBER := OKL_API.G_MISS_NUM,
205 COVERAGE NUMBER := OKL_API.G_MISS_NUM,
206 LRV_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
207 AMOUNT NUMBER := OKL_API.G_MISS_NUM,
208 LRS_PERCENT NUMBER := OKL_API.G_MISS_NUM,
209 EVERGREEN_PERCENT NUMBER := OKL_API.G_MISS_NUM,
210 PERCENT_STAKE NUMBER := OKL_API.G_MISS_NUM,
211 AMOUNT_STAKE NUMBER := OKL_API.G_MISS_NUM,
212 DATE_SOLD OKL_K_LINES_H.DATE_SOLD%TYPE := OKL_API.G_MISS_DATE,
213 STY_ID_FOR NUMBER := OKL_API.G_MISS_NUM,
214 ATTRIBUTE_CATEGORY OKL_K_LINES_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
215 ATTRIBUTE1 OKL_K_LINES_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
216 ATTRIBUTE2 OKL_K_LINES_H.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
217 ATTRIBUTE3 OKL_K_LINES_H.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
218 ATTRIBUTE4 OKL_K_LINES_H.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
219 ATTRIBUTE5 OKL_K_LINES_H.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
220 ATTRIBUTE6 OKL_K_LINES_H.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
221 ATTRIBUTE7 OKL_K_LINES_H.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
222 ATTRIBUTE8 OKL_K_LINES_H.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
223 ATTRIBUTE9 OKL_K_LINES_H.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
224 ATTRIBUTE10 OKL_K_LINES_H.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
225 ATTRIBUTE11 OKL_K_LINES_H.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
226 ATTRIBUTE12 OKL_K_LINES_H.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
227 ATTRIBUTE13 OKL_K_LINES_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
228 ATTRIBUTE14 OKL_K_LINES_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
229 ATTRIBUTE15 OKL_K_LINES_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
230 CREATED_BY NUMBER := OKL_API.G_MISS_NUM,
231 CREATION_DATE OKL_K_LINES_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
232 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
233 LAST_UPDATE_DATE OKL_K_LINES_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
234 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM,
235 NTY_CODE OKL_K_LINES_H.NTY_CODE%TYPE := OKL_API.G_MISS_CHAR,
236 FCG_CODE OKL_K_LINES_H.FCG_CODE%TYPE := OKL_API.G_MISS_CHAR,
237 PRC_CODE OKL_K_LINES_H.PRC_CODE%TYPE := OKL_API.G_MISS_CHAR,
238 RE_LEASE_YN OKL_K_LINES_H.RE_LEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
239 PRESCRIBED_ASSET_YN OKL_K_LINES_H.PRESCRIBED_ASSET_YN%TYPE := OKL_API.G_MISS_CHAR,
240 CREDIT_TENANT_YN OKL_K_LINES_H.CREDIT_TENANT_YN%TYPE := OKL_API.G_MISS_CHAR,
241 SECURED_DEAL_YN OKL_K_LINES_H.SECURED_DEAL_YN%TYPE := OKL_API.G_MISS_CHAR,
242 CLG_ID NUMBER := OKL_API.G_MISS_NUM,
243 DATE_FUNDING OKL_K_LINES_H.DATE_FUNDING%TYPE := OKL_API.G_MISS_DATE,
244 DATE_FUNDING_REQUIRED OKL_K_LINES_H.DATE_FUNDING_REQUIRED%TYPE := OKL_API.G_MISS_DATE,
245 DATE_ACCEPTED OKL_K_LINES_H.DATE_ACCEPTED%TYPE := OKL_API.G_MISS_DATE,
246 DATE_DELIVERY_EXPECTED OKL_K_LINES_H.DATE_DELIVERY_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
247 OEC NUMBER := OKL_API.G_MISS_NUM,
248 CAPITAL_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
249 RESIDUAL_GRNTY_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
250 RESIDUAL_CODE OKL_K_LINES_H.RESIDUAL_CODE%TYPE := OKL_API.G_MISS_CHAR,
251 RVI_PREMIUM NUMBER := OKL_API.G_MISS_NUM,
252 CREDIT_NATURE OKL_K_LINES_H.CREDIT_NATURE%TYPE := OKL_API.G_MISS_CHAR,
253 CAPITALIZED_INTEREST NUMBER := OKL_API.G_MISS_NUM,
254 CAPITAL_REDUCTION_PERCENT NUMBER := OKL_API.G_MISS_NUM,
255 --Bug# 2697681 11.5.9
256 DATE_PAY_INVESTOR_START OKL_K_LINES_H.DATE_PAY_INVESTOR_START%TYPE := OKL_API.G_MISS_DATE,
257 PAY_INVESTOR_FREQUENCY OKL_K_LINES_H.PAY_INVESTOR_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
258 PAY_INVESTOR_EVENT OKL_K_LINES_H.PAY_INVESTOR_EVENT%TYPE := OKL_API.G_MISS_CHAR,
259 PAY_INVESTOR_REMITTANCE_DAYS NUMBER := OKL_API.G_MISS_NUM,
260 FEE_TYPE OKL_K_LINES_H.FEE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
261 --Bug# 3143522 :11.5.10
262 --subsidy
263 SUBSIDY_ID NUMBER := OKL_API.G_MISS_NUM,
264 --SUBSIDIZED_OEC NUMBER := OKL_API.G_MISS_NUM,
265 --SUBSIDIZED_CAP_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
266 SUBSIDY_OVERRIDE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
267 --financed fee
268 PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
269 AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
270 IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
271 IMPLICIT_NON_IDC_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
272 PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
273 AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
274 --quote
275 SUB_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
276 SUB_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
277 SUB_IMPL_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
278 SUB_IMPL_NON_IDC_INT_RATE NUMBER := OKL_API.G_MISS_NUM,
279 SUB_PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
280 SUB_AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
281 --Bug# 2994971
282 ITEM_INSURANCE_CATEGORY NUMBER := OKL_API.G_MISS_NUM,
283 --Bug# 3973640 :11.5.10+
284 QTE_ID NUMBER := OKL_API.G_MISS_NUM,
285 FUNDING_DATE OKL_K_LINES_H.FUNDING_DATE%TYPE := OKL_API.G_MISS_DATE,
286 STREAM_TYPE_SUBCLASS OKL_K_LINES_H.STREAM_TYPE_SUBCLASS%TYPE := OKL_API.G_MISS_CHAR,
287 --Bug#4419339
288 DATE_FUNDING_EXPECTED OKL_K_LINES_H.DATE_FUNDING_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
289 MANUFACTURER_NAME OKL_K_LINES_H.MANUFACTURER_NAME%TYPE := OKL_API.G_MISS_CHAR,
290 MODEL_NUMBER OKL_K_LINES_H.MODEL_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
291 DOWN_PAYMENT_RECEIVER_CODE OKL_K_LINES_H.DOWN_PAYMENT_RECEIVER_CODE%TYPE := OKL_API.G_MISS_CHAR,
292 CAPITALIZE_DOWN_PAYMENT_YN OKL_K_LINES_H.CAPITALIZE_DOWN_PAYMENT_YN%TYPE := OKL_API.G_MISS_CHAR,
293 --Bug#4373029
294 FEE_PURPOSE_CODE OKL_K_LINES_H.FEE_PURPOSE_CODE%TYPE := OKL_API.G_MISS_CHAR,
295 TERMINATION_VALUE NUMBER := OKL_API.G_MISS_NUM,
296 --Bug# 4631549
297 EXPECTED_ASSET_COST NUMBER := OKL_API.G_MISS_NUM,
298 ORIG_CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM,
299
300 ORIGINATION_INCOME NUMBER := OKL_API.G_MISS_NUM,
301 AMOUNT_BALANCE_LEGACY NUMBER := OKL_API.G_MISS_NUM,
302 DT_EFFECTIVE_BALANCE_LEGACY OKL_K_LINES_H.DT_EFFECTIVE_BALANCE_LEGACY%TYPE := OKL_API.G_MISS_DATE
303 );
304
305 g_miss_okl_k_lines_h_rec okl_k_lines_h_rec_type;
306
307 TYPE okl_k_lines_h_tbl_type IS TABLE OF okl_k_lines_h_rec_type INDEX BY BINARY_INTEGER;
308
309 TYPE klev_rec_type IS RECORD (
310 ID NUMBER := OKL_API.G_MISS_NUM,
311 OBJECT_VERSION_NUMBER NUMBER := OKL_API.G_MISS_NUM,
312 KLE_ID NUMBER := OKL_API.G_MISS_NUM,
313 STY_ID NUMBER := OKL_API.G_MISS_NUM,
314 PRC_CODE OKL_K_LINES_V.PRC_CODE%TYPE := OKL_API.G_MISS_CHAR,
315 FCG_CODE OKL_K_LINES_V.FCG_CODE%TYPE := OKL_API.G_MISS_CHAR,
316 NTY_CODE OKL_K_LINES_V.NTY_CODE%TYPE := OKL_API.G_MISS_CHAR,
317 ESTIMATED_OEC NUMBER := OKL_API.G_MISS_NUM,
318 LAO_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
319 TITLE_DATE OKL_K_LINES_V.TITLE_DATE%TYPE := OKL_API.G_MISS_DATE,
320 FEE_CHARGE NUMBER := OKL_API.G_MISS_NUM,
321 LRS_PERCENT NUMBER := OKL_API.G_MISS_NUM,
322 INITIAL_DIRECT_COST NUMBER := OKL_API.G_MISS_NUM,
323 PERCENT_STAKE NUMBER := OKL_API.G_MISS_NUM,
324 PERCENT NUMBER := OKL_API.G_MISS_NUM,
325 EVERGREEN_PERCENT NUMBER := OKL_API.G_MISS_NUM,
326 AMOUNT_STAKE NUMBER := OKL_API.G_MISS_NUM,
327 OCCUPANCY NUMBER := OKL_API.G_MISS_NUM,
328 COVERAGE NUMBER := OKL_API.G_MISS_NUM,
329 RESIDUAL_PERCENTAGE NUMBER := OKL_API.G_MISS_NUM,
330 DATE_LAST_INSPECTION OKL_K_LINES_V.DATE_LAST_INSPECTION%TYPE := OKL_API.G_MISS_DATE,
331 DATE_SOLD OKL_K_LINES_V.DATE_SOLD%TYPE := OKL_API.G_MISS_DATE,
332 LRV_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
333 CAPITAL_REDUCTION NUMBER := OKL_API.G_MISS_NUM,
334 DATE_NEXT_INSPECTION_DUE OKL_K_LINES_V.DATE_NEXT_INSPECTION_DUE%TYPE := OKL_API.G_MISS_DATE,
335 DATE_RESIDUAL_LAST_REVIEW OKL_K_LINES_V.DATE_RESIDUAL_LAST_REVIEW%TYPE := OKL_API.G_MISS_DATE,
336 DATE_LAST_REAMORTISATION OKL_K_LINES_V.DATE_LAST_REAMORTISATION%TYPE := OKL_API.G_MISS_DATE,
337 VENDOR_ADVANCE_PAID NUMBER := OKL_API.G_MISS_NUM,
338 WEIGHTED_AVERAGE_LIFE NUMBER := OKL_API.G_MISS_NUM,
339 TRADEIN_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
340 BOND_EQUIVALENT_YIELD NUMBER := OKL_API.G_MISS_NUM,
341 TERMINATION_PURCHASE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
342 REFINANCE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
343 YEAR_BUILT NUMBER := OKL_API.G_MISS_NUM,
344 DELIVERED_DATE OKL_K_LINES_V.DELIVERED_DATE%TYPE := OKL_API.G_MISS_DATE,
345 CREDIT_TENANT_YN OKL_K_LINES_V.CREDIT_TENANT_YN%TYPE := OKL_API.G_MISS_CHAR,
346 DATE_LAST_CLEANUP OKL_K_LINES_V.DATE_LAST_CLEANUP%TYPE := OKL_API.G_MISS_DATE,
347 YEAR_OF_MANUFACTURE OKL_K_LINES_V.YEAR_OF_MANUFACTURE%TYPE := OKL_API.G_MISS_CHAR,
348 COVERAGE_RATIO NUMBER := OKL_API.G_MISS_NUM,
349 REMARKETED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
350 GROSS_SQUARE_FOOTAGE NUMBER := OKL_API.G_MISS_NUM,
351 PRESCRIBED_ASSET_YN OKL_K_LINES_V.PRESCRIBED_ASSET_YN%TYPE := OKL_API.G_MISS_CHAR,
352 DATE_REMARKETED OKL_K_LINES_V.DATE_REMARKETED%TYPE := OKL_API.G_MISS_DATE,
353 NET_RENTABLE NUMBER := OKL_API.G_MISS_NUM,
354 REMARKET_MARGIN NUMBER := OKL_API.G_MISS_NUM,
355 DATE_LETTER_ACCEPTANCE OKL_K_LINES_V.DATE_LETTER_ACCEPTANCE%TYPE := OKL_API.G_MISS_DATE,
356 REPURCHASED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
357 DATE_COMMITMENT_EXPIRATION OKL_K_LINES_V.DATE_COMMITMENT_EXPIRATION%TYPE := OKL_API.G_MISS_DATE,
358 DATE_REPURCHASED OKL_K_LINES_V.DATE_REPURCHASED%TYPE := OKL_API.G_MISS_DATE,
359 DATE_APPRAISAL OKL_K_LINES_V.DATE_APPRAISAL%TYPE := OKL_API.G_MISS_DATE,
360 RESIDUAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
361 APPRAISAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
362 SECURED_DEAL_YN OKL_K_LINES_V.SECURED_DEAL_YN%TYPE := OKL_API.G_MISS_CHAR,
363 GAIN_LOSS NUMBER := OKL_API.G_MISS_NUM,
364 FLOOR_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
365 RE_LEASE_YN OKL_K_LINES_V.RE_LEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
366 PREVIOUS_CONTRACT OKL_K_LINES_V.PREVIOUS_CONTRACT%TYPE := OKL_API.G_MISS_CHAR,
367 TRACKED_RESIDUAL NUMBER := OKL_API.G_MISS_NUM,
368 DATE_TITLE_RECEIVED OKL_K_LINES_V.DATE_TITLE_RECEIVED%TYPE := OKL_API.G_MISS_DATE,
369 AMOUNT NUMBER := OKL_API.G_MISS_NUM,
370 ATTRIBUTE_CATEGORY OKL_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
371 ATTRIBUTE1 OKL_K_LINES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
372 ATTRIBUTE2 OKL_K_LINES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
373 ATTRIBUTE3 OKL_K_LINES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
374 ATTRIBUTE4 OKL_K_LINES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
375 ATTRIBUTE5 OKL_K_LINES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
376 ATTRIBUTE6 OKL_K_LINES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
377 ATTRIBUTE7 OKL_K_LINES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
378 ATTRIBUTE8 OKL_K_LINES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
379 ATTRIBUTE9 OKL_K_LINES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
380 ATTRIBUTE10 OKL_K_LINES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
381 ATTRIBUTE11 OKL_K_LINES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
382 ATTRIBUTE12 OKL_K_LINES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
383 ATTRIBUTE13 OKL_K_LINES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
384 ATTRIBUTE14 OKL_K_LINES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
385 ATTRIBUTE15 OKL_K_LINES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
386 STY_ID_FOR NUMBER := OKL_API.G_MISS_NUM,
387 CLG_ID NUMBER := OKL_API.G_MISS_NUM,
388 CREATED_BY NUMBER := OKL_API.G_MISS_NUM,
389 CREATION_DATE OKL_K_LINES_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
390 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
391 LAST_UPDATE_DATE OKL_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
392 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM,
393 DATE_FUNDING OKL_K_LINES_V.DATE_FUNDING%TYPE := OKL_API.G_MISS_DATE,
394 DATE_FUNDING_REQUIRED OKL_K_LINES_V.DATE_FUNDING_REQUIRED%TYPE := OKL_API.G_MISS_DATE,
395 DATE_ACCEPTED OKL_K_LINES_V.DATE_ACCEPTED%TYPE := OKL_API.G_MISS_DATE,
396 DATE_DELIVERY_EXPECTED OKL_K_LINES_V.DATE_DELIVERY_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
397 OEC NUMBER := OKL_API.G_MISS_NUM,
398 CAPITAL_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
399 RESIDUAL_GRNTY_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
400 RESIDUAL_CODE OKL_K_LINES_V.RESIDUAL_CODE%TYPE := OKL_API.G_MISS_CHAR,
401 RVI_PREMIUM NUMBER := OKL_API.G_MISS_NUM,
402 CREDIT_NATURE OKL_K_LINES_V.CREDIT_NATURE%TYPE := OKL_API.G_MISS_CHAR,
403 CAPITALIZED_INTEREST NUMBER := OKL_API.G_MISS_NUM,
404 CAPITAL_REDUCTION_PERCENT NUMBER := OKL_API.G_MISS_NUM,
405 --Bug# 2697681 11.5.9
406 DATE_PAY_INVESTOR_START OKL_K_LINES_V.DATE_PAY_INVESTOR_START%TYPE := OKL_API.G_MISS_DATE,
407 PAY_INVESTOR_FREQUENCY OKL_K_LINES_V.PAY_INVESTOR_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
408 PAY_INVESTOR_EVENT OKL_K_LINES_V.PAY_INVESTOR_EVENT%TYPE := OKL_API.G_MISS_CHAR,
409 PAY_INVESTOR_REMITTANCE_DAYS NUMBER := OKL_API.G_MISS_NUM,
410 FEE_TYPE OKL_K_LINES_V.FEE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
411 --Bug# 3143522 :11.5.10
412 --subsidy
413 SUBSIDY_ID NUMBER := OKL_API.G_MISS_NUM,
414 --SUBSIDIZED_OEC NUMBER := OKL_API.G_MISS_NUM,
415 --SUBSIDIZED_CAP_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
416 SUBSIDY_OVERRIDE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
417 --financed fee
418 PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
419 AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
420 IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
421 IMPLICIT_NON_IDC_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
422 PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
423 AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
424 --quote
425 SUB_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
426 SUB_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
427 SUB_IMPL_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
428 SUB_IMPL_NON_IDC_INT_RATE NUMBER := OKL_API.G_MISS_NUM,
429 SUB_PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
430 SUB_AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
431 --Bug# 2994971
432 ITEM_INSURANCE_CATEGORY NUMBER := OKL_API.G_MISS_NUM,
433 --Bug# 3973640 :11.5.10+
434 QTE_ID NUMBER := OKL_API.G_MISS_NUM,
435 FUNDING_DATE OKL_K_LINES_V.FUNDING_DATE%TYPE := OKL_API.G_MISS_DATE,
436 STREAM_TYPE_SUBCLASS OKL_K_LINES_V.STREAM_TYPE_SUBCLASS%TYPE := OKL_API.G_MISS_CHAR,
437 --Bug#4419339 OKLH
438 DATE_FUNDING_EXPECTED OKL_K_LINES_V.DATE_FUNDING_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
439 MANUFACTURER_NAME OKL_K_LINES_V.MANUFACTURER_NAME%TYPE := OKL_API.G_MISS_CHAR,
440 MODEL_NUMBER OKL_K_LINES_V.MODEL_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
441 DOWN_PAYMENT_RECEIVER_CODE OKL_K_LINES_V.DOWN_PAYMENT_RECEIVER_CODE%TYPE := OKL_API.G_MISS_CHAR,
442 CAPITALIZE_DOWN_PAYMENT_YN OKL_K_LINES_V.CAPITALIZE_DOWN_PAYMENT_YN%TYPE := OKL_API.G_MISS_CHAR,
443 --Bug#4373029
444 FEE_PURPOSE_CODE OKL_K_LINES_V.FEE_PURPOSE_CODE%TYPE := OKL_API.G_MISS_CHAR,
445 TERMINATION_VALUE NUMBER := OKL_API.G_MISS_NUM,
446 --Bug# 4558486
447 VALIDATE_DFF_YN VARCHAR(3) := OKL_API.G_MISS_CHAR,
448 --Bug# 4631549
449 EXPECTED_ASSET_COST NUMBER := OKL_API.G_MISS_NUM,
450 ORIG_CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM,
451 --Added by JJUNEJA
452 ORIGINATION_INCOME NUMBER := OKL_API.G_MISS_NUM,
453 --ENd of addition by JJUNEJA
454 AMOUNT_BALANCE_LEGACY NUMBER := OKL_API.G_MISS_NUM,
455 DT_EFFECTIVE_BALANCE_LEGACY OKL_K_LINES_V.DT_EFFECTIVE_BALANCE_LEGACY%TYPE := OKL_API.G_MISS_DATE
456 );
457
458 g_miss_klev_rec klev_rec_type;
459
460 TYPE klev_tbl_type IS TABLE OF klev_rec_type INDEX BY BINARY_INTEGER;
461
462 ---------------------------------------------------------------------------
463 -- GLOBAL MESSAGE CONSTANTS
464 ---------------------------------------------------------------------------
465 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
466 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
467 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
468 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
469 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
470 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
471 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
472 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
473 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
474 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
475
476 ---------------------------------------------------------------------------
477 -- GLOBAL VARIABLES
478 ---------------------------------------------------------------------------
479 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_KLE_PVT';
480 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
481
482 ---------------------------------------------------------------------------
483 -- Procedures and Functions
484 ---------------------------------------------------------------------------
485
486 PROCEDURE qc;
487 PROCEDURE change_version;
488 PROCEDURE api_copy;
489
490
491 PROCEDURE insert_row(
492
493 p_api_version IN NUMBER,
494 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
495 x_return_status OUT NOCOPY VARCHAR2,
496 x_msg_count OUT NOCOPY NUMBER,
497 x_msg_data OUT NOCOPY VARCHAR2,
498 p_klev_rec IN klev_rec_type,
499 x_klev_rec OUT NOCOPY klev_rec_type);
500
501 PROCEDURE insert_row(
502
503 p_api_version IN NUMBER,
504 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
505 x_return_status OUT NOCOPY VARCHAR2,
506 x_msg_count OUT NOCOPY NUMBER,
507 x_msg_data OUT NOCOPY VARCHAR2,
508 p_klev_tbl IN klev_tbl_type,
509 x_klev_tbl OUT NOCOPY klev_tbl_type);
510
511 PROCEDURE update_row(
512
513 p_api_version IN NUMBER,
514 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
515 x_return_status OUT NOCOPY VARCHAR2,
516 x_msg_count OUT NOCOPY NUMBER,
517 x_msg_data OUT NOCOPY VARCHAR2,
518 p_klev_rec IN klev_rec_type,
519 x_klev_rec OUT NOCOPY klev_rec_type);
520
521 PROCEDURE update_row(
522
523 p_api_version IN NUMBER,
524 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
525 x_return_status OUT NOCOPY VARCHAR2,
526 x_msg_count OUT NOCOPY NUMBER,
527 x_msg_data OUT NOCOPY VARCHAR2,
528 p_klev_tbl IN klev_tbl_type,
529 x_klev_tbl OUT NOCOPY klev_tbl_type);
530
531 PROCEDURE delete_row(
532
533 p_api_version IN NUMBER,
534 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
535 x_return_status OUT NOCOPY VARCHAR2,
536 x_msg_count OUT NOCOPY NUMBER,
537 x_msg_data OUT NOCOPY VARCHAR2,
538 p_klev_rec IN klev_rec_type);
539
540 PROCEDURE delete_row(
541
542 p_api_version IN NUMBER,
543 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
544 x_return_status OUT NOCOPY VARCHAR2,
545 x_msg_count OUT NOCOPY NUMBER,
546 x_msg_data OUT NOCOPY VARCHAR2,
547 p_klev_tbl IN klev_tbl_type);
548
549 PROCEDURE validate_row(
550
551 p_api_version IN NUMBER,
552 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
553 x_return_status OUT NOCOPY VARCHAR2,
554 x_msg_count OUT NOCOPY NUMBER,
555 x_msg_data OUT NOCOPY VARCHAR2,
556 p_klev_rec IN klev_rec_type);
557
558 PROCEDURE validate_row(
559
560 p_api_version IN NUMBER,
561 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
562 x_return_status OUT NOCOPY VARCHAR2,
563 x_msg_count OUT NOCOPY NUMBER,
564 x_msg_data OUT NOCOPY VARCHAR2,
565 p_klev_tbl IN klev_tbl_type);
566
567 PROCEDURE lock_row(
568
569 p_api_version IN NUMBER,
570 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
571 x_return_status OUT NOCOPY VARCHAR2,
572 x_msg_count OUT NOCOPY NUMBER,
573 x_msg_data OUT NOCOPY VARCHAR2,
574 p_klev_rec IN klev_rec_type);
575
576 PROCEDURE lock_row(
577
578 p_api_version IN NUMBER,
579 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
580 x_return_status OUT NOCOPY VARCHAR2,
581 x_msg_count OUT NOCOPY NUMBER,
582 x_msg_data OUT NOCOPY VARCHAR2,
583 p_klev_tbl IN klev_tbl_type);
584
585 FUNCTION create_version(
586 p_chr_id IN NUMBER,
587 p_major_version IN NUMBER) RETURN VARCHAR2;
588
589 FUNCTION restore_version(
590 p_chr_id IN NUMBER,
591 p_major_version IN NUMBER) RETURN VARCHAR2;
592
593
594 END OKL_KLE_PVT;