1 package ahl_vwp_visits_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWVSTS.pls 120.5.12020000.2 2012/12/11 06:00:50 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 );
105 procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
106 , a1 out nocopy JTF_VARCHAR2_TABLE_100
107 , a2 out nocopy JTF_NUMBER_TABLE
108 , a3 out nocopy JTF_NUMBER_TABLE
109 , a4 out nocopy JTF_DATE_TABLE
110 , a5 out nocopy JTF_NUMBER_TABLE
111 , a6 out nocopy JTF_DATE_TABLE
112 , a7 out nocopy JTF_NUMBER_TABLE
113 , a8 out nocopy JTF_NUMBER_TABLE
114 , a9 out nocopy JTF_NUMBER_TABLE
115 , a10 out nocopy JTF_VARCHAR2_TABLE_300
116 , a11 out nocopy JTF_NUMBER_TABLE
117 , a12 out nocopy JTF_VARCHAR2_TABLE_300
118 , a13 out nocopy JTF_NUMBER_TABLE
119 , a14 out nocopy JTF_VARCHAR2_TABLE_100
120 , a15 out nocopy JTF_VARCHAR2_TABLE_100
121 , a16 out nocopy JTF_VARCHAR2_TABLE_100
122 , a17 out nocopy JTF_DATE_TABLE
123 , a18 out nocopy JTF_NUMBER_TABLE
124 , a19 out nocopy JTF_NUMBER_TABLE
125 , a20 out nocopy JTF_DATE_TABLE
126 , a21 out nocopy JTF_NUMBER_TABLE
127 , a22 out nocopy JTF_NUMBER_TABLE
128 , a23 out nocopy JTF_DATE_TABLE
129 , a24 out nocopy JTF_DATE_TABLE
130 , a25 out nocopy JTF_VARCHAR2_TABLE_100
131 , a26 out nocopy JTF_VARCHAR2_TABLE_100
132 , a27 out nocopy JTF_VARCHAR2_TABLE_100
133 , a28 out nocopy JTF_VARCHAR2_TABLE_100
134 , a29 out nocopy JTF_NUMBER_TABLE
135 , a30 out nocopy JTF_VARCHAR2_TABLE_100
136 , a31 out nocopy JTF_NUMBER_TABLE
137 , a32 out nocopy JTF_VARCHAR2_TABLE_100
138 , a33 out nocopy JTF_NUMBER_TABLE
139 , a34 out nocopy JTF_VARCHAR2_TABLE_100
140 , a35 out nocopy JTF_NUMBER_TABLE
141 , a36 out nocopy JTF_NUMBER_TABLE
142 , a37 out nocopy JTF_VARCHAR2_TABLE_100
143 , a38 out nocopy JTF_VARCHAR2_TABLE_100
144 , a39 out nocopy JTF_VARCHAR2_TABLE_100
145 , a40 out nocopy JTF_VARCHAR2_TABLE_100
146 , a41 out nocopy JTF_VARCHAR2_TABLE_100
147 , a42 out nocopy JTF_VARCHAR2_TABLE_100
148 , a43 out nocopy JTF_NUMBER_TABLE
149 , a44 out nocopy JTF_NUMBER_TABLE
150 , a45 out nocopy JTF_VARCHAR2_TABLE_4000
151 , a46 out nocopy JTF_NUMBER_TABLE
152 , a47 out nocopy JTF_VARCHAR2_TABLE_100
153 , a48 out nocopy JTF_VARCHAR2_TABLE_200
154 , a49 out nocopy JTF_VARCHAR2_TABLE_200
155 , a50 out nocopy JTF_VARCHAR2_TABLE_200
156 , a51 out nocopy JTF_VARCHAR2_TABLE_200
157 , a52 out nocopy JTF_VARCHAR2_TABLE_200
158 , a53 out nocopy JTF_VARCHAR2_TABLE_200
159 , a54 out nocopy JTF_VARCHAR2_TABLE_200
160 , a55 out nocopy JTF_VARCHAR2_TABLE_200
161 , a56 out nocopy JTF_VARCHAR2_TABLE_200
162 , a57 out nocopy JTF_VARCHAR2_TABLE_200
163 , a58 out nocopy JTF_VARCHAR2_TABLE_200
164 , a59 out nocopy JTF_VARCHAR2_TABLE_200
165 , a60 out nocopy JTF_VARCHAR2_TABLE_200
166 , a61 out nocopy JTF_VARCHAR2_TABLE_200
167 , a62 out nocopy JTF_VARCHAR2_TABLE_200
168 , a63 out nocopy JTF_VARCHAR2_TABLE_100
169 , a64 out nocopy JTF_VARCHAR2_TABLE_100
170 , a65 out nocopy JTF_VARCHAR2_TABLE_300
171 , a66 out nocopy JTF_VARCHAR2_TABLE_100
172 , a67 out nocopy JTF_NUMBER_TABLE
173 , a68 out nocopy JTF_VARCHAR2_TABLE_100
174 , a69 out nocopy JTF_VARCHAR2_TABLE_100
175 , a70 out nocopy JTF_NUMBER_TABLE
176 , a71 out nocopy JTF_VARCHAR2_TABLE_100
177 , a72 out nocopy JTF_VARCHAR2_TABLE_100
178 , a73 out nocopy JTF_NUMBER_TABLE
179 , a74 out nocopy JTF_VARCHAR2_TABLE_100
180 , a75 out nocopy JTF_VARCHAR2_TABLE_100
181 , a76 out nocopy JTF_NUMBER_TABLE
182 , a77 out nocopy JTF_VARCHAR2_TABLE_100
183 , a78 out nocopy JTF_VARCHAR2_TABLE_300
184 , a79 out nocopy JTF_NUMBER_TABLE
185 , a80 out nocopy JTF_NUMBER_TABLE
186 , a81 out nocopy JTF_VARCHAR2_TABLE_100
187 , a82 out nocopy JTF_VARCHAR2_TABLE_100
188 , a83 out nocopy JTF_DATE_TABLE
189 , a84 out nocopy JTF_VARCHAR2_TABLE_100
190 , a85 out nocopy JTF_VARCHAR2_TABLE_2000
191 , a86 out nocopy JTF_VARCHAR2_TABLE_100
192 , a87 out nocopy JTF_VARCHAR2_TABLE_4000
193 , a88 out nocopy JTF_VARCHAR2_TABLE_100
194 , a89 out nocopy JTF_VARCHAR2_TABLE_100
195 , a90 out nocopy JTF_VARCHAR2_TABLE_100
196 , a91 out nocopy JTF_NUMBER_TABLE
197 , a92 out nocopy JTF_NUMBER_TABLE
198 , a93 out nocopy JTF_VARCHAR2_TABLE_100
199 , a94 out nocopy JTF_VARCHAR2_TABLE_300
200 , a95 out nocopy JTF_NUMBER_TABLE
201 , a96 out nocopy JTF_VARCHAR2_TABLE_100
202 , a97 out nocopy JTF_VARCHAR2_TABLE_300
203 , a98 out nocopy JTF_NUMBER_TABLE
204 , a99 out nocopy JTF_VARCHAR2_TABLE_100
205 , a100 out nocopy JTF_VARCHAR2_TABLE_100
206 );
207
208 procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_visits_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
209 , a1 JTF_VARCHAR2_TABLE_100
210 , a2 JTF_VARCHAR2_TABLE_100
211 , a3 JTF_VARCHAR2_TABLE_100
212 , a4 JTF_VARCHAR2_TABLE_100
213 , a5 JTF_DATE_TABLE
214 , a6 JTF_DATE_TABLE
215 , a7 JTF_VARCHAR2_TABLE_100
216 );
217 procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
218 , a1 out nocopy JTF_VARCHAR2_TABLE_100
219 , a2 out nocopy JTF_VARCHAR2_TABLE_100
220 , a3 out nocopy JTF_VARCHAR2_TABLE_100
221 , a4 out nocopy JTF_VARCHAR2_TABLE_100
222 , a5 out nocopy JTF_DATE_TABLE
223 , a6 out nocopy JTF_DATE_TABLE
224 , a7 out nocopy JTF_VARCHAR2_TABLE_100
225 );
226
227 procedure process_visit(p_api_version NUMBER
228 , p_init_msg_list VARCHAR2
229 , p_commit VARCHAR2
230 , p_validation_level NUMBER
231 , p_module_type VARCHAR2
232 , p5_a0 in out nocopy JTF_NUMBER_TABLE
233 , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
234 , p5_a2 in out nocopy JTF_NUMBER_TABLE
235 , p5_a3 in out nocopy JTF_NUMBER_TABLE
236 , p5_a4 in out nocopy JTF_DATE_TABLE
237 , p5_a5 in out nocopy JTF_NUMBER_TABLE
238 , p5_a6 in out nocopy JTF_DATE_TABLE
239 , p5_a7 in out nocopy JTF_NUMBER_TABLE
240 , p5_a8 in out nocopy JTF_NUMBER_TABLE
241 , p5_a9 in out nocopy JTF_NUMBER_TABLE
242 , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
243 , p5_a11 in out nocopy JTF_NUMBER_TABLE
244 , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
245 , p5_a13 in out nocopy JTF_NUMBER_TABLE
246 , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
247 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
248 , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
249 , p5_a17 in out nocopy JTF_DATE_TABLE
250 , p5_a18 in out nocopy JTF_NUMBER_TABLE
251 , p5_a19 in out nocopy JTF_NUMBER_TABLE
252 , p5_a20 in out nocopy JTF_DATE_TABLE
253 , p5_a21 in out nocopy JTF_NUMBER_TABLE
254 , p5_a22 in out nocopy JTF_NUMBER_TABLE
255 , p5_a23 in out nocopy JTF_DATE_TABLE
256 , p5_a24 in out nocopy JTF_DATE_TABLE
257 , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100
258 , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
259 , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
260 , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
261 , p5_a29 in out nocopy JTF_NUMBER_TABLE
262 , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_100
263 , p5_a31 in out nocopy JTF_NUMBER_TABLE
264 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
265 , p5_a33 in out nocopy JTF_NUMBER_TABLE
266 , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
267 , p5_a35 in out nocopy JTF_NUMBER_TABLE
268 , p5_a36 in out nocopy JTF_NUMBER_TABLE
269 , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
270 , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_100
271 , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
272 , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
273 , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_100
274 , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
275 , p5_a43 in out nocopy JTF_NUMBER_TABLE
276 , p5_a44 in out nocopy JTF_NUMBER_TABLE
277 , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_4000
278 , p5_a46 in out nocopy JTF_NUMBER_TABLE
279 , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_100
280 , p5_a48 in out nocopy JTF_VARCHAR2_TABLE_200
281 , p5_a49 in out nocopy JTF_VARCHAR2_TABLE_200
282 , p5_a50 in out nocopy JTF_VARCHAR2_TABLE_200
283 , p5_a51 in out nocopy JTF_VARCHAR2_TABLE_200
284 , p5_a52 in out nocopy JTF_VARCHAR2_TABLE_200
285 , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
286 , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
287 , p5_a55 in out nocopy JTF_VARCHAR2_TABLE_200
288 , p5_a56 in out nocopy JTF_VARCHAR2_TABLE_200
289 , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
290 , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
291 , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_200
292 , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_200
293 , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_200
294 , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_200
295 , p5_a63 in out nocopy JTF_VARCHAR2_TABLE_100
296 , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_100
297 , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_300
298 , p5_a66 in out nocopy JTF_VARCHAR2_TABLE_100
299 , p5_a67 in out nocopy JTF_NUMBER_TABLE
300 , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
301 , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
302 , p5_a70 in out nocopy JTF_NUMBER_TABLE
303 , p5_a71 in out nocopy JTF_VARCHAR2_TABLE_100
304 , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
305 , p5_a73 in out nocopy JTF_NUMBER_TABLE
306 , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
307 , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
308 , p5_a76 in out nocopy JTF_NUMBER_TABLE
309 , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
310 , p5_a78 in out nocopy JTF_VARCHAR2_TABLE_300
311 , p5_a79 in out nocopy JTF_NUMBER_TABLE
312 , p5_a80 in out nocopy JTF_NUMBER_TABLE
313 , p5_a81 in out nocopy JTF_VARCHAR2_TABLE_100
314 , p5_a82 in out nocopy JTF_VARCHAR2_TABLE_100
315 , p5_a83 in out nocopy JTF_DATE_TABLE
316 , p5_a84 in out nocopy JTF_VARCHAR2_TABLE_100
317 , p5_a85 in out nocopy JTF_VARCHAR2_TABLE_2000
318 , p5_a86 in out nocopy JTF_VARCHAR2_TABLE_100
319 , p5_a87 in out nocopy JTF_VARCHAR2_TABLE_4000
320 , p5_a88 in out nocopy JTF_VARCHAR2_TABLE_100
321 , p5_a89 in out nocopy JTF_VARCHAR2_TABLE_100
322 , p5_a90 in out nocopy JTF_VARCHAR2_TABLE_100
323 , p5_a91 in out nocopy JTF_NUMBER_TABLE
324 , p5_a92 in out nocopy JTF_NUMBER_TABLE
325 , p5_a93 in out nocopy JTF_VARCHAR2_TABLE_100
326 , p5_a94 in out nocopy JTF_VARCHAR2_TABLE_300
327 , p5_a95 in out nocopy JTF_NUMBER_TABLE
328 , p5_a96 in out nocopy JTF_VARCHAR2_TABLE_100
329 , p5_a97 in out nocopy JTF_VARCHAR2_TABLE_300
330 , p5_a98 in out nocopy JTF_NUMBER_TABLE
331 , p5_a99 in out nocopy JTF_VARCHAR2_TABLE_100
332 , p5_a100 in out nocopy JTF_VARCHAR2_TABLE_100
333 , x_return_status out nocopy VARCHAR2
334 , x_msg_count out nocopy NUMBER
335 , x_msg_data out nocopy VARCHAR2
336 );
337 procedure get_visit_details(p_api_version NUMBER
338 , p_init_msg_list VARCHAR2
339 , p_commit VARCHAR2
340 , p_validation_level NUMBER
341 , p_module_type VARCHAR2
342 , p_visit_id NUMBER
343 , p6_a0 out nocopy NUMBER
344 , p6_a1 out nocopy VARCHAR2
345 , p6_a2 out nocopy NUMBER
346 , p6_a3 out nocopy NUMBER
347 , p6_a4 out nocopy DATE
348 , p6_a5 out nocopy NUMBER
349 , p6_a6 out nocopy DATE
350 , p6_a7 out nocopy NUMBER
351 , p6_a8 out nocopy NUMBER
352 , p6_a9 out nocopy NUMBER
353 , p6_a10 out nocopy VARCHAR2
354 , p6_a11 out nocopy NUMBER
355 , p6_a12 out nocopy VARCHAR2
356 , p6_a13 out nocopy NUMBER
357 , p6_a14 out nocopy VARCHAR2
358 , p6_a15 out nocopy VARCHAR2
359 , p6_a16 out nocopy VARCHAR2
360 , p6_a17 out nocopy DATE
361 , p6_a18 out nocopy NUMBER
362 , p6_a19 out nocopy NUMBER
363 , p6_a20 out nocopy DATE
364 , p6_a21 out nocopy NUMBER
365 , p6_a22 out nocopy NUMBER
366 , p6_a23 out nocopy DATE
367 , p6_a24 out nocopy DATE
368 , p6_a25 out nocopy VARCHAR2
369 , p6_a26 out nocopy VARCHAR2
370 , p6_a27 out nocopy VARCHAR2
371 , p6_a28 out nocopy VARCHAR2
372 , p6_a29 out nocopy NUMBER
373 , p6_a30 out nocopy VARCHAR2
374 , p6_a31 out nocopy NUMBER
375 , p6_a32 out nocopy VARCHAR2
376 , p6_a33 out nocopy NUMBER
377 , p6_a34 out nocopy VARCHAR2
378 , p6_a35 out nocopy NUMBER
379 , p6_a36 out nocopy NUMBER
380 , p6_a37 out nocopy VARCHAR2
381 , p6_a38 out nocopy VARCHAR2
382 , p6_a39 out nocopy VARCHAR2
383 , p6_a40 out nocopy VARCHAR2
384 , p6_a41 out nocopy VARCHAR2
385 , p6_a42 out nocopy VARCHAR2
386 , p6_a43 out nocopy NUMBER
387 , p6_a44 out nocopy NUMBER
388 , p6_a45 out nocopy VARCHAR2
389 , p6_a46 out nocopy NUMBER
390 , p6_a47 out nocopy VARCHAR2
391 , p6_a48 out nocopy VARCHAR2
392 , p6_a49 out nocopy VARCHAR2
393 , p6_a50 out nocopy VARCHAR2
394 , p6_a51 out nocopy VARCHAR2
395 , p6_a52 out nocopy VARCHAR2
396 , p6_a53 out nocopy VARCHAR2
397 , p6_a54 out nocopy VARCHAR2
398 , p6_a55 out nocopy VARCHAR2
399 , p6_a56 out nocopy VARCHAR2
400 , p6_a57 out nocopy VARCHAR2
401 , p6_a58 out nocopy VARCHAR2
402 , p6_a59 out nocopy VARCHAR2
403 , p6_a60 out nocopy VARCHAR2
404 , p6_a61 out nocopy VARCHAR2
405 , p6_a62 out nocopy VARCHAR2
406 , p6_a63 out nocopy VARCHAR2
407 , p6_a64 out nocopy VARCHAR2
408 , p6_a65 out nocopy VARCHAR2
409 , p6_a66 out nocopy VARCHAR2
410 , p6_a67 out nocopy NUMBER
411 , p6_a68 out nocopy VARCHAR2
412 , p6_a69 out nocopy VARCHAR2
413 , p6_a70 out nocopy NUMBER
414 , p6_a71 out nocopy VARCHAR2
415 , p6_a72 out nocopy VARCHAR2
416 , p6_a73 out nocopy NUMBER
417 , p6_a74 out nocopy VARCHAR2
418 , p6_a75 out nocopy VARCHAR2
419 , p6_a76 out nocopy NUMBER
420 , p6_a77 out nocopy VARCHAR2
421 , p6_a78 out nocopy VARCHAR2
422 , p6_a79 out nocopy NUMBER
423 , p6_a80 out nocopy NUMBER
424 , p6_a81 out nocopy VARCHAR2
425 , p6_a82 out nocopy VARCHAR2
426 , p6_a83 out nocopy DATE
427 , p6_a84 out nocopy VARCHAR2
428 , p6_a85 out nocopy VARCHAR2
429 , p6_a86 out nocopy VARCHAR2
430 , p6_a87 out nocopy VARCHAR2
431 , p6_a88 out nocopy VARCHAR2
432 , p6_a89 out nocopy VARCHAR2
433 , p6_a90 out nocopy VARCHAR2
434 , p6_a91 out nocopy NUMBER
435 , p6_a92 out nocopy NUMBER
436 , p6_a93 out nocopy VARCHAR2
437 , p6_a94 out nocopy VARCHAR2
438 , p6_a95 out nocopy NUMBER
439 , p6_a96 out nocopy VARCHAR2
440 , p6_a97 out nocopy VARCHAR2
441 , p6_a98 out nocopy NUMBER
442 , p6_a99 out nocopy VARCHAR2
443 , p6_a100 out nocopy VARCHAR2
444 , x_return_status out nocopy VARCHAR2
445 , x_msg_count out nocopy NUMBER
446 , x_msg_data out nocopy VARCHAR2
447 );
448 procedure validate_component_visit(p_api_version NUMBER
449 , p_init_msg_list VARCHAR2
450 , p_commit VARCHAR2
451 , p_validation_level NUMBER
452 , p_module_type VARCHAR2
453 , p5_a0 NUMBER
454 , p5_a1 VARCHAR2
455 , p5_a2 NUMBER
456 , p5_a3 NUMBER
457 , p5_a4 DATE
458 , p5_a5 NUMBER
459 , p5_a6 DATE
460 , p5_a7 NUMBER
461 , p5_a8 NUMBER
462 , p5_a9 NUMBER
463 , p5_a10 VARCHAR2
464 , p5_a11 NUMBER
465 , p5_a12 VARCHAR2
466 , p5_a13 NUMBER
467 , p5_a14 VARCHAR2
468 , p5_a15 VARCHAR2
469 , p5_a16 VARCHAR2
470 , p5_a17 DATE
471 , p5_a18 NUMBER
472 , p5_a19 NUMBER
473 , p5_a20 DATE
474 , p5_a21 NUMBER
475 , p5_a22 NUMBER
476 , p5_a23 DATE
477 , p5_a24 DATE
478 , p5_a25 VARCHAR2
479 , p5_a26 VARCHAR2
480 , p5_a27 VARCHAR2
481 , p5_a28 VARCHAR2
482 , p5_a29 NUMBER
483 , p5_a30 VARCHAR2
484 , p5_a31 NUMBER
485 , p5_a32 VARCHAR2
486 , p5_a33 NUMBER
487 , p5_a34 VARCHAR2
488 , p5_a35 NUMBER
489 , p5_a36 NUMBER
490 , p5_a37 VARCHAR2
491 , p5_a38 VARCHAR2
492 , p5_a39 VARCHAR2
493 , p5_a40 VARCHAR2
494 , p5_a41 VARCHAR2
495 , p5_a42 VARCHAR2
496 , p5_a43 NUMBER
497 , p5_a44 NUMBER
498 , p5_a45 VARCHAR2
499 , p5_a46 NUMBER
500 , p5_a47 VARCHAR2
501 , p5_a48 VARCHAR2
502 , p5_a49 VARCHAR2
503 , p5_a50 VARCHAR2
504 , p5_a51 VARCHAR2
505 , p5_a52 VARCHAR2
506 , p5_a53 VARCHAR2
507 , p5_a54 VARCHAR2
508 , p5_a55 VARCHAR2
509 , p5_a56 VARCHAR2
510 , p5_a57 VARCHAR2
511 , p5_a58 VARCHAR2
512 , p5_a59 VARCHAR2
513 , p5_a60 VARCHAR2
514 , p5_a61 VARCHAR2
515 , p5_a62 VARCHAR2
516 , p5_a63 VARCHAR2
517 , p5_a64 VARCHAR2
518 , p5_a65 VARCHAR2
519 , p5_a66 VARCHAR2
520 , p5_a67 NUMBER
521 , p5_a68 VARCHAR2
522 , p5_a69 VARCHAR2
523 , p5_a70 NUMBER
524 , p5_a71 VARCHAR2
525 , p5_a72 VARCHAR2
526 , p5_a73 NUMBER
527 , p5_a74 VARCHAR2
528 , p5_a75 VARCHAR2
529 , p5_a76 NUMBER
530 , p5_a77 VARCHAR2
531 , p5_a78 VARCHAR2
532 , p5_a79 NUMBER
533 , p5_a80 NUMBER
534 , p5_a81 VARCHAR2
535 , p5_a82 VARCHAR2
536 , p5_a83 DATE
537 , p5_a84 VARCHAR2
538 , p5_a85 VARCHAR2
539 , p5_a86 VARCHAR2
540 , p5_a87 VARCHAR2
541 , p5_a88 VARCHAR2
542 , p5_a89 VARCHAR2
543 , p5_a90 VARCHAR2
544 , p5_a91 NUMBER
545 , p5_a92 NUMBER
546 , p5_a93 VARCHAR2
547 , p5_a94 VARCHAR2
548 , p5_a95 NUMBER
549 , p5_a96 VARCHAR2
550 , p5_a97 VARCHAR2
551 , p5_a98 NUMBER
552 , p5_a99 VARCHAR2
553 , p5_a100 VARCHAR2
554 , x_return_status out nocopy VARCHAR2
555 , x_msg_count out nocopy NUMBER
556 , x_msg_data out nocopy VARCHAR2
557 );
558 procedure create_visit(p_api_version NUMBER
559 , p_init_msg_list VARCHAR2
560 , p_commit VARCHAR2
561 , p_validation_level NUMBER
562 , p_module_type VARCHAR2
563 , p5_a0 in out nocopy NUMBER
564 , p5_a1 in out nocopy VARCHAR2
565 , p5_a2 in out nocopy NUMBER
566 , p5_a3 in out nocopy NUMBER
567 , p5_a4 in out nocopy DATE
568 , p5_a5 in out nocopy NUMBER
569 , p5_a6 in out nocopy DATE
570 , p5_a7 in out nocopy NUMBER
571 , p5_a8 in out nocopy NUMBER
572 , p5_a9 in out nocopy NUMBER
573 , p5_a10 in out nocopy VARCHAR2
574 , p5_a11 in out nocopy NUMBER
575 , p5_a12 in out nocopy VARCHAR2
576 , p5_a13 in out nocopy NUMBER
577 , p5_a14 in out nocopy VARCHAR2
578 , p5_a15 in out nocopy VARCHAR2
579 , p5_a16 in out nocopy VARCHAR2
580 , p5_a17 in out nocopy DATE
581 , p5_a18 in out nocopy NUMBER
582 , p5_a19 in out nocopy NUMBER
583 , p5_a20 in out nocopy DATE
584 , p5_a21 in out nocopy NUMBER
585 , p5_a22 in out nocopy NUMBER
586 , p5_a23 in out nocopy DATE
587 , p5_a24 in out nocopy DATE
588 , p5_a25 in out nocopy VARCHAR2
589 , p5_a26 in out nocopy VARCHAR2
590 , p5_a27 in out nocopy VARCHAR2
591 , p5_a28 in out nocopy VARCHAR2
592 , p5_a29 in out nocopy NUMBER
593 , p5_a30 in out nocopy VARCHAR2
594 , p5_a31 in out nocopy NUMBER
595 , p5_a32 in out nocopy VARCHAR2
596 , p5_a33 in out nocopy NUMBER
597 , p5_a34 in out nocopy VARCHAR2
598 , p5_a35 in out nocopy NUMBER
599 , p5_a36 in out nocopy NUMBER
600 , p5_a37 in out nocopy VARCHAR2
601 , p5_a38 in out nocopy VARCHAR2
602 , p5_a39 in out nocopy VARCHAR2
603 , p5_a40 in out nocopy VARCHAR2
604 , p5_a41 in out nocopy VARCHAR2
605 , p5_a42 in out nocopy VARCHAR2
606 , p5_a43 in out nocopy NUMBER
607 , p5_a44 in out nocopy NUMBER
608 , p5_a45 in out nocopy VARCHAR2
609 , p5_a46 in out nocopy NUMBER
610 , p5_a47 in out nocopy VARCHAR2
611 , p5_a48 in out nocopy VARCHAR2
612 , p5_a49 in out nocopy VARCHAR2
613 , p5_a50 in out nocopy VARCHAR2
614 , p5_a51 in out nocopy VARCHAR2
615 , p5_a52 in out nocopy VARCHAR2
616 , p5_a53 in out nocopy VARCHAR2
617 , p5_a54 in out nocopy VARCHAR2
618 , p5_a55 in out nocopy VARCHAR2
619 , p5_a56 in out nocopy VARCHAR2
620 , p5_a57 in out nocopy VARCHAR2
621 , p5_a58 in out nocopy VARCHAR2
622 , p5_a59 in out nocopy VARCHAR2
623 , p5_a60 in out nocopy VARCHAR2
624 , p5_a61 in out nocopy VARCHAR2
625 , p5_a62 in out nocopy VARCHAR2
626 , p5_a63 in out nocopy VARCHAR2
627 , p5_a64 in out nocopy VARCHAR2
628 , p5_a65 in out nocopy VARCHAR2
629 , p5_a66 in out nocopy VARCHAR2
630 , p5_a67 in out nocopy NUMBER
631 , p5_a68 in out nocopy VARCHAR2
632 , p5_a69 in out nocopy VARCHAR2
633 , p5_a70 in out nocopy NUMBER
634 , p5_a71 in out nocopy VARCHAR2
635 , p5_a72 in out nocopy VARCHAR2
636 , p5_a73 in out nocopy NUMBER
637 , p5_a74 in out nocopy VARCHAR2
638 , p5_a75 in out nocopy VARCHAR2
639 , p5_a76 in out nocopy NUMBER
640 , p5_a77 in out nocopy VARCHAR2
641 , p5_a78 in out nocopy VARCHAR2
642 , p5_a79 in out nocopy NUMBER
643 , p5_a80 in out nocopy NUMBER
644 , p5_a81 in out nocopy VARCHAR2
645 , p5_a82 in out nocopy VARCHAR2
646 , p5_a83 in out nocopy DATE
647 , p5_a84 in out nocopy VARCHAR2
648 , p5_a85 in out nocopy VARCHAR2
649 , p5_a86 in out nocopy VARCHAR2
650 , p5_a87 in out nocopy VARCHAR2
651 , p5_a88 in out nocopy VARCHAR2
652 , p5_a89 in out nocopy VARCHAR2
653 , p5_a90 in out nocopy VARCHAR2
654 , p5_a91 in out nocopy NUMBER
655 , p5_a92 in out nocopy NUMBER
656 , p5_a93 in out nocopy VARCHAR2
657 , p5_a94 in out nocopy VARCHAR2
658 , p5_a95 in out nocopy NUMBER
659 , p5_a96 in out nocopy VARCHAR2
660 , p5_a97 in out nocopy VARCHAR2
661 , p5_a98 in out nocopy NUMBER
662 , p5_a99 in out nocopy VARCHAR2
663 , p5_a100 in out nocopy VARCHAR2
664 , x_return_status out nocopy VARCHAR2
665 , x_msg_count out nocopy NUMBER
666 , x_msg_data out nocopy VARCHAR2
667 );
668 procedure update_visit(p_api_version NUMBER
669 , p_init_msg_list VARCHAR2
670 , p_commit VARCHAR2
671 , p_validation_level NUMBER
672 , p_module_type VARCHAR2
673 , p5_a0 in out nocopy NUMBER
674 , p5_a1 in out nocopy VARCHAR2
675 , p5_a2 in out nocopy NUMBER
676 , p5_a3 in out nocopy NUMBER
677 , p5_a4 in out nocopy DATE
678 , p5_a5 in out nocopy NUMBER
679 , p5_a6 in out nocopy DATE
680 , p5_a7 in out nocopy NUMBER
681 , p5_a8 in out nocopy NUMBER
682 , p5_a9 in out nocopy NUMBER
683 , p5_a10 in out nocopy VARCHAR2
684 , p5_a11 in out nocopy NUMBER
685 , p5_a12 in out nocopy VARCHAR2
686 , p5_a13 in out nocopy NUMBER
687 , p5_a14 in out nocopy VARCHAR2
688 , p5_a15 in out nocopy VARCHAR2
689 , p5_a16 in out nocopy VARCHAR2
690 , p5_a17 in out nocopy DATE
691 , p5_a18 in out nocopy NUMBER
692 , p5_a19 in out nocopy NUMBER
693 , p5_a20 in out nocopy DATE
694 , p5_a21 in out nocopy NUMBER
695 , p5_a22 in out nocopy NUMBER
696 , p5_a23 in out nocopy DATE
697 , p5_a24 in out nocopy DATE
698 , p5_a25 in out nocopy VARCHAR2
699 , p5_a26 in out nocopy VARCHAR2
700 , p5_a27 in out nocopy VARCHAR2
701 , p5_a28 in out nocopy VARCHAR2
702 , p5_a29 in out nocopy NUMBER
703 , p5_a30 in out nocopy VARCHAR2
704 , p5_a31 in out nocopy NUMBER
705 , p5_a32 in out nocopy VARCHAR2
706 , p5_a33 in out nocopy NUMBER
707 , p5_a34 in out nocopy VARCHAR2
708 , p5_a35 in out nocopy NUMBER
709 , p5_a36 in out nocopy NUMBER
710 , p5_a37 in out nocopy VARCHAR2
711 , p5_a38 in out nocopy VARCHAR2
712 , p5_a39 in out nocopy VARCHAR2
713 , p5_a40 in out nocopy VARCHAR2
714 , p5_a41 in out nocopy VARCHAR2
715 , p5_a42 in out nocopy VARCHAR2
716 , p5_a43 in out nocopy NUMBER
717 , p5_a44 in out nocopy NUMBER
718 , p5_a45 in out nocopy VARCHAR2
719 , p5_a46 in out nocopy NUMBER
720 , p5_a47 in out nocopy VARCHAR2
721 , p5_a48 in out nocopy VARCHAR2
722 , p5_a49 in out nocopy VARCHAR2
723 , p5_a50 in out nocopy VARCHAR2
724 , p5_a51 in out nocopy VARCHAR2
725 , p5_a52 in out nocopy VARCHAR2
726 , p5_a53 in out nocopy VARCHAR2
727 , p5_a54 in out nocopy VARCHAR2
728 , p5_a55 in out nocopy VARCHAR2
729 , p5_a56 in out nocopy VARCHAR2
730 , p5_a57 in out nocopy VARCHAR2
731 , p5_a58 in out nocopy VARCHAR2
732 , p5_a59 in out nocopy VARCHAR2
733 , p5_a60 in out nocopy VARCHAR2
734 , p5_a61 in out nocopy VARCHAR2
735 , p5_a62 in out nocopy VARCHAR2
736 , p5_a63 in out nocopy VARCHAR2
737 , p5_a64 in out nocopy VARCHAR2
738 , p5_a65 in out nocopy VARCHAR2
739 , p5_a66 in out nocopy VARCHAR2
740 , p5_a67 in out nocopy NUMBER
741 , p5_a68 in out nocopy VARCHAR2
742 , p5_a69 in out nocopy VARCHAR2
743 , p5_a70 in out nocopy NUMBER
744 , p5_a71 in out nocopy VARCHAR2
745 , p5_a72 in out nocopy VARCHAR2
746 , p5_a73 in out nocopy NUMBER
747 , p5_a74 in out nocopy VARCHAR2
748 , p5_a75 in out nocopy VARCHAR2
749 , p5_a76 in out nocopy NUMBER
750 , p5_a77 in out nocopy VARCHAR2
751 , p5_a78 in out nocopy VARCHAR2
752 , p5_a79 in out nocopy NUMBER
753 , p5_a80 in out nocopy NUMBER
754 , p5_a81 in out nocopy VARCHAR2
755 , p5_a82 in out nocopy VARCHAR2
756 , p5_a83 in out nocopy DATE
757 , p5_a84 in out nocopy VARCHAR2
758 , p5_a85 in out nocopy VARCHAR2
759 , p5_a86 in out nocopy VARCHAR2
760 , p5_a87 in out nocopy VARCHAR2
761 , p5_a88 in out nocopy VARCHAR2
762 , p5_a89 in out nocopy VARCHAR2
763 , p5_a90 in out nocopy VARCHAR2
764 , p5_a91 in out nocopy NUMBER
765 , p5_a92 in out nocopy NUMBER
766 , p5_a93 in out nocopy VARCHAR2
767 , p5_a94 in out nocopy VARCHAR2
768 , p5_a95 in out nocopy NUMBER
769 , p5_a96 in out nocopy VARCHAR2
770 , p5_a97 in out nocopy VARCHAR2
771 , p5_a98 in out nocopy NUMBER
772 , p5_a99 in out nocopy VARCHAR2
773 , p5_a100 in out nocopy VARCHAR2
774 , x_return_status out nocopy VARCHAR2
775 , x_msg_count out nocopy NUMBER
776 , x_msg_data out nocopy VARCHAR2
777 );
778 end ahl_vwp_visits_pvt_w;