1 package ahl_prd_workorder_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWPRJS.pls 120.7.12020000.2 2012/12/14 05:54:35 shnatu 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_300
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 , a101 JTF_NUMBER_TABLE
222 , a102 JTF_VARCHAR2_TABLE_100
223 , a103 JTF_VARCHAR2_TABLE_100
224 , a104 JTF_VARCHAR2_TABLE_100
225 );
226 procedure rosetta_table_copy_out_p3(t ahl_prd_workorder_pvt.prd_workorder_tbl, a0 out nocopy JTF_NUMBER_TABLE
227 , a1 out nocopy JTF_NUMBER_TABLE
228 , a2 out nocopy JTF_NUMBER_TABLE
229 , a3 out nocopy JTF_NUMBER_TABLE
230 , a4 out nocopy JTF_NUMBER_TABLE
231 , a5 out nocopy JTF_VARCHAR2_TABLE_100
232 , a6 out nocopy JTF_VARCHAR2_TABLE_300
233 , a7 out nocopy JTF_NUMBER_TABLE
234 , a8 out nocopy JTF_VARCHAR2_TABLE_300
235 , a9 out nocopy JTF_VARCHAR2_TABLE_100
236 , a10 out nocopy JTF_VARCHAR2_TABLE_300
237 , a11 out nocopy JTF_NUMBER_TABLE
238 , a12 out nocopy JTF_VARCHAR2_TABLE_100
239 , a13 out nocopy JTF_VARCHAR2_TABLE_100
240 , a14 out nocopy JTF_VARCHAR2_TABLE_100
241 , a15 out nocopy JTF_DATE_TABLE
242 , a16 out nocopy JTF_NUMBER_TABLE
243 , a17 out nocopy JTF_NUMBER_TABLE
244 , a18 out nocopy JTF_DATE_TABLE
245 , a19 out nocopy JTF_NUMBER_TABLE
246 , a20 out nocopy JTF_NUMBER_TABLE
247 , a21 out nocopy JTF_DATE_TABLE
248 , a22 out nocopy JTF_NUMBER_TABLE
249 , a23 out nocopy JTF_NUMBER_TABLE
250 , a24 out nocopy JTF_DATE_TABLE
251 , a25 out nocopy JTF_NUMBER_TABLE
252 , a26 out nocopy JTF_NUMBER_TABLE
253 , a27 out nocopy JTF_NUMBER_TABLE
254 , a28 out nocopy JTF_NUMBER_TABLE
255 , a29 out nocopy JTF_VARCHAR2_TABLE_100
256 , a30 out nocopy JTF_VARCHAR2_TABLE_100
257 , a31 out nocopy JTF_VARCHAR2_TABLE_100
258 , a32 out nocopy JTF_VARCHAR2_TABLE_300
259 , a33 out nocopy JTF_VARCHAR2_TABLE_100
260 , a34 out nocopy JTF_VARCHAR2_TABLE_100
261 , a35 out nocopy JTF_VARCHAR2_TABLE_100
262 , a36 out nocopy JTF_NUMBER_TABLE
263 , a37 out nocopy JTF_VARCHAR2_TABLE_300
264 , a38 out nocopy JTF_NUMBER_TABLE
265 , a39 out nocopy JTF_VARCHAR2_TABLE_100
266 , a40 out nocopy JTF_NUMBER_TABLE
267 , a41 out nocopy JTF_VARCHAR2_TABLE_100
268 , a42 out nocopy JTF_NUMBER_TABLE
269 , a43 out nocopy JTF_NUMBER_TABLE
270 , a44 out nocopy JTF_VARCHAR2_TABLE_100
271 , a45 out nocopy JTF_NUMBER_TABLE
272 , a46 out nocopy JTF_NUMBER_TABLE
273 , a47 out nocopy JTF_NUMBER_TABLE
274 , a48 out nocopy JTF_VARCHAR2_TABLE_100
275 , a49 out nocopy JTF_NUMBER_TABLE
276 , a50 out nocopy JTF_NUMBER_TABLE
277 , a51 out nocopy JTF_VARCHAR2_TABLE_100
278 , a52 out nocopy JTF_VARCHAR2_TABLE_100
279 , a53 out nocopy JTF_NUMBER_TABLE
280 , a54 out nocopy JTF_NUMBER_TABLE
281 , a55 out nocopy JTF_VARCHAR2_TABLE_300
282 , a56 out nocopy JTF_VARCHAR2_TABLE_100
283 , a57 out nocopy JTF_VARCHAR2_TABLE_100
284 , a58 out nocopy JTF_NUMBER_TABLE
285 , a59 out nocopy JTF_NUMBER_TABLE
286 , a60 out nocopy JTF_NUMBER_TABLE
287 , a61 out nocopy JTF_NUMBER_TABLE
288 , a62 out nocopy JTF_NUMBER_TABLE
289 , a63 out nocopy JTF_NUMBER_TABLE
290 , a64 out nocopy JTF_NUMBER_TABLE
291 , a65 out nocopy JTF_NUMBER_TABLE
292 , a66 out nocopy JTF_VARCHAR2_TABLE_100
293 , a67 out nocopy JTF_VARCHAR2_TABLE_100
294 , a68 out nocopy JTF_NUMBER_TABLE
295 , a69 out nocopy JTF_VARCHAR2_TABLE_100
296 , a70 out nocopy JTF_NUMBER_TABLE
297 , a71 out nocopy JTF_NUMBER_TABLE
298 , a72 out nocopy JTF_NUMBER_TABLE
299 , a73 out nocopy JTF_NUMBER_TABLE
300 , a74 out nocopy JTF_VARCHAR2_TABLE_100
301 , a75 out nocopy JTF_NUMBER_TABLE
302 , a76 out nocopy JTF_NUMBER_TABLE
303 , a77 out nocopy JTF_VARCHAR2_TABLE_100
304 , a78 out nocopy JTF_VARCHAR2_TABLE_200
305 , a79 out nocopy JTF_VARCHAR2_TABLE_200
306 , a80 out nocopy JTF_VARCHAR2_TABLE_200
307 , a81 out nocopy JTF_VARCHAR2_TABLE_200
308 , a82 out nocopy JTF_VARCHAR2_TABLE_200
309 , a83 out nocopy JTF_VARCHAR2_TABLE_200
310 , a84 out nocopy JTF_VARCHAR2_TABLE_200
311 , a85 out nocopy JTF_VARCHAR2_TABLE_200
312 , a86 out nocopy JTF_VARCHAR2_TABLE_200
313 , a87 out nocopy JTF_VARCHAR2_TABLE_200
314 , a88 out nocopy JTF_VARCHAR2_TABLE_200
315 , a89 out nocopy JTF_VARCHAR2_TABLE_200
316 , a90 out nocopy JTF_VARCHAR2_TABLE_200
317 , a91 out nocopy JTF_VARCHAR2_TABLE_200
318 , a92 out nocopy JTF_VARCHAR2_TABLE_200
319 , a93 out nocopy JTF_DATE_TABLE
320 , a94 out nocopy JTF_NUMBER_TABLE
321 , a95 out nocopy JTF_DATE_TABLE
322 , a96 out nocopy JTF_NUMBER_TABLE
323 , a97 out nocopy JTF_NUMBER_TABLE
324 , a98 out nocopy JTF_VARCHAR2_TABLE_100
325 , a99 out nocopy JTF_VARCHAR2_TABLE_100
326 , a100 out nocopy JTF_VARCHAR2_TABLE_100
327 , a101 out nocopy JTF_NUMBER_TABLE
328 , a102 out nocopy JTF_VARCHAR2_TABLE_100
329 , a103 out nocopy JTF_VARCHAR2_TABLE_100
330 , a104 out nocopy JTF_VARCHAR2_TABLE_100
331 );
332
333 procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 JTF_NUMBER_TABLE
334 , a1 JTF_NUMBER_TABLE
335 , a2 JTF_NUMBER_TABLE
336 , a3 JTF_NUMBER_TABLE
337 , a4 JTF_NUMBER_TABLE
338 , a5 JTF_NUMBER_TABLE
339 , a6 JTF_NUMBER_TABLE
340 , a7 JTF_VARCHAR2_TABLE_100
341 );
342 procedure rosetta_table_copy_out_p5(t ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 out nocopy JTF_NUMBER_TABLE
343 , a1 out nocopy JTF_NUMBER_TABLE
344 , a2 out nocopy JTF_NUMBER_TABLE
345 , a3 out nocopy JTF_NUMBER_TABLE
346 , a4 out nocopy JTF_NUMBER_TABLE
347 , a5 out nocopy JTF_NUMBER_TABLE
348 , a6 out nocopy JTF_NUMBER_TABLE
349 , a7 out nocopy JTF_VARCHAR2_TABLE_100
350 );
351
352 procedure rosetta_table_copy_in_p14(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
353 , a1 JTF_NUMBER_TABLE
354 , a2 JTF_VARCHAR2_TABLE_100
355 , a3 JTF_VARCHAR2_TABLE_2000
356 , a4 JTF_NUMBER_TABLE
357 , a5 JTF_VARCHAR2_TABLE_300
358 , a6 JTF_DATE_TABLE
359 , a7 JTF_NUMBER_TABLE
360 );
361 procedure rosetta_table_copy_out_p14(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
362 , a1 out nocopy JTF_NUMBER_TABLE
363 , a2 out nocopy JTF_VARCHAR2_TABLE_100
364 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
365 , a4 out nocopy JTF_NUMBER_TABLE
366 , a5 out nocopy JTF_VARCHAR2_TABLE_300
367 , a6 out nocopy JTF_DATE_TABLE
368 , a7 out nocopy JTF_NUMBER_TABLE
369 );
370
371 procedure rosetta_table_copy_in_p23(t out nocopy ahl_prd_workorder_pvt.workorder_id_tbl_type, a0 JTF_NUMBER_TABLE
372 , a1 JTF_NUMBER_TABLE
373 );
374 procedure rosetta_table_copy_out_p23(t ahl_prd_workorder_pvt.workorder_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
375 , a1 out nocopy JTF_NUMBER_TABLE
376 );
377
378 procedure process_jobs(p_api_version NUMBER
379 , p_init_msg_list VARCHAR2
380 , p_commit VARCHAR2
381 , p_validation_level NUMBER
382 , p_default VARCHAR2
383 , p_module_type VARCHAR2
384 , x_return_status out nocopy VARCHAR2
385 , x_msg_count out nocopy NUMBER
386 , x_msg_data out nocopy VARCHAR2
387 , p9_a0 in out nocopy JTF_NUMBER_TABLE
388 , p9_a1 in out nocopy JTF_NUMBER_TABLE
389 , p9_a2 in out nocopy JTF_NUMBER_TABLE
390 , p9_a3 in out nocopy JTF_NUMBER_TABLE
391 , p9_a4 in out nocopy JTF_NUMBER_TABLE
392 , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
393 , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
394 , p9_a7 in out nocopy JTF_NUMBER_TABLE
395 , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_300
396 , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
397 , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
398 , p9_a11 in out nocopy JTF_NUMBER_TABLE
399 , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
400 , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
401 , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
402 , p9_a15 in out nocopy JTF_DATE_TABLE
403 , p9_a16 in out nocopy JTF_NUMBER_TABLE
404 , p9_a17 in out nocopy JTF_NUMBER_TABLE
405 , p9_a18 in out nocopy JTF_DATE_TABLE
406 , p9_a19 in out nocopy JTF_NUMBER_TABLE
407 , p9_a20 in out nocopy JTF_NUMBER_TABLE
408 , p9_a21 in out nocopy JTF_DATE_TABLE
409 , p9_a22 in out nocopy JTF_NUMBER_TABLE
410 , p9_a23 in out nocopy JTF_NUMBER_TABLE
411 , p9_a24 in out nocopy JTF_DATE_TABLE
412 , p9_a25 in out nocopy JTF_NUMBER_TABLE
413 , p9_a26 in out nocopy JTF_NUMBER_TABLE
414 , p9_a27 in out nocopy JTF_NUMBER_TABLE
415 , p9_a28 in out nocopy JTF_NUMBER_TABLE
416 , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
417 , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
418 , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
419 , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
420 , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
421 , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
422 , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
423 , p9_a36 in out nocopy JTF_NUMBER_TABLE
424 , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
425 , p9_a38 in out nocopy JTF_NUMBER_TABLE
426 , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
427 , p9_a40 in out nocopy JTF_NUMBER_TABLE
428 , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
429 , p9_a42 in out nocopy JTF_NUMBER_TABLE
430 , p9_a43 in out nocopy JTF_NUMBER_TABLE
431 , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
432 , p9_a45 in out nocopy JTF_NUMBER_TABLE
433 , p9_a46 in out nocopy JTF_NUMBER_TABLE
434 , p9_a47 in out nocopy JTF_NUMBER_TABLE
435 , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
436 , p9_a49 in out nocopy JTF_NUMBER_TABLE
437 , p9_a50 in out nocopy JTF_NUMBER_TABLE
438 , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
439 , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
440 , p9_a53 in out nocopy JTF_NUMBER_TABLE
441 , p9_a54 in out nocopy JTF_NUMBER_TABLE
442 , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
443 , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100
444 , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100
445 , p9_a58 in out nocopy JTF_NUMBER_TABLE
446 , p9_a59 in out nocopy JTF_NUMBER_TABLE
447 , p9_a60 in out nocopy JTF_NUMBER_TABLE
448 , p9_a61 in out nocopy JTF_NUMBER_TABLE
449 , p9_a62 in out nocopy JTF_NUMBER_TABLE
450 , p9_a63 in out nocopy JTF_NUMBER_TABLE
451 , p9_a64 in out nocopy JTF_NUMBER_TABLE
452 , p9_a65 in out nocopy JTF_NUMBER_TABLE
453 , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
454 , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
455 , p9_a68 in out nocopy JTF_NUMBER_TABLE
456 , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
457 , p9_a70 in out nocopy JTF_NUMBER_TABLE
458 , p9_a71 in out nocopy JTF_NUMBER_TABLE
459 , p9_a72 in out nocopy JTF_NUMBER_TABLE
460 , p9_a73 in out nocopy JTF_NUMBER_TABLE
461 , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100
462 , p9_a75 in out nocopy JTF_NUMBER_TABLE
463 , p9_a76 in out nocopy JTF_NUMBER_TABLE
464 , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100
465 , p9_a78 in out nocopy JTF_VARCHAR2_TABLE_200
466 , p9_a79 in out nocopy JTF_VARCHAR2_TABLE_200
467 , p9_a80 in out nocopy JTF_VARCHAR2_TABLE_200
468 , p9_a81 in out nocopy JTF_VARCHAR2_TABLE_200
469 , p9_a82 in out nocopy JTF_VARCHAR2_TABLE_200
470 , p9_a83 in out nocopy JTF_VARCHAR2_TABLE_200
471 , p9_a84 in out nocopy JTF_VARCHAR2_TABLE_200
472 , p9_a85 in out nocopy JTF_VARCHAR2_TABLE_200
473 , p9_a86 in out nocopy JTF_VARCHAR2_TABLE_200
474 , p9_a87 in out nocopy JTF_VARCHAR2_TABLE_200
475 , p9_a88 in out nocopy JTF_VARCHAR2_TABLE_200
476 , p9_a89 in out nocopy JTF_VARCHAR2_TABLE_200
477 , p9_a90 in out nocopy JTF_VARCHAR2_TABLE_200
478 , p9_a91 in out nocopy JTF_VARCHAR2_TABLE_200
479 , p9_a92 in out nocopy JTF_VARCHAR2_TABLE_200
480 , p9_a93 in out nocopy JTF_DATE_TABLE
481 , p9_a94 in out nocopy JTF_NUMBER_TABLE
482 , p9_a95 in out nocopy JTF_DATE_TABLE
483 , p9_a96 in out nocopy JTF_NUMBER_TABLE
484 , p9_a97 in out nocopy JTF_NUMBER_TABLE
485 , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
486 , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
487 , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
488 , p9_a101 in out nocopy JTF_NUMBER_TABLE
489 , p9_a102 in out nocopy JTF_VARCHAR2_TABLE_100
490 , p9_a103 in out nocopy JTF_VARCHAR2_TABLE_100
491 , p9_a104 in out nocopy JTF_VARCHAR2_TABLE_100
492 , p10_a0 JTF_NUMBER_TABLE
493 , p10_a1 JTF_NUMBER_TABLE
494 , p10_a2 JTF_NUMBER_TABLE
495 , p10_a3 JTF_NUMBER_TABLE
496 , p10_a4 JTF_NUMBER_TABLE
497 , p10_a5 JTF_NUMBER_TABLE
498 , p10_a6 JTF_NUMBER_TABLE
499 , p10_a7 JTF_VARCHAR2_TABLE_100
500 );
501 procedure update_job(p_api_version NUMBER
502 , p_init_msg_list VARCHAR2
503 , p_commit VARCHAR2
504 , p_validation_level NUMBER
505 , p_default VARCHAR2
506 , p_module_type VARCHAR2
507 , x_return_status out nocopy VARCHAR2
508 , x_msg_count out nocopy NUMBER
509 , x_msg_data out nocopy VARCHAR2
510 , p_wip_load_flag VARCHAR2
511 , p10_a0 in out nocopy NUMBER
512 , p10_a1 in out nocopy NUMBER
513 , p10_a2 in out nocopy NUMBER
514 , p10_a3 in out nocopy NUMBER
515 , p10_a4 in out nocopy NUMBER
516 , p10_a5 in out nocopy VARCHAR2
517 , p10_a6 in out nocopy VARCHAR2
518 , p10_a7 in out nocopy NUMBER
519 , p10_a8 in out nocopy VARCHAR2
520 , p10_a9 in out nocopy VARCHAR2
521 , p10_a10 in out nocopy VARCHAR2
522 , p10_a11 in out nocopy NUMBER
523 , p10_a12 in out nocopy VARCHAR2
524 , p10_a13 in out nocopy VARCHAR2
525 , p10_a14 in out nocopy VARCHAR2
526 , p10_a15 in out nocopy DATE
527 , p10_a16 in out nocopy NUMBER
528 , p10_a17 in out nocopy NUMBER
529 , p10_a18 in out nocopy DATE
530 , p10_a19 in out nocopy NUMBER
531 , p10_a20 in out nocopy NUMBER
532 , p10_a21 in out nocopy DATE
533 , p10_a22 in out nocopy NUMBER
534 , p10_a23 in out nocopy NUMBER
535 , p10_a24 in out nocopy DATE
536 , p10_a25 in out nocopy NUMBER
537 , p10_a26 in out nocopy NUMBER
538 , p10_a27 in out nocopy NUMBER
539 , p10_a28 in out nocopy NUMBER
540 , p10_a29 in out nocopy VARCHAR2
541 , p10_a30 in out nocopy VARCHAR2
542 , p10_a31 in out nocopy VARCHAR2
543 , p10_a32 in out nocopy VARCHAR2
544 , p10_a33 in out nocopy VARCHAR2
545 , p10_a34 in out nocopy VARCHAR2
546 , p10_a35 in out nocopy VARCHAR2
547 , p10_a36 in out nocopy NUMBER
548 , p10_a37 in out nocopy VARCHAR2
549 , p10_a38 in out nocopy NUMBER
550 , p10_a39 in out nocopy VARCHAR2
551 , p10_a40 in out nocopy NUMBER
552 , p10_a41 in out nocopy VARCHAR2
553 , p10_a42 in out nocopy NUMBER
554 , p10_a43 in out nocopy NUMBER
555 , p10_a44 in out nocopy VARCHAR2
556 , p10_a45 in out nocopy NUMBER
557 , p10_a46 in out nocopy NUMBER
558 , p10_a47 in out nocopy NUMBER
559 , p10_a48 in out nocopy VARCHAR2
560 , p10_a49 in out nocopy NUMBER
561 , p10_a50 in out nocopy NUMBER
562 , p10_a51 in out nocopy VARCHAR2
563 , p10_a52 in out nocopy VARCHAR2
564 , p10_a53 in out nocopy NUMBER
565 , p10_a54 in out nocopy NUMBER
566 , p10_a55 in out nocopy VARCHAR2
567 , p10_a56 in out nocopy VARCHAR2
568 , p10_a57 in out nocopy VARCHAR2
569 , p10_a58 in out nocopy NUMBER
570 , p10_a59 in out nocopy NUMBER
571 , p10_a60 in out nocopy NUMBER
572 , p10_a61 in out nocopy NUMBER
573 , p10_a62 in out nocopy NUMBER
574 , p10_a63 in out nocopy NUMBER
575 , p10_a64 in out nocopy NUMBER
576 , p10_a65 in out nocopy NUMBER
577 , p10_a66 in out nocopy VARCHAR2
578 , p10_a67 in out nocopy VARCHAR2
579 , p10_a68 in out nocopy NUMBER
580 , p10_a69 in out nocopy VARCHAR2
581 , p10_a70 in out nocopy NUMBER
582 , p10_a71 in out nocopy NUMBER
583 , p10_a72 in out nocopy NUMBER
584 , p10_a73 in out nocopy NUMBER
585 , p10_a74 in out nocopy VARCHAR2
586 , p10_a75 in out nocopy NUMBER
587 , p10_a76 in out nocopy NUMBER
588 , p10_a77 in out nocopy VARCHAR2
589 , p10_a78 in out nocopy VARCHAR2
590 , p10_a79 in out nocopy VARCHAR2
591 , p10_a80 in out nocopy VARCHAR2
592 , p10_a81 in out nocopy VARCHAR2
593 , p10_a82 in out nocopy VARCHAR2
594 , p10_a83 in out nocopy VARCHAR2
595 , p10_a84 in out nocopy VARCHAR2
596 , p10_a85 in out nocopy VARCHAR2
597 , p10_a86 in out nocopy VARCHAR2
598 , p10_a87 in out nocopy VARCHAR2
599 , p10_a88 in out nocopy VARCHAR2
600 , p10_a89 in out nocopy VARCHAR2
601 , p10_a90 in out nocopy VARCHAR2
602 , p10_a91 in out nocopy VARCHAR2
603 , p10_a92 in out nocopy VARCHAR2
604 , p10_a93 in out nocopy DATE
605 , p10_a94 in out nocopy NUMBER
606 , p10_a95 in out nocopy DATE
607 , p10_a96 in out nocopy NUMBER
608 , p10_a97 in out nocopy NUMBER
609 , p10_a98 in out nocopy VARCHAR2
610 , p10_a99 in out nocopy VARCHAR2
611 , p10_a100 in out nocopy VARCHAR2
612 , p10_a101 in out nocopy NUMBER
613 , p10_a102 in out nocopy VARCHAR2
614 , p10_a103 in out nocopy VARCHAR2
615 , p10_a104 in out nocopy VARCHAR2
616 , p11_a0 in out nocopy JTF_NUMBER_TABLE
617 , p11_a1 in out nocopy JTF_NUMBER_TABLE
618 , p11_a2 in out nocopy JTF_NUMBER_TABLE
619 , p11_a3 in out nocopy JTF_VARCHAR2_TABLE_500
620 , p11_a4 in out nocopy JTF_NUMBER_TABLE
621 , p11_a5 in out nocopy JTF_NUMBER_TABLE
622 , p11_a6 in out nocopy JTF_NUMBER_TABLE
623 , p11_a7 in out nocopy JTF_NUMBER_TABLE
624 , p11_a8 in out nocopy JTF_DATE_TABLE
625 , p11_a9 in out nocopy JTF_NUMBER_TABLE
626 , p11_a10 in out nocopy JTF_DATE_TABLE
627 , p11_a11 in out nocopy JTF_NUMBER_TABLE
628 , p11_a12 in out nocopy JTF_NUMBER_TABLE
629 , p11_a13 in out nocopy JTF_NUMBER_TABLE
630 , p11_a14 in out nocopy JTF_VARCHAR2_TABLE_300
631 , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
632 , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
633 , p11_a17 in out nocopy JTF_NUMBER_TABLE
634 , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
635 , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
636 , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
637 , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
638 , p11_a22 in out nocopy JTF_NUMBER_TABLE
639 , p11_a23 in out nocopy JTF_NUMBER_TABLE
640 , p11_a24 in out nocopy JTF_DATE_TABLE
641 , p11_a25 in out nocopy JTF_NUMBER_TABLE
642 , p11_a26 in out nocopy JTF_NUMBER_TABLE
643 , p11_a27 in out nocopy JTF_DATE_TABLE
644 , p11_a28 in out nocopy JTF_NUMBER_TABLE
645 , p11_a29 in out nocopy JTF_NUMBER_TABLE
646 , p11_a30 in out nocopy JTF_DATE_TABLE
647 , p11_a31 in out nocopy JTF_NUMBER_TABLE
648 , p11_a32 in out nocopy JTF_NUMBER_TABLE
649 , p11_a33 in out nocopy JTF_DATE_TABLE
650 , p11_a34 in out nocopy JTF_NUMBER_TABLE
651 , p11_a35 in out nocopy JTF_NUMBER_TABLE
652 , p11_a36 in out nocopy JTF_NUMBER_TABLE
653 , p11_a37 in out nocopy JTF_NUMBER_TABLE
654 , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100
655 , p11_a39 in out nocopy JTF_NUMBER_TABLE
656 , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100
657 , p11_a41 in out nocopy JTF_VARCHAR2_TABLE_200
658 , p11_a42 in out nocopy JTF_VARCHAR2_TABLE_200
659 , p11_a43 in out nocopy JTF_VARCHAR2_TABLE_200
660 , p11_a44 in out nocopy JTF_VARCHAR2_TABLE_200
661 , p11_a45 in out nocopy JTF_VARCHAR2_TABLE_200
662 , p11_a46 in out nocopy JTF_VARCHAR2_TABLE_200
663 , p11_a47 in out nocopy JTF_VARCHAR2_TABLE_200
664 , p11_a48 in out nocopy JTF_VARCHAR2_TABLE_200
665 , p11_a49 in out nocopy JTF_VARCHAR2_TABLE_200
666 , p11_a50 in out nocopy JTF_VARCHAR2_TABLE_200
667 , p11_a51 in out nocopy JTF_VARCHAR2_TABLE_200
668 , p11_a52 in out nocopy JTF_VARCHAR2_TABLE_200
669 , p11_a53 in out nocopy JTF_VARCHAR2_TABLE_200
670 , p11_a54 in out nocopy JTF_VARCHAR2_TABLE_200
671 , p11_a55 in out nocopy JTF_VARCHAR2_TABLE_200
672 , p11_a56 in out nocopy JTF_VARCHAR2_TABLE_100
673 );
674 procedure process_stage_jobs(p_api_version NUMBER
675 , p_init_msg_list VARCHAR2
676 , p_commit VARCHAR2
677 , p_validation_level NUMBER
678 , p_module_type VARCHAR2
679 , p5_a0 JTF_NUMBER_TABLE
680 , p5_a1 JTF_NUMBER_TABLE
681 , p5_a2 JTF_NUMBER_TABLE
682 , p5_a3 JTF_NUMBER_TABLE
683 , p5_a4 JTF_NUMBER_TABLE
684 , p5_a5 JTF_VARCHAR2_TABLE_100
685 , p5_a6 JTF_VARCHAR2_TABLE_300
686 , p5_a7 JTF_NUMBER_TABLE
687 , p5_a8 JTF_VARCHAR2_TABLE_300
688 , p5_a9 JTF_VARCHAR2_TABLE_100
689 , p5_a10 JTF_VARCHAR2_TABLE_300
690 , p5_a11 JTF_NUMBER_TABLE
691 , p5_a12 JTF_VARCHAR2_TABLE_100
692 , p5_a13 JTF_VARCHAR2_TABLE_100
693 , p5_a14 JTF_VARCHAR2_TABLE_100
694 , p5_a15 JTF_DATE_TABLE
695 , p5_a16 JTF_NUMBER_TABLE
696 , p5_a17 JTF_NUMBER_TABLE
697 , p5_a18 JTF_DATE_TABLE
698 , p5_a19 JTF_NUMBER_TABLE
699 , p5_a20 JTF_NUMBER_TABLE
700 , p5_a21 JTF_DATE_TABLE
701 , p5_a22 JTF_NUMBER_TABLE
702 , p5_a23 JTF_NUMBER_TABLE
703 , p5_a24 JTF_DATE_TABLE
704 , p5_a25 JTF_NUMBER_TABLE
705 , p5_a26 JTF_NUMBER_TABLE
706 , p5_a27 JTF_NUMBER_TABLE
707 , p5_a28 JTF_NUMBER_TABLE
708 , p5_a29 JTF_VARCHAR2_TABLE_100
709 , p5_a30 JTF_VARCHAR2_TABLE_100
710 , p5_a31 JTF_VARCHAR2_TABLE_100
711 , p5_a32 JTF_VARCHAR2_TABLE_300
712 , p5_a33 JTF_VARCHAR2_TABLE_100
713 , p5_a34 JTF_VARCHAR2_TABLE_100
714 , p5_a35 JTF_VARCHAR2_TABLE_100
715 , p5_a36 JTF_NUMBER_TABLE
716 , p5_a37 JTF_VARCHAR2_TABLE_300
717 , p5_a38 JTF_NUMBER_TABLE
718 , p5_a39 JTF_VARCHAR2_TABLE_100
719 , p5_a40 JTF_NUMBER_TABLE
720 , p5_a41 JTF_VARCHAR2_TABLE_100
721 , p5_a42 JTF_NUMBER_TABLE
722 , p5_a43 JTF_NUMBER_TABLE
723 , p5_a44 JTF_VARCHAR2_TABLE_100
724 , p5_a45 JTF_NUMBER_TABLE
725 , p5_a46 JTF_NUMBER_TABLE
726 , p5_a47 JTF_NUMBER_TABLE
727 , p5_a48 JTF_VARCHAR2_TABLE_100
728 , p5_a49 JTF_NUMBER_TABLE
729 , p5_a50 JTF_NUMBER_TABLE
730 , p5_a51 JTF_VARCHAR2_TABLE_100
731 , p5_a52 JTF_VARCHAR2_TABLE_100
732 , p5_a53 JTF_NUMBER_TABLE
733 , p5_a54 JTF_NUMBER_TABLE
734 , p5_a55 JTF_VARCHAR2_TABLE_300
735 , p5_a56 JTF_VARCHAR2_TABLE_100
736 , p5_a57 JTF_VARCHAR2_TABLE_100
737 , p5_a58 JTF_NUMBER_TABLE
738 , p5_a59 JTF_NUMBER_TABLE
739 , p5_a60 JTF_NUMBER_TABLE
740 , p5_a61 JTF_NUMBER_TABLE
741 , p5_a62 JTF_NUMBER_TABLE
742 , p5_a63 JTF_NUMBER_TABLE
743 , p5_a64 JTF_NUMBER_TABLE
744 , p5_a65 JTF_NUMBER_TABLE
745 , p5_a66 JTF_VARCHAR2_TABLE_100
746 , p5_a67 JTF_VARCHAR2_TABLE_100
747 , p5_a68 JTF_NUMBER_TABLE
748 , p5_a69 JTF_VARCHAR2_TABLE_100
749 , p5_a70 JTF_NUMBER_TABLE
750 , p5_a71 JTF_NUMBER_TABLE
751 , p5_a72 JTF_NUMBER_TABLE
752 , p5_a73 JTF_NUMBER_TABLE
753 , p5_a74 JTF_VARCHAR2_TABLE_100
754 , p5_a75 JTF_NUMBER_TABLE
755 , p5_a76 JTF_NUMBER_TABLE
756 , p5_a77 JTF_VARCHAR2_TABLE_100
757 , p5_a78 JTF_VARCHAR2_TABLE_200
758 , p5_a79 JTF_VARCHAR2_TABLE_200
759 , p5_a80 JTF_VARCHAR2_TABLE_200
760 , p5_a81 JTF_VARCHAR2_TABLE_200
761 , p5_a82 JTF_VARCHAR2_TABLE_200
762 , p5_a83 JTF_VARCHAR2_TABLE_200
763 , p5_a84 JTF_VARCHAR2_TABLE_200
764 , p5_a85 JTF_VARCHAR2_TABLE_200
765 , p5_a86 JTF_VARCHAR2_TABLE_200
766 , p5_a87 JTF_VARCHAR2_TABLE_200
767 , p5_a88 JTF_VARCHAR2_TABLE_200
768 , p5_a89 JTF_VARCHAR2_TABLE_200
769 , p5_a90 JTF_VARCHAR2_TABLE_200
770 , p5_a91 JTF_VARCHAR2_TABLE_200
771 , p5_a92 JTF_VARCHAR2_TABLE_200
772 , p5_a93 JTF_DATE_TABLE
773 , p5_a94 JTF_NUMBER_TABLE
774 , p5_a95 JTF_DATE_TABLE
775 , p5_a96 JTF_NUMBER_TABLE
776 , p5_a97 JTF_NUMBER_TABLE
777 , p5_a98 JTF_VARCHAR2_TABLE_100
778 , p5_a99 JTF_VARCHAR2_TABLE_100
779 , p5_a100 JTF_VARCHAR2_TABLE_100
780 , p5_a101 JTF_NUMBER_TABLE
781 , p5_a102 JTF_VARCHAR2_TABLE_100
782 , p5_a103 JTF_VARCHAR2_TABLE_100
783 , p5_a104 JTF_VARCHAR2_TABLE_100
784 , x_return_status out nocopy VARCHAR2
785 , x_msg_count out nocopy NUMBER
786 , x_msg_data out nocopy VARCHAR2
787 );
788 procedure reschedule_visit_jobs(p_api_version NUMBER
789 , p_init_msg_list VARCHAR2
790 , p_commit VARCHAR2
791 , p_validation_level NUMBER
792 , p_default VARCHAR2
793 , p_module_type VARCHAR2
794 , x_return_status out nocopy VARCHAR2
795 , x_msg_count out nocopy NUMBER
796 , x_msg_data out nocopy VARCHAR2
797 , p_visit_id NUMBER
798 , p_x_scheduled_start_date in out nocopy date
799 , p_x_scheduled_end_date in out nocopy date
800 );
801 procedure insert_turnover_notes(p_api_version NUMBER
802 , p_init_msg_list VARCHAR2
803 , p_commit VARCHAR2
804 , p_validation_level NUMBER
805 , p_default VARCHAR2
806 , p_module_type VARCHAR2
807 , x_return_status out nocopy VARCHAR2
808 , x_msg_count out nocopy NUMBER
809 , x_msg_data out nocopy VARCHAR2
810 , p9_a0 in out nocopy JTF_NUMBER_TABLE
811 , p9_a1 in out nocopy JTF_NUMBER_TABLE
812 , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
813 , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
814 , p9_a4 in out nocopy JTF_NUMBER_TABLE
815 , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_300
816 , p9_a6 in out nocopy JTF_DATE_TABLE
817 , p9_a7 in out nocopy JTF_NUMBER_TABLE
818 );
819 procedure unclose_workorder(p_api_version NUMBER
820 , p_init_msg_list VARCHAR2
821 , p_commit VARCHAR2
822 , p_validation_level NUMBER
823 , p_default VARCHAR2
824 , p_module_type VARCHAR2
825 , x_return_status out nocopy VARCHAR2
826 , x_msg_count out nocopy NUMBER
827 , x_msg_data out nocopy VARCHAR2
828 , p9_a0 in out nocopy NUMBER
829 , p9_a1 in out nocopy NUMBER
830 , p9_a2 in out nocopy NUMBER
831 , p9_a3 in out nocopy NUMBER
832 , p9_a4 in out nocopy NUMBER
833 , p9_a5 in out nocopy VARCHAR2
834 , p9_a6 in out nocopy VARCHAR2
835 , p9_a7 in out nocopy NUMBER
836 , p9_a8 in out nocopy VARCHAR2
837 , p9_a9 in out nocopy VARCHAR2
838 , p9_a10 in out nocopy VARCHAR2
839 , p9_a11 in out nocopy NUMBER
840 , p9_a12 in out nocopy VARCHAR2
841 , p9_a13 in out nocopy VARCHAR2
842 , p9_a14 in out nocopy VARCHAR2
843 , p9_a15 in out nocopy DATE
844 , p9_a16 in out nocopy NUMBER
845 , p9_a17 in out nocopy NUMBER
846 , p9_a18 in out nocopy DATE
847 , p9_a19 in out nocopy NUMBER
848 , p9_a20 in out nocopy NUMBER
849 , p9_a21 in out nocopy DATE
850 , p9_a22 in out nocopy NUMBER
851 , p9_a23 in out nocopy NUMBER
852 , p9_a24 in out nocopy DATE
853 , p9_a25 in out nocopy NUMBER
854 , p9_a26 in out nocopy NUMBER
855 , p9_a27 in out nocopy NUMBER
856 , p9_a28 in out nocopy NUMBER
857 , p9_a29 in out nocopy VARCHAR2
858 , p9_a30 in out nocopy VARCHAR2
859 , p9_a31 in out nocopy VARCHAR2
860 , p9_a32 in out nocopy VARCHAR2
861 , p9_a33 in out nocopy VARCHAR2
862 , p9_a34 in out nocopy VARCHAR2
863 , p9_a35 in out nocopy VARCHAR2
864 , p9_a36 in out nocopy NUMBER
865 , p9_a37 in out nocopy VARCHAR2
866 , p9_a38 in out nocopy NUMBER
867 , p9_a39 in out nocopy VARCHAR2
868 , p9_a40 in out nocopy NUMBER
869 , p9_a41 in out nocopy VARCHAR2
870 , p9_a42 in out nocopy NUMBER
871 , p9_a43 in out nocopy NUMBER
872 , p9_a44 in out nocopy VARCHAR2
873 , p9_a45 in out nocopy NUMBER
874 , p9_a46 in out nocopy NUMBER
875 , p9_a47 in out nocopy NUMBER
876 , p9_a48 in out nocopy VARCHAR2
877 , p9_a49 in out nocopy NUMBER
878 , p9_a50 in out nocopy NUMBER
879 , p9_a51 in out nocopy VARCHAR2
880 , p9_a52 in out nocopy VARCHAR2
881 , p9_a53 in out nocopy NUMBER
882 , p9_a54 in out nocopy NUMBER
883 , p9_a55 in out nocopy VARCHAR2
884 , p9_a56 in out nocopy VARCHAR2
885 , p9_a57 in out nocopy VARCHAR2
886 , p9_a58 in out nocopy NUMBER
887 , p9_a59 in out nocopy NUMBER
888 , p9_a60 in out nocopy NUMBER
889 , p9_a61 in out nocopy NUMBER
890 , p9_a62 in out nocopy NUMBER
891 , p9_a63 in out nocopy NUMBER
892 , p9_a64 in out nocopy NUMBER
893 , p9_a65 in out nocopy NUMBER
894 , p9_a66 in out nocopy VARCHAR2
895 , p9_a67 in out nocopy VARCHAR2
896 , p9_a68 in out nocopy NUMBER
897 , p9_a69 in out nocopy VARCHAR2
898 , p9_a70 in out nocopy NUMBER
899 , p9_a71 in out nocopy NUMBER
900 , p9_a72 in out nocopy NUMBER
901 , p9_a73 in out nocopy NUMBER
902 , p9_a74 in out nocopy VARCHAR2
903 , p9_a75 in out nocopy NUMBER
904 , p9_a76 in out nocopy NUMBER
905 , p9_a77 in out nocopy VARCHAR2
906 , p9_a78 in out nocopy VARCHAR2
907 , p9_a79 in out nocopy VARCHAR2
908 , p9_a80 in out nocopy VARCHAR2
909 , p9_a81 in out nocopy VARCHAR2
910 , p9_a82 in out nocopy VARCHAR2
911 , p9_a83 in out nocopy VARCHAR2
912 , p9_a84 in out nocopy VARCHAR2
913 , p9_a85 in out nocopy VARCHAR2
914 , p9_a86 in out nocopy VARCHAR2
915 , p9_a87 in out nocopy VARCHAR2
916 , p9_a88 in out nocopy VARCHAR2
917 , p9_a89 in out nocopy VARCHAR2
918 , p9_a90 in out nocopy VARCHAR2
919 , p9_a91 in out nocopy VARCHAR2
920 , p9_a92 in out nocopy VARCHAR2
921 , p9_a93 in out nocopy DATE
922 , p9_a94 in out nocopy NUMBER
923 , p9_a95 in out nocopy DATE
924 , p9_a96 in out nocopy NUMBER
925 , p9_a97 in out nocopy NUMBER
926 , p9_a98 in out nocopy VARCHAR2
927 , p9_a99 in out nocopy VARCHAR2
928 , p9_a100 in out nocopy VARCHAR2
929 , p9_a101 in out nocopy NUMBER
930 , p9_a102 in out nocopy VARCHAR2
931 , p9_a103 in out nocopy VARCHAR2
932 , p9_a104 in out nocopy VARCHAR2
933 );
934 procedure populate_entitlements(p_api_version NUMBER
935 , p_init_msg_list VARCHAR2
936 , p_commit VARCHAR2
937 , p_validation_level NUMBER
938 , p_contract_number NUMBER
939 , p5_a0 in out nocopy NUMBER
940 , p5_a1 in out nocopy VARCHAR2
941 , p5_a2 in out nocopy NUMBER
942 , p5_a3 in out nocopy DATE
943 , p5_a4 in out nocopy NUMBER
944 , p5_a5 in out nocopy DATE
945 , p5_a6 in out nocopy NUMBER
946 , p5_a7 in out nocopy NUMBER
947 , p5_a8 in out nocopy NUMBER
948 , p5_a9 in out nocopy NUMBER
949 , p5_a10 in out nocopy VARCHAR2
950 , p5_a11 in out nocopy NUMBER
951 , p5_a12 in out nocopy NUMBER
952 , p5_a13 in out nocopy NUMBER
953 , p5_a14 in out nocopy NUMBER
954 , p5_a15 in out nocopy NUMBER
955 , p5_a16 in out nocopy NUMBER
956 , p5_a17 in out nocopy VARCHAR2
957 , p5_a18 in out nocopy VARCHAR2
958 , p5_a19 in out nocopy NUMBER
959 , p5_a20 in out nocopy VARCHAR2
960 , p5_a21 in out nocopy VARCHAR2
961 , p5_a22 in out nocopy VARCHAR2
962 , p5_a23 in out nocopy VARCHAR2
963 , p5_a24 in out nocopy VARCHAR2
964 , p5_a25 in out nocopy VARCHAR2
965 , p5_a26 in out nocopy VARCHAR2
966 , p5_a27 in out nocopy VARCHAR2
967 , p5_a28 in out nocopy VARCHAR2
968 , p5_a29 in out nocopy VARCHAR2
969 , p5_a30 in out nocopy VARCHAR2
970 , p5_a31 in out nocopy VARCHAR2
971 , p5_a32 in out nocopy VARCHAR2
972 , p5_a33 in out nocopy VARCHAR2
973 , p5_a34 in out nocopy VARCHAR2
974 , p5_a35 in out nocopy VARCHAR2
975 , p_user_role VARCHAR2
976 , x_return_status out nocopy VARCHAR2
977 , x_msg_count out nocopy NUMBER
978 , x_msg_data out nocopy VARCHAR2
979 );
980 procedure update_wo_aog_status(p_api_version NUMBER
981 , p_init_msg_list VARCHAR2
982 , p_commit VARCHAR2
983 , p3_a0 JTF_NUMBER_TABLE
984 , p3_a1 JTF_NUMBER_TABLE
985 , x_return_status out nocopy VARCHAR2
986 , x_msg_count out nocopy NUMBER
987 , x_msg_data out nocopy VARCHAR2
988 );
989 end ahl_prd_workorder_pvt_w;
[Home] [Help]