1 package ahl_vwp_visit_cst_pr_pvt_w as
2 /* $Header: AHLWVCPS.pls 120.1 2006/05/04 07:14 anraj noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_visit_cst_pr_pvt.cost_price_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_DATE_TABLE
25 , a22 JTF_DATE_TABLE
26 , a23 JTF_DATE_TABLE
27 , a24 JTF_DATE_TABLE
28 , a25 JTF_DATE_TABLE
29 , a26 JTF_DATE_TABLE
30 , a27 JTF_VARCHAR2_TABLE_100
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_VARCHAR2_TABLE_100
33 , a30 JTF_VARCHAR2_TABLE_2000
34 , a31 JTF_NUMBER_TABLE
35 , a32 JTF_VARCHAR2_TABLE_400
36 , a33 JTF_VARCHAR2_TABLE_300
37 , a34 JTF_VARCHAR2_TABLE_300
38 , a35 JTF_NUMBER_TABLE
39 , a36 JTF_VARCHAR2_TABLE_100
40 , a37 JTF_NUMBER_TABLE
41 , a38 JTF_NUMBER_TABLE
42 , a39 JTF_NUMBER_TABLE
43 , a40 JTF_DATE_TABLE
44 , a41 JTF_NUMBER_TABLE
45 , a42 JTF_DATE_TABLE
46 , a43 JTF_NUMBER_TABLE
47 , a44 JTF_VARCHAR2_TABLE_100
48 , a45 JTF_VARCHAR2_TABLE_200
49 , a46 JTF_VARCHAR2_TABLE_200
50 , a47 JTF_VARCHAR2_TABLE_200
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 );
64 procedure rosetta_table_copy_out_p1(t ahl_vwp_visit_cst_pr_pvt.cost_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65 , a1 out nocopy JTF_NUMBER_TABLE
66 , a2 out nocopy JTF_NUMBER_TABLE
67 , a3 out nocopy JTF_NUMBER_TABLE
68 , a4 out nocopy JTF_NUMBER_TABLE
69 , a5 out nocopy JTF_NUMBER_TABLE
70 , a6 out nocopy JTF_NUMBER_TABLE
71 , a7 out nocopy JTF_VARCHAR2_TABLE_100
72 , a8 out nocopy JTF_NUMBER_TABLE
73 , a9 out nocopy JTF_NUMBER_TABLE
74 , a10 out nocopy JTF_NUMBER_TABLE
75 , a11 out nocopy JTF_NUMBER_TABLE
76 , a12 out nocopy JTF_VARCHAR2_TABLE_100
77 , a13 out nocopy JTF_VARCHAR2_TABLE_100
78 , a14 out nocopy JTF_VARCHAR2_TABLE_100
79 , a15 out nocopy JTF_VARCHAR2_TABLE_100
80 , a16 out nocopy JTF_NUMBER_TABLE
81 , a17 out nocopy JTF_VARCHAR2_TABLE_100
82 , a18 out nocopy JTF_NUMBER_TABLE
83 , a19 out nocopy JTF_NUMBER_TABLE
84 , a20 out nocopy JTF_NUMBER_TABLE
85 , a21 out nocopy JTF_DATE_TABLE
86 , a22 out nocopy JTF_DATE_TABLE
87 , a23 out nocopy JTF_DATE_TABLE
88 , a24 out nocopy JTF_DATE_TABLE
89 , a25 out nocopy JTF_DATE_TABLE
90 , a26 out nocopy JTF_DATE_TABLE
91 , a27 out nocopy JTF_VARCHAR2_TABLE_100
92 , a28 out nocopy JTF_NUMBER_TABLE
93 , a29 out nocopy JTF_VARCHAR2_TABLE_100
94 , a30 out nocopy JTF_VARCHAR2_TABLE_2000
95 , a31 out nocopy JTF_NUMBER_TABLE
96 , a32 out nocopy JTF_VARCHAR2_TABLE_400
97 , a33 out nocopy JTF_VARCHAR2_TABLE_300
98 , a34 out nocopy JTF_VARCHAR2_TABLE_300
99 , a35 out nocopy JTF_NUMBER_TABLE
100 , a36 out nocopy JTF_VARCHAR2_TABLE_100
101 , a37 out nocopy JTF_NUMBER_TABLE
102 , a38 out nocopy JTF_NUMBER_TABLE
103 , a39 out nocopy JTF_NUMBER_TABLE
104 , a40 out nocopy JTF_DATE_TABLE
105 , a41 out nocopy JTF_NUMBER_TABLE
106 , a42 out nocopy JTF_DATE_TABLE
107 , a43 out nocopy JTF_NUMBER_TABLE
108 , a44 out nocopy JTF_VARCHAR2_TABLE_100
109 , a45 out nocopy JTF_VARCHAR2_TABLE_200
110 , a46 out nocopy JTF_VARCHAR2_TABLE_200
111 , a47 out nocopy JTF_VARCHAR2_TABLE_200
112 , a48 out nocopy JTF_VARCHAR2_TABLE_200
113 , a49 out nocopy JTF_VARCHAR2_TABLE_200
114 , a50 out nocopy JTF_VARCHAR2_TABLE_200
115 , a51 out nocopy JTF_VARCHAR2_TABLE_200
116 , a52 out nocopy JTF_VARCHAR2_TABLE_200
117 , a53 out nocopy JTF_VARCHAR2_TABLE_200
118 , a54 out nocopy JTF_VARCHAR2_TABLE_200
119 , a55 out nocopy JTF_VARCHAR2_TABLE_200
120 , a56 out nocopy JTF_VARCHAR2_TABLE_200
121 , a57 out nocopy JTF_VARCHAR2_TABLE_200
122 , a58 out nocopy JTF_VARCHAR2_TABLE_200
123 , a59 out nocopy JTF_VARCHAR2_TABLE_200
124 );
125
126 procedure get_visit_cost_details(p_api_version NUMBER
127 , p_init_msg_list VARCHAR2
128 , p_commit VARCHAR2
129 , p_validation_level NUMBER
130 , p_module_type VARCHAR2
131 , p5_a0 in out nocopy NUMBER
132 , p5_a1 in out nocopy NUMBER
133 , p5_a2 in out nocopy NUMBER
134 , p5_a3 in out nocopy NUMBER
135 , p5_a4 in out nocopy NUMBER
136 , p5_a5 in out nocopy NUMBER
137 , p5_a6 in out nocopy NUMBER
138 , p5_a7 in out nocopy VARCHAR2
139 , p5_a8 in out nocopy NUMBER
140 , p5_a9 in out nocopy NUMBER
141 , p5_a10 in out nocopy NUMBER
142 , p5_a11 in out nocopy NUMBER
143 , p5_a12 in out nocopy VARCHAR2
144 , p5_a13 in out nocopy VARCHAR2
145 , p5_a14 in out nocopy VARCHAR2
146 , p5_a15 in out nocopy VARCHAR2
147 , p5_a16 in out nocopy NUMBER
148 , p5_a17 in out nocopy VARCHAR2
149 , p5_a18 in out nocopy NUMBER
150 , p5_a19 in out nocopy NUMBER
151 , p5_a20 in out nocopy NUMBER
152 , p5_a21 in out nocopy DATE
153 , p5_a22 in out nocopy DATE
154 , p5_a23 in out nocopy DATE
155 , p5_a24 in out nocopy DATE
156 , p5_a25 in out nocopy DATE
157 , p5_a26 in out nocopy DATE
158 , p5_a27 in out nocopy VARCHAR2
159 , p5_a28 in out nocopy NUMBER
160 , p5_a29 in out nocopy VARCHAR2
161 , p5_a30 in out nocopy VARCHAR2
162 , p5_a31 in out nocopy NUMBER
163 , p5_a32 in out nocopy VARCHAR2
164 , p5_a33 in out nocopy VARCHAR2
165 , p5_a34 in out nocopy VARCHAR2
166 , p5_a35 in out nocopy NUMBER
167 , p5_a36 in out nocopy VARCHAR2
168 , p5_a37 in out nocopy NUMBER
169 , p5_a38 in out nocopy NUMBER
170 , p5_a39 in out nocopy NUMBER
171 , p5_a40 in out nocopy DATE
172 , p5_a41 in out nocopy NUMBER
173 , p5_a42 in out nocopy DATE
174 , p5_a43 in out nocopy NUMBER
175 , p5_a44 in out nocopy VARCHAR2
176 , p5_a45 in out nocopy VARCHAR2
177 , p5_a46 in out nocopy VARCHAR2
178 , p5_a47 in out nocopy VARCHAR2
179 , p5_a48 in out nocopy VARCHAR2
180 , p5_a49 in out nocopy VARCHAR2
181 , p5_a50 in out nocopy VARCHAR2
182 , p5_a51 in out nocopy VARCHAR2
183 , p5_a52 in out nocopy VARCHAR2
184 , p5_a53 in out nocopy VARCHAR2
185 , p5_a54 in out nocopy VARCHAR2
186 , p5_a55 in out nocopy VARCHAR2
187 , p5_a56 in out nocopy VARCHAR2
188 , p5_a57 in out nocopy VARCHAR2
189 , p5_a58 in out nocopy VARCHAR2
190 , p5_a59 in out nocopy VARCHAR2
191 , x_return_status out nocopy VARCHAR2
192 , x_msg_count out nocopy NUMBER
193 , x_msg_data out nocopy VARCHAR2
194 );
195 procedure estimate_visit_cost(p_api_version NUMBER
196 , p_init_msg_list VARCHAR2
197 , p_commit VARCHAR2
198 , p_validation_level NUMBER
199 , p_module_type VARCHAR2
200 , p5_a0 in out nocopy NUMBER
201 , p5_a1 in out nocopy NUMBER
202 , p5_a2 in out nocopy NUMBER
203 , p5_a3 in out nocopy NUMBER
204 , p5_a4 in out nocopy NUMBER
205 , p5_a5 in out nocopy NUMBER
206 , p5_a6 in out nocopy NUMBER
207 , p5_a7 in out nocopy VARCHAR2
208 , p5_a8 in out nocopy NUMBER
209 , p5_a9 in out nocopy NUMBER
210 , p5_a10 in out nocopy NUMBER
211 , p5_a11 in out nocopy NUMBER
212 , p5_a12 in out nocopy VARCHAR2
213 , p5_a13 in out nocopy VARCHAR2
214 , p5_a14 in out nocopy VARCHAR2
215 , p5_a15 in out nocopy VARCHAR2
216 , p5_a16 in out nocopy NUMBER
217 , p5_a17 in out nocopy VARCHAR2
218 , p5_a18 in out nocopy NUMBER
219 , p5_a19 in out nocopy NUMBER
220 , p5_a20 in out nocopy NUMBER
221 , p5_a21 in out nocopy DATE
222 , p5_a22 in out nocopy DATE
223 , p5_a23 in out nocopy DATE
224 , p5_a24 in out nocopy DATE
225 , p5_a25 in out nocopy DATE
226 , p5_a26 in out nocopy DATE
227 , p5_a27 in out nocopy VARCHAR2
228 , p5_a28 in out nocopy NUMBER
229 , p5_a29 in out nocopy VARCHAR2
230 , p5_a30 in out nocopy VARCHAR2
231 , p5_a31 in out nocopy NUMBER
232 , p5_a32 in out nocopy VARCHAR2
233 , p5_a33 in out nocopy VARCHAR2
234 , p5_a34 in out nocopy VARCHAR2
235 , p5_a35 in out nocopy NUMBER
236 , p5_a36 in out nocopy VARCHAR2
237 , p5_a37 in out nocopy NUMBER
238 , p5_a38 in out nocopy NUMBER
239 , p5_a39 in out nocopy NUMBER
240 , p5_a40 in out nocopy DATE
241 , p5_a41 in out nocopy NUMBER
242 , p5_a42 in out nocopy DATE
243 , p5_a43 in out nocopy NUMBER
244 , p5_a44 in out nocopy VARCHAR2
245 , p5_a45 in out nocopy VARCHAR2
246 , p5_a46 in out nocopy VARCHAR2
247 , p5_a47 in out nocopy VARCHAR2
248 , p5_a48 in out nocopy VARCHAR2
249 , p5_a49 in out nocopy VARCHAR2
250 , p5_a50 in out nocopy VARCHAR2
251 , p5_a51 in out nocopy VARCHAR2
252 , p5_a52 in out nocopy VARCHAR2
253 , p5_a53 in out nocopy VARCHAR2
254 , p5_a54 in out nocopy VARCHAR2
255 , p5_a55 in out nocopy VARCHAR2
256 , p5_a56 in out nocopy VARCHAR2
257 , p5_a57 in out nocopy VARCHAR2
258 , p5_a58 in out nocopy VARCHAR2
259 , p5_a59 in out nocopy VARCHAR2
260 , x_return_status out nocopy VARCHAR2
261 , x_msg_count out nocopy NUMBER
262 , x_msg_data out nocopy VARCHAR2
263 );
264 procedure estimate_visit_price(p_api_version NUMBER
265 , p_init_msg_list VARCHAR2
266 , p_commit VARCHAR2
267 , p_validation_level NUMBER
268 , p_module_type VARCHAR2
269 , p5_a0 in out nocopy NUMBER
270 , p5_a1 in out nocopy NUMBER
271 , p5_a2 in out nocopy NUMBER
272 , p5_a3 in out nocopy NUMBER
273 , p5_a4 in out nocopy NUMBER
274 , p5_a5 in out nocopy NUMBER
275 , p5_a6 in out nocopy NUMBER
276 , p5_a7 in out nocopy VARCHAR2
277 , p5_a8 in out nocopy NUMBER
278 , p5_a9 in out nocopy NUMBER
279 , p5_a10 in out nocopy NUMBER
280 , p5_a11 in out nocopy NUMBER
281 , p5_a12 in out nocopy VARCHAR2
282 , p5_a13 in out nocopy VARCHAR2
283 , p5_a14 in out nocopy VARCHAR2
284 , p5_a15 in out nocopy VARCHAR2
285 , p5_a16 in out nocopy NUMBER
286 , p5_a17 in out nocopy VARCHAR2
287 , p5_a18 in out nocopy NUMBER
288 , p5_a19 in out nocopy NUMBER
289 , p5_a20 in out nocopy NUMBER
290 , p5_a21 in out nocopy DATE
291 , p5_a22 in out nocopy DATE
292 , p5_a23 in out nocopy DATE
293 , p5_a24 in out nocopy DATE
294 , p5_a25 in out nocopy DATE
295 , p5_a26 in out nocopy DATE
296 , p5_a27 in out nocopy VARCHAR2
297 , p5_a28 in out nocopy NUMBER
298 , p5_a29 in out nocopy VARCHAR2
299 , p5_a30 in out nocopy VARCHAR2
300 , p5_a31 in out nocopy NUMBER
301 , p5_a32 in out nocopy VARCHAR2
302 , p5_a33 in out nocopy VARCHAR2
303 , p5_a34 in out nocopy VARCHAR2
304 , p5_a35 in out nocopy NUMBER
305 , p5_a36 in out nocopy VARCHAR2
306 , p5_a37 in out nocopy NUMBER
307 , p5_a38 in out nocopy NUMBER
308 , p5_a39 in out nocopy NUMBER
309 , p5_a40 in out nocopy DATE
310 , p5_a41 in out nocopy NUMBER
311 , p5_a42 in out nocopy DATE
312 , p5_a43 in out nocopy NUMBER
313 , p5_a44 in out nocopy VARCHAR2
314 , p5_a45 in out nocopy VARCHAR2
315 , p5_a46 in out nocopy VARCHAR2
316 , p5_a47 in out nocopy VARCHAR2
317 , p5_a48 in out nocopy VARCHAR2
318 , p5_a49 in out nocopy VARCHAR2
319 , p5_a50 in out nocopy VARCHAR2
320 , p5_a51 in out nocopy VARCHAR2
321 , p5_a52 in out nocopy VARCHAR2
322 , p5_a53 in out nocopy VARCHAR2
323 , p5_a54 in out nocopy VARCHAR2
324 , p5_a55 in out nocopy VARCHAR2
325 , p5_a56 in out nocopy VARCHAR2
326 , p5_a57 in out nocopy VARCHAR2
327 , p5_a58 in out nocopy VARCHAR2
328 , p5_a59 in out nocopy VARCHAR2
329 , x_return_status out nocopy VARCHAR2
330 , x_msg_count out nocopy NUMBER
331 , x_msg_data out nocopy VARCHAR2
332 );
333 procedure create_cost_snapshot(p_api_version NUMBER
334 , p_init_msg_list VARCHAR2
335 , p_commit VARCHAR2
336 , p_validation_level NUMBER
337 , p_module_type VARCHAR2
338 , p5_a0 in out nocopy NUMBER
339 , p5_a1 in out nocopy NUMBER
340 , p5_a2 in out nocopy NUMBER
341 , p5_a3 in out nocopy NUMBER
342 , p5_a4 in out nocopy NUMBER
343 , p5_a5 in out nocopy NUMBER
344 , p5_a6 in out nocopy NUMBER
345 , p5_a7 in out nocopy VARCHAR2
346 , p5_a8 in out nocopy NUMBER
347 , p5_a9 in out nocopy NUMBER
348 , p5_a10 in out nocopy NUMBER
349 , p5_a11 in out nocopy NUMBER
350 , p5_a12 in out nocopy VARCHAR2
351 , p5_a13 in out nocopy VARCHAR2
352 , p5_a14 in out nocopy VARCHAR2
353 , p5_a15 in out nocopy VARCHAR2
354 , p5_a16 in out nocopy NUMBER
355 , p5_a17 in out nocopy VARCHAR2
356 , p5_a18 in out nocopy NUMBER
357 , p5_a19 in out nocopy NUMBER
358 , p5_a20 in out nocopy NUMBER
359 , p5_a21 in out nocopy DATE
360 , p5_a22 in out nocopy DATE
361 , p5_a23 in out nocopy DATE
362 , p5_a24 in out nocopy DATE
363 , p5_a25 in out nocopy DATE
364 , p5_a26 in out nocopy DATE
365 , p5_a27 in out nocopy VARCHAR2
366 , p5_a28 in out nocopy NUMBER
367 , p5_a29 in out nocopy VARCHAR2
368 , p5_a30 in out nocopy VARCHAR2
369 , p5_a31 in out nocopy NUMBER
370 , p5_a32 in out nocopy VARCHAR2
371 , p5_a33 in out nocopy VARCHAR2
372 , p5_a34 in out nocopy VARCHAR2
373 , p5_a35 in out nocopy NUMBER
374 , p5_a36 in out nocopy VARCHAR2
375 , p5_a37 in out nocopy NUMBER
376 , p5_a38 in out nocopy NUMBER
377 , p5_a39 in out nocopy NUMBER
378 , p5_a40 in out nocopy DATE
379 , p5_a41 in out nocopy NUMBER
380 , p5_a42 in out nocopy DATE
381 , p5_a43 in out nocopy NUMBER
382 , p5_a44 in out nocopy VARCHAR2
383 , p5_a45 in out nocopy VARCHAR2
384 , p5_a46 in out nocopy VARCHAR2
385 , p5_a47 in out nocopy VARCHAR2
386 , p5_a48 in out nocopy VARCHAR2
387 , p5_a49 in out nocopy VARCHAR2
388 , p5_a50 in out nocopy VARCHAR2
389 , p5_a51 in out nocopy VARCHAR2
390 , p5_a52 in out nocopy VARCHAR2
391 , p5_a53 in out nocopy VARCHAR2
392 , p5_a54 in out nocopy VARCHAR2
393 , p5_a55 in out nocopy VARCHAR2
394 , p5_a56 in out nocopy VARCHAR2
395 , p5_a57 in out nocopy VARCHAR2
396 , p5_a58 in out nocopy VARCHAR2
397 , p5_a59 in out nocopy VARCHAR2
398 , x_return_status out nocopy VARCHAR2
399 , x_msg_count out nocopy NUMBER
400 , x_msg_data out nocopy VARCHAR2
401 );
402 procedure update_visit_cost_details(p_api_version NUMBER
403 , p_init_msg_list VARCHAR2
404 , p_commit VARCHAR2
405 , p_validation_level NUMBER
406 , p_module_type VARCHAR2
407 , p5_a0 in out nocopy NUMBER
408 , p5_a1 in out nocopy NUMBER
409 , p5_a2 in out nocopy NUMBER
410 , p5_a3 in out nocopy NUMBER
411 , p5_a4 in out nocopy NUMBER
412 , p5_a5 in out nocopy NUMBER
413 , p5_a6 in out nocopy NUMBER
414 , p5_a7 in out nocopy VARCHAR2
415 , p5_a8 in out nocopy NUMBER
416 , p5_a9 in out nocopy NUMBER
417 , p5_a10 in out nocopy NUMBER
418 , p5_a11 in out nocopy NUMBER
419 , p5_a12 in out nocopy VARCHAR2
420 , p5_a13 in out nocopy VARCHAR2
421 , p5_a14 in out nocopy VARCHAR2
422 , p5_a15 in out nocopy VARCHAR2
423 , p5_a16 in out nocopy NUMBER
424 , p5_a17 in out nocopy VARCHAR2
425 , p5_a18 in out nocopy NUMBER
426 , p5_a19 in out nocopy NUMBER
427 , p5_a20 in out nocopy NUMBER
428 , p5_a21 in out nocopy DATE
429 , p5_a22 in out nocopy DATE
430 , p5_a23 in out nocopy DATE
431 , p5_a24 in out nocopy DATE
432 , p5_a25 in out nocopy DATE
433 , p5_a26 in out nocopy DATE
434 , p5_a27 in out nocopy VARCHAR2
435 , p5_a28 in out nocopy NUMBER
436 , p5_a29 in out nocopy VARCHAR2
437 , p5_a30 in out nocopy VARCHAR2
438 , p5_a31 in out nocopy NUMBER
439 , p5_a32 in out nocopy VARCHAR2
440 , p5_a33 in out nocopy VARCHAR2
441 , p5_a34 in out nocopy VARCHAR2
442 , p5_a35 in out nocopy NUMBER
443 , p5_a36 in out nocopy VARCHAR2
444 , p5_a37 in out nocopy NUMBER
445 , p5_a38 in out nocopy NUMBER
446 , p5_a39 in out nocopy NUMBER
447 , p5_a40 in out nocopy DATE
448 , p5_a41 in out nocopy NUMBER
449 , p5_a42 in out nocopy DATE
450 , p5_a43 in out nocopy NUMBER
451 , p5_a44 in out nocopy VARCHAR2
452 , p5_a45 in out nocopy VARCHAR2
453 , p5_a46 in out nocopy VARCHAR2
454 , p5_a47 in out nocopy VARCHAR2
455 , p5_a48 in out nocopy VARCHAR2
456 , p5_a49 in out nocopy VARCHAR2
457 , p5_a50 in out nocopy VARCHAR2
458 , p5_a51 in out nocopy VARCHAR2
459 , p5_a52 in out nocopy VARCHAR2
460 , p5_a53 in out nocopy VARCHAR2
461 , p5_a54 in out nocopy VARCHAR2
462 , p5_a55 in out nocopy VARCHAR2
463 , p5_a56 in out nocopy VARCHAR2
464 , p5_a57 in out nocopy VARCHAR2
465 , p5_a58 in out nocopy VARCHAR2
466 , p5_a59 in out nocopy VARCHAR2
467 , x_return_status out nocopy VARCHAR2
468 , x_msg_count out nocopy NUMBER
469 , x_msg_data out nocopy VARCHAR2
470 );
471 procedure get_visit_items_no_price(p_api_version NUMBER
472 , p_init_msg_list VARCHAR2
473 , p_commit VARCHAR2
474 , p_validation_level NUMBER
475 , p_module_type VARCHAR2
476 , x_return_status out nocopy VARCHAR2
477 , x_msg_count out nocopy NUMBER
478 , x_msg_data out nocopy VARCHAR2
479 , p8_a0 NUMBER
480 , p8_a1 NUMBER
481 , p8_a2 NUMBER
482 , p8_a3 NUMBER
483 , p8_a4 NUMBER
484 , p8_a5 NUMBER
485 , p8_a6 NUMBER
486 , p8_a7 VARCHAR2
487 , p8_a8 NUMBER
488 , p8_a9 NUMBER
489 , p8_a10 NUMBER
490 , p8_a11 NUMBER
491 , p8_a12 VARCHAR2
492 , p8_a13 VARCHAR2
493 , p8_a14 VARCHAR2
494 , p8_a15 VARCHAR2
495 , p8_a16 NUMBER
496 , p8_a17 VARCHAR2
497 , p8_a18 NUMBER
498 , p8_a19 NUMBER
499 , p8_a20 NUMBER
500 , p8_a21 DATE
501 , p8_a22 DATE
502 , p8_a23 DATE
503 , p8_a24 DATE
504 , p8_a25 DATE
505 , p8_a26 DATE
506 , p8_a27 VARCHAR2
507 , p8_a28 NUMBER
508 , p8_a29 VARCHAR2
509 , p8_a30 VARCHAR2
510 , p8_a31 NUMBER
511 , p8_a32 VARCHAR2
512 , p8_a33 VARCHAR2
513 , p8_a34 VARCHAR2
514 , p8_a35 NUMBER
515 , p8_a36 VARCHAR2
516 , p8_a37 NUMBER
517 , p8_a38 NUMBER
518 , p8_a39 NUMBER
519 , p8_a40 DATE
520 , p8_a41 NUMBER
521 , p8_a42 DATE
522 , p8_a43 NUMBER
523 , p8_a44 VARCHAR2
524 , p8_a45 VARCHAR2
525 , p8_a46 VARCHAR2
526 , p8_a47 VARCHAR2
527 , p8_a48 VARCHAR2
528 , p8_a49 VARCHAR2
529 , p8_a50 VARCHAR2
530 , p8_a51 VARCHAR2
531 , p8_a52 VARCHAR2
532 , p8_a53 VARCHAR2
533 , p8_a54 VARCHAR2
534 , p8_a55 VARCHAR2
535 , p8_a56 VARCHAR2
536 , p8_a57 VARCHAR2
537 , p8_a58 VARCHAR2
538 , p8_a59 VARCHAR2
539 , p9_a0 out nocopy JTF_NUMBER_TABLE
540 , p9_a1 out nocopy JTF_NUMBER_TABLE
541 , p9_a2 out nocopy JTF_NUMBER_TABLE
542 , p9_a3 out nocopy JTF_NUMBER_TABLE
543 , p9_a4 out nocopy JTF_NUMBER_TABLE
544 , p9_a5 out nocopy JTF_NUMBER_TABLE
545 , p9_a6 out nocopy JTF_NUMBER_TABLE
546 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
547 , p9_a8 out nocopy JTF_NUMBER_TABLE
548 , p9_a9 out nocopy JTF_NUMBER_TABLE
549 , p9_a10 out nocopy JTF_NUMBER_TABLE
550 , p9_a11 out nocopy JTF_NUMBER_TABLE
551 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
552 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
553 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
554 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
555 , p9_a16 out nocopy JTF_NUMBER_TABLE
556 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
557 , p9_a18 out nocopy JTF_NUMBER_TABLE
558 , p9_a19 out nocopy JTF_NUMBER_TABLE
559 , p9_a20 out nocopy JTF_NUMBER_TABLE
560 , p9_a21 out nocopy JTF_DATE_TABLE
561 , p9_a22 out nocopy JTF_DATE_TABLE
562 , p9_a23 out nocopy JTF_DATE_TABLE
563 , p9_a24 out nocopy JTF_DATE_TABLE
564 , p9_a25 out nocopy JTF_DATE_TABLE
565 , p9_a26 out nocopy JTF_DATE_TABLE
566 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
567 , p9_a28 out nocopy JTF_NUMBER_TABLE
568 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_100
569 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_2000
570 , p9_a31 out nocopy JTF_NUMBER_TABLE
571 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_400
572 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_300
573 , p9_a34 out nocopy JTF_VARCHAR2_TABLE_300
574 , p9_a35 out nocopy JTF_NUMBER_TABLE
575 , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
576 , p9_a37 out nocopy JTF_NUMBER_TABLE
577 , p9_a38 out nocopy JTF_NUMBER_TABLE
578 , p9_a39 out nocopy JTF_NUMBER_TABLE
579 , p9_a40 out nocopy JTF_DATE_TABLE
580 , p9_a41 out nocopy JTF_NUMBER_TABLE
581 , p9_a42 out nocopy JTF_DATE_TABLE
582 , p9_a43 out nocopy JTF_NUMBER_TABLE
583 , p9_a44 out nocopy JTF_VARCHAR2_TABLE_100
584 , p9_a45 out nocopy JTF_VARCHAR2_TABLE_200
585 , p9_a46 out nocopy JTF_VARCHAR2_TABLE_200
586 , p9_a47 out nocopy JTF_VARCHAR2_TABLE_200
587 , p9_a48 out nocopy JTF_VARCHAR2_TABLE_200
588 , p9_a49 out nocopy JTF_VARCHAR2_TABLE_200
589 , p9_a50 out nocopy JTF_VARCHAR2_TABLE_200
590 , p9_a51 out nocopy JTF_VARCHAR2_TABLE_200
591 , p9_a52 out nocopy JTF_VARCHAR2_TABLE_200
592 , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200
593 , p9_a54 out nocopy JTF_VARCHAR2_TABLE_200
594 , p9_a55 out nocopy JTF_VARCHAR2_TABLE_200
595 , p9_a56 out nocopy JTF_VARCHAR2_TABLE_200
596 , p9_a57 out nocopy JTF_VARCHAR2_TABLE_200
597 , p9_a58 out nocopy JTF_VARCHAR2_TABLE_200
598 , p9_a59 out nocopy JTF_VARCHAR2_TABLE_200
599 );
600 end ahl_vwp_visit_cst_pr_pvt_w;
[Home] [Help]