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