[Home] [Help]
Skip to content
PACKAGE BODY: APPS.AHL_UA_UNIT_SCHEDULES_PVT_W
Source
1 package body ahl_ua_unit_schedules_pvt_w as
2 /* $Header: AHLWUUSB.pls 120.1.12020000.2 2012/12/11 05:54:47 prakkum ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 ) as
10 ddindx binary_integer; indx binary_integer;
11 begin
12 if a0 is not null and a0.count > 0 then
13 if a0.count > 0 then
14 indx := a0.first;
15 ddindx := 1;
16 while true loop
17 t(ddindx).result_row_num := a0(indx);
18 t(ddindx).result_col_num := a1(indx);
19 t(ddindx).unit_config_header_id := a2(indx);
20 t(ddindx).unit_name := a3(indx);
21 t(ddindx).schedule_id := a4(indx);
22 t(ddindx).schedule_type := a5(indx);
23 ddindx := ddindx+1;
24 if a0.last =indx
25 then exit;
26 end if;
27 indx := a0.next(indx);
28 end loop;
29 end if;
30 end if;
31 end rosetta_table_copy_in_p3;
32 procedure rosetta_table_copy_out_p3(t ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33 , a1 out nocopy JTF_NUMBER_TABLE
34 , a2 out nocopy JTF_NUMBER_TABLE
35 , a3 out nocopy JTF_VARCHAR2_TABLE_100
36 , a4 out nocopy JTF_NUMBER_TABLE
37 , a5 out nocopy JTF_VARCHAR2_TABLE_100
38 ) as
39 ddindx binary_integer; indx binary_integer;
40 begin
41 if t is null or t.count = 0 then
42 a0 := JTF_NUMBER_TABLE();
43 a1 := JTF_NUMBER_TABLE();
44 a2 := JTF_NUMBER_TABLE();
45 a3 := JTF_VARCHAR2_TABLE_100();
46 a4 := JTF_NUMBER_TABLE();
47 a5 := JTF_VARCHAR2_TABLE_100();
48 else
49 a0 := JTF_NUMBER_TABLE();
50 a1 := JTF_NUMBER_TABLE();
51 a2 := JTF_NUMBER_TABLE();
52 a3 := JTF_VARCHAR2_TABLE_100();
53 a4 := JTF_NUMBER_TABLE();
54 a5 := JTF_VARCHAR2_TABLE_100();
55 if t.count > 0 then
56 a0.extend(t.count);
57 a1.extend(t.count);
58 a2.extend(t.count);
59 a3.extend(t.count);
60 a4.extend(t.count);
61 a5.extend(t.count);
62 ddindx := t.first;
63 indx := 1;
64 while true loop
65 a0(indx) := t(ddindx).result_row_num;
66 a1(indx) := t(ddindx).result_col_num;
67 a2(indx) := t(ddindx).unit_config_header_id;
68 a3(indx) := t(ddindx).unit_name;
69 a4(indx) := t(ddindx).schedule_id;
70 a5(indx) := t(ddindx).schedule_type;
71 indx := indx+1;
72 if t.last =ddindx
73 then exit;
74 end if;
75 ddindx := t.next(ddindx);
76 end loop;
77 end if;
78 end if;
79 end rosetta_table_copy_out_p3;
80
81 procedure rosetta_table_copy_in_p6(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
82 , a1 JTF_NUMBER_TABLE
83 , a2 JTF_VARCHAR2_TABLE_100
84 , a3 JTF_VARCHAR2_TABLE_100
85 , a4 JTF_NUMBER_TABLE
86 , a5 JTF_VARCHAR2_TABLE_300
87 , a6 JTF_NUMBER_TABLE
88 , a7 JTF_VARCHAR2_TABLE_300
89 , a8 JTF_NUMBER_TABLE
90 , a9 JTF_VARCHAR2_TABLE_300
91 , a10 JTF_NUMBER_TABLE
92 , a11 JTF_VARCHAR2_TABLE_300
93 , a12 JTF_DATE_TABLE
94 , a13 JTF_DATE_TABLE
95 , a14 JTF_VARCHAR2_TABLE_100
96 , a15 JTF_NUMBER_TABLE
97 , a16 JTF_NUMBER_TABLE
98 , a17 JTF_VARCHAR2_TABLE_100
99 , a18 JTF_VARCHAR2_TABLE_300
100 , a19 JTF_NUMBER_TABLE
101 , a20 JTF_VARCHAR2_TABLE_300
102 , a21 JTF_DATE_TABLE
103 , a22 JTF_NUMBER_TABLE
104 , a23 JTF_VARCHAR2_TABLE_100
105 , a24 JTF_VARCHAR2_TABLE_100
106 , a25 JTF_VARCHAR2_TABLE_100
107 , a26 JTF_VARCHAR2_TABLE_2000
108 , a27 JTF_VARCHAR2_TABLE_100
109 ) as
110 ddindx binary_integer; indx binary_integer;
111 begin
112 if a0 is not null and a0.count > 0 then
113 if a0.count > 0 then
114 indx := a0.first;
115 ddindx := 1;
116 while true loop
117 t(ddindx).event_seq := a0(indx);
118 t(ddindx).unit_schedule_id := a1(indx);
119 t(ddindx).flight_number := a2(indx);
120 t(ddindx).segment := a3(indx);
121 t(ddindx).departure_org_id := a4(indx);
122 t(ddindx).departure_org_name := a5(indx);
123 t(ddindx).departure_dep_id := a6(indx);
124 t(ddindx).departure_dep_name := a7(indx);
125 t(ddindx).arrival_org_id := a8(indx);
126 t(ddindx).arrival_org_name := a9(indx);
127 t(ddindx).arrival_dep_id := a10(indx);
128 t(ddindx).arrival_dep_name := a11(indx);
129 t(ddindx).departure_time := a12(indx);
130 t(ddindx).arrival_time := a13(indx);
131 t(ddindx).prev_event_type := a14(indx);
132 t(ddindx).prev_event_id := a15(indx);
133 t(ddindx).prev_event_org_id := a16(indx);
134 t(ddindx).is_prev_org_valid := a17(indx);
135 t(ddindx).prev_event_org_name := a18(indx);
136 t(ddindx).prev_event_dep_id := a19(indx);
137 t(ddindx).prve_event_dep_name := a20(indx);
138 t(ddindx).prev_event_end_time := a21(indx);
139 t(ddindx).prev_unit_schedule_id := a22(indx);
140 t(ddindx).prev_flight_number := a23(indx);
141 t(ddindx).has_mopportunity := a24(indx);
142 t(ddindx).has_conflict := a25(indx);
143 t(ddindx).conflict_message := a26(indx);
144 t(ddindx).is_org_valid := a27(indx);
145 ddindx := ddindx+1;
146 if a0.last =indx
147 then exit;
148 end if;
149 indx := a0.next(indx);
150 end loop;
151 end if;
152 end if;
153 end rosetta_table_copy_in_p6;
154 procedure rosetta_table_copy_out_p6(t ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
155 , a1 out nocopy JTF_NUMBER_TABLE
156 , a2 out nocopy JTF_VARCHAR2_TABLE_100
157 , a3 out nocopy JTF_VARCHAR2_TABLE_100
158 , a4 out nocopy JTF_NUMBER_TABLE
159 , a5 out nocopy JTF_VARCHAR2_TABLE_300
160 , a6 out nocopy JTF_NUMBER_TABLE
161 , a7 out nocopy JTF_VARCHAR2_TABLE_300
162 , a8 out nocopy JTF_NUMBER_TABLE
163 , a9 out nocopy JTF_VARCHAR2_TABLE_300
164 , a10 out nocopy JTF_NUMBER_TABLE
165 , a11 out nocopy JTF_VARCHAR2_TABLE_300
166 , a12 out nocopy JTF_DATE_TABLE
167 , a13 out nocopy JTF_DATE_TABLE
168 , a14 out nocopy JTF_VARCHAR2_TABLE_100
169 , a15 out nocopy JTF_NUMBER_TABLE
170 , a16 out nocopy JTF_NUMBER_TABLE
171 , a17 out nocopy JTF_VARCHAR2_TABLE_100
172 , a18 out nocopy JTF_VARCHAR2_TABLE_300
173 , a19 out nocopy JTF_NUMBER_TABLE
174 , a20 out nocopy JTF_VARCHAR2_TABLE_300
175 , a21 out nocopy JTF_DATE_TABLE
176 , a22 out nocopy JTF_NUMBER_TABLE
177 , a23 out nocopy JTF_VARCHAR2_TABLE_100
178 , a24 out nocopy JTF_VARCHAR2_TABLE_100
179 , a25 out nocopy JTF_VARCHAR2_TABLE_100
180 , a26 out nocopy JTF_VARCHAR2_TABLE_2000
181 , a27 out nocopy JTF_VARCHAR2_TABLE_100
182 ) as
183 ddindx binary_integer; indx binary_integer;
184 begin
185 if t is null or t.count = 0 then
186 a0 := JTF_NUMBER_TABLE();
187 a1 := JTF_NUMBER_TABLE();
188 a2 := JTF_VARCHAR2_TABLE_100();
189 a3 := JTF_VARCHAR2_TABLE_100();
190 a4 := JTF_NUMBER_TABLE();
191 a5 := JTF_VARCHAR2_TABLE_300();
192 a6 := JTF_NUMBER_TABLE();
193 a7 := JTF_VARCHAR2_TABLE_300();
194 a8 := JTF_NUMBER_TABLE();
195 a9 := JTF_VARCHAR2_TABLE_300();
196 a10 := JTF_NUMBER_TABLE();
197 a11 := JTF_VARCHAR2_TABLE_300();
198 a12 := JTF_DATE_TABLE();
199 a13 := JTF_DATE_TABLE();
200 a14 := JTF_VARCHAR2_TABLE_100();
201 a15 := JTF_NUMBER_TABLE();
202 a16 := JTF_NUMBER_TABLE();
203 a17 := JTF_VARCHAR2_TABLE_100();
204 a18 := JTF_VARCHAR2_TABLE_300();
205 a19 := JTF_NUMBER_TABLE();
206 a20 := JTF_VARCHAR2_TABLE_300();
207 a21 := JTF_DATE_TABLE();
208 a22 := JTF_NUMBER_TABLE();
209 a23 := JTF_VARCHAR2_TABLE_100();
210 a24 := JTF_VARCHAR2_TABLE_100();
211 a25 := JTF_VARCHAR2_TABLE_100();
212 a26 := JTF_VARCHAR2_TABLE_2000();
213 a27 := JTF_VARCHAR2_TABLE_100();
214 else
215 a0 := JTF_NUMBER_TABLE();
216 a1 := JTF_NUMBER_TABLE();
217 a2 := JTF_VARCHAR2_TABLE_100();
218 a3 := JTF_VARCHAR2_TABLE_100();
219 a4 := JTF_NUMBER_TABLE();
220 a5 := JTF_VARCHAR2_TABLE_300();
221 a6 := JTF_NUMBER_TABLE();
222 a7 := JTF_VARCHAR2_TABLE_300();
223 a8 := JTF_NUMBER_TABLE();
224 a9 := JTF_VARCHAR2_TABLE_300();
225 a10 := JTF_NUMBER_TABLE();
226 a11 := JTF_VARCHAR2_TABLE_300();
227 a12 := JTF_DATE_TABLE();
228 a13 := JTF_DATE_TABLE();
229 a14 := JTF_VARCHAR2_TABLE_100();
230 a15 := JTF_NUMBER_TABLE();
231 a16 := JTF_NUMBER_TABLE();
232 a17 := JTF_VARCHAR2_TABLE_100();
233 a18 := JTF_VARCHAR2_TABLE_300();
234 a19 := JTF_NUMBER_TABLE();
235 a20 := JTF_VARCHAR2_TABLE_300();
236 a21 := JTF_DATE_TABLE();
237 a22 := JTF_NUMBER_TABLE();
238 a23 := JTF_VARCHAR2_TABLE_100();
239 a24 := JTF_VARCHAR2_TABLE_100();
240 a25 := JTF_VARCHAR2_TABLE_100();
241 a26 := JTF_VARCHAR2_TABLE_2000();
242 a27 := JTF_VARCHAR2_TABLE_100();
243 if t.count > 0 then
244 a0.extend(t.count);
245 a1.extend(t.count);
246 a2.extend(t.count);
247 a3.extend(t.count);
248 a4.extend(t.count);
249 a5.extend(t.count);
250 a6.extend(t.count);
251 a7.extend(t.count);
252 a8.extend(t.count);
253 a9.extend(t.count);
254 a10.extend(t.count);
255 a11.extend(t.count);
256 a12.extend(t.count);
257 a13.extend(t.count);
258 a14.extend(t.count);
259 a15.extend(t.count);
260 a16.extend(t.count);
261 a17.extend(t.count);
262 a18.extend(t.count);
263 a19.extend(t.count);
264 a20.extend(t.count);
265 a21.extend(t.count);
266 a22.extend(t.count);
267 a23.extend(t.count);
268 a24.extend(t.count);
269 a25.extend(t.count);
270 a26.extend(t.count);
271 a27.extend(t.count);
272 ddindx := t.first;
273 indx := 1;
274 while true loop
275 a0(indx) := t(ddindx).event_seq;
276 a1(indx) := t(ddindx).unit_schedule_id;
277 a2(indx) := t(ddindx).flight_number;
278 a3(indx) := t(ddindx).segment;
279 a4(indx) := t(ddindx).departure_org_id;
280 a5(indx) := t(ddindx).departure_org_name;
281 a6(indx) := t(ddindx).departure_dep_id;
282 a7(indx) := t(ddindx).departure_dep_name;
283 a8(indx) := t(ddindx).arrival_org_id;
284 a9(indx) := t(ddindx).arrival_org_name;
285 a10(indx) := t(ddindx).arrival_dep_id;
286 a11(indx) := t(ddindx).arrival_dep_name;
287 a12(indx) := t(ddindx).departure_time;
288 a13(indx) := t(ddindx).arrival_time;
289 a14(indx) := t(ddindx).prev_event_type;
290 a15(indx) := t(ddindx).prev_event_id;
291 a16(indx) := t(ddindx).prev_event_org_id;
292 a17(indx) := t(ddindx).is_prev_org_valid;
293 a18(indx) := t(ddindx).prev_event_org_name;
294 a19(indx) := t(ddindx).prev_event_dep_id;
295 a20(indx) := t(ddindx).prve_event_dep_name;
296 a21(indx) := t(ddindx).prev_event_end_time;
297 a22(indx) := t(ddindx).prev_unit_schedule_id;
298 a23(indx) := t(ddindx).prev_flight_number;
299 a24(indx) := t(ddindx).has_mopportunity;
300 a25(indx) := t(ddindx).has_conflict;
301 a26(indx) := t(ddindx).conflict_message;
302 a27(indx) := t(ddindx).is_org_valid;
303 indx := indx+1;
304 if t.last =ddindx
305 then exit;
306 end if;
307 ddindx := t.next(ddindx);
308 end loop;
309 end if;
310 end if;
311 end rosetta_table_copy_out_p6;
312
313 procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
314 , a1 JTF_NUMBER_TABLE
315 , a2 JTF_VARCHAR2_TABLE_100
316 , a3 JTF_VARCHAR2_TABLE_100
317 , a4 JTF_VARCHAR2_TABLE_100
318 , a5 JTF_VARCHAR2_TABLE_100
319 , a6 JTF_VARCHAR2_TABLE_100
320 , a7 JTF_NUMBER_TABLE
321 , a8 JTF_VARCHAR2_TABLE_300
322 , a9 JTF_NUMBER_TABLE
323 , a10 JTF_VARCHAR2_TABLE_300
324 , a11 JTF_DATE_TABLE
325 , a12 JTF_DATE_TABLE
326 , a13 JTF_VARCHAR2_TABLE_100
327 , a14 JTF_NUMBER_TABLE
328 , a15 JTF_NUMBER_TABLE
329 , a16 JTF_VARCHAR2_TABLE_100
330 , a17 JTF_VARCHAR2_TABLE_300
331 , a18 JTF_NUMBER_TABLE
332 , a19 JTF_VARCHAR2_TABLE_300
333 , a20 JTF_DATE_TABLE
334 , a21 JTF_NUMBER_TABLE
335 , a22 JTF_VARCHAR2_TABLE_100
336 , a23 JTF_VARCHAR2_TABLE_100
337 , a24 JTF_VARCHAR2_TABLE_100
338 , a25 JTF_VARCHAR2_TABLE_2000
339 , a26 JTF_VARCHAR2_TABLE_100
340 , a27 JTF_VARCHAR2_TABLE_100
341 ) as
342 ddindx binary_integer; indx binary_integer;
343 begin
344 if a0 is not null and a0.count > 0 then
345 if a0.count > 0 then
346 indx := a0.first;
347 ddindx := 1;
348 while true loop
349 t(ddindx).event_seq := a0(indx);
350 t(ddindx).visit_id := a1(indx);
351 t(ddindx).visit_number := a2(indx);
352 t(ddindx).visit_type := a3(indx);
353 t(ddindx).visit_name := a4(indx);
354 t(ddindx).visit_status_code := a5(indx);
355 t(ddindx).visit_status := a6(indx);
356 t(ddindx).visit_org_id := a7(indx);
357 t(ddindx).visit_org_name := a8(indx);
358 t(ddindx).visit_dep_id := a9(indx);
359 t(ddindx).visit_dep_name := a10(indx);
360 t(ddindx).start_time := a11(indx);
361 t(ddindx).end_time := a12(indx);
362 t(ddindx).prev_event_type := a13(indx);
363 t(ddindx).prev_event_id := a14(indx);
364 t(ddindx).prev_event_org_id := a15(indx);
365 t(ddindx).is_prev_org_valid := a16(indx);
366 t(ddindx).prev_event_org_name := a17(indx);
367 t(ddindx).prev_event_dep_id := a18(indx);
368 t(ddindx).prve_event_dep_name := a19(indx);
369 t(ddindx).prev_event_end_time := a20(indx);
370 t(ddindx).prev_unit_schedule_id := a21(indx);
371 t(ddindx).prev_flight_number := a22(indx);
372 t(ddindx).has_mopportunity := a23(indx);
373 t(ddindx).has_conflict := a24(indx);
374 t(ddindx).conflict_message := a25(indx);
375 t(ddindx).can_cancel := a26(indx);
376 t(ddindx).is_org_valid := a27(indx);
377 ddindx := ddindx+1;
378 if a0.last =indx
379 then exit;
380 end if;
381 indx := a0.next(indx);
382 end loop;
383 end if;
384 end if;
385 end rosetta_table_copy_in_p8;
386 procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
387 , a1 out nocopy JTF_NUMBER_TABLE
388 , a2 out nocopy JTF_VARCHAR2_TABLE_100
389 , a3 out nocopy JTF_VARCHAR2_TABLE_100
390 , a4 out nocopy JTF_VARCHAR2_TABLE_100
391 , a5 out nocopy JTF_VARCHAR2_TABLE_100
392 , a6 out nocopy JTF_VARCHAR2_TABLE_100
393 , a7 out nocopy JTF_NUMBER_TABLE
394 , a8 out nocopy JTF_VARCHAR2_TABLE_300
395 , a9 out nocopy JTF_NUMBER_TABLE
396 , a10 out nocopy JTF_VARCHAR2_TABLE_300
397 , a11 out nocopy JTF_DATE_TABLE
398 , a12 out nocopy JTF_DATE_TABLE
399 , a13 out nocopy JTF_VARCHAR2_TABLE_100
400 , a14 out nocopy JTF_NUMBER_TABLE
401 , a15 out nocopy JTF_NUMBER_TABLE
402 , a16 out nocopy JTF_VARCHAR2_TABLE_100
403 , a17 out nocopy JTF_VARCHAR2_TABLE_300
404 , a18 out nocopy JTF_NUMBER_TABLE
405 , a19 out nocopy JTF_VARCHAR2_TABLE_300
406 , a20 out nocopy JTF_DATE_TABLE
407 , a21 out nocopy JTF_NUMBER_TABLE
408 , a22 out nocopy JTF_VARCHAR2_TABLE_100
409 , a23 out nocopy JTF_VARCHAR2_TABLE_100
410 , a24 out nocopy JTF_VARCHAR2_TABLE_100
411 , a25 out nocopy JTF_VARCHAR2_TABLE_2000
412 , a26 out nocopy JTF_VARCHAR2_TABLE_100
413 , a27 out nocopy JTF_VARCHAR2_TABLE_100
414 ) as
415 ddindx binary_integer; indx binary_integer;
416 begin
417 if t is null or t.count = 0 then
418 a0 := JTF_NUMBER_TABLE();
419 a1 := JTF_NUMBER_TABLE();
420 a2 := JTF_VARCHAR2_TABLE_100();
421 a3 := JTF_VARCHAR2_TABLE_100();
422 a4 := JTF_VARCHAR2_TABLE_100();
423 a5 := JTF_VARCHAR2_TABLE_100();
424 a6 := JTF_VARCHAR2_TABLE_100();
425 a7 := JTF_NUMBER_TABLE();
426 a8 := JTF_VARCHAR2_TABLE_300();
427 a9 := JTF_NUMBER_TABLE();
428 a10 := JTF_VARCHAR2_TABLE_300();
429 a11 := JTF_DATE_TABLE();
430 a12 := JTF_DATE_TABLE();
431 a13 := JTF_VARCHAR2_TABLE_100();
432 a14 := JTF_NUMBER_TABLE();
433 a15 := JTF_NUMBER_TABLE();
434 a16 := JTF_VARCHAR2_TABLE_100();
435 a17 := JTF_VARCHAR2_TABLE_300();
436 a18 := JTF_NUMBER_TABLE();
437 a19 := JTF_VARCHAR2_TABLE_300();
438 a20 := JTF_DATE_TABLE();
439 a21 := JTF_NUMBER_TABLE();
440 a22 := JTF_VARCHAR2_TABLE_100();
441 a23 := JTF_VARCHAR2_TABLE_100();
442 a24 := JTF_VARCHAR2_TABLE_100();
443 a25 := JTF_VARCHAR2_TABLE_2000();
444 a26 := JTF_VARCHAR2_TABLE_100();
445 a27 := JTF_VARCHAR2_TABLE_100();
446 else
447 a0 := JTF_NUMBER_TABLE();
448 a1 := JTF_NUMBER_TABLE();
449 a2 := JTF_VARCHAR2_TABLE_100();
450 a3 := JTF_VARCHAR2_TABLE_100();
451 a4 := JTF_VARCHAR2_TABLE_100();
452 a5 := JTF_VARCHAR2_TABLE_100();
453 a6 := JTF_VARCHAR2_TABLE_100();
454 a7 := JTF_NUMBER_TABLE();
455 a8 := JTF_VARCHAR2_TABLE_300();
456 a9 := JTF_NUMBER_TABLE();
457 a10 := JTF_VARCHAR2_TABLE_300();
458 a11 := JTF_DATE_TABLE();
459 a12 := JTF_DATE_TABLE();
460 a13 := JTF_VARCHAR2_TABLE_100();
461 a14 := JTF_NUMBER_TABLE();
462 a15 := JTF_NUMBER_TABLE();
463 a16 := JTF_VARCHAR2_TABLE_100();
464 a17 := JTF_VARCHAR2_TABLE_300();
465 a18 := JTF_NUMBER_TABLE();
466 a19 := JTF_VARCHAR2_TABLE_300();
467 a20 := JTF_DATE_TABLE();
468 a21 := JTF_NUMBER_TABLE();
469 a22 := JTF_VARCHAR2_TABLE_100();
470 a23 := JTF_VARCHAR2_TABLE_100();
471 a24 := JTF_VARCHAR2_TABLE_100();
472 a25 := JTF_VARCHAR2_TABLE_2000();
473 a26 := JTF_VARCHAR2_TABLE_100();
474 a27 := JTF_VARCHAR2_TABLE_100();
475 if t.count > 0 then
476 a0.extend(t.count);
477 a1.extend(t.count);
478 a2.extend(t.count);
479 a3.extend(t.count);
480 a4.extend(t.count);
481 a5.extend(t.count);
482 a6.extend(t.count);
483 a7.extend(t.count);
484 a8.extend(t.count);
485 a9.extend(t.count);
486 a10.extend(t.count);
487 a11.extend(t.count);
488 a12.extend(t.count);
489 a13.extend(t.count);
490 a14.extend(t.count);
491 a15.extend(t.count);
492 a16.extend(t.count);
493 a17.extend(t.count);
494 a18.extend(t.count);
495 a19.extend(t.count);
496 a20.extend(t.count);
497 a21.extend(t.count);
498 a22.extend(t.count);
499 a23.extend(t.count);
500 a24.extend(t.count);
501 a25.extend(t.count);
502 a26.extend(t.count);
503 a27.extend(t.count);
504 ddindx := t.first;
505 indx := 1;
506 while true loop
507 a0(indx) := t(ddindx).event_seq;
508 a1(indx) := t(ddindx).visit_id;
509 a2(indx) := t(ddindx).visit_number;
510 a3(indx) := t(ddindx).visit_type;
511 a4(indx) := t(ddindx).visit_name;
512 a5(indx) := t(ddindx).visit_status_code;
513 a6(indx) := t(ddindx).visit_status;
514 a7(indx) := t(ddindx).visit_org_id;
515 a8(indx) := t(ddindx).visit_org_name;
516 a9(indx) := t(ddindx).visit_dep_id;
517 a10(indx) := t(ddindx).visit_dep_name;
518 a11(indx) := t(ddindx).start_time;
519 a12(indx) := t(ddindx).end_time;
520 a13(indx) := t(ddindx).prev_event_type;
521 a14(indx) := t(ddindx).prev_event_id;
522 a15(indx) := t(ddindx).prev_event_org_id;
523 a16(indx) := t(ddindx).is_prev_org_valid;
524 a17(indx) := t(ddindx).prev_event_org_name;
525 a18(indx) := t(ddindx).prev_event_dep_id;
526 a19(indx) := t(ddindx).prve_event_dep_name;
527 a20(indx) := t(ddindx).prev_event_end_time;
528 a21(indx) := t(ddindx).prev_unit_schedule_id;
529 a22(indx) := t(ddindx).prev_flight_number;
530 a23(indx) := t(ddindx).has_mopportunity;
531 a24(indx) := t(ddindx).has_conflict;
532 a25(indx) := t(ddindx).conflict_message;
533 a26(indx) := t(ddindx).can_cancel;
534 a27(indx) := t(ddindx).is_org_valid;
535 indx := indx+1;
536 if t.last =ddindx
537 then exit;
538 end if;
539 ddindx := t.next(ddindx);
540 end loop;
541 end if;
542 end if;
543 end rosetta_table_copy_out_p8;
544
545 procedure search_unit_schedules(p_api_version NUMBER
546 , x_return_status out nocopy VARCHAR2
547 , x_msg_count out nocopy NUMBER
548 , x_msg_data out nocopy VARCHAR2
549 , p4_a0 VARCHAR2
550 , p4_a1 VARCHAR2
551 , p4_a2 VARCHAR2
552 , p4_a3 DATE
553 , p4_a4 NUMBER
554 , p4_a5 VARCHAR2
555 , p5_a0 out nocopy JTF_NUMBER_TABLE
556 , p5_a1 out nocopy JTF_NUMBER_TABLE
557 , p5_a2 out nocopy JTF_NUMBER_TABLE
558 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
559 , p5_a4 out nocopy JTF_NUMBER_TABLE
560 , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
561 )
562
563 as
564 ddp_unit_schedules_search ahl_ua_unit_schedules_pvt.unit_schedules_search_rec_type;
565 ddx_unit_schedules_results ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type;
566 ddindx binary_integer; indx binary_integer;
567 begin
568
569 -- copy data to the local IN or IN-OUT args, if any
570
571
572
573
574 ddp_unit_schedules_search.unit_name := p4_a0;
575 ddp_unit_schedules_search.item_number := p4_a1;
576 ddp_unit_schedules_search.serial_number := p4_a2;
577 ddp_unit_schedules_search.start_date_time := p4_a3;
578 ddp_unit_schedules_search.time_increment := p4_a4;
579 ddp_unit_schedules_search.time_uom := p4_a5;
580
581
582 -- here's the delegated call to the old PL/SQL routine
583 ahl_ua_unit_schedules_pvt.search_unit_schedules(p_api_version,
584 x_return_status,
585 x_msg_count,
586 x_msg_data,
587 ddp_unit_schedules_search,
588 ddx_unit_schedules_results);
589
590 -- copy data back from the local variables to OUT or IN-OUT args, if any
591
592
593
594
595
596 ahl_ua_unit_schedules_pvt_w.rosetta_table_copy_out_p3(ddx_unit_schedules_results, p5_a0
597 , p5_a1
598 , p5_a2
599 , p5_a3
600 , p5_a4
601 , p5_a5
602 );
603 end;
604
605 procedure get_mevent_details(p_api_version NUMBER
606 , p_module_type VARCHAR2
607 , x_return_status out nocopy VARCHAR2
608 , x_msg_count out nocopy NUMBER
609 , x_msg_data out nocopy VARCHAR2
610 , p5_a0 in out nocopy NUMBER
611 , p5_a1 in out nocopy VARCHAR2
612 , p5_a2 in out nocopy DATE
613 , p5_a3 in out nocopy DATE
614 , p5_a4 in out nocopy VARCHAR2
615 , p5_a5 in out nocopy VARCHAR2
616 , p5_a6 in out nocopy NUMBER
617 , p5_a7 in out nocopy VARCHAR2
618 , p5_a8 in out nocopy VARCHAR2
619 , p6_a0 out nocopy JTF_NUMBER_TABLE
620 , p6_a1 out nocopy JTF_NUMBER_TABLE
621 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
622 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
623 , p6_a4 out nocopy JTF_NUMBER_TABLE
624 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
625 , p6_a6 out nocopy JTF_NUMBER_TABLE
626 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
627 , p6_a8 out nocopy JTF_NUMBER_TABLE
628 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
629 , p6_a10 out nocopy JTF_NUMBER_TABLE
630 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
631 , p6_a12 out nocopy JTF_DATE_TABLE
632 , p6_a13 out nocopy JTF_DATE_TABLE
633 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
634 , p6_a15 out nocopy JTF_NUMBER_TABLE
635 , p6_a16 out nocopy JTF_NUMBER_TABLE
636 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
637 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
638 , p6_a19 out nocopy JTF_NUMBER_TABLE
639 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
640 , p6_a21 out nocopy JTF_DATE_TABLE
641 , p6_a22 out nocopy JTF_NUMBER_TABLE
642 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
643 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
644 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
645 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
646 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
647 , p7_a0 out nocopy JTF_NUMBER_TABLE
648 , p7_a1 out nocopy JTF_NUMBER_TABLE
649 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
650 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
651 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
652 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
653 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
654 , p7_a7 out nocopy JTF_NUMBER_TABLE
655 , p7_a8 out nocopy JTF_VARCHAR2_TABLE_300
656 , p7_a9 out nocopy JTF_NUMBER_TABLE
657 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_300
658 , p7_a11 out nocopy JTF_DATE_TABLE
659 , p7_a12 out nocopy JTF_DATE_TABLE
660 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
661 , p7_a14 out nocopy JTF_NUMBER_TABLE
662 , p7_a15 out nocopy JTF_NUMBER_TABLE
663 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
664 , p7_a17 out nocopy JTF_VARCHAR2_TABLE_300
665 , p7_a18 out nocopy JTF_NUMBER_TABLE
666 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300
667 , p7_a20 out nocopy JTF_DATE_TABLE
668 , p7_a21 out nocopy JTF_NUMBER_TABLE
669 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
670 , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
671 , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
672 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
673 , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
674 , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
675 )
676
677 as
678 ddp_x_mevent_header_rec ahl_ua_unit_schedules_pvt.mevent_header_rec_type;
679 ddx_unit_schedule_tbl ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type;
680 ddx_visit_schedule_tbl ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type;
681 ddindx binary_integer; indx binary_integer;
682 begin
683
684 -- copy data to the local IN or IN-OUT args, if any
685
686
687
688
689
690 ddp_x_mevent_header_rec.unit_config_header_id := p5_a0;
691 ddp_x_mevent_header_rec.unit_name := p5_a1;
692 ddp_x_mevent_header_rec.start_time := p5_a2;
693 ddp_x_mevent_header_rec.end_time := p5_a3;
694 ddp_x_mevent_header_rec.item_number := p5_a4;
695 ddp_x_mevent_header_rec.serial_number := p5_a5;
696 ddp_x_mevent_header_rec.event_count := p5_a6;
697 ddp_x_mevent_header_rec.has_conflict := p5_a7;
698 ddp_x_mevent_header_rec.has_mopportunity := p5_a8;
699
700
701
702 -- here's the delegated call to the old PL/SQL routine
703 ahl_ua_unit_schedules_pvt.get_mevent_details(p_api_version,
704 p_module_type,
705 x_return_status,
706 x_msg_count,
707 x_msg_data,
708 ddp_x_mevent_header_rec,
709 ddx_unit_schedule_tbl,
710 ddx_visit_schedule_tbl);
711
712 -- copy data back from the local variables to OUT or IN-OUT args, if any
713
714
715
716
717
718 p5_a0 := ddp_x_mevent_header_rec.unit_config_header_id;
719 p5_a1 := ddp_x_mevent_header_rec.unit_name;
720 p5_a2 := ddp_x_mevent_header_rec.start_time;
721 p5_a3 := ddp_x_mevent_header_rec.end_time;
722 p5_a4 := ddp_x_mevent_header_rec.item_number;
723 p5_a5 := ddp_x_mevent_header_rec.serial_number;
724 p5_a6 := ddp_x_mevent_header_rec.event_count;
725 p5_a7 := ddp_x_mevent_header_rec.has_conflict;
726 p5_a8 := ddp_x_mevent_header_rec.has_mopportunity;
727
728 ahl_ua_unit_schedules_pvt_w.rosetta_table_copy_out_p6(ddx_unit_schedule_tbl, p6_a0
729 , p6_a1
730 , p6_a2
731 , p6_a3
732 , p6_a4
733 , p6_a5
734 , p6_a6
735 , p6_a7
736 , p6_a8
737 , p6_a9
738 , p6_a10
739 , p6_a11
740 , p6_a12
741 , p6_a13
742 , p6_a14
743 , p6_a15
744 , p6_a16
745 , p6_a17
746 , p6_a18
747 , p6_a19
748 , p6_a20
749 , p6_a21
750 , p6_a22
751 , p6_a23
752 , p6_a24
753 , p6_a25
754 , p6_a26
755 , p6_a27
756 );
757
758 ahl_ua_unit_schedules_pvt_w.rosetta_table_copy_out_p8(ddx_visit_schedule_tbl, p7_a0
759 , p7_a1
760 , p7_a2
761 , p7_a3
762 , p7_a4
763 , p7_a5
764 , p7_a6
765 , p7_a7
766 , p7_a8
767 , p7_a9
768 , p7_a10
769 , p7_a11
770 , p7_a12
771 , p7_a13
772 , p7_a14
773 , p7_a15
774 , p7_a16
775 , p7_a17
776 , p7_a18
777 , p7_a19
778 , p7_a20
779 , p7_a21
780 , p7_a22
781 , p7_a23
782 , p7_a24
783 , p7_a25
784 , p7_a26
785 , p7_a27
786 );
787 end;
788
789 procedure get_prec_succ_event_info(p_api_version NUMBER
790 , x_return_status out nocopy VARCHAR2
791 , x_msg_count out nocopy NUMBER
792 , x_msg_data out nocopy VARCHAR2
793 , p_unit_config_id NUMBER
794 , p_start_date_time DATE
795 , p_end_date_time DATE
796 , p7_a0 out nocopy NUMBER
797 , p7_a1 out nocopy VARCHAR2
798 , p7_a2 out nocopy NUMBER
799 , p7_a3 out nocopy NUMBER
800 , p7_a4 out nocopy DATE
801 , p7_a5 out nocopy NUMBER
802 , p7_a6 out nocopy DATE
803 , p7_a7 out nocopy NUMBER
804 , p7_a8 out nocopy NUMBER
805 , p7_a9 out nocopy NUMBER
806 , p7_a10 out nocopy VARCHAR2
807 , p7_a11 out nocopy NUMBER
808 , p7_a12 out nocopy VARCHAR2
809 , p7_a13 out nocopy NUMBER
810 , p7_a14 out nocopy VARCHAR2
811 , p7_a15 out nocopy VARCHAR2
812 , p7_a16 out nocopy VARCHAR2
813 , p7_a17 out nocopy DATE
814 , p7_a18 out nocopy NUMBER
815 , p7_a19 out nocopy NUMBER
816 , p7_a20 out nocopy DATE
817 , p7_a21 out nocopy NUMBER
818 , p7_a22 out nocopy NUMBER
819 , p7_a23 out nocopy DATE
820 , p7_a24 out nocopy DATE
821 , p7_a25 out nocopy VARCHAR2
822 , p7_a26 out nocopy VARCHAR2
823 , p7_a27 out nocopy VARCHAR2
824 , p7_a28 out nocopy VARCHAR2
825 , p7_a29 out nocopy NUMBER
826 , p7_a30 out nocopy VARCHAR2
827 , p7_a31 out nocopy NUMBER
828 , p7_a32 out nocopy VARCHAR2
829 , p7_a33 out nocopy NUMBER
830 , p7_a34 out nocopy VARCHAR2
831 , p7_a35 out nocopy NUMBER
832 , p7_a36 out nocopy NUMBER
833 , p7_a37 out nocopy VARCHAR2
834 , p7_a38 out nocopy VARCHAR2
835 , p7_a39 out nocopy VARCHAR2
836 , p7_a40 out nocopy VARCHAR2
837 , p7_a41 out nocopy VARCHAR2
838 , p7_a42 out nocopy VARCHAR2
839 , p7_a43 out nocopy NUMBER
840 , p7_a44 out nocopy NUMBER
841 , p7_a45 out nocopy VARCHAR2
842 , p7_a46 out nocopy NUMBER
843 , p7_a47 out nocopy VARCHAR2
844 , p7_a48 out nocopy VARCHAR2
845 , p7_a49 out nocopy VARCHAR2
846 , p7_a50 out nocopy VARCHAR2
847 , p7_a51 out nocopy VARCHAR2
848 , p7_a52 out nocopy VARCHAR2
849 , p7_a53 out nocopy VARCHAR2
850 , p7_a54 out nocopy VARCHAR2
851 , p7_a55 out nocopy VARCHAR2
852 , p7_a56 out nocopy VARCHAR2
853 , p7_a57 out nocopy VARCHAR2
854 , p7_a58 out nocopy VARCHAR2
855 , p7_a59 out nocopy VARCHAR2
856 , p7_a60 out nocopy VARCHAR2
857 , p7_a61 out nocopy VARCHAR2
858 , p7_a62 out nocopy VARCHAR2
859 , p7_a63 out nocopy VARCHAR2
860 , p7_a64 out nocopy VARCHAR2
861 , p7_a65 out nocopy VARCHAR2
862 , p7_a66 out nocopy VARCHAR2
863 , p7_a67 out nocopy NUMBER
864 , p7_a68 out nocopy VARCHAR2
865 , p7_a69 out nocopy VARCHAR2
866 , p7_a70 out nocopy NUMBER
867 , p7_a71 out nocopy VARCHAR2
868 , p7_a72 out nocopy VARCHAR2
869 , p7_a73 out nocopy NUMBER
870 , p7_a74 out nocopy VARCHAR2
871 , p7_a75 out nocopy VARCHAR2
872 , p7_a76 out nocopy NUMBER
873 , p7_a77 out nocopy VARCHAR2
874 , p7_a78 out nocopy VARCHAR2
875 , p7_a79 out nocopy NUMBER
876 , p7_a80 out nocopy NUMBER
877 , p7_a81 out nocopy VARCHAR2
878 , p7_a82 out nocopy VARCHAR2
879 , p7_a83 out nocopy DATE
880 , p7_a84 out nocopy VARCHAR2
881 , p7_a85 out nocopy VARCHAR2
882 , p7_a86 out nocopy VARCHAR2
883 , p7_a87 out nocopy VARCHAR2
884 , p7_a88 out nocopy VARCHAR2
885 , p7_a89 out nocopy VARCHAR2
886 , p7_a90 out nocopy VARCHAR2
887 , p7_a91 out nocopy NUMBER
888 , p7_a92 out nocopy NUMBER
889 , p8_a0 out nocopy NUMBER
890 , p8_a1 out nocopy VARCHAR2
891 , p8_a2 out nocopy VARCHAR2
892 , p8_a3 out nocopy DATE
893 , p8_a4 out nocopy DATE
894 , p8_a5 out nocopy NUMBER
895 , p8_a6 out nocopy VARCHAR2
896 , p8_a7 out nocopy NUMBER
897 , p8_a8 out nocopy VARCHAR2
898 , p8_a9 out nocopy DATE
899 , p8_a10 out nocopy DATE
900 , p8_a11 out nocopy NUMBER
901 , p8_a12 out nocopy VARCHAR2
902 , p8_a13 out nocopy NUMBER
903 , p8_a14 out nocopy VARCHAR2
904 , p8_a15 out nocopy NUMBER
905 , p8_a16 out nocopy NUMBER
906 , p8_a17 out nocopy VARCHAR2
907 , p8_a18 out nocopy NUMBER
908 , p8_a19 out nocopy VARCHAR2
909 , p8_a20 out nocopy VARCHAR2
910 , p8_a21 out nocopy VARCHAR2
911 , p8_a22 out nocopy VARCHAR2
912 , p8_a23 out nocopy VARCHAR2
913 , p8_a24 out nocopy NUMBER
914 , p8_a25 out nocopy VARCHAR2
915 , p8_a26 out nocopy VARCHAR2
916 , p8_a27 out nocopy VARCHAR2
917 , p8_a28 out nocopy VARCHAR2
918 , p8_a29 out nocopy VARCHAR2
919 , p8_a30 out nocopy NUMBER
920 , p8_a31 out nocopy VARCHAR2
921 , p8_a32 out nocopy NUMBER
922 , p8_a33 out nocopy VARCHAR2
923 , p8_a34 out nocopy VARCHAR2
924 , p8_a35 out nocopy VARCHAR2
925 , p8_a36 out nocopy VARCHAR2
926 , p8_a37 out nocopy VARCHAR2
927 , p8_a38 out nocopy VARCHAR2
928 , p8_a39 out nocopy VARCHAR2
929 , p8_a40 out nocopy VARCHAR2
930 , p8_a41 out nocopy VARCHAR2
931 , p8_a42 out nocopy VARCHAR2
932 , p8_a43 out nocopy VARCHAR2
933 , p8_a44 out nocopy VARCHAR2
934 , p8_a45 out nocopy VARCHAR2
935 , p8_a46 out nocopy VARCHAR2
936 , p8_a47 out nocopy VARCHAR2
937 , p8_a48 out nocopy VARCHAR2
938 , p8_a49 out nocopy VARCHAR2
939 , p8_a50 out nocopy VARCHAR2
940 , x_is_prec_conflict out nocopy VARCHAR2
941 , x_is_prec_org_in_ou out nocopy VARCHAR2
942 , p11_a0 out nocopy NUMBER
943 , p11_a1 out nocopy VARCHAR2
944 , p11_a2 out nocopy NUMBER
945 , p11_a3 out nocopy NUMBER
946 , p11_a4 out nocopy DATE
947 , p11_a5 out nocopy NUMBER
948 , p11_a6 out nocopy DATE
949 , p11_a7 out nocopy NUMBER
950 , p11_a8 out nocopy NUMBER
951 , p11_a9 out nocopy NUMBER
952 , p11_a10 out nocopy VARCHAR2
953 , p11_a11 out nocopy NUMBER
954 , p11_a12 out nocopy VARCHAR2
955 , p11_a13 out nocopy NUMBER
956 , p11_a14 out nocopy VARCHAR2
957 , p11_a15 out nocopy VARCHAR2
958 , p11_a16 out nocopy VARCHAR2
959 , p11_a17 out nocopy DATE
960 , p11_a18 out nocopy NUMBER
961 , p11_a19 out nocopy NUMBER
962 , p11_a20 out nocopy DATE
963 , p11_a21 out nocopy NUMBER
964 , p11_a22 out nocopy NUMBER
965 , p11_a23 out nocopy DATE
966 , p11_a24 out nocopy DATE
967 , p11_a25 out nocopy VARCHAR2
968 , p11_a26 out nocopy VARCHAR2
969 , p11_a27 out nocopy VARCHAR2
970 , p11_a28 out nocopy VARCHAR2
971 , p11_a29 out nocopy NUMBER
972 , p11_a30 out nocopy VARCHAR2
973 , p11_a31 out nocopy NUMBER
974 , p11_a32 out nocopy VARCHAR2
975 , p11_a33 out nocopy NUMBER
976 , p11_a34 out nocopy VARCHAR2
977 , p11_a35 out nocopy NUMBER
978 , p11_a36 out nocopy NUMBER
979 , p11_a37 out nocopy VARCHAR2
980 , p11_a38 out nocopy VARCHAR2
981 , p11_a39 out nocopy VARCHAR2
982 , p11_a40 out nocopy VARCHAR2
983 , p11_a41 out nocopy VARCHAR2
984 , p11_a42 out nocopy VARCHAR2
985 , p11_a43 out nocopy NUMBER
986 , p11_a44 out nocopy NUMBER
987 , p11_a45 out nocopy VARCHAR2
988 , p11_a46 out nocopy NUMBER
989 , p11_a47 out nocopy VARCHAR2
990 , p11_a48 out nocopy VARCHAR2
991 , p11_a49 out nocopy VARCHAR2
992 , p11_a50 out nocopy VARCHAR2
993 , p11_a51 out nocopy VARCHAR2
994 , p11_a52 out nocopy VARCHAR2
995 , p11_a53 out nocopy VARCHAR2
996 , p11_a54 out nocopy VARCHAR2
997 , p11_a55 out nocopy VARCHAR2
998 , p11_a56 out nocopy VARCHAR2
999 , p11_a57 out nocopy VARCHAR2
1000 , p11_a58 out nocopy VARCHAR2
1001 , p11_a59 out nocopy VARCHAR2
1002 , p11_a60 out nocopy VARCHAR2
1003 , p11_a61 out nocopy VARCHAR2
1004 , p11_a62 out nocopy VARCHAR2
1005 , p11_a63 out nocopy VARCHAR2
1006 , p11_a64 out nocopy VARCHAR2
1007 , p11_a65 out nocopy VARCHAR2
1008 , p11_a66 out nocopy VARCHAR2
1009 , p11_a67 out nocopy NUMBER
1010 , p11_a68 out nocopy VARCHAR2
1011 , p11_a69 out nocopy VARCHAR2
1012 , p11_a70 out nocopy NUMBER
1013 , p11_a71 out nocopy VARCHAR2
1014 , p11_a72 out nocopy VARCHAR2
1015 , p11_a73 out nocopy NUMBER
1016 , p11_a74 out nocopy VARCHAR2
1017 , p11_a75 out nocopy VARCHAR2
1018 , p11_a76 out nocopy NUMBER
1019 , p11_a77 out nocopy VARCHAR2
1020 , p11_a78 out nocopy VARCHAR2
1021 , p11_a79 out nocopy NUMBER
1022 , p11_a80 out nocopy NUMBER
1023 , p11_a81 out nocopy VARCHAR2
1024 , p11_a82 out nocopy VARCHAR2
1025 , p11_a83 out nocopy DATE
1026 , p11_a84 out nocopy VARCHAR2
1027 , p11_a85 out nocopy VARCHAR2
1028 , p11_a86 out nocopy VARCHAR2
1029 , p11_a87 out nocopy VARCHAR2
1030 , p11_a88 out nocopy VARCHAR2
1031 , p11_a89 out nocopy VARCHAR2
1032 , p11_a90 out nocopy VARCHAR2
1033 , p11_a91 out nocopy NUMBER
1034 , p11_a92 out nocopy NUMBER
1035 , p12_a0 out nocopy NUMBER
1036 , p12_a1 out nocopy VARCHAR2
1037 , p12_a2 out nocopy VARCHAR2
1038 , p12_a3 out nocopy DATE
1039 , p12_a4 out nocopy DATE
1040 , p12_a5 out nocopy NUMBER
1041 , p12_a6 out nocopy VARCHAR2
1042 , p12_a7 out nocopy NUMBER
1043 , p12_a8 out nocopy VARCHAR2
1044 , p12_a9 out nocopy DATE
1045 , p12_a10 out nocopy DATE
1046 , p12_a11 out nocopy NUMBER
1047 , p12_a12 out nocopy VARCHAR2
1048 , p12_a13 out nocopy NUMBER
1049 , p12_a14 out nocopy VARCHAR2
1050 , p12_a15 out nocopy NUMBER
1051 , p12_a16 out nocopy NUMBER
1052 , p12_a17 out nocopy VARCHAR2
1053 , p12_a18 out nocopy NUMBER
1054 , p12_a19 out nocopy VARCHAR2
1055 , p12_a20 out nocopy VARCHAR2
1056 , p12_a21 out nocopy VARCHAR2
1057 , p12_a22 out nocopy VARCHAR2
1058 , p12_a23 out nocopy VARCHAR2
1059 , p12_a24 out nocopy NUMBER
1060 , p12_a25 out nocopy VARCHAR2
1061 , p12_a26 out nocopy VARCHAR2
1062 , p12_a27 out nocopy VARCHAR2
1063 , p12_a28 out nocopy VARCHAR2
1064 , p12_a29 out nocopy VARCHAR2
1065 , p12_a30 out nocopy NUMBER
1066 , p12_a31 out nocopy VARCHAR2
1067 , p12_a32 out nocopy NUMBER
1068 , p12_a33 out nocopy VARCHAR2
1069 , p12_a34 out nocopy VARCHAR2
1070 , p12_a35 out nocopy VARCHAR2
1071 , p12_a36 out nocopy VARCHAR2
1072 , p12_a37 out nocopy VARCHAR2
1073 , p12_a38 out nocopy VARCHAR2
1074 , p12_a39 out nocopy VARCHAR2
1075 , p12_a40 out nocopy VARCHAR2
1076 , p12_a41 out nocopy VARCHAR2
1077 , p12_a42 out nocopy VARCHAR2
1078 , p12_a43 out nocopy VARCHAR2
1079 , p12_a44 out nocopy VARCHAR2
1080 , p12_a45 out nocopy VARCHAR2
1081 , p12_a46 out nocopy VARCHAR2
1082 , p12_a47 out nocopy VARCHAR2
1083 , p12_a48 out nocopy VARCHAR2
1084 , p12_a49 out nocopy VARCHAR2
1085 , p12_a50 out nocopy VARCHAR2
1086 , x_is_succ_conflict out nocopy VARCHAR2
1087 , x_is_succ_org_in_ou out nocopy VARCHAR2
1088 )
1089
1090 as
1091 ddx_prec_visit ahl_vwp_visits_pvt.visit_rec_type;
1092 ddx_prec_flight_schedule ahl_ua_flight_schedules_pvt.flight_schedule_rec_type;
1093 ddx_succ_visit ahl_vwp_visits_pvt.visit_rec_type;
1094 ddx_succ_flight_schedule ahl_ua_flight_schedules_pvt.flight_schedule_rec_type;
1095 ddindx binary_integer; indx binary_integer;
1096 begin
1097
1098 -- copy data to the local IN or IN-OUT args, if any
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114 -- here's the delegated call to the old PL/SQL routine
1115 ahl_ua_unit_schedules_pvt.get_prec_succ_event_info(p_api_version,
1116 x_return_status,
1117 x_msg_count,
1118 x_msg_data,
1119 p_unit_config_id,
1120 p_start_date_time,
1121 p_end_date_time,
1122 ddx_prec_visit,
1123 ddx_prec_flight_schedule,
1124 x_is_prec_conflict,
1125 x_is_prec_org_in_ou,
1126 ddx_succ_visit,
1127 ddx_succ_flight_schedule,
1128 x_is_succ_conflict,
1129 x_is_succ_org_in_ou);
1130
1131 -- copy data back from the local variables to OUT or IN-OUT args, if any
1132
1133
1134
1135
1136
1137
1138
1139 p7_a0 := ddx_prec_visit.visit_id;
1140 p7_a1 := ddx_prec_visit.visit_name;
1141 p7_a2 := ddx_prec_visit.visit_number;
1142 p7_a3 := ddx_prec_visit.object_version_number;
1143 p7_a4 := ddx_prec_visit.last_update_date;
1144 p7_a5 := ddx_prec_visit.last_updated_by;
1145 p7_a6 := ddx_prec_visit.creation_date;
1146 p7_a7 := ddx_prec_visit.created_by;
1147 p7_a8 := ddx_prec_visit.last_update_login;
1148 p7_a9 := ddx_prec_visit.organization_id;
1149 p7_a10 := ddx_prec_visit.org_name;
1150 p7_a11 := ddx_prec_visit.department_id;
1151 p7_a12 := ddx_prec_visit.dept_name;
1152 p7_a13 := ddx_prec_visit.service_request_id;
1153 p7_a14 := ddx_prec_visit.service_request_number;
1154 p7_a15 := ddx_prec_visit.space_category_code;
1155 p7_a16 := ddx_prec_visit.space_category_name;
1156 p7_a17 := ddx_prec_visit.start_date;
1157 p7_a18 := ddx_prec_visit.start_hour;
1158 p7_a19 := ddx_prec_visit.start_min;
1159 p7_a20 := ddx_prec_visit.plan_end_date;
1160 p7_a21 := ddx_prec_visit.plan_end_hour;
1161 p7_a22 := ddx_prec_visit.plan_end_min;
1162 p7_a23 := ddx_prec_visit.end_date;
1163 p7_a24 := ddx_prec_visit.due_by_date;
1164 p7_a25 := ddx_prec_visit.visit_type_code;
1165 p7_a26 := ddx_prec_visit.visit_type_name;
1166 p7_a27 := ddx_prec_visit.status_code;
1167 p7_a28 := ddx_prec_visit.status_name;
1168 p7_a29 := ddx_prec_visit.simulation_plan_id;
1169 p7_a30 := ddx_prec_visit.simulation_plan_name;
1170 p7_a31 := ddx_prec_visit.asso_primary_visit_id;
1171 p7_a32 := ddx_prec_visit.unit_name;
1172 p7_a33 := ddx_prec_visit.item_instance_id;
1173 p7_a34 := ddx_prec_visit.serial_number;
1174 p7_a35 := ddx_prec_visit.inventory_item_id;
1175 p7_a36 := ddx_prec_visit.item_organization_id;
1176 p7_a37 := ddx_prec_visit.item_name;
1177 p7_a38 := ddx_prec_visit.simulation_delete_flag;
1178 p7_a39 := ddx_prec_visit.template_flag;
1179 p7_a40 := ddx_prec_visit.out_of_sync_flag;
1180 p7_a41 := ddx_prec_visit.project_flag;
1181 p7_a42 := ddx_prec_visit.project_flag_code;
1182 p7_a43 := ddx_prec_visit.project_id;
1183 p7_a44 := ddx_prec_visit.project_number;
1184 p7_a45 := ddx_prec_visit.description;
1185 p7_a46 := ddx_prec_visit.duration;
1186 p7_a47 := ddx_prec_visit.attribute_category;
1187 p7_a48 := ddx_prec_visit.attribute1;
1188 p7_a49 := ddx_prec_visit.attribute2;
1189 p7_a50 := ddx_prec_visit.attribute3;
1190 p7_a51 := ddx_prec_visit.attribute4;
1191 p7_a52 := ddx_prec_visit.attribute5;
1192 p7_a53 := ddx_prec_visit.attribute6;
1193 p7_a54 := ddx_prec_visit.attribute7;
1194 p7_a55 := ddx_prec_visit.attribute8;
1195 p7_a56 := ddx_prec_visit.attribute9;
1196 p7_a57 := ddx_prec_visit.attribute10;
1197 p7_a58 := ddx_prec_visit.attribute11;
1198 p7_a59 := ddx_prec_visit.attribute12;
1199 p7_a60 := ddx_prec_visit.attribute13;
1200 p7_a61 := ddx_prec_visit.attribute14;
1201 p7_a62 := ddx_prec_visit.attribute15;
1202 p7_a63 := ddx_prec_visit.operation_flag;
1203 p7_a64 := ddx_prec_visit.outside_party_flag;
1204 p7_a65 := ddx_prec_visit.job_number;
1205 p7_a66 := ddx_prec_visit.proj_template_name;
1206 p7_a67 := ddx_prec_visit.proj_template_id;
1207 p7_a68 := ddx_prec_visit.priority_value;
1208 p7_a69 := ddx_prec_visit.priority_code;
1209 p7_a70 := ddx_prec_visit.unit_schedule_id;
1210 p7_a71 := ddx_prec_visit.visit_create_type;
1211 p7_a72 := ddx_prec_visit.visit_create_meaning;
1212 p7_a73 := ddx_prec_visit.unit_header_id;
1213 p7_a74 := ddx_prec_visit.flight_number;
1214 p7_a75 := ddx_prec_visit.project_name;
1215 p7_a76 := ddx_prec_visit.top_project_task_id;
1216 p7_a77 := ddx_prec_visit.subinventory;
1217 p7_a78 := ddx_prec_visit.locator_segment;
1218 p7_a79 := ddx_prec_visit.inv_locator_id;
1219 p7_a80 := ddx_prec_visit.cp_request_id;
1220 p7_a81 := ddx_prec_visit.cp_phase_code;
1221 p7_a82 := ddx_prec_visit.cp_status_code;
1222 p7_a83 := ddx_prec_visit.cp_request_date;
1223 p7_a84 := ddx_prec_visit.jc_exist;
1224 p7_a85 := ddx_prec_visit.view_jc_url;
1225 p7_a86 := ddx_prec_visit.jc_gen_status;
1226 p7_a87 := ddx_prec_visit.jc_gen_error_text;
1227 p7_a88 := ddx_prec_visit.past_dated_visit_flag;
1228 p7_a89 := ddx_prec_visit.locked_flag;
1229 p7_a90 := ddx_prec_visit.firmed_flag;
1230 p7_a91 := ddx_prec_visit.tasks_ovn_updated_count;
1231 p7_a92 := ddx_prec_visit.stages_ovn_updated_count;
1232
1233 p8_a0 := ddx_prec_flight_schedule.unit_schedule_id;
1234 p8_a1 := ddx_prec_flight_schedule.flight_number;
1235 p8_a2 := ddx_prec_flight_schedule.segment;
1236 p8_a3 := ddx_prec_flight_schedule.est_departure_time;
1237 p8_a4 := ddx_prec_flight_schedule.actual_departure_time;
1238 p8_a5 := ddx_prec_flight_schedule.departure_dept_id;
1239 p8_a6 := ddx_prec_flight_schedule.departure_dept_code;
1240 p8_a7 := ddx_prec_flight_schedule.departure_org_id;
1241 p8_a8 := ddx_prec_flight_schedule.departure_org_code;
1242 p8_a9 := ddx_prec_flight_schedule.est_arrival_time;
1243 p8_a10 := ddx_prec_flight_schedule.actual_arrival_time;
1244 p8_a11 := ddx_prec_flight_schedule.arrival_dept_id;
1245 p8_a12 := ddx_prec_flight_schedule.arrival_dept_code;
1246 p8_a13 := ddx_prec_flight_schedule.arrival_org_id;
1247 p8_a14 := ddx_prec_flight_schedule.arrival_org_code;
1248 p8_a15 := ddx_prec_flight_schedule.preceding_us_id;
1249 p8_a16 := ddx_prec_flight_schedule.unit_config_header_id;
1250 p8_a17 := ddx_prec_flight_schedule.unit_config_name;
1251 p8_a18 := ddx_prec_flight_schedule.csi_instance_id;
1252 p8_a19 := ddx_prec_flight_schedule.instance_number;
1253 p8_a20 := ddx_prec_flight_schedule.item_number;
1254 p8_a21 := ddx_prec_flight_schedule.serial_number;
1255 p8_a22 := ddx_prec_flight_schedule.visit_reschedule_mode;
1256 p8_a23 := ddx_prec_flight_schedule.visit_reschedule_meaning;
1257 p8_a24 := ddx_prec_flight_schedule.object_version_number;
1258 p8_a25 := ddx_prec_flight_schedule.is_update_allowed;
1259 p8_a26 := ddx_prec_flight_schedule.is_delete_allowed;
1260 p8_a27 := ddx_prec_flight_schedule.conflict_message;
1261 p8_a28 := ddx_prec_flight_schedule.flight_category_code;
1262 p8_a29 := ddx_prec_flight_schedule.flight_category_meaning;
1263 p8_a30 := ddx_prec_flight_schedule.departure_space_id;
1264 p8_a31 := ddx_prec_flight_schedule.departure_space_name;
1265 p8_a32 := ddx_prec_flight_schedule.arrival_space_id;
1266 p8_a33 := ddx_prec_flight_schedule.arrival_space_name;
1267 p8_a34 := ddx_prec_flight_schedule.attribute_category;
1268 p8_a35 := ddx_prec_flight_schedule.attribute1;
1269 p8_a36 := ddx_prec_flight_schedule.attribute2;
1270 p8_a37 := ddx_prec_flight_schedule.attribute3;
1271 p8_a38 := ddx_prec_flight_schedule.attribute4;
1272 p8_a39 := ddx_prec_flight_schedule.attribute5;
1273 p8_a40 := ddx_prec_flight_schedule.attribute6;
1274 p8_a41 := ddx_prec_flight_schedule.attribute7;
1275 p8_a42 := ddx_prec_flight_schedule.attribute8;
1276 p8_a43 := ddx_prec_flight_schedule.attribute9;
1277 p8_a44 := ddx_prec_flight_schedule.attribute10;
1278 p8_a45 := ddx_prec_flight_schedule.attribute11;
1279 p8_a46 := ddx_prec_flight_schedule.attribute12;
1280 p8_a47 := ddx_prec_flight_schedule.attribute13;
1281 p8_a48 := ddx_prec_flight_schedule.attribute14;
1282 p8_a49 := ddx_prec_flight_schedule.attribute15;
1283 p8_a50 := ddx_prec_flight_schedule.dml_operation;
1284
1285
1286
1287 p11_a0 := ddx_succ_visit.visit_id;
1288 p11_a1 := ddx_succ_visit.visit_name;
1289 p11_a2 := ddx_succ_visit.visit_number;
1290 p11_a3 := ddx_succ_visit.object_version_number;
1291 p11_a4 := ddx_succ_visit.last_update_date;
1292 p11_a5 := ddx_succ_visit.last_updated_by;
1293 p11_a6 := ddx_succ_visit.creation_date;
1294 p11_a7 := ddx_succ_visit.created_by;
1295 p11_a8 := ddx_succ_visit.last_update_login;
1296 p11_a9 := ddx_succ_visit.organization_id;
1297 p11_a10 := ddx_succ_visit.org_name;
1298 p11_a11 := ddx_succ_visit.department_id;
1299 p11_a12 := ddx_succ_visit.dept_name;
1300 p11_a13 := ddx_succ_visit.service_request_id;
1301 p11_a14 := ddx_succ_visit.service_request_number;
1302 p11_a15 := ddx_succ_visit.space_category_code;
1303 p11_a16 := ddx_succ_visit.space_category_name;
1304 p11_a17 := ddx_succ_visit.start_date;
1305 p11_a18 := ddx_succ_visit.start_hour;
1306 p11_a19 := ddx_succ_visit.start_min;
1307 p11_a20 := ddx_succ_visit.plan_end_date;
1308 p11_a21 := ddx_succ_visit.plan_end_hour;
1309 p11_a22 := ddx_succ_visit.plan_end_min;
1310 p11_a23 := ddx_succ_visit.end_date;
1311 p11_a24 := ddx_succ_visit.due_by_date;
1312 p11_a25 := ddx_succ_visit.visit_type_code;
1313 p11_a26 := ddx_succ_visit.visit_type_name;
1314 p11_a27 := ddx_succ_visit.status_code;
1315 p11_a28 := ddx_succ_visit.status_name;
1316 p11_a29 := ddx_succ_visit.simulation_plan_id;
1317 p11_a30 := ddx_succ_visit.simulation_plan_name;
1318 p11_a31 := ddx_succ_visit.asso_primary_visit_id;
1319 p11_a32 := ddx_succ_visit.unit_name;
1320 p11_a33 := ddx_succ_visit.item_instance_id;
1321 p11_a34 := ddx_succ_visit.serial_number;
1322 p11_a35 := ddx_succ_visit.inventory_item_id;
1323 p11_a36 := ddx_succ_visit.item_organization_id;
1324 p11_a37 := ddx_succ_visit.item_name;
1325 p11_a38 := ddx_succ_visit.simulation_delete_flag;
1326 p11_a39 := ddx_succ_visit.template_flag;
1327 p11_a40 := ddx_succ_visit.out_of_sync_flag;
1328 p11_a41 := ddx_succ_visit.project_flag;
1329 p11_a42 := ddx_succ_visit.project_flag_code;
1330 p11_a43 := ddx_succ_visit.project_id;
1331 p11_a44 := ddx_succ_visit.project_number;
1332 p11_a45 := ddx_succ_visit.description;
1333 p11_a46 := ddx_succ_visit.duration;
1334 p11_a47 := ddx_succ_visit.attribute_category;
1335 p11_a48 := ddx_succ_visit.attribute1;
1336 p11_a49 := ddx_succ_visit.attribute2;
1337 p11_a50 := ddx_succ_visit.attribute3;
1338 p11_a51 := ddx_succ_visit.attribute4;
1339 p11_a52 := ddx_succ_visit.attribute5;
1340 p11_a53 := ddx_succ_visit.attribute6;
1341 p11_a54 := ddx_succ_visit.attribute7;
1342 p11_a55 := ddx_succ_visit.attribute8;
1343 p11_a56 := ddx_succ_visit.attribute9;
1344 p11_a57 := ddx_succ_visit.attribute10;
1345 p11_a58 := ddx_succ_visit.attribute11;
1346 p11_a59 := ddx_succ_visit.attribute12;
1347 p11_a60 := ddx_succ_visit.attribute13;
1348 p11_a61 := ddx_succ_visit.attribute14;
1349 p11_a62 := ddx_succ_visit.attribute15;
1350 p11_a63 := ddx_succ_visit.operation_flag;
1351 p11_a64 := ddx_succ_visit.outside_party_flag;
1352 p11_a65 := ddx_succ_visit.job_number;
1353 p11_a66 := ddx_succ_visit.proj_template_name;
1354 p11_a67 := ddx_succ_visit.proj_template_id;
1355 p11_a68 := ddx_succ_visit.priority_value;
1356 p11_a69 := ddx_succ_visit.priority_code;
1357 p11_a70 := ddx_succ_visit.unit_schedule_id;
1358 p11_a71 := ddx_succ_visit.visit_create_type;
1359 p11_a72 := ddx_succ_visit.visit_create_meaning;
1360 p11_a73 := ddx_succ_visit.unit_header_id;
1361 p11_a74 := ddx_succ_visit.flight_number;
1362 p11_a75 := ddx_succ_visit.project_name;
1363 p11_a76 := ddx_succ_visit.top_project_task_id;
1364 p11_a77 := ddx_succ_visit.subinventory;
1365 p11_a78 := ddx_succ_visit.locator_segment;
1366 p11_a79 := ddx_succ_visit.inv_locator_id;
1367 p11_a80 := ddx_succ_visit.cp_request_id;
1368 p11_a81 := ddx_succ_visit.cp_phase_code;
1369 p11_a82 := ddx_succ_visit.cp_status_code;
1370 p11_a83 := ddx_succ_visit.cp_request_date;
1371 p11_a84 := ddx_succ_visit.jc_exist;
1372 p11_a85 := ddx_succ_visit.view_jc_url;
1373 p11_a86 := ddx_succ_visit.jc_gen_status;
1374 p11_a87 := ddx_succ_visit.jc_gen_error_text;
1375 p11_a88 := ddx_succ_visit.past_dated_visit_flag;
1376 p11_a89 := ddx_succ_visit.locked_flag;
1377 p11_a90 := ddx_succ_visit.firmed_flag;
1378 p11_a91 := ddx_succ_visit.tasks_ovn_updated_count;
1379 p11_a92 := ddx_succ_visit.stages_ovn_updated_count;
1380
1381 p12_a0 := ddx_succ_flight_schedule.unit_schedule_id;
1382 p12_a1 := ddx_succ_flight_schedule.flight_number;
1383 p12_a2 := ddx_succ_flight_schedule.segment;
1384 p12_a3 := ddx_succ_flight_schedule.est_departure_time;
1385 p12_a4 := ddx_succ_flight_schedule.actual_departure_time;
1386 p12_a5 := ddx_succ_flight_schedule.departure_dept_id;
1387 p12_a6 := ddx_succ_flight_schedule.departure_dept_code;
1388 p12_a7 := ddx_succ_flight_schedule.departure_org_id;
1389 p12_a8 := ddx_succ_flight_schedule.departure_org_code;
1390 p12_a9 := ddx_succ_flight_schedule.est_arrival_time;
1391 p12_a10 := ddx_succ_flight_schedule.actual_arrival_time;
1392 p12_a11 := ddx_succ_flight_schedule.arrival_dept_id;
1393 p12_a12 := ddx_succ_flight_schedule.arrival_dept_code;
1394 p12_a13 := ddx_succ_flight_schedule.arrival_org_id;
1395 p12_a14 := ddx_succ_flight_schedule.arrival_org_code;
1396 p12_a15 := ddx_succ_flight_schedule.preceding_us_id;
1397 p12_a16 := ddx_succ_flight_schedule.unit_config_header_id;
1398 p12_a17 := ddx_succ_flight_schedule.unit_config_name;
1399 p12_a18 := ddx_succ_flight_schedule.csi_instance_id;
1400 p12_a19 := ddx_succ_flight_schedule.instance_number;
1401 p12_a20 := ddx_succ_flight_schedule.item_number;
1402 p12_a21 := ddx_succ_flight_schedule.serial_number;
1403 p12_a22 := ddx_succ_flight_schedule.visit_reschedule_mode;
1404 p12_a23 := ddx_succ_flight_schedule.visit_reschedule_meaning;
1405 p12_a24 := ddx_succ_flight_schedule.object_version_number;
1406 p12_a25 := ddx_succ_flight_schedule.is_update_allowed;
1407 p12_a26 := ddx_succ_flight_schedule.is_delete_allowed;
1408 p12_a27 := ddx_succ_flight_schedule.conflict_message;
1409 p12_a28 := ddx_succ_flight_schedule.flight_category_code;
1410 p12_a29 := ddx_succ_flight_schedule.flight_category_meaning;
1411 p12_a30 := ddx_succ_flight_schedule.departure_space_id;
1412 p12_a31 := ddx_succ_flight_schedule.departure_space_name;
1413 p12_a32 := ddx_succ_flight_schedule.arrival_space_id;
1414 p12_a33 := ddx_succ_flight_schedule.arrival_space_name;
1415 p12_a34 := ddx_succ_flight_schedule.attribute_category;
1416 p12_a35 := ddx_succ_flight_schedule.attribute1;
1417 p12_a36 := ddx_succ_flight_schedule.attribute2;
1418 p12_a37 := ddx_succ_flight_schedule.attribute3;
1419 p12_a38 := ddx_succ_flight_schedule.attribute4;
1420 p12_a39 := ddx_succ_flight_schedule.attribute5;
1421 p12_a40 := ddx_succ_flight_schedule.attribute6;
1422 p12_a41 := ddx_succ_flight_schedule.attribute7;
1423 p12_a42 := ddx_succ_flight_schedule.attribute8;
1424 p12_a43 := ddx_succ_flight_schedule.attribute9;
1425 p12_a44 := ddx_succ_flight_schedule.attribute10;
1426 p12_a45 := ddx_succ_flight_schedule.attribute11;
1427 p12_a46 := ddx_succ_flight_schedule.attribute12;
1428 p12_a47 := ddx_succ_flight_schedule.attribute13;
1429 p12_a48 := ddx_succ_flight_schedule.attribute14;
1430 p12_a49 := ddx_succ_flight_schedule.attribute15;
1431 p12_a50 := ddx_succ_flight_schedule.dml_operation;
1432
1433
1434 end;
1435
1436 end ahl_ua_unit_schedules_pvt_w;