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