APPS.OKL_FMA_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_fma_pvt.fma_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_fma_pvt.fma_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 24: , a2 JTF_NUMBER_TABLE

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

Line 26: , a4 JTF_NUMBER_TABLE

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

Line 30: , a8 JTF_NUMBER_TABLE

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

Line 49: , a27 JTF_NUMBER_TABLE

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

Line 51: , a29 JTF_NUMBER_TABLE

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

Line 53: , a31 JTF_NUMBER_TABLE

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

Line 103: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_200
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE

Line 105: , a2 out nocopy JTF_NUMBER_TABLE

101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_200
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 107: , a4 out nocopy JTF_NUMBER_TABLE

103: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_200
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a8 out nocopy JTF_NUMBER_TABLE

Line 111: , a8 out nocopy JTF_NUMBER_TABLE

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

Line 130: , a27 out nocopy JTF_NUMBER_TABLE

126: , a23 out nocopy JTF_VARCHAR2_TABLE_500
127: , a24 out nocopy JTF_VARCHAR2_TABLE_500
128: , a25 out nocopy JTF_VARCHAR2_TABLE_500
129: , a26 out nocopy JTF_VARCHAR2_TABLE_500
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE

Line 132: , a29 out nocopy JTF_NUMBER_TABLE

128: , a25 out nocopy JTF_VARCHAR2_TABLE_500
129: , a26 out nocopy JTF_VARCHAR2_TABLE_500
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
135: ) as
136: ddindx binary_integer; indx binary_integer;

Line 134: , a31 out nocopy JTF_NUMBER_TABLE

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

Line 139: a0 := JTF_NUMBER_TABLE();

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

Line 141: a2 := JTF_NUMBER_TABLE();

137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_VARCHAR2_TABLE_200();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();

Line 143: a4 := JTF_NUMBER_TABLE();

139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_VARCHAR2_TABLE_200();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_2000();
147: a8 := JTF_NUMBER_TABLE();

Line 147: a8 := JTF_NUMBER_TABLE();

143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_VARCHAR2_TABLE_100();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_2000();
147: a8 := JTF_NUMBER_TABLE();
148: a9 := JTF_DATE_TABLE();
149: a10 := JTF_VARCHAR2_TABLE_100();
150: a11 := JTF_DATE_TABLE();
151: a12 := JTF_VARCHAR2_TABLE_500();

Line 166: a27 := JTF_NUMBER_TABLE();

162: a23 := JTF_VARCHAR2_TABLE_500();
163: a24 := JTF_VARCHAR2_TABLE_500();
164: a25 := JTF_VARCHAR2_TABLE_500();
165: a26 := JTF_VARCHAR2_TABLE_500();
166: a27 := JTF_NUMBER_TABLE();
167: a28 := JTF_DATE_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();

Line 168: a29 := JTF_NUMBER_TABLE();

164: a25 := JTF_VARCHAR2_TABLE_500();
165: a26 := JTF_VARCHAR2_TABLE_500();
166: a27 := JTF_NUMBER_TABLE();
167: a28 := JTF_DATE_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();

Line 170: a31 := JTF_NUMBER_TABLE();

166: a27 := JTF_NUMBER_TABLE();
167: a28 := JTF_DATE_TABLE();
168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_VARCHAR2_TABLE_200();
174: a2 := JTF_NUMBER_TABLE();

Line 172: a0 := JTF_NUMBER_TABLE();

168: a29 := JTF_NUMBER_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_VARCHAR2_TABLE_200();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();

Line 174: a2 := JTF_NUMBER_TABLE();

170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_VARCHAR2_TABLE_200();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();

Line 176: a4 := JTF_NUMBER_TABLE();

172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_VARCHAR2_TABLE_200();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_2000();
180: a8 := JTF_NUMBER_TABLE();

Line 180: a8 := JTF_NUMBER_TABLE();

176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_VARCHAR2_TABLE_100();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_2000();
180: a8 := JTF_NUMBER_TABLE();
181: a9 := JTF_DATE_TABLE();
182: a10 := JTF_VARCHAR2_TABLE_100();
183: a11 := JTF_DATE_TABLE();
184: a12 := JTF_VARCHAR2_TABLE_500();

Line 199: a27 := JTF_NUMBER_TABLE();

195: a23 := JTF_VARCHAR2_TABLE_500();
196: a24 := JTF_VARCHAR2_TABLE_500();
197: a25 := JTF_VARCHAR2_TABLE_500();
198: a26 := JTF_VARCHAR2_TABLE_500();
199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_DATE_TABLE();
201: a29 := JTF_NUMBER_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();

Line 201: a29 := JTF_NUMBER_TABLE();

197: a25 := JTF_VARCHAR2_TABLE_500();
198: a26 := JTF_VARCHAR2_TABLE_500();
199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_DATE_TABLE();
201: a29 := JTF_NUMBER_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);

Line 203: a31 := JTF_NUMBER_TABLE();

199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_DATE_TABLE();
201: a29 := JTF_NUMBER_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);
206: a1.extend(t.count);
207: a2.extend(t.count);

Line 282: procedure rosetta_table_copy_in_p5(t out nocopy okl_fma_pvt.okl_formulae_tl_tbl_type, a0 JTF_NUMBER_TABLE

278: end if;
279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_fma_pvt.okl_formulae_tl_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_VARCHAR2_TABLE_100
284: , a2 JTF_VARCHAR2_TABLE_100
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_VARCHAR2_TABLE_2000

Line 287: , a5 JTF_NUMBER_TABLE

283: , a1 JTF_VARCHAR2_TABLE_100
284: , a2 JTF_VARCHAR2_TABLE_100
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_VARCHAR2_TABLE_2000
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_NUMBER_TABLE
290: , a8 JTF_DATE_TABLE
291: , a9 JTF_NUMBER_TABLE

Line 289: , a7 JTF_NUMBER_TABLE

285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_VARCHAR2_TABLE_2000
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_NUMBER_TABLE
290: , a8 JTF_DATE_TABLE
291: , a9 JTF_NUMBER_TABLE
292: ) as
293: ddindx binary_integer; indx binary_integer;

Line 291: , a9 JTF_NUMBER_TABLE

287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_NUMBER_TABLE
290: , a8 JTF_DATE_TABLE
291: , a9 JTF_NUMBER_TABLE
292: ) as
293: ddindx binary_integer; indx binary_integer;
294: begin
295: if a0 is not null and a0.count > 0 then

Line 319: procedure rosetta_table_copy_out_p5(t okl_fma_pvt.okl_formulae_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

315: end loop;
316: end if;
317: end if;
318: end rosetta_table_copy_in_p5;
319: procedure rosetta_table_copy_out_p5(t okl_fma_pvt.okl_formulae_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
320: , a1 out nocopy JTF_VARCHAR2_TABLE_100
321: , a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , a3 out nocopy JTF_VARCHAR2_TABLE_100
323: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 324: , a5 out nocopy JTF_NUMBER_TABLE

320: , a1 out nocopy JTF_VARCHAR2_TABLE_100
321: , a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , a3 out nocopy JTF_VARCHAR2_TABLE_100
323: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
324: , a5 out nocopy JTF_NUMBER_TABLE
325: , a6 out nocopy JTF_DATE_TABLE
326: , a7 out nocopy JTF_NUMBER_TABLE
327: , a8 out nocopy JTF_DATE_TABLE
328: , a9 out nocopy JTF_NUMBER_TABLE

Line 326: , a7 out nocopy JTF_NUMBER_TABLE

322: , a3 out nocopy JTF_VARCHAR2_TABLE_100
323: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
324: , a5 out nocopy JTF_NUMBER_TABLE
325: , a6 out nocopy JTF_DATE_TABLE
326: , a7 out nocopy JTF_NUMBER_TABLE
327: , a8 out nocopy JTF_DATE_TABLE
328: , a9 out nocopy JTF_NUMBER_TABLE
329: ) as
330: ddindx binary_integer; indx binary_integer;

Line 328: , a9 out nocopy JTF_NUMBER_TABLE

324: , a5 out nocopy JTF_NUMBER_TABLE
325: , a6 out nocopy JTF_DATE_TABLE
326: , a7 out nocopy JTF_NUMBER_TABLE
327: , a8 out nocopy JTF_DATE_TABLE
328: , a9 out nocopy JTF_NUMBER_TABLE
329: ) as
330: ddindx binary_integer; indx binary_integer;
331: begin
332: if t is null or t.count = 0 then

Line 333: a0 := JTF_NUMBER_TABLE();

329: ) as
330: ddindx binary_integer; indx binary_integer;
331: begin
332: if t is null or t.count = 0 then
333: a0 := JTF_NUMBER_TABLE();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_VARCHAR2_TABLE_100();
336: a3 := JTF_VARCHAR2_TABLE_100();
337: a4 := JTF_VARCHAR2_TABLE_2000();

Line 338: a5 := JTF_NUMBER_TABLE();

334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_VARCHAR2_TABLE_100();
336: a3 := JTF_VARCHAR2_TABLE_100();
337: a4 := JTF_VARCHAR2_TABLE_2000();
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_DATE_TABLE();
340: a7 := JTF_NUMBER_TABLE();
341: a8 := JTF_DATE_TABLE();
342: a9 := JTF_NUMBER_TABLE();

Line 340: a7 := JTF_NUMBER_TABLE();

336: a3 := JTF_VARCHAR2_TABLE_100();
337: a4 := JTF_VARCHAR2_TABLE_2000();
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_DATE_TABLE();
340: a7 := JTF_NUMBER_TABLE();
341: a8 := JTF_DATE_TABLE();
342: a9 := JTF_NUMBER_TABLE();
343: else
344: a0 := JTF_NUMBER_TABLE();

Line 342: a9 := JTF_NUMBER_TABLE();

338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_DATE_TABLE();
340: a7 := JTF_NUMBER_TABLE();
341: a8 := JTF_DATE_TABLE();
342: a9 := JTF_NUMBER_TABLE();
343: else
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_VARCHAR2_TABLE_100();

Line 344: a0 := JTF_NUMBER_TABLE();

340: a7 := JTF_NUMBER_TABLE();
341: a8 := JTF_DATE_TABLE();
342: a9 := JTF_NUMBER_TABLE();
343: else
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_VARCHAR2_TABLE_100();
347: a3 := JTF_VARCHAR2_TABLE_100();
348: a4 := JTF_VARCHAR2_TABLE_2000();

Line 349: a5 := JTF_NUMBER_TABLE();

345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_VARCHAR2_TABLE_100();
347: a3 := JTF_VARCHAR2_TABLE_100();
348: a4 := JTF_VARCHAR2_TABLE_2000();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_DATE_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_DATE_TABLE();
353: a9 := JTF_NUMBER_TABLE();

Line 351: a7 := JTF_NUMBER_TABLE();

347: a3 := JTF_VARCHAR2_TABLE_100();
348: a4 := JTF_VARCHAR2_TABLE_2000();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_DATE_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_DATE_TABLE();
353: a9 := JTF_NUMBER_TABLE();
354: if t.count > 0 then
355: a0.extend(t.count);

Line 353: a9 := JTF_NUMBER_TABLE();

349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_DATE_TABLE();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_DATE_TABLE();
353: a9 := JTF_NUMBER_TABLE();
354: if t.count > 0 then
355: a0.extend(t.count);
356: a1.extend(t.count);
357: a2.extend(t.count);

Line 388: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE

384: end if;
385: end if;
386: end rosetta_table_copy_out_p5;
387:
388: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
389: , a1 JTF_NUMBER_TABLE
390: , a2 JTF_VARCHAR2_TABLE_100
391: , a3 JTF_NUMBER_TABLE
392: , a4 JTF_VARCHAR2_TABLE_100

Line 389: , a1 JTF_NUMBER_TABLE

385: end if;
386: end rosetta_table_copy_out_p5;
387:
388: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
389: , a1 JTF_NUMBER_TABLE
390: , a2 JTF_VARCHAR2_TABLE_100
391: , a3 JTF_NUMBER_TABLE
392: , a4 JTF_VARCHAR2_TABLE_100
393: , a5 JTF_VARCHAR2_TABLE_200

Line 391: , a3 JTF_NUMBER_TABLE

387:
388: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
389: , a1 JTF_NUMBER_TABLE
390: , a2 JTF_VARCHAR2_TABLE_100
391: , a3 JTF_NUMBER_TABLE
392: , a4 JTF_VARCHAR2_TABLE_100
393: , a5 JTF_VARCHAR2_TABLE_200
394: , a6 JTF_VARCHAR2_TABLE_2000
395: , a7 JTF_VARCHAR2_TABLE_2000

Line 415: , a27 JTF_NUMBER_TABLE

411: , a23 JTF_VARCHAR2_TABLE_500
412: , a24 JTF_VARCHAR2_TABLE_500
413: , a25 JTF_VARCHAR2_TABLE_500
414: , a26 JTF_VARCHAR2_TABLE_500
415: , a27 JTF_NUMBER_TABLE
416: , a28 JTF_VARCHAR2_TABLE_100
417: , a29 JTF_NUMBER_TABLE
418: , a30 JTF_DATE_TABLE
419: , a31 JTF_NUMBER_TABLE

Line 417: , a29 JTF_NUMBER_TABLE

413: , a25 JTF_VARCHAR2_TABLE_500
414: , a26 JTF_VARCHAR2_TABLE_500
415: , a27 JTF_NUMBER_TABLE
416: , a28 JTF_VARCHAR2_TABLE_100
417: , a29 JTF_NUMBER_TABLE
418: , a30 JTF_DATE_TABLE
419: , a31 JTF_NUMBER_TABLE
420: , a32 JTF_DATE_TABLE
421: , a33 JTF_NUMBER_TABLE

Line 419: , a31 JTF_NUMBER_TABLE

415: , a27 JTF_NUMBER_TABLE
416: , a28 JTF_VARCHAR2_TABLE_100
417: , a29 JTF_NUMBER_TABLE
418: , a30 JTF_DATE_TABLE
419: , a31 JTF_NUMBER_TABLE
420: , a32 JTF_DATE_TABLE
421: , a33 JTF_NUMBER_TABLE
422: ) as
423: ddindx binary_integer; indx binary_integer;

Line 421: , a33 JTF_NUMBER_TABLE

417: , a29 JTF_NUMBER_TABLE
418: , a30 JTF_DATE_TABLE
419: , a31 JTF_NUMBER_TABLE
420: , a32 JTF_DATE_TABLE
421: , a33 JTF_NUMBER_TABLE
422: ) as
423: ddindx binary_integer; indx binary_integer;
424: begin
425: if a0 is not null and a0.count > 0 then

Line 473: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

469: end loop;
470: end if;
471: end if;
472: end rosetta_table_copy_in_p8;
473: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
474: , a1 out nocopy JTF_NUMBER_TABLE
475: , a2 out nocopy JTF_VARCHAR2_TABLE_100
476: , a3 out nocopy JTF_NUMBER_TABLE
477: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 474: , a1 out nocopy JTF_NUMBER_TABLE

470: end if;
471: end if;
472: end rosetta_table_copy_in_p8;
473: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
474: , a1 out nocopy JTF_NUMBER_TABLE
475: , a2 out nocopy JTF_VARCHAR2_TABLE_100
476: , a3 out nocopy JTF_NUMBER_TABLE
477: , a4 out nocopy JTF_VARCHAR2_TABLE_100
478: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 476: , a3 out nocopy JTF_NUMBER_TABLE

472: end rosetta_table_copy_in_p8;
473: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
474: , a1 out nocopy JTF_NUMBER_TABLE
475: , a2 out nocopy JTF_VARCHAR2_TABLE_100
476: , a3 out nocopy JTF_NUMBER_TABLE
477: , a4 out nocopy JTF_VARCHAR2_TABLE_100
478: , a5 out nocopy JTF_VARCHAR2_TABLE_200
479: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
480: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 500: , a27 out nocopy JTF_NUMBER_TABLE

496: , a23 out nocopy JTF_VARCHAR2_TABLE_500
497: , a24 out nocopy JTF_VARCHAR2_TABLE_500
498: , a25 out nocopy JTF_VARCHAR2_TABLE_500
499: , a26 out nocopy JTF_VARCHAR2_TABLE_500
500: , a27 out nocopy JTF_NUMBER_TABLE
501: , a28 out nocopy JTF_VARCHAR2_TABLE_100
502: , a29 out nocopy JTF_NUMBER_TABLE
503: , a30 out nocopy JTF_DATE_TABLE
504: , a31 out nocopy JTF_NUMBER_TABLE

Line 502: , a29 out nocopy JTF_NUMBER_TABLE

498: , a25 out nocopy JTF_VARCHAR2_TABLE_500
499: , a26 out nocopy JTF_VARCHAR2_TABLE_500
500: , a27 out nocopy JTF_NUMBER_TABLE
501: , a28 out nocopy JTF_VARCHAR2_TABLE_100
502: , a29 out nocopy JTF_NUMBER_TABLE
503: , a30 out nocopy JTF_DATE_TABLE
504: , a31 out nocopy JTF_NUMBER_TABLE
505: , a32 out nocopy JTF_DATE_TABLE
506: , a33 out nocopy JTF_NUMBER_TABLE

Line 504: , a31 out nocopy JTF_NUMBER_TABLE

500: , a27 out nocopy JTF_NUMBER_TABLE
501: , a28 out nocopy JTF_VARCHAR2_TABLE_100
502: , a29 out nocopy JTF_NUMBER_TABLE
503: , a30 out nocopy JTF_DATE_TABLE
504: , a31 out nocopy JTF_NUMBER_TABLE
505: , a32 out nocopy JTF_DATE_TABLE
506: , a33 out nocopy JTF_NUMBER_TABLE
507: ) as
508: ddindx binary_integer; indx binary_integer;

Line 506: , a33 out nocopy JTF_NUMBER_TABLE

502: , a29 out nocopy JTF_NUMBER_TABLE
503: , a30 out nocopy JTF_DATE_TABLE
504: , a31 out nocopy JTF_NUMBER_TABLE
505: , a32 out nocopy JTF_DATE_TABLE
506: , a33 out nocopy JTF_NUMBER_TABLE
507: ) as
508: ddindx binary_integer; indx binary_integer;
509: begin
510: if t is null or t.count = 0 then

Line 511: a0 := JTF_NUMBER_TABLE();

507: ) as
508: ddindx binary_integer; indx binary_integer;
509: begin
510: if t is null or t.count = 0 then
511: a0 := JTF_NUMBER_TABLE();
512: a1 := JTF_NUMBER_TABLE();
513: a2 := JTF_VARCHAR2_TABLE_100();
514: a3 := JTF_NUMBER_TABLE();
515: a4 := JTF_VARCHAR2_TABLE_100();

Line 512: a1 := JTF_NUMBER_TABLE();

508: ddindx binary_integer; indx binary_integer;
509: begin
510: if t is null or t.count = 0 then
511: a0 := JTF_NUMBER_TABLE();
512: a1 := JTF_NUMBER_TABLE();
513: a2 := JTF_VARCHAR2_TABLE_100();
514: a3 := JTF_NUMBER_TABLE();
515: a4 := JTF_VARCHAR2_TABLE_100();
516: a5 := JTF_VARCHAR2_TABLE_200();

Line 514: a3 := JTF_NUMBER_TABLE();

510: if t is null or t.count = 0 then
511: a0 := JTF_NUMBER_TABLE();
512: a1 := JTF_NUMBER_TABLE();
513: a2 := JTF_VARCHAR2_TABLE_100();
514: a3 := JTF_NUMBER_TABLE();
515: a4 := JTF_VARCHAR2_TABLE_100();
516: a5 := JTF_VARCHAR2_TABLE_200();
517: a6 := JTF_VARCHAR2_TABLE_2000();
518: a7 := JTF_VARCHAR2_TABLE_2000();

Line 538: a27 := JTF_NUMBER_TABLE();

534: a23 := JTF_VARCHAR2_TABLE_500();
535: a24 := JTF_VARCHAR2_TABLE_500();
536: a25 := JTF_VARCHAR2_TABLE_500();
537: a26 := JTF_VARCHAR2_TABLE_500();
538: a27 := JTF_NUMBER_TABLE();
539: a28 := JTF_VARCHAR2_TABLE_100();
540: a29 := JTF_NUMBER_TABLE();
541: a30 := JTF_DATE_TABLE();
542: a31 := JTF_NUMBER_TABLE();

Line 540: a29 := JTF_NUMBER_TABLE();

536: a25 := JTF_VARCHAR2_TABLE_500();
537: a26 := JTF_VARCHAR2_TABLE_500();
538: a27 := JTF_NUMBER_TABLE();
539: a28 := JTF_VARCHAR2_TABLE_100();
540: a29 := JTF_NUMBER_TABLE();
541: a30 := JTF_DATE_TABLE();
542: a31 := JTF_NUMBER_TABLE();
543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();

Line 542: a31 := JTF_NUMBER_TABLE();

538: a27 := JTF_NUMBER_TABLE();
539: a28 := JTF_VARCHAR2_TABLE_100();
540: a29 := JTF_NUMBER_TABLE();
541: a30 := JTF_DATE_TABLE();
542: a31 := JTF_NUMBER_TABLE();
543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();
545: else
546: a0 := JTF_NUMBER_TABLE();

Line 544: a33 := JTF_NUMBER_TABLE();

540: a29 := JTF_NUMBER_TABLE();
541: a30 := JTF_DATE_TABLE();
542: a31 := JTF_NUMBER_TABLE();
543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_VARCHAR2_TABLE_100();

Line 546: a0 := JTF_NUMBER_TABLE();

542: a31 := JTF_NUMBER_TABLE();
543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_VARCHAR2_TABLE_100();

Line 547: a1 := JTF_NUMBER_TABLE();

543: a32 := JTF_DATE_TABLE();
544: a33 := JTF_NUMBER_TABLE();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_VARCHAR2_TABLE_100();
551: a5 := JTF_VARCHAR2_TABLE_200();

Line 549: a3 := JTF_NUMBER_TABLE();

545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_VARCHAR2_TABLE_100();
551: a5 := JTF_VARCHAR2_TABLE_200();
552: a6 := JTF_VARCHAR2_TABLE_2000();
553: a7 := JTF_VARCHAR2_TABLE_2000();

Line 573: a27 := JTF_NUMBER_TABLE();

569: a23 := JTF_VARCHAR2_TABLE_500();
570: a24 := JTF_VARCHAR2_TABLE_500();
571: a25 := JTF_VARCHAR2_TABLE_500();
572: a26 := JTF_VARCHAR2_TABLE_500();
573: a27 := JTF_NUMBER_TABLE();
574: a28 := JTF_VARCHAR2_TABLE_100();
575: a29 := JTF_NUMBER_TABLE();
576: a30 := JTF_DATE_TABLE();
577: a31 := JTF_NUMBER_TABLE();

Line 575: a29 := JTF_NUMBER_TABLE();

571: a25 := JTF_VARCHAR2_TABLE_500();
572: a26 := JTF_VARCHAR2_TABLE_500();
573: a27 := JTF_NUMBER_TABLE();
574: a28 := JTF_VARCHAR2_TABLE_100();
575: a29 := JTF_NUMBER_TABLE();
576: a30 := JTF_DATE_TABLE();
577: a31 := JTF_NUMBER_TABLE();
578: a32 := JTF_DATE_TABLE();
579: a33 := JTF_NUMBER_TABLE();

Line 577: a31 := JTF_NUMBER_TABLE();

573: a27 := JTF_NUMBER_TABLE();
574: a28 := JTF_VARCHAR2_TABLE_100();
575: a29 := JTF_NUMBER_TABLE();
576: a30 := JTF_DATE_TABLE();
577: a31 := JTF_NUMBER_TABLE();
578: a32 := JTF_DATE_TABLE();
579: a33 := JTF_NUMBER_TABLE();
580: if t.count > 0 then
581: a0.extend(t.count);

Line 579: a33 := JTF_NUMBER_TABLE();

575: a29 := JTF_NUMBER_TABLE();
576: a30 := JTF_DATE_TABLE();
577: a31 := JTF_NUMBER_TABLE();
578: a32 := JTF_DATE_TABLE();
579: a33 := JTF_NUMBER_TABLE();
580: if t.count > 0 then
581: a0.extend(t.count);
582: a1.extend(t.count);
583: a2.extend(t.count);

Line 842: , p5_a0 JTF_NUMBER_TABLE

838: , p_init_msg_list VARCHAR2
839: , x_return_status out nocopy VARCHAR2
840: , x_msg_count out nocopy NUMBER
841: , x_msg_data out nocopy VARCHAR2
842: , p5_a0 JTF_NUMBER_TABLE
843: , p5_a1 JTF_NUMBER_TABLE
844: , p5_a2 JTF_VARCHAR2_TABLE_100
845: , p5_a3 JTF_NUMBER_TABLE
846: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 843: , p5_a1 JTF_NUMBER_TABLE

839: , x_return_status out nocopy VARCHAR2
840: , x_msg_count out nocopy NUMBER
841: , x_msg_data out nocopy VARCHAR2
842: , p5_a0 JTF_NUMBER_TABLE
843: , p5_a1 JTF_NUMBER_TABLE
844: , p5_a2 JTF_VARCHAR2_TABLE_100
845: , p5_a3 JTF_NUMBER_TABLE
846: , p5_a4 JTF_VARCHAR2_TABLE_100
847: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 845: , p5_a3 JTF_NUMBER_TABLE

841: , x_msg_data out nocopy VARCHAR2
842: , p5_a0 JTF_NUMBER_TABLE
843: , p5_a1 JTF_NUMBER_TABLE
844: , p5_a2 JTF_VARCHAR2_TABLE_100
845: , p5_a3 JTF_NUMBER_TABLE
846: , p5_a4 JTF_VARCHAR2_TABLE_100
847: , p5_a5 JTF_VARCHAR2_TABLE_200
848: , p5_a6 JTF_VARCHAR2_TABLE_2000
849: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 869: , p5_a27 JTF_NUMBER_TABLE

865: , p5_a23 JTF_VARCHAR2_TABLE_500
866: , p5_a24 JTF_VARCHAR2_TABLE_500
867: , p5_a25 JTF_VARCHAR2_TABLE_500
868: , p5_a26 JTF_VARCHAR2_TABLE_500
869: , p5_a27 JTF_NUMBER_TABLE
870: , p5_a28 JTF_VARCHAR2_TABLE_100
871: , p5_a29 JTF_NUMBER_TABLE
872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE

Line 871: , p5_a29 JTF_NUMBER_TABLE

867: , p5_a25 JTF_VARCHAR2_TABLE_500
868: , p5_a26 JTF_VARCHAR2_TABLE_500
869: , p5_a27 JTF_NUMBER_TABLE
870: , p5_a28 JTF_VARCHAR2_TABLE_100
871: , p5_a29 JTF_NUMBER_TABLE
872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE

Line 873: , p5_a31 JTF_NUMBER_TABLE

869: , p5_a27 JTF_NUMBER_TABLE
870: , p5_a28 JTF_VARCHAR2_TABLE_100
871: , p5_a29 JTF_NUMBER_TABLE
872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 875: , p5_a33 JTF_NUMBER_TABLE

871: , p5_a29 JTF_NUMBER_TABLE
872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE
878: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
879: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 876: , p6_a0 out nocopy JTF_NUMBER_TABLE

872: , p5_a30 JTF_DATE_TABLE
873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE
878: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
879: , p6_a3 out nocopy JTF_NUMBER_TABLE
880: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 877: , p6_a1 out nocopy JTF_NUMBER_TABLE

873: , p5_a31 JTF_NUMBER_TABLE
874: , p5_a32 JTF_DATE_TABLE
875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE
878: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
879: , p6_a3 out nocopy JTF_NUMBER_TABLE
880: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
881: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 879: , p6_a3 out nocopy JTF_NUMBER_TABLE

875: , p5_a33 JTF_NUMBER_TABLE
876: , p6_a0 out nocopy JTF_NUMBER_TABLE
877: , p6_a1 out nocopy JTF_NUMBER_TABLE
878: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
879: , p6_a3 out nocopy JTF_NUMBER_TABLE
880: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
881: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
882: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
883: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 903: , p6_a27 out nocopy JTF_NUMBER_TABLE

899: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
900: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
901: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
902: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
903: , p6_a27 out nocopy JTF_NUMBER_TABLE
904: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
905: , p6_a29 out nocopy JTF_NUMBER_TABLE
906: , p6_a30 out nocopy JTF_DATE_TABLE
907: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 905: , p6_a29 out nocopy JTF_NUMBER_TABLE

901: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
902: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
903: , p6_a27 out nocopy JTF_NUMBER_TABLE
904: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
905: , p6_a29 out nocopy JTF_NUMBER_TABLE
906: , p6_a30 out nocopy JTF_DATE_TABLE
907: , p6_a31 out nocopy JTF_NUMBER_TABLE
908: , p6_a32 out nocopy JTF_DATE_TABLE
909: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 907: , p6_a31 out nocopy JTF_NUMBER_TABLE

903: , p6_a27 out nocopy JTF_NUMBER_TABLE
904: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
905: , p6_a29 out nocopy JTF_NUMBER_TABLE
906: , p6_a30 out nocopy JTF_DATE_TABLE
907: , p6_a31 out nocopy JTF_NUMBER_TABLE
908: , p6_a32 out nocopy JTF_DATE_TABLE
909: , p6_a33 out nocopy JTF_NUMBER_TABLE
910: )
911:

Line 909: , p6_a33 out nocopy JTF_NUMBER_TABLE

905: , p6_a29 out nocopy JTF_NUMBER_TABLE
906: , p6_a30 out nocopy JTF_DATE_TABLE
907: , p6_a31 out nocopy JTF_NUMBER_TABLE
908: , p6_a32 out nocopy JTF_DATE_TABLE
909: , p6_a33 out nocopy JTF_NUMBER_TABLE
910: )
911:
912: as
913: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;

Line 1122: , p5_a0 JTF_NUMBER_TABLE

1118: , p_init_msg_list VARCHAR2
1119: , x_return_status out nocopy VARCHAR2
1120: , x_msg_count out nocopy NUMBER
1121: , x_msg_data out nocopy VARCHAR2
1122: , p5_a0 JTF_NUMBER_TABLE
1123: , p5_a1 JTF_NUMBER_TABLE
1124: , p5_a2 JTF_VARCHAR2_TABLE_100
1125: , p5_a3 JTF_NUMBER_TABLE
1126: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1123: , p5_a1 JTF_NUMBER_TABLE

1119: , x_return_status out nocopy VARCHAR2
1120: , x_msg_count out nocopy NUMBER
1121: , x_msg_data out nocopy VARCHAR2
1122: , p5_a0 JTF_NUMBER_TABLE
1123: , p5_a1 JTF_NUMBER_TABLE
1124: , p5_a2 JTF_VARCHAR2_TABLE_100
1125: , p5_a3 JTF_NUMBER_TABLE
1126: , p5_a4 JTF_VARCHAR2_TABLE_100
1127: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 1125: , p5_a3 JTF_NUMBER_TABLE

1121: , x_msg_data out nocopy VARCHAR2
1122: , p5_a0 JTF_NUMBER_TABLE
1123: , p5_a1 JTF_NUMBER_TABLE
1124: , p5_a2 JTF_VARCHAR2_TABLE_100
1125: , p5_a3 JTF_NUMBER_TABLE
1126: , p5_a4 JTF_VARCHAR2_TABLE_100
1127: , p5_a5 JTF_VARCHAR2_TABLE_200
1128: , p5_a6 JTF_VARCHAR2_TABLE_2000
1129: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 1149: , p5_a27 JTF_NUMBER_TABLE

1145: , p5_a23 JTF_VARCHAR2_TABLE_500
1146: , p5_a24 JTF_VARCHAR2_TABLE_500
1147: , p5_a25 JTF_VARCHAR2_TABLE_500
1148: , p5_a26 JTF_VARCHAR2_TABLE_500
1149: , p5_a27 JTF_NUMBER_TABLE
1150: , p5_a28 JTF_VARCHAR2_TABLE_100
1151: , p5_a29 JTF_NUMBER_TABLE
1152: , p5_a30 JTF_DATE_TABLE
1153: , p5_a31 JTF_NUMBER_TABLE

Line 1151: , p5_a29 JTF_NUMBER_TABLE

1147: , p5_a25 JTF_VARCHAR2_TABLE_500
1148: , p5_a26 JTF_VARCHAR2_TABLE_500
1149: , p5_a27 JTF_NUMBER_TABLE
1150: , p5_a28 JTF_VARCHAR2_TABLE_100
1151: , p5_a29 JTF_NUMBER_TABLE
1152: , p5_a30 JTF_DATE_TABLE
1153: , p5_a31 JTF_NUMBER_TABLE
1154: , p5_a32 JTF_DATE_TABLE
1155: , p5_a33 JTF_NUMBER_TABLE

Line 1153: , p5_a31 JTF_NUMBER_TABLE

1149: , p5_a27 JTF_NUMBER_TABLE
1150: , p5_a28 JTF_VARCHAR2_TABLE_100
1151: , p5_a29 JTF_NUMBER_TABLE
1152: , p5_a30 JTF_DATE_TABLE
1153: , p5_a31 JTF_NUMBER_TABLE
1154: , p5_a32 JTF_DATE_TABLE
1155: , p5_a33 JTF_NUMBER_TABLE
1156: )
1157:

Line 1155: , p5_a33 JTF_NUMBER_TABLE

1151: , p5_a29 JTF_NUMBER_TABLE
1152: , p5_a30 JTF_DATE_TABLE
1153: , p5_a31 JTF_NUMBER_TABLE
1154: , p5_a32 JTF_DATE_TABLE
1155: , p5_a33 JTF_NUMBER_TABLE
1156: )
1157:
1158: as
1159: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;

Line 1401: , p5_a0 JTF_NUMBER_TABLE

1397: , p_init_msg_list VARCHAR2
1398: , x_return_status out nocopy VARCHAR2
1399: , x_msg_count out nocopy NUMBER
1400: , x_msg_data out nocopy VARCHAR2
1401: , p5_a0 JTF_NUMBER_TABLE
1402: , p5_a1 JTF_NUMBER_TABLE
1403: , p5_a2 JTF_VARCHAR2_TABLE_100
1404: , p5_a3 JTF_NUMBER_TABLE
1405: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1402: , p5_a1 JTF_NUMBER_TABLE

1398: , x_return_status out nocopy VARCHAR2
1399: , x_msg_count out nocopy NUMBER
1400: , x_msg_data out nocopy VARCHAR2
1401: , p5_a0 JTF_NUMBER_TABLE
1402: , p5_a1 JTF_NUMBER_TABLE
1403: , p5_a2 JTF_VARCHAR2_TABLE_100
1404: , p5_a3 JTF_NUMBER_TABLE
1405: , p5_a4 JTF_VARCHAR2_TABLE_100
1406: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 1404: , p5_a3 JTF_NUMBER_TABLE

1400: , x_msg_data out nocopy VARCHAR2
1401: , p5_a0 JTF_NUMBER_TABLE
1402: , p5_a1 JTF_NUMBER_TABLE
1403: , p5_a2 JTF_VARCHAR2_TABLE_100
1404: , p5_a3 JTF_NUMBER_TABLE
1405: , p5_a4 JTF_VARCHAR2_TABLE_100
1406: , p5_a5 JTF_VARCHAR2_TABLE_200
1407: , p5_a6 JTF_VARCHAR2_TABLE_2000
1408: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 1428: , p5_a27 JTF_NUMBER_TABLE

1424: , p5_a23 JTF_VARCHAR2_TABLE_500
1425: , p5_a24 JTF_VARCHAR2_TABLE_500
1426: , p5_a25 JTF_VARCHAR2_TABLE_500
1427: , p5_a26 JTF_VARCHAR2_TABLE_500
1428: , p5_a27 JTF_NUMBER_TABLE
1429: , p5_a28 JTF_VARCHAR2_TABLE_100
1430: , p5_a29 JTF_NUMBER_TABLE
1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE

Line 1430: , p5_a29 JTF_NUMBER_TABLE

1426: , p5_a25 JTF_VARCHAR2_TABLE_500
1427: , p5_a26 JTF_VARCHAR2_TABLE_500
1428: , p5_a27 JTF_NUMBER_TABLE
1429: , p5_a28 JTF_VARCHAR2_TABLE_100
1430: , p5_a29 JTF_NUMBER_TABLE
1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE

Line 1432: , p5_a31 JTF_NUMBER_TABLE

1428: , p5_a27 JTF_NUMBER_TABLE
1429: , p5_a28 JTF_VARCHAR2_TABLE_100
1430: , p5_a29 JTF_NUMBER_TABLE
1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 1434: , p5_a33 JTF_NUMBER_TABLE

1430: , p5_a29 JTF_NUMBER_TABLE
1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE
1437: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1438: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1435: , p6_a0 out nocopy JTF_NUMBER_TABLE

1431: , p5_a30 JTF_DATE_TABLE
1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE
1437: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1438: , p6_a3 out nocopy JTF_NUMBER_TABLE
1439: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1436: , p6_a1 out nocopy JTF_NUMBER_TABLE

1432: , p5_a31 JTF_NUMBER_TABLE
1433: , p5_a32 JTF_DATE_TABLE
1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE
1437: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1438: , p6_a3 out nocopy JTF_NUMBER_TABLE
1439: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1440: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 1438: , p6_a3 out nocopy JTF_NUMBER_TABLE

1434: , p5_a33 JTF_NUMBER_TABLE
1435: , p6_a0 out nocopy JTF_NUMBER_TABLE
1436: , p6_a1 out nocopy JTF_NUMBER_TABLE
1437: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1438: , p6_a3 out nocopy JTF_NUMBER_TABLE
1439: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1440: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1441: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1442: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1462: , p6_a27 out nocopy JTF_NUMBER_TABLE

1458: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1459: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1460: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1461: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1462: , p6_a27 out nocopy JTF_NUMBER_TABLE
1463: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a29 out nocopy JTF_NUMBER_TABLE
1465: , p6_a30 out nocopy JTF_DATE_TABLE
1466: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 1464: , p6_a29 out nocopy JTF_NUMBER_TABLE

1460: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1461: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1462: , p6_a27 out nocopy JTF_NUMBER_TABLE
1463: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a29 out nocopy JTF_NUMBER_TABLE
1465: , p6_a30 out nocopy JTF_DATE_TABLE
1466: , p6_a31 out nocopy JTF_NUMBER_TABLE
1467: , p6_a32 out nocopy JTF_DATE_TABLE
1468: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 1466: , p6_a31 out nocopy JTF_NUMBER_TABLE

1462: , p6_a27 out nocopy JTF_NUMBER_TABLE
1463: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a29 out nocopy JTF_NUMBER_TABLE
1465: , p6_a30 out nocopy JTF_DATE_TABLE
1466: , p6_a31 out nocopy JTF_NUMBER_TABLE
1467: , p6_a32 out nocopy JTF_DATE_TABLE
1468: , p6_a33 out nocopy JTF_NUMBER_TABLE
1469: )
1470:

Line 1468: , p6_a33 out nocopy JTF_NUMBER_TABLE

1464: , p6_a29 out nocopy JTF_NUMBER_TABLE
1465: , p6_a30 out nocopy JTF_DATE_TABLE
1466: , p6_a31 out nocopy JTF_NUMBER_TABLE
1467: , p6_a32 out nocopy JTF_DATE_TABLE
1468: , p6_a33 out nocopy JTF_NUMBER_TABLE
1469: )
1470:
1471: as
1472: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;

Line 1681: , p5_a0 JTF_NUMBER_TABLE

1677: , p_init_msg_list VARCHAR2
1678: , x_return_status out nocopy VARCHAR2
1679: , x_msg_count out nocopy NUMBER
1680: , x_msg_data out nocopy VARCHAR2
1681: , p5_a0 JTF_NUMBER_TABLE
1682: , p5_a1 JTF_NUMBER_TABLE
1683: , p5_a2 JTF_VARCHAR2_TABLE_100
1684: , p5_a3 JTF_NUMBER_TABLE
1685: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1682: , p5_a1 JTF_NUMBER_TABLE

1678: , x_return_status out nocopy VARCHAR2
1679: , x_msg_count out nocopy NUMBER
1680: , x_msg_data out nocopy VARCHAR2
1681: , p5_a0 JTF_NUMBER_TABLE
1682: , p5_a1 JTF_NUMBER_TABLE
1683: , p5_a2 JTF_VARCHAR2_TABLE_100
1684: , p5_a3 JTF_NUMBER_TABLE
1685: , p5_a4 JTF_VARCHAR2_TABLE_100
1686: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 1684: , p5_a3 JTF_NUMBER_TABLE

1680: , x_msg_data out nocopy VARCHAR2
1681: , p5_a0 JTF_NUMBER_TABLE
1682: , p5_a1 JTF_NUMBER_TABLE
1683: , p5_a2 JTF_VARCHAR2_TABLE_100
1684: , p5_a3 JTF_NUMBER_TABLE
1685: , p5_a4 JTF_VARCHAR2_TABLE_100
1686: , p5_a5 JTF_VARCHAR2_TABLE_200
1687: , p5_a6 JTF_VARCHAR2_TABLE_2000
1688: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 1708: , p5_a27 JTF_NUMBER_TABLE

1704: , p5_a23 JTF_VARCHAR2_TABLE_500
1705: , p5_a24 JTF_VARCHAR2_TABLE_500
1706: , p5_a25 JTF_VARCHAR2_TABLE_500
1707: , p5_a26 JTF_VARCHAR2_TABLE_500
1708: , p5_a27 JTF_NUMBER_TABLE
1709: , p5_a28 JTF_VARCHAR2_TABLE_100
1710: , p5_a29 JTF_NUMBER_TABLE
1711: , p5_a30 JTF_DATE_TABLE
1712: , p5_a31 JTF_NUMBER_TABLE

Line 1710: , p5_a29 JTF_NUMBER_TABLE

1706: , p5_a25 JTF_VARCHAR2_TABLE_500
1707: , p5_a26 JTF_VARCHAR2_TABLE_500
1708: , p5_a27 JTF_NUMBER_TABLE
1709: , p5_a28 JTF_VARCHAR2_TABLE_100
1710: , p5_a29 JTF_NUMBER_TABLE
1711: , p5_a30 JTF_DATE_TABLE
1712: , p5_a31 JTF_NUMBER_TABLE
1713: , p5_a32 JTF_DATE_TABLE
1714: , p5_a33 JTF_NUMBER_TABLE

Line 1712: , p5_a31 JTF_NUMBER_TABLE

1708: , p5_a27 JTF_NUMBER_TABLE
1709: , p5_a28 JTF_VARCHAR2_TABLE_100
1710: , p5_a29 JTF_NUMBER_TABLE
1711: , p5_a30 JTF_DATE_TABLE
1712: , p5_a31 JTF_NUMBER_TABLE
1713: , p5_a32 JTF_DATE_TABLE
1714: , p5_a33 JTF_NUMBER_TABLE
1715: )
1716:

Line 1714: , p5_a33 JTF_NUMBER_TABLE

1710: , p5_a29 JTF_NUMBER_TABLE
1711: , p5_a30 JTF_DATE_TABLE
1712: , p5_a31 JTF_NUMBER_TABLE
1713: , p5_a32 JTF_DATE_TABLE
1714: , p5_a33 JTF_NUMBER_TABLE
1715: )
1716:
1717: as
1718: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;

Line 1888: , p5_a0 JTF_NUMBER_TABLE

1884: , p_init_msg_list VARCHAR2
1885: , x_return_status out nocopy VARCHAR2
1886: , x_msg_count out nocopy NUMBER
1887: , x_msg_data out nocopy VARCHAR2
1888: , p5_a0 JTF_NUMBER_TABLE
1889: , p5_a1 JTF_NUMBER_TABLE
1890: , p5_a2 JTF_VARCHAR2_TABLE_100
1891: , p5_a3 JTF_NUMBER_TABLE
1892: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 1889: , p5_a1 JTF_NUMBER_TABLE

1885: , x_return_status out nocopy VARCHAR2
1886: , x_msg_count out nocopy NUMBER
1887: , x_msg_data out nocopy VARCHAR2
1888: , p5_a0 JTF_NUMBER_TABLE
1889: , p5_a1 JTF_NUMBER_TABLE
1890: , p5_a2 JTF_VARCHAR2_TABLE_100
1891: , p5_a3 JTF_NUMBER_TABLE
1892: , p5_a4 JTF_VARCHAR2_TABLE_100
1893: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 1891: , p5_a3 JTF_NUMBER_TABLE

1887: , x_msg_data out nocopy VARCHAR2
1888: , p5_a0 JTF_NUMBER_TABLE
1889: , p5_a1 JTF_NUMBER_TABLE
1890: , p5_a2 JTF_VARCHAR2_TABLE_100
1891: , p5_a3 JTF_NUMBER_TABLE
1892: , p5_a4 JTF_VARCHAR2_TABLE_100
1893: , p5_a5 JTF_VARCHAR2_TABLE_200
1894: , p5_a6 JTF_VARCHAR2_TABLE_2000
1895: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 1915: , p5_a27 JTF_NUMBER_TABLE

1911: , p5_a23 JTF_VARCHAR2_TABLE_500
1912: , p5_a24 JTF_VARCHAR2_TABLE_500
1913: , p5_a25 JTF_VARCHAR2_TABLE_500
1914: , p5_a26 JTF_VARCHAR2_TABLE_500
1915: , p5_a27 JTF_NUMBER_TABLE
1916: , p5_a28 JTF_VARCHAR2_TABLE_100
1917: , p5_a29 JTF_NUMBER_TABLE
1918: , p5_a30 JTF_DATE_TABLE
1919: , p5_a31 JTF_NUMBER_TABLE

Line 1917: , p5_a29 JTF_NUMBER_TABLE

1913: , p5_a25 JTF_VARCHAR2_TABLE_500
1914: , p5_a26 JTF_VARCHAR2_TABLE_500
1915: , p5_a27 JTF_NUMBER_TABLE
1916: , p5_a28 JTF_VARCHAR2_TABLE_100
1917: , p5_a29 JTF_NUMBER_TABLE
1918: , p5_a30 JTF_DATE_TABLE
1919: , p5_a31 JTF_NUMBER_TABLE
1920: , p5_a32 JTF_DATE_TABLE
1921: , p5_a33 JTF_NUMBER_TABLE

Line 1919: , p5_a31 JTF_NUMBER_TABLE

1915: , p5_a27 JTF_NUMBER_TABLE
1916: , p5_a28 JTF_VARCHAR2_TABLE_100
1917: , p5_a29 JTF_NUMBER_TABLE
1918: , p5_a30 JTF_DATE_TABLE
1919: , p5_a31 JTF_NUMBER_TABLE
1920: , p5_a32 JTF_DATE_TABLE
1921: , p5_a33 JTF_NUMBER_TABLE
1922: )
1923:

Line 1921: , p5_a33 JTF_NUMBER_TABLE

1917: , p5_a29 JTF_NUMBER_TABLE
1918: , p5_a30 JTF_DATE_TABLE
1919: , p5_a31 JTF_NUMBER_TABLE
1920: , p5_a32 JTF_DATE_TABLE
1921: , p5_a33 JTF_NUMBER_TABLE
1922: )
1923:
1924: as
1925: ddp_fmav_tbl okl_fma_pvt.fmav_tbl_type;