eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_SEARCH_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 440: procedure rosetta_table_copy_in_p7(t out nocopy hz_party_search.txlist, a0 JTF_VARCHAR2_TABLE_2000) as

436: end if;
437: end if;
438: end rosetta_table_copy_out_p6;
439:
440: procedure rosetta_table_copy_in_p7(t out nocopy hz_party_search.txlist, a0 JTF_VARCHAR2_TABLE_2000) as
441: ddindx binary_integer; indx binary_integer;
442: begin
443: if a0 is not null and a0.count > 0 then
444: if a0.count > 0 then

Line 458: procedure rosetta_table_copy_out_p7(t hz_party_search.txlist, a0 out nocopy JTF_VARCHAR2_TABLE_2000) as

454: end loop;
455: end if;
456: end if;
457: end rosetta_table_copy_in_p7;
458: procedure rosetta_table_copy_out_p7(t hz_party_search.txlist, a0 out nocopy JTF_VARCHAR2_TABLE_2000) as
459: ddindx binary_integer; indx binary_integer;
460: begin
461: if t is null or t.count = 0 then
462: a0 := JTF_VARCHAR2_TABLE_2000();

Line 462: a0 := JTF_VARCHAR2_TABLE_2000();

458: procedure rosetta_table_copy_out_p7(t hz_party_search.txlist, a0 out nocopy JTF_VARCHAR2_TABLE_2000) as
459: ddindx binary_integer; indx binary_integer;
460: begin
461: if t is null or t.count = 0 then
462: a0 := JTF_VARCHAR2_TABLE_2000();
463: else
464: a0 := JTF_VARCHAR2_TABLE_2000();
465: if t.count > 0 then
466: a0.extend(t.count);

Line 464: a0 := JTF_VARCHAR2_TABLE_2000();

460: begin
461: if t is null or t.count = 0 then
462: a0 := JTF_VARCHAR2_TABLE_2000();
463: else
464: a0 := JTF_VARCHAR2_TABLE_2000();
465: if t.count > 0 then
466: a0.extend(t.count);
467: ddindx := t.first;
468: indx := 1;

Line 1539: , a41 JTF_VARCHAR2_TABLE_2000

1535: , a37 JTF_VARCHAR2_TABLE_100
1536: , a38 JTF_VARCHAR2_TABLE_100
1537: , a39 JTF_NUMBER_TABLE
1538: , a40 JTF_VARCHAR2_TABLE_100
1539: , a41 JTF_VARCHAR2_TABLE_2000
1540: , a42 JTF_VARCHAR2_TABLE_100
1541: , a43 JTF_VARCHAR2_TABLE_4000
1542: , a44 JTF_DATE_TABLE
1543: , a45 JTF_VARCHAR2_TABLE_100

Line 1550: , a52 JTF_VARCHAR2_TABLE_2000

1546: , a48 JTF_VARCHAR2_TABLE_100
1547: , a49 JTF_VARCHAR2_TABLE_100
1548: , a50 JTF_VARCHAR2_TABLE_100
1549: , a51 JTF_VARCHAR2_TABLE_100
1550: , a52 JTF_VARCHAR2_TABLE_2000
1551: , a53 JTF_VARCHAR2_TABLE_100
1552: , a54 JTF_VARCHAR2_TABLE_100
1553: , a55 JTF_NUMBER_TABLE
1554: , a56 JTF_VARCHAR2_TABLE_2000

Line 1554: , a56 JTF_VARCHAR2_TABLE_2000

1550: , a52 JTF_VARCHAR2_TABLE_2000
1551: , a53 JTF_VARCHAR2_TABLE_100
1552: , a54 JTF_VARCHAR2_TABLE_100
1553: , a55 JTF_NUMBER_TABLE
1554: , a56 JTF_VARCHAR2_TABLE_2000
1555: , a57 JTF_VARCHAR2_TABLE_100
1556: , a58 JTF_VARCHAR2_TABLE_100
1557: , a59 JTF_VARCHAR2_TABLE_100
1558: ) as

Line 1676: , a41 out nocopy JTF_VARCHAR2_TABLE_2000

1672: , a37 out nocopy JTF_VARCHAR2_TABLE_100
1673: , a38 out nocopy JTF_VARCHAR2_TABLE_100
1674: , a39 out nocopy JTF_NUMBER_TABLE
1675: , a40 out nocopy JTF_VARCHAR2_TABLE_100
1676: , a41 out nocopy JTF_VARCHAR2_TABLE_2000
1677: , a42 out nocopy JTF_VARCHAR2_TABLE_100
1678: , a43 out nocopy JTF_VARCHAR2_TABLE_4000
1679: , a44 out nocopy JTF_DATE_TABLE
1680: , a45 out nocopy JTF_VARCHAR2_TABLE_100

Line 1687: , a52 out nocopy JTF_VARCHAR2_TABLE_2000

1683: , a48 out nocopy JTF_VARCHAR2_TABLE_100
1684: , a49 out nocopy JTF_VARCHAR2_TABLE_100
1685: , a50 out nocopy JTF_VARCHAR2_TABLE_100
1686: , a51 out nocopy JTF_VARCHAR2_TABLE_100
1687: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
1688: , a53 out nocopy JTF_VARCHAR2_TABLE_100
1689: , a54 out nocopy JTF_VARCHAR2_TABLE_100
1690: , a55 out nocopy JTF_NUMBER_TABLE
1691: , a56 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1691: , a56 out nocopy JTF_VARCHAR2_TABLE_2000

1687: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
1688: , a53 out nocopy JTF_VARCHAR2_TABLE_100
1689: , a54 out nocopy JTF_VARCHAR2_TABLE_100
1690: , a55 out nocopy JTF_NUMBER_TABLE
1691: , a56 out nocopy JTF_VARCHAR2_TABLE_2000
1692: , a57 out nocopy JTF_VARCHAR2_TABLE_100
1693: , a58 out nocopy JTF_VARCHAR2_TABLE_100
1694: , a59 out nocopy JTF_VARCHAR2_TABLE_100
1695: ) as

Line 1740: a41 := JTF_VARCHAR2_TABLE_2000();

1736: a37 := JTF_VARCHAR2_TABLE_100();
1737: a38 := JTF_VARCHAR2_TABLE_100();
1738: a39 := JTF_NUMBER_TABLE();
1739: a40 := JTF_VARCHAR2_TABLE_100();
1740: a41 := JTF_VARCHAR2_TABLE_2000();
1741: a42 := JTF_VARCHAR2_TABLE_100();
1742: a43 := JTF_VARCHAR2_TABLE_4000();
1743: a44 := JTF_DATE_TABLE();
1744: a45 := JTF_VARCHAR2_TABLE_100();

Line 1751: a52 := JTF_VARCHAR2_TABLE_2000();

1747: a48 := JTF_VARCHAR2_TABLE_100();
1748: a49 := JTF_VARCHAR2_TABLE_100();
1749: a50 := JTF_VARCHAR2_TABLE_100();
1750: a51 := JTF_VARCHAR2_TABLE_100();
1751: a52 := JTF_VARCHAR2_TABLE_2000();
1752: a53 := JTF_VARCHAR2_TABLE_100();
1753: a54 := JTF_VARCHAR2_TABLE_100();
1754: a55 := JTF_NUMBER_TABLE();
1755: a56 := JTF_VARCHAR2_TABLE_2000();

Line 1755: a56 := JTF_VARCHAR2_TABLE_2000();

1751: a52 := JTF_VARCHAR2_TABLE_2000();
1752: a53 := JTF_VARCHAR2_TABLE_100();
1753: a54 := JTF_VARCHAR2_TABLE_100();
1754: a55 := JTF_NUMBER_TABLE();
1755: a56 := JTF_VARCHAR2_TABLE_2000();
1756: a57 := JTF_VARCHAR2_TABLE_100();
1757: a58 := JTF_VARCHAR2_TABLE_100();
1758: a59 := JTF_VARCHAR2_TABLE_100();
1759: else

Line 1801: a41 := JTF_VARCHAR2_TABLE_2000();

1797: a37 := JTF_VARCHAR2_TABLE_100();
1798: a38 := JTF_VARCHAR2_TABLE_100();
1799: a39 := JTF_NUMBER_TABLE();
1800: a40 := JTF_VARCHAR2_TABLE_100();
1801: a41 := JTF_VARCHAR2_TABLE_2000();
1802: a42 := JTF_VARCHAR2_TABLE_100();
1803: a43 := JTF_VARCHAR2_TABLE_4000();
1804: a44 := JTF_DATE_TABLE();
1805: a45 := JTF_VARCHAR2_TABLE_100();

Line 1812: a52 := JTF_VARCHAR2_TABLE_2000();

1808: a48 := JTF_VARCHAR2_TABLE_100();
1809: a49 := JTF_VARCHAR2_TABLE_100();
1810: a50 := JTF_VARCHAR2_TABLE_100();
1811: a51 := JTF_VARCHAR2_TABLE_100();
1812: a52 := JTF_VARCHAR2_TABLE_2000();
1813: a53 := JTF_VARCHAR2_TABLE_100();
1814: a54 := JTF_VARCHAR2_TABLE_100();
1815: a55 := JTF_NUMBER_TABLE();
1816: a56 := JTF_VARCHAR2_TABLE_2000();

Line 1816: a56 := JTF_VARCHAR2_TABLE_2000();

1812: a52 := JTF_VARCHAR2_TABLE_2000();
1813: a53 := JTF_VARCHAR2_TABLE_100();
1814: a54 := JTF_VARCHAR2_TABLE_100();
1815: a55 := JTF_NUMBER_TABLE();
1816: a56 := JTF_VARCHAR2_TABLE_2000();
1817: a57 := JTF_VARCHAR2_TABLE_100();
1818: a58 := JTF_VARCHAR2_TABLE_100();
1819: a59 := JTF_VARCHAR2_TABLE_100();
1820: if t.count > 0 then

Line 2420: , p5_a41 JTF_VARCHAR2_TABLE_2000

2416: , p5_a37 JTF_VARCHAR2_TABLE_100
2417: , p5_a38 JTF_VARCHAR2_TABLE_100
2418: , p5_a39 JTF_NUMBER_TABLE
2419: , p5_a40 JTF_VARCHAR2_TABLE_100
2420: , p5_a41 JTF_VARCHAR2_TABLE_2000
2421: , p5_a42 JTF_VARCHAR2_TABLE_100
2422: , p5_a43 JTF_VARCHAR2_TABLE_4000
2423: , p5_a44 JTF_DATE_TABLE
2424: , p5_a45 JTF_VARCHAR2_TABLE_100

Line 2431: , p5_a52 JTF_VARCHAR2_TABLE_2000

2427: , p5_a48 JTF_VARCHAR2_TABLE_100
2428: , p5_a49 JTF_VARCHAR2_TABLE_100
2429: , p5_a50 JTF_VARCHAR2_TABLE_100
2430: , p5_a51 JTF_VARCHAR2_TABLE_100
2431: , p5_a52 JTF_VARCHAR2_TABLE_2000
2432: , p5_a53 JTF_VARCHAR2_TABLE_100
2433: , p5_a54 JTF_VARCHAR2_TABLE_100
2434: , p5_a55 JTF_NUMBER_TABLE
2435: , p5_a56 JTF_VARCHAR2_TABLE_2000

Line 2435: , p5_a56 JTF_VARCHAR2_TABLE_2000

2431: , p5_a52 JTF_VARCHAR2_TABLE_2000
2432: , p5_a53 JTF_VARCHAR2_TABLE_100
2433: , p5_a54 JTF_VARCHAR2_TABLE_100
2434: , p5_a55 JTF_NUMBER_TABLE
2435: , p5_a56 JTF_VARCHAR2_TABLE_2000
2436: , p5_a57 JTF_VARCHAR2_TABLE_100
2437: , p5_a58 JTF_VARCHAR2_TABLE_100
2438: , p5_a59 JTF_VARCHAR2_TABLE_100
2439: , p_restrict_sql VARCHAR2

Line 3258: , p5_a41 JTF_VARCHAR2_TABLE_2000

3254: , p5_a37 JTF_VARCHAR2_TABLE_100
3255: , p5_a38 JTF_VARCHAR2_TABLE_100
3256: , p5_a39 JTF_NUMBER_TABLE
3257: , p5_a40 JTF_VARCHAR2_TABLE_100
3258: , p5_a41 JTF_VARCHAR2_TABLE_2000
3259: , p5_a42 JTF_VARCHAR2_TABLE_100
3260: , p5_a43 JTF_VARCHAR2_TABLE_4000
3261: , p5_a44 JTF_DATE_TABLE
3262: , p5_a45 JTF_VARCHAR2_TABLE_100

Line 3269: , p5_a52 JTF_VARCHAR2_TABLE_2000

3265: , p5_a48 JTF_VARCHAR2_TABLE_100
3266: , p5_a49 JTF_VARCHAR2_TABLE_100
3267: , p5_a50 JTF_VARCHAR2_TABLE_100
3268: , p5_a51 JTF_VARCHAR2_TABLE_100
3269: , p5_a52 JTF_VARCHAR2_TABLE_2000
3270: , p5_a53 JTF_VARCHAR2_TABLE_100
3271: , p5_a54 JTF_VARCHAR2_TABLE_100
3272: , p5_a55 JTF_NUMBER_TABLE
3273: , p5_a56 JTF_VARCHAR2_TABLE_2000

Line 3273: , p5_a56 JTF_VARCHAR2_TABLE_2000

3269: , p5_a52 JTF_VARCHAR2_TABLE_2000
3270: , p5_a53 JTF_VARCHAR2_TABLE_100
3271: , p5_a54 JTF_VARCHAR2_TABLE_100
3272: , p5_a55 JTF_NUMBER_TABLE
3273: , p5_a56 JTF_VARCHAR2_TABLE_2000
3274: , p5_a57 JTF_VARCHAR2_TABLE_100
3275: , p5_a58 JTF_VARCHAR2_TABLE_100
3276: , p5_a59 JTF_VARCHAR2_TABLE_100
3277: , p_restrict_sql VARCHAR2

Line 4092: , p5_a41 JTF_VARCHAR2_TABLE_2000

4088: , p5_a37 JTF_VARCHAR2_TABLE_100
4089: , p5_a38 JTF_VARCHAR2_TABLE_100
4090: , p5_a39 JTF_NUMBER_TABLE
4091: , p5_a40 JTF_VARCHAR2_TABLE_100
4092: , p5_a41 JTF_VARCHAR2_TABLE_2000
4093: , p5_a42 JTF_VARCHAR2_TABLE_100
4094: , p5_a43 JTF_VARCHAR2_TABLE_4000
4095: , p5_a44 JTF_DATE_TABLE
4096: , p5_a45 JTF_VARCHAR2_TABLE_100

Line 4103: , p5_a52 JTF_VARCHAR2_TABLE_2000

4099: , p5_a48 JTF_VARCHAR2_TABLE_100
4100: , p5_a49 JTF_VARCHAR2_TABLE_100
4101: , p5_a50 JTF_VARCHAR2_TABLE_100
4102: , p5_a51 JTF_VARCHAR2_TABLE_100
4103: , p5_a52 JTF_VARCHAR2_TABLE_2000
4104: , p5_a53 JTF_VARCHAR2_TABLE_100
4105: , p5_a54 JTF_VARCHAR2_TABLE_100
4106: , p5_a55 JTF_NUMBER_TABLE
4107: , p5_a56 JTF_VARCHAR2_TABLE_2000

Line 4107: , p5_a56 JTF_VARCHAR2_TABLE_2000

4103: , p5_a52 JTF_VARCHAR2_TABLE_2000
4104: , p5_a53 JTF_VARCHAR2_TABLE_100
4105: , p5_a54 JTF_VARCHAR2_TABLE_100
4106: , p5_a55 JTF_NUMBER_TABLE
4107: , p5_a56 JTF_VARCHAR2_TABLE_2000
4108: , p5_a57 JTF_VARCHAR2_TABLE_100
4109: , p5_a58 JTF_VARCHAR2_TABLE_100
4110: , p5_a59 JTF_VARCHAR2_TABLE_100
4111: , p_restrict_sql VARCHAR2

Line 4669: , p4_a41 JTF_VARCHAR2_TABLE_2000

4665: , p4_a37 JTF_VARCHAR2_TABLE_100
4666: , p4_a38 JTF_VARCHAR2_TABLE_100
4667: , p4_a39 JTF_NUMBER_TABLE
4668: , p4_a40 JTF_VARCHAR2_TABLE_100
4669: , p4_a41 JTF_VARCHAR2_TABLE_2000
4670: , p4_a42 JTF_VARCHAR2_TABLE_100
4671: , p4_a43 JTF_VARCHAR2_TABLE_4000
4672: , p4_a44 JTF_DATE_TABLE
4673: , p4_a45 JTF_VARCHAR2_TABLE_100

Line 4680: , p4_a52 JTF_VARCHAR2_TABLE_2000

4676: , p4_a48 JTF_VARCHAR2_TABLE_100
4677: , p4_a49 JTF_VARCHAR2_TABLE_100
4678: , p4_a50 JTF_VARCHAR2_TABLE_100
4679: , p4_a51 JTF_VARCHAR2_TABLE_100
4680: , p4_a52 JTF_VARCHAR2_TABLE_2000
4681: , p4_a53 JTF_VARCHAR2_TABLE_100
4682: , p4_a54 JTF_VARCHAR2_TABLE_100
4683: , p4_a55 JTF_NUMBER_TABLE
4684: , p4_a56 JTF_VARCHAR2_TABLE_2000

Line 4684: , p4_a56 JTF_VARCHAR2_TABLE_2000

4680: , p4_a52 JTF_VARCHAR2_TABLE_2000
4681: , p4_a53 JTF_VARCHAR2_TABLE_100
4682: , p4_a54 JTF_VARCHAR2_TABLE_100
4683: , p4_a55 JTF_NUMBER_TABLE
4684: , p4_a56 JTF_VARCHAR2_TABLE_2000
4685: , p4_a57 JTF_VARCHAR2_TABLE_100
4686: , p4_a58 JTF_VARCHAR2_TABLE_100
4687: , p4_a59 JTF_VARCHAR2_TABLE_100
4688: , p_restrict_sql VARCHAR2

Line 4982: , p4_a41 JTF_VARCHAR2_TABLE_2000

4978: , p4_a37 JTF_VARCHAR2_TABLE_100
4979: , p4_a38 JTF_VARCHAR2_TABLE_100
4980: , p4_a39 JTF_NUMBER_TABLE
4981: , p4_a40 JTF_VARCHAR2_TABLE_100
4982: , p4_a41 JTF_VARCHAR2_TABLE_2000
4983: , p4_a42 JTF_VARCHAR2_TABLE_100
4984: , p4_a43 JTF_VARCHAR2_TABLE_4000
4985: , p4_a44 JTF_DATE_TABLE
4986: , p4_a45 JTF_VARCHAR2_TABLE_100

Line 4993: , p4_a52 JTF_VARCHAR2_TABLE_2000

4989: , p4_a48 JTF_VARCHAR2_TABLE_100
4990: , p4_a49 JTF_VARCHAR2_TABLE_100
4991: , p4_a50 JTF_VARCHAR2_TABLE_100
4992: , p4_a51 JTF_VARCHAR2_TABLE_100
4993: , p4_a52 JTF_VARCHAR2_TABLE_2000
4994: , p4_a53 JTF_VARCHAR2_TABLE_100
4995: , p4_a54 JTF_VARCHAR2_TABLE_100
4996: , p4_a55 JTF_NUMBER_TABLE
4997: , p4_a56 JTF_VARCHAR2_TABLE_2000

Line 4997: , p4_a56 JTF_VARCHAR2_TABLE_2000

4993: , p4_a52 JTF_VARCHAR2_TABLE_2000
4994: , p4_a53 JTF_VARCHAR2_TABLE_100
4995: , p4_a54 JTF_VARCHAR2_TABLE_100
4996: , p4_a55 JTF_NUMBER_TABLE
4997: , p4_a56 JTF_VARCHAR2_TABLE_2000
4998: , p4_a57 JTF_VARCHAR2_TABLE_100
4999: , p4_a58 JTF_VARCHAR2_TABLE_100
5000: , p4_a59 JTF_VARCHAR2_TABLE_100
5001: , x_search_ctx_id out nocopy NUMBER

Line 5286: , p4_a41 JTF_VARCHAR2_TABLE_2000

5282: , p4_a37 JTF_VARCHAR2_TABLE_100
5283: , p4_a38 JTF_VARCHAR2_TABLE_100
5284: , p4_a39 JTF_NUMBER_TABLE
5285: , p4_a40 JTF_VARCHAR2_TABLE_100
5286: , p4_a41 JTF_VARCHAR2_TABLE_2000
5287: , p4_a42 JTF_VARCHAR2_TABLE_100
5288: , p4_a43 JTF_VARCHAR2_TABLE_4000
5289: , p4_a44 JTF_DATE_TABLE
5290: , p4_a45 JTF_VARCHAR2_TABLE_100

Line 5297: , p4_a52 JTF_VARCHAR2_TABLE_2000

5293: , p4_a48 JTF_VARCHAR2_TABLE_100
5294: , p4_a49 JTF_VARCHAR2_TABLE_100
5295: , p4_a50 JTF_VARCHAR2_TABLE_100
5296: , p4_a51 JTF_VARCHAR2_TABLE_100
5297: , p4_a52 JTF_VARCHAR2_TABLE_2000
5298: , p4_a53 JTF_VARCHAR2_TABLE_100
5299: , p4_a54 JTF_VARCHAR2_TABLE_100
5300: , p4_a55 JTF_NUMBER_TABLE
5301: , p4_a56 JTF_VARCHAR2_TABLE_2000

Line 5301: , p4_a56 JTF_VARCHAR2_TABLE_2000

5297: , p4_a52 JTF_VARCHAR2_TABLE_2000
5298: , p4_a53 JTF_VARCHAR2_TABLE_100
5299: , p4_a54 JTF_VARCHAR2_TABLE_100
5300: , p4_a55 JTF_NUMBER_TABLE
5301: , p4_a56 JTF_VARCHAR2_TABLE_2000
5302: , p4_a57 JTF_VARCHAR2_TABLE_100
5303: , p4_a58 JTF_VARCHAR2_TABLE_100
5304: , p4_a59 JTF_VARCHAR2_TABLE_100
5305: , p_restrict_sql VARCHAR2

Line 5605: , p4_a41 JTF_VARCHAR2_TABLE_2000

5601: , p4_a37 JTF_VARCHAR2_TABLE_100
5602: , p4_a38 JTF_VARCHAR2_TABLE_100
5603: , p4_a39 JTF_NUMBER_TABLE
5604: , p4_a40 JTF_VARCHAR2_TABLE_100
5605: , p4_a41 JTF_VARCHAR2_TABLE_2000
5606: , p4_a42 JTF_VARCHAR2_TABLE_100
5607: , p4_a43 JTF_VARCHAR2_TABLE_4000
5608: , p4_a44 JTF_DATE_TABLE
5609: , p4_a45 JTF_VARCHAR2_TABLE_100

Line 5616: , p4_a52 JTF_VARCHAR2_TABLE_2000

5612: , p4_a48 JTF_VARCHAR2_TABLE_100
5613: , p4_a49 JTF_VARCHAR2_TABLE_100
5614: , p4_a50 JTF_VARCHAR2_TABLE_100
5615: , p4_a51 JTF_VARCHAR2_TABLE_100
5616: , p4_a52 JTF_VARCHAR2_TABLE_2000
5617: , p4_a53 JTF_VARCHAR2_TABLE_100
5618: , p4_a54 JTF_VARCHAR2_TABLE_100
5619: , p4_a55 JTF_NUMBER_TABLE
5620: , p4_a56 JTF_VARCHAR2_TABLE_2000

Line 5620: , p4_a56 JTF_VARCHAR2_TABLE_2000

5616: , p4_a52 JTF_VARCHAR2_TABLE_2000
5617: , p4_a53 JTF_VARCHAR2_TABLE_100
5618: , p4_a54 JTF_VARCHAR2_TABLE_100
5619: , p4_a55 JTF_NUMBER_TABLE
5620: , p4_a56 JTF_VARCHAR2_TABLE_2000
5621: , p4_a57 JTF_VARCHAR2_TABLE_100
5622: , p4_a58 JTF_VARCHAR2_TABLE_100
5623: , p4_a59 JTF_VARCHAR2_TABLE_100
5624: , x_search_ctx_id out nocopy NUMBER

Line 5843: , p3_a41 JTF_VARCHAR2_TABLE_2000

5839: , p3_a37 JTF_VARCHAR2_TABLE_100
5840: , p3_a38 JTF_VARCHAR2_TABLE_100
5841: , p3_a39 JTF_NUMBER_TABLE
5842: , p3_a40 JTF_VARCHAR2_TABLE_100
5843: , p3_a41 JTF_VARCHAR2_TABLE_2000
5844: , p3_a42 JTF_VARCHAR2_TABLE_100
5845: , p3_a43 JTF_VARCHAR2_TABLE_4000
5846: , p3_a44 JTF_DATE_TABLE
5847: , p3_a45 JTF_VARCHAR2_TABLE_100

Line 5854: , p3_a52 JTF_VARCHAR2_TABLE_2000

5850: , p3_a48 JTF_VARCHAR2_TABLE_100
5851: , p3_a49 JTF_VARCHAR2_TABLE_100
5852: , p3_a50 JTF_VARCHAR2_TABLE_100
5853: , p3_a51 JTF_VARCHAR2_TABLE_100
5854: , p3_a52 JTF_VARCHAR2_TABLE_2000
5855: , p3_a53 JTF_VARCHAR2_TABLE_100
5856: , p3_a54 JTF_VARCHAR2_TABLE_100
5857: , p3_a55 JTF_NUMBER_TABLE
5858: , p3_a56 JTF_VARCHAR2_TABLE_2000

Line 5858: , p3_a56 JTF_VARCHAR2_TABLE_2000

5854: , p3_a52 JTF_VARCHAR2_TABLE_2000
5855: , p3_a53 JTF_VARCHAR2_TABLE_100
5856: , p3_a54 JTF_VARCHAR2_TABLE_100
5857: , p3_a55 JTF_NUMBER_TABLE
5858: , p3_a56 JTF_VARCHAR2_TABLE_2000
5859: , p3_a57 JTF_VARCHAR2_TABLE_100
5860: , p3_a58 JTF_VARCHAR2_TABLE_100
5861: , p3_a59 JTF_VARCHAR2_TABLE_100
5862: , p_restrict_sql VARCHAR2

Line 6019: , p3_a41 JTF_VARCHAR2_TABLE_2000

6015: , p3_a37 JTF_VARCHAR2_TABLE_100
6016: , p3_a38 JTF_VARCHAR2_TABLE_100
6017: , p3_a39 JTF_NUMBER_TABLE
6018: , p3_a40 JTF_VARCHAR2_TABLE_100
6019: , p3_a41 JTF_VARCHAR2_TABLE_2000
6020: , p3_a42 JTF_VARCHAR2_TABLE_100
6021: , p3_a43 JTF_VARCHAR2_TABLE_4000
6022: , p3_a44 JTF_DATE_TABLE
6023: , p3_a45 JTF_VARCHAR2_TABLE_100

Line 6030: , p3_a52 JTF_VARCHAR2_TABLE_2000

6026: , p3_a48 JTF_VARCHAR2_TABLE_100
6027: , p3_a49 JTF_VARCHAR2_TABLE_100
6028: , p3_a50 JTF_VARCHAR2_TABLE_100
6029: , p3_a51 JTF_VARCHAR2_TABLE_100
6030: , p3_a52 JTF_VARCHAR2_TABLE_2000
6031: , p3_a53 JTF_VARCHAR2_TABLE_100
6032: , p3_a54 JTF_VARCHAR2_TABLE_100
6033: , p3_a55 JTF_NUMBER_TABLE
6034: , p3_a56 JTF_VARCHAR2_TABLE_2000

Line 6034: , p3_a56 JTF_VARCHAR2_TABLE_2000

6030: , p3_a52 JTF_VARCHAR2_TABLE_2000
6031: , p3_a53 JTF_VARCHAR2_TABLE_100
6032: , p3_a54 JTF_VARCHAR2_TABLE_100
6033: , p3_a55 JTF_NUMBER_TABLE
6034: , p3_a56 JTF_VARCHAR2_TABLE_2000
6035: , p3_a57 JTF_VARCHAR2_TABLE_100
6036: , p3_a58 JTF_VARCHAR2_TABLE_100
6037: , p3_a59 JTF_VARCHAR2_TABLE_100
6038: , x_search_ctx_id out nocopy NUMBER

Line 6508: , p7_a41 JTF_VARCHAR2_TABLE_2000

6504: , p7_a37 JTF_VARCHAR2_TABLE_100
6505: , p7_a38 JTF_VARCHAR2_TABLE_100
6506: , p7_a39 JTF_NUMBER_TABLE
6507: , p7_a40 JTF_VARCHAR2_TABLE_100
6508: , p7_a41 JTF_VARCHAR2_TABLE_2000
6509: , p7_a42 JTF_VARCHAR2_TABLE_100
6510: , p7_a43 JTF_VARCHAR2_TABLE_4000
6511: , p7_a44 JTF_DATE_TABLE
6512: , p7_a45 JTF_VARCHAR2_TABLE_100

Line 6519: , p7_a52 JTF_VARCHAR2_TABLE_2000

6515: , p7_a48 JTF_VARCHAR2_TABLE_100
6516: , p7_a49 JTF_VARCHAR2_TABLE_100
6517: , p7_a50 JTF_VARCHAR2_TABLE_100
6518: , p7_a51 JTF_VARCHAR2_TABLE_100
6519: , p7_a52 JTF_VARCHAR2_TABLE_2000
6520: , p7_a53 JTF_VARCHAR2_TABLE_100
6521: , p7_a54 JTF_VARCHAR2_TABLE_100
6522: , p7_a55 JTF_NUMBER_TABLE
6523: , p7_a56 JTF_VARCHAR2_TABLE_2000

Line 6523: , p7_a56 JTF_VARCHAR2_TABLE_2000

6519: , p7_a52 JTF_VARCHAR2_TABLE_2000
6520: , p7_a53 JTF_VARCHAR2_TABLE_100
6521: , p7_a54 JTF_VARCHAR2_TABLE_100
6522: , p7_a55 JTF_NUMBER_TABLE
6523: , p7_a56 JTF_VARCHAR2_TABLE_2000
6524: , p7_a57 JTF_VARCHAR2_TABLE_100
6525: , p7_a58 JTF_VARCHAR2_TABLE_100
6526: , p7_a59 JTF_VARCHAR2_TABLE_100
6527: , x_return_status out nocopy VARCHAR2

Line 7333: , p6_a41 JTF_VARCHAR2_TABLE_2000

7329: , p6_a37 JTF_VARCHAR2_TABLE_100
7330: , p6_a38 JTF_VARCHAR2_TABLE_100
7331: , p6_a39 JTF_NUMBER_TABLE
7332: , p6_a40 JTF_VARCHAR2_TABLE_100
7333: , p6_a41 JTF_VARCHAR2_TABLE_2000
7334: , p6_a42 JTF_VARCHAR2_TABLE_100
7335: , p6_a43 JTF_VARCHAR2_TABLE_4000
7336: , p6_a44 JTF_DATE_TABLE
7337: , p6_a45 JTF_VARCHAR2_TABLE_100

Line 7344: , p6_a52 JTF_VARCHAR2_TABLE_2000

7340: , p6_a48 JTF_VARCHAR2_TABLE_100
7341: , p6_a49 JTF_VARCHAR2_TABLE_100
7342: , p6_a50 JTF_VARCHAR2_TABLE_100
7343: , p6_a51 JTF_VARCHAR2_TABLE_100
7344: , p6_a52 JTF_VARCHAR2_TABLE_2000
7345: , p6_a53 JTF_VARCHAR2_TABLE_100
7346: , p6_a54 JTF_VARCHAR2_TABLE_100
7347: , p6_a55 JTF_NUMBER_TABLE
7348: , p6_a56 JTF_VARCHAR2_TABLE_2000

Line 7348: , p6_a56 JTF_VARCHAR2_TABLE_2000

7344: , p6_a52 JTF_VARCHAR2_TABLE_2000
7345: , p6_a53 JTF_VARCHAR2_TABLE_100
7346: , p6_a54 JTF_VARCHAR2_TABLE_100
7347: , p6_a55 JTF_NUMBER_TABLE
7348: , p6_a56 JTF_VARCHAR2_TABLE_2000
7349: , p6_a57 JTF_VARCHAR2_TABLE_100
7350: , p6_a58 JTF_VARCHAR2_TABLE_100
7351: , p6_a59 JTF_VARCHAR2_TABLE_100
7352: , x_search_ctx_id in out nocopy NUMBER

Line 8158: , p5_a41 JTF_VARCHAR2_TABLE_2000

8154: , p5_a37 JTF_VARCHAR2_TABLE_100
8155: , p5_a38 JTF_VARCHAR2_TABLE_100
8156: , p5_a39 JTF_NUMBER_TABLE
8157: , p5_a40 JTF_VARCHAR2_TABLE_100
8158: , p5_a41 JTF_VARCHAR2_TABLE_2000
8159: , p5_a42 JTF_VARCHAR2_TABLE_100
8160: , p5_a43 JTF_VARCHAR2_TABLE_4000
8161: , p5_a44 JTF_DATE_TABLE
8162: , p5_a45 JTF_VARCHAR2_TABLE_100

Line 8169: , p5_a52 JTF_VARCHAR2_TABLE_2000

8165: , p5_a48 JTF_VARCHAR2_TABLE_100
8166: , p5_a49 JTF_VARCHAR2_TABLE_100
8167: , p5_a50 JTF_VARCHAR2_TABLE_100
8168: , p5_a51 JTF_VARCHAR2_TABLE_100
8169: , p5_a52 JTF_VARCHAR2_TABLE_2000
8170: , p5_a53 JTF_VARCHAR2_TABLE_100
8171: , p5_a54 JTF_VARCHAR2_TABLE_100
8172: , p5_a55 JTF_NUMBER_TABLE
8173: , p5_a56 JTF_VARCHAR2_TABLE_2000

Line 8173: , p5_a56 JTF_VARCHAR2_TABLE_2000

8169: , p5_a52 JTF_VARCHAR2_TABLE_2000
8170: , p5_a53 JTF_VARCHAR2_TABLE_100
8171: , p5_a54 JTF_VARCHAR2_TABLE_100
8172: , p5_a55 JTF_NUMBER_TABLE
8173: , p5_a56 JTF_VARCHAR2_TABLE_2000
8174: , p5_a57 JTF_VARCHAR2_TABLE_100
8175: , p5_a58 JTF_VARCHAR2_TABLE_100
8176: , p5_a59 JTF_VARCHAR2_TABLE_100
8177: , p_restrict_sql VARCHAR2

Line 8997: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_2000

8993: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
8994: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
8995: , p6_a39 out nocopy JTF_NUMBER_TABLE
8996: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
8997: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_2000
8998: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
8999: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_4000
9000: , p6_a44 out nocopy JTF_DATE_TABLE
9001: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

Line 9008: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000

9004: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
9005: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
9006: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_100
9007: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
9008: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
9009: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
9010: , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
9011: , p6_a55 out nocopy JTF_NUMBER_TABLE
9012: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_2000

Line 9012: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_2000

9008: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
9009: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
9010: , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
9011: , p6_a55 out nocopy JTF_NUMBER_TABLE
9012: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_2000
9013: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
9014: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
9015: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
9016: , x_return_status out nocopy VARCHAR2

Line 9822: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_2000

9818: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
9819: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
9820: , p9_a39 out nocopy JTF_NUMBER_TABLE
9821: , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
9822: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_2000
9823: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
9824: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_4000
9825: , p9_a44 out nocopy JTF_DATE_TABLE
9826: , p9_a45 out nocopy JTF_VARCHAR2_TABLE_100

Line 9833: , p9_a52 out nocopy JTF_VARCHAR2_TABLE_2000

9829: , p9_a48 out nocopy JTF_VARCHAR2_TABLE_100
9830: , p9_a49 out nocopy JTF_VARCHAR2_TABLE_100
9831: , p9_a50 out nocopy JTF_VARCHAR2_TABLE_100
9832: , p9_a51 out nocopy JTF_VARCHAR2_TABLE_100
9833: , p9_a52 out nocopy JTF_VARCHAR2_TABLE_2000
9834: , p9_a53 out nocopy JTF_VARCHAR2_TABLE_100
9835: , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
9836: , p9_a55 out nocopy JTF_NUMBER_TABLE
9837: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_2000

Line 9837: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_2000

9833: , p9_a52 out nocopy JTF_VARCHAR2_TABLE_2000
9834: , p9_a53 out nocopy JTF_VARCHAR2_TABLE_100
9835: , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
9836: , p9_a55 out nocopy JTF_NUMBER_TABLE
9837: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_2000
9838: , p9_a57 out nocopy JTF_VARCHAR2_TABLE_100
9839: , p9_a58 out nocopy JTF_VARCHAR2_TABLE_100
9840: , p9_a59 out nocopy JTF_VARCHAR2_TABLE_100
9841: , x_return_status out nocopy VARCHAR2