[Home] [Help]
PACKAGE BODY: APPS.AHL_VWP_VISITS_PVT_W
Source
1 package body ahl_vwp_visits_pvt_w as
2 /* $Header: AHLWVSTB.pls 120.5.12020000.2 2012/12/11 05:59:40 prakkum ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_VARCHAR2_TABLE_300
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_300
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_DATE_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_DATE_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_DATE_TABLE
27 , a24 JTF_DATE_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
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_VARCHAR2_TABLE_100
38 , a35 JTF_NUMBER_TABLE
39 , a36 JTF_NUMBER_TABLE
40 , a37 JTF_VARCHAR2_TABLE_100
41 , a38 JTF_VARCHAR2_TABLE_100
42 , a39 JTF_VARCHAR2_TABLE_100
43 , a40 JTF_VARCHAR2_TABLE_100
44 , a41 JTF_VARCHAR2_TABLE_100
45 , a42 JTF_VARCHAR2_TABLE_100
46 , a43 JTF_NUMBER_TABLE
47 , a44 JTF_NUMBER_TABLE
48 , a45 JTF_VARCHAR2_TABLE_4000
49 , a46 JTF_NUMBER_TABLE
50 , a47 JTF_VARCHAR2_TABLE_100
51 , a48 JTF_VARCHAR2_TABLE_200
52 , a49 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_200
58 , a55 JTF_VARCHAR2_TABLE_200
59 , a56 JTF_VARCHAR2_TABLE_200
60 , a57 JTF_VARCHAR2_TABLE_200
61 , a58 JTF_VARCHAR2_TABLE_200
62 , a59 JTF_VARCHAR2_TABLE_200
63 , a60 JTF_VARCHAR2_TABLE_200
64 , a61 JTF_VARCHAR2_TABLE_200
65 , a62 JTF_VARCHAR2_TABLE_200
66 , a63 JTF_VARCHAR2_TABLE_100
67 , a64 JTF_VARCHAR2_TABLE_100
68 , a65 JTF_VARCHAR2_TABLE_300
69 , a66 JTF_VARCHAR2_TABLE_100
70 , a67 JTF_NUMBER_TABLE
71 , a68 JTF_VARCHAR2_TABLE_100
72 , a69 JTF_VARCHAR2_TABLE_100
73 , a70 JTF_NUMBER_TABLE
74 , a71 JTF_VARCHAR2_TABLE_100
75 , a72 JTF_VARCHAR2_TABLE_100
76 , a73 JTF_NUMBER_TABLE
77 , a74 JTF_VARCHAR2_TABLE_100
78 , a75 JTF_VARCHAR2_TABLE_100
79 , a76 JTF_NUMBER_TABLE
80 , a77 JTF_VARCHAR2_TABLE_100
81 , a78 JTF_VARCHAR2_TABLE_300
82 , a79 JTF_NUMBER_TABLE
83 , a80 JTF_NUMBER_TABLE
84 , a81 JTF_VARCHAR2_TABLE_100
85 , a82 JTF_VARCHAR2_TABLE_100
86 , a83 JTF_DATE_TABLE
87 , a84 JTF_VARCHAR2_TABLE_100
88 , a85 JTF_VARCHAR2_TABLE_2000
89 , a86 JTF_VARCHAR2_TABLE_100
90 , a87 JTF_VARCHAR2_TABLE_4000
91 , a88 JTF_VARCHAR2_TABLE_100
92 , a89 JTF_VARCHAR2_TABLE_100
93 , a90 JTF_VARCHAR2_TABLE_100
94 , a91 JTF_NUMBER_TABLE
95 , a92 JTF_NUMBER_TABLE
96 , a93 JTF_VARCHAR2_TABLE_100
97 , a94 JTF_VARCHAR2_TABLE_300
98 , a95 JTF_NUMBER_TABLE
99 , a96 JTF_VARCHAR2_TABLE_100
100 , a97 JTF_VARCHAR2_TABLE_300
101 , a98 JTF_NUMBER_TABLE
102 , a99 JTF_VARCHAR2_TABLE_100
103 , a100 JTF_VARCHAR2_TABLE_100
104 ) as
105 ddindx binary_integer; indx binary_integer;
106 begin
107 if a0 is not null and a0.count > 0 then
108 if a0.count > 0 then
109 indx := a0.first;
110 ddindx := 1;
111 while true loop
112 t(ddindx).visit_id := a0(indx);
113 t(ddindx).visit_name := a1(indx);
114 t(ddindx).visit_number := a2(indx);
115 t(ddindx).object_version_number := a3(indx);
116 t(ddindx).last_update_date := a4(indx);
117 t(ddindx).last_updated_by := a5(indx);
118 t(ddindx).creation_date := a6(indx);
119 t(ddindx).created_by := a7(indx);
120 t(ddindx).last_update_login := a8(indx);
121 t(ddindx).organization_id := a9(indx);
122 t(ddindx).org_name := a10(indx);
123 t(ddindx).department_id := a11(indx);
124 t(ddindx).dept_name := a12(indx);
125 t(ddindx).service_request_id := a13(indx);
126 t(ddindx).service_request_number := a14(indx);
127 t(ddindx).space_category_code := a15(indx);
128 t(ddindx).space_category_name := a16(indx);
129 t(ddindx).start_date := a17(indx);
130 t(ddindx).start_hour := a18(indx);
131 t(ddindx).start_min := a19(indx);
132 t(ddindx).plan_end_date := a20(indx);
133 t(ddindx).plan_end_hour := a21(indx);
134 t(ddindx).plan_end_min := a22(indx);
135 t(ddindx).end_date := a23(indx);
136 t(ddindx).due_by_date := a24(indx);
137 t(ddindx).visit_type_code := a25(indx);
138 t(ddindx).visit_type_name := a26(indx);
139 t(ddindx).status_code := a27(indx);
140 t(ddindx).status_name := a28(indx);
141 t(ddindx).simulation_plan_id := a29(indx);
142 t(ddindx).simulation_plan_name := a30(indx);
143 t(ddindx).asso_primary_visit_id := a31(indx);
144 t(ddindx).unit_name := a32(indx);
145 t(ddindx).item_instance_id := a33(indx);
146 t(ddindx).serial_number := a34(indx);
147 t(ddindx).inventory_item_id := a35(indx);
148 t(ddindx).item_organization_id := a36(indx);
149 t(ddindx).item_name := a37(indx);
150 t(ddindx).simulation_delete_flag := a38(indx);
151 t(ddindx).template_flag := a39(indx);
152 t(ddindx).out_of_sync_flag := a40(indx);
153 t(ddindx).project_flag := a41(indx);
154 t(ddindx).project_flag_code := a42(indx);
155 t(ddindx).project_id := a43(indx);
156 t(ddindx).project_number := a44(indx);
157 t(ddindx).description := a45(indx);
158 t(ddindx).duration := a46(indx);
159 t(ddindx).attribute_category := a47(indx);
160 t(ddindx).attribute1 := a48(indx);
161 t(ddindx).attribute2 := a49(indx);
162 t(ddindx).attribute3 := a50(indx);
163 t(ddindx).attribute4 := a51(indx);
164 t(ddindx).attribute5 := a52(indx);
165 t(ddindx).attribute6 := a53(indx);
166 t(ddindx).attribute7 := a54(indx);
167 t(ddindx).attribute8 := a55(indx);
168 t(ddindx).attribute9 := a56(indx);
169 t(ddindx).attribute10 := a57(indx);
170 t(ddindx).attribute11 := a58(indx);
171 t(ddindx).attribute12 := a59(indx);
172 t(ddindx).attribute13 := a60(indx);
173 t(ddindx).attribute14 := a61(indx);
174 t(ddindx).attribute15 := a62(indx);
175 t(ddindx).operation_flag := a63(indx);
176 t(ddindx).outside_party_flag := a64(indx);
177 t(ddindx).job_number := a65(indx);
178 t(ddindx).proj_template_name := a66(indx);
179 t(ddindx).proj_template_id := a67(indx);
180 t(ddindx).priority_value := a68(indx);
181 t(ddindx).priority_code := a69(indx);
182 t(ddindx).unit_schedule_id := a70(indx);
183 t(ddindx).visit_create_type := a71(indx);
184 t(ddindx).visit_create_meaning := a72(indx);
185 t(ddindx).unit_header_id := a73(indx);
186 t(ddindx).flight_number := a74(indx);
187 t(ddindx).project_name := a75(indx);
188 t(ddindx).top_project_task_id := a76(indx);
189 t(ddindx).subinventory := a77(indx);
190 t(ddindx).locator_segment := a78(indx);
191 t(ddindx).inv_locator_id := a79(indx);
192 t(ddindx).cp_request_id := a80(indx);
193 t(ddindx).cp_phase_code := a81(indx);
194 t(ddindx).cp_status_code := a82(indx);
195 t(ddindx).cp_request_date := a83(indx);
196 t(ddindx).jc_exist := a84(indx);
197 t(ddindx).view_jc_url := a85(indx);
198 t(ddindx).jc_gen_status := a86(indx);
199 t(ddindx).jc_gen_error_text := a87(indx);
200 t(ddindx).past_dated_visit_flag := a88(indx);
201 t(ddindx).locked_flag := a89(indx);
202 t(ddindx).firmed_flag := a90(indx);
203 t(ddindx).tasks_ovn_updated_count := a91(indx);
204 t(ddindx).stages_ovn_updated_count := a92(indx);
205 t(ddindx).comp_planning_subinv := a93(indx);
206 t(ddindx).comp_planning_loc_seg := a94(indx);
207 t(ddindx).comp_planning_loc_id := a95(indx);
208 t(ddindx).comp_inrepair_subinv := a96(indx);
209 t(ddindx).comp_inrepair_loc_seg := a97(indx);
210 t(ddindx).comp_inrepair_loc_id := a98(indx);
211 t(ddindx).item_owner_flag := a99(indx);
212 t(ddindx).auto_visit_type_flag := a100(indx);
213 ddindx := ddindx+1;
214 if a0.last =indx
215 then exit;
216 end if;
217 indx := a0.next(indx);
218 end loop;
219 end if;
220 end if;
221 end rosetta_table_copy_in_p3;
222 procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
223 , a1 out nocopy JTF_VARCHAR2_TABLE_100
224 , a2 out nocopy JTF_NUMBER_TABLE
225 , a3 out nocopy JTF_NUMBER_TABLE
226 , a4 out nocopy JTF_DATE_TABLE
227 , a5 out nocopy JTF_NUMBER_TABLE
228 , a6 out nocopy JTF_DATE_TABLE
229 , a7 out nocopy JTF_NUMBER_TABLE
230 , a8 out nocopy JTF_NUMBER_TABLE
231 , a9 out nocopy JTF_NUMBER_TABLE
232 , a10 out nocopy JTF_VARCHAR2_TABLE_300
233 , a11 out nocopy JTF_NUMBER_TABLE
234 , a12 out nocopy JTF_VARCHAR2_TABLE_300
235 , a13 out nocopy JTF_NUMBER_TABLE
236 , a14 out nocopy JTF_VARCHAR2_TABLE_100
237 , a15 out nocopy JTF_VARCHAR2_TABLE_100
238 , a16 out nocopy JTF_VARCHAR2_TABLE_100
239 , a17 out nocopy JTF_DATE_TABLE
240 , a18 out nocopy JTF_NUMBER_TABLE
241 , a19 out nocopy JTF_NUMBER_TABLE
242 , a20 out nocopy JTF_DATE_TABLE
243 , a21 out nocopy JTF_NUMBER_TABLE
244 , a22 out nocopy JTF_NUMBER_TABLE
245 , a23 out nocopy JTF_DATE_TABLE
246 , a24 out nocopy JTF_DATE_TABLE
247 , a25 out nocopy JTF_VARCHAR2_TABLE_100
248 , a26 out nocopy JTF_VARCHAR2_TABLE_100
249 , a27 out nocopy JTF_VARCHAR2_TABLE_100
250 , a28 out nocopy JTF_VARCHAR2_TABLE_100
251 , a29 out nocopy JTF_NUMBER_TABLE
252 , a30 out nocopy JTF_VARCHAR2_TABLE_100
253 , a31 out nocopy JTF_NUMBER_TABLE
254 , a32 out nocopy JTF_VARCHAR2_TABLE_100
255 , a33 out nocopy JTF_NUMBER_TABLE
256 , a34 out nocopy JTF_VARCHAR2_TABLE_100
257 , a35 out nocopy JTF_NUMBER_TABLE
258 , a36 out nocopy JTF_NUMBER_TABLE
259 , a37 out nocopy JTF_VARCHAR2_TABLE_100
260 , a38 out nocopy JTF_VARCHAR2_TABLE_100
261 , a39 out nocopy JTF_VARCHAR2_TABLE_100
262 , a40 out nocopy JTF_VARCHAR2_TABLE_100
263 , a41 out nocopy JTF_VARCHAR2_TABLE_100
264 , a42 out nocopy JTF_VARCHAR2_TABLE_100
265 , a43 out nocopy JTF_NUMBER_TABLE
266 , a44 out nocopy JTF_NUMBER_TABLE
267 , a45 out nocopy JTF_VARCHAR2_TABLE_4000
268 , a46 out nocopy JTF_NUMBER_TABLE
269 , a47 out nocopy JTF_VARCHAR2_TABLE_100
270 , a48 out nocopy JTF_VARCHAR2_TABLE_200
271 , a49 out nocopy JTF_VARCHAR2_TABLE_200
272 , a50 out nocopy JTF_VARCHAR2_TABLE_200
273 , a51 out nocopy JTF_VARCHAR2_TABLE_200
274 , a52 out nocopy JTF_VARCHAR2_TABLE_200
275 , a53 out nocopy JTF_VARCHAR2_TABLE_200
276 , a54 out nocopy JTF_VARCHAR2_TABLE_200
277 , a55 out nocopy JTF_VARCHAR2_TABLE_200
278 , a56 out nocopy JTF_VARCHAR2_TABLE_200
279 , a57 out nocopy JTF_VARCHAR2_TABLE_200
280 , a58 out nocopy JTF_VARCHAR2_TABLE_200
281 , a59 out nocopy JTF_VARCHAR2_TABLE_200
282 , a60 out nocopy JTF_VARCHAR2_TABLE_200
283 , a61 out nocopy JTF_VARCHAR2_TABLE_200
284 , a62 out nocopy JTF_VARCHAR2_TABLE_200
285 , a63 out nocopy JTF_VARCHAR2_TABLE_100
286 , a64 out nocopy JTF_VARCHAR2_TABLE_100
287 , a65 out nocopy JTF_VARCHAR2_TABLE_300
288 , a66 out nocopy JTF_VARCHAR2_TABLE_100
289 , a67 out nocopy JTF_NUMBER_TABLE
290 , a68 out nocopy JTF_VARCHAR2_TABLE_100
291 , a69 out nocopy JTF_VARCHAR2_TABLE_100
292 , a70 out nocopy JTF_NUMBER_TABLE
293 , a71 out nocopy JTF_VARCHAR2_TABLE_100
294 , a72 out nocopy JTF_VARCHAR2_TABLE_100
295 , a73 out nocopy JTF_NUMBER_TABLE
296 , a74 out nocopy JTF_VARCHAR2_TABLE_100
297 , a75 out nocopy JTF_VARCHAR2_TABLE_100
298 , a76 out nocopy JTF_NUMBER_TABLE
299 , a77 out nocopy JTF_VARCHAR2_TABLE_100
300 , a78 out nocopy JTF_VARCHAR2_TABLE_300
301 , a79 out nocopy JTF_NUMBER_TABLE
302 , a80 out nocopy JTF_NUMBER_TABLE
303 , a81 out nocopy JTF_VARCHAR2_TABLE_100
304 , a82 out nocopy JTF_VARCHAR2_TABLE_100
305 , a83 out nocopy JTF_DATE_TABLE
306 , a84 out nocopy JTF_VARCHAR2_TABLE_100
307 , a85 out nocopy JTF_VARCHAR2_TABLE_2000
308 , a86 out nocopy JTF_VARCHAR2_TABLE_100
309 , a87 out nocopy JTF_VARCHAR2_TABLE_4000
310 , a88 out nocopy JTF_VARCHAR2_TABLE_100
311 , a89 out nocopy JTF_VARCHAR2_TABLE_100
312 , a90 out nocopy JTF_VARCHAR2_TABLE_100
313 , a91 out nocopy JTF_NUMBER_TABLE
314 , a92 out nocopy JTF_NUMBER_TABLE
315 , a93 out nocopy JTF_VARCHAR2_TABLE_100
316 , a94 out nocopy JTF_VARCHAR2_TABLE_300
317 , a95 out nocopy JTF_NUMBER_TABLE
318 , a96 out nocopy JTF_VARCHAR2_TABLE_100
319 , a97 out nocopy JTF_VARCHAR2_TABLE_300
320 , a98 out nocopy JTF_NUMBER_TABLE
321 , a99 out nocopy JTF_VARCHAR2_TABLE_100
322 , a100 out nocopy JTF_VARCHAR2_TABLE_100
323 ) as
324 ddindx binary_integer; indx binary_integer;
325 begin
326 if t is null or t.count = 0 then
327 a0 := JTF_NUMBER_TABLE();
328 a1 := JTF_VARCHAR2_TABLE_100();
329 a2 := JTF_NUMBER_TABLE();
330 a3 := JTF_NUMBER_TABLE();
331 a4 := JTF_DATE_TABLE();
332 a5 := JTF_NUMBER_TABLE();
333 a6 := JTF_DATE_TABLE();
334 a7 := JTF_NUMBER_TABLE();
335 a8 := JTF_NUMBER_TABLE();
336 a9 := JTF_NUMBER_TABLE();
337 a10 := JTF_VARCHAR2_TABLE_300();
338 a11 := JTF_NUMBER_TABLE();
339 a12 := JTF_VARCHAR2_TABLE_300();
340 a13 := JTF_NUMBER_TABLE();
341 a14 := JTF_VARCHAR2_TABLE_100();
342 a15 := JTF_VARCHAR2_TABLE_100();
343 a16 := JTF_VARCHAR2_TABLE_100();
344 a17 := JTF_DATE_TABLE();
345 a18 := JTF_NUMBER_TABLE();
346 a19 := JTF_NUMBER_TABLE();
347 a20 := JTF_DATE_TABLE();
348 a21 := JTF_NUMBER_TABLE();
349 a22 := JTF_NUMBER_TABLE();
350 a23 := JTF_DATE_TABLE();
351 a24 := JTF_DATE_TABLE();
352 a25 := JTF_VARCHAR2_TABLE_100();
353 a26 := JTF_VARCHAR2_TABLE_100();
354 a27 := JTF_VARCHAR2_TABLE_100();
355 a28 := JTF_VARCHAR2_TABLE_100();
356 a29 := JTF_NUMBER_TABLE();
357 a30 := JTF_VARCHAR2_TABLE_100();
358 a31 := JTF_NUMBER_TABLE();
359 a32 := JTF_VARCHAR2_TABLE_100();
360 a33 := JTF_NUMBER_TABLE();
361 a34 := JTF_VARCHAR2_TABLE_100();
362 a35 := JTF_NUMBER_TABLE();
363 a36 := JTF_NUMBER_TABLE();
364 a37 := JTF_VARCHAR2_TABLE_100();
365 a38 := JTF_VARCHAR2_TABLE_100();
366 a39 := JTF_VARCHAR2_TABLE_100();
367 a40 := JTF_VARCHAR2_TABLE_100();
368 a41 := JTF_VARCHAR2_TABLE_100();
372 a45 := JTF_VARCHAR2_TABLE_4000();
369 a42 := JTF_VARCHAR2_TABLE_100();
370 a43 := JTF_NUMBER_TABLE();
371 a44 := JTF_NUMBER_TABLE();
373 a46 := JTF_NUMBER_TABLE();
374 a47 := JTF_VARCHAR2_TABLE_100();
375 a48 := JTF_VARCHAR2_TABLE_200();
376 a49 := JTF_VARCHAR2_TABLE_200();
377 a50 := JTF_VARCHAR2_TABLE_200();
378 a51 := JTF_VARCHAR2_TABLE_200();
379 a52 := JTF_VARCHAR2_TABLE_200();
380 a53 := JTF_VARCHAR2_TABLE_200();
381 a54 := JTF_VARCHAR2_TABLE_200();
382 a55 := JTF_VARCHAR2_TABLE_200();
383 a56 := JTF_VARCHAR2_TABLE_200();
384 a57 := JTF_VARCHAR2_TABLE_200();
385 a58 := JTF_VARCHAR2_TABLE_200();
386 a59 := JTF_VARCHAR2_TABLE_200();
387 a60 := JTF_VARCHAR2_TABLE_200();
388 a61 := JTF_VARCHAR2_TABLE_200();
389 a62 := JTF_VARCHAR2_TABLE_200();
390 a63 := JTF_VARCHAR2_TABLE_100();
391 a64 := JTF_VARCHAR2_TABLE_100();
392 a65 := JTF_VARCHAR2_TABLE_300();
393 a66 := JTF_VARCHAR2_TABLE_100();
394 a67 := JTF_NUMBER_TABLE();
395 a68 := JTF_VARCHAR2_TABLE_100();
396 a69 := JTF_VARCHAR2_TABLE_100();
397 a70 := JTF_NUMBER_TABLE();
398 a71 := JTF_VARCHAR2_TABLE_100();
399 a72 := JTF_VARCHAR2_TABLE_100();
400 a73 := JTF_NUMBER_TABLE();
401 a74 := JTF_VARCHAR2_TABLE_100();
402 a75 := JTF_VARCHAR2_TABLE_100();
403 a76 := JTF_NUMBER_TABLE();
404 a77 := JTF_VARCHAR2_TABLE_100();
405 a78 := JTF_VARCHAR2_TABLE_300();
406 a79 := JTF_NUMBER_TABLE();
407 a80 := JTF_NUMBER_TABLE();
408 a81 := JTF_VARCHAR2_TABLE_100();
409 a82 := JTF_VARCHAR2_TABLE_100();
410 a83 := JTF_DATE_TABLE();
411 a84 := JTF_VARCHAR2_TABLE_100();
412 a85 := JTF_VARCHAR2_TABLE_2000();
413 a86 := JTF_VARCHAR2_TABLE_100();
414 a87 := JTF_VARCHAR2_TABLE_4000();
415 a88 := JTF_VARCHAR2_TABLE_100();
416 a89 := JTF_VARCHAR2_TABLE_100();
417 a90 := JTF_VARCHAR2_TABLE_100();
418 a91 := JTF_NUMBER_TABLE();
419 a92 := JTF_NUMBER_TABLE();
420 a93 := JTF_VARCHAR2_TABLE_100();
421 a94 := JTF_VARCHAR2_TABLE_300();
422 a95 := JTF_NUMBER_TABLE();
423 a96 := JTF_VARCHAR2_TABLE_100();
424 a97 := JTF_VARCHAR2_TABLE_300();
425 a98 := JTF_NUMBER_TABLE();
426 a99 := JTF_VARCHAR2_TABLE_100();
427 a100 := JTF_VARCHAR2_TABLE_100();
428 else
429 a0 := JTF_NUMBER_TABLE();
430 a1 := JTF_VARCHAR2_TABLE_100();
431 a2 := JTF_NUMBER_TABLE();
432 a3 := JTF_NUMBER_TABLE();
433 a4 := JTF_DATE_TABLE();
434 a5 := JTF_NUMBER_TABLE();
435 a6 := JTF_DATE_TABLE();
436 a7 := JTF_NUMBER_TABLE();
437 a8 := JTF_NUMBER_TABLE();
438 a9 := JTF_NUMBER_TABLE();
439 a10 := JTF_VARCHAR2_TABLE_300();
440 a11 := JTF_NUMBER_TABLE();
441 a12 := JTF_VARCHAR2_TABLE_300();
442 a13 := JTF_NUMBER_TABLE();
443 a14 := JTF_VARCHAR2_TABLE_100();
444 a15 := JTF_VARCHAR2_TABLE_100();
445 a16 := JTF_VARCHAR2_TABLE_100();
446 a17 := JTF_DATE_TABLE();
447 a18 := JTF_NUMBER_TABLE();
448 a19 := JTF_NUMBER_TABLE();
449 a20 := JTF_DATE_TABLE();
450 a21 := JTF_NUMBER_TABLE();
451 a22 := JTF_NUMBER_TABLE();
452 a23 := JTF_DATE_TABLE();
453 a24 := JTF_DATE_TABLE();
454 a25 := JTF_VARCHAR2_TABLE_100();
455 a26 := JTF_VARCHAR2_TABLE_100();
456 a27 := JTF_VARCHAR2_TABLE_100();
457 a28 := JTF_VARCHAR2_TABLE_100();
458 a29 := JTF_NUMBER_TABLE();
459 a30 := JTF_VARCHAR2_TABLE_100();
460 a31 := JTF_NUMBER_TABLE();
461 a32 := JTF_VARCHAR2_TABLE_100();
462 a33 := JTF_NUMBER_TABLE();
463 a34 := JTF_VARCHAR2_TABLE_100();
464 a35 := JTF_NUMBER_TABLE();
465 a36 := JTF_NUMBER_TABLE();
466 a37 := JTF_VARCHAR2_TABLE_100();
467 a38 := JTF_VARCHAR2_TABLE_100();
468 a39 := JTF_VARCHAR2_TABLE_100();
469 a40 := JTF_VARCHAR2_TABLE_100();
470 a41 := JTF_VARCHAR2_TABLE_100();
471 a42 := JTF_VARCHAR2_TABLE_100();
472 a43 := JTF_NUMBER_TABLE();
473 a44 := JTF_NUMBER_TABLE();
474 a45 := JTF_VARCHAR2_TABLE_4000();
475 a46 := JTF_NUMBER_TABLE();
476 a47 := JTF_VARCHAR2_TABLE_100();
477 a48 := JTF_VARCHAR2_TABLE_200();
478 a49 := JTF_VARCHAR2_TABLE_200();
479 a50 := JTF_VARCHAR2_TABLE_200();
480 a51 := JTF_VARCHAR2_TABLE_200();
481 a52 := JTF_VARCHAR2_TABLE_200();
482 a53 := JTF_VARCHAR2_TABLE_200();
483 a54 := JTF_VARCHAR2_TABLE_200();
484 a55 := JTF_VARCHAR2_TABLE_200();
485 a56 := JTF_VARCHAR2_TABLE_200();
486 a57 := JTF_VARCHAR2_TABLE_200();
487 a58 := JTF_VARCHAR2_TABLE_200();
488 a59 := JTF_VARCHAR2_TABLE_200();
489 a60 := JTF_VARCHAR2_TABLE_200();
490 a61 := JTF_VARCHAR2_TABLE_200();
491 a62 := JTF_VARCHAR2_TABLE_200();
492 a63 := JTF_VARCHAR2_TABLE_100();
493 a64 := JTF_VARCHAR2_TABLE_100();
494 a65 := JTF_VARCHAR2_TABLE_300();
495 a66 := JTF_VARCHAR2_TABLE_100();
496 a67 := JTF_NUMBER_TABLE();
497 a68 := JTF_VARCHAR2_TABLE_100();
498 a69 := JTF_VARCHAR2_TABLE_100();
499 a70 := JTF_NUMBER_TABLE();
500 a71 := JTF_VARCHAR2_TABLE_100();
501 a72 := JTF_VARCHAR2_TABLE_100();
502 a73 := JTF_NUMBER_TABLE();
503 a74 := JTF_VARCHAR2_TABLE_100();
504 a75 := JTF_VARCHAR2_TABLE_100();
505 a76 := JTF_NUMBER_TABLE();
506 a77 := JTF_VARCHAR2_TABLE_100();
507 a78 := JTF_VARCHAR2_TABLE_300();
508 a79 := JTF_NUMBER_TABLE();
509 a80 := JTF_NUMBER_TABLE();
510 a81 := JTF_VARCHAR2_TABLE_100();
511 a82 := JTF_VARCHAR2_TABLE_100();
515 a86 := JTF_VARCHAR2_TABLE_100();
512 a83 := JTF_DATE_TABLE();
513 a84 := JTF_VARCHAR2_TABLE_100();
514 a85 := JTF_VARCHAR2_TABLE_2000();
516 a87 := JTF_VARCHAR2_TABLE_4000();
517 a88 := JTF_VARCHAR2_TABLE_100();
518 a89 := JTF_VARCHAR2_TABLE_100();
519 a90 := JTF_VARCHAR2_TABLE_100();
520 a91 := JTF_NUMBER_TABLE();
521 a92 := JTF_NUMBER_TABLE();
522 a93 := JTF_VARCHAR2_TABLE_100();
523 a94 := JTF_VARCHAR2_TABLE_300();
524 a95 := JTF_NUMBER_TABLE();
525 a96 := JTF_VARCHAR2_TABLE_100();
526 a97 := JTF_VARCHAR2_TABLE_300();
527 a98 := JTF_NUMBER_TABLE();
528 a99 := JTF_VARCHAR2_TABLE_100();
529 a100 := JTF_VARCHAR2_TABLE_100();
530 if t.count > 0 then
531 a0.extend(t.count);
532 a1.extend(t.count);
533 a2.extend(t.count);
534 a3.extend(t.count);
535 a4.extend(t.count);
536 a5.extend(t.count);
537 a6.extend(t.count);
538 a7.extend(t.count);
539 a8.extend(t.count);
540 a9.extend(t.count);
541 a10.extend(t.count);
542 a11.extend(t.count);
543 a12.extend(t.count);
544 a13.extend(t.count);
545 a14.extend(t.count);
546 a15.extend(t.count);
547 a16.extend(t.count);
548 a17.extend(t.count);
549 a18.extend(t.count);
550 a19.extend(t.count);
551 a20.extend(t.count);
552 a21.extend(t.count);
553 a22.extend(t.count);
554 a23.extend(t.count);
555 a24.extend(t.count);
556 a25.extend(t.count);
557 a26.extend(t.count);
558 a27.extend(t.count);
559 a28.extend(t.count);
560 a29.extend(t.count);
561 a30.extend(t.count);
562 a31.extend(t.count);
563 a32.extend(t.count);
564 a33.extend(t.count);
565 a34.extend(t.count);
566 a35.extend(t.count);
567 a36.extend(t.count);
568 a37.extend(t.count);
569 a38.extend(t.count);
570 a39.extend(t.count);
571 a40.extend(t.count);
572 a41.extend(t.count);
573 a42.extend(t.count);
574 a43.extend(t.count);
575 a44.extend(t.count);
576 a45.extend(t.count);
577 a46.extend(t.count);
578 a47.extend(t.count);
579 a48.extend(t.count);
580 a49.extend(t.count);
581 a50.extend(t.count);
582 a51.extend(t.count);
583 a52.extend(t.count);
584 a53.extend(t.count);
585 a54.extend(t.count);
586 a55.extend(t.count);
587 a56.extend(t.count);
588 a57.extend(t.count);
589 a58.extend(t.count);
590 a59.extend(t.count);
591 a60.extend(t.count);
592 a61.extend(t.count);
593 a62.extend(t.count);
594 a63.extend(t.count);
595 a64.extend(t.count);
596 a65.extend(t.count);
597 a66.extend(t.count);
598 a67.extend(t.count);
599 a68.extend(t.count);
600 a69.extend(t.count);
601 a70.extend(t.count);
602 a71.extend(t.count);
603 a72.extend(t.count);
604 a73.extend(t.count);
605 a74.extend(t.count);
606 a75.extend(t.count);
607 a76.extend(t.count);
608 a77.extend(t.count);
609 a78.extend(t.count);
610 a79.extend(t.count);
611 a80.extend(t.count);
612 a81.extend(t.count);
613 a82.extend(t.count);
614 a83.extend(t.count);
615 a84.extend(t.count);
616 a85.extend(t.count);
617 a86.extend(t.count);
618 a87.extend(t.count);
619 a88.extend(t.count);
620 a89.extend(t.count);
621 a90.extend(t.count);
622 a91.extend(t.count);
623 a92.extend(t.count);
624 a93.extend(t.count);
625 a94.extend(t.count);
626 a95.extend(t.count);
627 a96.extend(t.count);
628 a97.extend(t.count);
629 a98.extend(t.count);
630 a99.extend(t.count);
631 a100.extend(t.count);
632 ddindx := t.first;
633 indx := 1;
634 while true loop
635 a0(indx) := t(ddindx).visit_id;
636 a1(indx) := t(ddindx).visit_name;
637 a2(indx) := t(ddindx).visit_number;
638 a3(indx) := t(ddindx).object_version_number;
639 a4(indx) := t(ddindx).last_update_date;
640 a5(indx) := t(ddindx).last_updated_by;
641 a6(indx) := t(ddindx).creation_date;
642 a7(indx) := t(ddindx).created_by;
643 a8(indx) := t(ddindx).last_update_login;
644 a9(indx) := t(ddindx).organization_id;
645 a10(indx) := t(ddindx).org_name;
646 a11(indx) := t(ddindx).department_id;
647 a12(indx) := t(ddindx).dept_name;
648 a13(indx) := t(ddindx).service_request_id;
649 a14(indx) := t(ddindx).service_request_number;
650 a15(indx) := t(ddindx).space_category_code;
651 a16(indx) := t(ddindx).space_category_name;
652 a17(indx) := t(ddindx).start_date;
653 a18(indx) := t(ddindx).start_hour;
654 a19(indx) := t(ddindx).start_min;
655 a20(indx) := t(ddindx).plan_end_date;
656 a21(indx) := t(ddindx).plan_end_hour;
657 a22(indx) := t(ddindx).plan_end_min;
658 a23(indx) := t(ddindx).end_date;
659 a24(indx) := t(ddindx).due_by_date;
660 a25(indx) := t(ddindx).visit_type_code;
661 a26(indx) := t(ddindx).visit_type_name;
665 a30(indx) := t(ddindx).simulation_plan_name;
662 a27(indx) := t(ddindx).status_code;
663 a28(indx) := t(ddindx).status_name;
664 a29(indx) := t(ddindx).simulation_plan_id;
666 a31(indx) := t(ddindx).asso_primary_visit_id;
667 a32(indx) := t(ddindx).unit_name;
668 a33(indx) := t(ddindx).item_instance_id;
669 a34(indx) := t(ddindx).serial_number;
670 a35(indx) := t(ddindx).inventory_item_id;
671 a36(indx) := t(ddindx).item_organization_id;
672 a37(indx) := t(ddindx).item_name;
673 a38(indx) := t(ddindx).simulation_delete_flag;
674 a39(indx) := t(ddindx).template_flag;
675 a40(indx) := t(ddindx).out_of_sync_flag;
676 a41(indx) := t(ddindx).project_flag;
677 a42(indx) := t(ddindx).project_flag_code;
678 a43(indx) := t(ddindx).project_id;
679 a44(indx) := t(ddindx).project_number;
680 a45(indx) := t(ddindx).description;
681 a46(indx) := t(ddindx).duration;
682 a47(indx) := t(ddindx).attribute_category;
683 a48(indx) := t(ddindx).attribute1;
684 a49(indx) := t(ddindx).attribute2;
685 a50(indx) := t(ddindx).attribute3;
686 a51(indx) := t(ddindx).attribute4;
687 a52(indx) := t(ddindx).attribute5;
688 a53(indx) := t(ddindx).attribute6;
689 a54(indx) := t(ddindx).attribute7;
690 a55(indx) := t(ddindx).attribute8;
691 a56(indx) := t(ddindx).attribute9;
692 a57(indx) := t(ddindx).attribute10;
693 a58(indx) := t(ddindx).attribute11;
694 a59(indx) := t(ddindx).attribute12;
695 a60(indx) := t(ddindx).attribute13;
696 a61(indx) := t(ddindx).attribute14;
697 a62(indx) := t(ddindx).attribute15;
698 a63(indx) := t(ddindx).operation_flag;
699 a64(indx) := t(ddindx).outside_party_flag;
700 a65(indx) := t(ddindx).job_number;
701 a66(indx) := t(ddindx).proj_template_name;
702 a67(indx) := t(ddindx).proj_template_id;
703 a68(indx) := t(ddindx).priority_value;
704 a69(indx) := t(ddindx).priority_code;
705 a70(indx) := t(ddindx).unit_schedule_id;
706 a71(indx) := t(ddindx).visit_create_type;
707 a72(indx) := t(ddindx).visit_create_meaning;
708 a73(indx) := t(ddindx).unit_header_id;
709 a74(indx) := t(ddindx).flight_number;
710 a75(indx) := t(ddindx).project_name;
711 a76(indx) := t(ddindx).top_project_task_id;
712 a77(indx) := t(ddindx).subinventory;
713 a78(indx) := t(ddindx).locator_segment;
714 a79(indx) := t(ddindx).inv_locator_id;
715 a80(indx) := t(ddindx).cp_request_id;
716 a81(indx) := t(ddindx).cp_phase_code;
717 a82(indx) := t(ddindx).cp_status_code;
718 a83(indx) := t(ddindx).cp_request_date;
719 a84(indx) := t(ddindx).jc_exist;
720 a85(indx) := t(ddindx).view_jc_url;
721 a86(indx) := t(ddindx).jc_gen_status;
722 a87(indx) := t(ddindx).jc_gen_error_text;
723 a88(indx) := t(ddindx).past_dated_visit_flag;
724 a89(indx) := t(ddindx).locked_flag;
725 a90(indx) := t(ddindx).firmed_flag;
726 a91(indx) := t(ddindx).tasks_ovn_updated_count;
727 a92(indx) := t(ddindx).stages_ovn_updated_count;
728 a93(indx) := t(ddindx).comp_planning_subinv;
729 a94(indx) := t(ddindx).comp_planning_loc_seg;
730 a95(indx) := t(ddindx).comp_planning_loc_id;
731 a96(indx) := t(ddindx).comp_inrepair_subinv;
732 a97(indx) := t(ddindx).comp_inrepair_loc_seg;
733 a98(indx) := t(ddindx).comp_inrepair_loc_id;
734 a99(indx) := t(ddindx).item_owner_flag;
735 a100(indx) := t(ddindx).auto_visit_type_flag;
736 indx := indx+1;
737 if t.last =ddindx
738 then exit;
739 end if;
740 ddindx := t.next(ddindx);
741 end loop;
742 end if;
743 end if;
744 end rosetta_table_copy_out_p3;
745
746 procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_visits_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
747 , a1 JTF_VARCHAR2_TABLE_100
748 , a2 JTF_VARCHAR2_TABLE_100
749 , a3 JTF_VARCHAR2_TABLE_100
750 , a4 JTF_VARCHAR2_TABLE_100
751 , a5 JTF_DATE_TABLE
752 , a6 JTF_DATE_TABLE
753 , a7 JTF_VARCHAR2_TABLE_100
754 ) as
755 ddindx binary_integer; indx binary_integer;
756 begin
757 if a0 is not null and a0.count > 0 then
758 if a0.count > 0 then
759 indx := a0.first;
760 ddindx := 1;
761 while true loop
762 t(ddindx).job_id := a0(indx);
763 t(ddindx).job_number := a1(indx);
764 t(ddindx).service_request := a2(indx);
765 t(ddindx).task_number := a3(indx);
766 t(ddindx).priority := a4(indx);
767 t(ddindx).scheduled_start_date := a5(indx);
768 t(ddindx).scheduled_end_date := a6(indx);
769 t(ddindx).job_status := a7(indx);
770 ddindx := ddindx+1;
771 if a0.last =indx
772 then exit;
773 end if;
774 indx := a0.next(indx);
775 end loop;
776 end if;
777 end if;
778 end rosetta_table_copy_in_p4;
779 procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
780 , a1 out nocopy JTF_VARCHAR2_TABLE_100
781 , a2 out nocopy JTF_VARCHAR2_TABLE_100
782 , a3 out nocopy JTF_VARCHAR2_TABLE_100
783 , a4 out nocopy JTF_VARCHAR2_TABLE_100
784 , a5 out nocopy JTF_DATE_TABLE
785 , a6 out nocopy JTF_DATE_TABLE
786 , a7 out nocopy JTF_VARCHAR2_TABLE_100
787 ) as
791 a0 := JTF_NUMBER_TABLE();
788 ddindx binary_integer; indx binary_integer;
789 begin
790 if t is null or t.count = 0 then
792 a1 := JTF_VARCHAR2_TABLE_100();
793 a2 := JTF_VARCHAR2_TABLE_100();
794 a3 := JTF_VARCHAR2_TABLE_100();
795 a4 := JTF_VARCHAR2_TABLE_100();
796 a5 := JTF_DATE_TABLE();
797 a6 := JTF_DATE_TABLE();
798 a7 := JTF_VARCHAR2_TABLE_100();
799 else
800 a0 := JTF_NUMBER_TABLE();
801 a1 := JTF_VARCHAR2_TABLE_100();
802 a2 := JTF_VARCHAR2_TABLE_100();
803 a3 := JTF_VARCHAR2_TABLE_100();
804 a4 := JTF_VARCHAR2_TABLE_100();
805 a5 := JTF_DATE_TABLE();
806 a6 := JTF_DATE_TABLE();
807 a7 := JTF_VARCHAR2_TABLE_100();
808 if t.count > 0 then
809 a0.extend(t.count);
810 a1.extend(t.count);
811 a2.extend(t.count);
812 a3.extend(t.count);
813 a4.extend(t.count);
814 a5.extend(t.count);
815 a6.extend(t.count);
816 a7.extend(t.count);
817 ddindx := t.first;
818 indx := 1;
819 while true loop
820 a0(indx) := t(ddindx).job_id;
821 a1(indx) := t(ddindx).job_number;
822 a2(indx) := t(ddindx).service_request;
823 a3(indx) := t(ddindx).task_number;
824 a4(indx) := t(ddindx).priority;
825 a5(indx) := t(ddindx).scheduled_start_date;
826 a6(indx) := t(ddindx).scheduled_end_date;
827 a7(indx) := t(ddindx).job_status;
828 indx := indx+1;
829 if t.last =ddindx
830 then exit;
831 end if;
832 ddindx := t.next(ddindx);
833 end loop;
834 end if;
835 end if;
836 end rosetta_table_copy_out_p4;
837
838 procedure process_visit(p_api_version NUMBER
839 , p_init_msg_list VARCHAR2
840 , p_commit VARCHAR2
841 , p_validation_level NUMBER
842 , p_module_type VARCHAR2
843 , p5_a0 in out nocopy JTF_NUMBER_TABLE
844 , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
845 , p5_a2 in out nocopy JTF_NUMBER_TABLE
846 , p5_a3 in out nocopy JTF_NUMBER_TABLE
847 , p5_a4 in out nocopy JTF_DATE_TABLE
848 , p5_a5 in out nocopy JTF_NUMBER_TABLE
849 , p5_a6 in out nocopy JTF_DATE_TABLE
850 , p5_a7 in out nocopy JTF_NUMBER_TABLE
851 , p5_a8 in out nocopy JTF_NUMBER_TABLE
852 , p5_a9 in out nocopy JTF_NUMBER_TABLE
853 , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
854 , p5_a11 in out nocopy JTF_NUMBER_TABLE
855 , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
856 , p5_a13 in out nocopy JTF_NUMBER_TABLE
857 , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
858 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
859 , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
860 , p5_a17 in out nocopy JTF_DATE_TABLE
861 , p5_a18 in out nocopy JTF_NUMBER_TABLE
862 , p5_a19 in out nocopy JTF_NUMBER_TABLE
863 , p5_a20 in out nocopy JTF_DATE_TABLE
864 , p5_a21 in out nocopy JTF_NUMBER_TABLE
865 , p5_a22 in out nocopy JTF_NUMBER_TABLE
866 , p5_a23 in out nocopy JTF_DATE_TABLE
867 , p5_a24 in out nocopy JTF_DATE_TABLE
868 , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100
869 , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
870 , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
871 , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
872 , p5_a29 in out nocopy JTF_NUMBER_TABLE
873 , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_100
874 , p5_a31 in out nocopy JTF_NUMBER_TABLE
875 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
876 , p5_a33 in out nocopy JTF_NUMBER_TABLE
877 , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
878 , p5_a35 in out nocopy JTF_NUMBER_TABLE
879 , p5_a36 in out nocopy JTF_NUMBER_TABLE
880 , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
881 , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_100
882 , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
883 , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
884 , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_100
885 , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
886 , p5_a43 in out nocopy JTF_NUMBER_TABLE
887 , p5_a44 in out nocopy JTF_NUMBER_TABLE
888 , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_4000
889 , p5_a46 in out nocopy JTF_NUMBER_TABLE
890 , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_100
891 , p5_a48 in out nocopy JTF_VARCHAR2_TABLE_200
892 , p5_a49 in out nocopy JTF_VARCHAR2_TABLE_200
893 , p5_a50 in out nocopy JTF_VARCHAR2_TABLE_200
894 , p5_a51 in out nocopy JTF_VARCHAR2_TABLE_200
895 , p5_a52 in out nocopy JTF_VARCHAR2_TABLE_200
896 , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
897 , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
898 , p5_a55 in out nocopy JTF_VARCHAR2_TABLE_200
899 , p5_a56 in out nocopy JTF_VARCHAR2_TABLE_200
900 , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
901 , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
902 , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_200
903 , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_200
904 , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_200
905 , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_200
906 , p5_a63 in out nocopy JTF_VARCHAR2_TABLE_100
907 , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_100
908 , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_300
909 , p5_a66 in out nocopy JTF_VARCHAR2_TABLE_100
910 , p5_a67 in out nocopy JTF_NUMBER_TABLE
911 , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
912 , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
913 , p5_a70 in out nocopy JTF_NUMBER_TABLE
914 , p5_a71 in out nocopy JTF_VARCHAR2_TABLE_100
915 , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
916 , p5_a73 in out nocopy JTF_NUMBER_TABLE
917 , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
918 , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
922 , p5_a79 in out nocopy JTF_NUMBER_TABLE
919 , p5_a76 in out nocopy JTF_NUMBER_TABLE
920 , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
921 , p5_a78 in out nocopy JTF_VARCHAR2_TABLE_300
923 , p5_a80 in out nocopy JTF_NUMBER_TABLE
924 , p5_a81 in out nocopy JTF_VARCHAR2_TABLE_100
925 , p5_a82 in out nocopy JTF_VARCHAR2_TABLE_100
926 , p5_a83 in out nocopy JTF_DATE_TABLE
927 , p5_a84 in out nocopy JTF_VARCHAR2_TABLE_100
928 , p5_a85 in out nocopy JTF_VARCHAR2_TABLE_2000
929 , p5_a86 in out nocopy JTF_VARCHAR2_TABLE_100
930 , p5_a87 in out nocopy JTF_VARCHAR2_TABLE_4000
931 , p5_a88 in out nocopy JTF_VARCHAR2_TABLE_100
932 , p5_a89 in out nocopy JTF_VARCHAR2_TABLE_100
933 , p5_a90 in out nocopy JTF_VARCHAR2_TABLE_100
934 , p5_a91 in out nocopy JTF_NUMBER_TABLE
935 , p5_a92 in out nocopy JTF_NUMBER_TABLE
936 , p5_a93 in out nocopy JTF_VARCHAR2_TABLE_100
937 , p5_a94 in out nocopy JTF_VARCHAR2_TABLE_300
938 , p5_a95 in out nocopy JTF_NUMBER_TABLE
939 , p5_a96 in out nocopy JTF_VARCHAR2_TABLE_100
940 , p5_a97 in out nocopy JTF_VARCHAR2_TABLE_300
941 , p5_a98 in out nocopy JTF_NUMBER_TABLE
942 , p5_a99 in out nocopy JTF_VARCHAR2_TABLE_100
943 , p5_a100 in out nocopy JTF_VARCHAR2_TABLE_100
944 , x_return_status out nocopy VARCHAR2
945 , x_msg_count out nocopy NUMBER
946 , x_msg_data out nocopy VARCHAR2
947 )
948
949 as
950 ddp_x_visit_tbl ahl_vwp_visits_pvt.visit_tbl_type;
951 ddindx binary_integer; indx binary_integer;
952 begin
953
954 -- copy data to the local IN or IN-OUT args, if any
955
956
957
958
959
960 ahl_vwp_visits_pvt_w.rosetta_table_copy_in_p3(ddp_x_visit_tbl, p5_a0
961 , p5_a1
962 , p5_a2
963 , p5_a3
964 , p5_a4
965 , p5_a5
966 , p5_a6
967 , p5_a7
968 , p5_a8
969 , p5_a9
970 , p5_a10
971 , p5_a11
972 , p5_a12
973 , p5_a13
974 , p5_a14
975 , p5_a15
976 , p5_a16
977 , p5_a17
978 , p5_a18
979 , p5_a19
980 , p5_a20
981 , p5_a21
982 , p5_a22
983 , p5_a23
984 , p5_a24
985 , p5_a25
986 , p5_a26
987 , p5_a27
988 , p5_a28
989 , p5_a29
990 , p5_a30
991 , p5_a31
992 , p5_a32
993 , p5_a33
994 , p5_a34
995 , p5_a35
996 , p5_a36
997 , p5_a37
998 , p5_a38
999 , p5_a39
1000 , p5_a40
1001 , p5_a41
1002 , p5_a42
1003 , p5_a43
1004 , p5_a44
1005 , p5_a45
1006 , p5_a46
1007 , p5_a47
1008 , p5_a48
1009 , p5_a49
1010 , p5_a50
1011 , p5_a51
1012 , p5_a52
1013 , p5_a53
1014 , p5_a54
1015 , p5_a55
1016 , p5_a56
1017 , p5_a57
1018 , p5_a58
1019 , p5_a59
1020 , p5_a60
1021 , p5_a61
1022 , p5_a62
1023 , p5_a63
1024 , p5_a64
1025 , p5_a65
1026 , p5_a66
1027 , p5_a67
1028 , p5_a68
1029 , p5_a69
1030 , p5_a70
1031 , p5_a71
1032 , p5_a72
1033 , p5_a73
1034 , p5_a74
1035 , p5_a75
1036 , p5_a76
1037 , p5_a77
1038 , p5_a78
1039 , p5_a79
1040 , p5_a80
1041 , p5_a81
1042 , p5_a82
1043 , p5_a83
1044 , p5_a84
1045 , p5_a85
1046 , p5_a86
1047 , p5_a87
1048 , p5_a88
1049 , p5_a89
1050 , p5_a90
1051 , p5_a91
1052 , p5_a92
1053 , p5_a93
1054 , p5_a94
1055 , p5_a95
1056 , p5_a96
1057 , p5_a97
1058 , p5_a98
1059 , p5_a99
1060 , p5_a100
1061 );
1062
1063
1064
1065
1066 -- here's the delegated call to the old PL/SQL routine
1067 ahl_vwp_visits_pvt.process_visit(p_api_version,
1068 p_init_msg_list,
1069 p_commit,
1070 p_validation_level,
1071 p_module_type,
1072 ddp_x_visit_tbl,
1073 x_return_status,
1074 x_msg_count,
1075 x_msg_data);
1076
1077 -- copy data back from the local variables to OUT or IN-OUT args, if any
1078
1079
1080
1081
1082
1083 ahl_vwp_visits_pvt_w.rosetta_table_copy_out_p3(ddp_x_visit_tbl, p5_a0
1084 , p5_a1
1085 , p5_a2
1086 , p5_a3
1087 , p5_a4
1088 , p5_a5
1089 , p5_a6
1090 , p5_a7
1091 , p5_a8
1092 , p5_a9
1093 , p5_a10
1094 , p5_a11
1095 , p5_a12
1096 , p5_a13
1097 , p5_a14
1098 , p5_a15
1099 , p5_a16
1100 , p5_a17
1101 , p5_a18
1102 , p5_a19
1103 , p5_a20
1104 , p5_a21
1105 , p5_a22
1106 , p5_a23
1107 , p5_a24
1108 , p5_a25
1109 , p5_a26
1110 , p5_a27
1111 , p5_a28
1112 , p5_a29
1113 , p5_a30
1114 , p5_a31
1115 , p5_a32
1116 , p5_a33
1117 , p5_a34
1118 , p5_a35
1119 , p5_a36
1120 , p5_a37
1121 , p5_a38
1122 , p5_a39
1123 , p5_a40
1124 , p5_a41
1125 , p5_a42
1126 , p5_a43
1130 , p5_a47
1127 , p5_a44
1128 , p5_a45
1129 , p5_a46
1131 , p5_a48
1132 , p5_a49
1133 , p5_a50
1134 , p5_a51
1135 , p5_a52
1136 , p5_a53
1137 , p5_a54
1138 , p5_a55
1139 , p5_a56
1140 , p5_a57
1141 , p5_a58
1142 , p5_a59
1143 , p5_a60
1144 , p5_a61
1145 , p5_a62
1146 , p5_a63
1147 , p5_a64
1148 , p5_a65
1149 , p5_a66
1150 , p5_a67
1151 , p5_a68
1152 , p5_a69
1153 , p5_a70
1154 , p5_a71
1155 , p5_a72
1156 , p5_a73
1157 , p5_a74
1158 , p5_a75
1159 , p5_a76
1160 , p5_a77
1161 , p5_a78
1162 , p5_a79
1163 , p5_a80
1164 , p5_a81
1165 , p5_a82
1166 , p5_a83
1167 , p5_a84
1168 , p5_a85
1169 , p5_a86
1170 , p5_a87
1171 , p5_a88
1172 , p5_a89
1173 , p5_a90
1174 , p5_a91
1175 , p5_a92
1176 , p5_a93
1177 , p5_a94
1178 , p5_a95
1179 , p5_a96
1180 , p5_a97
1181 , p5_a98
1182 , p5_a99
1183 , p5_a100
1184 );
1185
1186
1187
1188 end;
1189
1190 procedure get_visit_details(p_api_version NUMBER
1191 , p_init_msg_list VARCHAR2
1192 , p_commit VARCHAR2
1193 , p_validation_level NUMBER
1194 , p_module_type VARCHAR2
1195 , p_visit_id NUMBER
1196 , p6_a0 out nocopy NUMBER
1197 , p6_a1 out nocopy VARCHAR2
1198 , p6_a2 out nocopy NUMBER
1199 , p6_a3 out nocopy NUMBER
1200 , p6_a4 out nocopy DATE
1201 , p6_a5 out nocopy NUMBER
1202 , p6_a6 out nocopy DATE
1203 , p6_a7 out nocopy NUMBER
1204 , p6_a8 out nocopy NUMBER
1205 , p6_a9 out nocopy NUMBER
1206 , p6_a10 out nocopy VARCHAR2
1207 , p6_a11 out nocopy NUMBER
1208 , p6_a12 out nocopy VARCHAR2
1209 , p6_a13 out nocopy NUMBER
1210 , p6_a14 out nocopy VARCHAR2
1211 , p6_a15 out nocopy VARCHAR2
1212 , p6_a16 out nocopy VARCHAR2
1213 , p6_a17 out nocopy DATE
1214 , p6_a18 out nocopy NUMBER
1215 , p6_a19 out nocopy NUMBER
1216 , p6_a20 out nocopy DATE
1217 , p6_a21 out nocopy NUMBER
1218 , p6_a22 out nocopy NUMBER
1219 , p6_a23 out nocopy DATE
1220 , p6_a24 out nocopy DATE
1221 , p6_a25 out nocopy VARCHAR2
1222 , p6_a26 out nocopy VARCHAR2
1223 , p6_a27 out nocopy VARCHAR2
1224 , p6_a28 out nocopy VARCHAR2
1225 , p6_a29 out nocopy NUMBER
1226 , p6_a30 out nocopy VARCHAR2
1227 , p6_a31 out nocopy NUMBER
1228 , p6_a32 out nocopy VARCHAR2
1229 , p6_a33 out nocopy NUMBER
1230 , p6_a34 out nocopy VARCHAR2
1231 , p6_a35 out nocopy NUMBER
1232 , p6_a36 out nocopy NUMBER
1233 , p6_a37 out nocopy VARCHAR2
1234 , p6_a38 out nocopy VARCHAR2
1235 , p6_a39 out nocopy VARCHAR2
1236 , p6_a40 out nocopy VARCHAR2
1237 , p6_a41 out nocopy VARCHAR2
1238 , p6_a42 out nocopy VARCHAR2
1239 , p6_a43 out nocopy NUMBER
1240 , p6_a44 out nocopy NUMBER
1241 , p6_a45 out nocopy VARCHAR2
1242 , p6_a46 out nocopy NUMBER
1243 , p6_a47 out nocopy VARCHAR2
1244 , p6_a48 out nocopy VARCHAR2
1245 , p6_a49 out nocopy VARCHAR2
1246 , p6_a50 out nocopy VARCHAR2
1247 , p6_a51 out nocopy VARCHAR2
1248 , p6_a52 out nocopy VARCHAR2
1249 , p6_a53 out nocopy VARCHAR2
1250 , p6_a54 out nocopy VARCHAR2
1251 , p6_a55 out nocopy VARCHAR2
1252 , p6_a56 out nocopy VARCHAR2
1253 , p6_a57 out nocopy VARCHAR2
1254 , p6_a58 out nocopy VARCHAR2
1255 , p6_a59 out nocopy VARCHAR2
1256 , p6_a60 out nocopy VARCHAR2
1257 , p6_a61 out nocopy VARCHAR2
1258 , p6_a62 out nocopy VARCHAR2
1259 , p6_a63 out nocopy VARCHAR2
1260 , p6_a64 out nocopy VARCHAR2
1261 , p6_a65 out nocopy VARCHAR2
1262 , p6_a66 out nocopy VARCHAR2
1263 , p6_a67 out nocopy NUMBER
1264 , p6_a68 out nocopy VARCHAR2
1265 , p6_a69 out nocopy VARCHAR2
1266 , p6_a70 out nocopy NUMBER
1267 , p6_a71 out nocopy VARCHAR2
1268 , p6_a72 out nocopy VARCHAR2
1269 , p6_a73 out nocopy NUMBER
1270 , p6_a74 out nocopy VARCHAR2
1271 , p6_a75 out nocopy VARCHAR2
1272 , p6_a76 out nocopy NUMBER
1273 , p6_a77 out nocopy VARCHAR2
1274 , p6_a78 out nocopy VARCHAR2
1275 , p6_a79 out nocopy NUMBER
1276 , p6_a80 out nocopy NUMBER
1277 , p6_a81 out nocopy VARCHAR2
1278 , p6_a82 out nocopy VARCHAR2
1279 , p6_a83 out nocopy DATE
1280 , p6_a84 out nocopy VARCHAR2
1281 , p6_a85 out nocopy VARCHAR2
1282 , p6_a86 out nocopy VARCHAR2
1283 , p6_a87 out nocopy VARCHAR2
1284 , p6_a88 out nocopy VARCHAR2
1285 , p6_a89 out nocopy VARCHAR2
1286 , p6_a90 out nocopy VARCHAR2
1287 , p6_a91 out nocopy NUMBER
1288 , p6_a92 out nocopy NUMBER
1289 , p6_a93 out nocopy VARCHAR2
1290 , p6_a94 out nocopy VARCHAR2
1291 , p6_a95 out nocopy NUMBER
1292 , p6_a96 out nocopy VARCHAR2
1293 , p6_a97 out nocopy VARCHAR2
1294 , p6_a98 out nocopy NUMBER
1295 , p6_a99 out nocopy VARCHAR2
1296 , p6_a100 out nocopy VARCHAR2
1297 , x_return_status out nocopy VARCHAR2
1298 , x_msg_count out nocopy NUMBER
1299 , x_msg_data out nocopy VARCHAR2
1300 )
1301
1302 as
1303 ddx_visit_rec ahl_vwp_visits_pvt.visit_rec_type;
1307 -- copy data to the local IN or IN-OUT args, if any
1304 ddindx binary_integer; indx binary_integer;
1305 begin
1306
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318 -- here's the delegated call to the old PL/SQL routine
1319 ahl_vwp_visits_pvt.get_visit_details(p_api_version,
1320 p_init_msg_list,
1321 p_commit,
1322 p_validation_level,
1323 p_module_type,
1324 p_visit_id,
1325 ddx_visit_rec,
1326 x_return_status,
1327 x_msg_count,
1328 x_msg_data);
1329
1330 -- copy data back from the local variables to OUT or IN-OUT args, if any
1331
1332
1333
1334
1335
1336
1337 p6_a0 := ddx_visit_rec.visit_id;
1338 p6_a1 := ddx_visit_rec.visit_name;
1339 p6_a2 := ddx_visit_rec.visit_number;
1340 p6_a3 := ddx_visit_rec.object_version_number;
1341 p6_a4 := ddx_visit_rec.last_update_date;
1342 p6_a5 := ddx_visit_rec.last_updated_by;
1343 p6_a6 := ddx_visit_rec.creation_date;
1344 p6_a7 := ddx_visit_rec.created_by;
1345 p6_a8 := ddx_visit_rec.last_update_login;
1346 p6_a9 := ddx_visit_rec.organization_id;
1347 p6_a10 := ddx_visit_rec.org_name;
1348 p6_a11 := ddx_visit_rec.department_id;
1349 p6_a12 := ddx_visit_rec.dept_name;
1350 p6_a13 := ddx_visit_rec.service_request_id;
1351 p6_a14 := ddx_visit_rec.service_request_number;
1352 p6_a15 := ddx_visit_rec.space_category_code;
1353 p6_a16 := ddx_visit_rec.space_category_name;
1354 p6_a17 := ddx_visit_rec.start_date;
1355 p6_a18 := ddx_visit_rec.start_hour;
1356 p6_a19 := ddx_visit_rec.start_min;
1357 p6_a20 := ddx_visit_rec.plan_end_date;
1358 p6_a21 := ddx_visit_rec.plan_end_hour;
1359 p6_a22 := ddx_visit_rec.plan_end_min;
1360 p6_a23 := ddx_visit_rec.end_date;
1361 p6_a24 := ddx_visit_rec.due_by_date;
1362 p6_a25 := ddx_visit_rec.visit_type_code;
1363 p6_a26 := ddx_visit_rec.visit_type_name;
1364 p6_a27 := ddx_visit_rec.status_code;
1365 p6_a28 := ddx_visit_rec.status_name;
1366 p6_a29 := ddx_visit_rec.simulation_plan_id;
1367 p6_a30 := ddx_visit_rec.simulation_plan_name;
1368 p6_a31 := ddx_visit_rec.asso_primary_visit_id;
1369 p6_a32 := ddx_visit_rec.unit_name;
1370 p6_a33 := ddx_visit_rec.item_instance_id;
1371 p6_a34 := ddx_visit_rec.serial_number;
1372 p6_a35 := ddx_visit_rec.inventory_item_id;
1373 p6_a36 := ddx_visit_rec.item_organization_id;
1374 p6_a37 := ddx_visit_rec.item_name;
1375 p6_a38 := ddx_visit_rec.simulation_delete_flag;
1376 p6_a39 := ddx_visit_rec.template_flag;
1377 p6_a40 := ddx_visit_rec.out_of_sync_flag;
1378 p6_a41 := ddx_visit_rec.project_flag;
1379 p6_a42 := ddx_visit_rec.project_flag_code;
1380 p6_a43 := ddx_visit_rec.project_id;
1381 p6_a44 := ddx_visit_rec.project_number;
1382 p6_a45 := ddx_visit_rec.description;
1383 p6_a46 := ddx_visit_rec.duration;
1384 p6_a47 := ddx_visit_rec.attribute_category;
1385 p6_a48 := ddx_visit_rec.attribute1;
1386 p6_a49 := ddx_visit_rec.attribute2;
1387 p6_a50 := ddx_visit_rec.attribute3;
1388 p6_a51 := ddx_visit_rec.attribute4;
1389 p6_a52 := ddx_visit_rec.attribute5;
1390 p6_a53 := ddx_visit_rec.attribute6;
1391 p6_a54 := ddx_visit_rec.attribute7;
1392 p6_a55 := ddx_visit_rec.attribute8;
1393 p6_a56 := ddx_visit_rec.attribute9;
1394 p6_a57 := ddx_visit_rec.attribute10;
1395 p6_a58 := ddx_visit_rec.attribute11;
1396 p6_a59 := ddx_visit_rec.attribute12;
1397 p6_a60 := ddx_visit_rec.attribute13;
1398 p6_a61 := ddx_visit_rec.attribute14;
1399 p6_a62 := ddx_visit_rec.attribute15;
1400 p6_a63 := ddx_visit_rec.operation_flag;
1401 p6_a64 := ddx_visit_rec.outside_party_flag;
1402 p6_a65 := ddx_visit_rec.job_number;
1403 p6_a66 := ddx_visit_rec.proj_template_name;
1404 p6_a67 := ddx_visit_rec.proj_template_id;
1405 p6_a68 := ddx_visit_rec.priority_value;
1406 p6_a69 := ddx_visit_rec.priority_code;
1407 p6_a70 := ddx_visit_rec.unit_schedule_id;
1408 p6_a71 := ddx_visit_rec.visit_create_type;
1409 p6_a72 := ddx_visit_rec.visit_create_meaning;
1410 p6_a73 := ddx_visit_rec.unit_header_id;
1411 p6_a74 := ddx_visit_rec.flight_number;
1412 p6_a75 := ddx_visit_rec.project_name;
1413 p6_a76 := ddx_visit_rec.top_project_task_id;
1414 p6_a77 := ddx_visit_rec.subinventory;
1415 p6_a78 := ddx_visit_rec.locator_segment;
1416 p6_a79 := ddx_visit_rec.inv_locator_id;
1417 p6_a80 := ddx_visit_rec.cp_request_id;
1418 p6_a81 := ddx_visit_rec.cp_phase_code;
1419 p6_a82 := ddx_visit_rec.cp_status_code;
1420 p6_a83 := ddx_visit_rec.cp_request_date;
1421 p6_a84 := ddx_visit_rec.jc_exist;
1422 p6_a85 := ddx_visit_rec.view_jc_url;
1423 p6_a86 := ddx_visit_rec.jc_gen_status;
1424 p6_a87 := ddx_visit_rec.jc_gen_error_text;
1425 p6_a88 := ddx_visit_rec.past_dated_visit_flag;
1426 p6_a89 := ddx_visit_rec.locked_flag;
1427 p6_a90 := ddx_visit_rec.firmed_flag;
1428 p6_a91 := ddx_visit_rec.tasks_ovn_updated_count;
1429 p6_a92 := ddx_visit_rec.stages_ovn_updated_count;
1430 p6_a93 := ddx_visit_rec.comp_planning_subinv;
1431 p6_a94 := ddx_visit_rec.comp_planning_loc_seg;
1432 p6_a95 := ddx_visit_rec.comp_planning_loc_id;
1433 p6_a96 := ddx_visit_rec.comp_inrepair_subinv;
1434 p6_a97 := ddx_visit_rec.comp_inrepair_loc_seg;
1435 p6_a98 := ddx_visit_rec.comp_inrepair_loc_id;
1436 p6_a99 := ddx_visit_rec.item_owner_flag;
1437 p6_a100 := ddx_visit_rec.auto_visit_type_flag;
1438
1439
1440
1441 end;
1442
1443 procedure validate_component_visit(p_api_version NUMBER
1444 , p_init_msg_list VARCHAR2
1445 , p_commit VARCHAR2
1446 , p_validation_level NUMBER
1450 , p5_a2 NUMBER
1447 , p_module_type VARCHAR2
1448 , p5_a0 NUMBER
1449 , p5_a1 VARCHAR2
1451 , p5_a3 NUMBER
1452 , p5_a4 DATE
1453 , p5_a5 NUMBER
1454 , p5_a6 DATE
1455 , p5_a7 NUMBER
1456 , p5_a8 NUMBER
1457 , p5_a9 NUMBER
1458 , p5_a10 VARCHAR2
1459 , p5_a11 NUMBER
1460 , p5_a12 VARCHAR2
1461 , p5_a13 NUMBER
1462 , p5_a14 VARCHAR2
1463 , p5_a15 VARCHAR2
1464 , p5_a16 VARCHAR2
1465 , p5_a17 DATE
1466 , p5_a18 NUMBER
1467 , p5_a19 NUMBER
1468 , p5_a20 DATE
1469 , p5_a21 NUMBER
1470 , p5_a22 NUMBER
1471 , p5_a23 DATE
1472 , p5_a24 DATE
1473 , p5_a25 VARCHAR2
1474 , p5_a26 VARCHAR2
1475 , p5_a27 VARCHAR2
1476 , p5_a28 VARCHAR2
1477 , p5_a29 NUMBER
1478 , p5_a30 VARCHAR2
1479 , p5_a31 NUMBER
1480 , p5_a32 VARCHAR2
1481 , p5_a33 NUMBER
1482 , p5_a34 VARCHAR2
1483 , p5_a35 NUMBER
1484 , p5_a36 NUMBER
1485 , p5_a37 VARCHAR2
1486 , p5_a38 VARCHAR2
1487 , p5_a39 VARCHAR2
1488 , p5_a40 VARCHAR2
1489 , p5_a41 VARCHAR2
1490 , p5_a42 VARCHAR2
1491 , p5_a43 NUMBER
1492 , p5_a44 NUMBER
1493 , p5_a45 VARCHAR2
1494 , p5_a46 NUMBER
1495 , p5_a47 VARCHAR2
1496 , p5_a48 VARCHAR2
1497 , p5_a49 VARCHAR2
1498 , p5_a50 VARCHAR2
1499 , p5_a51 VARCHAR2
1500 , p5_a52 VARCHAR2
1501 , p5_a53 VARCHAR2
1502 , p5_a54 VARCHAR2
1503 , p5_a55 VARCHAR2
1504 , p5_a56 VARCHAR2
1505 , p5_a57 VARCHAR2
1506 , p5_a58 VARCHAR2
1507 , p5_a59 VARCHAR2
1508 , p5_a60 VARCHAR2
1509 , p5_a61 VARCHAR2
1510 , p5_a62 VARCHAR2
1511 , p5_a63 VARCHAR2
1512 , p5_a64 VARCHAR2
1513 , p5_a65 VARCHAR2
1514 , p5_a66 VARCHAR2
1515 , p5_a67 NUMBER
1516 , p5_a68 VARCHAR2
1517 , p5_a69 VARCHAR2
1518 , p5_a70 NUMBER
1519 , p5_a71 VARCHAR2
1520 , p5_a72 VARCHAR2
1521 , p5_a73 NUMBER
1522 , p5_a74 VARCHAR2
1523 , p5_a75 VARCHAR2
1524 , p5_a76 NUMBER
1525 , p5_a77 VARCHAR2
1526 , p5_a78 VARCHAR2
1527 , p5_a79 NUMBER
1528 , p5_a80 NUMBER
1529 , p5_a81 VARCHAR2
1530 , p5_a82 VARCHAR2
1531 , p5_a83 DATE
1532 , p5_a84 VARCHAR2
1533 , p5_a85 VARCHAR2
1534 , p5_a86 VARCHAR2
1535 , p5_a87 VARCHAR2
1536 , p5_a88 VARCHAR2
1537 , p5_a89 VARCHAR2
1538 , p5_a90 VARCHAR2
1539 , p5_a91 NUMBER
1540 , p5_a92 NUMBER
1541 , p5_a93 VARCHAR2
1542 , p5_a94 VARCHAR2
1543 , p5_a95 NUMBER
1544 , p5_a96 VARCHAR2
1545 , p5_a97 VARCHAR2
1546 , p5_a98 NUMBER
1547 , p5_a99 VARCHAR2
1548 , p5_a100 VARCHAR2
1549 , x_return_status out nocopy VARCHAR2
1550 , x_msg_count out nocopy NUMBER
1551 , x_msg_data out nocopy VARCHAR2
1552 )
1553
1554 as
1555 ddp_visit_rec ahl_vwp_visits_pvt.visit_rec_type;
1556 ddindx binary_integer; indx binary_integer;
1557 begin
1558
1559 -- copy data to the local IN or IN-OUT args, if any
1560
1561
1562
1563
1564
1565 ddp_visit_rec.visit_id := p5_a0;
1566 ddp_visit_rec.visit_name := p5_a1;
1567 ddp_visit_rec.visit_number := p5_a2;
1568 ddp_visit_rec.object_version_number := p5_a3;
1569 ddp_visit_rec.last_update_date := p5_a4;
1570 ddp_visit_rec.last_updated_by := p5_a5;
1571 ddp_visit_rec.creation_date := p5_a6;
1572 ddp_visit_rec.created_by := p5_a7;
1573 ddp_visit_rec.last_update_login := p5_a8;
1574 ddp_visit_rec.organization_id := p5_a9;
1575 ddp_visit_rec.org_name := p5_a10;
1576 ddp_visit_rec.department_id := p5_a11;
1577 ddp_visit_rec.dept_name := p5_a12;
1578 ddp_visit_rec.service_request_id := p5_a13;
1579 ddp_visit_rec.service_request_number := p5_a14;
1580 ddp_visit_rec.space_category_code := p5_a15;
1581 ddp_visit_rec.space_category_name := p5_a16;
1582 ddp_visit_rec.start_date := p5_a17;
1583 ddp_visit_rec.start_hour := p5_a18;
1584 ddp_visit_rec.start_min := p5_a19;
1585 ddp_visit_rec.plan_end_date := p5_a20;
1586 ddp_visit_rec.plan_end_hour := p5_a21;
1587 ddp_visit_rec.plan_end_min := p5_a22;
1588 ddp_visit_rec.end_date := p5_a23;
1589 ddp_visit_rec.due_by_date := p5_a24;
1590 ddp_visit_rec.visit_type_code := p5_a25;
1591 ddp_visit_rec.visit_type_name := p5_a26;
1592 ddp_visit_rec.status_code := p5_a27;
1593 ddp_visit_rec.status_name := p5_a28;
1594 ddp_visit_rec.simulation_plan_id := p5_a29;
1595 ddp_visit_rec.simulation_plan_name := p5_a30;
1596 ddp_visit_rec.asso_primary_visit_id := p5_a31;
1597 ddp_visit_rec.unit_name := p5_a32;
1598 ddp_visit_rec.item_instance_id := p5_a33;
1599 ddp_visit_rec.serial_number := p5_a34;
1600 ddp_visit_rec.inventory_item_id := p5_a35;
1601 ddp_visit_rec.item_organization_id := p5_a36;
1602 ddp_visit_rec.item_name := p5_a37;
1603 ddp_visit_rec.simulation_delete_flag := p5_a38;
1604 ddp_visit_rec.template_flag := p5_a39;
1605 ddp_visit_rec.out_of_sync_flag := p5_a40;
1606 ddp_visit_rec.project_flag := p5_a41;
1607 ddp_visit_rec.project_flag_code := p5_a42;
1608 ddp_visit_rec.project_id := p5_a43;
1609 ddp_visit_rec.project_number := p5_a44;
1610 ddp_visit_rec.description := p5_a45;
1611 ddp_visit_rec.duration := p5_a46;
1612 ddp_visit_rec.attribute_category := p5_a47;
1613 ddp_visit_rec.attribute1 := p5_a48;
1614 ddp_visit_rec.attribute2 := p5_a49;
1618 ddp_visit_rec.attribute6 := p5_a53;
1615 ddp_visit_rec.attribute3 := p5_a50;
1616 ddp_visit_rec.attribute4 := p5_a51;
1617 ddp_visit_rec.attribute5 := p5_a52;
1619 ddp_visit_rec.attribute7 := p5_a54;
1620 ddp_visit_rec.attribute8 := p5_a55;
1621 ddp_visit_rec.attribute9 := p5_a56;
1622 ddp_visit_rec.attribute10 := p5_a57;
1623 ddp_visit_rec.attribute11 := p5_a58;
1624 ddp_visit_rec.attribute12 := p5_a59;
1625 ddp_visit_rec.attribute13 := p5_a60;
1626 ddp_visit_rec.attribute14 := p5_a61;
1627 ddp_visit_rec.attribute15 := p5_a62;
1628 ddp_visit_rec.operation_flag := p5_a63;
1629 ddp_visit_rec.outside_party_flag := p5_a64;
1630 ddp_visit_rec.job_number := p5_a65;
1631 ddp_visit_rec.proj_template_name := p5_a66;
1632 ddp_visit_rec.proj_template_id := p5_a67;
1633 ddp_visit_rec.priority_value := p5_a68;
1634 ddp_visit_rec.priority_code := p5_a69;
1635 ddp_visit_rec.unit_schedule_id := p5_a70;
1636 ddp_visit_rec.visit_create_type := p5_a71;
1637 ddp_visit_rec.visit_create_meaning := p5_a72;
1638 ddp_visit_rec.unit_header_id := p5_a73;
1639 ddp_visit_rec.flight_number := p5_a74;
1640 ddp_visit_rec.project_name := p5_a75;
1641 ddp_visit_rec.top_project_task_id := p5_a76;
1642 ddp_visit_rec.subinventory := p5_a77;
1643 ddp_visit_rec.locator_segment := p5_a78;
1644 ddp_visit_rec.inv_locator_id := p5_a79;
1645 ddp_visit_rec.cp_request_id := p5_a80;
1646 ddp_visit_rec.cp_phase_code := p5_a81;
1647 ddp_visit_rec.cp_status_code := p5_a82;
1648 ddp_visit_rec.cp_request_date := p5_a83;
1649 ddp_visit_rec.jc_exist := p5_a84;
1650 ddp_visit_rec.view_jc_url := p5_a85;
1651 ddp_visit_rec.jc_gen_status := p5_a86;
1652 ddp_visit_rec.jc_gen_error_text := p5_a87;
1653 ddp_visit_rec.past_dated_visit_flag := p5_a88;
1654 ddp_visit_rec.locked_flag := p5_a89;
1655 ddp_visit_rec.firmed_flag := p5_a90;
1656 ddp_visit_rec.tasks_ovn_updated_count := p5_a91;
1657 ddp_visit_rec.stages_ovn_updated_count := p5_a92;
1658 ddp_visit_rec.comp_planning_subinv := p5_a93;
1659 ddp_visit_rec.comp_planning_loc_seg := p5_a94;
1660 ddp_visit_rec.comp_planning_loc_id := p5_a95;
1661 ddp_visit_rec.comp_inrepair_subinv := p5_a96;
1662 ddp_visit_rec.comp_inrepair_loc_seg := p5_a97;
1663 ddp_visit_rec.comp_inrepair_loc_id := p5_a98;
1664 ddp_visit_rec.item_owner_flag := p5_a99;
1665 ddp_visit_rec.auto_visit_type_flag := p5_a100;
1666
1667
1668
1669
1670 -- here's the delegated call to the old PL/SQL routine
1671 ahl_vwp_visits_pvt.validate_component_visit(p_api_version,
1672 p_init_msg_list,
1673 p_commit,
1674 p_validation_level,
1675 p_module_type,
1676 ddp_visit_rec,
1677 x_return_status,
1678 x_msg_count,
1679 x_msg_data);
1680
1681 -- copy data back from the local variables to OUT or IN-OUT args, if any
1682
1683
1684
1685
1686
1687
1688
1689
1690 end;
1691
1692 procedure create_visit(p_api_version NUMBER
1693 , p_init_msg_list VARCHAR2
1694 , p_commit VARCHAR2
1695 , p_validation_level NUMBER
1696 , p_module_type VARCHAR2
1697 , p5_a0 in out nocopy NUMBER
1698 , p5_a1 in out nocopy VARCHAR2
1699 , p5_a2 in out nocopy NUMBER
1700 , p5_a3 in out nocopy NUMBER
1701 , p5_a4 in out nocopy DATE
1702 , p5_a5 in out nocopy NUMBER
1703 , p5_a6 in out nocopy DATE
1704 , p5_a7 in out nocopy NUMBER
1705 , p5_a8 in out nocopy NUMBER
1706 , p5_a9 in out nocopy NUMBER
1707 , p5_a10 in out nocopy VARCHAR2
1708 , p5_a11 in out nocopy NUMBER
1709 , p5_a12 in out nocopy VARCHAR2
1710 , p5_a13 in out nocopy NUMBER
1711 , p5_a14 in out nocopy VARCHAR2
1712 , p5_a15 in out nocopy VARCHAR2
1713 , p5_a16 in out nocopy VARCHAR2
1714 , p5_a17 in out nocopy DATE
1715 , p5_a18 in out nocopy NUMBER
1716 , p5_a19 in out nocopy NUMBER
1717 , p5_a20 in out nocopy DATE
1718 , p5_a21 in out nocopy NUMBER
1719 , p5_a22 in out nocopy NUMBER
1720 , p5_a23 in out nocopy DATE
1721 , p5_a24 in out nocopy DATE
1722 , p5_a25 in out nocopy VARCHAR2
1723 , p5_a26 in out nocopy VARCHAR2
1724 , p5_a27 in out nocopy VARCHAR2
1725 , p5_a28 in out nocopy VARCHAR2
1726 , p5_a29 in out nocopy NUMBER
1727 , p5_a30 in out nocopy VARCHAR2
1728 , p5_a31 in out nocopy NUMBER
1729 , p5_a32 in out nocopy VARCHAR2
1730 , p5_a33 in out nocopy NUMBER
1731 , p5_a34 in out nocopy VARCHAR2
1732 , p5_a35 in out nocopy NUMBER
1733 , p5_a36 in out nocopy NUMBER
1734 , p5_a37 in out nocopy VARCHAR2
1735 , p5_a38 in out nocopy VARCHAR2
1736 , p5_a39 in out nocopy VARCHAR2
1737 , p5_a40 in out nocopy VARCHAR2
1738 , p5_a41 in out nocopy VARCHAR2
1739 , p5_a42 in out nocopy VARCHAR2
1740 , p5_a43 in out nocopy NUMBER
1741 , p5_a44 in out nocopy NUMBER
1742 , p5_a45 in out nocopy VARCHAR2
1743 , p5_a46 in out nocopy NUMBER
1744 , p5_a47 in out nocopy VARCHAR2
1745 , p5_a48 in out nocopy VARCHAR2
1746 , p5_a49 in out nocopy VARCHAR2
1747 , p5_a50 in out nocopy VARCHAR2
1748 , p5_a51 in out nocopy VARCHAR2
1749 , p5_a52 in out nocopy VARCHAR2
1750 , p5_a53 in out nocopy VARCHAR2
1751 , p5_a54 in out nocopy VARCHAR2
1752 , p5_a55 in out nocopy VARCHAR2
1753 , p5_a56 in out nocopy VARCHAR2
1754 , p5_a57 in out nocopy VARCHAR2
1755 , p5_a58 in out nocopy VARCHAR2
1756 , p5_a59 in out nocopy VARCHAR2
1757 , p5_a60 in out nocopy VARCHAR2
1758 , p5_a61 in out nocopy VARCHAR2
1759 , p5_a62 in out nocopy VARCHAR2
1763 , p5_a66 in out nocopy VARCHAR2
1760 , p5_a63 in out nocopy VARCHAR2
1761 , p5_a64 in out nocopy VARCHAR2
1762 , p5_a65 in out nocopy VARCHAR2
1764 , p5_a67 in out nocopy NUMBER
1765 , p5_a68 in out nocopy VARCHAR2
1766 , p5_a69 in out nocopy VARCHAR2
1767 , p5_a70 in out nocopy NUMBER
1768 , p5_a71 in out nocopy VARCHAR2
1769 , p5_a72 in out nocopy VARCHAR2
1770 , p5_a73 in out nocopy NUMBER
1771 , p5_a74 in out nocopy VARCHAR2
1772 , p5_a75 in out nocopy VARCHAR2
1773 , p5_a76 in out nocopy NUMBER
1774 , p5_a77 in out nocopy VARCHAR2
1775 , p5_a78 in out nocopy VARCHAR2
1776 , p5_a79 in out nocopy NUMBER
1777 , p5_a80 in out nocopy NUMBER
1778 , p5_a81 in out nocopy VARCHAR2
1779 , p5_a82 in out nocopy VARCHAR2
1780 , p5_a83 in out nocopy DATE
1781 , p5_a84 in out nocopy VARCHAR2
1782 , p5_a85 in out nocopy VARCHAR2
1783 , p5_a86 in out nocopy VARCHAR2
1784 , p5_a87 in out nocopy VARCHAR2
1785 , p5_a88 in out nocopy VARCHAR2
1786 , p5_a89 in out nocopy VARCHAR2
1787 , p5_a90 in out nocopy VARCHAR2
1788 , p5_a91 in out nocopy NUMBER
1789 , p5_a92 in out nocopy NUMBER
1790 , p5_a93 in out nocopy VARCHAR2
1791 , p5_a94 in out nocopy VARCHAR2
1792 , p5_a95 in out nocopy NUMBER
1793 , p5_a96 in out nocopy VARCHAR2
1794 , p5_a97 in out nocopy VARCHAR2
1795 , p5_a98 in out nocopy NUMBER
1796 , p5_a99 in out nocopy VARCHAR2
1797 , p5_a100 in out nocopy VARCHAR2
1798 , x_return_status out nocopy VARCHAR2
1799 , x_msg_count out nocopy NUMBER
1800 , x_msg_data out nocopy VARCHAR2
1801 )
1802
1803 as
1804 ddp_x_visit_rec ahl_vwp_visits_pvt.visit_rec_type;
1805 ddindx binary_integer; indx binary_integer;
1806 begin
1807
1808 -- copy data to the local IN or IN-OUT args, if any
1809
1810
1811
1812
1813
1814 ddp_x_visit_rec.visit_id := p5_a0;
1815 ddp_x_visit_rec.visit_name := p5_a1;
1816 ddp_x_visit_rec.visit_number := p5_a2;
1817 ddp_x_visit_rec.object_version_number := p5_a3;
1818 ddp_x_visit_rec.last_update_date := p5_a4;
1819 ddp_x_visit_rec.last_updated_by := p5_a5;
1820 ddp_x_visit_rec.creation_date := p5_a6;
1821 ddp_x_visit_rec.created_by := p5_a7;
1822 ddp_x_visit_rec.last_update_login := p5_a8;
1823 ddp_x_visit_rec.organization_id := p5_a9;
1824 ddp_x_visit_rec.org_name := p5_a10;
1825 ddp_x_visit_rec.department_id := p5_a11;
1826 ddp_x_visit_rec.dept_name := p5_a12;
1827 ddp_x_visit_rec.service_request_id := p5_a13;
1828 ddp_x_visit_rec.service_request_number := p5_a14;
1829 ddp_x_visit_rec.space_category_code := p5_a15;
1830 ddp_x_visit_rec.space_category_name := p5_a16;
1831 ddp_x_visit_rec.start_date := p5_a17;
1832 ddp_x_visit_rec.start_hour := p5_a18;
1833 ddp_x_visit_rec.start_min := p5_a19;
1834 ddp_x_visit_rec.plan_end_date := p5_a20;
1835 ddp_x_visit_rec.plan_end_hour := p5_a21;
1836 ddp_x_visit_rec.plan_end_min := p5_a22;
1837 ddp_x_visit_rec.end_date := p5_a23;
1838 ddp_x_visit_rec.due_by_date := p5_a24;
1839 ddp_x_visit_rec.visit_type_code := p5_a25;
1840 ddp_x_visit_rec.visit_type_name := p5_a26;
1841 ddp_x_visit_rec.status_code := p5_a27;
1842 ddp_x_visit_rec.status_name := p5_a28;
1843 ddp_x_visit_rec.simulation_plan_id := p5_a29;
1844 ddp_x_visit_rec.simulation_plan_name := p5_a30;
1845 ddp_x_visit_rec.asso_primary_visit_id := p5_a31;
1846 ddp_x_visit_rec.unit_name := p5_a32;
1847 ddp_x_visit_rec.item_instance_id := p5_a33;
1848 ddp_x_visit_rec.serial_number := p5_a34;
1849 ddp_x_visit_rec.inventory_item_id := p5_a35;
1850 ddp_x_visit_rec.item_organization_id := p5_a36;
1851 ddp_x_visit_rec.item_name := p5_a37;
1852 ddp_x_visit_rec.simulation_delete_flag := p5_a38;
1853 ddp_x_visit_rec.template_flag := p5_a39;
1854 ddp_x_visit_rec.out_of_sync_flag := p5_a40;
1855 ddp_x_visit_rec.project_flag := p5_a41;
1856 ddp_x_visit_rec.project_flag_code := p5_a42;
1857 ddp_x_visit_rec.project_id := p5_a43;
1858 ddp_x_visit_rec.project_number := p5_a44;
1859 ddp_x_visit_rec.description := p5_a45;
1860 ddp_x_visit_rec.duration := p5_a46;
1861 ddp_x_visit_rec.attribute_category := p5_a47;
1862 ddp_x_visit_rec.attribute1 := p5_a48;
1863 ddp_x_visit_rec.attribute2 := p5_a49;
1864 ddp_x_visit_rec.attribute3 := p5_a50;
1865 ddp_x_visit_rec.attribute4 := p5_a51;
1866 ddp_x_visit_rec.attribute5 := p5_a52;
1867 ddp_x_visit_rec.attribute6 := p5_a53;
1868 ddp_x_visit_rec.attribute7 := p5_a54;
1869 ddp_x_visit_rec.attribute8 := p5_a55;
1870 ddp_x_visit_rec.attribute9 := p5_a56;
1871 ddp_x_visit_rec.attribute10 := p5_a57;
1872 ddp_x_visit_rec.attribute11 := p5_a58;
1873 ddp_x_visit_rec.attribute12 := p5_a59;
1874 ddp_x_visit_rec.attribute13 := p5_a60;
1875 ddp_x_visit_rec.attribute14 := p5_a61;
1876 ddp_x_visit_rec.attribute15 := p5_a62;
1877 ddp_x_visit_rec.operation_flag := p5_a63;
1878 ddp_x_visit_rec.outside_party_flag := p5_a64;
1879 ddp_x_visit_rec.job_number := p5_a65;
1880 ddp_x_visit_rec.proj_template_name := p5_a66;
1881 ddp_x_visit_rec.proj_template_id := p5_a67;
1882 ddp_x_visit_rec.priority_value := p5_a68;
1883 ddp_x_visit_rec.priority_code := p5_a69;
1884 ddp_x_visit_rec.unit_schedule_id := p5_a70;
1885 ddp_x_visit_rec.visit_create_type := p5_a71;
1886 ddp_x_visit_rec.visit_create_meaning := p5_a72;
1887 ddp_x_visit_rec.unit_header_id := p5_a73;
1888 ddp_x_visit_rec.flight_number := p5_a74;
1889 ddp_x_visit_rec.project_name := p5_a75;
1890 ddp_x_visit_rec.top_project_task_id := p5_a76;
1891 ddp_x_visit_rec.subinventory := p5_a77;
1892 ddp_x_visit_rec.locator_segment := p5_a78;
1896 ddp_x_visit_rec.cp_status_code := p5_a82;
1893 ddp_x_visit_rec.inv_locator_id := p5_a79;
1894 ddp_x_visit_rec.cp_request_id := p5_a80;
1895 ddp_x_visit_rec.cp_phase_code := p5_a81;
1897 ddp_x_visit_rec.cp_request_date := p5_a83;
1898 ddp_x_visit_rec.jc_exist := p5_a84;
1899 ddp_x_visit_rec.view_jc_url := p5_a85;
1900 ddp_x_visit_rec.jc_gen_status := p5_a86;
1901 ddp_x_visit_rec.jc_gen_error_text := p5_a87;
1902 ddp_x_visit_rec.past_dated_visit_flag := p5_a88;
1903 ddp_x_visit_rec.locked_flag := p5_a89;
1904 ddp_x_visit_rec.firmed_flag := p5_a90;
1905 ddp_x_visit_rec.tasks_ovn_updated_count := p5_a91;
1906 ddp_x_visit_rec.stages_ovn_updated_count := p5_a92;
1907 ddp_x_visit_rec.comp_planning_subinv := p5_a93;
1908 ddp_x_visit_rec.comp_planning_loc_seg := p5_a94;
1909 ddp_x_visit_rec.comp_planning_loc_id := p5_a95;
1910 ddp_x_visit_rec.comp_inrepair_subinv := p5_a96;
1911 ddp_x_visit_rec.comp_inrepair_loc_seg := p5_a97;
1912 ddp_x_visit_rec.comp_inrepair_loc_id := p5_a98;
1913 ddp_x_visit_rec.item_owner_flag := p5_a99;
1914 ddp_x_visit_rec.auto_visit_type_flag := p5_a100;
1915
1916
1917
1918
1919 -- here's the delegated call to the old PL/SQL routine
1920 ahl_vwp_visits_pvt.create_visit(p_api_version,
1921 p_init_msg_list,
1922 p_commit,
1923 p_validation_level,
1924 p_module_type,
1925 ddp_x_visit_rec,
1926 x_return_status,
1927 x_msg_count,
1928 x_msg_data);
1929
1930 -- copy data back from the local variables to OUT or IN-OUT args, if any
1931
1932
1933
1934
1935
1936 p5_a0 := ddp_x_visit_rec.visit_id;
1937 p5_a1 := ddp_x_visit_rec.visit_name;
1938 p5_a2 := ddp_x_visit_rec.visit_number;
1939 p5_a3 := ddp_x_visit_rec.object_version_number;
1940 p5_a4 := ddp_x_visit_rec.last_update_date;
1941 p5_a5 := ddp_x_visit_rec.last_updated_by;
1942 p5_a6 := ddp_x_visit_rec.creation_date;
1943 p5_a7 := ddp_x_visit_rec.created_by;
1944 p5_a8 := ddp_x_visit_rec.last_update_login;
1945 p5_a9 := ddp_x_visit_rec.organization_id;
1946 p5_a10 := ddp_x_visit_rec.org_name;
1947 p5_a11 := ddp_x_visit_rec.department_id;
1948 p5_a12 := ddp_x_visit_rec.dept_name;
1949 p5_a13 := ddp_x_visit_rec.service_request_id;
1950 p5_a14 := ddp_x_visit_rec.service_request_number;
1951 p5_a15 := ddp_x_visit_rec.space_category_code;
1952 p5_a16 := ddp_x_visit_rec.space_category_name;
1953 p5_a17 := ddp_x_visit_rec.start_date;
1954 p5_a18 := ddp_x_visit_rec.start_hour;
1955 p5_a19 := ddp_x_visit_rec.start_min;
1956 p5_a20 := ddp_x_visit_rec.plan_end_date;
1957 p5_a21 := ddp_x_visit_rec.plan_end_hour;
1958 p5_a22 := ddp_x_visit_rec.plan_end_min;
1959 p5_a23 := ddp_x_visit_rec.end_date;
1960 p5_a24 := ddp_x_visit_rec.due_by_date;
1961 p5_a25 := ddp_x_visit_rec.visit_type_code;
1962 p5_a26 := ddp_x_visit_rec.visit_type_name;
1963 p5_a27 := ddp_x_visit_rec.status_code;
1964 p5_a28 := ddp_x_visit_rec.status_name;
1965 p5_a29 := ddp_x_visit_rec.simulation_plan_id;
1966 p5_a30 := ddp_x_visit_rec.simulation_plan_name;
1967 p5_a31 := ddp_x_visit_rec.asso_primary_visit_id;
1968 p5_a32 := ddp_x_visit_rec.unit_name;
1969 p5_a33 := ddp_x_visit_rec.item_instance_id;
1970 p5_a34 := ddp_x_visit_rec.serial_number;
1971 p5_a35 := ddp_x_visit_rec.inventory_item_id;
1972 p5_a36 := ddp_x_visit_rec.item_organization_id;
1973 p5_a37 := ddp_x_visit_rec.item_name;
1974 p5_a38 := ddp_x_visit_rec.simulation_delete_flag;
1975 p5_a39 := ddp_x_visit_rec.template_flag;
1976 p5_a40 := ddp_x_visit_rec.out_of_sync_flag;
1977 p5_a41 := ddp_x_visit_rec.project_flag;
1978 p5_a42 := ddp_x_visit_rec.project_flag_code;
1979 p5_a43 := ddp_x_visit_rec.project_id;
1980 p5_a44 := ddp_x_visit_rec.project_number;
1981 p5_a45 := ddp_x_visit_rec.description;
1982 p5_a46 := ddp_x_visit_rec.duration;
1983 p5_a47 := ddp_x_visit_rec.attribute_category;
1984 p5_a48 := ddp_x_visit_rec.attribute1;
1985 p5_a49 := ddp_x_visit_rec.attribute2;
1986 p5_a50 := ddp_x_visit_rec.attribute3;
1987 p5_a51 := ddp_x_visit_rec.attribute4;
1988 p5_a52 := ddp_x_visit_rec.attribute5;
1989 p5_a53 := ddp_x_visit_rec.attribute6;
1990 p5_a54 := ddp_x_visit_rec.attribute7;
1991 p5_a55 := ddp_x_visit_rec.attribute8;
1992 p5_a56 := ddp_x_visit_rec.attribute9;
1993 p5_a57 := ddp_x_visit_rec.attribute10;
1994 p5_a58 := ddp_x_visit_rec.attribute11;
1995 p5_a59 := ddp_x_visit_rec.attribute12;
1996 p5_a60 := ddp_x_visit_rec.attribute13;
1997 p5_a61 := ddp_x_visit_rec.attribute14;
1998 p5_a62 := ddp_x_visit_rec.attribute15;
1999 p5_a63 := ddp_x_visit_rec.operation_flag;
2000 p5_a64 := ddp_x_visit_rec.outside_party_flag;
2001 p5_a65 := ddp_x_visit_rec.job_number;
2002 p5_a66 := ddp_x_visit_rec.proj_template_name;
2003 p5_a67 := ddp_x_visit_rec.proj_template_id;
2004 p5_a68 := ddp_x_visit_rec.priority_value;
2005 p5_a69 := ddp_x_visit_rec.priority_code;
2006 p5_a70 := ddp_x_visit_rec.unit_schedule_id;
2007 p5_a71 := ddp_x_visit_rec.visit_create_type;
2008 p5_a72 := ddp_x_visit_rec.visit_create_meaning;
2009 p5_a73 := ddp_x_visit_rec.unit_header_id;
2010 p5_a74 := ddp_x_visit_rec.flight_number;
2011 p5_a75 := ddp_x_visit_rec.project_name;
2012 p5_a76 := ddp_x_visit_rec.top_project_task_id;
2013 p5_a77 := ddp_x_visit_rec.subinventory;
2014 p5_a78 := ddp_x_visit_rec.locator_segment;
2015 p5_a79 := ddp_x_visit_rec.inv_locator_id;
2016 p5_a80 := ddp_x_visit_rec.cp_request_id;
2017 p5_a81 := ddp_x_visit_rec.cp_phase_code;
2018 p5_a82 := ddp_x_visit_rec.cp_status_code;
2019 p5_a83 := ddp_x_visit_rec.cp_request_date;
2020 p5_a84 := ddp_x_visit_rec.jc_exist;
2021 p5_a85 := ddp_x_visit_rec.view_jc_url;
2025 p5_a89 := ddp_x_visit_rec.locked_flag;
2022 p5_a86 := ddp_x_visit_rec.jc_gen_status;
2023 p5_a87 := ddp_x_visit_rec.jc_gen_error_text;
2024 p5_a88 := ddp_x_visit_rec.past_dated_visit_flag;
2026 p5_a90 := ddp_x_visit_rec.firmed_flag;
2027 p5_a91 := ddp_x_visit_rec.tasks_ovn_updated_count;
2028 p5_a92 := ddp_x_visit_rec.stages_ovn_updated_count;
2029 p5_a93 := ddp_x_visit_rec.comp_planning_subinv;
2030 p5_a94 := ddp_x_visit_rec.comp_planning_loc_seg;
2031 p5_a95 := ddp_x_visit_rec.comp_planning_loc_id;
2032 p5_a96 := ddp_x_visit_rec.comp_inrepair_subinv;
2033 p5_a97 := ddp_x_visit_rec.comp_inrepair_loc_seg;
2034 p5_a98 := ddp_x_visit_rec.comp_inrepair_loc_id;
2035 p5_a99 := ddp_x_visit_rec.item_owner_flag;
2036 p5_a100 := ddp_x_visit_rec.auto_visit_type_flag;
2037
2038
2039
2040 end;
2041
2042 procedure update_visit(p_api_version NUMBER
2043 , p_init_msg_list VARCHAR2
2044 , p_commit VARCHAR2
2045 , p_validation_level NUMBER
2046 , p_module_type VARCHAR2
2047 , p5_a0 in out nocopy NUMBER
2048 , p5_a1 in out nocopy VARCHAR2
2049 , p5_a2 in out nocopy NUMBER
2050 , p5_a3 in out nocopy NUMBER
2051 , p5_a4 in out nocopy DATE
2052 , p5_a5 in out nocopy NUMBER
2053 , p5_a6 in out nocopy DATE
2054 , p5_a7 in out nocopy NUMBER
2055 , p5_a8 in out nocopy NUMBER
2056 , p5_a9 in out nocopy NUMBER
2057 , p5_a10 in out nocopy VARCHAR2
2058 , p5_a11 in out nocopy NUMBER
2059 , p5_a12 in out nocopy VARCHAR2
2060 , p5_a13 in out nocopy NUMBER
2061 , p5_a14 in out nocopy VARCHAR2
2062 , p5_a15 in out nocopy VARCHAR2
2063 , p5_a16 in out nocopy VARCHAR2
2064 , p5_a17 in out nocopy DATE
2065 , p5_a18 in out nocopy NUMBER
2066 , p5_a19 in out nocopy NUMBER
2067 , p5_a20 in out nocopy DATE
2068 , p5_a21 in out nocopy NUMBER
2069 , p5_a22 in out nocopy NUMBER
2070 , p5_a23 in out nocopy DATE
2071 , p5_a24 in out nocopy DATE
2072 , p5_a25 in out nocopy VARCHAR2
2073 , p5_a26 in out nocopy VARCHAR2
2074 , p5_a27 in out nocopy VARCHAR2
2075 , p5_a28 in out nocopy VARCHAR2
2076 , p5_a29 in out nocopy NUMBER
2077 , p5_a30 in out nocopy VARCHAR2
2078 , p5_a31 in out nocopy NUMBER
2079 , p5_a32 in out nocopy VARCHAR2
2080 , p5_a33 in out nocopy NUMBER
2081 , p5_a34 in out nocopy VARCHAR2
2082 , p5_a35 in out nocopy NUMBER
2083 , p5_a36 in out nocopy NUMBER
2084 , p5_a37 in out nocopy VARCHAR2
2085 , p5_a38 in out nocopy VARCHAR2
2086 , p5_a39 in out nocopy VARCHAR2
2087 , p5_a40 in out nocopy VARCHAR2
2088 , p5_a41 in out nocopy VARCHAR2
2089 , p5_a42 in out nocopy VARCHAR2
2090 , p5_a43 in out nocopy NUMBER
2091 , p5_a44 in out nocopy NUMBER
2092 , p5_a45 in out nocopy VARCHAR2
2093 , p5_a46 in out nocopy NUMBER
2094 , p5_a47 in out nocopy VARCHAR2
2095 , p5_a48 in out nocopy VARCHAR2
2096 , p5_a49 in out nocopy VARCHAR2
2097 , p5_a50 in out nocopy VARCHAR2
2098 , p5_a51 in out nocopy VARCHAR2
2099 , p5_a52 in out nocopy VARCHAR2
2100 , p5_a53 in out nocopy VARCHAR2
2101 , p5_a54 in out nocopy VARCHAR2
2102 , p5_a55 in out nocopy VARCHAR2
2103 , p5_a56 in out nocopy VARCHAR2
2104 , p5_a57 in out nocopy VARCHAR2
2105 , p5_a58 in out nocopy VARCHAR2
2106 , p5_a59 in out nocopy VARCHAR2
2107 , p5_a60 in out nocopy VARCHAR2
2108 , p5_a61 in out nocopy VARCHAR2
2109 , p5_a62 in out nocopy VARCHAR2
2110 , p5_a63 in out nocopy VARCHAR2
2111 , p5_a64 in out nocopy VARCHAR2
2112 , p5_a65 in out nocopy VARCHAR2
2113 , p5_a66 in out nocopy VARCHAR2
2114 , p5_a67 in out nocopy NUMBER
2115 , p5_a68 in out nocopy VARCHAR2
2116 , p5_a69 in out nocopy VARCHAR2
2117 , p5_a70 in out nocopy NUMBER
2118 , p5_a71 in out nocopy VARCHAR2
2119 , p5_a72 in out nocopy VARCHAR2
2120 , p5_a73 in out nocopy NUMBER
2121 , p5_a74 in out nocopy VARCHAR2
2122 , p5_a75 in out nocopy VARCHAR2
2123 , p5_a76 in out nocopy NUMBER
2124 , p5_a77 in out nocopy VARCHAR2
2125 , p5_a78 in out nocopy VARCHAR2
2126 , p5_a79 in out nocopy NUMBER
2127 , p5_a80 in out nocopy NUMBER
2128 , p5_a81 in out nocopy VARCHAR2
2129 , p5_a82 in out nocopy VARCHAR2
2130 , p5_a83 in out nocopy DATE
2131 , p5_a84 in out nocopy VARCHAR2
2132 , p5_a85 in out nocopy VARCHAR2
2133 , p5_a86 in out nocopy VARCHAR2
2134 , p5_a87 in out nocopy VARCHAR2
2135 , p5_a88 in out nocopy VARCHAR2
2136 , p5_a89 in out nocopy VARCHAR2
2137 , p5_a90 in out nocopy VARCHAR2
2138 , p5_a91 in out nocopy NUMBER
2139 , p5_a92 in out nocopy NUMBER
2140 , p5_a93 in out nocopy VARCHAR2
2141 , p5_a94 in out nocopy VARCHAR2
2142 , p5_a95 in out nocopy NUMBER
2143 , p5_a96 in out nocopy VARCHAR2
2144 , p5_a97 in out nocopy VARCHAR2
2145 , p5_a98 in out nocopy NUMBER
2146 , p5_a99 in out nocopy VARCHAR2
2147 , p5_a100 in out nocopy VARCHAR2
2148 , x_return_status out nocopy VARCHAR2
2149 , x_msg_count out nocopy NUMBER
2150 , x_msg_data out nocopy VARCHAR2
2151 )
2152
2153 as
2154 ddp_x_visit_rec ahl_vwp_visits_pvt.visit_rec_type;
2155 ddindx binary_integer; indx binary_integer;
2156 begin
2157
2158 -- copy data to the local IN or IN-OUT args, if any
2159
2160
2161
2162
2163
2164 ddp_x_visit_rec.visit_id := p5_a0;
2165 ddp_x_visit_rec.visit_name := p5_a1;
2166 ddp_x_visit_rec.visit_number := p5_a2;
2167 ddp_x_visit_rec.object_version_number := p5_a3;
2171 ddp_x_visit_rec.created_by := p5_a7;
2168 ddp_x_visit_rec.last_update_date := p5_a4;
2169 ddp_x_visit_rec.last_updated_by := p5_a5;
2170 ddp_x_visit_rec.creation_date := p5_a6;
2172 ddp_x_visit_rec.last_update_login := p5_a8;
2173 ddp_x_visit_rec.organization_id := p5_a9;
2174 ddp_x_visit_rec.org_name := p5_a10;
2175 ddp_x_visit_rec.department_id := p5_a11;
2176 ddp_x_visit_rec.dept_name := p5_a12;
2177 ddp_x_visit_rec.service_request_id := p5_a13;
2178 ddp_x_visit_rec.service_request_number := p5_a14;
2179 ddp_x_visit_rec.space_category_code := p5_a15;
2180 ddp_x_visit_rec.space_category_name := p5_a16;
2181 ddp_x_visit_rec.start_date := p5_a17;
2182 ddp_x_visit_rec.start_hour := p5_a18;
2183 ddp_x_visit_rec.start_min := p5_a19;
2184 ddp_x_visit_rec.plan_end_date := p5_a20;
2185 ddp_x_visit_rec.plan_end_hour := p5_a21;
2186 ddp_x_visit_rec.plan_end_min := p5_a22;
2187 ddp_x_visit_rec.end_date := p5_a23;
2188 ddp_x_visit_rec.due_by_date := p5_a24;
2189 ddp_x_visit_rec.visit_type_code := p5_a25;
2190 ddp_x_visit_rec.visit_type_name := p5_a26;
2191 ddp_x_visit_rec.status_code := p5_a27;
2192 ddp_x_visit_rec.status_name := p5_a28;
2193 ddp_x_visit_rec.simulation_plan_id := p5_a29;
2194 ddp_x_visit_rec.simulation_plan_name := p5_a30;
2195 ddp_x_visit_rec.asso_primary_visit_id := p5_a31;
2196 ddp_x_visit_rec.unit_name := p5_a32;
2197 ddp_x_visit_rec.item_instance_id := p5_a33;
2198 ddp_x_visit_rec.serial_number := p5_a34;
2199 ddp_x_visit_rec.inventory_item_id := p5_a35;
2200 ddp_x_visit_rec.item_organization_id := p5_a36;
2201 ddp_x_visit_rec.item_name := p5_a37;
2202 ddp_x_visit_rec.simulation_delete_flag := p5_a38;
2203 ddp_x_visit_rec.template_flag := p5_a39;
2204 ddp_x_visit_rec.out_of_sync_flag := p5_a40;
2205 ddp_x_visit_rec.project_flag := p5_a41;
2206 ddp_x_visit_rec.project_flag_code := p5_a42;
2207 ddp_x_visit_rec.project_id := p5_a43;
2208 ddp_x_visit_rec.project_number := p5_a44;
2209 ddp_x_visit_rec.description := p5_a45;
2210 ddp_x_visit_rec.duration := p5_a46;
2211 ddp_x_visit_rec.attribute_category := p5_a47;
2212 ddp_x_visit_rec.attribute1 := p5_a48;
2213 ddp_x_visit_rec.attribute2 := p5_a49;
2214 ddp_x_visit_rec.attribute3 := p5_a50;
2215 ddp_x_visit_rec.attribute4 := p5_a51;
2216 ddp_x_visit_rec.attribute5 := p5_a52;
2217 ddp_x_visit_rec.attribute6 := p5_a53;
2218 ddp_x_visit_rec.attribute7 := p5_a54;
2219 ddp_x_visit_rec.attribute8 := p5_a55;
2220 ddp_x_visit_rec.attribute9 := p5_a56;
2221 ddp_x_visit_rec.attribute10 := p5_a57;
2222 ddp_x_visit_rec.attribute11 := p5_a58;
2223 ddp_x_visit_rec.attribute12 := p5_a59;
2224 ddp_x_visit_rec.attribute13 := p5_a60;
2225 ddp_x_visit_rec.attribute14 := p5_a61;
2226 ddp_x_visit_rec.attribute15 := p5_a62;
2227 ddp_x_visit_rec.operation_flag := p5_a63;
2228 ddp_x_visit_rec.outside_party_flag := p5_a64;
2229 ddp_x_visit_rec.job_number := p5_a65;
2230 ddp_x_visit_rec.proj_template_name := p5_a66;
2231 ddp_x_visit_rec.proj_template_id := p5_a67;
2232 ddp_x_visit_rec.priority_value := p5_a68;
2233 ddp_x_visit_rec.priority_code := p5_a69;
2234 ddp_x_visit_rec.unit_schedule_id := p5_a70;
2235 ddp_x_visit_rec.visit_create_type := p5_a71;
2236 ddp_x_visit_rec.visit_create_meaning := p5_a72;
2237 ddp_x_visit_rec.unit_header_id := p5_a73;
2238 ddp_x_visit_rec.flight_number := p5_a74;
2239 ddp_x_visit_rec.project_name := p5_a75;
2240 ddp_x_visit_rec.top_project_task_id := p5_a76;
2241 ddp_x_visit_rec.subinventory := p5_a77;
2242 ddp_x_visit_rec.locator_segment := p5_a78;
2243 ddp_x_visit_rec.inv_locator_id := p5_a79;
2244 ddp_x_visit_rec.cp_request_id := p5_a80;
2245 ddp_x_visit_rec.cp_phase_code := p5_a81;
2246 ddp_x_visit_rec.cp_status_code := p5_a82;
2247 ddp_x_visit_rec.cp_request_date := p5_a83;
2248 ddp_x_visit_rec.jc_exist := p5_a84;
2249 ddp_x_visit_rec.view_jc_url := p5_a85;
2250 ddp_x_visit_rec.jc_gen_status := p5_a86;
2251 ddp_x_visit_rec.jc_gen_error_text := p5_a87;
2252 ddp_x_visit_rec.past_dated_visit_flag := p5_a88;
2253 ddp_x_visit_rec.locked_flag := p5_a89;
2254 ddp_x_visit_rec.firmed_flag := p5_a90;
2255 ddp_x_visit_rec.tasks_ovn_updated_count := p5_a91;
2256 ddp_x_visit_rec.stages_ovn_updated_count := p5_a92;
2257 ddp_x_visit_rec.comp_planning_subinv := p5_a93;
2258 ddp_x_visit_rec.comp_planning_loc_seg := p5_a94;
2259 ddp_x_visit_rec.comp_planning_loc_id := p5_a95;
2260 ddp_x_visit_rec.comp_inrepair_subinv := p5_a96;
2261 ddp_x_visit_rec.comp_inrepair_loc_seg := p5_a97;
2262 ddp_x_visit_rec.comp_inrepair_loc_id := p5_a98;
2263 ddp_x_visit_rec.item_owner_flag := p5_a99;
2264 ddp_x_visit_rec.auto_visit_type_flag := p5_a100;
2265
2266
2267
2268
2269 -- here's the delegated call to the old PL/SQL routine
2270 ahl_vwp_visits_pvt.update_visit(p_api_version,
2271 p_init_msg_list,
2272 p_commit,
2273 p_validation_level,
2274 p_module_type,
2275 ddp_x_visit_rec,
2276 x_return_status,
2277 x_msg_count,
2278 x_msg_data);
2279
2280 -- copy data back from the local variables to OUT or IN-OUT args, if any
2281
2282
2283
2284
2285
2286 p5_a0 := ddp_x_visit_rec.visit_id;
2287 p5_a1 := ddp_x_visit_rec.visit_name;
2288 p5_a2 := ddp_x_visit_rec.visit_number;
2289 p5_a3 := ddp_x_visit_rec.object_version_number;
2290 p5_a4 := ddp_x_visit_rec.last_update_date;
2291 p5_a5 := ddp_x_visit_rec.last_updated_by;
2292 p5_a6 := ddp_x_visit_rec.creation_date;
2293 p5_a7 := ddp_x_visit_rec.created_by;
2294 p5_a8 := ddp_x_visit_rec.last_update_login;
2295 p5_a9 := ddp_x_visit_rec.organization_id;
2296 p5_a10 := ddp_x_visit_rec.org_name;
2300 p5_a14 := ddp_x_visit_rec.service_request_number;
2297 p5_a11 := ddp_x_visit_rec.department_id;
2298 p5_a12 := ddp_x_visit_rec.dept_name;
2299 p5_a13 := ddp_x_visit_rec.service_request_id;
2301 p5_a15 := ddp_x_visit_rec.space_category_code;
2302 p5_a16 := ddp_x_visit_rec.space_category_name;
2303 p5_a17 := ddp_x_visit_rec.start_date;
2304 p5_a18 := ddp_x_visit_rec.start_hour;
2305 p5_a19 := ddp_x_visit_rec.start_min;
2306 p5_a20 := ddp_x_visit_rec.plan_end_date;
2307 p5_a21 := ddp_x_visit_rec.plan_end_hour;
2308 p5_a22 := ddp_x_visit_rec.plan_end_min;
2309 p5_a23 := ddp_x_visit_rec.end_date;
2310 p5_a24 := ddp_x_visit_rec.due_by_date;
2311 p5_a25 := ddp_x_visit_rec.visit_type_code;
2312 p5_a26 := ddp_x_visit_rec.visit_type_name;
2313 p5_a27 := ddp_x_visit_rec.status_code;
2314 p5_a28 := ddp_x_visit_rec.status_name;
2315 p5_a29 := ddp_x_visit_rec.simulation_plan_id;
2316 p5_a30 := ddp_x_visit_rec.simulation_plan_name;
2317 p5_a31 := ddp_x_visit_rec.asso_primary_visit_id;
2318 p5_a32 := ddp_x_visit_rec.unit_name;
2319 p5_a33 := ddp_x_visit_rec.item_instance_id;
2320 p5_a34 := ddp_x_visit_rec.serial_number;
2321 p5_a35 := ddp_x_visit_rec.inventory_item_id;
2322 p5_a36 := ddp_x_visit_rec.item_organization_id;
2323 p5_a37 := ddp_x_visit_rec.item_name;
2324 p5_a38 := ddp_x_visit_rec.simulation_delete_flag;
2325 p5_a39 := ddp_x_visit_rec.template_flag;
2326 p5_a40 := ddp_x_visit_rec.out_of_sync_flag;
2327 p5_a41 := ddp_x_visit_rec.project_flag;
2328 p5_a42 := ddp_x_visit_rec.project_flag_code;
2329 p5_a43 := ddp_x_visit_rec.project_id;
2330 p5_a44 := ddp_x_visit_rec.project_number;
2331 p5_a45 := ddp_x_visit_rec.description;
2332 p5_a46 := ddp_x_visit_rec.duration;
2333 p5_a47 := ddp_x_visit_rec.attribute_category;
2334 p5_a48 := ddp_x_visit_rec.attribute1;
2335 p5_a49 := ddp_x_visit_rec.attribute2;
2336 p5_a50 := ddp_x_visit_rec.attribute3;
2337 p5_a51 := ddp_x_visit_rec.attribute4;
2338 p5_a52 := ddp_x_visit_rec.attribute5;
2339 p5_a53 := ddp_x_visit_rec.attribute6;
2340 p5_a54 := ddp_x_visit_rec.attribute7;
2341 p5_a55 := ddp_x_visit_rec.attribute8;
2342 p5_a56 := ddp_x_visit_rec.attribute9;
2343 p5_a57 := ddp_x_visit_rec.attribute10;
2344 p5_a58 := ddp_x_visit_rec.attribute11;
2345 p5_a59 := ddp_x_visit_rec.attribute12;
2346 p5_a60 := ddp_x_visit_rec.attribute13;
2347 p5_a61 := ddp_x_visit_rec.attribute14;
2348 p5_a62 := ddp_x_visit_rec.attribute15;
2349 p5_a63 := ddp_x_visit_rec.operation_flag;
2350 p5_a64 := ddp_x_visit_rec.outside_party_flag;
2351 p5_a65 := ddp_x_visit_rec.job_number;
2352 p5_a66 := ddp_x_visit_rec.proj_template_name;
2353 p5_a67 := ddp_x_visit_rec.proj_template_id;
2354 p5_a68 := ddp_x_visit_rec.priority_value;
2355 p5_a69 := ddp_x_visit_rec.priority_code;
2356 p5_a70 := ddp_x_visit_rec.unit_schedule_id;
2357 p5_a71 := ddp_x_visit_rec.visit_create_type;
2358 p5_a72 := ddp_x_visit_rec.visit_create_meaning;
2359 p5_a73 := ddp_x_visit_rec.unit_header_id;
2360 p5_a74 := ddp_x_visit_rec.flight_number;
2361 p5_a75 := ddp_x_visit_rec.project_name;
2362 p5_a76 := ddp_x_visit_rec.top_project_task_id;
2363 p5_a77 := ddp_x_visit_rec.subinventory;
2364 p5_a78 := ddp_x_visit_rec.locator_segment;
2365 p5_a79 := ddp_x_visit_rec.inv_locator_id;
2366 p5_a80 := ddp_x_visit_rec.cp_request_id;
2367 p5_a81 := ddp_x_visit_rec.cp_phase_code;
2368 p5_a82 := ddp_x_visit_rec.cp_status_code;
2369 p5_a83 := ddp_x_visit_rec.cp_request_date;
2370 p5_a84 := ddp_x_visit_rec.jc_exist;
2371 p5_a85 := ddp_x_visit_rec.view_jc_url;
2372 p5_a86 := ddp_x_visit_rec.jc_gen_status;
2373 p5_a87 := ddp_x_visit_rec.jc_gen_error_text;
2374 p5_a88 := ddp_x_visit_rec.past_dated_visit_flag;
2375 p5_a89 := ddp_x_visit_rec.locked_flag;
2376 p5_a90 := ddp_x_visit_rec.firmed_flag;
2377 p5_a91 := ddp_x_visit_rec.tasks_ovn_updated_count;
2378 p5_a92 := ddp_x_visit_rec.stages_ovn_updated_count;
2379 p5_a93 := ddp_x_visit_rec.comp_planning_subinv;
2380 p5_a94 := ddp_x_visit_rec.comp_planning_loc_seg;
2381 p5_a95 := ddp_x_visit_rec.comp_planning_loc_id;
2382 p5_a96 := ddp_x_visit_rec.comp_inrepair_subinv;
2383 p5_a97 := ddp_x_visit_rec.comp_inrepair_loc_seg;
2384 p5_a98 := ddp_x_visit_rec.comp_inrepair_loc_id;
2385 p5_a99 := ddp_x_visit_rec.item_owner_flag;
2386 p5_a100 := ddp_x_visit_rec.auto_visit_type_flag;
2387
2388
2389
2390 end;
2391
2392 end ahl_vwp_visits_pvt_w;