DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 166: , a15 JTF_VARCHAR2_TABLE_300

162: , a11 JTF_NUMBER_TABLE
163: , a12 JTF_VARCHAR2_TABLE_100
164: , a13 JTF_NUMBER_TABLE
165: , a14 JTF_NUMBER_TABLE
166: , a15 JTF_VARCHAR2_TABLE_300
167: , a16 JTF_NUMBER_TABLE
168: , a17 JTF_VARCHAR2_TABLE_100
169: , a18 JTF_NUMBER_TABLE
170: , a19 JTF_NUMBER_TABLE

Line 215: , a64 JTF_VARCHAR2_TABLE_300

211: , a60 JTF_NUMBER_TABLE
212: , a61 JTF_NUMBER_TABLE
213: , a62 JTF_VARCHAR2_TABLE_100
214: , a63 JTF_NUMBER_TABLE
215: , a64 JTF_VARCHAR2_TABLE_300
216: , a65 JTF_VARCHAR2_TABLE_100
217: , a66 JTF_DATE_TABLE
218: , a67 JTF_DATE_TABLE
219: , a68 JTF_VARCHAR2_TABLE_100

Line 245: , a94 JTF_VARCHAR2_TABLE_300

241: , a90 JTF_VARCHAR2_TABLE_100
242: , a91 JTF_VARCHAR2_TABLE_100
243: , a92 JTF_VARCHAR2_TABLE_100
244: , a93 JTF_NUMBER_TABLE
245: , a94 JTF_VARCHAR2_TABLE_300
246: ) as
247: ddindx binary_integer; indx binary_integer;
248: begin
249: if a0 is not null and a0.count > 0 then

Line 373: , a15 out nocopy JTF_VARCHAR2_TABLE_300

369: , a11 out nocopy JTF_NUMBER_TABLE
370: , a12 out nocopy JTF_VARCHAR2_TABLE_100
371: , a13 out nocopy JTF_NUMBER_TABLE
372: , a14 out nocopy JTF_NUMBER_TABLE
373: , a15 out nocopy JTF_VARCHAR2_TABLE_300
374: , a16 out nocopy JTF_NUMBER_TABLE
375: , a17 out nocopy JTF_VARCHAR2_TABLE_100
376: , a18 out nocopy JTF_NUMBER_TABLE
377: , a19 out nocopy JTF_NUMBER_TABLE

Line 422: , a64 out nocopy JTF_VARCHAR2_TABLE_300

418: , a60 out nocopy JTF_NUMBER_TABLE
419: , a61 out nocopy JTF_NUMBER_TABLE
420: , a62 out nocopy JTF_VARCHAR2_TABLE_100
421: , a63 out nocopy JTF_NUMBER_TABLE
422: , a64 out nocopy JTF_VARCHAR2_TABLE_300
423: , a65 out nocopy JTF_VARCHAR2_TABLE_100
424: , a66 out nocopy JTF_DATE_TABLE
425: , a67 out nocopy JTF_DATE_TABLE
426: , a68 out nocopy JTF_VARCHAR2_TABLE_100

Line 452: , a94 out nocopy JTF_VARCHAR2_TABLE_300

448: , a90 out nocopy JTF_VARCHAR2_TABLE_100
449: , a91 out nocopy JTF_VARCHAR2_TABLE_100
450: , a92 out nocopy JTF_VARCHAR2_TABLE_100
451: , a93 out nocopy JTF_NUMBER_TABLE
452: , a94 out nocopy JTF_VARCHAR2_TABLE_300
453: ) as
454: ddindx binary_integer; indx binary_integer;
455: begin
456: if t is null or t.count = 0 then

Line 472: a15 := JTF_VARCHAR2_TABLE_300();

468: a11 := JTF_NUMBER_TABLE();
469: a12 := JTF_VARCHAR2_TABLE_100();
470: a13 := JTF_NUMBER_TABLE();
471: a14 := JTF_NUMBER_TABLE();
472: a15 := JTF_VARCHAR2_TABLE_300();
473: a16 := JTF_NUMBER_TABLE();
474: a17 := JTF_VARCHAR2_TABLE_100();
475: a18 := JTF_NUMBER_TABLE();
476: a19 := JTF_NUMBER_TABLE();

Line 521: a64 := JTF_VARCHAR2_TABLE_300();

517: a60 := JTF_NUMBER_TABLE();
518: a61 := JTF_NUMBER_TABLE();
519: a62 := JTF_VARCHAR2_TABLE_100();
520: a63 := JTF_NUMBER_TABLE();
521: a64 := JTF_VARCHAR2_TABLE_300();
522: a65 := JTF_VARCHAR2_TABLE_100();
523: a66 := JTF_DATE_TABLE();
524: a67 := JTF_DATE_TABLE();
525: a68 := JTF_VARCHAR2_TABLE_100();

Line 551: a94 := JTF_VARCHAR2_TABLE_300();

547: a90 := JTF_VARCHAR2_TABLE_100();
548: a91 := JTF_VARCHAR2_TABLE_100();
549: a92 := JTF_VARCHAR2_TABLE_100();
550: a93 := JTF_NUMBER_TABLE();
551: a94 := JTF_VARCHAR2_TABLE_300();
552: else
553: a0 := JTF_NUMBER_TABLE();
554: a1 := JTF_NUMBER_TABLE();
555: a2 := JTF_NUMBER_TABLE();

Line 568: a15 := JTF_VARCHAR2_TABLE_300();

564: a11 := JTF_NUMBER_TABLE();
565: a12 := JTF_VARCHAR2_TABLE_100();
566: a13 := JTF_NUMBER_TABLE();
567: a14 := JTF_NUMBER_TABLE();
568: a15 := JTF_VARCHAR2_TABLE_300();
569: a16 := JTF_NUMBER_TABLE();
570: a17 := JTF_VARCHAR2_TABLE_100();
571: a18 := JTF_NUMBER_TABLE();
572: a19 := JTF_NUMBER_TABLE();

Line 617: a64 := JTF_VARCHAR2_TABLE_300();

613: a60 := JTF_NUMBER_TABLE();
614: a61 := JTF_NUMBER_TABLE();
615: a62 := JTF_VARCHAR2_TABLE_100();
616: a63 := JTF_NUMBER_TABLE();
617: a64 := JTF_VARCHAR2_TABLE_300();
618: a65 := JTF_VARCHAR2_TABLE_100();
619: a66 := JTF_DATE_TABLE();
620: a67 := JTF_DATE_TABLE();
621: a68 := JTF_VARCHAR2_TABLE_100();

Line 647: a94 := JTF_VARCHAR2_TABLE_300();

643: a90 := JTF_VARCHAR2_TABLE_100();
644: a91 := JTF_VARCHAR2_TABLE_100();
645: a92 := JTF_VARCHAR2_TABLE_100();
646: a93 := JTF_NUMBER_TABLE();
647: a94 := JTF_VARCHAR2_TABLE_300();
648: if t.count > 0 then
649: a0.extend(t.count);
650: a1.extend(t.count);
651: a2.extend(t.count);

Line 1832: , p5_a15 JTF_VARCHAR2_TABLE_300

1828: , p5_a11 JTF_NUMBER_TABLE
1829: , p5_a12 JTF_VARCHAR2_TABLE_100
1830: , p5_a13 JTF_NUMBER_TABLE
1831: , p5_a14 JTF_NUMBER_TABLE
1832: , p5_a15 JTF_VARCHAR2_TABLE_300
1833: , p5_a16 JTF_NUMBER_TABLE
1834: , p5_a17 JTF_VARCHAR2_TABLE_100
1835: , p5_a18 JTF_NUMBER_TABLE
1836: , p5_a19 JTF_NUMBER_TABLE

Line 1881: , p5_a64 JTF_VARCHAR2_TABLE_300

1877: , p5_a60 JTF_NUMBER_TABLE
1878: , p5_a61 JTF_NUMBER_TABLE
1879: , p5_a62 JTF_VARCHAR2_TABLE_100
1880: , p5_a63 JTF_NUMBER_TABLE
1881: , p5_a64 JTF_VARCHAR2_TABLE_300
1882: , p5_a65 JTF_VARCHAR2_TABLE_100
1883: , p5_a66 JTF_DATE_TABLE
1884: , p5_a67 JTF_DATE_TABLE
1885: , p5_a68 JTF_VARCHAR2_TABLE_100

Line 1911: , p5_a94 JTF_VARCHAR2_TABLE_300

1907: , p5_a90 JTF_VARCHAR2_TABLE_100
1908: , p5_a91 JTF_VARCHAR2_TABLE_100
1909: , p5_a92 JTF_VARCHAR2_TABLE_100
1910: , p5_a93 JTF_NUMBER_TABLE
1911: , p5_a94 JTF_VARCHAR2_TABLE_300
1912: , x_return_status out nocopy VARCHAR2
1913: , x_msg_count out nocopy NUMBER
1914: , x_msg_data out nocopy VARCHAR2
1915: )

Line 2069: , p4_a15 JTF_VARCHAR2_TABLE_300

2065: , p4_a11 JTF_NUMBER_TABLE
2066: , p4_a12 JTF_VARCHAR2_TABLE_100
2067: , p4_a13 JTF_NUMBER_TABLE
2068: , p4_a14 JTF_NUMBER_TABLE
2069: , p4_a15 JTF_VARCHAR2_TABLE_300
2070: , p4_a16 JTF_NUMBER_TABLE
2071: , p4_a17 JTF_VARCHAR2_TABLE_100
2072: , p4_a18 JTF_NUMBER_TABLE
2073: , p4_a19 JTF_NUMBER_TABLE

Line 2118: , p4_a64 JTF_VARCHAR2_TABLE_300

2114: , p4_a60 JTF_NUMBER_TABLE
2115: , p4_a61 JTF_NUMBER_TABLE
2116: , p4_a62 JTF_VARCHAR2_TABLE_100
2117: , p4_a63 JTF_NUMBER_TABLE
2118: , p4_a64 JTF_VARCHAR2_TABLE_300
2119: , p4_a65 JTF_VARCHAR2_TABLE_100
2120: , p4_a66 JTF_DATE_TABLE
2121: , p4_a67 JTF_DATE_TABLE
2122: , p4_a68 JTF_VARCHAR2_TABLE_100

Line 2148: , p4_a94 JTF_VARCHAR2_TABLE_300

2144: , p4_a90 JTF_VARCHAR2_TABLE_100
2145: , p4_a91 JTF_VARCHAR2_TABLE_100
2146: , p4_a92 JTF_VARCHAR2_TABLE_100
2147: , p4_a93 JTF_NUMBER_TABLE
2148: , p4_a94 JTF_VARCHAR2_TABLE_300
2149: , x_return_status out nocopy VARCHAR2
2150: , x_msg_count out nocopy NUMBER
2151: , x_msg_data out nocopy VARCHAR2
2152: )

Line 2303: , p4_a15 JTF_VARCHAR2_TABLE_300

2299: , p4_a11 JTF_NUMBER_TABLE
2300: , p4_a12 JTF_VARCHAR2_TABLE_100
2301: , p4_a13 JTF_NUMBER_TABLE
2302: , p4_a14 JTF_NUMBER_TABLE
2303: , p4_a15 JTF_VARCHAR2_TABLE_300
2304: , p4_a16 JTF_NUMBER_TABLE
2305: , p4_a17 JTF_VARCHAR2_TABLE_100
2306: , p4_a18 JTF_NUMBER_TABLE
2307: , p4_a19 JTF_NUMBER_TABLE

Line 2352: , p4_a64 JTF_VARCHAR2_TABLE_300

2348: , p4_a60 JTF_NUMBER_TABLE
2349: , p4_a61 JTF_NUMBER_TABLE
2350: , p4_a62 JTF_VARCHAR2_TABLE_100
2351: , p4_a63 JTF_NUMBER_TABLE
2352: , p4_a64 JTF_VARCHAR2_TABLE_300
2353: , p4_a65 JTF_VARCHAR2_TABLE_100
2354: , p4_a66 JTF_DATE_TABLE
2355: , p4_a67 JTF_DATE_TABLE
2356: , p4_a68 JTF_VARCHAR2_TABLE_100

Line 2382: , p4_a94 JTF_VARCHAR2_TABLE_300

2378: , p4_a90 JTF_VARCHAR2_TABLE_100
2379: , p4_a91 JTF_VARCHAR2_TABLE_100
2380: , p4_a92 JTF_VARCHAR2_TABLE_100
2381: , p4_a93 JTF_NUMBER_TABLE
2382: , p4_a94 JTF_VARCHAR2_TABLE_300
2383: , x_return_status out nocopy VARCHAR2
2384: , x_msg_count out nocopy NUMBER
2385: , x_msg_data out nocopy VARCHAR2
2386: )

Line 2537: , p4_a15 JTF_VARCHAR2_TABLE_300

2533: , p4_a11 JTF_NUMBER_TABLE
2534: , p4_a12 JTF_VARCHAR2_TABLE_100
2535: , p4_a13 JTF_NUMBER_TABLE
2536: , p4_a14 JTF_NUMBER_TABLE
2537: , p4_a15 JTF_VARCHAR2_TABLE_300
2538: , p4_a16 JTF_NUMBER_TABLE
2539: , p4_a17 JTF_VARCHAR2_TABLE_100
2540: , p4_a18 JTF_NUMBER_TABLE
2541: , p4_a19 JTF_NUMBER_TABLE

Line 2586: , p4_a64 JTF_VARCHAR2_TABLE_300

2582: , p4_a60 JTF_NUMBER_TABLE
2583: , p4_a61 JTF_NUMBER_TABLE
2584: , p4_a62 JTF_VARCHAR2_TABLE_100
2585: , p4_a63 JTF_NUMBER_TABLE
2586: , p4_a64 JTF_VARCHAR2_TABLE_300
2587: , p4_a65 JTF_VARCHAR2_TABLE_100
2588: , p4_a66 JTF_DATE_TABLE
2589: , p4_a67 JTF_DATE_TABLE
2590: , p4_a68 JTF_VARCHAR2_TABLE_100

Line 2616: , p4_a94 JTF_VARCHAR2_TABLE_300

2612: , p4_a90 JTF_VARCHAR2_TABLE_100
2613: , p4_a91 JTF_VARCHAR2_TABLE_100
2614: , p4_a92 JTF_VARCHAR2_TABLE_100
2615: , p4_a93 JTF_NUMBER_TABLE
2616: , p4_a94 JTF_VARCHAR2_TABLE_300
2617: , x_return_status out nocopy VARCHAR2
2618: , x_msg_count out nocopy NUMBER
2619: , x_msg_data out nocopy VARCHAR2
2620: )

Line 2773: , p6_a15 JTF_VARCHAR2_TABLE_300

2769: , p6_a11 JTF_NUMBER_TABLE
2770: , p6_a12 JTF_VARCHAR2_TABLE_100
2771: , p6_a13 JTF_NUMBER_TABLE
2772: , p6_a14 JTF_NUMBER_TABLE
2773: , p6_a15 JTF_VARCHAR2_TABLE_300
2774: , p6_a16 JTF_NUMBER_TABLE
2775: , p6_a17 JTF_VARCHAR2_TABLE_100
2776: , p6_a18 JTF_NUMBER_TABLE
2777: , p6_a19 JTF_NUMBER_TABLE

Line 2822: , p6_a64 JTF_VARCHAR2_TABLE_300

2818: , p6_a60 JTF_NUMBER_TABLE
2819: , p6_a61 JTF_NUMBER_TABLE
2820: , p6_a62 JTF_VARCHAR2_TABLE_100
2821: , p6_a63 JTF_NUMBER_TABLE
2822: , p6_a64 JTF_VARCHAR2_TABLE_300
2823: , p6_a65 JTF_VARCHAR2_TABLE_100
2824: , p6_a66 JTF_DATE_TABLE
2825: , p6_a67 JTF_DATE_TABLE
2826: , p6_a68 JTF_VARCHAR2_TABLE_100

Line 2852: , p6_a94 JTF_VARCHAR2_TABLE_300

2848: , p6_a90 JTF_VARCHAR2_TABLE_100
2849: , p6_a91 JTF_VARCHAR2_TABLE_100
2850: , p6_a92 JTF_VARCHAR2_TABLE_100
2851: , p6_a93 JTF_NUMBER_TABLE
2852: , p6_a94 JTF_VARCHAR2_TABLE_300
2853: , x_return_status out nocopy VARCHAR2
2854: , x_msg_count out nocopy NUMBER
2855: , x_msg_data out nocopy VARCHAR2
2856: )

Line 3014: , p5_a15 JTF_VARCHAR2_TABLE_300

3010: , p5_a11 JTF_NUMBER_TABLE
3011: , p5_a12 JTF_VARCHAR2_TABLE_100
3012: , p5_a13 JTF_NUMBER_TABLE
3013: , p5_a14 JTF_NUMBER_TABLE
3014: , p5_a15 JTF_VARCHAR2_TABLE_300
3015: , p5_a16 JTF_NUMBER_TABLE
3016: , p5_a17 JTF_VARCHAR2_TABLE_100
3017: , p5_a18 JTF_NUMBER_TABLE
3018: , p5_a19 JTF_NUMBER_TABLE

Line 3063: , p5_a64 JTF_VARCHAR2_TABLE_300

3059: , p5_a60 JTF_NUMBER_TABLE
3060: , p5_a61 JTF_NUMBER_TABLE
3061: , p5_a62 JTF_VARCHAR2_TABLE_100
3062: , p5_a63 JTF_NUMBER_TABLE
3063: , p5_a64 JTF_VARCHAR2_TABLE_300
3064: , p5_a65 JTF_VARCHAR2_TABLE_100
3065: , p5_a66 JTF_DATE_TABLE
3066: , p5_a67 JTF_DATE_TABLE
3067: , p5_a68 JTF_VARCHAR2_TABLE_100

Line 3093: , p5_a94 JTF_VARCHAR2_TABLE_300

3089: , p5_a90 JTF_VARCHAR2_TABLE_100
3090: , p5_a91 JTF_VARCHAR2_TABLE_100
3091: , p5_a92 JTF_VARCHAR2_TABLE_100
3092: , p5_a93 JTF_NUMBER_TABLE
3093: , p5_a94 JTF_VARCHAR2_TABLE_300
3094: , x_return_status out nocopy VARCHAR2
3095: , x_msg_count out nocopy NUMBER
3096: , x_msg_data out nocopy VARCHAR2
3097: )

Line 3252: , p5_a15 JTF_VARCHAR2_TABLE_300

3248: , p5_a11 JTF_NUMBER_TABLE
3249: , p5_a12 JTF_VARCHAR2_TABLE_100
3250: , p5_a13 JTF_NUMBER_TABLE
3251: , p5_a14 JTF_NUMBER_TABLE
3252: , p5_a15 JTF_VARCHAR2_TABLE_300
3253: , p5_a16 JTF_NUMBER_TABLE
3254: , p5_a17 JTF_VARCHAR2_TABLE_100
3255: , p5_a18 JTF_NUMBER_TABLE
3256: , p5_a19 JTF_NUMBER_TABLE

Line 3301: , p5_a64 JTF_VARCHAR2_TABLE_300

3297: , p5_a60 JTF_NUMBER_TABLE
3298: , p5_a61 JTF_NUMBER_TABLE
3299: , p5_a62 JTF_VARCHAR2_TABLE_100
3300: , p5_a63 JTF_NUMBER_TABLE
3301: , p5_a64 JTF_VARCHAR2_TABLE_300
3302: , p5_a65 JTF_VARCHAR2_TABLE_100
3303: , p5_a66 JTF_DATE_TABLE
3304: , p5_a67 JTF_DATE_TABLE
3305: , p5_a68 JTF_VARCHAR2_TABLE_100

Line 3331: , p5_a94 JTF_VARCHAR2_TABLE_300

3327: , p5_a90 JTF_VARCHAR2_TABLE_100
3328: , p5_a91 JTF_VARCHAR2_TABLE_100
3329: , p5_a92 JTF_VARCHAR2_TABLE_100
3330: , p5_a93 JTF_NUMBER_TABLE
3331: , p5_a94 JTF_VARCHAR2_TABLE_300
3332: , x_return_status out nocopy VARCHAR2
3333: , x_msg_count out nocopy NUMBER
3334: , x_msg_data out nocopy VARCHAR2
3335: )