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_gtp_pvt.gtp_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_100
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtp_pvt.gtp_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: ) as
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: ) as
38: ddindx binary_integer; indx binary_integer;
39: begin
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: ) as
38: ddindx binary_integer; indx binary_integer;
39: begin
40: if a0 is not null and a0.count > 0 then
65: end loop;
66: end if;
67: end if;
68: end rosetta_table_copy_in_p2;
69: procedure rosetta_table_copy_out_p2(t okl_gtp_pvt.gtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_NUMBER_TABLE
71: , a2 out nocopy JTF_VARCHAR2_TABLE_200
72: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
66: end if;
67: end if;
68: end rosetta_table_copy_in_p2;
69: procedure rosetta_table_copy_out_p2(t okl_gtp_pvt.gtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_NUMBER_TABLE
71: , a2 out nocopy JTF_VARCHAR2_TABLE_200
72: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_VARCHAR2_TABLE_100
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_VARCHAR2_TABLE_100
75: , a6 out nocopy JTF_VARCHAR2_TABLE_500
76: , a7 out nocopy JTF_VARCHAR2_TABLE_500
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_DATE_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_DATE_TABLE
74: , a5 out nocopy JTF_VARCHAR2_TABLE_100
75: , a6 out nocopy JTF_VARCHAR2_TABLE_500
76: , a7 out nocopy JTF_VARCHAR2_TABLE_500
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_DATE_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_DATE_TABLE
82: , a13 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_VARCHAR2_TABLE_500
77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_DATE_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_DATE_TABLE
82: , a13 out nocopy JTF_NUMBER_TABLE
83: , a14 out nocopy JTF_NUMBER_TABLE
84: ) as
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_DATE_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_DATE_TABLE
82: , a13 out nocopy JTF_NUMBER_TABLE
83: , a14 out nocopy JTF_NUMBER_TABLE
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
79: , a10 out nocopy JTF_DATE_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_DATE_TABLE
82: , a13 out nocopy JTF_NUMBER_TABLE
83: , a14 out nocopy JTF_NUMBER_TABLE
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
87: if t is null or t.count = 0 then
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
87: if t is null or t.count = 0 then
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_VARCHAR2_TABLE_200();
91: a3 := JTF_VARCHAR2_TABLE_2000();
92: a4 := JTF_VARCHAR2_TABLE_100();
85: ddindx binary_integer; indx binary_integer;
86: begin
87: if t is null or t.count = 0 then
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_VARCHAR2_TABLE_200();
91: a3 := JTF_VARCHAR2_TABLE_2000();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_VARCHAR2_TABLE_100();
94: a6 := JTF_VARCHAR2_TABLE_500();
95: a7 := JTF_VARCHAR2_TABLE_500();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_DATE_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_DATE_TABLE();
93: a5 := JTF_VARCHAR2_TABLE_100();
94: a6 := JTF_VARCHAR2_TABLE_500();
95: a7 := JTF_VARCHAR2_TABLE_500();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_DATE_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_DATE_TABLE();
101: a13 := JTF_NUMBER_TABLE();
95: a7 := JTF_VARCHAR2_TABLE_500();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_DATE_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_DATE_TABLE();
101: a13 := JTF_NUMBER_TABLE();
102: a14 := JTF_NUMBER_TABLE();
103: else
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_DATE_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_DATE_TABLE();
101: a13 := JTF_NUMBER_TABLE();
102: a14 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_NUMBER_TABLE();
98: a10 := JTF_DATE_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_DATE_TABLE();
101: a13 := JTF_NUMBER_TABLE();
102: a14 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_NUMBER_TABLE();
106: a2 := JTF_VARCHAR2_TABLE_200();
100: a12 := JTF_DATE_TABLE();
101: a13 := JTF_NUMBER_TABLE();
102: a14 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_NUMBER_TABLE();
106: a2 := JTF_VARCHAR2_TABLE_200();
107: a3 := JTF_VARCHAR2_TABLE_2000();
108: a4 := JTF_VARCHAR2_TABLE_100();
101: a13 := JTF_NUMBER_TABLE();
102: a14 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_NUMBER_TABLE();
106: a2 := JTF_VARCHAR2_TABLE_200();
107: a3 := JTF_VARCHAR2_TABLE_2000();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_VARCHAR2_TABLE_100();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_VARCHAR2_TABLE_100();
110: a6 := JTF_VARCHAR2_TABLE_500();
111: a7 := JTF_VARCHAR2_TABLE_500();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_DATE_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_DATE_TABLE();
109: a5 := JTF_VARCHAR2_TABLE_100();
110: a6 := JTF_VARCHAR2_TABLE_500();
111: a7 := JTF_VARCHAR2_TABLE_500();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_DATE_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_DATE_TABLE();
117: a13 := JTF_NUMBER_TABLE();
111: a7 := JTF_VARCHAR2_TABLE_500();
112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_DATE_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_DATE_TABLE();
117: a13 := JTF_NUMBER_TABLE();
118: a14 := JTF_NUMBER_TABLE();
119: if t.count > 0 then
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_DATE_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_DATE_TABLE();
117: a13 := JTF_NUMBER_TABLE();
118: a14 := JTF_NUMBER_TABLE();
119: if t.count > 0 then
120: a0.extend(t.count);
121: a1.extend(t.count);
114: a10 := JTF_DATE_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_DATE_TABLE();
117: a13 := JTF_NUMBER_TABLE();
118: a14 := JTF_NUMBER_TABLE();
119: if t.count > 0 then
120: a0.extend(t.count);
121: a1.extend(t.count);
122: a2.extend(t.count);
159: end if;
160: end if;
161: end rosetta_table_copy_out_p2;
162:
163: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtp_pvt.gtpv_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_NUMBER_TABLE
165: , a2 JTF_VARCHAR2_TABLE_200
166: , a3 JTF_VARCHAR2_TABLE_2000
167: , a4 JTF_VARCHAR2_TABLE_100
160: end if;
161: end rosetta_table_copy_out_p2;
162:
163: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtp_pvt.gtpv_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_NUMBER_TABLE
165: , a2 JTF_VARCHAR2_TABLE_200
166: , a3 JTF_VARCHAR2_TABLE_2000
167: , a4 JTF_VARCHAR2_TABLE_100
168: , a5 JTF_VARCHAR2_TABLE_100
167: , a4 JTF_VARCHAR2_TABLE_100
168: , a5 JTF_VARCHAR2_TABLE_100
169: , a6 JTF_VARCHAR2_TABLE_500
170: , a7 JTF_VARCHAR2_TABLE_500
171: , a8 JTF_NUMBER_TABLE
172: , a9 JTF_NUMBER_TABLE
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
175: , a12 JTF_DATE_TABLE
168: , a5 JTF_VARCHAR2_TABLE_100
169: , a6 JTF_VARCHAR2_TABLE_500
170: , a7 JTF_VARCHAR2_TABLE_500
171: , a8 JTF_NUMBER_TABLE
172: , a9 JTF_NUMBER_TABLE
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
175: , a12 JTF_DATE_TABLE
176: , a13 JTF_NUMBER_TABLE
170: , a7 JTF_VARCHAR2_TABLE_500
171: , a8 JTF_NUMBER_TABLE
172: , a9 JTF_NUMBER_TABLE
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
175: , a12 JTF_DATE_TABLE
176: , a13 JTF_NUMBER_TABLE
177: , a14 JTF_NUMBER_TABLE
178: ) as
172: , a9 JTF_NUMBER_TABLE
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
175: , a12 JTF_DATE_TABLE
176: , a13 JTF_NUMBER_TABLE
177: , a14 JTF_NUMBER_TABLE
178: ) as
179: ddindx binary_integer; indx binary_integer;
180: begin
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
175: , a12 JTF_DATE_TABLE
176: , a13 JTF_NUMBER_TABLE
177: , a14 JTF_NUMBER_TABLE
178: ) as
179: ddindx binary_integer; indx binary_integer;
180: begin
181: if a0 is not null and a0.count > 0 then
206: end loop;
207: end if;
208: end if;
209: end rosetta_table_copy_in_p5;
210: procedure rosetta_table_copy_out_p5(t okl_gtp_pvt.gtpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
211: , a1 out nocopy JTF_NUMBER_TABLE
212: , a2 out nocopy JTF_VARCHAR2_TABLE_200
213: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
214: , a4 out nocopy JTF_VARCHAR2_TABLE_100
207: end if;
208: end if;
209: end rosetta_table_copy_in_p5;
210: procedure rosetta_table_copy_out_p5(t okl_gtp_pvt.gtpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
211: , a1 out nocopy JTF_NUMBER_TABLE
212: , a2 out nocopy JTF_VARCHAR2_TABLE_200
213: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
214: , a4 out nocopy JTF_VARCHAR2_TABLE_100
215: , a5 out nocopy JTF_VARCHAR2_TABLE_100
214: , a4 out nocopy JTF_VARCHAR2_TABLE_100
215: , a5 out nocopy JTF_VARCHAR2_TABLE_100
216: , a6 out nocopy JTF_VARCHAR2_TABLE_500
217: , a7 out nocopy JTF_VARCHAR2_TABLE_500
218: , a8 out nocopy JTF_NUMBER_TABLE
219: , a9 out nocopy JTF_NUMBER_TABLE
220: , a10 out nocopy JTF_DATE_TABLE
221: , a11 out nocopy JTF_NUMBER_TABLE
222: , a12 out nocopy JTF_DATE_TABLE
215: , a5 out nocopy JTF_VARCHAR2_TABLE_100
216: , a6 out nocopy JTF_VARCHAR2_TABLE_500
217: , a7 out nocopy JTF_VARCHAR2_TABLE_500
218: , a8 out nocopy JTF_NUMBER_TABLE
219: , a9 out nocopy JTF_NUMBER_TABLE
220: , a10 out nocopy JTF_DATE_TABLE
221: , a11 out nocopy JTF_NUMBER_TABLE
222: , a12 out nocopy JTF_DATE_TABLE
223: , a13 out nocopy JTF_NUMBER_TABLE
217: , a7 out nocopy JTF_VARCHAR2_TABLE_500
218: , a8 out nocopy JTF_NUMBER_TABLE
219: , a9 out nocopy JTF_NUMBER_TABLE
220: , a10 out nocopy JTF_DATE_TABLE
221: , a11 out nocopy JTF_NUMBER_TABLE
222: , a12 out nocopy JTF_DATE_TABLE
223: , a13 out nocopy JTF_NUMBER_TABLE
224: , a14 out nocopy JTF_NUMBER_TABLE
225: ) as
219: , a9 out nocopy JTF_NUMBER_TABLE
220: , a10 out nocopy JTF_DATE_TABLE
221: , a11 out nocopy JTF_NUMBER_TABLE
222: , a12 out nocopy JTF_DATE_TABLE
223: , a13 out nocopy JTF_NUMBER_TABLE
224: , a14 out nocopy JTF_NUMBER_TABLE
225: ) as
226: ddindx binary_integer; indx binary_integer;
227: begin
220: , a10 out nocopy JTF_DATE_TABLE
221: , a11 out nocopy JTF_NUMBER_TABLE
222: , a12 out nocopy JTF_DATE_TABLE
223: , a13 out nocopy JTF_NUMBER_TABLE
224: , a14 out nocopy JTF_NUMBER_TABLE
225: ) as
226: ddindx binary_integer; indx binary_integer;
227: begin
228: if t is null or t.count = 0 then
225: ) as
226: ddindx binary_integer; indx binary_integer;
227: begin
228: if t is null or t.count = 0 then
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_NUMBER_TABLE();
231: a2 := JTF_VARCHAR2_TABLE_200();
232: a3 := JTF_VARCHAR2_TABLE_2000();
233: a4 := JTF_VARCHAR2_TABLE_100();
226: ddindx binary_integer; indx binary_integer;
227: begin
228: if t is null or t.count = 0 then
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_NUMBER_TABLE();
231: a2 := JTF_VARCHAR2_TABLE_200();
232: a3 := JTF_VARCHAR2_TABLE_2000();
233: a4 := JTF_VARCHAR2_TABLE_100();
234: a5 := JTF_VARCHAR2_TABLE_100();
233: a4 := JTF_VARCHAR2_TABLE_100();
234: a5 := JTF_VARCHAR2_TABLE_100();
235: a6 := JTF_VARCHAR2_TABLE_500();
236: a7 := JTF_VARCHAR2_TABLE_500();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_NUMBER_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_NUMBER_TABLE();
241: a12 := JTF_DATE_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_100();
235: a6 := JTF_VARCHAR2_TABLE_500();
236: a7 := JTF_VARCHAR2_TABLE_500();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_NUMBER_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_NUMBER_TABLE();
241: a12 := JTF_DATE_TABLE();
242: a13 := JTF_NUMBER_TABLE();
236: a7 := JTF_VARCHAR2_TABLE_500();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_NUMBER_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_NUMBER_TABLE();
241: a12 := JTF_DATE_TABLE();
242: a13 := JTF_NUMBER_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: else
238: a9 := JTF_NUMBER_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_NUMBER_TABLE();
241: a12 := JTF_DATE_TABLE();
242: a13 := JTF_NUMBER_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: a1 := JTF_NUMBER_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_NUMBER_TABLE();
241: a12 := JTF_DATE_TABLE();
242: a13 := JTF_NUMBER_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: a1 := JTF_NUMBER_TABLE();
247: a2 := JTF_VARCHAR2_TABLE_200();
241: a12 := JTF_DATE_TABLE();
242: a13 := JTF_NUMBER_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: a1 := JTF_NUMBER_TABLE();
247: a2 := JTF_VARCHAR2_TABLE_200();
248: a3 := JTF_VARCHAR2_TABLE_2000();
249: a4 := JTF_VARCHAR2_TABLE_100();
242: a13 := JTF_NUMBER_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: a1 := JTF_NUMBER_TABLE();
247: a2 := JTF_VARCHAR2_TABLE_200();
248: a3 := JTF_VARCHAR2_TABLE_2000();
249: a4 := JTF_VARCHAR2_TABLE_100();
250: a5 := JTF_VARCHAR2_TABLE_100();
249: a4 := JTF_VARCHAR2_TABLE_100();
250: a5 := JTF_VARCHAR2_TABLE_100();
251: a6 := JTF_VARCHAR2_TABLE_500();
252: a7 := JTF_VARCHAR2_TABLE_500();
253: a8 := JTF_NUMBER_TABLE();
254: a9 := JTF_NUMBER_TABLE();
255: a10 := JTF_DATE_TABLE();
256: a11 := JTF_NUMBER_TABLE();
257: a12 := JTF_DATE_TABLE();
250: a5 := JTF_VARCHAR2_TABLE_100();
251: a6 := JTF_VARCHAR2_TABLE_500();
252: a7 := JTF_VARCHAR2_TABLE_500();
253: a8 := JTF_NUMBER_TABLE();
254: a9 := JTF_NUMBER_TABLE();
255: a10 := JTF_DATE_TABLE();
256: a11 := JTF_NUMBER_TABLE();
257: a12 := JTF_DATE_TABLE();
258: a13 := JTF_NUMBER_TABLE();
252: a7 := JTF_VARCHAR2_TABLE_500();
253: a8 := JTF_NUMBER_TABLE();
254: a9 := JTF_NUMBER_TABLE();
255: a10 := JTF_DATE_TABLE();
256: a11 := JTF_NUMBER_TABLE();
257: a12 := JTF_DATE_TABLE();
258: a13 := JTF_NUMBER_TABLE();
259: a14 := JTF_NUMBER_TABLE();
260: if t.count > 0 then
254: a9 := JTF_NUMBER_TABLE();
255: a10 := JTF_DATE_TABLE();
256: a11 := JTF_NUMBER_TABLE();
257: a12 := JTF_DATE_TABLE();
258: a13 := JTF_NUMBER_TABLE();
259: a14 := JTF_NUMBER_TABLE();
260: if t.count > 0 then
261: a0.extend(t.count);
262: a1.extend(t.count);
255: a10 := JTF_DATE_TABLE();
256: a11 := JTF_NUMBER_TABLE();
257: a12 := JTF_DATE_TABLE();
258: a13 := JTF_NUMBER_TABLE();
259: a14 := JTF_NUMBER_TABLE();
260: if t.count > 0 then
261: a0.extend(t.count);
262: a1.extend(t.count);
263: a2.extend(t.count);
404: , p_init_msg_list VARCHAR2
405: , x_return_status out nocopy VARCHAR2
406: , x_msg_count out nocopy NUMBER
407: , x_msg_data out nocopy VARCHAR2
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_NUMBER_TABLE
410: , p5_a2 JTF_VARCHAR2_TABLE_200
411: , p5_a3 JTF_VARCHAR2_TABLE_2000
412: , p5_a4 JTF_VARCHAR2_TABLE_100
405: , x_return_status out nocopy VARCHAR2
406: , x_msg_count out nocopy NUMBER
407: , x_msg_data out nocopy VARCHAR2
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_NUMBER_TABLE
410: , p5_a2 JTF_VARCHAR2_TABLE_200
411: , p5_a3 JTF_VARCHAR2_TABLE_2000
412: , p5_a4 JTF_VARCHAR2_TABLE_100
413: , p5_a5 JTF_VARCHAR2_TABLE_100
412: , p5_a4 JTF_VARCHAR2_TABLE_100
413: , p5_a5 JTF_VARCHAR2_TABLE_100
414: , p5_a6 JTF_VARCHAR2_TABLE_500
415: , p5_a7 JTF_VARCHAR2_TABLE_500
416: , p5_a8 JTF_NUMBER_TABLE
417: , p5_a9 JTF_NUMBER_TABLE
418: , p5_a10 JTF_DATE_TABLE
419: , p5_a11 JTF_NUMBER_TABLE
420: , p5_a12 JTF_DATE_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_100
414: , p5_a6 JTF_VARCHAR2_TABLE_500
415: , p5_a7 JTF_VARCHAR2_TABLE_500
416: , p5_a8 JTF_NUMBER_TABLE
417: , p5_a9 JTF_NUMBER_TABLE
418: , p5_a10 JTF_DATE_TABLE
419: , p5_a11 JTF_NUMBER_TABLE
420: , p5_a12 JTF_DATE_TABLE
421: , p5_a13 JTF_NUMBER_TABLE
415: , p5_a7 JTF_VARCHAR2_TABLE_500
416: , p5_a8 JTF_NUMBER_TABLE
417: , p5_a9 JTF_NUMBER_TABLE
418: , p5_a10 JTF_DATE_TABLE
419: , p5_a11 JTF_NUMBER_TABLE
420: , p5_a12 JTF_DATE_TABLE
421: , p5_a13 JTF_NUMBER_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
417: , p5_a9 JTF_NUMBER_TABLE
418: , p5_a10 JTF_DATE_TABLE
419: , p5_a11 JTF_NUMBER_TABLE
420: , p5_a12 JTF_DATE_TABLE
421: , p5_a13 JTF_NUMBER_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_NUMBER_TABLE
425: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
418: , p5_a10 JTF_DATE_TABLE
419: , p5_a11 JTF_NUMBER_TABLE
420: , p5_a12 JTF_DATE_TABLE
421: , p5_a13 JTF_NUMBER_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_NUMBER_TABLE
425: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
426: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
419: , p5_a11 JTF_NUMBER_TABLE
420: , p5_a12 JTF_DATE_TABLE
421: , p5_a13 JTF_NUMBER_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_NUMBER_TABLE
425: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
426: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
427: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
420: , p5_a12 JTF_DATE_TABLE
421: , p5_a13 JTF_NUMBER_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_NUMBER_TABLE
425: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
426: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
427: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
428: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
428: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
430: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_NUMBER_TABLE
433: , p6_a10 out nocopy JTF_DATE_TABLE
434: , p6_a11 out nocopy JTF_NUMBER_TABLE
435: , p6_a12 out nocopy JTF_DATE_TABLE
428: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
430: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_NUMBER_TABLE
433: , p6_a10 out nocopy JTF_DATE_TABLE
434: , p6_a11 out nocopy JTF_NUMBER_TABLE
435: , p6_a12 out nocopy JTF_DATE_TABLE
436: , p6_a13 out nocopy JTF_NUMBER_TABLE
430: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_NUMBER_TABLE
433: , p6_a10 out nocopy JTF_DATE_TABLE
434: , p6_a11 out nocopy JTF_NUMBER_TABLE
435: , p6_a12 out nocopy JTF_DATE_TABLE
436: , p6_a13 out nocopy JTF_NUMBER_TABLE
437: , p6_a14 out nocopy JTF_NUMBER_TABLE
438: )
432: , p6_a9 out nocopy JTF_NUMBER_TABLE
433: , p6_a10 out nocopy JTF_DATE_TABLE
434: , p6_a11 out nocopy JTF_NUMBER_TABLE
435: , p6_a12 out nocopy JTF_DATE_TABLE
436: , p6_a13 out nocopy JTF_NUMBER_TABLE
437: , p6_a14 out nocopy JTF_NUMBER_TABLE
438: )
439:
440: as
433: , p6_a10 out nocopy JTF_DATE_TABLE
434: , p6_a11 out nocopy JTF_NUMBER_TABLE
435: , p6_a12 out nocopy JTF_DATE_TABLE
436: , p6_a13 out nocopy JTF_NUMBER_TABLE
437: , p6_a14 out nocopy JTF_NUMBER_TABLE
438: )
439:
440: as
441: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
604: , p_init_msg_list VARCHAR2
605: , x_return_status out nocopy VARCHAR2
606: , x_msg_count out nocopy NUMBER
607: , x_msg_data out nocopy VARCHAR2
608: , p5_a0 JTF_NUMBER_TABLE
609: , p5_a1 JTF_NUMBER_TABLE
610: , p5_a2 JTF_VARCHAR2_TABLE_200
611: , p5_a3 JTF_VARCHAR2_TABLE_2000
612: , p5_a4 JTF_VARCHAR2_TABLE_100
605: , x_return_status out nocopy VARCHAR2
606: , x_msg_count out nocopy NUMBER
607: , x_msg_data out nocopy VARCHAR2
608: , p5_a0 JTF_NUMBER_TABLE
609: , p5_a1 JTF_NUMBER_TABLE
610: , p5_a2 JTF_VARCHAR2_TABLE_200
611: , p5_a3 JTF_VARCHAR2_TABLE_2000
612: , p5_a4 JTF_VARCHAR2_TABLE_100
613: , p5_a5 JTF_VARCHAR2_TABLE_100
612: , p5_a4 JTF_VARCHAR2_TABLE_100
613: , p5_a5 JTF_VARCHAR2_TABLE_100
614: , p5_a6 JTF_VARCHAR2_TABLE_500
615: , p5_a7 JTF_VARCHAR2_TABLE_500
616: , p5_a8 JTF_NUMBER_TABLE
617: , p5_a9 JTF_NUMBER_TABLE
618: , p5_a10 JTF_DATE_TABLE
619: , p5_a11 JTF_NUMBER_TABLE
620: , p5_a12 JTF_DATE_TABLE
613: , p5_a5 JTF_VARCHAR2_TABLE_100
614: , p5_a6 JTF_VARCHAR2_TABLE_500
615: , p5_a7 JTF_VARCHAR2_TABLE_500
616: , p5_a8 JTF_NUMBER_TABLE
617: , p5_a9 JTF_NUMBER_TABLE
618: , p5_a10 JTF_DATE_TABLE
619: , p5_a11 JTF_NUMBER_TABLE
620: , p5_a12 JTF_DATE_TABLE
621: , p5_a13 JTF_NUMBER_TABLE
615: , p5_a7 JTF_VARCHAR2_TABLE_500
616: , p5_a8 JTF_NUMBER_TABLE
617: , p5_a9 JTF_NUMBER_TABLE
618: , p5_a10 JTF_DATE_TABLE
619: , p5_a11 JTF_NUMBER_TABLE
620: , p5_a12 JTF_DATE_TABLE
621: , p5_a13 JTF_NUMBER_TABLE
622: , p5_a14 JTF_NUMBER_TABLE
623: , p6_a0 out nocopy JTF_NUMBER_TABLE
617: , p5_a9 JTF_NUMBER_TABLE
618: , p5_a10 JTF_DATE_TABLE
619: , p5_a11 JTF_NUMBER_TABLE
620: , p5_a12 JTF_DATE_TABLE
621: , p5_a13 JTF_NUMBER_TABLE
622: , p5_a14 JTF_NUMBER_TABLE
623: , p6_a0 out nocopy JTF_NUMBER_TABLE
624: , p6_a1 out nocopy JTF_NUMBER_TABLE
625: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
618: , p5_a10 JTF_DATE_TABLE
619: , p5_a11 JTF_NUMBER_TABLE
620: , p5_a12 JTF_DATE_TABLE
621: , p5_a13 JTF_NUMBER_TABLE
622: , p5_a14 JTF_NUMBER_TABLE
623: , p6_a0 out nocopy JTF_NUMBER_TABLE
624: , p6_a1 out nocopy JTF_NUMBER_TABLE
625: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
626: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
619: , p5_a11 JTF_NUMBER_TABLE
620: , p5_a12 JTF_DATE_TABLE
621: , p5_a13 JTF_NUMBER_TABLE
622: , p5_a14 JTF_NUMBER_TABLE
623: , p6_a0 out nocopy JTF_NUMBER_TABLE
624: , p6_a1 out nocopy JTF_NUMBER_TABLE
625: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
626: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
627: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
620: , p5_a12 JTF_DATE_TABLE
621: , p5_a13 JTF_NUMBER_TABLE
622: , p5_a14 JTF_NUMBER_TABLE
623: , p6_a0 out nocopy JTF_NUMBER_TABLE
624: , p6_a1 out nocopy JTF_NUMBER_TABLE
625: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
626: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
627: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
628: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
628: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
629: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
630: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
631: , p6_a8 out nocopy JTF_NUMBER_TABLE
632: , p6_a9 out nocopy JTF_NUMBER_TABLE
633: , p6_a10 out nocopy JTF_DATE_TABLE
634: , p6_a11 out nocopy JTF_NUMBER_TABLE
635: , p6_a12 out nocopy JTF_DATE_TABLE
628: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
629: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
630: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
631: , p6_a8 out nocopy JTF_NUMBER_TABLE
632: , p6_a9 out nocopy JTF_NUMBER_TABLE
633: , p6_a10 out nocopy JTF_DATE_TABLE
634: , p6_a11 out nocopy JTF_NUMBER_TABLE
635: , p6_a12 out nocopy JTF_DATE_TABLE
636: , p6_a13 out nocopy JTF_NUMBER_TABLE
630: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
631: , p6_a8 out nocopy JTF_NUMBER_TABLE
632: , p6_a9 out nocopy JTF_NUMBER_TABLE
633: , p6_a10 out nocopy JTF_DATE_TABLE
634: , p6_a11 out nocopy JTF_NUMBER_TABLE
635: , p6_a12 out nocopy JTF_DATE_TABLE
636: , p6_a13 out nocopy JTF_NUMBER_TABLE
637: , p6_a14 out nocopy JTF_NUMBER_TABLE
638: )
632: , p6_a9 out nocopy JTF_NUMBER_TABLE
633: , p6_a10 out nocopy JTF_DATE_TABLE
634: , p6_a11 out nocopy JTF_NUMBER_TABLE
635: , p6_a12 out nocopy JTF_DATE_TABLE
636: , p6_a13 out nocopy JTF_NUMBER_TABLE
637: , p6_a14 out nocopy JTF_NUMBER_TABLE
638: )
639:
640: as
633: , p6_a10 out nocopy JTF_DATE_TABLE
634: , p6_a11 out nocopy JTF_NUMBER_TABLE
635: , p6_a12 out nocopy JTF_DATE_TABLE
636: , p6_a13 out nocopy JTF_NUMBER_TABLE
637: , p6_a14 out nocopy JTF_NUMBER_TABLE
638: )
639:
640: as
641: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;
770: , p_init_msg_list VARCHAR2
771: , x_return_status out nocopy VARCHAR2
772: , x_msg_count out nocopy NUMBER
773: , x_msg_data out nocopy VARCHAR2
774: , p5_a0 JTF_NUMBER_TABLE
775: , p5_a1 JTF_NUMBER_TABLE
776: , p5_a2 JTF_VARCHAR2_TABLE_200
777: , p5_a3 JTF_VARCHAR2_TABLE_2000
778: , p5_a4 JTF_VARCHAR2_TABLE_100
771: , x_return_status out nocopy VARCHAR2
772: , x_msg_count out nocopy NUMBER
773: , x_msg_data out nocopy VARCHAR2
774: , p5_a0 JTF_NUMBER_TABLE
775: , p5_a1 JTF_NUMBER_TABLE
776: , p5_a2 JTF_VARCHAR2_TABLE_200
777: , p5_a3 JTF_VARCHAR2_TABLE_2000
778: , p5_a4 JTF_VARCHAR2_TABLE_100
779: , p5_a5 JTF_VARCHAR2_TABLE_100
778: , p5_a4 JTF_VARCHAR2_TABLE_100
779: , p5_a5 JTF_VARCHAR2_TABLE_100
780: , p5_a6 JTF_VARCHAR2_TABLE_500
781: , p5_a7 JTF_VARCHAR2_TABLE_500
782: , p5_a8 JTF_NUMBER_TABLE
783: , p5_a9 JTF_NUMBER_TABLE
784: , p5_a10 JTF_DATE_TABLE
785: , p5_a11 JTF_NUMBER_TABLE
786: , p5_a12 JTF_DATE_TABLE
779: , p5_a5 JTF_VARCHAR2_TABLE_100
780: , p5_a6 JTF_VARCHAR2_TABLE_500
781: , p5_a7 JTF_VARCHAR2_TABLE_500
782: , p5_a8 JTF_NUMBER_TABLE
783: , p5_a9 JTF_NUMBER_TABLE
784: , p5_a10 JTF_DATE_TABLE
785: , p5_a11 JTF_NUMBER_TABLE
786: , p5_a12 JTF_DATE_TABLE
787: , p5_a13 JTF_NUMBER_TABLE
781: , p5_a7 JTF_VARCHAR2_TABLE_500
782: , p5_a8 JTF_NUMBER_TABLE
783: , p5_a9 JTF_NUMBER_TABLE
784: , p5_a10 JTF_DATE_TABLE
785: , p5_a11 JTF_NUMBER_TABLE
786: , p5_a12 JTF_DATE_TABLE
787: , p5_a13 JTF_NUMBER_TABLE
788: , p5_a14 JTF_NUMBER_TABLE
789: )
783: , p5_a9 JTF_NUMBER_TABLE
784: , p5_a10 JTF_DATE_TABLE
785: , p5_a11 JTF_NUMBER_TABLE
786: , p5_a12 JTF_DATE_TABLE
787: , p5_a13 JTF_NUMBER_TABLE
788: , p5_a14 JTF_NUMBER_TABLE
789: )
790:
791: as
784: , p5_a10 JTF_DATE_TABLE
785: , p5_a11 JTF_NUMBER_TABLE
786: , p5_a12 JTF_DATE_TABLE
787: , p5_a13 JTF_NUMBER_TABLE
788: , p5_a14 JTF_NUMBER_TABLE
789: )
790:
791: as
792: ddp_gtpv_tbl okl_gtp_pvt.gtpv_tbl_type;