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

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_spp_pvt.spp_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_spp_pvt.spp_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_DATE_TABLE

Line 23: , a1 JTF_NUMBER_TABLE

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

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_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_NUMBER_TABLE

Line 50: , a28 JTF_NUMBER_TABLE

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_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_DATE_TABLE
53: , a31 JTF_NUMBER_TABLE
54: ) as

Line 53: , a31 JTF_NUMBER_TABLE

49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_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_spp_pvt.spp_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_spp_pvt.spp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_200
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_DATE_TABLE

Line 104: , a1 out nocopy JTF_NUMBER_TABLE

100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_spp_pvt.spp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_200
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_DATE_TABLE

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_NUMBER_TABLE
132: , a29 out nocopy JTF_DATE_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE

Line 131: , a28 out nocopy JTF_NUMBER_TABLE

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_NUMBER_TABLE
132: , a29 out nocopy JTF_DATE_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
135: ) as

Line 134: , a31 out nocopy JTF_NUMBER_TABLE

130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_NUMBER_TABLE
132: , a29 out nocopy JTF_DATE_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_NUMBER_TABLE();
141: a2 := JTF_VARCHAR2_TABLE_200();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_DATE_TABLE();

Line 140: a1 := JTF_NUMBER_TABLE();

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_NUMBER_TABLE();
141: a2 := JTF_VARCHAR2_TABLE_200();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_DATE_TABLE();
144: a5 := JTF_DATE_TABLE();

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_NUMBER_TABLE();
168: a29 := JTF_DATE_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();

Line 167: a28 := JTF_NUMBER_TABLE();

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_NUMBER_TABLE();
168: a29 := JTF_DATE_TABLE();
169: a30 := JTF_DATE_TABLE();
170: a31 := JTF_NUMBER_TABLE();
171: else

Line 170: a31 := JTF_NUMBER_TABLE();

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

Line 172: a0 := JTF_NUMBER_TABLE();

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

Line 173: a1 := JTF_NUMBER_TABLE();

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

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_NUMBER_TABLE();
201: a29 := JTF_DATE_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();

Line 200: a28 := JTF_NUMBER_TABLE();

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_NUMBER_TABLE();
201: a29 := JTF_DATE_TABLE();
202: a30 := JTF_DATE_TABLE();
203: a31 := JTF_NUMBER_TABLE();
204: if t.count > 0 then

Line 203: a31 := JTF_NUMBER_TABLE();

199: a27 := JTF_NUMBER_TABLE();
200: a28 := JTF_NUMBER_TABLE();
201: a29 := JTF_DATE_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_spp_pvt.sppv_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_spp_pvt.sppv_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_NUMBER_TABLE
284: , a2 JTF_VARCHAR2_TABLE_200
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_DATE_TABLE

Line 283: , a1 JTF_NUMBER_TABLE

279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_spp_pvt.sppv_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_NUMBER_TABLE
284: , a2 JTF_VARCHAR2_TABLE_200
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_DATE_TABLE
287: , a5 JTF_DATE_TABLE

Line 309: , a27 JTF_NUMBER_TABLE

305: , a23 JTF_VARCHAR2_TABLE_500
306: , a24 JTF_VARCHAR2_TABLE_500
307: , a25 JTF_VARCHAR2_TABLE_500
308: , a26 JTF_VARCHAR2_TABLE_500
309: , a27 JTF_NUMBER_TABLE
310: , a28 JTF_NUMBER_TABLE
311: , a29 JTF_DATE_TABLE
312: , a30 JTF_DATE_TABLE
313: , a31 JTF_NUMBER_TABLE

Line 310: , a28 JTF_NUMBER_TABLE

306: , a24 JTF_VARCHAR2_TABLE_500
307: , a25 JTF_VARCHAR2_TABLE_500
308: , a26 JTF_VARCHAR2_TABLE_500
309: , a27 JTF_NUMBER_TABLE
310: , a28 JTF_NUMBER_TABLE
311: , a29 JTF_DATE_TABLE
312: , a30 JTF_DATE_TABLE
313: , a31 JTF_NUMBER_TABLE
314: ) as

Line 313: , a31 JTF_NUMBER_TABLE

309: , a27 JTF_NUMBER_TABLE
310: , a28 JTF_NUMBER_TABLE
311: , a29 JTF_DATE_TABLE
312: , a30 JTF_DATE_TABLE
313: , a31 JTF_NUMBER_TABLE
314: ) as
315: ddindx binary_integer; indx binary_integer;
316: begin
317: if a0 is not null and a0.count > 0 then

Line 363: procedure rosetta_table_copy_out_p5(t okl_spp_pvt.sppv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

359: end loop;
360: end if;
361: end if;
362: end rosetta_table_copy_in_p5;
363: procedure rosetta_table_copy_out_p5(t okl_spp_pvt.sppv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_NUMBER_TABLE
365: , a2 out nocopy JTF_VARCHAR2_TABLE_200
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_DATE_TABLE

Line 364: , a1 out nocopy JTF_NUMBER_TABLE

360: end if;
361: end if;
362: end rosetta_table_copy_in_p5;
363: procedure rosetta_table_copy_out_p5(t okl_spp_pvt.sppv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_NUMBER_TABLE
365: , a2 out nocopy JTF_VARCHAR2_TABLE_200
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_DATE_TABLE
368: , a5 out nocopy JTF_DATE_TABLE

Line 390: , a27 out nocopy JTF_NUMBER_TABLE

386: , a23 out nocopy JTF_VARCHAR2_TABLE_500
387: , a24 out nocopy JTF_VARCHAR2_TABLE_500
388: , a25 out nocopy JTF_VARCHAR2_TABLE_500
389: , a26 out nocopy JTF_VARCHAR2_TABLE_500
390: , a27 out nocopy JTF_NUMBER_TABLE
391: , a28 out nocopy JTF_NUMBER_TABLE
392: , a29 out nocopy JTF_DATE_TABLE
393: , a30 out nocopy JTF_DATE_TABLE
394: , a31 out nocopy JTF_NUMBER_TABLE

Line 391: , a28 out nocopy JTF_NUMBER_TABLE

387: , a24 out nocopy JTF_VARCHAR2_TABLE_500
388: , a25 out nocopy JTF_VARCHAR2_TABLE_500
389: , a26 out nocopy JTF_VARCHAR2_TABLE_500
390: , a27 out nocopy JTF_NUMBER_TABLE
391: , a28 out nocopy JTF_NUMBER_TABLE
392: , a29 out nocopy JTF_DATE_TABLE
393: , a30 out nocopy JTF_DATE_TABLE
394: , a31 out nocopy JTF_NUMBER_TABLE
395: ) as

Line 394: , a31 out nocopy JTF_NUMBER_TABLE

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

Line 399: a0 := JTF_NUMBER_TABLE();

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

Line 400: a1 := JTF_NUMBER_TABLE();

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

Line 426: a27 := JTF_NUMBER_TABLE();

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

Line 427: a28 := JTF_NUMBER_TABLE();

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

Line 430: a31 := JTF_NUMBER_TABLE();

426: a27 := JTF_NUMBER_TABLE();
427: a28 := JTF_NUMBER_TABLE();
428: a29 := JTF_DATE_TABLE();
429: a30 := JTF_DATE_TABLE();
430: a31 := JTF_NUMBER_TABLE();
431: else
432: a0 := JTF_NUMBER_TABLE();
433: a1 := JTF_NUMBER_TABLE();
434: a2 := JTF_VARCHAR2_TABLE_200();

Line 432: a0 := JTF_NUMBER_TABLE();

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

Line 433: a1 := JTF_NUMBER_TABLE();

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

Line 459: a27 := JTF_NUMBER_TABLE();

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

Line 460: a28 := JTF_NUMBER_TABLE();

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

Line 463: a31 := JTF_NUMBER_TABLE();

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

Line 714: , p5_a0 JTF_NUMBER_TABLE

710: , p_init_msg_list VARCHAR2
711: , x_return_status out nocopy VARCHAR2
712: , x_msg_count out nocopy NUMBER
713: , x_msg_data out nocopy VARCHAR2
714: , p5_a0 JTF_NUMBER_TABLE
715: , p5_a1 JTF_NUMBER_TABLE
716: , p5_a2 JTF_VARCHAR2_TABLE_200
717: , p5_a3 JTF_VARCHAR2_TABLE_100
718: , p5_a4 JTF_DATE_TABLE

Line 715: , p5_a1 JTF_NUMBER_TABLE

711: , x_return_status out nocopy VARCHAR2
712: , x_msg_count out nocopy NUMBER
713: , x_msg_data out nocopy VARCHAR2
714: , p5_a0 JTF_NUMBER_TABLE
715: , p5_a1 JTF_NUMBER_TABLE
716: , p5_a2 JTF_VARCHAR2_TABLE_200
717: , p5_a3 JTF_VARCHAR2_TABLE_100
718: , p5_a4 JTF_DATE_TABLE
719: , p5_a5 JTF_DATE_TABLE

Line 741: , p5_a27 JTF_NUMBER_TABLE

737: , p5_a23 JTF_VARCHAR2_TABLE_500
738: , p5_a24 JTF_VARCHAR2_TABLE_500
739: , p5_a25 JTF_VARCHAR2_TABLE_500
740: , p5_a26 JTF_VARCHAR2_TABLE_500
741: , p5_a27 JTF_NUMBER_TABLE
742: , p5_a28 JTF_NUMBER_TABLE
743: , p5_a29 JTF_DATE_TABLE
744: , p5_a30 JTF_DATE_TABLE
745: , p5_a31 JTF_NUMBER_TABLE

Line 742: , p5_a28 JTF_NUMBER_TABLE

738: , p5_a24 JTF_VARCHAR2_TABLE_500
739: , p5_a25 JTF_VARCHAR2_TABLE_500
740: , p5_a26 JTF_VARCHAR2_TABLE_500
741: , p5_a27 JTF_NUMBER_TABLE
742: , p5_a28 JTF_NUMBER_TABLE
743: , p5_a29 JTF_DATE_TABLE
744: , p5_a30 JTF_DATE_TABLE
745: , p5_a31 JTF_NUMBER_TABLE
746: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 745: , p5_a31 JTF_NUMBER_TABLE

741: , p5_a27 JTF_NUMBER_TABLE
742: , p5_a28 JTF_NUMBER_TABLE
743: , p5_a29 JTF_DATE_TABLE
744: , p5_a30 JTF_DATE_TABLE
745: , p5_a31 JTF_NUMBER_TABLE
746: , p6_a0 out nocopy JTF_NUMBER_TABLE
747: , p6_a1 out nocopy JTF_NUMBER_TABLE
748: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
749: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 746: , p6_a0 out nocopy JTF_NUMBER_TABLE

742: , p5_a28 JTF_NUMBER_TABLE
743: , p5_a29 JTF_DATE_TABLE
744: , p5_a30 JTF_DATE_TABLE
745: , p5_a31 JTF_NUMBER_TABLE
746: , p6_a0 out nocopy JTF_NUMBER_TABLE
747: , p6_a1 out nocopy JTF_NUMBER_TABLE
748: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
749: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a4 out nocopy JTF_DATE_TABLE

Line 747: , p6_a1 out nocopy JTF_NUMBER_TABLE

743: , p5_a29 JTF_DATE_TABLE
744: , p5_a30 JTF_DATE_TABLE
745: , p5_a31 JTF_NUMBER_TABLE
746: , p6_a0 out nocopy JTF_NUMBER_TABLE
747: , p6_a1 out nocopy JTF_NUMBER_TABLE
748: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
749: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a4 out nocopy JTF_DATE_TABLE
751: , p6_a5 out nocopy JTF_DATE_TABLE

Line 773: , p6_a27 out nocopy JTF_NUMBER_TABLE

769: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
770: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
771: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
772: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
773: , p6_a27 out nocopy JTF_NUMBER_TABLE
774: , p6_a28 out nocopy JTF_NUMBER_TABLE
775: , p6_a29 out nocopy JTF_DATE_TABLE
776: , p6_a30 out nocopy JTF_DATE_TABLE
777: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 774: , p6_a28 out nocopy JTF_NUMBER_TABLE

770: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
771: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
772: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
773: , p6_a27 out nocopy JTF_NUMBER_TABLE
774: , p6_a28 out nocopy JTF_NUMBER_TABLE
775: , p6_a29 out nocopy JTF_DATE_TABLE
776: , p6_a30 out nocopy JTF_DATE_TABLE
777: , p6_a31 out nocopy JTF_NUMBER_TABLE
778: )

Line 777: , p6_a31 out nocopy JTF_NUMBER_TABLE

773: , p6_a27 out nocopy JTF_NUMBER_TABLE
774: , p6_a28 out nocopy JTF_NUMBER_TABLE
775: , p6_a29 out nocopy JTF_DATE_TABLE
776: , p6_a30 out nocopy JTF_DATE_TABLE
777: , p6_a31 out nocopy JTF_NUMBER_TABLE
778: )
779:
780: as
781: ddp_sppv_tbl okl_spp_pvt.sppv_tbl_type;

Line 982: , p5_a0 JTF_NUMBER_TABLE

978: , p_init_msg_list VARCHAR2
979: , x_return_status out nocopy VARCHAR2
980: , x_msg_count out nocopy NUMBER
981: , x_msg_data out nocopy VARCHAR2
982: , p5_a0 JTF_NUMBER_TABLE
983: , p5_a1 JTF_NUMBER_TABLE
984: , p5_a2 JTF_VARCHAR2_TABLE_200
985: , p5_a3 JTF_VARCHAR2_TABLE_100
986: , p5_a4 JTF_DATE_TABLE

Line 983: , p5_a1 JTF_NUMBER_TABLE

979: , x_return_status out nocopy VARCHAR2
980: , x_msg_count out nocopy NUMBER
981: , x_msg_data out nocopy VARCHAR2
982: , p5_a0 JTF_NUMBER_TABLE
983: , p5_a1 JTF_NUMBER_TABLE
984: , p5_a2 JTF_VARCHAR2_TABLE_200
985: , p5_a3 JTF_VARCHAR2_TABLE_100
986: , p5_a4 JTF_DATE_TABLE
987: , p5_a5 JTF_DATE_TABLE

Line 1009: , p5_a27 JTF_NUMBER_TABLE

1005: , p5_a23 JTF_VARCHAR2_TABLE_500
1006: , p5_a24 JTF_VARCHAR2_TABLE_500
1007: , p5_a25 JTF_VARCHAR2_TABLE_500
1008: , p5_a26 JTF_VARCHAR2_TABLE_500
1009: , p5_a27 JTF_NUMBER_TABLE
1010: , p5_a28 JTF_NUMBER_TABLE
1011: , p5_a29 JTF_DATE_TABLE
1012: , p5_a30 JTF_DATE_TABLE
1013: , p5_a31 JTF_NUMBER_TABLE

Line 1010: , p5_a28 JTF_NUMBER_TABLE

1006: , p5_a24 JTF_VARCHAR2_TABLE_500
1007: , p5_a25 JTF_VARCHAR2_TABLE_500
1008: , p5_a26 JTF_VARCHAR2_TABLE_500
1009: , p5_a27 JTF_NUMBER_TABLE
1010: , p5_a28 JTF_NUMBER_TABLE
1011: , p5_a29 JTF_DATE_TABLE
1012: , p5_a30 JTF_DATE_TABLE
1013: , p5_a31 JTF_NUMBER_TABLE
1014: )

Line 1013: , p5_a31 JTF_NUMBER_TABLE

1009: , p5_a27 JTF_NUMBER_TABLE
1010: , p5_a28 JTF_NUMBER_TABLE
1011: , p5_a29 JTF_DATE_TABLE
1012: , p5_a30 JTF_DATE_TABLE
1013: , p5_a31 JTF_NUMBER_TABLE
1014: )
1015:
1016: as
1017: ddp_sppv_tbl okl_spp_pvt.sppv_tbl_type;

Line 1249: , p5_a0 JTF_NUMBER_TABLE

1245: , p_init_msg_list VARCHAR2
1246: , x_return_status out nocopy VARCHAR2
1247: , x_msg_count out nocopy NUMBER
1248: , x_msg_data out nocopy VARCHAR2
1249: , p5_a0 JTF_NUMBER_TABLE
1250: , p5_a1 JTF_NUMBER_TABLE
1251: , p5_a2 JTF_VARCHAR2_TABLE_200
1252: , p5_a3 JTF_VARCHAR2_TABLE_100
1253: , p5_a4 JTF_DATE_TABLE

Line 1250: , p5_a1 JTF_NUMBER_TABLE

1246: , x_return_status out nocopy VARCHAR2
1247: , x_msg_count out nocopy NUMBER
1248: , x_msg_data out nocopy VARCHAR2
1249: , p5_a0 JTF_NUMBER_TABLE
1250: , p5_a1 JTF_NUMBER_TABLE
1251: , p5_a2 JTF_VARCHAR2_TABLE_200
1252: , p5_a3 JTF_VARCHAR2_TABLE_100
1253: , p5_a4 JTF_DATE_TABLE
1254: , p5_a5 JTF_DATE_TABLE

Line 1276: , p5_a27 JTF_NUMBER_TABLE

1272: , p5_a23 JTF_VARCHAR2_TABLE_500
1273: , p5_a24 JTF_VARCHAR2_TABLE_500
1274: , p5_a25 JTF_VARCHAR2_TABLE_500
1275: , p5_a26 JTF_VARCHAR2_TABLE_500
1276: , p5_a27 JTF_NUMBER_TABLE
1277: , p5_a28 JTF_NUMBER_TABLE
1278: , p5_a29 JTF_DATE_TABLE
1279: , p5_a30 JTF_DATE_TABLE
1280: , p5_a31 JTF_NUMBER_TABLE

Line 1277: , p5_a28 JTF_NUMBER_TABLE

1273: , p5_a24 JTF_VARCHAR2_TABLE_500
1274: , p5_a25 JTF_VARCHAR2_TABLE_500
1275: , p5_a26 JTF_VARCHAR2_TABLE_500
1276: , p5_a27 JTF_NUMBER_TABLE
1277: , p5_a28 JTF_NUMBER_TABLE
1278: , p5_a29 JTF_DATE_TABLE
1279: , p5_a30 JTF_DATE_TABLE
1280: , p5_a31 JTF_NUMBER_TABLE
1281: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1280: , p5_a31 JTF_NUMBER_TABLE

1276: , p5_a27 JTF_NUMBER_TABLE
1277: , p5_a28 JTF_NUMBER_TABLE
1278: , p5_a29 JTF_DATE_TABLE
1279: , p5_a30 JTF_DATE_TABLE
1280: , p5_a31 JTF_NUMBER_TABLE
1281: , p6_a0 out nocopy JTF_NUMBER_TABLE
1282: , p6_a1 out nocopy JTF_NUMBER_TABLE
1283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 1281: , p6_a0 out nocopy JTF_NUMBER_TABLE

1277: , p5_a28 JTF_NUMBER_TABLE
1278: , p5_a29 JTF_DATE_TABLE
1279: , p5_a30 JTF_DATE_TABLE
1280: , p5_a31 JTF_NUMBER_TABLE
1281: , p6_a0 out nocopy JTF_NUMBER_TABLE
1282: , p6_a1 out nocopy JTF_NUMBER_TABLE
1283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1285: , p6_a4 out nocopy JTF_DATE_TABLE

Line 1282: , p6_a1 out nocopy JTF_NUMBER_TABLE

1278: , p5_a29 JTF_DATE_TABLE
1279: , p5_a30 JTF_DATE_TABLE
1280: , p5_a31 JTF_NUMBER_TABLE
1281: , p6_a0 out nocopy JTF_NUMBER_TABLE
1282: , p6_a1 out nocopy JTF_NUMBER_TABLE
1283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1285: , p6_a4 out nocopy JTF_DATE_TABLE
1286: , p6_a5 out nocopy JTF_DATE_TABLE

Line 1308: , p6_a27 out nocopy JTF_NUMBER_TABLE

1304: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1305: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1306: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1307: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1308: , p6_a27 out nocopy JTF_NUMBER_TABLE
1309: , p6_a28 out nocopy JTF_NUMBER_TABLE
1310: , p6_a29 out nocopy JTF_DATE_TABLE
1311: , p6_a30 out nocopy JTF_DATE_TABLE
1312: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 1309: , p6_a28 out nocopy JTF_NUMBER_TABLE

1305: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1306: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1307: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1308: , p6_a27 out nocopy JTF_NUMBER_TABLE
1309: , p6_a28 out nocopy JTF_NUMBER_TABLE
1310: , p6_a29 out nocopy JTF_DATE_TABLE
1311: , p6_a30 out nocopy JTF_DATE_TABLE
1312: , p6_a31 out nocopy JTF_NUMBER_TABLE
1313: )

Line 1312: , p6_a31 out nocopy JTF_NUMBER_TABLE

1308: , p6_a27 out nocopy JTF_NUMBER_TABLE
1309: , p6_a28 out nocopy JTF_NUMBER_TABLE
1310: , p6_a29 out nocopy JTF_DATE_TABLE
1311: , p6_a30 out nocopy JTF_DATE_TABLE
1312: , p6_a31 out nocopy JTF_NUMBER_TABLE
1313: )
1314:
1315: as
1316: ddp_sppv_tbl okl_spp_pvt.sppv_tbl_type;

Line 1517: , p5_a0 JTF_NUMBER_TABLE

1513: , p_init_msg_list VARCHAR2
1514: , x_return_status out nocopy VARCHAR2
1515: , x_msg_count out nocopy NUMBER
1516: , x_msg_data out nocopy VARCHAR2
1517: , p5_a0 JTF_NUMBER_TABLE
1518: , p5_a1 JTF_NUMBER_TABLE
1519: , p5_a2 JTF_VARCHAR2_TABLE_200
1520: , p5_a3 JTF_VARCHAR2_TABLE_100
1521: , p5_a4 JTF_DATE_TABLE

Line 1518: , p5_a1 JTF_NUMBER_TABLE

1514: , x_return_status out nocopy VARCHAR2
1515: , x_msg_count out nocopy NUMBER
1516: , x_msg_data out nocopy VARCHAR2
1517: , p5_a0 JTF_NUMBER_TABLE
1518: , p5_a1 JTF_NUMBER_TABLE
1519: , p5_a2 JTF_VARCHAR2_TABLE_200
1520: , p5_a3 JTF_VARCHAR2_TABLE_100
1521: , p5_a4 JTF_DATE_TABLE
1522: , p5_a5 JTF_DATE_TABLE

Line 1544: , p5_a27 JTF_NUMBER_TABLE

1540: , p5_a23 JTF_VARCHAR2_TABLE_500
1541: , p5_a24 JTF_VARCHAR2_TABLE_500
1542: , p5_a25 JTF_VARCHAR2_TABLE_500
1543: , p5_a26 JTF_VARCHAR2_TABLE_500
1544: , p5_a27 JTF_NUMBER_TABLE
1545: , p5_a28 JTF_NUMBER_TABLE
1546: , p5_a29 JTF_DATE_TABLE
1547: , p5_a30 JTF_DATE_TABLE
1548: , p5_a31 JTF_NUMBER_TABLE

Line 1545: , p5_a28 JTF_NUMBER_TABLE

1541: , p5_a24 JTF_VARCHAR2_TABLE_500
1542: , p5_a25 JTF_VARCHAR2_TABLE_500
1543: , p5_a26 JTF_VARCHAR2_TABLE_500
1544: , p5_a27 JTF_NUMBER_TABLE
1545: , p5_a28 JTF_NUMBER_TABLE
1546: , p5_a29 JTF_DATE_TABLE
1547: , p5_a30 JTF_DATE_TABLE
1548: , p5_a31 JTF_NUMBER_TABLE
1549: )

Line 1548: , p5_a31 JTF_NUMBER_TABLE

1544: , p5_a27 JTF_NUMBER_TABLE
1545: , p5_a28 JTF_NUMBER_TABLE
1546: , p5_a29 JTF_DATE_TABLE
1547: , p5_a30 JTF_DATE_TABLE
1548: , p5_a31 JTF_NUMBER_TABLE
1549: )
1550:
1551: as
1552: ddp_sppv_tbl okl_spp_pvt.sppv_tbl_type;

Line 1716: , p5_a0 JTF_NUMBER_TABLE

1712: , p_init_msg_list VARCHAR2
1713: , x_return_status out nocopy VARCHAR2
1714: , x_msg_count out nocopy NUMBER
1715: , x_msg_data out nocopy VARCHAR2
1716: , p5_a0 JTF_NUMBER_TABLE
1717: , p5_a1 JTF_NUMBER_TABLE
1718: , p5_a2 JTF_VARCHAR2_TABLE_200
1719: , p5_a3 JTF_VARCHAR2_TABLE_100
1720: , p5_a4 JTF_DATE_TABLE

Line 1717: , p5_a1 JTF_NUMBER_TABLE

1713: , x_return_status out nocopy VARCHAR2
1714: , x_msg_count out nocopy NUMBER
1715: , x_msg_data out nocopy VARCHAR2
1716: , p5_a0 JTF_NUMBER_TABLE
1717: , p5_a1 JTF_NUMBER_TABLE
1718: , p5_a2 JTF_VARCHAR2_TABLE_200
1719: , p5_a3 JTF_VARCHAR2_TABLE_100
1720: , p5_a4 JTF_DATE_TABLE
1721: , p5_a5 JTF_DATE_TABLE

Line 1743: , p5_a27 JTF_NUMBER_TABLE

1739: , p5_a23 JTF_VARCHAR2_TABLE_500
1740: , p5_a24 JTF_VARCHAR2_TABLE_500
1741: , p5_a25 JTF_VARCHAR2_TABLE_500
1742: , p5_a26 JTF_VARCHAR2_TABLE_500
1743: , p5_a27 JTF_NUMBER_TABLE
1744: , p5_a28 JTF_NUMBER_TABLE
1745: , p5_a29 JTF_DATE_TABLE
1746: , p5_a30 JTF_DATE_TABLE
1747: , p5_a31 JTF_NUMBER_TABLE

Line 1744: , p5_a28 JTF_NUMBER_TABLE

1740: , p5_a24 JTF_VARCHAR2_TABLE_500
1741: , p5_a25 JTF_VARCHAR2_TABLE_500
1742: , p5_a26 JTF_VARCHAR2_TABLE_500
1743: , p5_a27 JTF_NUMBER_TABLE
1744: , p5_a28 JTF_NUMBER_TABLE
1745: , p5_a29 JTF_DATE_TABLE
1746: , p5_a30 JTF_DATE_TABLE
1747: , p5_a31 JTF_NUMBER_TABLE
1748: )

Line 1747: , p5_a31 JTF_NUMBER_TABLE

1743: , p5_a27 JTF_NUMBER_TABLE
1744: , p5_a28 JTF_NUMBER_TABLE
1745: , p5_a29 JTF_DATE_TABLE
1746: , p5_a30 JTF_DATE_TABLE
1747: , p5_a31 JTF_NUMBER_TABLE
1748: )
1749:
1750: as
1751: ddp_sppv_tbl okl_spp_pvt.sppv_tbl_type;