18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ozf_pricelist_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ozf_pricelist_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_300
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_300
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_300
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_300
40: , a18 JTF_VARCHAR2_TABLE_300
41: , a19 JTF_VARCHAR2_TABLE_300
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_300
40: , a18 JTF_VARCHAR2_TABLE_300
41: , a19 JTF_VARCHAR2_TABLE_300
42: , a20 JTF_VARCHAR2_TABLE_300
99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p3;
103: procedure rosetta_table_copy_out_p3(t ozf_pricelist_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
102: end rosetta_table_copy_in_p3;
103: procedure rosetta_table_copy_out_p3(t ozf_pricelist_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_VARCHAR2_TABLE_300
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_VARCHAR2_TABLE_300
111: , a8 out nocopy JTF_VARCHAR2_TABLE_300
112: , a9 out nocopy JTF_VARCHAR2_TABLE_100
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_VARCHAR2_TABLE_300
111: , a8 out nocopy JTF_VARCHAR2_TABLE_300
112: , a9 out nocopy JTF_VARCHAR2_TABLE_100
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_VARCHAR2_TABLE_300
111: , a8 out nocopy JTF_VARCHAR2_TABLE_300
112: , a9 out nocopy JTF_VARCHAR2_TABLE_100
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_DATE_TABLE
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_DATE_TABLE
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100
119: , a16 out nocopy JTF_VARCHAR2_TABLE_100
120: , a17 out nocopy JTF_VARCHAR2_TABLE_300
121: , a18 out nocopy JTF_VARCHAR2_TABLE_300
122: , a19 out nocopy JTF_VARCHAR2_TABLE_300
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_DATE_TABLE
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100
119: , a16 out nocopy JTF_VARCHAR2_TABLE_100
120: , a17 out nocopy JTF_VARCHAR2_TABLE_300
121: , a18 out nocopy JTF_VARCHAR2_TABLE_300
122: , a19 out nocopy JTF_VARCHAR2_TABLE_300
123: , a20 out nocopy JTF_VARCHAR2_TABLE_300
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_VARCHAR2_TABLE_100();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_DATE_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
138: if t is null or t.count = 0 then
139: a0 := JTF_VARCHAR2_TABLE_100();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_DATE_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_300();
141: a2 := JTF_DATE_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_300();
147: a8 := JTF_VARCHAR2_TABLE_300();
148: a9 := JTF_VARCHAR2_TABLE_100();
149: a10 := JTF_VARCHAR2_TABLE_100();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_300();
147: a8 := JTF_VARCHAR2_TABLE_300();
148: a9 := JTF_VARCHAR2_TABLE_100();
149: a10 := JTF_VARCHAR2_TABLE_100();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_300();
147: a8 := JTF_VARCHAR2_TABLE_300();
148: a9 := JTF_VARCHAR2_TABLE_100();
149: a10 := JTF_VARCHAR2_TABLE_100();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
153: a14 := JTF_DATE_TABLE();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
153: a14 := JTF_DATE_TABLE();
154: a15 := JTF_VARCHAR2_TABLE_100();
155: a16 := JTF_VARCHAR2_TABLE_100();
156: a17 := JTF_VARCHAR2_TABLE_300();
157: a18 := JTF_VARCHAR2_TABLE_300();
158: a19 := JTF_VARCHAR2_TABLE_300();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
153: a14 := JTF_DATE_TABLE();
154: a15 := JTF_VARCHAR2_TABLE_100();
155: a16 := JTF_VARCHAR2_TABLE_100();
156: a17 := JTF_VARCHAR2_TABLE_300();
157: a18 := JTF_VARCHAR2_TABLE_300();
158: a19 := JTF_VARCHAR2_TABLE_300();
159: a20 := JTF_VARCHAR2_TABLE_300();
168: a29 := JTF_VARCHAR2_TABLE_300();
169: a30 := JTF_VARCHAR2_TABLE_300();
170: a31 := JTF_VARCHAR2_TABLE_300();
171: else
172: a0 := JTF_VARCHAR2_TABLE_100();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_DATE_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_VARCHAR2_TABLE_100();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_DATE_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_300();
174: a2 := JTF_DATE_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_300();
180: a8 := JTF_VARCHAR2_TABLE_300();
181: a9 := JTF_VARCHAR2_TABLE_100();
182: a10 := JTF_VARCHAR2_TABLE_100();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_300();
180: a8 := JTF_VARCHAR2_TABLE_300();
181: a9 := JTF_VARCHAR2_TABLE_100();
182: a10 := JTF_VARCHAR2_TABLE_100();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_300();
180: a8 := JTF_VARCHAR2_TABLE_300();
181: a9 := JTF_VARCHAR2_TABLE_100();
182: a10 := JTF_VARCHAR2_TABLE_100();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_DATE_TABLE();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_DATE_TABLE();
187: a15 := JTF_VARCHAR2_TABLE_100();
188: a16 := JTF_VARCHAR2_TABLE_100();
189: a17 := JTF_VARCHAR2_TABLE_300();
190: a18 := JTF_VARCHAR2_TABLE_300();
191: a19 := JTF_VARCHAR2_TABLE_300();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_DATE_TABLE();
187: a15 := JTF_VARCHAR2_TABLE_100();
188: a16 := JTF_VARCHAR2_TABLE_100();
189: a17 := JTF_VARCHAR2_TABLE_300();
190: a18 := JTF_VARCHAR2_TABLE_300();
191: a19 := JTF_VARCHAR2_TABLE_300();
192: a20 := JTF_VARCHAR2_TABLE_300();
278: end if;
279: end if;
280: end rosetta_table_copy_out_p3;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
283: , a1 JTF_DATE_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_VARCHAR2_TABLE_100
290: , a8 JTF_VARCHAR2_TABLE_100
291: , a9 JTF_NUMBER_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_VARCHAR2_TABLE_100
290: , a8 JTF_VARCHAR2_TABLE_100
291: , a9 JTF_NUMBER_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_NUMBER_TABLE
294: , a12 JTF_NUMBER_TABLE
293: , a11 JTF_NUMBER_TABLE
294: , a12 JTF_NUMBER_TABLE
295: , a13 JTF_VARCHAR2_TABLE_2000
296: , a14 JTF_NUMBER_TABLE
297: , a15 JTF_VARCHAR2_TABLE_100
298: , a16 JTF_VARCHAR2_TABLE_300
299: , a17 JTF_VARCHAR2_TABLE_300
300: , a18 JTF_VARCHAR2_TABLE_300
301: , a19 JTF_VARCHAR2_TABLE_300
357: end loop;
358: end if;
359: end if;
360: end rosetta_table_copy_in_p5;
361: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
362: , a1 out nocopy JTF_DATE_TABLE
363: , a2 out nocopy JTF_NUMBER_TABLE
364: , a3 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE
364: , a3 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE
366: , a5 out nocopy JTF_NUMBER_TABLE
367: , a6 out nocopy JTF_DATE_TABLE
368: , a7 out nocopy JTF_VARCHAR2_TABLE_100
369: , a8 out nocopy JTF_VARCHAR2_TABLE_100
370: , a9 out nocopy JTF_NUMBER_TABLE
371: , a10 out nocopy JTF_NUMBER_TABLE
372: , a11 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE
366: , a5 out nocopy JTF_NUMBER_TABLE
367: , a6 out nocopy JTF_DATE_TABLE
368: , a7 out nocopy JTF_VARCHAR2_TABLE_100
369: , a8 out nocopy JTF_VARCHAR2_TABLE_100
370: , a9 out nocopy JTF_NUMBER_TABLE
371: , a10 out nocopy JTF_NUMBER_TABLE
372: , a11 out nocopy JTF_NUMBER_TABLE
373: , a12 out nocopy JTF_NUMBER_TABLE
372: , a11 out nocopy JTF_NUMBER_TABLE
373: , a12 out nocopy JTF_NUMBER_TABLE
374: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
375: , a14 out nocopy JTF_NUMBER_TABLE
376: , a15 out nocopy JTF_VARCHAR2_TABLE_100
377: , a16 out nocopy JTF_VARCHAR2_TABLE_300
378: , a17 out nocopy JTF_VARCHAR2_TABLE_300
379: , a18 out nocopy JTF_VARCHAR2_TABLE_300
380: , a19 out nocopy JTF_VARCHAR2_TABLE_300
392: ) as
393: ddindx binary_integer; indx binary_integer;
394: begin
395: if t is null or t.count = 0 then
396: a0 := JTF_VARCHAR2_TABLE_100();
397: a1 := JTF_DATE_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_DATE_TABLE();
403: a7 := JTF_VARCHAR2_TABLE_100();
404: a8 := JTF_VARCHAR2_TABLE_100();
405: a9 := JTF_NUMBER_TABLE();
406: a10 := JTF_NUMBER_TABLE();
407: a11 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_DATE_TABLE();
403: a7 := JTF_VARCHAR2_TABLE_100();
404: a8 := JTF_VARCHAR2_TABLE_100();
405: a9 := JTF_NUMBER_TABLE();
406: a10 := JTF_NUMBER_TABLE();
407: a11 := JTF_NUMBER_TABLE();
408: a12 := JTF_NUMBER_TABLE();
407: a11 := JTF_NUMBER_TABLE();
408: a12 := JTF_NUMBER_TABLE();
409: a13 := JTF_VARCHAR2_TABLE_2000();
410: a14 := JTF_NUMBER_TABLE();
411: a15 := JTF_VARCHAR2_TABLE_100();
412: a16 := JTF_VARCHAR2_TABLE_300();
413: a17 := JTF_VARCHAR2_TABLE_300();
414: a18 := JTF_VARCHAR2_TABLE_300();
415: a19 := JTF_VARCHAR2_TABLE_300();
424: a28 := JTF_VARCHAR2_TABLE_300();
425: a29 := JTF_VARCHAR2_TABLE_300();
426: a30 := JTF_VARCHAR2_TABLE_300();
427: else
428: a0 := JTF_VARCHAR2_TABLE_100();
429: a1 := JTF_DATE_TABLE();
430: a2 := JTF_NUMBER_TABLE();
431: a3 := JTF_NUMBER_TABLE();
432: a4 := JTF_NUMBER_TABLE();
431: a3 := JTF_NUMBER_TABLE();
432: a4 := JTF_NUMBER_TABLE();
433: a5 := JTF_NUMBER_TABLE();
434: a6 := JTF_DATE_TABLE();
435: a7 := JTF_VARCHAR2_TABLE_100();
436: a8 := JTF_VARCHAR2_TABLE_100();
437: a9 := JTF_NUMBER_TABLE();
438: a10 := JTF_NUMBER_TABLE();
439: a11 := JTF_NUMBER_TABLE();
432: a4 := JTF_NUMBER_TABLE();
433: a5 := JTF_NUMBER_TABLE();
434: a6 := JTF_DATE_TABLE();
435: a7 := JTF_VARCHAR2_TABLE_100();
436: a8 := JTF_VARCHAR2_TABLE_100();
437: a9 := JTF_NUMBER_TABLE();
438: a10 := JTF_NUMBER_TABLE();
439: a11 := JTF_NUMBER_TABLE();
440: a12 := JTF_NUMBER_TABLE();
439: a11 := JTF_NUMBER_TABLE();
440: a12 := JTF_NUMBER_TABLE();
441: a13 := JTF_VARCHAR2_TABLE_2000();
442: a14 := JTF_NUMBER_TABLE();
443: a15 := JTF_VARCHAR2_TABLE_100();
444: a16 := JTF_VARCHAR2_TABLE_300();
445: a17 := JTF_VARCHAR2_TABLE_300();
446: a18 := JTF_VARCHAR2_TABLE_300();
447: a19 := JTF_VARCHAR2_TABLE_300();
532: end if;
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_VARCHAR2_TABLE_100
537: , a2 JTF_VARCHAR2_TABLE_100
538: , a3 JTF_NUMBER_TABLE
539: , a4 JTF_VARCHAR2_TABLE_300
540: , a5 JTF_VARCHAR2_TABLE_300
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_VARCHAR2_TABLE_100
537: , a2 JTF_VARCHAR2_TABLE_100
538: , a3 JTF_NUMBER_TABLE
539: , a4 JTF_VARCHAR2_TABLE_300
540: , a5 JTF_VARCHAR2_TABLE_300
541: , a6 JTF_VARCHAR2_TABLE_100
537: , a2 JTF_VARCHAR2_TABLE_100
538: , a3 JTF_NUMBER_TABLE
539: , a4 JTF_VARCHAR2_TABLE_300
540: , a5 JTF_VARCHAR2_TABLE_300
541: , a6 JTF_VARCHAR2_TABLE_100
542: , a7 JTF_VARCHAR2_TABLE_100
543: , a8 JTF_VARCHAR2_TABLE_300
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
538: , a3 JTF_NUMBER_TABLE
539: , a4 JTF_VARCHAR2_TABLE_300
540: , a5 JTF_VARCHAR2_TABLE_300
541: , a6 JTF_VARCHAR2_TABLE_100
542: , a7 JTF_VARCHAR2_TABLE_100
543: , a8 JTF_VARCHAR2_TABLE_300
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
540: , a5 JTF_VARCHAR2_TABLE_300
541: , a6 JTF_VARCHAR2_TABLE_100
542: , a7 JTF_VARCHAR2_TABLE_100
543: , a8 JTF_VARCHAR2_TABLE_300
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_VARCHAR2_TABLE_100
548: , a13 JTF_NUMBER_TABLE
541: , a6 JTF_VARCHAR2_TABLE_100
542: , a7 JTF_VARCHAR2_TABLE_100
543: , a8 JTF_VARCHAR2_TABLE_300
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_VARCHAR2_TABLE_100
548: , a13 JTF_NUMBER_TABLE
549: ) as
543: , a8 JTF_VARCHAR2_TABLE_300
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_VARCHAR2_TABLE_100
548: , a13 JTF_NUMBER_TABLE
549: ) as
550: ddindx binary_integer; indx binary_integer;
551: begin
577: end if;
578: end if;
579: end rosetta_table_copy_in_p7;
580: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
581: , a1 out nocopy JTF_VARCHAR2_TABLE_100
582: , a2 out nocopy JTF_VARCHAR2_TABLE_100
583: , a3 out nocopy JTF_NUMBER_TABLE
584: , a4 out nocopy JTF_VARCHAR2_TABLE_300
585: , a5 out nocopy JTF_VARCHAR2_TABLE_300
578: end if;
579: end rosetta_table_copy_in_p7;
580: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
581: , a1 out nocopy JTF_VARCHAR2_TABLE_100
582: , a2 out nocopy JTF_VARCHAR2_TABLE_100
583: , a3 out nocopy JTF_NUMBER_TABLE
584: , a4 out nocopy JTF_VARCHAR2_TABLE_300
585: , a5 out nocopy JTF_VARCHAR2_TABLE_300
586: , a6 out nocopy JTF_VARCHAR2_TABLE_100
582: , a2 out nocopy JTF_VARCHAR2_TABLE_100
583: , a3 out nocopy JTF_NUMBER_TABLE
584: , a4 out nocopy JTF_VARCHAR2_TABLE_300
585: , a5 out nocopy JTF_VARCHAR2_TABLE_300
586: , a6 out nocopy JTF_VARCHAR2_TABLE_100
587: , a7 out nocopy JTF_VARCHAR2_TABLE_100
588: , a8 out nocopy JTF_VARCHAR2_TABLE_300
589: , a9 out nocopy JTF_VARCHAR2_TABLE_100
590: , a10 out nocopy JTF_VARCHAR2_TABLE_100
583: , a3 out nocopy JTF_NUMBER_TABLE
584: , a4 out nocopy JTF_VARCHAR2_TABLE_300
585: , a5 out nocopy JTF_VARCHAR2_TABLE_300
586: , a6 out nocopy JTF_VARCHAR2_TABLE_100
587: , a7 out nocopy JTF_VARCHAR2_TABLE_100
588: , a8 out nocopy JTF_VARCHAR2_TABLE_300
589: , a9 out nocopy JTF_VARCHAR2_TABLE_100
590: , a10 out nocopy JTF_VARCHAR2_TABLE_100
591: , a11 out nocopy JTF_NUMBER_TABLE
585: , a5 out nocopy JTF_VARCHAR2_TABLE_300
586: , a6 out nocopy JTF_VARCHAR2_TABLE_100
587: , a7 out nocopy JTF_VARCHAR2_TABLE_100
588: , a8 out nocopy JTF_VARCHAR2_TABLE_300
589: , a9 out nocopy JTF_VARCHAR2_TABLE_100
590: , a10 out nocopy JTF_VARCHAR2_TABLE_100
591: , a11 out nocopy JTF_NUMBER_TABLE
592: , a12 out nocopy JTF_VARCHAR2_TABLE_100
593: , a13 out nocopy JTF_NUMBER_TABLE
586: , a6 out nocopy JTF_VARCHAR2_TABLE_100
587: , a7 out nocopy JTF_VARCHAR2_TABLE_100
588: , a8 out nocopy JTF_VARCHAR2_TABLE_300
589: , a9 out nocopy JTF_VARCHAR2_TABLE_100
590: , a10 out nocopy JTF_VARCHAR2_TABLE_100
591: , a11 out nocopy JTF_NUMBER_TABLE
592: , a12 out nocopy JTF_VARCHAR2_TABLE_100
593: , a13 out nocopy JTF_NUMBER_TABLE
594: ) as
588: , a8 out nocopy JTF_VARCHAR2_TABLE_300
589: , a9 out nocopy JTF_VARCHAR2_TABLE_100
590: , a10 out nocopy JTF_VARCHAR2_TABLE_100
591: , a11 out nocopy JTF_NUMBER_TABLE
592: , a12 out nocopy JTF_VARCHAR2_TABLE_100
593: , a13 out nocopy JTF_NUMBER_TABLE
594: ) as
595: ddindx binary_integer; indx binary_integer;
596: begin
595: ddindx binary_integer; indx binary_integer;
596: begin
597: if t is null or t.count = 0 then
598: a0 := JTF_NUMBER_TABLE();
599: a1 := JTF_VARCHAR2_TABLE_100();
600: a2 := JTF_VARCHAR2_TABLE_100();
601: a3 := JTF_NUMBER_TABLE();
602: a4 := JTF_VARCHAR2_TABLE_300();
603: a5 := JTF_VARCHAR2_TABLE_300();
596: begin
597: if t is null or t.count = 0 then
598: a0 := JTF_NUMBER_TABLE();
599: a1 := JTF_VARCHAR2_TABLE_100();
600: a2 := JTF_VARCHAR2_TABLE_100();
601: a3 := JTF_NUMBER_TABLE();
602: a4 := JTF_VARCHAR2_TABLE_300();
603: a5 := JTF_VARCHAR2_TABLE_300();
604: a6 := JTF_VARCHAR2_TABLE_100();
600: a2 := JTF_VARCHAR2_TABLE_100();
601: a3 := JTF_NUMBER_TABLE();
602: a4 := JTF_VARCHAR2_TABLE_300();
603: a5 := JTF_VARCHAR2_TABLE_300();
604: a6 := JTF_VARCHAR2_TABLE_100();
605: a7 := JTF_VARCHAR2_TABLE_100();
606: a8 := JTF_VARCHAR2_TABLE_300();
607: a9 := JTF_VARCHAR2_TABLE_100();
608: a10 := JTF_VARCHAR2_TABLE_100();
601: a3 := JTF_NUMBER_TABLE();
602: a4 := JTF_VARCHAR2_TABLE_300();
603: a5 := JTF_VARCHAR2_TABLE_300();
604: a6 := JTF_VARCHAR2_TABLE_100();
605: a7 := JTF_VARCHAR2_TABLE_100();
606: a8 := JTF_VARCHAR2_TABLE_300();
607: a9 := JTF_VARCHAR2_TABLE_100();
608: a10 := JTF_VARCHAR2_TABLE_100();
609: a11 := JTF_NUMBER_TABLE();
603: a5 := JTF_VARCHAR2_TABLE_300();
604: a6 := JTF_VARCHAR2_TABLE_100();
605: a7 := JTF_VARCHAR2_TABLE_100();
606: a8 := JTF_VARCHAR2_TABLE_300();
607: a9 := JTF_VARCHAR2_TABLE_100();
608: a10 := JTF_VARCHAR2_TABLE_100();
609: a11 := JTF_NUMBER_TABLE();
610: a12 := JTF_VARCHAR2_TABLE_100();
611: a13 := JTF_NUMBER_TABLE();
604: a6 := JTF_VARCHAR2_TABLE_100();
605: a7 := JTF_VARCHAR2_TABLE_100();
606: a8 := JTF_VARCHAR2_TABLE_300();
607: a9 := JTF_VARCHAR2_TABLE_100();
608: a10 := JTF_VARCHAR2_TABLE_100();
609: a11 := JTF_NUMBER_TABLE();
610: a12 := JTF_VARCHAR2_TABLE_100();
611: a13 := JTF_NUMBER_TABLE();
612: else
606: a8 := JTF_VARCHAR2_TABLE_300();
607: a9 := JTF_VARCHAR2_TABLE_100();
608: a10 := JTF_VARCHAR2_TABLE_100();
609: a11 := JTF_NUMBER_TABLE();
610: a12 := JTF_VARCHAR2_TABLE_100();
611: a13 := JTF_NUMBER_TABLE();
612: else
613: a0 := JTF_NUMBER_TABLE();
614: a1 := JTF_VARCHAR2_TABLE_100();
610: a12 := JTF_VARCHAR2_TABLE_100();
611: a13 := JTF_NUMBER_TABLE();
612: else
613: a0 := JTF_NUMBER_TABLE();
614: a1 := JTF_VARCHAR2_TABLE_100();
615: a2 := JTF_VARCHAR2_TABLE_100();
616: a3 := JTF_NUMBER_TABLE();
617: a4 := JTF_VARCHAR2_TABLE_300();
618: a5 := JTF_VARCHAR2_TABLE_300();
611: a13 := JTF_NUMBER_TABLE();
612: else
613: a0 := JTF_NUMBER_TABLE();
614: a1 := JTF_VARCHAR2_TABLE_100();
615: a2 := JTF_VARCHAR2_TABLE_100();
616: a3 := JTF_NUMBER_TABLE();
617: a4 := JTF_VARCHAR2_TABLE_300();
618: a5 := JTF_VARCHAR2_TABLE_300();
619: a6 := JTF_VARCHAR2_TABLE_100();
615: a2 := JTF_VARCHAR2_TABLE_100();
616: a3 := JTF_NUMBER_TABLE();
617: a4 := JTF_VARCHAR2_TABLE_300();
618: a5 := JTF_VARCHAR2_TABLE_300();
619: a6 := JTF_VARCHAR2_TABLE_100();
620: a7 := JTF_VARCHAR2_TABLE_100();
621: a8 := JTF_VARCHAR2_TABLE_300();
622: a9 := JTF_VARCHAR2_TABLE_100();
623: a10 := JTF_VARCHAR2_TABLE_100();
616: a3 := JTF_NUMBER_TABLE();
617: a4 := JTF_VARCHAR2_TABLE_300();
618: a5 := JTF_VARCHAR2_TABLE_300();
619: a6 := JTF_VARCHAR2_TABLE_100();
620: a7 := JTF_VARCHAR2_TABLE_100();
621: a8 := JTF_VARCHAR2_TABLE_300();
622: a9 := JTF_VARCHAR2_TABLE_100();
623: a10 := JTF_VARCHAR2_TABLE_100();
624: a11 := JTF_NUMBER_TABLE();
618: a5 := JTF_VARCHAR2_TABLE_300();
619: a6 := JTF_VARCHAR2_TABLE_100();
620: a7 := JTF_VARCHAR2_TABLE_100();
621: a8 := JTF_VARCHAR2_TABLE_300();
622: a9 := JTF_VARCHAR2_TABLE_100();
623: a10 := JTF_VARCHAR2_TABLE_100();
624: a11 := JTF_NUMBER_TABLE();
625: a12 := JTF_VARCHAR2_TABLE_100();
626: a13 := JTF_NUMBER_TABLE();
619: a6 := JTF_VARCHAR2_TABLE_100();
620: a7 := JTF_VARCHAR2_TABLE_100();
621: a8 := JTF_VARCHAR2_TABLE_300();
622: a9 := JTF_VARCHAR2_TABLE_100();
623: a10 := JTF_VARCHAR2_TABLE_100();
624: a11 := JTF_NUMBER_TABLE();
625: a12 := JTF_VARCHAR2_TABLE_100();
626: a13 := JTF_NUMBER_TABLE();
627: if t.count > 0 then
621: a8 := JTF_VARCHAR2_TABLE_300();
622: a9 := JTF_VARCHAR2_TABLE_100();
623: a10 := JTF_VARCHAR2_TABLE_100();
624: a11 := JTF_NUMBER_TABLE();
625: a12 := JTF_VARCHAR2_TABLE_100();
626: a13 := JTF_NUMBER_TABLE();
627: if t.count > 0 then
628: a0.extend(t.count);
629: a1.extend(t.count);
713: , p_validation_level NUMBER
714: , x_return_status out nocopy VARCHAR2
715: , x_msg_count out nocopy NUMBER
716: , x_msg_data out nocopy VARCHAR2
717: , p8_a0 JTF_VARCHAR2_TABLE_100
718: , p8_a1 JTF_DATE_TABLE
719: , p8_a2 JTF_NUMBER_TABLE
720: , p8_a3 JTF_NUMBER_TABLE
721: , p8_a4 JTF_NUMBER_TABLE
720: , p8_a3 JTF_NUMBER_TABLE
721: , p8_a4 JTF_NUMBER_TABLE
722: , p8_a5 JTF_NUMBER_TABLE
723: , p8_a6 JTF_DATE_TABLE
724: , p8_a7 JTF_VARCHAR2_TABLE_100
725: , p8_a8 JTF_VARCHAR2_TABLE_100
726: , p8_a9 JTF_NUMBER_TABLE
727: , p8_a10 JTF_NUMBER_TABLE
728: , p8_a11 JTF_NUMBER_TABLE
721: , p8_a4 JTF_NUMBER_TABLE
722: , p8_a5 JTF_NUMBER_TABLE
723: , p8_a6 JTF_DATE_TABLE
724: , p8_a7 JTF_VARCHAR2_TABLE_100
725: , p8_a8 JTF_VARCHAR2_TABLE_100
726: , p8_a9 JTF_NUMBER_TABLE
727: , p8_a10 JTF_NUMBER_TABLE
728: , p8_a11 JTF_NUMBER_TABLE
729: , p8_a12 JTF_NUMBER_TABLE
728: , p8_a11 JTF_NUMBER_TABLE
729: , p8_a12 JTF_NUMBER_TABLE
730: , p8_a13 JTF_VARCHAR2_TABLE_2000
731: , p8_a14 JTF_NUMBER_TABLE
732: , p8_a15 JTF_VARCHAR2_TABLE_100
733: , p8_a16 JTF_VARCHAR2_TABLE_300
734: , p8_a17 JTF_VARCHAR2_TABLE_300
735: , p8_a18 JTF_VARCHAR2_TABLE_300
736: , p8_a19 JTF_VARCHAR2_TABLE_300
745: , p8_a28 JTF_VARCHAR2_TABLE_300
746: , p8_a29 JTF_VARCHAR2_TABLE_300
747: , p8_a30 JTF_VARCHAR2_TABLE_300
748: , p9_a0 JTF_NUMBER_TABLE
749: , p9_a1 JTF_VARCHAR2_TABLE_100
750: , p9_a2 JTF_VARCHAR2_TABLE_100
751: , p9_a3 JTF_NUMBER_TABLE
752: , p9_a4 JTF_VARCHAR2_TABLE_300
753: , p9_a5 JTF_VARCHAR2_TABLE_300
746: , p8_a29 JTF_VARCHAR2_TABLE_300
747: , p8_a30 JTF_VARCHAR2_TABLE_300
748: , p9_a0 JTF_NUMBER_TABLE
749: , p9_a1 JTF_VARCHAR2_TABLE_100
750: , p9_a2 JTF_VARCHAR2_TABLE_100
751: , p9_a3 JTF_NUMBER_TABLE
752: , p9_a4 JTF_VARCHAR2_TABLE_300
753: , p9_a5 JTF_VARCHAR2_TABLE_300
754: , p9_a6 JTF_VARCHAR2_TABLE_100
750: , p9_a2 JTF_VARCHAR2_TABLE_100
751: , p9_a3 JTF_NUMBER_TABLE
752: , p9_a4 JTF_VARCHAR2_TABLE_300
753: , p9_a5 JTF_VARCHAR2_TABLE_300
754: , p9_a6 JTF_VARCHAR2_TABLE_100
755: , p9_a7 JTF_VARCHAR2_TABLE_100
756: , p9_a8 JTF_VARCHAR2_TABLE_300
757: , p9_a9 JTF_VARCHAR2_TABLE_100
758: , p9_a10 JTF_VARCHAR2_TABLE_100
751: , p9_a3 JTF_NUMBER_TABLE
752: , p9_a4 JTF_VARCHAR2_TABLE_300
753: , p9_a5 JTF_VARCHAR2_TABLE_300
754: , p9_a6 JTF_VARCHAR2_TABLE_100
755: , p9_a7 JTF_VARCHAR2_TABLE_100
756: , p9_a8 JTF_VARCHAR2_TABLE_300
757: , p9_a9 JTF_VARCHAR2_TABLE_100
758: , p9_a10 JTF_VARCHAR2_TABLE_100
759: , p9_a11 JTF_NUMBER_TABLE
753: , p9_a5 JTF_VARCHAR2_TABLE_300
754: , p9_a6 JTF_VARCHAR2_TABLE_100
755: , p9_a7 JTF_VARCHAR2_TABLE_100
756: , p9_a8 JTF_VARCHAR2_TABLE_300
757: , p9_a9 JTF_VARCHAR2_TABLE_100
758: , p9_a10 JTF_VARCHAR2_TABLE_100
759: , p9_a11 JTF_NUMBER_TABLE
760: , p9_a12 JTF_VARCHAR2_TABLE_100
761: , p9_a13 JTF_NUMBER_TABLE
754: , p9_a6 JTF_VARCHAR2_TABLE_100
755: , p9_a7 JTF_VARCHAR2_TABLE_100
756: , p9_a8 JTF_VARCHAR2_TABLE_300
757: , p9_a9 JTF_VARCHAR2_TABLE_100
758: , p9_a10 JTF_VARCHAR2_TABLE_100
759: , p9_a11 JTF_NUMBER_TABLE
760: , p9_a12 JTF_VARCHAR2_TABLE_100
761: , p9_a13 JTF_NUMBER_TABLE
762: , p10_a0 JTF_VARCHAR2_TABLE_100
756: , p9_a8 JTF_VARCHAR2_TABLE_300
757: , p9_a9 JTF_VARCHAR2_TABLE_100
758: , p9_a10 JTF_VARCHAR2_TABLE_100
759: , p9_a11 JTF_NUMBER_TABLE
760: , p9_a12 JTF_VARCHAR2_TABLE_100
761: , p9_a13 JTF_NUMBER_TABLE
762: , p10_a0 JTF_VARCHAR2_TABLE_100
763: , p10_a1 JTF_NUMBER_TABLE
764: , p10_a2 JTF_DATE_TABLE
758: , p9_a10 JTF_VARCHAR2_TABLE_100
759: , p9_a11 JTF_NUMBER_TABLE
760: , p9_a12 JTF_VARCHAR2_TABLE_100
761: , p9_a13 JTF_NUMBER_TABLE
762: , p10_a0 JTF_VARCHAR2_TABLE_100
763: , p10_a1 JTF_NUMBER_TABLE
764: , p10_a2 JTF_DATE_TABLE
765: , p10_a3 JTF_VARCHAR2_TABLE_100
766: , p10_a4 JTF_NUMBER_TABLE
761: , p9_a13 JTF_NUMBER_TABLE
762: , p10_a0 JTF_VARCHAR2_TABLE_100
763: , p10_a1 JTF_NUMBER_TABLE
764: , p10_a2 JTF_DATE_TABLE
765: , p10_a3 JTF_VARCHAR2_TABLE_100
766: , p10_a4 JTF_NUMBER_TABLE
767: , p10_a5 JTF_NUMBER_TABLE
768: , p10_a6 JTF_VARCHAR2_TABLE_100
769: , p10_a7 JTF_VARCHAR2_TABLE_300
764: , p10_a2 JTF_DATE_TABLE
765: , p10_a3 JTF_VARCHAR2_TABLE_100
766: , p10_a4 JTF_NUMBER_TABLE
767: , p10_a5 JTF_NUMBER_TABLE
768: , p10_a6 JTF_VARCHAR2_TABLE_100
769: , p10_a7 JTF_VARCHAR2_TABLE_300
770: , p10_a8 JTF_VARCHAR2_TABLE_300
771: , p10_a9 JTF_VARCHAR2_TABLE_100
772: , p10_a10 JTF_VARCHAR2_TABLE_100
767: , p10_a5 JTF_NUMBER_TABLE
768: , p10_a6 JTF_VARCHAR2_TABLE_100
769: , p10_a7 JTF_VARCHAR2_TABLE_300
770: , p10_a8 JTF_VARCHAR2_TABLE_300
771: , p10_a9 JTF_VARCHAR2_TABLE_100
772: , p10_a10 JTF_VARCHAR2_TABLE_100
773: , p10_a11 JTF_NUMBER_TABLE
774: , p10_a12 JTF_NUMBER_TABLE
775: , p10_a13 JTF_NUMBER_TABLE
768: , p10_a6 JTF_VARCHAR2_TABLE_100
769: , p10_a7 JTF_VARCHAR2_TABLE_300
770: , p10_a8 JTF_VARCHAR2_TABLE_300
771: , p10_a9 JTF_VARCHAR2_TABLE_100
772: , p10_a10 JTF_VARCHAR2_TABLE_100
773: , p10_a11 JTF_NUMBER_TABLE
774: , p10_a12 JTF_NUMBER_TABLE
775: , p10_a13 JTF_NUMBER_TABLE
776: , p10_a14 JTF_DATE_TABLE
773: , p10_a11 JTF_NUMBER_TABLE
774: , p10_a12 JTF_NUMBER_TABLE
775: , p10_a13 JTF_NUMBER_TABLE
776: , p10_a14 JTF_DATE_TABLE
777: , p10_a15 JTF_VARCHAR2_TABLE_100
778: , p10_a16 JTF_VARCHAR2_TABLE_100
779: , p10_a17 JTF_VARCHAR2_TABLE_300
780: , p10_a18 JTF_VARCHAR2_TABLE_300
781: , p10_a19 JTF_VARCHAR2_TABLE_300
774: , p10_a12 JTF_NUMBER_TABLE
775: , p10_a13 JTF_NUMBER_TABLE
776: , p10_a14 JTF_DATE_TABLE
777: , p10_a15 JTF_VARCHAR2_TABLE_100
778: , p10_a16 JTF_VARCHAR2_TABLE_100
779: , p10_a17 JTF_VARCHAR2_TABLE_300
780: , p10_a18 JTF_VARCHAR2_TABLE_300
781: , p10_a19 JTF_VARCHAR2_TABLE_300
782: , p10_a20 JTF_VARCHAR2_TABLE_300