[Home] [Help]
PACKAGE: APPS.AHL_MM_RESERVATIONS_PVT_W
Source
1 package ahl_mm_reservations_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWMMRS.pls 120.0.12020000.2 2012/12/13 06:07:48 shnatu noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_reservations_pvt.serial_number_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 );
6 procedure rosetta_table_copy_out_p2(t ahl_mm_reservations_pvt.serial_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7 , a1 out nocopy JTF_VARCHAR2_TABLE_100
8 );
9
10 procedure rosetta_table_copy_in_p4(t out nocopy ahl_mm_reservations_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
11 procedure rosetta_table_copy_out_p4(t ahl_mm_reservations_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
12
13 procedure rosetta_table_copy_in_p5(t out nocopy ahl_mm_reservations_pvt.varchar_table_type, a0 JTF_VARCHAR2_TABLE_100);
14 procedure rosetta_table_copy_out_p5(t ahl_mm_reservations_pvt.varchar_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
15
16 procedure create_reservation(p_api_version NUMBER
17 , p_init_msg_list VARCHAR2
18 , p_commit VARCHAR2
19 , p_validation_level NUMBER
20 , p_module_type VARCHAR2
21 , x_return_status out nocopy VARCHAR2
22 , x_msg_count out nocopy NUMBER
23 , x_msg_data out nocopy VARCHAR2
24 , p8_a0 NUMBER
25 , p8_a1 DATE
26 , p8_a2 NUMBER
27 , p8_a3 NUMBER
28 , p8_a4 NUMBER
29 , p8_a5 VARCHAR2
30 , p8_a6 NUMBER
31 , p8_a7 NUMBER
32 , p8_a8 NUMBER
33 , p8_a9 VARCHAR2
34 , p8_a10 NUMBER
35 , p8_a11 VARCHAR2
36 , p8_a12 NUMBER
37 , p8_a13 VARCHAR2
38 , p8_a14 NUMBER
39 , p8_a15 NUMBER
40 , p8_a16 NUMBER
41 , p8_a17 NUMBER
42 , p8_a18 NUMBER
43 , p8_a19 NUMBER
44 , p8_a20 NUMBER
45 , p8_a21 VARCHAR2
46 , p8_a22 NUMBER
47 , p8_a23 NUMBER
48 , p8_a24 NUMBER
49 , p8_a25 NUMBER
50 , p8_a26 VARCHAR2
51 , p8_a27 NUMBER
52 , p8_a28 VARCHAR2
53 , p8_a29 VARCHAR2
54 , p8_a30 NUMBER
55 , p8_a31 NUMBER
56 , p8_a32 VARCHAR2
57 , p8_a33 NUMBER
58 , p8_a34 NUMBER
59 , p8_a35 NUMBER
60 , p8_a36 VARCHAR2
61 , p8_a37 VARCHAR2
62 , p8_a38 VARCHAR2
63 , p8_a39 VARCHAR2
64 , p8_a40 VARCHAR2
65 , p8_a41 VARCHAR2
66 , p8_a42 VARCHAR2
67 , p8_a43 VARCHAR2
68 , p8_a44 VARCHAR2
69 , p8_a45 VARCHAR2
70 , p8_a46 VARCHAR2
71 , p8_a47 VARCHAR2
72 , p8_a48 VARCHAR2
73 , p8_a49 VARCHAR2
74 , p8_a50 VARCHAR2
75 , p8_a51 VARCHAR2
76 , p8_a52 NUMBER
77 , p8_a53 VARCHAR2
78 , p8_a54 VARCHAR2
79 , p8_a55 NUMBER
80 , p8_a56 NUMBER
81 , p8_a57 NUMBER
82 , p8_a58 DATE
83 , p8_a59 DATE
84 , p8_a60 NUMBER
85 , p8_a61 NUMBER
86 , p8_a62 NUMBER
87 , p8_a63 NUMBER
88 , p8_a64 NUMBER
89 , p8_a65 NUMBER
90 , p8_a66 NUMBER
91 , p8_a67 NUMBER
92 , p8_a68 NUMBER
93 , p8_a69 NUMBER
94 , p8_a70 VARCHAR2
95 , p9_a0 JTF_NUMBER_TABLE
96 , p9_a1 JTF_VARCHAR2_TABLE_100
97 , x_reservation_id out nocopy NUMBER
98 );
99 procedure update_reservation(p_api_version NUMBER
100 , p_init_msg_list VARCHAR2
101 , p_commit VARCHAR2
102 , p_validation_level NUMBER
103 , p_module_type VARCHAR2
104 , x_return_status out nocopy VARCHAR2
105 , x_msg_count out nocopy NUMBER
106 , x_msg_data out nocopy VARCHAR2
107 , p_reservation_id NUMBER
108 , p9_a0 NUMBER
109 , p9_a1 DATE
110 , p9_a2 NUMBER
111 , p9_a3 NUMBER
112 , p9_a4 NUMBER
113 , p9_a5 VARCHAR2
114 , p9_a6 NUMBER
115 , p9_a7 NUMBER
116 , p9_a8 NUMBER
117 , p9_a9 VARCHAR2
118 , p9_a10 NUMBER
119 , p9_a11 VARCHAR2
120 , p9_a12 NUMBER
121 , p9_a13 VARCHAR2
122 , p9_a14 NUMBER
123 , p9_a15 NUMBER
124 , p9_a16 NUMBER
125 , p9_a17 NUMBER
126 , p9_a18 NUMBER
127 , p9_a19 NUMBER
128 , p9_a20 NUMBER
129 , p9_a21 VARCHAR2
130 , p9_a22 NUMBER
131 , p9_a23 NUMBER
132 , p9_a24 NUMBER
133 , p9_a25 NUMBER
134 , p9_a26 VARCHAR2
135 , p9_a27 NUMBER
136 , p9_a28 VARCHAR2
137 , p9_a29 VARCHAR2
138 , p9_a30 NUMBER
139 , p9_a31 NUMBER
140 , p9_a32 VARCHAR2
141 , p9_a33 NUMBER
142 , p9_a34 NUMBER
143 , p9_a35 NUMBER
144 , p9_a36 VARCHAR2
145 , p9_a37 VARCHAR2
146 , p9_a38 VARCHAR2
147 , p9_a39 VARCHAR2
148 , p9_a40 VARCHAR2
149 , p9_a41 VARCHAR2
150 , p9_a42 VARCHAR2
151 , p9_a43 VARCHAR2
152 , p9_a44 VARCHAR2
153 , p9_a45 VARCHAR2
154 , p9_a46 VARCHAR2
155 , p9_a47 VARCHAR2
156 , p9_a48 VARCHAR2
157 , p9_a49 VARCHAR2
158 , p9_a50 VARCHAR2
159 , p9_a51 VARCHAR2
160 , p9_a52 NUMBER
161 , p9_a53 VARCHAR2
162 , p9_a54 VARCHAR2
163 , p9_a55 NUMBER
164 , p9_a56 NUMBER
165 , p9_a57 NUMBER
166 , p9_a58 DATE
167 , p9_a59 DATE
168 , p9_a60 NUMBER
169 , p9_a61 NUMBER
170 , p9_a62 NUMBER
171 , p9_a63 NUMBER
172 , p9_a64 NUMBER
173 , p9_a65 NUMBER
174 , p9_a66 NUMBER
175 , p9_a67 NUMBER
176 , p9_a68 NUMBER
177 , p9_a69 NUMBER
178 , p9_a70 VARCHAR2
179 , p10_a0 JTF_NUMBER_TABLE
180 , p10_a1 JTF_VARCHAR2_TABLE_100
181 );
182 procedure relieve_reservation(p_api_version NUMBER
183 , p_init_msg_list VARCHAR2
184 , p_commit VARCHAR2
185 , p_validation_level NUMBER
186 , p_module_type VARCHAR2
187 , x_return_status out nocopy VARCHAR2
188 , x_msg_count out nocopy NUMBER
189 , x_msg_data out nocopy VARCHAR2
190 , p_reservation_id NUMBER
191 , p9_a0 JTF_NUMBER_TABLE
192 , p9_a1 JTF_VARCHAR2_TABLE_100
193 );
194 procedure transfer_reservation(p_api_version NUMBER
195 , p_init_msg_list VARCHAR2
196 , p_commit VARCHAR2
197 , p_validation_level NUMBER
198 , p_module_type VARCHAR2
199 , x_return_status out nocopy VARCHAR2
200 , x_msg_count out nocopy NUMBER
201 , x_msg_data out nocopy VARCHAR2
202 , p_from_reservation_id NUMBER
203 , p9_a0 NUMBER
204 , p9_a1 DATE
205 , p9_a2 NUMBER
206 , p9_a3 NUMBER
207 , p9_a4 NUMBER
208 , p9_a5 VARCHAR2
209 , p9_a6 NUMBER
210 , p9_a7 NUMBER
211 , p9_a8 NUMBER
212 , p9_a9 VARCHAR2
213 , p9_a10 NUMBER
214 , p9_a11 VARCHAR2
215 , p9_a12 NUMBER
216 , p9_a13 VARCHAR2
217 , p9_a14 NUMBER
218 , p9_a15 NUMBER
219 , p9_a16 NUMBER
220 , p9_a17 NUMBER
221 , p9_a18 NUMBER
222 , p9_a19 NUMBER
223 , p9_a20 NUMBER
224 , p9_a21 VARCHAR2
225 , p9_a22 NUMBER
226 , p9_a23 NUMBER
227 , p9_a24 NUMBER
228 , p9_a25 NUMBER
229 , p9_a26 VARCHAR2
230 , p9_a27 NUMBER
231 , p9_a28 VARCHAR2
232 , p9_a29 VARCHAR2
233 , p9_a30 NUMBER
234 , p9_a31 NUMBER
235 , p9_a32 VARCHAR2
236 , p9_a33 NUMBER
237 , p9_a34 NUMBER
238 , p9_a35 NUMBER
239 , p9_a36 VARCHAR2
240 , p9_a37 VARCHAR2
241 , p9_a38 VARCHAR2
242 , p9_a39 VARCHAR2
243 , p9_a40 VARCHAR2
244 , p9_a41 VARCHAR2
245 , p9_a42 VARCHAR2
246 , p9_a43 VARCHAR2
247 , p9_a44 VARCHAR2
248 , p9_a45 VARCHAR2
249 , p9_a46 VARCHAR2
250 , p9_a47 VARCHAR2
251 , p9_a48 VARCHAR2
252 , p9_a49 VARCHAR2
253 , p9_a50 VARCHAR2
254 , p9_a51 VARCHAR2
255 , p9_a52 NUMBER
256 , p9_a53 VARCHAR2
257 , p9_a54 VARCHAR2
258 , p9_a55 NUMBER
259 , p9_a56 NUMBER
260 , p9_a57 NUMBER
261 , p9_a58 DATE
262 , p9_a59 DATE
263 , p9_a60 NUMBER
264 , p9_a61 NUMBER
265 , p9_a62 NUMBER
266 , p9_a63 NUMBER
267 , p9_a64 NUMBER
268 , p9_a65 NUMBER
269 , p9_a66 NUMBER
270 , p9_a67 NUMBER
271 , p9_a68 NUMBER
272 , p9_a69 NUMBER
273 , p9_a70 VARCHAR2
274 , p10_a0 JTF_NUMBER_TABLE
275 , p10_a1 JTF_VARCHAR2_TABLE_100
276 , x_to_reservation_id out nocopy NUMBER
277 );
278 procedure process_reservation(p_api_version NUMBER
279 , p_init_msg_list VARCHAR2
280 , p_commit VARCHAR2
281 , p_validation_level NUMBER
282 , p_module_type VARCHAR2
283 , x_return_status out nocopy VARCHAR2
284 , x_msg_count out nocopy NUMBER
285 , x_msg_data out nocopy VARCHAR2
286 , p8_a0 NUMBER
287 , p8_a1 DATE
288 , p8_a2 NUMBER
289 , p8_a3 NUMBER
290 , p8_a4 NUMBER
291 , p8_a5 VARCHAR2
292 , p8_a6 NUMBER
293 , p8_a7 NUMBER
294 , p8_a8 NUMBER
295 , p8_a9 VARCHAR2
296 , p8_a10 NUMBER
297 , p8_a11 VARCHAR2
298 , p8_a12 NUMBER
299 , p8_a13 VARCHAR2
300 , p8_a14 NUMBER
301 , p8_a15 NUMBER
302 , p8_a16 NUMBER
303 , p8_a17 NUMBER
304 , p8_a18 NUMBER
305 , p8_a19 NUMBER
306 , p8_a20 NUMBER
307 , p8_a21 VARCHAR2
308 , p8_a22 NUMBER
309 , p8_a23 NUMBER
310 , p8_a24 NUMBER
311 , p8_a25 NUMBER
312 , p8_a26 VARCHAR2
313 , p8_a27 NUMBER
314 , p8_a28 VARCHAR2
315 , p8_a29 VARCHAR2
316 , p8_a30 NUMBER
317 , p8_a31 NUMBER
318 , p8_a32 VARCHAR2
319 , p8_a33 NUMBER
320 , p8_a34 NUMBER
321 , p8_a35 NUMBER
322 , p8_a36 VARCHAR2
323 , p8_a37 VARCHAR2
324 , p8_a38 VARCHAR2
325 , p8_a39 VARCHAR2
326 , p8_a40 VARCHAR2
327 , p8_a41 VARCHAR2
328 , p8_a42 VARCHAR2
329 , p8_a43 VARCHAR2
330 , p8_a44 VARCHAR2
331 , p8_a45 VARCHAR2
332 , p8_a46 VARCHAR2
333 , p8_a47 VARCHAR2
334 , p8_a48 VARCHAR2
335 , p8_a49 VARCHAR2
336 , p8_a50 VARCHAR2
337 , p8_a51 VARCHAR2
338 , p8_a52 NUMBER
339 , p8_a53 VARCHAR2
340 , p8_a54 VARCHAR2
341 , p8_a55 NUMBER
342 , p8_a56 NUMBER
343 , p8_a57 NUMBER
344 , p8_a58 DATE
345 , p8_a59 DATE
346 , p8_a60 NUMBER
347 , p8_a61 NUMBER
348 , p8_a62 NUMBER
349 , p8_a63 NUMBER
350 , p8_a64 NUMBER
351 , p8_a65 NUMBER
352 , p8_a66 NUMBER
353 , p8_a67 NUMBER
354 , p8_a68 NUMBER
355 , p8_a69 NUMBER
356 , p8_a70 VARCHAR2
357 , p9_a0 JTF_NUMBER_TABLE
358 , p9_a1 JTF_VARCHAR2_TABLE_100
359 , x_reservation_id_tbl out nocopy JTF_NUMBER_TABLE
360 );
361 procedure cancel_reservation(p_api_version NUMBER
362 , p_init_msg_list VARCHAR2
363 , p_commit VARCHAR2
364 , p_validation_level NUMBER
365 , p_module_type VARCHAR2
366 , x_return_status out nocopy VARCHAR2
367 , x_msg_count out nocopy NUMBER
368 , x_msg_data out nocopy VARCHAR2
369 , p8_a0 JTF_NUMBER_TABLE
370 , p8_a1 JTF_VARCHAR2_TABLE_100
371 , p_reservation_id_tbl JTF_NUMBER_TABLE
372 );
373 end ahl_mm_reservations_pvt_w;