[Home] [Help]
PACKAGE BODY: APPS.OKL_SERVICE_INTEGRATION_PVT_W
Source
1 package body okl_service_integration_pvt_w as
2 /* $Header: OKLESRIB.pls 115.1 2003/10/20 18:56:00 dedey noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p19(t out nocopy okl_service_integration_pvt.link_line_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 ) as
25 ddindx binary_integer; indx binary_integer;
26 begin
27 if a0 is not null and a0.count > 0 then
28 if a0.count > 0 then
29 indx := a0.first;
30 ddindx := 1;
31 while true loop
32 t(ddindx).okl_service_line_id := rosetta_g_miss_num_map(a0(indx));
33 t(ddindx).oks_service_line_id := rosetta_g_miss_num_map(a1(indx));
34 ddindx := ddindx+1;
35 if a0.last =indx
36 then exit;
37 end if;
38 indx := a0.next(indx);
39 end loop;
40 end if;
41 end if;
42 end rosetta_table_copy_in_p19;
43 procedure rosetta_table_copy_out_p19(t okl_service_integration_pvt.link_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
44 , a1 out nocopy JTF_NUMBER_TABLE
45 ) as
46 ddindx binary_integer; indx binary_integer;
47 begin
48 if t is null or t.count = 0 then
49 a0 := JTF_NUMBER_TABLE();
50 a1 := JTF_NUMBER_TABLE();
51 else
52 a0 := JTF_NUMBER_TABLE();
53 a1 := JTF_NUMBER_TABLE();
54 if t.count > 0 then
55 a0.extend(t.count);
56 a1.extend(t.count);
57 ddindx := t.first;
58 indx := 1;
59 while true loop
60 a0(indx) := rosetta_g_miss_num_map(t(ddindx).okl_service_line_id);
61 a1(indx) := rosetta_g_miss_num_map(t(ddindx).oks_service_line_id);
62 indx := indx+1;
63 if t.last =ddindx
64 then exit;
65 end if;
66 ddindx := t.next(ddindx);
67 end loop;
68 end if;
69 end if;
70 end rosetta_table_copy_out_p19;
71
72 procedure rosetta_table_copy_in_p21(t out nocopy okl_service_integration_pvt.srv_cov_tbl_type, a0 JTF_NUMBER_TABLE
73 ) as
74 ddindx binary_integer; indx binary_integer;
75 begin
76 if a0 is not null and a0.count > 0 then
77 if a0.count > 0 then
78 indx := a0.first;
79 ddindx := 1;
80 while true loop
81 t(ddindx).oks_cov_prod_line_id := rosetta_g_miss_num_map(a0(indx));
82 ddindx := ddindx+1;
83 if a0.last =indx
84 then exit;
85 end if;
86 indx := a0.next(indx);
87 end loop;
88 end if;
89 end if;
90 end rosetta_table_copy_in_p21;
91 procedure rosetta_table_copy_out_p21(t okl_service_integration_pvt.srv_cov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92 ) as
93 ddindx binary_integer; indx binary_integer;
94 begin
95 if t is null or t.count = 0 then
96 a0 := JTF_NUMBER_TABLE();
97 else
98 a0 := JTF_NUMBER_TABLE();
99 if t.count > 0 then
100 a0.extend(t.count);
101 ddindx := t.first;
102 indx := 1;
103 while true loop
104 a0(indx) := rosetta_g_miss_num_map(t(ddindx).oks_cov_prod_line_id);
105 indx := indx+1;
106 if t.last =ddindx
107 then exit;
108 end if;
109 ddindx := t.next(ddindx);
110 end loop;
111 end if;
112 end if;
113 end rosetta_table_copy_out_p21;
114
115 procedure delete_service_line(p_api_version NUMBER
116 , p_init_msg_list VARCHAR2
117 , x_return_status out nocopy VARCHAR2
118 , x_msg_count out nocopy NUMBER
119 , x_msg_data out nocopy VARCHAR2
120 , p5_a0 NUMBER := 0-1962.0724
121 , p5_a1 NUMBER := 0-1962.0724
122 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
123 , p5_a3 NUMBER := 0-1962.0724
124 , p5_a4 NUMBER := 0-1962.0724
125 , p5_a5 NUMBER := 0-1962.0724
126 , p5_a6 NUMBER := 0-1962.0724
127 , p5_a7 NUMBER := 0-1962.0724
128 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
129 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
130 , p5_a10 NUMBER := 0-1962.0724
131 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
132 , p5_a12 NUMBER := 0-1962.0724
133 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
134 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
135 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
136 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
137 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
138 , p5_a18 NUMBER := 0-1962.0724
139 , p5_a19 NUMBER := 0-1962.0724
140 , p5_a20 NUMBER := 0-1962.0724
141 , p5_a21 NUMBER := 0-1962.0724
142 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
143 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
144 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
145 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
146 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
147 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
148 , p5_a28 DATE := fnd_api.g_miss_date
149 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
150 , p5_a30 DATE := fnd_api.g_miss_date
151 , p5_a31 DATE := fnd_api.g_miss_date
152 , p5_a32 DATE := fnd_api.g_miss_date
153 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
154 , p5_a34 NUMBER := 0-1962.0724
155 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
156 , p5_a36 NUMBER := 0-1962.0724
157 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
158 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
159 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
160 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
161 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
162 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
163 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
164 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
165 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
166 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
167 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
168 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
169 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
170 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
171 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
172 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
173 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
174 , p5_a54 NUMBER := 0-1962.0724
175 , p5_a55 DATE := fnd_api.g_miss_date
176 , p5_a56 NUMBER := 0-1962.0724
177 , p5_a57 DATE := fnd_api.g_miss_date
178 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
179 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
180 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
181 , p5_a61 NUMBER := 0-1962.0724
182 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
183 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
184 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
185 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
186 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
187 , p5_a67 NUMBER := 0-1962.0724
188 , p5_a68 NUMBER := 0-1962.0724
189 , p5_a69 NUMBER := 0-1962.0724
190 , p5_a70 DATE := fnd_api.g_miss_date
191 , p5_a71 NUMBER := 0-1962.0724
192 , p5_a72 DATE := fnd_api.g_miss_date
193 , p5_a73 NUMBER := 0-1962.0724
194 , p5_a74 NUMBER := 0-1962.0724
195 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
196 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
197 , p5_a77 NUMBER := 0-1962.0724
198 , p5_a78 NUMBER := 0-1962.0724
199 , p5_a79 VARCHAR2 := fnd_api.g_miss_char
200 , p5_a80 VARCHAR2 := fnd_api.g_miss_char
201 , p5_a81 NUMBER := 0-1962.0724
202 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
203 , p5_a83 NUMBER := 0-1962.0724
204 , p5_a84 NUMBER := 0-1962.0724
205 , p5_a85 NUMBER := 0-1962.0724
206 , p5_a86 NUMBER := 0-1962.0724
207 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
208 , p5_a88 NUMBER := 0-1962.0724
209 , p5_a89 NUMBER := 0-1962.0724
210 , p6_a0 NUMBER := 0-1962.0724
211 , p6_a1 NUMBER := 0-1962.0724
212 , p6_a2 NUMBER := 0-1962.0724
213 , p6_a3 NUMBER := 0-1962.0724
214 , p6_a4 VARCHAR2 := fnd_api.g_miss_char
215 , p6_a5 VARCHAR2 := fnd_api.g_miss_char
216 , p6_a6 VARCHAR2 := fnd_api.g_miss_char
217 , p6_a7 NUMBER := 0-1962.0724
218 , p6_a8 NUMBER := 0-1962.0724
219 , p6_a9 DATE := fnd_api.g_miss_date
220 , p6_a10 NUMBER := 0-1962.0724
221 , p6_a11 NUMBER := 0-1962.0724
222 , p6_a12 NUMBER := 0-1962.0724
223 , p6_a13 NUMBER := 0-1962.0724
224 , p6_a14 NUMBER := 0-1962.0724
225 , p6_a15 NUMBER := 0-1962.0724
226 , p6_a16 NUMBER := 0-1962.0724
227 , p6_a17 NUMBER := 0-1962.0724
228 , p6_a18 NUMBER := 0-1962.0724
229 , p6_a19 NUMBER := 0-1962.0724
230 , p6_a20 DATE := fnd_api.g_miss_date
231 , p6_a21 DATE := fnd_api.g_miss_date
232 , p6_a22 NUMBER := 0-1962.0724
233 , p6_a23 NUMBER := 0-1962.0724
234 , p6_a24 DATE := fnd_api.g_miss_date
235 , p6_a25 DATE := fnd_api.g_miss_date
236 , p6_a26 DATE := fnd_api.g_miss_date
237 , p6_a27 NUMBER := 0-1962.0724
238 , p6_a28 NUMBER := 0-1962.0724
239 , p6_a29 NUMBER := 0-1962.0724
240 , p6_a30 NUMBER := 0-1962.0724
241 , p6_a31 NUMBER := 0-1962.0724
242 , p6_a32 NUMBER := 0-1962.0724
243 , p6_a33 NUMBER := 0-1962.0724
244 , p6_a34 DATE := fnd_api.g_miss_date
245 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
246 , p6_a36 DATE := fnd_api.g_miss_date
247 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
248 , p6_a38 NUMBER := 0-1962.0724
249 , p6_a39 NUMBER := 0-1962.0724
250 , p6_a40 NUMBER := 0-1962.0724
251 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
252 , p6_a42 DATE := fnd_api.g_miss_date
253 , p6_a43 NUMBER := 0-1962.0724
254 , p6_a44 NUMBER := 0-1962.0724
255 , p6_a45 DATE := fnd_api.g_miss_date
256 , p6_a46 NUMBER := 0-1962.0724
257 , p6_a47 DATE := fnd_api.g_miss_date
258 , p6_a48 DATE := fnd_api.g_miss_date
259 , p6_a49 DATE := fnd_api.g_miss_date
260 , p6_a50 NUMBER := 0-1962.0724
261 , p6_a51 NUMBER := 0-1962.0724
262 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
263 , p6_a53 NUMBER := 0-1962.0724
264 , p6_a54 NUMBER := 0-1962.0724
265 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
266 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
267 , p6_a57 NUMBER := 0-1962.0724
268 , p6_a58 DATE := fnd_api.g_miss_date
269 , p6_a59 NUMBER := 0-1962.0724
270 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
271 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
272 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
273 , p6_a63 VARCHAR2 := fnd_api.g_miss_char
274 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
275 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
276 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
277 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
278 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
279 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
280 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
281 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
282 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
283 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
284 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
285 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
286 , p6_a76 NUMBER := 0-1962.0724
287 , p6_a77 NUMBER := 0-1962.0724
288 , p6_a78 NUMBER := 0-1962.0724
289 , p6_a79 DATE := fnd_api.g_miss_date
290 , p6_a80 NUMBER := 0-1962.0724
291 , p6_a81 DATE := fnd_api.g_miss_date
292 , p6_a82 NUMBER := 0-1962.0724
293 , p6_a83 DATE := fnd_api.g_miss_date
294 , p6_a84 DATE := fnd_api.g_miss_date
295 , p6_a85 DATE := fnd_api.g_miss_date
296 , p6_a86 DATE := fnd_api.g_miss_date
297 , p6_a87 NUMBER := 0-1962.0724
298 , p6_a88 NUMBER := 0-1962.0724
299 , p6_a89 NUMBER := 0-1962.0724
300 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
301 , p6_a91 NUMBER := 0-1962.0724
302 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
303 , p6_a93 NUMBER := 0-1962.0724
304 , p6_a94 NUMBER := 0-1962.0724
305 , p6_a95 DATE := fnd_api.g_miss_date
306 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
307 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
308 , p6_a98 NUMBER := 0-1962.0724
309 )
310
311 as
312 ddp_clev_rec okl_service_integration_pvt.clev_rec_type;
313 ddp_klev_rec okl_service_integration_pvt.klev_rec_type;
314 ddindx binary_integer; indx binary_integer;
315 begin
316
317 -- copy data to the local IN or IN-OUT args, if any
318
319
320
321
322
323 ddp_clev_rec.id := rosetta_g_miss_num_map(p5_a0);
324 ddp_clev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
325 ddp_clev_rec.sfwt_flag := p5_a2;
326 ddp_clev_rec.chr_id := rosetta_g_miss_num_map(p5_a3);
327 ddp_clev_rec.cle_id := rosetta_g_miss_num_map(p5_a4);
328 ddp_clev_rec.cle_id_renewed := rosetta_g_miss_num_map(p5_a5);
329 ddp_clev_rec.cle_id_renewed_to := rosetta_g_miss_num_map(p5_a6);
330 ddp_clev_rec.lse_id := rosetta_g_miss_num_map(p5_a7);
331 ddp_clev_rec.line_number := p5_a8;
332 ddp_clev_rec.sts_code := p5_a9;
333 ddp_clev_rec.display_sequence := rosetta_g_miss_num_map(p5_a10);
334 ddp_clev_rec.trn_code := p5_a11;
335 ddp_clev_rec.dnz_chr_id := rosetta_g_miss_num_map(p5_a12);
336 ddp_clev_rec.comments := p5_a13;
337 ddp_clev_rec.item_description := p5_a14;
338 ddp_clev_rec.oke_boe_description := p5_a15;
339 ddp_clev_rec.cognomen := p5_a16;
340 ddp_clev_rec.hidden_ind := p5_a17;
341 ddp_clev_rec.price_unit := rosetta_g_miss_num_map(p5_a18);
342 ddp_clev_rec.price_unit_percent := rosetta_g_miss_num_map(p5_a19);
343 ddp_clev_rec.price_negotiated := rosetta_g_miss_num_map(p5_a20);
344 ddp_clev_rec.price_negotiated_renewed := rosetta_g_miss_num_map(p5_a21);
345 ddp_clev_rec.price_level_ind := p5_a22;
346 ddp_clev_rec.invoice_line_level_ind := p5_a23;
347 ddp_clev_rec.dpas_rating := p5_a24;
348 ddp_clev_rec.block23text := p5_a25;
349 ddp_clev_rec.exception_yn := p5_a26;
350 ddp_clev_rec.template_used := p5_a27;
351 ddp_clev_rec.date_terminated := rosetta_g_miss_date_in_map(p5_a28);
352 ddp_clev_rec.name := p5_a29;
353 ddp_clev_rec.start_date := rosetta_g_miss_date_in_map(p5_a30);
354 ddp_clev_rec.end_date := rosetta_g_miss_date_in_map(p5_a31);
355 ddp_clev_rec.date_renewed := rosetta_g_miss_date_in_map(p5_a32);
356 ddp_clev_rec.upg_orig_system_ref := p5_a33;
357 ddp_clev_rec.upg_orig_system_ref_id := rosetta_g_miss_num_map(p5_a34);
358 ddp_clev_rec.orig_system_source_code := p5_a35;
359 ddp_clev_rec.orig_system_id1 := rosetta_g_miss_num_map(p5_a36);
360 ddp_clev_rec.orig_system_reference1 := p5_a37;
361 ddp_clev_rec.attribute_category := p5_a38;
362 ddp_clev_rec.attribute1 := p5_a39;
363 ddp_clev_rec.attribute2 := p5_a40;
364 ddp_clev_rec.attribute3 := p5_a41;
365 ddp_clev_rec.attribute4 := p5_a42;
366 ddp_clev_rec.attribute5 := p5_a43;
367 ddp_clev_rec.attribute6 := p5_a44;
368 ddp_clev_rec.attribute7 := p5_a45;
369 ddp_clev_rec.attribute8 := p5_a46;
370 ddp_clev_rec.attribute9 := p5_a47;
371 ddp_clev_rec.attribute10 := p5_a48;
372 ddp_clev_rec.attribute11 := p5_a49;
373 ddp_clev_rec.attribute12 := p5_a50;
374 ddp_clev_rec.attribute13 := p5_a51;
375 ddp_clev_rec.attribute14 := p5_a52;
376 ddp_clev_rec.attribute15 := p5_a53;
377 ddp_clev_rec.created_by := rosetta_g_miss_num_map(p5_a54);
378 ddp_clev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
379 ddp_clev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
380 ddp_clev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
381 ddp_clev_rec.price_type := p5_a58;
382 ddp_clev_rec.currency_code := p5_a59;
383 ddp_clev_rec.currency_code_renewed := p5_a60;
384 ddp_clev_rec.last_update_login := rosetta_g_miss_num_map(p5_a61);
385 ddp_clev_rec.old_sts_code := p5_a62;
386 ddp_clev_rec.new_sts_code := p5_a63;
387 ddp_clev_rec.old_ste_code := p5_a64;
388 ddp_clev_rec.new_ste_code := p5_a65;
389 ddp_clev_rec.call_action_asmblr := p5_a66;
390 ddp_clev_rec.request_id := rosetta_g_miss_num_map(p5_a67);
391 ddp_clev_rec.program_application_id := rosetta_g_miss_num_map(p5_a68);
392 ddp_clev_rec.program_id := rosetta_g_miss_num_map(p5_a69);
393 ddp_clev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a70);
394 ddp_clev_rec.price_list_id := rosetta_g_miss_num_map(p5_a71);
395 ddp_clev_rec.pricing_date := rosetta_g_miss_date_in_map(p5_a72);
396 ddp_clev_rec.price_list_line_id := rosetta_g_miss_num_map(p5_a73);
397 ddp_clev_rec.line_list_price := rosetta_g_miss_num_map(p5_a74);
398 ddp_clev_rec.item_to_price_yn := p5_a75;
399 ddp_clev_rec.price_basis_yn := p5_a76;
400 ddp_clev_rec.config_header_id := rosetta_g_miss_num_map(p5_a77);
401 ddp_clev_rec.config_revision_number := rosetta_g_miss_num_map(p5_a78);
402 ddp_clev_rec.config_complete_yn := p5_a79;
403 ddp_clev_rec.config_valid_yn := p5_a80;
404 ddp_clev_rec.config_top_model_line_id := rosetta_g_miss_num_map(p5_a81);
405 ddp_clev_rec.config_item_type := p5_a82;
406 ddp_clev_rec.config_item_id := rosetta_g_miss_num_map(p5_a83);
407 ddp_clev_rec.cust_acct_id := rosetta_g_miss_num_map(p5_a84);
408 ddp_clev_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p5_a85);
409 ddp_clev_rec.inv_rule_id := rosetta_g_miss_num_map(p5_a86);
410 ddp_clev_rec.line_renewal_type_code := p5_a87;
411 ddp_clev_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a88);
412 ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p5_a89);
413
414 ddp_klev_rec.id := rosetta_g_miss_num_map(p6_a0);
415 ddp_klev_rec.object_version_number := rosetta_g_miss_num_map(p6_a1);
416 ddp_klev_rec.kle_id := rosetta_g_miss_num_map(p6_a2);
417 ddp_klev_rec.sty_id := rosetta_g_miss_num_map(p6_a3);
418 ddp_klev_rec.prc_code := p6_a4;
419 ddp_klev_rec.fcg_code := p6_a5;
420 ddp_klev_rec.nty_code := p6_a6;
421 ddp_klev_rec.estimated_oec := rosetta_g_miss_num_map(p6_a7);
422 ddp_klev_rec.lao_amount := rosetta_g_miss_num_map(p6_a8);
423 ddp_klev_rec.title_date := rosetta_g_miss_date_in_map(p6_a9);
424 ddp_klev_rec.fee_charge := rosetta_g_miss_num_map(p6_a10);
425 ddp_klev_rec.lrs_percent := rosetta_g_miss_num_map(p6_a11);
426 ddp_klev_rec.initial_direct_cost := rosetta_g_miss_num_map(p6_a12);
427 ddp_klev_rec.percent_stake := rosetta_g_miss_num_map(p6_a13);
428 ddp_klev_rec.percent := rosetta_g_miss_num_map(p6_a14);
429 ddp_klev_rec.evergreen_percent := rosetta_g_miss_num_map(p6_a15);
430 ddp_klev_rec.amount_stake := rosetta_g_miss_num_map(p6_a16);
431 ddp_klev_rec.occupancy := rosetta_g_miss_num_map(p6_a17);
432 ddp_klev_rec.coverage := rosetta_g_miss_num_map(p6_a18);
433 ddp_klev_rec.residual_percentage := rosetta_g_miss_num_map(p6_a19);
434 ddp_klev_rec.date_last_inspection := rosetta_g_miss_date_in_map(p6_a20);
435 ddp_klev_rec.date_sold := rosetta_g_miss_date_in_map(p6_a21);
436 ddp_klev_rec.lrv_amount := rosetta_g_miss_num_map(p6_a22);
437 ddp_klev_rec.capital_reduction := rosetta_g_miss_num_map(p6_a23);
438 ddp_klev_rec.date_next_inspection_due := rosetta_g_miss_date_in_map(p6_a24);
439 ddp_klev_rec.date_residual_last_review := rosetta_g_miss_date_in_map(p6_a25);
440 ddp_klev_rec.date_last_reamortisation := rosetta_g_miss_date_in_map(p6_a26);
441 ddp_klev_rec.vendor_advance_paid := rosetta_g_miss_num_map(p6_a27);
442 ddp_klev_rec.weighted_average_life := rosetta_g_miss_num_map(p6_a28);
443 ddp_klev_rec.tradein_amount := rosetta_g_miss_num_map(p6_a29);
444 ddp_klev_rec.bond_equivalent_yield := rosetta_g_miss_num_map(p6_a30);
445 ddp_klev_rec.termination_purchase_amount := rosetta_g_miss_num_map(p6_a31);
446 ddp_klev_rec.refinance_amount := rosetta_g_miss_num_map(p6_a32);
447 ddp_klev_rec.year_built := rosetta_g_miss_num_map(p6_a33);
448 ddp_klev_rec.delivered_date := rosetta_g_miss_date_in_map(p6_a34);
449 ddp_klev_rec.credit_tenant_yn := p6_a35;
450 ddp_klev_rec.date_last_cleanup := rosetta_g_miss_date_in_map(p6_a36);
451 ddp_klev_rec.year_of_manufacture := p6_a37;
452 ddp_klev_rec.coverage_ratio := rosetta_g_miss_num_map(p6_a38);
453 ddp_klev_rec.remarketed_amount := rosetta_g_miss_num_map(p6_a39);
454 ddp_klev_rec.gross_square_footage := rosetta_g_miss_num_map(p6_a40);
455 ddp_klev_rec.prescribed_asset_yn := p6_a41;
456 ddp_klev_rec.date_remarketed := rosetta_g_miss_date_in_map(p6_a42);
457 ddp_klev_rec.net_rentable := rosetta_g_miss_num_map(p6_a43);
458 ddp_klev_rec.remarket_margin := rosetta_g_miss_num_map(p6_a44);
459 ddp_klev_rec.date_letter_acceptance := rosetta_g_miss_date_in_map(p6_a45);
460 ddp_klev_rec.repurchased_amount := rosetta_g_miss_num_map(p6_a46);
461 ddp_klev_rec.date_commitment_expiration := rosetta_g_miss_date_in_map(p6_a47);
462 ddp_klev_rec.date_repurchased := rosetta_g_miss_date_in_map(p6_a48);
463 ddp_klev_rec.date_appraisal := rosetta_g_miss_date_in_map(p6_a49);
464 ddp_klev_rec.residual_value := rosetta_g_miss_num_map(p6_a50);
465 ddp_klev_rec.appraisal_value := rosetta_g_miss_num_map(p6_a51);
466 ddp_klev_rec.secured_deal_yn := p6_a52;
467 ddp_klev_rec.gain_loss := rosetta_g_miss_num_map(p6_a53);
468 ddp_klev_rec.floor_amount := rosetta_g_miss_num_map(p6_a54);
469 ddp_klev_rec.re_lease_yn := p6_a55;
470 ddp_klev_rec.previous_contract := p6_a56;
471 ddp_klev_rec.tracked_residual := rosetta_g_miss_num_map(p6_a57);
472 ddp_klev_rec.date_title_received := rosetta_g_miss_date_in_map(p6_a58);
473 ddp_klev_rec.amount := rosetta_g_miss_num_map(p6_a59);
474 ddp_klev_rec.attribute_category := p6_a60;
475 ddp_klev_rec.attribute1 := p6_a61;
476 ddp_klev_rec.attribute2 := p6_a62;
477 ddp_klev_rec.attribute3 := p6_a63;
478 ddp_klev_rec.attribute4 := p6_a64;
479 ddp_klev_rec.attribute5 := p6_a65;
480 ddp_klev_rec.attribute6 := p6_a66;
481 ddp_klev_rec.attribute7 := p6_a67;
482 ddp_klev_rec.attribute8 := p6_a68;
483 ddp_klev_rec.attribute9 := p6_a69;
484 ddp_klev_rec.attribute10 := p6_a70;
485 ddp_klev_rec.attribute11 := p6_a71;
486 ddp_klev_rec.attribute12 := p6_a72;
487 ddp_klev_rec.attribute13 := p6_a73;
488 ddp_klev_rec.attribute14 := p6_a74;
489 ddp_klev_rec.attribute15 := p6_a75;
490 ddp_klev_rec.sty_id_for := rosetta_g_miss_num_map(p6_a76);
491 ddp_klev_rec.clg_id := rosetta_g_miss_num_map(p6_a77);
492 ddp_klev_rec.created_by := rosetta_g_miss_num_map(p6_a78);
493 ddp_klev_rec.creation_date := rosetta_g_miss_date_in_map(p6_a79);
494 ddp_klev_rec.last_updated_by := rosetta_g_miss_num_map(p6_a80);
495 ddp_klev_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a81);
496 ddp_klev_rec.last_update_login := rosetta_g_miss_num_map(p6_a82);
497 ddp_klev_rec.date_funding := rosetta_g_miss_date_in_map(p6_a83);
498 ddp_klev_rec.date_funding_required := rosetta_g_miss_date_in_map(p6_a84);
499 ddp_klev_rec.date_accepted := rosetta_g_miss_date_in_map(p6_a85);
500 ddp_klev_rec.date_delivery_expected := rosetta_g_miss_date_in_map(p6_a86);
501 ddp_klev_rec.oec := rosetta_g_miss_num_map(p6_a87);
502 ddp_klev_rec.capital_amount := rosetta_g_miss_num_map(p6_a88);
503 ddp_klev_rec.residual_grnty_amount := rosetta_g_miss_num_map(p6_a89);
504 ddp_klev_rec.residual_code := p6_a90;
505 ddp_klev_rec.rvi_premium := rosetta_g_miss_num_map(p6_a91);
506 ddp_klev_rec.credit_nature := p6_a92;
507 ddp_klev_rec.capitalized_interest := rosetta_g_miss_num_map(p6_a93);
508 ddp_klev_rec.capital_reduction_percent := rosetta_g_miss_num_map(p6_a94);
509 ddp_klev_rec.date_pay_investor_start := rosetta_g_miss_date_in_map(p6_a95);
510 ddp_klev_rec.pay_investor_frequency := p6_a96;
511 ddp_klev_rec.pay_investor_event := p6_a97;
512 ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p6_a98);
513
514 -- here's the delegated call to the old PL/SQL routine
515 okl_service_integration_pvt.delete_service_line(p_api_version,
516 p_init_msg_list,
517 x_return_status,
518 x_msg_count,
519 x_msg_data,
520 ddp_clev_rec,
521 ddp_klev_rec);
522
523 -- copy data back from the local variables to OUT or IN-OUT args, if any
524
525
526
527
528
529
530 end;
531
532 procedure get_service_link_line(p_api_version NUMBER
533 , p_init_msg_list VARCHAR2
534 , x_return_status out nocopy VARCHAR2
535 , x_msg_count out nocopy NUMBER
536 , x_msg_data out nocopy VARCHAR2
537 , p_lease_contract_id NUMBER
538 , p6_a0 out nocopy JTF_NUMBER_TABLE
539 , p6_a1 out nocopy JTF_NUMBER_TABLE
540 , x_service_contract_id out nocopy NUMBER
541 )
542
543 as
544 ddx_link_line_tbl okl_service_integration_pvt.link_line_tbl_type;
545 ddindx binary_integer; indx binary_integer;
546 begin
547
548 -- copy data to the local IN or IN-OUT args, if any
549
550
551
552
553
554
555
556
557 -- here's the delegated call to the old PL/SQL routine
558 okl_service_integration_pvt.get_service_link_line(p_api_version,
559 p_init_msg_list,
560 x_return_status,
561 x_msg_count,
562 x_msg_data,
563 p_lease_contract_id,
564 ddx_link_line_tbl,
565 x_service_contract_id);
566
567 -- copy data back from the local variables to OUT or IN-OUT args, if any
568
569
570
571
572
573
574 okl_service_integration_pvt_w.rosetta_table_copy_out_p19(ddx_link_line_tbl, p6_a0
575 , p6_a1
576 );
577
578 end;
579
580 procedure update_service_line(p_api_version NUMBER
581 , p_init_msg_list VARCHAR2
582 , x_return_status out nocopy VARCHAR2
583 , x_msg_count out nocopy NUMBER
584 , x_msg_data out nocopy VARCHAR2
585 , p_okl_chr_id NUMBER
586 , p_oks_chr_id NUMBER
587 , p_oks_service_line_id NUMBER
588 , p_supplier_id NUMBER
589 , x_okl_service_line_id out nocopy NUMBER
590 , p9_a0 NUMBER := 0-1962.0724
591 , p9_a1 NUMBER := 0-1962.0724
592 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
593 , p9_a3 NUMBER := 0-1962.0724
594 , p9_a4 NUMBER := 0-1962.0724
595 , p9_a5 NUMBER := 0-1962.0724
596 , p9_a6 NUMBER := 0-1962.0724
597 , p9_a7 NUMBER := 0-1962.0724
598 , p9_a8 VARCHAR2 := fnd_api.g_miss_char
599 , p9_a9 VARCHAR2 := fnd_api.g_miss_char
600 , p9_a10 NUMBER := 0-1962.0724
601 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
602 , p9_a12 NUMBER := 0-1962.0724
603 , p9_a13 VARCHAR2 := fnd_api.g_miss_char
604 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
605 , p9_a15 VARCHAR2 := fnd_api.g_miss_char
606 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
607 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
608 , p9_a18 NUMBER := 0-1962.0724
609 , p9_a19 NUMBER := 0-1962.0724
610 , p9_a20 NUMBER := 0-1962.0724
611 , p9_a21 NUMBER := 0-1962.0724
612 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
613 , p9_a23 VARCHAR2 := fnd_api.g_miss_char
614 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
615 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
616 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
617 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
618 , p9_a28 DATE := fnd_api.g_miss_date
619 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
620 , p9_a30 DATE := fnd_api.g_miss_date
621 , p9_a31 DATE := fnd_api.g_miss_date
622 , p9_a32 DATE := fnd_api.g_miss_date
623 , p9_a33 VARCHAR2 := fnd_api.g_miss_char
624 , p9_a34 NUMBER := 0-1962.0724
625 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
626 , p9_a36 NUMBER := 0-1962.0724
627 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
628 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
629 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
630 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
631 , p9_a41 VARCHAR2 := fnd_api.g_miss_char
632 , p9_a42 VARCHAR2 := fnd_api.g_miss_char
633 , p9_a43 VARCHAR2 := fnd_api.g_miss_char
634 , p9_a44 VARCHAR2 := fnd_api.g_miss_char
635 , p9_a45 VARCHAR2 := fnd_api.g_miss_char
636 , p9_a46 VARCHAR2 := fnd_api.g_miss_char
637 , p9_a47 VARCHAR2 := fnd_api.g_miss_char
638 , p9_a48 VARCHAR2 := fnd_api.g_miss_char
639 , p9_a49 VARCHAR2 := fnd_api.g_miss_char
640 , p9_a50 VARCHAR2 := fnd_api.g_miss_char
641 , p9_a51 VARCHAR2 := fnd_api.g_miss_char
642 , p9_a52 VARCHAR2 := fnd_api.g_miss_char
643 , p9_a53 VARCHAR2 := fnd_api.g_miss_char
644 , p9_a54 NUMBER := 0-1962.0724
645 , p9_a55 DATE := fnd_api.g_miss_date
646 , p9_a56 NUMBER := 0-1962.0724
647 , p9_a57 DATE := fnd_api.g_miss_date
648 , p9_a58 VARCHAR2 := fnd_api.g_miss_char
649 , p9_a59 VARCHAR2 := fnd_api.g_miss_char
650 , p9_a60 VARCHAR2 := fnd_api.g_miss_char
651 , p9_a61 NUMBER := 0-1962.0724
652 , p9_a62 VARCHAR2 := fnd_api.g_miss_char
653 , p9_a63 VARCHAR2 := fnd_api.g_miss_char
654 , p9_a64 VARCHAR2 := fnd_api.g_miss_char
655 , p9_a65 VARCHAR2 := fnd_api.g_miss_char
656 , p9_a66 VARCHAR2 := fnd_api.g_miss_char
657 , p9_a67 NUMBER := 0-1962.0724
658 , p9_a68 NUMBER := 0-1962.0724
659 , p9_a69 NUMBER := 0-1962.0724
660 , p9_a70 DATE := fnd_api.g_miss_date
661 , p9_a71 NUMBER := 0-1962.0724
662 , p9_a72 DATE := fnd_api.g_miss_date
663 , p9_a73 NUMBER := 0-1962.0724
664 , p9_a74 NUMBER := 0-1962.0724
665 , p9_a75 VARCHAR2 := fnd_api.g_miss_char
666 , p9_a76 VARCHAR2 := fnd_api.g_miss_char
667 , p9_a77 NUMBER := 0-1962.0724
668 , p9_a78 NUMBER := 0-1962.0724
669 , p9_a79 VARCHAR2 := fnd_api.g_miss_char
670 , p9_a80 VARCHAR2 := fnd_api.g_miss_char
671 , p9_a81 NUMBER := 0-1962.0724
672 , p9_a82 VARCHAR2 := fnd_api.g_miss_char
673 , p9_a83 NUMBER := 0-1962.0724
674 , p9_a84 NUMBER := 0-1962.0724
675 , p9_a85 NUMBER := 0-1962.0724
676 , p9_a86 NUMBER := 0-1962.0724
677 , p9_a87 VARCHAR2 := fnd_api.g_miss_char
678 , p9_a88 NUMBER := 0-1962.0724
679 , p9_a89 NUMBER := 0-1962.0724
680 , p10_a0 NUMBER := 0-1962.0724
681 , p10_a1 NUMBER := 0-1962.0724
682 , p10_a2 NUMBER := 0-1962.0724
683 , p10_a3 NUMBER := 0-1962.0724
684 , p10_a4 VARCHAR2 := fnd_api.g_miss_char
685 , p10_a5 VARCHAR2 := fnd_api.g_miss_char
686 , p10_a6 VARCHAR2 := fnd_api.g_miss_char
687 , p10_a7 NUMBER := 0-1962.0724
688 , p10_a8 NUMBER := 0-1962.0724
689 , p10_a9 DATE := fnd_api.g_miss_date
690 , p10_a10 NUMBER := 0-1962.0724
691 , p10_a11 NUMBER := 0-1962.0724
692 , p10_a12 NUMBER := 0-1962.0724
693 , p10_a13 NUMBER := 0-1962.0724
694 , p10_a14 NUMBER := 0-1962.0724
695 , p10_a15 NUMBER := 0-1962.0724
696 , p10_a16 NUMBER := 0-1962.0724
697 , p10_a17 NUMBER := 0-1962.0724
698 , p10_a18 NUMBER := 0-1962.0724
699 , p10_a19 NUMBER := 0-1962.0724
700 , p10_a20 DATE := fnd_api.g_miss_date
701 , p10_a21 DATE := fnd_api.g_miss_date
702 , p10_a22 NUMBER := 0-1962.0724
703 , p10_a23 NUMBER := 0-1962.0724
704 , p10_a24 DATE := fnd_api.g_miss_date
705 , p10_a25 DATE := fnd_api.g_miss_date
706 , p10_a26 DATE := fnd_api.g_miss_date
707 , p10_a27 NUMBER := 0-1962.0724
708 , p10_a28 NUMBER := 0-1962.0724
709 , p10_a29 NUMBER := 0-1962.0724
710 , p10_a30 NUMBER := 0-1962.0724
711 , p10_a31 NUMBER := 0-1962.0724
712 , p10_a32 NUMBER := 0-1962.0724
713 , p10_a33 NUMBER := 0-1962.0724
714 , p10_a34 DATE := fnd_api.g_miss_date
715 , p10_a35 VARCHAR2 := fnd_api.g_miss_char
716 , p10_a36 DATE := fnd_api.g_miss_date
717 , p10_a37 VARCHAR2 := fnd_api.g_miss_char
718 , p10_a38 NUMBER := 0-1962.0724
719 , p10_a39 NUMBER := 0-1962.0724
720 , p10_a40 NUMBER := 0-1962.0724
721 , p10_a41 VARCHAR2 := fnd_api.g_miss_char
722 , p10_a42 DATE := fnd_api.g_miss_date
723 , p10_a43 NUMBER := 0-1962.0724
724 , p10_a44 NUMBER := 0-1962.0724
725 , p10_a45 DATE := fnd_api.g_miss_date
726 , p10_a46 NUMBER := 0-1962.0724
727 , p10_a47 DATE := fnd_api.g_miss_date
728 , p10_a48 DATE := fnd_api.g_miss_date
729 , p10_a49 DATE := fnd_api.g_miss_date
730 , p10_a50 NUMBER := 0-1962.0724
731 , p10_a51 NUMBER := 0-1962.0724
732 , p10_a52 VARCHAR2 := fnd_api.g_miss_char
733 , p10_a53 NUMBER := 0-1962.0724
734 , p10_a54 NUMBER := 0-1962.0724
735 , p10_a55 VARCHAR2 := fnd_api.g_miss_char
736 , p10_a56 VARCHAR2 := fnd_api.g_miss_char
737 , p10_a57 NUMBER := 0-1962.0724
738 , p10_a58 DATE := fnd_api.g_miss_date
739 , p10_a59 NUMBER := 0-1962.0724
740 , p10_a60 VARCHAR2 := fnd_api.g_miss_char
741 , p10_a61 VARCHAR2 := fnd_api.g_miss_char
742 , p10_a62 VARCHAR2 := fnd_api.g_miss_char
743 , p10_a63 VARCHAR2 := fnd_api.g_miss_char
744 , p10_a64 VARCHAR2 := fnd_api.g_miss_char
745 , p10_a65 VARCHAR2 := fnd_api.g_miss_char
746 , p10_a66 VARCHAR2 := fnd_api.g_miss_char
747 , p10_a67 VARCHAR2 := fnd_api.g_miss_char
748 , p10_a68 VARCHAR2 := fnd_api.g_miss_char
749 , p10_a69 VARCHAR2 := fnd_api.g_miss_char
750 , p10_a70 VARCHAR2 := fnd_api.g_miss_char
751 , p10_a71 VARCHAR2 := fnd_api.g_miss_char
752 , p10_a72 VARCHAR2 := fnd_api.g_miss_char
753 , p10_a73 VARCHAR2 := fnd_api.g_miss_char
754 , p10_a74 VARCHAR2 := fnd_api.g_miss_char
755 , p10_a75 VARCHAR2 := fnd_api.g_miss_char
756 , p10_a76 NUMBER := 0-1962.0724
757 , p10_a77 NUMBER := 0-1962.0724
758 , p10_a78 NUMBER := 0-1962.0724
759 , p10_a79 DATE := fnd_api.g_miss_date
760 , p10_a80 NUMBER := 0-1962.0724
761 , p10_a81 DATE := fnd_api.g_miss_date
762 , p10_a82 NUMBER := 0-1962.0724
763 , p10_a83 DATE := fnd_api.g_miss_date
764 , p10_a84 DATE := fnd_api.g_miss_date
765 , p10_a85 DATE := fnd_api.g_miss_date
766 , p10_a86 DATE := fnd_api.g_miss_date
767 , p10_a87 NUMBER := 0-1962.0724
768 , p10_a88 NUMBER := 0-1962.0724
769 , p10_a89 NUMBER := 0-1962.0724
770 , p10_a90 VARCHAR2 := fnd_api.g_miss_char
771 , p10_a91 NUMBER := 0-1962.0724
772 , p10_a92 VARCHAR2 := fnd_api.g_miss_char
773 , p10_a93 NUMBER := 0-1962.0724
774 , p10_a94 NUMBER := 0-1962.0724
775 , p10_a95 DATE := fnd_api.g_miss_date
776 , p10_a96 VARCHAR2 := fnd_api.g_miss_char
777 , p10_a97 VARCHAR2 := fnd_api.g_miss_char
778 , p10_a98 NUMBER := 0-1962.0724
779 )
780
781 as
782 ddp_clev_rec okl_service_integration_pvt.clev_rec_type;
783 ddp_klev_rec okl_service_integration_pvt.klev_rec_type;
784 ddindx binary_integer; indx binary_integer;
785 begin
786
787 -- copy data to the local IN or IN-OUT args, if any
788
789
790
791
792
793
794
795
796
797 ddp_clev_rec.id := rosetta_g_miss_num_map(p9_a0);
798 ddp_clev_rec.object_version_number := rosetta_g_miss_num_map(p9_a1);
799 ddp_clev_rec.sfwt_flag := p9_a2;
800 ddp_clev_rec.chr_id := rosetta_g_miss_num_map(p9_a3);
801 ddp_clev_rec.cle_id := rosetta_g_miss_num_map(p9_a4);
802 ddp_clev_rec.cle_id_renewed := rosetta_g_miss_num_map(p9_a5);
803 ddp_clev_rec.cle_id_renewed_to := rosetta_g_miss_num_map(p9_a6);
804 ddp_clev_rec.lse_id := rosetta_g_miss_num_map(p9_a7);
805 ddp_clev_rec.line_number := p9_a8;
806 ddp_clev_rec.sts_code := p9_a9;
807 ddp_clev_rec.display_sequence := rosetta_g_miss_num_map(p9_a10);
808 ddp_clev_rec.trn_code := p9_a11;
809 ddp_clev_rec.dnz_chr_id := rosetta_g_miss_num_map(p9_a12);
810 ddp_clev_rec.comments := p9_a13;
811 ddp_clev_rec.item_description := p9_a14;
812 ddp_clev_rec.oke_boe_description := p9_a15;
813 ddp_clev_rec.cognomen := p9_a16;
814 ddp_clev_rec.hidden_ind := p9_a17;
815 ddp_clev_rec.price_unit := rosetta_g_miss_num_map(p9_a18);
816 ddp_clev_rec.price_unit_percent := rosetta_g_miss_num_map(p9_a19);
817 ddp_clev_rec.price_negotiated := rosetta_g_miss_num_map(p9_a20);
818 ddp_clev_rec.price_negotiated_renewed := rosetta_g_miss_num_map(p9_a21);
819 ddp_clev_rec.price_level_ind := p9_a22;
820 ddp_clev_rec.invoice_line_level_ind := p9_a23;
821 ddp_clev_rec.dpas_rating := p9_a24;
822 ddp_clev_rec.block23text := p9_a25;
823 ddp_clev_rec.exception_yn := p9_a26;
824 ddp_clev_rec.template_used := p9_a27;
825 ddp_clev_rec.date_terminated := rosetta_g_miss_date_in_map(p9_a28);
826 ddp_clev_rec.name := p9_a29;
827 ddp_clev_rec.start_date := rosetta_g_miss_date_in_map(p9_a30);
828 ddp_clev_rec.end_date := rosetta_g_miss_date_in_map(p9_a31);
829 ddp_clev_rec.date_renewed := rosetta_g_miss_date_in_map(p9_a32);
830 ddp_clev_rec.upg_orig_system_ref := p9_a33;
831 ddp_clev_rec.upg_orig_system_ref_id := rosetta_g_miss_num_map(p9_a34);
832 ddp_clev_rec.orig_system_source_code := p9_a35;
833 ddp_clev_rec.orig_system_id1 := rosetta_g_miss_num_map(p9_a36);
834 ddp_clev_rec.orig_system_reference1 := p9_a37;
835 ddp_clev_rec.attribute_category := p9_a38;
836 ddp_clev_rec.attribute1 := p9_a39;
837 ddp_clev_rec.attribute2 := p9_a40;
838 ddp_clev_rec.attribute3 := p9_a41;
839 ddp_clev_rec.attribute4 := p9_a42;
840 ddp_clev_rec.attribute5 := p9_a43;
841 ddp_clev_rec.attribute6 := p9_a44;
842 ddp_clev_rec.attribute7 := p9_a45;
843 ddp_clev_rec.attribute8 := p9_a46;
844 ddp_clev_rec.attribute9 := p9_a47;
845 ddp_clev_rec.attribute10 := p9_a48;
846 ddp_clev_rec.attribute11 := p9_a49;
847 ddp_clev_rec.attribute12 := p9_a50;
848 ddp_clev_rec.attribute13 := p9_a51;
849 ddp_clev_rec.attribute14 := p9_a52;
850 ddp_clev_rec.attribute15 := p9_a53;
851 ddp_clev_rec.created_by := rosetta_g_miss_num_map(p9_a54);
852 ddp_clev_rec.creation_date := rosetta_g_miss_date_in_map(p9_a55);
853 ddp_clev_rec.last_updated_by := rosetta_g_miss_num_map(p9_a56);
854 ddp_clev_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a57);
855 ddp_clev_rec.price_type := p9_a58;
856 ddp_clev_rec.currency_code := p9_a59;
857 ddp_clev_rec.currency_code_renewed := p9_a60;
858 ddp_clev_rec.last_update_login := rosetta_g_miss_num_map(p9_a61);
859 ddp_clev_rec.old_sts_code := p9_a62;
860 ddp_clev_rec.new_sts_code := p9_a63;
861 ddp_clev_rec.old_ste_code := p9_a64;
862 ddp_clev_rec.new_ste_code := p9_a65;
863 ddp_clev_rec.call_action_asmblr := p9_a66;
864 ddp_clev_rec.request_id := rosetta_g_miss_num_map(p9_a67);
865 ddp_clev_rec.program_application_id := rosetta_g_miss_num_map(p9_a68);
866 ddp_clev_rec.program_id := rosetta_g_miss_num_map(p9_a69);
867 ddp_clev_rec.program_update_date := rosetta_g_miss_date_in_map(p9_a70);
868 ddp_clev_rec.price_list_id := rosetta_g_miss_num_map(p9_a71);
869 ddp_clev_rec.pricing_date := rosetta_g_miss_date_in_map(p9_a72);
870 ddp_clev_rec.price_list_line_id := rosetta_g_miss_num_map(p9_a73);
871 ddp_clev_rec.line_list_price := rosetta_g_miss_num_map(p9_a74);
872 ddp_clev_rec.item_to_price_yn := p9_a75;
873 ddp_clev_rec.price_basis_yn := p9_a76;
874 ddp_clev_rec.config_header_id := rosetta_g_miss_num_map(p9_a77);
875 ddp_clev_rec.config_revision_number := rosetta_g_miss_num_map(p9_a78);
876 ddp_clev_rec.config_complete_yn := p9_a79;
877 ddp_clev_rec.config_valid_yn := p9_a80;
878 ddp_clev_rec.config_top_model_line_id := rosetta_g_miss_num_map(p9_a81);
879 ddp_clev_rec.config_item_type := p9_a82;
880 ddp_clev_rec.config_item_id := rosetta_g_miss_num_map(p9_a83);
881 ddp_clev_rec.cust_acct_id := rosetta_g_miss_num_map(p9_a84);
882 ddp_clev_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p9_a85);
883 ddp_clev_rec.inv_rule_id := rosetta_g_miss_num_map(p9_a86);
884 ddp_clev_rec.line_renewal_type_code := p9_a87;
885 ddp_clev_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p9_a88);
886 ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p9_a89);
887
888 ddp_klev_rec.id := rosetta_g_miss_num_map(p10_a0);
889 ddp_klev_rec.object_version_number := rosetta_g_miss_num_map(p10_a1);
890 ddp_klev_rec.kle_id := rosetta_g_miss_num_map(p10_a2);
891 ddp_klev_rec.sty_id := rosetta_g_miss_num_map(p10_a3);
892 ddp_klev_rec.prc_code := p10_a4;
893 ddp_klev_rec.fcg_code := p10_a5;
894 ddp_klev_rec.nty_code := p10_a6;
895 ddp_klev_rec.estimated_oec := rosetta_g_miss_num_map(p10_a7);
896 ddp_klev_rec.lao_amount := rosetta_g_miss_num_map(p10_a8);
897 ddp_klev_rec.title_date := rosetta_g_miss_date_in_map(p10_a9);
898 ddp_klev_rec.fee_charge := rosetta_g_miss_num_map(p10_a10);
899 ddp_klev_rec.lrs_percent := rosetta_g_miss_num_map(p10_a11);
900 ddp_klev_rec.initial_direct_cost := rosetta_g_miss_num_map(p10_a12);
901 ddp_klev_rec.percent_stake := rosetta_g_miss_num_map(p10_a13);
902 ddp_klev_rec.percent := rosetta_g_miss_num_map(p10_a14);
903 ddp_klev_rec.evergreen_percent := rosetta_g_miss_num_map(p10_a15);
904 ddp_klev_rec.amount_stake := rosetta_g_miss_num_map(p10_a16);
905 ddp_klev_rec.occupancy := rosetta_g_miss_num_map(p10_a17);
906 ddp_klev_rec.coverage := rosetta_g_miss_num_map(p10_a18);
907 ddp_klev_rec.residual_percentage := rosetta_g_miss_num_map(p10_a19);
908 ddp_klev_rec.date_last_inspection := rosetta_g_miss_date_in_map(p10_a20);
909 ddp_klev_rec.date_sold := rosetta_g_miss_date_in_map(p10_a21);
910 ddp_klev_rec.lrv_amount := rosetta_g_miss_num_map(p10_a22);
911 ddp_klev_rec.capital_reduction := rosetta_g_miss_num_map(p10_a23);
912 ddp_klev_rec.date_next_inspection_due := rosetta_g_miss_date_in_map(p10_a24);
913 ddp_klev_rec.date_residual_last_review := rosetta_g_miss_date_in_map(p10_a25);
914 ddp_klev_rec.date_last_reamortisation := rosetta_g_miss_date_in_map(p10_a26);
915 ddp_klev_rec.vendor_advance_paid := rosetta_g_miss_num_map(p10_a27);
916 ddp_klev_rec.weighted_average_life := rosetta_g_miss_num_map(p10_a28);
917 ddp_klev_rec.tradein_amount := rosetta_g_miss_num_map(p10_a29);
918 ddp_klev_rec.bond_equivalent_yield := rosetta_g_miss_num_map(p10_a30);
919 ddp_klev_rec.termination_purchase_amount := rosetta_g_miss_num_map(p10_a31);
920 ddp_klev_rec.refinance_amount := rosetta_g_miss_num_map(p10_a32);
921 ddp_klev_rec.year_built := rosetta_g_miss_num_map(p10_a33);
922 ddp_klev_rec.delivered_date := rosetta_g_miss_date_in_map(p10_a34);
923 ddp_klev_rec.credit_tenant_yn := p10_a35;
924 ddp_klev_rec.date_last_cleanup := rosetta_g_miss_date_in_map(p10_a36);
925 ddp_klev_rec.year_of_manufacture := p10_a37;
926 ddp_klev_rec.coverage_ratio := rosetta_g_miss_num_map(p10_a38);
927 ddp_klev_rec.remarketed_amount := rosetta_g_miss_num_map(p10_a39);
928 ddp_klev_rec.gross_square_footage := rosetta_g_miss_num_map(p10_a40);
929 ddp_klev_rec.prescribed_asset_yn := p10_a41;
930 ddp_klev_rec.date_remarketed := rosetta_g_miss_date_in_map(p10_a42);
931 ddp_klev_rec.net_rentable := rosetta_g_miss_num_map(p10_a43);
932 ddp_klev_rec.remarket_margin := rosetta_g_miss_num_map(p10_a44);
933 ddp_klev_rec.date_letter_acceptance := rosetta_g_miss_date_in_map(p10_a45);
934 ddp_klev_rec.repurchased_amount := rosetta_g_miss_num_map(p10_a46);
935 ddp_klev_rec.date_commitment_expiration := rosetta_g_miss_date_in_map(p10_a47);
936 ddp_klev_rec.date_repurchased := rosetta_g_miss_date_in_map(p10_a48);
937 ddp_klev_rec.date_appraisal := rosetta_g_miss_date_in_map(p10_a49);
938 ddp_klev_rec.residual_value := rosetta_g_miss_num_map(p10_a50);
939 ddp_klev_rec.appraisal_value := rosetta_g_miss_num_map(p10_a51);
940 ddp_klev_rec.secured_deal_yn := p10_a52;
941 ddp_klev_rec.gain_loss := rosetta_g_miss_num_map(p10_a53);
942 ddp_klev_rec.floor_amount := rosetta_g_miss_num_map(p10_a54);
943 ddp_klev_rec.re_lease_yn := p10_a55;
944 ddp_klev_rec.previous_contract := p10_a56;
945 ddp_klev_rec.tracked_residual := rosetta_g_miss_num_map(p10_a57);
946 ddp_klev_rec.date_title_received := rosetta_g_miss_date_in_map(p10_a58);
947 ddp_klev_rec.amount := rosetta_g_miss_num_map(p10_a59);
948 ddp_klev_rec.attribute_category := p10_a60;
949 ddp_klev_rec.attribute1 := p10_a61;
950 ddp_klev_rec.attribute2 := p10_a62;
951 ddp_klev_rec.attribute3 := p10_a63;
952 ddp_klev_rec.attribute4 := p10_a64;
953 ddp_klev_rec.attribute5 := p10_a65;
954 ddp_klev_rec.attribute6 := p10_a66;
955 ddp_klev_rec.attribute7 := p10_a67;
956 ddp_klev_rec.attribute8 := p10_a68;
957 ddp_klev_rec.attribute9 := p10_a69;
958 ddp_klev_rec.attribute10 := p10_a70;
959 ddp_klev_rec.attribute11 := p10_a71;
960 ddp_klev_rec.attribute12 := p10_a72;
961 ddp_klev_rec.attribute13 := p10_a73;
962 ddp_klev_rec.attribute14 := p10_a74;
963 ddp_klev_rec.attribute15 := p10_a75;
964 ddp_klev_rec.sty_id_for := rosetta_g_miss_num_map(p10_a76);
965 ddp_klev_rec.clg_id := rosetta_g_miss_num_map(p10_a77);
966 ddp_klev_rec.created_by := rosetta_g_miss_num_map(p10_a78);
967 ddp_klev_rec.creation_date := rosetta_g_miss_date_in_map(p10_a79);
968 ddp_klev_rec.last_updated_by := rosetta_g_miss_num_map(p10_a80);
969 ddp_klev_rec.last_update_date := rosetta_g_miss_date_in_map(p10_a81);
970 ddp_klev_rec.last_update_login := rosetta_g_miss_num_map(p10_a82);
971 ddp_klev_rec.date_funding := rosetta_g_miss_date_in_map(p10_a83);
972 ddp_klev_rec.date_funding_required := rosetta_g_miss_date_in_map(p10_a84);
973 ddp_klev_rec.date_accepted := rosetta_g_miss_date_in_map(p10_a85);
974 ddp_klev_rec.date_delivery_expected := rosetta_g_miss_date_in_map(p10_a86);
975 ddp_klev_rec.oec := rosetta_g_miss_num_map(p10_a87);
976 ddp_klev_rec.capital_amount := rosetta_g_miss_num_map(p10_a88);
977 ddp_klev_rec.residual_grnty_amount := rosetta_g_miss_num_map(p10_a89);
978 ddp_klev_rec.residual_code := p10_a90;
979 ddp_klev_rec.rvi_premium := rosetta_g_miss_num_map(p10_a91);
980 ddp_klev_rec.credit_nature := p10_a92;
981 ddp_klev_rec.capitalized_interest := rosetta_g_miss_num_map(p10_a93);
982 ddp_klev_rec.capital_reduction_percent := rosetta_g_miss_num_map(p10_a94);
983 ddp_klev_rec.date_pay_investor_start := rosetta_g_miss_date_in_map(p10_a95);
984 ddp_klev_rec.pay_investor_frequency := p10_a96;
985 ddp_klev_rec.pay_investor_event := p10_a97;
986 ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p10_a98);
987
988
989 -- here's the delegated call to the old PL/SQL routine
990 okl_service_integration_pvt.update_service_line(p_api_version,
991 p_init_msg_list,
992 x_return_status,
993 x_msg_count,
994 x_msg_data,
995 p_okl_chr_id,
996 p_oks_chr_id,
997 p_oks_service_line_id,
998 p_supplier_id,
999 ddp_clev_rec,
1000 ddp_klev_rec,
1001 x_okl_service_line_id);
1002
1003 -- copy data back from the local variables to OUT or IN-OUT args, if any
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015 end;
1016
1017 procedure create_cov_asset_line(p_api_version NUMBER
1018 , p_init_msg_list VARCHAR2
1019 , x_return_status out nocopy VARCHAR2
1020 , x_msg_count out nocopy NUMBER
1021 , x_msg_data out nocopy VARCHAR2
1022 , p5_a0 JTF_NUMBER_TABLE
1023 , p5_a1 JTF_NUMBER_TABLE
1024 , p5_a2 JTF_VARCHAR2_TABLE_100
1025 , p5_a3 JTF_NUMBER_TABLE
1026 , p5_a4 JTF_NUMBER_TABLE
1027 , p5_a5 JTF_NUMBER_TABLE
1028 , p5_a6 JTF_NUMBER_TABLE
1029 , p5_a7 JTF_NUMBER_TABLE
1030 , p5_a8 JTF_VARCHAR2_TABLE_200
1031 , p5_a9 JTF_VARCHAR2_TABLE_100
1032 , p5_a10 JTF_NUMBER_TABLE
1033 , p5_a11 JTF_VARCHAR2_TABLE_100
1034 , p5_a12 JTF_NUMBER_TABLE
1035 , p5_a13 JTF_VARCHAR2_TABLE_2000
1036 , p5_a14 JTF_VARCHAR2_TABLE_2000
1037 , p5_a15 JTF_VARCHAR2_TABLE_2000
1038 , p5_a16 JTF_VARCHAR2_TABLE_300
1039 , p5_a17 JTF_VARCHAR2_TABLE_100
1040 , p5_a18 JTF_NUMBER_TABLE
1041 , p5_a19 JTF_NUMBER_TABLE
1042 , p5_a20 JTF_NUMBER_TABLE
1043 , p5_a21 JTF_NUMBER_TABLE
1044 , p5_a22 JTF_VARCHAR2_TABLE_100
1045 , p5_a23 JTF_VARCHAR2_TABLE_100
1046 , p5_a24 JTF_VARCHAR2_TABLE_100
1047 , p5_a25 JTF_VARCHAR2_TABLE_2000
1048 , p5_a26 JTF_VARCHAR2_TABLE_100
1049 , p5_a27 JTF_VARCHAR2_TABLE_200
1050 , p5_a28 JTF_DATE_TABLE
1051 , p5_a29 JTF_VARCHAR2_TABLE_200
1052 , p5_a30 JTF_DATE_TABLE
1053 , p5_a31 JTF_DATE_TABLE
1054 , p5_a32 JTF_DATE_TABLE
1055 , p5_a33 JTF_VARCHAR2_TABLE_100
1056 , p5_a34 JTF_NUMBER_TABLE
1057 , p5_a35 JTF_VARCHAR2_TABLE_100
1058 , p5_a36 JTF_NUMBER_TABLE
1059 , p5_a37 JTF_VARCHAR2_TABLE_100
1060 , p5_a38 JTF_VARCHAR2_TABLE_100
1061 , p5_a39 JTF_VARCHAR2_TABLE_500
1062 , p5_a40 JTF_VARCHAR2_TABLE_500
1063 , p5_a41 JTF_VARCHAR2_TABLE_500
1064 , p5_a42 JTF_VARCHAR2_TABLE_500
1065 , p5_a43 JTF_VARCHAR2_TABLE_500
1066 , p5_a44 JTF_VARCHAR2_TABLE_500
1067 , p5_a45 JTF_VARCHAR2_TABLE_500
1068 , p5_a46 JTF_VARCHAR2_TABLE_500
1069 , p5_a47 JTF_VARCHAR2_TABLE_500
1070 , p5_a48 JTF_VARCHAR2_TABLE_500
1071 , p5_a49 JTF_VARCHAR2_TABLE_500
1072 , p5_a50 JTF_VARCHAR2_TABLE_500
1073 , p5_a51 JTF_VARCHAR2_TABLE_500
1074 , p5_a52 JTF_VARCHAR2_TABLE_500
1075 , p5_a53 JTF_VARCHAR2_TABLE_500
1076 , p5_a54 JTF_NUMBER_TABLE
1077 , p5_a55 JTF_DATE_TABLE
1078 , p5_a56 JTF_NUMBER_TABLE
1079 , p5_a57 JTF_DATE_TABLE
1080 , p5_a58 JTF_VARCHAR2_TABLE_100
1081 , p5_a59 JTF_VARCHAR2_TABLE_100
1082 , p5_a60 JTF_VARCHAR2_TABLE_100
1083 , p5_a61 JTF_NUMBER_TABLE
1084 , p5_a62 JTF_VARCHAR2_TABLE_100
1085 , p5_a63 JTF_VARCHAR2_TABLE_100
1086 , p5_a64 JTF_VARCHAR2_TABLE_100
1087 , p5_a65 JTF_VARCHAR2_TABLE_100
1088 , p5_a66 JTF_VARCHAR2_TABLE_100
1089 , p5_a67 JTF_NUMBER_TABLE
1090 , p5_a68 JTF_NUMBER_TABLE
1091 , p5_a69 JTF_NUMBER_TABLE
1092 , p5_a70 JTF_DATE_TABLE
1093 , p5_a71 JTF_NUMBER_TABLE
1094 , p5_a72 JTF_DATE_TABLE
1095 , p5_a73 JTF_NUMBER_TABLE
1096 , p5_a74 JTF_NUMBER_TABLE
1097 , p5_a75 JTF_VARCHAR2_TABLE_100
1098 , p5_a76 JTF_VARCHAR2_TABLE_100
1099 , p5_a77 JTF_NUMBER_TABLE
1100 , p5_a78 JTF_NUMBER_TABLE
1101 , p5_a79 JTF_VARCHAR2_TABLE_100
1102 , p5_a80 JTF_VARCHAR2_TABLE_100
1103 , p5_a81 JTF_NUMBER_TABLE
1104 , p5_a82 JTF_VARCHAR2_TABLE_100
1105 , p5_a83 JTF_NUMBER_TABLE
1106 , p5_a84 JTF_NUMBER_TABLE
1107 , p5_a85 JTF_NUMBER_TABLE
1108 , p5_a86 JTF_NUMBER_TABLE
1109 , p5_a87 JTF_VARCHAR2_TABLE_100
1110 , p5_a88 JTF_NUMBER_TABLE
1111 , p5_a89 JTF_NUMBER_TABLE
1112 , p6_a0 JTF_NUMBER_TABLE
1113 , p6_a1 JTF_NUMBER_TABLE
1114 , p6_a2 JTF_NUMBER_TABLE
1115 , p6_a3 JTF_NUMBER_TABLE
1116 , p6_a4 JTF_VARCHAR2_TABLE_100
1117 , p6_a5 JTF_VARCHAR2_TABLE_100
1118 , p6_a6 JTF_VARCHAR2_TABLE_100
1119 , p6_a7 JTF_NUMBER_TABLE
1120 , p6_a8 JTF_NUMBER_TABLE
1121 , p6_a9 JTF_DATE_TABLE
1122 , p6_a10 JTF_NUMBER_TABLE
1123 , p6_a11 JTF_NUMBER_TABLE
1124 , p6_a12 JTF_NUMBER_TABLE
1125 , p6_a13 JTF_NUMBER_TABLE
1126 , p6_a14 JTF_NUMBER_TABLE
1127 , p6_a15 JTF_NUMBER_TABLE
1128 , p6_a16 JTF_NUMBER_TABLE
1129 , p6_a17 JTF_NUMBER_TABLE
1130 , p6_a18 JTF_NUMBER_TABLE
1131 , p6_a19 JTF_NUMBER_TABLE
1132 , p6_a20 JTF_DATE_TABLE
1133 , p6_a21 JTF_DATE_TABLE
1134 , p6_a22 JTF_NUMBER_TABLE
1135 , p6_a23 JTF_NUMBER_TABLE
1136 , p6_a24 JTF_DATE_TABLE
1137 , p6_a25 JTF_DATE_TABLE
1138 , p6_a26 JTF_DATE_TABLE
1139 , p6_a27 JTF_NUMBER_TABLE
1140 , p6_a28 JTF_NUMBER_TABLE
1141 , p6_a29 JTF_NUMBER_TABLE
1142 , p6_a30 JTF_NUMBER_TABLE
1143 , p6_a31 JTF_NUMBER_TABLE
1144 , p6_a32 JTF_NUMBER_TABLE
1145 , p6_a33 JTF_NUMBER_TABLE
1146 , p6_a34 JTF_DATE_TABLE
1147 , p6_a35 JTF_VARCHAR2_TABLE_100
1148 , p6_a36 JTF_DATE_TABLE
1149 , p6_a37 JTF_VARCHAR2_TABLE_300
1150 , p6_a38 JTF_NUMBER_TABLE
1151 , p6_a39 JTF_NUMBER_TABLE
1152 , p6_a40 JTF_NUMBER_TABLE
1153 , p6_a41 JTF_VARCHAR2_TABLE_100
1154 , p6_a42 JTF_DATE_TABLE
1155 , p6_a43 JTF_NUMBER_TABLE
1156 , p6_a44 JTF_NUMBER_TABLE
1157 , p6_a45 JTF_DATE_TABLE
1158 , p6_a46 JTF_NUMBER_TABLE
1159 , p6_a47 JTF_DATE_TABLE
1160 , p6_a48 JTF_DATE_TABLE
1161 , p6_a49 JTF_DATE_TABLE
1162 , p6_a50 JTF_NUMBER_TABLE
1163 , p6_a51 JTF_NUMBER_TABLE
1164 , p6_a52 JTF_VARCHAR2_TABLE_100
1165 , p6_a53 JTF_NUMBER_TABLE
1166 , p6_a54 JTF_NUMBER_TABLE
1167 , p6_a55 JTF_VARCHAR2_TABLE_100
1168 , p6_a56 JTF_VARCHAR2_TABLE_100
1169 , p6_a57 JTF_NUMBER_TABLE
1170 , p6_a58 JTF_DATE_TABLE
1171 , p6_a59 JTF_NUMBER_TABLE
1172 , p6_a60 JTF_VARCHAR2_TABLE_100
1173 , p6_a61 JTF_VARCHAR2_TABLE_500
1174 , p6_a62 JTF_VARCHAR2_TABLE_500
1175 , p6_a63 JTF_VARCHAR2_TABLE_500
1176 , p6_a64 JTF_VARCHAR2_TABLE_500
1177 , p6_a65 JTF_VARCHAR2_TABLE_500
1178 , p6_a66 JTF_VARCHAR2_TABLE_500
1179 , p6_a67 JTF_VARCHAR2_TABLE_500
1180 , p6_a68 JTF_VARCHAR2_TABLE_500
1181 , p6_a69 JTF_VARCHAR2_TABLE_500
1182 , p6_a70 JTF_VARCHAR2_TABLE_500
1183 , p6_a71 JTF_VARCHAR2_TABLE_500
1184 , p6_a72 JTF_VARCHAR2_TABLE_500
1185 , p6_a73 JTF_VARCHAR2_TABLE_500
1186 , p6_a74 JTF_VARCHAR2_TABLE_500
1187 , p6_a75 JTF_VARCHAR2_TABLE_500
1188 , p6_a76 JTF_NUMBER_TABLE
1189 , p6_a77 JTF_NUMBER_TABLE
1190 , p6_a78 JTF_NUMBER_TABLE
1191 , p6_a79 JTF_DATE_TABLE
1192 , p6_a80 JTF_NUMBER_TABLE
1193 , p6_a81 JTF_DATE_TABLE
1194 , p6_a82 JTF_NUMBER_TABLE
1195 , p6_a83 JTF_DATE_TABLE
1196 , p6_a84 JTF_DATE_TABLE
1197 , p6_a85 JTF_DATE_TABLE
1198 , p6_a86 JTF_DATE_TABLE
1199 , p6_a87 JTF_NUMBER_TABLE
1200 , p6_a88 JTF_NUMBER_TABLE
1201 , p6_a89 JTF_NUMBER_TABLE
1202 , p6_a90 JTF_VARCHAR2_TABLE_100
1203 , p6_a91 JTF_NUMBER_TABLE
1204 , p6_a92 JTF_VARCHAR2_TABLE_100
1205 , p6_a93 JTF_NUMBER_TABLE
1206 , p6_a94 JTF_NUMBER_TABLE
1207 , p6_a95 JTF_DATE_TABLE
1208 , p6_a96 JTF_VARCHAR2_TABLE_100
1209 , p6_a97 JTF_VARCHAR2_TABLE_100
1210 , p6_a98 JTF_NUMBER_TABLE
1211 , p7_a0 JTF_NUMBER_TABLE
1212 , p7_a1 JTF_NUMBER_TABLE
1213 , p7_a2 JTF_NUMBER_TABLE
1214 , p7_a3 JTF_NUMBER_TABLE
1215 , p7_a4 JTF_NUMBER_TABLE
1216 , p7_a5 JTF_NUMBER_TABLE
1217 , p7_a6 JTF_VARCHAR2_TABLE_100
1218 , p7_a7 JTF_VARCHAR2_TABLE_200
1219 , p7_a8 JTF_VARCHAR2_TABLE_100
1220 , p7_a9 JTF_VARCHAR2_TABLE_100
1221 , p7_a10 JTF_VARCHAR2_TABLE_100
1222 , p7_a11 JTF_NUMBER_TABLE
1223 , p7_a12 JTF_VARCHAR2_TABLE_100
1224 , p7_a13 JTF_NUMBER_TABLE
1225 , p7_a14 JTF_VARCHAR2_TABLE_100
1226 , p7_a15 JTF_NUMBER_TABLE
1227 , p7_a16 JTF_DATE_TABLE
1228 , p7_a17 JTF_NUMBER_TABLE
1229 , p7_a18 JTF_DATE_TABLE
1230 , p7_a19 JTF_NUMBER_TABLE
1231 , p8_a0 JTF_NUMBER_TABLE
1232 , p9_a0 out nocopy JTF_NUMBER_TABLE
1233 , p9_a1 out nocopy JTF_NUMBER_TABLE
1234 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
1235 , p9_a3 out nocopy JTF_NUMBER_TABLE
1236 , p9_a4 out nocopy JTF_NUMBER_TABLE
1237 , p9_a5 out nocopy JTF_NUMBER_TABLE
1238 , p9_a6 out nocopy JTF_NUMBER_TABLE
1239 , p9_a7 out nocopy JTF_NUMBER_TABLE
1240 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
1241 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
1242 , p9_a10 out nocopy JTF_NUMBER_TABLE
1243 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
1244 , p9_a12 out nocopy JTF_NUMBER_TABLE
1245 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_2000
1246 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1247 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_2000
1248 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_300
1249 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
1250 , p9_a18 out nocopy JTF_NUMBER_TABLE
1251 , p9_a19 out nocopy JTF_NUMBER_TABLE
1252 , p9_a20 out nocopy JTF_NUMBER_TABLE
1253 , p9_a21 out nocopy JTF_NUMBER_TABLE
1254 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
1255 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_100
1256 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
1257 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1258 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
1259 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_200
1260 , p9_a28 out nocopy JTF_DATE_TABLE
1261 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_200
1262 , p9_a30 out nocopy JTF_DATE_TABLE
1263 , p9_a31 out nocopy JTF_DATE_TABLE
1264 , p9_a32 out nocopy JTF_DATE_TABLE
1265 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_100
1266 , p9_a34 out nocopy JTF_NUMBER_TABLE
1267 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_100
1268 , p9_a36 out nocopy JTF_NUMBER_TABLE
1269 , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
1270 , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
1271 , p9_a39 out nocopy JTF_VARCHAR2_TABLE_500
1272 , p9_a40 out nocopy JTF_VARCHAR2_TABLE_500
1273 , p9_a41 out nocopy JTF_VARCHAR2_TABLE_500
1274 , p9_a42 out nocopy JTF_VARCHAR2_TABLE_500
1275 , p9_a43 out nocopy JTF_VARCHAR2_TABLE_500
1276 , p9_a44 out nocopy JTF_VARCHAR2_TABLE_500
1277 , p9_a45 out nocopy JTF_VARCHAR2_TABLE_500
1278 , p9_a46 out nocopy JTF_VARCHAR2_TABLE_500
1279 , p9_a47 out nocopy JTF_VARCHAR2_TABLE_500
1280 , p9_a48 out nocopy JTF_VARCHAR2_TABLE_500
1281 , p9_a49 out nocopy JTF_VARCHAR2_TABLE_500
1282 , p9_a50 out nocopy JTF_VARCHAR2_TABLE_500
1283 , p9_a51 out nocopy JTF_VARCHAR2_TABLE_500
1284 , p9_a52 out nocopy JTF_VARCHAR2_TABLE_500
1285 , p9_a53 out nocopy JTF_VARCHAR2_TABLE_500
1286 , p9_a54 out nocopy JTF_NUMBER_TABLE
1287 , p9_a55 out nocopy JTF_DATE_TABLE
1288 , p9_a56 out nocopy JTF_NUMBER_TABLE
1289 , p9_a57 out nocopy JTF_DATE_TABLE
1290 , p9_a58 out nocopy JTF_VARCHAR2_TABLE_100
1291 , p9_a59 out nocopy JTF_VARCHAR2_TABLE_100
1292 , p9_a60 out nocopy JTF_VARCHAR2_TABLE_100
1293 , p9_a61 out nocopy JTF_NUMBER_TABLE
1294 , p9_a62 out nocopy JTF_VARCHAR2_TABLE_100
1295 , p9_a63 out nocopy JTF_VARCHAR2_TABLE_100
1296 , p9_a64 out nocopy JTF_VARCHAR2_TABLE_100
1297 , p9_a65 out nocopy JTF_VARCHAR2_TABLE_100
1298 , p9_a66 out nocopy JTF_VARCHAR2_TABLE_100
1299 , p9_a67 out nocopy JTF_NUMBER_TABLE
1300 , p9_a68 out nocopy JTF_NUMBER_TABLE
1301 , p9_a69 out nocopy JTF_NUMBER_TABLE
1302 , p9_a70 out nocopy JTF_DATE_TABLE
1303 , p9_a71 out nocopy JTF_NUMBER_TABLE
1304 , p9_a72 out nocopy JTF_DATE_TABLE
1305 , p9_a73 out nocopy JTF_NUMBER_TABLE
1306 , p9_a74 out nocopy JTF_NUMBER_TABLE
1307 , p9_a75 out nocopy JTF_VARCHAR2_TABLE_100
1308 , p9_a76 out nocopy JTF_VARCHAR2_TABLE_100
1309 , p9_a77 out nocopy JTF_NUMBER_TABLE
1310 , p9_a78 out nocopy JTF_NUMBER_TABLE
1311 , p9_a79 out nocopy JTF_VARCHAR2_TABLE_100
1312 , p9_a80 out nocopy JTF_VARCHAR2_TABLE_100
1313 , p9_a81 out nocopy JTF_NUMBER_TABLE
1314 , p9_a82 out nocopy JTF_VARCHAR2_TABLE_100
1315 , p9_a83 out nocopy JTF_NUMBER_TABLE
1316 , p9_a84 out nocopy JTF_NUMBER_TABLE
1317 , p9_a85 out nocopy JTF_NUMBER_TABLE
1318 , p9_a86 out nocopy JTF_NUMBER_TABLE
1319 , p9_a87 out nocopy JTF_VARCHAR2_TABLE_100
1320 , p9_a88 out nocopy JTF_NUMBER_TABLE
1321 , p9_a89 out nocopy JTF_NUMBER_TABLE
1322 , p10_a0 out nocopy JTF_NUMBER_TABLE
1323 , p10_a1 out nocopy JTF_NUMBER_TABLE
1324 , p10_a2 out nocopy JTF_NUMBER_TABLE
1325 , p10_a3 out nocopy JTF_NUMBER_TABLE
1326 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
1327 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1328 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1329 , p10_a7 out nocopy JTF_NUMBER_TABLE
1330 , p10_a8 out nocopy JTF_NUMBER_TABLE
1331 , p10_a9 out nocopy JTF_DATE_TABLE
1332 , p10_a10 out nocopy JTF_NUMBER_TABLE
1333 , p10_a11 out nocopy JTF_NUMBER_TABLE
1334 , p10_a12 out nocopy JTF_NUMBER_TABLE
1335 , p10_a13 out nocopy JTF_NUMBER_TABLE
1336 , p10_a14 out nocopy JTF_NUMBER_TABLE
1337 , p10_a15 out nocopy JTF_NUMBER_TABLE
1338 , p10_a16 out nocopy JTF_NUMBER_TABLE
1339 , p10_a17 out nocopy JTF_NUMBER_TABLE
1340 , p10_a18 out nocopy JTF_NUMBER_TABLE
1341 , p10_a19 out nocopy JTF_NUMBER_TABLE
1342 , p10_a20 out nocopy JTF_DATE_TABLE
1343 , p10_a21 out nocopy JTF_DATE_TABLE
1344 , p10_a22 out nocopy JTF_NUMBER_TABLE
1345 , p10_a23 out nocopy JTF_NUMBER_TABLE
1346 , p10_a24 out nocopy JTF_DATE_TABLE
1347 , p10_a25 out nocopy JTF_DATE_TABLE
1348 , p10_a26 out nocopy JTF_DATE_TABLE
1349 , p10_a27 out nocopy JTF_NUMBER_TABLE
1350 , p10_a28 out nocopy JTF_NUMBER_TABLE
1351 , p10_a29 out nocopy JTF_NUMBER_TABLE
1352 , p10_a30 out nocopy JTF_NUMBER_TABLE
1353 , p10_a31 out nocopy JTF_NUMBER_TABLE
1354 , p10_a32 out nocopy JTF_NUMBER_TABLE
1355 , p10_a33 out nocopy JTF_NUMBER_TABLE
1356 , p10_a34 out nocopy JTF_DATE_TABLE
1357 , p10_a35 out nocopy JTF_VARCHAR2_TABLE_100
1358 , p10_a36 out nocopy JTF_DATE_TABLE
1359 , p10_a37 out nocopy JTF_VARCHAR2_TABLE_300
1360 , p10_a38 out nocopy JTF_NUMBER_TABLE
1361 , p10_a39 out nocopy JTF_NUMBER_TABLE
1362 , p10_a40 out nocopy JTF_NUMBER_TABLE
1363 , p10_a41 out nocopy JTF_VARCHAR2_TABLE_100
1364 , p10_a42 out nocopy JTF_DATE_TABLE
1365 , p10_a43 out nocopy JTF_NUMBER_TABLE
1366 , p10_a44 out nocopy JTF_NUMBER_TABLE
1367 , p10_a45 out nocopy JTF_DATE_TABLE
1368 , p10_a46 out nocopy JTF_NUMBER_TABLE
1369 , p10_a47 out nocopy JTF_DATE_TABLE
1370 , p10_a48 out nocopy JTF_DATE_TABLE
1371 , p10_a49 out nocopy JTF_DATE_TABLE
1372 , p10_a50 out nocopy JTF_NUMBER_TABLE
1373 , p10_a51 out nocopy JTF_NUMBER_TABLE
1374 , p10_a52 out nocopy JTF_VARCHAR2_TABLE_100
1375 , p10_a53 out nocopy JTF_NUMBER_TABLE
1376 , p10_a54 out nocopy JTF_NUMBER_TABLE
1377 , p10_a55 out nocopy JTF_VARCHAR2_TABLE_100
1378 , p10_a56 out nocopy JTF_VARCHAR2_TABLE_100
1379 , p10_a57 out nocopy JTF_NUMBER_TABLE
1380 , p10_a58 out nocopy JTF_DATE_TABLE
1381 , p10_a59 out nocopy JTF_NUMBER_TABLE
1382 , p10_a60 out nocopy JTF_VARCHAR2_TABLE_100
1383 , p10_a61 out nocopy JTF_VARCHAR2_TABLE_500
1384 , p10_a62 out nocopy JTF_VARCHAR2_TABLE_500
1385 , p10_a63 out nocopy JTF_VARCHAR2_TABLE_500
1386 , p10_a64 out nocopy JTF_VARCHAR2_TABLE_500
1387 , p10_a65 out nocopy JTF_VARCHAR2_TABLE_500
1388 , p10_a66 out nocopy JTF_VARCHAR2_TABLE_500
1389 , p10_a67 out nocopy JTF_VARCHAR2_TABLE_500
1390 , p10_a68 out nocopy JTF_VARCHAR2_TABLE_500
1391 , p10_a69 out nocopy JTF_VARCHAR2_TABLE_500
1392 , p10_a70 out nocopy JTF_VARCHAR2_TABLE_500
1393 , p10_a71 out nocopy JTF_VARCHAR2_TABLE_500
1394 , p10_a72 out nocopy JTF_VARCHAR2_TABLE_500
1395 , p10_a73 out nocopy JTF_VARCHAR2_TABLE_500
1396 , p10_a74 out nocopy JTF_VARCHAR2_TABLE_500
1397 , p10_a75 out nocopy JTF_VARCHAR2_TABLE_500
1398 , p10_a76 out nocopy JTF_NUMBER_TABLE
1399 , p10_a77 out nocopy JTF_NUMBER_TABLE
1400 , p10_a78 out nocopy JTF_NUMBER_TABLE
1401 , p10_a79 out nocopy JTF_DATE_TABLE
1402 , p10_a80 out nocopy JTF_NUMBER_TABLE
1403 , p10_a81 out nocopy JTF_DATE_TABLE
1404 , p10_a82 out nocopy JTF_NUMBER_TABLE
1405 , p10_a83 out nocopy JTF_DATE_TABLE
1406 , p10_a84 out nocopy JTF_DATE_TABLE
1407 , p10_a85 out nocopy JTF_DATE_TABLE
1408 , p10_a86 out nocopy JTF_DATE_TABLE
1409 , p10_a87 out nocopy JTF_NUMBER_TABLE
1410 , p10_a88 out nocopy JTF_NUMBER_TABLE
1411 , p10_a89 out nocopy JTF_NUMBER_TABLE
1412 , p10_a90 out nocopy JTF_VARCHAR2_TABLE_100
1413 , p10_a91 out nocopy JTF_NUMBER_TABLE
1414 , p10_a92 out nocopy JTF_VARCHAR2_TABLE_100
1415 , p10_a93 out nocopy JTF_NUMBER_TABLE
1416 , p10_a94 out nocopy JTF_NUMBER_TABLE
1417 , p10_a95 out nocopy JTF_DATE_TABLE
1418 , p10_a96 out nocopy JTF_VARCHAR2_TABLE_100
1419 , p10_a97 out nocopy JTF_VARCHAR2_TABLE_100
1420 , p10_a98 out nocopy JTF_NUMBER_TABLE
1421 , p11_a0 out nocopy JTF_NUMBER_TABLE
1422 , p11_a1 out nocopy JTF_NUMBER_TABLE
1423 , p11_a2 out nocopy JTF_NUMBER_TABLE
1424 , p11_a3 out nocopy JTF_NUMBER_TABLE
1425 , p11_a4 out nocopy JTF_NUMBER_TABLE
1426 , p11_a5 out nocopy JTF_NUMBER_TABLE
1427 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
1428 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_200
1429 , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
1430 , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
1431 , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
1432 , p11_a11 out nocopy JTF_NUMBER_TABLE
1433 , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
1434 , p11_a13 out nocopy JTF_NUMBER_TABLE
1435 , p11_a14 out nocopy JTF_VARCHAR2_TABLE_100
1436 , p11_a15 out nocopy JTF_NUMBER_TABLE
1437 , p11_a16 out nocopy JTF_DATE_TABLE
1438 , p11_a17 out nocopy JTF_NUMBER_TABLE
1439 , p11_a18 out nocopy JTF_DATE_TABLE
1440 , p11_a19 out nocopy JTF_NUMBER_TABLE
1441 )
1442
1443 as
1444 ddp_clev_tbl okl_service_integration_pvt.clev_tbl_type;
1445 ddp_klev_tbl okl_service_integration_pvt.klev_tbl_type;
1446 ddp_cimv_tbl okl_service_integration_pvt.cimv_tbl_type;
1447 ddp_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
1448 ddx_clev_tbl okl_service_integration_pvt.clev_tbl_type;
1449 ddx_klev_tbl okl_service_integration_pvt.klev_tbl_type;
1450 ddx_cimv_tbl okl_service_integration_pvt.cimv_tbl_type;
1451 ddindx binary_integer; indx binary_integer;
1452 begin
1453
1454 -- copy data to the local IN or IN-OUT args, if any
1455
1456
1457
1458
1459
1460 okl_okc_migration_pvt_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0
1461 , p5_a1
1462 , p5_a2
1463 , p5_a3
1464 , p5_a4
1465 , p5_a5
1466 , p5_a6
1467 , p5_a7
1468 , p5_a8
1469 , p5_a9
1470 , p5_a10
1471 , p5_a11
1472 , p5_a12
1473 , p5_a13
1474 , p5_a14
1475 , p5_a15
1476 , p5_a16
1477 , p5_a17
1478 , p5_a18
1479 , p5_a19
1480 , p5_a20
1481 , p5_a21
1482 , p5_a22
1483 , p5_a23
1484 , p5_a24
1485 , p5_a25
1486 , p5_a26
1487 , p5_a27
1488 , p5_a28
1489 , p5_a29
1490 , p5_a30
1491 , p5_a31
1492 , p5_a32
1493 , p5_a33
1494 , p5_a34
1495 , p5_a35
1496 , p5_a36
1497 , p5_a37
1498 , p5_a38
1499 , p5_a39
1500 , p5_a40
1501 , p5_a41
1502 , p5_a42
1503 , p5_a43
1504 , p5_a44
1505 , p5_a45
1506 , p5_a46
1507 , p5_a47
1508 , p5_a48
1509 , p5_a49
1510 , p5_a50
1511 , p5_a51
1512 , p5_a52
1513 , p5_a53
1514 , p5_a54
1515 , p5_a55
1516 , p5_a56
1517 , p5_a57
1518 , p5_a58
1519 , p5_a59
1520 , p5_a60
1521 , p5_a61
1522 , p5_a62
1523 , p5_a63
1524 , p5_a64
1525 , p5_a65
1526 , p5_a66
1527 , p5_a67
1528 , p5_a68
1529 , p5_a69
1530 , p5_a70
1531 , p5_a71
1532 , p5_a72
1533 , p5_a73
1534 , p5_a74
1535 , p5_a75
1536 , p5_a76
1537 , p5_a77
1538 , p5_a78
1539 , p5_a79
1540 , p5_a80
1541 , p5_a81
1542 , p5_a82
1543 , p5_a83
1544 , p5_a84
1545 , p5_a85
1546 , p5_a86
1547 , p5_a87
1548 , p5_a88
1549 , p5_a89
1550 );
1551
1552 okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p6_a0
1553 , p6_a1
1554 , p6_a2
1555 , p6_a3
1556 , p6_a4
1557 , p6_a5
1558 , p6_a6
1559 , p6_a7
1560 , p6_a8
1561 , p6_a9
1562 , p6_a10
1563 , p6_a11
1564 , p6_a12
1565 , p6_a13
1566 , p6_a14
1567 , p6_a15
1568 , p6_a16
1569 , p6_a17
1570 , p6_a18
1571 , p6_a19
1572 , p6_a20
1573 , p6_a21
1574 , p6_a22
1575 , p6_a23
1576 , p6_a24
1577 , p6_a25
1578 , p6_a26
1579 , p6_a27
1580 , p6_a28
1581 , p6_a29
1582 , p6_a30
1583 , p6_a31
1584 , p6_a32
1585 , p6_a33
1586 , p6_a34
1587 , p6_a35
1588 , p6_a36
1589 , p6_a37
1590 , p6_a38
1591 , p6_a39
1592 , p6_a40
1593 , p6_a41
1594 , p6_a42
1595 , p6_a43
1596 , p6_a44
1597 , p6_a45
1598 , p6_a46
1599 , p6_a47
1600 , p6_a48
1601 , p6_a49
1602 , p6_a50
1603 , p6_a51
1604 , p6_a52
1605 , p6_a53
1606 , p6_a54
1607 , p6_a55
1608 , p6_a56
1609 , p6_a57
1610 , p6_a58
1611 , p6_a59
1612 , p6_a60
1613 , p6_a61
1614 , p6_a62
1615 , p6_a63
1616 , p6_a64
1617 , p6_a65
1618 , p6_a66
1619 , p6_a67
1620 , p6_a68
1621 , p6_a69
1622 , p6_a70
1623 , p6_a71
1624 , p6_a72
1625 , p6_a73
1626 , p6_a74
1627 , p6_a75
1628 , p6_a76
1629 , p6_a77
1630 , p6_a78
1631 , p6_a79
1632 , p6_a80
1633 , p6_a81
1634 , p6_a82
1635 , p6_a83
1636 , p6_a84
1637 , p6_a85
1638 , p6_a86
1639 , p6_a87
1640 , p6_a88
1641 , p6_a89
1642 , p6_a90
1643 , p6_a91
1644 , p6_a92
1645 , p6_a93
1646 , p6_a94
1647 , p6_a95
1648 , p6_a96
1649 , p6_a97
1650 , p6_a98
1651 );
1652
1653 okl_okc_migration_pvt_w.rosetta_table_copy_in_p7(ddp_cimv_tbl, p7_a0
1654 , p7_a1
1655 , p7_a2
1656 , p7_a3
1657 , p7_a4
1658 , p7_a5
1659 , p7_a6
1660 , p7_a7
1661 , p7_a8
1662 , p7_a9
1663 , p7_a10
1664 , p7_a11
1665 , p7_a12
1666 , p7_a13
1667 , p7_a14
1668 , p7_a15
1669 , p7_a16
1670 , p7_a17
1671 , p7_a18
1672 , p7_a19
1673 );
1674
1675 okl_service_integration_pvt_w.rosetta_table_copy_in_p21(ddp_cov_tbl, p8_a0
1676 );
1677
1678
1679
1680
1681 -- here's the delegated call to the old PL/SQL routine
1682 okl_service_integration_pvt.create_cov_asset_line(p_api_version,
1683 p_init_msg_list,
1684 x_return_status,
1685 x_msg_count,
1686 x_msg_data,
1687 ddp_clev_tbl,
1688 ddp_klev_tbl,
1689 ddp_cimv_tbl,
1690 ddp_cov_tbl,
1691 ddx_clev_tbl,
1692 ddx_klev_tbl,
1693 ddx_cimv_tbl);
1694
1695 -- copy data back from the local variables to OUT or IN-OUT args, if any
1696
1697
1698
1699
1700
1701
1702
1703
1704
1705 okl_okc_migration_pvt_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p9_a0
1706 , p9_a1
1707 , p9_a2
1708 , p9_a3
1709 , p9_a4
1710 , p9_a5
1711 , p9_a6
1712 , p9_a7
1713 , p9_a8
1714 , p9_a9
1715 , p9_a10
1716 , p9_a11
1717 , p9_a12
1718 , p9_a13
1719 , p9_a14
1720 , p9_a15
1721 , p9_a16
1722 , p9_a17
1723 , p9_a18
1724 , p9_a19
1725 , p9_a20
1726 , p9_a21
1727 , p9_a22
1728 , p9_a23
1729 , p9_a24
1730 , p9_a25
1731 , p9_a26
1732 , p9_a27
1733 , p9_a28
1734 , p9_a29
1735 , p9_a30
1736 , p9_a31
1737 , p9_a32
1738 , p9_a33
1739 , p9_a34
1740 , p9_a35
1741 , p9_a36
1742 , p9_a37
1743 , p9_a38
1744 , p9_a39
1745 , p9_a40
1746 , p9_a41
1747 , p9_a42
1748 , p9_a43
1749 , p9_a44
1750 , p9_a45
1751 , p9_a46
1752 , p9_a47
1753 , p9_a48
1754 , p9_a49
1755 , p9_a50
1756 , p9_a51
1757 , p9_a52
1758 , p9_a53
1759 , p9_a54
1760 , p9_a55
1761 , p9_a56
1762 , p9_a57
1763 , p9_a58
1764 , p9_a59
1765 , p9_a60
1766 , p9_a61
1767 , p9_a62
1768 , p9_a63
1769 , p9_a64
1770 , p9_a65
1771 , p9_a66
1772 , p9_a67
1773 , p9_a68
1774 , p9_a69
1775 , p9_a70
1776 , p9_a71
1777 , p9_a72
1778 , p9_a73
1779 , p9_a74
1780 , p9_a75
1781 , p9_a76
1782 , p9_a77
1783 , p9_a78
1784 , p9_a79
1785 , p9_a80
1786 , p9_a81
1787 , p9_a82
1788 , p9_a83
1789 , p9_a84
1790 , p9_a85
1791 , p9_a86
1792 , p9_a87
1793 , p9_a88
1794 , p9_a89
1795 );
1796
1797 okl_kle_pvt_w.rosetta_table_copy_out_p8(ddx_klev_tbl, p10_a0
1798 , p10_a1
1799 , p10_a2
1800 , p10_a3
1801 , p10_a4
1802 , p10_a5
1803 , p10_a6
1804 , p10_a7
1805 , p10_a8
1806 , p10_a9
1807 , p10_a10
1808 , p10_a11
1809 , p10_a12
1810 , p10_a13
1811 , p10_a14
1812 , p10_a15
1813 , p10_a16
1814 , p10_a17
1815 , p10_a18
1816 , p10_a19
1817 , p10_a20
1818 , p10_a21
1819 , p10_a22
1820 , p10_a23
1821 , p10_a24
1822 , p10_a25
1823 , p10_a26
1824 , p10_a27
1825 , p10_a28
1826 , p10_a29
1827 , p10_a30
1828 , p10_a31
1829 , p10_a32
1830 , p10_a33
1831 , p10_a34
1832 , p10_a35
1833 , p10_a36
1834 , p10_a37
1835 , p10_a38
1836 , p10_a39
1837 , p10_a40
1838 , p10_a41
1839 , p10_a42
1840 , p10_a43
1841 , p10_a44
1842 , p10_a45
1843 , p10_a46
1844 , p10_a47
1845 , p10_a48
1846 , p10_a49
1847 , p10_a50
1848 , p10_a51
1849 , p10_a52
1850 , p10_a53
1851 , p10_a54
1852 , p10_a55
1853 , p10_a56
1854 , p10_a57
1855 , p10_a58
1856 , p10_a59
1857 , p10_a60
1858 , p10_a61
1859 , p10_a62
1860 , p10_a63
1861 , p10_a64
1862 , p10_a65
1863 , p10_a66
1864 , p10_a67
1865 , p10_a68
1866 , p10_a69
1867 , p10_a70
1868 , p10_a71
1869 , p10_a72
1870 , p10_a73
1871 , p10_a74
1872 , p10_a75
1873 , p10_a76
1874 , p10_a77
1875 , p10_a78
1876 , p10_a79
1877 , p10_a80
1878 , p10_a81
1879 , p10_a82
1880 , p10_a83
1881 , p10_a84
1882 , p10_a85
1883 , p10_a86
1884 , p10_a87
1885 , p10_a88
1886 , p10_a89
1887 , p10_a90
1888 , p10_a91
1889 , p10_a92
1890 , p10_a93
1891 , p10_a94
1892 , p10_a95
1893 , p10_a96
1894 , p10_a97
1895 , p10_a98
1896 );
1897
1898 okl_okc_migration_pvt_w.rosetta_table_copy_out_p7(ddx_cimv_tbl, p11_a0
1899 , p11_a1
1900 , p11_a2
1901 , p11_a3
1902 , p11_a4
1903 , p11_a5
1904 , p11_a6
1905 , p11_a7
1906 , p11_a8
1907 , p11_a9
1908 , p11_a10
1909 , p11_a11
1910 , p11_a12
1911 , p11_a13
1912 , p11_a14
1913 , p11_a15
1914 , p11_a16
1915 , p11_a17
1916 , p11_a18
1917 , p11_a19
1918 );
1919 end;
1920
1921 procedure update_cov_asset_line(p_api_version NUMBER
1922 , p_init_msg_list VARCHAR2
1923 , x_return_status out nocopy VARCHAR2
1924 , x_msg_count out nocopy NUMBER
1925 , x_msg_data out nocopy VARCHAR2
1926 , p5_a0 JTF_NUMBER_TABLE
1927 , p5_a1 JTF_NUMBER_TABLE
1928 , p5_a2 JTF_VARCHAR2_TABLE_100
1929 , p5_a3 JTF_NUMBER_TABLE
1930 , p5_a4 JTF_NUMBER_TABLE
1931 , p5_a5 JTF_NUMBER_TABLE
1932 , p5_a6 JTF_NUMBER_TABLE
1933 , p5_a7 JTF_NUMBER_TABLE
1934 , p5_a8 JTF_VARCHAR2_TABLE_200
1935 , p5_a9 JTF_VARCHAR2_TABLE_100
1936 , p5_a10 JTF_NUMBER_TABLE
1937 , p5_a11 JTF_VARCHAR2_TABLE_100
1938 , p5_a12 JTF_NUMBER_TABLE
1939 , p5_a13 JTF_VARCHAR2_TABLE_2000
1940 , p5_a14 JTF_VARCHAR2_TABLE_2000
1941 , p5_a15 JTF_VARCHAR2_TABLE_2000
1942 , p5_a16 JTF_VARCHAR2_TABLE_300
1943 , p5_a17 JTF_VARCHAR2_TABLE_100
1944 , p5_a18 JTF_NUMBER_TABLE
1945 , p5_a19 JTF_NUMBER_TABLE
1946 , p5_a20 JTF_NUMBER_TABLE
1947 , p5_a21 JTF_NUMBER_TABLE
1948 , p5_a22 JTF_VARCHAR2_TABLE_100
1949 , p5_a23 JTF_VARCHAR2_TABLE_100
1950 , p5_a24 JTF_VARCHAR2_TABLE_100
1951 , p5_a25 JTF_VARCHAR2_TABLE_2000
1952 , p5_a26 JTF_VARCHAR2_TABLE_100
1953 , p5_a27 JTF_VARCHAR2_TABLE_200
1954 , p5_a28 JTF_DATE_TABLE
1955 , p5_a29 JTF_VARCHAR2_TABLE_200
1956 , p5_a30 JTF_DATE_TABLE
1957 , p5_a31 JTF_DATE_TABLE
1958 , p5_a32 JTF_DATE_TABLE
1959 , p5_a33 JTF_VARCHAR2_TABLE_100
1960 , p5_a34 JTF_NUMBER_TABLE
1961 , p5_a35 JTF_VARCHAR2_TABLE_100
1962 , p5_a36 JTF_NUMBER_TABLE
1963 , p5_a37 JTF_VARCHAR2_TABLE_100
1964 , p5_a38 JTF_VARCHAR2_TABLE_100
1965 , p5_a39 JTF_VARCHAR2_TABLE_500
1966 , p5_a40 JTF_VARCHAR2_TABLE_500
1967 , p5_a41 JTF_VARCHAR2_TABLE_500
1968 , p5_a42 JTF_VARCHAR2_TABLE_500
1969 , p5_a43 JTF_VARCHAR2_TABLE_500
1970 , p5_a44 JTF_VARCHAR2_TABLE_500
1971 , p5_a45 JTF_VARCHAR2_TABLE_500
1972 , p5_a46 JTF_VARCHAR2_TABLE_500
1973 , p5_a47 JTF_VARCHAR2_TABLE_500
1974 , p5_a48 JTF_VARCHAR2_TABLE_500
1975 , p5_a49 JTF_VARCHAR2_TABLE_500
1976 , p5_a50 JTF_VARCHAR2_TABLE_500
1977 , p5_a51 JTF_VARCHAR2_TABLE_500
1978 , p5_a52 JTF_VARCHAR2_TABLE_500
1979 , p5_a53 JTF_VARCHAR2_TABLE_500
1980 , p5_a54 JTF_NUMBER_TABLE
1981 , p5_a55 JTF_DATE_TABLE
1982 , p5_a56 JTF_NUMBER_TABLE
1983 , p5_a57 JTF_DATE_TABLE
1984 , p5_a58 JTF_VARCHAR2_TABLE_100
1985 , p5_a59 JTF_VARCHAR2_TABLE_100
1986 , p5_a60 JTF_VARCHAR2_TABLE_100
1987 , p5_a61 JTF_NUMBER_TABLE
1988 , p5_a62 JTF_VARCHAR2_TABLE_100
1989 , p5_a63 JTF_VARCHAR2_TABLE_100
1990 , p5_a64 JTF_VARCHAR2_TABLE_100
1991 , p5_a65 JTF_VARCHAR2_TABLE_100
1992 , p5_a66 JTF_VARCHAR2_TABLE_100
1993 , p5_a67 JTF_NUMBER_TABLE
1994 , p5_a68 JTF_NUMBER_TABLE
1995 , p5_a69 JTF_NUMBER_TABLE
1996 , p5_a70 JTF_DATE_TABLE
1997 , p5_a71 JTF_NUMBER_TABLE
1998 , p5_a72 JTF_DATE_TABLE
1999 , p5_a73 JTF_NUMBER_TABLE
2000 , p5_a74 JTF_NUMBER_TABLE
2001 , p5_a75 JTF_VARCHAR2_TABLE_100
2002 , p5_a76 JTF_VARCHAR2_TABLE_100
2003 , p5_a77 JTF_NUMBER_TABLE
2004 , p5_a78 JTF_NUMBER_TABLE
2005 , p5_a79 JTF_VARCHAR2_TABLE_100
2006 , p5_a80 JTF_VARCHAR2_TABLE_100
2007 , p5_a81 JTF_NUMBER_TABLE
2008 , p5_a82 JTF_VARCHAR2_TABLE_100
2009 , p5_a83 JTF_NUMBER_TABLE
2010 , p5_a84 JTF_NUMBER_TABLE
2011 , p5_a85 JTF_NUMBER_TABLE
2012 , p5_a86 JTF_NUMBER_TABLE
2013 , p5_a87 JTF_VARCHAR2_TABLE_100
2014 , p5_a88 JTF_NUMBER_TABLE
2015 , p5_a89 JTF_NUMBER_TABLE
2016 , p6_a0 JTF_NUMBER_TABLE
2017 , p6_a1 JTF_NUMBER_TABLE
2018 , p6_a2 JTF_NUMBER_TABLE
2019 , p6_a3 JTF_NUMBER_TABLE
2020 , p6_a4 JTF_VARCHAR2_TABLE_100
2021 , p6_a5 JTF_VARCHAR2_TABLE_100
2022 , p6_a6 JTF_VARCHAR2_TABLE_100
2023 , p6_a7 JTF_NUMBER_TABLE
2024 , p6_a8 JTF_NUMBER_TABLE
2025 , p6_a9 JTF_DATE_TABLE
2026 , p6_a10 JTF_NUMBER_TABLE
2027 , p6_a11 JTF_NUMBER_TABLE
2028 , p6_a12 JTF_NUMBER_TABLE
2029 , p6_a13 JTF_NUMBER_TABLE
2030 , p6_a14 JTF_NUMBER_TABLE
2031 , p6_a15 JTF_NUMBER_TABLE
2032 , p6_a16 JTF_NUMBER_TABLE
2033 , p6_a17 JTF_NUMBER_TABLE
2034 , p6_a18 JTF_NUMBER_TABLE
2035 , p6_a19 JTF_NUMBER_TABLE
2036 , p6_a20 JTF_DATE_TABLE
2037 , p6_a21 JTF_DATE_TABLE
2038 , p6_a22 JTF_NUMBER_TABLE
2039 , p6_a23 JTF_NUMBER_TABLE
2040 , p6_a24 JTF_DATE_TABLE
2041 , p6_a25 JTF_DATE_TABLE
2042 , p6_a26 JTF_DATE_TABLE
2043 , p6_a27 JTF_NUMBER_TABLE
2044 , p6_a28 JTF_NUMBER_TABLE
2045 , p6_a29 JTF_NUMBER_TABLE
2046 , p6_a30 JTF_NUMBER_TABLE
2047 , p6_a31 JTF_NUMBER_TABLE
2048 , p6_a32 JTF_NUMBER_TABLE
2049 , p6_a33 JTF_NUMBER_TABLE
2050 , p6_a34 JTF_DATE_TABLE
2051 , p6_a35 JTF_VARCHAR2_TABLE_100
2052 , p6_a36 JTF_DATE_TABLE
2053 , p6_a37 JTF_VARCHAR2_TABLE_300
2054 , p6_a38 JTF_NUMBER_TABLE
2055 , p6_a39 JTF_NUMBER_TABLE
2056 , p6_a40 JTF_NUMBER_TABLE
2057 , p6_a41 JTF_VARCHAR2_TABLE_100
2058 , p6_a42 JTF_DATE_TABLE
2059 , p6_a43 JTF_NUMBER_TABLE
2060 , p6_a44 JTF_NUMBER_TABLE
2061 , p6_a45 JTF_DATE_TABLE
2062 , p6_a46 JTF_NUMBER_TABLE
2063 , p6_a47 JTF_DATE_TABLE
2064 , p6_a48 JTF_DATE_TABLE
2065 , p6_a49 JTF_DATE_TABLE
2066 , p6_a50 JTF_NUMBER_TABLE
2067 , p6_a51 JTF_NUMBER_TABLE
2068 , p6_a52 JTF_VARCHAR2_TABLE_100
2069 , p6_a53 JTF_NUMBER_TABLE
2070 , p6_a54 JTF_NUMBER_TABLE
2071 , p6_a55 JTF_VARCHAR2_TABLE_100
2072 , p6_a56 JTF_VARCHAR2_TABLE_100
2073 , p6_a57 JTF_NUMBER_TABLE
2074 , p6_a58 JTF_DATE_TABLE
2075 , p6_a59 JTF_NUMBER_TABLE
2076 , p6_a60 JTF_VARCHAR2_TABLE_100
2077 , p6_a61 JTF_VARCHAR2_TABLE_500
2078 , p6_a62 JTF_VARCHAR2_TABLE_500
2079 , p6_a63 JTF_VARCHAR2_TABLE_500
2080 , p6_a64 JTF_VARCHAR2_TABLE_500
2081 , p6_a65 JTF_VARCHAR2_TABLE_500
2082 , p6_a66 JTF_VARCHAR2_TABLE_500
2083 , p6_a67 JTF_VARCHAR2_TABLE_500
2084 , p6_a68 JTF_VARCHAR2_TABLE_500
2085 , p6_a69 JTF_VARCHAR2_TABLE_500
2086 , p6_a70 JTF_VARCHAR2_TABLE_500
2087 , p6_a71 JTF_VARCHAR2_TABLE_500
2088 , p6_a72 JTF_VARCHAR2_TABLE_500
2089 , p6_a73 JTF_VARCHAR2_TABLE_500
2090 , p6_a74 JTF_VARCHAR2_TABLE_500
2091 , p6_a75 JTF_VARCHAR2_TABLE_500
2092 , p6_a76 JTF_NUMBER_TABLE
2093 , p6_a77 JTF_NUMBER_TABLE
2094 , p6_a78 JTF_NUMBER_TABLE
2095 , p6_a79 JTF_DATE_TABLE
2096 , p6_a80 JTF_NUMBER_TABLE
2097 , p6_a81 JTF_DATE_TABLE
2098 , p6_a82 JTF_NUMBER_TABLE
2099 , p6_a83 JTF_DATE_TABLE
2100 , p6_a84 JTF_DATE_TABLE
2101 , p6_a85 JTF_DATE_TABLE
2102 , p6_a86 JTF_DATE_TABLE
2103 , p6_a87 JTF_NUMBER_TABLE
2104 , p6_a88 JTF_NUMBER_TABLE
2105 , p6_a89 JTF_NUMBER_TABLE
2106 , p6_a90 JTF_VARCHAR2_TABLE_100
2107 , p6_a91 JTF_NUMBER_TABLE
2108 , p6_a92 JTF_VARCHAR2_TABLE_100
2109 , p6_a93 JTF_NUMBER_TABLE
2110 , p6_a94 JTF_NUMBER_TABLE
2111 , p6_a95 JTF_DATE_TABLE
2112 , p6_a96 JTF_VARCHAR2_TABLE_100
2113 , p6_a97 JTF_VARCHAR2_TABLE_100
2114 , p6_a98 JTF_NUMBER_TABLE
2115 , p7_a0 JTF_NUMBER_TABLE
2116 , p7_a1 JTF_NUMBER_TABLE
2117 , p7_a2 JTF_NUMBER_TABLE
2118 , p7_a3 JTF_NUMBER_TABLE
2119 , p7_a4 JTF_NUMBER_TABLE
2120 , p7_a5 JTF_NUMBER_TABLE
2121 , p7_a6 JTF_VARCHAR2_TABLE_100
2122 , p7_a7 JTF_VARCHAR2_TABLE_200
2123 , p7_a8 JTF_VARCHAR2_TABLE_100
2124 , p7_a9 JTF_VARCHAR2_TABLE_100
2125 , p7_a10 JTF_VARCHAR2_TABLE_100
2126 , p7_a11 JTF_NUMBER_TABLE
2127 , p7_a12 JTF_VARCHAR2_TABLE_100
2128 , p7_a13 JTF_NUMBER_TABLE
2129 , p7_a14 JTF_VARCHAR2_TABLE_100
2130 , p7_a15 JTF_NUMBER_TABLE
2131 , p7_a16 JTF_DATE_TABLE
2132 , p7_a17 JTF_NUMBER_TABLE
2133 , p7_a18 JTF_DATE_TABLE
2134 , p7_a19 JTF_NUMBER_TABLE
2135 , p8_a0 JTF_NUMBER_TABLE
2136 , p9_a0 out nocopy JTF_NUMBER_TABLE
2137 , p9_a1 out nocopy JTF_NUMBER_TABLE
2138 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
2139 , p9_a3 out nocopy JTF_NUMBER_TABLE
2140 , p9_a4 out nocopy JTF_NUMBER_TABLE
2141 , p9_a5 out nocopy JTF_NUMBER_TABLE
2142 , p9_a6 out nocopy JTF_NUMBER_TABLE
2143 , p9_a7 out nocopy JTF_NUMBER_TABLE
2144 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
2145 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
2146 , p9_a10 out nocopy JTF_NUMBER_TABLE
2147 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
2148 , p9_a12 out nocopy JTF_NUMBER_TABLE
2149 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_2000
2150 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
2151 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_2000
2152 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_300
2153 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
2154 , p9_a18 out nocopy JTF_NUMBER_TABLE
2155 , p9_a19 out nocopy JTF_NUMBER_TABLE
2156 , p9_a20 out nocopy JTF_NUMBER_TABLE
2157 , p9_a21 out nocopy JTF_NUMBER_TABLE
2158 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
2159 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_100
2160 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
2161 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_2000
2162 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
2163 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_200
2164 , p9_a28 out nocopy JTF_DATE_TABLE
2165 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_200
2166 , p9_a30 out nocopy JTF_DATE_TABLE
2167 , p9_a31 out nocopy JTF_DATE_TABLE
2168 , p9_a32 out nocopy JTF_DATE_TABLE
2169 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_100
2170 , p9_a34 out nocopy JTF_NUMBER_TABLE
2171 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_100
2172 , p9_a36 out nocopy JTF_NUMBER_TABLE
2173 , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
2174 , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
2175 , p9_a39 out nocopy JTF_VARCHAR2_TABLE_500
2176 , p9_a40 out nocopy JTF_VARCHAR2_TABLE_500
2177 , p9_a41 out nocopy JTF_VARCHAR2_TABLE_500
2178 , p9_a42 out nocopy JTF_VARCHAR2_TABLE_500
2179 , p9_a43 out nocopy JTF_VARCHAR2_TABLE_500
2180 , p9_a44 out nocopy JTF_VARCHAR2_TABLE_500
2181 , p9_a45 out nocopy JTF_VARCHAR2_TABLE_500
2182 , p9_a46 out nocopy JTF_VARCHAR2_TABLE_500
2183 , p9_a47 out nocopy JTF_VARCHAR2_TABLE_500
2184 , p9_a48 out nocopy JTF_VARCHAR2_TABLE_500
2185 , p9_a49 out nocopy JTF_VARCHAR2_TABLE_500
2186 , p9_a50 out nocopy JTF_VARCHAR2_TABLE_500
2187 , p9_a51 out nocopy JTF_VARCHAR2_TABLE_500
2188 , p9_a52 out nocopy JTF_VARCHAR2_TABLE_500
2189 , p9_a53 out nocopy JTF_VARCHAR2_TABLE_500
2190 , p9_a54 out nocopy JTF_NUMBER_TABLE
2191 , p9_a55 out nocopy JTF_DATE_TABLE
2192 , p9_a56 out nocopy JTF_NUMBER_TABLE
2193 , p9_a57 out nocopy JTF_DATE_TABLE
2194 , p9_a58 out nocopy JTF_VARCHAR2_TABLE_100
2195 , p9_a59 out nocopy JTF_VARCHAR2_TABLE_100
2196 , p9_a60 out nocopy JTF_VARCHAR2_TABLE_100
2197 , p9_a61 out nocopy JTF_NUMBER_TABLE
2198 , p9_a62 out nocopy JTF_VARCHAR2_TABLE_100
2199 , p9_a63 out nocopy JTF_VARCHAR2_TABLE_100
2200 , p9_a64 out nocopy JTF_VARCHAR2_TABLE_100
2201 , p9_a65 out nocopy JTF_VARCHAR2_TABLE_100
2202 , p9_a66 out nocopy JTF_VARCHAR2_TABLE_100
2203 , p9_a67 out nocopy JTF_NUMBER_TABLE
2204 , p9_a68 out nocopy JTF_NUMBER_TABLE
2205 , p9_a69 out nocopy JTF_NUMBER_TABLE
2206 , p9_a70 out nocopy JTF_DATE_TABLE
2207 , p9_a71 out nocopy JTF_NUMBER_TABLE
2208 , p9_a72 out nocopy JTF_DATE_TABLE
2209 , p9_a73 out nocopy JTF_NUMBER_TABLE
2210 , p9_a74 out nocopy JTF_NUMBER_TABLE
2211 , p9_a75 out nocopy JTF_VARCHAR2_TABLE_100
2212 , p9_a76 out nocopy JTF_VARCHAR2_TABLE_100
2213 , p9_a77 out nocopy JTF_NUMBER_TABLE
2214 , p9_a78 out nocopy JTF_NUMBER_TABLE
2215 , p9_a79 out nocopy JTF_VARCHAR2_TABLE_100
2216 , p9_a80 out nocopy JTF_VARCHAR2_TABLE_100
2217 , p9_a81 out nocopy JTF_NUMBER_TABLE
2218 , p9_a82 out nocopy JTF_VARCHAR2_TABLE_100
2219 , p9_a83 out nocopy JTF_NUMBER_TABLE
2220 , p9_a84 out nocopy JTF_NUMBER_TABLE
2221 , p9_a85 out nocopy JTF_NUMBER_TABLE
2222 , p9_a86 out nocopy JTF_NUMBER_TABLE
2223 , p9_a87 out nocopy JTF_VARCHAR2_TABLE_100
2224 , p9_a88 out nocopy JTF_NUMBER_TABLE
2225 , p9_a89 out nocopy JTF_NUMBER_TABLE
2226 , p10_a0 out nocopy JTF_NUMBER_TABLE
2227 , p10_a1 out nocopy JTF_NUMBER_TABLE
2228 , p10_a2 out nocopy JTF_NUMBER_TABLE
2229 , p10_a3 out nocopy JTF_NUMBER_TABLE
2230 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
2231 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
2232 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
2233 , p10_a7 out nocopy JTF_NUMBER_TABLE
2234 , p10_a8 out nocopy JTF_NUMBER_TABLE
2235 , p10_a9 out nocopy JTF_DATE_TABLE
2236 , p10_a10 out nocopy JTF_NUMBER_TABLE
2237 , p10_a11 out nocopy JTF_NUMBER_TABLE
2238 , p10_a12 out nocopy JTF_NUMBER_TABLE
2239 , p10_a13 out nocopy JTF_NUMBER_TABLE
2240 , p10_a14 out nocopy JTF_NUMBER_TABLE
2241 , p10_a15 out nocopy JTF_NUMBER_TABLE
2242 , p10_a16 out nocopy JTF_NUMBER_TABLE
2243 , p10_a17 out nocopy JTF_NUMBER_TABLE
2244 , p10_a18 out nocopy JTF_NUMBER_TABLE
2245 , p10_a19 out nocopy JTF_NUMBER_TABLE
2246 , p10_a20 out nocopy JTF_DATE_TABLE
2247 , p10_a21 out nocopy JTF_DATE_TABLE
2248 , p10_a22 out nocopy JTF_NUMBER_TABLE
2249 , p10_a23 out nocopy JTF_NUMBER_TABLE
2250 , p10_a24 out nocopy JTF_DATE_TABLE
2251 , p10_a25 out nocopy JTF_DATE_TABLE
2252 , p10_a26 out nocopy JTF_DATE_TABLE
2253 , p10_a27 out nocopy JTF_NUMBER_TABLE
2254 , p10_a28 out nocopy JTF_NUMBER_TABLE
2255 , p10_a29 out nocopy JTF_NUMBER_TABLE
2256 , p10_a30 out nocopy JTF_NUMBER_TABLE
2257 , p10_a31 out nocopy JTF_NUMBER_TABLE
2258 , p10_a32 out nocopy JTF_NUMBER_TABLE
2259 , p10_a33 out nocopy JTF_NUMBER_TABLE
2260 , p10_a34 out nocopy JTF_DATE_TABLE
2261 , p10_a35 out nocopy JTF_VARCHAR2_TABLE_100
2262 , p10_a36 out nocopy JTF_DATE_TABLE
2263 , p10_a37 out nocopy JTF_VARCHAR2_TABLE_300
2264 , p10_a38 out nocopy JTF_NUMBER_TABLE
2265 , p10_a39 out nocopy JTF_NUMBER_TABLE
2266 , p10_a40 out nocopy JTF_NUMBER_TABLE
2267 , p10_a41 out nocopy JTF_VARCHAR2_TABLE_100
2268 , p10_a42 out nocopy JTF_DATE_TABLE
2269 , p10_a43 out nocopy JTF_NUMBER_TABLE
2270 , p10_a44 out nocopy JTF_NUMBER_TABLE
2271 , p10_a45 out nocopy JTF_DATE_TABLE
2272 , p10_a46 out nocopy JTF_NUMBER_TABLE
2273 , p10_a47 out nocopy JTF_DATE_TABLE
2274 , p10_a48 out nocopy JTF_DATE_TABLE
2275 , p10_a49 out nocopy JTF_DATE_TABLE
2276 , p10_a50 out nocopy JTF_NUMBER_TABLE
2277 , p10_a51 out nocopy JTF_NUMBER_TABLE
2278 , p10_a52 out nocopy JTF_VARCHAR2_TABLE_100
2279 , p10_a53 out nocopy JTF_NUMBER_TABLE
2280 , p10_a54 out nocopy JTF_NUMBER_TABLE
2281 , p10_a55 out nocopy JTF_VARCHAR2_TABLE_100
2282 , p10_a56 out nocopy JTF_VARCHAR2_TABLE_100
2283 , p10_a57 out nocopy JTF_NUMBER_TABLE
2284 , p10_a58 out nocopy JTF_DATE_TABLE
2285 , p10_a59 out nocopy JTF_NUMBER_TABLE
2286 , p10_a60 out nocopy JTF_VARCHAR2_TABLE_100
2287 , p10_a61 out nocopy JTF_VARCHAR2_TABLE_500
2288 , p10_a62 out nocopy JTF_VARCHAR2_TABLE_500
2289 , p10_a63 out nocopy JTF_VARCHAR2_TABLE_500
2290 , p10_a64 out nocopy JTF_VARCHAR2_TABLE_500
2291 , p10_a65 out nocopy JTF_VARCHAR2_TABLE_500
2292 , p10_a66 out nocopy JTF_VARCHAR2_TABLE_500
2293 , p10_a67 out nocopy JTF_VARCHAR2_TABLE_500
2294 , p10_a68 out nocopy JTF_VARCHAR2_TABLE_500
2295 , p10_a69 out nocopy JTF_VARCHAR2_TABLE_500
2296 , p10_a70 out nocopy JTF_VARCHAR2_TABLE_500
2297 , p10_a71 out nocopy JTF_VARCHAR2_TABLE_500
2298 , p10_a72 out nocopy JTF_VARCHAR2_TABLE_500
2299 , p10_a73 out nocopy JTF_VARCHAR2_TABLE_500
2300 , p10_a74 out nocopy JTF_VARCHAR2_TABLE_500
2301 , p10_a75 out nocopy JTF_VARCHAR2_TABLE_500
2302 , p10_a76 out nocopy JTF_NUMBER_TABLE
2303 , p10_a77 out nocopy JTF_NUMBER_TABLE
2304 , p10_a78 out nocopy JTF_NUMBER_TABLE
2305 , p10_a79 out nocopy JTF_DATE_TABLE
2306 , p10_a80 out nocopy JTF_NUMBER_TABLE
2307 , p10_a81 out nocopy JTF_DATE_TABLE
2308 , p10_a82 out nocopy JTF_NUMBER_TABLE
2309 , p10_a83 out nocopy JTF_DATE_TABLE
2310 , p10_a84 out nocopy JTF_DATE_TABLE
2311 , p10_a85 out nocopy JTF_DATE_TABLE
2312 , p10_a86 out nocopy JTF_DATE_TABLE
2313 , p10_a87 out nocopy JTF_NUMBER_TABLE
2314 , p10_a88 out nocopy JTF_NUMBER_TABLE
2315 , p10_a89 out nocopy JTF_NUMBER_TABLE
2316 , p10_a90 out nocopy JTF_VARCHAR2_TABLE_100
2317 , p10_a91 out nocopy JTF_NUMBER_TABLE
2318 , p10_a92 out nocopy JTF_VARCHAR2_TABLE_100
2319 , p10_a93 out nocopy JTF_NUMBER_TABLE
2320 , p10_a94 out nocopy JTF_NUMBER_TABLE
2321 , p10_a95 out nocopy JTF_DATE_TABLE
2322 , p10_a96 out nocopy JTF_VARCHAR2_TABLE_100
2323 , p10_a97 out nocopy JTF_VARCHAR2_TABLE_100
2324 , p10_a98 out nocopy JTF_NUMBER_TABLE
2325 , p11_a0 out nocopy JTF_NUMBER_TABLE
2326 , p11_a1 out nocopy JTF_NUMBER_TABLE
2327 , p11_a2 out nocopy JTF_NUMBER_TABLE
2328 , p11_a3 out nocopy JTF_NUMBER_TABLE
2329 , p11_a4 out nocopy JTF_NUMBER_TABLE
2330 , p11_a5 out nocopy JTF_NUMBER_TABLE
2331 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
2332 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_200
2333 , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
2334 , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
2335 , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
2336 , p11_a11 out nocopy JTF_NUMBER_TABLE
2337 , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
2338 , p11_a13 out nocopy JTF_NUMBER_TABLE
2339 , p11_a14 out nocopy JTF_VARCHAR2_TABLE_100
2340 , p11_a15 out nocopy JTF_NUMBER_TABLE
2341 , p11_a16 out nocopy JTF_DATE_TABLE
2342 , p11_a17 out nocopy JTF_NUMBER_TABLE
2343 , p11_a18 out nocopy JTF_DATE_TABLE
2344 , p11_a19 out nocopy JTF_NUMBER_TABLE
2345 )
2346
2347 as
2348 ddp_clev_tbl okl_service_integration_pvt.clev_tbl_type;
2349 ddp_klev_tbl okl_service_integration_pvt.klev_tbl_type;
2350 ddp_cimv_tbl okl_service_integration_pvt.cimv_tbl_type;
2351 ddp_cov_tbl okl_service_integration_pvt.srv_cov_tbl_type;
2352 ddx_clev_tbl okl_service_integration_pvt.clev_tbl_type;
2353 ddx_klev_tbl okl_service_integration_pvt.klev_tbl_type;
2354 ddx_cimv_tbl okl_service_integration_pvt.cimv_tbl_type;
2355 ddindx binary_integer; indx binary_integer;
2356 begin
2357
2358 -- copy data to the local IN or IN-OUT args, if any
2359
2360
2361
2362
2363
2364 okl_okc_migration_pvt_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0
2365 , p5_a1
2366 , p5_a2
2367 , p5_a3
2368 , p5_a4
2369 , p5_a5
2370 , p5_a6
2371 , p5_a7
2372 , p5_a8
2373 , p5_a9
2374 , p5_a10
2375 , p5_a11
2376 , p5_a12
2377 , p5_a13
2378 , p5_a14
2379 , p5_a15
2380 , p5_a16
2381 , p5_a17
2382 , p5_a18
2383 , p5_a19
2384 , p5_a20
2385 , p5_a21
2386 , p5_a22
2387 , p5_a23
2388 , p5_a24
2389 , p5_a25
2390 , p5_a26
2391 , p5_a27
2392 , p5_a28
2393 , p5_a29
2394 , p5_a30
2395 , p5_a31
2396 , p5_a32
2397 , p5_a33
2398 , p5_a34
2399 , p5_a35
2400 , p5_a36
2401 , p5_a37
2402 , p5_a38
2403 , p5_a39
2404 , p5_a40
2405 , p5_a41
2406 , p5_a42
2407 , p5_a43
2408 , p5_a44
2409 , p5_a45
2410 , p5_a46
2411 , p5_a47
2412 , p5_a48
2413 , p5_a49
2414 , p5_a50
2415 , p5_a51
2416 , p5_a52
2417 , p5_a53
2418 , p5_a54
2419 , p5_a55
2420 , p5_a56
2421 , p5_a57
2422 , p5_a58
2423 , p5_a59
2424 , p5_a60
2425 , p5_a61
2426 , p5_a62
2427 , p5_a63
2428 , p5_a64
2429 , p5_a65
2430 , p5_a66
2431 , p5_a67
2432 , p5_a68
2433 , p5_a69
2434 , p5_a70
2435 , p5_a71
2436 , p5_a72
2437 , p5_a73
2438 , p5_a74
2439 , p5_a75
2440 , p5_a76
2441 , p5_a77
2442 , p5_a78
2443 , p5_a79
2444 , p5_a80
2445 , p5_a81
2446 , p5_a82
2447 , p5_a83
2448 , p5_a84
2449 , p5_a85
2450 , p5_a86
2451 , p5_a87
2452 , p5_a88
2453 , p5_a89
2454 );
2455
2456 okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p6_a0
2457 , p6_a1
2458 , p6_a2
2459 , p6_a3
2460 , p6_a4
2461 , p6_a5
2462 , p6_a6
2463 , p6_a7
2464 , p6_a8
2465 , p6_a9
2466 , p6_a10
2467 , p6_a11
2468 , p6_a12
2469 , p6_a13
2470 , p6_a14
2471 , p6_a15
2472 , p6_a16
2473 , p6_a17
2474 , p6_a18
2475 , p6_a19
2476 , p6_a20
2477 , p6_a21
2478 , p6_a22
2479 , p6_a23
2480 , p6_a24
2481 , p6_a25
2482 , p6_a26
2483 , p6_a27
2484 , p6_a28
2485 , p6_a29
2486 , p6_a30
2487 , p6_a31
2488 , p6_a32
2489 , p6_a33
2490 , p6_a34
2491 , p6_a35
2492 , p6_a36
2493 , p6_a37
2494 , p6_a38
2495 , p6_a39
2496 , p6_a40
2497 , p6_a41
2498 , p6_a42
2499 , p6_a43
2500 , p6_a44
2501 , p6_a45
2502 , p6_a46
2503 , p6_a47
2504 , p6_a48
2505 , p6_a49
2506 , p6_a50
2507 , p6_a51
2508 , p6_a52
2509 , p6_a53
2510 , p6_a54
2511 , p6_a55
2512 , p6_a56
2513 , p6_a57
2514 , p6_a58
2515 , p6_a59
2516 , p6_a60
2517 , p6_a61
2518 , p6_a62
2519 , p6_a63
2520 , p6_a64
2521 , p6_a65
2522 , p6_a66
2523 , p6_a67
2524 , p6_a68
2525 , p6_a69
2526 , p6_a70
2527 , p6_a71
2528 , p6_a72
2529 , p6_a73
2530 , p6_a74
2531 , p6_a75
2532 , p6_a76
2533 , p6_a77
2534 , p6_a78
2535 , p6_a79
2536 , p6_a80
2537 , p6_a81
2538 , p6_a82
2539 , p6_a83
2540 , p6_a84
2541 , p6_a85
2542 , p6_a86
2543 , p6_a87
2544 , p6_a88
2545 , p6_a89
2546 , p6_a90
2547 , p6_a91
2548 , p6_a92
2549 , p6_a93
2550 , p6_a94
2551 , p6_a95
2552 , p6_a96
2553 , p6_a97
2554 , p6_a98
2555 );
2556
2557 okl_okc_migration_pvt_w.rosetta_table_copy_in_p7(ddp_cimv_tbl, p7_a0
2558 , p7_a1
2559 , p7_a2
2560 , p7_a3
2561 , p7_a4
2562 , p7_a5
2563 , p7_a6
2564 , p7_a7
2565 , p7_a8
2566 , p7_a9
2567 , p7_a10
2568 , p7_a11
2569 , p7_a12
2570 , p7_a13
2571 , p7_a14
2572 , p7_a15
2573 , p7_a16
2574 , p7_a17
2575 , p7_a18
2576 , p7_a19
2577 );
2578
2579 okl_service_integration_pvt_w.rosetta_table_copy_in_p21(ddp_cov_tbl, p8_a0
2580 );
2581
2582
2583
2584
2585 -- here's the delegated call to the old PL/SQL routine
2586 okl_service_integration_pvt.update_cov_asset_line(p_api_version,
2587 p_init_msg_list,
2588 x_return_status,
2589 x_msg_count,
2590 x_msg_data,
2591 ddp_clev_tbl,
2592 ddp_klev_tbl,
2593 ddp_cimv_tbl,
2594 ddp_cov_tbl,
2595 ddx_clev_tbl,
2596 ddx_klev_tbl,
2597 ddx_cimv_tbl);
2598
2599 -- copy data back from the local variables to OUT or IN-OUT args, if any
2600
2601
2602
2603
2604
2605
2606
2607
2608
2609 okl_okc_migration_pvt_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p9_a0
2610 , p9_a1
2611 , p9_a2
2612 , p9_a3
2613 , p9_a4
2614 , p9_a5
2615 , p9_a6
2616 , p9_a7
2617 , p9_a8
2618 , p9_a9
2619 , p9_a10
2620 , p9_a11
2621 , p9_a12
2622 , p9_a13
2623 , p9_a14
2624 , p9_a15
2625 , p9_a16
2626 , p9_a17
2627 , p9_a18
2628 , p9_a19
2629 , p9_a20
2630 , p9_a21
2631 , p9_a22
2632 , p9_a23
2633 , p9_a24
2634 , p9_a25
2635 , p9_a26
2636 , p9_a27
2637 , p9_a28
2638 , p9_a29
2639 , p9_a30
2640 , p9_a31
2641 , p9_a32
2642 , p9_a33
2643 , p9_a34
2644 , p9_a35
2645 , p9_a36
2646 , p9_a37
2647 , p9_a38
2648 , p9_a39
2649 , p9_a40
2650 , p9_a41
2651 , p9_a42
2652 , p9_a43
2653 , p9_a44
2654 , p9_a45
2655 , p9_a46
2656 , p9_a47
2657 , p9_a48
2658 , p9_a49
2659 , p9_a50
2660 , p9_a51
2661 , p9_a52
2662 , p9_a53
2663 , p9_a54
2664 , p9_a55
2665 , p9_a56
2666 , p9_a57
2667 , p9_a58
2668 , p9_a59
2669 , p9_a60
2670 , p9_a61
2671 , p9_a62
2672 , p9_a63
2673 , p9_a64
2674 , p9_a65
2675 , p9_a66
2676 , p9_a67
2677 , p9_a68
2678 , p9_a69
2679 , p9_a70
2680 , p9_a71
2681 , p9_a72
2682 , p9_a73
2683 , p9_a74
2684 , p9_a75
2685 , p9_a76
2686 , p9_a77
2687 , p9_a78
2688 , p9_a79
2689 , p9_a80
2690 , p9_a81
2691 , p9_a82
2692 , p9_a83
2693 , p9_a84
2694 , p9_a85
2695 , p9_a86
2696 , p9_a87
2697 , p9_a88
2698 , p9_a89
2699 );
2700
2701 okl_kle_pvt_w.rosetta_table_copy_out_p8(ddx_klev_tbl, p10_a0
2702 , p10_a1
2703 , p10_a2
2704 , p10_a3
2705 , p10_a4
2706 , p10_a5
2707 , p10_a6
2708 , p10_a7
2709 , p10_a8
2710 , p10_a9
2711 , p10_a10
2712 , p10_a11
2713 , p10_a12
2714 , p10_a13
2715 , p10_a14
2716 , p10_a15
2717 , p10_a16
2718 , p10_a17
2719 , p10_a18
2720 , p10_a19
2721 , p10_a20
2722 , p10_a21
2723 , p10_a22
2724 , p10_a23
2725 , p10_a24
2726 , p10_a25
2727 , p10_a26
2728 , p10_a27
2729 , p10_a28
2730 , p10_a29
2731 , p10_a30
2732 , p10_a31
2733 , p10_a32
2734 , p10_a33
2735 , p10_a34
2736 , p10_a35
2737 , p10_a36
2738 , p10_a37
2739 , p10_a38
2740 , p10_a39
2741 , p10_a40
2742 , p10_a41
2743 , p10_a42
2744 , p10_a43
2745 , p10_a44
2746 , p10_a45
2747 , p10_a46
2748 , p10_a47
2749 , p10_a48
2750 , p10_a49
2751 , p10_a50
2752 , p10_a51
2753 , p10_a52
2754 , p10_a53
2755 , p10_a54
2756 , p10_a55
2757 , p10_a56
2758 , p10_a57
2759 , p10_a58
2760 , p10_a59
2761 , p10_a60
2762 , p10_a61
2763 , p10_a62
2764 , p10_a63
2765 , p10_a64
2766 , p10_a65
2767 , p10_a66
2768 , p10_a67
2769 , p10_a68
2770 , p10_a69
2771 , p10_a70
2772 , p10_a71
2773 , p10_a72
2774 , p10_a73
2775 , p10_a74
2776 , p10_a75
2777 , p10_a76
2778 , p10_a77
2779 , p10_a78
2780 , p10_a79
2781 , p10_a80
2782 , p10_a81
2783 , p10_a82
2784 , p10_a83
2785 , p10_a84
2786 , p10_a85
2787 , p10_a86
2788 , p10_a87
2789 , p10_a88
2790 , p10_a89
2791 , p10_a90
2792 , p10_a91
2793 , p10_a92
2794 , p10_a93
2795 , p10_a94
2796 , p10_a95
2797 , p10_a96
2798 , p10_a97
2799 , p10_a98
2800 );
2801
2802 okl_okc_migration_pvt_w.rosetta_table_copy_out_p7(ddx_cimv_tbl, p11_a0
2803 , p11_a1
2804 , p11_a2
2805 , p11_a3
2806 , p11_a4
2807 , p11_a5
2808 , p11_a6
2809 , p11_a7
2810 , p11_a8
2811 , p11_a9
2812 , p11_a10
2813 , p11_a11
2814 , p11_a12
2815 , p11_a13
2816 , p11_a14
2817 , p11_a15
2818 , p11_a16
2819 , p11_a17
2820 , p11_a18
2821 , p11_a19
2822 );
2823 end;
2824
2825 end okl_service_integration_pvt_w;