22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_tbc_pvt.tbcv_tbl_type, a0 JTF_VARCHAR2_TABLE_300
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_VARCHAR2_TABLE_100
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_NUMBER_TABLE
36: , a11 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_NUMBER_TABLE
36: , a11 JTF_NUMBER_TABLE
37: , a12 JTF_NUMBER_TABLE
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_NUMBER_TABLE
36: , a11 JTF_NUMBER_TABLE
37: , a12 JTF_NUMBER_TABLE
38: , a13 JTF_NUMBER_TABLE
35: , a10 JTF_NUMBER_TABLE
36: , a11 JTF_NUMBER_TABLE
37: , a12 JTF_NUMBER_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_500
41: , a16 JTF_VARCHAR2_TABLE_500
42: , a17 JTF_VARCHAR2_TABLE_500
43: , a18 JTF_VARCHAR2_TABLE_500
57: , a32 JTF_NUMBER_TABLE
58: , a33 JTF_DATE_TABLE
59: , a34 JTF_NUMBER_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_VARCHAR2_TABLE_100
62: , a37 JTF_VARCHAR2_TABLE_100
63: , a38 JTF_DATE_TABLE
64: , a39 JTF_DATE_TABLE
65: , a40 JTF_VARCHAR2_TABLE_100
58: , a33 JTF_DATE_TABLE
59: , a34 JTF_NUMBER_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_VARCHAR2_TABLE_100
62: , a37 JTF_VARCHAR2_TABLE_100
63: , a38 JTF_DATE_TABLE
64: , a39 JTF_DATE_TABLE
65: , a40 JTF_VARCHAR2_TABLE_100
66: , a41 JTF_VARCHAR2_TABLE_100
61: , a36 JTF_VARCHAR2_TABLE_100
62: , a37 JTF_VARCHAR2_TABLE_100
63: , a38 JTF_DATE_TABLE
64: , a39 JTF_DATE_TABLE
65: , a40 JTF_VARCHAR2_TABLE_100
66: , a41 JTF_VARCHAR2_TABLE_100
67: , a42 JTF_VARCHAR2_TABLE_100
68: , a43 JTF_VARCHAR2_TABLE_100
69: ) as
62: , a37 JTF_VARCHAR2_TABLE_100
63: , a38 JTF_DATE_TABLE
64: , a39 JTF_DATE_TABLE
65: , a40 JTF_VARCHAR2_TABLE_100
66: , a41 JTF_VARCHAR2_TABLE_100
67: , a42 JTF_VARCHAR2_TABLE_100
68: , a43 JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
63: , a38 JTF_DATE_TABLE
64: , a39 JTF_DATE_TABLE
65: , a40 JTF_VARCHAR2_TABLE_100
66: , a41 JTF_VARCHAR2_TABLE_100
67: , a42 JTF_VARCHAR2_TABLE_100
68: , a43 JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
64: , a39 JTF_DATE_TABLE
65: , a40 JTF_VARCHAR2_TABLE_100
66: , a41 JTF_VARCHAR2_TABLE_100
67: , a42 JTF_VARCHAR2_TABLE_100
68: , a43 JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if a0 is not null and a0.count > 0 then
127: end if;
128: end if;
129: end rosetta_table_copy_in_p2;
130: procedure rosetta_table_copy_out_p2(t okl_tbc_pvt.tbcv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
131: , a1 out nocopy JTF_VARCHAR2_TABLE_100
132: , a2 out nocopy JTF_NUMBER_TABLE
133: , a3 out nocopy JTF_NUMBER_TABLE
134: , a4 out nocopy JTF_NUMBER_TABLE
135: , a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , a1 out nocopy JTF_VARCHAR2_TABLE_100
132: , a2 out nocopy JTF_NUMBER_TABLE
133: , a3 out nocopy JTF_NUMBER_TABLE
134: , a4 out nocopy JTF_NUMBER_TABLE
135: , a5 out nocopy JTF_VARCHAR2_TABLE_100
136: , a6 out nocopy JTF_VARCHAR2_TABLE_100
137: , a7 out nocopy JTF_VARCHAR2_TABLE_100
138: , a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , a9 out nocopy JTF_VARCHAR2_TABLE_100
132: , a2 out nocopy JTF_NUMBER_TABLE
133: , a3 out nocopy JTF_NUMBER_TABLE
134: , a4 out nocopy JTF_NUMBER_TABLE
135: , a5 out nocopy JTF_VARCHAR2_TABLE_100
136: , a6 out nocopy JTF_VARCHAR2_TABLE_100
137: , a7 out nocopy JTF_VARCHAR2_TABLE_100
138: , a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , a9 out nocopy JTF_VARCHAR2_TABLE_100
140: , a10 out nocopy JTF_NUMBER_TABLE
133: , a3 out nocopy JTF_NUMBER_TABLE
134: , a4 out nocopy JTF_NUMBER_TABLE
135: , a5 out nocopy JTF_VARCHAR2_TABLE_100
136: , a6 out nocopy JTF_VARCHAR2_TABLE_100
137: , a7 out nocopy JTF_VARCHAR2_TABLE_100
138: , a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , a9 out nocopy JTF_VARCHAR2_TABLE_100
140: , a10 out nocopy JTF_NUMBER_TABLE
141: , a11 out nocopy JTF_NUMBER_TABLE
134: , a4 out nocopy JTF_NUMBER_TABLE
135: , a5 out nocopy JTF_VARCHAR2_TABLE_100
136: , a6 out nocopy JTF_VARCHAR2_TABLE_100
137: , a7 out nocopy JTF_VARCHAR2_TABLE_100
138: , a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , a9 out nocopy JTF_VARCHAR2_TABLE_100
140: , a10 out nocopy JTF_NUMBER_TABLE
141: , a11 out nocopy JTF_NUMBER_TABLE
142: , a12 out nocopy JTF_NUMBER_TABLE
135: , a5 out nocopy JTF_VARCHAR2_TABLE_100
136: , a6 out nocopy JTF_VARCHAR2_TABLE_100
137: , a7 out nocopy JTF_VARCHAR2_TABLE_100
138: , a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , a9 out nocopy JTF_VARCHAR2_TABLE_100
140: , a10 out nocopy JTF_NUMBER_TABLE
141: , a11 out nocopy JTF_NUMBER_TABLE
142: , a12 out nocopy JTF_NUMBER_TABLE
143: , a13 out nocopy JTF_NUMBER_TABLE
140: , a10 out nocopy JTF_NUMBER_TABLE
141: , a11 out nocopy JTF_NUMBER_TABLE
142: , a12 out nocopy JTF_NUMBER_TABLE
143: , a13 out nocopy JTF_NUMBER_TABLE
144: , a14 out nocopy JTF_VARCHAR2_TABLE_100
145: , a15 out nocopy JTF_VARCHAR2_TABLE_500
146: , a16 out nocopy JTF_VARCHAR2_TABLE_500
147: , a17 out nocopy JTF_VARCHAR2_TABLE_500
148: , a18 out nocopy JTF_VARCHAR2_TABLE_500
162: , a32 out nocopy JTF_NUMBER_TABLE
163: , a33 out nocopy JTF_DATE_TABLE
164: , a34 out nocopy JTF_NUMBER_TABLE
165: , a35 out nocopy JTF_NUMBER_TABLE
166: , a36 out nocopy JTF_VARCHAR2_TABLE_100
167: , a37 out nocopy JTF_VARCHAR2_TABLE_100
168: , a38 out nocopy JTF_DATE_TABLE
169: , a39 out nocopy JTF_DATE_TABLE
170: , a40 out nocopy JTF_VARCHAR2_TABLE_100
163: , a33 out nocopy JTF_DATE_TABLE
164: , a34 out nocopy JTF_NUMBER_TABLE
165: , a35 out nocopy JTF_NUMBER_TABLE
166: , a36 out nocopy JTF_VARCHAR2_TABLE_100
167: , a37 out nocopy JTF_VARCHAR2_TABLE_100
168: , a38 out nocopy JTF_DATE_TABLE
169: , a39 out nocopy JTF_DATE_TABLE
170: , a40 out nocopy JTF_VARCHAR2_TABLE_100
171: , a41 out nocopy JTF_VARCHAR2_TABLE_100
166: , a36 out nocopy JTF_VARCHAR2_TABLE_100
167: , a37 out nocopy JTF_VARCHAR2_TABLE_100
168: , a38 out nocopy JTF_DATE_TABLE
169: , a39 out nocopy JTF_DATE_TABLE
170: , a40 out nocopy JTF_VARCHAR2_TABLE_100
171: , a41 out nocopy JTF_VARCHAR2_TABLE_100
172: , a42 out nocopy JTF_VARCHAR2_TABLE_100
173: , a43 out nocopy JTF_VARCHAR2_TABLE_100
174: ) as
167: , a37 out nocopy JTF_VARCHAR2_TABLE_100
168: , a38 out nocopy JTF_DATE_TABLE
169: , a39 out nocopy JTF_DATE_TABLE
170: , a40 out nocopy JTF_VARCHAR2_TABLE_100
171: , a41 out nocopy JTF_VARCHAR2_TABLE_100
172: , a42 out nocopy JTF_VARCHAR2_TABLE_100
173: , a43 out nocopy JTF_VARCHAR2_TABLE_100
174: ) as
175: ddindx binary_integer; indx binary_integer;
168: , a38 out nocopy JTF_DATE_TABLE
169: , a39 out nocopy JTF_DATE_TABLE
170: , a40 out nocopy JTF_VARCHAR2_TABLE_100
171: , a41 out nocopy JTF_VARCHAR2_TABLE_100
172: , a42 out nocopy JTF_VARCHAR2_TABLE_100
173: , a43 out nocopy JTF_VARCHAR2_TABLE_100
174: ) as
175: ddindx binary_integer; indx binary_integer;
176: begin
169: , a39 out nocopy JTF_DATE_TABLE
170: , a40 out nocopy JTF_VARCHAR2_TABLE_100
171: , a41 out nocopy JTF_VARCHAR2_TABLE_100
172: , a42 out nocopy JTF_VARCHAR2_TABLE_100
173: , a43 out nocopy JTF_VARCHAR2_TABLE_100
174: ) as
175: ddindx binary_integer; indx binary_integer;
176: begin
177: if t is null or t.count = 0 then
175: ddindx binary_integer; indx binary_integer;
176: begin
177: if t is null or t.count = 0 then
178: a0 := JTF_VARCHAR2_TABLE_300();
179: a1 := JTF_VARCHAR2_TABLE_100();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
179: a1 := JTF_VARCHAR2_TABLE_100();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_100();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_100();
188: a10 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_100();
188: a10 := JTF_NUMBER_TABLE();
189: a11 := JTF_NUMBER_TABLE();
182: a4 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_100();
188: a10 := JTF_NUMBER_TABLE();
189: a11 := JTF_NUMBER_TABLE();
190: a12 := JTF_NUMBER_TABLE();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_100();
188: a10 := JTF_NUMBER_TABLE();
189: a11 := JTF_NUMBER_TABLE();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_NUMBER_TABLE();
188: a10 := JTF_NUMBER_TABLE();
189: a11 := JTF_NUMBER_TABLE();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_NUMBER_TABLE();
192: a14 := JTF_VARCHAR2_TABLE_100();
193: a15 := JTF_VARCHAR2_TABLE_500();
194: a16 := JTF_VARCHAR2_TABLE_500();
195: a17 := JTF_VARCHAR2_TABLE_500();
196: a18 := JTF_VARCHAR2_TABLE_500();
210: a32 := JTF_NUMBER_TABLE();
211: a33 := JTF_DATE_TABLE();
212: a34 := JTF_NUMBER_TABLE();
213: a35 := JTF_NUMBER_TABLE();
214: a36 := JTF_VARCHAR2_TABLE_100();
215: a37 := JTF_VARCHAR2_TABLE_100();
216: a38 := JTF_DATE_TABLE();
217: a39 := JTF_DATE_TABLE();
218: a40 := JTF_VARCHAR2_TABLE_100();
211: a33 := JTF_DATE_TABLE();
212: a34 := JTF_NUMBER_TABLE();
213: a35 := JTF_NUMBER_TABLE();
214: a36 := JTF_VARCHAR2_TABLE_100();
215: a37 := JTF_VARCHAR2_TABLE_100();
216: a38 := JTF_DATE_TABLE();
217: a39 := JTF_DATE_TABLE();
218: a40 := JTF_VARCHAR2_TABLE_100();
219: a41 := JTF_VARCHAR2_TABLE_100();
214: a36 := JTF_VARCHAR2_TABLE_100();
215: a37 := JTF_VARCHAR2_TABLE_100();
216: a38 := JTF_DATE_TABLE();
217: a39 := JTF_DATE_TABLE();
218: a40 := JTF_VARCHAR2_TABLE_100();
219: a41 := JTF_VARCHAR2_TABLE_100();
220: a42 := JTF_VARCHAR2_TABLE_100();
221: a43 := JTF_VARCHAR2_TABLE_100();
222: else
215: a37 := JTF_VARCHAR2_TABLE_100();
216: a38 := JTF_DATE_TABLE();
217: a39 := JTF_DATE_TABLE();
218: a40 := JTF_VARCHAR2_TABLE_100();
219: a41 := JTF_VARCHAR2_TABLE_100();
220: a42 := JTF_VARCHAR2_TABLE_100();
221: a43 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_VARCHAR2_TABLE_300();
216: a38 := JTF_DATE_TABLE();
217: a39 := JTF_DATE_TABLE();
218: a40 := JTF_VARCHAR2_TABLE_100();
219: a41 := JTF_VARCHAR2_TABLE_100();
220: a42 := JTF_VARCHAR2_TABLE_100();
221: a43 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_VARCHAR2_TABLE_300();
224: a1 := JTF_VARCHAR2_TABLE_100();
217: a39 := JTF_DATE_TABLE();
218: a40 := JTF_VARCHAR2_TABLE_100();
219: a41 := JTF_VARCHAR2_TABLE_100();
220: a42 := JTF_VARCHAR2_TABLE_100();
221: a43 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_VARCHAR2_TABLE_300();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_NUMBER_TABLE();
220: a42 := JTF_VARCHAR2_TABLE_100();
221: a43 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_VARCHAR2_TABLE_300();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_NUMBER_TABLE();
228: a5 := JTF_VARCHAR2_TABLE_100();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_NUMBER_TABLE();
228: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_VARCHAR2_TABLE_100();
232: a9 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_NUMBER_TABLE();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_NUMBER_TABLE();
228: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_VARCHAR2_TABLE_100();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_NUMBER_TABLE();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_NUMBER_TABLE();
228: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_VARCHAR2_TABLE_100();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_NUMBER_TABLE();
227: a4 := JTF_NUMBER_TABLE();
228: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_VARCHAR2_TABLE_100();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_NUMBER_TABLE();
235: a12 := JTF_NUMBER_TABLE();
228: a5 := JTF_VARCHAR2_TABLE_100();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_VARCHAR2_TABLE_100();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_NUMBER_TABLE();
235: a12 := JTF_NUMBER_TABLE();
236: a13 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_NUMBER_TABLE();
235: a12 := JTF_NUMBER_TABLE();
236: a13 := JTF_NUMBER_TABLE();
237: a14 := JTF_VARCHAR2_TABLE_100();
238: a15 := JTF_VARCHAR2_TABLE_500();
239: a16 := JTF_VARCHAR2_TABLE_500();
240: a17 := JTF_VARCHAR2_TABLE_500();
241: a18 := JTF_VARCHAR2_TABLE_500();
255: a32 := JTF_NUMBER_TABLE();
256: a33 := JTF_DATE_TABLE();
257: a34 := JTF_NUMBER_TABLE();
258: a35 := JTF_NUMBER_TABLE();
259: a36 := JTF_VARCHAR2_TABLE_100();
260: a37 := JTF_VARCHAR2_TABLE_100();
261: a38 := JTF_DATE_TABLE();
262: a39 := JTF_DATE_TABLE();
263: a40 := JTF_VARCHAR2_TABLE_100();
256: a33 := JTF_DATE_TABLE();
257: a34 := JTF_NUMBER_TABLE();
258: a35 := JTF_NUMBER_TABLE();
259: a36 := JTF_VARCHAR2_TABLE_100();
260: a37 := JTF_VARCHAR2_TABLE_100();
261: a38 := JTF_DATE_TABLE();
262: a39 := JTF_DATE_TABLE();
263: a40 := JTF_VARCHAR2_TABLE_100();
264: a41 := JTF_VARCHAR2_TABLE_100();
259: a36 := JTF_VARCHAR2_TABLE_100();
260: a37 := JTF_VARCHAR2_TABLE_100();
261: a38 := JTF_DATE_TABLE();
262: a39 := JTF_DATE_TABLE();
263: a40 := JTF_VARCHAR2_TABLE_100();
264: a41 := JTF_VARCHAR2_TABLE_100();
265: a42 := JTF_VARCHAR2_TABLE_100();
266: a43 := JTF_VARCHAR2_TABLE_100();
267: if t.count > 0 then
260: a37 := JTF_VARCHAR2_TABLE_100();
261: a38 := JTF_DATE_TABLE();
262: a39 := JTF_DATE_TABLE();
263: a40 := JTF_VARCHAR2_TABLE_100();
264: a41 := JTF_VARCHAR2_TABLE_100();
265: a42 := JTF_VARCHAR2_TABLE_100();
266: a43 := JTF_VARCHAR2_TABLE_100();
267: if t.count > 0 then
268: a0.extend(t.count);
261: a38 := JTF_DATE_TABLE();
262: a39 := JTF_DATE_TABLE();
263: a40 := JTF_VARCHAR2_TABLE_100();
264: a41 := JTF_VARCHAR2_TABLE_100();
265: a42 := JTF_VARCHAR2_TABLE_100();
266: a43 := JTF_VARCHAR2_TABLE_100();
267: if t.count > 0 then
268: a0.extend(t.count);
269: a1.extend(t.count);
262: a39 := JTF_DATE_TABLE();
263: a40 := JTF_VARCHAR2_TABLE_100();
264: a41 := JTF_VARCHAR2_TABLE_100();
265: a42 := JTF_VARCHAR2_TABLE_100();
266: a43 := JTF_VARCHAR2_TABLE_100();
267: if t.count > 0 then
268: a0.extend(t.count);
269: a1.extend(t.count);
270: a2.extend(t.count);
366: end if;
367: end rosetta_table_copy_out_p2;
368:
369: procedure rosetta_table_copy_in_p5(t out nocopy okl_tbc_pvt.tbc_tbl_type, a0 JTF_VARCHAR2_TABLE_300
370: , a1 JTF_VARCHAR2_TABLE_100
371: , a2 JTF_NUMBER_TABLE
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_NUMBER_TABLE
374: , a5 JTF_VARCHAR2_TABLE_100
370: , a1 JTF_VARCHAR2_TABLE_100
371: , a2 JTF_NUMBER_TABLE
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_NUMBER_TABLE
374: , a5 JTF_VARCHAR2_TABLE_100
375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_VARCHAR2_TABLE_100
377: , a8 JTF_VARCHAR2_TABLE_100
378: , a9 JTF_VARCHAR2_TABLE_100
371: , a2 JTF_NUMBER_TABLE
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_NUMBER_TABLE
374: , a5 JTF_VARCHAR2_TABLE_100
375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_VARCHAR2_TABLE_100
377: , a8 JTF_VARCHAR2_TABLE_100
378: , a9 JTF_VARCHAR2_TABLE_100
379: , a10 JTF_NUMBER_TABLE
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_NUMBER_TABLE
374: , a5 JTF_VARCHAR2_TABLE_100
375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_VARCHAR2_TABLE_100
377: , a8 JTF_VARCHAR2_TABLE_100
378: , a9 JTF_VARCHAR2_TABLE_100
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_NUMBER_TABLE
373: , a4 JTF_NUMBER_TABLE
374: , a5 JTF_VARCHAR2_TABLE_100
375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_VARCHAR2_TABLE_100
377: , a8 JTF_VARCHAR2_TABLE_100
378: , a9 JTF_VARCHAR2_TABLE_100
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_NUMBER_TABLE
381: , a12 JTF_NUMBER_TABLE
374: , a5 JTF_VARCHAR2_TABLE_100
375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_VARCHAR2_TABLE_100
377: , a8 JTF_VARCHAR2_TABLE_100
378: , a9 JTF_VARCHAR2_TABLE_100
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_NUMBER_TABLE
381: , a12 JTF_NUMBER_TABLE
382: , a13 JTF_NUMBER_TABLE
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_NUMBER_TABLE
381: , a12 JTF_NUMBER_TABLE
382: , a13 JTF_NUMBER_TABLE
383: , a14 JTF_VARCHAR2_TABLE_100
384: , a15 JTF_VARCHAR2_TABLE_500
385: , a16 JTF_VARCHAR2_TABLE_500
386: , a17 JTF_VARCHAR2_TABLE_500
387: , a18 JTF_VARCHAR2_TABLE_500
401: , a32 JTF_NUMBER_TABLE
402: , a33 JTF_DATE_TABLE
403: , a34 JTF_NUMBER_TABLE
404: , a35 JTF_NUMBER_TABLE
405: , a36 JTF_VARCHAR2_TABLE_100
406: , a37 JTF_VARCHAR2_TABLE_100
407: , a38 JTF_DATE_TABLE
408: , a39 JTF_DATE_TABLE
409: , a40 JTF_VARCHAR2_TABLE_100
402: , a33 JTF_DATE_TABLE
403: , a34 JTF_NUMBER_TABLE
404: , a35 JTF_NUMBER_TABLE
405: , a36 JTF_VARCHAR2_TABLE_100
406: , a37 JTF_VARCHAR2_TABLE_100
407: , a38 JTF_DATE_TABLE
408: , a39 JTF_DATE_TABLE
409: , a40 JTF_VARCHAR2_TABLE_100
410: , a41 JTF_VARCHAR2_TABLE_100
405: , a36 JTF_VARCHAR2_TABLE_100
406: , a37 JTF_VARCHAR2_TABLE_100
407: , a38 JTF_DATE_TABLE
408: , a39 JTF_DATE_TABLE
409: , a40 JTF_VARCHAR2_TABLE_100
410: , a41 JTF_VARCHAR2_TABLE_100
411: , a42 JTF_VARCHAR2_TABLE_100
412: , a43 JTF_VARCHAR2_TABLE_100
413: ) as
406: , a37 JTF_VARCHAR2_TABLE_100
407: , a38 JTF_DATE_TABLE
408: , a39 JTF_DATE_TABLE
409: , a40 JTF_VARCHAR2_TABLE_100
410: , a41 JTF_VARCHAR2_TABLE_100
411: , a42 JTF_VARCHAR2_TABLE_100
412: , a43 JTF_VARCHAR2_TABLE_100
413: ) as
414: ddindx binary_integer; indx binary_integer;
407: , a38 JTF_DATE_TABLE
408: , a39 JTF_DATE_TABLE
409: , a40 JTF_VARCHAR2_TABLE_100
410: , a41 JTF_VARCHAR2_TABLE_100
411: , a42 JTF_VARCHAR2_TABLE_100
412: , a43 JTF_VARCHAR2_TABLE_100
413: ) as
414: ddindx binary_integer; indx binary_integer;
415: begin
408: , a39 JTF_DATE_TABLE
409: , a40 JTF_VARCHAR2_TABLE_100
410: , a41 JTF_VARCHAR2_TABLE_100
411: , a42 JTF_VARCHAR2_TABLE_100
412: , a43 JTF_VARCHAR2_TABLE_100
413: ) as
414: ddindx binary_integer; indx binary_integer;
415: begin
416: if a0 is not null and a0.count > 0 then
471: end if;
472: end if;
473: end rosetta_table_copy_in_p5;
474: procedure rosetta_table_copy_out_p5(t okl_tbc_pvt.tbc_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
475: , a1 out nocopy JTF_VARCHAR2_TABLE_100
476: , a2 out nocopy JTF_NUMBER_TABLE
477: , a3 out nocopy JTF_NUMBER_TABLE
478: , a4 out nocopy JTF_NUMBER_TABLE
479: , a5 out nocopy JTF_VARCHAR2_TABLE_100
475: , a1 out nocopy JTF_VARCHAR2_TABLE_100
476: , a2 out nocopy JTF_NUMBER_TABLE
477: , a3 out nocopy JTF_NUMBER_TABLE
478: , a4 out nocopy JTF_NUMBER_TABLE
479: , a5 out nocopy JTF_VARCHAR2_TABLE_100
480: , a6 out nocopy JTF_VARCHAR2_TABLE_100
481: , a7 out nocopy JTF_VARCHAR2_TABLE_100
482: , a8 out nocopy JTF_VARCHAR2_TABLE_100
483: , a9 out nocopy JTF_VARCHAR2_TABLE_100
476: , a2 out nocopy JTF_NUMBER_TABLE
477: , a3 out nocopy JTF_NUMBER_TABLE
478: , a4 out nocopy JTF_NUMBER_TABLE
479: , a5 out nocopy JTF_VARCHAR2_TABLE_100
480: , a6 out nocopy JTF_VARCHAR2_TABLE_100
481: , a7 out nocopy JTF_VARCHAR2_TABLE_100
482: , a8 out nocopy JTF_VARCHAR2_TABLE_100
483: , a9 out nocopy JTF_VARCHAR2_TABLE_100
484: , a10 out nocopy JTF_NUMBER_TABLE
477: , a3 out nocopy JTF_NUMBER_TABLE
478: , a4 out nocopy JTF_NUMBER_TABLE
479: , a5 out nocopy JTF_VARCHAR2_TABLE_100
480: , a6 out nocopy JTF_VARCHAR2_TABLE_100
481: , a7 out nocopy JTF_VARCHAR2_TABLE_100
482: , a8 out nocopy JTF_VARCHAR2_TABLE_100
483: , a9 out nocopy JTF_VARCHAR2_TABLE_100
484: , a10 out nocopy JTF_NUMBER_TABLE
485: , a11 out nocopy JTF_NUMBER_TABLE
478: , a4 out nocopy JTF_NUMBER_TABLE
479: , a5 out nocopy JTF_VARCHAR2_TABLE_100
480: , a6 out nocopy JTF_VARCHAR2_TABLE_100
481: , a7 out nocopy JTF_VARCHAR2_TABLE_100
482: , a8 out nocopy JTF_VARCHAR2_TABLE_100
483: , a9 out nocopy JTF_VARCHAR2_TABLE_100
484: , a10 out nocopy JTF_NUMBER_TABLE
485: , a11 out nocopy JTF_NUMBER_TABLE
486: , a12 out nocopy JTF_NUMBER_TABLE
479: , a5 out nocopy JTF_VARCHAR2_TABLE_100
480: , a6 out nocopy JTF_VARCHAR2_TABLE_100
481: , a7 out nocopy JTF_VARCHAR2_TABLE_100
482: , a8 out nocopy JTF_VARCHAR2_TABLE_100
483: , a9 out nocopy JTF_VARCHAR2_TABLE_100
484: , a10 out nocopy JTF_NUMBER_TABLE
485: , a11 out nocopy JTF_NUMBER_TABLE
486: , a12 out nocopy JTF_NUMBER_TABLE
487: , a13 out nocopy JTF_NUMBER_TABLE
484: , a10 out nocopy JTF_NUMBER_TABLE
485: , a11 out nocopy JTF_NUMBER_TABLE
486: , a12 out nocopy JTF_NUMBER_TABLE
487: , a13 out nocopy JTF_NUMBER_TABLE
488: , a14 out nocopy JTF_VARCHAR2_TABLE_100
489: , a15 out nocopy JTF_VARCHAR2_TABLE_500
490: , a16 out nocopy JTF_VARCHAR2_TABLE_500
491: , a17 out nocopy JTF_VARCHAR2_TABLE_500
492: , a18 out nocopy JTF_VARCHAR2_TABLE_500
506: , a32 out nocopy JTF_NUMBER_TABLE
507: , a33 out nocopy JTF_DATE_TABLE
508: , a34 out nocopy JTF_NUMBER_TABLE
509: , a35 out nocopy JTF_NUMBER_TABLE
510: , a36 out nocopy JTF_VARCHAR2_TABLE_100
511: , a37 out nocopy JTF_VARCHAR2_TABLE_100
512: , a38 out nocopy JTF_DATE_TABLE
513: , a39 out nocopy JTF_DATE_TABLE
514: , a40 out nocopy JTF_VARCHAR2_TABLE_100
507: , a33 out nocopy JTF_DATE_TABLE
508: , a34 out nocopy JTF_NUMBER_TABLE
509: , a35 out nocopy JTF_NUMBER_TABLE
510: , a36 out nocopy JTF_VARCHAR2_TABLE_100
511: , a37 out nocopy JTF_VARCHAR2_TABLE_100
512: , a38 out nocopy JTF_DATE_TABLE
513: , a39 out nocopy JTF_DATE_TABLE
514: , a40 out nocopy JTF_VARCHAR2_TABLE_100
515: , a41 out nocopy JTF_VARCHAR2_TABLE_100
510: , a36 out nocopy JTF_VARCHAR2_TABLE_100
511: , a37 out nocopy JTF_VARCHAR2_TABLE_100
512: , a38 out nocopy JTF_DATE_TABLE
513: , a39 out nocopy JTF_DATE_TABLE
514: , a40 out nocopy JTF_VARCHAR2_TABLE_100
515: , a41 out nocopy JTF_VARCHAR2_TABLE_100
516: , a42 out nocopy JTF_VARCHAR2_TABLE_100
517: , a43 out nocopy JTF_VARCHAR2_TABLE_100
518: ) as
511: , a37 out nocopy JTF_VARCHAR2_TABLE_100
512: , a38 out nocopy JTF_DATE_TABLE
513: , a39 out nocopy JTF_DATE_TABLE
514: , a40 out nocopy JTF_VARCHAR2_TABLE_100
515: , a41 out nocopy JTF_VARCHAR2_TABLE_100
516: , a42 out nocopy JTF_VARCHAR2_TABLE_100
517: , a43 out nocopy JTF_VARCHAR2_TABLE_100
518: ) as
519: ddindx binary_integer; indx binary_integer;
512: , a38 out nocopy JTF_DATE_TABLE
513: , a39 out nocopy JTF_DATE_TABLE
514: , a40 out nocopy JTF_VARCHAR2_TABLE_100
515: , a41 out nocopy JTF_VARCHAR2_TABLE_100
516: , a42 out nocopy JTF_VARCHAR2_TABLE_100
517: , a43 out nocopy JTF_VARCHAR2_TABLE_100
518: ) as
519: ddindx binary_integer; indx binary_integer;
520: begin
513: , a39 out nocopy JTF_DATE_TABLE
514: , a40 out nocopy JTF_VARCHAR2_TABLE_100
515: , a41 out nocopy JTF_VARCHAR2_TABLE_100
516: , a42 out nocopy JTF_VARCHAR2_TABLE_100
517: , a43 out nocopy JTF_VARCHAR2_TABLE_100
518: ) as
519: ddindx binary_integer; indx binary_integer;
520: begin
521: if t is null or t.count = 0 then
519: ddindx binary_integer; indx binary_integer;
520: begin
521: if t is null or t.count = 0 then
522: a0 := JTF_VARCHAR2_TABLE_300();
523: a1 := JTF_VARCHAR2_TABLE_100();
524: a2 := JTF_NUMBER_TABLE();
525: a3 := JTF_NUMBER_TABLE();
526: a4 := JTF_NUMBER_TABLE();
527: a5 := JTF_VARCHAR2_TABLE_100();
523: a1 := JTF_VARCHAR2_TABLE_100();
524: a2 := JTF_NUMBER_TABLE();
525: a3 := JTF_NUMBER_TABLE();
526: a4 := JTF_NUMBER_TABLE();
527: a5 := JTF_VARCHAR2_TABLE_100();
528: a6 := JTF_VARCHAR2_TABLE_100();
529: a7 := JTF_VARCHAR2_TABLE_100();
530: a8 := JTF_VARCHAR2_TABLE_100();
531: a9 := JTF_VARCHAR2_TABLE_100();
524: a2 := JTF_NUMBER_TABLE();
525: a3 := JTF_NUMBER_TABLE();
526: a4 := JTF_NUMBER_TABLE();
527: a5 := JTF_VARCHAR2_TABLE_100();
528: a6 := JTF_VARCHAR2_TABLE_100();
529: a7 := JTF_VARCHAR2_TABLE_100();
530: a8 := JTF_VARCHAR2_TABLE_100();
531: a9 := JTF_VARCHAR2_TABLE_100();
532: a10 := JTF_NUMBER_TABLE();
525: a3 := JTF_NUMBER_TABLE();
526: a4 := JTF_NUMBER_TABLE();
527: a5 := JTF_VARCHAR2_TABLE_100();
528: a6 := JTF_VARCHAR2_TABLE_100();
529: a7 := JTF_VARCHAR2_TABLE_100();
530: a8 := JTF_VARCHAR2_TABLE_100();
531: a9 := JTF_VARCHAR2_TABLE_100();
532: a10 := JTF_NUMBER_TABLE();
533: a11 := JTF_NUMBER_TABLE();
526: a4 := JTF_NUMBER_TABLE();
527: a5 := JTF_VARCHAR2_TABLE_100();
528: a6 := JTF_VARCHAR2_TABLE_100();
529: a7 := JTF_VARCHAR2_TABLE_100();
530: a8 := JTF_VARCHAR2_TABLE_100();
531: a9 := JTF_VARCHAR2_TABLE_100();
532: a10 := JTF_NUMBER_TABLE();
533: a11 := JTF_NUMBER_TABLE();
534: a12 := JTF_NUMBER_TABLE();
527: a5 := JTF_VARCHAR2_TABLE_100();
528: a6 := JTF_VARCHAR2_TABLE_100();
529: a7 := JTF_VARCHAR2_TABLE_100();
530: a8 := JTF_VARCHAR2_TABLE_100();
531: a9 := JTF_VARCHAR2_TABLE_100();
532: a10 := JTF_NUMBER_TABLE();
533: a11 := JTF_NUMBER_TABLE();
534: a12 := JTF_NUMBER_TABLE();
535: a13 := JTF_NUMBER_TABLE();
532: a10 := JTF_NUMBER_TABLE();
533: a11 := JTF_NUMBER_TABLE();
534: a12 := JTF_NUMBER_TABLE();
535: a13 := JTF_NUMBER_TABLE();
536: a14 := JTF_VARCHAR2_TABLE_100();
537: a15 := JTF_VARCHAR2_TABLE_500();
538: a16 := JTF_VARCHAR2_TABLE_500();
539: a17 := JTF_VARCHAR2_TABLE_500();
540: a18 := JTF_VARCHAR2_TABLE_500();
554: a32 := JTF_NUMBER_TABLE();
555: a33 := JTF_DATE_TABLE();
556: a34 := JTF_NUMBER_TABLE();
557: a35 := JTF_NUMBER_TABLE();
558: a36 := JTF_VARCHAR2_TABLE_100();
559: a37 := JTF_VARCHAR2_TABLE_100();
560: a38 := JTF_DATE_TABLE();
561: a39 := JTF_DATE_TABLE();
562: a40 := JTF_VARCHAR2_TABLE_100();
555: a33 := JTF_DATE_TABLE();
556: a34 := JTF_NUMBER_TABLE();
557: a35 := JTF_NUMBER_TABLE();
558: a36 := JTF_VARCHAR2_TABLE_100();
559: a37 := JTF_VARCHAR2_TABLE_100();
560: a38 := JTF_DATE_TABLE();
561: a39 := JTF_DATE_TABLE();
562: a40 := JTF_VARCHAR2_TABLE_100();
563: a41 := JTF_VARCHAR2_TABLE_100();
558: a36 := JTF_VARCHAR2_TABLE_100();
559: a37 := JTF_VARCHAR2_TABLE_100();
560: a38 := JTF_DATE_TABLE();
561: a39 := JTF_DATE_TABLE();
562: a40 := JTF_VARCHAR2_TABLE_100();
563: a41 := JTF_VARCHAR2_TABLE_100();
564: a42 := JTF_VARCHAR2_TABLE_100();
565: a43 := JTF_VARCHAR2_TABLE_100();
566: else
559: a37 := JTF_VARCHAR2_TABLE_100();
560: a38 := JTF_DATE_TABLE();
561: a39 := JTF_DATE_TABLE();
562: a40 := JTF_VARCHAR2_TABLE_100();
563: a41 := JTF_VARCHAR2_TABLE_100();
564: a42 := JTF_VARCHAR2_TABLE_100();
565: a43 := JTF_VARCHAR2_TABLE_100();
566: else
567: a0 := JTF_VARCHAR2_TABLE_300();
560: a38 := JTF_DATE_TABLE();
561: a39 := JTF_DATE_TABLE();
562: a40 := JTF_VARCHAR2_TABLE_100();
563: a41 := JTF_VARCHAR2_TABLE_100();
564: a42 := JTF_VARCHAR2_TABLE_100();
565: a43 := JTF_VARCHAR2_TABLE_100();
566: else
567: a0 := JTF_VARCHAR2_TABLE_300();
568: a1 := JTF_VARCHAR2_TABLE_100();
561: a39 := JTF_DATE_TABLE();
562: a40 := JTF_VARCHAR2_TABLE_100();
563: a41 := JTF_VARCHAR2_TABLE_100();
564: a42 := JTF_VARCHAR2_TABLE_100();
565: a43 := JTF_VARCHAR2_TABLE_100();
566: else
567: a0 := JTF_VARCHAR2_TABLE_300();
568: a1 := JTF_VARCHAR2_TABLE_100();
569: a2 := JTF_NUMBER_TABLE();
564: a42 := JTF_VARCHAR2_TABLE_100();
565: a43 := JTF_VARCHAR2_TABLE_100();
566: else
567: a0 := JTF_VARCHAR2_TABLE_300();
568: a1 := JTF_VARCHAR2_TABLE_100();
569: a2 := JTF_NUMBER_TABLE();
570: a3 := JTF_NUMBER_TABLE();
571: a4 := JTF_NUMBER_TABLE();
572: a5 := JTF_VARCHAR2_TABLE_100();
568: a1 := JTF_VARCHAR2_TABLE_100();
569: a2 := JTF_NUMBER_TABLE();
570: a3 := JTF_NUMBER_TABLE();
571: a4 := JTF_NUMBER_TABLE();
572: a5 := JTF_VARCHAR2_TABLE_100();
573: a6 := JTF_VARCHAR2_TABLE_100();
574: a7 := JTF_VARCHAR2_TABLE_100();
575: a8 := JTF_VARCHAR2_TABLE_100();
576: a9 := JTF_VARCHAR2_TABLE_100();
569: a2 := JTF_NUMBER_TABLE();
570: a3 := JTF_NUMBER_TABLE();
571: a4 := JTF_NUMBER_TABLE();
572: a5 := JTF_VARCHAR2_TABLE_100();
573: a6 := JTF_VARCHAR2_TABLE_100();
574: a7 := JTF_VARCHAR2_TABLE_100();
575: a8 := JTF_VARCHAR2_TABLE_100();
576: a9 := JTF_VARCHAR2_TABLE_100();
577: a10 := JTF_NUMBER_TABLE();
570: a3 := JTF_NUMBER_TABLE();
571: a4 := JTF_NUMBER_TABLE();
572: a5 := JTF_VARCHAR2_TABLE_100();
573: a6 := JTF_VARCHAR2_TABLE_100();
574: a7 := JTF_VARCHAR2_TABLE_100();
575: a8 := JTF_VARCHAR2_TABLE_100();
576: a9 := JTF_VARCHAR2_TABLE_100();
577: a10 := JTF_NUMBER_TABLE();
578: a11 := JTF_NUMBER_TABLE();
571: a4 := JTF_NUMBER_TABLE();
572: a5 := JTF_VARCHAR2_TABLE_100();
573: a6 := JTF_VARCHAR2_TABLE_100();
574: a7 := JTF_VARCHAR2_TABLE_100();
575: a8 := JTF_VARCHAR2_TABLE_100();
576: a9 := JTF_VARCHAR2_TABLE_100();
577: a10 := JTF_NUMBER_TABLE();
578: a11 := JTF_NUMBER_TABLE();
579: a12 := JTF_NUMBER_TABLE();
572: a5 := JTF_VARCHAR2_TABLE_100();
573: a6 := JTF_VARCHAR2_TABLE_100();
574: a7 := JTF_VARCHAR2_TABLE_100();
575: a8 := JTF_VARCHAR2_TABLE_100();
576: a9 := JTF_VARCHAR2_TABLE_100();
577: a10 := JTF_NUMBER_TABLE();
578: a11 := JTF_NUMBER_TABLE();
579: a12 := JTF_NUMBER_TABLE();
580: a13 := JTF_NUMBER_TABLE();
577: a10 := JTF_NUMBER_TABLE();
578: a11 := JTF_NUMBER_TABLE();
579: a12 := JTF_NUMBER_TABLE();
580: a13 := JTF_NUMBER_TABLE();
581: a14 := JTF_VARCHAR2_TABLE_100();
582: a15 := JTF_VARCHAR2_TABLE_500();
583: a16 := JTF_VARCHAR2_TABLE_500();
584: a17 := JTF_VARCHAR2_TABLE_500();
585: a18 := JTF_VARCHAR2_TABLE_500();
599: a32 := JTF_NUMBER_TABLE();
600: a33 := JTF_DATE_TABLE();
601: a34 := JTF_NUMBER_TABLE();
602: a35 := JTF_NUMBER_TABLE();
603: a36 := JTF_VARCHAR2_TABLE_100();
604: a37 := JTF_VARCHAR2_TABLE_100();
605: a38 := JTF_DATE_TABLE();
606: a39 := JTF_DATE_TABLE();
607: a40 := JTF_VARCHAR2_TABLE_100();
600: a33 := JTF_DATE_TABLE();
601: a34 := JTF_NUMBER_TABLE();
602: a35 := JTF_NUMBER_TABLE();
603: a36 := JTF_VARCHAR2_TABLE_100();
604: a37 := JTF_VARCHAR2_TABLE_100();
605: a38 := JTF_DATE_TABLE();
606: a39 := JTF_DATE_TABLE();
607: a40 := JTF_VARCHAR2_TABLE_100();
608: a41 := JTF_VARCHAR2_TABLE_100();
603: a36 := JTF_VARCHAR2_TABLE_100();
604: a37 := JTF_VARCHAR2_TABLE_100();
605: a38 := JTF_DATE_TABLE();
606: a39 := JTF_DATE_TABLE();
607: a40 := JTF_VARCHAR2_TABLE_100();
608: a41 := JTF_VARCHAR2_TABLE_100();
609: a42 := JTF_VARCHAR2_TABLE_100();
610: a43 := JTF_VARCHAR2_TABLE_100();
611: if t.count > 0 then
604: a37 := JTF_VARCHAR2_TABLE_100();
605: a38 := JTF_DATE_TABLE();
606: a39 := JTF_DATE_TABLE();
607: a40 := JTF_VARCHAR2_TABLE_100();
608: a41 := JTF_VARCHAR2_TABLE_100();
609: a42 := JTF_VARCHAR2_TABLE_100();
610: a43 := JTF_VARCHAR2_TABLE_100();
611: if t.count > 0 then
612: a0.extend(t.count);
605: a38 := JTF_DATE_TABLE();
606: a39 := JTF_DATE_TABLE();
607: a40 := JTF_VARCHAR2_TABLE_100();
608: a41 := JTF_VARCHAR2_TABLE_100();
609: a42 := JTF_VARCHAR2_TABLE_100();
610: a43 := JTF_VARCHAR2_TABLE_100();
611: if t.count > 0 then
612: a0.extend(t.count);
613: a1.extend(t.count);
606: a39 := JTF_DATE_TABLE();
607: a40 := JTF_VARCHAR2_TABLE_100();
608: a41 := JTF_VARCHAR2_TABLE_100();
609: a42 := JTF_VARCHAR2_TABLE_100();
610: a43 := JTF_VARCHAR2_TABLE_100();
611: if t.count > 0 then
612: a0.extend(t.count);
613: a1.extend(t.count);
614: a2.extend(t.count);
930: , x_return_status out nocopy VARCHAR2
931: , x_msg_count out nocopy NUMBER
932: , x_msg_data out nocopy VARCHAR2
933: , p5_a0 JTF_VARCHAR2_TABLE_300
934: , p5_a1 JTF_VARCHAR2_TABLE_100
935: , p5_a2 JTF_NUMBER_TABLE
936: , p5_a3 JTF_NUMBER_TABLE
937: , p5_a4 JTF_NUMBER_TABLE
938: , p5_a5 JTF_VARCHAR2_TABLE_100
934: , p5_a1 JTF_VARCHAR2_TABLE_100
935: , p5_a2 JTF_NUMBER_TABLE
936: , p5_a3 JTF_NUMBER_TABLE
937: , p5_a4 JTF_NUMBER_TABLE
938: , p5_a5 JTF_VARCHAR2_TABLE_100
939: , p5_a6 JTF_VARCHAR2_TABLE_100
940: , p5_a7 JTF_VARCHAR2_TABLE_100
941: , p5_a8 JTF_VARCHAR2_TABLE_100
942: , p5_a9 JTF_VARCHAR2_TABLE_100
935: , p5_a2 JTF_NUMBER_TABLE
936: , p5_a3 JTF_NUMBER_TABLE
937: , p5_a4 JTF_NUMBER_TABLE
938: , p5_a5 JTF_VARCHAR2_TABLE_100
939: , p5_a6 JTF_VARCHAR2_TABLE_100
940: , p5_a7 JTF_VARCHAR2_TABLE_100
941: , p5_a8 JTF_VARCHAR2_TABLE_100
942: , p5_a9 JTF_VARCHAR2_TABLE_100
943: , p5_a10 JTF_NUMBER_TABLE
936: , p5_a3 JTF_NUMBER_TABLE
937: , p5_a4 JTF_NUMBER_TABLE
938: , p5_a5 JTF_VARCHAR2_TABLE_100
939: , p5_a6 JTF_VARCHAR2_TABLE_100
940: , p5_a7 JTF_VARCHAR2_TABLE_100
941: , p5_a8 JTF_VARCHAR2_TABLE_100
942: , p5_a9 JTF_VARCHAR2_TABLE_100
943: , p5_a10 JTF_NUMBER_TABLE
944: , p5_a11 JTF_NUMBER_TABLE
937: , p5_a4 JTF_NUMBER_TABLE
938: , p5_a5 JTF_VARCHAR2_TABLE_100
939: , p5_a6 JTF_VARCHAR2_TABLE_100
940: , p5_a7 JTF_VARCHAR2_TABLE_100
941: , p5_a8 JTF_VARCHAR2_TABLE_100
942: , p5_a9 JTF_VARCHAR2_TABLE_100
943: , p5_a10 JTF_NUMBER_TABLE
944: , p5_a11 JTF_NUMBER_TABLE
945: , p5_a12 JTF_NUMBER_TABLE
938: , p5_a5 JTF_VARCHAR2_TABLE_100
939: , p5_a6 JTF_VARCHAR2_TABLE_100
940: , p5_a7 JTF_VARCHAR2_TABLE_100
941: , p5_a8 JTF_VARCHAR2_TABLE_100
942: , p5_a9 JTF_VARCHAR2_TABLE_100
943: , p5_a10 JTF_NUMBER_TABLE
944: , p5_a11 JTF_NUMBER_TABLE
945: , p5_a12 JTF_NUMBER_TABLE
946: , p5_a13 JTF_NUMBER_TABLE
943: , p5_a10 JTF_NUMBER_TABLE
944: , p5_a11 JTF_NUMBER_TABLE
945: , p5_a12 JTF_NUMBER_TABLE
946: , p5_a13 JTF_NUMBER_TABLE
947: , p5_a14 JTF_VARCHAR2_TABLE_100
948: , p5_a15 JTF_VARCHAR2_TABLE_500
949: , p5_a16 JTF_VARCHAR2_TABLE_500
950: , p5_a17 JTF_VARCHAR2_TABLE_500
951: , p5_a18 JTF_VARCHAR2_TABLE_500
965: , p5_a32 JTF_NUMBER_TABLE
966: , p5_a33 JTF_DATE_TABLE
967: , p5_a34 JTF_NUMBER_TABLE
968: , p5_a35 JTF_NUMBER_TABLE
969: , p5_a36 JTF_VARCHAR2_TABLE_100
970: , p5_a37 JTF_VARCHAR2_TABLE_100
971: , p5_a38 JTF_DATE_TABLE
972: , p5_a39 JTF_DATE_TABLE
973: , p5_a40 JTF_VARCHAR2_TABLE_100
966: , p5_a33 JTF_DATE_TABLE
967: , p5_a34 JTF_NUMBER_TABLE
968: , p5_a35 JTF_NUMBER_TABLE
969: , p5_a36 JTF_VARCHAR2_TABLE_100
970: , p5_a37 JTF_VARCHAR2_TABLE_100
971: , p5_a38 JTF_DATE_TABLE
972: , p5_a39 JTF_DATE_TABLE
973: , p5_a40 JTF_VARCHAR2_TABLE_100
974: , p5_a41 JTF_VARCHAR2_TABLE_100
969: , p5_a36 JTF_VARCHAR2_TABLE_100
970: , p5_a37 JTF_VARCHAR2_TABLE_100
971: , p5_a38 JTF_DATE_TABLE
972: , p5_a39 JTF_DATE_TABLE
973: , p5_a40 JTF_VARCHAR2_TABLE_100
974: , p5_a41 JTF_VARCHAR2_TABLE_100
975: , p5_a42 JTF_VARCHAR2_TABLE_100
976: , p5_a43 JTF_VARCHAR2_TABLE_100
977: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
970: , p5_a37 JTF_VARCHAR2_TABLE_100
971: , p5_a38 JTF_DATE_TABLE
972: , p5_a39 JTF_DATE_TABLE
973: , p5_a40 JTF_VARCHAR2_TABLE_100
974: , p5_a41 JTF_VARCHAR2_TABLE_100
975: , p5_a42 JTF_VARCHAR2_TABLE_100
976: , p5_a43 JTF_VARCHAR2_TABLE_100
977: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
978: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
971: , p5_a38 JTF_DATE_TABLE
972: , p5_a39 JTF_DATE_TABLE
973: , p5_a40 JTF_VARCHAR2_TABLE_100
974: , p5_a41 JTF_VARCHAR2_TABLE_100
975: , p5_a42 JTF_VARCHAR2_TABLE_100
976: , p5_a43 JTF_VARCHAR2_TABLE_100
977: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
978: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
979: , p6_a2 out nocopy JTF_NUMBER_TABLE
972: , p5_a39 JTF_DATE_TABLE
973: , p5_a40 JTF_VARCHAR2_TABLE_100
974: , p5_a41 JTF_VARCHAR2_TABLE_100
975: , p5_a42 JTF_VARCHAR2_TABLE_100
976: , p5_a43 JTF_VARCHAR2_TABLE_100
977: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
978: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
979: , p6_a2 out nocopy JTF_NUMBER_TABLE
980: , p6_a3 out nocopy JTF_NUMBER_TABLE
974: , p5_a41 JTF_VARCHAR2_TABLE_100
975: , p5_a42 JTF_VARCHAR2_TABLE_100
976: , p5_a43 JTF_VARCHAR2_TABLE_100
977: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
978: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
979: , p6_a2 out nocopy JTF_NUMBER_TABLE
980: , p6_a3 out nocopy JTF_NUMBER_TABLE
981: , p6_a4 out nocopy JTF_NUMBER_TABLE
982: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
978: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
979: , p6_a2 out nocopy JTF_NUMBER_TABLE
980: , p6_a3 out nocopy JTF_NUMBER_TABLE
981: , p6_a4 out nocopy JTF_NUMBER_TABLE
982: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
983: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
986: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
979: , p6_a2 out nocopy JTF_NUMBER_TABLE
980: , p6_a3 out nocopy JTF_NUMBER_TABLE
981: , p6_a4 out nocopy JTF_NUMBER_TABLE
982: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
983: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
986: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
987: , p6_a10 out nocopy JTF_NUMBER_TABLE
980: , p6_a3 out nocopy JTF_NUMBER_TABLE
981: , p6_a4 out nocopy JTF_NUMBER_TABLE
982: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
983: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
986: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
987: , p6_a10 out nocopy JTF_NUMBER_TABLE
988: , p6_a11 out nocopy JTF_NUMBER_TABLE
981: , p6_a4 out nocopy JTF_NUMBER_TABLE
982: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
983: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
986: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
987: , p6_a10 out nocopy JTF_NUMBER_TABLE
988: , p6_a11 out nocopy JTF_NUMBER_TABLE
989: , p6_a12 out nocopy JTF_NUMBER_TABLE
982: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
983: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
986: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
987: , p6_a10 out nocopy JTF_NUMBER_TABLE
988: , p6_a11 out nocopy JTF_NUMBER_TABLE
989: , p6_a12 out nocopy JTF_NUMBER_TABLE
990: , p6_a13 out nocopy JTF_NUMBER_TABLE
987: , p6_a10 out nocopy JTF_NUMBER_TABLE
988: , p6_a11 out nocopy JTF_NUMBER_TABLE
989: , p6_a12 out nocopy JTF_NUMBER_TABLE
990: , p6_a13 out nocopy JTF_NUMBER_TABLE
991: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
992: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
993: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
994: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
995: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1009: , p6_a32 out nocopy JTF_NUMBER_TABLE
1010: , p6_a33 out nocopy JTF_DATE_TABLE
1011: , p6_a34 out nocopy JTF_NUMBER_TABLE
1012: , p6_a35 out nocopy JTF_NUMBER_TABLE
1013: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1014: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1015: , p6_a38 out nocopy JTF_DATE_TABLE
1016: , p6_a39 out nocopy JTF_DATE_TABLE
1017: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1010: , p6_a33 out nocopy JTF_DATE_TABLE
1011: , p6_a34 out nocopy JTF_NUMBER_TABLE
1012: , p6_a35 out nocopy JTF_NUMBER_TABLE
1013: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1014: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1015: , p6_a38 out nocopy JTF_DATE_TABLE
1016: , p6_a39 out nocopy JTF_DATE_TABLE
1017: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1013: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1014: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1015: , p6_a38 out nocopy JTF_DATE_TABLE
1016: , p6_a39 out nocopy JTF_DATE_TABLE
1017: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1021: )
1014: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1015: , p6_a38 out nocopy JTF_DATE_TABLE
1016: , p6_a39 out nocopy JTF_DATE_TABLE
1017: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1021: )
1022:
1015: , p6_a38 out nocopy JTF_DATE_TABLE
1016: , p6_a39 out nocopy JTF_DATE_TABLE
1017: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1021: )
1022:
1023: as
1016: , p6_a39 out nocopy JTF_DATE_TABLE
1017: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1021: )
1022:
1023: as
1024: ddp_tbcv_tbl okl_tbc_pvt.tbcv_tbl_type;
1270: , x_return_status out nocopy VARCHAR2
1271: , x_msg_count out nocopy NUMBER
1272: , x_msg_data out nocopy VARCHAR2
1273: , p5_a0 JTF_VARCHAR2_TABLE_300
1274: , p5_a1 JTF_VARCHAR2_TABLE_100
1275: , p5_a2 JTF_NUMBER_TABLE
1276: , p5_a3 JTF_NUMBER_TABLE
1277: , p5_a4 JTF_NUMBER_TABLE
1278: , p5_a5 JTF_VARCHAR2_TABLE_100
1274: , p5_a1 JTF_VARCHAR2_TABLE_100
1275: , p5_a2 JTF_NUMBER_TABLE
1276: , p5_a3 JTF_NUMBER_TABLE
1277: , p5_a4 JTF_NUMBER_TABLE
1278: , p5_a5 JTF_VARCHAR2_TABLE_100
1279: , p5_a6 JTF_VARCHAR2_TABLE_100
1280: , p5_a7 JTF_VARCHAR2_TABLE_100
1281: , p5_a8 JTF_VARCHAR2_TABLE_100
1282: , p5_a9 JTF_VARCHAR2_TABLE_100
1275: , p5_a2 JTF_NUMBER_TABLE
1276: , p5_a3 JTF_NUMBER_TABLE
1277: , p5_a4 JTF_NUMBER_TABLE
1278: , p5_a5 JTF_VARCHAR2_TABLE_100
1279: , p5_a6 JTF_VARCHAR2_TABLE_100
1280: , p5_a7 JTF_VARCHAR2_TABLE_100
1281: , p5_a8 JTF_VARCHAR2_TABLE_100
1282: , p5_a9 JTF_VARCHAR2_TABLE_100
1283: , p5_a10 JTF_NUMBER_TABLE
1276: , p5_a3 JTF_NUMBER_TABLE
1277: , p5_a4 JTF_NUMBER_TABLE
1278: , p5_a5 JTF_VARCHAR2_TABLE_100
1279: , p5_a6 JTF_VARCHAR2_TABLE_100
1280: , p5_a7 JTF_VARCHAR2_TABLE_100
1281: , p5_a8 JTF_VARCHAR2_TABLE_100
1282: , p5_a9 JTF_VARCHAR2_TABLE_100
1283: , p5_a10 JTF_NUMBER_TABLE
1284: , p5_a11 JTF_NUMBER_TABLE
1277: , p5_a4 JTF_NUMBER_TABLE
1278: , p5_a5 JTF_VARCHAR2_TABLE_100
1279: , p5_a6 JTF_VARCHAR2_TABLE_100
1280: , p5_a7 JTF_VARCHAR2_TABLE_100
1281: , p5_a8 JTF_VARCHAR2_TABLE_100
1282: , p5_a9 JTF_VARCHAR2_TABLE_100
1283: , p5_a10 JTF_NUMBER_TABLE
1284: , p5_a11 JTF_NUMBER_TABLE
1285: , p5_a12 JTF_NUMBER_TABLE
1278: , p5_a5 JTF_VARCHAR2_TABLE_100
1279: , p5_a6 JTF_VARCHAR2_TABLE_100
1280: , p5_a7 JTF_VARCHAR2_TABLE_100
1281: , p5_a8 JTF_VARCHAR2_TABLE_100
1282: , p5_a9 JTF_VARCHAR2_TABLE_100
1283: , p5_a10 JTF_NUMBER_TABLE
1284: , p5_a11 JTF_NUMBER_TABLE
1285: , p5_a12 JTF_NUMBER_TABLE
1286: , p5_a13 JTF_NUMBER_TABLE
1283: , p5_a10 JTF_NUMBER_TABLE
1284: , p5_a11 JTF_NUMBER_TABLE
1285: , p5_a12 JTF_NUMBER_TABLE
1286: , p5_a13 JTF_NUMBER_TABLE
1287: , p5_a14 JTF_VARCHAR2_TABLE_100
1288: , p5_a15 JTF_VARCHAR2_TABLE_500
1289: , p5_a16 JTF_VARCHAR2_TABLE_500
1290: , p5_a17 JTF_VARCHAR2_TABLE_500
1291: , p5_a18 JTF_VARCHAR2_TABLE_500
1305: , p5_a32 JTF_NUMBER_TABLE
1306: , p5_a33 JTF_DATE_TABLE
1307: , p5_a34 JTF_NUMBER_TABLE
1308: , p5_a35 JTF_NUMBER_TABLE
1309: , p5_a36 JTF_VARCHAR2_TABLE_100
1310: , p5_a37 JTF_VARCHAR2_TABLE_100
1311: , p5_a38 JTF_DATE_TABLE
1312: , p5_a39 JTF_DATE_TABLE
1313: , p5_a40 JTF_VARCHAR2_TABLE_100
1306: , p5_a33 JTF_DATE_TABLE
1307: , p5_a34 JTF_NUMBER_TABLE
1308: , p5_a35 JTF_NUMBER_TABLE
1309: , p5_a36 JTF_VARCHAR2_TABLE_100
1310: , p5_a37 JTF_VARCHAR2_TABLE_100
1311: , p5_a38 JTF_DATE_TABLE
1312: , p5_a39 JTF_DATE_TABLE
1313: , p5_a40 JTF_VARCHAR2_TABLE_100
1314: , p5_a41 JTF_VARCHAR2_TABLE_100
1309: , p5_a36 JTF_VARCHAR2_TABLE_100
1310: , p5_a37 JTF_VARCHAR2_TABLE_100
1311: , p5_a38 JTF_DATE_TABLE
1312: , p5_a39 JTF_DATE_TABLE
1313: , p5_a40 JTF_VARCHAR2_TABLE_100
1314: , p5_a41 JTF_VARCHAR2_TABLE_100
1315: , p5_a42 JTF_VARCHAR2_TABLE_100
1316: , p5_a43 JTF_VARCHAR2_TABLE_100
1317: )
1310: , p5_a37 JTF_VARCHAR2_TABLE_100
1311: , p5_a38 JTF_DATE_TABLE
1312: , p5_a39 JTF_DATE_TABLE
1313: , p5_a40 JTF_VARCHAR2_TABLE_100
1314: , p5_a41 JTF_VARCHAR2_TABLE_100
1315: , p5_a42 JTF_VARCHAR2_TABLE_100
1316: , p5_a43 JTF_VARCHAR2_TABLE_100
1317: )
1318:
1311: , p5_a38 JTF_DATE_TABLE
1312: , p5_a39 JTF_DATE_TABLE
1313: , p5_a40 JTF_VARCHAR2_TABLE_100
1314: , p5_a41 JTF_VARCHAR2_TABLE_100
1315: , p5_a42 JTF_VARCHAR2_TABLE_100
1316: , p5_a43 JTF_VARCHAR2_TABLE_100
1317: )
1318:
1319: as
1312: , p5_a39 JTF_DATE_TABLE
1313: , p5_a40 JTF_VARCHAR2_TABLE_100
1314: , p5_a41 JTF_VARCHAR2_TABLE_100
1315: , p5_a42 JTF_VARCHAR2_TABLE_100
1316: , p5_a43 JTF_VARCHAR2_TABLE_100
1317: )
1318:
1319: as
1320: ddp_tbcv_tbl okl_tbc_pvt.tbcv_tbl_type;
1609: , x_return_status out nocopy VARCHAR2
1610: , x_msg_count out nocopy NUMBER
1611: , x_msg_data out nocopy VARCHAR2
1612: , p5_a0 JTF_VARCHAR2_TABLE_300
1613: , p5_a1 JTF_VARCHAR2_TABLE_100
1614: , p5_a2 JTF_NUMBER_TABLE
1615: , p5_a3 JTF_NUMBER_TABLE
1616: , p5_a4 JTF_NUMBER_TABLE
1617: , p5_a5 JTF_VARCHAR2_TABLE_100
1613: , p5_a1 JTF_VARCHAR2_TABLE_100
1614: , p5_a2 JTF_NUMBER_TABLE
1615: , p5_a3 JTF_NUMBER_TABLE
1616: , p5_a4 JTF_NUMBER_TABLE
1617: , p5_a5 JTF_VARCHAR2_TABLE_100
1618: , p5_a6 JTF_VARCHAR2_TABLE_100
1619: , p5_a7 JTF_VARCHAR2_TABLE_100
1620: , p5_a8 JTF_VARCHAR2_TABLE_100
1621: , p5_a9 JTF_VARCHAR2_TABLE_100
1614: , p5_a2 JTF_NUMBER_TABLE
1615: , p5_a3 JTF_NUMBER_TABLE
1616: , p5_a4 JTF_NUMBER_TABLE
1617: , p5_a5 JTF_VARCHAR2_TABLE_100
1618: , p5_a6 JTF_VARCHAR2_TABLE_100
1619: , p5_a7 JTF_VARCHAR2_TABLE_100
1620: , p5_a8 JTF_VARCHAR2_TABLE_100
1621: , p5_a9 JTF_VARCHAR2_TABLE_100
1622: , p5_a10 JTF_NUMBER_TABLE
1615: , p5_a3 JTF_NUMBER_TABLE
1616: , p5_a4 JTF_NUMBER_TABLE
1617: , p5_a5 JTF_VARCHAR2_TABLE_100
1618: , p5_a6 JTF_VARCHAR2_TABLE_100
1619: , p5_a7 JTF_VARCHAR2_TABLE_100
1620: , p5_a8 JTF_VARCHAR2_TABLE_100
1621: , p5_a9 JTF_VARCHAR2_TABLE_100
1622: , p5_a10 JTF_NUMBER_TABLE
1623: , p5_a11 JTF_NUMBER_TABLE
1616: , p5_a4 JTF_NUMBER_TABLE
1617: , p5_a5 JTF_VARCHAR2_TABLE_100
1618: , p5_a6 JTF_VARCHAR2_TABLE_100
1619: , p5_a7 JTF_VARCHAR2_TABLE_100
1620: , p5_a8 JTF_VARCHAR2_TABLE_100
1621: , p5_a9 JTF_VARCHAR2_TABLE_100
1622: , p5_a10 JTF_NUMBER_TABLE
1623: , p5_a11 JTF_NUMBER_TABLE
1624: , p5_a12 JTF_NUMBER_TABLE
1617: , p5_a5 JTF_VARCHAR2_TABLE_100
1618: , p5_a6 JTF_VARCHAR2_TABLE_100
1619: , p5_a7 JTF_VARCHAR2_TABLE_100
1620: , p5_a8 JTF_VARCHAR2_TABLE_100
1621: , p5_a9 JTF_VARCHAR2_TABLE_100
1622: , p5_a10 JTF_NUMBER_TABLE
1623: , p5_a11 JTF_NUMBER_TABLE
1624: , p5_a12 JTF_NUMBER_TABLE
1625: , p5_a13 JTF_NUMBER_TABLE
1622: , p5_a10 JTF_NUMBER_TABLE
1623: , p5_a11 JTF_NUMBER_TABLE
1624: , p5_a12 JTF_NUMBER_TABLE
1625: , p5_a13 JTF_NUMBER_TABLE
1626: , p5_a14 JTF_VARCHAR2_TABLE_100
1627: , p5_a15 JTF_VARCHAR2_TABLE_500
1628: , p5_a16 JTF_VARCHAR2_TABLE_500
1629: , p5_a17 JTF_VARCHAR2_TABLE_500
1630: , p5_a18 JTF_VARCHAR2_TABLE_500
1644: , p5_a32 JTF_NUMBER_TABLE
1645: , p5_a33 JTF_DATE_TABLE
1646: , p5_a34 JTF_NUMBER_TABLE
1647: , p5_a35 JTF_NUMBER_TABLE
1648: , p5_a36 JTF_VARCHAR2_TABLE_100
1649: , p5_a37 JTF_VARCHAR2_TABLE_100
1650: , p5_a38 JTF_DATE_TABLE
1651: , p5_a39 JTF_DATE_TABLE
1652: , p5_a40 JTF_VARCHAR2_TABLE_100
1645: , p5_a33 JTF_DATE_TABLE
1646: , p5_a34 JTF_NUMBER_TABLE
1647: , p5_a35 JTF_NUMBER_TABLE
1648: , p5_a36 JTF_VARCHAR2_TABLE_100
1649: , p5_a37 JTF_VARCHAR2_TABLE_100
1650: , p5_a38 JTF_DATE_TABLE
1651: , p5_a39 JTF_DATE_TABLE
1652: , p5_a40 JTF_VARCHAR2_TABLE_100
1653: , p5_a41 JTF_VARCHAR2_TABLE_100
1648: , p5_a36 JTF_VARCHAR2_TABLE_100
1649: , p5_a37 JTF_VARCHAR2_TABLE_100
1650: , p5_a38 JTF_DATE_TABLE
1651: , p5_a39 JTF_DATE_TABLE
1652: , p5_a40 JTF_VARCHAR2_TABLE_100
1653: , p5_a41 JTF_VARCHAR2_TABLE_100
1654: , p5_a42 JTF_VARCHAR2_TABLE_100
1655: , p5_a43 JTF_VARCHAR2_TABLE_100
1656: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
1649: , p5_a37 JTF_VARCHAR2_TABLE_100
1650: , p5_a38 JTF_DATE_TABLE
1651: , p5_a39 JTF_DATE_TABLE
1652: , p5_a40 JTF_VARCHAR2_TABLE_100
1653: , p5_a41 JTF_VARCHAR2_TABLE_100
1654: , p5_a42 JTF_VARCHAR2_TABLE_100
1655: , p5_a43 JTF_VARCHAR2_TABLE_100
1656: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
1657: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1650: , p5_a38 JTF_DATE_TABLE
1651: , p5_a39 JTF_DATE_TABLE
1652: , p5_a40 JTF_VARCHAR2_TABLE_100
1653: , p5_a41 JTF_VARCHAR2_TABLE_100
1654: , p5_a42 JTF_VARCHAR2_TABLE_100
1655: , p5_a43 JTF_VARCHAR2_TABLE_100
1656: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
1657: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1658: , p6_a2 out nocopy JTF_NUMBER_TABLE
1651: , p5_a39 JTF_DATE_TABLE
1652: , p5_a40 JTF_VARCHAR2_TABLE_100
1653: , p5_a41 JTF_VARCHAR2_TABLE_100
1654: , p5_a42 JTF_VARCHAR2_TABLE_100
1655: , p5_a43 JTF_VARCHAR2_TABLE_100
1656: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
1657: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1658: , p6_a2 out nocopy JTF_NUMBER_TABLE
1659: , p6_a3 out nocopy JTF_NUMBER_TABLE
1653: , p5_a41 JTF_VARCHAR2_TABLE_100
1654: , p5_a42 JTF_VARCHAR2_TABLE_100
1655: , p5_a43 JTF_VARCHAR2_TABLE_100
1656: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_300
1657: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1658: , p6_a2 out nocopy JTF_NUMBER_TABLE
1659: , p6_a3 out nocopy JTF_NUMBER_TABLE
1660: , p6_a4 out nocopy JTF_NUMBER_TABLE
1661: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1657: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1658: , p6_a2 out nocopy JTF_NUMBER_TABLE
1659: , p6_a3 out nocopy JTF_NUMBER_TABLE
1660: , p6_a4 out nocopy JTF_NUMBER_TABLE
1661: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1662: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1664: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1665: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1658: , p6_a2 out nocopy JTF_NUMBER_TABLE
1659: , p6_a3 out nocopy JTF_NUMBER_TABLE
1660: , p6_a4 out nocopy JTF_NUMBER_TABLE
1661: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1662: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1664: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1665: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1666: , p6_a10 out nocopy JTF_NUMBER_TABLE
1659: , p6_a3 out nocopy JTF_NUMBER_TABLE
1660: , p6_a4 out nocopy JTF_NUMBER_TABLE
1661: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1662: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1664: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1665: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1666: , p6_a10 out nocopy JTF_NUMBER_TABLE
1667: , p6_a11 out nocopy JTF_NUMBER_TABLE
1660: , p6_a4 out nocopy JTF_NUMBER_TABLE
1661: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1662: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1664: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1665: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1666: , p6_a10 out nocopy JTF_NUMBER_TABLE
1667: , p6_a11 out nocopy JTF_NUMBER_TABLE
1668: , p6_a12 out nocopy JTF_NUMBER_TABLE
1661: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1662: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1664: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1665: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1666: , p6_a10 out nocopy JTF_NUMBER_TABLE
1667: , p6_a11 out nocopy JTF_NUMBER_TABLE
1668: , p6_a12 out nocopy JTF_NUMBER_TABLE
1669: , p6_a13 out nocopy JTF_NUMBER_TABLE
1666: , p6_a10 out nocopy JTF_NUMBER_TABLE
1667: , p6_a11 out nocopy JTF_NUMBER_TABLE
1668: , p6_a12 out nocopy JTF_NUMBER_TABLE
1669: , p6_a13 out nocopy JTF_NUMBER_TABLE
1670: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1671: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1672: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1673: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1674: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1688: , p6_a32 out nocopy JTF_NUMBER_TABLE
1689: , p6_a33 out nocopy JTF_DATE_TABLE
1690: , p6_a34 out nocopy JTF_NUMBER_TABLE
1691: , p6_a35 out nocopy JTF_NUMBER_TABLE
1692: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1693: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1694: , p6_a38 out nocopy JTF_DATE_TABLE
1695: , p6_a39 out nocopy JTF_DATE_TABLE
1696: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1689: , p6_a33 out nocopy JTF_DATE_TABLE
1690: , p6_a34 out nocopy JTF_NUMBER_TABLE
1691: , p6_a35 out nocopy JTF_NUMBER_TABLE
1692: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1693: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1694: , p6_a38 out nocopy JTF_DATE_TABLE
1695: , p6_a39 out nocopy JTF_DATE_TABLE
1696: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1697: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1692: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1693: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1694: , p6_a38 out nocopy JTF_DATE_TABLE
1695: , p6_a39 out nocopy JTF_DATE_TABLE
1696: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1697: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1698: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1699: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1700: )
1693: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1694: , p6_a38 out nocopy JTF_DATE_TABLE
1695: , p6_a39 out nocopy JTF_DATE_TABLE
1696: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1697: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1698: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1699: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1700: )
1701:
1694: , p6_a38 out nocopy JTF_DATE_TABLE
1695: , p6_a39 out nocopy JTF_DATE_TABLE
1696: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1697: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1698: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1699: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1700: )
1701:
1702: as
1695: , p6_a39 out nocopy JTF_DATE_TABLE
1696: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1697: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1698: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1699: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1700: )
1701:
1702: as
1703: ddp_tbcv_tbl okl_tbc_pvt.tbcv_tbl_type;
1949: , x_return_status out nocopy VARCHAR2
1950: , x_msg_count out nocopy NUMBER
1951: , x_msg_data out nocopy VARCHAR2
1952: , p5_a0 JTF_VARCHAR2_TABLE_300
1953: , p5_a1 JTF_VARCHAR2_TABLE_100
1954: , p5_a2 JTF_NUMBER_TABLE
1955: , p5_a3 JTF_NUMBER_TABLE
1956: , p5_a4 JTF_NUMBER_TABLE
1957: , p5_a5 JTF_VARCHAR2_TABLE_100
1953: , p5_a1 JTF_VARCHAR2_TABLE_100
1954: , p5_a2 JTF_NUMBER_TABLE
1955: , p5_a3 JTF_NUMBER_TABLE
1956: , p5_a4 JTF_NUMBER_TABLE
1957: , p5_a5 JTF_VARCHAR2_TABLE_100
1958: , p5_a6 JTF_VARCHAR2_TABLE_100
1959: , p5_a7 JTF_VARCHAR2_TABLE_100
1960: , p5_a8 JTF_VARCHAR2_TABLE_100
1961: , p5_a9 JTF_VARCHAR2_TABLE_100
1954: , p5_a2 JTF_NUMBER_TABLE
1955: , p5_a3 JTF_NUMBER_TABLE
1956: , p5_a4 JTF_NUMBER_TABLE
1957: , p5_a5 JTF_VARCHAR2_TABLE_100
1958: , p5_a6 JTF_VARCHAR2_TABLE_100
1959: , p5_a7 JTF_VARCHAR2_TABLE_100
1960: , p5_a8 JTF_VARCHAR2_TABLE_100
1961: , p5_a9 JTF_VARCHAR2_TABLE_100
1962: , p5_a10 JTF_NUMBER_TABLE
1955: , p5_a3 JTF_NUMBER_TABLE
1956: , p5_a4 JTF_NUMBER_TABLE
1957: , p5_a5 JTF_VARCHAR2_TABLE_100
1958: , p5_a6 JTF_VARCHAR2_TABLE_100
1959: , p5_a7 JTF_VARCHAR2_TABLE_100
1960: , p5_a8 JTF_VARCHAR2_TABLE_100
1961: , p5_a9 JTF_VARCHAR2_TABLE_100
1962: , p5_a10 JTF_NUMBER_TABLE
1963: , p5_a11 JTF_NUMBER_TABLE
1956: , p5_a4 JTF_NUMBER_TABLE
1957: , p5_a5 JTF_VARCHAR2_TABLE_100
1958: , p5_a6 JTF_VARCHAR2_TABLE_100
1959: , p5_a7 JTF_VARCHAR2_TABLE_100
1960: , p5_a8 JTF_VARCHAR2_TABLE_100
1961: , p5_a9 JTF_VARCHAR2_TABLE_100
1962: , p5_a10 JTF_NUMBER_TABLE
1963: , p5_a11 JTF_NUMBER_TABLE
1964: , p5_a12 JTF_NUMBER_TABLE
1957: , p5_a5 JTF_VARCHAR2_TABLE_100
1958: , p5_a6 JTF_VARCHAR2_TABLE_100
1959: , p5_a7 JTF_VARCHAR2_TABLE_100
1960: , p5_a8 JTF_VARCHAR2_TABLE_100
1961: , p5_a9 JTF_VARCHAR2_TABLE_100
1962: , p5_a10 JTF_NUMBER_TABLE
1963: , p5_a11 JTF_NUMBER_TABLE
1964: , p5_a12 JTF_NUMBER_TABLE
1965: , p5_a13 JTF_NUMBER_TABLE
1962: , p5_a10 JTF_NUMBER_TABLE
1963: , p5_a11 JTF_NUMBER_TABLE
1964: , p5_a12 JTF_NUMBER_TABLE
1965: , p5_a13 JTF_NUMBER_TABLE
1966: , p5_a14 JTF_VARCHAR2_TABLE_100
1967: , p5_a15 JTF_VARCHAR2_TABLE_500
1968: , p5_a16 JTF_VARCHAR2_TABLE_500
1969: , p5_a17 JTF_VARCHAR2_TABLE_500
1970: , p5_a18 JTF_VARCHAR2_TABLE_500
1984: , p5_a32 JTF_NUMBER_TABLE
1985: , p5_a33 JTF_DATE_TABLE
1986: , p5_a34 JTF_NUMBER_TABLE
1987: , p5_a35 JTF_NUMBER_TABLE
1988: , p5_a36 JTF_VARCHAR2_TABLE_100
1989: , p5_a37 JTF_VARCHAR2_TABLE_100
1990: , p5_a38 JTF_DATE_TABLE
1991: , p5_a39 JTF_DATE_TABLE
1992: , p5_a40 JTF_VARCHAR2_TABLE_100
1985: , p5_a33 JTF_DATE_TABLE
1986: , p5_a34 JTF_NUMBER_TABLE
1987: , p5_a35 JTF_NUMBER_TABLE
1988: , p5_a36 JTF_VARCHAR2_TABLE_100
1989: , p5_a37 JTF_VARCHAR2_TABLE_100
1990: , p5_a38 JTF_DATE_TABLE
1991: , p5_a39 JTF_DATE_TABLE
1992: , p5_a40 JTF_VARCHAR2_TABLE_100
1993: , p5_a41 JTF_VARCHAR2_TABLE_100
1988: , p5_a36 JTF_VARCHAR2_TABLE_100
1989: , p5_a37 JTF_VARCHAR2_TABLE_100
1990: , p5_a38 JTF_DATE_TABLE
1991: , p5_a39 JTF_DATE_TABLE
1992: , p5_a40 JTF_VARCHAR2_TABLE_100
1993: , p5_a41 JTF_VARCHAR2_TABLE_100
1994: , p5_a42 JTF_VARCHAR2_TABLE_100
1995: , p5_a43 JTF_VARCHAR2_TABLE_100
1996: )
1989: , p5_a37 JTF_VARCHAR2_TABLE_100
1990: , p5_a38 JTF_DATE_TABLE
1991: , p5_a39 JTF_DATE_TABLE
1992: , p5_a40 JTF_VARCHAR2_TABLE_100
1993: , p5_a41 JTF_VARCHAR2_TABLE_100
1994: , p5_a42 JTF_VARCHAR2_TABLE_100
1995: , p5_a43 JTF_VARCHAR2_TABLE_100
1996: )
1997:
1990: , p5_a38 JTF_DATE_TABLE
1991: , p5_a39 JTF_DATE_TABLE
1992: , p5_a40 JTF_VARCHAR2_TABLE_100
1993: , p5_a41 JTF_VARCHAR2_TABLE_100
1994: , p5_a42 JTF_VARCHAR2_TABLE_100
1995: , p5_a43 JTF_VARCHAR2_TABLE_100
1996: )
1997:
1998: as
1991: , p5_a39 JTF_DATE_TABLE
1992: , p5_a40 JTF_VARCHAR2_TABLE_100
1993: , p5_a41 JTF_VARCHAR2_TABLE_100
1994: , p5_a42 JTF_VARCHAR2_TABLE_100
1995: , p5_a43 JTF_VARCHAR2_TABLE_100
1996: )
1997:
1998: as
1999: ddp_tbcv_tbl okl_tbc_pvt.tbcv_tbl_type;
2196: , x_return_status out nocopy VARCHAR2
2197: , x_msg_count out nocopy NUMBER
2198: , x_msg_data out nocopy VARCHAR2
2199: , p5_a0 JTF_VARCHAR2_TABLE_300
2200: , p5_a1 JTF_VARCHAR2_TABLE_100
2201: , p5_a2 JTF_NUMBER_TABLE
2202: , p5_a3 JTF_NUMBER_TABLE
2203: , p5_a4 JTF_NUMBER_TABLE
2204: , p5_a5 JTF_VARCHAR2_TABLE_100
2200: , p5_a1 JTF_VARCHAR2_TABLE_100
2201: , p5_a2 JTF_NUMBER_TABLE
2202: , p5_a3 JTF_NUMBER_TABLE
2203: , p5_a4 JTF_NUMBER_TABLE
2204: , p5_a5 JTF_VARCHAR2_TABLE_100
2205: , p5_a6 JTF_VARCHAR2_TABLE_100
2206: , p5_a7 JTF_VARCHAR2_TABLE_100
2207: , p5_a8 JTF_VARCHAR2_TABLE_100
2208: , p5_a9 JTF_VARCHAR2_TABLE_100
2201: , p5_a2 JTF_NUMBER_TABLE
2202: , p5_a3 JTF_NUMBER_TABLE
2203: , p5_a4 JTF_NUMBER_TABLE
2204: , p5_a5 JTF_VARCHAR2_TABLE_100
2205: , p5_a6 JTF_VARCHAR2_TABLE_100
2206: , p5_a7 JTF_VARCHAR2_TABLE_100
2207: , p5_a8 JTF_VARCHAR2_TABLE_100
2208: , p5_a9 JTF_VARCHAR2_TABLE_100
2209: , p5_a10 JTF_NUMBER_TABLE
2202: , p5_a3 JTF_NUMBER_TABLE
2203: , p5_a4 JTF_NUMBER_TABLE
2204: , p5_a5 JTF_VARCHAR2_TABLE_100
2205: , p5_a6 JTF_VARCHAR2_TABLE_100
2206: , p5_a7 JTF_VARCHAR2_TABLE_100
2207: , p5_a8 JTF_VARCHAR2_TABLE_100
2208: , p5_a9 JTF_VARCHAR2_TABLE_100
2209: , p5_a10 JTF_NUMBER_TABLE
2210: , p5_a11 JTF_NUMBER_TABLE
2203: , p5_a4 JTF_NUMBER_TABLE
2204: , p5_a5 JTF_VARCHAR2_TABLE_100
2205: , p5_a6 JTF_VARCHAR2_TABLE_100
2206: , p5_a7 JTF_VARCHAR2_TABLE_100
2207: , p5_a8 JTF_VARCHAR2_TABLE_100
2208: , p5_a9 JTF_VARCHAR2_TABLE_100
2209: , p5_a10 JTF_NUMBER_TABLE
2210: , p5_a11 JTF_NUMBER_TABLE
2211: , p5_a12 JTF_NUMBER_TABLE
2204: , p5_a5 JTF_VARCHAR2_TABLE_100
2205: , p5_a6 JTF_VARCHAR2_TABLE_100
2206: , p5_a7 JTF_VARCHAR2_TABLE_100
2207: , p5_a8 JTF_VARCHAR2_TABLE_100
2208: , p5_a9 JTF_VARCHAR2_TABLE_100
2209: , p5_a10 JTF_NUMBER_TABLE
2210: , p5_a11 JTF_NUMBER_TABLE
2211: , p5_a12 JTF_NUMBER_TABLE
2212: , p5_a13 JTF_NUMBER_TABLE
2209: , p5_a10 JTF_NUMBER_TABLE
2210: , p5_a11 JTF_NUMBER_TABLE
2211: , p5_a12 JTF_NUMBER_TABLE
2212: , p5_a13 JTF_NUMBER_TABLE
2213: , p5_a14 JTF_VARCHAR2_TABLE_100
2214: , p5_a15 JTF_VARCHAR2_TABLE_500
2215: , p5_a16 JTF_VARCHAR2_TABLE_500
2216: , p5_a17 JTF_VARCHAR2_TABLE_500
2217: , p5_a18 JTF_VARCHAR2_TABLE_500
2231: , p5_a32 JTF_NUMBER_TABLE
2232: , p5_a33 JTF_DATE_TABLE
2233: , p5_a34 JTF_NUMBER_TABLE
2234: , p5_a35 JTF_NUMBER_TABLE
2235: , p5_a36 JTF_VARCHAR2_TABLE_100
2236: , p5_a37 JTF_VARCHAR2_TABLE_100
2237: , p5_a38 JTF_DATE_TABLE
2238: , p5_a39 JTF_DATE_TABLE
2239: , p5_a40 JTF_VARCHAR2_TABLE_100
2232: , p5_a33 JTF_DATE_TABLE
2233: , p5_a34 JTF_NUMBER_TABLE
2234: , p5_a35 JTF_NUMBER_TABLE
2235: , p5_a36 JTF_VARCHAR2_TABLE_100
2236: , p5_a37 JTF_VARCHAR2_TABLE_100
2237: , p5_a38 JTF_DATE_TABLE
2238: , p5_a39 JTF_DATE_TABLE
2239: , p5_a40 JTF_VARCHAR2_TABLE_100
2240: , p5_a41 JTF_VARCHAR2_TABLE_100
2235: , p5_a36 JTF_VARCHAR2_TABLE_100
2236: , p5_a37 JTF_VARCHAR2_TABLE_100
2237: , p5_a38 JTF_DATE_TABLE
2238: , p5_a39 JTF_DATE_TABLE
2239: , p5_a40 JTF_VARCHAR2_TABLE_100
2240: , p5_a41 JTF_VARCHAR2_TABLE_100
2241: , p5_a42 JTF_VARCHAR2_TABLE_100
2242: , p5_a43 JTF_VARCHAR2_TABLE_100
2243: )
2236: , p5_a37 JTF_VARCHAR2_TABLE_100
2237: , p5_a38 JTF_DATE_TABLE
2238: , p5_a39 JTF_DATE_TABLE
2239: , p5_a40 JTF_VARCHAR2_TABLE_100
2240: , p5_a41 JTF_VARCHAR2_TABLE_100
2241: , p5_a42 JTF_VARCHAR2_TABLE_100
2242: , p5_a43 JTF_VARCHAR2_TABLE_100
2243: )
2244:
2237: , p5_a38 JTF_DATE_TABLE
2238: , p5_a39 JTF_DATE_TABLE
2239: , p5_a40 JTF_VARCHAR2_TABLE_100
2240: , p5_a41 JTF_VARCHAR2_TABLE_100
2241: , p5_a42 JTF_VARCHAR2_TABLE_100
2242: , p5_a43 JTF_VARCHAR2_TABLE_100
2243: )
2244:
2245: as
2238: , p5_a39 JTF_DATE_TABLE
2239: , p5_a40 JTF_VARCHAR2_TABLE_100
2240: , p5_a41 JTF_VARCHAR2_TABLE_100
2241: , p5_a42 JTF_VARCHAR2_TABLE_100
2242: , p5_a43 JTF_VARCHAR2_TABLE_100
2243: )
2244:
2245: as
2246: ddp_tbcv_tbl okl_tbc_pvt.tbcv_tbl_type;