APPS.AHL_UA_FLIGHT_SCHEDULES_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body ahl_ua_flight_schedules_pub_w as
2: /* $Header: AHLUFSWB.pls 120.0 2005/05/26 00:59:51 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body ahl_ua_flight_schedules_pub_w as
2: /* $Header: AHLUFSWB.pls 120.0 2005/05/26 00:59:51 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE

Line 17: , a14 JTF_VARCHAR2_TABLE_100

13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE

Line 20: , a17 JTF_VARCHAR2_TABLE_100

16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100

Line 25: , a22 JTF_VARCHAR2_TABLE_100

21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100

Line 26: , a23 JTF_VARCHAR2_TABLE_100

22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE

Line 28: , a25 JTF_VARCHAR2_TABLE_100

24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100

Line 29: , a26 JTF_VARCHAR2_TABLE_100

25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100

Line 32: , a29 JTF_VARCHAR2_TABLE_100

28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_200

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_200
37: , a34 JTF_VARCHAR2_TABLE_200

Line 34: , a31 JTF_VARCHAR2_TABLE_100

30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_200
37: , a34 JTF_VARCHAR2_TABLE_200
38: , a35 JTF_VARCHAR2_TABLE_200

Line 35: , a32 JTF_VARCHAR2_TABLE_100

31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_200
37: , a34 JTF_VARCHAR2_TABLE_200
38: , a35 JTF_VARCHAR2_TABLE_200
39: , a36 JTF_VARCHAR2_TABLE_200

Line 51: , a48 JTF_VARCHAR2_TABLE_100

47: , a44 JTF_VARCHAR2_TABLE_200
48: , a45 JTF_VARCHAR2_TABLE_200
49: , a46 JTF_VARCHAR2_TABLE_200
50: , a47 JTF_VARCHAR2_TABLE_200
51: , a48 JTF_VARCHAR2_TABLE_100
52: ) as
53: ddindx binary_integer; indx binary_integer;
54: begin
55: if a0 is not null and a0.count > 0 then

Line 119: , a1 out nocopy JTF_VARCHAR2_TABLE_100

115: end if;
116: end if;
117: end rosetta_table_copy_in_p2;
118: procedure rosetta_table_copy_out_p2(t ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_VARCHAR2_TABLE_100
120: , a2 out nocopy JTF_VARCHAR2_TABLE_100
121: , a3 out nocopy JTF_DATE_TABLE
122: , a4 out nocopy JTF_DATE_TABLE
123: , a5 out nocopy JTF_NUMBER_TABLE

Line 120: , a2 out nocopy JTF_VARCHAR2_TABLE_100

116: end if;
117: end rosetta_table_copy_in_p2;
118: procedure rosetta_table_copy_out_p2(t ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_VARCHAR2_TABLE_100
120: , a2 out nocopy JTF_VARCHAR2_TABLE_100
121: , a3 out nocopy JTF_DATE_TABLE
122: , a4 out nocopy JTF_DATE_TABLE
123: , a5 out nocopy JTF_NUMBER_TABLE
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , a6 out nocopy JTF_VARCHAR2_TABLE_100

120: , a2 out nocopy JTF_VARCHAR2_TABLE_100
121: , a3 out nocopy JTF_DATE_TABLE
122: , a4 out nocopy JTF_DATE_TABLE
123: , a5 out nocopy JTF_NUMBER_TABLE
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100
125: , a7 out nocopy JTF_NUMBER_TABLE
126: , a8 out nocopy JTF_VARCHAR2_TABLE_100
127: , a9 out nocopy JTF_DATE_TABLE
128: , a10 out nocopy JTF_DATE_TABLE

Line 126: , a8 out nocopy JTF_VARCHAR2_TABLE_100

122: , a4 out nocopy JTF_DATE_TABLE
123: , a5 out nocopy JTF_NUMBER_TABLE
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100
125: , a7 out nocopy JTF_NUMBER_TABLE
126: , a8 out nocopy JTF_VARCHAR2_TABLE_100
127: , a9 out nocopy JTF_DATE_TABLE
128: , a10 out nocopy JTF_DATE_TABLE
129: , a11 out nocopy JTF_NUMBER_TABLE
130: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 130: , a12 out nocopy JTF_VARCHAR2_TABLE_100

126: , a8 out nocopy JTF_VARCHAR2_TABLE_100
127: , a9 out nocopy JTF_DATE_TABLE
128: , a10 out nocopy JTF_DATE_TABLE
129: , a11 out nocopy JTF_NUMBER_TABLE
130: , a12 out nocopy JTF_VARCHAR2_TABLE_100
131: , a13 out nocopy JTF_NUMBER_TABLE
132: , a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , a15 out nocopy JTF_NUMBER_TABLE
134: , a16 out nocopy JTF_NUMBER_TABLE

Line 132: , a14 out nocopy JTF_VARCHAR2_TABLE_100

128: , a10 out nocopy JTF_DATE_TABLE
129: , a11 out nocopy JTF_NUMBER_TABLE
130: , a12 out nocopy JTF_VARCHAR2_TABLE_100
131: , a13 out nocopy JTF_NUMBER_TABLE
132: , a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , a15 out nocopy JTF_NUMBER_TABLE
134: , a16 out nocopy JTF_NUMBER_TABLE
135: , a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , a18 out nocopy JTF_NUMBER_TABLE

Line 135: , a17 out nocopy JTF_VARCHAR2_TABLE_100

131: , a13 out nocopy JTF_NUMBER_TABLE
132: , a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , a15 out nocopy JTF_NUMBER_TABLE
134: , a16 out nocopy JTF_NUMBER_TABLE
135: , a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , a18 out nocopy JTF_NUMBER_TABLE
137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: , a19 out nocopy JTF_VARCHAR2_TABLE_100

133: , a15 out nocopy JTF_NUMBER_TABLE
134: , a16 out nocopy JTF_NUMBER_TABLE
135: , a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , a18 out nocopy JTF_NUMBER_TABLE
137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , a22 out nocopy JTF_VARCHAR2_TABLE_100
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 138: , a20 out nocopy JTF_VARCHAR2_TABLE_100

134: , a16 out nocopy JTF_NUMBER_TABLE
135: , a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , a18 out nocopy JTF_NUMBER_TABLE
137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , a22 out nocopy JTF_VARCHAR2_TABLE_100
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100
142: , a24 out nocopy JTF_NUMBER_TABLE

Line 139: , a21 out nocopy JTF_VARCHAR2_TABLE_100

135: , a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , a18 out nocopy JTF_NUMBER_TABLE
137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , a22 out nocopy JTF_VARCHAR2_TABLE_100
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100
142: , a24 out nocopy JTF_NUMBER_TABLE
143: , a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: , a22 out nocopy JTF_VARCHAR2_TABLE_100

136: , a18 out nocopy JTF_NUMBER_TABLE
137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , a22 out nocopy JTF_VARCHAR2_TABLE_100
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100
142: , a24 out nocopy JTF_NUMBER_TABLE
143: , a25 out nocopy JTF_VARCHAR2_TABLE_100
144: , a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 141: , a23 out nocopy JTF_VARCHAR2_TABLE_100

137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , a22 out nocopy JTF_VARCHAR2_TABLE_100
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100
142: , a24 out nocopy JTF_NUMBER_TABLE
143: , a25 out nocopy JTF_VARCHAR2_TABLE_100
144: , a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , a27 out nocopy JTF_NUMBER_TABLE

Line 143: , a25 out nocopy JTF_VARCHAR2_TABLE_100

139: , a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , a22 out nocopy JTF_VARCHAR2_TABLE_100
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100
142: , a24 out nocopy JTF_NUMBER_TABLE
143: , a25 out nocopy JTF_VARCHAR2_TABLE_100
144: , a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , a27 out nocopy JTF_NUMBER_TABLE
146: , a28 out nocopy JTF_VARCHAR2_TABLE_100
147: , a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 144: , a26 out nocopy JTF_VARCHAR2_TABLE_100

140: , a22 out nocopy JTF_VARCHAR2_TABLE_100
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100
142: , a24 out nocopy JTF_NUMBER_TABLE
143: , a25 out nocopy JTF_VARCHAR2_TABLE_100
144: , a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , a27 out nocopy JTF_NUMBER_TABLE
146: , a28 out nocopy JTF_VARCHAR2_TABLE_100
147: , a29 out nocopy JTF_VARCHAR2_TABLE_100
148: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 146: , a28 out nocopy JTF_VARCHAR2_TABLE_100

142: , a24 out nocopy JTF_NUMBER_TABLE
143: , a25 out nocopy JTF_VARCHAR2_TABLE_100
144: , a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , a27 out nocopy JTF_NUMBER_TABLE
146: , a28 out nocopy JTF_VARCHAR2_TABLE_100
147: , a29 out nocopy JTF_VARCHAR2_TABLE_100
148: , a30 out nocopy JTF_VARCHAR2_TABLE_100
149: , a31 out nocopy JTF_VARCHAR2_TABLE_100
150: , a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 147: , a29 out nocopy JTF_VARCHAR2_TABLE_100

143: , a25 out nocopy JTF_VARCHAR2_TABLE_100
144: , a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , a27 out nocopy JTF_NUMBER_TABLE
146: , a28 out nocopy JTF_VARCHAR2_TABLE_100
147: , a29 out nocopy JTF_VARCHAR2_TABLE_100
148: , a30 out nocopy JTF_VARCHAR2_TABLE_100
149: , a31 out nocopy JTF_VARCHAR2_TABLE_100
150: , a32 out nocopy JTF_VARCHAR2_TABLE_100
151: , a33 out nocopy JTF_VARCHAR2_TABLE_200

Line 148: , a30 out nocopy JTF_VARCHAR2_TABLE_100

144: , a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , a27 out nocopy JTF_NUMBER_TABLE
146: , a28 out nocopy JTF_VARCHAR2_TABLE_100
147: , a29 out nocopy JTF_VARCHAR2_TABLE_100
148: , a30 out nocopy JTF_VARCHAR2_TABLE_100
149: , a31 out nocopy JTF_VARCHAR2_TABLE_100
150: , a32 out nocopy JTF_VARCHAR2_TABLE_100
151: , a33 out nocopy JTF_VARCHAR2_TABLE_200
152: , a34 out nocopy JTF_VARCHAR2_TABLE_200

Line 149: , a31 out nocopy JTF_VARCHAR2_TABLE_100

145: , a27 out nocopy JTF_NUMBER_TABLE
146: , a28 out nocopy JTF_VARCHAR2_TABLE_100
147: , a29 out nocopy JTF_VARCHAR2_TABLE_100
148: , a30 out nocopy JTF_VARCHAR2_TABLE_100
149: , a31 out nocopy JTF_VARCHAR2_TABLE_100
150: , a32 out nocopy JTF_VARCHAR2_TABLE_100
151: , a33 out nocopy JTF_VARCHAR2_TABLE_200
152: , a34 out nocopy JTF_VARCHAR2_TABLE_200
153: , a35 out nocopy JTF_VARCHAR2_TABLE_200

Line 150: , a32 out nocopy JTF_VARCHAR2_TABLE_100

146: , a28 out nocopy JTF_VARCHAR2_TABLE_100
147: , a29 out nocopy JTF_VARCHAR2_TABLE_100
148: , a30 out nocopy JTF_VARCHAR2_TABLE_100
149: , a31 out nocopy JTF_VARCHAR2_TABLE_100
150: , a32 out nocopy JTF_VARCHAR2_TABLE_100
151: , a33 out nocopy JTF_VARCHAR2_TABLE_200
152: , a34 out nocopy JTF_VARCHAR2_TABLE_200
153: , a35 out nocopy JTF_VARCHAR2_TABLE_200
154: , a36 out nocopy JTF_VARCHAR2_TABLE_200

Line 166: , a48 out nocopy JTF_VARCHAR2_TABLE_100

162: , a44 out nocopy JTF_VARCHAR2_TABLE_200
163: , a45 out nocopy JTF_VARCHAR2_TABLE_200
164: , a46 out nocopy JTF_VARCHAR2_TABLE_200
165: , a47 out nocopy JTF_VARCHAR2_TABLE_200
166: , a48 out nocopy JTF_VARCHAR2_TABLE_100
167: ) as
168: ddindx binary_integer; indx binary_integer;
169: begin
170: if t is null or t.count = 0 then

Line 172: a1 := JTF_VARCHAR2_TABLE_100();

168: ddindx binary_integer; indx binary_integer;
169: begin
170: if t is null or t.count = 0 then
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_VARCHAR2_TABLE_100();
173: a2 := JTF_VARCHAR2_TABLE_100();
174: a3 := JTF_DATE_TABLE();
175: a4 := JTF_DATE_TABLE();
176: a5 := JTF_NUMBER_TABLE();

Line 173: a2 := JTF_VARCHAR2_TABLE_100();

169: begin
170: if t is null or t.count = 0 then
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_VARCHAR2_TABLE_100();
173: a2 := JTF_VARCHAR2_TABLE_100();
174: a3 := JTF_DATE_TABLE();
175: a4 := JTF_DATE_TABLE();
176: a5 := JTF_NUMBER_TABLE();
177: a6 := JTF_VARCHAR2_TABLE_100();

Line 177: a6 := JTF_VARCHAR2_TABLE_100();

173: a2 := JTF_VARCHAR2_TABLE_100();
174: a3 := JTF_DATE_TABLE();
175: a4 := JTF_DATE_TABLE();
176: a5 := JTF_NUMBER_TABLE();
177: a6 := JTF_VARCHAR2_TABLE_100();
178: a7 := JTF_NUMBER_TABLE();
179: a8 := JTF_VARCHAR2_TABLE_100();
180: a9 := JTF_DATE_TABLE();
181: a10 := JTF_DATE_TABLE();

Line 179: a8 := JTF_VARCHAR2_TABLE_100();

175: a4 := JTF_DATE_TABLE();
176: a5 := JTF_NUMBER_TABLE();
177: a6 := JTF_VARCHAR2_TABLE_100();
178: a7 := JTF_NUMBER_TABLE();
179: a8 := JTF_VARCHAR2_TABLE_100();
180: a9 := JTF_DATE_TABLE();
181: a10 := JTF_DATE_TABLE();
182: a11 := JTF_NUMBER_TABLE();
183: a12 := JTF_VARCHAR2_TABLE_100();

Line 183: a12 := JTF_VARCHAR2_TABLE_100();

179: a8 := JTF_VARCHAR2_TABLE_100();
180: a9 := JTF_DATE_TABLE();
181: a10 := JTF_DATE_TABLE();
182: a11 := JTF_NUMBER_TABLE();
183: a12 := JTF_VARCHAR2_TABLE_100();
184: a13 := JTF_NUMBER_TABLE();
185: a14 := JTF_VARCHAR2_TABLE_100();
186: a15 := JTF_NUMBER_TABLE();
187: a16 := JTF_NUMBER_TABLE();

Line 185: a14 := JTF_VARCHAR2_TABLE_100();

181: a10 := JTF_DATE_TABLE();
182: a11 := JTF_NUMBER_TABLE();
183: a12 := JTF_VARCHAR2_TABLE_100();
184: a13 := JTF_NUMBER_TABLE();
185: a14 := JTF_VARCHAR2_TABLE_100();
186: a15 := JTF_NUMBER_TABLE();
187: a16 := JTF_NUMBER_TABLE();
188: a17 := JTF_VARCHAR2_TABLE_100();
189: a18 := JTF_NUMBER_TABLE();

Line 188: a17 := JTF_VARCHAR2_TABLE_100();

184: a13 := JTF_NUMBER_TABLE();
185: a14 := JTF_VARCHAR2_TABLE_100();
186: a15 := JTF_NUMBER_TABLE();
187: a16 := JTF_NUMBER_TABLE();
188: a17 := JTF_VARCHAR2_TABLE_100();
189: a18 := JTF_NUMBER_TABLE();
190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_VARCHAR2_TABLE_100();
192: a21 := JTF_VARCHAR2_TABLE_100();

Line 190: a19 := JTF_VARCHAR2_TABLE_100();

186: a15 := JTF_NUMBER_TABLE();
187: a16 := JTF_NUMBER_TABLE();
188: a17 := JTF_VARCHAR2_TABLE_100();
189: a18 := JTF_NUMBER_TABLE();
190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_VARCHAR2_TABLE_100();
192: a21 := JTF_VARCHAR2_TABLE_100();
193: a22 := JTF_VARCHAR2_TABLE_100();
194: a23 := JTF_VARCHAR2_TABLE_100();

Line 191: a20 := JTF_VARCHAR2_TABLE_100();

187: a16 := JTF_NUMBER_TABLE();
188: a17 := JTF_VARCHAR2_TABLE_100();
189: a18 := JTF_NUMBER_TABLE();
190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_VARCHAR2_TABLE_100();
192: a21 := JTF_VARCHAR2_TABLE_100();
193: a22 := JTF_VARCHAR2_TABLE_100();
194: a23 := JTF_VARCHAR2_TABLE_100();
195: a24 := JTF_NUMBER_TABLE();

Line 192: a21 := JTF_VARCHAR2_TABLE_100();

188: a17 := JTF_VARCHAR2_TABLE_100();
189: a18 := JTF_NUMBER_TABLE();
190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_VARCHAR2_TABLE_100();
192: a21 := JTF_VARCHAR2_TABLE_100();
193: a22 := JTF_VARCHAR2_TABLE_100();
194: a23 := JTF_VARCHAR2_TABLE_100();
195: a24 := JTF_NUMBER_TABLE();
196: a25 := JTF_VARCHAR2_TABLE_100();

Line 193: a22 := JTF_VARCHAR2_TABLE_100();

189: a18 := JTF_NUMBER_TABLE();
190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_VARCHAR2_TABLE_100();
192: a21 := JTF_VARCHAR2_TABLE_100();
193: a22 := JTF_VARCHAR2_TABLE_100();
194: a23 := JTF_VARCHAR2_TABLE_100();
195: a24 := JTF_NUMBER_TABLE();
196: a25 := JTF_VARCHAR2_TABLE_100();
197: a26 := JTF_VARCHAR2_TABLE_100();

Line 194: a23 := JTF_VARCHAR2_TABLE_100();

190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_VARCHAR2_TABLE_100();
192: a21 := JTF_VARCHAR2_TABLE_100();
193: a22 := JTF_VARCHAR2_TABLE_100();
194: a23 := JTF_VARCHAR2_TABLE_100();
195: a24 := JTF_NUMBER_TABLE();
196: a25 := JTF_VARCHAR2_TABLE_100();
197: a26 := JTF_VARCHAR2_TABLE_100();
198: a27 := JTF_NUMBER_TABLE();

Line 196: a25 := JTF_VARCHAR2_TABLE_100();

192: a21 := JTF_VARCHAR2_TABLE_100();
193: a22 := JTF_VARCHAR2_TABLE_100();
194: a23 := JTF_VARCHAR2_TABLE_100();
195: a24 := JTF_NUMBER_TABLE();
196: a25 := JTF_VARCHAR2_TABLE_100();
197: a26 := JTF_VARCHAR2_TABLE_100();
198: a27 := JTF_NUMBER_TABLE();
199: a28 := JTF_VARCHAR2_TABLE_100();
200: a29 := JTF_VARCHAR2_TABLE_100();

Line 197: a26 := JTF_VARCHAR2_TABLE_100();

193: a22 := JTF_VARCHAR2_TABLE_100();
194: a23 := JTF_VARCHAR2_TABLE_100();
195: a24 := JTF_NUMBER_TABLE();
196: a25 := JTF_VARCHAR2_TABLE_100();
197: a26 := JTF_VARCHAR2_TABLE_100();
198: a27 := JTF_NUMBER_TABLE();
199: a28 := JTF_VARCHAR2_TABLE_100();
200: a29 := JTF_VARCHAR2_TABLE_100();
201: a30 := JTF_VARCHAR2_TABLE_100();

Line 199: a28 := JTF_VARCHAR2_TABLE_100();

195: a24 := JTF_NUMBER_TABLE();
196: a25 := JTF_VARCHAR2_TABLE_100();
197: a26 := JTF_VARCHAR2_TABLE_100();
198: a27 := JTF_NUMBER_TABLE();
199: a28 := JTF_VARCHAR2_TABLE_100();
200: a29 := JTF_VARCHAR2_TABLE_100();
201: a30 := JTF_VARCHAR2_TABLE_100();
202: a31 := JTF_VARCHAR2_TABLE_100();
203: a32 := JTF_VARCHAR2_TABLE_100();

Line 200: a29 := JTF_VARCHAR2_TABLE_100();

196: a25 := JTF_VARCHAR2_TABLE_100();
197: a26 := JTF_VARCHAR2_TABLE_100();
198: a27 := JTF_NUMBER_TABLE();
199: a28 := JTF_VARCHAR2_TABLE_100();
200: a29 := JTF_VARCHAR2_TABLE_100();
201: a30 := JTF_VARCHAR2_TABLE_100();
202: a31 := JTF_VARCHAR2_TABLE_100();
203: a32 := JTF_VARCHAR2_TABLE_100();
204: a33 := JTF_VARCHAR2_TABLE_200();

Line 201: a30 := JTF_VARCHAR2_TABLE_100();

197: a26 := JTF_VARCHAR2_TABLE_100();
198: a27 := JTF_NUMBER_TABLE();
199: a28 := JTF_VARCHAR2_TABLE_100();
200: a29 := JTF_VARCHAR2_TABLE_100();
201: a30 := JTF_VARCHAR2_TABLE_100();
202: a31 := JTF_VARCHAR2_TABLE_100();
203: a32 := JTF_VARCHAR2_TABLE_100();
204: a33 := JTF_VARCHAR2_TABLE_200();
205: a34 := JTF_VARCHAR2_TABLE_200();

Line 202: a31 := JTF_VARCHAR2_TABLE_100();

198: a27 := JTF_NUMBER_TABLE();
199: a28 := JTF_VARCHAR2_TABLE_100();
200: a29 := JTF_VARCHAR2_TABLE_100();
201: a30 := JTF_VARCHAR2_TABLE_100();
202: a31 := JTF_VARCHAR2_TABLE_100();
203: a32 := JTF_VARCHAR2_TABLE_100();
204: a33 := JTF_VARCHAR2_TABLE_200();
205: a34 := JTF_VARCHAR2_TABLE_200();
206: a35 := JTF_VARCHAR2_TABLE_200();

Line 203: a32 := JTF_VARCHAR2_TABLE_100();

199: a28 := JTF_VARCHAR2_TABLE_100();
200: a29 := JTF_VARCHAR2_TABLE_100();
201: a30 := JTF_VARCHAR2_TABLE_100();
202: a31 := JTF_VARCHAR2_TABLE_100();
203: a32 := JTF_VARCHAR2_TABLE_100();
204: a33 := JTF_VARCHAR2_TABLE_200();
205: a34 := JTF_VARCHAR2_TABLE_200();
206: a35 := JTF_VARCHAR2_TABLE_200();
207: a36 := JTF_VARCHAR2_TABLE_200();

Line 219: a48 := JTF_VARCHAR2_TABLE_100();

215: a44 := JTF_VARCHAR2_TABLE_200();
216: a45 := JTF_VARCHAR2_TABLE_200();
217: a46 := JTF_VARCHAR2_TABLE_200();
218: a47 := JTF_VARCHAR2_TABLE_200();
219: a48 := JTF_VARCHAR2_TABLE_100();
220: else
221: a0 := JTF_NUMBER_TABLE();
222: a1 := JTF_VARCHAR2_TABLE_100();
223: a2 := JTF_VARCHAR2_TABLE_100();

Line 222: a1 := JTF_VARCHAR2_TABLE_100();

218: a47 := JTF_VARCHAR2_TABLE_200();
219: a48 := JTF_VARCHAR2_TABLE_100();
220: else
221: a0 := JTF_NUMBER_TABLE();
222: a1 := JTF_VARCHAR2_TABLE_100();
223: a2 := JTF_VARCHAR2_TABLE_100();
224: a3 := JTF_DATE_TABLE();
225: a4 := JTF_DATE_TABLE();
226: a5 := JTF_NUMBER_TABLE();

Line 223: a2 := JTF_VARCHAR2_TABLE_100();

219: a48 := JTF_VARCHAR2_TABLE_100();
220: else
221: a0 := JTF_NUMBER_TABLE();
222: a1 := JTF_VARCHAR2_TABLE_100();
223: a2 := JTF_VARCHAR2_TABLE_100();
224: a3 := JTF_DATE_TABLE();
225: a4 := JTF_DATE_TABLE();
226: a5 := JTF_NUMBER_TABLE();
227: a6 := JTF_VARCHAR2_TABLE_100();

Line 227: a6 := JTF_VARCHAR2_TABLE_100();

223: a2 := JTF_VARCHAR2_TABLE_100();
224: a3 := JTF_DATE_TABLE();
225: a4 := JTF_DATE_TABLE();
226: a5 := JTF_NUMBER_TABLE();
227: a6 := JTF_VARCHAR2_TABLE_100();
228: a7 := JTF_NUMBER_TABLE();
229: a8 := JTF_VARCHAR2_TABLE_100();
230: a9 := JTF_DATE_TABLE();
231: a10 := JTF_DATE_TABLE();

Line 229: a8 := JTF_VARCHAR2_TABLE_100();

225: a4 := JTF_DATE_TABLE();
226: a5 := JTF_NUMBER_TABLE();
227: a6 := JTF_VARCHAR2_TABLE_100();
228: a7 := JTF_NUMBER_TABLE();
229: a8 := JTF_VARCHAR2_TABLE_100();
230: a9 := JTF_DATE_TABLE();
231: a10 := JTF_DATE_TABLE();
232: a11 := JTF_NUMBER_TABLE();
233: a12 := JTF_VARCHAR2_TABLE_100();

Line 233: a12 := JTF_VARCHAR2_TABLE_100();

229: a8 := JTF_VARCHAR2_TABLE_100();
230: a9 := JTF_DATE_TABLE();
231: a10 := JTF_DATE_TABLE();
232: a11 := JTF_NUMBER_TABLE();
233: a12 := JTF_VARCHAR2_TABLE_100();
234: a13 := JTF_NUMBER_TABLE();
235: a14 := JTF_VARCHAR2_TABLE_100();
236: a15 := JTF_NUMBER_TABLE();
237: a16 := JTF_NUMBER_TABLE();

Line 235: a14 := JTF_VARCHAR2_TABLE_100();

231: a10 := JTF_DATE_TABLE();
232: a11 := JTF_NUMBER_TABLE();
233: a12 := JTF_VARCHAR2_TABLE_100();
234: a13 := JTF_NUMBER_TABLE();
235: a14 := JTF_VARCHAR2_TABLE_100();
236: a15 := JTF_NUMBER_TABLE();
237: a16 := JTF_NUMBER_TABLE();
238: a17 := JTF_VARCHAR2_TABLE_100();
239: a18 := JTF_NUMBER_TABLE();

Line 238: a17 := JTF_VARCHAR2_TABLE_100();

234: a13 := JTF_NUMBER_TABLE();
235: a14 := JTF_VARCHAR2_TABLE_100();
236: a15 := JTF_NUMBER_TABLE();
237: a16 := JTF_NUMBER_TABLE();
238: a17 := JTF_VARCHAR2_TABLE_100();
239: a18 := JTF_NUMBER_TABLE();
240: a19 := JTF_VARCHAR2_TABLE_100();
241: a20 := JTF_VARCHAR2_TABLE_100();
242: a21 := JTF_VARCHAR2_TABLE_100();

Line 240: a19 := JTF_VARCHAR2_TABLE_100();

236: a15 := JTF_NUMBER_TABLE();
237: a16 := JTF_NUMBER_TABLE();
238: a17 := JTF_VARCHAR2_TABLE_100();
239: a18 := JTF_NUMBER_TABLE();
240: a19 := JTF_VARCHAR2_TABLE_100();
241: a20 := JTF_VARCHAR2_TABLE_100();
242: a21 := JTF_VARCHAR2_TABLE_100();
243: a22 := JTF_VARCHAR2_TABLE_100();
244: a23 := JTF_VARCHAR2_TABLE_100();

Line 241: a20 := JTF_VARCHAR2_TABLE_100();

237: a16 := JTF_NUMBER_TABLE();
238: a17 := JTF_VARCHAR2_TABLE_100();
239: a18 := JTF_NUMBER_TABLE();
240: a19 := JTF_VARCHAR2_TABLE_100();
241: a20 := JTF_VARCHAR2_TABLE_100();
242: a21 := JTF_VARCHAR2_TABLE_100();
243: a22 := JTF_VARCHAR2_TABLE_100();
244: a23 := JTF_VARCHAR2_TABLE_100();
245: a24 := JTF_NUMBER_TABLE();

Line 242: a21 := JTF_VARCHAR2_TABLE_100();

238: a17 := JTF_VARCHAR2_TABLE_100();
239: a18 := JTF_NUMBER_TABLE();
240: a19 := JTF_VARCHAR2_TABLE_100();
241: a20 := JTF_VARCHAR2_TABLE_100();
242: a21 := JTF_VARCHAR2_TABLE_100();
243: a22 := JTF_VARCHAR2_TABLE_100();
244: a23 := JTF_VARCHAR2_TABLE_100();
245: a24 := JTF_NUMBER_TABLE();
246: a25 := JTF_VARCHAR2_TABLE_100();

Line 243: a22 := JTF_VARCHAR2_TABLE_100();

239: a18 := JTF_NUMBER_TABLE();
240: a19 := JTF_VARCHAR2_TABLE_100();
241: a20 := JTF_VARCHAR2_TABLE_100();
242: a21 := JTF_VARCHAR2_TABLE_100();
243: a22 := JTF_VARCHAR2_TABLE_100();
244: a23 := JTF_VARCHAR2_TABLE_100();
245: a24 := JTF_NUMBER_TABLE();
246: a25 := JTF_VARCHAR2_TABLE_100();
247: a26 := JTF_VARCHAR2_TABLE_100();

Line 244: a23 := JTF_VARCHAR2_TABLE_100();

240: a19 := JTF_VARCHAR2_TABLE_100();
241: a20 := JTF_VARCHAR2_TABLE_100();
242: a21 := JTF_VARCHAR2_TABLE_100();
243: a22 := JTF_VARCHAR2_TABLE_100();
244: a23 := JTF_VARCHAR2_TABLE_100();
245: a24 := JTF_NUMBER_TABLE();
246: a25 := JTF_VARCHAR2_TABLE_100();
247: a26 := JTF_VARCHAR2_TABLE_100();
248: a27 := JTF_NUMBER_TABLE();

Line 246: a25 := JTF_VARCHAR2_TABLE_100();

242: a21 := JTF_VARCHAR2_TABLE_100();
243: a22 := JTF_VARCHAR2_TABLE_100();
244: a23 := JTF_VARCHAR2_TABLE_100();
245: a24 := JTF_NUMBER_TABLE();
246: a25 := JTF_VARCHAR2_TABLE_100();
247: a26 := JTF_VARCHAR2_TABLE_100();
248: a27 := JTF_NUMBER_TABLE();
249: a28 := JTF_VARCHAR2_TABLE_100();
250: a29 := JTF_VARCHAR2_TABLE_100();

Line 247: a26 := JTF_VARCHAR2_TABLE_100();

243: a22 := JTF_VARCHAR2_TABLE_100();
244: a23 := JTF_VARCHAR2_TABLE_100();
245: a24 := JTF_NUMBER_TABLE();
246: a25 := JTF_VARCHAR2_TABLE_100();
247: a26 := JTF_VARCHAR2_TABLE_100();
248: a27 := JTF_NUMBER_TABLE();
249: a28 := JTF_VARCHAR2_TABLE_100();
250: a29 := JTF_VARCHAR2_TABLE_100();
251: a30 := JTF_VARCHAR2_TABLE_100();

Line 249: a28 := JTF_VARCHAR2_TABLE_100();

245: a24 := JTF_NUMBER_TABLE();
246: a25 := JTF_VARCHAR2_TABLE_100();
247: a26 := JTF_VARCHAR2_TABLE_100();
248: a27 := JTF_NUMBER_TABLE();
249: a28 := JTF_VARCHAR2_TABLE_100();
250: a29 := JTF_VARCHAR2_TABLE_100();
251: a30 := JTF_VARCHAR2_TABLE_100();
252: a31 := JTF_VARCHAR2_TABLE_100();
253: a32 := JTF_VARCHAR2_TABLE_100();

Line 250: a29 := JTF_VARCHAR2_TABLE_100();

246: a25 := JTF_VARCHAR2_TABLE_100();
247: a26 := JTF_VARCHAR2_TABLE_100();
248: a27 := JTF_NUMBER_TABLE();
249: a28 := JTF_VARCHAR2_TABLE_100();
250: a29 := JTF_VARCHAR2_TABLE_100();
251: a30 := JTF_VARCHAR2_TABLE_100();
252: a31 := JTF_VARCHAR2_TABLE_100();
253: a32 := JTF_VARCHAR2_TABLE_100();
254: a33 := JTF_VARCHAR2_TABLE_200();

Line 251: a30 := JTF_VARCHAR2_TABLE_100();

247: a26 := JTF_VARCHAR2_TABLE_100();
248: a27 := JTF_NUMBER_TABLE();
249: a28 := JTF_VARCHAR2_TABLE_100();
250: a29 := JTF_VARCHAR2_TABLE_100();
251: a30 := JTF_VARCHAR2_TABLE_100();
252: a31 := JTF_VARCHAR2_TABLE_100();
253: a32 := JTF_VARCHAR2_TABLE_100();
254: a33 := JTF_VARCHAR2_TABLE_200();
255: a34 := JTF_VARCHAR2_TABLE_200();

Line 252: a31 := JTF_VARCHAR2_TABLE_100();

248: a27 := JTF_NUMBER_TABLE();
249: a28 := JTF_VARCHAR2_TABLE_100();
250: a29 := JTF_VARCHAR2_TABLE_100();
251: a30 := JTF_VARCHAR2_TABLE_100();
252: a31 := JTF_VARCHAR2_TABLE_100();
253: a32 := JTF_VARCHAR2_TABLE_100();
254: a33 := JTF_VARCHAR2_TABLE_200();
255: a34 := JTF_VARCHAR2_TABLE_200();
256: a35 := JTF_VARCHAR2_TABLE_200();

Line 253: a32 := JTF_VARCHAR2_TABLE_100();

249: a28 := JTF_VARCHAR2_TABLE_100();
250: a29 := JTF_VARCHAR2_TABLE_100();
251: a30 := JTF_VARCHAR2_TABLE_100();
252: a31 := JTF_VARCHAR2_TABLE_100();
253: a32 := JTF_VARCHAR2_TABLE_100();
254: a33 := JTF_VARCHAR2_TABLE_200();
255: a34 := JTF_VARCHAR2_TABLE_200();
256: a35 := JTF_VARCHAR2_TABLE_200();
257: a36 := JTF_VARCHAR2_TABLE_200();

Line 269: a48 := JTF_VARCHAR2_TABLE_100();

265: a44 := JTF_VARCHAR2_TABLE_200();
266: a45 := JTF_VARCHAR2_TABLE_200();
267: a46 := JTF_VARCHAR2_TABLE_200();
268: a47 := JTF_VARCHAR2_TABLE_200();
269: a48 := JTF_VARCHAR2_TABLE_100();
270: if t.count > 0 then
271: a0.extend(t.count);
272: a1.extend(t.count);
273: a2.extend(t.count);

Line 403: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100

399: , p9_a8 VARCHAR2
400: , p9_a9 DATE
401: , p9_a10 DATE
402: , p10_a0 out nocopy JTF_NUMBER_TABLE
403: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
404: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
405: , p10_a3 out nocopy JTF_DATE_TABLE
406: , p10_a4 out nocopy JTF_DATE_TABLE
407: , p10_a5 out nocopy JTF_NUMBER_TABLE

Line 404: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

400: , p9_a9 DATE
401: , p9_a10 DATE
402: , p10_a0 out nocopy JTF_NUMBER_TABLE
403: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
404: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
405: , p10_a3 out nocopy JTF_DATE_TABLE
406: , p10_a4 out nocopy JTF_DATE_TABLE
407: , p10_a5 out nocopy JTF_NUMBER_TABLE
408: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 408: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

404: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
405: , p10_a3 out nocopy JTF_DATE_TABLE
406: , p10_a4 out nocopy JTF_DATE_TABLE
407: , p10_a5 out nocopy JTF_NUMBER_TABLE
408: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
409: , p10_a7 out nocopy JTF_NUMBER_TABLE
410: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
411: , p10_a9 out nocopy JTF_DATE_TABLE
412: , p10_a10 out nocopy JTF_DATE_TABLE

Line 410: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100

406: , p10_a4 out nocopy JTF_DATE_TABLE
407: , p10_a5 out nocopy JTF_NUMBER_TABLE
408: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
409: , p10_a7 out nocopy JTF_NUMBER_TABLE
410: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
411: , p10_a9 out nocopy JTF_DATE_TABLE
412: , p10_a10 out nocopy JTF_DATE_TABLE
413: , p10_a11 out nocopy JTF_NUMBER_TABLE
414: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 414: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100

410: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
411: , p10_a9 out nocopy JTF_DATE_TABLE
412: , p10_a10 out nocopy JTF_DATE_TABLE
413: , p10_a11 out nocopy JTF_NUMBER_TABLE
414: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
415: , p10_a13 out nocopy JTF_NUMBER_TABLE
416: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
417: , p10_a15 out nocopy JTF_NUMBER_TABLE
418: , p10_a16 out nocopy JTF_NUMBER_TABLE

Line 416: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100

412: , p10_a10 out nocopy JTF_DATE_TABLE
413: , p10_a11 out nocopy JTF_NUMBER_TABLE
414: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
415: , p10_a13 out nocopy JTF_NUMBER_TABLE
416: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
417: , p10_a15 out nocopy JTF_NUMBER_TABLE
418: , p10_a16 out nocopy JTF_NUMBER_TABLE
419: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
420: , p10_a18 out nocopy JTF_NUMBER_TABLE

Line 419: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100

415: , p10_a13 out nocopy JTF_NUMBER_TABLE
416: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
417: , p10_a15 out nocopy JTF_NUMBER_TABLE
418: , p10_a16 out nocopy JTF_NUMBER_TABLE
419: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
420: , p10_a18 out nocopy JTF_NUMBER_TABLE
421: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
422: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
423: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 421: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100

417: , p10_a15 out nocopy JTF_NUMBER_TABLE
418: , p10_a16 out nocopy JTF_NUMBER_TABLE
419: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
420: , p10_a18 out nocopy JTF_NUMBER_TABLE
421: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
422: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
423: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
424: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
425: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 422: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100

418: , p10_a16 out nocopy JTF_NUMBER_TABLE
419: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
420: , p10_a18 out nocopy JTF_NUMBER_TABLE
421: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
422: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
423: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
424: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
425: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
426: , p10_a24 out nocopy JTF_NUMBER_TABLE

Line 423: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100

419: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
420: , p10_a18 out nocopy JTF_NUMBER_TABLE
421: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
422: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
423: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
424: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
425: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
426: , p10_a24 out nocopy JTF_NUMBER_TABLE
427: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 424: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100

420: , p10_a18 out nocopy JTF_NUMBER_TABLE
421: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
422: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
423: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
424: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
425: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
426: , p10_a24 out nocopy JTF_NUMBER_TABLE
427: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 425: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100

421: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
422: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
423: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
424: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
425: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
426: , p10_a24 out nocopy JTF_NUMBER_TABLE
427: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
429: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000

Line 427: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100

423: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
424: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
425: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
426: , p10_a24 out nocopy JTF_NUMBER_TABLE
427: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
429: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000
430: , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100
431: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_200

Line 428: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100

424: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
425: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
426: , p10_a24 out nocopy JTF_NUMBER_TABLE
427: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
429: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000
430: , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100
431: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_200
432: , p10_a30 out nocopy JTF_VARCHAR2_TABLE_200

Line 430: , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100

426: , p10_a24 out nocopy JTF_NUMBER_TABLE
427: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
428: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
429: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000
430: , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100
431: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_200
432: , p10_a30 out nocopy JTF_VARCHAR2_TABLE_200
433: , p10_a31 out nocopy JTF_VARCHAR2_TABLE_200
434: , p10_a32 out nocopy JTF_VARCHAR2_TABLE_200

Line 446: , p10_a44 out nocopy JTF_VARCHAR2_TABLE_100

442: , p10_a40 out nocopy JTF_VARCHAR2_TABLE_200
443: , p10_a41 out nocopy JTF_VARCHAR2_TABLE_200
444: , p10_a42 out nocopy JTF_VARCHAR2_TABLE_200
445: , p10_a43 out nocopy JTF_VARCHAR2_TABLE_200
446: , p10_a44 out nocopy JTF_VARCHAR2_TABLE_100
447: )
448:
449: as
450: ddp_flight_search_rec ahl_ua_flight_schedules_pub.flight_search_rec_type;

Line 560: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

556: , x_return_status out nocopy VARCHAR2
557: , x_msg_count out nocopy NUMBER
558: , x_msg_data out nocopy VARCHAR2
559: , p9_a0 in out nocopy JTF_NUMBER_TABLE
560: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
561: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
562: , p9_a3 in out nocopy JTF_DATE_TABLE
563: , p9_a4 in out nocopy JTF_DATE_TABLE
564: , p9_a5 in out nocopy JTF_NUMBER_TABLE

Line 561: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100

557: , x_msg_count out nocopy NUMBER
558: , x_msg_data out nocopy VARCHAR2
559: , p9_a0 in out nocopy JTF_NUMBER_TABLE
560: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
561: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
562: , p9_a3 in out nocopy JTF_DATE_TABLE
563: , p9_a4 in out nocopy JTF_DATE_TABLE
564: , p9_a5 in out nocopy JTF_NUMBER_TABLE
565: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 565: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

561: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
562: , p9_a3 in out nocopy JTF_DATE_TABLE
563: , p9_a4 in out nocopy JTF_DATE_TABLE
564: , p9_a5 in out nocopy JTF_NUMBER_TABLE
565: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
566: , p9_a7 in out nocopy JTF_NUMBER_TABLE
567: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
568: , p9_a9 in out nocopy JTF_DATE_TABLE
569: , p9_a10 in out nocopy JTF_DATE_TABLE

Line 567: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

563: , p9_a4 in out nocopy JTF_DATE_TABLE
564: , p9_a5 in out nocopy JTF_NUMBER_TABLE
565: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
566: , p9_a7 in out nocopy JTF_NUMBER_TABLE
567: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
568: , p9_a9 in out nocopy JTF_DATE_TABLE
569: , p9_a10 in out nocopy JTF_DATE_TABLE
570: , p9_a11 in out nocopy JTF_NUMBER_TABLE
571: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 571: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

567: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
568: , p9_a9 in out nocopy JTF_DATE_TABLE
569: , p9_a10 in out nocopy JTF_DATE_TABLE
570: , p9_a11 in out nocopy JTF_NUMBER_TABLE
571: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
572: , p9_a13 in out nocopy JTF_NUMBER_TABLE
573: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
574: , p9_a15 in out nocopy JTF_NUMBER_TABLE
575: , p9_a16 in out nocopy JTF_NUMBER_TABLE

Line 573: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100

569: , p9_a10 in out nocopy JTF_DATE_TABLE
570: , p9_a11 in out nocopy JTF_NUMBER_TABLE
571: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
572: , p9_a13 in out nocopy JTF_NUMBER_TABLE
573: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
574: , p9_a15 in out nocopy JTF_NUMBER_TABLE
575: , p9_a16 in out nocopy JTF_NUMBER_TABLE
576: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p9_a18 in out nocopy JTF_NUMBER_TABLE

Line 576: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100

572: , p9_a13 in out nocopy JTF_NUMBER_TABLE
573: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
574: , p9_a15 in out nocopy JTF_NUMBER_TABLE
575: , p9_a16 in out nocopy JTF_NUMBER_TABLE
576: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p9_a18 in out nocopy JTF_NUMBER_TABLE
578: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
580: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100

Line 578: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100

574: , p9_a15 in out nocopy JTF_NUMBER_TABLE
575: , p9_a16 in out nocopy JTF_NUMBER_TABLE
576: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p9_a18 in out nocopy JTF_NUMBER_TABLE
578: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
580: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100

Line 579: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100

575: , p9_a16 in out nocopy JTF_NUMBER_TABLE
576: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p9_a18 in out nocopy JTF_NUMBER_TABLE
578: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
580: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p9_a24 in out nocopy JTF_NUMBER_TABLE

Line 580: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100

576: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p9_a18 in out nocopy JTF_NUMBER_TABLE
578: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
580: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p9_a24 in out nocopy JTF_NUMBER_TABLE
584: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100

Line 581: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100

577: , p9_a18 in out nocopy JTF_NUMBER_TABLE
578: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
580: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p9_a24 in out nocopy JTF_NUMBER_TABLE
584: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100

Line 582: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100

578: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
580: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p9_a24 in out nocopy JTF_NUMBER_TABLE
584: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
586: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 584: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100

580: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p9_a24 in out nocopy JTF_NUMBER_TABLE
584: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
586: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
587: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_200

Line 585: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100

581: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p9_a24 in out nocopy JTF_NUMBER_TABLE
584: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
586: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
587: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_200
589: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_200

Line 587: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100

583: , p9_a24 in out nocopy JTF_NUMBER_TABLE
584: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
586: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
587: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_200
589: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_200
590: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_200
591: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_200

Line 603: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100

599: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_200
600: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_200
601: , p9_a42 in out nocopy JTF_VARCHAR2_TABLE_200
602: , p9_a43 in out nocopy JTF_VARCHAR2_TABLE_200
603: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
604: )
605:
606: as
607: ddp_x_flight_schedules_tbl ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type;

Line 748: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

744: , x_return_status out nocopy VARCHAR2
745: , x_msg_count out nocopy NUMBER
746: , x_msg_data out nocopy VARCHAR2
747: , p9_a0 in out nocopy JTF_NUMBER_TABLE
748: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
749: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
750: , p9_a3 in out nocopy JTF_DATE_TABLE
751: , p9_a4 in out nocopy JTF_DATE_TABLE
752: , p9_a5 in out nocopy JTF_NUMBER_TABLE

Line 749: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100

745: , x_msg_count out nocopy NUMBER
746: , x_msg_data out nocopy VARCHAR2
747: , p9_a0 in out nocopy JTF_NUMBER_TABLE
748: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
749: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
750: , p9_a3 in out nocopy JTF_DATE_TABLE
751: , p9_a4 in out nocopy JTF_DATE_TABLE
752: , p9_a5 in out nocopy JTF_NUMBER_TABLE
753: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 753: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

749: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
750: , p9_a3 in out nocopy JTF_DATE_TABLE
751: , p9_a4 in out nocopy JTF_DATE_TABLE
752: , p9_a5 in out nocopy JTF_NUMBER_TABLE
753: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
754: , p9_a7 in out nocopy JTF_NUMBER_TABLE
755: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
756: , p9_a9 in out nocopy JTF_DATE_TABLE
757: , p9_a10 in out nocopy JTF_DATE_TABLE

Line 755: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

751: , p9_a4 in out nocopy JTF_DATE_TABLE
752: , p9_a5 in out nocopy JTF_NUMBER_TABLE
753: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
754: , p9_a7 in out nocopy JTF_NUMBER_TABLE
755: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
756: , p9_a9 in out nocopy JTF_DATE_TABLE
757: , p9_a10 in out nocopy JTF_DATE_TABLE
758: , p9_a11 in out nocopy JTF_NUMBER_TABLE
759: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 759: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

755: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
756: , p9_a9 in out nocopy JTF_DATE_TABLE
757: , p9_a10 in out nocopy JTF_DATE_TABLE
758: , p9_a11 in out nocopy JTF_NUMBER_TABLE
759: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
760: , p9_a13 in out nocopy JTF_NUMBER_TABLE
761: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
762: , p9_a15 in out nocopy JTF_NUMBER_TABLE
763: , p9_a16 in out nocopy JTF_NUMBER_TABLE

Line 761: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100

757: , p9_a10 in out nocopy JTF_DATE_TABLE
758: , p9_a11 in out nocopy JTF_NUMBER_TABLE
759: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
760: , p9_a13 in out nocopy JTF_NUMBER_TABLE
761: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
762: , p9_a15 in out nocopy JTF_NUMBER_TABLE
763: , p9_a16 in out nocopy JTF_NUMBER_TABLE
764: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
765: , p9_a18 in out nocopy JTF_NUMBER_TABLE

Line 764: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100

760: , p9_a13 in out nocopy JTF_NUMBER_TABLE
761: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
762: , p9_a15 in out nocopy JTF_NUMBER_TABLE
763: , p9_a16 in out nocopy JTF_NUMBER_TABLE
764: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
765: , p9_a18 in out nocopy JTF_NUMBER_TABLE
766: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
767: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
768: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100

Line 766: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100

762: , p9_a15 in out nocopy JTF_NUMBER_TABLE
763: , p9_a16 in out nocopy JTF_NUMBER_TABLE
764: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
765: , p9_a18 in out nocopy JTF_NUMBER_TABLE
766: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
767: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
768: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
769: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
770: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100

Line 767: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100

763: , p9_a16 in out nocopy JTF_NUMBER_TABLE
764: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
765: , p9_a18 in out nocopy JTF_NUMBER_TABLE
766: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
767: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
768: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
769: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
770: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
771: , p9_a24 in out nocopy JTF_NUMBER_TABLE

Line 768: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100

764: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
765: , p9_a18 in out nocopy JTF_NUMBER_TABLE
766: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
767: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
768: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
769: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
770: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
771: , p9_a24 in out nocopy JTF_NUMBER_TABLE
772: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100

Line 769: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100

765: , p9_a18 in out nocopy JTF_NUMBER_TABLE
766: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
767: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
768: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
769: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
770: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
771: , p9_a24 in out nocopy JTF_NUMBER_TABLE
772: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
773: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100

Line 770: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100

766: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
767: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
768: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
769: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
770: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
771: , p9_a24 in out nocopy JTF_NUMBER_TABLE
772: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
773: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
774: , p9_a27 in out nocopy JTF_NUMBER_TABLE

Line 772: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100

768: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
769: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
770: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
771: , p9_a24 in out nocopy JTF_NUMBER_TABLE
772: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
773: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
774: , p9_a27 in out nocopy JTF_NUMBER_TABLE
775: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
776: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100

Line 773: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100

769: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
770: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
771: , p9_a24 in out nocopy JTF_NUMBER_TABLE
772: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
773: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
774: , p9_a27 in out nocopy JTF_NUMBER_TABLE
775: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
776: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
777: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100

Line 775: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100

771: , p9_a24 in out nocopy JTF_NUMBER_TABLE
772: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
773: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
774: , p9_a27 in out nocopy JTF_NUMBER_TABLE
775: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
776: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
777: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
778: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
779: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100

Line 776: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100

772: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
773: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
774: , p9_a27 in out nocopy JTF_NUMBER_TABLE
775: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
776: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
777: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
778: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
779: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
780: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_200

Line 777: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100

773: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
774: , p9_a27 in out nocopy JTF_NUMBER_TABLE
775: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
776: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
777: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
778: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
779: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
780: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_200
781: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_200

Line 778: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100

774: , p9_a27 in out nocopy JTF_NUMBER_TABLE
775: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
776: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
777: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
778: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
779: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
780: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_200
781: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_200
782: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_200

Line 779: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100

775: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
776: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
777: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
778: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
779: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
780: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_200
781: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_200
782: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_200
783: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_200

Line 795: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100

791: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_200
792: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_200
793: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_200
794: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_200
795: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
796: )
797:
798: as
799: ddp_x_flight_visit_sch_tbl ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type;