APPS.OKL_QLS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

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

Line 25: , a3 JTF_VARCHAR2_TABLE_100

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

Line 62: , a1 out nocopy JTF_VARCHAR2_TABLE_100

58: end if;
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE

Line 64: , a3 out nocopy JTF_VARCHAR2_TABLE_100

60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE

Line 77: a1 := JTF_VARCHAR2_TABLE_100();

73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();

Line 79: a3 := JTF_VARCHAR2_TABLE_100();

75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();

Line 89: a1 := JTF_VARCHAR2_TABLE_100();

85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();

Line 91: a3 := JTF_VARCHAR2_TABLE_100();

87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();

Line 136: , a1 JTF_VARCHAR2_TABLE_100

132: end if;
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE

Line 138: , a3 JTF_VARCHAR2_TABLE_100

134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE

Line 175: , a1 out nocopy JTF_VARCHAR2_TABLE_100

171: end if;
172: end if;
173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_NUMBER_TABLE
179: , a5 out nocopy JTF_NUMBER_TABLE

Line 177: , a3 out nocopy JTF_VARCHAR2_TABLE_100

173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_NUMBER_TABLE
179: , a5 out nocopy JTF_NUMBER_TABLE
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE

Line 190: a1 := JTF_VARCHAR2_TABLE_100();

186: ddindx binary_integer; indx binary_integer;
187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_NUMBER_TABLE();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_NUMBER_TABLE();
194: a5 := JTF_NUMBER_TABLE();

Line 192: a3 := JTF_VARCHAR2_TABLE_100();

188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_NUMBER_TABLE();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_NUMBER_TABLE();
194: a5 := JTF_NUMBER_TABLE();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();

Line 202: a1 := JTF_VARCHAR2_TABLE_100();

198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_NUMBER_TABLE();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();

Line 204: a3 := JTF_VARCHAR2_TABLE_100();

200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_NUMBER_TABLE();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();

Line 337: , p5_a1 JTF_VARCHAR2_TABLE_100

333: , x_return_status out nocopy VARCHAR2
334: , x_msg_count out nocopy NUMBER
335: , x_msg_data out nocopy VARCHAR2
336: , p5_a0 JTF_NUMBER_TABLE
337: , p5_a1 JTF_VARCHAR2_TABLE_100
338: , p5_a2 JTF_NUMBER_TABLE
339: , p5_a3 JTF_VARCHAR2_TABLE_100
340: , p5_a4 JTF_NUMBER_TABLE
341: , p5_a5 JTF_NUMBER_TABLE

Line 339: , p5_a3 JTF_VARCHAR2_TABLE_100

335: , x_msg_data out nocopy VARCHAR2
336: , p5_a0 JTF_NUMBER_TABLE
337: , p5_a1 JTF_VARCHAR2_TABLE_100
338: , p5_a2 JTF_NUMBER_TABLE
339: , p5_a3 JTF_VARCHAR2_TABLE_100
340: , p5_a4 JTF_NUMBER_TABLE
341: , p5_a5 JTF_NUMBER_TABLE
342: , p5_a6 JTF_NUMBER_TABLE
343: , p5_a7 JTF_DATE_TABLE

Line 348: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

344: , p5_a8 JTF_NUMBER_TABLE
345: , p5_a9 JTF_DATE_TABLE
346: , p5_a10 JTF_NUMBER_TABLE
347: , p6_a0 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a2 out nocopy JTF_NUMBER_TABLE
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a4 out nocopy JTF_NUMBER_TABLE
352: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

346: , p5_a10 JTF_NUMBER_TABLE
347: , p6_a0 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a2 out nocopy JTF_NUMBER_TABLE
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a4 out nocopy JTF_NUMBER_TABLE
352: , p6_a5 out nocopy JTF_NUMBER_TABLE
353: , p6_a6 out nocopy JTF_NUMBER_TABLE
354: , p6_a7 out nocopy JTF_DATE_TABLE

Line 359: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

355: , p6_a8 out nocopy JTF_NUMBER_TABLE
356: , p6_a9 out nocopy JTF_DATE_TABLE
357: , p6_a10 out nocopy JTF_NUMBER_TABLE
358: , p7_a0 in out nocopy JTF_NUMBER_TABLE
359: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
360: , p7_a2 in out nocopy JTF_NUMBER_TABLE
361: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
362: , p7_a4 in out nocopy JTF_NUMBER_TABLE
363: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 363: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

359: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
360: , p7_a2 in out nocopy JTF_NUMBER_TABLE
361: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
362: , p7_a4 in out nocopy JTF_NUMBER_TABLE
363: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
364: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
365: )
366:
367: as

Line 364: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

360: , p7_a2 in out nocopy JTF_NUMBER_TABLE
361: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
362: , p7_a4 in out nocopy JTF_NUMBER_TABLE
363: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
364: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
365: )
366:
367: as
368: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;

Line 449: , p5_a1 JTF_VARCHAR2_TABLE_100

445: , x_return_status out nocopy VARCHAR2
446: , x_msg_count out nocopy NUMBER
447: , x_msg_data out nocopy VARCHAR2
448: , p5_a0 JTF_NUMBER_TABLE
449: , p5_a1 JTF_VARCHAR2_TABLE_100
450: , p5_a2 JTF_NUMBER_TABLE
451: , p5_a3 JTF_VARCHAR2_TABLE_100
452: , p5_a4 JTF_NUMBER_TABLE
453: , p5_a5 JTF_NUMBER_TABLE

Line 451: , p5_a3 JTF_VARCHAR2_TABLE_100

447: , x_msg_data out nocopy VARCHAR2
448: , p5_a0 JTF_NUMBER_TABLE
449: , p5_a1 JTF_VARCHAR2_TABLE_100
450: , p5_a2 JTF_NUMBER_TABLE
451: , p5_a3 JTF_VARCHAR2_TABLE_100
452: , p5_a4 JTF_NUMBER_TABLE
453: , p5_a5 JTF_NUMBER_TABLE
454: , p5_a6 JTF_NUMBER_TABLE
455: , p5_a7 JTF_DATE_TABLE

Line 460: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

456: , p5_a8 JTF_NUMBER_TABLE
457: , p5_a9 JTF_DATE_TABLE
458: , p5_a10 JTF_NUMBER_TABLE
459: , p6_a0 out nocopy JTF_NUMBER_TABLE
460: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a2 out nocopy JTF_NUMBER_TABLE
462: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , p6_a4 out nocopy JTF_NUMBER_TABLE
464: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 462: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

458: , p5_a10 JTF_NUMBER_TABLE
459: , p6_a0 out nocopy JTF_NUMBER_TABLE
460: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a2 out nocopy JTF_NUMBER_TABLE
462: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , p6_a4 out nocopy JTF_NUMBER_TABLE
464: , p6_a5 out nocopy JTF_NUMBER_TABLE
465: , p6_a6 out nocopy JTF_NUMBER_TABLE
466: , p6_a7 out nocopy JTF_DATE_TABLE

Line 591: , p5_a1 JTF_VARCHAR2_TABLE_100

587: , x_return_status out nocopy VARCHAR2
588: , x_msg_count out nocopy NUMBER
589: , x_msg_data out nocopy VARCHAR2
590: , p5_a0 JTF_NUMBER_TABLE
591: , p5_a1 JTF_VARCHAR2_TABLE_100
592: , p5_a2 JTF_NUMBER_TABLE
593: , p5_a3 JTF_VARCHAR2_TABLE_100
594: , p5_a4 JTF_NUMBER_TABLE
595: , p5_a5 JTF_NUMBER_TABLE

Line 593: , p5_a3 JTF_VARCHAR2_TABLE_100

589: , x_msg_data out nocopy VARCHAR2
590: , p5_a0 JTF_NUMBER_TABLE
591: , p5_a1 JTF_VARCHAR2_TABLE_100
592: , p5_a2 JTF_NUMBER_TABLE
593: , p5_a3 JTF_VARCHAR2_TABLE_100
594: , p5_a4 JTF_NUMBER_TABLE
595: , p5_a5 JTF_NUMBER_TABLE
596: , p5_a6 JTF_NUMBER_TABLE
597: , p5_a7 JTF_DATE_TABLE

Line 602: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

598: , p5_a8 JTF_NUMBER_TABLE
599: , p5_a9 JTF_DATE_TABLE
600: , p5_a10 JTF_NUMBER_TABLE
601: , p6_a0 in out nocopy JTF_NUMBER_TABLE
602: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a2 in out nocopy JTF_NUMBER_TABLE
604: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
605: , p6_a4 in out nocopy JTF_NUMBER_TABLE
606: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 606: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

602: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a2 in out nocopy JTF_NUMBER_TABLE
604: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
605: , p6_a4 in out nocopy JTF_NUMBER_TABLE
606: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
607: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
608: )
609:
610: as

Line 607: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

603: , p6_a2 in out nocopy JTF_NUMBER_TABLE
604: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
605: , p6_a4 in out nocopy JTF_NUMBER_TABLE
606: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
607: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
608: )
609:
610: as
611: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;

Line 676: , p5_a1 JTF_VARCHAR2_TABLE_100

672: , x_return_status out nocopy VARCHAR2
673: , x_msg_count out nocopy NUMBER
674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_VARCHAR2_TABLE_100
677: , p5_a2 JTF_NUMBER_TABLE
678: , p5_a3 JTF_VARCHAR2_TABLE_100
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_NUMBER_TABLE

Line 678: , p5_a3 JTF_VARCHAR2_TABLE_100

674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_VARCHAR2_TABLE_100
677: , p5_a2 JTF_NUMBER_TABLE
678: , p5_a3 JTF_VARCHAR2_TABLE_100
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_NUMBER_TABLE
681: , p5_a6 JTF_NUMBER_TABLE
682: , p5_a7 JTF_DATE_TABLE

Line 817: , p5_a1 JTF_VARCHAR2_TABLE_100

813: , x_return_status out nocopy VARCHAR2
814: , x_msg_count out nocopy NUMBER
815: , x_msg_data out nocopy VARCHAR2
816: , p5_a0 JTF_NUMBER_TABLE
817: , p5_a1 JTF_VARCHAR2_TABLE_100
818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_VARCHAR2_TABLE_100
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_NUMBER_TABLE

Line 819: , p5_a3 JTF_VARCHAR2_TABLE_100

815: , x_msg_data out nocopy VARCHAR2
816: , p5_a0 JTF_NUMBER_TABLE
817: , p5_a1 JTF_VARCHAR2_TABLE_100
818: , p5_a2 JTF_NUMBER_TABLE
819: , p5_a3 JTF_VARCHAR2_TABLE_100
820: , p5_a4 JTF_NUMBER_TABLE
821: , p5_a5 JTF_NUMBER_TABLE
822: , p5_a6 JTF_NUMBER_TABLE
823: , p5_a7 JTF_DATE_TABLE

Line 828: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

824: , p5_a8 JTF_NUMBER_TABLE
825: , p5_a9 JTF_DATE_TABLE
826: , p5_a10 JTF_NUMBER_TABLE
827: , p6_a0 out nocopy JTF_NUMBER_TABLE
828: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a2 out nocopy JTF_NUMBER_TABLE
830: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a4 out nocopy JTF_NUMBER_TABLE
832: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 830: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

826: , p5_a10 JTF_NUMBER_TABLE
827: , p6_a0 out nocopy JTF_NUMBER_TABLE
828: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a2 out nocopy JTF_NUMBER_TABLE
830: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a4 out nocopy JTF_NUMBER_TABLE
832: , p6_a5 out nocopy JTF_NUMBER_TABLE
833: , p6_a6 out nocopy JTF_NUMBER_TABLE
834: , p6_a7 out nocopy JTF_DATE_TABLE

Line 839: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

835: , p6_a8 out nocopy JTF_NUMBER_TABLE
836: , p6_a9 out nocopy JTF_DATE_TABLE
837: , p6_a10 out nocopy JTF_NUMBER_TABLE
838: , p7_a0 in out nocopy JTF_NUMBER_TABLE
839: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
840: , p7_a2 in out nocopy JTF_NUMBER_TABLE
841: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
842: , p7_a4 in out nocopy JTF_NUMBER_TABLE
843: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 843: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

839: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
840: , p7_a2 in out nocopy JTF_NUMBER_TABLE
841: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
842: , p7_a4 in out nocopy JTF_NUMBER_TABLE
843: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
844: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
845: )
846:
847: as

Line 844: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

840: , p7_a2 in out nocopy JTF_NUMBER_TABLE
841: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
842: , p7_a4 in out nocopy JTF_NUMBER_TABLE
843: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
844: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
845: )
846:
847: as
848: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;

Line 929: , p5_a1 JTF_VARCHAR2_TABLE_100

925: , x_return_status out nocopy VARCHAR2
926: , x_msg_count out nocopy NUMBER
927: , x_msg_data out nocopy VARCHAR2
928: , p5_a0 JTF_NUMBER_TABLE
929: , p5_a1 JTF_VARCHAR2_TABLE_100
930: , p5_a2 JTF_NUMBER_TABLE
931: , p5_a3 JTF_VARCHAR2_TABLE_100
932: , p5_a4 JTF_NUMBER_TABLE
933: , p5_a5 JTF_NUMBER_TABLE

Line 931: , p5_a3 JTF_VARCHAR2_TABLE_100

927: , x_msg_data out nocopy VARCHAR2
928: , p5_a0 JTF_NUMBER_TABLE
929: , p5_a1 JTF_VARCHAR2_TABLE_100
930: , p5_a2 JTF_NUMBER_TABLE
931: , p5_a3 JTF_VARCHAR2_TABLE_100
932: , p5_a4 JTF_NUMBER_TABLE
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_NUMBER_TABLE
935: , p5_a7 JTF_DATE_TABLE

Line 940: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

936: , p5_a8 JTF_NUMBER_TABLE
937: , p5_a9 JTF_DATE_TABLE
938: , p5_a10 JTF_NUMBER_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a2 out nocopy JTF_NUMBER_TABLE
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

938: , p5_a10 JTF_NUMBER_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a2 out nocopy JTF_NUMBER_TABLE
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_NUMBER_TABLE
945: , p6_a6 out nocopy JTF_NUMBER_TABLE
946: , p6_a7 out nocopy JTF_DATE_TABLE

Line 1071: , p5_a1 JTF_VARCHAR2_TABLE_100

1067: , x_return_status out nocopy VARCHAR2
1068: , x_msg_count out nocopy NUMBER
1069: , x_msg_data out nocopy VARCHAR2
1070: , p5_a0 JTF_NUMBER_TABLE
1071: , p5_a1 JTF_VARCHAR2_TABLE_100
1072: , p5_a2 JTF_NUMBER_TABLE
1073: , p5_a3 JTF_VARCHAR2_TABLE_100
1074: , p5_a4 JTF_NUMBER_TABLE
1075: , p5_a5 JTF_NUMBER_TABLE

Line 1073: , p5_a3 JTF_VARCHAR2_TABLE_100

1069: , x_msg_data out nocopy VARCHAR2
1070: , p5_a0 JTF_NUMBER_TABLE
1071: , p5_a1 JTF_VARCHAR2_TABLE_100
1072: , p5_a2 JTF_NUMBER_TABLE
1073: , p5_a3 JTF_VARCHAR2_TABLE_100
1074: , p5_a4 JTF_NUMBER_TABLE
1075: , p5_a5 JTF_NUMBER_TABLE
1076: , p5_a6 JTF_NUMBER_TABLE
1077: , p5_a7 JTF_DATE_TABLE

Line 1082: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1078: , p5_a8 JTF_NUMBER_TABLE
1079: , p5_a9 JTF_DATE_TABLE
1080: , p5_a10 JTF_NUMBER_TABLE
1081: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1082: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1083: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1084: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1085: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1086: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1086: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1082: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1083: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1084: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1085: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1086: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1087: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1088: )
1089:
1090: as

Line 1087: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

1083: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1084: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1085: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1086: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1087: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1088: )
1089:
1090: as
1091: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;

Line 1156: , p5_a1 JTF_VARCHAR2_TABLE_100

1152: , x_return_status out nocopy VARCHAR2
1153: , x_msg_count out nocopy NUMBER
1154: , x_msg_data out nocopy VARCHAR2
1155: , p5_a0 JTF_NUMBER_TABLE
1156: , p5_a1 JTF_VARCHAR2_TABLE_100
1157: , p5_a2 JTF_NUMBER_TABLE
1158: , p5_a3 JTF_VARCHAR2_TABLE_100
1159: , p5_a4 JTF_NUMBER_TABLE
1160: , p5_a5 JTF_NUMBER_TABLE

Line 1158: , p5_a3 JTF_VARCHAR2_TABLE_100

1154: , x_msg_data out nocopy VARCHAR2
1155: , p5_a0 JTF_NUMBER_TABLE
1156: , p5_a1 JTF_VARCHAR2_TABLE_100
1157: , p5_a2 JTF_NUMBER_TABLE
1158: , p5_a3 JTF_VARCHAR2_TABLE_100
1159: , p5_a4 JTF_NUMBER_TABLE
1160: , p5_a5 JTF_NUMBER_TABLE
1161: , p5_a6 JTF_NUMBER_TABLE
1162: , p5_a7 JTF_DATE_TABLE

Line 1271: , p5_a1 JTF_VARCHAR2_TABLE_100

1267: , x_return_status out nocopy VARCHAR2
1268: , x_msg_count out nocopy NUMBER
1269: , x_msg_data out nocopy VARCHAR2
1270: , p5_a0 JTF_NUMBER_TABLE
1271: , p5_a1 JTF_VARCHAR2_TABLE_100
1272: , p5_a2 JTF_NUMBER_TABLE
1273: , p5_a3 JTF_VARCHAR2_TABLE_100
1274: , p5_a4 JTF_NUMBER_TABLE
1275: , p5_a5 JTF_NUMBER_TABLE

Line 1273: , p5_a3 JTF_VARCHAR2_TABLE_100

1269: , x_msg_data out nocopy VARCHAR2
1270: , p5_a0 JTF_NUMBER_TABLE
1271: , p5_a1 JTF_VARCHAR2_TABLE_100
1272: , p5_a2 JTF_NUMBER_TABLE
1273: , p5_a3 JTF_VARCHAR2_TABLE_100
1274: , p5_a4 JTF_NUMBER_TABLE
1275: , p5_a5 JTF_NUMBER_TABLE
1276: , p5_a6 JTF_NUMBER_TABLE
1277: , p5_a7 JTF_DATE_TABLE

Line 1282: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1278: , p5_a8 JTF_NUMBER_TABLE
1279: , p5_a9 JTF_DATE_TABLE
1280: , p5_a10 JTF_NUMBER_TABLE
1281: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1282: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1284: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1285: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1286: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1286: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1282: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1284: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1285: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1286: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1287: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1288: )
1289:
1290: as

Line 1287: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

1283: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1284: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1285: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1286: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1287: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1288: )
1289:
1290: as
1291: ddp_qlsv_tbl okl_qls_pvt.qlsv_tbl_type;

Line 1356: , p5_a1 JTF_VARCHAR2_TABLE_100

1352: , x_return_status out nocopy VARCHAR2
1353: , x_msg_count out nocopy NUMBER
1354: , x_msg_data out nocopy VARCHAR2
1355: , p5_a0 JTF_NUMBER_TABLE
1356: , p5_a1 JTF_VARCHAR2_TABLE_100
1357: , p5_a2 JTF_NUMBER_TABLE
1358: , p5_a3 JTF_VARCHAR2_TABLE_100
1359: , p5_a4 JTF_NUMBER_TABLE
1360: , p5_a5 JTF_NUMBER_TABLE

Line 1358: , p5_a3 JTF_VARCHAR2_TABLE_100

1354: , x_msg_data out nocopy VARCHAR2
1355: , p5_a0 JTF_NUMBER_TABLE
1356: , p5_a1 JTF_VARCHAR2_TABLE_100
1357: , p5_a2 JTF_NUMBER_TABLE
1358: , p5_a3 JTF_VARCHAR2_TABLE_100
1359: , p5_a4 JTF_NUMBER_TABLE
1360: , p5_a5 JTF_NUMBER_TABLE
1361: , p5_a6 JTF_NUMBER_TABLE
1362: , p5_a7 JTF_DATE_TABLE