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_SIB_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sib_pvt.sibv_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sib_pvt.sibv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sib_pvt.sibv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_DATE_TABLE

Line 29: , a7 JTF_NUMBER_TABLE

25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_500

Line 30: , a8 JTF_NUMBER_TABLE

26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_500
34: , a12 JTF_VARCHAR2_TABLE_500

Line 48: , a26 JTF_NUMBER_TABLE

44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE

Line 50: , a28 JTF_NUMBER_TABLE

46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;

Line 52: , a30 JTF_NUMBER_TABLE

48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_DATE_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if a0 is not null and a0.count > 0 then

Line 101: procedure rosetta_table_copy_out_p2(t okl_sib_pvt.sibv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sib_pvt.sibv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 102: , a1 out nocopy JTF_NUMBER_TABLE

98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sib_pvt.sibv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_DATE_TABLE

Line 108: , a7 out nocopy JTF_NUMBER_TABLE

104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_DATE_TABLE
107: , a6 out nocopy JTF_VARCHAR2_TABLE_100
108: , a7 out nocopy JTF_NUMBER_TABLE
109: , a8 out nocopy JTF_NUMBER_TABLE
110: , a9 out nocopy JTF_DATE_TABLE
111: , a10 out nocopy JTF_VARCHAR2_TABLE_100
112: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 109: , a8 out nocopy JTF_NUMBER_TABLE

105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_DATE_TABLE
107: , a6 out nocopy JTF_VARCHAR2_TABLE_100
108: , a7 out nocopy JTF_NUMBER_TABLE
109: , a8 out nocopy JTF_NUMBER_TABLE
110: , a9 out nocopy JTF_DATE_TABLE
111: , a10 out nocopy JTF_VARCHAR2_TABLE_100
112: , a11 out nocopy JTF_VARCHAR2_TABLE_500
113: , a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 127: , a26 out nocopy JTF_NUMBER_TABLE

123: , a22 out nocopy JTF_VARCHAR2_TABLE_500
124: , a23 out nocopy JTF_VARCHAR2_TABLE_500
125: , a24 out nocopy JTF_VARCHAR2_TABLE_500
126: , a25 out nocopy JTF_VARCHAR2_TABLE_500
127: , a26 out nocopy JTF_NUMBER_TABLE
128: , a27 out nocopy JTF_DATE_TABLE
129: , a28 out nocopy JTF_NUMBER_TABLE
130: , a29 out nocopy JTF_DATE_TABLE
131: , a30 out nocopy JTF_NUMBER_TABLE

Line 129: , a28 out nocopy JTF_NUMBER_TABLE

125: , a24 out nocopy JTF_VARCHAR2_TABLE_500
126: , a25 out nocopy JTF_VARCHAR2_TABLE_500
127: , a26 out nocopy JTF_NUMBER_TABLE
128: , a27 out nocopy JTF_DATE_TABLE
129: , a28 out nocopy JTF_NUMBER_TABLE
130: , a29 out nocopy JTF_DATE_TABLE
131: , a30 out nocopy JTF_NUMBER_TABLE
132: ) as
133: ddindx binary_integer; indx binary_integer;

Line 131: , a30 out nocopy JTF_NUMBER_TABLE

127: , a26 out nocopy JTF_NUMBER_TABLE
128: , a27 out nocopy JTF_DATE_TABLE
129: , a28 out nocopy JTF_NUMBER_TABLE
130: , a29 out nocopy JTF_DATE_TABLE
131: , a30 out nocopy JTF_NUMBER_TABLE
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then

Line 136: a0 := JTF_NUMBER_TABLE();

132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_100();

Line 137: a1 := JTF_NUMBER_TABLE();

133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_DATE_TABLE();

Line 143: a7 := JTF_NUMBER_TABLE();

139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_DATE_TABLE();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_NUMBER_TABLE();
145: a9 := JTF_DATE_TABLE();
146: a10 := JTF_VARCHAR2_TABLE_100();
147: a11 := JTF_VARCHAR2_TABLE_500();

Line 144: a8 := JTF_NUMBER_TABLE();

140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_DATE_TABLE();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_NUMBER_TABLE();
145: a9 := JTF_DATE_TABLE();
146: a10 := JTF_VARCHAR2_TABLE_100();
147: a11 := JTF_VARCHAR2_TABLE_500();
148: a12 := JTF_VARCHAR2_TABLE_500();

Line 162: a26 := JTF_NUMBER_TABLE();

158: a22 := JTF_VARCHAR2_TABLE_500();
159: a23 := JTF_VARCHAR2_TABLE_500();
160: a24 := JTF_VARCHAR2_TABLE_500();
161: a25 := JTF_VARCHAR2_TABLE_500();
162: a26 := JTF_NUMBER_TABLE();
163: a27 := JTF_DATE_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();

Line 164: a28 := JTF_NUMBER_TABLE();

160: a24 := JTF_VARCHAR2_TABLE_500();
161: a25 := JTF_VARCHAR2_TABLE_500();
162: a26 := JTF_NUMBER_TABLE();
163: a27 := JTF_DATE_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();

Line 166: a30 := JTF_NUMBER_TABLE();

162: a26 := JTF_NUMBER_TABLE();
163: a27 := JTF_DATE_TABLE();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_VARCHAR2_TABLE_100();

Line 168: a0 := JTF_NUMBER_TABLE();

164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_VARCHAR2_TABLE_100();
171: a3 := JTF_VARCHAR2_TABLE_200();
172: a4 := JTF_VARCHAR2_TABLE_100();

Line 169: a1 := JTF_NUMBER_TABLE();

165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_VARCHAR2_TABLE_100();
171: a3 := JTF_VARCHAR2_TABLE_200();
172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_DATE_TABLE();

Line 175: a7 := JTF_NUMBER_TABLE();

171: a3 := JTF_VARCHAR2_TABLE_200();
172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_DATE_TABLE();
174: a6 := JTF_VARCHAR2_TABLE_100();
175: a7 := JTF_NUMBER_TABLE();
176: a8 := JTF_NUMBER_TABLE();
177: a9 := JTF_DATE_TABLE();
178: a10 := JTF_VARCHAR2_TABLE_100();
179: a11 := JTF_VARCHAR2_TABLE_500();

Line 176: a8 := JTF_NUMBER_TABLE();

172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_DATE_TABLE();
174: a6 := JTF_VARCHAR2_TABLE_100();
175: a7 := JTF_NUMBER_TABLE();
176: a8 := JTF_NUMBER_TABLE();
177: a9 := JTF_DATE_TABLE();
178: a10 := JTF_VARCHAR2_TABLE_100();
179: a11 := JTF_VARCHAR2_TABLE_500();
180: a12 := JTF_VARCHAR2_TABLE_500();

Line 194: a26 := JTF_NUMBER_TABLE();

190: a22 := JTF_VARCHAR2_TABLE_500();
191: a23 := JTF_VARCHAR2_TABLE_500();
192: a24 := JTF_VARCHAR2_TABLE_500();
193: a25 := JTF_VARCHAR2_TABLE_500();
194: a26 := JTF_NUMBER_TABLE();
195: a27 := JTF_DATE_TABLE();
196: a28 := JTF_NUMBER_TABLE();
197: a29 := JTF_DATE_TABLE();
198: a30 := JTF_NUMBER_TABLE();

Line 196: a28 := JTF_NUMBER_TABLE();

192: a24 := JTF_VARCHAR2_TABLE_500();
193: a25 := JTF_VARCHAR2_TABLE_500();
194: a26 := JTF_NUMBER_TABLE();
195: a27 := JTF_DATE_TABLE();
196: a28 := JTF_NUMBER_TABLE();
197: a29 := JTF_DATE_TABLE();
198: a30 := JTF_NUMBER_TABLE();
199: if t.count > 0 then
200: a0.extend(t.count);

Line 198: a30 := JTF_NUMBER_TABLE();

194: a26 := JTF_NUMBER_TABLE();
195: a27 := JTF_DATE_TABLE();
196: a28 := JTF_NUMBER_TABLE();
197: a29 := JTF_DATE_TABLE();
198: a30 := JTF_NUMBER_TABLE();
199: if t.count > 0 then
200: a0.extend(t.count);
201: a1.extend(t.count);
202: a2.extend(t.count);

Line 275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sib_pvt.sib_tbl_type, a0 JTF_NUMBER_TABLE

271: end if;
272: end if;
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sib_pvt.sib_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_VARCHAR2_TABLE_100
278: , a3 JTF_DATE_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100

Line 276: , a1 JTF_NUMBER_TABLE

272: end if;
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sib_pvt.sib_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_VARCHAR2_TABLE_100
278: , a3 JTF_DATE_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_NUMBER_TABLE

Line 280: , a5 JTF_NUMBER_TABLE

276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_VARCHAR2_TABLE_100
278: , a3 JTF_DATE_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_NUMBER_TABLE
281: , a6 JTF_VARCHAR2_TABLE_200
282: , a7 JTF_NUMBER_TABLE
283: , a8 JTF_DATE_TABLE
284: , a9 JTF_VARCHAR2_TABLE_100

Line 282: , a7 JTF_NUMBER_TABLE

278: , a3 JTF_DATE_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_NUMBER_TABLE
281: , a6 JTF_VARCHAR2_TABLE_200
282: , a7 JTF_NUMBER_TABLE
283: , a8 JTF_DATE_TABLE
284: , a9 JTF_VARCHAR2_TABLE_100
285: , a10 JTF_VARCHAR2_TABLE_500
286: , a11 JTF_VARCHAR2_TABLE_500

Line 300: , a25 JTF_NUMBER_TABLE

296: , a21 JTF_VARCHAR2_TABLE_500
297: , a22 JTF_VARCHAR2_TABLE_500
298: , a23 JTF_VARCHAR2_TABLE_500
299: , a24 JTF_VARCHAR2_TABLE_500
300: , a25 JTF_NUMBER_TABLE
301: , a26 JTF_DATE_TABLE
302: , a27 JTF_NUMBER_TABLE
303: , a28 JTF_DATE_TABLE
304: , a29 JTF_NUMBER_TABLE

Line 302: , a27 JTF_NUMBER_TABLE

298: , a23 JTF_VARCHAR2_TABLE_500
299: , a24 JTF_VARCHAR2_TABLE_500
300: , a25 JTF_NUMBER_TABLE
301: , a26 JTF_DATE_TABLE
302: , a27 JTF_NUMBER_TABLE
303: , a28 JTF_DATE_TABLE
304: , a29 JTF_NUMBER_TABLE
305: ) as
306: ddindx binary_integer; indx binary_integer;

Line 304: , a29 JTF_NUMBER_TABLE

300: , a25 JTF_NUMBER_TABLE
301: , a26 JTF_DATE_TABLE
302: , a27 JTF_NUMBER_TABLE
303: , a28 JTF_DATE_TABLE
304: , a29 JTF_NUMBER_TABLE
305: ) as
306: ddindx binary_integer; indx binary_integer;
307: begin
308: if a0 is not null and a0.count > 0 then

Line 352: procedure rosetta_table_copy_out_p5(t okl_sib_pvt.sib_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

348: end loop;
349: end if;
350: end if;
351: end rosetta_table_copy_in_p5;
352: procedure rosetta_table_copy_out_p5(t okl_sib_pvt.sib_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
353: , a1 out nocopy JTF_NUMBER_TABLE
354: , a2 out nocopy JTF_VARCHAR2_TABLE_100
355: , a3 out nocopy JTF_DATE_TABLE
356: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 353: , a1 out nocopy JTF_NUMBER_TABLE

349: end if;
350: end if;
351: end rosetta_table_copy_in_p5;
352: procedure rosetta_table_copy_out_p5(t okl_sib_pvt.sib_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
353: , a1 out nocopy JTF_NUMBER_TABLE
354: , a2 out nocopy JTF_VARCHAR2_TABLE_100
355: , a3 out nocopy JTF_DATE_TABLE
356: , a4 out nocopy JTF_VARCHAR2_TABLE_100
357: , a5 out nocopy JTF_NUMBER_TABLE

Line 357: , a5 out nocopy JTF_NUMBER_TABLE

353: , a1 out nocopy JTF_NUMBER_TABLE
354: , a2 out nocopy JTF_VARCHAR2_TABLE_100
355: , a3 out nocopy JTF_DATE_TABLE
356: , a4 out nocopy JTF_VARCHAR2_TABLE_100
357: , a5 out nocopy JTF_NUMBER_TABLE
358: , a6 out nocopy JTF_VARCHAR2_TABLE_200
359: , a7 out nocopy JTF_NUMBER_TABLE
360: , a8 out nocopy JTF_DATE_TABLE
361: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 359: , a7 out nocopy JTF_NUMBER_TABLE

355: , a3 out nocopy JTF_DATE_TABLE
356: , a4 out nocopy JTF_VARCHAR2_TABLE_100
357: , a5 out nocopy JTF_NUMBER_TABLE
358: , a6 out nocopy JTF_VARCHAR2_TABLE_200
359: , a7 out nocopy JTF_NUMBER_TABLE
360: , a8 out nocopy JTF_DATE_TABLE
361: , a9 out nocopy JTF_VARCHAR2_TABLE_100
362: , a10 out nocopy JTF_VARCHAR2_TABLE_500
363: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 377: , a25 out nocopy JTF_NUMBER_TABLE

373: , a21 out nocopy JTF_VARCHAR2_TABLE_500
374: , a22 out nocopy JTF_VARCHAR2_TABLE_500
375: , a23 out nocopy JTF_VARCHAR2_TABLE_500
376: , a24 out nocopy JTF_VARCHAR2_TABLE_500
377: , a25 out nocopy JTF_NUMBER_TABLE
378: , a26 out nocopy JTF_DATE_TABLE
379: , a27 out nocopy JTF_NUMBER_TABLE
380: , a28 out nocopy JTF_DATE_TABLE
381: , a29 out nocopy JTF_NUMBER_TABLE

Line 379: , a27 out nocopy JTF_NUMBER_TABLE

375: , a23 out nocopy JTF_VARCHAR2_TABLE_500
376: , a24 out nocopy JTF_VARCHAR2_TABLE_500
377: , a25 out nocopy JTF_NUMBER_TABLE
378: , a26 out nocopy JTF_DATE_TABLE
379: , a27 out nocopy JTF_NUMBER_TABLE
380: , a28 out nocopy JTF_DATE_TABLE
381: , a29 out nocopy JTF_NUMBER_TABLE
382: ) as
383: ddindx binary_integer; indx binary_integer;

Line 381: , a29 out nocopy JTF_NUMBER_TABLE

377: , a25 out nocopy JTF_NUMBER_TABLE
378: , a26 out nocopy JTF_DATE_TABLE
379: , a27 out nocopy JTF_NUMBER_TABLE
380: , a28 out nocopy JTF_DATE_TABLE
381: , a29 out nocopy JTF_NUMBER_TABLE
382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if t is null or t.count = 0 then

Line 386: a0 := JTF_NUMBER_TABLE();

382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if t is null or t.count = 0 then
386: a0 := JTF_NUMBER_TABLE();
387: a1 := JTF_NUMBER_TABLE();
388: a2 := JTF_VARCHAR2_TABLE_100();
389: a3 := JTF_DATE_TABLE();
390: a4 := JTF_VARCHAR2_TABLE_100();

Line 387: a1 := JTF_NUMBER_TABLE();

383: ddindx binary_integer; indx binary_integer;
384: begin
385: if t is null or t.count = 0 then
386: a0 := JTF_NUMBER_TABLE();
387: a1 := JTF_NUMBER_TABLE();
388: a2 := JTF_VARCHAR2_TABLE_100();
389: a3 := JTF_DATE_TABLE();
390: a4 := JTF_VARCHAR2_TABLE_100();
391: a5 := JTF_NUMBER_TABLE();

Line 391: a5 := JTF_NUMBER_TABLE();

387: a1 := JTF_NUMBER_TABLE();
388: a2 := JTF_VARCHAR2_TABLE_100();
389: a3 := JTF_DATE_TABLE();
390: a4 := JTF_VARCHAR2_TABLE_100();
391: a5 := JTF_NUMBER_TABLE();
392: a6 := JTF_VARCHAR2_TABLE_200();
393: a7 := JTF_NUMBER_TABLE();
394: a8 := JTF_DATE_TABLE();
395: a9 := JTF_VARCHAR2_TABLE_100();

Line 393: a7 := JTF_NUMBER_TABLE();

389: a3 := JTF_DATE_TABLE();
390: a4 := JTF_VARCHAR2_TABLE_100();
391: a5 := JTF_NUMBER_TABLE();
392: a6 := JTF_VARCHAR2_TABLE_200();
393: a7 := JTF_NUMBER_TABLE();
394: a8 := JTF_DATE_TABLE();
395: a9 := JTF_VARCHAR2_TABLE_100();
396: a10 := JTF_VARCHAR2_TABLE_500();
397: a11 := JTF_VARCHAR2_TABLE_500();

Line 411: a25 := JTF_NUMBER_TABLE();

407: a21 := JTF_VARCHAR2_TABLE_500();
408: a22 := JTF_VARCHAR2_TABLE_500();
409: a23 := JTF_VARCHAR2_TABLE_500();
410: a24 := JTF_VARCHAR2_TABLE_500();
411: a25 := JTF_NUMBER_TABLE();
412: a26 := JTF_DATE_TABLE();
413: a27 := JTF_NUMBER_TABLE();
414: a28 := JTF_DATE_TABLE();
415: a29 := JTF_NUMBER_TABLE();

Line 413: a27 := JTF_NUMBER_TABLE();

409: a23 := JTF_VARCHAR2_TABLE_500();
410: a24 := JTF_VARCHAR2_TABLE_500();
411: a25 := JTF_NUMBER_TABLE();
412: a26 := JTF_DATE_TABLE();
413: a27 := JTF_NUMBER_TABLE();
414: a28 := JTF_DATE_TABLE();
415: a29 := JTF_NUMBER_TABLE();
416: else
417: a0 := JTF_NUMBER_TABLE();

Line 415: a29 := JTF_NUMBER_TABLE();

411: a25 := JTF_NUMBER_TABLE();
412: a26 := JTF_DATE_TABLE();
413: a27 := JTF_NUMBER_TABLE();
414: a28 := JTF_DATE_TABLE();
415: a29 := JTF_NUMBER_TABLE();
416: else
417: a0 := JTF_NUMBER_TABLE();
418: a1 := JTF_NUMBER_TABLE();
419: a2 := JTF_VARCHAR2_TABLE_100();

Line 417: a0 := JTF_NUMBER_TABLE();

413: a27 := JTF_NUMBER_TABLE();
414: a28 := JTF_DATE_TABLE();
415: a29 := JTF_NUMBER_TABLE();
416: else
417: a0 := JTF_NUMBER_TABLE();
418: a1 := JTF_NUMBER_TABLE();
419: a2 := JTF_VARCHAR2_TABLE_100();
420: a3 := JTF_DATE_TABLE();
421: a4 := JTF_VARCHAR2_TABLE_100();

Line 418: a1 := JTF_NUMBER_TABLE();

414: a28 := JTF_DATE_TABLE();
415: a29 := JTF_NUMBER_TABLE();
416: else
417: a0 := JTF_NUMBER_TABLE();
418: a1 := JTF_NUMBER_TABLE();
419: a2 := JTF_VARCHAR2_TABLE_100();
420: a3 := JTF_DATE_TABLE();
421: a4 := JTF_VARCHAR2_TABLE_100();
422: a5 := JTF_NUMBER_TABLE();

Line 422: a5 := JTF_NUMBER_TABLE();

418: a1 := JTF_NUMBER_TABLE();
419: a2 := JTF_VARCHAR2_TABLE_100();
420: a3 := JTF_DATE_TABLE();
421: a4 := JTF_VARCHAR2_TABLE_100();
422: a5 := JTF_NUMBER_TABLE();
423: a6 := JTF_VARCHAR2_TABLE_200();
424: a7 := JTF_NUMBER_TABLE();
425: a8 := JTF_DATE_TABLE();
426: a9 := JTF_VARCHAR2_TABLE_100();

Line 424: a7 := JTF_NUMBER_TABLE();

420: a3 := JTF_DATE_TABLE();
421: a4 := JTF_VARCHAR2_TABLE_100();
422: a5 := JTF_NUMBER_TABLE();
423: a6 := JTF_VARCHAR2_TABLE_200();
424: a7 := JTF_NUMBER_TABLE();
425: a8 := JTF_DATE_TABLE();
426: a9 := JTF_VARCHAR2_TABLE_100();
427: a10 := JTF_VARCHAR2_TABLE_500();
428: a11 := JTF_VARCHAR2_TABLE_500();

Line 442: a25 := JTF_NUMBER_TABLE();

438: a21 := JTF_VARCHAR2_TABLE_500();
439: a22 := JTF_VARCHAR2_TABLE_500();
440: a23 := JTF_VARCHAR2_TABLE_500();
441: a24 := JTF_VARCHAR2_TABLE_500();
442: a25 := JTF_NUMBER_TABLE();
443: a26 := JTF_DATE_TABLE();
444: a27 := JTF_NUMBER_TABLE();
445: a28 := JTF_DATE_TABLE();
446: a29 := JTF_NUMBER_TABLE();

Line 444: a27 := JTF_NUMBER_TABLE();

440: a23 := JTF_VARCHAR2_TABLE_500();
441: a24 := JTF_VARCHAR2_TABLE_500();
442: a25 := JTF_NUMBER_TABLE();
443: a26 := JTF_DATE_TABLE();
444: a27 := JTF_NUMBER_TABLE();
445: a28 := JTF_DATE_TABLE();
446: a29 := JTF_NUMBER_TABLE();
447: if t.count > 0 then
448: a0.extend(t.count);

Line 446: a29 := JTF_NUMBER_TABLE();

442: a25 := JTF_NUMBER_TABLE();
443: a26 := JTF_DATE_TABLE();
444: a27 := JTF_NUMBER_TABLE();
445: a28 := JTF_DATE_TABLE();
446: a29 := JTF_NUMBER_TABLE();
447: if t.count > 0 then
448: a0.extend(t.count);
449: a1.extend(t.count);
450: a2.extend(t.count);

Line 521: procedure rosetta_table_copy_in_p8(t out nocopy okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 JTF_NUMBER_TABLE

517: end if;
518: end if;
519: end rosetta_table_copy_out_p5;
520:
521: procedure rosetta_table_copy_in_p8(t out nocopy okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 JTF_NUMBER_TABLE
522: , a1 JTF_VARCHAR2_TABLE_200
523: , a2 JTF_VARCHAR2_TABLE_100
524: , a3 JTF_VARCHAR2_TABLE_100
525: , a4 JTF_VARCHAR2_TABLE_100

Line 526: , a5 JTF_NUMBER_TABLE

522: , a1 JTF_VARCHAR2_TABLE_200
523: , a2 JTF_VARCHAR2_TABLE_100
524: , a3 JTF_VARCHAR2_TABLE_100
525: , a4 JTF_VARCHAR2_TABLE_100
526: , a5 JTF_NUMBER_TABLE
527: , a6 JTF_DATE_TABLE
528: , a7 JTF_NUMBER_TABLE
529: , a8 JTF_DATE_TABLE
530: , a9 JTF_NUMBER_TABLE

Line 528: , a7 JTF_NUMBER_TABLE

524: , a3 JTF_VARCHAR2_TABLE_100
525: , a4 JTF_VARCHAR2_TABLE_100
526: , a5 JTF_NUMBER_TABLE
527: , a6 JTF_DATE_TABLE
528: , a7 JTF_NUMBER_TABLE
529: , a8 JTF_DATE_TABLE
530: , a9 JTF_NUMBER_TABLE
531: ) as
532: ddindx binary_integer; indx binary_integer;

Line 530: , a9 JTF_NUMBER_TABLE

526: , a5 JTF_NUMBER_TABLE
527: , a6 JTF_DATE_TABLE
528: , a7 JTF_NUMBER_TABLE
529: , a8 JTF_DATE_TABLE
530: , a9 JTF_NUMBER_TABLE
531: ) as
532: ddindx binary_integer; indx binary_integer;
533: begin
534: if a0 is not null and a0.count > 0 then

Line 558: procedure rosetta_table_copy_out_p8(t okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 out nocopy JTF_NUMBER_TABLE

554: end loop;
555: end if;
556: end if;
557: end rosetta_table_copy_in_p8;
558: procedure rosetta_table_copy_out_p8(t okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_VARCHAR2_TABLE_200
560: , a2 out nocopy JTF_VARCHAR2_TABLE_100
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 563: , a5 out nocopy JTF_NUMBER_TABLE

559: , a1 out nocopy JTF_VARCHAR2_TABLE_200
560: , a2 out nocopy JTF_VARCHAR2_TABLE_100
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_100
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_DATE_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_DATE_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE

Line 565: , a7 out nocopy JTF_NUMBER_TABLE

561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_100
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_DATE_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_DATE_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
568: ) as
569: ddindx binary_integer; indx binary_integer;

Line 567: , a9 out nocopy JTF_NUMBER_TABLE

563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_DATE_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_DATE_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
568: ) as
569: ddindx binary_integer; indx binary_integer;
570: begin
571: if t is null or t.count = 0 then

Line 572: a0 := JTF_NUMBER_TABLE();

568: ) as
569: ddindx binary_integer; indx binary_integer;
570: begin
571: if t is null or t.count = 0 then
572: a0 := JTF_NUMBER_TABLE();
573: a1 := JTF_VARCHAR2_TABLE_200();
574: a2 := JTF_VARCHAR2_TABLE_100();
575: a3 := JTF_VARCHAR2_TABLE_100();
576: a4 := JTF_VARCHAR2_TABLE_100();

Line 577: a5 := JTF_NUMBER_TABLE();

573: a1 := JTF_VARCHAR2_TABLE_200();
574: a2 := JTF_VARCHAR2_TABLE_100();
575: a3 := JTF_VARCHAR2_TABLE_100();
576: a4 := JTF_VARCHAR2_TABLE_100();
577: a5 := JTF_NUMBER_TABLE();
578: a6 := JTF_DATE_TABLE();
579: a7 := JTF_NUMBER_TABLE();
580: a8 := JTF_DATE_TABLE();
581: a9 := JTF_NUMBER_TABLE();

Line 579: a7 := JTF_NUMBER_TABLE();

575: a3 := JTF_VARCHAR2_TABLE_100();
576: a4 := JTF_VARCHAR2_TABLE_100();
577: a5 := JTF_NUMBER_TABLE();
578: a6 := JTF_DATE_TABLE();
579: a7 := JTF_NUMBER_TABLE();
580: a8 := JTF_DATE_TABLE();
581: a9 := JTF_NUMBER_TABLE();
582: else
583: a0 := JTF_NUMBER_TABLE();

Line 581: a9 := JTF_NUMBER_TABLE();

577: a5 := JTF_NUMBER_TABLE();
578: a6 := JTF_DATE_TABLE();
579: a7 := JTF_NUMBER_TABLE();
580: a8 := JTF_DATE_TABLE();
581: a9 := JTF_NUMBER_TABLE();
582: else
583: a0 := JTF_NUMBER_TABLE();
584: a1 := JTF_VARCHAR2_TABLE_200();
585: a2 := JTF_VARCHAR2_TABLE_100();

Line 583: a0 := JTF_NUMBER_TABLE();

579: a7 := JTF_NUMBER_TABLE();
580: a8 := JTF_DATE_TABLE();
581: a9 := JTF_NUMBER_TABLE();
582: else
583: a0 := JTF_NUMBER_TABLE();
584: a1 := JTF_VARCHAR2_TABLE_200();
585: a2 := JTF_VARCHAR2_TABLE_100();
586: a3 := JTF_VARCHAR2_TABLE_100();
587: a4 := JTF_VARCHAR2_TABLE_100();

Line 588: a5 := JTF_NUMBER_TABLE();

584: a1 := JTF_VARCHAR2_TABLE_200();
585: a2 := JTF_VARCHAR2_TABLE_100();
586: a3 := JTF_VARCHAR2_TABLE_100();
587: a4 := JTF_VARCHAR2_TABLE_100();
588: a5 := JTF_NUMBER_TABLE();
589: a6 := JTF_DATE_TABLE();
590: a7 := JTF_NUMBER_TABLE();
591: a8 := JTF_DATE_TABLE();
592: a9 := JTF_NUMBER_TABLE();

Line 590: a7 := JTF_NUMBER_TABLE();

586: a3 := JTF_VARCHAR2_TABLE_100();
587: a4 := JTF_VARCHAR2_TABLE_100();
588: a5 := JTF_NUMBER_TABLE();
589: a6 := JTF_DATE_TABLE();
590: a7 := JTF_NUMBER_TABLE();
591: a8 := JTF_DATE_TABLE();
592: a9 := JTF_NUMBER_TABLE();
593: if t.count > 0 then
594: a0.extend(t.count);

Line 592: a9 := JTF_NUMBER_TABLE();

588: a5 := JTF_NUMBER_TABLE();
589: a6 := JTF_DATE_TABLE();
590: a7 := JTF_NUMBER_TABLE();
591: a8 := JTF_DATE_TABLE();
592: a9 := JTF_NUMBER_TABLE();
593: if t.count > 0 then
594: a0.extend(t.count);
595: a1.extend(t.count);
596: a2.extend(t.count);

Line 795: , p5_a0 JTF_NUMBER_TABLE

791: , p_init_msg_list VARCHAR2
792: , x_return_status out nocopy VARCHAR2
793: , x_msg_count out nocopy NUMBER
794: , x_msg_data out nocopy VARCHAR2
795: , p5_a0 JTF_NUMBER_TABLE
796: , p5_a1 JTF_NUMBER_TABLE
797: , p5_a2 JTF_VARCHAR2_TABLE_100
798: , p5_a3 JTF_VARCHAR2_TABLE_200
799: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 796: , p5_a1 JTF_NUMBER_TABLE

792: , x_return_status out nocopy VARCHAR2
793: , x_msg_count out nocopy NUMBER
794: , x_msg_data out nocopy VARCHAR2
795: , p5_a0 JTF_NUMBER_TABLE
796: , p5_a1 JTF_NUMBER_TABLE
797: , p5_a2 JTF_VARCHAR2_TABLE_100
798: , p5_a3 JTF_VARCHAR2_TABLE_200
799: , p5_a4 JTF_VARCHAR2_TABLE_100
800: , p5_a5 JTF_DATE_TABLE

Line 802: , p5_a7 JTF_NUMBER_TABLE

798: , p5_a3 JTF_VARCHAR2_TABLE_200
799: , p5_a4 JTF_VARCHAR2_TABLE_100
800: , p5_a5 JTF_DATE_TABLE
801: , p5_a6 JTF_VARCHAR2_TABLE_100
802: , p5_a7 JTF_NUMBER_TABLE
803: , p5_a8 JTF_NUMBER_TABLE
804: , p5_a9 JTF_DATE_TABLE
805: , p5_a10 JTF_VARCHAR2_TABLE_100
806: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 803: , p5_a8 JTF_NUMBER_TABLE

799: , p5_a4 JTF_VARCHAR2_TABLE_100
800: , p5_a5 JTF_DATE_TABLE
801: , p5_a6 JTF_VARCHAR2_TABLE_100
802: , p5_a7 JTF_NUMBER_TABLE
803: , p5_a8 JTF_NUMBER_TABLE
804: , p5_a9 JTF_DATE_TABLE
805: , p5_a10 JTF_VARCHAR2_TABLE_100
806: , p5_a11 JTF_VARCHAR2_TABLE_500
807: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 821: , p5_a26 JTF_NUMBER_TABLE

817: , p5_a22 JTF_VARCHAR2_TABLE_500
818: , p5_a23 JTF_VARCHAR2_TABLE_500
819: , p5_a24 JTF_VARCHAR2_TABLE_500
820: , p5_a25 JTF_VARCHAR2_TABLE_500
821: , p5_a26 JTF_NUMBER_TABLE
822: , p5_a27 JTF_DATE_TABLE
823: , p5_a28 JTF_NUMBER_TABLE
824: , p5_a29 JTF_DATE_TABLE
825: , p5_a30 JTF_NUMBER_TABLE

Line 823: , p5_a28 JTF_NUMBER_TABLE

819: , p5_a24 JTF_VARCHAR2_TABLE_500
820: , p5_a25 JTF_VARCHAR2_TABLE_500
821: , p5_a26 JTF_NUMBER_TABLE
822: , p5_a27 JTF_DATE_TABLE
823: , p5_a28 JTF_NUMBER_TABLE
824: , p5_a29 JTF_DATE_TABLE
825: , p5_a30 JTF_NUMBER_TABLE
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 825: , p5_a30 JTF_NUMBER_TABLE

821: , p5_a26 JTF_NUMBER_TABLE
822: , p5_a27 JTF_DATE_TABLE
823: , p5_a28 JTF_NUMBER_TABLE
824: , p5_a29 JTF_DATE_TABLE
825: , p5_a30 JTF_NUMBER_TABLE
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 826: , p6_a0 out nocopy JTF_NUMBER_TABLE

822: , p5_a27 JTF_DATE_TABLE
823: , p5_a28 JTF_NUMBER_TABLE
824: , p5_a29 JTF_DATE_TABLE
825: , p5_a30 JTF_NUMBER_TABLE
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 827: , p6_a1 out nocopy JTF_NUMBER_TABLE

823: , p5_a28 JTF_NUMBER_TABLE
824: , p5_a29 JTF_DATE_TABLE
825: , p5_a30 JTF_NUMBER_TABLE
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_DATE_TABLE

Line 833: , p6_a7 out nocopy JTF_NUMBER_TABLE

829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_DATE_TABLE
832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
833: , p6_a7 out nocopy JTF_NUMBER_TABLE
834: , p6_a8 out nocopy JTF_NUMBER_TABLE
835: , p6_a9 out nocopy JTF_DATE_TABLE
836: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
837: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 834: , p6_a8 out nocopy JTF_NUMBER_TABLE

830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_DATE_TABLE
832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
833: , p6_a7 out nocopy JTF_NUMBER_TABLE
834: , p6_a8 out nocopy JTF_NUMBER_TABLE
835: , p6_a9 out nocopy JTF_DATE_TABLE
836: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
837: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
838: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 852: , p6_a26 out nocopy JTF_NUMBER_TABLE

848: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
849: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
850: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
851: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
852: , p6_a26 out nocopy JTF_NUMBER_TABLE
853: , p6_a27 out nocopy JTF_DATE_TABLE
854: , p6_a28 out nocopy JTF_NUMBER_TABLE
855: , p6_a29 out nocopy JTF_DATE_TABLE
856: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 854: , p6_a28 out nocopy JTF_NUMBER_TABLE

850: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
851: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
852: , p6_a26 out nocopy JTF_NUMBER_TABLE
853: , p6_a27 out nocopy JTF_DATE_TABLE
854: , p6_a28 out nocopy JTF_NUMBER_TABLE
855: , p6_a29 out nocopy JTF_DATE_TABLE
856: , p6_a30 out nocopy JTF_NUMBER_TABLE
857: )
858:

Line 856: , p6_a30 out nocopy JTF_NUMBER_TABLE

852: , p6_a26 out nocopy JTF_NUMBER_TABLE
853: , p6_a27 out nocopy JTF_DATE_TABLE
854: , p6_a28 out nocopy JTF_NUMBER_TABLE
855: , p6_a29 out nocopy JTF_DATE_TABLE
856: , p6_a30 out nocopy JTF_NUMBER_TABLE
857: )
858:
859: as
860: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;

Line 1057: , p5_a0 JTF_NUMBER_TABLE

1053: , p_init_msg_list VARCHAR2
1054: , x_return_status out nocopy VARCHAR2
1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_VARCHAR2_TABLE_100
1060: , p5_a3 JTF_VARCHAR2_TABLE_200
1061: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1058: , p5_a1 JTF_NUMBER_TABLE

1054: , x_return_status out nocopy VARCHAR2
1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_VARCHAR2_TABLE_100
1060: , p5_a3 JTF_VARCHAR2_TABLE_200
1061: , p5_a4 JTF_VARCHAR2_TABLE_100
1062: , p5_a5 JTF_DATE_TABLE

Line 1064: , p5_a7 JTF_NUMBER_TABLE

1060: , p5_a3 JTF_VARCHAR2_TABLE_200
1061: , p5_a4 JTF_VARCHAR2_TABLE_100
1062: , p5_a5 JTF_DATE_TABLE
1063: , p5_a6 JTF_VARCHAR2_TABLE_100
1064: , p5_a7 JTF_NUMBER_TABLE
1065: , p5_a8 JTF_NUMBER_TABLE
1066: , p5_a9 JTF_DATE_TABLE
1067: , p5_a10 JTF_VARCHAR2_TABLE_100
1068: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1065: , p5_a8 JTF_NUMBER_TABLE

1061: , p5_a4 JTF_VARCHAR2_TABLE_100
1062: , p5_a5 JTF_DATE_TABLE
1063: , p5_a6 JTF_VARCHAR2_TABLE_100
1064: , p5_a7 JTF_NUMBER_TABLE
1065: , p5_a8 JTF_NUMBER_TABLE
1066: , p5_a9 JTF_DATE_TABLE
1067: , p5_a10 JTF_VARCHAR2_TABLE_100
1068: , p5_a11 JTF_VARCHAR2_TABLE_500
1069: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1083: , p5_a26 JTF_NUMBER_TABLE

1079: , p5_a22 JTF_VARCHAR2_TABLE_500
1080: , p5_a23 JTF_VARCHAR2_TABLE_500
1081: , p5_a24 JTF_VARCHAR2_TABLE_500
1082: , p5_a25 JTF_VARCHAR2_TABLE_500
1083: , p5_a26 JTF_NUMBER_TABLE
1084: , p5_a27 JTF_DATE_TABLE
1085: , p5_a28 JTF_NUMBER_TABLE
1086: , p5_a29 JTF_DATE_TABLE
1087: , p5_a30 JTF_NUMBER_TABLE

Line 1085: , p5_a28 JTF_NUMBER_TABLE

1081: , p5_a24 JTF_VARCHAR2_TABLE_500
1082: , p5_a25 JTF_VARCHAR2_TABLE_500
1083: , p5_a26 JTF_NUMBER_TABLE
1084: , p5_a27 JTF_DATE_TABLE
1085: , p5_a28 JTF_NUMBER_TABLE
1086: , p5_a29 JTF_DATE_TABLE
1087: , p5_a30 JTF_NUMBER_TABLE
1088: )
1089:

Line 1087: , p5_a30 JTF_NUMBER_TABLE

1083: , p5_a26 JTF_NUMBER_TABLE
1084: , p5_a27 JTF_DATE_TABLE
1085: , p5_a28 JTF_NUMBER_TABLE
1086: , p5_a29 JTF_DATE_TABLE
1087: , p5_a30 JTF_NUMBER_TABLE
1088: )
1089:
1090: as
1091: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;

Line 1318: , p5_a0 JTF_NUMBER_TABLE

1314: , p_init_msg_list VARCHAR2
1315: , x_return_status out nocopy VARCHAR2
1316: , x_msg_count out nocopy NUMBER
1317: , x_msg_data out nocopy VARCHAR2
1318: , p5_a0 JTF_NUMBER_TABLE
1319: , p5_a1 JTF_NUMBER_TABLE
1320: , p5_a2 JTF_VARCHAR2_TABLE_100
1321: , p5_a3 JTF_VARCHAR2_TABLE_200
1322: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1319: , p5_a1 JTF_NUMBER_TABLE

1315: , x_return_status out nocopy VARCHAR2
1316: , x_msg_count out nocopy NUMBER
1317: , x_msg_data out nocopy VARCHAR2
1318: , p5_a0 JTF_NUMBER_TABLE
1319: , p5_a1 JTF_NUMBER_TABLE
1320: , p5_a2 JTF_VARCHAR2_TABLE_100
1321: , p5_a3 JTF_VARCHAR2_TABLE_200
1322: , p5_a4 JTF_VARCHAR2_TABLE_100
1323: , p5_a5 JTF_DATE_TABLE

Line 1325: , p5_a7 JTF_NUMBER_TABLE

1321: , p5_a3 JTF_VARCHAR2_TABLE_200
1322: , p5_a4 JTF_VARCHAR2_TABLE_100
1323: , p5_a5 JTF_DATE_TABLE
1324: , p5_a6 JTF_VARCHAR2_TABLE_100
1325: , p5_a7 JTF_NUMBER_TABLE
1326: , p5_a8 JTF_NUMBER_TABLE
1327: , p5_a9 JTF_DATE_TABLE
1328: , p5_a10 JTF_VARCHAR2_TABLE_100
1329: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1326: , p5_a8 JTF_NUMBER_TABLE

1322: , p5_a4 JTF_VARCHAR2_TABLE_100
1323: , p5_a5 JTF_DATE_TABLE
1324: , p5_a6 JTF_VARCHAR2_TABLE_100
1325: , p5_a7 JTF_NUMBER_TABLE
1326: , p5_a8 JTF_NUMBER_TABLE
1327: , p5_a9 JTF_DATE_TABLE
1328: , p5_a10 JTF_VARCHAR2_TABLE_100
1329: , p5_a11 JTF_VARCHAR2_TABLE_500
1330: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1344: , p5_a26 JTF_NUMBER_TABLE

1340: , p5_a22 JTF_VARCHAR2_TABLE_500
1341: , p5_a23 JTF_VARCHAR2_TABLE_500
1342: , p5_a24 JTF_VARCHAR2_TABLE_500
1343: , p5_a25 JTF_VARCHAR2_TABLE_500
1344: , p5_a26 JTF_NUMBER_TABLE
1345: , p5_a27 JTF_DATE_TABLE
1346: , p5_a28 JTF_NUMBER_TABLE
1347: , p5_a29 JTF_DATE_TABLE
1348: , p5_a30 JTF_NUMBER_TABLE

Line 1346: , p5_a28 JTF_NUMBER_TABLE

1342: , p5_a24 JTF_VARCHAR2_TABLE_500
1343: , p5_a25 JTF_VARCHAR2_TABLE_500
1344: , p5_a26 JTF_NUMBER_TABLE
1345: , p5_a27 JTF_DATE_TABLE
1346: , p5_a28 JTF_NUMBER_TABLE
1347: , p5_a29 JTF_DATE_TABLE
1348: , p5_a30 JTF_NUMBER_TABLE
1349: , p6_a0 out nocopy JTF_NUMBER_TABLE
1350: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 1348: , p5_a30 JTF_NUMBER_TABLE

1344: , p5_a26 JTF_NUMBER_TABLE
1345: , p5_a27 JTF_DATE_TABLE
1346: , p5_a28 JTF_NUMBER_TABLE
1347: , p5_a29 JTF_DATE_TABLE
1348: , p5_a30 JTF_NUMBER_TABLE
1349: , p6_a0 out nocopy JTF_NUMBER_TABLE
1350: , p6_a1 out nocopy JTF_NUMBER_TABLE
1351: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1352: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 1349: , p6_a0 out nocopy JTF_NUMBER_TABLE

1345: , p5_a27 JTF_DATE_TABLE
1346: , p5_a28 JTF_NUMBER_TABLE
1347: , p5_a29 JTF_DATE_TABLE
1348: , p5_a30 JTF_NUMBER_TABLE
1349: , p6_a0 out nocopy JTF_NUMBER_TABLE
1350: , p6_a1 out nocopy JTF_NUMBER_TABLE
1351: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1352: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1353: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1350: , p6_a1 out nocopy JTF_NUMBER_TABLE

1346: , p5_a28 JTF_NUMBER_TABLE
1347: , p5_a29 JTF_DATE_TABLE
1348: , p5_a30 JTF_NUMBER_TABLE
1349: , p6_a0 out nocopy JTF_NUMBER_TABLE
1350: , p6_a1 out nocopy JTF_NUMBER_TABLE
1351: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1352: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1353: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1354: , p6_a5 out nocopy JTF_DATE_TABLE

Line 1356: , p6_a7 out nocopy JTF_NUMBER_TABLE

1352: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1353: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1354: , p6_a5 out nocopy JTF_DATE_TABLE
1355: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1356: , p6_a7 out nocopy JTF_NUMBER_TABLE
1357: , p6_a8 out nocopy JTF_NUMBER_TABLE
1358: , p6_a9 out nocopy JTF_DATE_TABLE
1359: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1360: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 1357: , p6_a8 out nocopy JTF_NUMBER_TABLE

1353: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1354: , p6_a5 out nocopy JTF_DATE_TABLE
1355: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1356: , p6_a7 out nocopy JTF_NUMBER_TABLE
1357: , p6_a8 out nocopy JTF_NUMBER_TABLE
1358: , p6_a9 out nocopy JTF_DATE_TABLE
1359: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1360: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1361: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 1375: , p6_a26 out nocopy JTF_NUMBER_TABLE

1371: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1372: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1373: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1374: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1375: , p6_a26 out nocopy JTF_NUMBER_TABLE
1376: , p6_a27 out nocopy JTF_DATE_TABLE
1377: , p6_a28 out nocopy JTF_NUMBER_TABLE
1378: , p6_a29 out nocopy JTF_DATE_TABLE
1379: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 1377: , p6_a28 out nocopy JTF_NUMBER_TABLE

1373: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1374: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1375: , p6_a26 out nocopy JTF_NUMBER_TABLE
1376: , p6_a27 out nocopy JTF_DATE_TABLE
1377: , p6_a28 out nocopy JTF_NUMBER_TABLE
1378: , p6_a29 out nocopy JTF_DATE_TABLE
1379: , p6_a30 out nocopy JTF_NUMBER_TABLE
1380: )
1381:

Line 1379: , p6_a30 out nocopy JTF_NUMBER_TABLE

1375: , p6_a26 out nocopy JTF_NUMBER_TABLE
1376: , p6_a27 out nocopy JTF_DATE_TABLE
1377: , p6_a28 out nocopy JTF_NUMBER_TABLE
1378: , p6_a29 out nocopy JTF_DATE_TABLE
1379: , p6_a30 out nocopy JTF_NUMBER_TABLE
1380: )
1381:
1382: as
1383: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;

Line 1580: , p5_a0 JTF_NUMBER_TABLE

1576: , p_init_msg_list VARCHAR2
1577: , x_return_status out nocopy VARCHAR2
1578: , x_msg_count out nocopy NUMBER
1579: , x_msg_data out nocopy VARCHAR2
1580: , p5_a0 JTF_NUMBER_TABLE
1581: , p5_a1 JTF_NUMBER_TABLE
1582: , p5_a2 JTF_VARCHAR2_TABLE_100
1583: , p5_a3 JTF_VARCHAR2_TABLE_200
1584: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1581: , p5_a1 JTF_NUMBER_TABLE

1577: , x_return_status out nocopy VARCHAR2
1578: , x_msg_count out nocopy NUMBER
1579: , x_msg_data out nocopy VARCHAR2
1580: , p5_a0 JTF_NUMBER_TABLE
1581: , p5_a1 JTF_NUMBER_TABLE
1582: , p5_a2 JTF_VARCHAR2_TABLE_100
1583: , p5_a3 JTF_VARCHAR2_TABLE_200
1584: , p5_a4 JTF_VARCHAR2_TABLE_100
1585: , p5_a5 JTF_DATE_TABLE

Line 1587: , p5_a7 JTF_NUMBER_TABLE

1583: , p5_a3 JTF_VARCHAR2_TABLE_200
1584: , p5_a4 JTF_VARCHAR2_TABLE_100
1585: , p5_a5 JTF_DATE_TABLE
1586: , p5_a6 JTF_VARCHAR2_TABLE_100
1587: , p5_a7 JTF_NUMBER_TABLE
1588: , p5_a8 JTF_NUMBER_TABLE
1589: , p5_a9 JTF_DATE_TABLE
1590: , p5_a10 JTF_VARCHAR2_TABLE_100
1591: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1588: , p5_a8 JTF_NUMBER_TABLE

1584: , p5_a4 JTF_VARCHAR2_TABLE_100
1585: , p5_a5 JTF_DATE_TABLE
1586: , p5_a6 JTF_VARCHAR2_TABLE_100
1587: , p5_a7 JTF_NUMBER_TABLE
1588: , p5_a8 JTF_NUMBER_TABLE
1589: , p5_a9 JTF_DATE_TABLE
1590: , p5_a10 JTF_VARCHAR2_TABLE_100
1591: , p5_a11 JTF_VARCHAR2_TABLE_500
1592: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1606: , p5_a26 JTF_NUMBER_TABLE

1602: , p5_a22 JTF_VARCHAR2_TABLE_500
1603: , p5_a23 JTF_VARCHAR2_TABLE_500
1604: , p5_a24 JTF_VARCHAR2_TABLE_500
1605: , p5_a25 JTF_VARCHAR2_TABLE_500
1606: , p5_a26 JTF_NUMBER_TABLE
1607: , p5_a27 JTF_DATE_TABLE
1608: , p5_a28 JTF_NUMBER_TABLE
1609: , p5_a29 JTF_DATE_TABLE
1610: , p5_a30 JTF_NUMBER_TABLE

Line 1608: , p5_a28 JTF_NUMBER_TABLE

1604: , p5_a24 JTF_VARCHAR2_TABLE_500
1605: , p5_a25 JTF_VARCHAR2_TABLE_500
1606: , p5_a26 JTF_NUMBER_TABLE
1607: , p5_a27 JTF_DATE_TABLE
1608: , p5_a28 JTF_NUMBER_TABLE
1609: , p5_a29 JTF_DATE_TABLE
1610: , p5_a30 JTF_NUMBER_TABLE
1611: )
1612:

Line 1610: , p5_a30 JTF_NUMBER_TABLE

1606: , p5_a26 JTF_NUMBER_TABLE
1607: , p5_a27 JTF_DATE_TABLE
1608: , p5_a28 JTF_NUMBER_TABLE
1609: , p5_a29 JTF_DATE_TABLE
1610: , p5_a30 JTF_NUMBER_TABLE
1611: )
1612:
1613: as
1614: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;

Line 1775: , p5_a0 JTF_NUMBER_TABLE

1771: , p_init_msg_list VARCHAR2
1772: , x_return_status out nocopy VARCHAR2
1773: , x_msg_count out nocopy NUMBER
1774: , x_msg_data out nocopy VARCHAR2
1775: , p5_a0 JTF_NUMBER_TABLE
1776: , p5_a1 JTF_NUMBER_TABLE
1777: , p5_a2 JTF_VARCHAR2_TABLE_100
1778: , p5_a3 JTF_VARCHAR2_TABLE_200
1779: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1776: , p5_a1 JTF_NUMBER_TABLE

1772: , x_return_status out nocopy VARCHAR2
1773: , x_msg_count out nocopy NUMBER
1774: , x_msg_data out nocopy VARCHAR2
1775: , p5_a0 JTF_NUMBER_TABLE
1776: , p5_a1 JTF_NUMBER_TABLE
1777: , p5_a2 JTF_VARCHAR2_TABLE_100
1778: , p5_a3 JTF_VARCHAR2_TABLE_200
1779: , p5_a4 JTF_VARCHAR2_TABLE_100
1780: , p5_a5 JTF_DATE_TABLE

Line 1782: , p5_a7 JTF_NUMBER_TABLE

1778: , p5_a3 JTF_VARCHAR2_TABLE_200
1779: , p5_a4 JTF_VARCHAR2_TABLE_100
1780: , p5_a5 JTF_DATE_TABLE
1781: , p5_a6 JTF_VARCHAR2_TABLE_100
1782: , p5_a7 JTF_NUMBER_TABLE
1783: , p5_a8 JTF_NUMBER_TABLE
1784: , p5_a9 JTF_DATE_TABLE
1785: , p5_a10 JTF_VARCHAR2_TABLE_100
1786: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1783: , p5_a8 JTF_NUMBER_TABLE

1779: , p5_a4 JTF_VARCHAR2_TABLE_100
1780: , p5_a5 JTF_DATE_TABLE
1781: , p5_a6 JTF_VARCHAR2_TABLE_100
1782: , p5_a7 JTF_NUMBER_TABLE
1783: , p5_a8 JTF_NUMBER_TABLE
1784: , p5_a9 JTF_DATE_TABLE
1785: , p5_a10 JTF_VARCHAR2_TABLE_100
1786: , p5_a11 JTF_VARCHAR2_TABLE_500
1787: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1801: , p5_a26 JTF_NUMBER_TABLE

1797: , p5_a22 JTF_VARCHAR2_TABLE_500
1798: , p5_a23 JTF_VARCHAR2_TABLE_500
1799: , p5_a24 JTF_VARCHAR2_TABLE_500
1800: , p5_a25 JTF_VARCHAR2_TABLE_500
1801: , p5_a26 JTF_NUMBER_TABLE
1802: , p5_a27 JTF_DATE_TABLE
1803: , p5_a28 JTF_NUMBER_TABLE
1804: , p5_a29 JTF_DATE_TABLE
1805: , p5_a30 JTF_NUMBER_TABLE

Line 1803: , p5_a28 JTF_NUMBER_TABLE

1799: , p5_a24 JTF_VARCHAR2_TABLE_500
1800: , p5_a25 JTF_VARCHAR2_TABLE_500
1801: , p5_a26 JTF_NUMBER_TABLE
1802: , p5_a27 JTF_DATE_TABLE
1803: , p5_a28 JTF_NUMBER_TABLE
1804: , p5_a29 JTF_DATE_TABLE
1805: , p5_a30 JTF_NUMBER_TABLE
1806: )
1807:

Line 1805: , p5_a30 JTF_NUMBER_TABLE

1801: , p5_a26 JTF_NUMBER_TABLE
1802: , p5_a27 JTF_DATE_TABLE
1803: , p5_a28 JTF_NUMBER_TABLE
1804: , p5_a29 JTF_DATE_TABLE
1805: , p5_a30 JTF_NUMBER_TABLE
1806: )
1807:
1808: as
1809: ddp_sibv_tbl okl_sib_pvt.sibv_tbl_type;