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