DBA Data[Home] [Help]

APPS.OKL_QPY_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 38: , a16 JTF_VARCHAR2_TABLE_200

34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_600
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_200
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_200
42: ) as

Line 41: , a19 JTF_VARCHAR2_TABLE_200

37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_200
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_200
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if a0 is not null and a0.count > 0 then

Line 95: , a16 out nocopy JTF_VARCHAR2_TABLE_200

91: , a12 out nocopy JTF_NUMBER_TABLE
92: , a13 out nocopy JTF_VARCHAR2_TABLE_600
93: , a14 out nocopy JTF_VARCHAR2_TABLE_100
94: , a15 out nocopy JTF_VARCHAR2_TABLE_100
95: , a16 out nocopy JTF_VARCHAR2_TABLE_200
96: , a17 out nocopy JTF_VARCHAR2_TABLE_100
97: , a18 out nocopy JTF_VARCHAR2_TABLE_100
98: , a19 out nocopy JTF_VARCHAR2_TABLE_200
99: ) as

Line 98: , a19 out nocopy JTF_VARCHAR2_TABLE_200

94: , a15 out nocopy JTF_VARCHAR2_TABLE_100
95: , a16 out nocopy JTF_VARCHAR2_TABLE_200
96: , a17 out nocopy JTF_VARCHAR2_TABLE_100
97: , a18 out nocopy JTF_VARCHAR2_TABLE_100
98: , a19 out nocopy JTF_VARCHAR2_TABLE_200
99: ) as
100: ddindx binary_integer; indx binary_integer;
101: begin
102: if t is null or t.count = 0 then

Line 119: a16 := JTF_VARCHAR2_TABLE_200();

115: a12 := JTF_NUMBER_TABLE();
116: a13 := JTF_VARCHAR2_TABLE_600();
117: a14 := JTF_VARCHAR2_TABLE_100();
118: a15 := JTF_VARCHAR2_TABLE_100();
119: a16 := JTF_VARCHAR2_TABLE_200();
120: a17 := JTF_VARCHAR2_TABLE_100();
121: a18 := JTF_VARCHAR2_TABLE_100();
122: a19 := JTF_VARCHAR2_TABLE_200();
123: else

Line 122: a19 := JTF_VARCHAR2_TABLE_200();

118: a15 := JTF_VARCHAR2_TABLE_100();
119: a16 := JTF_VARCHAR2_TABLE_200();
120: a17 := JTF_VARCHAR2_TABLE_100();
121: a18 := JTF_VARCHAR2_TABLE_100();
122: a19 := JTF_VARCHAR2_TABLE_200();
123: else
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();

Line 140: a16 := JTF_VARCHAR2_TABLE_200();

136: a12 := JTF_NUMBER_TABLE();
137: a13 := JTF_VARCHAR2_TABLE_600();
138: a14 := JTF_VARCHAR2_TABLE_100();
139: a15 := JTF_VARCHAR2_TABLE_100();
140: a16 := JTF_VARCHAR2_TABLE_200();
141: a17 := JTF_VARCHAR2_TABLE_100();
142: a18 := JTF_VARCHAR2_TABLE_100();
143: a19 := JTF_VARCHAR2_TABLE_200();
144: if t.count > 0 then

Line 143: a19 := JTF_VARCHAR2_TABLE_200();

139: a15 := JTF_VARCHAR2_TABLE_100();
140: a16 := JTF_VARCHAR2_TABLE_200();
141: a17 := JTF_VARCHAR2_TABLE_100();
142: a18 := JTF_VARCHAR2_TABLE_100();
143: a19 := JTF_VARCHAR2_TABLE_200();
144: if t.count > 0 then
145: a0.extend(t.count);
146: a1.extend(t.count);
147: a2.extend(t.count);

Line 209: , a11 JTF_VARCHAR2_TABLE_200

205: , a7 JTF_NUMBER_TABLE
206: , a8 JTF_VARCHAR2_TABLE_600
207: , a9 JTF_VARCHAR2_TABLE_100
208: , a10 JTF_VARCHAR2_TABLE_100
209: , a11 JTF_VARCHAR2_TABLE_200
210: , a12 JTF_VARCHAR2_TABLE_100
211: , a13 JTF_VARCHAR2_TABLE_100
212: , a14 JTF_VARCHAR2_TABLE_200
213: , a15 JTF_NUMBER_TABLE

Line 212: , a14 JTF_VARCHAR2_TABLE_200

208: , a10 JTF_VARCHAR2_TABLE_100
209: , a11 JTF_VARCHAR2_TABLE_200
210: , a12 JTF_VARCHAR2_TABLE_100
211: , a13 JTF_VARCHAR2_TABLE_100
212: , a14 JTF_VARCHAR2_TABLE_200
213: , a15 JTF_NUMBER_TABLE
214: , a16 JTF_DATE_TABLE
215: , a17 JTF_NUMBER_TABLE
216: , a18 JTF_DATE_TABLE

Line 266: , a11 out nocopy JTF_VARCHAR2_TABLE_200

262: , a7 out nocopy JTF_NUMBER_TABLE
263: , a8 out nocopy JTF_VARCHAR2_TABLE_600
264: , a9 out nocopy JTF_VARCHAR2_TABLE_100
265: , a10 out nocopy JTF_VARCHAR2_TABLE_100
266: , a11 out nocopy JTF_VARCHAR2_TABLE_200
267: , a12 out nocopy JTF_VARCHAR2_TABLE_100
268: , a13 out nocopy JTF_VARCHAR2_TABLE_100
269: , a14 out nocopy JTF_VARCHAR2_TABLE_200
270: , a15 out nocopy JTF_NUMBER_TABLE

Line 269: , a14 out nocopy JTF_VARCHAR2_TABLE_200

265: , a10 out nocopy JTF_VARCHAR2_TABLE_100
266: , a11 out nocopy JTF_VARCHAR2_TABLE_200
267: , a12 out nocopy JTF_VARCHAR2_TABLE_100
268: , a13 out nocopy JTF_VARCHAR2_TABLE_100
269: , a14 out nocopy JTF_VARCHAR2_TABLE_200
270: , a15 out nocopy JTF_NUMBER_TABLE
271: , a16 out nocopy JTF_DATE_TABLE
272: , a17 out nocopy JTF_NUMBER_TABLE
273: , a18 out nocopy JTF_DATE_TABLE

Line 290: a11 := JTF_VARCHAR2_TABLE_200();

286: a7 := JTF_NUMBER_TABLE();
287: a8 := JTF_VARCHAR2_TABLE_600();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_200();
291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_200();
294: a15 := JTF_NUMBER_TABLE();

Line 293: a14 := JTF_VARCHAR2_TABLE_200();

289: a10 := JTF_VARCHAR2_TABLE_100();
290: a11 := JTF_VARCHAR2_TABLE_200();
291: a12 := JTF_VARCHAR2_TABLE_100();
292: a13 := JTF_VARCHAR2_TABLE_100();
293: a14 := JTF_VARCHAR2_TABLE_200();
294: a15 := JTF_NUMBER_TABLE();
295: a16 := JTF_DATE_TABLE();
296: a17 := JTF_NUMBER_TABLE();
297: a18 := JTF_DATE_TABLE();

Line 311: a11 := JTF_VARCHAR2_TABLE_200();

307: a7 := JTF_NUMBER_TABLE();
308: a8 := JTF_VARCHAR2_TABLE_600();
309: a9 := JTF_VARCHAR2_TABLE_100();
310: a10 := JTF_VARCHAR2_TABLE_100();
311: a11 := JTF_VARCHAR2_TABLE_200();
312: a12 := JTF_VARCHAR2_TABLE_100();
313: a13 := JTF_VARCHAR2_TABLE_100();
314: a14 := JTF_VARCHAR2_TABLE_200();
315: a15 := JTF_NUMBER_TABLE();

Line 314: a14 := JTF_VARCHAR2_TABLE_200();

310: a10 := JTF_VARCHAR2_TABLE_100();
311: a11 := JTF_VARCHAR2_TABLE_200();
312: a12 := JTF_VARCHAR2_TABLE_100();
313: a13 := JTF_VARCHAR2_TABLE_100();
314: a14 := JTF_VARCHAR2_TABLE_200();
315: a15 := JTF_NUMBER_TABLE();
316: a16 := JTF_DATE_TABLE();
317: a17 := JTF_NUMBER_TABLE();
318: a18 := JTF_DATE_TABLE();

Line 509: , p5_a11 JTF_VARCHAR2_TABLE_200

505: , p5_a7 JTF_NUMBER_TABLE
506: , p5_a8 JTF_VARCHAR2_TABLE_600
507: , p5_a9 JTF_VARCHAR2_TABLE_100
508: , p5_a10 JTF_VARCHAR2_TABLE_100
509: , p5_a11 JTF_VARCHAR2_TABLE_200
510: , p5_a12 JTF_VARCHAR2_TABLE_100
511: , p5_a13 JTF_VARCHAR2_TABLE_100
512: , p5_a14 JTF_VARCHAR2_TABLE_200
513: , p5_a15 JTF_NUMBER_TABLE

Line 512: , p5_a14 JTF_VARCHAR2_TABLE_200

508: , p5_a10 JTF_VARCHAR2_TABLE_100
509: , p5_a11 JTF_VARCHAR2_TABLE_200
510: , p5_a12 JTF_VARCHAR2_TABLE_100
511: , p5_a13 JTF_VARCHAR2_TABLE_100
512: , p5_a14 JTF_VARCHAR2_TABLE_200
513: , p5_a15 JTF_NUMBER_TABLE
514: , p5_a16 JTF_DATE_TABLE
515: , p5_a17 JTF_NUMBER_TABLE
516: , p5_a18 JTF_DATE_TABLE

Line 529: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200

525: , p6_a7 out nocopy JTF_NUMBER_TABLE
526: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
527: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
528: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
530: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
531: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
532: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
533: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 532: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200

528: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
530: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
531: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
532: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
533: , p6_a15 out nocopy JTF_NUMBER_TABLE
534: , p6_a16 out nocopy JTF_DATE_TABLE
535: , p6_a17 out nocopy JTF_NUMBER_TABLE
536: , p6_a18 out nocopy JTF_DATE_TABLE

Line 705: , p5_a11 JTF_VARCHAR2_TABLE_200

701: , p5_a7 JTF_NUMBER_TABLE
702: , p5_a8 JTF_VARCHAR2_TABLE_600
703: , p5_a9 JTF_VARCHAR2_TABLE_100
704: , p5_a10 JTF_VARCHAR2_TABLE_100
705: , p5_a11 JTF_VARCHAR2_TABLE_200
706: , p5_a12 JTF_VARCHAR2_TABLE_100
707: , p5_a13 JTF_VARCHAR2_TABLE_100
708: , p5_a14 JTF_VARCHAR2_TABLE_200
709: , p5_a15 JTF_NUMBER_TABLE

Line 708: , p5_a14 JTF_VARCHAR2_TABLE_200

704: , p5_a10 JTF_VARCHAR2_TABLE_100
705: , p5_a11 JTF_VARCHAR2_TABLE_200
706: , p5_a12 JTF_VARCHAR2_TABLE_100
707: , p5_a13 JTF_VARCHAR2_TABLE_100
708: , p5_a14 JTF_VARCHAR2_TABLE_200
709: , p5_a15 JTF_NUMBER_TABLE
710: , p5_a16 JTF_DATE_TABLE
711: , p5_a17 JTF_NUMBER_TABLE
712: , p5_a18 JTF_DATE_TABLE

Line 900: , p5_a11 JTF_VARCHAR2_TABLE_200

896: , p5_a7 JTF_NUMBER_TABLE
897: , p5_a8 JTF_VARCHAR2_TABLE_600
898: , p5_a9 JTF_VARCHAR2_TABLE_100
899: , p5_a10 JTF_VARCHAR2_TABLE_100
900: , p5_a11 JTF_VARCHAR2_TABLE_200
901: , p5_a12 JTF_VARCHAR2_TABLE_100
902: , p5_a13 JTF_VARCHAR2_TABLE_100
903: , p5_a14 JTF_VARCHAR2_TABLE_200
904: , p5_a15 JTF_NUMBER_TABLE

Line 903: , p5_a14 JTF_VARCHAR2_TABLE_200

899: , p5_a10 JTF_VARCHAR2_TABLE_100
900: , p5_a11 JTF_VARCHAR2_TABLE_200
901: , p5_a12 JTF_VARCHAR2_TABLE_100
902: , p5_a13 JTF_VARCHAR2_TABLE_100
903: , p5_a14 JTF_VARCHAR2_TABLE_200
904: , p5_a15 JTF_NUMBER_TABLE
905: , p5_a16 JTF_DATE_TABLE
906: , p5_a17 JTF_NUMBER_TABLE
907: , p5_a18 JTF_DATE_TABLE

Line 920: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200

916: , p6_a7 out nocopy JTF_NUMBER_TABLE
917: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
918: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
919: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
920: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
921: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
923: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
924: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 923: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200

919: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
920: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
921: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
923: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
924: , p6_a15 out nocopy JTF_NUMBER_TABLE
925: , p6_a16 out nocopy JTF_DATE_TABLE
926: , p6_a17 out nocopy JTF_NUMBER_TABLE
927: , p6_a18 out nocopy JTF_DATE_TABLE

Line 1096: , p5_a11 JTF_VARCHAR2_TABLE_200

1092: , p5_a7 JTF_NUMBER_TABLE
1093: , p5_a8 JTF_VARCHAR2_TABLE_600
1094: , p5_a9 JTF_VARCHAR2_TABLE_100
1095: , p5_a10 JTF_VARCHAR2_TABLE_100
1096: , p5_a11 JTF_VARCHAR2_TABLE_200
1097: , p5_a12 JTF_VARCHAR2_TABLE_100
1098: , p5_a13 JTF_VARCHAR2_TABLE_100
1099: , p5_a14 JTF_VARCHAR2_TABLE_200
1100: , p5_a15 JTF_NUMBER_TABLE

Line 1099: , p5_a14 JTF_VARCHAR2_TABLE_200

1095: , p5_a10 JTF_VARCHAR2_TABLE_100
1096: , p5_a11 JTF_VARCHAR2_TABLE_200
1097: , p5_a12 JTF_VARCHAR2_TABLE_100
1098: , p5_a13 JTF_VARCHAR2_TABLE_100
1099: , p5_a14 JTF_VARCHAR2_TABLE_200
1100: , p5_a15 JTF_NUMBER_TABLE
1101: , p5_a16 JTF_DATE_TABLE
1102: , p5_a17 JTF_NUMBER_TABLE
1103: , p5_a18 JTF_DATE_TABLE

Line 1247: , p5_a11 JTF_VARCHAR2_TABLE_200

1243: , p5_a7 JTF_NUMBER_TABLE
1244: , p5_a8 JTF_VARCHAR2_TABLE_600
1245: , p5_a9 JTF_VARCHAR2_TABLE_100
1246: , p5_a10 JTF_VARCHAR2_TABLE_100
1247: , p5_a11 JTF_VARCHAR2_TABLE_200
1248: , p5_a12 JTF_VARCHAR2_TABLE_100
1249: , p5_a13 JTF_VARCHAR2_TABLE_100
1250: , p5_a14 JTF_VARCHAR2_TABLE_200
1251: , p5_a15 JTF_NUMBER_TABLE

Line 1250: , p5_a14 JTF_VARCHAR2_TABLE_200

1246: , p5_a10 JTF_VARCHAR2_TABLE_100
1247: , p5_a11 JTF_VARCHAR2_TABLE_200
1248: , p5_a12 JTF_VARCHAR2_TABLE_100
1249: , p5_a13 JTF_VARCHAR2_TABLE_100
1250: , p5_a14 JTF_VARCHAR2_TABLE_200
1251: , p5_a15 JTF_NUMBER_TABLE
1252: , p5_a16 JTF_DATE_TABLE
1253: , p5_a17 JTF_NUMBER_TABLE
1254: , p5_a18 JTF_DATE_TABLE