DBA Data[Home] [Help]

APPS.OKL_PMR_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

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

Line 63: , a4 out nocopy JTF_VARCHAR2_TABLE_100

59: procedure rosetta_table_copy_out_p2(t okl_pmr_pvt.pmr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_200
61: , a2 out nocopy JTF_VARCHAR2_TABLE_200
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_DATE_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_DATE_TABLE

Line 77: a4 := JTF_VARCHAR2_TABLE_100();

73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_200();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_DATE_TABLE();

Line 88: a4 := JTF_VARCHAR2_TABLE_100();

84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_200();
86: a2 := JTF_VARCHAR2_TABLE_200();
87: a3 := JTF_NUMBER_TABLE();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_NUMBER_TABLE();
90: a6 := JTF_DATE_TABLE();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_DATE_TABLE();

Line 129: , a1 JTF_VARCHAR2_TABLE_100

125: end if;
126: end rosetta_table_copy_out_p2;
127:
128: procedure rosetta_table_copy_in_p5(t out nocopy okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_100
132: , a4 JTF_VARCHAR2_TABLE_2000
133: , a5 JTF_NUMBER_TABLE

Line 130: , a2 JTF_VARCHAR2_TABLE_100

126: end rosetta_table_copy_out_p2;
127:
128: procedure rosetta_table_copy_in_p5(t out nocopy okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_100
132: , a4 JTF_VARCHAR2_TABLE_2000
133: , a5 JTF_NUMBER_TABLE
134: , a6 JTF_DATE_TABLE

Line 131: , a3 JTF_VARCHAR2_TABLE_100

127:
128: procedure rosetta_table_copy_in_p5(t out nocopy okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_100
132: , a4 JTF_VARCHAR2_TABLE_2000
133: , a5 JTF_NUMBER_TABLE
134: , a6 JTF_DATE_TABLE
135: , a7 JTF_NUMBER_TABLE

Line 166: , a1 out nocopy JTF_VARCHAR2_TABLE_100

162: end if;
163: end if;
164: end rosetta_table_copy_in_p5;
165: procedure rosetta_table_copy_out_p5(t okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
166: , a1 out nocopy JTF_VARCHAR2_TABLE_100
167: , a2 out nocopy JTF_VARCHAR2_TABLE_100
168: , a3 out nocopy JTF_VARCHAR2_TABLE_100
169: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
170: , a5 out nocopy JTF_NUMBER_TABLE

Line 167: , a2 out nocopy JTF_VARCHAR2_TABLE_100

163: end if;
164: end rosetta_table_copy_in_p5;
165: procedure rosetta_table_copy_out_p5(t okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
166: , a1 out nocopy JTF_VARCHAR2_TABLE_100
167: , a2 out nocopy JTF_VARCHAR2_TABLE_100
168: , a3 out nocopy JTF_VARCHAR2_TABLE_100
169: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
170: , a5 out nocopy JTF_NUMBER_TABLE
171: , a6 out nocopy JTF_DATE_TABLE

Line 168: , a3 out nocopy JTF_VARCHAR2_TABLE_100

164: end rosetta_table_copy_in_p5;
165: procedure rosetta_table_copy_out_p5(t okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
166: , a1 out nocopy JTF_VARCHAR2_TABLE_100
167: , a2 out nocopy JTF_VARCHAR2_TABLE_100
168: , a3 out nocopy JTF_VARCHAR2_TABLE_100
169: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
170: , a5 out nocopy JTF_NUMBER_TABLE
171: , a6 out nocopy JTF_DATE_TABLE
172: , a7 out nocopy JTF_NUMBER_TABLE

Line 180: a1 := JTF_VARCHAR2_TABLE_100();

176: ddindx binary_integer; indx binary_integer;
177: begin
178: if t is null or t.count = 0 then
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_VARCHAR2_TABLE_100();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_2000();
184: a5 := JTF_NUMBER_TABLE();

Line 181: a2 := JTF_VARCHAR2_TABLE_100();

177: begin
178: if t is null or t.count = 0 then
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_VARCHAR2_TABLE_100();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_2000();
184: a5 := JTF_NUMBER_TABLE();
185: a6 := JTF_DATE_TABLE();

Line 182: a3 := JTF_VARCHAR2_TABLE_100();

178: if t is null or t.count = 0 then
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_VARCHAR2_TABLE_100();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_VARCHAR2_TABLE_2000();
184: a5 := JTF_NUMBER_TABLE();
185: a6 := JTF_DATE_TABLE();
186: a7 := JTF_NUMBER_TABLE();

Line 191: a1 := JTF_VARCHAR2_TABLE_100();

187: a8 := JTF_DATE_TABLE();
188: a9 := JTF_NUMBER_TABLE();
189: else
190: a0 := JTF_NUMBER_TABLE();
191: a1 := JTF_VARCHAR2_TABLE_100();
192: a2 := JTF_VARCHAR2_TABLE_100();
193: a3 := JTF_VARCHAR2_TABLE_100();
194: a4 := JTF_VARCHAR2_TABLE_2000();
195: a5 := JTF_NUMBER_TABLE();

Line 192: a2 := JTF_VARCHAR2_TABLE_100();

188: a9 := JTF_NUMBER_TABLE();
189: else
190: a0 := JTF_NUMBER_TABLE();
191: a1 := JTF_VARCHAR2_TABLE_100();
192: a2 := JTF_VARCHAR2_TABLE_100();
193: a3 := JTF_VARCHAR2_TABLE_100();
194: a4 := JTF_VARCHAR2_TABLE_2000();
195: a5 := JTF_NUMBER_TABLE();
196: a6 := JTF_DATE_TABLE();

Line 193: a3 := JTF_VARCHAR2_TABLE_100();

189: else
190: a0 := JTF_NUMBER_TABLE();
191: a1 := JTF_VARCHAR2_TABLE_100();
192: a2 := JTF_VARCHAR2_TABLE_100();
193: a3 := JTF_VARCHAR2_TABLE_100();
194: a4 := JTF_VARCHAR2_TABLE_2000();
195: a5 := JTF_NUMBER_TABLE();
196: a6 := JTF_DATE_TABLE();
197: a7 := JTF_NUMBER_TABLE();

Line 236: , a2 JTF_VARCHAR2_TABLE_100

232: end rosetta_table_copy_out_p5;
233:
234: procedure rosetta_table_copy_in_p8(t out nocopy okl_pmr_pvt.pmrv_tbl_type, a0 JTF_NUMBER_TABLE
235: , a1 JTF_NUMBER_TABLE
236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_VARCHAR2_TABLE_100
238: , a4 JTF_VARCHAR2_TABLE_200
239: , a5 JTF_VARCHAR2_TABLE_200
240: , a6 JTF_VARCHAR2_TABLE_2000

Line 237: , a3 JTF_VARCHAR2_TABLE_100

233:
234: procedure rosetta_table_copy_in_p8(t out nocopy okl_pmr_pvt.pmrv_tbl_type, a0 JTF_NUMBER_TABLE
235: , a1 JTF_NUMBER_TABLE
236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_VARCHAR2_TABLE_100
238: , a4 JTF_VARCHAR2_TABLE_200
239: , a5 JTF_VARCHAR2_TABLE_200
240: , a6 JTF_VARCHAR2_TABLE_2000
241: , a7 JTF_NUMBER_TABLE

Line 277: , a2 out nocopy JTF_VARCHAR2_TABLE_100

273: end if;
274: end rosetta_table_copy_in_p8;
275: procedure rosetta_table_copy_out_p8(t okl_pmr_pvt.pmrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
276: , a1 out nocopy JTF_NUMBER_TABLE
277: , a2 out nocopy JTF_VARCHAR2_TABLE_100
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
280: , a5 out nocopy JTF_VARCHAR2_TABLE_200
281: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 278: , a3 out nocopy JTF_VARCHAR2_TABLE_100

274: end rosetta_table_copy_in_p8;
275: procedure rosetta_table_copy_out_p8(t okl_pmr_pvt.pmrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
276: , a1 out nocopy JTF_NUMBER_TABLE
277: , a2 out nocopy JTF_VARCHAR2_TABLE_100
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
280: , a5 out nocopy JTF_VARCHAR2_TABLE_200
281: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
282: , a7 out nocopy JTF_NUMBER_TABLE

Line 293: a2 := JTF_VARCHAR2_TABLE_100();

289: begin
290: if t is null or t.count = 0 then
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_VARCHAR2_TABLE_100();
294: a3 := JTF_VARCHAR2_TABLE_100();
295: a4 := JTF_VARCHAR2_TABLE_200();
296: a5 := JTF_VARCHAR2_TABLE_200();
297: a6 := JTF_VARCHAR2_TABLE_2000();

Line 294: a3 := JTF_VARCHAR2_TABLE_100();

290: if t is null or t.count = 0 then
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_VARCHAR2_TABLE_100();
294: a3 := JTF_VARCHAR2_TABLE_100();
295: a4 := JTF_VARCHAR2_TABLE_200();
296: a5 := JTF_VARCHAR2_TABLE_200();
297: a6 := JTF_VARCHAR2_TABLE_2000();
298: a7 := JTF_NUMBER_TABLE();

Line 306: a2 := JTF_VARCHAR2_TABLE_100();

302: a11 := JTF_NUMBER_TABLE();
303: else
304: a0 := JTF_NUMBER_TABLE();
305: a1 := JTF_NUMBER_TABLE();
306: a2 := JTF_VARCHAR2_TABLE_100();
307: a3 := JTF_VARCHAR2_TABLE_100();
308: a4 := JTF_VARCHAR2_TABLE_200();
309: a5 := JTF_VARCHAR2_TABLE_200();
310: a6 := JTF_VARCHAR2_TABLE_2000();

Line 307: a3 := JTF_VARCHAR2_TABLE_100();

303: else
304: a0 := JTF_NUMBER_TABLE();
305: a1 := JTF_NUMBER_TABLE();
306: a2 := JTF_VARCHAR2_TABLE_100();
307: a3 := JTF_VARCHAR2_TABLE_100();
308: a4 := JTF_VARCHAR2_TABLE_200();
309: a5 := JTF_VARCHAR2_TABLE_200();
310: a6 := JTF_VARCHAR2_TABLE_2000();
311: a7 := JTF_NUMBER_TABLE();

Line 448: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 449: , p5_a3 JTF_VARCHAR2_TABLE_100

445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_NUMBER_TABLE
448: , p5_a2 JTF_VARCHAR2_TABLE_100
449: , p5_a3 JTF_VARCHAR2_TABLE_100
450: , p5_a4 JTF_VARCHAR2_TABLE_200
451: , p5_a5 JTF_VARCHAR2_TABLE_200
452: , p5_a6 JTF_VARCHAR2_TABLE_2000
453: , p5_a7 JTF_NUMBER_TABLE

Line 460: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

456: , p5_a10 JTF_DATE_TABLE
457: , p5_a11 JTF_NUMBER_TABLE
458: , p6_a0 out nocopy JTF_NUMBER_TABLE
459: , p6_a1 out nocopy JTF_NUMBER_TABLE
460: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
463: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
464: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 461: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

457: , p5_a11 JTF_NUMBER_TABLE
458: , p6_a0 out nocopy JTF_NUMBER_TABLE
459: , p6_a1 out nocopy JTF_NUMBER_TABLE
460: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
463: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
464: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
465: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 596: , p5_a2 JTF_VARCHAR2_TABLE_100

592: , x_msg_count out nocopy NUMBER
593: , x_msg_data out nocopy VARCHAR2
594: , p5_a0 JTF_NUMBER_TABLE
595: , p5_a1 JTF_NUMBER_TABLE
596: , p5_a2 JTF_VARCHAR2_TABLE_100
597: , p5_a3 JTF_VARCHAR2_TABLE_100
598: , p5_a4 JTF_VARCHAR2_TABLE_200
599: , p5_a5 JTF_VARCHAR2_TABLE_200
600: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 597: , p5_a3 JTF_VARCHAR2_TABLE_100

593: , x_msg_data out nocopy VARCHAR2
594: , p5_a0 JTF_NUMBER_TABLE
595: , p5_a1 JTF_NUMBER_TABLE
596: , p5_a2 JTF_VARCHAR2_TABLE_100
597: , p5_a3 JTF_VARCHAR2_TABLE_100
598: , p5_a4 JTF_VARCHAR2_TABLE_200
599: , p5_a5 JTF_VARCHAR2_TABLE_200
600: , p5_a6 JTF_VARCHAR2_TABLE_2000
601: , p5_a7 JTF_NUMBER_TABLE

Line 743: , p5_a2 JTF_VARCHAR2_TABLE_100

739: , x_msg_count out nocopy NUMBER
740: , x_msg_data out nocopy VARCHAR2
741: , p5_a0 JTF_NUMBER_TABLE
742: , p5_a1 JTF_NUMBER_TABLE
743: , p5_a2 JTF_VARCHAR2_TABLE_100
744: , p5_a3 JTF_VARCHAR2_TABLE_100
745: , p5_a4 JTF_VARCHAR2_TABLE_200
746: , p5_a5 JTF_VARCHAR2_TABLE_200
747: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 744: , p5_a3 JTF_VARCHAR2_TABLE_100

740: , x_msg_data out nocopy VARCHAR2
741: , p5_a0 JTF_NUMBER_TABLE
742: , p5_a1 JTF_NUMBER_TABLE
743: , p5_a2 JTF_VARCHAR2_TABLE_100
744: , p5_a3 JTF_VARCHAR2_TABLE_100
745: , p5_a4 JTF_VARCHAR2_TABLE_200
746: , p5_a5 JTF_VARCHAR2_TABLE_200
747: , p5_a6 JTF_VARCHAR2_TABLE_2000
748: , p5_a7 JTF_NUMBER_TABLE

Line 755: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

751: , p5_a10 JTF_DATE_TABLE
752: , p5_a11 JTF_NUMBER_TABLE
753: , p6_a0 out nocopy JTF_NUMBER_TABLE
754: , p6_a1 out nocopy JTF_NUMBER_TABLE
755: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
757: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
758: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
759: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 756: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

752: , p5_a11 JTF_NUMBER_TABLE
753: , p6_a0 out nocopy JTF_NUMBER_TABLE
754: , p6_a1 out nocopy JTF_NUMBER_TABLE
755: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
757: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
758: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
759: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
760: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 891: , p5_a2 JTF_VARCHAR2_TABLE_100

887: , x_msg_count out nocopy NUMBER
888: , x_msg_data out nocopy VARCHAR2
889: , p5_a0 JTF_NUMBER_TABLE
890: , p5_a1 JTF_NUMBER_TABLE
891: , p5_a2 JTF_VARCHAR2_TABLE_100
892: , p5_a3 JTF_VARCHAR2_TABLE_100
893: , p5_a4 JTF_VARCHAR2_TABLE_200
894: , p5_a5 JTF_VARCHAR2_TABLE_200
895: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 892: , p5_a3 JTF_VARCHAR2_TABLE_100

888: , x_msg_data out nocopy VARCHAR2
889: , p5_a0 JTF_NUMBER_TABLE
890: , p5_a1 JTF_NUMBER_TABLE
891: , p5_a2 JTF_VARCHAR2_TABLE_100
892: , p5_a3 JTF_VARCHAR2_TABLE_100
893: , p5_a4 JTF_VARCHAR2_TABLE_200
894: , p5_a5 JTF_VARCHAR2_TABLE_200
895: , p5_a6 JTF_VARCHAR2_TABLE_2000
896: , p5_a7 JTF_NUMBER_TABLE

Line 1010: , p5_a2 JTF_VARCHAR2_TABLE_100

1006: , x_msg_count out nocopy NUMBER
1007: , x_msg_data out nocopy VARCHAR2
1008: , p5_a0 JTF_NUMBER_TABLE
1009: , p5_a1 JTF_NUMBER_TABLE
1010: , p5_a2 JTF_VARCHAR2_TABLE_100
1011: , p5_a3 JTF_VARCHAR2_TABLE_100
1012: , p5_a4 JTF_VARCHAR2_TABLE_200
1013: , p5_a5 JTF_VARCHAR2_TABLE_200
1014: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 1011: , p5_a3 JTF_VARCHAR2_TABLE_100

1007: , x_msg_data out nocopy VARCHAR2
1008: , p5_a0 JTF_NUMBER_TABLE
1009: , p5_a1 JTF_NUMBER_TABLE
1010: , p5_a2 JTF_VARCHAR2_TABLE_100
1011: , p5_a3 JTF_VARCHAR2_TABLE_100
1012: , p5_a4 JTF_VARCHAR2_TABLE_200
1013: , p5_a5 JTF_VARCHAR2_TABLE_200
1014: , p5_a6 JTF_VARCHAR2_TABLE_2000
1015: , p5_a7 JTF_NUMBER_TABLE