[Home] [Help]
PACKAGE: APPS.AHL_VWP_RULES_PVT_W
Source
1 package ahl_vwp_rules_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWRULS.pls 120.6.12020000.2 2012/12/14 06:13:28 shnatu ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_rules_pvt.mr_serial_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 );
7 procedure rosetta_table_copy_out_p3(t ahl_vwp_rules_pvt.mr_serial_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8 , a1 out nocopy JTF_NUMBER_TABLE
9 , a2 out nocopy JTF_NUMBER_TABLE
10 );
11
12 procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_rules_pvt.item_tbl_type, a0 JTF_NUMBER_TABLE
13 , a1 JTF_NUMBER_TABLE
14 , a2 JTF_NUMBER_TABLE
15 , a3 JTF_NUMBER_TABLE
16 , a4 JTF_DATE_TABLE
17 , a5 JTF_VARCHAR2_TABLE_100
18 );
19 procedure rosetta_table_copy_out_p4(t ahl_vwp_rules_pvt.item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20 , a1 out nocopy JTF_NUMBER_TABLE
21 , a2 out nocopy JTF_NUMBER_TABLE
22 , a3 out nocopy JTF_NUMBER_TABLE
23 , a4 out nocopy JTF_DATE_TABLE
24 , a5 out nocopy JTF_VARCHAR2_TABLE_100
25 );
26
27 procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_rules_pvt.task_tbl_type, a0 JTF_NUMBER_TABLE
28 , a1 JTF_NUMBER_TABLE
29 , a2 JTF_NUMBER_TABLE
30 , a3 JTF_VARCHAR2_TABLE_100
31 , a4 JTF_NUMBER_TABLE
32 , a5 JTF_NUMBER_TABLE
33 , a6 JTF_VARCHAR2_TABLE_100
34 , a7 JTF_NUMBER_TABLE
35 , a8 JTF_NUMBER_TABLE
36 , a9 JTF_NUMBER_TABLE
37 , a10 JTF_VARCHAR2_TABLE_100
38 , a11 JTF_NUMBER_TABLE
39 , a12 JTF_VARCHAR2_TABLE_100
40 , a13 JTF_NUMBER_TABLE
41 , a14 JTF_NUMBER_TABLE
42 , a15 JTF_VARCHAR2_TABLE_300
43 , a16 JTF_NUMBER_TABLE
44 , a17 JTF_VARCHAR2_TABLE_100
45 , a18 JTF_NUMBER_TABLE
46 , a19 JTF_NUMBER_TABLE
47 , a20 JTF_NUMBER_TABLE
48 , a21 JTF_VARCHAR2_TABLE_100
49 , a22 JTF_NUMBER_TABLE
50 , a23 JTF_VARCHAR2_TABLE_100
51 , a24 JTF_NUMBER_TABLE
52 , a25 JTF_NUMBER_TABLE
53 , a26 JTF_NUMBER_TABLE
54 , a27 JTF_VARCHAR2_TABLE_100
55 , a28 JTF_VARCHAR2_TABLE_100
56 , a29 JTF_VARCHAR2_TABLE_100
57 , a30 JTF_VARCHAR2_TABLE_4000
58 , a31 JTF_VARCHAR2_TABLE_100
59 , a32 JTF_VARCHAR2_TABLE_100
60 , a33 JTF_NUMBER_TABLE
61 , a34 JTF_DATE_TABLE
62 , a35 JTF_NUMBER_TABLE
63 , a36 JTF_DATE_TABLE
64 , a37 JTF_NUMBER_TABLE
65 , a38 JTF_NUMBER_TABLE
66 , a39 JTF_VARCHAR2_TABLE_100
67 , a40 JTF_VARCHAR2_TABLE_200
68 , a41 JTF_VARCHAR2_TABLE_200
69 , a42 JTF_VARCHAR2_TABLE_200
70 , a43 JTF_VARCHAR2_TABLE_200
71 , a44 JTF_VARCHAR2_TABLE_200
72 , a45 JTF_VARCHAR2_TABLE_200
73 , a46 JTF_VARCHAR2_TABLE_200
74 , a47 JTF_VARCHAR2_TABLE_200
75 , a48 JTF_VARCHAR2_TABLE_200
76 , a49 JTF_VARCHAR2_TABLE_200
77 , a50 JTF_VARCHAR2_TABLE_200
78 , a51 JTF_VARCHAR2_TABLE_200
79 , a52 JTF_VARCHAR2_TABLE_200
80 , a53 JTF_VARCHAR2_TABLE_200
81 , a54 JTF_VARCHAR2_TABLE_200
82 , a55 JTF_DATE_TABLE
83 , a56 JTF_DATE_TABLE
84 , a57 JTF_DATE_TABLE
85 , a58 JTF_VARCHAR2_TABLE_100
86 , a59 JTF_VARCHAR2_TABLE_100
87 , a60 JTF_NUMBER_TABLE
88 , a61 JTF_NUMBER_TABLE
89 , a62 JTF_VARCHAR2_TABLE_100
90 , a63 JTF_NUMBER_TABLE
91 , a64 JTF_VARCHAR2_TABLE_300
92 , a65 JTF_VARCHAR2_TABLE_100
93 , a66 JTF_DATE_TABLE
94 , a67 JTF_DATE_TABLE
95 , a68 JTF_VARCHAR2_TABLE_100
96 , a69 JTF_VARCHAR2_TABLE_100
97 , a70 JTF_VARCHAR2_TABLE_100
98 , a71 JTF_NUMBER_TABLE
99 , a72 JTF_VARCHAR2_TABLE_100
100 , a73 JTF_NUMBER_TABLE
101 , a74 JTF_VARCHAR2_TABLE_100
102 , a75 JTF_VARCHAR2_TABLE_100
103 , a76 JTF_VARCHAR2_TABLE_100
104 , a77 JTF_VARCHAR2_TABLE_100
105 , a78 JTF_DATE_TABLE
106 , a79 JTF_DATE_TABLE
107 , a80 JTF_NUMBER_TABLE
108 , a81 JTF_NUMBER_TABLE
109 , a82 JTF_NUMBER_TABLE
110 , a83 JTF_VARCHAR2_TABLE_100
111 , a84 JTF_VARCHAR2_TABLE_100
112 , a85 JTF_VARCHAR2_TABLE_100
113 , a86 JTF_VARCHAR2_TABLE_100
114 , a87 JTF_VARCHAR2_TABLE_100
115 , a88 JTF_VARCHAR2_TABLE_100
116 , a89 JTF_VARCHAR2_TABLE_100
117 , a90 JTF_VARCHAR2_TABLE_100
118 , a91 JTF_VARCHAR2_TABLE_100
119 , a92 JTF_VARCHAR2_TABLE_100
120 , a93 JTF_NUMBER_TABLE
121 , a94 JTF_VARCHAR2_TABLE_300
122 );
123 procedure rosetta_table_copy_out_p5(t ahl_vwp_rules_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
124 , a1 out nocopy JTF_NUMBER_TABLE
125 , a2 out nocopy JTF_NUMBER_TABLE
126 , a3 out nocopy JTF_VARCHAR2_TABLE_100
127 , a4 out nocopy JTF_NUMBER_TABLE
128 , a5 out nocopy JTF_NUMBER_TABLE
129 , a6 out nocopy JTF_VARCHAR2_TABLE_100
130 , a7 out nocopy JTF_NUMBER_TABLE
131 , a8 out nocopy JTF_NUMBER_TABLE
132 , a9 out nocopy JTF_NUMBER_TABLE
133 , a10 out nocopy JTF_VARCHAR2_TABLE_100
134 , a11 out nocopy JTF_NUMBER_TABLE
135 , a12 out nocopy JTF_VARCHAR2_TABLE_100
136 , a13 out nocopy JTF_NUMBER_TABLE
137 , a14 out nocopy JTF_NUMBER_TABLE
138 , a15 out nocopy JTF_VARCHAR2_TABLE_300
139 , a16 out nocopy JTF_NUMBER_TABLE
140 , a17 out nocopy JTF_VARCHAR2_TABLE_100
141 , a18 out nocopy JTF_NUMBER_TABLE
142 , a19 out nocopy JTF_NUMBER_TABLE
143 , a20 out nocopy JTF_NUMBER_TABLE
144 , a21 out nocopy JTF_VARCHAR2_TABLE_100
145 , a22 out nocopy JTF_NUMBER_TABLE
146 , a23 out nocopy JTF_VARCHAR2_TABLE_100
147 , a24 out nocopy JTF_NUMBER_TABLE
148 , a25 out nocopy JTF_NUMBER_TABLE
149 , a26 out nocopy JTF_NUMBER_TABLE
150 , a27 out nocopy JTF_VARCHAR2_TABLE_100
151 , a28 out nocopy JTF_VARCHAR2_TABLE_100
152 , a29 out nocopy JTF_VARCHAR2_TABLE_100
153 , a30 out nocopy JTF_VARCHAR2_TABLE_4000
154 , a31 out nocopy JTF_VARCHAR2_TABLE_100
155 , a32 out nocopy JTF_VARCHAR2_TABLE_100
156 , a33 out nocopy JTF_NUMBER_TABLE
157 , a34 out nocopy JTF_DATE_TABLE
158 , a35 out nocopy JTF_NUMBER_TABLE
159 , a36 out nocopy JTF_DATE_TABLE
160 , a37 out nocopy JTF_NUMBER_TABLE
161 , a38 out nocopy JTF_NUMBER_TABLE
162 , a39 out nocopy JTF_VARCHAR2_TABLE_100
163 , a40 out nocopy JTF_VARCHAR2_TABLE_200
164 , a41 out nocopy JTF_VARCHAR2_TABLE_200
165 , a42 out nocopy JTF_VARCHAR2_TABLE_200
166 , a43 out nocopy JTF_VARCHAR2_TABLE_200
167 , a44 out nocopy JTF_VARCHAR2_TABLE_200
168 , a45 out nocopy JTF_VARCHAR2_TABLE_200
169 , a46 out nocopy JTF_VARCHAR2_TABLE_200
170 , a47 out nocopy JTF_VARCHAR2_TABLE_200
171 , a48 out nocopy JTF_VARCHAR2_TABLE_200
172 , a49 out nocopy JTF_VARCHAR2_TABLE_200
173 , a50 out nocopy JTF_VARCHAR2_TABLE_200
174 , a51 out nocopy JTF_VARCHAR2_TABLE_200
175 , a52 out nocopy JTF_VARCHAR2_TABLE_200
176 , a53 out nocopy JTF_VARCHAR2_TABLE_200
177 , a54 out nocopy JTF_VARCHAR2_TABLE_200
178 , a55 out nocopy JTF_DATE_TABLE
179 , a56 out nocopy JTF_DATE_TABLE
180 , a57 out nocopy JTF_DATE_TABLE
181 , a58 out nocopy JTF_VARCHAR2_TABLE_100
182 , a59 out nocopy JTF_VARCHAR2_TABLE_100
183 , a60 out nocopy JTF_NUMBER_TABLE
184 , a61 out nocopy JTF_NUMBER_TABLE
185 , a62 out nocopy JTF_VARCHAR2_TABLE_100
186 , a63 out nocopy JTF_NUMBER_TABLE
187 , a64 out nocopy JTF_VARCHAR2_TABLE_300
188 , a65 out nocopy JTF_VARCHAR2_TABLE_100
189 , a66 out nocopy JTF_DATE_TABLE
190 , a67 out nocopy JTF_DATE_TABLE
191 , a68 out nocopy JTF_VARCHAR2_TABLE_100
192 , a69 out nocopy JTF_VARCHAR2_TABLE_100
193 , a70 out nocopy JTF_VARCHAR2_TABLE_100
194 , a71 out nocopy JTF_NUMBER_TABLE
195 , a72 out nocopy JTF_VARCHAR2_TABLE_100
196 , a73 out nocopy JTF_NUMBER_TABLE
197 , a74 out nocopy JTF_VARCHAR2_TABLE_100
198 , a75 out nocopy JTF_VARCHAR2_TABLE_100
199 , a76 out nocopy JTF_VARCHAR2_TABLE_100
200 , a77 out nocopy JTF_VARCHAR2_TABLE_100
201 , a78 out nocopy JTF_DATE_TABLE
202 , a79 out nocopy JTF_DATE_TABLE
203 , a80 out nocopy JTF_NUMBER_TABLE
204 , a81 out nocopy JTF_NUMBER_TABLE
205 , a82 out nocopy JTF_NUMBER_TABLE
206 , a83 out nocopy JTF_VARCHAR2_TABLE_100
207 , a84 out nocopy JTF_VARCHAR2_TABLE_100
208 , a85 out nocopy JTF_VARCHAR2_TABLE_100
209 , a86 out nocopy JTF_VARCHAR2_TABLE_100
210 , a87 out nocopy JTF_VARCHAR2_TABLE_100
211 , a88 out nocopy JTF_VARCHAR2_TABLE_100
212 , a89 out nocopy JTF_VARCHAR2_TABLE_100
213 , a90 out nocopy JTF_VARCHAR2_TABLE_100
214 , a91 out nocopy JTF_VARCHAR2_TABLE_100
215 , a92 out nocopy JTF_VARCHAR2_TABLE_100
216 , a93 out nocopy JTF_NUMBER_TABLE
217 , a94 out nocopy JTF_VARCHAR2_TABLE_300
218 );
219
220 procedure insert_tasks(p_visit_id NUMBER
221 , p_unit_id NUMBER
222 , p_serial_id NUMBER
223 , p_service_id NUMBER
224 , p_dept_id NUMBER
225 , p_item_id NUMBER
226 , p_item_org_id NUMBER
227 , p_mr_id NUMBER
228 , p_mr_route_id NUMBER
229 , p_parent_id NUMBER
230 , p_flag VARCHAR2
231 , p_stage_id NUMBER
232 , p_past_task_start_date date
233 , p_past_task_end_date date
234 , p_quantity NUMBER
235 , p_task_start_date date
236 , p_service_type_code VARCHAR2
237 , x_task_id out nocopy NUMBER
238 , x_return_status out nocopy VARCHAR2
239 , x_msg_count out nocopy NUMBER
240 , x_msg_data out nocopy VARCHAR2
241 );
242 procedure tech_dependency(p_visit_id NUMBER
243 , p_task_type VARCHAR2
244 , p2_a0 JTF_NUMBER_TABLE
245 , p2_a1 JTF_NUMBER_TABLE
246 , p2_a2 JTF_NUMBER_TABLE
247 , x_return_status out nocopy VARCHAR2
248 );
249 procedure create_tasks_for_mr(p_visit_id NUMBER
250 , p_unit_id NUMBER
251 , p_item_id NUMBER
252 , p_org_id NUMBER
253 , p_serial_id NUMBER
254 , p_mr_id NUMBER
255 , p_department_id NUMBER
256 , p_service_req_id NUMBER
257 , p_past_task_start_date date
258 , p_past_task_end_date date
259 , p_quantity NUMBER
260 , p_task_start_date date
261 , p_service_type_code VARCHAR2
262 , p_x_parent_mr_id in out nocopy NUMBER
263 , x_return_status out nocopy VARCHAR2
264 );
265 procedure merge_for_unique_items(p0_a0 JTF_NUMBER_TABLE
266 , p0_a1 JTF_NUMBER_TABLE
267 , p0_a2 JTF_NUMBER_TABLE
268 , p0_a3 JTF_NUMBER_TABLE
269 , p0_a4 JTF_DATE_TABLE
270 , p0_a5 JTF_VARCHAR2_TABLE_100
271 , p1_a0 JTF_NUMBER_TABLE
272 , p1_a1 JTF_NUMBER_TABLE
273 , p1_a2 JTF_NUMBER_TABLE
274 , p1_a3 JTF_NUMBER_TABLE
275 , p1_a4 JTF_DATE_TABLE
276 , p1_a5 JTF_VARCHAR2_TABLE_100
277 , p2_a0 out nocopy JTF_NUMBER_TABLE
278 , p2_a1 out nocopy JTF_NUMBER_TABLE
279 , p2_a2 out nocopy JTF_NUMBER_TABLE
280 , p2_a3 out nocopy JTF_NUMBER_TABLE
281 , p2_a4 out nocopy JTF_DATE_TABLE
282 , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
283 );
284 procedure validate_past_task_dates(p0_a0 in out nocopy NUMBER
285 , p0_a1 in out nocopy NUMBER
286 , p0_a2 in out nocopy NUMBER
287 , p0_a3 in out nocopy VARCHAR2
288 , p0_a4 in out nocopy NUMBER
289 , p0_a5 in out nocopy NUMBER
290 , p0_a6 in out nocopy VARCHAR2
291 , p0_a7 in out nocopy NUMBER
292 , p0_a8 in out nocopy NUMBER
293 , p0_a9 in out nocopy NUMBER
294 , p0_a10 in out nocopy VARCHAR2
295 , p0_a11 in out nocopy NUMBER
296 , p0_a12 in out nocopy VARCHAR2
297 , p0_a13 in out nocopy NUMBER
298 , p0_a14 in out nocopy NUMBER
299 , p0_a15 in out nocopy VARCHAR2
300 , p0_a16 in out nocopy NUMBER
301 , p0_a17 in out nocopy VARCHAR2
302 , p0_a18 in out nocopy NUMBER
303 , p0_a19 in out nocopy NUMBER
304 , p0_a20 in out nocopy NUMBER
305 , p0_a21 in out nocopy VARCHAR2
306 , p0_a22 in out nocopy NUMBER
307 , p0_a23 in out nocopy VARCHAR2
308 , p0_a24 in out nocopy NUMBER
309 , p0_a25 in out nocopy NUMBER
310 , p0_a26 in out nocopy NUMBER
311 , p0_a27 in out nocopy VARCHAR2
312 , p0_a28 in out nocopy VARCHAR2
313 , p0_a29 in out nocopy VARCHAR2
314 , p0_a30 in out nocopy VARCHAR2
315 , p0_a31 in out nocopy VARCHAR2
316 , p0_a32 in out nocopy VARCHAR2
317 , p0_a33 in out nocopy NUMBER
318 , p0_a34 in out nocopy DATE
319 , p0_a35 in out nocopy NUMBER
320 , p0_a36 in out nocopy DATE
321 , p0_a37 in out nocopy NUMBER
322 , p0_a38 in out nocopy NUMBER
323 , p0_a39 in out nocopy VARCHAR2
324 , p0_a40 in out nocopy VARCHAR2
325 , p0_a41 in out nocopy VARCHAR2
326 , p0_a42 in out nocopy VARCHAR2
327 , p0_a43 in out nocopy VARCHAR2
328 , p0_a44 in out nocopy VARCHAR2
329 , p0_a45 in out nocopy VARCHAR2
330 , p0_a46 in out nocopy VARCHAR2
331 , p0_a47 in out nocopy VARCHAR2
332 , p0_a48 in out nocopy VARCHAR2
333 , p0_a49 in out nocopy VARCHAR2
334 , p0_a50 in out nocopy VARCHAR2
335 , p0_a51 in out nocopy VARCHAR2
336 , p0_a52 in out nocopy VARCHAR2
337 , p0_a53 in out nocopy VARCHAR2
338 , p0_a54 in out nocopy VARCHAR2
339 , p0_a55 in out nocopy DATE
340 , p0_a56 in out nocopy DATE
341 , p0_a57 in out nocopy DATE
342 , p0_a58 in out nocopy VARCHAR2
343 , p0_a59 in out nocopy VARCHAR2
344 , p0_a60 in out nocopy NUMBER
345 , p0_a61 in out nocopy NUMBER
346 , p0_a62 in out nocopy VARCHAR2
347 , p0_a63 in out nocopy NUMBER
348 , p0_a64 in out nocopy VARCHAR2
349 , p0_a65 in out nocopy VARCHAR2
350 , p0_a66 in out nocopy DATE
351 , p0_a67 in out nocopy DATE
352 , p0_a68 in out nocopy VARCHAR2
353 , p0_a69 in out nocopy VARCHAR2
354 , p0_a70 in out nocopy VARCHAR2
355 , p0_a71 in out nocopy NUMBER
356 , p0_a72 in out nocopy VARCHAR2
357 , p0_a73 in out nocopy NUMBER
358 , p0_a74 in out nocopy VARCHAR2
359 , p0_a75 in out nocopy VARCHAR2
360 , p0_a76 in out nocopy VARCHAR2
361 , p0_a77 in out nocopy VARCHAR2
362 , p0_a78 in out nocopy DATE
363 , p0_a79 in out nocopy DATE
364 , p0_a80 in out nocopy NUMBER
365 , p0_a81 in out nocopy NUMBER
366 , p0_a82 in out nocopy NUMBER
367 , p0_a83 in out nocopy VARCHAR2
368 , p0_a84 in out nocopy VARCHAR2
369 , p0_a85 in out nocopy VARCHAR2
370 , p0_a86 in out nocopy VARCHAR2
371 , p0_a87 in out nocopy VARCHAR2
372 , p0_a88 in out nocopy VARCHAR2
373 , p0_a89 in out nocopy VARCHAR2
374 , p0_a90 in out nocopy VARCHAR2
375 , p0_a91 in out nocopy VARCHAR2
376 , p0_a92 in out nocopy VARCHAR2
377 , p0_a93 in out nocopy NUMBER
378 , p0_a94 in out nocopy VARCHAR2
379 , x_return_status out nocopy VARCHAR2
380 );
381 procedure get_warranty_rec_for_create(p_task_id NUMBER
382 , p_instance_id NUMBER
383 , p_service_req_id NUMBER
384 , p3_a0 out nocopy JTF_NUMBER_TABLE
385 , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
386 , p3_a2 out nocopy JTF_NUMBER_TABLE
387 , p3_a3 out nocopy JTF_DATE_TABLE
388 , p3_a4 out nocopy JTF_NUMBER_TABLE
389 , p3_a5 out nocopy JTF_DATE_TABLE
390 , p3_a6 out nocopy JTF_NUMBER_TABLE
391 , p3_a7 out nocopy JTF_NUMBER_TABLE
392 , p3_a8 out nocopy JTF_NUMBER_TABLE
393 , p3_a9 out nocopy JTF_NUMBER_TABLE
394 , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
395 , p3_a11 out nocopy JTF_NUMBER_TABLE
396 , p3_a12 out nocopy JTF_NUMBER_TABLE
397 , p3_a13 out nocopy JTF_NUMBER_TABLE
398 , p3_a14 out nocopy JTF_NUMBER_TABLE
399 , p3_a15 out nocopy JTF_NUMBER_TABLE
400 , p3_a16 out nocopy JTF_NUMBER_TABLE
401 , p3_a17 out nocopy JTF_VARCHAR2_TABLE_100
402 , p3_a18 out nocopy JTF_VARCHAR2_TABLE_100
403 , p3_a19 out nocopy JTF_NUMBER_TABLE
404 , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
405 , p3_a21 out nocopy JTF_VARCHAR2_TABLE_200
406 , p3_a22 out nocopy JTF_VARCHAR2_TABLE_200
407 , p3_a23 out nocopy JTF_VARCHAR2_TABLE_200
408 , p3_a24 out nocopy JTF_VARCHAR2_TABLE_200
409 , p3_a25 out nocopy JTF_VARCHAR2_TABLE_200
410 , p3_a26 out nocopy JTF_VARCHAR2_TABLE_200
411 , p3_a27 out nocopy JTF_VARCHAR2_TABLE_200
412 , p3_a28 out nocopy JTF_VARCHAR2_TABLE_200
413 , p3_a29 out nocopy JTF_VARCHAR2_TABLE_200
414 , p3_a30 out nocopy JTF_VARCHAR2_TABLE_200
415 , p3_a31 out nocopy JTF_VARCHAR2_TABLE_200
416 , p3_a32 out nocopy JTF_VARCHAR2_TABLE_200
417 , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
418 , p3_a34 out nocopy JTF_VARCHAR2_TABLE_200
419 , p3_a35 out nocopy JTF_VARCHAR2_TABLE_200
420 );
421 procedure get_warranty_rec_for_update(p0_a0 NUMBER
422 , p0_a1 NUMBER
423 , p0_a2 NUMBER
424 , p0_a3 VARCHAR2
425 , p0_a4 NUMBER
426 , p0_a5 NUMBER
427 , p0_a6 VARCHAR2
428 , p0_a7 NUMBER
429 , p0_a8 NUMBER
430 , p0_a9 NUMBER
431 , p0_a10 VARCHAR2
432 , p0_a11 NUMBER
433 , p0_a12 VARCHAR2
434 , p0_a13 NUMBER
435 , p0_a14 NUMBER
436 , p0_a15 VARCHAR2
437 , p0_a16 NUMBER
438 , p0_a17 VARCHAR2
439 , p0_a18 NUMBER
440 , p0_a19 NUMBER
441 , p0_a20 NUMBER
442 , p0_a21 VARCHAR2
443 , p0_a22 NUMBER
444 , p0_a23 VARCHAR2
445 , p0_a24 NUMBER
446 , p0_a25 NUMBER
447 , p0_a26 NUMBER
448 , p0_a27 VARCHAR2
449 , p0_a28 VARCHAR2
450 , p0_a29 VARCHAR2
451 , p0_a30 VARCHAR2
452 , p0_a31 VARCHAR2
453 , p0_a32 VARCHAR2
454 , p0_a33 NUMBER
455 , p0_a34 DATE
456 , p0_a35 NUMBER
457 , p0_a36 DATE
458 , p0_a37 NUMBER
459 , p0_a38 NUMBER
460 , p0_a39 VARCHAR2
461 , p0_a40 VARCHAR2
462 , p0_a41 VARCHAR2
463 , p0_a42 VARCHAR2
464 , p0_a43 VARCHAR2
465 , p0_a44 VARCHAR2
466 , p0_a45 VARCHAR2
467 , p0_a46 VARCHAR2
468 , p0_a47 VARCHAR2
469 , p0_a48 VARCHAR2
470 , p0_a49 VARCHAR2
471 , p0_a50 VARCHAR2
472 , p0_a51 VARCHAR2
473 , p0_a52 VARCHAR2
474 , p0_a53 VARCHAR2
475 , p0_a54 VARCHAR2
476 , p0_a55 DATE
477 , p0_a56 DATE
478 , p0_a57 DATE
479 , p0_a58 VARCHAR2
480 , p0_a59 VARCHAR2
481 , p0_a60 NUMBER
482 , p0_a61 NUMBER
483 , p0_a62 VARCHAR2
484 , p0_a63 NUMBER
485 , p0_a64 VARCHAR2
486 , p0_a65 VARCHAR2
487 , p0_a66 DATE
488 , p0_a67 DATE
489 , p0_a68 VARCHAR2
490 , p0_a69 VARCHAR2
491 , p0_a70 VARCHAR2
492 , p0_a71 NUMBER
493 , p0_a72 VARCHAR2
494 , p0_a73 NUMBER
495 , p0_a74 VARCHAR2
496 , p0_a75 VARCHAR2
497 , p0_a76 VARCHAR2
498 , p0_a77 VARCHAR2
499 , p0_a78 DATE
500 , p0_a79 DATE
501 , p0_a80 NUMBER
502 , p0_a81 NUMBER
503 , p0_a82 NUMBER
504 , p0_a83 VARCHAR2
505 , p0_a84 VARCHAR2
506 , p0_a85 VARCHAR2
507 , p0_a86 VARCHAR2
508 , p0_a87 VARCHAR2
509 , p0_a88 VARCHAR2
510 , p0_a89 VARCHAR2
511 , p0_a90 VARCHAR2
512 , p0_a91 VARCHAR2
513 , p0_a92 VARCHAR2
514 , p0_a93 NUMBER
515 , p0_a94 VARCHAR2
516 , p1_a0 out nocopy JTF_NUMBER_TABLE
517 , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
518 , p1_a2 out nocopy JTF_NUMBER_TABLE
519 , p1_a3 out nocopy JTF_DATE_TABLE
520 , p1_a4 out nocopy JTF_NUMBER_TABLE
521 , p1_a5 out nocopy JTF_DATE_TABLE
522 , p1_a6 out nocopy JTF_NUMBER_TABLE
523 , p1_a7 out nocopy JTF_NUMBER_TABLE
524 , p1_a8 out nocopy JTF_NUMBER_TABLE
525 , p1_a9 out nocopy JTF_NUMBER_TABLE
526 , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100
527 , p1_a11 out nocopy JTF_NUMBER_TABLE
528 , p1_a12 out nocopy JTF_NUMBER_TABLE
529 , p1_a13 out nocopy JTF_NUMBER_TABLE
530 , p1_a14 out nocopy JTF_NUMBER_TABLE
531 , p1_a15 out nocopy JTF_NUMBER_TABLE
532 , p1_a16 out nocopy JTF_NUMBER_TABLE
533 , p1_a17 out nocopy JTF_VARCHAR2_TABLE_100
534 , p1_a18 out nocopy JTF_VARCHAR2_TABLE_100
535 , p1_a19 out nocopy JTF_NUMBER_TABLE
536 , p1_a20 out nocopy JTF_VARCHAR2_TABLE_100
537 , p1_a21 out nocopy JTF_VARCHAR2_TABLE_200
538 , p1_a22 out nocopy JTF_VARCHAR2_TABLE_200
539 , p1_a23 out nocopy JTF_VARCHAR2_TABLE_200
540 , p1_a24 out nocopy JTF_VARCHAR2_TABLE_200
541 , p1_a25 out nocopy JTF_VARCHAR2_TABLE_200
542 , p1_a26 out nocopy JTF_VARCHAR2_TABLE_200
543 , p1_a27 out nocopy JTF_VARCHAR2_TABLE_200
544 , p1_a28 out nocopy JTF_VARCHAR2_TABLE_200
545 , p1_a29 out nocopy JTF_VARCHAR2_TABLE_200
546 , p1_a30 out nocopy JTF_VARCHAR2_TABLE_200
547 , p1_a31 out nocopy JTF_VARCHAR2_TABLE_200
548 , p1_a32 out nocopy JTF_VARCHAR2_TABLE_200
549 , p1_a33 out nocopy JTF_VARCHAR2_TABLE_200
550 , p1_a34 out nocopy JTF_VARCHAR2_TABLE_200
551 , p1_a35 out nocopy JTF_VARCHAR2_TABLE_200
552 );
553 procedure handle_task_dependency(p_api_version NUMBER
554 , p_init_msg_list VARCHAR2
555 , p_commit VARCHAR2
556 , p_validation_level NUMBER
557 , p_visit_id NUMBER
558 , p5_a0 JTF_NUMBER_TABLE
559 , p5_a1 JTF_NUMBER_TABLE
560 , p5_a2 JTF_NUMBER_TABLE
561 , p5_a3 JTF_VARCHAR2_TABLE_100
562 , p5_a4 JTF_NUMBER_TABLE
563 , p5_a5 JTF_NUMBER_TABLE
564 , p5_a6 JTF_VARCHAR2_TABLE_100
565 , p5_a7 JTF_NUMBER_TABLE
566 , p5_a8 JTF_NUMBER_TABLE
567 , p5_a9 JTF_NUMBER_TABLE
568 , p5_a10 JTF_VARCHAR2_TABLE_100
569 , p5_a11 JTF_NUMBER_TABLE
570 , p5_a12 JTF_VARCHAR2_TABLE_100
571 , p5_a13 JTF_NUMBER_TABLE
572 , p5_a14 JTF_NUMBER_TABLE
573 , p5_a15 JTF_VARCHAR2_TABLE_300
574 , p5_a16 JTF_NUMBER_TABLE
575 , p5_a17 JTF_VARCHAR2_TABLE_100
576 , p5_a18 JTF_NUMBER_TABLE
577 , p5_a19 JTF_NUMBER_TABLE
578 , p5_a20 JTF_NUMBER_TABLE
579 , p5_a21 JTF_VARCHAR2_TABLE_100
580 , p5_a22 JTF_NUMBER_TABLE
581 , p5_a23 JTF_VARCHAR2_TABLE_100
582 , p5_a24 JTF_NUMBER_TABLE
583 , p5_a25 JTF_NUMBER_TABLE
584 , p5_a26 JTF_NUMBER_TABLE
585 , p5_a27 JTF_VARCHAR2_TABLE_100
586 , p5_a28 JTF_VARCHAR2_TABLE_100
587 , p5_a29 JTF_VARCHAR2_TABLE_100
588 , p5_a30 JTF_VARCHAR2_TABLE_4000
589 , p5_a31 JTF_VARCHAR2_TABLE_100
590 , p5_a32 JTF_VARCHAR2_TABLE_100
591 , p5_a33 JTF_NUMBER_TABLE
592 , p5_a34 JTF_DATE_TABLE
593 , p5_a35 JTF_NUMBER_TABLE
594 , p5_a36 JTF_DATE_TABLE
595 , p5_a37 JTF_NUMBER_TABLE
596 , p5_a38 JTF_NUMBER_TABLE
597 , p5_a39 JTF_VARCHAR2_TABLE_100
598 , p5_a40 JTF_VARCHAR2_TABLE_200
599 , p5_a41 JTF_VARCHAR2_TABLE_200
600 , p5_a42 JTF_VARCHAR2_TABLE_200
601 , p5_a43 JTF_VARCHAR2_TABLE_200
602 , p5_a44 JTF_VARCHAR2_TABLE_200
603 , p5_a45 JTF_VARCHAR2_TABLE_200
604 , p5_a46 JTF_VARCHAR2_TABLE_200
605 , p5_a47 JTF_VARCHAR2_TABLE_200
606 , p5_a48 JTF_VARCHAR2_TABLE_200
607 , p5_a49 JTF_VARCHAR2_TABLE_200
608 , p5_a50 JTF_VARCHAR2_TABLE_200
609 , p5_a51 JTF_VARCHAR2_TABLE_200
610 , p5_a52 JTF_VARCHAR2_TABLE_200
611 , p5_a53 JTF_VARCHAR2_TABLE_200
612 , p5_a54 JTF_VARCHAR2_TABLE_200
613 , p5_a55 JTF_DATE_TABLE
614 , p5_a56 JTF_DATE_TABLE
615 , p5_a57 JTF_DATE_TABLE
616 , p5_a58 JTF_VARCHAR2_TABLE_100
617 , p5_a59 JTF_VARCHAR2_TABLE_100
618 , p5_a60 JTF_NUMBER_TABLE
619 , p5_a61 JTF_NUMBER_TABLE
620 , p5_a62 JTF_VARCHAR2_TABLE_100
621 , p5_a63 JTF_NUMBER_TABLE
622 , p5_a64 JTF_VARCHAR2_TABLE_300
623 , p5_a65 JTF_VARCHAR2_TABLE_100
624 , p5_a66 JTF_DATE_TABLE
625 , p5_a67 JTF_DATE_TABLE
626 , p5_a68 JTF_VARCHAR2_TABLE_100
627 , p5_a69 JTF_VARCHAR2_TABLE_100
628 , p5_a70 JTF_VARCHAR2_TABLE_100
629 , p5_a71 JTF_NUMBER_TABLE
630 , p5_a72 JTF_VARCHAR2_TABLE_100
631 , p5_a73 JTF_NUMBER_TABLE
632 , p5_a74 JTF_VARCHAR2_TABLE_100
633 , p5_a75 JTF_VARCHAR2_TABLE_100
634 , p5_a76 JTF_VARCHAR2_TABLE_100
635 , p5_a77 JTF_VARCHAR2_TABLE_100
636 , p5_a78 JTF_DATE_TABLE
637 , p5_a79 JTF_DATE_TABLE
638 , p5_a80 JTF_NUMBER_TABLE
639 , p5_a81 JTF_NUMBER_TABLE
640 , p5_a82 JTF_NUMBER_TABLE
641 , p5_a83 JTF_VARCHAR2_TABLE_100
642 , p5_a84 JTF_VARCHAR2_TABLE_100
643 , p5_a85 JTF_VARCHAR2_TABLE_100
644 , p5_a86 JTF_VARCHAR2_TABLE_100
645 , p5_a87 JTF_VARCHAR2_TABLE_100
646 , p5_a88 JTF_VARCHAR2_TABLE_100
647 , p5_a89 JTF_VARCHAR2_TABLE_100
648 , p5_a90 JTF_VARCHAR2_TABLE_100
649 , p5_a91 JTF_VARCHAR2_TABLE_100
650 , p5_a92 JTF_VARCHAR2_TABLE_100
651 , p5_a93 JTF_NUMBER_TABLE
652 , p5_a94 JTF_VARCHAR2_TABLE_300
653 , x_return_status out nocopy VARCHAR2
654 , x_msg_count out nocopy NUMBER
655 , x_msg_data out nocopy VARCHAR2
656 );
657 procedure warranty_not_applicable(p_api_version NUMBER
658 , p_init_msg_list VARCHAR2
659 , p_commit VARCHAR2
660 , p_validation_level NUMBER
661 , p4_a0 JTF_NUMBER_TABLE
662 , p4_a1 JTF_NUMBER_TABLE
663 , p4_a2 JTF_NUMBER_TABLE
664 , p4_a3 JTF_VARCHAR2_TABLE_100
665 , p4_a4 JTF_NUMBER_TABLE
666 , p4_a5 JTF_NUMBER_TABLE
667 , p4_a6 JTF_VARCHAR2_TABLE_100
668 , p4_a7 JTF_NUMBER_TABLE
669 , p4_a8 JTF_NUMBER_TABLE
670 , p4_a9 JTF_NUMBER_TABLE
671 , p4_a10 JTF_VARCHAR2_TABLE_100
672 , p4_a11 JTF_NUMBER_TABLE
673 , p4_a12 JTF_VARCHAR2_TABLE_100
674 , p4_a13 JTF_NUMBER_TABLE
675 , p4_a14 JTF_NUMBER_TABLE
676 , p4_a15 JTF_VARCHAR2_TABLE_300
677 , p4_a16 JTF_NUMBER_TABLE
678 , p4_a17 JTF_VARCHAR2_TABLE_100
679 , p4_a18 JTF_NUMBER_TABLE
680 , p4_a19 JTF_NUMBER_TABLE
681 , p4_a20 JTF_NUMBER_TABLE
682 , p4_a21 JTF_VARCHAR2_TABLE_100
683 , p4_a22 JTF_NUMBER_TABLE
684 , p4_a23 JTF_VARCHAR2_TABLE_100
685 , p4_a24 JTF_NUMBER_TABLE
686 , p4_a25 JTF_NUMBER_TABLE
687 , p4_a26 JTF_NUMBER_TABLE
688 , p4_a27 JTF_VARCHAR2_TABLE_100
689 , p4_a28 JTF_VARCHAR2_TABLE_100
690 , p4_a29 JTF_VARCHAR2_TABLE_100
691 , p4_a30 JTF_VARCHAR2_TABLE_4000
692 , p4_a31 JTF_VARCHAR2_TABLE_100
693 , p4_a32 JTF_VARCHAR2_TABLE_100
694 , p4_a33 JTF_NUMBER_TABLE
695 , p4_a34 JTF_DATE_TABLE
696 , p4_a35 JTF_NUMBER_TABLE
697 , p4_a36 JTF_DATE_TABLE
698 , p4_a37 JTF_NUMBER_TABLE
699 , p4_a38 JTF_NUMBER_TABLE
700 , p4_a39 JTF_VARCHAR2_TABLE_100
701 , p4_a40 JTF_VARCHAR2_TABLE_200
702 , p4_a41 JTF_VARCHAR2_TABLE_200
703 , p4_a42 JTF_VARCHAR2_TABLE_200
704 , p4_a43 JTF_VARCHAR2_TABLE_200
705 , p4_a44 JTF_VARCHAR2_TABLE_200
706 , p4_a45 JTF_VARCHAR2_TABLE_200
707 , p4_a46 JTF_VARCHAR2_TABLE_200
708 , p4_a47 JTF_VARCHAR2_TABLE_200
709 , p4_a48 JTF_VARCHAR2_TABLE_200
710 , p4_a49 JTF_VARCHAR2_TABLE_200
711 , p4_a50 JTF_VARCHAR2_TABLE_200
712 , p4_a51 JTF_VARCHAR2_TABLE_200
713 , p4_a52 JTF_VARCHAR2_TABLE_200
714 , p4_a53 JTF_VARCHAR2_TABLE_200
715 , p4_a54 JTF_VARCHAR2_TABLE_200
716 , p4_a55 JTF_DATE_TABLE
717 , p4_a56 JTF_DATE_TABLE
718 , p4_a57 JTF_DATE_TABLE
719 , p4_a58 JTF_VARCHAR2_TABLE_100
720 , p4_a59 JTF_VARCHAR2_TABLE_100
721 , p4_a60 JTF_NUMBER_TABLE
722 , p4_a61 JTF_NUMBER_TABLE
723 , p4_a62 JTF_VARCHAR2_TABLE_100
724 , p4_a63 JTF_NUMBER_TABLE
725 , p4_a64 JTF_VARCHAR2_TABLE_300
726 , p4_a65 JTF_VARCHAR2_TABLE_100
727 , p4_a66 JTF_DATE_TABLE
728 , p4_a67 JTF_DATE_TABLE
729 , p4_a68 JTF_VARCHAR2_TABLE_100
730 , p4_a69 JTF_VARCHAR2_TABLE_100
731 , p4_a70 JTF_VARCHAR2_TABLE_100
732 , p4_a71 JTF_NUMBER_TABLE
733 , p4_a72 JTF_VARCHAR2_TABLE_100
734 , p4_a73 JTF_NUMBER_TABLE
735 , p4_a74 JTF_VARCHAR2_TABLE_100
736 , p4_a75 JTF_VARCHAR2_TABLE_100
737 , p4_a76 JTF_VARCHAR2_TABLE_100
738 , p4_a77 JTF_VARCHAR2_TABLE_100
739 , p4_a78 JTF_DATE_TABLE
740 , p4_a79 JTF_DATE_TABLE
741 , p4_a80 JTF_NUMBER_TABLE
742 , p4_a81 JTF_NUMBER_TABLE
743 , p4_a82 JTF_NUMBER_TABLE
744 , p4_a83 JTF_VARCHAR2_TABLE_100
745 , p4_a84 JTF_VARCHAR2_TABLE_100
746 , p4_a85 JTF_VARCHAR2_TABLE_100
747 , p4_a86 JTF_VARCHAR2_TABLE_100
748 , p4_a87 JTF_VARCHAR2_TABLE_100
749 , p4_a88 JTF_VARCHAR2_TABLE_100
750 , p4_a89 JTF_VARCHAR2_TABLE_100
751 , p4_a90 JTF_VARCHAR2_TABLE_100
752 , p4_a91 JTF_VARCHAR2_TABLE_100
753 , p4_a92 JTF_VARCHAR2_TABLE_100
754 , p4_a93 JTF_NUMBER_TABLE
755 , p4_a94 JTF_VARCHAR2_TABLE_300
756 , x_return_status out nocopy VARCHAR2
757 , x_msg_count out nocopy NUMBER
758 , x_msg_data out nocopy VARCHAR2
759 );
760 procedure add_return_to_supply(p_api_version NUMBER
761 , p_init_msg_list VARCHAR2
762 , p_commit VARCHAR2
763 , p_validation_level NUMBER
764 , p4_a0 JTF_NUMBER_TABLE
765 , p4_a1 JTF_NUMBER_TABLE
766 , p4_a2 JTF_NUMBER_TABLE
767 , p4_a3 JTF_VARCHAR2_TABLE_100
768 , p4_a4 JTF_NUMBER_TABLE
769 , p4_a5 JTF_NUMBER_TABLE
770 , p4_a6 JTF_VARCHAR2_TABLE_100
771 , p4_a7 JTF_NUMBER_TABLE
772 , p4_a8 JTF_NUMBER_TABLE
773 , p4_a9 JTF_NUMBER_TABLE
774 , p4_a10 JTF_VARCHAR2_TABLE_100
775 , p4_a11 JTF_NUMBER_TABLE
776 , p4_a12 JTF_VARCHAR2_TABLE_100
777 , p4_a13 JTF_NUMBER_TABLE
778 , p4_a14 JTF_NUMBER_TABLE
779 , p4_a15 JTF_VARCHAR2_TABLE_300
780 , p4_a16 JTF_NUMBER_TABLE
781 , p4_a17 JTF_VARCHAR2_TABLE_100
782 , p4_a18 JTF_NUMBER_TABLE
783 , p4_a19 JTF_NUMBER_TABLE
784 , p4_a20 JTF_NUMBER_TABLE
785 , p4_a21 JTF_VARCHAR2_TABLE_100
786 , p4_a22 JTF_NUMBER_TABLE
787 , p4_a23 JTF_VARCHAR2_TABLE_100
788 , p4_a24 JTF_NUMBER_TABLE
789 , p4_a25 JTF_NUMBER_TABLE
790 , p4_a26 JTF_NUMBER_TABLE
791 , p4_a27 JTF_VARCHAR2_TABLE_100
792 , p4_a28 JTF_VARCHAR2_TABLE_100
793 , p4_a29 JTF_VARCHAR2_TABLE_100
794 , p4_a30 JTF_VARCHAR2_TABLE_4000
795 , p4_a31 JTF_VARCHAR2_TABLE_100
796 , p4_a32 JTF_VARCHAR2_TABLE_100
797 , p4_a33 JTF_NUMBER_TABLE
798 , p4_a34 JTF_DATE_TABLE
799 , p4_a35 JTF_NUMBER_TABLE
800 , p4_a36 JTF_DATE_TABLE
801 , p4_a37 JTF_NUMBER_TABLE
802 , p4_a38 JTF_NUMBER_TABLE
803 , p4_a39 JTF_VARCHAR2_TABLE_100
804 , p4_a40 JTF_VARCHAR2_TABLE_200
805 , p4_a41 JTF_VARCHAR2_TABLE_200
806 , p4_a42 JTF_VARCHAR2_TABLE_200
807 , p4_a43 JTF_VARCHAR2_TABLE_200
808 , p4_a44 JTF_VARCHAR2_TABLE_200
809 , p4_a45 JTF_VARCHAR2_TABLE_200
810 , p4_a46 JTF_VARCHAR2_TABLE_200
811 , p4_a47 JTF_VARCHAR2_TABLE_200
812 , p4_a48 JTF_VARCHAR2_TABLE_200
813 , p4_a49 JTF_VARCHAR2_TABLE_200
814 , p4_a50 JTF_VARCHAR2_TABLE_200
815 , p4_a51 JTF_VARCHAR2_TABLE_200
816 , p4_a52 JTF_VARCHAR2_TABLE_200
817 , p4_a53 JTF_VARCHAR2_TABLE_200
818 , p4_a54 JTF_VARCHAR2_TABLE_200
819 , p4_a55 JTF_DATE_TABLE
820 , p4_a56 JTF_DATE_TABLE
821 , p4_a57 JTF_DATE_TABLE
822 , p4_a58 JTF_VARCHAR2_TABLE_100
823 , p4_a59 JTF_VARCHAR2_TABLE_100
824 , p4_a60 JTF_NUMBER_TABLE
825 , p4_a61 JTF_NUMBER_TABLE
826 , p4_a62 JTF_VARCHAR2_TABLE_100
827 , p4_a63 JTF_NUMBER_TABLE
828 , p4_a64 JTF_VARCHAR2_TABLE_300
829 , p4_a65 JTF_VARCHAR2_TABLE_100
830 , p4_a66 JTF_DATE_TABLE
831 , p4_a67 JTF_DATE_TABLE
832 , p4_a68 JTF_VARCHAR2_TABLE_100
833 , p4_a69 JTF_VARCHAR2_TABLE_100
834 , p4_a70 JTF_VARCHAR2_TABLE_100
835 , p4_a71 JTF_NUMBER_TABLE
836 , p4_a72 JTF_VARCHAR2_TABLE_100
837 , p4_a73 JTF_NUMBER_TABLE
838 , p4_a74 JTF_VARCHAR2_TABLE_100
839 , p4_a75 JTF_VARCHAR2_TABLE_100
840 , p4_a76 JTF_VARCHAR2_TABLE_100
841 , p4_a77 JTF_VARCHAR2_TABLE_100
842 , p4_a78 JTF_DATE_TABLE
843 , p4_a79 JTF_DATE_TABLE
844 , p4_a80 JTF_NUMBER_TABLE
845 , p4_a81 JTF_NUMBER_TABLE
846 , p4_a82 JTF_NUMBER_TABLE
847 , p4_a83 JTF_VARCHAR2_TABLE_100
848 , p4_a84 JTF_VARCHAR2_TABLE_100
849 , p4_a85 JTF_VARCHAR2_TABLE_100
850 , p4_a86 JTF_VARCHAR2_TABLE_100
851 , p4_a87 JTF_VARCHAR2_TABLE_100
852 , p4_a88 JTF_VARCHAR2_TABLE_100
853 , p4_a89 JTF_VARCHAR2_TABLE_100
854 , p4_a90 JTF_VARCHAR2_TABLE_100
855 , p4_a91 JTF_VARCHAR2_TABLE_100
856 , p4_a92 JTF_VARCHAR2_TABLE_100
857 , p4_a93 JTF_NUMBER_TABLE
858 , p4_a94 JTF_VARCHAR2_TABLE_300
859 , x_return_status out nocopy VARCHAR2
860 , x_msg_count out nocopy NUMBER
861 , x_msg_data out nocopy VARCHAR2
862 );
863 procedure remove_return_to_supply(p_api_version NUMBER
864 , p_init_msg_list VARCHAR2
865 , p_commit VARCHAR2
866 , p_validation_level NUMBER
867 , p4_a0 JTF_NUMBER_TABLE
868 , p4_a1 JTF_NUMBER_TABLE
869 , p4_a2 JTF_NUMBER_TABLE
870 , p4_a3 JTF_VARCHAR2_TABLE_100
871 , p4_a4 JTF_NUMBER_TABLE
872 , p4_a5 JTF_NUMBER_TABLE
873 , p4_a6 JTF_VARCHAR2_TABLE_100
874 , p4_a7 JTF_NUMBER_TABLE
875 , p4_a8 JTF_NUMBER_TABLE
876 , p4_a9 JTF_NUMBER_TABLE
877 , p4_a10 JTF_VARCHAR2_TABLE_100
878 , p4_a11 JTF_NUMBER_TABLE
879 , p4_a12 JTF_VARCHAR2_TABLE_100
880 , p4_a13 JTF_NUMBER_TABLE
881 , p4_a14 JTF_NUMBER_TABLE
882 , p4_a15 JTF_VARCHAR2_TABLE_300
883 , p4_a16 JTF_NUMBER_TABLE
884 , p4_a17 JTF_VARCHAR2_TABLE_100
885 , p4_a18 JTF_NUMBER_TABLE
886 , p4_a19 JTF_NUMBER_TABLE
887 , p4_a20 JTF_NUMBER_TABLE
888 , p4_a21 JTF_VARCHAR2_TABLE_100
889 , p4_a22 JTF_NUMBER_TABLE
890 , p4_a23 JTF_VARCHAR2_TABLE_100
891 , p4_a24 JTF_NUMBER_TABLE
892 , p4_a25 JTF_NUMBER_TABLE
893 , p4_a26 JTF_NUMBER_TABLE
894 , p4_a27 JTF_VARCHAR2_TABLE_100
895 , p4_a28 JTF_VARCHAR2_TABLE_100
896 , p4_a29 JTF_VARCHAR2_TABLE_100
897 , p4_a30 JTF_VARCHAR2_TABLE_4000
898 , p4_a31 JTF_VARCHAR2_TABLE_100
899 , p4_a32 JTF_VARCHAR2_TABLE_100
900 , p4_a33 JTF_NUMBER_TABLE
901 , p4_a34 JTF_DATE_TABLE
902 , p4_a35 JTF_NUMBER_TABLE
903 , p4_a36 JTF_DATE_TABLE
904 , p4_a37 JTF_NUMBER_TABLE
905 , p4_a38 JTF_NUMBER_TABLE
906 , p4_a39 JTF_VARCHAR2_TABLE_100
907 , p4_a40 JTF_VARCHAR2_TABLE_200
908 , p4_a41 JTF_VARCHAR2_TABLE_200
909 , p4_a42 JTF_VARCHAR2_TABLE_200
910 , p4_a43 JTF_VARCHAR2_TABLE_200
911 , p4_a44 JTF_VARCHAR2_TABLE_200
912 , p4_a45 JTF_VARCHAR2_TABLE_200
913 , p4_a46 JTF_VARCHAR2_TABLE_200
914 , p4_a47 JTF_VARCHAR2_TABLE_200
915 , p4_a48 JTF_VARCHAR2_TABLE_200
916 , p4_a49 JTF_VARCHAR2_TABLE_200
917 , p4_a50 JTF_VARCHAR2_TABLE_200
918 , p4_a51 JTF_VARCHAR2_TABLE_200
919 , p4_a52 JTF_VARCHAR2_TABLE_200
920 , p4_a53 JTF_VARCHAR2_TABLE_200
921 , p4_a54 JTF_VARCHAR2_TABLE_200
922 , p4_a55 JTF_DATE_TABLE
923 , p4_a56 JTF_DATE_TABLE
924 , p4_a57 JTF_DATE_TABLE
925 , p4_a58 JTF_VARCHAR2_TABLE_100
926 , p4_a59 JTF_VARCHAR2_TABLE_100
927 , p4_a60 JTF_NUMBER_TABLE
928 , p4_a61 JTF_NUMBER_TABLE
929 , p4_a62 JTF_VARCHAR2_TABLE_100
930 , p4_a63 JTF_NUMBER_TABLE
931 , p4_a64 JTF_VARCHAR2_TABLE_300
932 , p4_a65 JTF_VARCHAR2_TABLE_100
933 , p4_a66 JTF_DATE_TABLE
934 , p4_a67 JTF_DATE_TABLE
935 , p4_a68 JTF_VARCHAR2_TABLE_100
936 , p4_a69 JTF_VARCHAR2_TABLE_100
937 , p4_a70 JTF_VARCHAR2_TABLE_100
938 , p4_a71 JTF_NUMBER_TABLE
939 , p4_a72 JTF_VARCHAR2_TABLE_100
940 , p4_a73 JTF_NUMBER_TABLE
941 , p4_a74 JTF_VARCHAR2_TABLE_100
942 , p4_a75 JTF_VARCHAR2_TABLE_100
943 , p4_a76 JTF_VARCHAR2_TABLE_100
944 , p4_a77 JTF_VARCHAR2_TABLE_100
945 , p4_a78 JTF_DATE_TABLE
946 , p4_a79 JTF_DATE_TABLE
947 , p4_a80 JTF_NUMBER_TABLE
948 , p4_a81 JTF_NUMBER_TABLE
949 , p4_a82 JTF_NUMBER_TABLE
950 , p4_a83 JTF_VARCHAR2_TABLE_100
951 , p4_a84 JTF_VARCHAR2_TABLE_100
952 , p4_a85 JTF_VARCHAR2_TABLE_100
953 , p4_a86 JTF_VARCHAR2_TABLE_100
954 , p4_a87 JTF_VARCHAR2_TABLE_100
955 , p4_a88 JTF_VARCHAR2_TABLE_100
956 , p4_a89 JTF_VARCHAR2_TABLE_100
957 , p4_a90 JTF_VARCHAR2_TABLE_100
958 , p4_a91 JTF_VARCHAR2_TABLE_100
959 , p4_a92 JTF_VARCHAR2_TABLE_100
960 , p4_a93 JTF_NUMBER_TABLE
961 , p4_a94 JTF_VARCHAR2_TABLE_300
962 , x_return_status out nocopy VARCHAR2
963 , x_msg_count out nocopy NUMBER
964 , x_msg_data out nocopy VARCHAR2
965 );
966 procedure validate_return_to_supply(p_api_version NUMBER
967 , p_init_msg_list VARCHAR2
968 , p_commit VARCHAR2
969 , p_validation_level NUMBER
970 , p_module_type VARCHAR2
971 , p_visit_id NUMBER
972 , p6_a0 JTF_NUMBER_TABLE
973 , p6_a1 JTF_NUMBER_TABLE
974 , p6_a2 JTF_NUMBER_TABLE
975 , p6_a3 JTF_VARCHAR2_TABLE_100
976 , p6_a4 JTF_NUMBER_TABLE
977 , p6_a5 JTF_NUMBER_TABLE
978 , p6_a6 JTF_VARCHAR2_TABLE_100
979 , p6_a7 JTF_NUMBER_TABLE
980 , p6_a8 JTF_NUMBER_TABLE
981 , p6_a9 JTF_NUMBER_TABLE
982 , p6_a10 JTF_VARCHAR2_TABLE_100
983 , p6_a11 JTF_NUMBER_TABLE
984 , p6_a12 JTF_VARCHAR2_TABLE_100
985 , p6_a13 JTF_NUMBER_TABLE
986 , p6_a14 JTF_NUMBER_TABLE
987 , p6_a15 JTF_VARCHAR2_TABLE_300
988 , p6_a16 JTF_NUMBER_TABLE
989 , p6_a17 JTF_VARCHAR2_TABLE_100
990 , p6_a18 JTF_NUMBER_TABLE
991 , p6_a19 JTF_NUMBER_TABLE
992 , p6_a20 JTF_NUMBER_TABLE
993 , p6_a21 JTF_VARCHAR2_TABLE_100
994 , p6_a22 JTF_NUMBER_TABLE
995 , p6_a23 JTF_VARCHAR2_TABLE_100
996 , p6_a24 JTF_NUMBER_TABLE
997 , p6_a25 JTF_NUMBER_TABLE
998 , p6_a26 JTF_NUMBER_TABLE
999 , p6_a27 JTF_VARCHAR2_TABLE_100
1000 , p6_a28 JTF_VARCHAR2_TABLE_100
1001 , p6_a29 JTF_VARCHAR2_TABLE_100
1002 , p6_a30 JTF_VARCHAR2_TABLE_4000
1003 , p6_a31 JTF_VARCHAR2_TABLE_100
1004 , p6_a32 JTF_VARCHAR2_TABLE_100
1005 , p6_a33 JTF_NUMBER_TABLE
1006 , p6_a34 JTF_DATE_TABLE
1007 , p6_a35 JTF_NUMBER_TABLE
1008 , p6_a36 JTF_DATE_TABLE
1009 , p6_a37 JTF_NUMBER_TABLE
1010 , p6_a38 JTF_NUMBER_TABLE
1011 , p6_a39 JTF_VARCHAR2_TABLE_100
1012 , p6_a40 JTF_VARCHAR2_TABLE_200
1013 , p6_a41 JTF_VARCHAR2_TABLE_200
1014 , p6_a42 JTF_VARCHAR2_TABLE_200
1015 , p6_a43 JTF_VARCHAR2_TABLE_200
1016 , p6_a44 JTF_VARCHAR2_TABLE_200
1017 , p6_a45 JTF_VARCHAR2_TABLE_200
1018 , p6_a46 JTF_VARCHAR2_TABLE_200
1019 , p6_a47 JTF_VARCHAR2_TABLE_200
1020 , p6_a48 JTF_VARCHAR2_TABLE_200
1021 , p6_a49 JTF_VARCHAR2_TABLE_200
1022 , p6_a50 JTF_VARCHAR2_TABLE_200
1023 , p6_a51 JTF_VARCHAR2_TABLE_200
1024 , p6_a52 JTF_VARCHAR2_TABLE_200
1025 , p6_a53 JTF_VARCHAR2_TABLE_200
1026 , p6_a54 JTF_VARCHAR2_TABLE_200
1027 , p6_a55 JTF_DATE_TABLE
1028 , p6_a56 JTF_DATE_TABLE
1029 , p6_a57 JTF_DATE_TABLE
1030 , p6_a58 JTF_VARCHAR2_TABLE_100
1031 , p6_a59 JTF_VARCHAR2_TABLE_100
1032 , p6_a60 JTF_NUMBER_TABLE
1033 , p6_a61 JTF_NUMBER_TABLE
1034 , p6_a62 JTF_VARCHAR2_TABLE_100
1035 , p6_a63 JTF_NUMBER_TABLE
1036 , p6_a64 JTF_VARCHAR2_TABLE_300
1037 , p6_a65 JTF_VARCHAR2_TABLE_100
1038 , p6_a66 JTF_DATE_TABLE
1039 , p6_a67 JTF_DATE_TABLE
1040 , p6_a68 JTF_VARCHAR2_TABLE_100
1041 , p6_a69 JTF_VARCHAR2_TABLE_100
1042 , p6_a70 JTF_VARCHAR2_TABLE_100
1043 , p6_a71 JTF_NUMBER_TABLE
1044 , p6_a72 JTF_VARCHAR2_TABLE_100
1045 , p6_a73 JTF_NUMBER_TABLE
1046 , p6_a74 JTF_VARCHAR2_TABLE_100
1047 , p6_a75 JTF_VARCHAR2_TABLE_100
1048 , p6_a76 JTF_VARCHAR2_TABLE_100
1049 , p6_a77 JTF_VARCHAR2_TABLE_100
1050 , p6_a78 JTF_DATE_TABLE
1051 , p6_a79 JTF_DATE_TABLE
1052 , p6_a80 JTF_NUMBER_TABLE
1053 , p6_a81 JTF_NUMBER_TABLE
1054 , p6_a82 JTF_NUMBER_TABLE
1055 , p6_a83 JTF_VARCHAR2_TABLE_100
1056 , p6_a84 JTF_VARCHAR2_TABLE_100
1057 , p6_a85 JTF_VARCHAR2_TABLE_100
1058 , p6_a86 JTF_VARCHAR2_TABLE_100
1059 , p6_a87 JTF_VARCHAR2_TABLE_100
1060 , p6_a88 JTF_VARCHAR2_TABLE_100
1061 , p6_a89 JTF_VARCHAR2_TABLE_100
1062 , p6_a90 JTF_VARCHAR2_TABLE_100
1063 , p6_a91 JTF_VARCHAR2_TABLE_100
1064 , p6_a92 JTF_VARCHAR2_TABLE_100
1065 , p6_a93 JTF_NUMBER_TABLE
1066 , p6_a94 JTF_VARCHAR2_TABLE_300
1067 , x_return_status out nocopy VARCHAR2
1068 , x_msg_count out nocopy NUMBER
1069 , x_msg_data out nocopy VARCHAR2
1070 );
1071 procedure flag_duplicate_task(p_api_version NUMBER
1072 , p_init_msg_list VARCHAR2
1073 , p_commit VARCHAR2
1074 , p_validation_level NUMBER
1075 , p_module_type VARCHAR2
1076 , p5_a0 JTF_NUMBER_TABLE
1077 , p5_a1 JTF_NUMBER_TABLE
1078 , p5_a2 JTF_NUMBER_TABLE
1079 , p5_a3 JTF_VARCHAR2_TABLE_100
1080 , p5_a4 JTF_NUMBER_TABLE
1081 , p5_a5 JTF_NUMBER_TABLE
1082 , p5_a6 JTF_VARCHAR2_TABLE_100
1083 , p5_a7 JTF_NUMBER_TABLE
1084 , p5_a8 JTF_NUMBER_TABLE
1085 , p5_a9 JTF_NUMBER_TABLE
1086 , p5_a10 JTF_VARCHAR2_TABLE_100
1087 , p5_a11 JTF_NUMBER_TABLE
1088 , p5_a12 JTF_VARCHAR2_TABLE_100
1089 , p5_a13 JTF_NUMBER_TABLE
1090 , p5_a14 JTF_NUMBER_TABLE
1091 , p5_a15 JTF_VARCHAR2_TABLE_300
1092 , p5_a16 JTF_NUMBER_TABLE
1093 , p5_a17 JTF_VARCHAR2_TABLE_100
1094 , p5_a18 JTF_NUMBER_TABLE
1095 , p5_a19 JTF_NUMBER_TABLE
1096 , p5_a20 JTF_NUMBER_TABLE
1097 , p5_a21 JTF_VARCHAR2_TABLE_100
1098 , p5_a22 JTF_NUMBER_TABLE
1099 , p5_a23 JTF_VARCHAR2_TABLE_100
1100 , p5_a24 JTF_NUMBER_TABLE
1101 , p5_a25 JTF_NUMBER_TABLE
1102 , p5_a26 JTF_NUMBER_TABLE
1103 , p5_a27 JTF_VARCHAR2_TABLE_100
1104 , p5_a28 JTF_VARCHAR2_TABLE_100
1105 , p5_a29 JTF_VARCHAR2_TABLE_100
1106 , p5_a30 JTF_VARCHAR2_TABLE_4000
1107 , p5_a31 JTF_VARCHAR2_TABLE_100
1108 , p5_a32 JTF_VARCHAR2_TABLE_100
1109 , p5_a33 JTF_NUMBER_TABLE
1110 , p5_a34 JTF_DATE_TABLE
1111 , p5_a35 JTF_NUMBER_TABLE
1112 , p5_a36 JTF_DATE_TABLE
1113 , p5_a37 JTF_NUMBER_TABLE
1114 , p5_a38 JTF_NUMBER_TABLE
1115 , p5_a39 JTF_VARCHAR2_TABLE_100
1116 , p5_a40 JTF_VARCHAR2_TABLE_200
1117 , p5_a41 JTF_VARCHAR2_TABLE_200
1118 , p5_a42 JTF_VARCHAR2_TABLE_200
1119 , p5_a43 JTF_VARCHAR2_TABLE_200
1120 , p5_a44 JTF_VARCHAR2_TABLE_200
1121 , p5_a45 JTF_VARCHAR2_TABLE_200
1122 , p5_a46 JTF_VARCHAR2_TABLE_200
1123 , p5_a47 JTF_VARCHAR2_TABLE_200
1124 , p5_a48 JTF_VARCHAR2_TABLE_200
1125 , p5_a49 JTF_VARCHAR2_TABLE_200
1126 , p5_a50 JTF_VARCHAR2_TABLE_200
1127 , p5_a51 JTF_VARCHAR2_TABLE_200
1128 , p5_a52 JTF_VARCHAR2_TABLE_200
1129 , p5_a53 JTF_VARCHAR2_TABLE_200
1130 , p5_a54 JTF_VARCHAR2_TABLE_200
1131 , p5_a55 JTF_DATE_TABLE
1132 , p5_a56 JTF_DATE_TABLE
1133 , p5_a57 JTF_DATE_TABLE
1134 , p5_a58 JTF_VARCHAR2_TABLE_100
1135 , p5_a59 JTF_VARCHAR2_TABLE_100
1136 , p5_a60 JTF_NUMBER_TABLE
1137 , p5_a61 JTF_NUMBER_TABLE
1138 , p5_a62 JTF_VARCHAR2_TABLE_100
1139 , p5_a63 JTF_NUMBER_TABLE
1140 , p5_a64 JTF_VARCHAR2_TABLE_300
1141 , p5_a65 JTF_VARCHAR2_TABLE_100
1142 , p5_a66 JTF_DATE_TABLE
1143 , p5_a67 JTF_DATE_TABLE
1144 , p5_a68 JTF_VARCHAR2_TABLE_100
1145 , p5_a69 JTF_VARCHAR2_TABLE_100
1146 , p5_a70 JTF_VARCHAR2_TABLE_100
1147 , p5_a71 JTF_NUMBER_TABLE
1148 , p5_a72 JTF_VARCHAR2_TABLE_100
1149 , p5_a73 JTF_NUMBER_TABLE
1150 , p5_a74 JTF_VARCHAR2_TABLE_100
1151 , p5_a75 JTF_VARCHAR2_TABLE_100
1152 , p5_a76 JTF_VARCHAR2_TABLE_100
1153 , p5_a77 JTF_VARCHAR2_TABLE_100
1154 , p5_a78 JTF_DATE_TABLE
1155 , p5_a79 JTF_DATE_TABLE
1156 , p5_a80 JTF_NUMBER_TABLE
1157 , p5_a81 JTF_NUMBER_TABLE
1158 , p5_a82 JTF_NUMBER_TABLE
1159 , p5_a83 JTF_VARCHAR2_TABLE_100
1160 , p5_a84 JTF_VARCHAR2_TABLE_100
1161 , p5_a85 JTF_VARCHAR2_TABLE_100
1162 , p5_a86 JTF_VARCHAR2_TABLE_100
1163 , p5_a87 JTF_VARCHAR2_TABLE_100
1164 , p5_a88 JTF_VARCHAR2_TABLE_100
1165 , p5_a89 JTF_VARCHAR2_TABLE_100
1166 , p5_a90 JTF_VARCHAR2_TABLE_100
1167 , p5_a91 JTF_VARCHAR2_TABLE_100
1168 , p5_a92 JTF_VARCHAR2_TABLE_100
1169 , p5_a93 JTF_NUMBER_TABLE
1170 , p5_a94 JTF_VARCHAR2_TABLE_300
1171 , x_return_status out nocopy VARCHAR2
1172 , x_msg_count out nocopy NUMBER
1173 , x_msg_data out nocopy VARCHAR2
1174 );
1175 procedure remove_duplicate_task_flag(p_api_version NUMBER
1176 , p_init_msg_list VARCHAR2
1177 , p_commit VARCHAR2
1178 , p_validation_level NUMBER
1179 , p_module_type VARCHAR2
1180 , p5_a0 JTF_NUMBER_TABLE
1181 , p5_a1 JTF_NUMBER_TABLE
1182 , p5_a2 JTF_NUMBER_TABLE
1183 , p5_a3 JTF_VARCHAR2_TABLE_100
1184 , p5_a4 JTF_NUMBER_TABLE
1185 , p5_a5 JTF_NUMBER_TABLE
1186 , p5_a6 JTF_VARCHAR2_TABLE_100
1187 , p5_a7 JTF_NUMBER_TABLE
1188 , p5_a8 JTF_NUMBER_TABLE
1189 , p5_a9 JTF_NUMBER_TABLE
1190 , p5_a10 JTF_VARCHAR2_TABLE_100
1191 , p5_a11 JTF_NUMBER_TABLE
1192 , p5_a12 JTF_VARCHAR2_TABLE_100
1193 , p5_a13 JTF_NUMBER_TABLE
1194 , p5_a14 JTF_NUMBER_TABLE
1195 , p5_a15 JTF_VARCHAR2_TABLE_300
1196 , p5_a16 JTF_NUMBER_TABLE
1197 , p5_a17 JTF_VARCHAR2_TABLE_100
1198 , p5_a18 JTF_NUMBER_TABLE
1199 , p5_a19 JTF_NUMBER_TABLE
1200 , p5_a20 JTF_NUMBER_TABLE
1201 , p5_a21 JTF_VARCHAR2_TABLE_100
1202 , p5_a22 JTF_NUMBER_TABLE
1203 , p5_a23 JTF_VARCHAR2_TABLE_100
1204 , p5_a24 JTF_NUMBER_TABLE
1205 , p5_a25 JTF_NUMBER_TABLE
1206 , p5_a26 JTF_NUMBER_TABLE
1207 , p5_a27 JTF_VARCHAR2_TABLE_100
1208 , p5_a28 JTF_VARCHAR2_TABLE_100
1209 , p5_a29 JTF_VARCHAR2_TABLE_100
1210 , p5_a30 JTF_VARCHAR2_TABLE_4000
1211 , p5_a31 JTF_VARCHAR2_TABLE_100
1212 , p5_a32 JTF_VARCHAR2_TABLE_100
1213 , p5_a33 JTF_NUMBER_TABLE
1214 , p5_a34 JTF_DATE_TABLE
1215 , p5_a35 JTF_NUMBER_TABLE
1216 , p5_a36 JTF_DATE_TABLE
1217 , p5_a37 JTF_NUMBER_TABLE
1218 , p5_a38 JTF_NUMBER_TABLE
1219 , p5_a39 JTF_VARCHAR2_TABLE_100
1220 , p5_a40 JTF_VARCHAR2_TABLE_200
1221 , p5_a41 JTF_VARCHAR2_TABLE_200
1222 , p5_a42 JTF_VARCHAR2_TABLE_200
1223 , p5_a43 JTF_VARCHAR2_TABLE_200
1224 , p5_a44 JTF_VARCHAR2_TABLE_200
1225 , p5_a45 JTF_VARCHAR2_TABLE_200
1226 , p5_a46 JTF_VARCHAR2_TABLE_200
1227 , p5_a47 JTF_VARCHAR2_TABLE_200
1228 , p5_a48 JTF_VARCHAR2_TABLE_200
1229 , p5_a49 JTF_VARCHAR2_TABLE_200
1230 , p5_a50 JTF_VARCHAR2_TABLE_200
1231 , p5_a51 JTF_VARCHAR2_TABLE_200
1232 , p5_a52 JTF_VARCHAR2_TABLE_200
1233 , p5_a53 JTF_VARCHAR2_TABLE_200
1234 , p5_a54 JTF_VARCHAR2_TABLE_200
1235 , p5_a55 JTF_DATE_TABLE
1236 , p5_a56 JTF_DATE_TABLE
1237 , p5_a57 JTF_DATE_TABLE
1238 , p5_a58 JTF_VARCHAR2_TABLE_100
1239 , p5_a59 JTF_VARCHAR2_TABLE_100
1240 , p5_a60 JTF_NUMBER_TABLE
1241 , p5_a61 JTF_NUMBER_TABLE
1242 , p5_a62 JTF_VARCHAR2_TABLE_100
1243 , p5_a63 JTF_NUMBER_TABLE
1244 , p5_a64 JTF_VARCHAR2_TABLE_300
1245 , p5_a65 JTF_VARCHAR2_TABLE_100
1246 , p5_a66 JTF_DATE_TABLE
1247 , p5_a67 JTF_DATE_TABLE
1248 , p5_a68 JTF_VARCHAR2_TABLE_100
1249 , p5_a69 JTF_VARCHAR2_TABLE_100
1250 , p5_a70 JTF_VARCHAR2_TABLE_100
1251 , p5_a71 JTF_NUMBER_TABLE
1252 , p5_a72 JTF_VARCHAR2_TABLE_100
1253 , p5_a73 JTF_NUMBER_TABLE
1254 , p5_a74 JTF_VARCHAR2_TABLE_100
1255 , p5_a75 JTF_VARCHAR2_TABLE_100
1256 , p5_a76 JTF_VARCHAR2_TABLE_100
1257 , p5_a77 JTF_VARCHAR2_TABLE_100
1258 , p5_a78 JTF_DATE_TABLE
1259 , p5_a79 JTF_DATE_TABLE
1260 , p5_a80 JTF_NUMBER_TABLE
1261 , p5_a81 JTF_NUMBER_TABLE
1262 , p5_a82 JTF_NUMBER_TABLE
1263 , p5_a83 JTF_VARCHAR2_TABLE_100
1264 , p5_a84 JTF_VARCHAR2_TABLE_100
1265 , p5_a85 JTF_VARCHAR2_TABLE_100
1266 , p5_a86 JTF_VARCHAR2_TABLE_100
1267 , p5_a87 JTF_VARCHAR2_TABLE_100
1268 , p5_a88 JTF_VARCHAR2_TABLE_100
1269 , p5_a89 JTF_VARCHAR2_TABLE_100
1270 , p5_a90 JTF_VARCHAR2_TABLE_100
1271 , p5_a91 JTF_VARCHAR2_TABLE_100
1272 , p5_a92 JTF_VARCHAR2_TABLE_100
1273 , p5_a93 JTF_NUMBER_TABLE
1274 , p5_a94 JTF_VARCHAR2_TABLE_300
1275 , x_return_status out nocopy VARCHAR2
1276 , x_msg_count out nocopy NUMBER
1277 , x_msg_data out nocopy VARCHAR2
1278 );
1279 end ahl_vwp_rules_pvt_w;