eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ETH_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_eth_pvt_w as
2: /* $Header: OKLIETHB.pls 120.0 2005/07/07 10:38:19 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body okl_eth_pvt_w as
2: /* $Header: OKLIETHB.pls 120.0 2005/07/07 10:38:19 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100

Line 32: , a29 JTF_NUMBER_TABLE

28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE

Line 34: , a31 JTF_NUMBER_TABLE

30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: ) as
38: ddindx binary_integer; indx binary_integer;

Line 36: , a33 JTF_NUMBER_TABLE

32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 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

Line 88: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE

84: end loop;
85: end if;
86: end if;
87: end rosetta_table_copy_in_p1;
88: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_300
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_NUMBER_TABLE

Line 89: , a1 out nocopy JTF_NUMBER_TABLE

85: end if;
86: end if;
87: end rosetta_table_copy_in_p1;
88: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_300
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 92: , a4 out nocopy JTF_NUMBER_TABLE

88: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_300
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 95: , a7 out nocopy JTF_NUMBER_TABLE

91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_VARCHAR2_TABLE_100
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_DATE_TABLE

Line 97: , a9 out nocopy JTF_NUMBER_TABLE

93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_VARCHAR2_TABLE_100
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_DATE_TABLE
100: , a12 out nocopy JTF_DATE_TABLE
101: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a29 out nocopy JTF_NUMBER_TABLE

113: , a25 out nocopy JTF_VARCHAR2_TABLE_500
114: , a26 out nocopy JTF_VARCHAR2_TABLE_500
115: , a27 out nocopy JTF_VARCHAR2_TABLE_500
116: , a28 out nocopy JTF_VARCHAR2_TABLE_500
117: , a29 out nocopy JTF_NUMBER_TABLE
118: , a30 out nocopy JTF_DATE_TABLE
119: , a31 out nocopy JTF_NUMBER_TABLE
120: , a32 out nocopy JTF_DATE_TABLE
121: , a33 out nocopy JTF_NUMBER_TABLE

Line 119: , a31 out nocopy JTF_NUMBER_TABLE

115: , a27 out nocopy JTF_VARCHAR2_TABLE_500
116: , a28 out nocopy JTF_VARCHAR2_TABLE_500
117: , a29 out nocopy JTF_NUMBER_TABLE
118: , a30 out nocopy JTF_DATE_TABLE
119: , a31 out nocopy JTF_NUMBER_TABLE
120: , a32 out nocopy JTF_DATE_TABLE
121: , a33 out nocopy JTF_NUMBER_TABLE
122: ) as
123: ddindx binary_integer; indx binary_integer;

Line 121: , a33 out nocopy JTF_NUMBER_TABLE

117: , a29 out nocopy JTF_NUMBER_TABLE
118: , a30 out nocopy JTF_DATE_TABLE
119: , a31 out nocopy JTF_NUMBER_TABLE
120: , a32 out nocopy JTF_DATE_TABLE
121: , a33 out nocopy JTF_NUMBER_TABLE
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then

Line 126: a0 := JTF_NUMBER_TABLE();

122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_300();
129: a3 := JTF_VARCHAR2_TABLE_2000();
130: a4 := JTF_NUMBER_TABLE();

Line 127: a1 := JTF_NUMBER_TABLE();

123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_300();
129: a3 := JTF_VARCHAR2_TABLE_2000();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_VARCHAR2_TABLE_100();

Line 130: a4 := JTF_NUMBER_TABLE();

126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_300();
129: a3 := JTF_VARCHAR2_TABLE_2000();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_VARCHAR2_TABLE_100();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();

Line 133: a7 := JTF_NUMBER_TABLE();

129: a3 := JTF_VARCHAR2_TABLE_2000();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_VARCHAR2_TABLE_100();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_DATE_TABLE();

Line 135: a9 := JTF_NUMBER_TABLE();

131: a5 := JTF_VARCHAR2_TABLE_100();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_VARCHAR2_TABLE_100();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_DATE_TABLE();
138: a12 := JTF_DATE_TABLE();
139: a13 := JTF_VARCHAR2_TABLE_100();

Line 155: a29 := JTF_NUMBER_TABLE();

151: a25 := JTF_VARCHAR2_TABLE_500();
152: a26 := JTF_VARCHAR2_TABLE_500();
153: a27 := JTF_VARCHAR2_TABLE_500();
154: a28 := JTF_VARCHAR2_TABLE_500();
155: a29 := JTF_NUMBER_TABLE();
156: a30 := JTF_DATE_TABLE();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();

Line 157: a31 := JTF_NUMBER_TABLE();

153: a27 := JTF_VARCHAR2_TABLE_500();
154: a28 := JTF_VARCHAR2_TABLE_500();
155: a29 := JTF_NUMBER_TABLE();
156: a30 := JTF_DATE_TABLE();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();

Line 159: a33 := JTF_NUMBER_TABLE();

155: a29 := JTF_NUMBER_TABLE();
156: a30 := JTF_DATE_TABLE();
157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_300();

Line 161: a0 := JTF_NUMBER_TABLE();

157: a31 := JTF_NUMBER_TABLE();
158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_300();
164: a3 := JTF_VARCHAR2_TABLE_2000();
165: a4 := JTF_NUMBER_TABLE();

Line 162: a1 := JTF_NUMBER_TABLE();

158: a32 := JTF_DATE_TABLE();
159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_300();
164: a3 := JTF_VARCHAR2_TABLE_2000();
165: a4 := JTF_NUMBER_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();

Line 165: a4 := JTF_NUMBER_TABLE();

161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_300();
164: a3 := JTF_VARCHAR2_TABLE_2000();
165: a4 := JTF_NUMBER_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_VARCHAR2_TABLE_100();

Line 168: a7 := JTF_NUMBER_TABLE();

164: a3 := JTF_VARCHAR2_TABLE_2000();
165: a4 := JTF_NUMBER_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_VARCHAR2_TABLE_100();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_DATE_TABLE();

Line 170: a9 := JTF_NUMBER_TABLE();

166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_VARCHAR2_TABLE_100();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_DATE_TABLE();
173: a12 := JTF_DATE_TABLE();
174: a13 := JTF_VARCHAR2_TABLE_100();

Line 190: a29 := JTF_NUMBER_TABLE();

186: a25 := JTF_VARCHAR2_TABLE_500();
187: a26 := JTF_VARCHAR2_TABLE_500();
188: a27 := JTF_VARCHAR2_TABLE_500();
189: a28 := JTF_VARCHAR2_TABLE_500();
190: a29 := JTF_NUMBER_TABLE();
191: a30 := JTF_DATE_TABLE();
192: a31 := JTF_NUMBER_TABLE();
193: a32 := JTF_DATE_TABLE();
194: a33 := JTF_NUMBER_TABLE();

Line 192: a31 := JTF_NUMBER_TABLE();

188: a27 := JTF_VARCHAR2_TABLE_500();
189: a28 := JTF_VARCHAR2_TABLE_500();
190: a29 := JTF_NUMBER_TABLE();
191: a30 := JTF_DATE_TABLE();
192: a31 := JTF_NUMBER_TABLE();
193: a32 := JTF_DATE_TABLE();
194: a33 := JTF_NUMBER_TABLE();
195: if t.count > 0 then
196: a0.extend(t.count);

Line 194: a33 := JTF_NUMBER_TABLE();

190: a29 := JTF_NUMBER_TABLE();
191: a30 := JTF_DATE_TABLE();
192: a31 := JTF_NUMBER_TABLE();
193: a32 := JTF_DATE_TABLE();
194: a33 := JTF_NUMBER_TABLE();
195: if t.count > 0 then
196: a0.extend(t.count);
197: a1.extend(t.count);
198: a2.extend(t.count);

Line 277: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE

273: end if;
274: end if;
275: end rosetta_table_copy_out_p1;
276:
277: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
278: , a1 JTF_NUMBER_TABLE
279: , a2 JTF_VARCHAR2_TABLE_300
280: , a3 JTF_NUMBER_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100

Line 278: , a1 JTF_NUMBER_TABLE

274: end if;
275: end rosetta_table_copy_out_p1;
276:
277: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
278: , a1 JTF_NUMBER_TABLE
279: , a2 JTF_VARCHAR2_TABLE_300
280: , a3 JTF_NUMBER_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100
282: , a5 JTF_VARCHAR2_TABLE_100

Line 280: , a3 JTF_NUMBER_TABLE

276:
277: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
278: , a1 JTF_NUMBER_TABLE
279: , a2 JTF_VARCHAR2_TABLE_300
280: , a3 JTF_NUMBER_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100
282: , a5 JTF_VARCHAR2_TABLE_100
283: , a6 JTF_NUMBER_TABLE
284: , a7 JTF_VARCHAR2_TABLE_100

Line 283: , a6 JTF_NUMBER_TABLE

279: , a2 JTF_VARCHAR2_TABLE_300
280: , a3 JTF_NUMBER_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100
282: , a5 JTF_VARCHAR2_TABLE_100
283: , a6 JTF_NUMBER_TABLE
284: , a7 JTF_VARCHAR2_TABLE_100
285: , a8 JTF_NUMBER_TABLE
286: , a9 JTF_VARCHAR2_TABLE_100
287: , a10 JTF_DATE_TABLE

Line 285: , a8 JTF_NUMBER_TABLE

281: , a4 JTF_VARCHAR2_TABLE_100
282: , a5 JTF_VARCHAR2_TABLE_100
283: , a6 JTF_NUMBER_TABLE
284: , a7 JTF_VARCHAR2_TABLE_100
285: , a8 JTF_NUMBER_TABLE
286: , a9 JTF_VARCHAR2_TABLE_100
287: , a10 JTF_DATE_TABLE
288: , a11 JTF_DATE_TABLE
289: , a12 JTF_VARCHAR2_TABLE_100

Line 305: , a28 JTF_NUMBER_TABLE

301: , a24 JTF_VARCHAR2_TABLE_500
302: , a25 JTF_VARCHAR2_TABLE_500
303: , a26 JTF_VARCHAR2_TABLE_500
304: , a27 JTF_VARCHAR2_TABLE_500
305: , a28 JTF_NUMBER_TABLE
306: , a29 JTF_DATE_TABLE
307: , a30 JTF_NUMBER_TABLE
308: , a31 JTF_DATE_TABLE
309: , a32 JTF_NUMBER_TABLE

Line 307: , a30 JTF_NUMBER_TABLE

303: , a26 JTF_VARCHAR2_TABLE_500
304: , a27 JTF_VARCHAR2_TABLE_500
305: , a28 JTF_NUMBER_TABLE
306: , a29 JTF_DATE_TABLE
307: , a30 JTF_NUMBER_TABLE
308: , a31 JTF_DATE_TABLE
309: , a32 JTF_NUMBER_TABLE
310: ) as
311: ddindx binary_integer; indx binary_integer;

Line 309: , a32 JTF_NUMBER_TABLE

305: , a28 JTF_NUMBER_TABLE
306: , a29 JTF_DATE_TABLE
307: , a30 JTF_NUMBER_TABLE
308: , a31 JTF_DATE_TABLE
309: , a32 JTF_NUMBER_TABLE
310: ) as
311: ddindx binary_integer; indx binary_integer;
312: begin
313: if a0 is not null and a0.count > 0 then

Line 360: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE

356: end loop;
357: end if;
358: end if;
359: end rosetta_table_copy_in_p3;
360: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_VARCHAR2_TABLE_300
363: , a3 out nocopy JTF_NUMBER_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 361: , a1 out nocopy JTF_NUMBER_TABLE

357: end if;
358: end if;
359: end rosetta_table_copy_in_p3;
360: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_VARCHAR2_TABLE_300
363: , a3 out nocopy JTF_NUMBER_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 363: , a3 out nocopy JTF_NUMBER_TABLE

359: end rosetta_table_copy_in_p3;
360: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_VARCHAR2_TABLE_300
363: , a3 out nocopy JTF_NUMBER_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_NUMBER_TABLE
367: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 366: , a6 out nocopy JTF_NUMBER_TABLE

362: , a2 out nocopy JTF_VARCHAR2_TABLE_300
363: , a3 out nocopy JTF_NUMBER_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_NUMBER_TABLE
367: , a7 out nocopy JTF_VARCHAR2_TABLE_100
368: , a8 out nocopy JTF_NUMBER_TABLE
369: , a9 out nocopy JTF_VARCHAR2_TABLE_100
370: , a10 out nocopy JTF_DATE_TABLE

Line 368: , a8 out nocopy JTF_NUMBER_TABLE

364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_NUMBER_TABLE
367: , a7 out nocopy JTF_VARCHAR2_TABLE_100
368: , a8 out nocopy JTF_NUMBER_TABLE
369: , a9 out nocopy JTF_VARCHAR2_TABLE_100
370: , a10 out nocopy JTF_DATE_TABLE
371: , a11 out nocopy JTF_DATE_TABLE
372: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 388: , a28 out nocopy JTF_NUMBER_TABLE

384: , a24 out nocopy JTF_VARCHAR2_TABLE_500
385: , a25 out nocopy JTF_VARCHAR2_TABLE_500
386: , a26 out nocopy JTF_VARCHAR2_TABLE_500
387: , a27 out nocopy JTF_VARCHAR2_TABLE_500
388: , a28 out nocopy JTF_NUMBER_TABLE
389: , a29 out nocopy JTF_DATE_TABLE
390: , a30 out nocopy JTF_NUMBER_TABLE
391: , a31 out nocopy JTF_DATE_TABLE
392: , a32 out nocopy JTF_NUMBER_TABLE

Line 390: , a30 out nocopy JTF_NUMBER_TABLE

386: , a26 out nocopy JTF_VARCHAR2_TABLE_500
387: , a27 out nocopy JTF_VARCHAR2_TABLE_500
388: , a28 out nocopy JTF_NUMBER_TABLE
389: , a29 out nocopy JTF_DATE_TABLE
390: , a30 out nocopy JTF_NUMBER_TABLE
391: , a31 out nocopy JTF_DATE_TABLE
392: , a32 out nocopy JTF_NUMBER_TABLE
393: ) as
394: ddindx binary_integer; indx binary_integer;

Line 392: , a32 out nocopy JTF_NUMBER_TABLE

388: , a28 out nocopy JTF_NUMBER_TABLE
389: , a29 out nocopy JTF_DATE_TABLE
390: , a30 out nocopy JTF_NUMBER_TABLE
391: , a31 out nocopy JTF_DATE_TABLE
392: , a32 out nocopy JTF_NUMBER_TABLE
393: ) as
394: ddindx binary_integer; indx binary_integer;
395: begin
396: if t is null or t.count = 0 then

Line 397: a0 := JTF_NUMBER_TABLE();

393: ) as
394: ddindx binary_integer; indx binary_integer;
395: begin
396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_NUMBER_TABLE();
399: a2 := JTF_VARCHAR2_TABLE_300();
400: a3 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();

Line 398: a1 := JTF_NUMBER_TABLE();

394: ddindx binary_integer; indx binary_integer;
395: begin
396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_NUMBER_TABLE();
399: a2 := JTF_VARCHAR2_TABLE_300();
400: a3 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();
402: a5 := JTF_VARCHAR2_TABLE_100();

Line 400: a3 := JTF_NUMBER_TABLE();

396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_NUMBER_TABLE();
399: a2 := JTF_VARCHAR2_TABLE_300();
400: a3 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();
402: a5 := JTF_VARCHAR2_TABLE_100();
403: a6 := JTF_NUMBER_TABLE();
404: a7 := JTF_VARCHAR2_TABLE_100();

Line 403: a6 := JTF_NUMBER_TABLE();

399: a2 := JTF_VARCHAR2_TABLE_300();
400: a3 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();
402: a5 := JTF_VARCHAR2_TABLE_100();
403: a6 := JTF_NUMBER_TABLE();
404: a7 := JTF_VARCHAR2_TABLE_100();
405: a8 := JTF_NUMBER_TABLE();
406: a9 := JTF_VARCHAR2_TABLE_100();
407: a10 := JTF_DATE_TABLE();

Line 405: a8 := JTF_NUMBER_TABLE();

401: a4 := JTF_VARCHAR2_TABLE_100();
402: a5 := JTF_VARCHAR2_TABLE_100();
403: a6 := JTF_NUMBER_TABLE();
404: a7 := JTF_VARCHAR2_TABLE_100();
405: a8 := JTF_NUMBER_TABLE();
406: a9 := JTF_VARCHAR2_TABLE_100();
407: a10 := JTF_DATE_TABLE();
408: a11 := JTF_DATE_TABLE();
409: a12 := JTF_VARCHAR2_TABLE_100();

Line 425: a28 := JTF_NUMBER_TABLE();

421: a24 := JTF_VARCHAR2_TABLE_500();
422: a25 := JTF_VARCHAR2_TABLE_500();
423: a26 := JTF_VARCHAR2_TABLE_500();
424: a27 := JTF_VARCHAR2_TABLE_500();
425: a28 := JTF_NUMBER_TABLE();
426: a29 := JTF_DATE_TABLE();
427: a30 := JTF_NUMBER_TABLE();
428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();

Line 427: a30 := JTF_NUMBER_TABLE();

423: a26 := JTF_VARCHAR2_TABLE_500();
424: a27 := JTF_VARCHAR2_TABLE_500();
425: a28 := JTF_NUMBER_TABLE();
426: a29 := JTF_DATE_TABLE();
427: a30 := JTF_NUMBER_TABLE();
428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();
430: else
431: a0 := JTF_NUMBER_TABLE();

Line 429: a32 := JTF_NUMBER_TABLE();

425: a28 := JTF_NUMBER_TABLE();
426: a29 := JTF_DATE_TABLE();
427: a30 := JTF_NUMBER_TABLE();
428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();
430: else
431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_300();

Line 431: a0 := JTF_NUMBER_TABLE();

427: a30 := JTF_NUMBER_TABLE();
428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();
430: else
431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_300();
434: a3 := JTF_NUMBER_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();

Line 432: a1 := JTF_NUMBER_TABLE();

428: a31 := JTF_DATE_TABLE();
429: a32 := JTF_NUMBER_TABLE();
430: else
431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_300();
434: a3 := JTF_NUMBER_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();

Line 434: a3 := JTF_NUMBER_TABLE();

430: else
431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_300();
434: a3 := JTF_NUMBER_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_NUMBER_TABLE();
438: a7 := JTF_VARCHAR2_TABLE_100();

Line 437: a6 := JTF_NUMBER_TABLE();

433: a2 := JTF_VARCHAR2_TABLE_300();
434: a3 := JTF_NUMBER_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_NUMBER_TABLE();
438: a7 := JTF_VARCHAR2_TABLE_100();
439: a8 := JTF_NUMBER_TABLE();
440: a9 := JTF_VARCHAR2_TABLE_100();
441: a10 := JTF_DATE_TABLE();

Line 439: a8 := JTF_NUMBER_TABLE();

435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_NUMBER_TABLE();
438: a7 := JTF_VARCHAR2_TABLE_100();
439: a8 := JTF_NUMBER_TABLE();
440: a9 := JTF_VARCHAR2_TABLE_100();
441: a10 := JTF_DATE_TABLE();
442: a11 := JTF_DATE_TABLE();
443: a12 := JTF_VARCHAR2_TABLE_100();

Line 459: a28 := JTF_NUMBER_TABLE();

455: a24 := JTF_VARCHAR2_TABLE_500();
456: a25 := JTF_VARCHAR2_TABLE_500();
457: a26 := JTF_VARCHAR2_TABLE_500();
458: a27 := JTF_VARCHAR2_TABLE_500();
459: a28 := JTF_NUMBER_TABLE();
460: a29 := JTF_DATE_TABLE();
461: a30 := JTF_NUMBER_TABLE();
462: a31 := JTF_DATE_TABLE();
463: a32 := JTF_NUMBER_TABLE();

Line 461: a30 := JTF_NUMBER_TABLE();

457: a26 := JTF_VARCHAR2_TABLE_500();
458: a27 := JTF_VARCHAR2_TABLE_500();
459: a28 := JTF_NUMBER_TABLE();
460: a29 := JTF_DATE_TABLE();
461: a30 := JTF_NUMBER_TABLE();
462: a31 := JTF_DATE_TABLE();
463: a32 := JTF_NUMBER_TABLE();
464: if t.count > 0 then
465: a0.extend(t.count);

Line 463: a32 := JTF_NUMBER_TABLE();

459: a28 := JTF_NUMBER_TABLE();
460: a29 := JTF_DATE_TABLE();
461: a30 := JTF_NUMBER_TABLE();
462: a31 := JTF_DATE_TABLE();
463: a32 := JTF_NUMBER_TABLE();
464: if t.count > 0 then
465: a0.extend(t.count);
466: a1.extend(t.count);
467: a2.extend(t.count);

Line 544: procedure rosetta_table_copy_in_p5(t out nocopy okl_eth_pvt.okl_ethtl_tbl, a0 JTF_NUMBER_TABLE

540: end if;
541: end if;
542: end rosetta_table_copy_out_p3;
543:
544: procedure rosetta_table_copy_in_p5(t out nocopy okl_eth_pvt.okl_ethtl_tbl, a0 JTF_NUMBER_TABLE
545: , a1 JTF_VARCHAR2_TABLE_2000
546: , a2 JTF_VARCHAR2_TABLE_100
547: , a3 JTF_VARCHAR2_TABLE_100
548: , a4 JTF_VARCHAR2_TABLE_100

Line 549: , a5 JTF_NUMBER_TABLE

545: , a1 JTF_VARCHAR2_TABLE_2000
546: , a2 JTF_VARCHAR2_TABLE_100
547: , a3 JTF_VARCHAR2_TABLE_100
548: , a4 JTF_VARCHAR2_TABLE_100
549: , a5 JTF_NUMBER_TABLE
550: , a6 JTF_DATE_TABLE
551: , a7 JTF_NUMBER_TABLE
552: , a8 JTF_DATE_TABLE
553: , a9 JTF_NUMBER_TABLE

Line 551: , a7 JTF_NUMBER_TABLE

547: , a3 JTF_VARCHAR2_TABLE_100
548: , a4 JTF_VARCHAR2_TABLE_100
549: , a5 JTF_NUMBER_TABLE
550: , a6 JTF_DATE_TABLE
551: , a7 JTF_NUMBER_TABLE
552: , a8 JTF_DATE_TABLE
553: , a9 JTF_NUMBER_TABLE
554: ) as
555: ddindx binary_integer; indx binary_integer;

Line 553: , a9 JTF_NUMBER_TABLE

549: , a5 JTF_NUMBER_TABLE
550: , a6 JTF_DATE_TABLE
551: , a7 JTF_NUMBER_TABLE
552: , a8 JTF_DATE_TABLE
553: , a9 JTF_NUMBER_TABLE
554: ) as
555: ddindx binary_integer; indx binary_integer;
556: begin
557: if a0 is not null and a0.count > 0 then

Line 581: procedure rosetta_table_copy_out_p5(t okl_eth_pvt.okl_ethtl_tbl, a0 out nocopy JTF_NUMBER_TABLE

577: end loop;
578: end if;
579: end if;
580: end rosetta_table_copy_in_p5;
581: procedure rosetta_table_copy_out_p5(t okl_eth_pvt.okl_ethtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
582: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
583: , a2 out nocopy JTF_VARCHAR2_TABLE_100
584: , a3 out nocopy JTF_VARCHAR2_TABLE_100
585: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 586: , a5 out nocopy JTF_NUMBER_TABLE

582: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
583: , a2 out nocopy JTF_VARCHAR2_TABLE_100
584: , a3 out nocopy JTF_VARCHAR2_TABLE_100
585: , a4 out nocopy JTF_VARCHAR2_TABLE_100
586: , a5 out nocopy JTF_NUMBER_TABLE
587: , a6 out nocopy JTF_DATE_TABLE
588: , a7 out nocopy JTF_NUMBER_TABLE
589: , a8 out nocopy JTF_DATE_TABLE
590: , a9 out nocopy JTF_NUMBER_TABLE

Line 588: , a7 out nocopy JTF_NUMBER_TABLE

584: , a3 out nocopy JTF_VARCHAR2_TABLE_100
585: , a4 out nocopy JTF_VARCHAR2_TABLE_100
586: , a5 out nocopy JTF_NUMBER_TABLE
587: , a6 out nocopy JTF_DATE_TABLE
588: , a7 out nocopy JTF_NUMBER_TABLE
589: , a8 out nocopy JTF_DATE_TABLE
590: , a9 out nocopy JTF_NUMBER_TABLE
591: ) as
592: ddindx binary_integer; indx binary_integer;

Line 590: , a9 out nocopy JTF_NUMBER_TABLE

586: , a5 out nocopy JTF_NUMBER_TABLE
587: , a6 out nocopy JTF_DATE_TABLE
588: , a7 out nocopy JTF_NUMBER_TABLE
589: , a8 out nocopy JTF_DATE_TABLE
590: , a9 out nocopy JTF_NUMBER_TABLE
591: ) as
592: ddindx binary_integer; indx binary_integer;
593: begin
594: if t is null or t.count = 0 then

Line 595: a0 := JTF_NUMBER_TABLE();

591: ) as
592: ddindx binary_integer; indx binary_integer;
593: begin
594: if t is null or t.count = 0 then
595: a0 := JTF_NUMBER_TABLE();
596: a1 := JTF_VARCHAR2_TABLE_2000();
597: a2 := JTF_VARCHAR2_TABLE_100();
598: a3 := JTF_VARCHAR2_TABLE_100();
599: a4 := JTF_VARCHAR2_TABLE_100();

Line 600: a5 := JTF_NUMBER_TABLE();

596: a1 := JTF_VARCHAR2_TABLE_2000();
597: a2 := JTF_VARCHAR2_TABLE_100();
598: a3 := JTF_VARCHAR2_TABLE_100();
599: a4 := JTF_VARCHAR2_TABLE_100();
600: a5 := JTF_NUMBER_TABLE();
601: a6 := JTF_DATE_TABLE();
602: a7 := JTF_NUMBER_TABLE();
603: a8 := JTF_DATE_TABLE();
604: a9 := JTF_NUMBER_TABLE();

Line 602: a7 := JTF_NUMBER_TABLE();

598: a3 := JTF_VARCHAR2_TABLE_100();
599: a4 := JTF_VARCHAR2_TABLE_100();
600: a5 := JTF_NUMBER_TABLE();
601: a6 := JTF_DATE_TABLE();
602: a7 := JTF_NUMBER_TABLE();
603: a8 := JTF_DATE_TABLE();
604: a9 := JTF_NUMBER_TABLE();
605: else
606: a0 := JTF_NUMBER_TABLE();

Line 604: a9 := JTF_NUMBER_TABLE();

600: a5 := JTF_NUMBER_TABLE();
601: a6 := JTF_DATE_TABLE();
602: a7 := JTF_NUMBER_TABLE();
603: a8 := JTF_DATE_TABLE();
604: a9 := JTF_NUMBER_TABLE();
605: else
606: a0 := JTF_NUMBER_TABLE();
607: a1 := JTF_VARCHAR2_TABLE_2000();
608: a2 := JTF_VARCHAR2_TABLE_100();

Line 606: a0 := JTF_NUMBER_TABLE();

602: a7 := JTF_NUMBER_TABLE();
603: a8 := JTF_DATE_TABLE();
604: a9 := JTF_NUMBER_TABLE();
605: else
606: a0 := JTF_NUMBER_TABLE();
607: a1 := JTF_VARCHAR2_TABLE_2000();
608: a2 := JTF_VARCHAR2_TABLE_100();
609: a3 := JTF_VARCHAR2_TABLE_100();
610: a4 := JTF_VARCHAR2_TABLE_100();

Line 611: a5 := JTF_NUMBER_TABLE();

607: a1 := JTF_VARCHAR2_TABLE_2000();
608: a2 := JTF_VARCHAR2_TABLE_100();
609: a3 := JTF_VARCHAR2_TABLE_100();
610: a4 := JTF_VARCHAR2_TABLE_100();
611: a5 := JTF_NUMBER_TABLE();
612: a6 := JTF_DATE_TABLE();
613: a7 := JTF_NUMBER_TABLE();
614: a8 := JTF_DATE_TABLE();
615: a9 := JTF_NUMBER_TABLE();

Line 613: a7 := JTF_NUMBER_TABLE();

609: a3 := JTF_VARCHAR2_TABLE_100();
610: a4 := JTF_VARCHAR2_TABLE_100();
611: a5 := JTF_NUMBER_TABLE();
612: a6 := JTF_DATE_TABLE();
613: a7 := JTF_NUMBER_TABLE();
614: a8 := JTF_DATE_TABLE();
615: a9 := JTF_NUMBER_TABLE();
616: if t.count > 0 then
617: a0.extend(t.count);

Line 615: a9 := JTF_NUMBER_TABLE();

611: a5 := JTF_NUMBER_TABLE();
612: a6 := JTF_DATE_TABLE();
613: a7 := JTF_NUMBER_TABLE();
614: a8 := JTF_DATE_TABLE();
615: a9 := JTF_NUMBER_TABLE();
616: if t.count > 0 then
617: a0.extend(t.count);
618: a1.extend(t.count);
619: a2.extend(t.count);

Line 830: , p5_a0 JTF_NUMBER_TABLE

826: , p_init_msg_list VARCHAR2
827: , x_return_status out nocopy VARCHAR2
828: , x_msg_count out nocopy NUMBER
829: , x_msg_data out nocopy VARCHAR2
830: , p5_a0 JTF_NUMBER_TABLE
831: , p5_a1 JTF_NUMBER_TABLE
832: , p5_a2 JTF_VARCHAR2_TABLE_300
833: , p5_a3 JTF_VARCHAR2_TABLE_2000
834: , p5_a4 JTF_NUMBER_TABLE

Line 831: , p5_a1 JTF_NUMBER_TABLE

827: , x_return_status out nocopy VARCHAR2
828: , x_msg_count out nocopy NUMBER
829: , x_msg_data out nocopy VARCHAR2
830: , p5_a0 JTF_NUMBER_TABLE
831: , p5_a1 JTF_NUMBER_TABLE
832: , p5_a2 JTF_VARCHAR2_TABLE_300
833: , p5_a3 JTF_VARCHAR2_TABLE_2000
834: , p5_a4 JTF_NUMBER_TABLE
835: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 834: , p5_a4 JTF_NUMBER_TABLE

830: , p5_a0 JTF_NUMBER_TABLE
831: , p5_a1 JTF_NUMBER_TABLE
832: , p5_a2 JTF_VARCHAR2_TABLE_300
833: , p5_a3 JTF_VARCHAR2_TABLE_2000
834: , p5_a4 JTF_NUMBER_TABLE
835: , p5_a5 JTF_VARCHAR2_TABLE_100
836: , p5_a6 JTF_VARCHAR2_TABLE_100
837: , p5_a7 JTF_NUMBER_TABLE
838: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 837: , p5_a7 JTF_NUMBER_TABLE

833: , p5_a3 JTF_VARCHAR2_TABLE_2000
834: , p5_a4 JTF_NUMBER_TABLE
835: , p5_a5 JTF_VARCHAR2_TABLE_100
836: , p5_a6 JTF_VARCHAR2_TABLE_100
837: , p5_a7 JTF_NUMBER_TABLE
838: , p5_a8 JTF_VARCHAR2_TABLE_100
839: , p5_a9 JTF_NUMBER_TABLE
840: , p5_a10 JTF_VARCHAR2_TABLE_100
841: , p5_a11 JTF_DATE_TABLE

Line 839: , p5_a9 JTF_NUMBER_TABLE

835: , p5_a5 JTF_VARCHAR2_TABLE_100
836: , p5_a6 JTF_VARCHAR2_TABLE_100
837: , p5_a7 JTF_NUMBER_TABLE
838: , p5_a8 JTF_VARCHAR2_TABLE_100
839: , p5_a9 JTF_NUMBER_TABLE
840: , p5_a10 JTF_VARCHAR2_TABLE_100
841: , p5_a11 JTF_DATE_TABLE
842: , p5_a12 JTF_DATE_TABLE
843: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 859: , p5_a29 JTF_NUMBER_TABLE

855: , p5_a25 JTF_VARCHAR2_TABLE_500
856: , p5_a26 JTF_VARCHAR2_TABLE_500
857: , p5_a27 JTF_VARCHAR2_TABLE_500
858: , p5_a28 JTF_VARCHAR2_TABLE_500
859: , p5_a29 JTF_NUMBER_TABLE
860: , p5_a30 JTF_DATE_TABLE
861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE

Line 861: , p5_a31 JTF_NUMBER_TABLE

857: , p5_a27 JTF_VARCHAR2_TABLE_500
858: , p5_a28 JTF_VARCHAR2_TABLE_500
859: , p5_a29 JTF_NUMBER_TABLE
860: , p5_a30 JTF_DATE_TABLE
861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 863: , p5_a33 JTF_NUMBER_TABLE

859: , p5_a29 JTF_NUMBER_TABLE
860: , p5_a30 JTF_DATE_TABLE
861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 864: , p6_a0 out nocopy JTF_NUMBER_TABLE

860: , p5_a30 JTF_DATE_TABLE
861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 865: , p6_a1 out nocopy JTF_NUMBER_TABLE

861: , p5_a31 JTF_NUMBER_TABLE
862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 out nocopy JTF_NUMBER_TABLE
869: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 868: , p6_a4 out nocopy JTF_NUMBER_TABLE

864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 out nocopy JTF_NUMBER_TABLE
869: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a7 out nocopy JTF_NUMBER_TABLE
872: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 871: , p6_a7 out nocopy JTF_NUMBER_TABLE

867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 out nocopy JTF_NUMBER_TABLE
869: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a7 out nocopy JTF_NUMBER_TABLE
872: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
873: , p6_a9 out nocopy JTF_NUMBER_TABLE
874: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
875: , p6_a11 out nocopy JTF_DATE_TABLE

Line 873: , p6_a9 out nocopy JTF_NUMBER_TABLE

869: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a7 out nocopy JTF_NUMBER_TABLE
872: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
873: , p6_a9 out nocopy JTF_NUMBER_TABLE
874: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
875: , p6_a11 out nocopy JTF_DATE_TABLE
876: , p6_a12 out nocopy JTF_DATE_TABLE
877: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 893: , p6_a29 out nocopy JTF_NUMBER_TABLE

889: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
890: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
891: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
892: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
893: , p6_a29 out nocopy JTF_NUMBER_TABLE
894: , p6_a30 out nocopy JTF_DATE_TABLE
895: , p6_a31 out nocopy JTF_NUMBER_TABLE
896: , p6_a32 out nocopy JTF_DATE_TABLE
897: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 895: , p6_a31 out nocopy JTF_NUMBER_TABLE

891: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
892: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
893: , p6_a29 out nocopy JTF_NUMBER_TABLE
894: , p6_a30 out nocopy JTF_DATE_TABLE
895: , p6_a31 out nocopy JTF_NUMBER_TABLE
896: , p6_a32 out nocopy JTF_DATE_TABLE
897: , p6_a33 out nocopy JTF_NUMBER_TABLE
898: )
899:

Line 897: , p6_a33 out nocopy JTF_NUMBER_TABLE

893: , p6_a29 out nocopy JTF_NUMBER_TABLE
894: , p6_a30 out nocopy JTF_DATE_TABLE
895: , p6_a31 out nocopy JTF_NUMBER_TABLE
896: , p6_a32 out nocopy JTF_DATE_TABLE
897: , p6_a33 out nocopy JTF_NUMBER_TABLE
898: )
899:
900: as
901: ddp_ethv_tbl okl_eth_pvt.okl_ethv_tbl;

Line 1182: , p5_a0 JTF_NUMBER_TABLE

1178: , p_init_msg_list VARCHAR2
1179: , x_return_status out nocopy VARCHAR2
1180: , x_msg_count out nocopy NUMBER
1181: , x_msg_data out nocopy VARCHAR2
1182: , p5_a0 JTF_NUMBER_TABLE
1183: , p5_a1 JTF_NUMBER_TABLE
1184: , p5_a2 JTF_VARCHAR2_TABLE_300
1185: , p5_a3 JTF_VARCHAR2_TABLE_2000
1186: , p5_a4 JTF_NUMBER_TABLE

Line 1183: , p5_a1 JTF_NUMBER_TABLE

1179: , x_return_status out nocopy VARCHAR2
1180: , x_msg_count out nocopy NUMBER
1181: , x_msg_data out nocopy VARCHAR2
1182: , p5_a0 JTF_NUMBER_TABLE
1183: , p5_a1 JTF_NUMBER_TABLE
1184: , p5_a2 JTF_VARCHAR2_TABLE_300
1185: , p5_a3 JTF_VARCHAR2_TABLE_2000
1186: , p5_a4 JTF_NUMBER_TABLE
1187: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1186: , p5_a4 JTF_NUMBER_TABLE

1182: , p5_a0 JTF_NUMBER_TABLE
1183: , p5_a1 JTF_NUMBER_TABLE
1184: , p5_a2 JTF_VARCHAR2_TABLE_300
1185: , p5_a3 JTF_VARCHAR2_TABLE_2000
1186: , p5_a4 JTF_NUMBER_TABLE
1187: , p5_a5 JTF_VARCHAR2_TABLE_100
1188: , p5_a6 JTF_VARCHAR2_TABLE_100
1189: , p5_a7 JTF_NUMBER_TABLE
1190: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 1189: , p5_a7 JTF_NUMBER_TABLE

1185: , p5_a3 JTF_VARCHAR2_TABLE_2000
1186: , p5_a4 JTF_NUMBER_TABLE
1187: , p5_a5 JTF_VARCHAR2_TABLE_100
1188: , p5_a6 JTF_VARCHAR2_TABLE_100
1189: , p5_a7 JTF_NUMBER_TABLE
1190: , p5_a8 JTF_VARCHAR2_TABLE_100
1191: , p5_a9 JTF_NUMBER_TABLE
1192: , p5_a10 JTF_VARCHAR2_TABLE_100
1193: , p5_a11 JTF_DATE_TABLE

Line 1191: , p5_a9 JTF_NUMBER_TABLE

1187: , p5_a5 JTF_VARCHAR2_TABLE_100
1188: , p5_a6 JTF_VARCHAR2_TABLE_100
1189: , p5_a7 JTF_NUMBER_TABLE
1190: , p5_a8 JTF_VARCHAR2_TABLE_100
1191: , p5_a9 JTF_NUMBER_TABLE
1192: , p5_a10 JTF_VARCHAR2_TABLE_100
1193: , p5_a11 JTF_DATE_TABLE
1194: , p5_a12 JTF_DATE_TABLE
1195: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 1211: , p5_a29 JTF_NUMBER_TABLE

1207: , p5_a25 JTF_VARCHAR2_TABLE_500
1208: , p5_a26 JTF_VARCHAR2_TABLE_500
1209: , p5_a27 JTF_VARCHAR2_TABLE_500
1210: , p5_a28 JTF_VARCHAR2_TABLE_500
1211: , p5_a29 JTF_NUMBER_TABLE
1212: , p5_a30 JTF_DATE_TABLE
1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE

Line 1213: , p5_a31 JTF_NUMBER_TABLE

1209: , p5_a27 JTF_VARCHAR2_TABLE_500
1210: , p5_a28 JTF_VARCHAR2_TABLE_500
1211: , p5_a29 JTF_NUMBER_TABLE
1212: , p5_a30 JTF_DATE_TABLE
1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 1215: , p5_a33 JTF_NUMBER_TABLE

1211: , p5_a29 JTF_NUMBER_TABLE
1212: , p5_a30 JTF_DATE_TABLE
1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1216: , p6_a0 out nocopy JTF_NUMBER_TABLE

1212: , p5_a30 JTF_DATE_TABLE
1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1220: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 1217: , p6_a1 out nocopy JTF_NUMBER_TABLE

1213: , p5_a31 JTF_NUMBER_TABLE
1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1220: , p6_a4 out nocopy JTF_NUMBER_TABLE
1221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1220: , p6_a4 out nocopy JTF_NUMBER_TABLE

1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1220: , p6_a4 out nocopy JTF_NUMBER_TABLE
1221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p6_a7 out nocopy JTF_NUMBER_TABLE
1224: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1223: , p6_a7 out nocopy JTF_NUMBER_TABLE

1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1220: , p6_a4 out nocopy JTF_NUMBER_TABLE
1221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p6_a7 out nocopy JTF_NUMBER_TABLE
1224: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1225: , p6_a9 out nocopy JTF_NUMBER_TABLE
1226: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1227: , p6_a11 out nocopy JTF_DATE_TABLE

Line 1225: , p6_a9 out nocopy JTF_NUMBER_TABLE

1221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1223: , p6_a7 out nocopy JTF_NUMBER_TABLE
1224: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1225: , p6_a9 out nocopy JTF_NUMBER_TABLE
1226: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1227: , p6_a11 out nocopy JTF_DATE_TABLE
1228: , p6_a12 out nocopy JTF_DATE_TABLE
1229: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1245: , p6_a29 out nocopy JTF_NUMBER_TABLE

1241: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1242: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1243: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1244: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1245: , p6_a29 out nocopy JTF_NUMBER_TABLE
1246: , p6_a30 out nocopy JTF_DATE_TABLE
1247: , p6_a31 out nocopy JTF_NUMBER_TABLE
1248: , p6_a32 out nocopy JTF_DATE_TABLE
1249: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 1247: , p6_a31 out nocopy JTF_NUMBER_TABLE

1243: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1244: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1245: , p6_a29 out nocopy JTF_NUMBER_TABLE
1246: , p6_a30 out nocopy JTF_DATE_TABLE
1247: , p6_a31 out nocopy JTF_NUMBER_TABLE
1248: , p6_a32 out nocopy JTF_DATE_TABLE
1249: , p6_a33 out nocopy JTF_NUMBER_TABLE
1250: )
1251:

Line 1249: , p6_a33 out nocopy JTF_NUMBER_TABLE

1245: , p6_a29 out nocopy JTF_NUMBER_TABLE
1246: , p6_a30 out nocopy JTF_DATE_TABLE
1247: , p6_a31 out nocopy JTF_NUMBER_TABLE
1248: , p6_a32 out nocopy JTF_DATE_TABLE
1249: , p6_a33 out nocopy JTF_NUMBER_TABLE
1250: )
1251:
1252: as
1253: ddp_ethv_tbl okl_eth_pvt.okl_ethv_tbl;

Line 1462: , p5_a0 JTF_NUMBER_TABLE

1458: , p_init_msg_list VARCHAR2
1459: , x_return_status out nocopy VARCHAR2
1460: , x_msg_count out nocopy NUMBER
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_VARCHAR2_TABLE_300
1465: , p5_a3 JTF_VARCHAR2_TABLE_2000
1466: , p5_a4 JTF_NUMBER_TABLE

Line 1463: , p5_a1 JTF_NUMBER_TABLE

1459: , x_return_status out nocopy VARCHAR2
1460: , x_msg_count out nocopy NUMBER
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_VARCHAR2_TABLE_300
1465: , p5_a3 JTF_VARCHAR2_TABLE_2000
1466: , p5_a4 JTF_NUMBER_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1466: , p5_a4 JTF_NUMBER_TABLE

1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_VARCHAR2_TABLE_300
1465: , p5_a3 JTF_VARCHAR2_TABLE_2000
1466: , p5_a4 JTF_NUMBER_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1468: , p5_a6 JTF_VARCHAR2_TABLE_100
1469: , p5_a7 JTF_NUMBER_TABLE
1470: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 1469: , p5_a7 JTF_NUMBER_TABLE

1465: , p5_a3 JTF_VARCHAR2_TABLE_2000
1466: , p5_a4 JTF_NUMBER_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1468: , p5_a6 JTF_VARCHAR2_TABLE_100
1469: , p5_a7 JTF_NUMBER_TABLE
1470: , p5_a8 JTF_VARCHAR2_TABLE_100
1471: , p5_a9 JTF_NUMBER_TABLE
1472: , p5_a10 JTF_VARCHAR2_TABLE_100
1473: , p5_a11 JTF_DATE_TABLE

Line 1471: , p5_a9 JTF_NUMBER_TABLE

1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1468: , p5_a6 JTF_VARCHAR2_TABLE_100
1469: , p5_a7 JTF_NUMBER_TABLE
1470: , p5_a8 JTF_VARCHAR2_TABLE_100
1471: , p5_a9 JTF_NUMBER_TABLE
1472: , p5_a10 JTF_VARCHAR2_TABLE_100
1473: , p5_a11 JTF_DATE_TABLE
1474: , p5_a12 JTF_DATE_TABLE
1475: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 1491: , p5_a29 JTF_NUMBER_TABLE

1487: , p5_a25 JTF_VARCHAR2_TABLE_500
1488: , p5_a26 JTF_VARCHAR2_TABLE_500
1489: , p5_a27 JTF_VARCHAR2_TABLE_500
1490: , p5_a28 JTF_VARCHAR2_TABLE_500
1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_DATE_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE

Line 1493: , p5_a31 JTF_NUMBER_TABLE

1489: , p5_a27 JTF_VARCHAR2_TABLE_500
1490: , p5_a28 JTF_VARCHAR2_TABLE_500
1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_DATE_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1496: )
1497:

Line 1495: , p5_a33 JTF_NUMBER_TABLE

1491: , p5_a29 JTF_NUMBER_TABLE
1492: , p5_a30 JTF_DATE_TABLE
1493: , p5_a31 JTF_NUMBER_TABLE
1494: , p5_a32 JTF_DATE_TABLE
1495: , p5_a33 JTF_NUMBER_TABLE
1496: )
1497:
1498: as
1499: ddp_ethv_tbl okl_eth_pvt.okl_ethv_tbl;