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