1: package ahl_ua_flight_schedules_pub_w AUTHID CURRENT_USER as
2: /* $Header: AHLUFSWS.pls 120.0.12020000.2 2012/12/10 16:50:18 prakkum ship $ */
3: procedure rosetta_table_copy_in_p4(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
1: package ahl_ua_flight_schedules_pub_w AUTHID CURRENT_USER as
2: /* $Header: AHLUFSWS.pls 120.0.12020000.2 2012/12/10 16:50:18 prakkum ship $ */
3: procedure rosetta_table_copy_in_p4(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
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
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
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
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
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
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
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
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
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
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_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_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 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_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_200
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_200
44: , a41 JTF_VARCHAR2_TABLE_200
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_200
44: , a41 JTF_VARCHAR2_TABLE_200
45: , a42 JTF_VARCHAR2_TABLE_200
53: , a50 JTF_VARCHAR2_TABLE_200
54: , a51 JTF_VARCHAR2_TABLE_200
55: , a52 JTF_VARCHAR2_TABLE_200
56: , a53 JTF_VARCHAR2_TABLE_200
57: , a54 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p4(t ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_100
56: , a53 JTF_VARCHAR2_TABLE_200
57: , a54 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p4(t ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_100
62: , a3 out nocopy JTF_DATE_TABLE
63: , a4 out nocopy JTF_DATE_TABLE
64: , a5 out nocopy JTF_NUMBER_TABLE
57: , a54 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p4(t ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_100
62: , a3 out nocopy JTF_DATE_TABLE
63: , a4 out nocopy JTF_DATE_TABLE
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_100
62: , a3 out nocopy JTF_DATE_TABLE
63: , a4 out nocopy JTF_DATE_TABLE
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_VARCHAR2_TABLE_100
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a9 out nocopy JTF_DATE_TABLE
69: , a10 out nocopy JTF_DATE_TABLE
63: , a4 out nocopy JTF_DATE_TABLE
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_VARCHAR2_TABLE_100
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a9 out nocopy JTF_DATE_TABLE
69: , a10 out nocopy JTF_DATE_TABLE
70: , a11 out nocopy JTF_NUMBER_TABLE
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100
67: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a9 out nocopy JTF_DATE_TABLE
69: , a10 out nocopy JTF_DATE_TABLE
70: , a11 out nocopy JTF_NUMBER_TABLE
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100
72: , a13 out nocopy JTF_NUMBER_TABLE
73: , a14 out nocopy JTF_VARCHAR2_TABLE_100
74: , a15 out nocopy JTF_NUMBER_TABLE
75: , a16 out nocopy JTF_NUMBER_TABLE
69: , a10 out nocopy JTF_DATE_TABLE
70: , a11 out nocopy JTF_NUMBER_TABLE
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100
72: , a13 out nocopy JTF_NUMBER_TABLE
73: , a14 out nocopy JTF_VARCHAR2_TABLE_100
74: , a15 out nocopy JTF_NUMBER_TABLE
75: , a16 out nocopy JTF_NUMBER_TABLE
76: , a17 out nocopy JTF_VARCHAR2_TABLE_100
77: , a18 out nocopy JTF_NUMBER_TABLE
72: , a13 out nocopy JTF_NUMBER_TABLE
73: , a14 out nocopy JTF_VARCHAR2_TABLE_100
74: , a15 out nocopy JTF_NUMBER_TABLE
75: , a16 out nocopy JTF_NUMBER_TABLE
76: , a17 out nocopy JTF_VARCHAR2_TABLE_100
77: , a18 out nocopy JTF_NUMBER_TABLE
78: , a19 out nocopy JTF_VARCHAR2_TABLE_100
79: , a20 out nocopy JTF_VARCHAR2_TABLE_100
80: , a21 out nocopy JTF_VARCHAR2_TABLE_100
74: , a15 out nocopy JTF_NUMBER_TABLE
75: , a16 out nocopy JTF_NUMBER_TABLE
76: , a17 out nocopy JTF_VARCHAR2_TABLE_100
77: , a18 out nocopy JTF_NUMBER_TABLE
78: , a19 out nocopy JTF_VARCHAR2_TABLE_100
79: , a20 out nocopy JTF_VARCHAR2_TABLE_100
80: , a21 out nocopy JTF_VARCHAR2_TABLE_100
81: , a22 out nocopy JTF_VARCHAR2_TABLE_100
82: , a23 out nocopy JTF_VARCHAR2_TABLE_100
75: , a16 out nocopy JTF_NUMBER_TABLE
76: , a17 out nocopy JTF_VARCHAR2_TABLE_100
77: , a18 out nocopy JTF_NUMBER_TABLE
78: , a19 out nocopy JTF_VARCHAR2_TABLE_100
79: , a20 out nocopy JTF_VARCHAR2_TABLE_100
80: , a21 out nocopy JTF_VARCHAR2_TABLE_100
81: , a22 out nocopy JTF_VARCHAR2_TABLE_100
82: , a23 out nocopy JTF_VARCHAR2_TABLE_100
83: , a24 out nocopy JTF_NUMBER_TABLE
76: , a17 out nocopy JTF_VARCHAR2_TABLE_100
77: , a18 out nocopy JTF_NUMBER_TABLE
78: , a19 out nocopy JTF_VARCHAR2_TABLE_100
79: , a20 out nocopy JTF_VARCHAR2_TABLE_100
80: , a21 out nocopy JTF_VARCHAR2_TABLE_100
81: , a22 out nocopy JTF_VARCHAR2_TABLE_100
82: , a23 out nocopy JTF_VARCHAR2_TABLE_100
83: , a24 out nocopy JTF_NUMBER_TABLE
84: , a25 out nocopy JTF_VARCHAR2_TABLE_100
77: , a18 out nocopy JTF_NUMBER_TABLE
78: , a19 out nocopy JTF_VARCHAR2_TABLE_100
79: , a20 out nocopy JTF_VARCHAR2_TABLE_100
80: , a21 out nocopy JTF_VARCHAR2_TABLE_100
81: , a22 out nocopy JTF_VARCHAR2_TABLE_100
82: , a23 out nocopy JTF_VARCHAR2_TABLE_100
83: , a24 out nocopy JTF_NUMBER_TABLE
84: , a25 out nocopy JTF_VARCHAR2_TABLE_100
85: , a26 out nocopy JTF_VARCHAR2_TABLE_100
78: , a19 out nocopy JTF_VARCHAR2_TABLE_100
79: , a20 out nocopy JTF_VARCHAR2_TABLE_100
80: , a21 out nocopy JTF_VARCHAR2_TABLE_100
81: , a22 out nocopy JTF_VARCHAR2_TABLE_100
82: , a23 out nocopy JTF_VARCHAR2_TABLE_100
83: , a24 out nocopy JTF_NUMBER_TABLE
84: , a25 out nocopy JTF_VARCHAR2_TABLE_100
85: , a26 out nocopy JTF_VARCHAR2_TABLE_100
86: , a27 out nocopy JTF_VARCHAR2_TABLE_100
80: , a21 out nocopy JTF_VARCHAR2_TABLE_100
81: , a22 out nocopy JTF_VARCHAR2_TABLE_100
82: , a23 out nocopy JTF_VARCHAR2_TABLE_100
83: , a24 out nocopy JTF_NUMBER_TABLE
84: , a25 out nocopy JTF_VARCHAR2_TABLE_100
85: , a26 out nocopy JTF_VARCHAR2_TABLE_100
86: , a27 out nocopy JTF_VARCHAR2_TABLE_100
87: , a28 out nocopy JTF_VARCHAR2_TABLE_100
88: , a29 out nocopy JTF_NUMBER_TABLE
81: , a22 out nocopy JTF_VARCHAR2_TABLE_100
82: , a23 out nocopy JTF_VARCHAR2_TABLE_100
83: , a24 out nocopy JTF_NUMBER_TABLE
84: , a25 out nocopy JTF_VARCHAR2_TABLE_100
85: , a26 out nocopy JTF_VARCHAR2_TABLE_100
86: , a27 out nocopy JTF_VARCHAR2_TABLE_100
87: , a28 out nocopy JTF_VARCHAR2_TABLE_100
88: , a29 out nocopy JTF_NUMBER_TABLE
89: , a30 out nocopy JTF_VARCHAR2_TABLE_100
82: , a23 out nocopy JTF_VARCHAR2_TABLE_100
83: , a24 out nocopy JTF_NUMBER_TABLE
84: , a25 out nocopy JTF_VARCHAR2_TABLE_100
85: , a26 out nocopy JTF_VARCHAR2_TABLE_100
86: , a27 out nocopy JTF_VARCHAR2_TABLE_100
87: , a28 out nocopy JTF_VARCHAR2_TABLE_100
88: , a29 out nocopy JTF_NUMBER_TABLE
89: , a30 out nocopy JTF_VARCHAR2_TABLE_100
90: , a31 out nocopy JTF_NUMBER_TABLE
83: , a24 out nocopy JTF_NUMBER_TABLE
84: , a25 out nocopy JTF_VARCHAR2_TABLE_100
85: , a26 out nocopy JTF_VARCHAR2_TABLE_100
86: , a27 out nocopy JTF_VARCHAR2_TABLE_100
87: , a28 out nocopy JTF_VARCHAR2_TABLE_100
88: , a29 out nocopy JTF_NUMBER_TABLE
89: , a30 out nocopy JTF_VARCHAR2_TABLE_100
90: , a31 out nocopy JTF_NUMBER_TABLE
91: , a32 out nocopy JTF_VARCHAR2_TABLE_100
85: , a26 out nocopy JTF_VARCHAR2_TABLE_100
86: , a27 out nocopy JTF_VARCHAR2_TABLE_100
87: , a28 out nocopy JTF_VARCHAR2_TABLE_100
88: , a29 out nocopy JTF_NUMBER_TABLE
89: , a30 out nocopy JTF_VARCHAR2_TABLE_100
90: , a31 out nocopy JTF_NUMBER_TABLE
91: , a32 out nocopy JTF_VARCHAR2_TABLE_100
92: , a33 out nocopy JTF_NUMBER_TABLE
93: , a34 out nocopy JTF_VARCHAR2_TABLE_100
87: , a28 out nocopy JTF_VARCHAR2_TABLE_100
88: , a29 out nocopy JTF_NUMBER_TABLE
89: , a30 out nocopy JTF_VARCHAR2_TABLE_100
90: , a31 out nocopy JTF_NUMBER_TABLE
91: , a32 out nocopy JTF_VARCHAR2_TABLE_100
92: , a33 out nocopy JTF_NUMBER_TABLE
93: , a34 out nocopy JTF_VARCHAR2_TABLE_100
94: , a35 out nocopy JTF_VARCHAR2_TABLE_100
95: , a36 out nocopy JTF_VARCHAR2_TABLE_100
89: , a30 out nocopy JTF_VARCHAR2_TABLE_100
90: , a31 out nocopy JTF_NUMBER_TABLE
91: , a32 out nocopy JTF_VARCHAR2_TABLE_100
92: , a33 out nocopy JTF_NUMBER_TABLE
93: , a34 out nocopy JTF_VARCHAR2_TABLE_100
94: , a35 out nocopy JTF_VARCHAR2_TABLE_100
95: , a36 out nocopy JTF_VARCHAR2_TABLE_100
96: , a37 out nocopy JTF_VARCHAR2_TABLE_100
97: , a38 out nocopy JTF_VARCHAR2_TABLE_100
90: , a31 out nocopy JTF_NUMBER_TABLE
91: , a32 out nocopy JTF_VARCHAR2_TABLE_100
92: , a33 out nocopy JTF_NUMBER_TABLE
93: , a34 out nocopy JTF_VARCHAR2_TABLE_100
94: , a35 out nocopy JTF_VARCHAR2_TABLE_100
95: , a36 out nocopy JTF_VARCHAR2_TABLE_100
96: , a37 out nocopy JTF_VARCHAR2_TABLE_100
97: , a38 out nocopy JTF_VARCHAR2_TABLE_100
98: , a39 out nocopy JTF_VARCHAR2_TABLE_200
91: , a32 out nocopy JTF_VARCHAR2_TABLE_100
92: , a33 out nocopy JTF_NUMBER_TABLE
93: , a34 out nocopy JTF_VARCHAR2_TABLE_100
94: , a35 out nocopy JTF_VARCHAR2_TABLE_100
95: , a36 out nocopy JTF_VARCHAR2_TABLE_100
96: , a37 out nocopy JTF_VARCHAR2_TABLE_100
97: , a38 out nocopy JTF_VARCHAR2_TABLE_100
98: , a39 out nocopy JTF_VARCHAR2_TABLE_200
99: , a40 out nocopy JTF_VARCHAR2_TABLE_200
92: , a33 out nocopy JTF_NUMBER_TABLE
93: , a34 out nocopy JTF_VARCHAR2_TABLE_100
94: , a35 out nocopy JTF_VARCHAR2_TABLE_100
95: , a36 out nocopy JTF_VARCHAR2_TABLE_100
96: , a37 out nocopy JTF_VARCHAR2_TABLE_100
97: , a38 out nocopy JTF_VARCHAR2_TABLE_100
98: , a39 out nocopy JTF_VARCHAR2_TABLE_200
99: , a40 out nocopy JTF_VARCHAR2_TABLE_200
100: , a41 out nocopy JTF_VARCHAR2_TABLE_200
93: , a34 out nocopy JTF_VARCHAR2_TABLE_100
94: , a35 out nocopy JTF_VARCHAR2_TABLE_100
95: , a36 out nocopy JTF_VARCHAR2_TABLE_100
96: , a37 out nocopy JTF_VARCHAR2_TABLE_100
97: , a38 out nocopy JTF_VARCHAR2_TABLE_100
98: , a39 out nocopy JTF_VARCHAR2_TABLE_200
99: , a40 out nocopy JTF_VARCHAR2_TABLE_200
100: , a41 out nocopy JTF_VARCHAR2_TABLE_200
101: , a42 out nocopy JTF_VARCHAR2_TABLE_200
109: , a50 out nocopy JTF_VARCHAR2_TABLE_200
110: , a51 out nocopy JTF_VARCHAR2_TABLE_200
111: , a52 out nocopy JTF_VARCHAR2_TABLE_200
112: , a53 out nocopy JTF_VARCHAR2_TABLE_200
113: , a54 out nocopy JTF_VARCHAR2_TABLE_100
114: );
115:
116: procedure get_flight_schedule_details(p_api_version NUMBER
117: , p_init_msg_list VARCHAR2
134: , p9_a9 DATE
135: , p9_a10 DATE
136: , p9_a11 VARCHAR2
137: , p10_a0 out nocopy JTF_NUMBER_TABLE
138: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
139: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
140: , p10_a3 out nocopy JTF_DATE_TABLE
141: , p10_a4 out nocopy JTF_DATE_TABLE
142: , p10_a5 out nocopy JTF_NUMBER_TABLE
135: , p9_a10 DATE
136: , p9_a11 VARCHAR2
137: , p10_a0 out nocopy JTF_NUMBER_TABLE
138: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
139: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
140: , p10_a3 out nocopy JTF_DATE_TABLE
141: , p10_a4 out nocopy JTF_DATE_TABLE
142: , p10_a5 out nocopy JTF_NUMBER_TABLE
143: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
139: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
140: , p10_a3 out nocopy JTF_DATE_TABLE
141: , p10_a4 out nocopy JTF_DATE_TABLE
142: , p10_a5 out nocopy JTF_NUMBER_TABLE
143: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
144: , p10_a7 out nocopy JTF_NUMBER_TABLE
145: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
146: , p10_a9 out nocopy JTF_DATE_TABLE
147: , p10_a10 out nocopy JTF_DATE_TABLE
141: , p10_a4 out nocopy JTF_DATE_TABLE
142: , p10_a5 out nocopy JTF_NUMBER_TABLE
143: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
144: , p10_a7 out nocopy JTF_NUMBER_TABLE
145: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
146: , p10_a9 out nocopy JTF_DATE_TABLE
147: , p10_a10 out nocopy JTF_DATE_TABLE
148: , p10_a11 out nocopy JTF_NUMBER_TABLE
149: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
145: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
146: , p10_a9 out nocopy JTF_DATE_TABLE
147: , p10_a10 out nocopy JTF_DATE_TABLE
148: , p10_a11 out nocopy JTF_NUMBER_TABLE
149: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
150: , p10_a13 out nocopy JTF_NUMBER_TABLE
151: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
152: , p10_a15 out nocopy JTF_NUMBER_TABLE
153: , p10_a16 out nocopy JTF_NUMBER_TABLE
147: , p10_a10 out nocopy JTF_DATE_TABLE
148: , p10_a11 out nocopy JTF_NUMBER_TABLE
149: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
150: , p10_a13 out nocopy JTF_NUMBER_TABLE
151: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
152: , p10_a15 out nocopy JTF_NUMBER_TABLE
153: , p10_a16 out nocopy JTF_NUMBER_TABLE
154: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
155: , p10_a18 out nocopy JTF_NUMBER_TABLE
150: , p10_a13 out nocopy JTF_NUMBER_TABLE
151: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
152: , p10_a15 out nocopy JTF_NUMBER_TABLE
153: , p10_a16 out nocopy JTF_NUMBER_TABLE
154: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
155: , p10_a18 out nocopy JTF_NUMBER_TABLE
156: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
157: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
158: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
152: , p10_a15 out nocopy JTF_NUMBER_TABLE
153: , p10_a16 out nocopy JTF_NUMBER_TABLE
154: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
155: , p10_a18 out nocopy JTF_NUMBER_TABLE
156: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
157: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
158: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
160: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
153: , p10_a16 out nocopy JTF_NUMBER_TABLE
154: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
155: , p10_a18 out nocopy JTF_NUMBER_TABLE
156: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
157: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
158: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
160: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
161: , p10_a24 out nocopy JTF_NUMBER_TABLE
154: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
155: , p10_a18 out nocopy JTF_NUMBER_TABLE
156: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
157: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
158: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
160: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
161: , p10_a24 out nocopy JTF_NUMBER_TABLE
162: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
155: , p10_a18 out nocopy JTF_NUMBER_TABLE
156: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
157: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
158: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
160: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
161: , p10_a24 out nocopy JTF_NUMBER_TABLE
162: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
163: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
156: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
157: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
158: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
160: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
161: , p10_a24 out nocopy JTF_NUMBER_TABLE
162: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
163: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
164: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000
158: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
160: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
161: , p10_a24 out nocopy JTF_NUMBER_TABLE
162: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
163: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
164: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100
166: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
160: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
161: , p10_a24 out nocopy JTF_NUMBER_TABLE
162: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
163: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
164: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100
166: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_100
167: , p10_a30 out nocopy JTF_NUMBER_TABLE
161: , p10_a24 out nocopy JTF_NUMBER_TABLE
162: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
163: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
164: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100
166: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_100
167: , p10_a30 out nocopy JTF_NUMBER_TABLE
168: , p10_a31 out nocopy JTF_VARCHAR2_TABLE_100
169: , p10_a32 out nocopy JTF_NUMBER_TABLE
162: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
163: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
164: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100
166: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_100
167: , p10_a30 out nocopy JTF_NUMBER_TABLE
168: , p10_a31 out nocopy JTF_VARCHAR2_TABLE_100
169: , p10_a32 out nocopy JTF_NUMBER_TABLE
170: , p10_a33 out nocopy JTF_VARCHAR2_TABLE_100
164: , p10_a27 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100
166: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_100
167: , p10_a30 out nocopy JTF_NUMBER_TABLE
168: , p10_a31 out nocopy JTF_VARCHAR2_TABLE_100
169: , p10_a32 out nocopy JTF_NUMBER_TABLE
170: , p10_a33 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a34 out nocopy JTF_VARCHAR2_TABLE_100
172: , p10_a35 out nocopy JTF_VARCHAR2_TABLE_200
166: , p10_a29 out nocopy JTF_VARCHAR2_TABLE_100
167: , p10_a30 out nocopy JTF_NUMBER_TABLE
168: , p10_a31 out nocopy JTF_VARCHAR2_TABLE_100
169: , p10_a32 out nocopy JTF_NUMBER_TABLE
170: , p10_a33 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a34 out nocopy JTF_VARCHAR2_TABLE_100
172: , p10_a35 out nocopy JTF_VARCHAR2_TABLE_200
173: , p10_a36 out nocopy JTF_VARCHAR2_TABLE_200
174: , p10_a37 out nocopy JTF_VARCHAR2_TABLE_200
167: , p10_a30 out nocopy JTF_NUMBER_TABLE
168: , p10_a31 out nocopy JTF_VARCHAR2_TABLE_100
169: , p10_a32 out nocopy JTF_NUMBER_TABLE
170: , p10_a33 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a34 out nocopy JTF_VARCHAR2_TABLE_100
172: , p10_a35 out nocopy JTF_VARCHAR2_TABLE_200
173: , p10_a36 out nocopy JTF_VARCHAR2_TABLE_200
174: , p10_a37 out nocopy JTF_VARCHAR2_TABLE_200
175: , p10_a38 out nocopy JTF_VARCHAR2_TABLE_200
183: , p10_a46 out nocopy JTF_VARCHAR2_TABLE_200
184: , p10_a47 out nocopy JTF_VARCHAR2_TABLE_200
185: , p10_a48 out nocopy JTF_VARCHAR2_TABLE_200
186: , p10_a49 out nocopy JTF_VARCHAR2_TABLE_200
187: , p10_a50 out nocopy JTF_VARCHAR2_TABLE_100
188: );
189: procedure process_flight_schedules(p_api_version NUMBER
190: , p_init_msg_list VARCHAR2
191: , p_commit VARCHAR2
195: , x_return_status out nocopy VARCHAR2
196: , x_msg_count out nocopy NUMBER
197: , x_msg_data out nocopy VARCHAR2
198: , p9_a0 in out nocopy JTF_NUMBER_TABLE
199: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p9_a3 in out nocopy JTF_DATE_TABLE
202: , p9_a4 in out nocopy JTF_DATE_TABLE
203: , p9_a5 in out nocopy JTF_NUMBER_TABLE
196: , x_msg_count out nocopy NUMBER
197: , x_msg_data out nocopy VARCHAR2
198: , p9_a0 in out nocopy JTF_NUMBER_TABLE
199: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p9_a3 in out nocopy JTF_DATE_TABLE
202: , p9_a4 in out nocopy JTF_DATE_TABLE
203: , p9_a5 in out nocopy JTF_NUMBER_TABLE
204: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p9_a3 in out nocopy JTF_DATE_TABLE
202: , p9_a4 in out nocopy JTF_DATE_TABLE
203: , p9_a5 in out nocopy JTF_NUMBER_TABLE
204: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
205: , p9_a7 in out nocopy JTF_NUMBER_TABLE
206: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
207: , p9_a9 in out nocopy JTF_DATE_TABLE
208: , p9_a10 in out nocopy JTF_DATE_TABLE
202: , p9_a4 in out nocopy JTF_DATE_TABLE
203: , p9_a5 in out nocopy JTF_NUMBER_TABLE
204: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
205: , p9_a7 in out nocopy JTF_NUMBER_TABLE
206: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
207: , p9_a9 in out nocopy JTF_DATE_TABLE
208: , p9_a10 in out nocopy JTF_DATE_TABLE
209: , p9_a11 in out nocopy JTF_NUMBER_TABLE
210: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
206: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
207: , p9_a9 in out nocopy JTF_DATE_TABLE
208: , p9_a10 in out nocopy JTF_DATE_TABLE
209: , p9_a11 in out nocopy JTF_NUMBER_TABLE
210: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
211: , p9_a13 in out nocopy JTF_NUMBER_TABLE
212: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
213: , p9_a15 in out nocopy JTF_NUMBER_TABLE
214: , p9_a16 in out nocopy JTF_NUMBER_TABLE
208: , p9_a10 in out nocopy JTF_DATE_TABLE
209: , p9_a11 in out nocopy JTF_NUMBER_TABLE
210: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
211: , p9_a13 in out nocopy JTF_NUMBER_TABLE
212: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
213: , p9_a15 in out nocopy JTF_NUMBER_TABLE
214: , p9_a16 in out nocopy JTF_NUMBER_TABLE
215: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
216: , p9_a18 in out nocopy JTF_NUMBER_TABLE
211: , p9_a13 in out nocopy JTF_NUMBER_TABLE
212: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
213: , p9_a15 in out nocopy JTF_NUMBER_TABLE
214: , p9_a16 in out nocopy JTF_NUMBER_TABLE
215: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
216: , p9_a18 in out nocopy JTF_NUMBER_TABLE
217: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
213: , p9_a15 in out nocopy JTF_NUMBER_TABLE
214: , p9_a16 in out nocopy JTF_NUMBER_TABLE
215: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
216: , p9_a18 in out nocopy JTF_NUMBER_TABLE
217: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
214: , p9_a16 in out nocopy JTF_NUMBER_TABLE
215: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
216: , p9_a18 in out nocopy JTF_NUMBER_TABLE
217: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
222: , p9_a24 in out nocopy JTF_NUMBER_TABLE
215: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
216: , p9_a18 in out nocopy JTF_NUMBER_TABLE
217: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
222: , p9_a24 in out nocopy JTF_NUMBER_TABLE
223: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
216: , p9_a18 in out nocopy JTF_NUMBER_TABLE
217: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
222: , p9_a24 in out nocopy JTF_NUMBER_TABLE
223: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
217: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
222: , p9_a24 in out nocopy JTF_NUMBER_TABLE
223: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
219: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
222: , p9_a24 in out nocopy JTF_NUMBER_TABLE
223: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
226: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
227: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
220: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
222: , p9_a24 in out nocopy JTF_NUMBER_TABLE
223: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
226: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
227: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
228: , p9_a30 in out nocopy JTF_NUMBER_TABLE
222: , p9_a24 in out nocopy JTF_NUMBER_TABLE
223: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
226: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
227: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
228: , p9_a30 in out nocopy JTF_NUMBER_TABLE
229: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
230: , p9_a32 in out nocopy JTF_NUMBER_TABLE
223: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
226: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
227: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
228: , p9_a30 in out nocopy JTF_NUMBER_TABLE
229: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
230: , p9_a32 in out nocopy JTF_NUMBER_TABLE
231: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
226: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
227: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
228: , p9_a30 in out nocopy JTF_NUMBER_TABLE
229: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
230: , p9_a32 in out nocopy JTF_NUMBER_TABLE
231: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
232: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
233: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_200
227: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
228: , p9_a30 in out nocopy JTF_NUMBER_TABLE
229: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
230: , p9_a32 in out nocopy JTF_NUMBER_TABLE
231: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
232: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
233: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_200
234: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_200
235: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_200
228: , p9_a30 in out nocopy JTF_NUMBER_TABLE
229: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
230: , p9_a32 in out nocopy JTF_NUMBER_TABLE
231: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
232: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
233: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_200
234: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_200
235: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_200
236: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_200
244: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_200
245: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_200
246: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_200
247: , p9_a49 in out nocopy JTF_VARCHAR2_TABLE_200
248: , p9_a50 in out nocopy JTF_VARCHAR2_TABLE_100
249: );
250: procedure process_flightvisit_sch(p_api_version NUMBER
251: , p_init_msg_list VARCHAR2
252: , p_commit VARCHAR2
256: , x_return_status out nocopy VARCHAR2
257: , x_msg_count out nocopy NUMBER
258: , x_msg_data out nocopy VARCHAR2
259: , p9_a0 in out nocopy JTF_NUMBER_TABLE
260: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
262: , p9_a3 in out nocopy JTF_DATE_TABLE
263: , p9_a4 in out nocopy JTF_DATE_TABLE
264: , p9_a5 in out nocopy JTF_NUMBER_TABLE
257: , x_msg_count out nocopy NUMBER
258: , x_msg_data out nocopy VARCHAR2
259: , p9_a0 in out nocopy JTF_NUMBER_TABLE
260: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
262: , p9_a3 in out nocopy JTF_DATE_TABLE
263: , p9_a4 in out nocopy JTF_DATE_TABLE
264: , p9_a5 in out nocopy JTF_NUMBER_TABLE
265: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
262: , p9_a3 in out nocopy JTF_DATE_TABLE
263: , p9_a4 in out nocopy JTF_DATE_TABLE
264: , p9_a5 in out nocopy JTF_NUMBER_TABLE
265: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
266: , p9_a7 in out nocopy JTF_NUMBER_TABLE
267: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
268: , p9_a9 in out nocopy JTF_DATE_TABLE
269: , p9_a10 in out nocopy JTF_DATE_TABLE
263: , p9_a4 in out nocopy JTF_DATE_TABLE
264: , p9_a5 in out nocopy JTF_NUMBER_TABLE
265: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
266: , p9_a7 in out nocopy JTF_NUMBER_TABLE
267: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
268: , p9_a9 in out nocopy JTF_DATE_TABLE
269: , p9_a10 in out nocopy JTF_DATE_TABLE
270: , p9_a11 in out nocopy JTF_NUMBER_TABLE
271: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
267: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
268: , p9_a9 in out nocopy JTF_DATE_TABLE
269: , p9_a10 in out nocopy JTF_DATE_TABLE
270: , p9_a11 in out nocopy JTF_NUMBER_TABLE
271: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a13 in out nocopy JTF_NUMBER_TABLE
273: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p9_a15 in out nocopy JTF_NUMBER_TABLE
275: , p9_a16 in out nocopy JTF_NUMBER_TABLE
269: , p9_a10 in out nocopy JTF_DATE_TABLE
270: , p9_a11 in out nocopy JTF_NUMBER_TABLE
271: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a13 in out nocopy JTF_NUMBER_TABLE
273: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p9_a15 in out nocopy JTF_NUMBER_TABLE
275: , p9_a16 in out nocopy JTF_NUMBER_TABLE
276: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p9_a18 in out nocopy JTF_NUMBER_TABLE
272: , p9_a13 in out nocopy JTF_NUMBER_TABLE
273: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p9_a15 in out nocopy JTF_NUMBER_TABLE
275: , p9_a16 in out nocopy JTF_NUMBER_TABLE
276: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p9_a18 in out nocopy JTF_NUMBER_TABLE
278: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p9_a15 in out nocopy JTF_NUMBER_TABLE
275: , p9_a16 in out nocopy JTF_NUMBER_TABLE
276: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p9_a18 in out nocopy JTF_NUMBER_TABLE
278: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p9_a16 in out nocopy JTF_NUMBER_TABLE
276: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p9_a18 in out nocopy JTF_NUMBER_TABLE
278: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a24 in out nocopy JTF_NUMBER_TABLE
276: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p9_a18 in out nocopy JTF_NUMBER_TABLE
278: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a24 in out nocopy JTF_NUMBER_TABLE
284: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p9_a18 in out nocopy JTF_NUMBER_TABLE
278: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a24 in out nocopy JTF_NUMBER_TABLE
284: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
285: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
278: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a24 in out nocopy JTF_NUMBER_TABLE
284: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
285: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
286: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a24 in out nocopy JTF_NUMBER_TABLE
284: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
285: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
286: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_100
287: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p9_a29 in out nocopy JTF_NUMBER_TABLE
281: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a24 in out nocopy JTF_NUMBER_TABLE
284: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
285: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
286: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_100
287: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p9_a29 in out nocopy JTF_NUMBER_TABLE
289: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a24 in out nocopy JTF_NUMBER_TABLE
284: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
285: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
286: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_100
287: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p9_a29 in out nocopy JTF_NUMBER_TABLE
289: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p9_a31 in out nocopy JTF_NUMBER_TABLE
283: , p9_a24 in out nocopy JTF_NUMBER_TABLE
284: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
285: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
286: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_100
287: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p9_a29 in out nocopy JTF_NUMBER_TABLE
289: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p9_a31 in out nocopy JTF_NUMBER_TABLE
291: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
285: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
286: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_100
287: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p9_a29 in out nocopy JTF_NUMBER_TABLE
289: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p9_a31 in out nocopy JTF_NUMBER_TABLE
291: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
292: , p9_a33 in out nocopy JTF_NUMBER_TABLE
293: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
287: , p9_a28 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p9_a29 in out nocopy JTF_NUMBER_TABLE
289: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p9_a31 in out nocopy JTF_NUMBER_TABLE
291: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
292: , p9_a33 in out nocopy JTF_NUMBER_TABLE
293: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
294: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100
289: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p9_a31 in out nocopy JTF_NUMBER_TABLE
291: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
292: , p9_a33 in out nocopy JTF_NUMBER_TABLE
293: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
294: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p9_a31 in out nocopy JTF_NUMBER_TABLE
291: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
292: , p9_a33 in out nocopy JTF_NUMBER_TABLE
293: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
294: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_200
291: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
292: , p9_a33 in out nocopy JTF_NUMBER_TABLE
293: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
294: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_200
299: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_200
292: , p9_a33 in out nocopy JTF_NUMBER_TABLE
293: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
294: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_200
299: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_200
300: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_200
293: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
294: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_200
299: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_200
300: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_200
301: , p9_a42 in out nocopy JTF_VARCHAR2_TABLE_200
309: , p9_a50 in out nocopy JTF_VARCHAR2_TABLE_200
310: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_200
311: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_200
312: , p9_a53 in out nocopy JTF_VARCHAR2_TABLE_200
313: , p9_a54 in out nocopy JTF_VARCHAR2_TABLE_100
314: );
315: end ahl_ua_flight_schedules_pub_w;