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.PV_TERR_ASSIGN_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: , a3 JTF_VARCHAR2_TABLE_100

12:
13: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100

Line 17: , a4 JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100

Line 18: , a5 JTF_VARCHAR2_TABLE_100

14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100

Line 19: , a6 JTF_VARCHAR2_TABLE_100

15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE

Line 20: , a7 JTF_VARCHAR2_TABLE_100

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

Line 21: , a8 JTF_VARCHAR2_TABLE_100

17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100

Line 22: , a9 JTF_VARCHAR2_TABLE_100

18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_500

Line 25: , a12 JTF_VARCHAR2_TABLE_100

21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_500
27: , a14 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;

Line 27: , a14 JTF_VARCHAR2_TABLE_100

23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_500
27: , a14 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin
31: if a0 is not null and a0.count > 0 then

Line 63: , a3 out nocopy JTF_VARCHAR2_TABLE_100

59: end rosetta_table_copy_in_p15;
60: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , a4 out nocopy JTF_VARCHAR2_TABLE_100

60: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 65: , a5 out nocopy JTF_VARCHAR2_TABLE_100

61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 66: , a6 out nocopy JTF_VARCHAR2_TABLE_100

62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_NUMBER_TABLE

Line 67: , a7 out nocopy JTF_VARCHAR2_TABLE_100

63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_NUMBER_TABLE
71: , a11 out nocopy JTF_NUMBER_TABLE

Line 68: , a8 out nocopy JTF_VARCHAR2_TABLE_100

64: , a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_NUMBER_TABLE
71: , a11 out nocopy JTF_NUMBER_TABLE
72: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 69: , a9 out nocopy JTF_VARCHAR2_TABLE_100

65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_NUMBER_TABLE
71: , a11 out nocopy JTF_NUMBER_TABLE
72: , a12 out nocopy JTF_VARCHAR2_TABLE_100
73: , a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 72: , a12 out nocopy JTF_VARCHAR2_TABLE_100

68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_NUMBER_TABLE
71: , a11 out nocopy JTF_NUMBER_TABLE
72: , a12 out nocopy JTF_VARCHAR2_TABLE_100
73: , a13 out nocopy JTF_VARCHAR2_TABLE_500
74: , a14 out nocopy JTF_VARCHAR2_TABLE_100
75: ) as
76: ddindx binary_integer; indx binary_integer;

Line 74: , a14 out nocopy JTF_VARCHAR2_TABLE_100

70: , a10 out nocopy JTF_NUMBER_TABLE
71: , a11 out nocopy JTF_NUMBER_TABLE
72: , a12 out nocopy JTF_VARCHAR2_TABLE_100
73: , a13 out nocopy JTF_VARCHAR2_TABLE_500
74: , a14 out nocopy JTF_VARCHAR2_TABLE_100
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then

Line 82: a3 := JTF_VARCHAR2_TABLE_100();

78: if t is null or t.count = 0 then
79: a0 := JTF_VARCHAR2_TABLE_400();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_VARCHAR2_TABLE_100();

Line 83: a4 := JTF_VARCHAR2_TABLE_100();

79: a0 := JTF_VARCHAR2_TABLE_400();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_VARCHAR2_TABLE_100();
87: a8 := JTF_VARCHAR2_TABLE_100();

Line 84: a5 := JTF_VARCHAR2_TABLE_100();

80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_VARCHAR2_TABLE_100();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();

Line 85: a6 := JTF_VARCHAR2_TABLE_100();

81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_VARCHAR2_TABLE_100();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();

Line 86: a7 := JTF_VARCHAR2_TABLE_100();

82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_VARCHAR2_TABLE_100();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();
90: a11 := JTF_NUMBER_TABLE();

Line 87: a8 := JTF_VARCHAR2_TABLE_100();

83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_VARCHAR2_TABLE_100();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: a12 := JTF_VARCHAR2_TABLE_100();

Line 88: a9 := JTF_VARCHAR2_TABLE_100();

84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_VARCHAR2_TABLE_100();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: a12 := JTF_VARCHAR2_TABLE_100();
92: a13 := JTF_VARCHAR2_TABLE_500();

Line 91: a12 := JTF_VARCHAR2_TABLE_100();

87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: a12 := JTF_VARCHAR2_TABLE_100();
92: a13 := JTF_VARCHAR2_TABLE_500();
93: a14 := JTF_VARCHAR2_TABLE_100();
94: else
95: a0 := JTF_VARCHAR2_TABLE_400();

Line 93: a14 := JTF_VARCHAR2_TABLE_100();

89: a10 := JTF_NUMBER_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: a12 := JTF_VARCHAR2_TABLE_100();
92: a13 := JTF_VARCHAR2_TABLE_500();
93: a14 := JTF_VARCHAR2_TABLE_100();
94: else
95: a0 := JTF_VARCHAR2_TABLE_400();
96: a1 := JTF_NUMBER_TABLE();
97: a2 := JTF_NUMBER_TABLE();

Line 98: a3 := JTF_VARCHAR2_TABLE_100();

94: else
95: a0 := JTF_VARCHAR2_TABLE_400();
96: a1 := JTF_NUMBER_TABLE();
97: a2 := JTF_NUMBER_TABLE();
98: a3 := JTF_VARCHAR2_TABLE_100();
99: a4 := JTF_VARCHAR2_TABLE_100();
100: a5 := JTF_VARCHAR2_TABLE_100();
101: a6 := JTF_VARCHAR2_TABLE_100();
102: a7 := JTF_VARCHAR2_TABLE_100();

Line 99: a4 := JTF_VARCHAR2_TABLE_100();

95: a0 := JTF_VARCHAR2_TABLE_400();
96: a1 := JTF_NUMBER_TABLE();
97: a2 := JTF_NUMBER_TABLE();
98: a3 := JTF_VARCHAR2_TABLE_100();
99: a4 := JTF_VARCHAR2_TABLE_100();
100: a5 := JTF_VARCHAR2_TABLE_100();
101: a6 := JTF_VARCHAR2_TABLE_100();
102: a7 := JTF_VARCHAR2_TABLE_100();
103: a8 := JTF_VARCHAR2_TABLE_100();

Line 100: a5 := JTF_VARCHAR2_TABLE_100();

96: a1 := JTF_NUMBER_TABLE();
97: a2 := JTF_NUMBER_TABLE();
98: a3 := JTF_VARCHAR2_TABLE_100();
99: a4 := JTF_VARCHAR2_TABLE_100();
100: a5 := JTF_VARCHAR2_TABLE_100();
101: a6 := JTF_VARCHAR2_TABLE_100();
102: a7 := JTF_VARCHAR2_TABLE_100();
103: a8 := JTF_VARCHAR2_TABLE_100();
104: a9 := JTF_VARCHAR2_TABLE_100();

Line 101: a6 := JTF_VARCHAR2_TABLE_100();

97: a2 := JTF_NUMBER_TABLE();
98: a3 := JTF_VARCHAR2_TABLE_100();
99: a4 := JTF_VARCHAR2_TABLE_100();
100: a5 := JTF_VARCHAR2_TABLE_100();
101: a6 := JTF_VARCHAR2_TABLE_100();
102: a7 := JTF_VARCHAR2_TABLE_100();
103: a8 := JTF_VARCHAR2_TABLE_100();
104: a9 := JTF_VARCHAR2_TABLE_100();
105: a10 := JTF_NUMBER_TABLE();

Line 102: a7 := JTF_VARCHAR2_TABLE_100();

98: a3 := JTF_VARCHAR2_TABLE_100();
99: a4 := JTF_VARCHAR2_TABLE_100();
100: a5 := JTF_VARCHAR2_TABLE_100();
101: a6 := JTF_VARCHAR2_TABLE_100();
102: a7 := JTF_VARCHAR2_TABLE_100();
103: a8 := JTF_VARCHAR2_TABLE_100();
104: a9 := JTF_VARCHAR2_TABLE_100();
105: a10 := JTF_NUMBER_TABLE();
106: a11 := JTF_NUMBER_TABLE();

Line 103: a8 := JTF_VARCHAR2_TABLE_100();

99: a4 := JTF_VARCHAR2_TABLE_100();
100: a5 := JTF_VARCHAR2_TABLE_100();
101: a6 := JTF_VARCHAR2_TABLE_100();
102: a7 := JTF_VARCHAR2_TABLE_100();
103: a8 := JTF_VARCHAR2_TABLE_100();
104: a9 := JTF_VARCHAR2_TABLE_100();
105: a10 := JTF_NUMBER_TABLE();
106: a11 := JTF_NUMBER_TABLE();
107: a12 := JTF_VARCHAR2_TABLE_100();

Line 104: a9 := JTF_VARCHAR2_TABLE_100();

100: a5 := JTF_VARCHAR2_TABLE_100();
101: a6 := JTF_VARCHAR2_TABLE_100();
102: a7 := JTF_VARCHAR2_TABLE_100();
103: a8 := JTF_VARCHAR2_TABLE_100();
104: a9 := JTF_VARCHAR2_TABLE_100();
105: a10 := JTF_NUMBER_TABLE();
106: a11 := JTF_NUMBER_TABLE();
107: a12 := JTF_VARCHAR2_TABLE_100();
108: a13 := JTF_VARCHAR2_TABLE_500();

Line 107: a12 := JTF_VARCHAR2_TABLE_100();

103: a8 := JTF_VARCHAR2_TABLE_100();
104: a9 := JTF_VARCHAR2_TABLE_100();
105: a10 := JTF_NUMBER_TABLE();
106: a11 := JTF_NUMBER_TABLE();
107: a12 := JTF_VARCHAR2_TABLE_100();
108: a13 := JTF_VARCHAR2_TABLE_500();
109: a14 := JTF_VARCHAR2_TABLE_100();
110: if t.count > 0 then
111: a0.extend(t.count);

Line 109: a14 := JTF_VARCHAR2_TABLE_100();

105: a10 := JTF_NUMBER_TABLE();
106: a11 := JTF_NUMBER_TABLE();
107: a12 := JTF_VARCHAR2_TABLE_100();
108: a13 := JTF_VARCHAR2_TABLE_500();
109: a14 := JTF_VARCHAR2_TABLE_100();
110: if t.count > 0 then
111: a0.extend(t.count);
112: a1.extend(t.count);
113: a2.extend(t.count);

Line 154: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100

150: end if;
151: end if;
152: end rosetta_table_copy_out_p15;
153:
154: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
155: , a1 JTF_VARCHAR2_TABLE_100
156: , a2 JTF_VARCHAR2_TABLE_100
157: , a3 JTF_VARCHAR2_TABLE_100
158: , a4 JTF_VARCHAR2_TABLE_100

Line 155: , a1 JTF_VARCHAR2_TABLE_100

151: end if;
152: end rosetta_table_copy_out_p15;
153:
154: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
155: , a1 JTF_VARCHAR2_TABLE_100
156: , a2 JTF_VARCHAR2_TABLE_100
157: , a3 JTF_VARCHAR2_TABLE_100
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100

Line 156: , a2 JTF_VARCHAR2_TABLE_100

152: end rosetta_table_copy_out_p15;
153:
154: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
155: , a1 JTF_VARCHAR2_TABLE_100
156: , a2 JTF_VARCHAR2_TABLE_100
157: , a3 JTF_VARCHAR2_TABLE_100
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100

Line 157: , a3 JTF_VARCHAR2_TABLE_100

153:
154: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
155: , a1 JTF_VARCHAR2_TABLE_100
156: , a2 JTF_VARCHAR2_TABLE_100
157: , a3 JTF_VARCHAR2_TABLE_100
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_VARCHAR2_TABLE_100

Line 158: , a4 JTF_VARCHAR2_TABLE_100

154: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
155: , a1 JTF_VARCHAR2_TABLE_100
156: , a2 JTF_VARCHAR2_TABLE_100
157: , a3 JTF_VARCHAR2_TABLE_100
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_VARCHAR2_TABLE_100
162: , a8 JTF_VARCHAR2_TABLE_100

Line 159: , a5 JTF_VARCHAR2_TABLE_100

155: , a1 JTF_VARCHAR2_TABLE_100
156: , a2 JTF_VARCHAR2_TABLE_100
157: , a3 JTF_VARCHAR2_TABLE_100
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_VARCHAR2_TABLE_100
162: , a8 JTF_VARCHAR2_TABLE_100
163: , a9 JTF_VARCHAR2_TABLE_100

Line 160: , a6 JTF_VARCHAR2_TABLE_100

156: , a2 JTF_VARCHAR2_TABLE_100
157: , a3 JTF_VARCHAR2_TABLE_100
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_VARCHAR2_TABLE_100
162: , a8 JTF_VARCHAR2_TABLE_100
163: , a9 JTF_VARCHAR2_TABLE_100
164: , a10 JTF_VARCHAR2_TABLE_100

Line 161: , a7 JTF_VARCHAR2_TABLE_100

157: , a3 JTF_VARCHAR2_TABLE_100
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_VARCHAR2_TABLE_100
162: , a8 JTF_VARCHAR2_TABLE_100
163: , a9 JTF_VARCHAR2_TABLE_100
164: , a10 JTF_VARCHAR2_TABLE_100
165: , a11 JTF_VARCHAR2_TABLE_100

Line 162: , a8 JTF_VARCHAR2_TABLE_100

158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_VARCHAR2_TABLE_100
162: , a8 JTF_VARCHAR2_TABLE_100
163: , a9 JTF_VARCHAR2_TABLE_100
164: , a10 JTF_VARCHAR2_TABLE_100
165: , a11 JTF_VARCHAR2_TABLE_100
166: , a12 JTF_VARCHAR2_TABLE_100

Line 163: , a9 JTF_VARCHAR2_TABLE_100

159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_VARCHAR2_TABLE_100
162: , a8 JTF_VARCHAR2_TABLE_100
163: , a9 JTF_VARCHAR2_TABLE_100
164: , a10 JTF_VARCHAR2_TABLE_100
165: , a11 JTF_VARCHAR2_TABLE_100
166: , a12 JTF_VARCHAR2_TABLE_100
167: , a13 JTF_VARCHAR2_TABLE_100

Line 164: , a10 JTF_VARCHAR2_TABLE_100

160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_VARCHAR2_TABLE_100
162: , a8 JTF_VARCHAR2_TABLE_100
163: , a9 JTF_VARCHAR2_TABLE_100
164: , a10 JTF_VARCHAR2_TABLE_100
165: , a11 JTF_VARCHAR2_TABLE_100
166: , a12 JTF_VARCHAR2_TABLE_100
167: , a13 JTF_VARCHAR2_TABLE_100
168: ) as

Line 165: , a11 JTF_VARCHAR2_TABLE_100

161: , a7 JTF_VARCHAR2_TABLE_100
162: , a8 JTF_VARCHAR2_TABLE_100
163: , a9 JTF_VARCHAR2_TABLE_100
164: , a10 JTF_VARCHAR2_TABLE_100
165: , a11 JTF_VARCHAR2_TABLE_100
166: , a12 JTF_VARCHAR2_TABLE_100
167: , a13 JTF_VARCHAR2_TABLE_100
168: ) as
169: ddindx binary_integer; indx binary_integer;

Line 166: , a12 JTF_VARCHAR2_TABLE_100

162: , a8 JTF_VARCHAR2_TABLE_100
163: , a9 JTF_VARCHAR2_TABLE_100
164: , a10 JTF_VARCHAR2_TABLE_100
165: , a11 JTF_VARCHAR2_TABLE_100
166: , a12 JTF_VARCHAR2_TABLE_100
167: , a13 JTF_VARCHAR2_TABLE_100
168: ) as
169: ddindx binary_integer; indx binary_integer;
170: begin

Line 167: , a13 JTF_VARCHAR2_TABLE_100

163: , a9 JTF_VARCHAR2_TABLE_100
164: , a10 JTF_VARCHAR2_TABLE_100
165: , a11 JTF_VARCHAR2_TABLE_100
166: , a12 JTF_VARCHAR2_TABLE_100
167: , a13 JTF_VARCHAR2_TABLE_100
168: ) as
169: ddindx binary_integer; indx binary_integer;
170: begin
171: if a0 is not null and a0.count > 0 then

Line 199: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

195: end loop;
196: end if;
197: end if;
198: end rosetta_table_copy_in_p19;
199: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , a1 out nocopy JTF_VARCHAR2_TABLE_100
201: , a2 out nocopy JTF_VARCHAR2_TABLE_100
202: , a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 200: , a1 out nocopy JTF_VARCHAR2_TABLE_100

196: end if;
197: end if;
198: end rosetta_table_copy_in_p19;
199: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , a1 out nocopy JTF_VARCHAR2_TABLE_100
201: , a2 out nocopy JTF_VARCHAR2_TABLE_100
202: , a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: , a2 out nocopy JTF_VARCHAR2_TABLE_100

197: end if;
198: end rosetta_table_copy_in_p19;
199: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , a1 out nocopy JTF_VARCHAR2_TABLE_100
201: , a2 out nocopy JTF_VARCHAR2_TABLE_100
202: , a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , a5 out nocopy JTF_VARCHAR2_TABLE_100
205: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 202: , a3 out nocopy JTF_VARCHAR2_TABLE_100

198: end rosetta_table_copy_in_p19;
199: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , a1 out nocopy JTF_VARCHAR2_TABLE_100
201: , a2 out nocopy JTF_VARCHAR2_TABLE_100
202: , a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , a5 out nocopy JTF_VARCHAR2_TABLE_100
205: , a6 out nocopy JTF_VARCHAR2_TABLE_100
206: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 203: , a4 out nocopy JTF_VARCHAR2_TABLE_100

199: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , a1 out nocopy JTF_VARCHAR2_TABLE_100
201: , a2 out nocopy JTF_VARCHAR2_TABLE_100
202: , a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , a5 out nocopy JTF_VARCHAR2_TABLE_100
205: , a6 out nocopy JTF_VARCHAR2_TABLE_100
206: , a7 out nocopy JTF_VARCHAR2_TABLE_100
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 204: , a5 out nocopy JTF_VARCHAR2_TABLE_100

200: , a1 out nocopy JTF_VARCHAR2_TABLE_100
201: , a2 out nocopy JTF_VARCHAR2_TABLE_100
202: , a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , a5 out nocopy JTF_VARCHAR2_TABLE_100
205: , a6 out nocopy JTF_VARCHAR2_TABLE_100
206: , a7 out nocopy JTF_VARCHAR2_TABLE_100
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 205: , a6 out nocopy JTF_VARCHAR2_TABLE_100

201: , a2 out nocopy JTF_VARCHAR2_TABLE_100
202: , a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , a5 out nocopy JTF_VARCHAR2_TABLE_100
205: , a6 out nocopy JTF_VARCHAR2_TABLE_100
206: , a7 out nocopy JTF_VARCHAR2_TABLE_100
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_100
209: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 206: , a7 out nocopy JTF_VARCHAR2_TABLE_100

202: , a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , a5 out nocopy JTF_VARCHAR2_TABLE_100
205: , a6 out nocopy JTF_VARCHAR2_TABLE_100
206: , a7 out nocopy JTF_VARCHAR2_TABLE_100
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_100
209: , a10 out nocopy JTF_VARCHAR2_TABLE_100
210: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 207: , a8 out nocopy JTF_VARCHAR2_TABLE_100

203: , a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , a5 out nocopy JTF_VARCHAR2_TABLE_100
205: , a6 out nocopy JTF_VARCHAR2_TABLE_100
206: , a7 out nocopy JTF_VARCHAR2_TABLE_100
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_100
209: , a10 out nocopy JTF_VARCHAR2_TABLE_100
210: , a11 out nocopy JTF_VARCHAR2_TABLE_100
211: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 208: , a9 out nocopy JTF_VARCHAR2_TABLE_100

204: , a5 out nocopy JTF_VARCHAR2_TABLE_100
205: , a6 out nocopy JTF_VARCHAR2_TABLE_100
206: , a7 out nocopy JTF_VARCHAR2_TABLE_100
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_100
209: , a10 out nocopy JTF_VARCHAR2_TABLE_100
210: , a11 out nocopy JTF_VARCHAR2_TABLE_100
211: , a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 209: , a10 out nocopy JTF_VARCHAR2_TABLE_100

205: , a6 out nocopy JTF_VARCHAR2_TABLE_100
206: , a7 out nocopy JTF_VARCHAR2_TABLE_100
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_100
209: , a10 out nocopy JTF_VARCHAR2_TABLE_100
210: , a11 out nocopy JTF_VARCHAR2_TABLE_100
211: , a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , a13 out nocopy JTF_VARCHAR2_TABLE_100
213: ) as

Line 210: , a11 out nocopy JTF_VARCHAR2_TABLE_100

206: , a7 out nocopy JTF_VARCHAR2_TABLE_100
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_100
209: , a10 out nocopy JTF_VARCHAR2_TABLE_100
210: , a11 out nocopy JTF_VARCHAR2_TABLE_100
211: , a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , a13 out nocopy JTF_VARCHAR2_TABLE_100
213: ) as
214: ddindx binary_integer; indx binary_integer;

Line 211: , a12 out nocopy JTF_VARCHAR2_TABLE_100

207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_100
209: , a10 out nocopy JTF_VARCHAR2_TABLE_100
210: , a11 out nocopy JTF_VARCHAR2_TABLE_100
211: , a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , a13 out nocopy JTF_VARCHAR2_TABLE_100
213: ) as
214: ddindx binary_integer; indx binary_integer;
215: begin

Line 212: , a13 out nocopy JTF_VARCHAR2_TABLE_100

208: , a9 out nocopy JTF_VARCHAR2_TABLE_100
209: , a10 out nocopy JTF_VARCHAR2_TABLE_100
210: , a11 out nocopy JTF_VARCHAR2_TABLE_100
211: , a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , a13 out nocopy JTF_VARCHAR2_TABLE_100
213: ) as
214: ddindx binary_integer; indx binary_integer;
215: begin
216: if t is null or t.count = 0 then

Line 217: a0 := JTF_VARCHAR2_TABLE_100();

213: ) as
214: ddindx binary_integer; indx binary_integer;
215: begin
216: if t is null or t.count = 0 then
217: a0 := JTF_VARCHAR2_TABLE_100();
218: a1 := JTF_VARCHAR2_TABLE_100();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_VARCHAR2_TABLE_100();
221: a4 := JTF_VARCHAR2_TABLE_100();

Line 218: a1 := JTF_VARCHAR2_TABLE_100();

214: ddindx binary_integer; indx binary_integer;
215: begin
216: if t is null or t.count = 0 then
217: a0 := JTF_VARCHAR2_TABLE_100();
218: a1 := JTF_VARCHAR2_TABLE_100();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_VARCHAR2_TABLE_100();
221: a4 := JTF_VARCHAR2_TABLE_100();
222: a5 := JTF_VARCHAR2_TABLE_100();

Line 219: a2 := JTF_VARCHAR2_TABLE_100();

215: begin
216: if t is null or t.count = 0 then
217: a0 := JTF_VARCHAR2_TABLE_100();
218: a1 := JTF_VARCHAR2_TABLE_100();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_VARCHAR2_TABLE_100();
221: a4 := JTF_VARCHAR2_TABLE_100();
222: a5 := JTF_VARCHAR2_TABLE_100();
223: a6 := JTF_VARCHAR2_TABLE_100();

Line 220: a3 := JTF_VARCHAR2_TABLE_100();

216: if t is null or t.count = 0 then
217: a0 := JTF_VARCHAR2_TABLE_100();
218: a1 := JTF_VARCHAR2_TABLE_100();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_VARCHAR2_TABLE_100();
221: a4 := JTF_VARCHAR2_TABLE_100();
222: a5 := JTF_VARCHAR2_TABLE_100();
223: a6 := JTF_VARCHAR2_TABLE_100();
224: a7 := JTF_VARCHAR2_TABLE_100();

Line 221: a4 := JTF_VARCHAR2_TABLE_100();

217: a0 := JTF_VARCHAR2_TABLE_100();
218: a1 := JTF_VARCHAR2_TABLE_100();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_VARCHAR2_TABLE_100();
221: a4 := JTF_VARCHAR2_TABLE_100();
222: a5 := JTF_VARCHAR2_TABLE_100();
223: a6 := JTF_VARCHAR2_TABLE_100();
224: a7 := JTF_VARCHAR2_TABLE_100();
225: a8 := JTF_VARCHAR2_TABLE_100();

Line 222: a5 := JTF_VARCHAR2_TABLE_100();

218: a1 := JTF_VARCHAR2_TABLE_100();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_VARCHAR2_TABLE_100();
221: a4 := JTF_VARCHAR2_TABLE_100();
222: a5 := JTF_VARCHAR2_TABLE_100();
223: a6 := JTF_VARCHAR2_TABLE_100();
224: a7 := JTF_VARCHAR2_TABLE_100();
225: a8 := JTF_VARCHAR2_TABLE_100();
226: a9 := JTF_VARCHAR2_TABLE_100();

Line 223: a6 := JTF_VARCHAR2_TABLE_100();

219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_VARCHAR2_TABLE_100();
221: a4 := JTF_VARCHAR2_TABLE_100();
222: a5 := JTF_VARCHAR2_TABLE_100();
223: a6 := JTF_VARCHAR2_TABLE_100();
224: a7 := JTF_VARCHAR2_TABLE_100();
225: a8 := JTF_VARCHAR2_TABLE_100();
226: a9 := JTF_VARCHAR2_TABLE_100();
227: a10 := JTF_VARCHAR2_TABLE_100();

Line 224: a7 := JTF_VARCHAR2_TABLE_100();

220: a3 := JTF_VARCHAR2_TABLE_100();
221: a4 := JTF_VARCHAR2_TABLE_100();
222: a5 := JTF_VARCHAR2_TABLE_100();
223: a6 := JTF_VARCHAR2_TABLE_100();
224: a7 := JTF_VARCHAR2_TABLE_100();
225: a8 := JTF_VARCHAR2_TABLE_100();
226: a9 := JTF_VARCHAR2_TABLE_100();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();

Line 225: a8 := JTF_VARCHAR2_TABLE_100();

221: a4 := JTF_VARCHAR2_TABLE_100();
222: a5 := JTF_VARCHAR2_TABLE_100();
223: a6 := JTF_VARCHAR2_TABLE_100();
224: a7 := JTF_VARCHAR2_TABLE_100();
225: a8 := JTF_VARCHAR2_TABLE_100();
226: a9 := JTF_VARCHAR2_TABLE_100();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();
229: a12 := JTF_VARCHAR2_TABLE_100();

Line 226: a9 := JTF_VARCHAR2_TABLE_100();

222: a5 := JTF_VARCHAR2_TABLE_100();
223: a6 := JTF_VARCHAR2_TABLE_100();
224: a7 := JTF_VARCHAR2_TABLE_100();
225: a8 := JTF_VARCHAR2_TABLE_100();
226: a9 := JTF_VARCHAR2_TABLE_100();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();
229: a12 := JTF_VARCHAR2_TABLE_100();
230: a13 := JTF_VARCHAR2_TABLE_100();

Line 227: a10 := JTF_VARCHAR2_TABLE_100();

223: a6 := JTF_VARCHAR2_TABLE_100();
224: a7 := JTF_VARCHAR2_TABLE_100();
225: a8 := JTF_VARCHAR2_TABLE_100();
226: a9 := JTF_VARCHAR2_TABLE_100();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();
229: a12 := JTF_VARCHAR2_TABLE_100();
230: a13 := JTF_VARCHAR2_TABLE_100();
231: else

Line 228: a11 := JTF_VARCHAR2_TABLE_100();

224: a7 := JTF_VARCHAR2_TABLE_100();
225: a8 := JTF_VARCHAR2_TABLE_100();
226: a9 := JTF_VARCHAR2_TABLE_100();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();
229: a12 := JTF_VARCHAR2_TABLE_100();
230: a13 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_VARCHAR2_TABLE_100();

Line 229: a12 := JTF_VARCHAR2_TABLE_100();

225: a8 := JTF_VARCHAR2_TABLE_100();
226: a9 := JTF_VARCHAR2_TABLE_100();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();
229: a12 := JTF_VARCHAR2_TABLE_100();
230: a13 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_VARCHAR2_TABLE_100();
233: a1 := JTF_VARCHAR2_TABLE_100();

Line 230: a13 := JTF_VARCHAR2_TABLE_100();

226: a9 := JTF_VARCHAR2_TABLE_100();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();
229: a12 := JTF_VARCHAR2_TABLE_100();
230: a13 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_VARCHAR2_TABLE_100();
233: a1 := JTF_VARCHAR2_TABLE_100();
234: a2 := JTF_VARCHAR2_TABLE_100();

Line 232: a0 := JTF_VARCHAR2_TABLE_100();

228: a11 := JTF_VARCHAR2_TABLE_100();
229: a12 := JTF_VARCHAR2_TABLE_100();
230: a13 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_VARCHAR2_TABLE_100();
233: a1 := JTF_VARCHAR2_TABLE_100();
234: a2 := JTF_VARCHAR2_TABLE_100();
235: a3 := JTF_VARCHAR2_TABLE_100();
236: a4 := JTF_VARCHAR2_TABLE_100();

Line 233: a1 := JTF_VARCHAR2_TABLE_100();

229: a12 := JTF_VARCHAR2_TABLE_100();
230: a13 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_VARCHAR2_TABLE_100();
233: a1 := JTF_VARCHAR2_TABLE_100();
234: a2 := JTF_VARCHAR2_TABLE_100();
235: a3 := JTF_VARCHAR2_TABLE_100();
236: a4 := JTF_VARCHAR2_TABLE_100();
237: a5 := JTF_VARCHAR2_TABLE_100();

Line 234: a2 := JTF_VARCHAR2_TABLE_100();

230: a13 := JTF_VARCHAR2_TABLE_100();
231: else
232: a0 := JTF_VARCHAR2_TABLE_100();
233: a1 := JTF_VARCHAR2_TABLE_100();
234: a2 := JTF_VARCHAR2_TABLE_100();
235: a3 := JTF_VARCHAR2_TABLE_100();
236: a4 := JTF_VARCHAR2_TABLE_100();
237: a5 := JTF_VARCHAR2_TABLE_100();
238: a6 := JTF_VARCHAR2_TABLE_100();

Line 235: a3 := JTF_VARCHAR2_TABLE_100();

231: else
232: a0 := JTF_VARCHAR2_TABLE_100();
233: a1 := JTF_VARCHAR2_TABLE_100();
234: a2 := JTF_VARCHAR2_TABLE_100();
235: a3 := JTF_VARCHAR2_TABLE_100();
236: a4 := JTF_VARCHAR2_TABLE_100();
237: a5 := JTF_VARCHAR2_TABLE_100();
238: a6 := JTF_VARCHAR2_TABLE_100();
239: a7 := JTF_VARCHAR2_TABLE_100();

Line 236: a4 := JTF_VARCHAR2_TABLE_100();

232: a0 := JTF_VARCHAR2_TABLE_100();
233: a1 := JTF_VARCHAR2_TABLE_100();
234: a2 := JTF_VARCHAR2_TABLE_100();
235: a3 := JTF_VARCHAR2_TABLE_100();
236: a4 := JTF_VARCHAR2_TABLE_100();
237: a5 := JTF_VARCHAR2_TABLE_100();
238: a6 := JTF_VARCHAR2_TABLE_100();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_VARCHAR2_TABLE_100();

Line 237: a5 := JTF_VARCHAR2_TABLE_100();

233: a1 := JTF_VARCHAR2_TABLE_100();
234: a2 := JTF_VARCHAR2_TABLE_100();
235: a3 := JTF_VARCHAR2_TABLE_100();
236: a4 := JTF_VARCHAR2_TABLE_100();
237: a5 := JTF_VARCHAR2_TABLE_100();
238: a6 := JTF_VARCHAR2_TABLE_100();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_VARCHAR2_TABLE_100();
241: a9 := JTF_VARCHAR2_TABLE_100();

Line 238: a6 := JTF_VARCHAR2_TABLE_100();

234: a2 := JTF_VARCHAR2_TABLE_100();
235: a3 := JTF_VARCHAR2_TABLE_100();
236: a4 := JTF_VARCHAR2_TABLE_100();
237: a5 := JTF_VARCHAR2_TABLE_100();
238: a6 := JTF_VARCHAR2_TABLE_100();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_VARCHAR2_TABLE_100();
241: a9 := JTF_VARCHAR2_TABLE_100();
242: a10 := JTF_VARCHAR2_TABLE_100();

Line 239: a7 := JTF_VARCHAR2_TABLE_100();

235: a3 := JTF_VARCHAR2_TABLE_100();
236: a4 := JTF_VARCHAR2_TABLE_100();
237: a5 := JTF_VARCHAR2_TABLE_100();
238: a6 := JTF_VARCHAR2_TABLE_100();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_VARCHAR2_TABLE_100();
241: a9 := JTF_VARCHAR2_TABLE_100();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();

Line 240: a8 := JTF_VARCHAR2_TABLE_100();

236: a4 := JTF_VARCHAR2_TABLE_100();
237: a5 := JTF_VARCHAR2_TABLE_100();
238: a6 := JTF_VARCHAR2_TABLE_100();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_VARCHAR2_TABLE_100();
241: a9 := JTF_VARCHAR2_TABLE_100();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
244: a12 := JTF_VARCHAR2_TABLE_100();

Line 241: a9 := JTF_VARCHAR2_TABLE_100();

237: a5 := JTF_VARCHAR2_TABLE_100();
238: a6 := JTF_VARCHAR2_TABLE_100();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_VARCHAR2_TABLE_100();
241: a9 := JTF_VARCHAR2_TABLE_100();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
244: a12 := JTF_VARCHAR2_TABLE_100();
245: a13 := JTF_VARCHAR2_TABLE_100();

Line 242: a10 := JTF_VARCHAR2_TABLE_100();

238: a6 := JTF_VARCHAR2_TABLE_100();
239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_VARCHAR2_TABLE_100();
241: a9 := JTF_VARCHAR2_TABLE_100();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
244: a12 := JTF_VARCHAR2_TABLE_100();
245: a13 := JTF_VARCHAR2_TABLE_100();
246: if t.count > 0 then

Line 243: a11 := JTF_VARCHAR2_TABLE_100();

239: a7 := JTF_VARCHAR2_TABLE_100();
240: a8 := JTF_VARCHAR2_TABLE_100();
241: a9 := JTF_VARCHAR2_TABLE_100();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
244: a12 := JTF_VARCHAR2_TABLE_100();
245: a13 := JTF_VARCHAR2_TABLE_100();
246: if t.count > 0 then
247: a0.extend(t.count);

Line 244: a12 := JTF_VARCHAR2_TABLE_100();

240: a8 := JTF_VARCHAR2_TABLE_100();
241: a9 := JTF_VARCHAR2_TABLE_100();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
244: a12 := JTF_VARCHAR2_TABLE_100();
245: a13 := JTF_VARCHAR2_TABLE_100();
246: if t.count > 0 then
247: a0.extend(t.count);
248: a1.extend(t.count);

Line 245: a13 := JTF_VARCHAR2_TABLE_100();

241: a9 := JTF_VARCHAR2_TABLE_100();
242: a10 := JTF_VARCHAR2_TABLE_100();
243: a11 := JTF_VARCHAR2_TABLE_100();
244: a12 := JTF_VARCHAR2_TABLE_100();
245: a13 := JTF_VARCHAR2_TABLE_100();
246: if t.count > 0 then
247: a0.extend(t.count);
248: a1.extend(t.count);
249: a2.extend(t.count);

Line 386: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100) as

382: end if;
383: end if;
384: end rosetta_table_copy_out_p23;
385:
386: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100) as
387: ddindx binary_integer; indx binary_integer;
388: begin
389: if a0 is null then
390: t := null;

Line 410: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

406: end loop;
407: end if;
408: end if;
409: end rosetta_table_copy_in_p24;
410: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
411: ddindx binary_integer; indx binary_integer;
412: begin
413: if t is null then
414: a0 := null;

Line 416: a0 := JTF_VARCHAR2_TABLE_100();

412: begin
413: if t is null then
414: a0 := null;
415: elsif t.count = 0 then
416: a0 := JTF_VARCHAR2_TABLE_100();
417: else
418: a0 := JTF_VARCHAR2_TABLE_100();
419: if t.count > 0 then
420: a0.extend(t.count);

Line 418: a0 := JTF_VARCHAR2_TABLE_100();

414: a0 := null;
415: elsif t.count = 0 then
416: a0 := JTF_VARCHAR2_TABLE_100();
417: else
418: a0 := JTF_VARCHAR2_TABLE_100();
419: if t.count > 0 then
420: a0.extend(t.count);
421: ddindx := t.first;
422: indx := 1;

Line 531: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

527: procedure get_res_from_team_group(p_resource_id NUMBER
528: , p_resource_type VARCHAR2
529: , p2_a0 out nocopy JTF_NUMBER_TABLE
530: , p2_a1 out nocopy JTF_NUMBER_TABLE
531: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
532: , p2_a3 out nocopy JTF_NUMBER_TABLE
533: )
534:
535: as

Line 565: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

561: , x_msg_data out nocopy VARCHAR2
562: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_400
563: , p4_a1 out nocopy JTF_NUMBER_TABLE
564: , p4_a2 out nocopy JTF_NUMBER_TABLE
565: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
566: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 566: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

562: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_400
563: , p4_a1 out nocopy JTF_NUMBER_TABLE
564: , p4_a2 out nocopy JTF_NUMBER_TABLE
565: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
566: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

563: , p4_a1 out nocopy JTF_NUMBER_TABLE
564: , p4_a2 out nocopy JTF_NUMBER_TABLE
565: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
566: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
571: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

564: , p4_a2 out nocopy JTF_NUMBER_TABLE
565: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
566: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
571: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
572: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100

565: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
566: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
571: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
572: , p4_a10 out nocopy JTF_NUMBER_TABLE
573: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

566: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
571: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
572: , p4_a10 out nocopy JTF_NUMBER_TABLE
573: , p4_a11 out nocopy JTF_NUMBER_TABLE
574: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 571: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
571: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
572: , p4_a10 out nocopy JTF_NUMBER_TABLE
573: , p4_a11 out nocopy JTF_NUMBER_TABLE
574: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
575: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 574: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
571: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
572: , p4_a10 out nocopy JTF_NUMBER_TABLE
573: , p4_a11 out nocopy JTF_NUMBER_TABLE
574: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
575: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500
576: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100
577: )
578:

Line 576: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100

572: , p4_a10 out nocopy JTF_NUMBER_TABLE
573: , p4_a11 out nocopy JTF_NUMBER_TABLE
574: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
575: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500
576: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100
577: )
578:
579: as
580: ddx_partner_qualifiers_tbl pv_terr_assign_pub.partner_qualifiers_tbl_type;

Line 693: , p8_a3 JTF_VARCHAR2_TABLE_100

689: , p_login_user NUMBER
690: , p8_a0 JTF_VARCHAR2_TABLE_400
691: , p8_a1 JTF_NUMBER_TABLE
692: , p8_a2 JTF_NUMBER_TABLE
693: , p8_a3 JTF_VARCHAR2_TABLE_100
694: , p8_a4 JTF_VARCHAR2_TABLE_100
695: , p8_a5 JTF_VARCHAR2_TABLE_100
696: , p8_a6 JTF_VARCHAR2_TABLE_100
697: , p8_a7 JTF_VARCHAR2_TABLE_100

Line 694: , p8_a4 JTF_VARCHAR2_TABLE_100

690: , p8_a0 JTF_VARCHAR2_TABLE_400
691: , p8_a1 JTF_NUMBER_TABLE
692: , p8_a2 JTF_NUMBER_TABLE
693: , p8_a3 JTF_VARCHAR2_TABLE_100
694: , p8_a4 JTF_VARCHAR2_TABLE_100
695: , p8_a5 JTF_VARCHAR2_TABLE_100
696: , p8_a6 JTF_VARCHAR2_TABLE_100
697: , p8_a7 JTF_VARCHAR2_TABLE_100
698: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 695: , p8_a5 JTF_VARCHAR2_TABLE_100

691: , p8_a1 JTF_NUMBER_TABLE
692: , p8_a2 JTF_NUMBER_TABLE
693: , p8_a3 JTF_VARCHAR2_TABLE_100
694: , p8_a4 JTF_VARCHAR2_TABLE_100
695: , p8_a5 JTF_VARCHAR2_TABLE_100
696: , p8_a6 JTF_VARCHAR2_TABLE_100
697: , p8_a7 JTF_VARCHAR2_TABLE_100
698: , p8_a8 JTF_VARCHAR2_TABLE_100
699: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 696: , p8_a6 JTF_VARCHAR2_TABLE_100

692: , p8_a2 JTF_NUMBER_TABLE
693: , p8_a3 JTF_VARCHAR2_TABLE_100
694: , p8_a4 JTF_VARCHAR2_TABLE_100
695: , p8_a5 JTF_VARCHAR2_TABLE_100
696: , p8_a6 JTF_VARCHAR2_TABLE_100
697: , p8_a7 JTF_VARCHAR2_TABLE_100
698: , p8_a8 JTF_VARCHAR2_TABLE_100
699: , p8_a9 JTF_VARCHAR2_TABLE_100
700: , p8_a10 JTF_NUMBER_TABLE

Line 697: , p8_a7 JTF_VARCHAR2_TABLE_100

693: , p8_a3 JTF_VARCHAR2_TABLE_100
694: , p8_a4 JTF_VARCHAR2_TABLE_100
695: , p8_a5 JTF_VARCHAR2_TABLE_100
696: , p8_a6 JTF_VARCHAR2_TABLE_100
697: , p8_a7 JTF_VARCHAR2_TABLE_100
698: , p8_a8 JTF_VARCHAR2_TABLE_100
699: , p8_a9 JTF_VARCHAR2_TABLE_100
700: , p8_a10 JTF_NUMBER_TABLE
701: , p8_a11 JTF_NUMBER_TABLE

Line 698: , p8_a8 JTF_VARCHAR2_TABLE_100

694: , p8_a4 JTF_VARCHAR2_TABLE_100
695: , p8_a5 JTF_VARCHAR2_TABLE_100
696: , p8_a6 JTF_VARCHAR2_TABLE_100
697: , p8_a7 JTF_VARCHAR2_TABLE_100
698: , p8_a8 JTF_VARCHAR2_TABLE_100
699: , p8_a9 JTF_VARCHAR2_TABLE_100
700: , p8_a10 JTF_NUMBER_TABLE
701: , p8_a11 JTF_NUMBER_TABLE
702: , p8_a12 JTF_VARCHAR2_TABLE_100

Line 699: , p8_a9 JTF_VARCHAR2_TABLE_100

695: , p8_a5 JTF_VARCHAR2_TABLE_100
696: , p8_a6 JTF_VARCHAR2_TABLE_100
697: , p8_a7 JTF_VARCHAR2_TABLE_100
698: , p8_a8 JTF_VARCHAR2_TABLE_100
699: , p8_a9 JTF_VARCHAR2_TABLE_100
700: , p8_a10 JTF_NUMBER_TABLE
701: , p8_a11 JTF_NUMBER_TABLE
702: , p8_a12 JTF_VARCHAR2_TABLE_100
703: , p8_a13 JTF_VARCHAR2_TABLE_500

Line 702: , p8_a12 JTF_VARCHAR2_TABLE_100

698: , p8_a8 JTF_VARCHAR2_TABLE_100
699: , p8_a9 JTF_VARCHAR2_TABLE_100
700: , p8_a10 JTF_NUMBER_TABLE
701: , p8_a11 JTF_NUMBER_TABLE
702: , p8_a12 JTF_VARCHAR2_TABLE_100
703: , p8_a13 JTF_VARCHAR2_TABLE_500
704: , p8_a14 JTF_VARCHAR2_TABLE_100
705: , x_return_status out nocopy VARCHAR2
706: , x_msg_count out nocopy NUMBER

Line 704: , p8_a14 JTF_VARCHAR2_TABLE_100

700: , p8_a10 JTF_NUMBER_TABLE
701: , p8_a11 JTF_NUMBER_TABLE
702: , p8_a12 JTF_VARCHAR2_TABLE_100
703: , p8_a13 JTF_VARCHAR2_TABLE_500
704: , p8_a14 JTF_VARCHAR2_TABLE_100
705: , x_return_status out nocopy VARCHAR2
706: , x_msg_count out nocopy NUMBER
707: , x_msg_data out nocopy VARCHAR2
708: , p12_a0 out nocopy JTF_NUMBER_TABLE

Line 855: , p11_a3 JTF_VARCHAR2_TABLE_100

851: , p_login_user NUMBER
852: , p11_a0 JTF_VARCHAR2_TABLE_400
853: , p11_a1 JTF_NUMBER_TABLE
854: , p11_a2 JTF_NUMBER_TABLE
855: , p11_a3 JTF_VARCHAR2_TABLE_100
856: , p11_a4 JTF_VARCHAR2_TABLE_100
857: , p11_a5 JTF_VARCHAR2_TABLE_100
858: , p11_a6 JTF_VARCHAR2_TABLE_100
859: , p11_a7 JTF_VARCHAR2_TABLE_100

Line 856: , p11_a4 JTF_VARCHAR2_TABLE_100

852: , p11_a0 JTF_VARCHAR2_TABLE_400
853: , p11_a1 JTF_NUMBER_TABLE
854: , p11_a2 JTF_NUMBER_TABLE
855: , p11_a3 JTF_VARCHAR2_TABLE_100
856: , p11_a4 JTF_VARCHAR2_TABLE_100
857: , p11_a5 JTF_VARCHAR2_TABLE_100
858: , p11_a6 JTF_VARCHAR2_TABLE_100
859: , p11_a7 JTF_VARCHAR2_TABLE_100
860: , p11_a8 JTF_VARCHAR2_TABLE_100

Line 857: , p11_a5 JTF_VARCHAR2_TABLE_100

853: , p11_a1 JTF_NUMBER_TABLE
854: , p11_a2 JTF_NUMBER_TABLE
855: , p11_a3 JTF_VARCHAR2_TABLE_100
856: , p11_a4 JTF_VARCHAR2_TABLE_100
857: , p11_a5 JTF_VARCHAR2_TABLE_100
858: , p11_a6 JTF_VARCHAR2_TABLE_100
859: , p11_a7 JTF_VARCHAR2_TABLE_100
860: , p11_a8 JTF_VARCHAR2_TABLE_100
861: , p11_a9 JTF_VARCHAR2_TABLE_100

Line 858: , p11_a6 JTF_VARCHAR2_TABLE_100

854: , p11_a2 JTF_NUMBER_TABLE
855: , p11_a3 JTF_VARCHAR2_TABLE_100
856: , p11_a4 JTF_VARCHAR2_TABLE_100
857: , p11_a5 JTF_VARCHAR2_TABLE_100
858: , p11_a6 JTF_VARCHAR2_TABLE_100
859: , p11_a7 JTF_VARCHAR2_TABLE_100
860: , p11_a8 JTF_VARCHAR2_TABLE_100
861: , p11_a9 JTF_VARCHAR2_TABLE_100
862: , p11_a10 JTF_NUMBER_TABLE

Line 859: , p11_a7 JTF_VARCHAR2_TABLE_100

855: , p11_a3 JTF_VARCHAR2_TABLE_100
856: , p11_a4 JTF_VARCHAR2_TABLE_100
857: , p11_a5 JTF_VARCHAR2_TABLE_100
858: , p11_a6 JTF_VARCHAR2_TABLE_100
859: , p11_a7 JTF_VARCHAR2_TABLE_100
860: , p11_a8 JTF_VARCHAR2_TABLE_100
861: , p11_a9 JTF_VARCHAR2_TABLE_100
862: , p11_a10 JTF_NUMBER_TABLE
863: , p11_a11 JTF_NUMBER_TABLE

Line 860: , p11_a8 JTF_VARCHAR2_TABLE_100

856: , p11_a4 JTF_VARCHAR2_TABLE_100
857: , p11_a5 JTF_VARCHAR2_TABLE_100
858: , p11_a6 JTF_VARCHAR2_TABLE_100
859: , p11_a7 JTF_VARCHAR2_TABLE_100
860: , p11_a8 JTF_VARCHAR2_TABLE_100
861: , p11_a9 JTF_VARCHAR2_TABLE_100
862: , p11_a10 JTF_NUMBER_TABLE
863: , p11_a11 JTF_NUMBER_TABLE
864: , p11_a12 JTF_VARCHAR2_TABLE_100

Line 861: , p11_a9 JTF_VARCHAR2_TABLE_100

857: , p11_a5 JTF_VARCHAR2_TABLE_100
858: , p11_a6 JTF_VARCHAR2_TABLE_100
859: , p11_a7 JTF_VARCHAR2_TABLE_100
860: , p11_a8 JTF_VARCHAR2_TABLE_100
861: , p11_a9 JTF_VARCHAR2_TABLE_100
862: , p11_a10 JTF_NUMBER_TABLE
863: , p11_a11 JTF_NUMBER_TABLE
864: , p11_a12 JTF_VARCHAR2_TABLE_100
865: , p11_a13 JTF_VARCHAR2_TABLE_500

Line 864: , p11_a12 JTF_VARCHAR2_TABLE_100

860: , p11_a8 JTF_VARCHAR2_TABLE_100
861: , p11_a9 JTF_VARCHAR2_TABLE_100
862: , p11_a10 JTF_NUMBER_TABLE
863: , p11_a11 JTF_NUMBER_TABLE
864: , p11_a12 JTF_VARCHAR2_TABLE_100
865: , p11_a13 JTF_VARCHAR2_TABLE_500
866: , p11_a14 JTF_VARCHAR2_TABLE_100
867: , p12_a0 out nocopy JTF_NUMBER_TABLE
868: )

Line 866: , p11_a14 JTF_VARCHAR2_TABLE_100

862: , p11_a10 JTF_NUMBER_TABLE
863: , p11_a11 JTF_NUMBER_TABLE
864: , p11_a12 JTF_VARCHAR2_TABLE_100
865: , p11_a13 JTF_VARCHAR2_TABLE_500
866: , p11_a14 JTF_VARCHAR2_TABLE_100
867: , p12_a0 out nocopy JTF_NUMBER_TABLE
868: )
869:
870: as