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_cgr_pvt.cgr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgr_pvt.cgr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgr_pvt.cgr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: ) as
31: ddindx binary_integer; indx binary_integer;
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin
33: if a0 is not null and a0.count > 0 then
51: end loop;
52: end if;
53: end if;
54: end rosetta_table_copy_in_p2;
55: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_200
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_DATE_TABLE
53: end if;
54: end rosetta_table_copy_in_p2;
55: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_200
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_DATE_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_DATE_TABLE
54: end rosetta_table_copy_in_p2;
55: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_200
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_DATE_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_DATE_TABLE
62: , a7 out nocopy JTF_NUMBER_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_200
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_DATE_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_DATE_TABLE
62: , a7 out nocopy JTF_NUMBER_TABLE
63: ) as
64: ddindx binary_integer; indx binary_integer;
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_DATE_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_DATE_TABLE
62: , a7 out nocopy JTF_NUMBER_TABLE
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_200();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_DATE_TABLE();
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_200();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_DATE_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_DATE_TABLE();
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_200();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_DATE_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_DATE_TABLE();
74: a7 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_200();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_DATE_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_DATE_TABLE();
74: a7 := JTF_NUMBER_TABLE();
75: else
76: a0 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_DATE_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_DATE_TABLE();
74: a7 := JTF_NUMBER_TABLE();
75: else
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
78: a2 := JTF_NUMBER_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_DATE_TABLE();
74: a7 := JTF_NUMBER_TABLE();
75: else
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_DATE_TABLE();
74: a7 := JTF_NUMBER_TABLE();
75: else
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_DATE_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_DATE_TABLE();
75: else
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_DATE_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_DATE_TABLE();
83: a7 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_DATE_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_DATE_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: if t.count > 0 then
85: a0.extend(t.count);
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_DATE_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_DATE_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: if t.count > 0 then
85: a0.extend(t.count);
86: a1.extend(t.count);
87: a2.extend(t.count);
110: end if;
111: end if;
112: end rosetta_table_copy_out_p2;
113:
114: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 JTF_NUMBER_TABLE
115: , a1 JTF_VARCHAR2_TABLE_100
116: , a2 JTF_VARCHAR2_TABLE_100
117: , a3 JTF_VARCHAR2_TABLE_100
118: , a4 JTF_VARCHAR2_TABLE_2000
115: , a1 JTF_VARCHAR2_TABLE_100
116: , a2 JTF_VARCHAR2_TABLE_100
117: , a3 JTF_VARCHAR2_TABLE_100
118: , a4 JTF_VARCHAR2_TABLE_2000
119: , a5 JTF_NUMBER_TABLE
120: , a6 JTF_DATE_TABLE
121: , a7 JTF_NUMBER_TABLE
122: , a8 JTF_DATE_TABLE
123: , a9 JTF_NUMBER_TABLE
117: , a3 JTF_VARCHAR2_TABLE_100
118: , a4 JTF_VARCHAR2_TABLE_2000
119: , a5 JTF_NUMBER_TABLE
120: , a6 JTF_DATE_TABLE
121: , a7 JTF_NUMBER_TABLE
122: , a8 JTF_DATE_TABLE
123: , a9 JTF_NUMBER_TABLE
124: ) as
125: ddindx binary_integer; indx binary_integer;
119: , a5 JTF_NUMBER_TABLE
120: , a6 JTF_DATE_TABLE
121: , a7 JTF_NUMBER_TABLE
122: , a8 JTF_DATE_TABLE
123: , a9 JTF_NUMBER_TABLE
124: ) as
125: ddindx binary_integer; indx binary_integer;
126: begin
127: if a0 is not null and a0.count > 0 then
147: end loop;
148: end if;
149: end if;
150: end rosetta_table_copy_in_p5;
151: procedure rosetta_table_copy_out_p5(t okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
152: , a1 out nocopy JTF_VARCHAR2_TABLE_100
153: , a2 out nocopy JTF_VARCHAR2_TABLE_100
154: , a3 out nocopy JTF_VARCHAR2_TABLE_100
155: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
152: , a1 out nocopy JTF_VARCHAR2_TABLE_100
153: , a2 out nocopy JTF_VARCHAR2_TABLE_100
154: , a3 out nocopy JTF_VARCHAR2_TABLE_100
155: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a5 out nocopy JTF_NUMBER_TABLE
157: , a6 out nocopy JTF_DATE_TABLE
158: , a7 out nocopy JTF_NUMBER_TABLE
159: , a8 out nocopy JTF_DATE_TABLE
160: , a9 out nocopy JTF_NUMBER_TABLE
154: , a3 out nocopy JTF_VARCHAR2_TABLE_100
155: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a5 out nocopy JTF_NUMBER_TABLE
157: , a6 out nocopy JTF_DATE_TABLE
158: , a7 out nocopy JTF_NUMBER_TABLE
159: , a8 out nocopy JTF_DATE_TABLE
160: , a9 out nocopy JTF_NUMBER_TABLE
161: ) as
162: ddindx binary_integer; indx binary_integer;
156: , a5 out nocopy JTF_NUMBER_TABLE
157: , a6 out nocopy JTF_DATE_TABLE
158: , a7 out nocopy JTF_NUMBER_TABLE
159: , a8 out nocopy JTF_DATE_TABLE
160: , a9 out nocopy JTF_NUMBER_TABLE
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin
164: if t is null or t.count = 0 then
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin
164: if t is null or t.count = 0 then
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_VARCHAR2_TABLE_100();
167: a2 := JTF_VARCHAR2_TABLE_100();
168: a3 := JTF_VARCHAR2_TABLE_100();
169: a4 := JTF_VARCHAR2_TABLE_2000();
166: a1 := JTF_VARCHAR2_TABLE_100();
167: a2 := JTF_VARCHAR2_TABLE_100();
168: a3 := JTF_VARCHAR2_TABLE_100();
169: a4 := JTF_VARCHAR2_TABLE_2000();
170: a5 := JTF_NUMBER_TABLE();
171: a6 := JTF_DATE_TABLE();
172: a7 := JTF_NUMBER_TABLE();
173: a8 := JTF_DATE_TABLE();
174: a9 := JTF_NUMBER_TABLE();
168: a3 := JTF_VARCHAR2_TABLE_100();
169: a4 := JTF_VARCHAR2_TABLE_2000();
170: a5 := JTF_NUMBER_TABLE();
171: a6 := JTF_DATE_TABLE();
172: a7 := JTF_NUMBER_TABLE();
173: a8 := JTF_DATE_TABLE();
174: a9 := JTF_NUMBER_TABLE();
175: else
176: a0 := JTF_NUMBER_TABLE();
170: a5 := JTF_NUMBER_TABLE();
171: a6 := JTF_DATE_TABLE();
172: a7 := JTF_NUMBER_TABLE();
173: a8 := JTF_DATE_TABLE();
174: a9 := JTF_NUMBER_TABLE();
175: else
176: a0 := JTF_NUMBER_TABLE();
177: a1 := JTF_VARCHAR2_TABLE_100();
178: a2 := JTF_VARCHAR2_TABLE_100();
172: a7 := JTF_NUMBER_TABLE();
173: a8 := JTF_DATE_TABLE();
174: a9 := JTF_NUMBER_TABLE();
175: else
176: a0 := JTF_NUMBER_TABLE();
177: a1 := JTF_VARCHAR2_TABLE_100();
178: a2 := JTF_VARCHAR2_TABLE_100();
179: a3 := JTF_VARCHAR2_TABLE_100();
180: a4 := JTF_VARCHAR2_TABLE_2000();
177: a1 := JTF_VARCHAR2_TABLE_100();
178: a2 := JTF_VARCHAR2_TABLE_100();
179: a3 := JTF_VARCHAR2_TABLE_100();
180: a4 := JTF_VARCHAR2_TABLE_2000();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_DATE_TABLE();
183: a7 := JTF_NUMBER_TABLE();
184: a8 := JTF_DATE_TABLE();
185: a9 := JTF_NUMBER_TABLE();
179: a3 := JTF_VARCHAR2_TABLE_100();
180: a4 := JTF_VARCHAR2_TABLE_2000();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_DATE_TABLE();
183: a7 := JTF_NUMBER_TABLE();
184: a8 := JTF_DATE_TABLE();
185: a9 := JTF_NUMBER_TABLE();
186: if t.count > 0 then
187: a0.extend(t.count);
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_DATE_TABLE();
183: a7 := JTF_NUMBER_TABLE();
184: a8 := JTF_DATE_TABLE();
185: a9 := JTF_NUMBER_TABLE();
186: if t.count > 0 then
187: a0.extend(t.count);
188: a1.extend(t.count);
189: a2.extend(t.count);
216: end if;
217: end if;
218: end rosetta_table_copy_out_p5;
219:
220: procedure rosetta_table_copy_in_p8(t out nocopy okl_cgr_pvt.cgrv_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_VARCHAR2_TABLE_100
223: , a3 JTF_VARCHAR2_TABLE_200
224: , a4 JTF_VARCHAR2_TABLE_2000
217: end if;
218: end rosetta_table_copy_out_p5;
219:
220: procedure rosetta_table_copy_in_p8(t out nocopy okl_cgr_pvt.cgrv_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_VARCHAR2_TABLE_100
223: , a3 JTF_VARCHAR2_TABLE_200
224: , a4 JTF_VARCHAR2_TABLE_2000
225: , a5 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_VARCHAR2_TABLE_100
223: , a3 JTF_VARCHAR2_TABLE_200
224: , a4 JTF_VARCHAR2_TABLE_2000
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_DATE_TABLE
227: , a7 JTF_NUMBER_TABLE
228: , a8 JTF_DATE_TABLE
229: , a9 JTF_NUMBER_TABLE
223: , a3 JTF_VARCHAR2_TABLE_200
224: , a4 JTF_VARCHAR2_TABLE_2000
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_DATE_TABLE
227: , a7 JTF_NUMBER_TABLE
228: , a8 JTF_DATE_TABLE
229: , a9 JTF_NUMBER_TABLE
230: ) as
231: ddindx binary_integer; indx binary_integer;
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_DATE_TABLE
227: , a7 JTF_NUMBER_TABLE
228: , a8 JTF_DATE_TABLE
229: , a9 JTF_NUMBER_TABLE
230: ) as
231: ddindx binary_integer; indx binary_integer;
232: begin
233: if a0 is not null and a0.count > 0 then
253: end loop;
254: end if;
255: end if;
256: end rosetta_table_copy_in_p8;
257: procedure rosetta_table_copy_out_p8(t okl_cgr_pvt.cgrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
258: , a1 out nocopy JTF_NUMBER_TABLE
259: , a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , a3 out nocopy JTF_VARCHAR2_TABLE_200
261: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
254: end if;
255: end if;
256: end rosetta_table_copy_in_p8;
257: procedure rosetta_table_copy_out_p8(t okl_cgr_pvt.cgrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
258: , a1 out nocopy JTF_NUMBER_TABLE
259: , a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , a3 out nocopy JTF_VARCHAR2_TABLE_200
261: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
262: , a5 out nocopy JTF_NUMBER_TABLE
258: , a1 out nocopy JTF_NUMBER_TABLE
259: , a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , a3 out nocopy JTF_VARCHAR2_TABLE_200
261: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
262: , a5 out nocopy JTF_NUMBER_TABLE
263: , a6 out nocopy JTF_DATE_TABLE
264: , a7 out nocopy JTF_NUMBER_TABLE
265: , a8 out nocopy JTF_DATE_TABLE
266: , a9 out nocopy JTF_NUMBER_TABLE
260: , a3 out nocopy JTF_VARCHAR2_TABLE_200
261: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
262: , a5 out nocopy JTF_NUMBER_TABLE
263: , a6 out nocopy JTF_DATE_TABLE
264: , a7 out nocopy JTF_NUMBER_TABLE
265: , a8 out nocopy JTF_DATE_TABLE
266: , a9 out nocopy JTF_NUMBER_TABLE
267: ) as
268: ddindx binary_integer; indx binary_integer;
262: , a5 out nocopy JTF_NUMBER_TABLE
263: , a6 out nocopy JTF_DATE_TABLE
264: , a7 out nocopy JTF_NUMBER_TABLE
265: , a8 out nocopy JTF_DATE_TABLE
266: , a9 out nocopy JTF_NUMBER_TABLE
267: ) as
268: ddindx binary_integer; indx binary_integer;
269: begin
270: if t is null or t.count = 0 then
267: ) as
268: ddindx binary_integer; indx binary_integer;
269: begin
270: if t is null or t.count = 0 then
271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_VARCHAR2_TABLE_100();
274: a3 := JTF_VARCHAR2_TABLE_200();
275: a4 := JTF_VARCHAR2_TABLE_2000();
268: ddindx binary_integer; indx binary_integer;
269: begin
270: if t is null or t.count = 0 then
271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_VARCHAR2_TABLE_100();
274: a3 := JTF_VARCHAR2_TABLE_200();
275: a4 := JTF_VARCHAR2_TABLE_2000();
276: a5 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_VARCHAR2_TABLE_100();
274: a3 := JTF_VARCHAR2_TABLE_200();
275: a4 := JTF_VARCHAR2_TABLE_2000();
276: a5 := JTF_NUMBER_TABLE();
277: a6 := JTF_DATE_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_DATE_TABLE();
280: a9 := JTF_NUMBER_TABLE();
274: a3 := JTF_VARCHAR2_TABLE_200();
275: a4 := JTF_VARCHAR2_TABLE_2000();
276: a5 := JTF_NUMBER_TABLE();
277: a6 := JTF_DATE_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_DATE_TABLE();
280: a9 := JTF_NUMBER_TABLE();
281: else
282: a0 := JTF_NUMBER_TABLE();
276: a5 := JTF_NUMBER_TABLE();
277: a6 := JTF_DATE_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_DATE_TABLE();
280: a9 := JTF_NUMBER_TABLE();
281: else
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_DATE_TABLE();
280: a9 := JTF_NUMBER_TABLE();
281: else
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_200();
286: a4 := JTF_VARCHAR2_TABLE_2000();
279: a8 := JTF_DATE_TABLE();
280: a9 := JTF_NUMBER_TABLE();
281: else
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_200();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: a5 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_200();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: a5 := JTF_NUMBER_TABLE();
288: a6 := JTF_DATE_TABLE();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_DATE_TABLE();
291: a9 := JTF_NUMBER_TABLE();
285: a3 := JTF_VARCHAR2_TABLE_200();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: a5 := JTF_NUMBER_TABLE();
288: a6 := JTF_DATE_TABLE();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_DATE_TABLE();
291: a9 := JTF_NUMBER_TABLE();
292: if t.count > 0 then
293: a0.extend(t.count);
287: a5 := JTF_NUMBER_TABLE();
288: a6 := JTF_DATE_TABLE();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_DATE_TABLE();
291: a9 := JTF_NUMBER_TABLE();
292: if t.count > 0 then
293: a0.extend(t.count);
294: a1.extend(t.count);
295: a2.extend(t.count);
406: , p_init_msg_list VARCHAR2
407: , x_return_status out nocopy VARCHAR2
408: , x_msg_count out nocopy NUMBER
409: , x_msg_data out nocopy VARCHAR2
410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_NUMBER_TABLE
412: , p5_a2 JTF_VARCHAR2_TABLE_100
413: , p5_a3 JTF_VARCHAR2_TABLE_200
414: , p5_a4 JTF_VARCHAR2_TABLE_2000
407: , x_return_status out nocopy VARCHAR2
408: , x_msg_count out nocopy NUMBER
409: , x_msg_data out nocopy VARCHAR2
410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_NUMBER_TABLE
412: , p5_a2 JTF_VARCHAR2_TABLE_100
413: , p5_a3 JTF_VARCHAR2_TABLE_200
414: , p5_a4 JTF_VARCHAR2_TABLE_2000
415: , p5_a5 JTF_NUMBER_TABLE
411: , p5_a1 JTF_NUMBER_TABLE
412: , p5_a2 JTF_VARCHAR2_TABLE_100
413: , p5_a3 JTF_VARCHAR2_TABLE_200
414: , p5_a4 JTF_VARCHAR2_TABLE_2000
415: , p5_a5 JTF_NUMBER_TABLE
416: , p5_a6 JTF_DATE_TABLE
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_DATE_TABLE
419: , p5_a9 JTF_NUMBER_TABLE
413: , p5_a3 JTF_VARCHAR2_TABLE_200
414: , p5_a4 JTF_VARCHAR2_TABLE_2000
415: , p5_a5 JTF_NUMBER_TABLE
416: , p5_a6 JTF_DATE_TABLE
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_DATE_TABLE
419: , p5_a9 JTF_NUMBER_TABLE
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
415: , p5_a5 JTF_NUMBER_TABLE
416: , p5_a6 JTF_DATE_TABLE
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_DATE_TABLE
419: , p5_a9 JTF_NUMBER_TABLE
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
416: , p5_a6 JTF_DATE_TABLE
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_DATE_TABLE
419: , p5_a9 JTF_NUMBER_TABLE
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_DATE_TABLE
419: , p5_a9 JTF_NUMBER_TABLE
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a5 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a5 out nocopy JTF_NUMBER_TABLE
426: , p6_a6 out nocopy JTF_DATE_TABLE
427: , p6_a7 out nocopy JTF_NUMBER_TABLE
428: , p6_a8 out nocopy JTF_DATE_TABLE
429: , p6_a9 out nocopy JTF_NUMBER_TABLE
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a5 out nocopy JTF_NUMBER_TABLE
426: , p6_a6 out nocopy JTF_DATE_TABLE
427: , p6_a7 out nocopy JTF_NUMBER_TABLE
428: , p6_a8 out nocopy JTF_DATE_TABLE
429: , p6_a9 out nocopy JTF_NUMBER_TABLE
430: )
431:
425: , p6_a5 out nocopy JTF_NUMBER_TABLE
426: , p6_a6 out nocopy JTF_DATE_TABLE
427: , p6_a7 out nocopy JTF_NUMBER_TABLE
428: , p6_a8 out nocopy JTF_DATE_TABLE
429: , p6_a9 out nocopy JTF_NUMBER_TABLE
430: )
431:
432: as
433: ddp_cgrv_tbl okl_cgr_pvt.cgrv_tbl_type;
542: , p_init_msg_list VARCHAR2
543: , x_return_status out nocopy VARCHAR2
544: , x_msg_count out nocopy NUMBER
545: , x_msg_data out nocopy VARCHAR2
546: , p5_a0 JTF_NUMBER_TABLE
547: , p5_a1 JTF_NUMBER_TABLE
548: , p5_a2 JTF_VARCHAR2_TABLE_100
549: , p5_a3 JTF_VARCHAR2_TABLE_200
550: , p5_a4 JTF_VARCHAR2_TABLE_2000
543: , x_return_status out nocopy VARCHAR2
544: , x_msg_count out nocopy NUMBER
545: , x_msg_data out nocopy VARCHAR2
546: , p5_a0 JTF_NUMBER_TABLE
547: , p5_a1 JTF_NUMBER_TABLE
548: , p5_a2 JTF_VARCHAR2_TABLE_100
549: , p5_a3 JTF_VARCHAR2_TABLE_200
550: , p5_a4 JTF_VARCHAR2_TABLE_2000
551: , p5_a5 JTF_NUMBER_TABLE
547: , p5_a1 JTF_NUMBER_TABLE
548: , p5_a2 JTF_VARCHAR2_TABLE_100
549: , p5_a3 JTF_VARCHAR2_TABLE_200
550: , p5_a4 JTF_VARCHAR2_TABLE_2000
551: , p5_a5 JTF_NUMBER_TABLE
552: , p5_a6 JTF_DATE_TABLE
553: , p5_a7 JTF_NUMBER_TABLE
554: , p5_a8 JTF_DATE_TABLE
555: , p5_a9 JTF_NUMBER_TABLE
549: , p5_a3 JTF_VARCHAR2_TABLE_200
550: , p5_a4 JTF_VARCHAR2_TABLE_2000
551: , p5_a5 JTF_NUMBER_TABLE
552: , p5_a6 JTF_DATE_TABLE
553: , p5_a7 JTF_NUMBER_TABLE
554: , p5_a8 JTF_DATE_TABLE
555: , p5_a9 JTF_NUMBER_TABLE
556: )
557:
551: , p5_a5 JTF_NUMBER_TABLE
552: , p5_a6 JTF_DATE_TABLE
553: , p5_a7 JTF_NUMBER_TABLE
554: , p5_a8 JTF_DATE_TABLE
555: , p5_a9 JTF_NUMBER_TABLE
556: )
557:
558: as
559: ddp_cgrv_tbl okl_cgr_pvt.cgrv_tbl_type;
677: , p_init_msg_list VARCHAR2
678: , x_return_status out nocopy VARCHAR2
679: , x_msg_count out nocopy NUMBER
680: , x_msg_data out nocopy VARCHAR2
681: , p5_a0 JTF_NUMBER_TABLE
682: , p5_a1 JTF_NUMBER_TABLE
683: , p5_a2 JTF_VARCHAR2_TABLE_100
684: , p5_a3 JTF_VARCHAR2_TABLE_200
685: , p5_a4 JTF_VARCHAR2_TABLE_2000
678: , x_return_status out nocopy VARCHAR2
679: , x_msg_count out nocopy NUMBER
680: , x_msg_data out nocopy VARCHAR2
681: , p5_a0 JTF_NUMBER_TABLE
682: , p5_a1 JTF_NUMBER_TABLE
683: , p5_a2 JTF_VARCHAR2_TABLE_100
684: , p5_a3 JTF_VARCHAR2_TABLE_200
685: , p5_a4 JTF_VARCHAR2_TABLE_2000
686: , p5_a5 JTF_NUMBER_TABLE
682: , p5_a1 JTF_NUMBER_TABLE
683: , p5_a2 JTF_VARCHAR2_TABLE_100
684: , p5_a3 JTF_VARCHAR2_TABLE_200
685: , p5_a4 JTF_VARCHAR2_TABLE_2000
686: , p5_a5 JTF_NUMBER_TABLE
687: , p5_a6 JTF_DATE_TABLE
688: , p5_a7 JTF_NUMBER_TABLE
689: , p5_a8 JTF_DATE_TABLE
690: , p5_a9 JTF_NUMBER_TABLE
684: , p5_a3 JTF_VARCHAR2_TABLE_200
685: , p5_a4 JTF_VARCHAR2_TABLE_2000
686: , p5_a5 JTF_NUMBER_TABLE
687: , p5_a6 JTF_DATE_TABLE
688: , p5_a7 JTF_NUMBER_TABLE
689: , p5_a8 JTF_DATE_TABLE
690: , p5_a9 JTF_NUMBER_TABLE
691: , p6_a0 out nocopy JTF_NUMBER_TABLE
692: , p6_a1 out nocopy JTF_NUMBER_TABLE
686: , p5_a5 JTF_NUMBER_TABLE
687: , p5_a6 JTF_DATE_TABLE
688: , p5_a7 JTF_NUMBER_TABLE
689: , p5_a8 JTF_DATE_TABLE
690: , p5_a9 JTF_NUMBER_TABLE
691: , p6_a0 out nocopy JTF_NUMBER_TABLE
692: , p6_a1 out nocopy JTF_NUMBER_TABLE
693: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
694: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
687: , p5_a6 JTF_DATE_TABLE
688: , p5_a7 JTF_NUMBER_TABLE
689: , p5_a8 JTF_DATE_TABLE
690: , p5_a9 JTF_NUMBER_TABLE
691: , p6_a0 out nocopy JTF_NUMBER_TABLE
692: , p6_a1 out nocopy JTF_NUMBER_TABLE
693: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
694: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
695: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
688: , p5_a7 JTF_NUMBER_TABLE
689: , p5_a8 JTF_DATE_TABLE
690: , p5_a9 JTF_NUMBER_TABLE
691: , p6_a0 out nocopy JTF_NUMBER_TABLE
692: , p6_a1 out nocopy JTF_NUMBER_TABLE
693: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
694: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
695: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
696: , p6_a5 out nocopy JTF_NUMBER_TABLE
692: , p6_a1 out nocopy JTF_NUMBER_TABLE
693: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
694: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
695: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
696: , p6_a5 out nocopy JTF_NUMBER_TABLE
697: , p6_a6 out nocopy JTF_DATE_TABLE
698: , p6_a7 out nocopy JTF_NUMBER_TABLE
699: , p6_a8 out nocopy JTF_DATE_TABLE
700: , p6_a9 out nocopy JTF_NUMBER_TABLE
694: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
695: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
696: , p6_a5 out nocopy JTF_NUMBER_TABLE
697: , p6_a6 out nocopy JTF_DATE_TABLE
698: , p6_a7 out nocopy JTF_NUMBER_TABLE
699: , p6_a8 out nocopy JTF_DATE_TABLE
700: , p6_a9 out nocopy JTF_NUMBER_TABLE
701: )
702:
696: , p6_a5 out nocopy JTF_NUMBER_TABLE
697: , p6_a6 out nocopy JTF_DATE_TABLE
698: , p6_a7 out nocopy JTF_NUMBER_TABLE
699: , p6_a8 out nocopy JTF_DATE_TABLE
700: , p6_a9 out nocopy JTF_NUMBER_TABLE
701: )
702:
703: as
704: ddp_cgrv_tbl okl_cgr_pvt.cgrv_tbl_type;
813: , p_init_msg_list VARCHAR2
814: , x_return_status out nocopy VARCHAR2
815: , x_msg_count out nocopy NUMBER
816: , x_msg_data out nocopy VARCHAR2
817: , p5_a0 JTF_NUMBER_TABLE
818: , p5_a1 JTF_NUMBER_TABLE
819: , p5_a2 JTF_VARCHAR2_TABLE_100
820: , p5_a3 JTF_VARCHAR2_TABLE_200
821: , p5_a4 JTF_VARCHAR2_TABLE_2000
814: , x_return_status out nocopy VARCHAR2
815: , x_msg_count out nocopy NUMBER
816: , x_msg_data out nocopy VARCHAR2
817: , p5_a0 JTF_NUMBER_TABLE
818: , p5_a1 JTF_NUMBER_TABLE
819: , p5_a2 JTF_VARCHAR2_TABLE_100
820: , p5_a3 JTF_VARCHAR2_TABLE_200
821: , p5_a4 JTF_VARCHAR2_TABLE_2000
822: , p5_a5 JTF_NUMBER_TABLE
818: , p5_a1 JTF_NUMBER_TABLE
819: , p5_a2 JTF_VARCHAR2_TABLE_100
820: , p5_a3 JTF_VARCHAR2_TABLE_200
821: , p5_a4 JTF_VARCHAR2_TABLE_2000
822: , p5_a5 JTF_NUMBER_TABLE
823: , p5_a6 JTF_DATE_TABLE
824: , p5_a7 JTF_NUMBER_TABLE
825: , p5_a8 JTF_DATE_TABLE
826: , p5_a9 JTF_NUMBER_TABLE
820: , p5_a3 JTF_VARCHAR2_TABLE_200
821: , p5_a4 JTF_VARCHAR2_TABLE_2000
822: , p5_a5 JTF_NUMBER_TABLE
823: , p5_a6 JTF_DATE_TABLE
824: , p5_a7 JTF_NUMBER_TABLE
825: , p5_a8 JTF_DATE_TABLE
826: , p5_a9 JTF_NUMBER_TABLE
827: )
828:
822: , p5_a5 JTF_NUMBER_TABLE
823: , p5_a6 JTF_DATE_TABLE
824: , p5_a7 JTF_NUMBER_TABLE
825: , p5_a8 JTF_DATE_TABLE
826: , p5_a9 JTF_NUMBER_TABLE
827: )
828:
829: as
830: ddp_cgrv_tbl okl_cgr_pvt.cgrv_tbl_type;
924: , p_init_msg_list VARCHAR2
925: , x_return_status out nocopy VARCHAR2
926: , x_msg_count out nocopy NUMBER
927: , x_msg_data out nocopy VARCHAR2
928: , p5_a0 JTF_NUMBER_TABLE
929: , p5_a1 JTF_NUMBER_TABLE
930: , p5_a2 JTF_VARCHAR2_TABLE_100
931: , p5_a3 JTF_VARCHAR2_TABLE_200
932: , p5_a4 JTF_VARCHAR2_TABLE_2000
925: , x_return_status out nocopy VARCHAR2
926: , x_msg_count out nocopy NUMBER
927: , x_msg_data out nocopy VARCHAR2
928: , p5_a0 JTF_NUMBER_TABLE
929: , p5_a1 JTF_NUMBER_TABLE
930: , p5_a2 JTF_VARCHAR2_TABLE_100
931: , p5_a3 JTF_VARCHAR2_TABLE_200
932: , p5_a4 JTF_VARCHAR2_TABLE_2000
933: , p5_a5 JTF_NUMBER_TABLE
929: , p5_a1 JTF_NUMBER_TABLE
930: , p5_a2 JTF_VARCHAR2_TABLE_100
931: , p5_a3 JTF_VARCHAR2_TABLE_200
932: , p5_a4 JTF_VARCHAR2_TABLE_2000
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_DATE_TABLE
935: , p5_a7 JTF_NUMBER_TABLE
936: , p5_a8 JTF_DATE_TABLE
937: , p5_a9 JTF_NUMBER_TABLE
931: , p5_a3 JTF_VARCHAR2_TABLE_200
932: , p5_a4 JTF_VARCHAR2_TABLE_2000
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_DATE_TABLE
935: , p5_a7 JTF_NUMBER_TABLE
936: , p5_a8 JTF_DATE_TABLE
937: , p5_a9 JTF_NUMBER_TABLE
938: )
939:
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_DATE_TABLE
935: , p5_a7 JTF_NUMBER_TABLE
936: , p5_a8 JTF_DATE_TABLE
937: , p5_a9 JTF_NUMBER_TABLE
938: )
939:
940: as
941: ddp_cgrv_tbl okl_cgr_pvt.cgrv_tbl_type;