DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 20: , a7 JTF_VARCHAR2_TABLE_2000

16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_300
20: , a7 JTF_VARCHAR2_TABLE_2000
21: , a8 JTF_DATE_TABLE
22: , a9 JTF_DATE_TABLE
23: , a10 JTF_DATE_TABLE
24: , a11 JTF_NUMBER_TABLE

Line 63: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_VARCHAR2_TABLE_300
63: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a8 out nocopy JTF_DATE_TABLE
65: , a9 out nocopy JTF_DATE_TABLE
66: , a10 out nocopy JTF_DATE_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE

Line 80: a7 := JTF_VARCHAR2_TABLE_2000();

76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_VARCHAR2_TABLE_300();
80: a7 := JTF_VARCHAR2_TABLE_2000();
81: a8 := JTF_DATE_TABLE();
82: a9 := JTF_DATE_TABLE();
83: a10 := JTF_DATE_TABLE();
84: a11 := JTF_NUMBER_TABLE();

Line 94: a7 := JTF_VARCHAR2_TABLE_2000();

90: a3 := JTF_VARCHAR2_TABLE_100();
91: a4 := JTF_VARCHAR2_TABLE_100();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_VARCHAR2_TABLE_300();
94: a7 := JTF_VARCHAR2_TABLE_2000();
95: a8 := JTF_DATE_TABLE();
96: a9 := JTF_DATE_TABLE();
97: a10 := JTF_DATE_TABLE();
98: a11 := JTF_NUMBER_TABLE();

Line 634: , a10 JTF_VARCHAR2_TABLE_2000

630: , a6 JTF_VARCHAR2_TABLE_200
631: , a7 JTF_VARCHAR2_TABLE_300
632: , a8 JTF_VARCHAR2_TABLE_500
633: , a9 JTF_VARCHAR2_TABLE_500
634: , a10 JTF_VARCHAR2_TABLE_2000
635: , a11 JTF_VARCHAR2_TABLE_400
636: , a12 JTF_VARCHAR2_TABLE_400
637: , a13 JTF_NUMBER_TABLE
638: , a14 JTF_NUMBER_TABLE

Line 699: , a10 out nocopy JTF_VARCHAR2_TABLE_2000

695: , a6 out nocopy JTF_VARCHAR2_TABLE_200
696: , a7 out nocopy JTF_VARCHAR2_TABLE_300
697: , a8 out nocopy JTF_VARCHAR2_TABLE_500
698: , a9 out nocopy JTF_VARCHAR2_TABLE_500
699: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
700: , a11 out nocopy JTF_VARCHAR2_TABLE_400
701: , a12 out nocopy JTF_VARCHAR2_TABLE_400
702: , a13 out nocopy JTF_NUMBER_TABLE
703: , a14 out nocopy JTF_NUMBER_TABLE

Line 727: a10 := JTF_VARCHAR2_TABLE_2000();

723: a6 := JTF_VARCHAR2_TABLE_200();
724: a7 := JTF_VARCHAR2_TABLE_300();
725: a8 := JTF_VARCHAR2_TABLE_500();
726: a9 := JTF_VARCHAR2_TABLE_500();
727: a10 := JTF_VARCHAR2_TABLE_2000();
728: a11 := JTF_VARCHAR2_TABLE_400();
729: a12 := JTF_VARCHAR2_TABLE_400();
730: a13 := JTF_NUMBER_TABLE();
731: a14 := JTF_NUMBER_TABLE();

Line 752: a10 := JTF_VARCHAR2_TABLE_2000();

748: a6 := JTF_VARCHAR2_TABLE_200();
749: a7 := JTF_VARCHAR2_TABLE_300();
750: a8 := JTF_VARCHAR2_TABLE_500();
751: a9 := JTF_VARCHAR2_TABLE_500();
752: a10 := JTF_VARCHAR2_TABLE_2000();
753: a11 := JTF_VARCHAR2_TABLE_400();
754: a12 := JTF_VARCHAR2_TABLE_400();
755: a13 := JTF_NUMBER_TABLE();
756: a14 := JTF_NUMBER_TABLE();

Line 929: , a2 JTF_VARCHAR2_TABLE_2000

925: end rosetta_table_copy_out_p41;
926:
927: procedure rosetta_table_copy_in_p43(t out nocopy oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_100
928: , a1 JTF_VARCHAR2_TABLE_100
929: , a2 JTF_VARCHAR2_TABLE_2000
930: , a3 JTF_VARCHAR2_TABLE_100
931: , a4 JTF_VARCHAR2_TABLE_100
932: , a5 JTF_VARCHAR2_TABLE_100
933: , a6 JTF_VARCHAR2_TABLE_100

Line 962: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

958: end if;
959: end rosetta_table_copy_in_p43;
960: procedure rosetta_table_copy_out_p43(t oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
961: , a1 out nocopy JTF_VARCHAR2_TABLE_100
962: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
963: , a3 out nocopy JTF_VARCHAR2_TABLE_100
964: , a4 out nocopy JTF_VARCHAR2_TABLE_100
965: , a5 out nocopy JTF_VARCHAR2_TABLE_100
966: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 974: a2 := JTF_VARCHAR2_TABLE_2000();

970: begin
971: if t is null or t.count = 0 then
972: a0 := JTF_VARCHAR2_TABLE_100();
973: a1 := JTF_VARCHAR2_TABLE_100();
974: a2 := JTF_VARCHAR2_TABLE_2000();
975: a3 := JTF_VARCHAR2_TABLE_100();
976: a4 := JTF_VARCHAR2_TABLE_100();
977: a5 := JTF_VARCHAR2_TABLE_100();
978: a6 := JTF_VARCHAR2_TABLE_100();

Line 983: a2 := JTF_VARCHAR2_TABLE_2000();

979: a7 := JTF_VARCHAR2_TABLE_100();
980: else
981: a0 := JTF_VARCHAR2_TABLE_100();
982: a1 := JTF_VARCHAR2_TABLE_100();
983: a2 := JTF_VARCHAR2_TABLE_2000();
984: a3 := JTF_VARCHAR2_TABLE_100();
985: a4 := JTF_VARCHAR2_TABLE_100();
986: a5 := JTF_VARCHAR2_TABLE_100();
987: a6 := JTF_VARCHAR2_TABLE_100();

Line 1687: , a2 JTF_VARCHAR2_TABLE_2000

1683: end rosetta_table_copy_out_p62;
1684:
1685: procedure rosetta_table_copy_in_p65(t out nocopy oks_entitlements_web.covered_prods_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1686: , a1 JTF_VARCHAR2_TABLE_500
1687: , a2 JTF_VARCHAR2_TABLE_2000
1688: , a3 JTF_VARCHAR2_TABLE_500
1689: , a4 JTF_VARCHAR2_TABLE_500
1690: , a5 JTF_VARCHAR2_TABLE_500
1691: , a6 JTF_VARCHAR2_TABLE_500

Line 1700: , a15 JTF_VARCHAR2_TABLE_2000

1696: , a11 JTF_VARCHAR2_TABLE_500
1697: , a12 JTF_VARCHAR2_TABLE_500
1698: , a13 JTF_VARCHAR2_TABLE_500
1699: , a14 JTF_VARCHAR2_TABLE_500
1700: , a15 JTF_VARCHAR2_TABLE_2000
1701: , a16 JTF_VARCHAR2_TABLE_2000
1702: ) as
1703: ddindx binary_integer; indx binary_integer;
1704: begin

Line 1701: , a16 JTF_VARCHAR2_TABLE_2000

1697: , a12 JTF_VARCHAR2_TABLE_500
1698: , a13 JTF_VARCHAR2_TABLE_500
1699: , a14 JTF_VARCHAR2_TABLE_500
1700: , a15 JTF_VARCHAR2_TABLE_2000
1701: , a16 JTF_VARCHAR2_TABLE_2000
1702: ) as
1703: ddindx binary_integer; indx binary_integer;
1704: begin
1705: if a0 is not null and a0.count > 0 then

Line 1738: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

1734: end if;
1735: end rosetta_table_copy_in_p65;
1736: procedure rosetta_table_copy_out_p65(t oks_entitlements_web.covered_prods_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1737: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1738: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
1739: , a3 out nocopy JTF_VARCHAR2_TABLE_500
1740: , a4 out nocopy JTF_VARCHAR2_TABLE_500
1741: , a5 out nocopy JTF_VARCHAR2_TABLE_500
1742: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 1751: , a15 out nocopy JTF_VARCHAR2_TABLE_2000

1747: , a11 out nocopy JTF_VARCHAR2_TABLE_500
1748: , a12 out nocopy JTF_VARCHAR2_TABLE_500
1749: , a13 out nocopy JTF_VARCHAR2_TABLE_500
1750: , a14 out nocopy JTF_VARCHAR2_TABLE_500
1751: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
1752: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
1753: ) as
1754: ddindx binary_integer; indx binary_integer;
1755: begin

Line 1752: , a16 out nocopy JTF_VARCHAR2_TABLE_2000

1748: , a12 out nocopy JTF_VARCHAR2_TABLE_500
1749: , a13 out nocopy JTF_VARCHAR2_TABLE_500
1750: , a14 out nocopy JTF_VARCHAR2_TABLE_500
1751: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
1752: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
1753: ) as
1754: ddindx binary_integer; indx binary_integer;
1755: begin
1756: if t is null or t.count = 0 then

Line 1759: a2 := JTF_VARCHAR2_TABLE_2000();

1755: begin
1756: if t is null or t.count = 0 then
1757: a0 := JTF_VARCHAR2_TABLE_500();
1758: a1 := JTF_VARCHAR2_TABLE_500();
1759: a2 := JTF_VARCHAR2_TABLE_2000();
1760: a3 := JTF_VARCHAR2_TABLE_500();
1761: a4 := JTF_VARCHAR2_TABLE_500();
1762: a5 := JTF_VARCHAR2_TABLE_500();
1763: a6 := JTF_VARCHAR2_TABLE_500();

Line 1772: a15 := JTF_VARCHAR2_TABLE_2000();

1768: a11 := JTF_VARCHAR2_TABLE_500();
1769: a12 := JTF_VARCHAR2_TABLE_500();
1770: a13 := JTF_VARCHAR2_TABLE_500();
1771: a14 := JTF_VARCHAR2_TABLE_500();
1772: a15 := JTF_VARCHAR2_TABLE_2000();
1773: a16 := JTF_VARCHAR2_TABLE_2000();
1774: else
1775: a0 := JTF_VARCHAR2_TABLE_500();
1776: a1 := JTF_VARCHAR2_TABLE_500();

Line 1773: a16 := JTF_VARCHAR2_TABLE_2000();

1769: a12 := JTF_VARCHAR2_TABLE_500();
1770: a13 := JTF_VARCHAR2_TABLE_500();
1771: a14 := JTF_VARCHAR2_TABLE_500();
1772: a15 := JTF_VARCHAR2_TABLE_2000();
1773: a16 := JTF_VARCHAR2_TABLE_2000();
1774: else
1775: a0 := JTF_VARCHAR2_TABLE_500();
1776: a1 := JTF_VARCHAR2_TABLE_500();
1777: a2 := JTF_VARCHAR2_TABLE_2000();

Line 1777: a2 := JTF_VARCHAR2_TABLE_2000();

1773: a16 := JTF_VARCHAR2_TABLE_2000();
1774: else
1775: a0 := JTF_VARCHAR2_TABLE_500();
1776: a1 := JTF_VARCHAR2_TABLE_500();
1777: a2 := JTF_VARCHAR2_TABLE_2000();
1778: a3 := JTF_VARCHAR2_TABLE_500();
1779: a4 := JTF_VARCHAR2_TABLE_500();
1780: a5 := JTF_VARCHAR2_TABLE_500();
1781: a6 := JTF_VARCHAR2_TABLE_500();

Line 1790: a15 := JTF_VARCHAR2_TABLE_2000();

1786: a11 := JTF_VARCHAR2_TABLE_500();
1787: a12 := JTF_VARCHAR2_TABLE_500();
1788: a13 := JTF_VARCHAR2_TABLE_500();
1789: a14 := JTF_VARCHAR2_TABLE_500();
1790: a15 := JTF_VARCHAR2_TABLE_2000();
1791: a16 := JTF_VARCHAR2_TABLE_2000();
1792: if t.count > 0 then
1793: a0.extend(t.count);
1794: a1.extend(t.count);

Line 1791: a16 := JTF_VARCHAR2_TABLE_2000();

1787: a12 := JTF_VARCHAR2_TABLE_500();
1788: a13 := JTF_VARCHAR2_TABLE_500();
1789: a14 := JTF_VARCHAR2_TABLE_500();
1790: a15 := JTF_VARCHAR2_TABLE_2000();
1791: a16 := JTF_VARCHAR2_TABLE_2000();
1792: if t.count > 0 then
1793: a0.extend(t.count);
1794: a1.extend(t.count);
1795: a2.extend(t.count);

Line 1923: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_2000

1919: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1920: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1921: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1922: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
1923: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1924: , p5_a8 out nocopy JTF_DATE_TABLE
1925: , p5_a9 out nocopy JTF_DATE_TABLE
1926: , p5_a10 out nocopy JTF_DATE_TABLE
1927: , p5_a11 out nocopy JTF_NUMBER_TABLE

Line 2005: , p25_a7 out nocopy JTF_VARCHAR2_TABLE_2000

2001: , p25_a3 out nocopy JTF_VARCHAR2_TABLE_100
2002: , p25_a4 out nocopy JTF_VARCHAR2_TABLE_100
2003: , p25_a5 out nocopy JTF_VARCHAR2_TABLE_100
2004: , p25_a6 out nocopy JTF_VARCHAR2_TABLE_300
2005: , p25_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p25_a8 out nocopy JTF_DATE_TABLE
2007: , p25_a9 out nocopy JTF_DATE_TABLE
2008: , p25_a10 out nocopy JTF_DATE_TABLE
2009: , p25_a11 out nocopy JTF_NUMBER_TABLE

Line 2429: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000

2425: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_200
2426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
2427: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
2428: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
2429: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
2430: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
2431: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_400
2432: , p6_a13 out nocopy JTF_NUMBER_TABLE
2433: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 2587: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_2000

2583: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_200
2584: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_300
2585: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_500
2586: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_500
2587: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_2000
2588: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_400
2589: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_400
2590: , p5_a13 out nocopy JTF_NUMBER_TABLE
2591: , p5_a14 out nocopy JTF_NUMBER_TABLE

Line 2745: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_2000

2741: procedure party_contacts_overview(p_contact_id_arg VARCHAR2
2742: , x_return_status out nocopy VARCHAR2
2743: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_2000
2746: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
2748: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
2749: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 3077: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000

3073: , p2_a7 out nocopy VARCHAR2
3074: , p2_a8 out nocopy NUMBER
3075: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_500
3076: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_500
3077: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
3078: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_500
3079: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_500
3080: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_500
3081: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 3090: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_2000

3086: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_500
3087: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_500
3088: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_500
3089: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_500
3090: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_2000
3091: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_2000
3092: )
3093:
3094: as

Line 3091: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_2000

3087: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_500
3088: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_500
3089: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_500
3090: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_2000
3091: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_2000
3092: )
3093:
3094: as
3095: ddx_usage_hdr_rec_type oks_entitlements_web.usage_hdr_rec_type;