APPS.HZ_PARTY_SEARCH_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 109: procedure rosetta_table_copy_in_p7(t out nocopy hz_party_search.txlist, a0 JTF_VARCHAR2_TABLE_2000);

105:
106: procedure rosetta_table_copy_in_p6(t out nocopy hz_party_search.idlist, a0 JTF_NUMBER_TABLE);
107: procedure rosetta_table_copy_out_p6(t hz_party_search.idlist, a0 out nocopy JTF_NUMBER_TABLE);
108:
109: procedure rosetta_table_copy_in_p7(t out nocopy hz_party_search.txlist, a0 JTF_VARCHAR2_TABLE_2000);
110: procedure rosetta_table_copy_out_p7(t hz_party_search.txlist, a0 out nocopy JTF_VARCHAR2_TABLE_2000);
111:
112: procedure rosetta_table_copy_in_p8(t out nocopy hz_party_search.party_site_list, a0 JTF_VARCHAR2_TABLE_4000
113: , a1 JTF_VARCHAR2_TABLE_4000

Line 110: procedure rosetta_table_copy_out_p7(t hz_party_search.txlist, a0 out nocopy JTF_VARCHAR2_TABLE_2000);

106: procedure rosetta_table_copy_in_p6(t out nocopy hz_party_search.idlist, a0 JTF_NUMBER_TABLE);
107: procedure rosetta_table_copy_out_p6(t hz_party_search.idlist, a0 out nocopy JTF_NUMBER_TABLE);
108:
109: procedure rosetta_table_copy_in_p7(t out nocopy hz_party_search.txlist, a0 JTF_VARCHAR2_TABLE_2000);
110: procedure rosetta_table_copy_out_p7(t hz_party_search.txlist, a0 out nocopy JTF_VARCHAR2_TABLE_2000);
111:
112: procedure rosetta_table_copy_in_p8(t out nocopy hz_party_search.party_site_list, a0 JTF_VARCHAR2_TABLE_4000
113: , a1 JTF_VARCHAR2_TABLE_4000
114: , a2 JTF_VARCHAR2_TABLE_4000

Line 429: , a41 JTF_VARCHAR2_TABLE_2000

425: , a37 JTF_VARCHAR2_TABLE_100
426: , a38 JTF_VARCHAR2_TABLE_100
427: , a39 JTF_NUMBER_TABLE
428: , a40 JTF_VARCHAR2_TABLE_100
429: , a41 JTF_VARCHAR2_TABLE_2000
430: , a42 JTF_VARCHAR2_TABLE_100
431: , a43 JTF_VARCHAR2_TABLE_4000
432: , a44 JTF_DATE_TABLE
433: , a45 JTF_VARCHAR2_TABLE_100

Line 440: , a52 JTF_VARCHAR2_TABLE_2000

436: , a48 JTF_VARCHAR2_TABLE_100
437: , a49 JTF_VARCHAR2_TABLE_100
438: , a50 JTF_VARCHAR2_TABLE_100
439: , a51 JTF_VARCHAR2_TABLE_100
440: , a52 JTF_VARCHAR2_TABLE_2000
441: , a53 JTF_VARCHAR2_TABLE_100
442: , a54 JTF_VARCHAR2_TABLE_100
443: , a55 JTF_NUMBER_TABLE
444: , a56 JTF_VARCHAR2_TABLE_2000

Line 444: , a56 JTF_VARCHAR2_TABLE_2000

440: , a52 JTF_VARCHAR2_TABLE_2000
441: , a53 JTF_VARCHAR2_TABLE_100
442: , a54 JTF_VARCHAR2_TABLE_100
443: , a55 JTF_NUMBER_TABLE
444: , a56 JTF_VARCHAR2_TABLE_2000
445: , a57 JTF_VARCHAR2_TABLE_100
446: , a58 JTF_VARCHAR2_TABLE_100
447: , a59 JTF_VARCHAR2_TABLE_100
448: );

Line 490: , a41 out nocopy JTF_VARCHAR2_TABLE_2000

486: , a37 out nocopy JTF_VARCHAR2_TABLE_100
487: , a38 out nocopy JTF_VARCHAR2_TABLE_100
488: , a39 out nocopy JTF_NUMBER_TABLE
489: , a40 out nocopy JTF_VARCHAR2_TABLE_100
490: , a41 out nocopy JTF_VARCHAR2_TABLE_2000
491: , a42 out nocopy JTF_VARCHAR2_TABLE_100
492: , a43 out nocopy JTF_VARCHAR2_TABLE_4000
493: , a44 out nocopy JTF_DATE_TABLE
494: , a45 out nocopy JTF_VARCHAR2_TABLE_100

Line 501: , a52 out nocopy JTF_VARCHAR2_TABLE_2000

497: , a48 out nocopy JTF_VARCHAR2_TABLE_100
498: , a49 out nocopy JTF_VARCHAR2_TABLE_100
499: , a50 out nocopy JTF_VARCHAR2_TABLE_100
500: , a51 out nocopy JTF_VARCHAR2_TABLE_100
501: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
502: , a53 out nocopy JTF_VARCHAR2_TABLE_100
503: , a54 out nocopy JTF_VARCHAR2_TABLE_100
504: , a55 out nocopy JTF_NUMBER_TABLE
505: , a56 out nocopy JTF_VARCHAR2_TABLE_2000

Line 505: , a56 out nocopy JTF_VARCHAR2_TABLE_2000

501: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
502: , a53 out nocopy JTF_VARCHAR2_TABLE_100
503: , a54 out nocopy JTF_VARCHAR2_TABLE_100
504: , a55 out nocopy JTF_NUMBER_TABLE
505: , a56 out nocopy JTF_VARCHAR2_TABLE_2000
506: , a57 out nocopy JTF_VARCHAR2_TABLE_100
507: , a58 out nocopy JTF_VARCHAR2_TABLE_100
508: , a59 out nocopy JTF_VARCHAR2_TABLE_100
509: );

Line 899: , p5_a41 JTF_VARCHAR2_TABLE_2000

895: , p5_a37 JTF_VARCHAR2_TABLE_100
896: , p5_a38 JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_NUMBER_TABLE
898: , p5_a40 JTF_VARCHAR2_TABLE_100
899: , p5_a41 JTF_VARCHAR2_TABLE_2000
900: , p5_a42 JTF_VARCHAR2_TABLE_100
901: , p5_a43 JTF_VARCHAR2_TABLE_4000
902: , p5_a44 JTF_DATE_TABLE
903: , p5_a45 JTF_VARCHAR2_TABLE_100

Line 910: , p5_a52 JTF_VARCHAR2_TABLE_2000

906: , p5_a48 JTF_VARCHAR2_TABLE_100
907: , p5_a49 JTF_VARCHAR2_TABLE_100
908: , p5_a50 JTF_VARCHAR2_TABLE_100
909: , p5_a51 JTF_VARCHAR2_TABLE_100
910: , p5_a52 JTF_VARCHAR2_TABLE_2000
911: , p5_a53 JTF_VARCHAR2_TABLE_100
912: , p5_a54 JTF_VARCHAR2_TABLE_100
913: , p5_a55 JTF_NUMBER_TABLE
914: , p5_a56 JTF_VARCHAR2_TABLE_2000

Line 914: , p5_a56 JTF_VARCHAR2_TABLE_2000

910: , p5_a52 JTF_VARCHAR2_TABLE_2000
911: , p5_a53 JTF_VARCHAR2_TABLE_100
912: , p5_a54 JTF_VARCHAR2_TABLE_100
913: , p5_a55 JTF_NUMBER_TABLE
914: , p5_a56 JTF_VARCHAR2_TABLE_2000
915: , p5_a57 JTF_VARCHAR2_TABLE_100
916: , p5_a58 JTF_VARCHAR2_TABLE_100
917: , p5_a59 JTF_VARCHAR2_TABLE_100
918: , p_restrict_sql VARCHAR2

Line 1294: , p5_a41 JTF_VARCHAR2_TABLE_2000

1290: , p5_a37 JTF_VARCHAR2_TABLE_100
1291: , p5_a38 JTF_VARCHAR2_TABLE_100
1292: , p5_a39 JTF_NUMBER_TABLE
1293: , p5_a40 JTF_VARCHAR2_TABLE_100
1294: , p5_a41 JTF_VARCHAR2_TABLE_2000
1295: , p5_a42 JTF_VARCHAR2_TABLE_100
1296: , p5_a43 JTF_VARCHAR2_TABLE_4000
1297: , p5_a44 JTF_DATE_TABLE
1298: , p5_a45 JTF_VARCHAR2_TABLE_100

Line 1305: , p5_a52 JTF_VARCHAR2_TABLE_2000

1301: , p5_a48 JTF_VARCHAR2_TABLE_100
1302: , p5_a49 JTF_VARCHAR2_TABLE_100
1303: , p5_a50 JTF_VARCHAR2_TABLE_100
1304: , p5_a51 JTF_VARCHAR2_TABLE_100
1305: , p5_a52 JTF_VARCHAR2_TABLE_2000
1306: , p5_a53 JTF_VARCHAR2_TABLE_100
1307: , p5_a54 JTF_VARCHAR2_TABLE_100
1308: , p5_a55 JTF_NUMBER_TABLE
1309: , p5_a56 JTF_VARCHAR2_TABLE_2000

Line 1309: , p5_a56 JTF_VARCHAR2_TABLE_2000

1305: , p5_a52 JTF_VARCHAR2_TABLE_2000
1306: , p5_a53 JTF_VARCHAR2_TABLE_100
1307: , p5_a54 JTF_VARCHAR2_TABLE_100
1308: , p5_a55 JTF_NUMBER_TABLE
1309: , p5_a56 JTF_VARCHAR2_TABLE_2000
1310: , p5_a57 JTF_VARCHAR2_TABLE_100
1311: , p5_a58 JTF_VARCHAR2_TABLE_100
1312: , p5_a59 JTF_VARCHAR2_TABLE_100
1313: , p_restrict_sql VARCHAR2

Line 1688: , p5_a41 JTF_VARCHAR2_TABLE_2000

1684: , p5_a37 JTF_VARCHAR2_TABLE_100
1685: , p5_a38 JTF_VARCHAR2_TABLE_100
1686: , p5_a39 JTF_NUMBER_TABLE
1687: , p5_a40 JTF_VARCHAR2_TABLE_100
1688: , p5_a41 JTF_VARCHAR2_TABLE_2000
1689: , p5_a42 JTF_VARCHAR2_TABLE_100
1690: , p5_a43 JTF_VARCHAR2_TABLE_4000
1691: , p5_a44 JTF_DATE_TABLE
1692: , p5_a45 JTF_VARCHAR2_TABLE_100

Line 1699: , p5_a52 JTF_VARCHAR2_TABLE_2000

1695: , p5_a48 JTF_VARCHAR2_TABLE_100
1696: , p5_a49 JTF_VARCHAR2_TABLE_100
1697: , p5_a50 JTF_VARCHAR2_TABLE_100
1698: , p5_a51 JTF_VARCHAR2_TABLE_100
1699: , p5_a52 JTF_VARCHAR2_TABLE_2000
1700: , p5_a53 JTF_VARCHAR2_TABLE_100
1701: , p5_a54 JTF_VARCHAR2_TABLE_100
1702: , p5_a55 JTF_NUMBER_TABLE
1703: , p5_a56 JTF_VARCHAR2_TABLE_2000

Line 1703: , p5_a56 JTF_VARCHAR2_TABLE_2000

1699: , p5_a52 JTF_VARCHAR2_TABLE_2000
1700: , p5_a53 JTF_VARCHAR2_TABLE_100
1701: , p5_a54 JTF_VARCHAR2_TABLE_100
1702: , p5_a55 JTF_NUMBER_TABLE
1703: , p5_a56 JTF_VARCHAR2_TABLE_2000
1704: , p5_a57 JTF_VARCHAR2_TABLE_100
1705: , p5_a58 JTF_VARCHAR2_TABLE_100
1706: , p5_a59 JTF_VARCHAR2_TABLE_100
1707: , p_restrict_sql VARCHAR2

Line 1825: , p4_a41 JTF_VARCHAR2_TABLE_2000

1821: , p4_a37 JTF_VARCHAR2_TABLE_100
1822: , p4_a38 JTF_VARCHAR2_TABLE_100
1823: , p4_a39 JTF_NUMBER_TABLE
1824: , p4_a40 JTF_VARCHAR2_TABLE_100
1825: , p4_a41 JTF_VARCHAR2_TABLE_2000
1826: , p4_a42 JTF_VARCHAR2_TABLE_100
1827: , p4_a43 JTF_VARCHAR2_TABLE_4000
1828: , p4_a44 JTF_DATE_TABLE
1829: , p4_a45 JTF_VARCHAR2_TABLE_100

Line 1836: , p4_a52 JTF_VARCHAR2_TABLE_2000

1832: , p4_a48 JTF_VARCHAR2_TABLE_100
1833: , p4_a49 JTF_VARCHAR2_TABLE_100
1834: , p4_a50 JTF_VARCHAR2_TABLE_100
1835: , p4_a51 JTF_VARCHAR2_TABLE_100
1836: , p4_a52 JTF_VARCHAR2_TABLE_2000
1837: , p4_a53 JTF_VARCHAR2_TABLE_100
1838: , p4_a54 JTF_VARCHAR2_TABLE_100
1839: , p4_a55 JTF_NUMBER_TABLE
1840: , p4_a56 JTF_VARCHAR2_TABLE_2000

Line 1840: , p4_a56 JTF_VARCHAR2_TABLE_2000

1836: , p4_a52 JTF_VARCHAR2_TABLE_2000
1837: , p4_a53 JTF_VARCHAR2_TABLE_100
1838: , p4_a54 JTF_VARCHAR2_TABLE_100
1839: , p4_a55 JTF_NUMBER_TABLE
1840: , p4_a56 JTF_VARCHAR2_TABLE_2000
1841: , p4_a57 JTF_VARCHAR2_TABLE_100
1842: , p4_a58 JTF_VARCHAR2_TABLE_100
1843: , p4_a59 JTF_VARCHAR2_TABLE_100
1844: , p_restrict_sql VARCHAR2

Line 1962: , p4_a41 JTF_VARCHAR2_TABLE_2000

1958: , p4_a37 JTF_VARCHAR2_TABLE_100
1959: , p4_a38 JTF_VARCHAR2_TABLE_100
1960: , p4_a39 JTF_NUMBER_TABLE
1961: , p4_a40 JTF_VARCHAR2_TABLE_100
1962: , p4_a41 JTF_VARCHAR2_TABLE_2000
1963: , p4_a42 JTF_VARCHAR2_TABLE_100
1964: , p4_a43 JTF_VARCHAR2_TABLE_4000
1965: , p4_a44 JTF_DATE_TABLE
1966: , p4_a45 JTF_VARCHAR2_TABLE_100

Line 1973: , p4_a52 JTF_VARCHAR2_TABLE_2000

1969: , p4_a48 JTF_VARCHAR2_TABLE_100
1970: , p4_a49 JTF_VARCHAR2_TABLE_100
1971: , p4_a50 JTF_VARCHAR2_TABLE_100
1972: , p4_a51 JTF_VARCHAR2_TABLE_100
1973: , p4_a52 JTF_VARCHAR2_TABLE_2000
1974: , p4_a53 JTF_VARCHAR2_TABLE_100
1975: , p4_a54 JTF_VARCHAR2_TABLE_100
1976: , p4_a55 JTF_NUMBER_TABLE
1977: , p4_a56 JTF_VARCHAR2_TABLE_2000

Line 1977: , p4_a56 JTF_VARCHAR2_TABLE_2000

1973: , p4_a52 JTF_VARCHAR2_TABLE_2000
1974: , p4_a53 JTF_VARCHAR2_TABLE_100
1975: , p4_a54 JTF_VARCHAR2_TABLE_100
1976: , p4_a55 JTF_NUMBER_TABLE
1977: , p4_a56 JTF_VARCHAR2_TABLE_2000
1978: , p4_a57 JTF_VARCHAR2_TABLE_100
1979: , p4_a58 JTF_VARCHAR2_TABLE_100
1980: , p4_a59 JTF_VARCHAR2_TABLE_100
1981: , x_search_ctx_id out nocopy NUMBER

Line 2099: , p4_a41 JTF_VARCHAR2_TABLE_2000

2095: , p4_a37 JTF_VARCHAR2_TABLE_100
2096: , p4_a38 JTF_VARCHAR2_TABLE_100
2097: , p4_a39 JTF_NUMBER_TABLE
2098: , p4_a40 JTF_VARCHAR2_TABLE_100
2099: , p4_a41 JTF_VARCHAR2_TABLE_2000
2100: , p4_a42 JTF_VARCHAR2_TABLE_100
2101: , p4_a43 JTF_VARCHAR2_TABLE_4000
2102: , p4_a44 JTF_DATE_TABLE
2103: , p4_a45 JTF_VARCHAR2_TABLE_100

Line 2110: , p4_a52 JTF_VARCHAR2_TABLE_2000

2106: , p4_a48 JTF_VARCHAR2_TABLE_100
2107: , p4_a49 JTF_VARCHAR2_TABLE_100
2108: , p4_a50 JTF_VARCHAR2_TABLE_100
2109: , p4_a51 JTF_VARCHAR2_TABLE_100
2110: , p4_a52 JTF_VARCHAR2_TABLE_2000
2111: , p4_a53 JTF_VARCHAR2_TABLE_100
2112: , p4_a54 JTF_VARCHAR2_TABLE_100
2113: , p4_a55 JTF_NUMBER_TABLE
2114: , p4_a56 JTF_VARCHAR2_TABLE_2000

Line 2114: , p4_a56 JTF_VARCHAR2_TABLE_2000

2110: , p4_a52 JTF_VARCHAR2_TABLE_2000
2111: , p4_a53 JTF_VARCHAR2_TABLE_100
2112: , p4_a54 JTF_VARCHAR2_TABLE_100
2113: , p4_a55 JTF_NUMBER_TABLE
2114: , p4_a56 JTF_VARCHAR2_TABLE_2000
2115: , p4_a57 JTF_VARCHAR2_TABLE_100
2116: , p4_a58 JTF_VARCHAR2_TABLE_100
2117: , p4_a59 JTF_VARCHAR2_TABLE_100
2118: , p_restrict_sql VARCHAR2

Line 2239: , p4_a41 JTF_VARCHAR2_TABLE_2000

2235: , p4_a37 JTF_VARCHAR2_TABLE_100
2236: , p4_a38 JTF_VARCHAR2_TABLE_100
2237: , p4_a39 JTF_NUMBER_TABLE
2238: , p4_a40 JTF_VARCHAR2_TABLE_100
2239: , p4_a41 JTF_VARCHAR2_TABLE_2000
2240: , p4_a42 JTF_VARCHAR2_TABLE_100
2241: , p4_a43 JTF_VARCHAR2_TABLE_4000
2242: , p4_a44 JTF_DATE_TABLE
2243: , p4_a45 JTF_VARCHAR2_TABLE_100

Line 2250: , p4_a52 JTF_VARCHAR2_TABLE_2000

2246: , p4_a48 JTF_VARCHAR2_TABLE_100
2247: , p4_a49 JTF_VARCHAR2_TABLE_100
2248: , p4_a50 JTF_VARCHAR2_TABLE_100
2249: , p4_a51 JTF_VARCHAR2_TABLE_100
2250: , p4_a52 JTF_VARCHAR2_TABLE_2000
2251: , p4_a53 JTF_VARCHAR2_TABLE_100
2252: , p4_a54 JTF_VARCHAR2_TABLE_100
2253: , p4_a55 JTF_NUMBER_TABLE
2254: , p4_a56 JTF_VARCHAR2_TABLE_2000

Line 2254: , p4_a56 JTF_VARCHAR2_TABLE_2000

2250: , p4_a52 JTF_VARCHAR2_TABLE_2000
2251: , p4_a53 JTF_VARCHAR2_TABLE_100
2252: , p4_a54 JTF_VARCHAR2_TABLE_100
2253: , p4_a55 JTF_NUMBER_TABLE
2254: , p4_a56 JTF_VARCHAR2_TABLE_2000
2255: , p4_a57 JTF_VARCHAR2_TABLE_100
2256: , p4_a58 JTF_VARCHAR2_TABLE_100
2257: , p4_a59 JTF_VARCHAR2_TABLE_100
2258: , x_search_ctx_id out nocopy NUMBER

Line 2307: , p3_a41 JTF_VARCHAR2_TABLE_2000

2303: , p3_a37 JTF_VARCHAR2_TABLE_100
2304: , p3_a38 JTF_VARCHAR2_TABLE_100
2305: , p3_a39 JTF_NUMBER_TABLE
2306: , p3_a40 JTF_VARCHAR2_TABLE_100
2307: , p3_a41 JTF_VARCHAR2_TABLE_2000
2308: , p3_a42 JTF_VARCHAR2_TABLE_100
2309: , p3_a43 JTF_VARCHAR2_TABLE_4000
2310: , p3_a44 JTF_DATE_TABLE
2311: , p3_a45 JTF_VARCHAR2_TABLE_100

Line 2318: , p3_a52 JTF_VARCHAR2_TABLE_2000

2314: , p3_a48 JTF_VARCHAR2_TABLE_100
2315: , p3_a49 JTF_VARCHAR2_TABLE_100
2316: , p3_a50 JTF_VARCHAR2_TABLE_100
2317: , p3_a51 JTF_VARCHAR2_TABLE_100
2318: , p3_a52 JTF_VARCHAR2_TABLE_2000
2319: , p3_a53 JTF_VARCHAR2_TABLE_100
2320: , p3_a54 JTF_VARCHAR2_TABLE_100
2321: , p3_a55 JTF_NUMBER_TABLE
2322: , p3_a56 JTF_VARCHAR2_TABLE_2000

Line 2322: , p3_a56 JTF_VARCHAR2_TABLE_2000

2318: , p3_a52 JTF_VARCHAR2_TABLE_2000
2319: , p3_a53 JTF_VARCHAR2_TABLE_100
2320: , p3_a54 JTF_VARCHAR2_TABLE_100
2321: , p3_a55 JTF_NUMBER_TABLE
2322: , p3_a56 JTF_VARCHAR2_TABLE_2000
2323: , p3_a57 JTF_VARCHAR2_TABLE_100
2324: , p3_a58 JTF_VARCHAR2_TABLE_100
2325: , p3_a59 JTF_VARCHAR2_TABLE_100
2326: , p_restrict_sql VARCHAR2

Line 2378: , p3_a41 JTF_VARCHAR2_TABLE_2000

2374: , p3_a37 JTF_VARCHAR2_TABLE_100
2375: , p3_a38 JTF_VARCHAR2_TABLE_100
2376: , p3_a39 JTF_NUMBER_TABLE
2377: , p3_a40 JTF_VARCHAR2_TABLE_100
2378: , p3_a41 JTF_VARCHAR2_TABLE_2000
2379: , p3_a42 JTF_VARCHAR2_TABLE_100
2380: , p3_a43 JTF_VARCHAR2_TABLE_4000
2381: , p3_a44 JTF_DATE_TABLE
2382: , p3_a45 JTF_VARCHAR2_TABLE_100

Line 2389: , p3_a52 JTF_VARCHAR2_TABLE_2000

2385: , p3_a48 JTF_VARCHAR2_TABLE_100
2386: , p3_a49 JTF_VARCHAR2_TABLE_100
2387: , p3_a50 JTF_VARCHAR2_TABLE_100
2388: , p3_a51 JTF_VARCHAR2_TABLE_100
2389: , p3_a52 JTF_VARCHAR2_TABLE_2000
2390: , p3_a53 JTF_VARCHAR2_TABLE_100
2391: , p3_a54 JTF_VARCHAR2_TABLE_100
2392: , p3_a55 JTF_NUMBER_TABLE
2393: , p3_a56 JTF_VARCHAR2_TABLE_2000

Line 2393: , p3_a56 JTF_VARCHAR2_TABLE_2000

2389: , p3_a52 JTF_VARCHAR2_TABLE_2000
2390: , p3_a53 JTF_VARCHAR2_TABLE_100
2391: , p3_a54 JTF_VARCHAR2_TABLE_100
2392: , p3_a55 JTF_NUMBER_TABLE
2393: , p3_a56 JTF_VARCHAR2_TABLE_2000
2394: , p3_a57 JTF_VARCHAR2_TABLE_100
2395: , p3_a58 JTF_VARCHAR2_TABLE_100
2396: , p3_a59 JTF_VARCHAR2_TABLE_100
2397: , x_search_ctx_id out nocopy NUMBER

Line 2771: , p7_a41 JTF_VARCHAR2_TABLE_2000

2767: , p7_a37 JTF_VARCHAR2_TABLE_100
2768: , p7_a38 JTF_VARCHAR2_TABLE_100
2769: , p7_a39 JTF_NUMBER_TABLE
2770: , p7_a40 JTF_VARCHAR2_TABLE_100
2771: , p7_a41 JTF_VARCHAR2_TABLE_2000
2772: , p7_a42 JTF_VARCHAR2_TABLE_100
2773: , p7_a43 JTF_VARCHAR2_TABLE_4000
2774: , p7_a44 JTF_DATE_TABLE
2775: , p7_a45 JTF_VARCHAR2_TABLE_100

Line 2782: , p7_a52 JTF_VARCHAR2_TABLE_2000

2778: , p7_a48 JTF_VARCHAR2_TABLE_100
2779: , p7_a49 JTF_VARCHAR2_TABLE_100
2780: , p7_a50 JTF_VARCHAR2_TABLE_100
2781: , p7_a51 JTF_VARCHAR2_TABLE_100
2782: , p7_a52 JTF_VARCHAR2_TABLE_2000
2783: , p7_a53 JTF_VARCHAR2_TABLE_100
2784: , p7_a54 JTF_VARCHAR2_TABLE_100
2785: , p7_a55 JTF_NUMBER_TABLE
2786: , p7_a56 JTF_VARCHAR2_TABLE_2000

Line 2786: , p7_a56 JTF_VARCHAR2_TABLE_2000

2782: , p7_a52 JTF_VARCHAR2_TABLE_2000
2783: , p7_a53 JTF_VARCHAR2_TABLE_100
2784: , p7_a54 JTF_VARCHAR2_TABLE_100
2785: , p7_a55 JTF_NUMBER_TABLE
2786: , p7_a56 JTF_VARCHAR2_TABLE_2000
2787: , p7_a57 JTF_VARCHAR2_TABLE_100
2788: , p7_a58 JTF_VARCHAR2_TABLE_100
2789: , p7_a59 JTF_VARCHAR2_TABLE_100
2790: , x_return_status out nocopy VARCHAR2

Line 3162: , p6_a41 JTF_VARCHAR2_TABLE_2000

3158: , p6_a37 JTF_VARCHAR2_TABLE_100
3159: , p6_a38 JTF_VARCHAR2_TABLE_100
3160: , p6_a39 JTF_NUMBER_TABLE
3161: , p6_a40 JTF_VARCHAR2_TABLE_100
3162: , p6_a41 JTF_VARCHAR2_TABLE_2000
3163: , p6_a42 JTF_VARCHAR2_TABLE_100
3164: , p6_a43 JTF_VARCHAR2_TABLE_4000
3165: , p6_a44 JTF_DATE_TABLE
3166: , p6_a45 JTF_VARCHAR2_TABLE_100

Line 3173: , p6_a52 JTF_VARCHAR2_TABLE_2000

3169: , p6_a48 JTF_VARCHAR2_TABLE_100
3170: , p6_a49 JTF_VARCHAR2_TABLE_100
3171: , p6_a50 JTF_VARCHAR2_TABLE_100
3172: , p6_a51 JTF_VARCHAR2_TABLE_100
3173: , p6_a52 JTF_VARCHAR2_TABLE_2000
3174: , p6_a53 JTF_VARCHAR2_TABLE_100
3175: , p6_a54 JTF_VARCHAR2_TABLE_100
3176: , p6_a55 JTF_NUMBER_TABLE
3177: , p6_a56 JTF_VARCHAR2_TABLE_2000

Line 3177: , p6_a56 JTF_VARCHAR2_TABLE_2000

3173: , p6_a52 JTF_VARCHAR2_TABLE_2000
3174: , p6_a53 JTF_VARCHAR2_TABLE_100
3175: , p6_a54 JTF_VARCHAR2_TABLE_100
3176: , p6_a55 JTF_NUMBER_TABLE
3177: , p6_a56 JTF_VARCHAR2_TABLE_2000
3178: , p6_a57 JTF_VARCHAR2_TABLE_100
3179: , p6_a58 JTF_VARCHAR2_TABLE_100
3180: , p6_a59 JTF_VARCHAR2_TABLE_100
3181: , x_search_ctx_id in out nocopy NUMBER

Line 3553: , p5_a41 JTF_VARCHAR2_TABLE_2000

3549: , p5_a37 JTF_VARCHAR2_TABLE_100
3550: , p5_a38 JTF_VARCHAR2_TABLE_100
3551: , p5_a39 JTF_NUMBER_TABLE
3552: , p5_a40 JTF_VARCHAR2_TABLE_100
3553: , p5_a41 JTF_VARCHAR2_TABLE_2000
3554: , p5_a42 JTF_VARCHAR2_TABLE_100
3555: , p5_a43 JTF_VARCHAR2_TABLE_4000
3556: , p5_a44 JTF_DATE_TABLE
3557: , p5_a45 JTF_VARCHAR2_TABLE_100

Line 3564: , p5_a52 JTF_VARCHAR2_TABLE_2000

3560: , p5_a48 JTF_VARCHAR2_TABLE_100
3561: , p5_a49 JTF_VARCHAR2_TABLE_100
3562: , p5_a50 JTF_VARCHAR2_TABLE_100
3563: , p5_a51 JTF_VARCHAR2_TABLE_100
3564: , p5_a52 JTF_VARCHAR2_TABLE_2000
3565: , p5_a53 JTF_VARCHAR2_TABLE_100
3566: , p5_a54 JTF_VARCHAR2_TABLE_100
3567: , p5_a55 JTF_NUMBER_TABLE
3568: , p5_a56 JTF_VARCHAR2_TABLE_2000

Line 3568: , p5_a56 JTF_VARCHAR2_TABLE_2000

3564: , p5_a52 JTF_VARCHAR2_TABLE_2000
3565: , p5_a53 JTF_VARCHAR2_TABLE_100
3566: , p5_a54 JTF_VARCHAR2_TABLE_100
3567: , p5_a55 JTF_NUMBER_TABLE
3568: , p5_a56 JTF_VARCHAR2_TABLE_2000
3569: , p5_a57 JTF_VARCHAR2_TABLE_100
3570: , p5_a58 JTF_VARCHAR2_TABLE_100
3571: , p5_a59 JTF_VARCHAR2_TABLE_100
3572: , p_restrict_sql VARCHAR2

Line 3949: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_2000

3945: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
3946: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
3947: , p6_a39 out nocopy JTF_NUMBER_TABLE
3948: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
3949: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_2000
3950: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
3951: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_4000
3952: , p6_a44 out nocopy JTF_DATE_TABLE
3953: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

Line 3960: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000

3956: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
3957: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
3958: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_100
3959: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
3960: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
3961: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
3962: , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
3963: , p6_a55 out nocopy JTF_NUMBER_TABLE
3964: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_2000

Line 3964: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_2000

3960: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
3961: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
3962: , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
3963: , p6_a55 out nocopy JTF_NUMBER_TABLE
3964: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_2000
3965: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
3966: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
3967: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
3968: , x_return_status out nocopy VARCHAR2

Line 4343: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_2000

4339: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
4340: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
4341: , p9_a39 out nocopy JTF_NUMBER_TABLE
4342: , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
4343: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_2000
4344: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
4345: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_4000
4346: , p9_a44 out nocopy JTF_DATE_TABLE
4347: , p9_a45 out nocopy JTF_VARCHAR2_TABLE_100

Line 4354: , p9_a52 out nocopy JTF_VARCHAR2_TABLE_2000

4350: , p9_a48 out nocopy JTF_VARCHAR2_TABLE_100
4351: , p9_a49 out nocopy JTF_VARCHAR2_TABLE_100
4352: , p9_a50 out nocopy JTF_VARCHAR2_TABLE_100
4353: , p9_a51 out nocopy JTF_VARCHAR2_TABLE_100
4354: , p9_a52 out nocopy JTF_VARCHAR2_TABLE_2000
4355: , p9_a53 out nocopy JTF_VARCHAR2_TABLE_100
4356: , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
4357: , p9_a55 out nocopy JTF_NUMBER_TABLE
4358: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_2000

Line 4358: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_2000

4354: , p9_a52 out nocopy JTF_VARCHAR2_TABLE_2000
4355: , p9_a53 out nocopy JTF_VARCHAR2_TABLE_100
4356: , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
4357: , p9_a55 out nocopy JTF_NUMBER_TABLE
4358: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_2000
4359: , p9_a57 out nocopy JTF_VARCHAR2_TABLE_100
4360: , p9_a58 out nocopy JTF_VARCHAR2_TABLE_100
4361: , p9_a59 out nocopy JTF_VARCHAR2_TABLE_100
4362: , x_return_status out nocopy VARCHAR2