DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB_W dependencies on JTF_VARCHAR2_TABLE_200

Line 13: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_web.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_web.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
14: , a1 JTF_VARCHAR2_TABLE_200
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100

Line 14: , a1 JTF_VARCHAR2_TABLE_200

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_web.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
14: , a1 JTF_VARCHAR2_TABLE_200
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100

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 56: procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200

52: end loop;
53: end if;
54: end if;
55: end rosetta_table_copy_in_p19;
56: procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
57: , a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , a1 out nocopy JTF_VARCHAR2_TABLE_200

53: end if;
54: end if;
55: end rosetta_table_copy_in_p19;
56: procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
57: , a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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 73: a0 := JTF_VARCHAR2_TABLE_200();

69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_VARCHAR2_TABLE_200();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();

Line 74: a1 := JTF_VARCHAR2_TABLE_200();

70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_VARCHAR2_TABLE_200();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();

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 87: a0 := JTF_VARCHAR2_TABLE_200();

83: a10 := JTF_DATE_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_VARCHAR2_TABLE_100();
91: a4 := JTF_VARCHAR2_TABLE_100();

Line 88: a1 := JTF_VARCHAR2_TABLE_200();

84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_VARCHAR2_TABLE_100();
91: a4 := JTF_VARCHAR2_TABLE_100();
92: a5 := JTF_VARCHAR2_TABLE_100();

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 630: , a6 JTF_VARCHAR2_TABLE_200

626: , a2 JTF_DATE_TABLE
627: , a3 JTF_DATE_TABLE
628: , a4 JTF_VARCHAR2_TABLE_100
629: , a5 JTF_VARCHAR2_TABLE_100
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

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 639: , a15 JTF_VARCHAR2_TABLE_200

635: , a11 JTF_VARCHAR2_TABLE_400
636: , a12 JTF_VARCHAR2_TABLE_400
637: , a13 JTF_NUMBER_TABLE
638: , a14 JTF_NUMBER_TABLE
639: , a15 JTF_VARCHAR2_TABLE_200
640: , a16 JTF_VARCHAR2_TABLE_100
641: , a17 JTF_VARCHAR2_TABLE_400
642: , a18 JTF_VARCHAR2_TABLE_300
643: , a19 JTF_VARCHAR2_TABLE_100

Line 695: , a6 out nocopy JTF_VARCHAR2_TABLE_200

691: , a2 out nocopy JTF_DATE_TABLE
692: , a3 out nocopy JTF_DATE_TABLE
693: , a4 out nocopy JTF_VARCHAR2_TABLE_100
694: , a5 out nocopy JTF_VARCHAR2_TABLE_100
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

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 704: , a15 out nocopy JTF_VARCHAR2_TABLE_200

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
704: , a15 out nocopy JTF_VARCHAR2_TABLE_200
705: , a16 out nocopy JTF_VARCHAR2_TABLE_100
706: , a17 out nocopy JTF_VARCHAR2_TABLE_400
707: , a18 out nocopy JTF_VARCHAR2_TABLE_300
708: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 723: a6 := JTF_VARCHAR2_TABLE_200();

719: a2 := JTF_DATE_TABLE();
720: a3 := JTF_DATE_TABLE();
721: a4 := JTF_VARCHAR2_TABLE_100();
722: a5 := JTF_VARCHAR2_TABLE_100();
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();

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 732: a15 := JTF_VARCHAR2_TABLE_200();

728: a11 := JTF_VARCHAR2_TABLE_400();
729: a12 := JTF_VARCHAR2_TABLE_400();
730: a13 := JTF_NUMBER_TABLE();
731: a14 := JTF_NUMBER_TABLE();
732: a15 := JTF_VARCHAR2_TABLE_200();
733: a16 := JTF_VARCHAR2_TABLE_100();
734: a17 := JTF_VARCHAR2_TABLE_400();
735: a18 := JTF_VARCHAR2_TABLE_300();
736: a19 := JTF_VARCHAR2_TABLE_100();

Line 748: a6 := JTF_VARCHAR2_TABLE_200();

744: a2 := JTF_DATE_TABLE();
745: a3 := JTF_DATE_TABLE();
746: a4 := JTF_VARCHAR2_TABLE_100();
747: a5 := JTF_VARCHAR2_TABLE_100();
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();

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 757: a15 := JTF_VARCHAR2_TABLE_200();

753: a11 := JTF_VARCHAR2_TABLE_400();
754: a12 := JTF_VARCHAR2_TABLE_400();
755: a13 := JTF_NUMBER_TABLE();
756: a14 := JTF_NUMBER_TABLE();
757: a15 := JTF_VARCHAR2_TABLE_200();
758: a16 := JTF_VARCHAR2_TABLE_100();
759: a17 := JTF_VARCHAR2_TABLE_400();
760: a18 := JTF_VARCHAR2_TABLE_300();
761: a19 := JTF_VARCHAR2_TABLE_100();

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 1916: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_200

1912: , p_account_id VARCHAR2
1913: , x_return_status out nocopy VARCHAR2
1914: , x_msg_count out nocopy NUMBER
1915: , x_msg_data out nocopy VARCHAR2
1916: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_200
1917: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_200
1918: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1919: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1920: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1917: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_200

1913: , x_return_status out nocopy VARCHAR2
1914: , x_msg_count out nocopy NUMBER
1915: , x_msg_data out nocopy VARCHAR2
1916: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_200
1917: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_200
1918: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
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

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 1998: , p25_a0 out nocopy JTF_VARCHAR2_TABLE_200

1994: , p21_a0 JTF_NUMBER_TABLE
1995: , x_return_status out nocopy VARCHAR2
1996: , x_msg_count out nocopy NUMBER
1997: , x_msg_data out nocopy VARCHAR2
1998: , p25_a0 out nocopy JTF_VARCHAR2_TABLE_200
1999: , p25_a1 out nocopy JTF_VARCHAR2_TABLE_200
2000: , p25_a2 out nocopy JTF_VARCHAR2_TABLE_100
2001: , p25_a3 out nocopy JTF_VARCHAR2_TABLE_100
2002: , p25_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1999: , p25_a1 out nocopy JTF_VARCHAR2_TABLE_200

1995: , x_return_status out nocopy VARCHAR2
1996: , x_msg_count out nocopy NUMBER
1997: , x_msg_data out nocopy VARCHAR2
1998: , p25_a0 out nocopy JTF_VARCHAR2_TABLE_200
1999: , p25_a1 out nocopy JTF_VARCHAR2_TABLE_200
2000: , p25_a2 out nocopy JTF_VARCHAR2_TABLE_100
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

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 2425: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_200

2421: , p6_a2 out nocopy JTF_DATE_TABLE
2422: , p6_a3 out nocopy JTF_DATE_TABLE
2423: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
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

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 2434: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200

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
2434: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
2435: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2436: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400
2437: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
2438: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 2583: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_200

2579: , p5_a2 out nocopy JTF_DATE_TABLE
2580: , p5_a3 out nocopy JTF_DATE_TABLE
2581: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2582: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
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

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 2592: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200

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
2592: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
2593: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
2594: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400
2595: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300
2596: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100

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;