11: end;
12:
13: procedure rosetta_table_copy_in_p3(t out nocopy ahl_di_doc_index_pub.document_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
12:
13: procedure rosetta_table_copy_in_p3(t out nocopy ahl_di_doc_index_pub.document_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
13: procedure rosetta_table_copy_in_p3(t out nocopy ahl_di_doc_index_pub.document_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_VARCHAR2_TABLE_100
29: , a16 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_VARCHAR2_TABLE_100
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_VARCHAR2_TABLE_100
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_NUMBER_TABLE
31: , a18 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_VARCHAR2_TABLE_100
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_NUMBER_TABLE
31: , a18 JTF_VARCHAR2_TABLE_100
32: , a19 JTF_VARCHAR2_TABLE_200
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_VARCHAR2_TABLE_100
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_NUMBER_TABLE
31: , a18 JTF_VARCHAR2_TABLE_100
32: , a19 JTF_VARCHAR2_TABLE_200
33: , a20 JTF_VARCHAR2_TABLE_200
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_VARCHAR2_TABLE_100
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_NUMBER_TABLE
31: , a18 JTF_VARCHAR2_TABLE_100
32: , a19 JTF_VARCHAR2_TABLE_200
33: , a20 JTF_VARCHAR2_TABLE_200
34: , a21 JTF_VARCHAR2_TABLE_200
35: , a22 JTF_VARCHAR2_TABLE_200
43: , a30 JTF_VARCHAR2_TABLE_200
44: , a31 JTF_VARCHAR2_TABLE_200
45: , a32 JTF_VARCHAR2_TABLE_200
46: , a33 JTF_VARCHAR2_TABLE_200
47: , a34 JTF_VARCHAR2_TABLE_100
48: , a35 JTF_VARCHAR2_TABLE_100
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
44: , a31 JTF_VARCHAR2_TABLE_200
45: , a32 JTF_VARCHAR2_TABLE_200
46: , a33 JTF_VARCHAR2_TABLE_200
47: , a34 JTF_VARCHAR2_TABLE_100
48: , a35 JTF_VARCHAR2_TABLE_100
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
52: if a0 is not null and a0.count > 0 then
100: end if;
101: end rosetta_table_copy_in_p3;
102: procedure rosetta_table_copy_out_p3(t ahl_di_doc_index_pub.document_tbl, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
101: end rosetta_table_copy_in_p3;
102: procedure rosetta_table_copy_out_p3(t ahl_di_doc_index_pub.document_tbl, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
102: procedure rosetta_table_copy_out_p3(t ahl_di_doc_index_pub.document_tbl, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_VARCHAR2_TABLE_100
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_VARCHAR2_TABLE_100
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_VARCHAR2_TABLE_100
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_VARCHAR2_TABLE_100
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_VARCHAR2_TABLE_100
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_VARCHAR2_TABLE_100
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_VARCHAR2_TABLE_100
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_VARCHAR2_TABLE_100
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_VARCHAR2_TABLE_100
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_VARCHAR2_TABLE_100
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_VARCHAR2_TABLE_100
116: , a14 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_VARCHAR2_TABLE_100
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_VARCHAR2_TABLE_100
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_VARCHAR2_TABLE_100
116: , a14 out nocopy JTF_VARCHAR2_TABLE_100
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_VARCHAR2_TABLE_100
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_VARCHAR2_TABLE_100
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_VARCHAR2_TABLE_100
116: , a14 out nocopy JTF_VARCHAR2_TABLE_100
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100
118: , a16 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_VARCHAR2_TABLE_100
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_VARCHAR2_TABLE_100
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_VARCHAR2_TABLE_100
116: , a14 out nocopy JTF_VARCHAR2_TABLE_100
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100
118: , a16 out nocopy JTF_VARCHAR2_TABLE_100
119: , a17 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_VARCHAR2_TABLE_100
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_VARCHAR2_TABLE_100
116: , a14 out nocopy JTF_VARCHAR2_TABLE_100
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100
118: , a16 out nocopy JTF_VARCHAR2_TABLE_100
119: , a17 out nocopy JTF_NUMBER_TABLE
120: , a18 out nocopy JTF_VARCHAR2_TABLE_100
113: , a11 out nocopy JTF_VARCHAR2_TABLE_100
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_VARCHAR2_TABLE_100
116: , a14 out nocopy JTF_VARCHAR2_TABLE_100
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100
118: , a16 out nocopy JTF_VARCHAR2_TABLE_100
119: , a17 out nocopy JTF_NUMBER_TABLE
120: , a18 out nocopy JTF_VARCHAR2_TABLE_100
121: , a19 out nocopy JTF_VARCHAR2_TABLE_200
114: , a12 out nocopy JTF_VARCHAR2_TABLE_100
115: , a13 out nocopy JTF_VARCHAR2_TABLE_100
116: , a14 out nocopy JTF_VARCHAR2_TABLE_100
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100
118: , a16 out nocopy JTF_VARCHAR2_TABLE_100
119: , a17 out nocopy JTF_NUMBER_TABLE
120: , a18 out nocopy JTF_VARCHAR2_TABLE_100
121: , a19 out nocopy JTF_VARCHAR2_TABLE_200
122: , a20 out nocopy JTF_VARCHAR2_TABLE_200
116: , a14 out nocopy JTF_VARCHAR2_TABLE_100
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100
118: , a16 out nocopy JTF_VARCHAR2_TABLE_100
119: , a17 out nocopy JTF_NUMBER_TABLE
120: , a18 out nocopy JTF_VARCHAR2_TABLE_100
121: , a19 out nocopy JTF_VARCHAR2_TABLE_200
122: , a20 out nocopy JTF_VARCHAR2_TABLE_200
123: , a21 out nocopy JTF_VARCHAR2_TABLE_200
124: , a22 out nocopy JTF_VARCHAR2_TABLE_200
132: , a30 out nocopy JTF_VARCHAR2_TABLE_200
133: , a31 out nocopy JTF_VARCHAR2_TABLE_200
134: , a32 out nocopy JTF_VARCHAR2_TABLE_200
135: , a33 out nocopy JTF_VARCHAR2_TABLE_200
136: , a34 out nocopy JTF_VARCHAR2_TABLE_100
137: , a35 out nocopy JTF_VARCHAR2_TABLE_100
138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin
133: , a31 out nocopy JTF_VARCHAR2_TABLE_200
134: , a32 out nocopy JTF_VARCHAR2_TABLE_200
135: , a33 out nocopy JTF_VARCHAR2_TABLE_200
136: , a34 out nocopy JTF_VARCHAR2_TABLE_100
137: , a35 out nocopy JTF_VARCHAR2_TABLE_100
138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin
141: if t is null or t.count = 0 then
140: begin
141: if t is null or t.count = 0 then
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_VARCHAR2_TABLE_100();
145: a3 := JTF_VARCHAR2_TABLE_100();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_VARCHAR2_TABLE_100();
141: if t is null or t.count = 0 then
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_VARCHAR2_TABLE_100();
145: a3 := JTF_VARCHAR2_TABLE_100();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_VARCHAR2_TABLE_100();
149: a7 := JTF_VARCHAR2_TABLE_100();
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_VARCHAR2_TABLE_100();
145: a3 := JTF_VARCHAR2_TABLE_100();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_VARCHAR2_TABLE_100();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_VARCHAR2_TABLE_100();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_VARCHAR2_TABLE_100();
145: a3 := JTF_VARCHAR2_TABLE_100();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_VARCHAR2_TABLE_100();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_100();
144: a2 := JTF_VARCHAR2_TABLE_100();
145: a3 := JTF_VARCHAR2_TABLE_100();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_VARCHAR2_TABLE_100();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_100();
152: a10 := JTF_VARCHAR2_TABLE_100();
145: a3 := JTF_VARCHAR2_TABLE_100();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_VARCHAR2_TABLE_100();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_100();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_VARCHAR2_TABLE_100();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_100();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_VARCHAR2_TABLE_100();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_100();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_VARCHAR2_TABLE_100();
155: a13 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_VARCHAR2_TABLE_100();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_100();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_VARCHAR2_TABLE_100();
155: a13 := JTF_VARCHAR2_TABLE_100();
156: a14 := JTF_VARCHAR2_TABLE_100();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_100();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_VARCHAR2_TABLE_100();
155: a13 := JTF_VARCHAR2_TABLE_100();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_100();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_VARCHAR2_TABLE_100();
155: a13 := JTF_VARCHAR2_TABLE_100();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
158: a16 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_100();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_VARCHAR2_TABLE_100();
155: a13 := JTF_VARCHAR2_TABLE_100();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
158: a16 := JTF_VARCHAR2_TABLE_100();
159: a17 := JTF_NUMBER_TABLE();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_VARCHAR2_TABLE_100();
155: a13 := JTF_VARCHAR2_TABLE_100();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
158: a16 := JTF_VARCHAR2_TABLE_100();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_VARCHAR2_TABLE_100();
155: a13 := JTF_VARCHAR2_TABLE_100();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
158: a16 := JTF_VARCHAR2_TABLE_100();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_VARCHAR2_TABLE_100();
161: a19 := JTF_VARCHAR2_TABLE_200();
154: a12 := JTF_VARCHAR2_TABLE_100();
155: a13 := JTF_VARCHAR2_TABLE_100();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
158: a16 := JTF_VARCHAR2_TABLE_100();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_VARCHAR2_TABLE_100();
161: a19 := JTF_VARCHAR2_TABLE_200();
162: a20 := JTF_VARCHAR2_TABLE_200();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
158: a16 := JTF_VARCHAR2_TABLE_100();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_VARCHAR2_TABLE_100();
161: a19 := JTF_VARCHAR2_TABLE_200();
162: a20 := JTF_VARCHAR2_TABLE_200();
163: a21 := JTF_VARCHAR2_TABLE_200();
164: a22 := JTF_VARCHAR2_TABLE_200();
172: a30 := JTF_VARCHAR2_TABLE_200();
173: a31 := JTF_VARCHAR2_TABLE_200();
174: a32 := JTF_VARCHAR2_TABLE_200();
175: a33 := JTF_VARCHAR2_TABLE_200();
176: a34 := JTF_VARCHAR2_TABLE_100();
177: a35 := JTF_VARCHAR2_TABLE_100();
178: else
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_NUMBER_TABLE();
173: a31 := JTF_VARCHAR2_TABLE_200();
174: a32 := JTF_VARCHAR2_TABLE_200();
175: a33 := JTF_VARCHAR2_TABLE_200();
176: a34 := JTF_VARCHAR2_TABLE_100();
177: a35 := JTF_VARCHAR2_TABLE_100();
178: else
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_NUMBER_TABLE();
181: a2 := JTF_VARCHAR2_TABLE_100();
177: a35 := JTF_VARCHAR2_TABLE_100();
178: else
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_NUMBER_TABLE();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_100();
184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
178: else
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_NUMBER_TABLE();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_100();
184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_NUMBER_TABLE();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_100();
184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_100();
180: a1 := JTF_NUMBER_TABLE();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_100();
184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_100();
188: a9 := JTF_VARCHAR2_TABLE_100();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_100();
184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_100();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_100();
184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_100();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_100();
184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_100();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_100();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: a13 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_100();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: a14 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_100();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: a14 := JTF_VARCHAR2_TABLE_100();
194: a15 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_100();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: a14 := JTF_VARCHAR2_TABLE_100();
194: a15 := JTF_VARCHAR2_TABLE_100();
195: a16 := JTF_VARCHAR2_TABLE_100();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: a14 := JTF_VARCHAR2_TABLE_100();
194: a15 := JTF_VARCHAR2_TABLE_100();
195: a16 := JTF_VARCHAR2_TABLE_100();
196: a17 := JTF_NUMBER_TABLE();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: a14 := JTF_VARCHAR2_TABLE_100();
194: a15 := JTF_VARCHAR2_TABLE_100();
195: a16 := JTF_VARCHAR2_TABLE_100();
196: a17 := JTF_NUMBER_TABLE();
197: a18 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: a14 := JTF_VARCHAR2_TABLE_100();
194: a15 := JTF_VARCHAR2_TABLE_100();
195: a16 := JTF_VARCHAR2_TABLE_100();
196: a17 := JTF_NUMBER_TABLE();
197: a18 := JTF_VARCHAR2_TABLE_100();
198: a19 := JTF_VARCHAR2_TABLE_200();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: a14 := JTF_VARCHAR2_TABLE_100();
194: a15 := JTF_VARCHAR2_TABLE_100();
195: a16 := JTF_VARCHAR2_TABLE_100();
196: a17 := JTF_NUMBER_TABLE();
197: a18 := JTF_VARCHAR2_TABLE_100();
198: a19 := JTF_VARCHAR2_TABLE_200();
199: a20 := JTF_VARCHAR2_TABLE_200();
193: a14 := JTF_VARCHAR2_TABLE_100();
194: a15 := JTF_VARCHAR2_TABLE_100();
195: a16 := JTF_VARCHAR2_TABLE_100();
196: a17 := JTF_NUMBER_TABLE();
197: a18 := JTF_VARCHAR2_TABLE_100();
198: a19 := JTF_VARCHAR2_TABLE_200();
199: a20 := JTF_VARCHAR2_TABLE_200();
200: a21 := JTF_VARCHAR2_TABLE_200();
201: a22 := JTF_VARCHAR2_TABLE_200();
209: a30 := JTF_VARCHAR2_TABLE_200();
210: a31 := JTF_VARCHAR2_TABLE_200();
211: a32 := JTF_VARCHAR2_TABLE_200();
212: a33 := JTF_VARCHAR2_TABLE_200();
213: a34 := JTF_VARCHAR2_TABLE_100();
214: a35 := JTF_VARCHAR2_TABLE_100();
215: if t.count > 0 then
216: a0.extend(t.count);
217: a1.extend(t.count);
210: a31 := JTF_VARCHAR2_TABLE_200();
211: a32 := JTF_VARCHAR2_TABLE_200();
212: a33 := JTF_VARCHAR2_TABLE_200();
213: a34 := JTF_VARCHAR2_TABLE_100();
214: a35 := JTF_VARCHAR2_TABLE_100();
215: if t.count > 0 then
216: a0.extend(t.count);
217: a1.extend(t.count);
218: a2.extend(t.count);
299: end rosetta_table_copy_out_p3;
300:
301: procedure rosetta_table_copy_in_p4(t out nocopy ahl_di_doc_index_pub.supplier_tbl, a0 JTF_NUMBER_TABLE
302: , a1 JTF_NUMBER_TABLE
303: , a2 JTF_VARCHAR2_TABLE_100
304: , a3 JTF_NUMBER_TABLE
305: , a4 JTF_VARCHAR2_TABLE_100
306: , a5 JTF_VARCHAR2_TABLE_100
307: , a6 JTF_NUMBER_TABLE
301: procedure rosetta_table_copy_in_p4(t out nocopy ahl_di_doc_index_pub.supplier_tbl, a0 JTF_NUMBER_TABLE
302: , a1 JTF_NUMBER_TABLE
303: , a2 JTF_VARCHAR2_TABLE_100
304: , a3 JTF_NUMBER_TABLE
305: , a4 JTF_VARCHAR2_TABLE_100
306: , a5 JTF_VARCHAR2_TABLE_100
307: , a6 JTF_NUMBER_TABLE
308: , a7 JTF_VARCHAR2_TABLE_100
309: , a8 JTF_VARCHAR2_TABLE_200
302: , a1 JTF_NUMBER_TABLE
303: , a2 JTF_VARCHAR2_TABLE_100
304: , a3 JTF_NUMBER_TABLE
305: , a4 JTF_VARCHAR2_TABLE_100
306: , a5 JTF_VARCHAR2_TABLE_100
307: , a6 JTF_NUMBER_TABLE
308: , a7 JTF_VARCHAR2_TABLE_100
309: , a8 JTF_VARCHAR2_TABLE_200
310: , a9 JTF_VARCHAR2_TABLE_200
304: , a3 JTF_NUMBER_TABLE
305: , a4 JTF_VARCHAR2_TABLE_100
306: , a5 JTF_VARCHAR2_TABLE_100
307: , a6 JTF_NUMBER_TABLE
308: , a7 JTF_VARCHAR2_TABLE_100
309: , a8 JTF_VARCHAR2_TABLE_200
310: , a9 JTF_VARCHAR2_TABLE_200
311: , a10 JTF_VARCHAR2_TABLE_200
312: , a11 JTF_VARCHAR2_TABLE_200
320: , a19 JTF_VARCHAR2_TABLE_200
321: , a20 JTF_VARCHAR2_TABLE_200
322: , a21 JTF_VARCHAR2_TABLE_200
323: , a22 JTF_VARCHAR2_TABLE_200
324: , a23 JTF_VARCHAR2_TABLE_100
325: ) as
326: ddindx binary_integer; indx binary_integer;
327: begin
328: if a0 is not null and a0.count > 0 then
364: end if;
365: end rosetta_table_copy_in_p4;
366: procedure rosetta_table_copy_out_p4(t ahl_di_doc_index_pub.supplier_tbl, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_NUMBER_TABLE
370: , a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , a6 out nocopy JTF_NUMBER_TABLE
366: procedure rosetta_table_copy_out_p4(t ahl_di_doc_index_pub.supplier_tbl, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_NUMBER_TABLE
370: , a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , a6 out nocopy JTF_NUMBER_TABLE
373: , a7 out nocopy JTF_VARCHAR2_TABLE_100
374: , a8 out nocopy JTF_VARCHAR2_TABLE_200
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_NUMBER_TABLE
370: , a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , a6 out nocopy JTF_NUMBER_TABLE
373: , a7 out nocopy JTF_VARCHAR2_TABLE_100
374: , a8 out nocopy JTF_VARCHAR2_TABLE_200
375: , a9 out nocopy JTF_VARCHAR2_TABLE_200
369: , a3 out nocopy JTF_NUMBER_TABLE
370: , a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , a6 out nocopy JTF_NUMBER_TABLE
373: , a7 out nocopy JTF_VARCHAR2_TABLE_100
374: , a8 out nocopy JTF_VARCHAR2_TABLE_200
375: , a9 out nocopy JTF_VARCHAR2_TABLE_200
376: , a10 out nocopy JTF_VARCHAR2_TABLE_200
377: , a11 out nocopy JTF_VARCHAR2_TABLE_200
385: , a19 out nocopy JTF_VARCHAR2_TABLE_200
386: , a20 out nocopy JTF_VARCHAR2_TABLE_200
387: , a21 out nocopy JTF_VARCHAR2_TABLE_200
388: , a22 out nocopy JTF_VARCHAR2_TABLE_200
389: , a23 out nocopy JTF_VARCHAR2_TABLE_100
390: ) as
391: ddindx binary_integer; indx binary_integer;
392: begin
393: if t is null or t.count = 0 then
392: begin
393: if t is null or t.count = 0 then
394: a0 := JTF_NUMBER_TABLE();
395: a1 := JTF_NUMBER_TABLE();
396: a2 := JTF_VARCHAR2_TABLE_100();
397: a3 := JTF_NUMBER_TABLE();
398: a4 := JTF_VARCHAR2_TABLE_100();
399: a5 := JTF_VARCHAR2_TABLE_100();
400: a6 := JTF_NUMBER_TABLE();
394: a0 := JTF_NUMBER_TABLE();
395: a1 := JTF_NUMBER_TABLE();
396: a2 := JTF_VARCHAR2_TABLE_100();
397: a3 := JTF_NUMBER_TABLE();
398: a4 := JTF_VARCHAR2_TABLE_100();
399: a5 := JTF_VARCHAR2_TABLE_100();
400: a6 := JTF_NUMBER_TABLE();
401: a7 := JTF_VARCHAR2_TABLE_100();
402: a8 := JTF_VARCHAR2_TABLE_200();
395: a1 := JTF_NUMBER_TABLE();
396: a2 := JTF_VARCHAR2_TABLE_100();
397: a3 := JTF_NUMBER_TABLE();
398: a4 := JTF_VARCHAR2_TABLE_100();
399: a5 := JTF_VARCHAR2_TABLE_100();
400: a6 := JTF_NUMBER_TABLE();
401: a7 := JTF_VARCHAR2_TABLE_100();
402: a8 := JTF_VARCHAR2_TABLE_200();
403: a9 := JTF_VARCHAR2_TABLE_200();
397: a3 := JTF_NUMBER_TABLE();
398: a4 := JTF_VARCHAR2_TABLE_100();
399: a5 := JTF_VARCHAR2_TABLE_100();
400: a6 := JTF_NUMBER_TABLE();
401: a7 := JTF_VARCHAR2_TABLE_100();
402: a8 := JTF_VARCHAR2_TABLE_200();
403: a9 := JTF_VARCHAR2_TABLE_200();
404: a10 := JTF_VARCHAR2_TABLE_200();
405: a11 := JTF_VARCHAR2_TABLE_200();
413: a19 := JTF_VARCHAR2_TABLE_200();
414: a20 := JTF_VARCHAR2_TABLE_200();
415: a21 := JTF_VARCHAR2_TABLE_200();
416: a22 := JTF_VARCHAR2_TABLE_200();
417: a23 := JTF_VARCHAR2_TABLE_100();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
417: a23 := JTF_VARCHAR2_TABLE_100();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();
424: a5 := JTF_VARCHAR2_TABLE_100();
425: a6 := JTF_NUMBER_TABLE();
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();
424: a5 := JTF_VARCHAR2_TABLE_100();
425: a6 := JTF_NUMBER_TABLE();
426: a7 := JTF_VARCHAR2_TABLE_100();
427: a8 := JTF_VARCHAR2_TABLE_200();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();
424: a5 := JTF_VARCHAR2_TABLE_100();
425: a6 := JTF_NUMBER_TABLE();
426: a7 := JTF_VARCHAR2_TABLE_100();
427: a8 := JTF_VARCHAR2_TABLE_200();
428: a9 := JTF_VARCHAR2_TABLE_200();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_VARCHAR2_TABLE_100();
424: a5 := JTF_VARCHAR2_TABLE_100();
425: a6 := JTF_NUMBER_TABLE();
426: a7 := JTF_VARCHAR2_TABLE_100();
427: a8 := JTF_VARCHAR2_TABLE_200();
428: a9 := JTF_VARCHAR2_TABLE_200();
429: a10 := JTF_VARCHAR2_TABLE_200();
430: a11 := JTF_VARCHAR2_TABLE_200();
438: a19 := JTF_VARCHAR2_TABLE_200();
439: a20 := JTF_VARCHAR2_TABLE_200();
440: a21 := JTF_VARCHAR2_TABLE_200();
441: a22 := JTF_VARCHAR2_TABLE_200();
442: a23 := JTF_VARCHAR2_TABLE_100();
443: if t.count > 0 then
444: a0.extend(t.count);
445: a1.extend(t.count);
446: a2.extend(t.count);
503: end rosetta_table_copy_out_p4;
504:
505: procedure rosetta_table_copy_in_p5(t out nocopy ahl_di_doc_index_pub.recipient_tbl, a0 JTF_NUMBER_TABLE
506: , a1 JTF_NUMBER_TABLE
507: , a2 JTF_VARCHAR2_TABLE_100
508: , a3 JTF_NUMBER_TABLE
509: , a4 JTF_NUMBER_TABLE
510: , a5 JTF_VARCHAR2_TABLE_100
511: , a6 JTF_VARCHAR2_TABLE_200
506: , a1 JTF_NUMBER_TABLE
507: , a2 JTF_VARCHAR2_TABLE_100
508: , a3 JTF_NUMBER_TABLE
509: , a4 JTF_NUMBER_TABLE
510: , a5 JTF_VARCHAR2_TABLE_100
511: , a6 JTF_VARCHAR2_TABLE_200
512: , a7 JTF_VARCHAR2_TABLE_200
513: , a8 JTF_VARCHAR2_TABLE_200
514: , a9 JTF_VARCHAR2_TABLE_200
522: , a17 JTF_VARCHAR2_TABLE_200
523: , a18 JTF_VARCHAR2_TABLE_200
524: , a19 JTF_VARCHAR2_TABLE_200
525: , a20 JTF_VARCHAR2_TABLE_200
526: , a21 JTF_VARCHAR2_TABLE_100
527: ) as
528: ddindx binary_integer; indx binary_integer;
529: begin
530: if a0 is not null and a0.count > 0 then
564: end if;
565: end rosetta_table_copy_in_p5;
566: procedure rosetta_table_copy_out_p5(t ahl_di_doc_index_pub.recipient_tbl, a0 out nocopy JTF_NUMBER_TABLE
567: , a1 out nocopy JTF_NUMBER_TABLE
568: , a2 out nocopy JTF_VARCHAR2_TABLE_100
569: , a3 out nocopy JTF_NUMBER_TABLE
570: , a4 out nocopy JTF_NUMBER_TABLE
571: , a5 out nocopy JTF_VARCHAR2_TABLE_100
572: , a6 out nocopy JTF_VARCHAR2_TABLE_200
567: , a1 out nocopy JTF_NUMBER_TABLE
568: , a2 out nocopy JTF_VARCHAR2_TABLE_100
569: , a3 out nocopy JTF_NUMBER_TABLE
570: , a4 out nocopy JTF_NUMBER_TABLE
571: , a5 out nocopy JTF_VARCHAR2_TABLE_100
572: , a6 out nocopy JTF_VARCHAR2_TABLE_200
573: , a7 out nocopy JTF_VARCHAR2_TABLE_200
574: , a8 out nocopy JTF_VARCHAR2_TABLE_200
575: , a9 out nocopy JTF_VARCHAR2_TABLE_200
583: , a17 out nocopy JTF_VARCHAR2_TABLE_200
584: , a18 out nocopy JTF_VARCHAR2_TABLE_200
585: , a19 out nocopy JTF_VARCHAR2_TABLE_200
586: , a20 out nocopy JTF_VARCHAR2_TABLE_200
587: , a21 out nocopy JTF_VARCHAR2_TABLE_100
588: ) as
589: ddindx binary_integer; indx binary_integer;
590: begin
591: if t is null or t.count = 0 then
590: begin
591: if t is null or t.count = 0 then
592: a0 := JTF_NUMBER_TABLE();
593: a1 := JTF_NUMBER_TABLE();
594: a2 := JTF_VARCHAR2_TABLE_100();
595: a3 := JTF_NUMBER_TABLE();
596: a4 := JTF_NUMBER_TABLE();
597: a5 := JTF_VARCHAR2_TABLE_100();
598: a6 := JTF_VARCHAR2_TABLE_200();
593: a1 := JTF_NUMBER_TABLE();
594: a2 := JTF_VARCHAR2_TABLE_100();
595: a3 := JTF_NUMBER_TABLE();
596: a4 := JTF_NUMBER_TABLE();
597: a5 := JTF_VARCHAR2_TABLE_100();
598: a6 := JTF_VARCHAR2_TABLE_200();
599: a7 := JTF_VARCHAR2_TABLE_200();
600: a8 := JTF_VARCHAR2_TABLE_200();
601: a9 := JTF_VARCHAR2_TABLE_200();
609: a17 := JTF_VARCHAR2_TABLE_200();
610: a18 := JTF_VARCHAR2_TABLE_200();
611: a19 := JTF_VARCHAR2_TABLE_200();
612: a20 := JTF_VARCHAR2_TABLE_200();
613: a21 := JTF_VARCHAR2_TABLE_100();
614: else
615: a0 := JTF_NUMBER_TABLE();
616: a1 := JTF_NUMBER_TABLE();
617: a2 := JTF_VARCHAR2_TABLE_100();
613: a21 := JTF_VARCHAR2_TABLE_100();
614: else
615: a0 := JTF_NUMBER_TABLE();
616: a1 := JTF_NUMBER_TABLE();
617: a2 := JTF_VARCHAR2_TABLE_100();
618: a3 := JTF_NUMBER_TABLE();
619: a4 := JTF_NUMBER_TABLE();
620: a5 := JTF_VARCHAR2_TABLE_100();
621: a6 := JTF_VARCHAR2_TABLE_200();
616: a1 := JTF_NUMBER_TABLE();
617: a2 := JTF_VARCHAR2_TABLE_100();
618: a3 := JTF_NUMBER_TABLE();
619: a4 := JTF_NUMBER_TABLE();
620: a5 := JTF_VARCHAR2_TABLE_100();
621: a6 := JTF_VARCHAR2_TABLE_200();
622: a7 := JTF_VARCHAR2_TABLE_200();
623: a8 := JTF_VARCHAR2_TABLE_200();
624: a9 := JTF_VARCHAR2_TABLE_200();
632: a17 := JTF_VARCHAR2_TABLE_200();
633: a18 := JTF_VARCHAR2_TABLE_200();
634: a19 := JTF_VARCHAR2_TABLE_200();
635: a20 := JTF_VARCHAR2_TABLE_200();
636: a21 := JTF_VARCHAR2_TABLE_100();
637: if t.count > 0 then
638: a0.extend(t.count);
639: a1.extend(t.count);
640: a2.extend(t.count);
698: , p_validate_only VARCHAR2
699: , p_validation_level NUMBER
700: , p5_a0 in out nocopy JTF_NUMBER_TABLE
701: , p5_a1 in out nocopy JTF_NUMBER_TABLE
702: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
704: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p_validation_level NUMBER
700: , p5_a0 in out nocopy JTF_NUMBER_TABLE
701: , p5_a1 in out nocopy JTF_NUMBER_TABLE
702: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
704: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
700: , p5_a0 in out nocopy JTF_NUMBER_TABLE
701: , p5_a1 in out nocopy JTF_NUMBER_TABLE
702: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
704: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p5_a1 in out nocopy JTF_NUMBER_TABLE
702: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
704: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
702: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
704: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
704: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
704: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
712: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
712: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
713: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
712: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
713: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
714: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
707: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
712: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
713: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
714: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
715: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
712: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
713: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
714: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
715: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
712: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
713: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
714: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
715: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
717: , p5_a17 in out nocopy JTF_NUMBER_TABLE
710: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
712: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
713: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
714: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
715: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
717: , p5_a17 in out nocopy JTF_NUMBER_TABLE
718: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
712: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
713: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
714: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
715: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
717: , p5_a17 in out nocopy JTF_NUMBER_TABLE
718: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
719: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
712: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
713: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
714: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
715: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
717: , p5_a17 in out nocopy JTF_NUMBER_TABLE
718: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
719: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
720: , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
714: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
715: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
717: , p5_a17 in out nocopy JTF_NUMBER_TABLE
718: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
719: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
720: , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
721: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
722: , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
730: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_200
731: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_200
732: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_200
733: , p5_a33 in out nocopy JTF_VARCHAR2_TABLE_200
734: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
735: , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_100
736: , p6_a0 in out nocopy JTF_NUMBER_TABLE
737: , p6_a1 in out nocopy JTF_NUMBER_TABLE
738: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
731: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_200
732: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_200
733: , p5_a33 in out nocopy JTF_VARCHAR2_TABLE_200
734: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
735: , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_100
736: , p6_a0 in out nocopy JTF_NUMBER_TABLE
737: , p6_a1 in out nocopy JTF_NUMBER_TABLE
738: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a3 in out nocopy JTF_NUMBER_TABLE
734: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
735: , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_100
736: , p6_a0 in out nocopy JTF_NUMBER_TABLE
737: , p6_a1 in out nocopy JTF_NUMBER_TABLE
738: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a3 in out nocopy JTF_NUMBER_TABLE
740: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a6 in out nocopy JTF_NUMBER_TABLE
736: , p6_a0 in out nocopy JTF_NUMBER_TABLE
737: , p6_a1 in out nocopy JTF_NUMBER_TABLE
738: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a3 in out nocopy JTF_NUMBER_TABLE
740: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a6 in out nocopy JTF_NUMBER_TABLE
743: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_200
737: , p6_a1 in out nocopy JTF_NUMBER_TABLE
738: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a3 in out nocopy JTF_NUMBER_TABLE
740: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a6 in out nocopy JTF_NUMBER_TABLE
743: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_200
745: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_200
739: , p6_a3 in out nocopy JTF_NUMBER_TABLE
740: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a6 in out nocopy JTF_NUMBER_TABLE
743: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_200
745: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_200
746: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_200
747: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
755: , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
756: , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
757: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
758: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
759: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_100
760: , p7_a0 in out nocopy JTF_NUMBER_TABLE
761: , p7_a1 in out nocopy JTF_NUMBER_TABLE
762: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
763: , p7_a3 in out nocopy JTF_NUMBER_TABLE
758: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
759: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_100
760: , p7_a0 in out nocopy JTF_NUMBER_TABLE
761: , p7_a1 in out nocopy JTF_NUMBER_TABLE
762: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
763: , p7_a3 in out nocopy JTF_NUMBER_TABLE
764: , p7_a4 in out nocopy JTF_NUMBER_TABLE
765: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
766: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_200
761: , p7_a1 in out nocopy JTF_NUMBER_TABLE
762: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
763: , p7_a3 in out nocopy JTF_NUMBER_TABLE
764: , p7_a4 in out nocopy JTF_NUMBER_TABLE
765: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
766: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_200
767: , p7_a7 in out nocopy JTF_VARCHAR2_TABLE_200
768: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_200
769: , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_200
777: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
778: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
779: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
780: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
781: , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_100
782: , p_module_type VARCHAR2
783: , x_return_status out nocopy VARCHAR2
784: , x_msg_count out nocopy NUMBER
785: , x_msg_data out nocopy VARCHAR2
1009: , p_validate_only VARCHAR2
1010: , p_validation_level NUMBER
1011: , p5_a0 in out nocopy JTF_NUMBER_TABLE
1012: , p5_a1 in out nocopy JTF_NUMBER_TABLE
1013: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1015: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1016: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1017: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1010: , p_validation_level NUMBER
1011: , p5_a0 in out nocopy JTF_NUMBER_TABLE
1012: , p5_a1 in out nocopy JTF_NUMBER_TABLE
1013: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1015: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1016: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1017: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1018: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1011: , p5_a0 in out nocopy JTF_NUMBER_TABLE
1012: , p5_a1 in out nocopy JTF_NUMBER_TABLE
1013: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1015: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1016: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1017: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1018: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1019: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1012: , p5_a1 in out nocopy JTF_NUMBER_TABLE
1013: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1015: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1016: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1017: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1018: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1019: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1020: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1013: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1015: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1016: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1017: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1018: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1019: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1020: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1021: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1015: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1016: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1017: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1018: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1019: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1020: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1021: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1022: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1015: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1016: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1017: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1018: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1019: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1020: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1021: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1022: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1023: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1016: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1017: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1018: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1019: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1020: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1021: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1022: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1023: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1024: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1017: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1018: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1019: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1020: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1021: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1022: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1023: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1024: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1025: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1018: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1019: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1020: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1021: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1022: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1023: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1024: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1025: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1026: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1019: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1020: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1021: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1022: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1023: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1024: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1025: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1026: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1020: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1021: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1022: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1023: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1024: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1025: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1026: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a17 in out nocopy JTF_NUMBER_TABLE
1021: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1022: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1023: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1024: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1025: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1026: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a17 in out nocopy JTF_NUMBER_TABLE
1029: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1022: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1023: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1024: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1025: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1026: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a17 in out nocopy JTF_NUMBER_TABLE
1029: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1030: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1023: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1024: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1025: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1026: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a17 in out nocopy JTF_NUMBER_TABLE
1029: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1030: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1031: , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1025: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1026: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a17 in out nocopy JTF_NUMBER_TABLE
1029: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1030: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1031: , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1032: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
1033: , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1041: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_200
1042: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_200
1043: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_200
1044: , p5_a33 in out nocopy JTF_VARCHAR2_TABLE_200
1045: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1046: , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1047: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1048: , p6_a1 in out nocopy JTF_NUMBER_TABLE
1049: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1042: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_200
1043: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_200
1044: , p5_a33 in out nocopy JTF_VARCHAR2_TABLE_200
1045: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1046: , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1047: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1048: , p6_a1 in out nocopy JTF_NUMBER_TABLE
1049: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1050: , p6_a3 in out nocopy JTF_NUMBER_TABLE
1045: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1046: , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1047: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1048: , p6_a1 in out nocopy JTF_NUMBER_TABLE
1049: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1050: , p6_a3 in out nocopy JTF_NUMBER_TABLE
1051: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1052: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1053: , p6_a6 in out nocopy JTF_NUMBER_TABLE
1047: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1048: , p6_a1 in out nocopy JTF_NUMBER_TABLE
1049: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1050: , p6_a3 in out nocopy JTF_NUMBER_TABLE
1051: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1052: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1053: , p6_a6 in out nocopy JTF_NUMBER_TABLE
1054: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1055: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_200
1048: , p6_a1 in out nocopy JTF_NUMBER_TABLE
1049: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1050: , p6_a3 in out nocopy JTF_NUMBER_TABLE
1051: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1052: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1053: , p6_a6 in out nocopy JTF_NUMBER_TABLE
1054: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1055: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_200
1056: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_200
1050: , p6_a3 in out nocopy JTF_NUMBER_TABLE
1051: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1052: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1053: , p6_a6 in out nocopy JTF_NUMBER_TABLE
1054: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1055: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_200
1056: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_200
1057: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_200
1058: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
1066: , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1067: , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1068: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
1069: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1070: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_100
1071: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1072: , p7_a1 in out nocopy JTF_NUMBER_TABLE
1073: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1074: , p7_a3 in out nocopy JTF_NUMBER_TABLE
1069: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1070: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_100
1071: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1072: , p7_a1 in out nocopy JTF_NUMBER_TABLE
1073: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1074: , p7_a3 in out nocopy JTF_NUMBER_TABLE
1075: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1076: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1077: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_200
1072: , p7_a1 in out nocopy JTF_NUMBER_TABLE
1073: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1074: , p7_a3 in out nocopy JTF_NUMBER_TABLE
1075: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1076: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1077: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_200
1078: , p7_a7 in out nocopy JTF_VARCHAR2_TABLE_200
1079: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_200
1080: , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_200
1088: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1089: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1090: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1091: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1092: , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1093: , p_module_type VARCHAR2
1094: , x_return_status out nocopy VARCHAR2
1095: , x_msg_count out nocopy NUMBER
1096: , x_msg_data out nocopy VARCHAR2