[Home] [Help]
PACKAGE: APPS.OKL_KLE_PVT
Source
1 Package OKL_KLE_PVT AS
2 /* $Header: OKLSKLES.pls 120.5 2006/03/01 19:14:03 rpillay noship $ */
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 );
147
148 g_miss_kle_rec kle_rec_type;
149
150 TYPE kle_tbl_type IS TABLE OF kle_rec_type INDEX BY BINARY_INTEGER;
151
152 TYPE okl_k_lines_h_rec_type IS RECORD (
153 ID NUMBER := OKL_API.G_MISS_NUM,
154 MAJOR_VERSION NUMBER := OKL_API.G_MISS_NUM,
155 KLE_ID NUMBER := OKL_API.G_MISS_NUM,
156 STY_ID NUMBER := OKL_API.G_MISS_NUM,
157 OBJECT_VERSION_NUMBER NUMBER := OKL_API.G_MISS_NUM,
158 LAO_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
159 FEE_CHARGE NUMBER := OKL_API.G_MISS_NUM,
160 TITLE_DATE OKL_K_LINES_H.TITLE_DATE%TYPE := OKL_API.G_MISS_DATE,
161 DATE_RESIDUAL_LAST_REVIEW OKL_K_LINES_H.DATE_RESIDUAL_LAST_REVIEW%TYPE := OKL_API.G_MISS_DATE,
162 DATE_LAST_REAMORTISATION OKL_K_LINES_H.DATE_LAST_REAMORTISATION%TYPE := OKL_API.G_MISS_DATE,
163 TERMINATION_PURCHASE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
164 DATE_LAST_CLEANUP OKL_K_LINES_H.DATE_LAST_CLEANUP%TYPE := OKL_API.G_MISS_DATE,
165 REMARKETED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
166 DATE_REMARKETED OKL_K_LINES_H.DATE_REMARKETED%TYPE := OKL_API.G_MISS_DATE,
167 REMARKET_MARGIN NUMBER := OKL_API.G_MISS_NUM,
168 REPURCHASED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
169 DATE_REPURCHASED OKL_K_LINES_H.DATE_REPURCHASED%TYPE := OKL_API.G_MISS_DATE,
170 GAIN_LOSS NUMBER := OKL_API.G_MISS_NUM,
171 FLOOR_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
172 PREVIOUS_CONTRACT OKL_K_LINES_H.PREVIOUS_CONTRACT%TYPE := OKL_API.G_MISS_CHAR,
173 TRACKED_RESIDUAL NUMBER := OKL_API.G_MISS_NUM,
174 DATE_TITLE_RECEIVED OKL_K_LINES_H.DATE_TITLE_RECEIVED%TYPE := OKL_API.G_MISS_DATE,
175 ESTIMATED_OEC NUMBER := OKL_API.G_MISS_NUM,
176 RESIDUAL_PERCENTAGE NUMBER := OKL_API.G_MISS_NUM,
177 CAPITAL_REDUCTION NUMBER := OKL_API.G_MISS_NUM,
178 VENDOR_ADVANCE_PAID NUMBER := OKL_API.G_MISS_NUM,
179 TRADEIN_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
180 DELIVERED_DATE OKL_K_LINES_H.DELIVERED_DATE%TYPE := OKL_API.G_MISS_DATE,
181 YEAR_OF_MANUFACTURE OKL_K_LINES_H.YEAR_OF_MANUFACTURE%TYPE := OKL_API.G_MISS_CHAR,
182 INITIAL_DIRECT_COST NUMBER := OKL_API.G_MISS_NUM,
183 OCCUPANCY NUMBER := OKL_API.G_MISS_NUM,
184 DATE_LAST_INSPECTION OKL_K_LINES_H.DATE_LAST_INSPECTION%TYPE := OKL_API.G_MISS_DATE,
185 DATE_NEXT_INSPECTION_DUE OKL_K_LINES_H.DATE_NEXT_INSPECTION_DUE%TYPE := OKL_API.G_MISS_DATE,
186 WEIGHTED_AVERAGE_LIFE NUMBER := OKL_API.G_MISS_NUM,
187 BOND_EQUIVALENT_YIELD NUMBER := OKL_API.G_MISS_NUM,
188 REFINANCE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
189 YEAR_BUILT NUMBER := OKL_API.G_MISS_NUM,
190 COVERAGE_RATIO NUMBER := OKL_API.G_MISS_NUM,
191 GROSS_SQUARE_FOOTAGE NUMBER := OKL_API.G_MISS_NUM,
192 NET_RENTABLE NUMBER := OKL_API.G_MISS_NUM,
193 DATE_LETTER_ACCEPTANCE OKL_K_LINES_H.DATE_LETTER_ACCEPTANCE%TYPE := OKL_API.G_MISS_DATE,
194 DATE_COMMITMENT_EXPIRATION OKL_K_LINES_H.DATE_COMMITMENT_EXPIRATION%TYPE := OKL_API.G_MISS_DATE,
195 DATE_APPRAISAL OKL_K_LINES_H.DATE_APPRAISAL%TYPE := OKL_API.G_MISS_DATE,
196 APPRAISAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
197 RESIDUAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
198 PERCENT NUMBER := OKL_API.G_MISS_NUM,
199 COVERAGE NUMBER := OKL_API.G_MISS_NUM,
200 LRV_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
201 AMOUNT NUMBER := OKL_API.G_MISS_NUM,
202 LRS_PERCENT NUMBER := OKL_API.G_MISS_NUM,
203 EVERGREEN_PERCENT NUMBER := OKL_API.G_MISS_NUM,
204 PERCENT_STAKE NUMBER := OKL_API.G_MISS_NUM,
205 AMOUNT_STAKE NUMBER := OKL_API.G_MISS_NUM,
206 DATE_SOLD OKL_K_LINES_H.DATE_SOLD%TYPE := OKL_API.G_MISS_DATE,
207 STY_ID_FOR NUMBER := OKL_API.G_MISS_NUM,
208 ATTRIBUTE_CATEGORY OKL_K_LINES_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
209 ATTRIBUTE1 OKL_K_LINES_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
210 ATTRIBUTE2 OKL_K_LINES_H.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
211 ATTRIBUTE3 OKL_K_LINES_H.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
212 ATTRIBUTE4 OKL_K_LINES_H.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
213 ATTRIBUTE5 OKL_K_LINES_H.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
214 ATTRIBUTE6 OKL_K_LINES_H.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
215 ATTRIBUTE7 OKL_K_LINES_H.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
216 ATTRIBUTE8 OKL_K_LINES_H.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
217 ATTRIBUTE9 OKL_K_LINES_H.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
218 ATTRIBUTE10 OKL_K_LINES_H.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
219 ATTRIBUTE11 OKL_K_LINES_H.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
220 ATTRIBUTE12 OKL_K_LINES_H.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
221 ATTRIBUTE13 OKL_K_LINES_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
222 ATTRIBUTE14 OKL_K_LINES_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
223 ATTRIBUTE15 OKL_K_LINES_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
224 CREATED_BY NUMBER := OKL_API.G_MISS_NUM,
225 CREATION_DATE OKL_K_LINES_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
226 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
227 LAST_UPDATE_DATE OKL_K_LINES_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
228 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM,
229 NTY_CODE OKL_K_LINES_H.NTY_CODE%TYPE := OKL_API.G_MISS_CHAR,
230 FCG_CODE OKL_K_LINES_H.FCG_CODE%TYPE := OKL_API.G_MISS_CHAR,
231 PRC_CODE OKL_K_LINES_H.PRC_CODE%TYPE := OKL_API.G_MISS_CHAR,
232 RE_LEASE_YN OKL_K_LINES_H.RE_LEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
233 PRESCRIBED_ASSET_YN OKL_K_LINES_H.PRESCRIBED_ASSET_YN%TYPE := OKL_API.G_MISS_CHAR,
234 CREDIT_TENANT_YN OKL_K_LINES_H.CREDIT_TENANT_YN%TYPE := OKL_API.G_MISS_CHAR,
235 SECURED_DEAL_YN OKL_K_LINES_H.SECURED_DEAL_YN%TYPE := OKL_API.G_MISS_CHAR,
236 CLG_ID NUMBER := OKL_API.G_MISS_NUM,
237 DATE_FUNDING OKL_K_LINES_H.DATE_FUNDING%TYPE := OKL_API.G_MISS_DATE,
238 DATE_FUNDING_REQUIRED OKL_K_LINES_H.DATE_FUNDING_REQUIRED%TYPE := OKL_API.G_MISS_DATE,
239 DATE_ACCEPTED OKL_K_LINES_H.DATE_ACCEPTED%TYPE := OKL_API.G_MISS_DATE,
240 DATE_DELIVERY_EXPECTED OKL_K_LINES_H.DATE_DELIVERY_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
241 OEC NUMBER := OKL_API.G_MISS_NUM,
242 CAPITAL_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
243 RESIDUAL_GRNTY_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
244 RESIDUAL_CODE OKL_K_LINES_H.RESIDUAL_CODE%TYPE := OKL_API.G_MISS_CHAR,
245 RVI_PREMIUM NUMBER := OKL_API.G_MISS_NUM,
246 CREDIT_NATURE OKL_K_LINES_H.CREDIT_NATURE%TYPE := OKL_API.G_MISS_CHAR,
247 CAPITALIZED_INTEREST NUMBER := OKL_API.G_MISS_NUM,
248 CAPITAL_REDUCTION_PERCENT NUMBER := OKL_API.G_MISS_NUM,
249 --Bug# 2697681 11.5.9
250 DATE_PAY_INVESTOR_START OKL_K_LINES_H.DATE_PAY_INVESTOR_START%TYPE := OKL_API.G_MISS_DATE,
251 PAY_INVESTOR_FREQUENCY OKL_K_LINES_H.PAY_INVESTOR_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
252 PAY_INVESTOR_EVENT OKL_K_LINES_H.PAY_INVESTOR_EVENT%TYPE := OKL_API.G_MISS_CHAR,
253 PAY_INVESTOR_REMITTANCE_DAYS NUMBER := OKL_API.G_MISS_NUM,
254 FEE_TYPE OKL_K_LINES_H.FEE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
255 --Bug# 3143522 :11.5.10
256 --subsidy
257 SUBSIDY_ID NUMBER := OKL_API.G_MISS_NUM,
258 --SUBSIDIZED_OEC NUMBER := OKL_API.G_MISS_NUM,
259 --SUBSIDIZED_CAP_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
260 SUBSIDY_OVERRIDE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
261 --financed fee
262 PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
263 AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
264 IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
265 IMPLICIT_NON_IDC_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
266 PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
267 AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
268 --quote
269 SUB_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
270 SUB_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
271 SUB_IMPL_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
272 SUB_IMPL_NON_IDC_INT_RATE NUMBER := OKL_API.G_MISS_NUM,
273 SUB_PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
274 SUB_AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
275 --Bug# 2994971
276 ITEM_INSURANCE_CATEGORY NUMBER := OKL_API.G_MISS_NUM,
277 --Bug# 3973640 :11.5.10+
278 QTE_ID NUMBER := OKL_API.G_MISS_NUM,
279 FUNDING_DATE OKL_K_LINES_H.FUNDING_DATE%TYPE := OKL_API.G_MISS_DATE,
280 STREAM_TYPE_SUBCLASS OKL_K_LINES_H.STREAM_TYPE_SUBCLASS%TYPE := OKL_API.G_MISS_CHAR,
281 --Bug#4419339
282 DATE_FUNDING_EXPECTED OKL_K_LINES_H.DATE_FUNDING_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
283 MANUFACTURER_NAME OKL_K_LINES_H.MANUFACTURER_NAME%TYPE := OKL_API.G_MISS_CHAR,
284 MODEL_NUMBER OKL_K_LINES_H.MODEL_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
285 DOWN_PAYMENT_RECEIVER_CODE OKL_K_LINES_H.DOWN_PAYMENT_RECEIVER_CODE%TYPE := OKL_API.G_MISS_CHAR,
286 CAPITALIZE_DOWN_PAYMENT_YN OKL_K_LINES_H.CAPITALIZE_DOWN_PAYMENT_YN%TYPE := OKL_API.G_MISS_CHAR,
287 --Bug#4373029
288 FEE_PURPOSE_CODE OKL_K_LINES_H.FEE_PURPOSE_CODE%TYPE := OKL_API.G_MISS_CHAR,
289 TERMINATION_VALUE NUMBER := OKL_API.G_MISS_NUM,
290 --Bug# 4631549
291 EXPECTED_ASSET_COST NUMBER := OKL_API.G_MISS_NUM
292 );
293
294 g_miss_okl_k_lines_h_rec okl_k_lines_h_rec_type;
295
296 TYPE okl_k_lines_h_tbl_type IS TABLE OF okl_k_lines_h_rec_type INDEX BY BINARY_INTEGER;
297
298 TYPE klev_rec_type IS RECORD (
299 ID NUMBER := OKL_API.G_MISS_NUM,
300 OBJECT_VERSION_NUMBER NUMBER := OKL_API.G_MISS_NUM,
301 KLE_ID NUMBER := OKL_API.G_MISS_NUM,
302 STY_ID NUMBER := OKL_API.G_MISS_NUM,
303 PRC_CODE OKL_K_LINES_V.PRC_CODE%TYPE := OKL_API.G_MISS_CHAR,
304 FCG_CODE OKL_K_LINES_V.FCG_CODE%TYPE := OKL_API.G_MISS_CHAR,
305 NTY_CODE OKL_K_LINES_V.NTY_CODE%TYPE := OKL_API.G_MISS_CHAR,
306 ESTIMATED_OEC NUMBER := OKL_API.G_MISS_NUM,
307 LAO_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
308 TITLE_DATE OKL_K_LINES_V.TITLE_DATE%TYPE := OKL_API.G_MISS_DATE,
309 FEE_CHARGE NUMBER := OKL_API.G_MISS_NUM,
310 LRS_PERCENT NUMBER := OKL_API.G_MISS_NUM,
311 INITIAL_DIRECT_COST NUMBER := OKL_API.G_MISS_NUM,
312 PERCENT_STAKE NUMBER := OKL_API.G_MISS_NUM,
313 PERCENT NUMBER := OKL_API.G_MISS_NUM,
314 EVERGREEN_PERCENT NUMBER := OKL_API.G_MISS_NUM,
315 AMOUNT_STAKE NUMBER := OKL_API.G_MISS_NUM,
316 OCCUPANCY NUMBER := OKL_API.G_MISS_NUM,
317 COVERAGE NUMBER := OKL_API.G_MISS_NUM,
318 RESIDUAL_PERCENTAGE NUMBER := OKL_API.G_MISS_NUM,
319 DATE_LAST_INSPECTION OKL_K_LINES_V.DATE_LAST_INSPECTION%TYPE := OKL_API.G_MISS_DATE,
320 DATE_SOLD OKL_K_LINES_V.DATE_SOLD%TYPE := OKL_API.G_MISS_DATE,
321 LRV_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
322 CAPITAL_REDUCTION NUMBER := OKL_API.G_MISS_NUM,
323 DATE_NEXT_INSPECTION_DUE OKL_K_LINES_V.DATE_NEXT_INSPECTION_DUE%TYPE := OKL_API.G_MISS_DATE,
324 DATE_RESIDUAL_LAST_REVIEW OKL_K_LINES_V.DATE_RESIDUAL_LAST_REVIEW%TYPE := OKL_API.G_MISS_DATE,
325 DATE_LAST_REAMORTISATION OKL_K_LINES_V.DATE_LAST_REAMORTISATION%TYPE := OKL_API.G_MISS_DATE,
326 VENDOR_ADVANCE_PAID NUMBER := OKL_API.G_MISS_NUM,
327 WEIGHTED_AVERAGE_LIFE NUMBER := OKL_API.G_MISS_NUM,
328 TRADEIN_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
329 BOND_EQUIVALENT_YIELD NUMBER := OKL_API.G_MISS_NUM,
330 TERMINATION_PURCHASE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
331 REFINANCE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
332 YEAR_BUILT NUMBER := OKL_API.G_MISS_NUM,
333 DELIVERED_DATE OKL_K_LINES_V.DELIVERED_DATE%TYPE := OKL_API.G_MISS_DATE,
334 CREDIT_TENANT_YN OKL_K_LINES_V.CREDIT_TENANT_YN%TYPE := OKL_API.G_MISS_CHAR,
335 DATE_LAST_CLEANUP OKL_K_LINES_V.DATE_LAST_CLEANUP%TYPE := OKL_API.G_MISS_DATE,
336 YEAR_OF_MANUFACTURE OKL_K_LINES_V.YEAR_OF_MANUFACTURE%TYPE := OKL_API.G_MISS_CHAR,
337 COVERAGE_RATIO NUMBER := OKL_API.G_MISS_NUM,
338 REMARKETED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
339 GROSS_SQUARE_FOOTAGE NUMBER := OKL_API.G_MISS_NUM,
340 PRESCRIBED_ASSET_YN OKL_K_LINES_V.PRESCRIBED_ASSET_YN%TYPE := OKL_API.G_MISS_CHAR,
341 DATE_REMARKETED OKL_K_LINES_V.DATE_REMARKETED%TYPE := OKL_API.G_MISS_DATE,
342 NET_RENTABLE NUMBER := OKL_API.G_MISS_NUM,
343 REMARKET_MARGIN NUMBER := OKL_API.G_MISS_NUM,
344 DATE_LETTER_ACCEPTANCE OKL_K_LINES_V.DATE_LETTER_ACCEPTANCE%TYPE := OKL_API.G_MISS_DATE,
345 REPURCHASED_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
346 DATE_COMMITMENT_EXPIRATION OKL_K_LINES_V.DATE_COMMITMENT_EXPIRATION%TYPE := OKL_API.G_MISS_DATE,
347 DATE_REPURCHASED OKL_K_LINES_V.DATE_REPURCHASED%TYPE := OKL_API.G_MISS_DATE,
348 DATE_APPRAISAL OKL_K_LINES_V.DATE_APPRAISAL%TYPE := OKL_API.G_MISS_DATE,
349 RESIDUAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
350 APPRAISAL_VALUE NUMBER := OKL_API.G_MISS_NUM,
351 SECURED_DEAL_YN OKL_K_LINES_V.SECURED_DEAL_YN%TYPE := OKL_API.G_MISS_CHAR,
352 GAIN_LOSS NUMBER := OKL_API.G_MISS_NUM,
353 FLOOR_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
354 RE_LEASE_YN OKL_K_LINES_V.RE_LEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
355 PREVIOUS_CONTRACT OKL_K_LINES_V.PREVIOUS_CONTRACT%TYPE := OKL_API.G_MISS_CHAR,
356 TRACKED_RESIDUAL NUMBER := OKL_API.G_MISS_NUM,
357 DATE_TITLE_RECEIVED OKL_K_LINES_V.DATE_TITLE_RECEIVED%TYPE := OKL_API.G_MISS_DATE,
358 AMOUNT NUMBER := OKL_API.G_MISS_NUM,
359 ATTRIBUTE_CATEGORY OKL_K_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
360 ATTRIBUTE1 OKL_K_LINES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
361 ATTRIBUTE2 OKL_K_LINES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
362 ATTRIBUTE3 OKL_K_LINES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
363 ATTRIBUTE4 OKL_K_LINES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
364 ATTRIBUTE5 OKL_K_LINES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
365 ATTRIBUTE6 OKL_K_LINES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
366 ATTRIBUTE7 OKL_K_LINES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
367 ATTRIBUTE8 OKL_K_LINES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
368 ATTRIBUTE9 OKL_K_LINES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
369 ATTRIBUTE10 OKL_K_LINES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
370 ATTRIBUTE11 OKL_K_LINES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
371 ATTRIBUTE12 OKL_K_LINES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
372 ATTRIBUTE13 OKL_K_LINES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
373 ATTRIBUTE14 OKL_K_LINES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
374 ATTRIBUTE15 OKL_K_LINES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
375 STY_ID_FOR NUMBER := OKL_API.G_MISS_NUM,
376 CLG_ID NUMBER := OKL_API.G_MISS_NUM,
377 CREATED_BY NUMBER := OKL_API.G_MISS_NUM,
378 CREATION_DATE OKL_K_LINES_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
379 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
380 LAST_UPDATE_DATE OKL_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
381 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM,
382 DATE_FUNDING OKL_K_LINES_V.DATE_FUNDING%TYPE := OKL_API.G_MISS_DATE,
383 DATE_FUNDING_REQUIRED OKL_K_LINES_V.DATE_FUNDING_REQUIRED%TYPE := OKL_API.G_MISS_DATE,
384 DATE_ACCEPTED OKL_K_LINES_V.DATE_ACCEPTED%TYPE := OKL_API.G_MISS_DATE,
385 DATE_DELIVERY_EXPECTED OKL_K_LINES_V.DATE_DELIVERY_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
386 OEC NUMBER := OKL_API.G_MISS_NUM,
387 CAPITAL_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
388 RESIDUAL_GRNTY_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
389 RESIDUAL_CODE OKL_K_LINES_V.RESIDUAL_CODE%TYPE := OKL_API.G_MISS_CHAR,
390 RVI_PREMIUM NUMBER := OKL_API.G_MISS_NUM,
391 CREDIT_NATURE OKL_K_LINES_V.CREDIT_NATURE%TYPE := OKL_API.G_MISS_CHAR,
392 CAPITALIZED_INTEREST NUMBER := OKL_API.G_MISS_NUM,
393 CAPITAL_REDUCTION_PERCENT NUMBER := OKL_API.G_MISS_NUM,
394 --Bug# 2697681 11.5.9
395 DATE_PAY_INVESTOR_START OKL_K_LINES_V.DATE_PAY_INVESTOR_START%TYPE := OKL_API.G_MISS_DATE,
396 PAY_INVESTOR_FREQUENCY OKL_K_LINES_V.PAY_INVESTOR_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
397 PAY_INVESTOR_EVENT OKL_K_LINES_V.PAY_INVESTOR_EVENT%TYPE := OKL_API.G_MISS_CHAR,
398 PAY_INVESTOR_REMITTANCE_DAYS NUMBER := OKL_API.G_MISS_NUM,
399 FEE_TYPE OKL_K_LINES_V.FEE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
400 --Bug# 3143522 :11.5.10
401 --subsidy
402 SUBSIDY_ID NUMBER := OKL_API.G_MISS_NUM,
403 --SUBSIDIZED_OEC NUMBER := OKL_API.G_MISS_NUM,
404 --SUBSIDIZED_CAP_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
405 SUBSIDY_OVERRIDE_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
406 --financed fee
407 PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
408 AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
409 IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
410 IMPLICIT_NON_IDC_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
411 PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
412 AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
413 --quote
414 SUB_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
415 SUB_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
416 SUB_IMPL_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
417 SUB_IMPL_NON_IDC_INT_RATE NUMBER := OKL_API.G_MISS_NUM,
418 SUB_PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
419 SUB_AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
420 --Bug# 2994971
421 ITEM_INSURANCE_CATEGORY NUMBER := OKL_API.G_MISS_NUM,
422 --Bug# 3973640 :11.5.10+
423 QTE_ID NUMBER := OKL_API.G_MISS_NUM,
424 FUNDING_DATE OKL_K_LINES_V.FUNDING_DATE%TYPE := OKL_API.G_MISS_DATE,
425 STREAM_TYPE_SUBCLASS OKL_K_LINES_V.STREAM_TYPE_SUBCLASS%TYPE := OKL_API.G_MISS_CHAR,
426 --Bug#4419339 OKLH
427 DATE_FUNDING_EXPECTED OKL_K_LINES_V.DATE_FUNDING_EXPECTED%TYPE := OKL_API.G_MISS_DATE,
428 MANUFACTURER_NAME OKL_K_LINES_V.MANUFACTURER_NAME%TYPE := OKL_API.G_MISS_CHAR,
429 MODEL_NUMBER OKL_K_LINES_V.MODEL_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
430 DOWN_PAYMENT_RECEIVER_CODE OKL_K_LINES_V.DOWN_PAYMENT_RECEIVER_CODE%TYPE := OKL_API.G_MISS_CHAR,
431 CAPITALIZE_DOWN_PAYMENT_YN OKL_K_LINES_V.CAPITALIZE_DOWN_PAYMENT_YN%TYPE := OKL_API.G_MISS_CHAR,
432 --Bug#4373029
433 FEE_PURPOSE_CODE OKL_K_LINES_V.FEE_PURPOSE_CODE%TYPE := OKL_API.G_MISS_CHAR,
434 TERMINATION_VALUE NUMBER := OKL_API.G_MISS_NUM,
435 --Bug# 4558486
436 VALIDATE_DFF_YN VARCHAR(3) := OKL_API.G_MISS_CHAR,
437 --Bug# 4631549
438 EXPECTED_ASSET_COST NUMBER := OKL_API.G_MISS_NUM
439 );
440
441 g_miss_klev_rec klev_rec_type;
442
443 TYPE klev_tbl_type IS TABLE OF klev_rec_type INDEX BY BINARY_INTEGER;
444
445 ---------------------------------------------------------------------------
446 -- GLOBAL MESSAGE CONSTANTS
447 ---------------------------------------------------------------------------
448 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
449 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
450 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
451 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
452 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
453 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
454 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
455 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
456 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
457 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
458
459 ---------------------------------------------------------------------------
460 -- GLOBAL VARIABLES
461 ---------------------------------------------------------------------------
462 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_KLE_PVT';
463 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
464
465 ---------------------------------------------------------------------------
466 -- Procedures and Functions
467 ---------------------------------------------------------------------------
468
469 PROCEDURE qc;
470 PROCEDURE change_version;
471 PROCEDURE api_copy;
472
473
474 PROCEDURE insert_row(
475
476 p_api_version IN NUMBER,
477 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
478 x_return_status OUT NOCOPY VARCHAR2,
479 x_msg_count OUT NOCOPY NUMBER,
480 x_msg_data OUT NOCOPY VARCHAR2,
481 p_klev_rec IN klev_rec_type,
482 x_klev_rec OUT NOCOPY klev_rec_type);
483
484 PROCEDURE insert_row(
485
486 p_api_version IN NUMBER,
487 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
488 x_return_status OUT NOCOPY VARCHAR2,
489 x_msg_count OUT NOCOPY NUMBER,
490 x_msg_data OUT NOCOPY VARCHAR2,
491 p_klev_tbl IN klev_tbl_type,
492 x_klev_tbl OUT NOCOPY klev_tbl_type);
493
494 PROCEDURE update_row(
495
496 p_api_version IN NUMBER,
497 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
498 x_return_status OUT NOCOPY VARCHAR2,
499 x_msg_count OUT NOCOPY NUMBER,
500 x_msg_data OUT NOCOPY VARCHAR2,
501 p_klev_rec IN klev_rec_type,
502 x_klev_rec OUT NOCOPY klev_rec_type);
503
504 PROCEDURE update_row(
505
506 p_api_version IN NUMBER,
507 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
508 x_return_status OUT NOCOPY VARCHAR2,
509 x_msg_count OUT NOCOPY NUMBER,
510 x_msg_data OUT NOCOPY VARCHAR2,
511 p_klev_tbl IN klev_tbl_type,
512 x_klev_tbl OUT NOCOPY klev_tbl_type);
513
514 PROCEDURE delete_row(
515
516 p_api_version IN NUMBER,
517 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
518 x_return_status OUT NOCOPY VARCHAR2,
519 x_msg_count OUT NOCOPY NUMBER,
520 x_msg_data OUT NOCOPY VARCHAR2,
521 p_klev_rec IN klev_rec_type);
522
523 PROCEDURE delete_row(
524
525 p_api_version IN NUMBER,
526 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
527 x_return_status OUT NOCOPY VARCHAR2,
528 x_msg_count OUT NOCOPY NUMBER,
529 x_msg_data OUT NOCOPY VARCHAR2,
530 p_klev_tbl IN klev_tbl_type);
531
532 PROCEDURE validate_row(
533
534 p_api_version IN NUMBER,
535 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
536 x_return_status OUT NOCOPY VARCHAR2,
537 x_msg_count OUT NOCOPY NUMBER,
538 x_msg_data OUT NOCOPY VARCHAR2,
539 p_klev_rec IN klev_rec_type);
540
541 PROCEDURE validate_row(
542
543 p_api_version IN NUMBER,
544 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
545 x_return_status OUT NOCOPY VARCHAR2,
546 x_msg_count OUT NOCOPY NUMBER,
547 x_msg_data OUT NOCOPY VARCHAR2,
548 p_klev_tbl IN klev_tbl_type);
549
550 PROCEDURE lock_row(
551
552 p_api_version IN NUMBER,
553 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
554 x_return_status OUT NOCOPY VARCHAR2,
555 x_msg_count OUT NOCOPY NUMBER,
556 x_msg_data OUT NOCOPY VARCHAR2,
557 p_klev_rec IN klev_rec_type);
558
559 PROCEDURE lock_row(
560
561 p_api_version IN NUMBER,
562 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
563 x_return_status OUT NOCOPY VARCHAR2,
564 x_msg_count OUT NOCOPY NUMBER,
565 x_msg_data OUT NOCOPY VARCHAR2,
566 p_klev_tbl IN klev_tbl_type);
567
568 FUNCTION create_version(
569 p_chr_id IN NUMBER,
570 p_major_version IN NUMBER) RETURN VARCHAR2;
571
572 FUNCTION restore_version(
573 p_chr_id IN NUMBER,
574 p_major_version IN NUMBER) RETURN VARCHAR2;
575
576
577 END OKL_KLE_PVT;