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