1: package okl_mass_rebook_pvt_w as
2: /* $Header: OKLEMRPS.pls 120.3 2007/07/11 16:52:29 ssdeshpa ship $ */
3: procedure rosetta_table_copy_in_p31(t out nocopy okl_mass_rebook_pvt.crit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_200
9: );
10: procedure rosetta_table_copy_out_p31(t okl_mass_rebook_pvt.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_VARCHAR2_TABLE_100
12: , a2 out nocopy JTF_VARCHAR2_TABLE_200
13: , a3 out nocopy JTF_VARCHAR2_TABLE_200
14: , a4 out nocopy JTF_VARCHAR2_TABLE_200
14: , a4 out nocopy JTF_VARCHAR2_TABLE_200
15: , a5 out nocopy JTF_VARCHAR2_TABLE_200
16: );
17:
18: procedure rosetta_table_copy_in_p33(t out nocopy okl_mass_rebook_pvt.rbk_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_VARCHAR2_TABLE_200
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_600
22: );
16: );
17:
18: procedure rosetta_table_copy_in_p33(t out nocopy okl_mass_rebook_pvt.rbk_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_VARCHAR2_TABLE_200
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_600
22: );
23: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_200
19: , a1 JTF_VARCHAR2_TABLE_200
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_600
22: );
23: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_200
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_600
27: );
21: , a3 JTF_VARCHAR2_TABLE_600
22: );
23: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_200
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_600
27: );
28:
29: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_600
27: );
28:
29: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE
30: , a1 JTF_NUMBER_TABLE
31: , a2 JTF_VARCHAR2_TABLE_500
32: , a3 JTF_VARCHAR2_TABLE_500
33: , a4 JTF_VARCHAR2_TABLE_500
26: , a3 out nocopy JTF_VARCHAR2_TABLE_600
27: );
28:
29: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE
30: , a1 JTF_NUMBER_TABLE
31: , a2 JTF_VARCHAR2_TABLE_500
32: , a3 JTF_VARCHAR2_TABLE_500
33: , a4 JTF_VARCHAR2_TABLE_500
34: , a5 JTF_VARCHAR2_TABLE_500
53: , a24 JTF_VARCHAR2_TABLE_100
54: , a25 JTF_VARCHAR2_TABLE_100
55: , a26 JTF_VARCHAR2_TABLE_100
56: );
57: procedure rosetta_table_copy_out_p35(t okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_VARCHAR2_TABLE_500
60: , a3 out nocopy JTF_VARCHAR2_TABLE_500
61: , a4 out nocopy JTF_VARCHAR2_TABLE_500
54: , a25 JTF_VARCHAR2_TABLE_100
55: , a26 JTF_VARCHAR2_TABLE_100
56: );
57: procedure rosetta_table_copy_out_p35(t okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_VARCHAR2_TABLE_500
60: , a3 out nocopy JTF_VARCHAR2_TABLE_500
61: , a4 out nocopy JTF_VARCHAR2_TABLE_500
62: , a5 out nocopy JTF_VARCHAR2_TABLE_500
82: , a25 out nocopy JTF_VARCHAR2_TABLE_100
83: , a26 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
83: , a26 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: );
85:
86: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: );
92:
93: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE
86: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: );
92:
93: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE
94: );
89: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: );
92:
93: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE
94: );
95: procedure rosetta_table_copy_out_p39(t okl_mass_rebook_pvt.kle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: );
97:
91: );
92:
93: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE
94: );
95: procedure rosetta_table_copy_out_p39(t okl_mass_rebook_pvt.kle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: );
97:
98: procedure build_and_get_contracts(p_api_version NUMBER
99: , p_init_msg_list VARCHAR2
100: , x_return_status out nocopy VARCHAR2
101: , x_msg_count out nocopy NUMBER
102: , x_msg_data out nocopy VARCHAR2
103: , p_request_name VARCHAR2
104: , p6_a0 JTF_NUMBER_TABLE
105: , p6_a1 JTF_VARCHAR2_TABLE_600
106: , p6_a2 JTF_NUMBER_TABLE
107: , p6_a3 JTF_VARCHAR2_TABLE_100
108: , p6_a4 JTF_VARCHAR2_TABLE_100
102: , x_msg_data out nocopy VARCHAR2
103: , p_request_name VARCHAR2
104: , p6_a0 JTF_NUMBER_TABLE
105: , p6_a1 JTF_VARCHAR2_TABLE_600
106: , p6_a2 JTF_NUMBER_TABLE
107: , p6_a3 JTF_VARCHAR2_TABLE_100
108: , p6_a4 JTF_VARCHAR2_TABLE_100
109: , p6_a5 JTF_VARCHAR2_TABLE_100
110: , p6_a6 JTF_VARCHAR2_TABLE_600
127: , p6_a23 JTF_VARCHAR2_TABLE_500
128: , p6_a24 JTF_VARCHAR2_TABLE_500
129: , p6_a25 JTF_VARCHAR2_TABLE_500
130: , p6_a26 JTF_VARCHAR2_TABLE_500
131: , p6_a27 JTF_NUMBER_TABLE
132: , p6_a28 JTF_DATE_TABLE
133: , p6_a29 JTF_NUMBER_TABLE
134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE
129: , p6_a25 JTF_VARCHAR2_TABLE_500
130: , p6_a26 JTF_VARCHAR2_TABLE_500
131: , p6_a27 JTF_NUMBER_TABLE
132: , p6_a28 JTF_DATE_TABLE
133: , p6_a29 JTF_NUMBER_TABLE
134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE
136: , p7_a0 out nocopy JTF_NUMBER_TABLE
137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
131: , p6_a27 JTF_NUMBER_TABLE
132: , p6_a28 JTF_DATE_TABLE
133: , p6_a29 JTF_NUMBER_TABLE
134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE
136: , p7_a0 out nocopy JTF_NUMBER_TABLE
137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p6_a28 JTF_DATE_TABLE
133: , p6_a29 JTF_NUMBER_TABLE
134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE
136: , p7_a0 out nocopy JTF_NUMBER_TABLE
137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
134: , p6_a30 JTF_DATE_TABLE
135: , p6_a31 JTF_NUMBER_TABLE
136: , p7_a0 out nocopy JTF_NUMBER_TABLE
137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_NUMBER_TABLE
137: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_NUMBER_TABLE
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_NUMBER_TABLE
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
157: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
158: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
159: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
160: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
161: , p7_a25 out nocopy JTF_NUMBER_TABLE
162: , p7_a26 out nocopy JTF_DATE_TABLE
163: , p7_a27 out nocopy JTF_NUMBER_TABLE
164: , p7_a28 out nocopy JTF_DATE_TABLE
165: , p7_a29 out nocopy JTF_NUMBER_TABLE
159: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
160: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
161: , p7_a25 out nocopy JTF_NUMBER_TABLE
162: , p7_a26 out nocopy JTF_DATE_TABLE
163: , p7_a27 out nocopy JTF_NUMBER_TABLE
164: , p7_a28 out nocopy JTF_DATE_TABLE
165: , p7_a29 out nocopy JTF_NUMBER_TABLE
166: , p7_a30 out nocopy JTF_DATE_TABLE
167: , x_rbk_count out nocopy NUMBER
161: , p7_a25 out nocopy JTF_NUMBER_TABLE
162: , p7_a26 out nocopy JTF_DATE_TABLE
163: , p7_a27 out nocopy JTF_NUMBER_TABLE
164: , p7_a28 out nocopy JTF_DATE_TABLE
165: , p7_a29 out nocopy JTF_NUMBER_TABLE
166: , p7_a30 out nocopy JTF_DATE_TABLE
167: , x_rbk_count out nocopy NUMBER
168: );
169: procedure build_and_get_contracts(p_api_version NUMBER
172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , p_request_name VARCHAR2
175: , p_transaction_date date
176: , p7_a0 JTF_NUMBER_TABLE
177: , p7_a1 JTF_VARCHAR2_TABLE_600
178: , p7_a2 JTF_NUMBER_TABLE
179: , p7_a3 JTF_VARCHAR2_TABLE_100
180: , p7_a4 JTF_VARCHAR2_TABLE_100
174: , p_request_name VARCHAR2
175: , p_transaction_date date
176: , p7_a0 JTF_NUMBER_TABLE
177: , p7_a1 JTF_VARCHAR2_TABLE_600
178: , p7_a2 JTF_NUMBER_TABLE
179: , p7_a3 JTF_VARCHAR2_TABLE_100
180: , p7_a4 JTF_VARCHAR2_TABLE_100
181: , p7_a5 JTF_VARCHAR2_TABLE_100
182: , p7_a6 JTF_VARCHAR2_TABLE_600
199: , p7_a23 JTF_VARCHAR2_TABLE_500
200: , p7_a24 JTF_VARCHAR2_TABLE_500
201: , p7_a25 JTF_VARCHAR2_TABLE_500
202: , p7_a26 JTF_VARCHAR2_TABLE_500
203: , p7_a27 JTF_NUMBER_TABLE
204: , p7_a28 JTF_DATE_TABLE
205: , p7_a29 JTF_NUMBER_TABLE
206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE
201: , p7_a25 JTF_VARCHAR2_TABLE_500
202: , p7_a26 JTF_VARCHAR2_TABLE_500
203: , p7_a27 JTF_NUMBER_TABLE
204: , p7_a28 JTF_DATE_TABLE
205: , p7_a29 JTF_NUMBER_TABLE
206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE
208: , p8_a0 out nocopy JTF_NUMBER_TABLE
209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
203: , p7_a27 JTF_NUMBER_TABLE
204: , p7_a28 JTF_DATE_TABLE
205: , p7_a29 JTF_NUMBER_TABLE
206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE
208: , p8_a0 out nocopy JTF_NUMBER_TABLE
209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
204: , p7_a28 JTF_DATE_TABLE
205: , p7_a29 JTF_NUMBER_TABLE
206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE
208: , p8_a0 out nocopy JTF_NUMBER_TABLE
209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
212: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
206: , p7_a30 JTF_DATE_TABLE
207: , p7_a31 JTF_NUMBER_TABLE
208: , p8_a0 out nocopy JTF_NUMBER_TABLE
209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
212: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
213: , p8_a5 out nocopy JTF_NUMBER_TABLE
214: , p8_a6 out nocopy JTF_NUMBER_TABLE
209: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
212: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
213: , p8_a5 out nocopy JTF_NUMBER_TABLE
214: , p8_a6 out nocopy JTF_NUMBER_TABLE
215: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
216: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
217: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
210: , p8_a2 out nocopy JTF_NUMBER_TABLE
211: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
212: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
213: , p8_a5 out nocopy JTF_NUMBER_TABLE
214: , p8_a6 out nocopy JTF_NUMBER_TABLE
215: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
216: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
217: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
218: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_500
229: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
230: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_500
231: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
232: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
233: , p8_a25 out nocopy JTF_NUMBER_TABLE
234: , p8_a26 out nocopy JTF_DATE_TABLE
235: , p8_a27 out nocopy JTF_NUMBER_TABLE
236: , p8_a28 out nocopy JTF_DATE_TABLE
237: , p8_a29 out nocopy JTF_NUMBER_TABLE
231: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
232: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
233: , p8_a25 out nocopy JTF_NUMBER_TABLE
234: , p8_a26 out nocopy JTF_DATE_TABLE
235: , p8_a27 out nocopy JTF_NUMBER_TABLE
236: , p8_a28 out nocopy JTF_DATE_TABLE
237: , p8_a29 out nocopy JTF_NUMBER_TABLE
238: , p8_a30 out nocopy JTF_DATE_TABLE
239: , x_rbk_count out nocopy NUMBER
233: , p8_a25 out nocopy JTF_NUMBER_TABLE
234: , p8_a26 out nocopy JTF_DATE_TABLE
235: , p8_a27 out nocopy JTF_NUMBER_TABLE
236: , p8_a28 out nocopy JTF_DATE_TABLE
237: , p8_a29 out nocopy JTF_NUMBER_TABLE
238: , p8_a30 out nocopy JTF_DATE_TABLE
239: , x_rbk_count out nocopy NUMBER
240: );
241: procedure apply_mass_rebook(p_api_version NUMBER
242: , p_init_msg_list VARCHAR2
243: , x_return_status out nocopy VARCHAR2
244: , x_msg_count out nocopy NUMBER
245: , x_msg_data out nocopy VARCHAR2
246: , p5_a0 JTF_NUMBER_TABLE
247: , p5_a1 JTF_VARCHAR2_TABLE_200
248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_VARCHAR2_TABLE_600
250: , p_deprn_method_code VARCHAR2
244: , x_msg_count out nocopy NUMBER
245: , x_msg_data out nocopy VARCHAR2
246: , p5_a0 JTF_NUMBER_TABLE
247: , p5_a1 JTF_VARCHAR2_TABLE_200
248: , p5_a2 JTF_NUMBER_TABLE
249: , p5_a3 JTF_VARCHAR2_TABLE_600
250: , p_deprn_method_code VARCHAR2
251: , p_in_service_date date
252: , p_life_in_months NUMBER
252: , p_life_in_months NUMBER
253: , p_basic_rate NUMBER
254: , p_adjusted_rate NUMBER
255: , p_residual_value NUMBER
256: , p12_a0 JTF_NUMBER_TABLE
257: , p12_a1 JTF_NUMBER_TABLE
258: , p12_a2 JTF_VARCHAR2_TABLE_500
259: , p12_a3 JTF_VARCHAR2_TABLE_500
260: , p12_a4 JTF_VARCHAR2_TABLE_500
253: , p_basic_rate NUMBER
254: , p_adjusted_rate NUMBER
255: , p_residual_value NUMBER
256: , p12_a0 JTF_NUMBER_TABLE
257: , p12_a1 JTF_NUMBER_TABLE
258: , p12_a2 JTF_VARCHAR2_TABLE_500
259: , p12_a3 JTF_VARCHAR2_TABLE_500
260: , p12_a4 JTF_VARCHAR2_TABLE_500
261: , p12_a5 JTF_VARCHAR2_TABLE_500
285: , p_init_msg_list VARCHAR2
286: , x_return_status out nocopy VARCHAR2
287: , x_msg_count out nocopy NUMBER
288: , x_msg_data out nocopy VARCHAR2
289: , p5_a0 JTF_NUMBER_TABLE
290: , p5_a1 JTF_VARCHAR2_TABLE_200
291: , p5_a2 JTF_NUMBER_TABLE
292: , p5_a3 JTF_VARCHAR2_TABLE_600
293: , p_deprn_method_code VARCHAR2
287: , x_msg_count out nocopy NUMBER
288: , x_msg_data out nocopy VARCHAR2
289: , p5_a0 JTF_NUMBER_TABLE
290: , p5_a1 JTF_VARCHAR2_TABLE_200
291: , p5_a2 JTF_NUMBER_TABLE
292: , p5_a3 JTF_VARCHAR2_TABLE_600
293: , p_deprn_method_code VARCHAR2
294: , p_in_service_date date
295: , p_life_in_months NUMBER
295: , p_life_in_months NUMBER
296: , p_basic_rate NUMBER
297: , p_adjusted_rate NUMBER
298: , p_residual_value NUMBER
299: , p12_a0 JTF_NUMBER_TABLE
300: , p12_a1 JTF_NUMBER_TABLE
301: , p12_a2 JTF_VARCHAR2_TABLE_500
302: , p12_a3 JTF_VARCHAR2_TABLE_500
303: , p12_a4 JTF_VARCHAR2_TABLE_500
296: , p_basic_rate NUMBER
297: , p_adjusted_rate NUMBER
298: , p_residual_value NUMBER
299: , p12_a0 JTF_NUMBER_TABLE
300: , p12_a1 JTF_NUMBER_TABLE
301: , p12_a2 JTF_VARCHAR2_TABLE_500
302: , p12_a3 JTF_VARCHAR2_TABLE_500
303: , p12_a4 JTF_VARCHAR2_TABLE_500
304: , p12_a5 JTF_VARCHAR2_TABLE_500
322: , p12_a23 JTF_VARCHAR2_TABLE_200
323: , p12_a24 JTF_VARCHAR2_TABLE_100
324: , p12_a25 JTF_VARCHAR2_TABLE_100
325: , p12_a26 JTF_VARCHAR2_TABLE_100
326: , p13_a0 out nocopy JTF_NUMBER_TABLE
327: , p13_a1 out nocopy JTF_NUMBER_TABLE
328: );
329: procedure apply_mass_rebook(p_api_version NUMBER
330: , p_init_msg_list VARCHAR2
323: , p12_a24 JTF_VARCHAR2_TABLE_100
324: , p12_a25 JTF_VARCHAR2_TABLE_100
325: , p12_a26 JTF_VARCHAR2_TABLE_100
326: , p13_a0 out nocopy JTF_NUMBER_TABLE
327: , p13_a1 out nocopy JTF_NUMBER_TABLE
328: );
329: procedure apply_mass_rebook(p_api_version NUMBER
330: , p_init_msg_list VARCHAR2
331: , x_return_status out nocopy VARCHAR2
330: , p_init_msg_list VARCHAR2
331: , x_return_status out nocopy VARCHAR2
332: , x_msg_count out nocopy NUMBER
333: , x_msg_data out nocopy VARCHAR2
334: , p5_a0 JTF_NUMBER_TABLE
335: , p5_a1 JTF_VARCHAR2_TABLE_200
336: , p5_a2 JTF_NUMBER_TABLE
337: , p5_a3 JTF_VARCHAR2_TABLE_600
338: , p_deprn_method_code VARCHAR2
332: , x_msg_count out nocopy NUMBER
333: , x_msg_data out nocopy VARCHAR2
334: , p5_a0 JTF_NUMBER_TABLE
335: , p5_a1 JTF_VARCHAR2_TABLE_200
336: , p5_a2 JTF_NUMBER_TABLE
337: , p5_a3 JTF_VARCHAR2_TABLE_600
338: , p_deprn_method_code VARCHAR2
339: , p_in_service_date date
340: , p_life_in_months NUMBER
340: , p_life_in_months NUMBER
341: , p_basic_rate NUMBER
342: , p_adjusted_rate NUMBER
343: , p_residual_value NUMBER
344: , p12_a0 JTF_NUMBER_TABLE
345: , p12_a1 JTF_NUMBER_TABLE
346: , p12_a2 JTF_VARCHAR2_TABLE_500
347: , p12_a3 JTF_VARCHAR2_TABLE_500
348: , p12_a4 JTF_VARCHAR2_TABLE_500
341: , p_basic_rate NUMBER
342: , p_adjusted_rate NUMBER
343: , p_residual_value NUMBER
344: , p12_a0 JTF_NUMBER_TABLE
345: , p12_a1 JTF_NUMBER_TABLE
346: , p12_a2 JTF_VARCHAR2_TABLE_500
347: , p12_a3 JTF_VARCHAR2_TABLE_500
348: , p12_a4 JTF_VARCHAR2_TABLE_500
349: , p12_a5 JTF_VARCHAR2_TABLE_500
368: , p12_a24 JTF_VARCHAR2_TABLE_100
369: , p12_a25 JTF_VARCHAR2_TABLE_100
370: , p12_a26 JTF_VARCHAR2_TABLE_100
371: , p_transaction_date date
372: , p14_a0 out nocopy JTF_NUMBER_TABLE
373: , p14_a1 out nocopy JTF_NUMBER_TABLE
374: );
375: procedure apply_mass_rebook(p_api_version NUMBER
376: , p_init_msg_list VARCHAR2
369: , p12_a25 JTF_VARCHAR2_TABLE_100
370: , p12_a26 JTF_VARCHAR2_TABLE_100
371: , p_transaction_date date
372: , p14_a0 out nocopy JTF_NUMBER_TABLE
373: , p14_a1 out nocopy JTF_NUMBER_TABLE
374: );
375: procedure apply_mass_rebook(p_api_version NUMBER
376: , p_init_msg_list VARCHAR2
377: , x_return_status out nocopy VARCHAR2
376: , p_init_msg_list VARCHAR2
377: , x_return_status out nocopy VARCHAR2
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_VARCHAR2_TABLE_200
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_VARCHAR2_TABLE_600
384: , p_deprn_method_code VARCHAR2
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_VARCHAR2_TABLE_200
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_VARCHAR2_TABLE_600
384: , p_deprn_method_code VARCHAR2
385: , p_in_service_date date
386: , p_life_in_months NUMBER
386: , p_life_in_months NUMBER
387: , p_basic_rate NUMBER
388: , p_adjusted_rate NUMBER
389: , p_residual_value NUMBER
390: , p12_a0 JTF_NUMBER_TABLE
391: , p12_a1 JTF_NUMBER_TABLE
392: , p12_a2 JTF_VARCHAR2_TABLE_500
393: , p12_a3 JTF_VARCHAR2_TABLE_500
394: , p12_a4 JTF_VARCHAR2_TABLE_500
387: , p_basic_rate NUMBER
388: , p_adjusted_rate NUMBER
389: , p_residual_value NUMBER
390: , p12_a0 JTF_NUMBER_TABLE
391: , p12_a1 JTF_NUMBER_TABLE
392: , p12_a2 JTF_VARCHAR2_TABLE_500
393: , p12_a3 JTF_VARCHAR2_TABLE_500
394: , p12_a4 JTF_VARCHAR2_TABLE_500
395: , p12_a5 JTF_VARCHAR2_TABLE_500
422: , p_init_msg_list VARCHAR2
423: , x_return_status out nocopy VARCHAR2
424: , x_msg_count out nocopy NUMBER
425: , x_msg_data out nocopy VARCHAR2
426: , p5_a0 JTF_NUMBER_TABLE
427: , p5_a1 JTF_VARCHAR2_TABLE_200
428: , p5_a2 JTF_NUMBER_TABLE
429: , p5_a3 JTF_VARCHAR2_TABLE_600
430: , p_deprn_method_code VARCHAR2
424: , x_msg_count out nocopy NUMBER
425: , x_msg_data out nocopy VARCHAR2
426: , p5_a0 JTF_NUMBER_TABLE
427: , p5_a1 JTF_VARCHAR2_TABLE_200
428: , p5_a2 JTF_NUMBER_TABLE
429: , p5_a3 JTF_VARCHAR2_TABLE_600
430: , p_deprn_method_code VARCHAR2
431: , p_in_service_date date
432: , p_life_in_months NUMBER
432: , p_life_in_months NUMBER
433: , p_basic_rate NUMBER
434: , p_adjusted_rate NUMBER
435: , p_residual_value NUMBER
436: , p12_a0 JTF_NUMBER_TABLE
437: , p12_a1 JTF_NUMBER_TABLE
438: , p12_a2 JTF_VARCHAR2_TABLE_500
439: , p12_a3 JTF_VARCHAR2_TABLE_500
440: , p12_a4 JTF_VARCHAR2_TABLE_500
433: , p_basic_rate NUMBER
434: , p_adjusted_rate NUMBER
435: , p_residual_value NUMBER
436: , p12_a0 JTF_NUMBER_TABLE
437: , p12_a1 JTF_NUMBER_TABLE
438: , p12_a2 JTF_VARCHAR2_TABLE_500
439: , p12_a3 JTF_VARCHAR2_TABLE_500
440: , p12_a4 JTF_VARCHAR2_TABLE_500
441: , p12_a5 JTF_VARCHAR2_TABLE_500
470: , x_return_status out nocopy VARCHAR2
471: , x_msg_count out nocopy NUMBER
472: , x_msg_data out nocopy VARCHAR2
473: , p_chr_id NUMBER
474: , p6_a0 JTF_NUMBER_TABLE
475: , p_source_trx_id NUMBER
476: , p_source_trx_type VARCHAR2
477: , p_transaction_date date
478: , x_mass_rebook_trx_id out nocopy NUMBER
477: , p_transaction_date date
478: , x_mass_rebook_trx_id out nocopy NUMBER
479: , p_ppd_amount NUMBER
480: , p_ppd_reason_code VARCHAR2
481: , p13_a0 JTF_NUMBER_TABLE
482: , p13_a1 JTF_NUMBER_TABLE
483: , p13_a2 JTF_VARCHAR2_TABLE_500
484: , p13_a3 JTF_VARCHAR2_TABLE_500
485: , p13_a4 JTF_VARCHAR2_TABLE_500
478: , x_mass_rebook_trx_id out nocopy NUMBER
479: , p_ppd_amount NUMBER
480: , p_ppd_reason_code VARCHAR2
481: , p13_a0 JTF_NUMBER_TABLE
482: , p13_a1 JTF_NUMBER_TABLE
483: , p13_a2 JTF_VARCHAR2_TABLE_500
484: , p13_a3 JTF_VARCHAR2_TABLE_500
485: , p13_a4 JTF_VARCHAR2_TABLE_500
486: , p13_a5 JTF_VARCHAR2_TABLE_500
510: , p_init_msg_list VARCHAR2
511: , x_return_status out nocopy VARCHAR2
512: , x_msg_count out nocopy NUMBER
513: , x_msg_data out nocopy VARCHAR2
514: , p5_a0 JTF_NUMBER_TABLE
515: , p5_a1 JTF_VARCHAR2_TABLE_200
516: , p5_a2 JTF_NUMBER_TABLE
517: , p5_a3 JTF_VARCHAR2_TABLE_200
518: , p5_a4 JTF_VARCHAR2_TABLE_600
512: , x_msg_count out nocopy NUMBER
513: , x_msg_data out nocopy VARCHAR2
514: , p5_a0 JTF_NUMBER_TABLE
515: , p5_a1 JTF_VARCHAR2_TABLE_200
516: , p5_a2 JTF_NUMBER_TABLE
517: , p5_a3 JTF_VARCHAR2_TABLE_200
518: , p5_a4 JTF_VARCHAR2_TABLE_600
519: , p5_a5 JTF_NUMBER_TABLE
520: , p5_a6 JTF_NUMBER_TABLE
515: , p5_a1 JTF_VARCHAR2_TABLE_200
516: , p5_a2 JTF_NUMBER_TABLE
517: , p5_a3 JTF_VARCHAR2_TABLE_200
518: , p5_a4 JTF_VARCHAR2_TABLE_600
519: , p5_a5 JTF_NUMBER_TABLE
520: , p5_a6 JTF_NUMBER_TABLE
521: , p5_a7 JTF_VARCHAR2_TABLE_100
522: , p5_a8 JTF_VARCHAR2_TABLE_100
523: , p5_a9 JTF_VARCHAR2_TABLE_100
516: , p5_a2 JTF_NUMBER_TABLE
517: , p5_a3 JTF_VARCHAR2_TABLE_200
518: , p5_a4 JTF_VARCHAR2_TABLE_600
519: , p5_a5 JTF_NUMBER_TABLE
520: , p5_a6 JTF_NUMBER_TABLE
521: , p5_a7 JTF_VARCHAR2_TABLE_100
522: , p5_a8 JTF_VARCHAR2_TABLE_100
523: , p5_a9 JTF_VARCHAR2_TABLE_100
524: , p5_a10 JTF_VARCHAR2_TABLE_500
535: , p5_a21 JTF_VARCHAR2_TABLE_500
536: , p5_a22 JTF_VARCHAR2_TABLE_500
537: , p5_a23 JTF_VARCHAR2_TABLE_500
538: , p5_a24 JTF_VARCHAR2_TABLE_500
539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_DATE_TABLE
541: , p5_a27 JTF_NUMBER_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
537: , p5_a23 JTF_VARCHAR2_TABLE_500
538: , p5_a24 JTF_VARCHAR2_TABLE_500
539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_DATE_TABLE
541: , p5_a27 JTF_NUMBER_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_DATE_TABLE
545: , p6_a0 out nocopy JTF_NUMBER_TABLE
539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_DATE_TABLE
541: , p5_a27 JTF_NUMBER_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_DATE_TABLE
545: , p6_a0 out nocopy JTF_NUMBER_TABLE
546: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
547: , p6_a2 out nocopy JTF_NUMBER_TABLE
541: , p5_a27 JTF_NUMBER_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_DATE_TABLE
545: , p6_a0 out nocopy JTF_NUMBER_TABLE
546: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
547: , p6_a2 out nocopy JTF_NUMBER_TABLE
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
549: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_DATE_TABLE
545: , p6_a0 out nocopy JTF_NUMBER_TABLE
546: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
547: , p6_a2 out nocopy JTF_NUMBER_TABLE
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
549: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
550: , p6_a5 out nocopy JTF_NUMBER_TABLE
551: , p6_a6 out nocopy JTF_NUMBER_TABLE
546: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
547: , p6_a2 out nocopy JTF_NUMBER_TABLE
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
549: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
550: , p6_a5 out nocopy JTF_NUMBER_TABLE
551: , p6_a6 out nocopy JTF_NUMBER_TABLE
552: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
553: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
554: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
547: , p6_a2 out nocopy JTF_NUMBER_TABLE
548: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
549: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
550: , p6_a5 out nocopy JTF_NUMBER_TABLE
551: , p6_a6 out nocopy JTF_NUMBER_TABLE
552: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
553: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
554: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
555: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
566: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
567: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
568: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
569: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
570: , p6_a25 out nocopy JTF_NUMBER_TABLE
571: , p6_a26 out nocopy JTF_DATE_TABLE
572: , p6_a27 out nocopy JTF_NUMBER_TABLE
573: , p6_a28 out nocopy JTF_DATE_TABLE
574: , p6_a29 out nocopy JTF_NUMBER_TABLE
568: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
569: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
570: , p6_a25 out nocopy JTF_NUMBER_TABLE
571: , p6_a26 out nocopy JTF_DATE_TABLE
572: , p6_a27 out nocopy JTF_NUMBER_TABLE
573: , p6_a28 out nocopy JTF_DATE_TABLE
574: , p6_a29 out nocopy JTF_NUMBER_TABLE
575: , p6_a30 out nocopy JTF_DATE_TABLE
576: );
570: , p6_a25 out nocopy JTF_NUMBER_TABLE
571: , p6_a26 out nocopy JTF_DATE_TABLE
572: , p6_a27 out nocopy JTF_NUMBER_TABLE
573: , p6_a28 out nocopy JTF_DATE_TABLE
574: , p6_a29 out nocopy JTF_NUMBER_TABLE
575: , p6_a30 out nocopy JTF_DATE_TABLE
576: );
577: procedure create_mass_rbk_set_values(p_api_version NUMBER
578: , p_init_msg_list VARCHAR2
579: , x_return_status out nocopy VARCHAR2
580: , x_msg_count out nocopy NUMBER
581: , x_msg_data out nocopy VARCHAR2
582: , p_request_name VARCHAR2
583: , p6_a0 JTF_NUMBER_TABLE
584: , p6_a1 JTF_VARCHAR2_TABLE_600
585: , p6_a2 JTF_NUMBER_TABLE
586: , p6_a3 JTF_VARCHAR2_TABLE_100
587: , p6_a4 JTF_VARCHAR2_TABLE_100
581: , x_msg_data out nocopy VARCHAR2
582: , p_request_name VARCHAR2
583: , p6_a0 JTF_NUMBER_TABLE
584: , p6_a1 JTF_VARCHAR2_TABLE_600
585: , p6_a2 JTF_NUMBER_TABLE
586: , p6_a3 JTF_VARCHAR2_TABLE_100
587: , p6_a4 JTF_VARCHAR2_TABLE_100
588: , p6_a5 JTF_VARCHAR2_TABLE_100
589: , p6_a6 JTF_VARCHAR2_TABLE_600
606: , p6_a23 JTF_VARCHAR2_TABLE_500
607: , p6_a24 JTF_VARCHAR2_TABLE_500
608: , p6_a25 JTF_VARCHAR2_TABLE_500
609: , p6_a26 JTF_VARCHAR2_TABLE_500
610: , p6_a27 JTF_NUMBER_TABLE
611: , p6_a28 JTF_DATE_TABLE
612: , p6_a29 JTF_NUMBER_TABLE
613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE
608: , p6_a25 JTF_VARCHAR2_TABLE_500
609: , p6_a26 JTF_VARCHAR2_TABLE_500
610: , p6_a27 JTF_NUMBER_TABLE
611: , p6_a28 JTF_DATE_TABLE
612: , p6_a29 JTF_NUMBER_TABLE
613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE
615: , p7_a0 out nocopy JTF_NUMBER_TABLE
616: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
610: , p6_a27 JTF_NUMBER_TABLE
611: , p6_a28 JTF_DATE_TABLE
612: , p6_a29 JTF_NUMBER_TABLE
613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE
615: , p7_a0 out nocopy JTF_NUMBER_TABLE
616: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
617: , p7_a2 out nocopy JTF_NUMBER_TABLE
618: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
611: , p6_a28 JTF_DATE_TABLE
612: , p6_a29 JTF_NUMBER_TABLE
613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE
615: , p7_a0 out nocopy JTF_NUMBER_TABLE
616: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
617: , p7_a2 out nocopy JTF_NUMBER_TABLE
618: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
619: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
613: , p6_a30 JTF_DATE_TABLE
614: , p6_a31 JTF_NUMBER_TABLE
615: , p7_a0 out nocopy JTF_NUMBER_TABLE
616: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
617: , p7_a2 out nocopy JTF_NUMBER_TABLE
618: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
619: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
620: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
621: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_600
638: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
639: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
640: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_500
641: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_500
642: , p7_a27 out nocopy JTF_NUMBER_TABLE
643: , p7_a28 out nocopy JTF_DATE_TABLE
644: , p7_a29 out nocopy JTF_NUMBER_TABLE
645: , p7_a30 out nocopy JTF_DATE_TABLE
646: , p7_a31 out nocopy JTF_NUMBER_TABLE
640: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_500
641: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_500
642: , p7_a27 out nocopy JTF_NUMBER_TABLE
643: , p7_a28 out nocopy JTF_DATE_TABLE
644: , p7_a29 out nocopy JTF_NUMBER_TABLE
645: , p7_a30 out nocopy JTF_DATE_TABLE
646: , p7_a31 out nocopy JTF_NUMBER_TABLE
647: );
648: end okl_mass_rebook_pvt_w;
642: , p7_a27 out nocopy JTF_NUMBER_TABLE
643: , p7_a28 out nocopy JTF_DATE_TABLE
644: , p7_a29 out nocopy JTF_NUMBER_TABLE
645: , p7_a30 out nocopy JTF_DATE_TABLE
646: , p7_a31 out nocopy JTF_NUMBER_TABLE
647: );
648: end okl_mass_rebook_pvt_w;