1 package ahl_prd_workorder_pvt_w as
2 /* $Header: AHLWPRJS.pls 120.3.12010000.2 2008/12/15 01:46:34 sracha ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_workorder_pvt.prd_workoper_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_500
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_DATE_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_300
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_VARCHAR2_TABLE_500
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_DATE_TABLE
28 , a25 JTF_NUMBER_TABLE
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_DATE_TABLE
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_NUMBER_TABLE
33 , a30 JTF_DATE_TABLE
34 , a31 JTF_NUMBER_TABLE
35 , a32 JTF_NUMBER_TABLE
36 , a33 JTF_DATE_TABLE
37 , a34 JTF_NUMBER_TABLE
38 , a35 JTF_NUMBER_TABLE
39 , a36 JTF_NUMBER_TABLE
40 , a37 JTF_NUMBER_TABLE
41 , a38 JTF_VARCHAR2_TABLE_100
42 , a39 JTF_NUMBER_TABLE
43 , a40 JTF_VARCHAR2_TABLE_100
44 , a41 JTF_VARCHAR2_TABLE_200
45 , a42 JTF_VARCHAR2_TABLE_200
46 , a43 JTF_VARCHAR2_TABLE_200
47 , a44 JTF_VARCHAR2_TABLE_200
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_100
60 );
61 procedure rosetta_table_copy_out_p1(t ahl_prd_workorder_pvt.prd_workoper_tbl, a0 out nocopy JTF_NUMBER_TABLE
62 , a1 out nocopy JTF_NUMBER_TABLE
63 , a2 out nocopy JTF_NUMBER_TABLE
64 , a3 out nocopy JTF_VARCHAR2_TABLE_500
65 , a4 out nocopy JTF_NUMBER_TABLE
66 , a5 out nocopy JTF_NUMBER_TABLE
67 , a6 out nocopy JTF_NUMBER_TABLE
68 , a7 out nocopy JTF_NUMBER_TABLE
69 , a8 out nocopy JTF_DATE_TABLE
70 , a9 out nocopy JTF_NUMBER_TABLE
71 , a10 out nocopy JTF_DATE_TABLE
72 , a11 out nocopy JTF_NUMBER_TABLE
73 , a12 out nocopy JTF_NUMBER_TABLE
74 , a13 out nocopy JTF_NUMBER_TABLE
75 , a14 out nocopy JTF_VARCHAR2_TABLE_300
76 , a15 out nocopy JTF_VARCHAR2_TABLE_100
77 , a16 out nocopy JTF_VARCHAR2_TABLE_100
78 , a17 out nocopy JTF_NUMBER_TABLE
79 , a18 out nocopy JTF_VARCHAR2_TABLE_500
80 , a19 out nocopy JTF_VARCHAR2_TABLE_100
81 , a20 out nocopy JTF_VARCHAR2_TABLE_100
82 , a21 out nocopy JTF_VARCHAR2_TABLE_100
83 , a22 out nocopy JTF_NUMBER_TABLE
84 , a23 out nocopy JTF_NUMBER_TABLE
85 , a24 out nocopy JTF_DATE_TABLE
86 , a25 out nocopy JTF_NUMBER_TABLE
87 , a26 out nocopy JTF_NUMBER_TABLE
88 , a27 out nocopy JTF_DATE_TABLE
89 , a28 out nocopy JTF_NUMBER_TABLE
90 , a29 out nocopy JTF_NUMBER_TABLE
91 , a30 out nocopy JTF_DATE_TABLE
92 , a31 out nocopy JTF_NUMBER_TABLE
93 , a32 out nocopy JTF_NUMBER_TABLE
94 , a33 out nocopy JTF_DATE_TABLE
95 , a34 out nocopy JTF_NUMBER_TABLE
96 , a35 out nocopy JTF_NUMBER_TABLE
97 , a36 out nocopy JTF_NUMBER_TABLE
98 , a37 out nocopy JTF_NUMBER_TABLE
99 , a38 out nocopy JTF_VARCHAR2_TABLE_100
100 , a39 out nocopy JTF_NUMBER_TABLE
101 , a40 out nocopy JTF_VARCHAR2_TABLE_100
102 , a41 out nocopy JTF_VARCHAR2_TABLE_200
103 , a42 out nocopy JTF_VARCHAR2_TABLE_200
104 , a43 out nocopy JTF_VARCHAR2_TABLE_200
105 , a44 out nocopy JTF_VARCHAR2_TABLE_200
106 , a45 out nocopy JTF_VARCHAR2_TABLE_200
107 , a46 out nocopy JTF_VARCHAR2_TABLE_200
108 , a47 out nocopy JTF_VARCHAR2_TABLE_200
109 , a48 out nocopy JTF_VARCHAR2_TABLE_200
110 , a49 out nocopy JTF_VARCHAR2_TABLE_200
111 , a50 out nocopy JTF_VARCHAR2_TABLE_200
112 , a51 out nocopy JTF_VARCHAR2_TABLE_200
113 , a52 out nocopy JTF_VARCHAR2_TABLE_200
114 , a53 out nocopy JTF_VARCHAR2_TABLE_200
115 , a54 out nocopy JTF_VARCHAR2_TABLE_200
116 , a55 out nocopy JTF_VARCHAR2_TABLE_200
117 , a56 out nocopy JTF_VARCHAR2_TABLE_100
118 );
119
120 procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_workorder_pvt.prd_workorder_tbl, a0 JTF_NUMBER_TABLE
121 , a1 JTF_NUMBER_TABLE
122 , a2 JTF_NUMBER_TABLE
123 , a3 JTF_NUMBER_TABLE
124 , a4 JTF_NUMBER_TABLE
125 , a5 JTF_VARCHAR2_TABLE_100
126 , a6 JTF_VARCHAR2_TABLE_300
127 , a7 JTF_NUMBER_TABLE
128 , a8 JTF_VARCHAR2_TABLE_100
129 , a9 JTF_VARCHAR2_TABLE_100
130 , a10 JTF_VARCHAR2_TABLE_300
131 , a11 JTF_NUMBER_TABLE
132 , a12 JTF_VARCHAR2_TABLE_100
133 , a13 JTF_VARCHAR2_TABLE_100
134 , a14 JTF_VARCHAR2_TABLE_100
135 , a15 JTF_DATE_TABLE
136 , a16 JTF_NUMBER_TABLE
137 , a17 JTF_NUMBER_TABLE
138 , a18 JTF_DATE_TABLE
139 , a19 JTF_NUMBER_TABLE
140 , a20 JTF_NUMBER_TABLE
141 , a21 JTF_DATE_TABLE
142 , a22 JTF_NUMBER_TABLE
143 , a23 JTF_NUMBER_TABLE
144 , a24 JTF_DATE_TABLE
145 , a25 JTF_NUMBER_TABLE
146 , a26 JTF_NUMBER_TABLE
147 , a27 JTF_NUMBER_TABLE
148 , a28 JTF_NUMBER_TABLE
149 , a29 JTF_VARCHAR2_TABLE_100
150 , a30 JTF_VARCHAR2_TABLE_100
151 , a31 JTF_VARCHAR2_TABLE_100
152 , a32 JTF_VARCHAR2_TABLE_300
153 , a33 JTF_VARCHAR2_TABLE_100
154 , a34 JTF_VARCHAR2_TABLE_100
155 , a35 JTF_VARCHAR2_TABLE_100
156 , a36 JTF_NUMBER_TABLE
157 , a37 JTF_VARCHAR2_TABLE_300
158 , a38 JTF_NUMBER_TABLE
159 , a39 JTF_VARCHAR2_TABLE_100
160 , a40 JTF_NUMBER_TABLE
161 , a41 JTF_VARCHAR2_TABLE_100
162 , a42 JTF_NUMBER_TABLE
163 , a43 JTF_NUMBER_TABLE
164 , a44 JTF_VARCHAR2_TABLE_100
165 , a45 JTF_NUMBER_TABLE
166 , a46 JTF_NUMBER_TABLE
167 , a47 JTF_NUMBER_TABLE
168 , a48 JTF_VARCHAR2_TABLE_100
169 , a49 JTF_NUMBER_TABLE
170 , a50 JTF_NUMBER_TABLE
171 , a51 JTF_VARCHAR2_TABLE_100
172 , a52 JTF_VARCHAR2_TABLE_100
173 , a53 JTF_NUMBER_TABLE
174 , a54 JTF_NUMBER_TABLE
175 , a55 JTF_VARCHAR2_TABLE_300
176 , a56 JTF_VARCHAR2_TABLE_100
177 , a57 JTF_VARCHAR2_TABLE_100
178 , a58 JTF_NUMBER_TABLE
179 , a59 JTF_NUMBER_TABLE
180 , a60 JTF_NUMBER_TABLE
181 , a61 JTF_NUMBER_TABLE
182 , a62 JTF_NUMBER_TABLE
183 , a63 JTF_NUMBER_TABLE
184 , a64 JTF_NUMBER_TABLE
185 , a65 JTF_NUMBER_TABLE
186 , a66 JTF_VARCHAR2_TABLE_100
187 , a67 JTF_VARCHAR2_TABLE_100
188 , a68 JTF_NUMBER_TABLE
189 , a69 JTF_VARCHAR2_TABLE_100
190 , a70 JTF_NUMBER_TABLE
191 , a71 JTF_NUMBER_TABLE
192 , a72 JTF_NUMBER_TABLE
193 , a73 JTF_NUMBER_TABLE
194 , a74 JTF_VARCHAR2_TABLE_100
195 , a75 JTF_NUMBER_TABLE
196 , a76 JTF_NUMBER_TABLE
197 , a77 JTF_VARCHAR2_TABLE_100
198 , a78 JTF_VARCHAR2_TABLE_200
199 , a79 JTF_VARCHAR2_TABLE_200
200 , a80 JTF_VARCHAR2_TABLE_200
201 , a81 JTF_VARCHAR2_TABLE_200
202 , a82 JTF_VARCHAR2_TABLE_200
203 , a83 JTF_VARCHAR2_TABLE_200
204 , a84 JTF_VARCHAR2_TABLE_200
205 , a85 JTF_VARCHAR2_TABLE_200
206 , a86 JTF_VARCHAR2_TABLE_200
207 , a87 JTF_VARCHAR2_TABLE_200
208 , a88 JTF_VARCHAR2_TABLE_200
209 , a89 JTF_VARCHAR2_TABLE_200
210 , a90 JTF_VARCHAR2_TABLE_200
211 , a91 JTF_VARCHAR2_TABLE_200
212 , a92 JTF_VARCHAR2_TABLE_200
213 , a93 JTF_DATE_TABLE
214 , a94 JTF_NUMBER_TABLE
215 , a95 JTF_DATE_TABLE
216 , a96 JTF_NUMBER_TABLE
217 , a97 JTF_NUMBER_TABLE
218 , a98 JTF_VARCHAR2_TABLE_100
219 , a99 JTF_VARCHAR2_TABLE_100
220 , a100 JTF_VARCHAR2_TABLE_100
221 );
222 procedure rosetta_table_copy_out_p3(t ahl_prd_workorder_pvt.prd_workorder_tbl, a0 out nocopy JTF_NUMBER_TABLE
223 , a1 out nocopy JTF_NUMBER_TABLE
224 , a2 out nocopy JTF_NUMBER_TABLE
225 , a3 out nocopy JTF_NUMBER_TABLE
226 , a4 out nocopy JTF_NUMBER_TABLE
227 , a5 out nocopy JTF_VARCHAR2_TABLE_100
228 , a6 out nocopy JTF_VARCHAR2_TABLE_300
229 , a7 out nocopy JTF_NUMBER_TABLE
230 , a8 out nocopy JTF_VARCHAR2_TABLE_100
231 , a9 out nocopy JTF_VARCHAR2_TABLE_100
232 , a10 out nocopy JTF_VARCHAR2_TABLE_300
233 , a11 out nocopy JTF_NUMBER_TABLE
234 , a12 out nocopy JTF_VARCHAR2_TABLE_100
235 , a13 out nocopy JTF_VARCHAR2_TABLE_100
236 , a14 out nocopy JTF_VARCHAR2_TABLE_100
237 , a15 out nocopy JTF_DATE_TABLE
238 , a16 out nocopy JTF_NUMBER_TABLE
239 , a17 out nocopy JTF_NUMBER_TABLE
240 , a18 out nocopy JTF_DATE_TABLE
241 , a19 out nocopy JTF_NUMBER_TABLE
242 , a20 out nocopy JTF_NUMBER_TABLE
243 , a21 out nocopy JTF_DATE_TABLE
244 , a22 out nocopy JTF_NUMBER_TABLE
245 , a23 out nocopy JTF_NUMBER_TABLE
246 , a24 out nocopy JTF_DATE_TABLE
247 , a25 out nocopy JTF_NUMBER_TABLE
248 , a26 out nocopy JTF_NUMBER_TABLE
249 , a27 out nocopy JTF_NUMBER_TABLE
250 , a28 out nocopy JTF_NUMBER_TABLE
251 , a29 out nocopy JTF_VARCHAR2_TABLE_100
252 , a30 out nocopy JTF_VARCHAR2_TABLE_100
253 , a31 out nocopy JTF_VARCHAR2_TABLE_100
254 , a32 out nocopy JTF_VARCHAR2_TABLE_300
255 , a33 out nocopy JTF_VARCHAR2_TABLE_100
256 , a34 out nocopy JTF_VARCHAR2_TABLE_100
257 , a35 out nocopy JTF_VARCHAR2_TABLE_100
258 , a36 out nocopy JTF_NUMBER_TABLE
259 , a37 out nocopy JTF_VARCHAR2_TABLE_300
260 , a38 out nocopy JTF_NUMBER_TABLE
261 , a39 out nocopy JTF_VARCHAR2_TABLE_100
262 , a40 out nocopy JTF_NUMBER_TABLE
263 , a41 out nocopy JTF_VARCHAR2_TABLE_100
264 , a42 out nocopy JTF_NUMBER_TABLE
265 , a43 out nocopy JTF_NUMBER_TABLE
266 , a44 out nocopy JTF_VARCHAR2_TABLE_100
267 , a45 out nocopy JTF_NUMBER_TABLE
268 , a46 out nocopy JTF_NUMBER_TABLE
269 , a47 out nocopy JTF_NUMBER_TABLE
270 , a48 out nocopy JTF_VARCHAR2_TABLE_100
271 , a49 out nocopy JTF_NUMBER_TABLE
272 , a50 out nocopy JTF_NUMBER_TABLE
273 , a51 out nocopy JTF_VARCHAR2_TABLE_100
274 , a52 out nocopy JTF_VARCHAR2_TABLE_100
275 , a53 out nocopy JTF_NUMBER_TABLE
276 , a54 out nocopy JTF_NUMBER_TABLE
277 , a55 out nocopy JTF_VARCHAR2_TABLE_300
278 , a56 out nocopy JTF_VARCHAR2_TABLE_100
279 , a57 out nocopy JTF_VARCHAR2_TABLE_100
280 , a58 out nocopy JTF_NUMBER_TABLE
281 , a59 out nocopy JTF_NUMBER_TABLE
282 , a60 out nocopy JTF_NUMBER_TABLE
283 , a61 out nocopy JTF_NUMBER_TABLE
284 , a62 out nocopy JTF_NUMBER_TABLE
285 , a63 out nocopy JTF_NUMBER_TABLE
286 , a64 out nocopy JTF_NUMBER_TABLE
287 , a65 out nocopy JTF_NUMBER_TABLE
288 , a66 out nocopy JTF_VARCHAR2_TABLE_100
289 , a67 out nocopy JTF_VARCHAR2_TABLE_100
290 , a68 out nocopy JTF_NUMBER_TABLE
291 , a69 out nocopy JTF_VARCHAR2_TABLE_100
292 , a70 out nocopy JTF_NUMBER_TABLE
293 , a71 out nocopy JTF_NUMBER_TABLE
294 , a72 out nocopy JTF_NUMBER_TABLE
295 , a73 out nocopy JTF_NUMBER_TABLE
296 , a74 out nocopy JTF_VARCHAR2_TABLE_100
297 , a75 out nocopy JTF_NUMBER_TABLE
298 , a76 out nocopy JTF_NUMBER_TABLE
299 , a77 out nocopy JTF_VARCHAR2_TABLE_100
300 , a78 out nocopy JTF_VARCHAR2_TABLE_200
301 , a79 out nocopy JTF_VARCHAR2_TABLE_200
302 , a80 out nocopy JTF_VARCHAR2_TABLE_200
303 , a81 out nocopy JTF_VARCHAR2_TABLE_200
304 , a82 out nocopy JTF_VARCHAR2_TABLE_200
305 , a83 out nocopy JTF_VARCHAR2_TABLE_200
306 , a84 out nocopy JTF_VARCHAR2_TABLE_200
307 , a85 out nocopy JTF_VARCHAR2_TABLE_200
308 , a86 out nocopy JTF_VARCHAR2_TABLE_200
309 , a87 out nocopy JTF_VARCHAR2_TABLE_200
310 , a88 out nocopy JTF_VARCHAR2_TABLE_200
311 , a89 out nocopy JTF_VARCHAR2_TABLE_200
312 , a90 out nocopy JTF_VARCHAR2_TABLE_200
313 , a91 out nocopy JTF_VARCHAR2_TABLE_200
314 , a92 out nocopy JTF_VARCHAR2_TABLE_200
315 , a93 out nocopy JTF_DATE_TABLE
316 , a94 out nocopy JTF_NUMBER_TABLE
317 , a95 out nocopy JTF_DATE_TABLE
318 , a96 out nocopy JTF_NUMBER_TABLE
319 , a97 out nocopy JTF_NUMBER_TABLE
320 , a98 out nocopy JTF_VARCHAR2_TABLE_100
321 , a99 out nocopy JTF_VARCHAR2_TABLE_100
322 , a100 out nocopy JTF_VARCHAR2_TABLE_100
323 );
324
325 procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 JTF_NUMBER_TABLE
326 , a1 JTF_NUMBER_TABLE
327 , a2 JTF_NUMBER_TABLE
328 , a3 JTF_NUMBER_TABLE
329 , a4 JTF_NUMBER_TABLE
330 , a5 JTF_NUMBER_TABLE
331 , a6 JTF_NUMBER_TABLE
332 , a7 JTF_VARCHAR2_TABLE_100
333 );
334 procedure rosetta_table_copy_out_p5(t ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 out nocopy JTF_NUMBER_TABLE
335 , a1 out nocopy JTF_NUMBER_TABLE
336 , a2 out nocopy JTF_NUMBER_TABLE
337 , a3 out nocopy JTF_NUMBER_TABLE
338 , a4 out nocopy JTF_NUMBER_TABLE
339 , a5 out nocopy JTF_NUMBER_TABLE
340 , a6 out nocopy JTF_NUMBER_TABLE
341 , a7 out nocopy JTF_VARCHAR2_TABLE_100
342 );
343
344 procedure rosetta_table_copy_in_p13(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
345 , a1 JTF_NUMBER_TABLE
346 , a2 JTF_VARCHAR2_TABLE_100
347 , a3 JTF_VARCHAR2_TABLE_2000
348 , a4 JTF_NUMBER_TABLE
349 , a5 JTF_VARCHAR2_TABLE_300
350 , a6 JTF_DATE_TABLE
351 , a7 JTF_NUMBER_TABLE
352 );
353 procedure rosetta_table_copy_out_p13(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
354 , a1 out nocopy JTF_NUMBER_TABLE
355 , a2 out nocopy JTF_VARCHAR2_TABLE_100
356 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
357 , a4 out nocopy JTF_NUMBER_TABLE
358 , a5 out nocopy JTF_VARCHAR2_TABLE_300
359 , a6 out nocopy JTF_DATE_TABLE
360 , a7 out nocopy JTF_NUMBER_TABLE
361 );
362
363 procedure process_jobs(p_api_version NUMBER
364 , p_init_msg_list VARCHAR2
365 , p_commit VARCHAR2
366 , p_validation_level NUMBER
367 , p_default VARCHAR2
368 , p_module_type VARCHAR2
369 , x_return_status out nocopy VARCHAR2
370 , x_msg_count out nocopy NUMBER
371 , x_msg_data out nocopy VARCHAR2
372 , p9_a0 in out nocopy JTF_NUMBER_TABLE
373 , p9_a1 in out nocopy JTF_NUMBER_TABLE
374 , p9_a2 in out nocopy JTF_NUMBER_TABLE
375 , p9_a3 in out nocopy JTF_NUMBER_TABLE
376 , p9_a4 in out nocopy JTF_NUMBER_TABLE
377 , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
378 , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
379 , p9_a7 in out nocopy JTF_NUMBER_TABLE
380 , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
381 , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
382 , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
383 , p9_a11 in out nocopy JTF_NUMBER_TABLE
384 , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
385 , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
386 , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
387 , p9_a15 in out nocopy JTF_DATE_TABLE
388 , p9_a16 in out nocopy JTF_NUMBER_TABLE
389 , p9_a17 in out nocopy JTF_NUMBER_TABLE
390 , p9_a18 in out nocopy JTF_DATE_TABLE
391 , p9_a19 in out nocopy JTF_NUMBER_TABLE
392 , p9_a20 in out nocopy JTF_NUMBER_TABLE
393 , p9_a21 in out nocopy JTF_DATE_TABLE
394 , p9_a22 in out nocopy JTF_NUMBER_TABLE
395 , p9_a23 in out nocopy JTF_NUMBER_TABLE
396 , p9_a24 in out nocopy JTF_DATE_TABLE
397 , p9_a25 in out nocopy JTF_NUMBER_TABLE
398 , p9_a26 in out nocopy JTF_NUMBER_TABLE
399 , p9_a27 in out nocopy JTF_NUMBER_TABLE
400 , p9_a28 in out nocopy JTF_NUMBER_TABLE
401 , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
402 , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
403 , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
404 , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
405 , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
406 , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
407 , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
408 , p9_a36 in out nocopy JTF_NUMBER_TABLE
409 , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
410 , p9_a38 in out nocopy JTF_NUMBER_TABLE
411 , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
412 , p9_a40 in out nocopy JTF_NUMBER_TABLE
413 , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
414 , p9_a42 in out nocopy JTF_NUMBER_TABLE
415 , p9_a43 in out nocopy JTF_NUMBER_TABLE
416 , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
417 , p9_a45 in out nocopy JTF_NUMBER_TABLE
418 , p9_a46 in out nocopy JTF_NUMBER_TABLE
419 , p9_a47 in out nocopy JTF_NUMBER_TABLE
420 , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
421 , p9_a49 in out nocopy JTF_NUMBER_TABLE
422 , p9_a50 in out nocopy JTF_NUMBER_TABLE
423 , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
424 , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
425 , p9_a53 in out nocopy JTF_NUMBER_TABLE
426 , p9_a54 in out nocopy JTF_NUMBER_TABLE
427 , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
428 , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100
429 , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100
430 , p9_a58 in out nocopy JTF_NUMBER_TABLE
431 , p9_a59 in out nocopy JTF_NUMBER_TABLE
432 , p9_a60 in out nocopy JTF_NUMBER_TABLE
433 , p9_a61 in out nocopy JTF_NUMBER_TABLE
434 , p9_a62 in out nocopy JTF_NUMBER_TABLE
435 , p9_a63 in out nocopy JTF_NUMBER_TABLE
436 , p9_a64 in out nocopy JTF_NUMBER_TABLE
437 , p9_a65 in out nocopy JTF_NUMBER_TABLE
438 , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
439 , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
440 , p9_a68 in out nocopy JTF_NUMBER_TABLE
441 , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
442 , p9_a70 in out nocopy JTF_NUMBER_TABLE
443 , p9_a71 in out nocopy JTF_NUMBER_TABLE
444 , p9_a72 in out nocopy JTF_NUMBER_TABLE
445 , p9_a73 in out nocopy JTF_NUMBER_TABLE
446 , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100
447 , p9_a75 in out nocopy JTF_NUMBER_TABLE
448 , p9_a76 in out nocopy JTF_NUMBER_TABLE
449 , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100
450 , p9_a78 in out nocopy JTF_VARCHAR2_TABLE_200
451 , p9_a79 in out nocopy JTF_VARCHAR2_TABLE_200
452 , p9_a80 in out nocopy JTF_VARCHAR2_TABLE_200
453 , p9_a81 in out nocopy JTF_VARCHAR2_TABLE_200
454 , p9_a82 in out nocopy JTF_VARCHAR2_TABLE_200
455 , p9_a83 in out nocopy JTF_VARCHAR2_TABLE_200
456 , p9_a84 in out nocopy JTF_VARCHAR2_TABLE_200
457 , p9_a85 in out nocopy JTF_VARCHAR2_TABLE_200
458 , p9_a86 in out nocopy JTF_VARCHAR2_TABLE_200
459 , p9_a87 in out nocopy JTF_VARCHAR2_TABLE_200
460 , p9_a88 in out nocopy JTF_VARCHAR2_TABLE_200
461 , p9_a89 in out nocopy JTF_VARCHAR2_TABLE_200
462 , p9_a90 in out nocopy JTF_VARCHAR2_TABLE_200
463 , p9_a91 in out nocopy JTF_VARCHAR2_TABLE_200
464 , p9_a92 in out nocopy JTF_VARCHAR2_TABLE_200
465 , p9_a93 in out nocopy JTF_DATE_TABLE
466 , p9_a94 in out nocopy JTF_NUMBER_TABLE
467 , p9_a95 in out nocopy JTF_DATE_TABLE
468 , p9_a96 in out nocopy JTF_NUMBER_TABLE
469 , p9_a97 in out nocopy JTF_NUMBER_TABLE
470 , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
471 , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
472 , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
473 , p10_a0 JTF_NUMBER_TABLE
474 , p10_a1 JTF_NUMBER_TABLE
475 , p10_a2 JTF_NUMBER_TABLE
476 , p10_a3 JTF_NUMBER_TABLE
477 , p10_a4 JTF_NUMBER_TABLE
478 , p10_a5 JTF_NUMBER_TABLE
479 , p10_a6 JTF_NUMBER_TABLE
480 , p10_a7 JTF_VARCHAR2_TABLE_100
481 );
482 procedure update_job(p_api_version NUMBER
483 , p_init_msg_list VARCHAR2
484 , p_commit VARCHAR2
485 , p_validation_level NUMBER
486 , p_default VARCHAR2
487 , p_module_type VARCHAR2
488 , x_return_status out nocopy VARCHAR2
489 , x_msg_count out nocopy NUMBER
490 , x_msg_data out nocopy VARCHAR2
491 , p_wip_load_flag VARCHAR2
492 , p10_a0 in out nocopy NUMBER
493 , p10_a1 in out nocopy NUMBER
494 , p10_a2 in out nocopy NUMBER
495 , p10_a3 in out nocopy NUMBER
496 , p10_a4 in out nocopy NUMBER
497 , p10_a5 in out nocopy VARCHAR2
498 , p10_a6 in out nocopy VARCHAR2
499 , p10_a7 in out nocopy NUMBER
500 , p10_a8 in out nocopy VARCHAR2
501 , p10_a9 in out nocopy VARCHAR2
502 , p10_a10 in out nocopy VARCHAR2
503 , p10_a11 in out nocopy NUMBER
504 , p10_a12 in out nocopy VARCHAR2
505 , p10_a13 in out nocopy VARCHAR2
506 , p10_a14 in out nocopy VARCHAR2
507 , p10_a15 in out nocopy DATE
508 , p10_a16 in out nocopy NUMBER
509 , p10_a17 in out nocopy NUMBER
510 , p10_a18 in out nocopy DATE
511 , p10_a19 in out nocopy NUMBER
512 , p10_a20 in out nocopy NUMBER
513 , p10_a21 in out nocopy DATE
514 , p10_a22 in out nocopy NUMBER
515 , p10_a23 in out nocopy NUMBER
516 , p10_a24 in out nocopy DATE
517 , p10_a25 in out nocopy NUMBER
518 , p10_a26 in out nocopy NUMBER
519 , p10_a27 in out nocopy NUMBER
520 , p10_a28 in out nocopy NUMBER
521 , p10_a29 in out nocopy VARCHAR2
522 , p10_a30 in out nocopy VARCHAR2
523 , p10_a31 in out nocopy VARCHAR2
524 , p10_a32 in out nocopy VARCHAR2
525 , p10_a33 in out nocopy VARCHAR2
526 , p10_a34 in out nocopy VARCHAR2
527 , p10_a35 in out nocopy VARCHAR2
528 , p10_a36 in out nocopy NUMBER
529 , p10_a37 in out nocopy VARCHAR2
530 , p10_a38 in out nocopy NUMBER
531 , p10_a39 in out nocopy VARCHAR2
532 , p10_a40 in out nocopy NUMBER
533 , p10_a41 in out nocopy VARCHAR2
534 , p10_a42 in out nocopy NUMBER
535 , p10_a43 in out nocopy NUMBER
536 , p10_a44 in out nocopy VARCHAR2
537 , p10_a45 in out nocopy NUMBER
538 , p10_a46 in out nocopy NUMBER
539 , p10_a47 in out nocopy NUMBER
540 , p10_a48 in out nocopy VARCHAR2
541 , p10_a49 in out nocopy NUMBER
542 , p10_a50 in out nocopy NUMBER
543 , p10_a51 in out nocopy VARCHAR2
544 , p10_a52 in out nocopy VARCHAR2
545 , p10_a53 in out nocopy NUMBER
546 , p10_a54 in out nocopy NUMBER
547 , p10_a55 in out nocopy VARCHAR2
548 , p10_a56 in out nocopy VARCHAR2
549 , p10_a57 in out nocopy VARCHAR2
550 , p10_a58 in out nocopy NUMBER
551 , p10_a59 in out nocopy NUMBER
552 , p10_a60 in out nocopy NUMBER
553 , p10_a61 in out nocopy NUMBER
554 , p10_a62 in out nocopy NUMBER
555 , p10_a63 in out nocopy NUMBER
556 , p10_a64 in out nocopy NUMBER
557 , p10_a65 in out nocopy NUMBER
558 , p10_a66 in out nocopy VARCHAR2
559 , p10_a67 in out nocopy VARCHAR2
560 , p10_a68 in out nocopy NUMBER
561 , p10_a69 in out nocopy VARCHAR2
562 , p10_a70 in out nocopy NUMBER
563 , p10_a71 in out nocopy NUMBER
564 , p10_a72 in out nocopy NUMBER
565 , p10_a73 in out nocopy NUMBER
566 , p10_a74 in out nocopy VARCHAR2
567 , p10_a75 in out nocopy NUMBER
568 , p10_a76 in out nocopy NUMBER
569 , p10_a77 in out nocopy VARCHAR2
570 , p10_a78 in out nocopy VARCHAR2
571 , p10_a79 in out nocopy VARCHAR2
572 , p10_a80 in out nocopy VARCHAR2
573 , p10_a81 in out nocopy VARCHAR2
574 , p10_a82 in out nocopy VARCHAR2
575 , p10_a83 in out nocopy VARCHAR2
576 , p10_a84 in out nocopy VARCHAR2
577 , p10_a85 in out nocopy VARCHAR2
578 , p10_a86 in out nocopy VARCHAR2
579 , p10_a87 in out nocopy VARCHAR2
580 , p10_a88 in out nocopy VARCHAR2
581 , p10_a89 in out nocopy VARCHAR2
582 , p10_a90 in out nocopy VARCHAR2
583 , p10_a91 in out nocopy VARCHAR2
584 , p10_a92 in out nocopy VARCHAR2
585 , p10_a93 in out nocopy DATE
586 , p10_a94 in out nocopy NUMBER
587 , p10_a95 in out nocopy DATE
588 , p10_a96 in out nocopy NUMBER
589 , p10_a97 in out nocopy NUMBER
590 , p10_a98 in out nocopy VARCHAR2
591 , p10_a99 in out nocopy VARCHAR2
592 , p10_a100 in out nocopy VARCHAR2
593 , p11_a0 in out nocopy JTF_NUMBER_TABLE
594 , p11_a1 in out nocopy JTF_NUMBER_TABLE
595 , p11_a2 in out nocopy JTF_NUMBER_TABLE
596 , p11_a3 in out nocopy JTF_VARCHAR2_TABLE_500
597 , p11_a4 in out nocopy JTF_NUMBER_TABLE
598 , p11_a5 in out nocopy JTF_NUMBER_TABLE
599 , p11_a6 in out nocopy JTF_NUMBER_TABLE
600 , p11_a7 in out nocopy JTF_NUMBER_TABLE
601 , p11_a8 in out nocopy JTF_DATE_TABLE
602 , p11_a9 in out nocopy JTF_NUMBER_TABLE
603 , p11_a10 in out nocopy JTF_DATE_TABLE
604 , p11_a11 in out nocopy JTF_NUMBER_TABLE
605 , p11_a12 in out nocopy JTF_NUMBER_TABLE
606 , p11_a13 in out nocopy JTF_NUMBER_TABLE
607 , p11_a14 in out nocopy JTF_VARCHAR2_TABLE_300
608 , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
609 , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
610 , p11_a17 in out nocopy JTF_NUMBER_TABLE
611 , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
612 , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
613 , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
614 , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
615 , p11_a22 in out nocopy JTF_NUMBER_TABLE
616 , p11_a23 in out nocopy JTF_NUMBER_TABLE
617 , p11_a24 in out nocopy JTF_DATE_TABLE
618 , p11_a25 in out nocopy JTF_NUMBER_TABLE
619 , p11_a26 in out nocopy JTF_NUMBER_TABLE
620 , p11_a27 in out nocopy JTF_DATE_TABLE
621 , p11_a28 in out nocopy JTF_NUMBER_TABLE
622 , p11_a29 in out nocopy JTF_NUMBER_TABLE
623 , p11_a30 in out nocopy JTF_DATE_TABLE
624 , p11_a31 in out nocopy JTF_NUMBER_TABLE
625 , p11_a32 in out nocopy JTF_NUMBER_TABLE
626 , p11_a33 in out nocopy JTF_DATE_TABLE
627 , p11_a34 in out nocopy JTF_NUMBER_TABLE
628 , p11_a35 in out nocopy JTF_NUMBER_TABLE
629 , p11_a36 in out nocopy JTF_NUMBER_TABLE
630 , p11_a37 in out nocopy JTF_NUMBER_TABLE
631 , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100
632 , p11_a39 in out nocopy JTF_NUMBER_TABLE
633 , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100
634 , p11_a41 in out nocopy JTF_VARCHAR2_TABLE_200
635 , p11_a42 in out nocopy JTF_VARCHAR2_TABLE_200
636 , p11_a43 in out nocopy JTF_VARCHAR2_TABLE_200
637 , p11_a44 in out nocopy JTF_VARCHAR2_TABLE_200
638 , p11_a45 in out nocopy JTF_VARCHAR2_TABLE_200
639 , p11_a46 in out nocopy JTF_VARCHAR2_TABLE_200
640 , p11_a47 in out nocopy JTF_VARCHAR2_TABLE_200
641 , p11_a48 in out nocopy JTF_VARCHAR2_TABLE_200
642 , p11_a49 in out nocopy JTF_VARCHAR2_TABLE_200
643 , p11_a50 in out nocopy JTF_VARCHAR2_TABLE_200
644 , p11_a51 in out nocopy JTF_VARCHAR2_TABLE_200
645 , p11_a52 in out nocopy JTF_VARCHAR2_TABLE_200
646 , p11_a53 in out nocopy JTF_VARCHAR2_TABLE_200
647 , p11_a54 in out nocopy JTF_VARCHAR2_TABLE_200
648 , p11_a55 in out nocopy JTF_VARCHAR2_TABLE_200
649 , p11_a56 in out nocopy JTF_VARCHAR2_TABLE_100
650 );
651 procedure insert_turnover_notes(p_api_version NUMBER
652 , p_init_msg_list VARCHAR2
653 , p_commit VARCHAR2
654 , p_validation_level NUMBER
655 , p_default VARCHAR2
656 , p_module_type VARCHAR2
657 , x_return_status out nocopy VARCHAR2
658 , x_msg_count out nocopy NUMBER
659 , x_msg_data out nocopy VARCHAR2
660 , p9_a0 in out nocopy JTF_NUMBER_TABLE
661 , p9_a1 in out nocopy JTF_NUMBER_TABLE
662 , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
663 , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
664 , p9_a4 in out nocopy JTF_NUMBER_TABLE
665 , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_300
666 , p9_a6 in out nocopy JTF_DATE_TABLE
667 , p9_a7 in out nocopy JTF_NUMBER_TABLE
668 );
669 end ahl_prd_workorder_pvt_w;