DBA Data[Home] [Help]

APPS.OKL_SIP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE

Line 31: , a9 JTF_VARCHAR2_TABLE_100

27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE

Line 32: , a10 JTF_VARCHAR2_TABLE_100

28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE

Line 33: , a11 JTF_VARCHAR2_TABLE_100

29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE

Line 39: , a17 JTF_VARCHAR2_TABLE_100

35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500

Line 117: , a2 out nocopy JTF_VARCHAR2_TABLE_100

113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 118: , a3 out nocopy JTF_VARCHAR2_TABLE_100

114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE

Line 119: , a4 out nocopy JTF_VARCHAR2_TABLE_100

115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE

Line 124: , a9 out nocopy JTF_VARCHAR2_TABLE_100

120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE

Line 125: , a10 out nocopy JTF_VARCHAR2_TABLE_100

121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE

Line 126: , a11 out nocopy JTF_VARCHAR2_TABLE_100

122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_NUMBER_TABLE

Line 132: , a17 out nocopy JTF_VARCHAR2_TABLE_100

128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_DATE_TABLE
132: , a17 out nocopy JTF_VARCHAR2_TABLE_100
133: , a18 out nocopy JTF_VARCHAR2_TABLE_500
134: , a19 out nocopy JTF_VARCHAR2_TABLE_500
135: , a20 out nocopy JTF_VARCHAR2_TABLE_500
136: , a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 159: a2 := JTF_VARCHAR2_TABLE_100();

155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();

Line 160: a3 := JTF_VARCHAR2_TABLE_100();

156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();

Line 161: a4 := JTF_VARCHAR2_TABLE_100();

157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();

Line 166: a9 := JTF_VARCHAR2_TABLE_100();

162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();
166: a9 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();

Line 167: a10 := JTF_VARCHAR2_TABLE_100();

163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();
166: a9 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();

Line 168: a11 := JTF_VARCHAR2_TABLE_100();

164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();
166: a9 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_VARCHAR2_TABLE_100();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();

Line 174: a17 := JTF_VARCHAR2_TABLE_100();

170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();
172: a15 := JTF_NUMBER_TABLE();
173: a16 := JTF_DATE_TABLE();
174: a17 := JTF_VARCHAR2_TABLE_100();
175: a18 := JTF_VARCHAR2_TABLE_500();
176: a19 := JTF_VARCHAR2_TABLE_500();
177: a20 := JTF_VARCHAR2_TABLE_500();
178: a21 := JTF_VARCHAR2_TABLE_500();

Line 198: a2 := JTF_VARCHAR2_TABLE_100();

194: a37 := JTF_NUMBER_TABLE();
195: else
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();
201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();

Line 199: a3 := JTF_VARCHAR2_TABLE_100();

195: else
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();
201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();

Line 200: a4 := JTF_VARCHAR2_TABLE_100();

196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();
201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();

Line 205: a9 := JTF_VARCHAR2_TABLE_100();

201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();
205: a9 := JTF_VARCHAR2_TABLE_100();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();

Line 206: a10 := JTF_VARCHAR2_TABLE_100();

202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();
205: a9 := JTF_VARCHAR2_TABLE_100();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();

Line 207: a11 := JTF_VARCHAR2_TABLE_100();

203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();
205: a9 := JTF_VARCHAR2_TABLE_100();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_VARCHAR2_TABLE_100();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();
211: a15 := JTF_NUMBER_TABLE();

Line 213: a17 := JTF_VARCHAR2_TABLE_100();

209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();
211: a15 := JTF_NUMBER_TABLE();
212: a16 := JTF_DATE_TABLE();
213: a17 := JTF_VARCHAR2_TABLE_100();
214: a18 := JTF_VARCHAR2_TABLE_500();
215: a19 := JTF_VARCHAR2_TABLE_500();
216: a20 := JTF_VARCHAR2_TABLE_500();
217: a21 := JTF_VARCHAR2_TABLE_500();

Line 327: , a3 JTF_VARCHAR2_TABLE_100

323:
324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100
330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_DATE_TABLE

Line 328: , a4 JTF_VARCHAR2_TABLE_100

324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100
330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_DATE_TABLE
332: , a8 JTF_NUMBER_TABLE

Line 329: , a5 JTF_VARCHAR2_TABLE_100

325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100
330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_DATE_TABLE
332: , a8 JTF_NUMBER_TABLE
333: , a9 JTF_DATE_TABLE

Line 366: , a3 out nocopy JTF_VARCHAR2_TABLE_100

362: end rosetta_table_copy_in_p5;
363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , a6 out nocopy JTF_NUMBER_TABLE
370: , a7 out nocopy JTF_DATE_TABLE

Line 367: , a4 out nocopy JTF_VARCHAR2_TABLE_100

363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , a6 out nocopy JTF_NUMBER_TABLE
370: , a7 out nocopy JTF_DATE_TABLE
371: , a8 out nocopy JTF_NUMBER_TABLE

Line 368: , a5 out nocopy JTF_VARCHAR2_TABLE_100

364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , a6 out nocopy JTF_NUMBER_TABLE
370: , a7 out nocopy JTF_DATE_TABLE
371: , a8 out nocopy JTF_NUMBER_TABLE
372: , a9 out nocopy JTF_DATE_TABLE

Line 381: a3 := JTF_VARCHAR2_TABLE_100();

377: if t is null or t.count = 0 then
378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_200();
380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();
384: a6 := JTF_NUMBER_TABLE();
385: a7 := JTF_DATE_TABLE();

Line 382: a4 := JTF_VARCHAR2_TABLE_100();

378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_200();
380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();
384: a6 := JTF_NUMBER_TABLE();
385: a7 := JTF_DATE_TABLE();
386: a8 := JTF_NUMBER_TABLE();

Line 383: a5 := JTF_VARCHAR2_TABLE_100();

379: a1 := JTF_VARCHAR2_TABLE_200();
380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();
384: a6 := JTF_NUMBER_TABLE();
385: a7 := JTF_DATE_TABLE();
386: a8 := JTF_NUMBER_TABLE();
387: a9 := JTF_DATE_TABLE();

Line 393: a3 := JTF_VARCHAR2_TABLE_100();

389: else
390: a0 := JTF_NUMBER_TABLE();
391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();
396: a6 := JTF_NUMBER_TABLE();
397: a7 := JTF_DATE_TABLE();

Line 394: a4 := JTF_VARCHAR2_TABLE_100();

390: a0 := JTF_NUMBER_TABLE();
391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();
396: a6 := JTF_NUMBER_TABLE();
397: a7 := JTF_DATE_TABLE();
398: a8 := JTF_NUMBER_TABLE();

Line 395: a5 := JTF_VARCHAR2_TABLE_100();

391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();
396: a6 := JTF_NUMBER_TABLE();
397: a7 := JTF_DATE_TABLE();
398: a8 := JTF_NUMBER_TABLE();
399: a9 := JTF_DATE_TABLE();

Line 439: , a2 JTF_VARCHAR2_TABLE_100

435: end rosetta_table_copy_out_p5;
436:
437: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
438: , a1 JTF_NUMBER_TABLE
439: , a2 JTF_VARCHAR2_TABLE_100
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100

Line 440: , a3 JTF_VARCHAR2_TABLE_100

436:
437: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
438: , a1 JTF_NUMBER_TABLE
439: , a2 JTF_VARCHAR2_TABLE_100
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100

Line 443: , a6 JTF_VARCHAR2_TABLE_100

439: , a2 JTF_VARCHAR2_TABLE_100
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100
445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE

Line 444: , a7 JTF_VARCHAR2_TABLE_100

440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100
445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE

Line 445: , a8 JTF_VARCHAR2_TABLE_100

441: , a4 JTF_DATE_TABLE
442: , a5 JTF_DATE_TABLE
443: , a6 JTF_VARCHAR2_TABLE_100
444: , a7 JTF_VARCHAR2_TABLE_100
445: , a8 JTF_VARCHAR2_TABLE_100
446: , a9 JTF_NUMBER_TABLE
447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE
449: , a12 JTF_NUMBER_TABLE

Line 451: , a14 JTF_VARCHAR2_TABLE_100

447: , a10 JTF_NUMBER_TABLE
448: , a11 JTF_NUMBER_TABLE
449: , a12 JTF_NUMBER_TABLE
450: , a13 JTF_DATE_TABLE
451: , a14 JTF_VARCHAR2_TABLE_100
452: , a15 JTF_VARCHAR2_TABLE_500
453: , a16 JTF_VARCHAR2_TABLE_500
454: , a17 JTF_VARCHAR2_TABLE_500
455: , a18 JTF_VARCHAR2_TABLE_500

Line 526: , a2 out nocopy JTF_VARCHAR2_TABLE_100

522: end if;
523: end rosetta_table_copy_in_p8;
524: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
525: , a1 out nocopy JTF_NUMBER_TABLE
526: , a2 out nocopy JTF_VARCHAR2_TABLE_100
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 527: , a3 out nocopy JTF_VARCHAR2_TABLE_100

523: end rosetta_table_copy_in_p8;
524: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
525: , a1 out nocopy JTF_NUMBER_TABLE
526: , a2 out nocopy JTF_VARCHAR2_TABLE_100
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 530: , a6 out nocopy JTF_VARCHAR2_TABLE_100

526: , a2 out nocopy JTF_VARCHAR2_TABLE_100
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE

Line 531: , a7 out nocopy JTF_VARCHAR2_TABLE_100

527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE

Line 532: , a8 out nocopy JTF_VARCHAR2_TABLE_100

528: , a4 out nocopy JTF_DATE_TABLE
529: , a5 out nocopy JTF_DATE_TABLE
530: , a6 out nocopy JTF_VARCHAR2_TABLE_100
531: , a7 out nocopy JTF_VARCHAR2_TABLE_100
532: , a8 out nocopy JTF_VARCHAR2_TABLE_100
533: , a9 out nocopy JTF_NUMBER_TABLE
534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE
536: , a12 out nocopy JTF_NUMBER_TABLE

Line 538: , a14 out nocopy JTF_VARCHAR2_TABLE_100

534: , a10 out nocopy JTF_NUMBER_TABLE
535: , a11 out nocopy JTF_NUMBER_TABLE
536: , a12 out nocopy JTF_NUMBER_TABLE
537: , a13 out nocopy JTF_DATE_TABLE
538: , a14 out nocopy JTF_VARCHAR2_TABLE_100
539: , a15 out nocopy JTF_VARCHAR2_TABLE_500
540: , a16 out nocopy JTF_VARCHAR2_TABLE_500
541: , a17 out nocopy JTF_VARCHAR2_TABLE_500
542: , a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 565: a2 := JTF_VARCHAR2_TABLE_100();

561: begin
562: if t is null or t.count = 0 then
563: a0 := JTF_NUMBER_TABLE();
564: a1 := JTF_NUMBER_TABLE();
565: a2 := JTF_VARCHAR2_TABLE_100();
566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();

Line 566: a3 := JTF_VARCHAR2_TABLE_100();

562: if t is null or t.count = 0 then
563: a0 := JTF_NUMBER_TABLE();
564: a1 := JTF_NUMBER_TABLE();
565: a2 := JTF_VARCHAR2_TABLE_100();
566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();

Line 569: a6 := JTF_VARCHAR2_TABLE_100();

565: a2 := JTF_VARCHAR2_TABLE_100();
566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();
571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();

Line 570: a7 := JTF_VARCHAR2_TABLE_100();

566: a3 := JTF_VARCHAR2_TABLE_100();
567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();
571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();

Line 571: a8 := JTF_VARCHAR2_TABLE_100();

567: a4 := JTF_DATE_TABLE();
568: a5 := JTF_DATE_TABLE();
569: a6 := JTF_VARCHAR2_TABLE_100();
570: a7 := JTF_VARCHAR2_TABLE_100();
571: a8 := JTF_VARCHAR2_TABLE_100();
572: a9 := JTF_NUMBER_TABLE();
573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();
575: a12 := JTF_NUMBER_TABLE();

Line 577: a14 := JTF_VARCHAR2_TABLE_100();

573: a10 := JTF_NUMBER_TABLE();
574: a11 := JTF_NUMBER_TABLE();
575: a12 := JTF_NUMBER_TABLE();
576: a13 := JTF_DATE_TABLE();
577: a14 := JTF_VARCHAR2_TABLE_100();
578: a15 := JTF_VARCHAR2_TABLE_500();
579: a16 := JTF_VARCHAR2_TABLE_500();
580: a17 := JTF_VARCHAR2_TABLE_500();
581: a18 := JTF_VARCHAR2_TABLE_500();

Line 601: a2 := JTF_VARCHAR2_TABLE_100();

597: a34 := JTF_NUMBER_TABLE();
598: else
599: a0 := JTF_NUMBER_TABLE();
600: a1 := JTF_NUMBER_TABLE();
601: a2 := JTF_VARCHAR2_TABLE_100();
602: a3 := JTF_VARCHAR2_TABLE_100();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();

Line 602: a3 := JTF_VARCHAR2_TABLE_100();

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

Line 605: a6 := JTF_VARCHAR2_TABLE_100();

601: a2 := JTF_VARCHAR2_TABLE_100();
602: a3 := JTF_VARCHAR2_TABLE_100();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();
606: a7 := JTF_VARCHAR2_TABLE_100();
607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();

Line 606: a7 := JTF_VARCHAR2_TABLE_100();

602: a3 := JTF_VARCHAR2_TABLE_100();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();
606: a7 := JTF_VARCHAR2_TABLE_100();
607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();

Line 607: a8 := JTF_VARCHAR2_TABLE_100();

603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();
606: a7 := JTF_VARCHAR2_TABLE_100();
607: a8 := JTF_VARCHAR2_TABLE_100();
608: a9 := JTF_NUMBER_TABLE();
609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();
611: a12 := JTF_NUMBER_TABLE();

Line 613: a14 := JTF_VARCHAR2_TABLE_100();

609: a10 := JTF_NUMBER_TABLE();
610: a11 := JTF_NUMBER_TABLE();
611: a12 := JTF_NUMBER_TABLE();
612: a13 := JTF_DATE_TABLE();
613: a14 := JTF_VARCHAR2_TABLE_100();
614: a15 := JTF_VARCHAR2_TABLE_500();
615: a16 := JTF_VARCHAR2_TABLE_500();
616: a17 := JTF_VARCHAR2_TABLE_500();
617: a18 := JTF_VARCHAR2_TABLE_500();

Line 916: , p5_a2 JTF_VARCHAR2_TABLE_100

912: , x_msg_count out nocopy NUMBER
913: , x_msg_data out nocopy VARCHAR2
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100
919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 917: , p5_a3 JTF_VARCHAR2_TABLE_100

913: , x_msg_data out nocopy VARCHAR2
914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100
919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE

Line 918: , p5_a4 JTF_VARCHAR2_TABLE_100

914: , p5_a0 JTF_NUMBER_TABLE
915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100
919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE

Line 923: , p5_a9 JTF_VARCHAR2_TABLE_100

919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE
923: , p5_a9 JTF_VARCHAR2_TABLE_100
924: , p5_a10 JTF_VARCHAR2_TABLE_100
925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE

Line 924: , p5_a10 JTF_VARCHAR2_TABLE_100

920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE
923: , p5_a9 JTF_VARCHAR2_TABLE_100
924: , p5_a10 JTF_VARCHAR2_TABLE_100
925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE

Line 925: , p5_a11 JTF_VARCHAR2_TABLE_100

921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE
923: , p5_a9 JTF_VARCHAR2_TABLE_100
924: , p5_a10 JTF_VARCHAR2_TABLE_100
925: , p5_a11 JTF_VARCHAR2_TABLE_100
926: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE
929: , p5_a15 JTF_NUMBER_TABLE

Line 931: , p5_a17 JTF_VARCHAR2_TABLE_100

927: , p5_a13 JTF_NUMBER_TABLE
928: , p5_a14 JTF_NUMBER_TABLE
929: , p5_a15 JTF_NUMBER_TABLE
930: , p5_a16 JTF_DATE_TABLE
931: , p5_a17 JTF_VARCHAR2_TABLE_100
932: , p5_a18 JTF_VARCHAR2_TABLE_500
933: , p5_a19 JTF_VARCHAR2_TABLE_500
934: , p5_a20 JTF_VARCHAR2_TABLE_500
935: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

950: , p5_a36 JTF_DATE_TABLE
951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

951: , p5_a37 JTF_NUMBER_TABLE
952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE

Line 956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

952: , p6_a0 out nocopy JTF_NUMBER_TABLE
953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE

Line 961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE
961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE
961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE
961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
963: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a12 out nocopy JTF_NUMBER_TABLE
965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE
967: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 969: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

965: , p6_a13 out nocopy JTF_NUMBER_TABLE
966: , p6_a14 out nocopy JTF_NUMBER_TABLE
967: , p6_a15 out nocopy JTF_NUMBER_TABLE
968: , p6_a16 out nocopy JTF_DATE_TABLE
969: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
970: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
971: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
972: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
973: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 1220: , p5_a2 JTF_VARCHAR2_TABLE_100

1216: , x_msg_count out nocopy NUMBER
1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_VARCHAR2_TABLE_100
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 1221: , p5_a3 JTF_VARCHAR2_TABLE_100

1217: , x_msg_data out nocopy VARCHAR2
1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_VARCHAR2_TABLE_100
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE

Line 1222: , p5_a4 JTF_VARCHAR2_TABLE_100

1218: , p5_a0 JTF_NUMBER_TABLE
1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_VARCHAR2_TABLE_100
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE

Line 1227: , p5_a9 JTF_VARCHAR2_TABLE_100

1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE
1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE

Line 1228: , p5_a10 JTF_VARCHAR2_TABLE_100

1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE
1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE

Line 1229: , p5_a11 JTF_VARCHAR2_TABLE_100

1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE
1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100
1229: , p5_a11 JTF_VARCHAR2_TABLE_100
1230: , p5_a12 JTF_NUMBER_TABLE
1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE
1233: , p5_a15 JTF_NUMBER_TABLE

Line 1235: , p5_a17 JTF_VARCHAR2_TABLE_100

1231: , p5_a13 JTF_NUMBER_TABLE
1232: , p5_a14 JTF_NUMBER_TABLE
1233: , p5_a15 JTF_NUMBER_TABLE
1234: , p5_a16 JTF_DATE_TABLE
1235: , p5_a17 JTF_VARCHAR2_TABLE_100
1236: , p5_a18 JTF_VARCHAR2_TABLE_500
1237: , p5_a19 JTF_VARCHAR2_TABLE_500
1238: , p5_a20 JTF_VARCHAR2_TABLE_500
1239: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 1523: , p5_a2 JTF_VARCHAR2_TABLE_100

1519: , x_msg_count out nocopy NUMBER
1520: , x_msg_data out nocopy VARCHAR2
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100
1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 1524: , p5_a3 JTF_VARCHAR2_TABLE_100

1520: , x_msg_data out nocopy VARCHAR2
1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100
1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE

Line 1525: , p5_a4 JTF_VARCHAR2_TABLE_100

1521: , p5_a0 JTF_NUMBER_TABLE
1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100
1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE

Line 1530: , p5_a9 JTF_VARCHAR2_TABLE_100

1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE
1530: , p5_a9 JTF_VARCHAR2_TABLE_100
1531: , p5_a10 JTF_VARCHAR2_TABLE_100
1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE

Line 1531: , p5_a10 JTF_VARCHAR2_TABLE_100

1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE
1530: , p5_a9 JTF_VARCHAR2_TABLE_100
1531: , p5_a10 JTF_VARCHAR2_TABLE_100
1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE

Line 1532: , p5_a11 JTF_VARCHAR2_TABLE_100

1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE
1530: , p5_a9 JTF_VARCHAR2_TABLE_100
1531: , p5_a10 JTF_VARCHAR2_TABLE_100
1532: , p5_a11 JTF_VARCHAR2_TABLE_100
1533: , p5_a12 JTF_NUMBER_TABLE
1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE
1536: , p5_a15 JTF_NUMBER_TABLE

Line 1538: , p5_a17 JTF_VARCHAR2_TABLE_100

1534: , p5_a13 JTF_NUMBER_TABLE
1535: , p5_a14 JTF_NUMBER_TABLE
1536: , p5_a15 JTF_NUMBER_TABLE
1537: , p5_a16 JTF_DATE_TABLE
1538: , p5_a17 JTF_VARCHAR2_TABLE_100
1539: , p5_a18 JTF_VARCHAR2_TABLE_500
1540: , p5_a19 JTF_VARCHAR2_TABLE_500
1541: , p5_a20 JTF_VARCHAR2_TABLE_500
1542: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1557: , p5_a36 JTF_DATE_TABLE
1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

1558: , p5_a37 JTF_NUMBER_TABLE
1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE

Line 1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

1559: , p6_a0 out nocopy JTF_NUMBER_TABLE
1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE

Line 1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE
1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE
1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE
1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p6_a12 out nocopy JTF_NUMBER_TABLE
1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE
1574: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 1576: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

1572: , p6_a13 out nocopy JTF_NUMBER_TABLE
1573: , p6_a14 out nocopy JTF_NUMBER_TABLE
1574: , p6_a15 out nocopy JTF_NUMBER_TABLE
1575: , p6_a16 out nocopy JTF_DATE_TABLE
1576: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1578: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1579: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1580: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 1827: , p5_a2 JTF_VARCHAR2_TABLE_100

1823: , x_msg_count out nocopy NUMBER
1824: , x_msg_data out nocopy VARCHAR2
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100
1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 1828: , p5_a3 JTF_VARCHAR2_TABLE_100

1824: , x_msg_data out nocopy VARCHAR2
1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100
1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE

Line 1829: , p5_a4 JTF_VARCHAR2_TABLE_100

1825: , p5_a0 JTF_NUMBER_TABLE
1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100
1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE

Line 1834: , p5_a9 JTF_VARCHAR2_TABLE_100

1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE
1834: , p5_a9 JTF_VARCHAR2_TABLE_100
1835: , p5_a10 JTF_VARCHAR2_TABLE_100
1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE

Line 1835: , p5_a10 JTF_VARCHAR2_TABLE_100

1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE
1834: , p5_a9 JTF_VARCHAR2_TABLE_100
1835: , p5_a10 JTF_VARCHAR2_TABLE_100
1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE

Line 1836: , p5_a11 JTF_VARCHAR2_TABLE_100

1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE
1834: , p5_a9 JTF_VARCHAR2_TABLE_100
1835: , p5_a10 JTF_VARCHAR2_TABLE_100
1836: , p5_a11 JTF_VARCHAR2_TABLE_100
1837: , p5_a12 JTF_NUMBER_TABLE
1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE
1840: , p5_a15 JTF_NUMBER_TABLE

Line 1842: , p5_a17 JTF_VARCHAR2_TABLE_100

1838: , p5_a13 JTF_NUMBER_TABLE
1839: , p5_a14 JTF_NUMBER_TABLE
1840: , p5_a15 JTF_NUMBER_TABLE
1841: , p5_a16 JTF_DATE_TABLE
1842: , p5_a17 JTF_VARCHAR2_TABLE_100
1843: , p5_a18 JTF_VARCHAR2_TABLE_500
1844: , p5_a19 JTF_VARCHAR2_TABLE_500
1845: , p5_a20 JTF_VARCHAR2_TABLE_500
1846: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 2050: , p5_a2 JTF_VARCHAR2_TABLE_100

2046: , x_msg_count out nocopy NUMBER
2047: , x_msg_data out nocopy VARCHAR2
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100
2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 2051: , p5_a3 JTF_VARCHAR2_TABLE_100

2047: , x_msg_data out nocopy VARCHAR2
2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100
2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE

Line 2052: , p5_a4 JTF_VARCHAR2_TABLE_100

2048: , p5_a0 JTF_NUMBER_TABLE
2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100
2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE

Line 2057: , p5_a9 JTF_VARCHAR2_TABLE_100

2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE
2057: , p5_a9 JTF_VARCHAR2_TABLE_100
2058: , p5_a10 JTF_VARCHAR2_TABLE_100
2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE

Line 2058: , p5_a10 JTF_VARCHAR2_TABLE_100

2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE
2057: , p5_a9 JTF_VARCHAR2_TABLE_100
2058: , p5_a10 JTF_VARCHAR2_TABLE_100
2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE

Line 2059: , p5_a11 JTF_VARCHAR2_TABLE_100

2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE
2057: , p5_a9 JTF_VARCHAR2_TABLE_100
2058: , p5_a10 JTF_VARCHAR2_TABLE_100
2059: , p5_a11 JTF_VARCHAR2_TABLE_100
2060: , p5_a12 JTF_NUMBER_TABLE
2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE
2063: , p5_a15 JTF_NUMBER_TABLE

Line 2065: , p5_a17 JTF_VARCHAR2_TABLE_100

2061: , p5_a13 JTF_NUMBER_TABLE
2062: , p5_a14 JTF_NUMBER_TABLE
2063: , p5_a15 JTF_NUMBER_TABLE
2064: , p5_a16 JTF_DATE_TABLE
2065: , p5_a17 JTF_VARCHAR2_TABLE_100
2066: , p5_a18 JTF_VARCHAR2_TABLE_500
2067: , p5_a19 JTF_VARCHAR2_TABLE_500
2068: , p5_a20 JTF_VARCHAR2_TABLE_500
2069: , p5_a21 JTF_VARCHAR2_TABLE_500