DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 26: , a10 JTF_VARCHAR2_TABLE_300

22: , a6 JTF_DATE_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_300
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_300
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100

Line 28: , a12 JTF_VARCHAR2_TABLE_300

24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_300
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_300
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100

Line 81: , a65 JTF_VARCHAR2_TABLE_300

77: , a61 JTF_VARCHAR2_TABLE_200
78: , a62 JTF_VARCHAR2_TABLE_200
79: , a63 JTF_VARCHAR2_TABLE_100
80: , a64 JTF_VARCHAR2_TABLE_100
81: , a65 JTF_VARCHAR2_TABLE_300
82: , a66 JTF_VARCHAR2_TABLE_100
83: , a67 JTF_NUMBER_TABLE
84: , a68 JTF_VARCHAR2_TABLE_100
85: , a69 JTF_VARCHAR2_TABLE_100

Line 92: , a76 JTF_VARCHAR2_TABLE_300

88: , a72 JTF_VARCHAR2_TABLE_100
89: , a73 JTF_NUMBER_TABLE
90: , a74 JTF_VARCHAR2_TABLE_100
91: , a75 JTF_VARCHAR2_TABLE_100
92: , a76 JTF_VARCHAR2_TABLE_300
93: , a77 JTF_NUMBER_TABLE
94: ) as
95: ddindx binary_integer; indx binary_integer;
96: begin

Line 199: , a10 out nocopy JTF_VARCHAR2_TABLE_300

195: , a6 out nocopy JTF_DATE_TABLE
196: , a7 out nocopy JTF_NUMBER_TABLE
197: , a8 out nocopy JTF_NUMBER_TABLE
198: , a9 out nocopy JTF_NUMBER_TABLE
199: , a10 out nocopy JTF_VARCHAR2_TABLE_300
200: , a11 out nocopy JTF_NUMBER_TABLE
201: , a12 out nocopy JTF_VARCHAR2_TABLE_300
202: , a13 out nocopy JTF_NUMBER_TABLE
203: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: , a12 out nocopy JTF_VARCHAR2_TABLE_300

197: , a8 out nocopy JTF_NUMBER_TABLE
198: , a9 out nocopy JTF_NUMBER_TABLE
199: , a10 out nocopy JTF_VARCHAR2_TABLE_300
200: , a11 out nocopy JTF_NUMBER_TABLE
201: , a12 out nocopy JTF_VARCHAR2_TABLE_300
202: , a13 out nocopy JTF_NUMBER_TABLE
203: , a14 out nocopy JTF_VARCHAR2_TABLE_100
204: , a15 out nocopy JTF_VARCHAR2_TABLE_100
205: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 254: , a65 out nocopy JTF_VARCHAR2_TABLE_300

250: , a61 out nocopy JTF_VARCHAR2_TABLE_200
251: , a62 out nocopy JTF_VARCHAR2_TABLE_200
252: , a63 out nocopy JTF_VARCHAR2_TABLE_100
253: , a64 out nocopy JTF_VARCHAR2_TABLE_100
254: , a65 out nocopy JTF_VARCHAR2_TABLE_300
255: , a66 out nocopy JTF_VARCHAR2_TABLE_100
256: , a67 out nocopy JTF_NUMBER_TABLE
257: , a68 out nocopy JTF_VARCHAR2_TABLE_100
258: , a69 out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , a76 out nocopy JTF_VARCHAR2_TABLE_300

261: , a72 out nocopy JTF_VARCHAR2_TABLE_100
262: , a73 out nocopy JTF_NUMBER_TABLE
263: , a74 out nocopy JTF_VARCHAR2_TABLE_100
264: , a75 out nocopy JTF_VARCHAR2_TABLE_100
265: , a76 out nocopy JTF_VARCHAR2_TABLE_300
266: , a77 out nocopy JTF_NUMBER_TABLE
267: ) as
268: ddindx binary_integer; indx binary_integer;
269: begin

Line 281: a10 := JTF_VARCHAR2_TABLE_300();

277: a6 := JTF_DATE_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_NUMBER_TABLE();
280: a9 := JTF_NUMBER_TABLE();
281: a10 := JTF_VARCHAR2_TABLE_300();
282: a11 := JTF_NUMBER_TABLE();
283: a12 := JTF_VARCHAR2_TABLE_300();
284: a13 := JTF_NUMBER_TABLE();
285: a14 := JTF_VARCHAR2_TABLE_100();

Line 283: a12 := JTF_VARCHAR2_TABLE_300();

279: a8 := JTF_NUMBER_TABLE();
280: a9 := JTF_NUMBER_TABLE();
281: a10 := JTF_VARCHAR2_TABLE_300();
282: a11 := JTF_NUMBER_TABLE();
283: a12 := JTF_VARCHAR2_TABLE_300();
284: a13 := JTF_NUMBER_TABLE();
285: a14 := JTF_VARCHAR2_TABLE_100();
286: a15 := JTF_VARCHAR2_TABLE_100();
287: a16 := JTF_VARCHAR2_TABLE_100();

Line 336: a65 := JTF_VARCHAR2_TABLE_300();

332: a61 := JTF_VARCHAR2_TABLE_200();
333: a62 := JTF_VARCHAR2_TABLE_200();
334: a63 := JTF_VARCHAR2_TABLE_100();
335: a64 := JTF_VARCHAR2_TABLE_100();
336: a65 := JTF_VARCHAR2_TABLE_300();
337: a66 := JTF_VARCHAR2_TABLE_100();
338: a67 := JTF_NUMBER_TABLE();
339: a68 := JTF_VARCHAR2_TABLE_100();
340: a69 := JTF_VARCHAR2_TABLE_100();

Line 347: a76 := JTF_VARCHAR2_TABLE_300();

343: a72 := JTF_VARCHAR2_TABLE_100();
344: a73 := JTF_NUMBER_TABLE();
345: a74 := JTF_VARCHAR2_TABLE_100();
346: a75 := JTF_VARCHAR2_TABLE_100();
347: a76 := JTF_VARCHAR2_TABLE_300();
348: a77 := JTF_NUMBER_TABLE();
349: else
350: a0 := JTF_NUMBER_TABLE();
351: a1 := JTF_VARCHAR2_TABLE_100();

Line 360: a10 := JTF_VARCHAR2_TABLE_300();

356: a6 := JTF_DATE_TABLE();
357: a7 := JTF_NUMBER_TABLE();
358: a8 := JTF_NUMBER_TABLE();
359: a9 := JTF_NUMBER_TABLE();
360: a10 := JTF_VARCHAR2_TABLE_300();
361: a11 := JTF_NUMBER_TABLE();
362: a12 := JTF_VARCHAR2_TABLE_300();
363: a13 := JTF_NUMBER_TABLE();
364: a14 := JTF_VARCHAR2_TABLE_100();

Line 362: a12 := JTF_VARCHAR2_TABLE_300();

358: a8 := JTF_NUMBER_TABLE();
359: a9 := JTF_NUMBER_TABLE();
360: a10 := JTF_VARCHAR2_TABLE_300();
361: a11 := JTF_NUMBER_TABLE();
362: a12 := JTF_VARCHAR2_TABLE_300();
363: a13 := JTF_NUMBER_TABLE();
364: a14 := JTF_VARCHAR2_TABLE_100();
365: a15 := JTF_VARCHAR2_TABLE_100();
366: a16 := JTF_VARCHAR2_TABLE_100();

Line 415: a65 := JTF_VARCHAR2_TABLE_300();

411: a61 := JTF_VARCHAR2_TABLE_200();
412: a62 := JTF_VARCHAR2_TABLE_200();
413: a63 := JTF_VARCHAR2_TABLE_100();
414: a64 := JTF_VARCHAR2_TABLE_100();
415: a65 := JTF_VARCHAR2_TABLE_300();
416: a66 := JTF_VARCHAR2_TABLE_100();
417: a67 := JTF_NUMBER_TABLE();
418: a68 := JTF_VARCHAR2_TABLE_100();
419: a69 := JTF_VARCHAR2_TABLE_100();

Line 426: a76 := JTF_VARCHAR2_TABLE_300();

422: a72 := JTF_VARCHAR2_TABLE_100();
423: a73 := JTF_NUMBER_TABLE();
424: a74 := JTF_VARCHAR2_TABLE_100();
425: a75 := JTF_VARCHAR2_TABLE_100();
426: a76 := JTF_VARCHAR2_TABLE_300();
427: a77 := JTF_NUMBER_TABLE();
428: if t.count > 0 then
429: a0.extend(t.count);
430: a1.extend(t.count);

Line 705: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300

701: , p5_a6 in out nocopy JTF_DATE_TABLE
702: , p5_a7 in out nocopy JTF_NUMBER_TABLE
703: , p5_a8 in out nocopy JTF_NUMBER_TABLE
704: , p5_a9 in out nocopy JTF_NUMBER_TABLE
705: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
706: , p5_a11 in out nocopy JTF_NUMBER_TABLE
707: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
708: , p5_a13 in out nocopy JTF_NUMBER_TABLE
709: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 707: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300

703: , p5_a8 in out nocopy JTF_NUMBER_TABLE
704: , p5_a9 in out nocopy JTF_NUMBER_TABLE
705: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
706: , p5_a11 in out nocopy JTF_NUMBER_TABLE
707: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
708: , p5_a13 in out nocopy JTF_NUMBER_TABLE
709: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
710: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
711: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 760: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_300

756: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_200
757: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_200
758: , p5_a63 in out nocopy JTF_VARCHAR2_TABLE_100
759: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_100
760: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_300
761: , p5_a66 in out nocopy JTF_VARCHAR2_TABLE_100
762: , p5_a67 in out nocopy JTF_NUMBER_TABLE
763: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
764: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100

Line 771: , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_300

767: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
768: , p5_a73 in out nocopy JTF_NUMBER_TABLE
769: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
770: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
771: , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_300
772: , p5_a77 in out nocopy JTF_NUMBER_TABLE
773: , x_return_status out nocopy VARCHAR2
774: , x_msg_count out nocopy NUMBER
775: , x_msg_data out nocopy VARCHAR2