DBA Data[Home] [Help]

PACKAGE: APPS.CSD_HV_WIP_JOB_PVT_W

Source


1 package csd_hv_wip_job_pvt_w as
2   /* $Header: csdwhvjs.pls 120.9 2008/03/25 01:16:57 swai ship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_NUMBER_TABLE
10     );
11   procedure rosetta_table_copy_out_p3(t csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
12     , a1 out nocopy JTF_NUMBER_TABLE
13     , a2 out nocopy JTF_NUMBER_TABLE
14     , a3 out nocopy JTF_NUMBER_TABLE
15     , a4 out nocopy JTF_NUMBER_TABLE
16     , a5 out nocopy JTF_VARCHAR2_TABLE_100
17     , a6 out nocopy JTF_NUMBER_TABLE
18     );
19 
20   procedure rosetta_table_copy_in_p5(t out nocopy csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
21     , a1 JTF_NUMBER_TABLE
22     , a2 JTF_NUMBER_TABLE
23     , a3 JTF_NUMBER_TABLE
24     , a4 JTF_NUMBER_TABLE
25     , a5 JTF_NUMBER_TABLE
26     , a6 JTF_NUMBER_TABLE
27     , a7 JTF_NUMBER_TABLE
28     , a8 JTF_NUMBER_TABLE
29     , a9 JTF_NUMBER_TABLE
30     , a10 JTF_VARCHAR2_TABLE_100
31     , a11 JTF_VARCHAR2_TABLE_100
32     , a12 JTF_VARCHAR2_TABLE_100
33     , a13 JTF_VARCHAR2_TABLE_100
34     , a14 JTF_VARCHAR2_TABLE_100
35     , a15 JTF_NUMBER_TABLE
36     , a16 JTF_NUMBER_TABLE
37     , a17 JTF_NUMBER_TABLE
38     , a18 JTF_VARCHAR2_TABLE_100
39     , a19 JTF_NUMBER_TABLE
40     , a20 JTF_NUMBER_TABLE
41     , a21 JTF_NUMBER_TABLE
42     , a22 JTF_VARCHAR2_TABLE_100
43     , a23 JTF_NUMBER_TABLE
44     );
45   procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46     , a1 out nocopy JTF_NUMBER_TABLE
47     , a2 out nocopy JTF_NUMBER_TABLE
48     , a3 out nocopy JTF_NUMBER_TABLE
49     , a4 out nocopy JTF_NUMBER_TABLE
50     , a5 out nocopy JTF_NUMBER_TABLE
51     , a6 out nocopy JTF_NUMBER_TABLE
52     , a7 out nocopy JTF_NUMBER_TABLE
53     , a8 out nocopy JTF_NUMBER_TABLE
54     , a9 out nocopy JTF_NUMBER_TABLE
55     , a10 out nocopy JTF_VARCHAR2_TABLE_100
56     , a11 out nocopy JTF_VARCHAR2_TABLE_100
57     , a12 out nocopy JTF_VARCHAR2_TABLE_100
58     , a13 out nocopy JTF_VARCHAR2_TABLE_100
59     , a14 out nocopy JTF_VARCHAR2_TABLE_100
60     , a15 out nocopy JTF_NUMBER_TABLE
61     , a16 out nocopy JTF_NUMBER_TABLE
62     , a17 out nocopy JTF_NUMBER_TABLE
63     , a18 out nocopy JTF_VARCHAR2_TABLE_100
64     , a19 out nocopy JTF_NUMBER_TABLE
65     , a20 out nocopy JTF_NUMBER_TABLE
66     , a21 out nocopy JTF_NUMBER_TABLE
67     , a22 out nocopy JTF_VARCHAR2_TABLE_100
68     , a23 out nocopy JTF_NUMBER_TABLE
69     );
70 
71   procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
72     , a1 JTF_NUMBER_TABLE
73     , a2 JTF_NUMBER_TABLE
74     , a3 JTF_NUMBER_TABLE
75     , a4 JTF_NUMBER_TABLE
76     , a5 JTF_NUMBER_TABLE
77     , a6 JTF_NUMBER_TABLE
78     , a7 JTF_NUMBER_TABLE
79     , a8 JTF_NUMBER_TABLE
80     , a9 JTF_NUMBER_TABLE
81     , a10 JTF_NUMBER_TABLE
82     , a11 JTF_VARCHAR2_TABLE_100
83     , a12 JTF_NUMBER_TABLE
84     , a13 JTF_NUMBER_TABLE
85     , a14 JTF_VARCHAR2_TABLE_100
86     , a15 JTF_VARCHAR2_TABLE_100
87     , a16 JTF_VARCHAR2_TABLE_100
88     , a17 JTF_NUMBER_TABLE
89     , a18 JTF_VARCHAR2_TABLE_100
90     , a19 JTF_NUMBER_TABLE
91     , a20 JTF_VARCHAR2_TABLE_100
92     );
93   procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94     , a1 out nocopy JTF_NUMBER_TABLE
95     , a2 out nocopy JTF_NUMBER_TABLE
96     , a3 out nocopy JTF_NUMBER_TABLE
97     , a4 out nocopy JTF_NUMBER_TABLE
98     , a5 out nocopy JTF_NUMBER_TABLE
99     , a6 out nocopy JTF_NUMBER_TABLE
100     , a7 out nocopy JTF_NUMBER_TABLE
101     , a8 out nocopy JTF_NUMBER_TABLE
102     , a9 out nocopy JTF_NUMBER_TABLE
103     , a10 out nocopy JTF_NUMBER_TABLE
104     , a11 out nocopy JTF_VARCHAR2_TABLE_100
105     , a12 out nocopy JTF_NUMBER_TABLE
106     , a13 out nocopy JTF_NUMBER_TABLE
107     , a14 out nocopy JTF_VARCHAR2_TABLE_100
108     , a15 out nocopy JTF_VARCHAR2_TABLE_100
109     , a16 out nocopy JTF_VARCHAR2_TABLE_100
110     , a17 out nocopy JTF_NUMBER_TABLE
111     , a18 out nocopy JTF_VARCHAR2_TABLE_100
112     , a19 out nocopy JTF_NUMBER_TABLE
113     , a20 out nocopy JTF_VARCHAR2_TABLE_100
114     );
115 
116   procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
117     , a1 JTF_NUMBER_TABLE
118     , a2 JTF_NUMBER_TABLE
119     , a3 JTF_NUMBER_TABLE
120     , a4 JTF_VARCHAR2_TABLE_300
121     , a5 JTF_DATE_TABLE
122     , a6 JTF_DATE_TABLE
123     , a7 JTF_DATE_TABLE
124     , a8 JTF_DATE_TABLE
125     , a9 JTF_NUMBER_TABLE
126     , a10 JTF_NUMBER_TABLE
127     , a11 JTF_NUMBER_TABLE
128     , a12 JTF_NUMBER_TABLE
129     , a13 JTF_NUMBER_TABLE
130     , a14 JTF_VARCHAR2_TABLE_100
131     , a15 JTF_VARCHAR2_TABLE_100
132     , a16 JTF_NUMBER_TABLE
133     , a17 JTF_VARCHAR2_TABLE_100
134     );
135   procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
136     , a1 out nocopy JTF_NUMBER_TABLE
137     , a2 out nocopy JTF_NUMBER_TABLE
138     , a3 out nocopy JTF_NUMBER_TABLE
139     , a4 out nocopy JTF_VARCHAR2_TABLE_300
140     , a5 out nocopy JTF_DATE_TABLE
141     , a6 out nocopy JTF_DATE_TABLE
142     , a7 out nocopy JTF_DATE_TABLE
143     , a8 out nocopy JTF_DATE_TABLE
144     , a9 out nocopy JTF_NUMBER_TABLE
145     , a10 out nocopy JTF_NUMBER_TABLE
146     , a11 out nocopy JTF_NUMBER_TABLE
147     , a12 out nocopy JTF_NUMBER_TABLE
148     , a13 out nocopy JTF_NUMBER_TABLE
149     , a14 out nocopy JTF_VARCHAR2_TABLE_100
150     , a15 out nocopy JTF_VARCHAR2_TABLE_100
151     , a16 out nocopy JTF_NUMBER_TABLE
152     , a17 out nocopy JTF_VARCHAR2_TABLE_100
153     );
154 
155   procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
156     , a1 JTF_NUMBER_TABLE
157     , a2 JTF_NUMBER_TABLE
158     , a3 JTF_NUMBER_TABLE
159     );
160   procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
161     , a1 out nocopy JTF_NUMBER_TABLE
162     , a2 out nocopy JTF_NUMBER_TABLE
163     , a3 out nocopy JTF_NUMBER_TABLE
164     );
165 
166   procedure process_oper_comp_txn(p_api_version_number  NUMBER
167     , p_init_msg_list  VARCHAR2
168     , p_commit  VARCHAR2
169     , p_validation_level  NUMBER
170     , x_return_status out nocopy  VARCHAR2
171     , x_msg_count out nocopy  NUMBER
172     , x_msg_data out nocopy  VARCHAR2
173     , p7_a0 JTF_VARCHAR2_TABLE_300
174     , p7_a1 JTF_NUMBER_TABLE
175     , p7_a2 JTF_NUMBER_TABLE
176     , p7_a3 JTF_NUMBER_TABLE
177     , p7_a4 JTF_NUMBER_TABLE
178     , p7_a5 JTF_VARCHAR2_TABLE_100
179     , p7_a6 JTF_NUMBER_TABLE
180   );
181   procedure process_job_comp_txn(p_api_version_number  NUMBER
182     , p_init_msg_list  VARCHAR2
183     , p_commit  VARCHAR2
184     , p_validation_level  NUMBER
185     , x_return_status out nocopy  VARCHAR2
186     , x_msg_count out nocopy  NUMBER
187     , x_msg_data out nocopy  VARCHAR2
188     , p7_a0  NUMBER
189     , p7_a1  NUMBER
190     , p7_a2  NUMBER
191     , p7_a3  NUMBER
192     , p7_a4  VARCHAR2
193     , p7_a5  NUMBER
194     , p7_a6  VARCHAR2
195     , p7_a7  NUMBER
196     , p7_a8  NUMBER
197     , p7_a9  NUMBER
198     , x_transaction_header_id out nocopy  NUMBER
199   );
200   procedure insert_job_comp_txn(p_api_version_number  NUMBER
201     , p_init_msg_list  VARCHAR2
202     , p_commit  VARCHAR2
203     , p_validation_level  NUMBER
204     , x_return_status out nocopy  VARCHAR2
205     , x_msg_count out nocopy  NUMBER
206     , x_msg_data out nocopy  VARCHAR2
207     , p7_a0  NUMBER
208     , p7_a1  NUMBER
209     , p7_a2  NUMBER
210     , p7_a3  NUMBER
211     , p7_a4  VARCHAR2
212     , p7_a5  NUMBER
213     , p7_a6  VARCHAR2
214     , p7_a7  NUMBER
215     , p7_a8  NUMBER
216     , p7_a9  NUMBER
217     , x_need_details_flag out nocopy  VARCHAR2
218     , x_transaction_header_id out nocopy  NUMBER
219   );
220   procedure process_issue_mtl_txn(p_api_version_number  NUMBER
221     , p_init_msg_list  VARCHAR2
222     , p_commit  VARCHAR2
223     , p_validation_level  NUMBER
224     , x_return_status out nocopy  VARCHAR2
225     , x_msg_count out nocopy  NUMBER
226     , x_msg_data out nocopy  VARCHAR2
227     , p7_a0 JTF_NUMBER_TABLE
228     , p7_a1 JTF_NUMBER_TABLE
229     , p7_a2 JTF_NUMBER_TABLE
230     , p7_a3 JTF_NUMBER_TABLE
231     , p7_a4 JTF_NUMBER_TABLE
232     , p7_a5 JTF_NUMBER_TABLE
233     , p7_a6 JTF_NUMBER_TABLE
234     , p7_a7 JTF_NUMBER_TABLE
235     , p7_a8 JTF_NUMBER_TABLE
236     , p7_a9 JTF_NUMBER_TABLE
237     , p7_a10 JTF_VARCHAR2_TABLE_100
238     , p7_a11 JTF_VARCHAR2_TABLE_100
239     , p7_a12 JTF_VARCHAR2_TABLE_100
240     , p7_a13 JTF_VARCHAR2_TABLE_100
241     , p7_a14 JTF_VARCHAR2_TABLE_100
242     , p7_a15 JTF_NUMBER_TABLE
243     , p7_a16 JTF_NUMBER_TABLE
244     , p7_a17 JTF_NUMBER_TABLE
245     , p7_a18 JTF_VARCHAR2_TABLE_100
246     , p7_a19 JTF_NUMBER_TABLE
247     , p7_a20 JTF_NUMBER_TABLE
248     , p7_a21 JTF_NUMBER_TABLE
249     , p7_a22 JTF_VARCHAR2_TABLE_100
250     , p7_a23 JTF_NUMBER_TABLE
251     , x_transaction_header_id out nocopy  NUMBER
252   );
253   procedure process_issue_mtl_txns_lot_srl(p_api_version_number  NUMBER
254     , p_init_msg_list  VARCHAR2
255     , p_commit  VARCHAR2
256     , p_validation_level  NUMBER
257     , x_return_status out nocopy  VARCHAR2
258     , x_msg_count out nocopy  NUMBER
259     , x_msg_data out nocopy  VARCHAR2
260     , p7_a0 JTF_NUMBER_TABLE
261     , p7_a1 JTF_NUMBER_TABLE
262     , p7_a2 JTF_NUMBER_TABLE
263     , p7_a3 JTF_NUMBER_TABLE
264     , p7_a4 JTF_NUMBER_TABLE
265     , p7_a5 JTF_NUMBER_TABLE
266     , p7_a6 JTF_NUMBER_TABLE
267     , p7_a7 JTF_NUMBER_TABLE
268     , p7_a8 JTF_NUMBER_TABLE
269     , p7_a9 JTF_NUMBER_TABLE
270     , p7_a10 JTF_VARCHAR2_TABLE_100
271     , p7_a11 JTF_VARCHAR2_TABLE_100
272     , p7_a12 JTF_VARCHAR2_TABLE_100
273     , p7_a13 JTF_VARCHAR2_TABLE_100
274     , p7_a14 JTF_VARCHAR2_TABLE_100
275     , p7_a15 JTF_NUMBER_TABLE
276     , p7_a16 JTF_NUMBER_TABLE
277     , p7_a17 JTF_NUMBER_TABLE
278     , p7_a18 JTF_VARCHAR2_TABLE_100
279     , p7_a19 JTF_NUMBER_TABLE
280     , p7_a20 JTF_NUMBER_TABLE
281     , p7_a21 JTF_NUMBER_TABLE
282     , p7_a22 JTF_VARCHAR2_TABLE_100
283     , p7_a23 JTF_NUMBER_TABLE
284     , p_transaction_header_id  NUMBER
285   );
286   procedure update_mtl_txns_lot_srl(p_api_version_number  NUMBER
287     , p_init_msg_list  VARCHAR2
288     , p_commit  VARCHAR2
289     , p_validation_level  NUMBER
290     , x_return_status out nocopy  VARCHAR2
291     , x_msg_count out nocopy  NUMBER
292     , x_msg_data out nocopy  VARCHAR2
293     , p7_a0 JTF_NUMBER_TABLE
294     , p7_a1 JTF_NUMBER_TABLE
295     , p7_a2 JTF_NUMBER_TABLE
296     , p7_a3 JTF_NUMBER_TABLE
297     , p7_a4 JTF_NUMBER_TABLE
298     , p7_a5 JTF_NUMBER_TABLE
299     , p7_a6 JTF_NUMBER_TABLE
300     , p7_a7 JTF_NUMBER_TABLE
301     , p7_a8 JTF_NUMBER_TABLE
302     , p7_a9 JTF_NUMBER_TABLE
303     , p7_a10 JTF_VARCHAR2_TABLE_100
304     , p7_a11 JTF_VARCHAR2_TABLE_100
305     , p7_a12 JTF_VARCHAR2_TABLE_100
306     , p7_a13 JTF_VARCHAR2_TABLE_100
307     , p7_a14 JTF_VARCHAR2_TABLE_100
308     , p7_a15 JTF_NUMBER_TABLE
309     , p7_a16 JTF_NUMBER_TABLE
310     , p7_a17 JTF_NUMBER_TABLE
311     , p7_a18 JTF_VARCHAR2_TABLE_100
312     , p7_a19 JTF_NUMBER_TABLE
313     , p7_a20 JTF_NUMBER_TABLE
314     , p7_a21 JTF_NUMBER_TABLE
315     , p7_a22 JTF_VARCHAR2_TABLE_100
316     , p7_a23 JTF_NUMBER_TABLE
317     , p_transaction_header_id  NUMBER
318   );
319   procedure process_transact_res_txn(p_api_version_number  NUMBER
320     , p_init_msg_list  VARCHAR2
321     , p_commit  VARCHAR2
322     , p_validation_level  NUMBER
323     , x_return_status out nocopy  VARCHAR2
324     , x_msg_count out nocopy  NUMBER
325     , x_msg_data out nocopy  VARCHAR2
326     , p7_a0 JTF_NUMBER_TABLE
327     , p7_a1 JTF_NUMBER_TABLE
328     , p7_a2 JTF_NUMBER_TABLE
329     , p7_a3 JTF_NUMBER_TABLE
330     , p7_a4 JTF_NUMBER_TABLE
331     , p7_a5 JTF_NUMBER_TABLE
332     , p7_a6 JTF_NUMBER_TABLE
333     , p7_a7 JTF_NUMBER_TABLE
334     , p7_a8 JTF_NUMBER_TABLE
335     , p7_a9 JTF_NUMBER_TABLE
336     , p7_a10 JTF_NUMBER_TABLE
337     , p7_a11 JTF_VARCHAR2_TABLE_100
338     , p7_a12 JTF_NUMBER_TABLE
339     , p7_a13 JTF_NUMBER_TABLE
340     , p7_a14 JTF_VARCHAR2_TABLE_100
341     , p7_a15 JTF_VARCHAR2_TABLE_100
342     , p7_a16 JTF_VARCHAR2_TABLE_100
343     , p7_a17 JTF_NUMBER_TABLE
344     , p7_a18 JTF_VARCHAR2_TABLE_100
345     , p7_a19 JTF_NUMBER_TABLE
346     , p7_a20 JTF_VARCHAR2_TABLE_100
347   );
348   procedure process_save_mtl_txn_dtls(p_api_version_number  NUMBER
349     , p_init_msg_list  VARCHAR2
350     , p_commit  VARCHAR2
351     , p_validation_level  NUMBER
352     , x_return_status out nocopy  VARCHAR2
353     , x_msg_count out nocopy  NUMBER
354     , x_msg_data out nocopy  VARCHAR2
355     , p7_a0 JTF_NUMBER_TABLE
356     , p7_a1 JTF_NUMBER_TABLE
357     , p7_a2 JTF_NUMBER_TABLE
358     , p7_a3 JTF_NUMBER_TABLE
359     , p7_a4 JTF_NUMBER_TABLE
360     , p7_a5 JTF_NUMBER_TABLE
361     , p7_a6 JTF_NUMBER_TABLE
362     , p7_a7 JTF_NUMBER_TABLE
363     , p7_a8 JTF_NUMBER_TABLE
364     , p7_a9 JTF_NUMBER_TABLE
365     , p7_a10 JTF_VARCHAR2_TABLE_100
366     , p7_a11 JTF_VARCHAR2_TABLE_100
367     , p7_a12 JTF_VARCHAR2_TABLE_100
368     , p7_a13 JTF_VARCHAR2_TABLE_100
369     , p7_a14 JTF_VARCHAR2_TABLE_100
370     , p7_a15 JTF_NUMBER_TABLE
371     , p7_a16 JTF_NUMBER_TABLE
372     , p7_a17 JTF_NUMBER_TABLE
373     , p7_a18 JTF_VARCHAR2_TABLE_100
374     , p7_a19 JTF_NUMBER_TABLE
375     , p7_a20 JTF_NUMBER_TABLE
376     , p7_a21 JTF_NUMBER_TABLE
377     , p7_a22 JTF_VARCHAR2_TABLE_100
378     , p7_a23 JTF_NUMBER_TABLE
379     , x_op_created out nocopy  VARCHAR
380   );
381   procedure process_save_res_txn_dtls(p_api_version_number  NUMBER
382     , p_init_msg_list  VARCHAR2
383     , p_commit  VARCHAR2
384     , p_validation_level  NUMBER
385     , x_return_status out nocopy  VARCHAR2
386     , x_msg_count out nocopy  NUMBER
387     , x_msg_data out nocopy  VARCHAR2
388     , p7_a0 JTF_NUMBER_TABLE
389     , p7_a1 JTF_NUMBER_TABLE
390     , p7_a2 JTF_NUMBER_TABLE
391     , p7_a3 JTF_NUMBER_TABLE
392     , p7_a4 JTF_NUMBER_TABLE
393     , p7_a5 JTF_NUMBER_TABLE
394     , p7_a6 JTF_NUMBER_TABLE
395     , p7_a7 JTF_NUMBER_TABLE
396     , p7_a8 JTF_NUMBER_TABLE
397     , p7_a9 JTF_NUMBER_TABLE
398     , p7_a10 JTF_NUMBER_TABLE
399     , p7_a11 JTF_VARCHAR2_TABLE_100
400     , p7_a12 JTF_NUMBER_TABLE
401     , p7_a13 JTF_NUMBER_TABLE
402     , p7_a14 JTF_VARCHAR2_TABLE_100
406     , p7_a18 JTF_VARCHAR2_TABLE_100
403     , p7_a15 JTF_VARCHAR2_TABLE_100
404     , p7_a16 JTF_VARCHAR2_TABLE_100
405     , p7_a17 JTF_NUMBER_TABLE
407     , p7_a19 JTF_NUMBER_TABLE
408     , p7_a20 JTF_VARCHAR2_TABLE_100
409   );
410   procedure process_save_op_dtls(p_api_version_number  NUMBER
411     , p_init_msg_list  VARCHAR2
412     , p_commit  VARCHAR2
413     , p_validation_level  NUMBER
414     , x_return_status out nocopy  VARCHAR2
415     , x_msg_count out nocopy  NUMBER
416     , x_msg_data out nocopy  VARCHAR2
417     , p7_a0 JTF_NUMBER_TABLE
418     , p7_a1 JTF_NUMBER_TABLE
419     , p7_a2 JTF_NUMBER_TABLE
420     , p7_a3 JTF_NUMBER_TABLE
421     , p7_a4 JTF_VARCHAR2_TABLE_300
422     , p7_a5 JTF_DATE_TABLE
423     , p7_a6 JTF_DATE_TABLE
424     , p7_a7 JTF_DATE_TABLE
425     , p7_a8 JTF_DATE_TABLE
426     , p7_a9 JTF_NUMBER_TABLE
427     , p7_a10 JTF_NUMBER_TABLE
428     , p7_a11 JTF_NUMBER_TABLE
429     , p7_a12 JTF_NUMBER_TABLE
430     , p7_a13 JTF_NUMBER_TABLE
431     , p7_a14 JTF_VARCHAR2_TABLE_100
432     , p7_a15 JTF_VARCHAR2_TABLE_100
433     , p7_a16 JTF_NUMBER_TABLE
434     , p7_a17 JTF_VARCHAR2_TABLE_100
435   );
436   procedure generate_wip_jobs_from_scs(p_api_version_number  NUMBER
437     , p_init_msg_list  VARCHAR2
438     , p_commit  VARCHAR2
439     , p_validation_level  NUMBER
440     , x_return_status out nocopy  VARCHAR2
441     , x_msg_count out nocopy  NUMBER
442     , x_msg_data out nocopy  VARCHAR2
443     , p_repair_line_id  NUMBER
444     , p_repair_quantity  NUMBER
445     , p9_a0 JTF_NUMBER_TABLE
446     , p9_a1 JTF_NUMBER_TABLE
447     , p9_a2 JTF_NUMBER_TABLE
448     , p9_a3 JTF_NUMBER_TABLE
449   );
450 end csd_hv_wip_job_pvt_w;