DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_ASSIGN_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 21: , a8 JTF_VARCHAR2_TABLE_100

17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100

Line 25: , a12 JTF_VARCHAR2_TABLE_100

21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_300
27: , a14 JTF_NUMBER_TABLE
28: , a15 JTF_NUMBER_TABLE
29: , a16 JTF_VARCHAR2_TABLE_100

Line 29: , a16 JTF_VARCHAR2_TABLE_100

25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_300
27: , a14 JTF_NUMBER_TABLE
28: , a15 JTF_NUMBER_TABLE
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_NUMBER_TABLE
31: , a18 JTF_DATE_TABLE
32: , a19 JTF_NUMBER_TABLE
33: , a20 JTF_NUMBER_TABLE

Line 37: , a24 JTF_VARCHAR2_TABLE_100

33: , a20 JTF_NUMBER_TABLE
34: , a21 JTF_DATE_TABLE
35: , a22 JTF_NUMBER_TABLE
36: , a23 JTF_NUMBER_TABLE
37: , a24 JTF_VARCHAR2_TABLE_100
38: , a25 JTF_DATE_TABLE
39: , a26 JTF_NUMBER_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_NUMBER_TABLE

Line 46: , a33 JTF_VARCHAR2_TABLE_100

42: , a29 JTF_DATE_TABLE
43: , a30 JTF_NUMBER_TABLE
44: , a31 JTF_DATE_TABLE
45: , a32 JTF_NUMBER_TABLE
46: , a33 JTF_VARCHAR2_TABLE_100
47: , a34 JTF_VARCHAR2_TABLE_200
48: , a35 JTF_VARCHAR2_TABLE_200
49: , a36 JTF_VARCHAR2_TABLE_200
50: , a37 JTF_VARCHAR2_TABLE_200

Line 62: , a49 JTF_VARCHAR2_TABLE_100

58: , a45 JTF_VARCHAR2_TABLE_200
59: , a46 JTF_VARCHAR2_TABLE_200
60: , a47 JTF_VARCHAR2_TABLE_200
61: , a48 JTF_VARCHAR2_TABLE_200
62: , a49 JTF_VARCHAR2_TABLE_100
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if a0 is not null and a0.count > 0 then

Line 138: , a8 out nocopy JTF_VARCHAR2_TABLE_100

134: , a4 out nocopy JTF_NUMBER_TABLE
135: , a5 out nocopy JTF_NUMBER_TABLE
136: , a6 out nocopy JTF_NUMBER_TABLE
137: , a7 out nocopy JTF_NUMBER_TABLE
138: , a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , a9 out nocopy JTF_NUMBER_TABLE
140: , a10 out nocopy JTF_NUMBER_TABLE
141: , a11 out nocopy JTF_NUMBER_TABLE
142: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 142: , a12 out nocopy JTF_VARCHAR2_TABLE_100

138: , a8 out nocopy JTF_VARCHAR2_TABLE_100
139: , a9 out nocopy JTF_NUMBER_TABLE
140: , a10 out nocopy JTF_NUMBER_TABLE
141: , a11 out nocopy JTF_NUMBER_TABLE
142: , a12 out nocopy JTF_VARCHAR2_TABLE_100
143: , a13 out nocopy JTF_VARCHAR2_TABLE_300
144: , a14 out nocopy JTF_NUMBER_TABLE
145: , a15 out nocopy JTF_NUMBER_TABLE
146: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 146: , a16 out nocopy JTF_VARCHAR2_TABLE_100

142: , a12 out nocopy JTF_VARCHAR2_TABLE_100
143: , a13 out nocopy JTF_VARCHAR2_TABLE_300
144: , a14 out nocopy JTF_NUMBER_TABLE
145: , a15 out nocopy JTF_NUMBER_TABLE
146: , a16 out nocopy JTF_VARCHAR2_TABLE_100
147: , a17 out nocopy JTF_NUMBER_TABLE
148: , a18 out nocopy JTF_DATE_TABLE
149: , a19 out nocopy JTF_NUMBER_TABLE
150: , a20 out nocopy JTF_NUMBER_TABLE

Line 154: , a24 out nocopy JTF_VARCHAR2_TABLE_100

150: , a20 out nocopy JTF_NUMBER_TABLE
151: , a21 out nocopy JTF_DATE_TABLE
152: , a22 out nocopy JTF_NUMBER_TABLE
153: , a23 out nocopy JTF_NUMBER_TABLE
154: , a24 out nocopy JTF_VARCHAR2_TABLE_100
155: , a25 out nocopy JTF_DATE_TABLE
156: , a26 out nocopy JTF_NUMBER_TABLE
157: , a27 out nocopy JTF_NUMBER_TABLE
158: , a28 out nocopy JTF_NUMBER_TABLE

Line 163: , a33 out nocopy JTF_VARCHAR2_TABLE_100

159: , a29 out nocopy JTF_DATE_TABLE
160: , a30 out nocopy JTF_NUMBER_TABLE
161: , a31 out nocopy JTF_DATE_TABLE
162: , a32 out nocopy JTF_NUMBER_TABLE
163: , a33 out nocopy JTF_VARCHAR2_TABLE_100
164: , a34 out nocopy JTF_VARCHAR2_TABLE_200
165: , a35 out nocopy JTF_VARCHAR2_TABLE_200
166: , a36 out nocopy JTF_VARCHAR2_TABLE_200
167: , a37 out nocopy JTF_VARCHAR2_TABLE_200

Line 179: , a49 out nocopy JTF_VARCHAR2_TABLE_100

175: , a45 out nocopy JTF_VARCHAR2_TABLE_200
176: , a46 out nocopy JTF_VARCHAR2_TABLE_200
177: , a47 out nocopy JTF_VARCHAR2_TABLE_200
178: , a48 out nocopy JTF_VARCHAR2_TABLE_200
179: , a49 out nocopy JTF_VARCHAR2_TABLE_100
180: ) as
181: ddindx binary_integer; indx binary_integer;
182: begin
183: if t is null or t.count = 0 then

Line 192: a8 := JTF_VARCHAR2_TABLE_100();

188: a4 := JTF_NUMBER_TABLE();
189: a5 := JTF_NUMBER_TABLE();
190: a6 := JTF_NUMBER_TABLE();
191: a7 := JTF_NUMBER_TABLE();
192: a8 := JTF_VARCHAR2_TABLE_100();
193: a9 := JTF_NUMBER_TABLE();
194: a10 := JTF_NUMBER_TABLE();
195: a11 := JTF_NUMBER_TABLE();
196: a12 := JTF_VARCHAR2_TABLE_100();

Line 196: a12 := JTF_VARCHAR2_TABLE_100();

192: a8 := JTF_VARCHAR2_TABLE_100();
193: a9 := JTF_NUMBER_TABLE();
194: a10 := JTF_NUMBER_TABLE();
195: a11 := JTF_NUMBER_TABLE();
196: a12 := JTF_VARCHAR2_TABLE_100();
197: a13 := JTF_VARCHAR2_TABLE_300();
198: a14 := JTF_NUMBER_TABLE();
199: a15 := JTF_NUMBER_TABLE();
200: a16 := JTF_VARCHAR2_TABLE_100();

Line 200: a16 := JTF_VARCHAR2_TABLE_100();

196: a12 := JTF_VARCHAR2_TABLE_100();
197: a13 := JTF_VARCHAR2_TABLE_300();
198: a14 := JTF_NUMBER_TABLE();
199: a15 := JTF_NUMBER_TABLE();
200: a16 := JTF_VARCHAR2_TABLE_100();
201: a17 := JTF_NUMBER_TABLE();
202: a18 := JTF_DATE_TABLE();
203: a19 := JTF_NUMBER_TABLE();
204: a20 := JTF_NUMBER_TABLE();

Line 208: a24 := JTF_VARCHAR2_TABLE_100();

204: a20 := JTF_NUMBER_TABLE();
205: a21 := JTF_DATE_TABLE();
206: a22 := JTF_NUMBER_TABLE();
207: a23 := JTF_NUMBER_TABLE();
208: a24 := JTF_VARCHAR2_TABLE_100();
209: a25 := JTF_DATE_TABLE();
210: a26 := JTF_NUMBER_TABLE();
211: a27 := JTF_NUMBER_TABLE();
212: a28 := JTF_NUMBER_TABLE();

Line 217: a33 := JTF_VARCHAR2_TABLE_100();

213: a29 := JTF_DATE_TABLE();
214: a30 := JTF_NUMBER_TABLE();
215: a31 := JTF_DATE_TABLE();
216: a32 := JTF_NUMBER_TABLE();
217: a33 := JTF_VARCHAR2_TABLE_100();
218: a34 := JTF_VARCHAR2_TABLE_200();
219: a35 := JTF_VARCHAR2_TABLE_200();
220: a36 := JTF_VARCHAR2_TABLE_200();
221: a37 := JTF_VARCHAR2_TABLE_200();

Line 233: a49 := JTF_VARCHAR2_TABLE_100();

229: a45 := JTF_VARCHAR2_TABLE_200();
230: a46 := JTF_VARCHAR2_TABLE_200();
231: a47 := JTF_VARCHAR2_TABLE_200();
232: a48 := JTF_VARCHAR2_TABLE_200();
233: a49 := JTF_VARCHAR2_TABLE_100();
234: else
235: a0 := JTF_NUMBER_TABLE();
236: a1 := JTF_NUMBER_TABLE();
237: a2 := JTF_NUMBER_TABLE();

Line 243: a8 := JTF_VARCHAR2_TABLE_100();

239: a4 := JTF_NUMBER_TABLE();
240: a5 := JTF_NUMBER_TABLE();
241: a6 := JTF_NUMBER_TABLE();
242: a7 := JTF_NUMBER_TABLE();
243: a8 := JTF_VARCHAR2_TABLE_100();
244: a9 := JTF_NUMBER_TABLE();
245: a10 := JTF_NUMBER_TABLE();
246: a11 := JTF_NUMBER_TABLE();
247: a12 := JTF_VARCHAR2_TABLE_100();

Line 247: a12 := JTF_VARCHAR2_TABLE_100();

243: a8 := JTF_VARCHAR2_TABLE_100();
244: a9 := JTF_NUMBER_TABLE();
245: a10 := JTF_NUMBER_TABLE();
246: a11 := JTF_NUMBER_TABLE();
247: a12 := JTF_VARCHAR2_TABLE_100();
248: a13 := JTF_VARCHAR2_TABLE_300();
249: a14 := JTF_NUMBER_TABLE();
250: a15 := JTF_NUMBER_TABLE();
251: a16 := JTF_VARCHAR2_TABLE_100();

Line 251: a16 := JTF_VARCHAR2_TABLE_100();

247: a12 := JTF_VARCHAR2_TABLE_100();
248: a13 := JTF_VARCHAR2_TABLE_300();
249: a14 := JTF_NUMBER_TABLE();
250: a15 := JTF_NUMBER_TABLE();
251: a16 := JTF_VARCHAR2_TABLE_100();
252: a17 := JTF_NUMBER_TABLE();
253: a18 := JTF_DATE_TABLE();
254: a19 := JTF_NUMBER_TABLE();
255: a20 := JTF_NUMBER_TABLE();

Line 259: a24 := JTF_VARCHAR2_TABLE_100();

255: a20 := JTF_NUMBER_TABLE();
256: a21 := JTF_DATE_TABLE();
257: a22 := JTF_NUMBER_TABLE();
258: a23 := JTF_NUMBER_TABLE();
259: a24 := JTF_VARCHAR2_TABLE_100();
260: a25 := JTF_DATE_TABLE();
261: a26 := JTF_NUMBER_TABLE();
262: a27 := JTF_NUMBER_TABLE();
263: a28 := JTF_NUMBER_TABLE();

Line 268: a33 := JTF_VARCHAR2_TABLE_100();

264: a29 := JTF_DATE_TABLE();
265: a30 := JTF_NUMBER_TABLE();
266: a31 := JTF_DATE_TABLE();
267: a32 := JTF_NUMBER_TABLE();
268: a33 := JTF_VARCHAR2_TABLE_100();
269: a34 := JTF_VARCHAR2_TABLE_200();
270: a35 := JTF_VARCHAR2_TABLE_200();
271: a36 := JTF_VARCHAR2_TABLE_200();
272: a37 := JTF_VARCHAR2_TABLE_200();

Line 284: a49 := JTF_VARCHAR2_TABLE_100();

280: a45 := JTF_VARCHAR2_TABLE_200();
281: a46 := JTF_VARCHAR2_TABLE_200();
282: a47 := JTF_VARCHAR2_TABLE_200();
283: a48 := JTF_VARCHAR2_TABLE_200();
284: a49 := JTF_VARCHAR2_TABLE_100();
285: if t.count > 0 then
286: a0.extend(t.count);
287: a1.extend(t.count);
288: a2.extend(t.count);

Line 413: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100

409: , p6_a4 in out nocopy JTF_NUMBER_TABLE
410: , p6_a5 in out nocopy JTF_NUMBER_TABLE
411: , p6_a6 in out nocopy JTF_NUMBER_TABLE
412: , p6_a7 in out nocopy JTF_NUMBER_TABLE
413: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a9 in out nocopy JTF_NUMBER_TABLE
415: , p6_a10 in out nocopy JTF_NUMBER_TABLE
416: , p6_a11 in out nocopy JTF_NUMBER_TABLE
417: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 417: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100

413: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a9 in out nocopy JTF_NUMBER_TABLE
415: , p6_a10 in out nocopy JTF_NUMBER_TABLE
416: , p6_a11 in out nocopy JTF_NUMBER_TABLE
417: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
418: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_300
419: , p6_a14 in out nocopy JTF_NUMBER_TABLE
420: , p6_a15 in out nocopy JTF_NUMBER_TABLE
421: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 421: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100

417: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
418: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_300
419: , p6_a14 in out nocopy JTF_NUMBER_TABLE
420: , p6_a15 in out nocopy JTF_NUMBER_TABLE
421: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a17 in out nocopy JTF_NUMBER_TABLE
423: , p6_a18 in out nocopy JTF_DATE_TABLE
424: , p6_a19 in out nocopy JTF_NUMBER_TABLE
425: , p6_a20 in out nocopy JTF_NUMBER_TABLE

Line 429: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_100

425: , p6_a20 in out nocopy JTF_NUMBER_TABLE
426: , p6_a21 in out nocopy JTF_DATE_TABLE
427: , p6_a22 in out nocopy JTF_NUMBER_TABLE
428: , p6_a23 in out nocopy JTF_NUMBER_TABLE
429: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a25 in out nocopy JTF_DATE_TABLE
431: , p6_a26 in out nocopy JTF_NUMBER_TABLE
432: , p6_a27 in out nocopy JTF_NUMBER_TABLE
433: , p6_a28 in out nocopy JTF_NUMBER_TABLE

Line 438: , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100

434: , p6_a29 in out nocopy JTF_DATE_TABLE
435: , p6_a30 in out nocopy JTF_NUMBER_TABLE
436: , p6_a31 in out nocopy JTF_DATE_TABLE
437: , p6_a32 in out nocopy JTF_NUMBER_TABLE
438: , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100
439: , p6_a34 in out nocopy JTF_VARCHAR2_TABLE_200
440: , p6_a35 in out nocopy JTF_VARCHAR2_TABLE_200
441: , p6_a36 in out nocopy JTF_VARCHAR2_TABLE_200
442: , p6_a37 in out nocopy JTF_VARCHAR2_TABLE_200

Line 454: , p6_a49 in out nocopy JTF_VARCHAR2_TABLE_100

450: , p6_a45 in out nocopy JTF_VARCHAR2_TABLE_200
451: , p6_a46 in out nocopy JTF_VARCHAR2_TABLE_200
452: , p6_a47 in out nocopy JTF_VARCHAR2_TABLE_200
453: , p6_a48 in out nocopy JTF_VARCHAR2_TABLE_200
454: , p6_a49 in out nocopy JTF_VARCHAR2_TABLE_100
455: , x_return_status out nocopy VARCHAR2
456: , x_msg_count out nocopy NUMBER
457: , x_msg_data out nocopy VARCHAR2
458: )