[Home] [Help]
PACKAGE BODY: APPS.OKL_ASD_PVT_W
Source
1 package body okl_asd_pvt_w as
2 /* $Header: OKLIASDB.pls 115.6 2002/12/20 19:22:04 avsingh 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_p2(t out nocopy okl_asd_pvt.asd_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_NUMBER_TABLE
26 , a4 JTF_NUMBER_TABLE
27 , a5 JTF_VARCHAR2_TABLE_100
28 , a6 JTF_NUMBER_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_VARCHAR2_TABLE_100
31 , a9 JTF_NUMBER_TABLE
32 , a10 JTF_VARCHAR2_TABLE_100
33 , a11 JTF_NUMBER_TABLE
34 , a12 JTF_NUMBER_TABLE
35 , a13 JTF_NUMBER_TABLE
36 , a14 JTF_NUMBER_TABLE
37 , a15 JTF_VARCHAR2_TABLE_100
38 , a16 JTF_VARCHAR2_TABLE_500
39 , a17 JTF_VARCHAR2_TABLE_500
40 , a18 JTF_VARCHAR2_TABLE_500
41 , a19 JTF_VARCHAR2_TABLE_500
42 , a20 JTF_VARCHAR2_TABLE_500
43 , a21 JTF_VARCHAR2_TABLE_500
44 , a22 JTF_VARCHAR2_TABLE_500
45 , a23 JTF_VARCHAR2_TABLE_500
46 , a24 JTF_VARCHAR2_TABLE_500
47 , a25 JTF_VARCHAR2_TABLE_500
48 , a26 JTF_VARCHAR2_TABLE_500
49 , a27 JTF_VARCHAR2_TABLE_500
50 , a28 JTF_VARCHAR2_TABLE_500
51 , a29 JTF_VARCHAR2_TABLE_500
52 , a30 JTF_VARCHAR2_TABLE_500
53 , a31 JTF_NUMBER_TABLE
54 , a32 JTF_DATE_TABLE
55 , a33 JTF_NUMBER_TABLE
56 , a34 JTF_DATE_TABLE
57 , a35 JTF_NUMBER_TABLE
58 , a36 JTF_VARCHAR2_TABLE_100
59 , a37 JTF_VARCHAR2_TABLE_100
60 , a38 JTF_NUMBER_TABLE
61 , a39 JTF_DATE_TABLE
62 ) as
63 ddindx binary_integer; indx binary_integer;
64 begin
65 if a0 is not null and a0.count > 0 then
66 if a0.count > 0 then
67 indx := a0.first;
68 ddindx := 1;
69 while true loop
70 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
71 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
72 t(ddindx).tal_id := rosetta_g_miss_num_map(a2(indx));
73 t(ddindx).target_kle_id := rosetta_g_miss_num_map(a3(indx));
74 t(ddindx).line_detail_number := rosetta_g_miss_num_map(a4(indx));
75 t(ddindx).asset_number := a5(indx);
76 t(ddindx).quantity := rosetta_g_miss_num_map(a6(indx));
77 t(ddindx).cost := rosetta_g_miss_num_map(a7(indx));
78 t(ddindx).tax_book := a8(indx);
79 t(ddindx).life_in_months_tax := rosetta_g_miss_num_map(a9(indx));
80 t(ddindx).deprn_method_tax := a10(indx);
81 t(ddindx).deprn_rate_tax := rosetta_g_miss_num_map(a11(indx));
82 t(ddindx).salvage_value := rosetta_g_miss_num_map(a12(indx));
83 t(ddindx).split_percent := rosetta_g_miss_num_map(a13(indx));
84 t(ddindx).inventory_item_id := rosetta_g_miss_num_map(a14(indx));
85 t(ddindx).attribute_category := a15(indx);
86 t(ddindx).attribute1 := a16(indx);
87 t(ddindx).attribute2 := a17(indx);
88 t(ddindx).attribute3 := a18(indx);
89 t(ddindx).attribute4 := a19(indx);
90 t(ddindx).attribute5 := a20(indx);
91 t(ddindx).attribute6 := a21(indx);
92 t(ddindx).attribute7 := a22(indx);
93 t(ddindx).attribute8 := a23(indx);
94 t(ddindx).attribute9 := a24(indx);
95 t(ddindx).attribute10 := a25(indx);
96 t(ddindx).attribute11 := a26(indx);
97 t(ddindx).attribute12 := a27(indx);
98 t(ddindx).attribute13 := a28(indx);
99 t(ddindx).attribute14 := a29(indx);
100 t(ddindx).attribute15 := a30(indx);
101 t(ddindx).created_by := rosetta_g_miss_num_map(a31(indx));
102 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a32(indx));
103 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a33(indx));
104 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a34(indx));
105 t(ddindx).last_update_login := rosetta_g_miss_num_map(a35(indx));
106 t(ddindx).currency_code := a36(indx);
107 t(ddindx).currency_conversion_type := a37(indx);
108 t(ddindx).currency_conversion_rate := rosetta_g_miss_num_map(a38(indx));
109 t(ddindx).currency_conversion_date := rosetta_g_miss_date_in_map(a39(indx));
110 ddindx := ddindx+1;
111 if a0.last =indx
112 then exit;
113 end if;
114 indx := a0.next(indx);
115 end loop;
116 end if;
117 end if;
118 end rosetta_table_copy_in_p2;
119 procedure rosetta_table_copy_out_p2(t okl_asd_pvt.asd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120 , a1 out nocopy JTF_NUMBER_TABLE
121 , a2 out nocopy JTF_NUMBER_TABLE
122 , a3 out nocopy JTF_NUMBER_TABLE
123 , a4 out nocopy JTF_NUMBER_TABLE
124 , a5 out nocopy JTF_VARCHAR2_TABLE_100
125 , a6 out nocopy JTF_NUMBER_TABLE
126 , a7 out nocopy JTF_NUMBER_TABLE
127 , a8 out nocopy JTF_VARCHAR2_TABLE_100
128 , a9 out nocopy JTF_NUMBER_TABLE
129 , a10 out nocopy JTF_VARCHAR2_TABLE_100
130 , a11 out nocopy JTF_NUMBER_TABLE
131 , a12 out nocopy JTF_NUMBER_TABLE
132 , a13 out nocopy JTF_NUMBER_TABLE
133 , a14 out nocopy JTF_NUMBER_TABLE
134 , a15 out nocopy JTF_VARCHAR2_TABLE_100
135 , a16 out nocopy JTF_VARCHAR2_TABLE_500
136 , a17 out nocopy JTF_VARCHAR2_TABLE_500
137 , a18 out nocopy JTF_VARCHAR2_TABLE_500
138 , a19 out nocopy JTF_VARCHAR2_TABLE_500
139 , a20 out nocopy JTF_VARCHAR2_TABLE_500
140 , a21 out nocopy JTF_VARCHAR2_TABLE_500
141 , a22 out nocopy JTF_VARCHAR2_TABLE_500
142 , a23 out nocopy JTF_VARCHAR2_TABLE_500
143 , a24 out nocopy JTF_VARCHAR2_TABLE_500
144 , a25 out nocopy JTF_VARCHAR2_TABLE_500
145 , a26 out nocopy JTF_VARCHAR2_TABLE_500
146 , a27 out nocopy JTF_VARCHAR2_TABLE_500
147 , a28 out nocopy JTF_VARCHAR2_TABLE_500
148 , a29 out nocopy JTF_VARCHAR2_TABLE_500
149 , a30 out nocopy JTF_VARCHAR2_TABLE_500
150 , a31 out nocopy JTF_NUMBER_TABLE
151 , a32 out nocopy JTF_DATE_TABLE
152 , a33 out nocopy JTF_NUMBER_TABLE
153 , a34 out nocopy JTF_DATE_TABLE
154 , a35 out nocopy JTF_NUMBER_TABLE
155 , a36 out nocopy JTF_VARCHAR2_TABLE_100
156 , a37 out nocopy JTF_VARCHAR2_TABLE_100
157 , a38 out nocopy JTF_NUMBER_TABLE
158 , a39 out nocopy JTF_DATE_TABLE
159 ) as
160 ddindx binary_integer; indx binary_integer;
161 begin
162 if t is null or t.count = 0 then
163 a0 := JTF_NUMBER_TABLE();
164 a1 := JTF_NUMBER_TABLE();
165 a2 := JTF_NUMBER_TABLE();
166 a3 := JTF_NUMBER_TABLE();
167 a4 := JTF_NUMBER_TABLE();
168 a5 := JTF_VARCHAR2_TABLE_100();
169 a6 := JTF_NUMBER_TABLE();
170 a7 := JTF_NUMBER_TABLE();
171 a8 := JTF_VARCHAR2_TABLE_100();
172 a9 := JTF_NUMBER_TABLE();
173 a10 := JTF_VARCHAR2_TABLE_100();
174 a11 := JTF_NUMBER_TABLE();
175 a12 := JTF_NUMBER_TABLE();
176 a13 := JTF_NUMBER_TABLE();
177 a14 := JTF_NUMBER_TABLE();
178 a15 := JTF_VARCHAR2_TABLE_100();
179 a16 := JTF_VARCHAR2_TABLE_500();
180 a17 := JTF_VARCHAR2_TABLE_500();
181 a18 := JTF_VARCHAR2_TABLE_500();
182 a19 := JTF_VARCHAR2_TABLE_500();
183 a20 := JTF_VARCHAR2_TABLE_500();
184 a21 := JTF_VARCHAR2_TABLE_500();
185 a22 := JTF_VARCHAR2_TABLE_500();
186 a23 := JTF_VARCHAR2_TABLE_500();
187 a24 := JTF_VARCHAR2_TABLE_500();
188 a25 := JTF_VARCHAR2_TABLE_500();
189 a26 := JTF_VARCHAR2_TABLE_500();
190 a27 := JTF_VARCHAR2_TABLE_500();
191 a28 := JTF_VARCHAR2_TABLE_500();
192 a29 := JTF_VARCHAR2_TABLE_500();
193 a30 := JTF_VARCHAR2_TABLE_500();
194 a31 := JTF_NUMBER_TABLE();
195 a32 := JTF_DATE_TABLE();
196 a33 := JTF_NUMBER_TABLE();
197 a34 := JTF_DATE_TABLE();
198 a35 := JTF_NUMBER_TABLE();
199 a36 := JTF_VARCHAR2_TABLE_100();
200 a37 := JTF_VARCHAR2_TABLE_100();
201 a38 := JTF_NUMBER_TABLE();
202 a39 := JTF_DATE_TABLE();
203 else
204 a0 := JTF_NUMBER_TABLE();
205 a1 := JTF_NUMBER_TABLE();
206 a2 := JTF_NUMBER_TABLE();
207 a3 := JTF_NUMBER_TABLE();
208 a4 := JTF_NUMBER_TABLE();
209 a5 := JTF_VARCHAR2_TABLE_100();
210 a6 := JTF_NUMBER_TABLE();
211 a7 := JTF_NUMBER_TABLE();
212 a8 := JTF_VARCHAR2_TABLE_100();
213 a9 := JTF_NUMBER_TABLE();
214 a10 := JTF_VARCHAR2_TABLE_100();
215 a11 := JTF_NUMBER_TABLE();
216 a12 := JTF_NUMBER_TABLE();
217 a13 := JTF_NUMBER_TABLE();
218 a14 := JTF_NUMBER_TABLE();
219 a15 := JTF_VARCHAR2_TABLE_100();
220 a16 := JTF_VARCHAR2_TABLE_500();
221 a17 := JTF_VARCHAR2_TABLE_500();
222 a18 := JTF_VARCHAR2_TABLE_500();
223 a19 := JTF_VARCHAR2_TABLE_500();
224 a20 := JTF_VARCHAR2_TABLE_500();
225 a21 := JTF_VARCHAR2_TABLE_500();
226 a22 := JTF_VARCHAR2_TABLE_500();
227 a23 := JTF_VARCHAR2_TABLE_500();
228 a24 := JTF_VARCHAR2_TABLE_500();
229 a25 := JTF_VARCHAR2_TABLE_500();
230 a26 := JTF_VARCHAR2_TABLE_500();
231 a27 := JTF_VARCHAR2_TABLE_500();
232 a28 := JTF_VARCHAR2_TABLE_500();
233 a29 := JTF_VARCHAR2_TABLE_500();
234 a30 := JTF_VARCHAR2_TABLE_500();
235 a31 := JTF_NUMBER_TABLE();
236 a32 := JTF_DATE_TABLE();
237 a33 := JTF_NUMBER_TABLE();
238 a34 := JTF_DATE_TABLE();
239 a35 := JTF_NUMBER_TABLE();
240 a36 := JTF_VARCHAR2_TABLE_100();
241 a37 := JTF_VARCHAR2_TABLE_100();
242 a38 := JTF_NUMBER_TABLE();
243 a39 := JTF_DATE_TABLE();
244 if t.count > 0 then
245 a0.extend(t.count);
246 a1.extend(t.count);
247 a2.extend(t.count);
248 a3.extend(t.count);
249 a4.extend(t.count);
250 a5.extend(t.count);
251 a6.extend(t.count);
252 a7.extend(t.count);
253 a8.extend(t.count);
254 a9.extend(t.count);
255 a10.extend(t.count);
256 a11.extend(t.count);
257 a12.extend(t.count);
258 a13.extend(t.count);
259 a14.extend(t.count);
260 a15.extend(t.count);
261 a16.extend(t.count);
262 a17.extend(t.count);
263 a18.extend(t.count);
264 a19.extend(t.count);
265 a20.extend(t.count);
266 a21.extend(t.count);
267 a22.extend(t.count);
268 a23.extend(t.count);
269 a24.extend(t.count);
270 a25.extend(t.count);
271 a26.extend(t.count);
272 a27.extend(t.count);
273 a28.extend(t.count);
274 a29.extend(t.count);
275 a30.extend(t.count);
276 a31.extend(t.count);
277 a32.extend(t.count);
278 a33.extend(t.count);
279 a34.extend(t.count);
280 a35.extend(t.count);
281 a36.extend(t.count);
282 a37.extend(t.count);
283 a38.extend(t.count);
284 a39.extend(t.count);
285 ddindx := t.first;
286 indx := 1;
287 while true loop
288 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
289 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
290 a2(indx) := rosetta_g_miss_num_map(t(ddindx).tal_id);
291 a3(indx) := rosetta_g_miss_num_map(t(ddindx).target_kle_id);
292 a4(indx) := rosetta_g_miss_num_map(t(ddindx).line_detail_number);
293 a5(indx) := t(ddindx).asset_number;
294 a6(indx) := rosetta_g_miss_num_map(t(ddindx).quantity);
295 a7(indx) := rosetta_g_miss_num_map(t(ddindx).cost);
296 a8(indx) := t(ddindx).tax_book;
297 a9(indx) := rosetta_g_miss_num_map(t(ddindx).life_in_months_tax);
298 a10(indx) := t(ddindx).deprn_method_tax;
299 a11(indx) := rosetta_g_miss_num_map(t(ddindx).deprn_rate_tax);
300 a12(indx) := rosetta_g_miss_num_map(t(ddindx).salvage_value);
301 a13(indx) := rosetta_g_miss_num_map(t(ddindx).split_percent);
302 a14(indx) := rosetta_g_miss_num_map(t(ddindx).inventory_item_id);
303 a15(indx) := t(ddindx).attribute_category;
304 a16(indx) := t(ddindx).attribute1;
305 a17(indx) := t(ddindx).attribute2;
306 a18(indx) := t(ddindx).attribute3;
307 a19(indx) := t(ddindx).attribute4;
308 a20(indx) := t(ddindx).attribute5;
309 a21(indx) := t(ddindx).attribute6;
310 a22(indx) := t(ddindx).attribute7;
311 a23(indx) := t(ddindx).attribute8;
312 a24(indx) := t(ddindx).attribute9;
313 a25(indx) := t(ddindx).attribute10;
314 a26(indx) := t(ddindx).attribute11;
315 a27(indx) := t(ddindx).attribute12;
316 a28(indx) := t(ddindx).attribute13;
317 a29(indx) := t(ddindx).attribute14;
318 a30(indx) := t(ddindx).attribute15;
319 a31(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
320 a32(indx) := t(ddindx).creation_date;
321 a33(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
322 a34(indx) := t(ddindx).last_update_date;
323 a35(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
324 a36(indx) := t(ddindx).currency_code;
325 a37(indx) := t(ddindx).currency_conversion_type;
326 a38(indx) := rosetta_g_miss_num_map(t(ddindx).currency_conversion_rate);
327 a39(indx) := t(ddindx).currency_conversion_date;
328 indx := indx+1;
329 if t.last =ddindx
330 then exit;
331 end if;
332 ddindx := t.next(ddindx);
333 end loop;
334 end if;
335 end if;
336 end rosetta_table_copy_out_p2;
337
338 procedure rosetta_table_copy_in_p5(t out nocopy okl_asd_pvt.okl_txd_assets_tl_tbl_type, a0 JTF_NUMBER_TABLE
339 , a1 JTF_VARCHAR2_TABLE_100
340 , a2 JTF_VARCHAR2_TABLE_100
341 , a3 JTF_VARCHAR2_TABLE_100
342 , a4 JTF_VARCHAR2_TABLE_2000
343 , a5 JTF_NUMBER_TABLE
344 , a6 JTF_DATE_TABLE
345 , a7 JTF_NUMBER_TABLE
346 , a8 JTF_DATE_TABLE
347 , a9 JTF_NUMBER_TABLE
348 ) as
349 ddindx binary_integer; indx binary_integer;
350 begin
351 if a0 is not null and a0.count > 0 then
352 if a0.count > 0 then
353 indx := a0.first;
354 ddindx := 1;
355 while true loop
356 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
357 t(ddindx).language := a1(indx);
358 t(ddindx).source_lang := a2(indx);
359 t(ddindx).sfwt_flag := a3(indx);
360 t(ddindx).description := a4(indx);
361 t(ddindx).created_by := rosetta_g_miss_num_map(a5(indx));
362 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a6(indx));
363 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a7(indx));
364 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a8(indx));
365 t(ddindx).last_update_login := rosetta_g_miss_num_map(a9(indx));
366 ddindx := ddindx+1;
367 if a0.last =indx
368 then exit;
369 end if;
370 indx := a0.next(indx);
371 end loop;
372 end if;
373 end if;
374 end rosetta_table_copy_in_p5;
375 procedure rosetta_table_copy_out_p5(t okl_asd_pvt.okl_txd_assets_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
376 , a1 out nocopy JTF_VARCHAR2_TABLE_100
377 , a2 out nocopy JTF_VARCHAR2_TABLE_100
378 , a3 out nocopy JTF_VARCHAR2_TABLE_100
379 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
380 , a5 out nocopy JTF_NUMBER_TABLE
381 , a6 out nocopy JTF_DATE_TABLE
382 , a7 out nocopy JTF_NUMBER_TABLE
383 , a8 out nocopy JTF_DATE_TABLE
384 , a9 out nocopy JTF_NUMBER_TABLE
385 ) as
386 ddindx binary_integer; indx binary_integer;
387 begin
388 if t is null or t.count = 0 then
389 a0 := JTF_NUMBER_TABLE();
390 a1 := JTF_VARCHAR2_TABLE_100();
391 a2 := JTF_VARCHAR2_TABLE_100();
392 a3 := JTF_VARCHAR2_TABLE_100();
393 a4 := JTF_VARCHAR2_TABLE_2000();
394 a5 := JTF_NUMBER_TABLE();
395 a6 := JTF_DATE_TABLE();
396 a7 := JTF_NUMBER_TABLE();
397 a8 := JTF_DATE_TABLE();
398 a9 := JTF_NUMBER_TABLE();
399 else
400 a0 := JTF_NUMBER_TABLE();
401 a1 := JTF_VARCHAR2_TABLE_100();
402 a2 := JTF_VARCHAR2_TABLE_100();
403 a3 := JTF_VARCHAR2_TABLE_100();
404 a4 := JTF_VARCHAR2_TABLE_2000();
405 a5 := JTF_NUMBER_TABLE();
406 a6 := JTF_DATE_TABLE();
407 a7 := JTF_NUMBER_TABLE();
408 a8 := JTF_DATE_TABLE();
409 a9 := JTF_NUMBER_TABLE();
410 if t.count > 0 then
414 a3.extend(t.count);
411 a0.extend(t.count);
412 a1.extend(t.count);
413 a2.extend(t.count);
415 a4.extend(t.count);
416 a5.extend(t.count);
417 a6.extend(t.count);
418 a7.extend(t.count);
419 a8.extend(t.count);
420 a9.extend(t.count);
421 ddindx := t.first;
422 indx := 1;
423 while true loop
424 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
425 a1(indx) := t(ddindx).language;
426 a2(indx) := t(ddindx).source_lang;
427 a3(indx) := t(ddindx).sfwt_flag;
428 a4(indx) := t(ddindx).description;
429 a5(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
430 a6(indx) := t(ddindx).creation_date;
431 a7(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
432 a8(indx) := t(ddindx).last_update_date;
433 a9(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
434 indx := indx+1;
435 if t.last =ddindx
436 then exit;
437 end if;
438 ddindx := t.next(ddindx);
439 end loop;
440 end if;
441 end if;
442 end rosetta_table_copy_out_p5;
443
444 procedure rosetta_table_copy_in_p8(t out nocopy okl_asd_pvt.asdv_tbl_type, a0 JTF_NUMBER_TABLE
445 , a1 JTF_NUMBER_TABLE
446 , a2 JTF_VARCHAR2_TABLE_100
447 , a3 JTF_NUMBER_TABLE
448 , a4 JTF_NUMBER_TABLE
449 , a5 JTF_NUMBER_TABLE
450 , a6 JTF_VARCHAR2_TABLE_100
451 , a7 JTF_VARCHAR2_TABLE_2000
452 , a8 JTF_NUMBER_TABLE
453 , a9 JTF_NUMBER_TABLE
454 , a10 JTF_VARCHAR2_TABLE_100
455 , a11 JTF_NUMBER_TABLE
456 , a12 JTF_VARCHAR2_TABLE_100
457 , a13 JTF_NUMBER_TABLE
458 , a14 JTF_NUMBER_TABLE
459 , a15 JTF_NUMBER_TABLE
460 , a16 JTF_NUMBER_TABLE
461 , a17 JTF_VARCHAR2_TABLE_100
462 , a18 JTF_VARCHAR2_TABLE_500
463 , a19 JTF_VARCHAR2_TABLE_500
464 , a20 JTF_VARCHAR2_TABLE_500
465 , a21 JTF_VARCHAR2_TABLE_500
466 , a22 JTF_VARCHAR2_TABLE_500
467 , a23 JTF_VARCHAR2_TABLE_500
468 , a24 JTF_VARCHAR2_TABLE_500
469 , a25 JTF_VARCHAR2_TABLE_500
470 , a26 JTF_VARCHAR2_TABLE_500
471 , a27 JTF_VARCHAR2_TABLE_500
472 , a28 JTF_VARCHAR2_TABLE_500
473 , a29 JTF_VARCHAR2_TABLE_500
474 , a30 JTF_VARCHAR2_TABLE_500
475 , a31 JTF_VARCHAR2_TABLE_500
476 , a32 JTF_VARCHAR2_TABLE_500
477 , a33 JTF_NUMBER_TABLE
478 , a34 JTF_DATE_TABLE
479 , a35 JTF_NUMBER_TABLE
480 , a36 JTF_DATE_TABLE
481 , a37 JTF_NUMBER_TABLE
482 , a38 JTF_VARCHAR2_TABLE_100
483 , a39 JTF_VARCHAR2_TABLE_100
484 , a40 JTF_NUMBER_TABLE
485 , a41 JTF_DATE_TABLE
486 ) as
487 ddindx binary_integer; indx binary_integer;
488 begin
489 if a0 is not null and a0.count > 0 then
490 if a0.count > 0 then
491 indx := a0.first;
492 ddindx := 1;
493 while true loop
494 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
495 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
496 t(ddindx).sfwt_flag := a2(indx);
497 t(ddindx).tal_id := rosetta_g_miss_num_map(a3(indx));
498 t(ddindx).target_kle_id := rosetta_g_miss_num_map(a4(indx));
499 t(ddindx).line_detail_number := rosetta_g_miss_num_map(a5(indx));
500 t(ddindx).asset_number := a6(indx);
501 t(ddindx).description := a7(indx);
502 t(ddindx).quantity := rosetta_g_miss_num_map(a8(indx));
503 t(ddindx).cost := rosetta_g_miss_num_map(a9(indx));
504 t(ddindx).tax_book := a10(indx);
505 t(ddindx).life_in_months_tax := rosetta_g_miss_num_map(a11(indx));
506 t(ddindx).deprn_method_tax := a12(indx);
507 t(ddindx).deprn_rate_tax := rosetta_g_miss_num_map(a13(indx));
508 t(ddindx).salvage_value := rosetta_g_miss_num_map(a14(indx));
509 t(ddindx).split_percent := rosetta_g_miss_num_map(a15(indx));
510 t(ddindx).inventory_item_id := rosetta_g_miss_num_map(a16(indx));
511 t(ddindx).attribute_category := a17(indx);
512 t(ddindx).attribute1 := a18(indx);
516 t(ddindx).attribute5 := a22(indx);
513 t(ddindx).attribute2 := a19(indx);
514 t(ddindx).attribute3 := a20(indx);
515 t(ddindx).attribute4 := a21(indx);
517 t(ddindx).attribute6 := a23(indx);
518 t(ddindx).attribute7 := a24(indx);
519 t(ddindx).attribute8 := a25(indx);
520 t(ddindx).attribute9 := a26(indx);
521 t(ddindx).attribute10 := a27(indx);
522 t(ddindx).attribute11 := a28(indx);
523 t(ddindx).attribute12 := a29(indx);
524 t(ddindx).attribute13 := a30(indx);
525 t(ddindx).attribute14 := a31(indx);
526 t(ddindx).attribute15 := a32(indx);
527 t(ddindx).created_by := rosetta_g_miss_num_map(a33(indx));
528 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a34(indx));
529 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a35(indx));
530 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a36(indx));
531 t(ddindx).last_update_login := rosetta_g_miss_num_map(a37(indx));
532 t(ddindx).currency_code := a38(indx);
533 t(ddindx).currency_conversion_type := a39(indx);
534 t(ddindx).currency_conversion_rate := rosetta_g_miss_num_map(a40(indx));
535 t(ddindx).currency_conversion_date := rosetta_g_miss_date_in_map(a41(indx));
536 ddindx := ddindx+1;
537 if a0.last =indx
538 then exit;
539 end if;
540 indx := a0.next(indx);
541 end loop;
542 end if;
543 end if;
544 end rosetta_table_copy_in_p8;
545 procedure rosetta_table_copy_out_p8(t okl_asd_pvt.asdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
546 , a1 out nocopy JTF_NUMBER_TABLE
547 , a2 out nocopy JTF_VARCHAR2_TABLE_100
548 , a3 out nocopy JTF_NUMBER_TABLE
549 , a4 out nocopy JTF_NUMBER_TABLE
550 , a5 out nocopy JTF_NUMBER_TABLE
551 , a6 out nocopy JTF_VARCHAR2_TABLE_100
552 , a7 out nocopy JTF_VARCHAR2_TABLE_2000
553 , a8 out nocopy JTF_NUMBER_TABLE
554 , a9 out nocopy JTF_NUMBER_TABLE
555 , a10 out nocopy JTF_VARCHAR2_TABLE_100
556 , a11 out nocopy JTF_NUMBER_TABLE
557 , a12 out nocopy JTF_VARCHAR2_TABLE_100
558 , a13 out nocopy JTF_NUMBER_TABLE
559 , a14 out nocopy JTF_NUMBER_TABLE
560 , a15 out nocopy JTF_NUMBER_TABLE
561 , a16 out nocopy JTF_NUMBER_TABLE
562 , a17 out nocopy JTF_VARCHAR2_TABLE_100
563 , a18 out nocopy JTF_VARCHAR2_TABLE_500
564 , a19 out nocopy JTF_VARCHAR2_TABLE_500
565 , a20 out nocopy JTF_VARCHAR2_TABLE_500
566 , a21 out nocopy JTF_VARCHAR2_TABLE_500
567 , a22 out nocopy JTF_VARCHAR2_TABLE_500
568 , a23 out nocopy JTF_VARCHAR2_TABLE_500
569 , a24 out nocopy JTF_VARCHAR2_TABLE_500
570 , a25 out nocopy JTF_VARCHAR2_TABLE_500
571 , a26 out nocopy JTF_VARCHAR2_TABLE_500
572 , a27 out nocopy JTF_VARCHAR2_TABLE_500
573 , a28 out nocopy JTF_VARCHAR2_TABLE_500
574 , a29 out nocopy JTF_VARCHAR2_TABLE_500
575 , a30 out nocopy JTF_VARCHAR2_TABLE_500
576 , a31 out nocopy JTF_VARCHAR2_TABLE_500
577 , a32 out nocopy JTF_VARCHAR2_TABLE_500
578 , a33 out nocopy JTF_NUMBER_TABLE
579 , a34 out nocopy JTF_DATE_TABLE
580 , a35 out nocopy JTF_NUMBER_TABLE
581 , a36 out nocopy JTF_DATE_TABLE
582 , a37 out nocopy JTF_NUMBER_TABLE
583 , a38 out nocopy JTF_VARCHAR2_TABLE_100
584 , a39 out nocopy JTF_VARCHAR2_TABLE_100
585 , a40 out nocopy JTF_NUMBER_TABLE
586 , a41 out nocopy JTF_DATE_TABLE
587 ) as
588 ddindx binary_integer; indx binary_integer;
589 begin
590 if t is null or t.count = 0 then
591 a0 := JTF_NUMBER_TABLE();
592 a1 := JTF_NUMBER_TABLE();
593 a2 := JTF_VARCHAR2_TABLE_100();
594 a3 := JTF_NUMBER_TABLE();
595 a4 := JTF_NUMBER_TABLE();
596 a5 := JTF_NUMBER_TABLE();
597 a6 := JTF_VARCHAR2_TABLE_100();
598 a7 := JTF_VARCHAR2_TABLE_2000();
599 a8 := JTF_NUMBER_TABLE();
600 a9 := JTF_NUMBER_TABLE();
601 a10 := JTF_VARCHAR2_TABLE_100();
602 a11 := JTF_NUMBER_TABLE();
603 a12 := JTF_VARCHAR2_TABLE_100();
604 a13 := JTF_NUMBER_TABLE();
605 a14 := JTF_NUMBER_TABLE();
606 a15 := JTF_NUMBER_TABLE();
607 a16 := JTF_NUMBER_TABLE();
611 a20 := JTF_VARCHAR2_TABLE_500();
608 a17 := JTF_VARCHAR2_TABLE_100();
609 a18 := JTF_VARCHAR2_TABLE_500();
610 a19 := JTF_VARCHAR2_TABLE_500();
612 a21 := JTF_VARCHAR2_TABLE_500();
613 a22 := JTF_VARCHAR2_TABLE_500();
614 a23 := JTF_VARCHAR2_TABLE_500();
615 a24 := JTF_VARCHAR2_TABLE_500();
616 a25 := JTF_VARCHAR2_TABLE_500();
617 a26 := JTF_VARCHAR2_TABLE_500();
618 a27 := JTF_VARCHAR2_TABLE_500();
619 a28 := JTF_VARCHAR2_TABLE_500();
620 a29 := JTF_VARCHAR2_TABLE_500();
621 a30 := JTF_VARCHAR2_TABLE_500();
622 a31 := JTF_VARCHAR2_TABLE_500();
623 a32 := JTF_VARCHAR2_TABLE_500();
624 a33 := JTF_NUMBER_TABLE();
625 a34 := JTF_DATE_TABLE();
626 a35 := JTF_NUMBER_TABLE();
627 a36 := JTF_DATE_TABLE();
628 a37 := JTF_NUMBER_TABLE();
629 a38 := JTF_VARCHAR2_TABLE_100();
630 a39 := JTF_VARCHAR2_TABLE_100();
631 a40 := JTF_NUMBER_TABLE();
632 a41 := JTF_DATE_TABLE();
633 else
634 a0 := JTF_NUMBER_TABLE();
635 a1 := JTF_NUMBER_TABLE();
636 a2 := JTF_VARCHAR2_TABLE_100();
637 a3 := JTF_NUMBER_TABLE();
638 a4 := JTF_NUMBER_TABLE();
639 a5 := JTF_NUMBER_TABLE();
640 a6 := JTF_VARCHAR2_TABLE_100();
641 a7 := JTF_VARCHAR2_TABLE_2000();
642 a8 := JTF_NUMBER_TABLE();
643 a9 := JTF_NUMBER_TABLE();
644 a10 := JTF_VARCHAR2_TABLE_100();
645 a11 := JTF_NUMBER_TABLE();
646 a12 := JTF_VARCHAR2_TABLE_100();
647 a13 := JTF_NUMBER_TABLE();
648 a14 := JTF_NUMBER_TABLE();
649 a15 := JTF_NUMBER_TABLE();
650 a16 := JTF_NUMBER_TABLE();
651 a17 := JTF_VARCHAR2_TABLE_100();
652 a18 := JTF_VARCHAR2_TABLE_500();
653 a19 := JTF_VARCHAR2_TABLE_500();
654 a20 := JTF_VARCHAR2_TABLE_500();
655 a21 := JTF_VARCHAR2_TABLE_500();
656 a22 := JTF_VARCHAR2_TABLE_500();
657 a23 := JTF_VARCHAR2_TABLE_500();
658 a24 := JTF_VARCHAR2_TABLE_500();
659 a25 := JTF_VARCHAR2_TABLE_500();
660 a26 := JTF_VARCHAR2_TABLE_500();
661 a27 := JTF_VARCHAR2_TABLE_500();
662 a28 := JTF_VARCHAR2_TABLE_500();
663 a29 := JTF_VARCHAR2_TABLE_500();
664 a30 := JTF_VARCHAR2_TABLE_500();
665 a31 := JTF_VARCHAR2_TABLE_500();
666 a32 := JTF_VARCHAR2_TABLE_500();
667 a33 := JTF_NUMBER_TABLE();
668 a34 := JTF_DATE_TABLE();
669 a35 := JTF_NUMBER_TABLE();
670 a36 := JTF_DATE_TABLE();
671 a37 := JTF_NUMBER_TABLE();
672 a38 := JTF_VARCHAR2_TABLE_100();
673 a39 := JTF_VARCHAR2_TABLE_100();
674 a40 := JTF_NUMBER_TABLE();
675 a41 := JTF_DATE_TABLE();
676 if t.count > 0 then
677 a0.extend(t.count);
678 a1.extend(t.count);
679 a2.extend(t.count);
680 a3.extend(t.count);
681 a4.extend(t.count);
682 a5.extend(t.count);
683 a6.extend(t.count);
684 a7.extend(t.count);
685 a8.extend(t.count);
686 a9.extend(t.count);
687 a10.extend(t.count);
688 a11.extend(t.count);
689 a12.extend(t.count);
690 a13.extend(t.count);
691 a14.extend(t.count);
692 a15.extend(t.count);
693 a16.extend(t.count);
694 a17.extend(t.count);
695 a18.extend(t.count);
696 a19.extend(t.count);
697 a20.extend(t.count);
698 a21.extend(t.count);
699 a22.extend(t.count);
700 a23.extend(t.count);
701 a24.extend(t.count);
702 a25.extend(t.count);
703 a26.extend(t.count);
704 a27.extend(t.count);
705 a28.extend(t.count);
706 a29.extend(t.count);
707 a30.extend(t.count);
708 a31.extend(t.count);
709 a32.extend(t.count);
710 a33.extend(t.count);
711 a34.extend(t.count);
712 a35.extend(t.count);
713 a36.extend(t.count);
714 a37.extend(t.count);
715 a38.extend(t.count);
716 a39.extend(t.count);
717 a40.extend(t.count);
718 a41.extend(t.count);
719 ddindx := t.first;
720 indx := 1;
721 while true loop
722 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
723 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
724 a2(indx) := t(ddindx).sfwt_flag;
725 a3(indx) := rosetta_g_miss_num_map(t(ddindx).tal_id);
726 a4(indx) := rosetta_g_miss_num_map(t(ddindx).target_kle_id);
727 a5(indx) := rosetta_g_miss_num_map(t(ddindx).line_detail_number);
728 a6(indx) := t(ddindx).asset_number;
729 a7(indx) := t(ddindx).description;
730 a8(indx) := rosetta_g_miss_num_map(t(ddindx).quantity);
731 a9(indx) := rosetta_g_miss_num_map(t(ddindx).cost);
732 a10(indx) := t(ddindx).tax_book;
733 a11(indx) := rosetta_g_miss_num_map(t(ddindx).life_in_months_tax);
734 a12(indx) := t(ddindx).deprn_method_tax;
735 a13(indx) := rosetta_g_miss_num_map(t(ddindx).deprn_rate_tax);
739 a17(indx) := t(ddindx).attribute_category;
736 a14(indx) := rosetta_g_miss_num_map(t(ddindx).salvage_value);
737 a15(indx) := rosetta_g_miss_num_map(t(ddindx).split_percent);
738 a16(indx) := rosetta_g_miss_num_map(t(ddindx).inventory_item_id);
740 a18(indx) := t(ddindx).attribute1;
741 a19(indx) := t(ddindx).attribute2;
742 a20(indx) := t(ddindx).attribute3;
743 a21(indx) := t(ddindx).attribute4;
744 a22(indx) := t(ddindx).attribute5;
745 a23(indx) := t(ddindx).attribute6;
746 a24(indx) := t(ddindx).attribute7;
747 a25(indx) := t(ddindx).attribute8;
748 a26(indx) := t(ddindx).attribute9;
749 a27(indx) := t(ddindx).attribute10;
750 a28(indx) := t(ddindx).attribute11;
751 a29(indx) := t(ddindx).attribute12;
752 a30(indx) := t(ddindx).attribute13;
753 a31(indx) := t(ddindx).attribute14;
754 a32(indx) := t(ddindx).attribute15;
755 a33(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
756 a34(indx) := t(ddindx).creation_date;
757 a35(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
758 a36(indx) := t(ddindx).last_update_date;
759 a37(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
760 a38(indx) := t(ddindx).currency_code;
761 a39(indx) := t(ddindx).currency_conversion_type;
762 a40(indx) := rosetta_g_miss_num_map(t(ddindx).currency_conversion_rate);
763 a41(indx) := t(ddindx).currency_conversion_date;
764 indx := indx+1;
765 if t.last =ddindx
766 then exit;
767 end if;
768 ddindx := t.next(ddindx);
769 end loop;
770 end if;
771 end if;
772 end rosetta_table_copy_out_p8;
773
774 procedure insert_row(p_api_version NUMBER
775 , p_init_msg_list VARCHAR2
776 , x_return_status out nocopy VARCHAR2
777 , x_msg_count out nocopy NUMBER
778 , x_msg_data out nocopy VARCHAR2
779 , p6_a0 out nocopy NUMBER
780 , p6_a1 out nocopy NUMBER
781 , p6_a2 out nocopy VARCHAR2
782 , p6_a3 out nocopy NUMBER
783 , p6_a4 out nocopy NUMBER
784 , p6_a5 out nocopy NUMBER
785 , p6_a6 out nocopy VARCHAR2
786 , p6_a7 out nocopy VARCHAR2
787 , p6_a8 out nocopy NUMBER
788 , p6_a9 out nocopy NUMBER
789 , p6_a10 out nocopy VARCHAR2
790 , p6_a11 out nocopy NUMBER
791 , p6_a12 out nocopy VARCHAR2
792 , p6_a13 out nocopy NUMBER
793 , p6_a14 out nocopy NUMBER
794 , p6_a15 out nocopy NUMBER
795 , p6_a16 out nocopy NUMBER
796 , p6_a17 out nocopy VARCHAR2
797 , p6_a18 out nocopy VARCHAR2
798 , p6_a19 out nocopy VARCHAR2
799 , p6_a20 out nocopy VARCHAR2
800 , p6_a21 out nocopy VARCHAR2
801 , p6_a22 out nocopy VARCHAR2
802 , p6_a23 out nocopy VARCHAR2
806 , p6_a27 out nocopy VARCHAR2
803 , p6_a24 out nocopy VARCHAR2
804 , p6_a25 out nocopy VARCHAR2
805 , p6_a26 out nocopy VARCHAR2
807 , p6_a28 out nocopy VARCHAR2
808 , p6_a29 out nocopy VARCHAR2
809 , p6_a30 out nocopy VARCHAR2
810 , p6_a31 out nocopy VARCHAR2
811 , p6_a32 out nocopy VARCHAR2
812 , p6_a33 out nocopy NUMBER
813 , p6_a34 out nocopy DATE
814 , p6_a35 out nocopy NUMBER
815 , p6_a36 out nocopy DATE
816 , p6_a37 out nocopy NUMBER
817 , p6_a38 out nocopy VARCHAR2
818 , p6_a39 out nocopy VARCHAR2
819 , p6_a40 out nocopy NUMBER
820 , p6_a41 out nocopy DATE
821 , p5_a0 NUMBER := 0-1962.0724
822 , p5_a1 NUMBER := 0-1962.0724
823 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
824 , p5_a3 NUMBER := 0-1962.0724
825 , p5_a4 NUMBER := 0-1962.0724
826 , p5_a5 NUMBER := 0-1962.0724
827 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
828 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
829 , p5_a8 NUMBER := 0-1962.0724
830 , p5_a9 NUMBER := 0-1962.0724
831 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
832 , p5_a11 NUMBER := 0-1962.0724
833 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
834 , p5_a13 NUMBER := 0-1962.0724
835 , p5_a14 NUMBER := 0-1962.0724
836 , p5_a15 NUMBER := 0-1962.0724
837 , p5_a16 NUMBER := 0-1962.0724
838 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
839 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
840 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
841 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
842 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
843 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
844 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
845 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
846 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
847 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
848 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
849 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
850 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
851 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
852 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
853 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
854 , p5_a33 NUMBER := 0-1962.0724
855 , p5_a34 DATE := fnd_api.g_miss_date
856 , p5_a35 NUMBER := 0-1962.0724
857 , p5_a36 DATE := fnd_api.g_miss_date
858 , p5_a37 NUMBER := 0-1962.0724
859 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
860 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
861 , p5_a40 NUMBER := 0-1962.0724
862 , p5_a41 DATE := fnd_api.g_miss_date
863 )
864
865 as
866 ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
867 ddx_asdv_rec okl_asd_pvt.asdv_rec_type;
868 ddindx binary_integer; indx binary_integer;
869 begin
870
871 -- copy data to the local IN or IN-OUT args, if any
872
873
874
875
876
877 ddp_asdv_rec.id := rosetta_g_miss_num_map(p5_a0);
878 ddp_asdv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
879 ddp_asdv_rec.sfwt_flag := p5_a2;
880 ddp_asdv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
884 ddp_asdv_rec.description := p5_a7;
881 ddp_asdv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
882 ddp_asdv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
883 ddp_asdv_rec.asset_number := p5_a6;
885 ddp_asdv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
886 ddp_asdv_rec.cost := rosetta_g_miss_num_map(p5_a9);
887 ddp_asdv_rec.tax_book := p5_a10;
888 ddp_asdv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
889 ddp_asdv_rec.deprn_method_tax := p5_a12;
890 ddp_asdv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
891 ddp_asdv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
892 ddp_asdv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
893 ddp_asdv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
894 ddp_asdv_rec.attribute_category := p5_a17;
895 ddp_asdv_rec.attribute1 := p5_a18;
896 ddp_asdv_rec.attribute2 := p5_a19;
897 ddp_asdv_rec.attribute3 := p5_a20;
898 ddp_asdv_rec.attribute4 := p5_a21;
899 ddp_asdv_rec.attribute5 := p5_a22;
900 ddp_asdv_rec.attribute6 := p5_a23;
901 ddp_asdv_rec.attribute7 := p5_a24;
902 ddp_asdv_rec.attribute8 := p5_a25;
903 ddp_asdv_rec.attribute9 := p5_a26;
904 ddp_asdv_rec.attribute10 := p5_a27;
905 ddp_asdv_rec.attribute11 := p5_a28;
906 ddp_asdv_rec.attribute12 := p5_a29;
907 ddp_asdv_rec.attribute13 := p5_a30;
908 ddp_asdv_rec.attribute14 := p5_a31;
909 ddp_asdv_rec.attribute15 := p5_a32;
910 ddp_asdv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
911 ddp_asdv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
912 ddp_asdv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
913 ddp_asdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
914 ddp_asdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
915 ddp_asdv_rec.currency_code := p5_a38;
916 ddp_asdv_rec.currency_conversion_type := p5_a39;
917 ddp_asdv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
918 ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
919
920
921 -- here's the delegated call to the old PL/SQL routine
922 okl_asd_pvt.insert_row(p_api_version,
923 p_init_msg_list,
924 x_return_status,
925 x_msg_count,
926 x_msg_data,
927 ddp_asdv_rec,
928 ddx_asdv_rec);
929
930 -- copy data back from the local variables to OUT or IN-OUT args, if any
931
932
933
934
935
936
937 p6_a0 := rosetta_g_miss_num_map(ddx_asdv_rec.id);
938 p6_a1 := rosetta_g_miss_num_map(ddx_asdv_rec.object_version_number);
939 p6_a2 := ddx_asdv_rec.sfwt_flag;
940 p6_a3 := rosetta_g_miss_num_map(ddx_asdv_rec.tal_id);
941 p6_a4 := rosetta_g_miss_num_map(ddx_asdv_rec.target_kle_id);
945 p6_a8 := rosetta_g_miss_num_map(ddx_asdv_rec.quantity);
942 p6_a5 := rosetta_g_miss_num_map(ddx_asdv_rec.line_detail_number);
943 p6_a6 := ddx_asdv_rec.asset_number;
944 p6_a7 := ddx_asdv_rec.description;
946 p6_a9 := rosetta_g_miss_num_map(ddx_asdv_rec.cost);
947 p6_a10 := ddx_asdv_rec.tax_book;
948 p6_a11 := rosetta_g_miss_num_map(ddx_asdv_rec.life_in_months_tax);
949 p6_a12 := ddx_asdv_rec.deprn_method_tax;
950 p6_a13 := rosetta_g_miss_num_map(ddx_asdv_rec.deprn_rate_tax);
951 p6_a14 := rosetta_g_miss_num_map(ddx_asdv_rec.salvage_value);
952 p6_a15 := rosetta_g_miss_num_map(ddx_asdv_rec.split_percent);
953 p6_a16 := rosetta_g_miss_num_map(ddx_asdv_rec.inventory_item_id);
954 p6_a17 := ddx_asdv_rec.attribute_category;
955 p6_a18 := ddx_asdv_rec.attribute1;
956 p6_a19 := ddx_asdv_rec.attribute2;
957 p6_a20 := ddx_asdv_rec.attribute3;
958 p6_a21 := ddx_asdv_rec.attribute4;
959 p6_a22 := ddx_asdv_rec.attribute5;
960 p6_a23 := ddx_asdv_rec.attribute6;
961 p6_a24 := ddx_asdv_rec.attribute7;
962 p6_a25 := ddx_asdv_rec.attribute8;
963 p6_a26 := ddx_asdv_rec.attribute9;
964 p6_a27 := ddx_asdv_rec.attribute10;
965 p6_a28 := ddx_asdv_rec.attribute11;
966 p6_a29 := ddx_asdv_rec.attribute12;
967 p6_a30 := ddx_asdv_rec.attribute13;
968 p6_a31 := ddx_asdv_rec.attribute14;
969 p6_a32 := ddx_asdv_rec.attribute15;
970 p6_a33 := rosetta_g_miss_num_map(ddx_asdv_rec.created_by);
971 p6_a34 := ddx_asdv_rec.creation_date;
972 p6_a35 := rosetta_g_miss_num_map(ddx_asdv_rec.last_updated_by);
973 p6_a36 := ddx_asdv_rec.last_update_date;
974 p6_a37 := rosetta_g_miss_num_map(ddx_asdv_rec.last_update_login);
975 p6_a38 := ddx_asdv_rec.currency_code;
976 p6_a39 := ddx_asdv_rec.currency_conversion_type;
977 p6_a40 := rosetta_g_miss_num_map(ddx_asdv_rec.currency_conversion_rate);
978 p6_a41 := ddx_asdv_rec.currency_conversion_date;
979 end;
980
981 procedure insert_row(p_api_version NUMBER
982 , p_init_msg_list VARCHAR2
983 , x_return_status out nocopy VARCHAR2
984 , x_msg_count out nocopy NUMBER
985 , x_msg_data out nocopy VARCHAR2
986 , p5_a0 JTF_NUMBER_TABLE
987 , p5_a1 JTF_NUMBER_TABLE
988 , p5_a2 JTF_VARCHAR2_TABLE_100
989 , p5_a3 JTF_NUMBER_TABLE
990 , p5_a4 JTF_NUMBER_TABLE
991 , p5_a5 JTF_NUMBER_TABLE
992 , p5_a6 JTF_VARCHAR2_TABLE_100
993 , p5_a7 JTF_VARCHAR2_TABLE_2000
994 , p5_a8 JTF_NUMBER_TABLE
995 , p5_a9 JTF_NUMBER_TABLE
996 , p5_a10 JTF_VARCHAR2_TABLE_100
997 , p5_a11 JTF_NUMBER_TABLE
998 , p5_a12 JTF_VARCHAR2_TABLE_100
999 , p5_a13 JTF_NUMBER_TABLE
1000 , p5_a14 JTF_NUMBER_TABLE
1001 , p5_a15 JTF_NUMBER_TABLE
1002 , p5_a16 JTF_NUMBER_TABLE
1003 , p5_a17 JTF_VARCHAR2_TABLE_100
1004 , p5_a18 JTF_VARCHAR2_TABLE_500
1005 , p5_a19 JTF_VARCHAR2_TABLE_500
1006 , p5_a20 JTF_VARCHAR2_TABLE_500
1007 , p5_a21 JTF_VARCHAR2_TABLE_500
1008 , p5_a22 JTF_VARCHAR2_TABLE_500
1009 , p5_a23 JTF_VARCHAR2_TABLE_500
1010 , p5_a24 JTF_VARCHAR2_TABLE_500
1011 , p5_a25 JTF_VARCHAR2_TABLE_500
1012 , p5_a26 JTF_VARCHAR2_TABLE_500
1013 , p5_a27 JTF_VARCHAR2_TABLE_500
1014 , p5_a28 JTF_VARCHAR2_TABLE_500
1015 , p5_a29 JTF_VARCHAR2_TABLE_500
1016 , p5_a30 JTF_VARCHAR2_TABLE_500
1017 , p5_a31 JTF_VARCHAR2_TABLE_500
1018 , p5_a32 JTF_VARCHAR2_TABLE_500
1019 , p5_a33 JTF_NUMBER_TABLE
1020 , p5_a34 JTF_DATE_TABLE
1021 , p5_a35 JTF_NUMBER_TABLE
1022 , p5_a36 JTF_DATE_TABLE
1026 , p5_a40 JTF_NUMBER_TABLE
1023 , p5_a37 JTF_NUMBER_TABLE
1024 , p5_a38 JTF_VARCHAR2_TABLE_100
1025 , p5_a39 JTF_VARCHAR2_TABLE_100
1027 , p5_a41 JTF_DATE_TABLE
1028 , p6_a0 out nocopy JTF_NUMBER_TABLE
1029 , p6_a1 out nocopy JTF_NUMBER_TABLE
1030 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1031 , p6_a3 out nocopy JTF_NUMBER_TABLE
1032 , p6_a4 out nocopy JTF_NUMBER_TABLE
1033 , p6_a5 out nocopy JTF_NUMBER_TABLE
1034 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1035 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1036 , p6_a8 out nocopy JTF_NUMBER_TABLE
1037 , p6_a9 out nocopy JTF_NUMBER_TABLE
1038 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1039 , p6_a11 out nocopy JTF_NUMBER_TABLE
1040 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1041 , p6_a13 out nocopy JTF_NUMBER_TABLE
1042 , p6_a14 out nocopy JTF_NUMBER_TABLE
1043 , p6_a15 out nocopy JTF_NUMBER_TABLE
1044 , p6_a16 out nocopy JTF_NUMBER_TABLE
1045 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1046 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1047 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1048 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1049 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1050 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1051 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1052 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1053 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1054 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1055 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1056 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1057 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1058 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1059 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1060 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1061 , p6_a33 out nocopy JTF_NUMBER_TABLE
1062 , p6_a34 out nocopy JTF_DATE_TABLE
1063 , p6_a35 out nocopy JTF_NUMBER_TABLE
1064 , p6_a36 out nocopy JTF_DATE_TABLE
1065 , p6_a37 out nocopy JTF_NUMBER_TABLE
1066 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1067 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1068 , p6_a40 out nocopy JTF_NUMBER_TABLE
1069 , p6_a41 out nocopy JTF_DATE_TABLE
1070 )
1071
1072 as
1073 ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1074 ddx_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1075 ddindx binary_integer; indx binary_integer;
1076 begin
1077
1078 -- copy data to the local IN or IN-OUT args, if any
1079
1080
1081
1082
1083
1084 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
1085 , p5_a1
1086 , p5_a2
1087 , p5_a3
1088 , p5_a4
1089 , p5_a5
1090 , p5_a6
1091 , p5_a7
1092 , p5_a8
1093 , p5_a9
1094 , p5_a10
1095 , p5_a11
1096 , p5_a12
1097 , p5_a13
1098 , p5_a14
1099 , p5_a15
1100 , p5_a16
1101 , p5_a17
1102 , p5_a18
1103 , p5_a19
1104 , p5_a20
1105 , p5_a21
1106 , p5_a22
1107 , p5_a23
1108 , p5_a24
1109 , p5_a25
1110 , p5_a26
1111 , p5_a27
1112 , p5_a28
1113 , p5_a29
1114 , p5_a30
1115 , p5_a31
1116 , p5_a32
1117 , p5_a33
1118 , p5_a34
1119 , p5_a35
1120 , p5_a36
1121 , p5_a37
1122 , p5_a38
1123 , p5_a39
1124 , p5_a40
1125 , p5_a41
1126 );
1127
1128
1129 -- here's the delegated call to the old PL/SQL routine
1130 okl_asd_pvt.insert_row(p_api_version,
1131 p_init_msg_list,
1132 x_return_status,
1133 x_msg_count,
1134 x_msg_data,
1135 ddp_asdv_tbl,
1136 ddx_asdv_tbl);
1137
1138 -- copy data back from the local variables to OUT or IN-OUT args, if any
1139
1140
1141
1142
1143
1144
1145 okl_asd_pvt_w.rosetta_table_copy_out_p8(ddx_asdv_tbl, p6_a0
1146 , p6_a1
1147 , p6_a2
1148 , p6_a3
1149 , p6_a4
1150 , p6_a5
1151 , p6_a6
1152 , p6_a7
1153 , p6_a8
1154 , p6_a9
1155 , p6_a10
1156 , p6_a11
1157 , p6_a12
1158 , p6_a13
1159 , p6_a14
1160 , p6_a15
1161 , p6_a16
1162 , p6_a17
1163 , p6_a18
1164 , p6_a19
1165 , p6_a20
1166 , p6_a21
1167 , p6_a22
1168 , p6_a23
1169 , p6_a24
1170 , p6_a25
1171 , p6_a26
1172 , p6_a27
1173 , p6_a28
1174 , p6_a29
1175 , p6_a30
1176 , p6_a31
1177 , p6_a32
1178 , p6_a33
1179 , p6_a34
1180 , p6_a35
1181 , p6_a36
1182 , p6_a37
1183 , p6_a38
1184 , p6_a39
1185 , p6_a40
1186 , p6_a41
1187 );
1188 end;
1189
1190 procedure lock_row(p_api_version NUMBER
1191 , p_init_msg_list VARCHAR2
1192 , x_return_status out nocopy VARCHAR2
1193 , x_msg_count out nocopy NUMBER
1194 , x_msg_data out nocopy VARCHAR2
1195 , p5_a0 NUMBER := 0-1962.0724
1196 , p5_a1 NUMBER := 0-1962.0724
1197 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1201 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1198 , p5_a3 NUMBER := 0-1962.0724
1199 , p5_a4 NUMBER := 0-1962.0724
1200 , p5_a5 NUMBER := 0-1962.0724
1202 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1203 , p5_a8 NUMBER := 0-1962.0724
1204 , p5_a9 NUMBER := 0-1962.0724
1205 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1206 , p5_a11 NUMBER := 0-1962.0724
1207 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1208 , p5_a13 NUMBER := 0-1962.0724
1209 , p5_a14 NUMBER := 0-1962.0724
1210 , p5_a15 NUMBER := 0-1962.0724
1211 , p5_a16 NUMBER := 0-1962.0724
1212 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1213 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1214 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1215 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1216 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1217 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1218 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1219 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1220 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1221 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1222 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1223 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1224 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1225 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1226 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1227 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1228 , p5_a33 NUMBER := 0-1962.0724
1229 , p5_a34 DATE := fnd_api.g_miss_date
1230 , p5_a35 NUMBER := 0-1962.0724
1231 , p5_a36 DATE := fnd_api.g_miss_date
1232 , p5_a37 NUMBER := 0-1962.0724
1233 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1234 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1235 , p5_a40 NUMBER := 0-1962.0724
1236 , p5_a41 DATE := fnd_api.g_miss_date
1237 )
1238
1239 as
1240 ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
1241 ddindx binary_integer; indx binary_integer;
1242 begin
1243
1244 -- copy data to the local IN or IN-OUT args, if any
1245
1246
1247
1248
1249
1250 ddp_asdv_rec.id := rosetta_g_miss_num_map(p5_a0);
1251 ddp_asdv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1252 ddp_asdv_rec.sfwt_flag := p5_a2;
1253 ddp_asdv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
1254 ddp_asdv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
1255 ddp_asdv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
1256 ddp_asdv_rec.asset_number := p5_a6;
1257 ddp_asdv_rec.description := p5_a7;
1258 ddp_asdv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
1259 ddp_asdv_rec.cost := rosetta_g_miss_num_map(p5_a9);
1260 ddp_asdv_rec.tax_book := p5_a10;
1261 ddp_asdv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
1262 ddp_asdv_rec.deprn_method_tax := p5_a12;
1263 ddp_asdv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
1264 ddp_asdv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
1265 ddp_asdv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
1266 ddp_asdv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
1267 ddp_asdv_rec.attribute_category := p5_a17;
1268 ddp_asdv_rec.attribute1 := p5_a18;
1269 ddp_asdv_rec.attribute2 := p5_a19;
1270 ddp_asdv_rec.attribute3 := p5_a20;
1271 ddp_asdv_rec.attribute4 := p5_a21;
1272 ddp_asdv_rec.attribute5 := p5_a22;
1273 ddp_asdv_rec.attribute6 := p5_a23;
1274 ddp_asdv_rec.attribute7 := p5_a24;
1275 ddp_asdv_rec.attribute8 := p5_a25;
1276 ddp_asdv_rec.attribute9 := p5_a26;
1277 ddp_asdv_rec.attribute10 := p5_a27;
1278 ddp_asdv_rec.attribute11 := p5_a28;
1279 ddp_asdv_rec.attribute12 := p5_a29;
1280 ddp_asdv_rec.attribute13 := p5_a30;
1281 ddp_asdv_rec.attribute14 := p5_a31;
1282 ddp_asdv_rec.attribute15 := p5_a32;
1283 ddp_asdv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
1284 ddp_asdv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
1285 ddp_asdv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
1286 ddp_asdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1287 ddp_asdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1288 ddp_asdv_rec.currency_code := p5_a38;
1289 ddp_asdv_rec.currency_conversion_type := p5_a39;
1290 ddp_asdv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
1291 ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1292
1293 -- here's the delegated call to the old PL/SQL routine
1294 okl_asd_pvt.lock_row(p_api_version,
1295 p_init_msg_list,
1296 x_return_status,
1297 x_msg_count,
1298 x_msg_data,
1299 ddp_asdv_rec);
1300
1301 -- copy data back from the local variables to OUT or IN-OUT args, if any
1302
1303
1304
1305
1306
1307 end;
1308
1309 procedure lock_row(p_api_version NUMBER
1310 , p_init_msg_list VARCHAR2
1311 , x_return_status out nocopy VARCHAR2
1312 , x_msg_count out nocopy NUMBER
1313 , x_msg_data out nocopy VARCHAR2
1314 , p5_a0 JTF_NUMBER_TABLE
1315 , p5_a1 JTF_NUMBER_TABLE
1316 , p5_a2 JTF_VARCHAR2_TABLE_100
1317 , p5_a3 JTF_NUMBER_TABLE
1318 , p5_a4 JTF_NUMBER_TABLE
1319 , p5_a5 JTF_NUMBER_TABLE
1320 , p5_a6 JTF_VARCHAR2_TABLE_100
1321 , p5_a7 JTF_VARCHAR2_TABLE_2000
1322 , p5_a8 JTF_NUMBER_TABLE
1323 , p5_a9 JTF_NUMBER_TABLE
1324 , p5_a10 JTF_VARCHAR2_TABLE_100
1325 , p5_a11 JTF_NUMBER_TABLE
1326 , p5_a12 JTF_VARCHAR2_TABLE_100
1327 , p5_a13 JTF_NUMBER_TABLE
1328 , p5_a14 JTF_NUMBER_TABLE
1329 , p5_a15 JTF_NUMBER_TABLE
1330 , p5_a16 JTF_NUMBER_TABLE
1331 , p5_a17 JTF_VARCHAR2_TABLE_100
1332 , p5_a18 JTF_VARCHAR2_TABLE_500
1333 , p5_a19 JTF_VARCHAR2_TABLE_500
1334 , p5_a20 JTF_VARCHAR2_TABLE_500
1335 , p5_a21 JTF_VARCHAR2_TABLE_500
1339 , p5_a25 JTF_VARCHAR2_TABLE_500
1336 , p5_a22 JTF_VARCHAR2_TABLE_500
1337 , p5_a23 JTF_VARCHAR2_TABLE_500
1338 , p5_a24 JTF_VARCHAR2_TABLE_500
1340 , p5_a26 JTF_VARCHAR2_TABLE_500
1341 , p5_a27 JTF_VARCHAR2_TABLE_500
1342 , p5_a28 JTF_VARCHAR2_TABLE_500
1343 , p5_a29 JTF_VARCHAR2_TABLE_500
1344 , p5_a30 JTF_VARCHAR2_TABLE_500
1345 , p5_a31 JTF_VARCHAR2_TABLE_500
1346 , p5_a32 JTF_VARCHAR2_TABLE_500
1347 , p5_a33 JTF_NUMBER_TABLE
1348 , p5_a34 JTF_DATE_TABLE
1349 , p5_a35 JTF_NUMBER_TABLE
1350 , p5_a36 JTF_DATE_TABLE
1351 , p5_a37 JTF_NUMBER_TABLE
1352 , p5_a38 JTF_VARCHAR2_TABLE_100
1353 , p5_a39 JTF_VARCHAR2_TABLE_100
1354 , p5_a40 JTF_NUMBER_TABLE
1355 , p5_a41 JTF_DATE_TABLE
1356 )
1357
1358 as
1359 ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1360 ddindx binary_integer; indx binary_integer;
1361 begin
1362
1363 -- copy data to the local IN or IN-OUT args, if any
1364
1365
1366
1367
1368
1369 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
1370 , p5_a1
1371 , p5_a2
1372 , p5_a3
1373 , p5_a4
1374 , p5_a5
1375 , p5_a6
1376 , p5_a7
1377 , p5_a8
1378 , p5_a9
1379 , p5_a10
1380 , p5_a11
1381 , p5_a12
1382 , p5_a13
1383 , p5_a14
1384 , p5_a15
1385 , p5_a16
1386 , p5_a17
1387 , p5_a18
1388 , p5_a19
1389 , p5_a20
1390 , p5_a21
1391 , p5_a22
1392 , p5_a23
1393 , p5_a24
1394 , p5_a25
1395 , p5_a26
1396 , p5_a27
1397 , p5_a28
1398 , p5_a29
1399 , p5_a30
1400 , p5_a31
1401 , p5_a32
1402 , p5_a33
1403 , p5_a34
1404 , p5_a35
1405 , p5_a36
1406 , p5_a37
1407 , p5_a38
1408 , p5_a39
1409 , p5_a40
1410 , p5_a41
1411 );
1412
1413 -- here's the delegated call to the old PL/SQL routine
1414 okl_asd_pvt.lock_row(p_api_version,
1415 p_init_msg_list,
1416 x_return_status,
1417 x_msg_count,
1418 x_msg_data,
1419 ddp_asdv_tbl);
1420
1421 -- copy data back from the local variables to OUT or IN-OUT args, if any
1422
1423
1424
1425
1426
1427 end;
1428
1429 procedure update_row(p_api_version NUMBER
1430 , p_init_msg_list VARCHAR2
1431 , x_return_status out nocopy VARCHAR2
1432 , x_msg_count out nocopy NUMBER
1433 , x_msg_data out nocopy VARCHAR2
1434 , p6_a0 out nocopy NUMBER
1435 , p6_a1 out nocopy NUMBER
1436 , p6_a2 out nocopy VARCHAR2
1437 , p6_a3 out nocopy NUMBER
1438 , p6_a4 out nocopy NUMBER
1439 , p6_a5 out nocopy NUMBER
1440 , p6_a6 out nocopy VARCHAR2
1441 , p6_a7 out nocopy VARCHAR2
1442 , p6_a8 out nocopy NUMBER
1443 , p6_a9 out nocopy NUMBER
1444 , p6_a10 out nocopy VARCHAR2
1445 , p6_a11 out nocopy NUMBER
1446 , p6_a12 out nocopy VARCHAR2
1447 , p6_a13 out nocopy NUMBER
1448 , p6_a14 out nocopy NUMBER
1449 , p6_a15 out nocopy NUMBER
1450 , p6_a16 out nocopy NUMBER
1451 , p6_a17 out nocopy VARCHAR2
1452 , p6_a18 out nocopy VARCHAR2
1453 , p6_a19 out nocopy VARCHAR2
1454 , p6_a20 out nocopy VARCHAR2
1455 , p6_a21 out nocopy VARCHAR2
1456 , p6_a22 out nocopy VARCHAR2
1457 , p6_a23 out nocopy VARCHAR2
1458 , p6_a24 out nocopy VARCHAR2
1459 , p6_a25 out nocopy VARCHAR2
1460 , p6_a26 out nocopy VARCHAR2
1461 , p6_a27 out nocopy VARCHAR2
1462 , p6_a28 out nocopy VARCHAR2
1463 , p6_a29 out nocopy VARCHAR2
1464 , p6_a30 out nocopy VARCHAR2
1465 , p6_a31 out nocopy VARCHAR2
1466 , p6_a32 out nocopy VARCHAR2
1467 , p6_a33 out nocopy NUMBER
1468 , p6_a34 out nocopy DATE
1469 , p6_a35 out nocopy NUMBER
1470 , p6_a36 out nocopy DATE
1471 , p6_a37 out nocopy NUMBER
1472 , p6_a38 out nocopy VARCHAR2
1473 , p6_a39 out nocopy VARCHAR2
1474 , p6_a40 out nocopy NUMBER
1475 , p6_a41 out nocopy DATE
1476 , p5_a0 NUMBER := 0-1962.0724
1477 , p5_a1 NUMBER := 0-1962.0724
1478 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1479 , p5_a3 NUMBER := 0-1962.0724
1480 , p5_a4 NUMBER := 0-1962.0724
1481 , p5_a5 NUMBER := 0-1962.0724
1482 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1483 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1484 , p5_a8 NUMBER := 0-1962.0724
1485 , p5_a9 NUMBER := 0-1962.0724
1486 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1487 , p5_a11 NUMBER := 0-1962.0724
1488 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1489 , p5_a13 NUMBER := 0-1962.0724
1490 , p5_a14 NUMBER := 0-1962.0724
1491 , p5_a15 NUMBER := 0-1962.0724
1492 , p5_a16 NUMBER := 0-1962.0724
1493 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1494 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1495 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1496 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1497 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1498 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1499 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1500 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1501 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1502 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1503 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1504 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1505 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1506 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1510 , p5_a34 DATE := fnd_api.g_miss_date
1507 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1508 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1509 , p5_a33 NUMBER := 0-1962.0724
1511 , p5_a35 NUMBER := 0-1962.0724
1512 , p5_a36 DATE := fnd_api.g_miss_date
1513 , p5_a37 NUMBER := 0-1962.0724
1514 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1515 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1516 , p5_a40 NUMBER := 0-1962.0724
1517 , p5_a41 DATE := fnd_api.g_miss_date
1518 )
1519
1520 as
1521 ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
1522 ddx_asdv_rec okl_asd_pvt.asdv_rec_type;
1523 ddindx binary_integer; indx binary_integer;
1524 begin
1525
1526 -- copy data to the local IN or IN-OUT args, if any
1527
1528
1529
1530
1531
1532 ddp_asdv_rec.id := rosetta_g_miss_num_map(p5_a0);
1533 ddp_asdv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1534 ddp_asdv_rec.sfwt_flag := p5_a2;
1535 ddp_asdv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
1536 ddp_asdv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
1537 ddp_asdv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
1538 ddp_asdv_rec.asset_number := p5_a6;
1539 ddp_asdv_rec.description := p5_a7;
1540 ddp_asdv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
1541 ddp_asdv_rec.cost := rosetta_g_miss_num_map(p5_a9);
1542 ddp_asdv_rec.tax_book := p5_a10;
1543 ddp_asdv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
1544 ddp_asdv_rec.deprn_method_tax := p5_a12;
1545 ddp_asdv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
1546 ddp_asdv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
1547 ddp_asdv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
1548 ddp_asdv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
1549 ddp_asdv_rec.attribute_category := p5_a17;
1550 ddp_asdv_rec.attribute1 := p5_a18;
1551 ddp_asdv_rec.attribute2 := p5_a19;
1552 ddp_asdv_rec.attribute3 := p5_a20;
1553 ddp_asdv_rec.attribute4 := p5_a21;
1554 ddp_asdv_rec.attribute5 := p5_a22;
1555 ddp_asdv_rec.attribute6 := p5_a23;
1556 ddp_asdv_rec.attribute7 := p5_a24;
1557 ddp_asdv_rec.attribute8 := p5_a25;
1558 ddp_asdv_rec.attribute9 := p5_a26;
1559 ddp_asdv_rec.attribute10 := p5_a27;
1560 ddp_asdv_rec.attribute11 := p5_a28;
1561 ddp_asdv_rec.attribute12 := p5_a29;
1562 ddp_asdv_rec.attribute13 := p5_a30;
1563 ddp_asdv_rec.attribute14 := p5_a31;
1564 ddp_asdv_rec.attribute15 := p5_a32;
1565 ddp_asdv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
1566 ddp_asdv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
1567 ddp_asdv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
1568 ddp_asdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1569 ddp_asdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1570 ddp_asdv_rec.currency_code := p5_a38;
1571 ddp_asdv_rec.currency_conversion_type := p5_a39;
1572 ddp_asdv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
1573 ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1574
1575
1576 -- here's the delegated call to the old PL/SQL routine
1577 okl_asd_pvt.update_row(p_api_version,
1578 p_init_msg_list,
1579 x_return_status,
1580 x_msg_count,
1581 x_msg_data,
1582 ddp_asdv_rec,
1583 ddx_asdv_rec);
1584
1585 -- copy data back from the local variables to OUT or IN-OUT args, if any
1586
1587
1588
1589
1590
1591
1592 p6_a0 := rosetta_g_miss_num_map(ddx_asdv_rec.id);
1593 p6_a1 := rosetta_g_miss_num_map(ddx_asdv_rec.object_version_number);
1594 p6_a2 := ddx_asdv_rec.sfwt_flag;
1595 p6_a3 := rosetta_g_miss_num_map(ddx_asdv_rec.tal_id);
1596 p6_a4 := rosetta_g_miss_num_map(ddx_asdv_rec.target_kle_id);
1597 p6_a5 := rosetta_g_miss_num_map(ddx_asdv_rec.line_detail_number);
1598 p6_a6 := ddx_asdv_rec.asset_number;
1599 p6_a7 := ddx_asdv_rec.description;
1600 p6_a8 := rosetta_g_miss_num_map(ddx_asdv_rec.quantity);
1601 p6_a9 := rosetta_g_miss_num_map(ddx_asdv_rec.cost);
1602 p6_a10 := ddx_asdv_rec.tax_book;
1603 p6_a11 := rosetta_g_miss_num_map(ddx_asdv_rec.life_in_months_tax);
1604 p6_a12 := ddx_asdv_rec.deprn_method_tax;
1605 p6_a13 := rosetta_g_miss_num_map(ddx_asdv_rec.deprn_rate_tax);
1606 p6_a14 := rosetta_g_miss_num_map(ddx_asdv_rec.salvage_value);
1607 p6_a15 := rosetta_g_miss_num_map(ddx_asdv_rec.split_percent);
1608 p6_a16 := rosetta_g_miss_num_map(ddx_asdv_rec.inventory_item_id);
1609 p6_a17 := ddx_asdv_rec.attribute_category;
1610 p6_a18 := ddx_asdv_rec.attribute1;
1611 p6_a19 := ddx_asdv_rec.attribute2;
1612 p6_a20 := ddx_asdv_rec.attribute3;
1613 p6_a21 := ddx_asdv_rec.attribute4;
1614 p6_a22 := ddx_asdv_rec.attribute5;
1615 p6_a23 := ddx_asdv_rec.attribute6;
1616 p6_a24 := ddx_asdv_rec.attribute7;
1617 p6_a25 := ddx_asdv_rec.attribute8;
1618 p6_a26 := ddx_asdv_rec.attribute9;
1619 p6_a27 := ddx_asdv_rec.attribute10;
1620 p6_a28 := ddx_asdv_rec.attribute11;
1621 p6_a29 := ddx_asdv_rec.attribute12;
1622 p6_a30 := ddx_asdv_rec.attribute13;
1623 p6_a31 := ddx_asdv_rec.attribute14;
1624 p6_a32 := ddx_asdv_rec.attribute15;
1625 p6_a33 := rosetta_g_miss_num_map(ddx_asdv_rec.created_by);
1626 p6_a34 := ddx_asdv_rec.creation_date;
1627 p6_a35 := rosetta_g_miss_num_map(ddx_asdv_rec.last_updated_by);
1628 p6_a36 := ddx_asdv_rec.last_update_date;
1629 p6_a37 := rosetta_g_miss_num_map(ddx_asdv_rec.last_update_login);
1630 p6_a38 := ddx_asdv_rec.currency_code;
1631 p6_a39 := ddx_asdv_rec.currency_conversion_type;
1632 p6_a40 := rosetta_g_miss_num_map(ddx_asdv_rec.currency_conversion_rate);
1633 p6_a41 := ddx_asdv_rec.currency_conversion_date;
1634 end;
1635
1639 , x_msg_count out nocopy NUMBER
1636 procedure update_row(p_api_version NUMBER
1637 , p_init_msg_list VARCHAR2
1638 , x_return_status out nocopy VARCHAR2
1640 , x_msg_data out nocopy VARCHAR2
1641 , p5_a0 JTF_NUMBER_TABLE
1642 , p5_a1 JTF_NUMBER_TABLE
1643 , p5_a2 JTF_VARCHAR2_TABLE_100
1644 , p5_a3 JTF_NUMBER_TABLE
1645 , p5_a4 JTF_NUMBER_TABLE
1646 , p5_a5 JTF_NUMBER_TABLE
1647 , p5_a6 JTF_VARCHAR2_TABLE_100
1648 , p5_a7 JTF_VARCHAR2_TABLE_2000
1649 , p5_a8 JTF_NUMBER_TABLE
1650 , p5_a9 JTF_NUMBER_TABLE
1651 , p5_a10 JTF_VARCHAR2_TABLE_100
1652 , p5_a11 JTF_NUMBER_TABLE
1653 , p5_a12 JTF_VARCHAR2_TABLE_100
1654 , p5_a13 JTF_NUMBER_TABLE
1655 , p5_a14 JTF_NUMBER_TABLE
1656 , p5_a15 JTF_NUMBER_TABLE
1657 , p5_a16 JTF_NUMBER_TABLE
1658 , p5_a17 JTF_VARCHAR2_TABLE_100
1659 , p5_a18 JTF_VARCHAR2_TABLE_500
1660 , p5_a19 JTF_VARCHAR2_TABLE_500
1661 , p5_a20 JTF_VARCHAR2_TABLE_500
1662 , p5_a21 JTF_VARCHAR2_TABLE_500
1663 , p5_a22 JTF_VARCHAR2_TABLE_500
1664 , p5_a23 JTF_VARCHAR2_TABLE_500
1665 , p5_a24 JTF_VARCHAR2_TABLE_500
1666 , p5_a25 JTF_VARCHAR2_TABLE_500
1667 , p5_a26 JTF_VARCHAR2_TABLE_500
1668 , p5_a27 JTF_VARCHAR2_TABLE_500
1669 , p5_a28 JTF_VARCHAR2_TABLE_500
1670 , p5_a29 JTF_VARCHAR2_TABLE_500
1671 , p5_a30 JTF_VARCHAR2_TABLE_500
1672 , p5_a31 JTF_VARCHAR2_TABLE_500
1673 , p5_a32 JTF_VARCHAR2_TABLE_500
1674 , p5_a33 JTF_NUMBER_TABLE
1675 , p5_a34 JTF_DATE_TABLE
1676 , p5_a35 JTF_NUMBER_TABLE
1677 , p5_a36 JTF_DATE_TABLE
1678 , p5_a37 JTF_NUMBER_TABLE
1679 , p5_a38 JTF_VARCHAR2_TABLE_100
1680 , p5_a39 JTF_VARCHAR2_TABLE_100
1681 , p5_a40 JTF_NUMBER_TABLE
1682 , p5_a41 JTF_DATE_TABLE
1683 , p6_a0 out nocopy JTF_NUMBER_TABLE
1684 , p6_a1 out nocopy JTF_NUMBER_TABLE
1685 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1686 , p6_a3 out nocopy JTF_NUMBER_TABLE
1687 , p6_a4 out nocopy JTF_NUMBER_TABLE
1688 , p6_a5 out nocopy JTF_NUMBER_TABLE
1689 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1690 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1691 , p6_a8 out nocopy JTF_NUMBER_TABLE
1692 , p6_a9 out nocopy JTF_NUMBER_TABLE
1693 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1694 , p6_a11 out nocopy JTF_NUMBER_TABLE
1695 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1696 , p6_a13 out nocopy JTF_NUMBER_TABLE
1697 , p6_a14 out nocopy JTF_NUMBER_TABLE
1698 , p6_a15 out nocopy JTF_NUMBER_TABLE
1699 , p6_a16 out nocopy JTF_NUMBER_TABLE
1700 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1701 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1702 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1703 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1704 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1705 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1706 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1707 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1708 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1709 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1710 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1711 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1712 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1713 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1714 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1715 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1716 , p6_a33 out nocopy JTF_NUMBER_TABLE
1717 , p6_a34 out nocopy JTF_DATE_TABLE
1718 , p6_a35 out nocopy JTF_NUMBER_TABLE
1719 , p6_a36 out nocopy JTF_DATE_TABLE
1720 , p6_a37 out nocopy JTF_NUMBER_TABLE
1721 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1722 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1723 , p6_a40 out nocopy JTF_NUMBER_TABLE
1724 , p6_a41 out nocopy JTF_DATE_TABLE
1725 )
1726
1727 as
1728 ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1729 ddx_asdv_tbl okl_asd_pvt.asdv_tbl_type;
1730 ddindx binary_integer; indx binary_integer;
1731 begin
1732
1733 -- copy data to the local IN or IN-OUT args, if any
1734
1735
1736
1737
1738
1739 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
1740 , p5_a1
1741 , p5_a2
1742 , p5_a3
1743 , p5_a4
1744 , p5_a5
1745 , p5_a6
1746 , p5_a7
1747 , p5_a8
1748 , p5_a9
1749 , p5_a10
1750 , p5_a11
1751 , p5_a12
1752 , p5_a13
1753 , p5_a14
1754 , p5_a15
1755 , p5_a16
1756 , p5_a17
1757 , p5_a18
1758 , p5_a19
1759 , p5_a20
1760 , p5_a21
1761 , p5_a22
1762 , p5_a23
1763 , p5_a24
1764 , p5_a25
1765 , p5_a26
1766 , p5_a27
1767 , p5_a28
1768 , p5_a29
1769 , p5_a30
1770 , p5_a31
1771 , p5_a32
1772 , p5_a33
1773 , p5_a34
1774 , p5_a35
1775 , p5_a36
1776 , p5_a37
1777 , p5_a38
1778 , p5_a39
1779 , p5_a40
1780 , p5_a41
1781 );
1782
1783
1784 -- here's the delegated call to the old PL/SQL routine
1785 okl_asd_pvt.update_row(p_api_version,
1786 p_init_msg_list,
1787 x_return_status,
1788 x_msg_count,
1789 x_msg_data,
1790 ddp_asdv_tbl,
1791 ddx_asdv_tbl);
1792
1793 -- copy data back from the local variables to OUT or IN-OUT args, if any
1794
1795
1796
1797
1798
1799
1800 okl_asd_pvt_w.rosetta_table_copy_out_p8(ddx_asdv_tbl, p6_a0
1801 , p6_a1
1802 , p6_a2
1803 , p6_a3
1804 , p6_a4
1805 , p6_a5
1806 , p6_a6
1807 , p6_a7
1808 , p6_a8
1809 , p6_a9
1810 , p6_a10
1811 , p6_a11
1812 , p6_a12
1813 , p6_a13
1814 , p6_a14
1815 , p6_a15
1816 , p6_a16
1817 , p6_a17
1818 , p6_a18
1819 , p6_a19
1820 , p6_a20
1821 , p6_a21
1822 , p6_a22
1823 , p6_a23
1824 , p6_a24
1825 , p6_a25
1826 , p6_a26
1827 , p6_a27
1828 , p6_a28
1829 , p6_a29
1830 , p6_a30
1831 , p6_a31
1832 , p6_a32
1833 , p6_a33
1834 , p6_a34
1835 , p6_a35
1836 , p6_a36
1837 , p6_a37
1838 , p6_a38
1839 , p6_a39
1840 , p6_a40
1841 , p6_a41
1842 );
1843 end;
1844
1845 procedure delete_row(p_api_version NUMBER
1846 , p_init_msg_list VARCHAR2
1847 , x_return_status out nocopy VARCHAR2
1848 , x_msg_count out nocopy NUMBER
1852 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1849 , x_msg_data out nocopy VARCHAR2
1850 , p5_a0 NUMBER := 0-1962.0724
1851 , p5_a1 NUMBER := 0-1962.0724
1853 , p5_a3 NUMBER := 0-1962.0724
1854 , p5_a4 NUMBER := 0-1962.0724
1855 , p5_a5 NUMBER := 0-1962.0724
1856 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1857 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1858 , p5_a8 NUMBER := 0-1962.0724
1859 , p5_a9 NUMBER := 0-1962.0724
1860 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1861 , p5_a11 NUMBER := 0-1962.0724
1862 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1863 , p5_a13 NUMBER := 0-1962.0724
1864 , p5_a14 NUMBER := 0-1962.0724
1865 , p5_a15 NUMBER := 0-1962.0724
1866 , p5_a16 NUMBER := 0-1962.0724
1867 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1868 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1869 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1870 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1871 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1872 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1873 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1874 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1875 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1876 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1877 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1878 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1879 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1880 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1881 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1882 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1883 , p5_a33 NUMBER := 0-1962.0724
1884 , p5_a34 DATE := fnd_api.g_miss_date
1885 , p5_a35 NUMBER := 0-1962.0724
1886 , p5_a36 DATE := fnd_api.g_miss_date
1887 , p5_a37 NUMBER := 0-1962.0724
1888 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1889 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1890 , p5_a40 NUMBER := 0-1962.0724
1891 , p5_a41 DATE := fnd_api.g_miss_date
1892 )
1893
1894 as
1895 ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
1896 ddindx binary_integer; indx binary_integer;
1897 begin
1898
1899 -- copy data to the local IN or IN-OUT args, if any
1900
1901
1902
1903
1904
1905 ddp_asdv_rec.id := rosetta_g_miss_num_map(p5_a0);
1906 ddp_asdv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1907 ddp_asdv_rec.sfwt_flag := p5_a2;
1908 ddp_asdv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
1909 ddp_asdv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
1910 ddp_asdv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
1911 ddp_asdv_rec.asset_number := p5_a6;
1912 ddp_asdv_rec.description := p5_a7;
1913 ddp_asdv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
1914 ddp_asdv_rec.cost := rosetta_g_miss_num_map(p5_a9);
1915 ddp_asdv_rec.tax_book := p5_a10;
1916 ddp_asdv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
1917 ddp_asdv_rec.deprn_method_tax := p5_a12;
1921 ddp_asdv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
1918 ddp_asdv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
1919 ddp_asdv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
1920 ddp_asdv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
1922 ddp_asdv_rec.attribute_category := p5_a17;
1923 ddp_asdv_rec.attribute1 := p5_a18;
1924 ddp_asdv_rec.attribute2 := p5_a19;
1925 ddp_asdv_rec.attribute3 := p5_a20;
1926 ddp_asdv_rec.attribute4 := p5_a21;
1927 ddp_asdv_rec.attribute5 := p5_a22;
1928 ddp_asdv_rec.attribute6 := p5_a23;
1929 ddp_asdv_rec.attribute7 := p5_a24;
1930 ddp_asdv_rec.attribute8 := p5_a25;
1931 ddp_asdv_rec.attribute9 := p5_a26;
1932 ddp_asdv_rec.attribute10 := p5_a27;
1933 ddp_asdv_rec.attribute11 := p5_a28;
1934 ddp_asdv_rec.attribute12 := p5_a29;
1935 ddp_asdv_rec.attribute13 := p5_a30;
1936 ddp_asdv_rec.attribute14 := p5_a31;
1937 ddp_asdv_rec.attribute15 := p5_a32;
1938 ddp_asdv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
1939 ddp_asdv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
1940 ddp_asdv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
1941 ddp_asdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1942 ddp_asdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1943 ddp_asdv_rec.currency_code := p5_a38;
1944 ddp_asdv_rec.currency_conversion_type := p5_a39;
1945 ddp_asdv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
1946 ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1947
1948 -- here's the delegated call to the old PL/SQL routine
1949 okl_asd_pvt.delete_row(p_api_version,
1950 p_init_msg_list,
1951 x_return_status,
1952 x_msg_count,
1953 x_msg_data,
1954 ddp_asdv_rec);
1955
1956 -- copy data back from the local variables to OUT or IN-OUT args, if any
1957
1958
1959
1960
1961
1962 end;
1963
1964 procedure delete_row(p_api_version NUMBER
1965 , p_init_msg_list VARCHAR2
1966 , x_return_status out nocopy VARCHAR2
1967 , x_msg_count out nocopy NUMBER
1968 , x_msg_data out nocopy VARCHAR2
1969 , p5_a0 JTF_NUMBER_TABLE
1970 , p5_a1 JTF_NUMBER_TABLE
1971 , p5_a2 JTF_VARCHAR2_TABLE_100
1972 , p5_a3 JTF_NUMBER_TABLE
1973 , p5_a4 JTF_NUMBER_TABLE
1974 , p5_a5 JTF_NUMBER_TABLE
1975 , p5_a6 JTF_VARCHAR2_TABLE_100
1976 , p5_a7 JTF_VARCHAR2_TABLE_2000
1977 , p5_a8 JTF_NUMBER_TABLE
1978 , p5_a9 JTF_NUMBER_TABLE
1979 , p5_a10 JTF_VARCHAR2_TABLE_100
1980 , p5_a11 JTF_NUMBER_TABLE
1981 , p5_a12 JTF_VARCHAR2_TABLE_100
1982 , p5_a13 JTF_NUMBER_TABLE
1983 , p5_a14 JTF_NUMBER_TABLE
1984 , p5_a15 JTF_NUMBER_TABLE
1985 , p5_a16 JTF_NUMBER_TABLE
1986 , p5_a17 JTF_VARCHAR2_TABLE_100
1987 , p5_a18 JTF_VARCHAR2_TABLE_500
1988 , p5_a19 JTF_VARCHAR2_TABLE_500
1989 , p5_a20 JTF_VARCHAR2_TABLE_500
1990 , p5_a21 JTF_VARCHAR2_TABLE_500
1991 , p5_a22 JTF_VARCHAR2_TABLE_500
1992 , p5_a23 JTF_VARCHAR2_TABLE_500
1993 , p5_a24 JTF_VARCHAR2_TABLE_500
1994 , p5_a25 JTF_VARCHAR2_TABLE_500
1995 , p5_a26 JTF_VARCHAR2_TABLE_500
1996 , p5_a27 JTF_VARCHAR2_TABLE_500
1997 , p5_a28 JTF_VARCHAR2_TABLE_500
1998 , p5_a29 JTF_VARCHAR2_TABLE_500
1999 , p5_a30 JTF_VARCHAR2_TABLE_500
2000 , p5_a31 JTF_VARCHAR2_TABLE_500
2001 , p5_a32 JTF_VARCHAR2_TABLE_500
2002 , p5_a33 JTF_NUMBER_TABLE
2003 , p5_a34 JTF_DATE_TABLE
2004 , p5_a35 JTF_NUMBER_TABLE
2005 , p5_a36 JTF_DATE_TABLE
2006 , p5_a37 JTF_NUMBER_TABLE
2007 , p5_a38 JTF_VARCHAR2_TABLE_100
2008 , p5_a39 JTF_VARCHAR2_TABLE_100
2009 , p5_a40 JTF_NUMBER_TABLE
2010 , p5_a41 JTF_DATE_TABLE
2011 )
2012
2013 as
2014 ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
2015 ddindx binary_integer; indx binary_integer;
2016 begin
2017
2018 -- copy data to the local IN or IN-OUT args, if any
2019
2020
2021
2022
2023
2024 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
2025 , p5_a1
2026 , p5_a2
2027 , p5_a3
2028 , p5_a4
2029 , p5_a5
2030 , p5_a6
2031 , p5_a7
2032 , p5_a8
2033 , p5_a9
2034 , p5_a10
2035 , p5_a11
2036 , p5_a12
2037 , p5_a13
2038 , p5_a14
2042 , p5_a18
2039 , p5_a15
2040 , p5_a16
2041 , p5_a17
2043 , p5_a19
2044 , p5_a20
2045 , p5_a21
2046 , p5_a22
2047 , p5_a23
2048 , p5_a24
2049 , p5_a25
2050 , p5_a26
2051 , p5_a27
2052 , p5_a28
2053 , p5_a29
2054 , p5_a30
2055 , p5_a31
2056 , p5_a32
2057 , p5_a33
2058 , p5_a34
2059 , p5_a35
2060 , p5_a36
2061 , p5_a37
2062 , p5_a38
2063 , p5_a39
2064 , p5_a40
2065 , p5_a41
2066 );
2067
2068 -- here's the delegated call to the old PL/SQL routine
2069 okl_asd_pvt.delete_row(p_api_version,
2070 p_init_msg_list,
2071 x_return_status,
2072 x_msg_count,
2073 x_msg_data,
2074 ddp_asdv_tbl);
2075
2076 -- copy data back from the local variables to OUT or IN-OUT args, if any
2077
2078
2079
2080
2081
2082 end;
2083
2084 procedure validate_row(p_api_version NUMBER
2085 , p_init_msg_list VARCHAR2
2086 , x_return_status out nocopy VARCHAR2
2087 , x_msg_count out nocopy NUMBER
2088 , x_msg_data out nocopy VARCHAR2
2089 , p5_a0 NUMBER := 0-1962.0724
2090 , p5_a1 NUMBER := 0-1962.0724
2091 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2092 , p5_a3 NUMBER := 0-1962.0724
2093 , p5_a4 NUMBER := 0-1962.0724
2094 , p5_a5 NUMBER := 0-1962.0724
2095 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2096 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2097 , p5_a8 NUMBER := 0-1962.0724
2098 , p5_a9 NUMBER := 0-1962.0724
2099 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2100 , p5_a11 NUMBER := 0-1962.0724
2101 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2102 , p5_a13 NUMBER := 0-1962.0724
2103 , p5_a14 NUMBER := 0-1962.0724
2104 , p5_a15 NUMBER := 0-1962.0724
2105 , p5_a16 NUMBER := 0-1962.0724
2106 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2107 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2108 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2109 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2110 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2111 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2112 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2113 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2114 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2115 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2116 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2117 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2118 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2119 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2120 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2121 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2122 , p5_a33 NUMBER := 0-1962.0724
2123 , p5_a34 DATE := fnd_api.g_miss_date
2124 , p5_a35 NUMBER := 0-1962.0724
2125 , p5_a36 DATE := fnd_api.g_miss_date
2126 , p5_a37 NUMBER := 0-1962.0724
2127 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2128 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2129 , p5_a40 NUMBER := 0-1962.0724
2130 , p5_a41 DATE := fnd_api.g_miss_date
2131 )
2132
2133 as
2134 ddp_asdv_rec okl_asd_pvt.asdv_rec_type;
2135 ddindx binary_integer; indx binary_integer;
2136 begin
2137
2138 -- copy data to the local IN or IN-OUT args, if any
2139
2140
2141
2145 ddp_asdv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2142
2143
2144 ddp_asdv_rec.id := rosetta_g_miss_num_map(p5_a0);
2146 ddp_asdv_rec.sfwt_flag := p5_a2;
2147 ddp_asdv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
2148 ddp_asdv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
2149 ddp_asdv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
2150 ddp_asdv_rec.asset_number := p5_a6;
2151 ddp_asdv_rec.description := p5_a7;
2152 ddp_asdv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
2153 ddp_asdv_rec.cost := rosetta_g_miss_num_map(p5_a9);
2154 ddp_asdv_rec.tax_book := p5_a10;
2155 ddp_asdv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
2156 ddp_asdv_rec.deprn_method_tax := p5_a12;
2157 ddp_asdv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
2158 ddp_asdv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
2159 ddp_asdv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
2160 ddp_asdv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
2161 ddp_asdv_rec.attribute_category := p5_a17;
2162 ddp_asdv_rec.attribute1 := p5_a18;
2163 ddp_asdv_rec.attribute2 := p5_a19;
2164 ddp_asdv_rec.attribute3 := p5_a20;
2165 ddp_asdv_rec.attribute4 := p5_a21;
2166 ddp_asdv_rec.attribute5 := p5_a22;
2167 ddp_asdv_rec.attribute6 := p5_a23;
2168 ddp_asdv_rec.attribute7 := p5_a24;
2169 ddp_asdv_rec.attribute8 := p5_a25;
2170 ddp_asdv_rec.attribute9 := p5_a26;
2171 ddp_asdv_rec.attribute10 := p5_a27;
2172 ddp_asdv_rec.attribute11 := p5_a28;
2173 ddp_asdv_rec.attribute12 := p5_a29;
2174 ddp_asdv_rec.attribute13 := p5_a30;
2175 ddp_asdv_rec.attribute14 := p5_a31;
2176 ddp_asdv_rec.attribute15 := p5_a32;
2177 ddp_asdv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
2178 ddp_asdv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
2179 ddp_asdv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
2180 ddp_asdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
2181 ddp_asdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
2182 ddp_asdv_rec.currency_code := p5_a38;
2183 ddp_asdv_rec.currency_conversion_type := p5_a39;
2184 ddp_asdv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
2185 ddp_asdv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
2186
2187 -- here's the delegated call to the old PL/SQL routine
2188 okl_asd_pvt.validate_row(p_api_version,
2189 p_init_msg_list,
2190 x_return_status,
2191 x_msg_count,
2192 x_msg_data,
2193 ddp_asdv_rec);
2194
2195 -- copy data back from the local variables to OUT or IN-OUT args, if any
2196
2197
2198
2199
2200
2201 end;
2202
2203 procedure validate_row(p_api_version NUMBER
2204 , p_init_msg_list VARCHAR2
2205 , x_return_status out nocopy VARCHAR2
2206 , x_msg_count out nocopy NUMBER
2207 , x_msg_data out nocopy VARCHAR2
2208 , p5_a0 JTF_NUMBER_TABLE
2209 , p5_a1 JTF_NUMBER_TABLE
2210 , p5_a2 JTF_VARCHAR2_TABLE_100
2211 , p5_a3 JTF_NUMBER_TABLE
2212 , p5_a4 JTF_NUMBER_TABLE
2213 , p5_a5 JTF_NUMBER_TABLE
2214 , p5_a6 JTF_VARCHAR2_TABLE_100
2215 , p5_a7 JTF_VARCHAR2_TABLE_2000
2216 , p5_a8 JTF_NUMBER_TABLE
2217 , p5_a9 JTF_NUMBER_TABLE
2218 , p5_a10 JTF_VARCHAR2_TABLE_100
2219 , p5_a11 JTF_NUMBER_TABLE
2220 , p5_a12 JTF_VARCHAR2_TABLE_100
2221 , p5_a13 JTF_NUMBER_TABLE
2222 , p5_a14 JTF_NUMBER_TABLE
2223 , p5_a15 JTF_NUMBER_TABLE
2224 , p5_a16 JTF_NUMBER_TABLE
2225 , p5_a17 JTF_VARCHAR2_TABLE_100
2226 , p5_a18 JTF_VARCHAR2_TABLE_500
2227 , p5_a19 JTF_VARCHAR2_TABLE_500
2228 , p5_a20 JTF_VARCHAR2_TABLE_500
2229 , p5_a21 JTF_VARCHAR2_TABLE_500
2230 , p5_a22 JTF_VARCHAR2_TABLE_500
2231 , p5_a23 JTF_VARCHAR2_TABLE_500
2232 , p5_a24 JTF_VARCHAR2_TABLE_500
2233 , p5_a25 JTF_VARCHAR2_TABLE_500
2234 , p5_a26 JTF_VARCHAR2_TABLE_500
2235 , p5_a27 JTF_VARCHAR2_TABLE_500
2236 , p5_a28 JTF_VARCHAR2_TABLE_500
2237 , p5_a29 JTF_VARCHAR2_TABLE_500
2238 , p5_a30 JTF_VARCHAR2_TABLE_500
2239 , p5_a31 JTF_VARCHAR2_TABLE_500
2240 , p5_a32 JTF_VARCHAR2_TABLE_500
2241 , p5_a33 JTF_NUMBER_TABLE
2242 , p5_a34 JTF_DATE_TABLE
2243 , p5_a35 JTF_NUMBER_TABLE
2244 , p5_a36 JTF_DATE_TABLE
2245 , p5_a37 JTF_NUMBER_TABLE
2246 , p5_a38 JTF_VARCHAR2_TABLE_100
2247 , p5_a39 JTF_VARCHAR2_TABLE_100
2248 , p5_a40 JTF_NUMBER_TABLE
2249 , p5_a41 JTF_DATE_TABLE
2250 )
2251
2252 as
2253 ddp_asdv_tbl okl_asd_pvt.asdv_tbl_type;
2254 ddindx binary_integer; indx binary_integer;
2255 begin
2256
2257 -- copy data to the local IN or IN-OUT args, if any
2258
2259
2260
2261
2262
2263 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_asdv_tbl, p5_a0
2264 , p5_a1
2265 , p5_a2
2266 , p5_a3
2267 , p5_a4
2268 , p5_a5
2269 , p5_a6
2270 , p5_a7
2271 , p5_a8
2272 , p5_a9
2273 , p5_a10
2274 , p5_a11
2275 , p5_a12
2276 , p5_a13
2277 , p5_a14
2278 , p5_a15
2279 , p5_a16
2280 , p5_a17
2281 , p5_a18
2282 , p5_a19
2283 , p5_a20
2284 , p5_a21
2285 , p5_a22
2286 , p5_a23
2287 , p5_a24
2288 , p5_a25
2289 , p5_a26
2290 , p5_a27
2291 , p5_a28
2292 , p5_a29
2293 , p5_a30
2294 , p5_a31
2295 , p5_a32
2296 , p5_a33
2297 , p5_a34
2298 , p5_a35
2299 , p5_a36
2300 , p5_a37
2301 , p5_a38
2302 , p5_a39
2303 , p5_a40
2304 , p5_a41
2305 );
2306
2307 -- here's the delegated call to the old PL/SQL routine
2308 okl_asd_pvt.validate_row(p_api_version,
2309 p_init_msg_list,
2310 x_return_status,
2311 x_msg_count,
2312 x_msg_data,
2313 ddp_asdv_tbl);
2314
2315 -- copy data back from the local variables to OUT or IN-OUT args, if any
2316
2317
2318
2319
2320
2321 end;
2322
2323 end okl_asd_pvt_w;