[Home] [Help]
PACKAGE BODY: APPS.OKL_TXD_ASSETS_PUB_W
Source
1 package body okl_txd_assets_pub_w as
2 /* $Header: OKLUASDB.pls 115.6 2002/12/20 19:24:01 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 create_txd_asset_def(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 , p6_a0 out nocopy NUMBER
28 , p6_a1 out nocopy NUMBER
29 , p6_a2 out nocopy VARCHAR2
30 , p6_a3 out nocopy NUMBER
31 , p6_a4 out nocopy NUMBER
32 , p6_a5 out nocopy NUMBER
33 , p6_a6 out nocopy VARCHAR2
34 , p6_a7 out nocopy VARCHAR2
35 , p6_a8 out nocopy NUMBER
36 , p6_a9 out nocopy NUMBER
37 , p6_a10 out nocopy VARCHAR2
38 , p6_a11 out nocopy NUMBER
39 , p6_a12 out nocopy VARCHAR2
40 , p6_a13 out nocopy NUMBER
41 , p6_a14 out nocopy NUMBER
42 , p6_a15 out nocopy NUMBER
43 , p6_a16 out nocopy NUMBER
44 , p6_a17 out nocopy VARCHAR2
45 , p6_a18 out nocopy VARCHAR2
46 , p6_a19 out nocopy VARCHAR2
47 , p6_a20 out nocopy VARCHAR2
48 , p6_a21 out nocopy VARCHAR2
49 , p6_a22 out nocopy VARCHAR2
50 , p6_a23 out nocopy VARCHAR2
51 , p6_a24 out nocopy VARCHAR2
52 , p6_a25 out nocopy VARCHAR2
53 , p6_a26 out nocopy VARCHAR2
54 , p6_a27 out nocopy VARCHAR2
55 , p6_a28 out nocopy VARCHAR2
56 , p6_a29 out nocopy VARCHAR2
57 , p6_a30 out nocopy VARCHAR2
58 , p6_a31 out nocopy VARCHAR2
59 , p6_a32 out nocopy VARCHAR2
60 , p6_a33 out nocopy NUMBER
61 , p6_a34 out nocopy DATE
62 , p6_a35 out nocopy NUMBER
63 , p6_a36 out nocopy DATE
64 , p6_a37 out nocopy NUMBER
65 , p6_a38 out nocopy VARCHAR2
66 , p6_a39 out nocopy VARCHAR2
67 , p6_a40 out nocopy NUMBER
68 , p6_a41 out nocopy DATE
69 , p5_a0 NUMBER := 0-1962.0724
70 , p5_a1 NUMBER := 0-1962.0724
71 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
72 , p5_a3 NUMBER := 0-1962.0724
73 , p5_a4 NUMBER := 0-1962.0724
74 , p5_a5 NUMBER := 0-1962.0724
75 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
76 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
77 , p5_a8 NUMBER := 0-1962.0724
78 , p5_a9 NUMBER := 0-1962.0724
79 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
80 , p5_a11 NUMBER := 0-1962.0724
81 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
82 , p5_a13 NUMBER := 0-1962.0724
83 , p5_a14 NUMBER := 0-1962.0724
84 , p5_a15 NUMBER := 0-1962.0724
85 , p5_a16 NUMBER := 0-1962.0724
86 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
87 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
88 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
89 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
90 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
91 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
92 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
93 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
94 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
95 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
96 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
97 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
98 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
99 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
100 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
101 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
102 , p5_a33 NUMBER := 0-1962.0724
103 , p5_a34 DATE := fnd_api.g_miss_date
104 , p5_a35 NUMBER := 0-1962.0724
105 , p5_a36 DATE := fnd_api.g_miss_date
106 , p5_a37 NUMBER := 0-1962.0724
107 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
108 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
109 , p5_a40 NUMBER := 0-1962.0724
110 , p5_a41 DATE := fnd_api.g_miss_date
111 )
112
113 as
114 ddp_adpv_rec okl_txd_assets_pub.adpv_rec_type;
115 ddx_adpv_rec okl_txd_assets_pub.adpv_rec_type;
116 ddindx binary_integer; indx binary_integer;
117 begin
118
119 -- copy data to the local IN or IN-OUT args, if any
120
121
122
123
124
125 ddp_adpv_rec.id := rosetta_g_miss_num_map(p5_a0);
126 ddp_adpv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
127 ddp_adpv_rec.sfwt_flag := p5_a2;
128 ddp_adpv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
129 ddp_adpv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
130 ddp_adpv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
131 ddp_adpv_rec.asset_number := p5_a6;
132 ddp_adpv_rec.description := p5_a7;
133 ddp_adpv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
134 ddp_adpv_rec.cost := rosetta_g_miss_num_map(p5_a9);
135 ddp_adpv_rec.tax_book := p5_a10;
136 ddp_adpv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
137 ddp_adpv_rec.deprn_method_tax := p5_a12;
138 ddp_adpv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
139 ddp_adpv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
140 ddp_adpv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
141 ddp_adpv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
142 ddp_adpv_rec.attribute_category := p5_a17;
143 ddp_adpv_rec.attribute1 := p5_a18;
144 ddp_adpv_rec.attribute2 := p5_a19;
145 ddp_adpv_rec.attribute3 := p5_a20;
146 ddp_adpv_rec.attribute4 := p5_a21;
147 ddp_adpv_rec.attribute5 := p5_a22;
148 ddp_adpv_rec.attribute6 := p5_a23;
149 ddp_adpv_rec.attribute7 := p5_a24;
150 ddp_adpv_rec.attribute8 := p5_a25;
151 ddp_adpv_rec.attribute9 := p5_a26;
152 ddp_adpv_rec.attribute10 := p5_a27;
153 ddp_adpv_rec.attribute11 := p5_a28;
154 ddp_adpv_rec.attribute12 := p5_a29;
155 ddp_adpv_rec.attribute13 := p5_a30;
156 ddp_adpv_rec.attribute14 := p5_a31;
157 ddp_adpv_rec.attribute15 := p5_a32;
158 ddp_adpv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
159 ddp_adpv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
160 ddp_adpv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
161 ddp_adpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
162 ddp_adpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
163 ddp_adpv_rec.currency_code := p5_a38;
164 ddp_adpv_rec.currency_conversion_type := p5_a39;
165 ddp_adpv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
166 ddp_adpv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
167
168
169 -- here's the delegated call to the old PL/SQL routine
170 okl_txd_assets_pub.create_txd_asset_def(p_api_version,
171 p_init_msg_list,
172 x_return_status,
173 x_msg_count,
174 x_msg_data,
175 ddp_adpv_rec,
176 ddx_adpv_rec);
177
178 -- copy data back from the local variables to OUT or IN-OUT args, if any
179
180
181
182
183
184
185 p6_a0 := rosetta_g_miss_num_map(ddx_adpv_rec.id);
186 p6_a1 := rosetta_g_miss_num_map(ddx_adpv_rec.object_version_number);
187 p6_a2 := ddx_adpv_rec.sfwt_flag;
188 p6_a3 := rosetta_g_miss_num_map(ddx_adpv_rec.tal_id);
189 p6_a4 := rosetta_g_miss_num_map(ddx_adpv_rec.target_kle_id);
190 p6_a5 := rosetta_g_miss_num_map(ddx_adpv_rec.line_detail_number);
191 p6_a6 := ddx_adpv_rec.asset_number;
192 p6_a7 := ddx_adpv_rec.description;
193 p6_a8 := rosetta_g_miss_num_map(ddx_adpv_rec.quantity);
194 p6_a9 := rosetta_g_miss_num_map(ddx_adpv_rec.cost);
195 p6_a10 := ddx_adpv_rec.tax_book;
196 p6_a11 := rosetta_g_miss_num_map(ddx_adpv_rec.life_in_months_tax);
197 p6_a12 := ddx_adpv_rec.deprn_method_tax;
198 p6_a13 := rosetta_g_miss_num_map(ddx_adpv_rec.deprn_rate_tax);
199 p6_a14 := rosetta_g_miss_num_map(ddx_adpv_rec.salvage_value);
200 p6_a15 := rosetta_g_miss_num_map(ddx_adpv_rec.split_percent);
201 p6_a16 := rosetta_g_miss_num_map(ddx_adpv_rec.inventory_item_id);
202 p6_a17 := ddx_adpv_rec.attribute_category;
203 p6_a18 := ddx_adpv_rec.attribute1;
204 p6_a19 := ddx_adpv_rec.attribute2;
205 p6_a20 := ddx_adpv_rec.attribute3;
206 p6_a21 := ddx_adpv_rec.attribute4;
207 p6_a22 := ddx_adpv_rec.attribute5;
208 p6_a23 := ddx_adpv_rec.attribute6;
209 p6_a24 := ddx_adpv_rec.attribute7;
210 p6_a25 := ddx_adpv_rec.attribute8;
211 p6_a26 := ddx_adpv_rec.attribute9;
212 p6_a27 := ddx_adpv_rec.attribute10;
213 p6_a28 := ddx_adpv_rec.attribute11;
214 p6_a29 := ddx_adpv_rec.attribute12;
215 p6_a30 := ddx_adpv_rec.attribute13;
216 p6_a31 := ddx_adpv_rec.attribute14;
217 p6_a32 := ddx_adpv_rec.attribute15;
218 p6_a33 := rosetta_g_miss_num_map(ddx_adpv_rec.created_by);
219 p6_a34 := ddx_adpv_rec.creation_date;
220 p6_a35 := rosetta_g_miss_num_map(ddx_adpv_rec.last_updated_by);
221 p6_a36 := ddx_adpv_rec.last_update_date;
222 p6_a37 := rosetta_g_miss_num_map(ddx_adpv_rec.last_update_login);
223 p6_a38 := ddx_adpv_rec.currency_code;
224 p6_a39 := ddx_adpv_rec.currency_conversion_type;
225 p6_a40 := rosetta_g_miss_num_map(ddx_adpv_rec.currency_conversion_rate);
226 p6_a41 := ddx_adpv_rec.currency_conversion_date;
227 end;
228
229 procedure create_txd_asset_def(p_api_version NUMBER
230 , p_init_msg_list VARCHAR2
231 , x_return_status out nocopy VARCHAR2
232 , x_msg_count out nocopy NUMBER
233 , x_msg_data out nocopy VARCHAR2
234 , p5_a0 JTF_NUMBER_TABLE
235 , p5_a1 JTF_NUMBER_TABLE
236 , p5_a2 JTF_VARCHAR2_TABLE_100
237 , p5_a3 JTF_NUMBER_TABLE
238 , p5_a4 JTF_NUMBER_TABLE
239 , p5_a5 JTF_NUMBER_TABLE
240 , p5_a6 JTF_VARCHAR2_TABLE_100
241 , p5_a7 JTF_VARCHAR2_TABLE_2000
242 , p5_a8 JTF_NUMBER_TABLE
243 , p5_a9 JTF_NUMBER_TABLE
244 , p5_a10 JTF_VARCHAR2_TABLE_100
245 , p5_a11 JTF_NUMBER_TABLE
246 , p5_a12 JTF_VARCHAR2_TABLE_100
247 , p5_a13 JTF_NUMBER_TABLE
248 , p5_a14 JTF_NUMBER_TABLE
249 , p5_a15 JTF_NUMBER_TABLE
250 , p5_a16 JTF_NUMBER_TABLE
251 , p5_a17 JTF_VARCHAR2_TABLE_100
252 , p5_a18 JTF_VARCHAR2_TABLE_500
253 , p5_a19 JTF_VARCHAR2_TABLE_500
254 , p5_a20 JTF_VARCHAR2_TABLE_500
255 , p5_a21 JTF_VARCHAR2_TABLE_500
256 , p5_a22 JTF_VARCHAR2_TABLE_500
257 , p5_a23 JTF_VARCHAR2_TABLE_500
258 , p5_a24 JTF_VARCHAR2_TABLE_500
259 , p5_a25 JTF_VARCHAR2_TABLE_500
260 , p5_a26 JTF_VARCHAR2_TABLE_500
261 , p5_a27 JTF_VARCHAR2_TABLE_500
262 , p5_a28 JTF_VARCHAR2_TABLE_500
263 , p5_a29 JTF_VARCHAR2_TABLE_500
264 , p5_a30 JTF_VARCHAR2_TABLE_500
265 , p5_a31 JTF_VARCHAR2_TABLE_500
266 , p5_a32 JTF_VARCHAR2_TABLE_500
267 , p5_a33 JTF_NUMBER_TABLE
268 , p5_a34 JTF_DATE_TABLE
269 , p5_a35 JTF_NUMBER_TABLE
270 , p5_a36 JTF_DATE_TABLE
271 , p5_a37 JTF_NUMBER_TABLE
272 , p5_a38 JTF_VARCHAR2_TABLE_100
273 , p5_a39 JTF_VARCHAR2_TABLE_100
274 , p5_a40 JTF_NUMBER_TABLE
275 , p5_a41 JTF_DATE_TABLE
276 , p6_a0 out nocopy JTF_NUMBER_TABLE
277 , p6_a1 out nocopy JTF_NUMBER_TABLE
278 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
279 , p6_a3 out nocopy JTF_NUMBER_TABLE
280 , p6_a4 out nocopy JTF_NUMBER_TABLE
281 , p6_a5 out nocopy JTF_NUMBER_TABLE
282 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
283 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
284 , p6_a8 out nocopy JTF_NUMBER_TABLE
285 , p6_a9 out nocopy JTF_NUMBER_TABLE
286 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
287 , p6_a11 out nocopy JTF_NUMBER_TABLE
288 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
289 , p6_a13 out nocopy JTF_NUMBER_TABLE
290 , p6_a14 out nocopy JTF_NUMBER_TABLE
291 , p6_a15 out nocopy JTF_NUMBER_TABLE
292 , p6_a16 out nocopy JTF_NUMBER_TABLE
293 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
294 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
295 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
296 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
297 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
298 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
299 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
300 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
301 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
302 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
303 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
304 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
305 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
306 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
307 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
308 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
309 , p6_a33 out nocopy JTF_NUMBER_TABLE
310 , p6_a34 out nocopy JTF_DATE_TABLE
311 , p6_a35 out nocopy JTF_NUMBER_TABLE
312 , p6_a36 out nocopy JTF_DATE_TABLE
313 , p6_a37 out nocopy JTF_NUMBER_TABLE
314 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
315 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
316 , p6_a40 out nocopy JTF_NUMBER_TABLE
317 , p6_a41 out nocopy JTF_DATE_TABLE
318 )
319
320 as
321 ddp_adpv_tbl okl_txd_assets_pub.adpv_tbl_type;
322 ddx_adpv_tbl okl_txd_assets_pub.adpv_tbl_type;
323 ddindx binary_integer; indx binary_integer;
324 begin
325
326 -- copy data to the local IN or IN-OUT args, if any
327
328
329
330
331
332 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_adpv_tbl, p5_a0
333 , p5_a1
334 , p5_a2
335 , p5_a3
336 , p5_a4
337 , p5_a5
338 , p5_a6
339 , p5_a7
340 , p5_a8
341 , p5_a9
342 , p5_a10
343 , p5_a11
344 , p5_a12
345 , p5_a13
346 , p5_a14
347 , p5_a15
348 , p5_a16
349 , p5_a17
350 , p5_a18
351 , p5_a19
352 , p5_a20
353 , p5_a21
354 , p5_a22
355 , p5_a23
356 , p5_a24
357 , p5_a25
358 , p5_a26
359 , p5_a27
360 , p5_a28
361 , p5_a29
362 , p5_a30
363 , p5_a31
364 , p5_a32
365 , p5_a33
366 , p5_a34
367 , p5_a35
368 , p5_a36
369 , p5_a37
370 , p5_a38
371 , p5_a39
372 , p5_a40
373 , p5_a41
374 );
375
376
377 -- here's the delegated call to the old PL/SQL routine
378 okl_txd_assets_pub.create_txd_asset_def(p_api_version,
379 p_init_msg_list,
380 x_return_status,
381 x_msg_count,
382 x_msg_data,
383 ddp_adpv_tbl,
384 ddx_adpv_tbl);
385
386 -- copy data back from the local variables to OUT or IN-OUT args, if any
387
388
389
390
391
392
393 okl_asd_pvt_w.rosetta_table_copy_out_p8(ddx_adpv_tbl, p6_a0
394 , p6_a1
395 , p6_a2
396 , p6_a3
397 , p6_a4
398 , p6_a5
399 , p6_a6
400 , p6_a7
401 , p6_a8
402 , p6_a9
403 , p6_a10
404 , p6_a11
405 , p6_a12
406 , p6_a13
407 , p6_a14
408 , p6_a15
409 , p6_a16
410 , p6_a17
411 , p6_a18
412 , p6_a19
413 , p6_a20
414 , p6_a21
415 , p6_a22
416 , p6_a23
417 , p6_a24
418 , p6_a25
419 , p6_a26
420 , p6_a27
421 , p6_a28
422 , p6_a29
423 , p6_a30
424 , p6_a31
425 , p6_a32
426 , p6_a33
427 , p6_a34
428 , p6_a35
429 , p6_a36
430 , p6_a37
431 , p6_a38
432 , p6_a39
433 , p6_a40
434 , p6_a41
435 );
436 end;
437
438 procedure update_txd_asset_def(p_api_version NUMBER
439 , p_init_msg_list VARCHAR2
440 , x_return_status out nocopy VARCHAR2
441 , x_msg_count out nocopy NUMBER
442 , x_msg_data out nocopy VARCHAR2
443 , p6_a0 out nocopy NUMBER
444 , p6_a1 out nocopy NUMBER
445 , p6_a2 out nocopy VARCHAR2
446 , p6_a3 out nocopy NUMBER
447 , p6_a4 out nocopy NUMBER
448 , p6_a5 out nocopy NUMBER
449 , p6_a6 out nocopy VARCHAR2
450 , p6_a7 out nocopy VARCHAR2
451 , p6_a8 out nocopy NUMBER
452 , p6_a9 out nocopy NUMBER
453 , p6_a10 out nocopy VARCHAR2
454 , p6_a11 out nocopy NUMBER
455 , p6_a12 out nocopy VARCHAR2
456 , p6_a13 out nocopy NUMBER
457 , p6_a14 out nocopy NUMBER
458 , p6_a15 out nocopy NUMBER
459 , p6_a16 out nocopy NUMBER
460 , p6_a17 out nocopy VARCHAR2
461 , p6_a18 out nocopy VARCHAR2
462 , p6_a19 out nocopy VARCHAR2
463 , p6_a20 out nocopy VARCHAR2
464 , p6_a21 out nocopy VARCHAR2
465 , p6_a22 out nocopy VARCHAR2
466 , p6_a23 out nocopy VARCHAR2
467 , p6_a24 out nocopy VARCHAR2
468 , p6_a25 out nocopy VARCHAR2
469 , p6_a26 out nocopy VARCHAR2
470 , p6_a27 out nocopy VARCHAR2
471 , p6_a28 out nocopy VARCHAR2
472 , p6_a29 out nocopy VARCHAR2
473 , p6_a30 out nocopy VARCHAR2
474 , p6_a31 out nocopy VARCHAR2
475 , p6_a32 out nocopy VARCHAR2
476 , p6_a33 out nocopy NUMBER
477 , p6_a34 out nocopy DATE
478 , p6_a35 out nocopy NUMBER
479 , p6_a36 out nocopy DATE
480 , p6_a37 out nocopy NUMBER
481 , p6_a38 out nocopy VARCHAR2
482 , p6_a39 out nocopy VARCHAR2
483 , p6_a40 out nocopy NUMBER
484 , p6_a41 out nocopy DATE
485 , p5_a0 NUMBER := 0-1962.0724
486 , p5_a1 NUMBER := 0-1962.0724
487 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
488 , p5_a3 NUMBER := 0-1962.0724
489 , p5_a4 NUMBER := 0-1962.0724
490 , p5_a5 NUMBER := 0-1962.0724
491 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
492 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
493 , p5_a8 NUMBER := 0-1962.0724
494 , p5_a9 NUMBER := 0-1962.0724
495 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
496 , p5_a11 NUMBER := 0-1962.0724
497 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
498 , p5_a13 NUMBER := 0-1962.0724
499 , p5_a14 NUMBER := 0-1962.0724
500 , p5_a15 NUMBER := 0-1962.0724
501 , p5_a16 NUMBER := 0-1962.0724
502 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
503 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
504 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
505 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
506 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
507 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
508 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
509 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
510 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
511 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
512 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
513 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
514 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
515 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
516 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
517 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
518 , p5_a33 NUMBER := 0-1962.0724
519 , p5_a34 DATE := fnd_api.g_miss_date
520 , p5_a35 NUMBER := 0-1962.0724
521 , p5_a36 DATE := fnd_api.g_miss_date
522 , p5_a37 NUMBER := 0-1962.0724
523 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
524 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
525 , p5_a40 NUMBER := 0-1962.0724
526 , p5_a41 DATE := fnd_api.g_miss_date
527 )
528
529 as
530 ddp_adpv_rec okl_txd_assets_pub.adpv_rec_type;
531 ddx_adpv_rec okl_txd_assets_pub.adpv_rec_type;
532 ddindx binary_integer; indx binary_integer;
533 begin
534
535 -- copy data to the local IN or IN-OUT args, if any
536
537
538
539
540
541 ddp_adpv_rec.id := rosetta_g_miss_num_map(p5_a0);
542 ddp_adpv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
543 ddp_adpv_rec.sfwt_flag := p5_a2;
544 ddp_adpv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
545 ddp_adpv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
546 ddp_adpv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
547 ddp_adpv_rec.asset_number := p5_a6;
548 ddp_adpv_rec.description := p5_a7;
549 ddp_adpv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
550 ddp_adpv_rec.cost := rosetta_g_miss_num_map(p5_a9);
551 ddp_adpv_rec.tax_book := p5_a10;
552 ddp_adpv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
553 ddp_adpv_rec.deprn_method_tax := p5_a12;
554 ddp_adpv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
555 ddp_adpv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
556 ddp_adpv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
557 ddp_adpv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
558 ddp_adpv_rec.attribute_category := p5_a17;
559 ddp_adpv_rec.attribute1 := p5_a18;
560 ddp_adpv_rec.attribute2 := p5_a19;
561 ddp_adpv_rec.attribute3 := p5_a20;
562 ddp_adpv_rec.attribute4 := p5_a21;
563 ddp_adpv_rec.attribute5 := p5_a22;
564 ddp_adpv_rec.attribute6 := p5_a23;
565 ddp_adpv_rec.attribute7 := p5_a24;
566 ddp_adpv_rec.attribute8 := p5_a25;
567 ddp_adpv_rec.attribute9 := p5_a26;
568 ddp_adpv_rec.attribute10 := p5_a27;
569 ddp_adpv_rec.attribute11 := p5_a28;
570 ddp_adpv_rec.attribute12 := p5_a29;
571 ddp_adpv_rec.attribute13 := p5_a30;
572 ddp_adpv_rec.attribute14 := p5_a31;
573 ddp_adpv_rec.attribute15 := p5_a32;
574 ddp_adpv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
575 ddp_adpv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
576 ddp_adpv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
577 ddp_adpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
578 ddp_adpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
579 ddp_adpv_rec.currency_code := p5_a38;
580 ddp_adpv_rec.currency_conversion_type := p5_a39;
581 ddp_adpv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
582 ddp_adpv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
583
584
585 -- here's the delegated call to the old PL/SQL routine
586 okl_txd_assets_pub.update_txd_asset_def(p_api_version,
587 p_init_msg_list,
588 x_return_status,
589 x_msg_count,
590 x_msg_data,
591 ddp_adpv_rec,
592 ddx_adpv_rec);
593
594 -- copy data back from the local variables to OUT or IN-OUT args, if any
595
596
597
598
599
600
601 p6_a0 := rosetta_g_miss_num_map(ddx_adpv_rec.id);
602 p6_a1 := rosetta_g_miss_num_map(ddx_adpv_rec.object_version_number);
603 p6_a2 := ddx_adpv_rec.sfwt_flag;
604 p6_a3 := rosetta_g_miss_num_map(ddx_adpv_rec.tal_id);
605 p6_a4 := rosetta_g_miss_num_map(ddx_adpv_rec.target_kle_id);
606 p6_a5 := rosetta_g_miss_num_map(ddx_adpv_rec.line_detail_number);
607 p6_a6 := ddx_adpv_rec.asset_number;
608 p6_a7 := ddx_adpv_rec.description;
609 p6_a8 := rosetta_g_miss_num_map(ddx_adpv_rec.quantity);
610 p6_a9 := rosetta_g_miss_num_map(ddx_adpv_rec.cost);
611 p6_a10 := ddx_adpv_rec.tax_book;
612 p6_a11 := rosetta_g_miss_num_map(ddx_adpv_rec.life_in_months_tax);
613 p6_a12 := ddx_adpv_rec.deprn_method_tax;
614 p6_a13 := rosetta_g_miss_num_map(ddx_adpv_rec.deprn_rate_tax);
615 p6_a14 := rosetta_g_miss_num_map(ddx_adpv_rec.salvage_value);
616 p6_a15 := rosetta_g_miss_num_map(ddx_adpv_rec.split_percent);
617 p6_a16 := rosetta_g_miss_num_map(ddx_adpv_rec.inventory_item_id);
618 p6_a17 := ddx_adpv_rec.attribute_category;
619 p6_a18 := ddx_adpv_rec.attribute1;
620 p6_a19 := ddx_adpv_rec.attribute2;
621 p6_a20 := ddx_adpv_rec.attribute3;
622 p6_a21 := ddx_adpv_rec.attribute4;
623 p6_a22 := ddx_adpv_rec.attribute5;
624 p6_a23 := ddx_adpv_rec.attribute6;
625 p6_a24 := ddx_adpv_rec.attribute7;
626 p6_a25 := ddx_adpv_rec.attribute8;
627 p6_a26 := ddx_adpv_rec.attribute9;
628 p6_a27 := ddx_adpv_rec.attribute10;
629 p6_a28 := ddx_adpv_rec.attribute11;
630 p6_a29 := ddx_adpv_rec.attribute12;
631 p6_a30 := ddx_adpv_rec.attribute13;
632 p6_a31 := ddx_adpv_rec.attribute14;
633 p6_a32 := ddx_adpv_rec.attribute15;
634 p6_a33 := rosetta_g_miss_num_map(ddx_adpv_rec.created_by);
635 p6_a34 := ddx_adpv_rec.creation_date;
636 p6_a35 := rosetta_g_miss_num_map(ddx_adpv_rec.last_updated_by);
637 p6_a36 := ddx_adpv_rec.last_update_date;
638 p6_a37 := rosetta_g_miss_num_map(ddx_adpv_rec.last_update_login);
639 p6_a38 := ddx_adpv_rec.currency_code;
640 p6_a39 := ddx_adpv_rec.currency_conversion_type;
641 p6_a40 := rosetta_g_miss_num_map(ddx_adpv_rec.currency_conversion_rate);
642 p6_a41 := ddx_adpv_rec.currency_conversion_date;
643 end;
644
645 procedure update_txd_asset_def(p_api_version NUMBER
646 , p_init_msg_list VARCHAR2
647 , x_return_status out nocopy VARCHAR2
648 , x_msg_count out nocopy NUMBER
649 , x_msg_data out nocopy VARCHAR2
650 , p5_a0 JTF_NUMBER_TABLE
651 , p5_a1 JTF_NUMBER_TABLE
652 , p5_a2 JTF_VARCHAR2_TABLE_100
653 , p5_a3 JTF_NUMBER_TABLE
654 , p5_a4 JTF_NUMBER_TABLE
655 , p5_a5 JTF_NUMBER_TABLE
656 , p5_a6 JTF_VARCHAR2_TABLE_100
657 , p5_a7 JTF_VARCHAR2_TABLE_2000
658 , p5_a8 JTF_NUMBER_TABLE
659 , p5_a9 JTF_NUMBER_TABLE
660 , p5_a10 JTF_VARCHAR2_TABLE_100
661 , p5_a11 JTF_NUMBER_TABLE
662 , p5_a12 JTF_VARCHAR2_TABLE_100
663 , p5_a13 JTF_NUMBER_TABLE
664 , p5_a14 JTF_NUMBER_TABLE
665 , p5_a15 JTF_NUMBER_TABLE
666 , p5_a16 JTF_NUMBER_TABLE
667 , p5_a17 JTF_VARCHAR2_TABLE_100
668 , p5_a18 JTF_VARCHAR2_TABLE_500
669 , p5_a19 JTF_VARCHAR2_TABLE_500
670 , p5_a20 JTF_VARCHAR2_TABLE_500
671 , p5_a21 JTF_VARCHAR2_TABLE_500
672 , p5_a22 JTF_VARCHAR2_TABLE_500
673 , p5_a23 JTF_VARCHAR2_TABLE_500
674 , p5_a24 JTF_VARCHAR2_TABLE_500
675 , p5_a25 JTF_VARCHAR2_TABLE_500
676 , p5_a26 JTF_VARCHAR2_TABLE_500
677 , p5_a27 JTF_VARCHAR2_TABLE_500
678 , p5_a28 JTF_VARCHAR2_TABLE_500
679 , p5_a29 JTF_VARCHAR2_TABLE_500
680 , p5_a30 JTF_VARCHAR2_TABLE_500
681 , p5_a31 JTF_VARCHAR2_TABLE_500
682 , p5_a32 JTF_VARCHAR2_TABLE_500
683 , p5_a33 JTF_NUMBER_TABLE
684 , p5_a34 JTF_DATE_TABLE
685 , p5_a35 JTF_NUMBER_TABLE
686 , p5_a36 JTF_DATE_TABLE
687 , p5_a37 JTF_NUMBER_TABLE
688 , p5_a38 JTF_VARCHAR2_TABLE_100
689 , p5_a39 JTF_VARCHAR2_TABLE_100
690 , p5_a40 JTF_NUMBER_TABLE
691 , p5_a41 JTF_DATE_TABLE
692 , p6_a0 out nocopy JTF_NUMBER_TABLE
693 , p6_a1 out nocopy JTF_NUMBER_TABLE
694 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
695 , p6_a3 out nocopy JTF_NUMBER_TABLE
696 , p6_a4 out nocopy JTF_NUMBER_TABLE
697 , p6_a5 out nocopy JTF_NUMBER_TABLE
698 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
699 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
700 , p6_a8 out nocopy JTF_NUMBER_TABLE
701 , p6_a9 out nocopy JTF_NUMBER_TABLE
702 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
703 , p6_a11 out nocopy JTF_NUMBER_TABLE
704 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
705 , p6_a13 out nocopy JTF_NUMBER_TABLE
706 , p6_a14 out nocopy JTF_NUMBER_TABLE
707 , p6_a15 out nocopy JTF_NUMBER_TABLE
708 , p6_a16 out nocopy JTF_NUMBER_TABLE
709 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
710 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
711 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
712 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
713 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
714 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
715 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
716 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
717 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
718 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
719 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
720 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
721 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
722 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
723 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
724 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
725 , p6_a33 out nocopy JTF_NUMBER_TABLE
726 , p6_a34 out nocopy JTF_DATE_TABLE
727 , p6_a35 out nocopy JTF_NUMBER_TABLE
728 , p6_a36 out nocopy JTF_DATE_TABLE
729 , p6_a37 out nocopy JTF_NUMBER_TABLE
730 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
731 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
732 , p6_a40 out nocopy JTF_NUMBER_TABLE
733 , p6_a41 out nocopy JTF_DATE_TABLE
734 )
735
736 as
737 ddp_adpv_tbl okl_txd_assets_pub.adpv_tbl_type;
738 ddx_adpv_tbl okl_txd_assets_pub.adpv_tbl_type;
739 ddindx binary_integer; indx binary_integer;
740 begin
741
742 -- copy data to the local IN or IN-OUT args, if any
743
744
745
746
747
748 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_adpv_tbl, p5_a0
749 , p5_a1
750 , p5_a2
751 , p5_a3
752 , p5_a4
753 , p5_a5
754 , p5_a6
755 , p5_a7
756 , p5_a8
757 , p5_a9
758 , p5_a10
759 , p5_a11
760 , p5_a12
761 , p5_a13
762 , p5_a14
763 , p5_a15
764 , p5_a16
765 , p5_a17
766 , p5_a18
767 , p5_a19
768 , p5_a20
769 , p5_a21
770 , p5_a22
771 , p5_a23
772 , p5_a24
773 , p5_a25
774 , p5_a26
775 , p5_a27
776 , p5_a28
777 , p5_a29
778 , p5_a30
779 , p5_a31
780 , p5_a32
781 , p5_a33
782 , p5_a34
783 , p5_a35
784 , p5_a36
785 , p5_a37
786 , p5_a38
787 , p5_a39
788 , p5_a40
789 , p5_a41
790 );
791
792
793 -- here's the delegated call to the old PL/SQL routine
794 okl_txd_assets_pub.update_txd_asset_def(p_api_version,
795 p_init_msg_list,
796 x_return_status,
797 x_msg_count,
798 x_msg_data,
799 ddp_adpv_tbl,
800 ddx_adpv_tbl);
801
802 -- copy data back from the local variables to OUT or IN-OUT args, if any
803
804
805
806
807
808
809 okl_asd_pvt_w.rosetta_table_copy_out_p8(ddx_adpv_tbl, p6_a0
810 , p6_a1
811 , p6_a2
812 , p6_a3
813 , p6_a4
814 , p6_a5
815 , p6_a6
816 , p6_a7
817 , p6_a8
818 , p6_a9
819 , p6_a10
820 , p6_a11
821 , p6_a12
822 , p6_a13
823 , p6_a14
824 , p6_a15
825 , p6_a16
826 , p6_a17
827 , p6_a18
828 , p6_a19
829 , p6_a20
830 , p6_a21
831 , p6_a22
832 , p6_a23
833 , p6_a24
834 , p6_a25
835 , p6_a26
836 , p6_a27
837 , p6_a28
838 , p6_a29
839 , p6_a30
840 , p6_a31
841 , p6_a32
842 , p6_a33
843 , p6_a34
844 , p6_a35
845 , p6_a36
846 , p6_a37
847 , p6_a38
848 , p6_a39
849 , p6_a40
850 , p6_a41
851 );
852 end;
853
854 procedure delete_txd_asset_def(p_api_version NUMBER
855 , p_init_msg_list VARCHAR2
856 , x_return_status out nocopy VARCHAR2
857 , x_msg_count out nocopy NUMBER
858 , x_msg_data out nocopy VARCHAR2
859 , p5_a0 NUMBER := 0-1962.0724
860 , p5_a1 NUMBER := 0-1962.0724
861 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
862 , p5_a3 NUMBER := 0-1962.0724
863 , p5_a4 NUMBER := 0-1962.0724
864 , p5_a5 NUMBER := 0-1962.0724
865 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
866 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
867 , p5_a8 NUMBER := 0-1962.0724
868 , p5_a9 NUMBER := 0-1962.0724
869 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
870 , p5_a11 NUMBER := 0-1962.0724
871 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
872 , p5_a13 NUMBER := 0-1962.0724
873 , p5_a14 NUMBER := 0-1962.0724
874 , p5_a15 NUMBER := 0-1962.0724
875 , p5_a16 NUMBER := 0-1962.0724
876 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
877 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
878 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
879 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
880 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
881 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
882 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
883 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
884 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
885 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
886 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
887 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
888 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
889 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
890 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
891 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
892 , p5_a33 NUMBER := 0-1962.0724
893 , p5_a34 DATE := fnd_api.g_miss_date
894 , p5_a35 NUMBER := 0-1962.0724
895 , p5_a36 DATE := fnd_api.g_miss_date
896 , p5_a37 NUMBER := 0-1962.0724
897 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
898 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
899 , p5_a40 NUMBER := 0-1962.0724
900 , p5_a41 DATE := fnd_api.g_miss_date
901 )
902
903 as
904 ddp_adpv_rec okl_txd_assets_pub.adpv_rec_type;
905 ddindx binary_integer; indx binary_integer;
906 begin
907
908 -- copy data to the local IN or IN-OUT args, if any
909
910
911
912
913
914 ddp_adpv_rec.id := rosetta_g_miss_num_map(p5_a0);
915 ddp_adpv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
916 ddp_adpv_rec.sfwt_flag := p5_a2;
917 ddp_adpv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
918 ddp_adpv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
919 ddp_adpv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
920 ddp_adpv_rec.asset_number := p5_a6;
921 ddp_adpv_rec.description := p5_a7;
922 ddp_adpv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
923 ddp_adpv_rec.cost := rosetta_g_miss_num_map(p5_a9);
924 ddp_adpv_rec.tax_book := p5_a10;
925 ddp_adpv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
926 ddp_adpv_rec.deprn_method_tax := p5_a12;
927 ddp_adpv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
928 ddp_adpv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
929 ddp_adpv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
930 ddp_adpv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
931 ddp_adpv_rec.attribute_category := p5_a17;
932 ddp_adpv_rec.attribute1 := p5_a18;
933 ddp_adpv_rec.attribute2 := p5_a19;
934 ddp_adpv_rec.attribute3 := p5_a20;
935 ddp_adpv_rec.attribute4 := p5_a21;
936 ddp_adpv_rec.attribute5 := p5_a22;
937 ddp_adpv_rec.attribute6 := p5_a23;
938 ddp_adpv_rec.attribute7 := p5_a24;
939 ddp_adpv_rec.attribute8 := p5_a25;
940 ddp_adpv_rec.attribute9 := p5_a26;
941 ddp_adpv_rec.attribute10 := p5_a27;
942 ddp_adpv_rec.attribute11 := p5_a28;
943 ddp_adpv_rec.attribute12 := p5_a29;
944 ddp_adpv_rec.attribute13 := p5_a30;
945 ddp_adpv_rec.attribute14 := p5_a31;
946 ddp_adpv_rec.attribute15 := p5_a32;
947 ddp_adpv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
948 ddp_adpv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
949 ddp_adpv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
950 ddp_adpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
951 ddp_adpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
952 ddp_adpv_rec.currency_code := p5_a38;
953 ddp_adpv_rec.currency_conversion_type := p5_a39;
954 ddp_adpv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
955 ddp_adpv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
956
957 -- here's the delegated call to the old PL/SQL routine
958 okl_txd_assets_pub.delete_txd_asset_def(p_api_version,
959 p_init_msg_list,
960 x_return_status,
961 x_msg_count,
962 x_msg_data,
963 ddp_adpv_rec);
964
965 -- copy data back from the local variables to OUT or IN-OUT args, if any
966
967
968
969
970
971 end;
972
973 procedure delete_txd_asset_def(p_api_version NUMBER
974 , p_init_msg_list VARCHAR2
975 , x_return_status out nocopy VARCHAR2
976 , x_msg_count out nocopy NUMBER
977 , x_msg_data out nocopy VARCHAR2
978 , p5_a0 JTF_NUMBER_TABLE
979 , p5_a1 JTF_NUMBER_TABLE
980 , p5_a2 JTF_VARCHAR2_TABLE_100
981 , p5_a3 JTF_NUMBER_TABLE
982 , p5_a4 JTF_NUMBER_TABLE
983 , p5_a5 JTF_NUMBER_TABLE
984 , p5_a6 JTF_VARCHAR2_TABLE_100
985 , p5_a7 JTF_VARCHAR2_TABLE_2000
986 , p5_a8 JTF_NUMBER_TABLE
987 , p5_a9 JTF_NUMBER_TABLE
988 , p5_a10 JTF_VARCHAR2_TABLE_100
989 , p5_a11 JTF_NUMBER_TABLE
990 , p5_a12 JTF_VARCHAR2_TABLE_100
991 , p5_a13 JTF_NUMBER_TABLE
992 , p5_a14 JTF_NUMBER_TABLE
993 , p5_a15 JTF_NUMBER_TABLE
994 , p5_a16 JTF_NUMBER_TABLE
995 , p5_a17 JTF_VARCHAR2_TABLE_100
996 , p5_a18 JTF_VARCHAR2_TABLE_500
997 , p5_a19 JTF_VARCHAR2_TABLE_500
998 , p5_a20 JTF_VARCHAR2_TABLE_500
999 , p5_a21 JTF_VARCHAR2_TABLE_500
1000 , p5_a22 JTF_VARCHAR2_TABLE_500
1001 , p5_a23 JTF_VARCHAR2_TABLE_500
1002 , p5_a24 JTF_VARCHAR2_TABLE_500
1003 , p5_a25 JTF_VARCHAR2_TABLE_500
1004 , p5_a26 JTF_VARCHAR2_TABLE_500
1005 , p5_a27 JTF_VARCHAR2_TABLE_500
1006 , p5_a28 JTF_VARCHAR2_TABLE_500
1007 , p5_a29 JTF_VARCHAR2_TABLE_500
1008 , p5_a30 JTF_VARCHAR2_TABLE_500
1009 , p5_a31 JTF_VARCHAR2_TABLE_500
1010 , p5_a32 JTF_VARCHAR2_TABLE_500
1011 , p5_a33 JTF_NUMBER_TABLE
1012 , p5_a34 JTF_DATE_TABLE
1013 , p5_a35 JTF_NUMBER_TABLE
1014 , p5_a36 JTF_DATE_TABLE
1015 , p5_a37 JTF_NUMBER_TABLE
1016 , p5_a38 JTF_VARCHAR2_TABLE_100
1017 , p5_a39 JTF_VARCHAR2_TABLE_100
1018 , p5_a40 JTF_NUMBER_TABLE
1019 , p5_a41 JTF_DATE_TABLE
1020 )
1021
1022 as
1023 ddp_adpv_tbl okl_txd_assets_pub.adpv_tbl_type;
1024 ddindx binary_integer; indx binary_integer;
1025 begin
1026
1027 -- copy data to the local IN or IN-OUT args, if any
1028
1029
1030
1031
1032
1033 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_adpv_tbl, p5_a0
1034 , p5_a1
1035 , p5_a2
1036 , p5_a3
1037 , p5_a4
1038 , p5_a5
1039 , p5_a6
1040 , p5_a7
1041 , p5_a8
1042 , p5_a9
1043 , p5_a10
1044 , p5_a11
1045 , p5_a12
1046 , p5_a13
1047 , p5_a14
1048 , p5_a15
1049 , p5_a16
1050 , p5_a17
1051 , p5_a18
1052 , p5_a19
1053 , p5_a20
1054 , p5_a21
1055 , p5_a22
1056 , p5_a23
1057 , p5_a24
1058 , p5_a25
1059 , p5_a26
1060 , p5_a27
1061 , p5_a28
1062 , p5_a29
1063 , p5_a30
1064 , p5_a31
1065 , p5_a32
1066 , p5_a33
1067 , p5_a34
1068 , p5_a35
1069 , p5_a36
1070 , p5_a37
1071 , p5_a38
1072 , p5_a39
1073 , p5_a40
1074 , p5_a41
1075 );
1076
1077 -- here's the delegated call to the old PL/SQL routine
1078 okl_txd_assets_pub.delete_txd_asset_def(p_api_version,
1079 p_init_msg_list,
1080 x_return_status,
1081 x_msg_count,
1082 x_msg_data,
1083 ddp_adpv_tbl);
1084
1085 -- copy data back from the local variables to OUT or IN-OUT args, if any
1086
1087
1088
1089
1090
1091 end;
1092
1093 procedure lock_txd_asset_def(p_api_version NUMBER
1094 , p_init_msg_list VARCHAR2
1095 , x_return_status out nocopy VARCHAR2
1096 , x_msg_count out nocopy NUMBER
1097 , x_msg_data out nocopy VARCHAR2
1098 , p5_a0 NUMBER := 0-1962.0724
1099 , p5_a1 NUMBER := 0-1962.0724
1100 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1101 , p5_a3 NUMBER := 0-1962.0724
1102 , p5_a4 NUMBER := 0-1962.0724
1103 , p5_a5 NUMBER := 0-1962.0724
1104 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1105 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1106 , p5_a8 NUMBER := 0-1962.0724
1107 , p5_a9 NUMBER := 0-1962.0724
1108 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109 , p5_a11 NUMBER := 0-1962.0724
1110 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111 , p5_a13 NUMBER := 0-1962.0724
1112 , p5_a14 NUMBER := 0-1962.0724
1113 , p5_a15 NUMBER := 0-1962.0724
1114 , p5_a16 NUMBER := 0-1962.0724
1115 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1122 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1123 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1124 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1125 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1126 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1127 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1128 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1129 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1130 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1131 , p5_a33 NUMBER := 0-1962.0724
1132 , p5_a34 DATE := fnd_api.g_miss_date
1133 , p5_a35 NUMBER := 0-1962.0724
1134 , p5_a36 DATE := fnd_api.g_miss_date
1135 , p5_a37 NUMBER := 0-1962.0724
1136 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1137 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1138 , p5_a40 NUMBER := 0-1962.0724
1139 , p5_a41 DATE := fnd_api.g_miss_date
1140 )
1141
1142 as
1143 ddp_adpv_rec okl_txd_assets_pub.adpv_rec_type;
1144 ddindx binary_integer; indx binary_integer;
1145 begin
1146
1147 -- copy data to the local IN or IN-OUT args, if any
1148
1149
1150
1151
1152
1153 ddp_adpv_rec.id := rosetta_g_miss_num_map(p5_a0);
1154 ddp_adpv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1155 ddp_adpv_rec.sfwt_flag := p5_a2;
1156 ddp_adpv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
1157 ddp_adpv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
1158 ddp_adpv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
1159 ddp_adpv_rec.asset_number := p5_a6;
1160 ddp_adpv_rec.description := p5_a7;
1161 ddp_adpv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
1162 ddp_adpv_rec.cost := rosetta_g_miss_num_map(p5_a9);
1163 ddp_adpv_rec.tax_book := p5_a10;
1164 ddp_adpv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
1165 ddp_adpv_rec.deprn_method_tax := p5_a12;
1166 ddp_adpv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
1167 ddp_adpv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
1168 ddp_adpv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
1169 ddp_adpv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
1170 ddp_adpv_rec.attribute_category := p5_a17;
1171 ddp_adpv_rec.attribute1 := p5_a18;
1172 ddp_adpv_rec.attribute2 := p5_a19;
1173 ddp_adpv_rec.attribute3 := p5_a20;
1174 ddp_adpv_rec.attribute4 := p5_a21;
1175 ddp_adpv_rec.attribute5 := p5_a22;
1176 ddp_adpv_rec.attribute6 := p5_a23;
1177 ddp_adpv_rec.attribute7 := p5_a24;
1178 ddp_adpv_rec.attribute8 := p5_a25;
1179 ddp_adpv_rec.attribute9 := p5_a26;
1180 ddp_adpv_rec.attribute10 := p5_a27;
1181 ddp_adpv_rec.attribute11 := p5_a28;
1182 ddp_adpv_rec.attribute12 := p5_a29;
1183 ddp_adpv_rec.attribute13 := p5_a30;
1184 ddp_adpv_rec.attribute14 := p5_a31;
1185 ddp_adpv_rec.attribute15 := p5_a32;
1186 ddp_adpv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
1187 ddp_adpv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
1188 ddp_adpv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
1189 ddp_adpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1190 ddp_adpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1191 ddp_adpv_rec.currency_code := p5_a38;
1192 ddp_adpv_rec.currency_conversion_type := p5_a39;
1193 ddp_adpv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
1194 ddp_adpv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1195
1196 -- here's the delegated call to the old PL/SQL routine
1197 okl_txd_assets_pub.lock_txd_asset_def(p_api_version,
1198 p_init_msg_list,
1199 x_return_status,
1200 x_msg_count,
1201 x_msg_data,
1202 ddp_adpv_rec);
1203
1204 -- copy data back from the local variables to OUT or IN-OUT args, if any
1205
1206
1207
1208
1209
1210 end;
1211
1212 procedure lock_txd_asset_def(p_api_version NUMBER
1213 , p_init_msg_list VARCHAR2
1214 , x_return_status out nocopy VARCHAR2
1215 , x_msg_count out nocopy NUMBER
1216 , x_msg_data out nocopy VARCHAR2
1217 , p5_a0 JTF_NUMBER_TABLE
1218 , p5_a1 JTF_NUMBER_TABLE
1219 , p5_a2 JTF_VARCHAR2_TABLE_100
1220 , p5_a3 JTF_NUMBER_TABLE
1221 , p5_a4 JTF_NUMBER_TABLE
1222 , p5_a5 JTF_NUMBER_TABLE
1223 , p5_a6 JTF_VARCHAR2_TABLE_100
1224 , p5_a7 JTF_VARCHAR2_TABLE_2000
1225 , p5_a8 JTF_NUMBER_TABLE
1226 , p5_a9 JTF_NUMBER_TABLE
1227 , p5_a10 JTF_VARCHAR2_TABLE_100
1228 , p5_a11 JTF_NUMBER_TABLE
1229 , p5_a12 JTF_VARCHAR2_TABLE_100
1230 , p5_a13 JTF_NUMBER_TABLE
1231 , p5_a14 JTF_NUMBER_TABLE
1232 , p5_a15 JTF_NUMBER_TABLE
1233 , p5_a16 JTF_NUMBER_TABLE
1234 , p5_a17 JTF_VARCHAR2_TABLE_100
1235 , p5_a18 JTF_VARCHAR2_TABLE_500
1236 , p5_a19 JTF_VARCHAR2_TABLE_500
1237 , p5_a20 JTF_VARCHAR2_TABLE_500
1238 , p5_a21 JTF_VARCHAR2_TABLE_500
1239 , p5_a22 JTF_VARCHAR2_TABLE_500
1240 , p5_a23 JTF_VARCHAR2_TABLE_500
1241 , p5_a24 JTF_VARCHAR2_TABLE_500
1242 , p5_a25 JTF_VARCHAR2_TABLE_500
1243 , p5_a26 JTF_VARCHAR2_TABLE_500
1244 , p5_a27 JTF_VARCHAR2_TABLE_500
1245 , p5_a28 JTF_VARCHAR2_TABLE_500
1246 , p5_a29 JTF_VARCHAR2_TABLE_500
1247 , p5_a30 JTF_VARCHAR2_TABLE_500
1248 , p5_a31 JTF_VARCHAR2_TABLE_500
1249 , p5_a32 JTF_VARCHAR2_TABLE_500
1250 , p5_a33 JTF_NUMBER_TABLE
1251 , p5_a34 JTF_DATE_TABLE
1252 , p5_a35 JTF_NUMBER_TABLE
1253 , p5_a36 JTF_DATE_TABLE
1254 , p5_a37 JTF_NUMBER_TABLE
1255 , p5_a38 JTF_VARCHAR2_TABLE_100
1256 , p5_a39 JTF_VARCHAR2_TABLE_100
1257 , p5_a40 JTF_NUMBER_TABLE
1258 , p5_a41 JTF_DATE_TABLE
1259 )
1260
1261 as
1262 ddp_adpv_tbl okl_txd_assets_pub.adpv_tbl_type;
1263 ddindx binary_integer; indx binary_integer;
1264 begin
1265
1266 -- copy data to the local IN or IN-OUT args, if any
1267
1268
1269
1270
1271
1272 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_adpv_tbl, p5_a0
1273 , p5_a1
1274 , p5_a2
1275 , p5_a3
1276 , p5_a4
1277 , p5_a5
1278 , p5_a6
1279 , p5_a7
1280 , p5_a8
1281 , p5_a9
1282 , p5_a10
1283 , p5_a11
1284 , p5_a12
1285 , p5_a13
1286 , p5_a14
1287 , p5_a15
1288 , p5_a16
1289 , p5_a17
1290 , p5_a18
1291 , p5_a19
1292 , p5_a20
1293 , p5_a21
1294 , p5_a22
1295 , p5_a23
1296 , p5_a24
1297 , p5_a25
1298 , p5_a26
1299 , p5_a27
1300 , p5_a28
1301 , p5_a29
1302 , p5_a30
1303 , p5_a31
1304 , p5_a32
1305 , p5_a33
1306 , p5_a34
1307 , p5_a35
1308 , p5_a36
1309 , p5_a37
1310 , p5_a38
1311 , p5_a39
1312 , p5_a40
1313 , p5_a41
1314 );
1315
1316 -- here's the delegated call to the old PL/SQL routine
1317 okl_txd_assets_pub.lock_txd_asset_def(p_api_version,
1318 p_init_msg_list,
1319 x_return_status,
1320 x_msg_count,
1321 x_msg_data,
1322 ddp_adpv_tbl);
1323
1324 -- copy data back from the local variables to OUT or IN-OUT args, if any
1325
1326
1327
1328
1329
1330 end;
1331
1332 procedure validate_txd_asset_def(p_api_version NUMBER
1333 , p_init_msg_list VARCHAR2
1334 , x_return_status out nocopy VARCHAR2
1335 , x_msg_count out nocopy NUMBER
1336 , x_msg_data out nocopy VARCHAR2
1337 , p5_a0 NUMBER := 0-1962.0724
1338 , p5_a1 NUMBER := 0-1962.0724
1339 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1340 , p5_a3 NUMBER := 0-1962.0724
1341 , p5_a4 NUMBER := 0-1962.0724
1342 , p5_a5 NUMBER := 0-1962.0724
1343 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1344 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1345 , p5_a8 NUMBER := 0-1962.0724
1346 , p5_a9 NUMBER := 0-1962.0724
1347 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1348 , p5_a11 NUMBER := 0-1962.0724
1349 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1350 , p5_a13 NUMBER := 0-1962.0724
1351 , p5_a14 NUMBER := 0-1962.0724
1352 , p5_a15 NUMBER := 0-1962.0724
1353 , p5_a16 NUMBER := 0-1962.0724
1354 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1355 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1356 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1357 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1358 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1359 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1360 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1361 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1362 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1363 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1364 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1365 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1366 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1367 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1368 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1369 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1370 , p5_a33 NUMBER := 0-1962.0724
1371 , p5_a34 DATE := fnd_api.g_miss_date
1372 , p5_a35 NUMBER := 0-1962.0724
1373 , p5_a36 DATE := fnd_api.g_miss_date
1374 , p5_a37 NUMBER := 0-1962.0724
1375 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1376 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1377 , p5_a40 NUMBER := 0-1962.0724
1378 , p5_a41 DATE := fnd_api.g_miss_date
1379 )
1380
1381 as
1382 ddp_adpv_rec okl_txd_assets_pub.adpv_rec_type;
1383 ddindx binary_integer; indx binary_integer;
1384 begin
1385
1386 -- copy data to the local IN or IN-OUT args, if any
1387
1388
1389
1390
1391
1392 ddp_adpv_rec.id := rosetta_g_miss_num_map(p5_a0);
1393 ddp_adpv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1394 ddp_adpv_rec.sfwt_flag := p5_a2;
1395 ddp_adpv_rec.tal_id := rosetta_g_miss_num_map(p5_a3);
1396 ddp_adpv_rec.target_kle_id := rosetta_g_miss_num_map(p5_a4);
1397 ddp_adpv_rec.line_detail_number := rosetta_g_miss_num_map(p5_a5);
1398 ddp_adpv_rec.asset_number := p5_a6;
1399 ddp_adpv_rec.description := p5_a7;
1400 ddp_adpv_rec.quantity := rosetta_g_miss_num_map(p5_a8);
1401 ddp_adpv_rec.cost := rosetta_g_miss_num_map(p5_a9);
1402 ddp_adpv_rec.tax_book := p5_a10;
1403 ddp_adpv_rec.life_in_months_tax := rosetta_g_miss_num_map(p5_a11);
1404 ddp_adpv_rec.deprn_method_tax := p5_a12;
1405 ddp_adpv_rec.deprn_rate_tax := rosetta_g_miss_num_map(p5_a13);
1406 ddp_adpv_rec.salvage_value := rosetta_g_miss_num_map(p5_a14);
1407 ddp_adpv_rec.split_percent := rosetta_g_miss_num_map(p5_a15);
1408 ddp_adpv_rec.inventory_item_id := rosetta_g_miss_num_map(p5_a16);
1409 ddp_adpv_rec.attribute_category := p5_a17;
1410 ddp_adpv_rec.attribute1 := p5_a18;
1411 ddp_adpv_rec.attribute2 := p5_a19;
1412 ddp_adpv_rec.attribute3 := p5_a20;
1413 ddp_adpv_rec.attribute4 := p5_a21;
1414 ddp_adpv_rec.attribute5 := p5_a22;
1415 ddp_adpv_rec.attribute6 := p5_a23;
1416 ddp_adpv_rec.attribute7 := p5_a24;
1417 ddp_adpv_rec.attribute8 := p5_a25;
1418 ddp_adpv_rec.attribute9 := p5_a26;
1419 ddp_adpv_rec.attribute10 := p5_a27;
1420 ddp_adpv_rec.attribute11 := p5_a28;
1421 ddp_adpv_rec.attribute12 := p5_a29;
1422 ddp_adpv_rec.attribute13 := p5_a30;
1423 ddp_adpv_rec.attribute14 := p5_a31;
1424 ddp_adpv_rec.attribute15 := p5_a32;
1425 ddp_adpv_rec.created_by := rosetta_g_miss_num_map(p5_a33);
1426 ddp_adpv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a34);
1427 ddp_adpv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a35);
1428 ddp_adpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1429 ddp_adpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1430 ddp_adpv_rec.currency_code := p5_a38;
1431 ddp_adpv_rec.currency_conversion_type := p5_a39;
1432 ddp_adpv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a40);
1433 ddp_adpv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a41);
1434
1435 -- here's the delegated call to the old PL/SQL routine
1436 okl_txd_assets_pub.validate_txd_asset_def(p_api_version,
1437 p_init_msg_list,
1438 x_return_status,
1439 x_msg_count,
1440 x_msg_data,
1441 ddp_adpv_rec);
1442
1443 -- copy data back from the local variables to OUT or IN-OUT args, if any
1444
1445
1446
1447
1448
1449 end;
1450
1451 procedure validate_txd_asset_def(p_api_version NUMBER
1452 , p_init_msg_list VARCHAR2
1453 , x_return_status out nocopy VARCHAR2
1454 , x_msg_count out nocopy NUMBER
1455 , x_msg_data out nocopy VARCHAR2
1456 , p5_a0 JTF_NUMBER_TABLE
1457 , p5_a1 JTF_NUMBER_TABLE
1458 , p5_a2 JTF_VARCHAR2_TABLE_100
1459 , p5_a3 JTF_NUMBER_TABLE
1460 , p5_a4 JTF_NUMBER_TABLE
1461 , p5_a5 JTF_NUMBER_TABLE
1462 , p5_a6 JTF_VARCHAR2_TABLE_100
1463 , p5_a7 JTF_VARCHAR2_TABLE_2000
1464 , p5_a8 JTF_NUMBER_TABLE
1465 , p5_a9 JTF_NUMBER_TABLE
1466 , p5_a10 JTF_VARCHAR2_TABLE_100
1467 , p5_a11 JTF_NUMBER_TABLE
1468 , p5_a12 JTF_VARCHAR2_TABLE_100
1469 , p5_a13 JTF_NUMBER_TABLE
1470 , p5_a14 JTF_NUMBER_TABLE
1471 , p5_a15 JTF_NUMBER_TABLE
1472 , p5_a16 JTF_NUMBER_TABLE
1473 , p5_a17 JTF_VARCHAR2_TABLE_100
1474 , p5_a18 JTF_VARCHAR2_TABLE_500
1475 , p5_a19 JTF_VARCHAR2_TABLE_500
1476 , p5_a20 JTF_VARCHAR2_TABLE_500
1477 , p5_a21 JTF_VARCHAR2_TABLE_500
1478 , p5_a22 JTF_VARCHAR2_TABLE_500
1479 , p5_a23 JTF_VARCHAR2_TABLE_500
1480 , p5_a24 JTF_VARCHAR2_TABLE_500
1481 , p5_a25 JTF_VARCHAR2_TABLE_500
1482 , p5_a26 JTF_VARCHAR2_TABLE_500
1483 , p5_a27 JTF_VARCHAR2_TABLE_500
1484 , p5_a28 JTF_VARCHAR2_TABLE_500
1485 , p5_a29 JTF_VARCHAR2_TABLE_500
1486 , p5_a30 JTF_VARCHAR2_TABLE_500
1487 , p5_a31 JTF_VARCHAR2_TABLE_500
1488 , p5_a32 JTF_VARCHAR2_TABLE_500
1489 , p5_a33 JTF_NUMBER_TABLE
1490 , p5_a34 JTF_DATE_TABLE
1491 , p5_a35 JTF_NUMBER_TABLE
1492 , p5_a36 JTF_DATE_TABLE
1493 , p5_a37 JTF_NUMBER_TABLE
1494 , p5_a38 JTF_VARCHAR2_TABLE_100
1495 , p5_a39 JTF_VARCHAR2_TABLE_100
1496 , p5_a40 JTF_NUMBER_TABLE
1497 , p5_a41 JTF_DATE_TABLE
1498 )
1499
1500 as
1501 ddp_adpv_tbl okl_txd_assets_pub.adpv_tbl_type;
1502 ddindx binary_integer; indx binary_integer;
1503 begin
1504
1505 -- copy data to the local IN or IN-OUT args, if any
1506
1507
1508
1509
1510
1511 okl_asd_pvt_w.rosetta_table_copy_in_p8(ddp_adpv_tbl, p5_a0
1512 , p5_a1
1513 , p5_a2
1514 , p5_a3
1515 , p5_a4
1516 , p5_a5
1517 , p5_a6
1518 , p5_a7
1519 , p5_a8
1520 , p5_a9
1521 , p5_a10
1522 , p5_a11
1523 , p5_a12
1524 , p5_a13
1525 , p5_a14
1526 , p5_a15
1527 , p5_a16
1528 , p5_a17
1529 , p5_a18
1530 , p5_a19
1531 , p5_a20
1532 , p5_a21
1533 , p5_a22
1534 , p5_a23
1535 , p5_a24
1536 , p5_a25
1537 , p5_a26
1538 , p5_a27
1539 , p5_a28
1540 , p5_a29
1541 , p5_a30
1542 , p5_a31
1543 , p5_a32
1544 , p5_a33
1545 , p5_a34
1546 , p5_a35
1547 , p5_a36
1548 , p5_a37
1549 , p5_a38
1550 , p5_a39
1551 , p5_a40
1552 , p5_a41
1553 );
1554
1555 -- here's the delegated call to the old PL/SQL routine
1556 okl_txd_assets_pub.validate_txd_asset_def(p_api_version,
1557 p_init_msg_list,
1558 x_return_status,
1559 x_msg_count,
1560 x_msg_data,
1561 ddp_adpv_tbl);
1562
1563 -- copy data back from the local variables to OUT or IN-OUT args, if any
1564
1565
1566
1567
1568
1569 end;
1570
1571 end okl_txd_assets_pub_w;