1 package csp_parts_requirement_w as
2 /* $Header: cspwprqs.pls 120.0 2005/05/25 11:33:11 appldev noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_300
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_DATE_TABLE
19 , a16 JTF_DATE_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_VARCHAR2_TABLE_100
28 , a25 JTF_VARCHAR2_TABLE_200
29 , a26 JTF_VARCHAR2_TABLE_200
30 , a27 JTF_VARCHAR2_TABLE_200
31 , a28 JTF_VARCHAR2_TABLE_200
32 , a29 JTF_VARCHAR2_TABLE_200
33 , a30 JTF_VARCHAR2_TABLE_200
34 , a31 JTF_VARCHAR2_TABLE_200
35 , a32 JTF_VARCHAR2_TABLE_200
36 , a33 JTF_VARCHAR2_TABLE_200
37 , a34 JTF_VARCHAR2_TABLE_200
38 , a35 JTF_VARCHAR2_TABLE_200
39 , a36 JTF_VARCHAR2_TABLE_200
40 , a37 JTF_VARCHAR2_TABLE_200
41 , a38 JTF_VARCHAR2_TABLE_200
42 , a39 JTF_VARCHAR2_TABLE_200
43 );
44 procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45 , a1 out nocopy JTF_NUMBER_TABLE
46 , a2 out nocopy JTF_NUMBER_TABLE
47 , a3 out nocopy JTF_NUMBER_TABLE
48 , a4 out nocopy JTF_VARCHAR2_TABLE_300
49 , a5 out nocopy JTF_VARCHAR2_TABLE_100
50 , a6 out nocopy JTF_NUMBER_TABLE
51 , a7 out nocopy JTF_VARCHAR2_TABLE_100
52 , a8 out nocopy JTF_VARCHAR2_TABLE_100
53 , a9 out nocopy JTF_NUMBER_TABLE
54 , a10 out nocopy JTF_VARCHAR2_TABLE_100
55 , a11 out nocopy JTF_VARCHAR2_TABLE_100
56 , a12 out nocopy JTF_VARCHAR2_TABLE_100
57 , a13 out nocopy JTF_NUMBER_TABLE
58 , a14 out nocopy JTF_NUMBER_TABLE
59 , a15 out nocopy JTF_DATE_TABLE
60 , a16 out nocopy JTF_DATE_TABLE
61 , a17 out nocopy JTF_NUMBER_TABLE
62 , a18 out nocopy JTF_NUMBER_TABLE
63 , a19 out nocopy JTF_VARCHAR2_TABLE_100
64 , a20 out nocopy JTF_VARCHAR2_TABLE_100
65 , a21 out nocopy JTF_VARCHAR2_TABLE_100
66 , a22 out nocopy JTF_VARCHAR2_TABLE_100
67 , a23 out nocopy JTF_VARCHAR2_TABLE_100
68 , a24 out nocopy JTF_VARCHAR2_TABLE_100
69 , a25 out nocopy JTF_VARCHAR2_TABLE_200
70 , a26 out nocopy JTF_VARCHAR2_TABLE_200
71 , a27 out nocopy JTF_VARCHAR2_TABLE_200
72 , a28 out nocopy JTF_VARCHAR2_TABLE_200
73 , a29 out nocopy JTF_VARCHAR2_TABLE_200
74 , a30 out nocopy JTF_VARCHAR2_TABLE_200
75 , a31 out nocopy JTF_VARCHAR2_TABLE_200
76 , a32 out nocopy JTF_VARCHAR2_TABLE_200
77 , a33 out nocopy JTF_VARCHAR2_TABLE_200
78 , a34 out nocopy JTF_VARCHAR2_TABLE_200
79 , a35 out nocopy JTF_VARCHAR2_TABLE_200
80 , a36 out nocopy JTF_VARCHAR2_TABLE_200
81 , a37 out nocopy JTF_VARCHAR2_TABLE_200
82 , a38 out nocopy JTF_VARCHAR2_TABLE_200
83 , a39 out nocopy JTF_VARCHAR2_TABLE_200
84 );
85
86 procedure rosetta_table_copy_in_p4(t out nocopy csp_parts_requirement.line_detail_tbl_type, a0 JTF_NUMBER_TABLE
87 , a1 JTF_NUMBER_TABLE
88 , a2 JTF_VARCHAR2_TABLE_100
89 , a3 JTF_NUMBER_TABLE
90 );
91 procedure rosetta_table_copy_out_p4(t csp_parts_requirement.line_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92 , a1 out nocopy JTF_NUMBER_TABLE
93 , a2 out nocopy JTF_VARCHAR2_TABLE_100
94 , a3 out nocopy JTF_NUMBER_TABLE
95 );
96
97 procedure rosetta_table_copy_in_p6(t out nocopy csp_parts_requirement.rqmt_line_tbl_type, a0 JTF_NUMBER_TABLE
98 );
99 procedure rosetta_table_copy_out_p6(t csp_parts_requirement.rqmt_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100 );
101
102 procedure rosetta_table_copy_in_p8(t out nocopy csp_parts_requirement.order_tbl_type, a0 JTF_VARCHAR2_TABLE_100
103 , a1 JTF_NUMBER_TABLE
104 );
105 procedure rosetta_table_copy_out_p8(t csp_parts_requirement.order_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
106 , a1 out nocopy JTF_NUMBER_TABLE
107 );
108
109 procedure process_requirement(p_api_version NUMBER
110 , p_init_msg_list VARCHAR2
111 , p_commit VARCHAR2
112 , p3_a0 in out nocopy NUMBER
113 , p3_a1 in out nocopy VARCHAR2
114 , p3_a2 in out nocopy VARCHAR2
115 , p3_a3 in out nocopy NUMBER
116 , p3_a4 in out nocopy NUMBER
117 , p3_a5 in out nocopy NUMBER
118 , p3_a6 in out nocopy VARCHAR2
119 , p3_a7 in out nocopy NUMBER
120 , p3_a8 in out nocopy NUMBER
121 , p3_a9 in out nocopy DATE
122 , p3_a10 in out nocopy NUMBER
123 , p3_a11 in out nocopy VARCHAR2
124 , p3_a12 in out nocopy VARCHAR2
125 , p3_a13 in out nocopy NUMBER
126 , p3_a14 in out nocopy VARCHAR2
127 , p3_a15 in out nocopy VARCHAR2
128 , p3_a16 in out nocopy VARCHAR2
129 , p3_a17 in out nocopy NUMBER
130 , p3_a18 in out nocopy NUMBER
131 , p3_a19 in out nocopy VARCHAR2
132 , p3_a20 in out nocopy VARCHAR2
133 , p3_a21 in out nocopy VARCHAR2
134 , p3_a22 in out nocopy VARCHAR2
135 , p3_a23 in out nocopy VARCHAR2
136 , p3_a24 in out nocopy VARCHAR2
137 , p3_a25 in out nocopy VARCHAR2
138 , p3_a26 in out nocopy VARCHAR2
139 , p3_a27 in out nocopy VARCHAR2
140 , p3_a28 in out nocopy VARCHAR2
141 , p3_a29 in out nocopy VARCHAR2
142 , p3_a30 in out nocopy VARCHAR2
143 , p3_a31 in out nocopy VARCHAR2
144 , p3_a32 in out nocopy VARCHAR2
145 , p3_a33 in out nocopy VARCHAR2
146 , p3_a34 in out nocopy VARCHAR2
147 , p3_a35 in out nocopy VARCHAR2
148 , p4_a0 in out nocopy JTF_NUMBER_TABLE
149 , p4_a1 in out nocopy JTF_NUMBER_TABLE
150 , p4_a2 in out nocopy JTF_NUMBER_TABLE
151 , p4_a3 in out nocopy JTF_NUMBER_TABLE
152 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
153 , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
154 , p4_a6 in out nocopy JTF_NUMBER_TABLE
155 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
156 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
157 , p4_a9 in out nocopy JTF_NUMBER_TABLE
158 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
159 , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
160 , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
161 , p4_a13 in out nocopy JTF_NUMBER_TABLE
162 , p4_a14 in out nocopy JTF_NUMBER_TABLE
163 , p4_a15 in out nocopy JTF_DATE_TABLE
164 , p4_a16 in out nocopy JTF_DATE_TABLE
165 , p4_a17 in out nocopy JTF_NUMBER_TABLE
166 , p4_a18 in out nocopy JTF_NUMBER_TABLE
167 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
168 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
169 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
170 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100
171 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100
172 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_100
173 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
174 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_200
175 , p4_a27 in out nocopy JTF_VARCHAR2_TABLE_200
176 , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_200
177 , p4_a29 in out nocopy JTF_VARCHAR2_TABLE_200
178 , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_200
179 , p4_a31 in out nocopy JTF_VARCHAR2_TABLE_200
180 , p4_a32 in out nocopy JTF_VARCHAR2_TABLE_200
181 , p4_a33 in out nocopy JTF_VARCHAR2_TABLE_200
182 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_200
183 , p4_a35 in out nocopy JTF_VARCHAR2_TABLE_200
184 , p4_a36 in out nocopy JTF_VARCHAR2_TABLE_200
185 , p4_a37 in out nocopy JTF_VARCHAR2_TABLE_200
186 , p4_a38 in out nocopy JTF_VARCHAR2_TABLE_200
187 , p4_a39 in out nocopy JTF_VARCHAR2_TABLE_200
188 , p_create_order_flag VARCHAR2
189 , x_return_status out nocopy VARCHAR2
190 , x_msg_count out nocopy NUMBER
191 , x_msg_data out nocopy VARCHAR2
192 );
193 procedure csptrreq_fm_order(p_api_version NUMBER
194 , p_init_msg_list VARCHAR2
195 , p_commit VARCHAR2
196 , p3_a0 in out nocopy NUMBER
197 , p3_a1 in out nocopy VARCHAR2
198 , p3_a2 in out nocopy VARCHAR2
199 , p3_a3 in out nocopy NUMBER
200 , p3_a4 in out nocopy NUMBER
201 , p3_a5 in out nocopy NUMBER
202 , p3_a6 in out nocopy VARCHAR2
203 , p3_a7 in out nocopy NUMBER
204 , p3_a8 in out nocopy NUMBER
205 , p3_a9 in out nocopy DATE
206 , p3_a10 in out nocopy NUMBER
207 , p3_a11 in out nocopy VARCHAR2
208 , p3_a12 in out nocopy VARCHAR2
209 , p3_a13 in out nocopy NUMBER
210 , p3_a14 in out nocopy VARCHAR2
211 , p3_a15 in out nocopy VARCHAR2
212 , p3_a16 in out nocopy VARCHAR2
213 , p3_a17 in out nocopy NUMBER
214 , p3_a18 in out nocopy NUMBER
215 , p3_a19 in out nocopy VARCHAR2
216 , p3_a20 in out nocopy VARCHAR2
217 , p3_a21 in out nocopy VARCHAR2
218 , p3_a22 in out nocopy VARCHAR2
219 , p3_a23 in out nocopy VARCHAR2
220 , p3_a24 in out nocopy VARCHAR2
221 , p3_a25 in out nocopy VARCHAR2
222 , p3_a26 in out nocopy VARCHAR2
223 , p3_a27 in out nocopy VARCHAR2
224 , p3_a28 in out nocopy VARCHAR2
225 , p3_a29 in out nocopy VARCHAR2
226 , p3_a30 in out nocopy VARCHAR2
227 , p3_a31 in out nocopy VARCHAR2
228 , p3_a32 in out nocopy VARCHAR2
229 , p3_a33 in out nocopy VARCHAR2
230 , p3_a34 in out nocopy VARCHAR2
231 , p3_a35 in out nocopy VARCHAR2
232 , p4_a0 in out nocopy JTF_NUMBER_TABLE
233 , p4_a1 in out nocopy JTF_NUMBER_TABLE
234 , p4_a2 in out nocopy JTF_NUMBER_TABLE
235 , p4_a3 in out nocopy JTF_NUMBER_TABLE
236 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
237 , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
238 , p4_a6 in out nocopy JTF_NUMBER_TABLE
239 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
240 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
241 , p4_a9 in out nocopy JTF_NUMBER_TABLE
242 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
243 , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
244 , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
245 , p4_a13 in out nocopy JTF_NUMBER_TABLE
246 , p4_a14 in out nocopy JTF_NUMBER_TABLE
247 , p4_a15 in out nocopy JTF_DATE_TABLE
248 , p4_a16 in out nocopy JTF_DATE_TABLE
249 , p4_a17 in out nocopy JTF_NUMBER_TABLE
250 , p4_a18 in out nocopy JTF_NUMBER_TABLE
251 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
252 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
253 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
254 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100
255 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100
256 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_100
257 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
258 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_200
259 , p4_a27 in out nocopy JTF_VARCHAR2_TABLE_200
260 , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_200
261 , p4_a29 in out nocopy JTF_VARCHAR2_TABLE_200
262 , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_200
263 , p4_a31 in out nocopy JTF_VARCHAR2_TABLE_200
264 , p4_a32 in out nocopy JTF_VARCHAR2_TABLE_200
265 , p4_a33 in out nocopy JTF_VARCHAR2_TABLE_200
266 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_200
267 , p4_a35 in out nocopy JTF_VARCHAR2_TABLE_200
268 , p4_a36 in out nocopy JTF_VARCHAR2_TABLE_200
269 , p4_a37 in out nocopy JTF_VARCHAR2_TABLE_200
270 , p4_a38 in out nocopy JTF_VARCHAR2_TABLE_200
271 , p4_a39 in out nocopy JTF_VARCHAR2_TABLE_200
272 , x_return_status out nocopy VARCHAR2
273 , x_msg_count out nocopy NUMBER
274 , x_msg_data out nocopy VARCHAR2
275 );
276 procedure csptrreq_order_res(p_api_version NUMBER
277 , p_init_msg_list VARCHAR2
278 , p_commit VARCHAR2
279 , p3_a0 in out nocopy NUMBER
280 , p3_a1 in out nocopy VARCHAR2
281 , p3_a2 in out nocopy VARCHAR2
282 , p3_a3 in out nocopy NUMBER
283 , p3_a4 in out nocopy NUMBER
284 , p3_a5 in out nocopy NUMBER
285 , p3_a6 in out nocopy VARCHAR2
286 , p3_a7 in out nocopy NUMBER
287 , p3_a8 in out nocopy NUMBER
288 , p3_a9 in out nocopy DATE
289 , p3_a10 in out nocopy NUMBER
290 , p3_a11 in out nocopy VARCHAR2
291 , p3_a12 in out nocopy VARCHAR2
292 , p3_a13 in out nocopy NUMBER
293 , p3_a14 in out nocopy VARCHAR2
294 , p3_a15 in out nocopy VARCHAR2
295 , p3_a16 in out nocopy VARCHAR2
296 , p3_a17 in out nocopy NUMBER
297 , p3_a18 in out nocopy NUMBER
298 , p3_a19 in out nocopy VARCHAR2
299 , p3_a20 in out nocopy VARCHAR2
300 , p3_a21 in out nocopy VARCHAR2
301 , p3_a22 in out nocopy VARCHAR2
302 , p3_a23 in out nocopy VARCHAR2
303 , p3_a24 in out nocopy VARCHAR2
304 , p3_a25 in out nocopy VARCHAR2
305 , p3_a26 in out nocopy VARCHAR2
306 , p3_a27 in out nocopy VARCHAR2
307 , p3_a28 in out nocopy VARCHAR2
308 , p3_a29 in out nocopy VARCHAR2
309 , p3_a30 in out nocopy VARCHAR2
310 , p3_a31 in out nocopy VARCHAR2
311 , p3_a32 in out nocopy VARCHAR2
312 , p3_a33 in out nocopy VARCHAR2
313 , p3_a34 in out nocopy VARCHAR2
314 , p3_a35 in out nocopy VARCHAR2
315 , p4_a0 in out nocopy JTF_NUMBER_TABLE
316 , p4_a1 in out nocopy JTF_NUMBER_TABLE
317 , p4_a2 in out nocopy JTF_NUMBER_TABLE
318 , p4_a3 in out nocopy JTF_NUMBER_TABLE
319 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
320 , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
321 , p4_a6 in out nocopy JTF_NUMBER_TABLE
322 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
323 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
324 , p4_a9 in out nocopy JTF_NUMBER_TABLE
325 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
326 , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
327 , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
328 , p4_a13 in out nocopy JTF_NUMBER_TABLE
329 , p4_a14 in out nocopy JTF_NUMBER_TABLE
330 , p4_a15 in out nocopy JTF_DATE_TABLE
331 , p4_a16 in out nocopy JTF_DATE_TABLE
332 , p4_a17 in out nocopy JTF_NUMBER_TABLE
333 , p4_a18 in out nocopy JTF_NUMBER_TABLE
334 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
335 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
336 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
337 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100
338 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100
339 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_100
340 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
341 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_200
342 , p4_a27 in out nocopy JTF_VARCHAR2_TABLE_200
343 , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_200
344 , p4_a29 in out nocopy JTF_VARCHAR2_TABLE_200
345 , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_200
346 , p4_a31 in out nocopy JTF_VARCHAR2_TABLE_200
347 , p4_a32 in out nocopy JTF_VARCHAR2_TABLE_200
348 , p4_a33 in out nocopy JTF_VARCHAR2_TABLE_200
349 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_200
350 , p4_a35 in out nocopy JTF_VARCHAR2_TABLE_200
351 , p4_a36 in out nocopy JTF_VARCHAR2_TABLE_200
352 , p4_a37 in out nocopy JTF_VARCHAR2_TABLE_200
353 , p4_a38 in out nocopy JTF_VARCHAR2_TABLE_200
354 , p4_a39 in out nocopy JTF_VARCHAR2_TABLE_200
355 , x_return_status out nocopy VARCHAR2
356 , x_msg_count out nocopy NUMBER
357 , x_msg_data out nocopy VARCHAR2
358 );
359 procedure save_rqmt_line(p_api_version NUMBER
360 , p_init_msg_list VARCHAR2
361 , p_commit VARCHAR2
362 , p3_a0 in out nocopy NUMBER
363 , p3_a1 in out nocopy VARCHAR2
364 , p3_a2 in out nocopy VARCHAR2
365 , p3_a3 in out nocopy NUMBER
366 , p3_a4 in out nocopy NUMBER
367 , p3_a5 in out nocopy NUMBER
368 , p3_a6 in out nocopy VARCHAR2
369 , p3_a7 in out nocopy NUMBER
370 , p3_a8 in out nocopy NUMBER
371 , p3_a9 in out nocopy DATE
372 , p3_a10 in out nocopy NUMBER
373 , p3_a11 in out nocopy VARCHAR2
374 , p3_a12 in out nocopy VARCHAR2
375 , p3_a13 in out nocopy NUMBER
376 , p3_a14 in out nocopy VARCHAR2
377 , p3_a15 in out nocopy VARCHAR2
378 , p3_a16 in out nocopy VARCHAR2
379 , p3_a17 in out nocopy NUMBER
380 , p3_a18 in out nocopy NUMBER
381 , p3_a19 in out nocopy VARCHAR2
382 , p3_a20 in out nocopy VARCHAR2
383 , p3_a21 in out nocopy VARCHAR2
384 , p3_a22 in out nocopy VARCHAR2
385 , p3_a23 in out nocopy VARCHAR2
386 , p3_a24 in out nocopy VARCHAR2
387 , p3_a25 in out nocopy VARCHAR2
388 , p3_a26 in out nocopy VARCHAR2
389 , p3_a27 in out nocopy VARCHAR2
390 , p3_a28 in out nocopy VARCHAR2
391 , p3_a29 in out nocopy VARCHAR2
392 , p3_a30 in out nocopy VARCHAR2
393 , p3_a31 in out nocopy VARCHAR2
394 , p3_a32 in out nocopy VARCHAR2
395 , p3_a33 in out nocopy VARCHAR2
396 , p3_a34 in out nocopy VARCHAR2
397 , p3_a35 in out nocopy VARCHAR2
398 , p4_a0 in out nocopy JTF_NUMBER_TABLE
399 , p4_a1 in out nocopy JTF_NUMBER_TABLE
400 , p4_a2 in out nocopy JTF_NUMBER_TABLE
401 , p4_a3 in out nocopy JTF_NUMBER_TABLE
402 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
403 , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
404 , p4_a6 in out nocopy JTF_NUMBER_TABLE
405 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
406 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
407 , p4_a9 in out nocopy JTF_NUMBER_TABLE
408 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
409 , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
410 , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
411 , p4_a13 in out nocopy JTF_NUMBER_TABLE
412 , p4_a14 in out nocopy JTF_NUMBER_TABLE
413 , p4_a15 in out nocopy JTF_DATE_TABLE
414 , p4_a16 in out nocopy JTF_DATE_TABLE
415 , p4_a17 in out nocopy JTF_NUMBER_TABLE
416 , p4_a18 in out nocopy JTF_NUMBER_TABLE
417 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
418 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
419 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
420 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100
421 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100
422 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_100
423 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
424 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_200
425 , p4_a27 in out nocopy JTF_VARCHAR2_TABLE_200
426 , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_200
427 , p4_a29 in out nocopy JTF_VARCHAR2_TABLE_200
428 , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_200
429 , p4_a31 in out nocopy JTF_VARCHAR2_TABLE_200
430 , p4_a32 in out nocopy JTF_VARCHAR2_TABLE_200
431 , p4_a33 in out nocopy JTF_VARCHAR2_TABLE_200
432 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_200
433 , p4_a35 in out nocopy JTF_VARCHAR2_TABLE_200
434 , p4_a36 in out nocopy JTF_VARCHAR2_TABLE_200
435 , p4_a37 in out nocopy JTF_VARCHAR2_TABLE_200
436 , p4_a38 in out nocopy JTF_VARCHAR2_TABLE_200
437 , p4_a39 in out nocopy JTF_VARCHAR2_TABLE_200
438 , x_return_status out nocopy VARCHAR2
439 , x_msg_count out nocopy NUMBER
440 , x_msg_data out nocopy VARCHAR2
441 );
442 procedure delete_rqmt_line(p_api_version NUMBER
443 , p_init_msg_list VARCHAR2
444 , p_commit VARCHAR2
445 , p3_a0 in out nocopy JTF_NUMBER_TABLE
446 , x_return_status out nocopy VARCHAR2
447 , x_msg_count out nocopy NUMBER
448 , x_msg_data out nocopy VARCHAR2
449 );
450 procedure check_availability(p_api_version NUMBER
451 , p_init_msg_list VARCHAR2
452 , p_commit VARCHAR2
453 , p_header_id NUMBER
454 , p4_a0 out nocopy JTF_NUMBER_TABLE
455 , p4_a1 out nocopy JTF_NUMBER_TABLE
456 , p4_a2 out nocopy JTF_NUMBER_TABLE
457 , p4_a3 out nocopy JTF_NUMBER_TABLE
458 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
459 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
460 , p4_a6 out nocopy JTF_NUMBER_TABLE
461 , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
462 , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
463 , p4_a9 out nocopy JTF_NUMBER_TABLE
464 , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
465 , p4_a11 out nocopy JTF_VARCHAR2_TABLE_100
466 , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
467 , p4_a13 out nocopy JTF_NUMBER_TABLE
468 , p4_a14 out nocopy JTF_NUMBER_TABLE
469 , p4_a15 out nocopy JTF_DATE_TABLE
470 , p4_a16 out nocopy JTF_DATE_TABLE
471 , p4_a17 out nocopy JTF_NUMBER_TABLE
472 , p4_a18 out nocopy JTF_NUMBER_TABLE
473 , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
474 , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
475 , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
476 , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
477 , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
478 , p4_a24 out nocopy JTF_VARCHAR2_TABLE_100
479 , p4_a25 out nocopy JTF_VARCHAR2_TABLE_200
480 , p4_a26 out nocopy JTF_VARCHAR2_TABLE_200
481 , p4_a27 out nocopy JTF_VARCHAR2_TABLE_200
482 , p4_a28 out nocopy JTF_VARCHAR2_TABLE_200
483 , p4_a29 out nocopy JTF_VARCHAR2_TABLE_200
484 , p4_a30 out nocopy JTF_VARCHAR2_TABLE_200
485 , p4_a31 out nocopy JTF_VARCHAR2_TABLE_200
486 , p4_a32 out nocopy JTF_VARCHAR2_TABLE_200
487 , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
488 , p4_a34 out nocopy JTF_VARCHAR2_TABLE_200
489 , p4_a35 out nocopy JTF_VARCHAR2_TABLE_200
490 , p4_a36 out nocopy JTF_VARCHAR2_TABLE_200
491 , p4_a37 out nocopy JTF_VARCHAR2_TABLE_200
492 , p4_a38 out nocopy JTF_VARCHAR2_TABLE_200
493 , p4_a39 out nocopy JTF_VARCHAR2_TABLE_200
494 , x_avail_flag out nocopy VARCHAR2
495 , x_return_status out nocopy VARCHAR2
496 , x_msg_count out nocopy NUMBER
497 , x_msg_data out nocopy VARCHAR2
498 );
499 procedure create_order(p_api_version NUMBER
500 , p_init_msg_list VARCHAR2
501 , p_commit VARCHAR2
502 , p_header_id NUMBER
503 , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
504 , p4_a1 out nocopy JTF_NUMBER_TABLE
505 , x_return_status out nocopy VARCHAR2
506 , x_msg_count out nocopy NUMBER
507 , x_msg_data out nocopy VARCHAR2
508 );
509 end csp_parts_requirement_w;
[Home] [Help]