[Home] [Help]
PACKAGE: APPS.CSP_SCH_INT_PVT_W
Source
1 package csp_sch_int_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cspvscis.pls 120.6.12020000.2 2012/07/17 08:04:34 htank ship $ */
3 procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 );
6 procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
7 , a1 out nocopy JTF_VARCHAR2_TABLE_100
8 );
9
10 procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
11 , a1 JTF_VARCHAR2_TABLE_100
12 , a2 JTF_DATE_TABLE
13 , a3 JTF_NUMBER_TABLE
14 , a4 JTF_NUMBER_TABLE
15 , a5 JTF_NUMBER_TABLE
16 , a6 JTF_VARCHAR2_TABLE_4000
17 , a7 JTF_VARCHAR2_TABLE_4000
18 , a8 JTF_VARCHAR2_TABLE_4000
19 );
20 procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
21 , a1 out nocopy JTF_VARCHAR2_TABLE_100
22 , a2 out nocopy JTF_DATE_TABLE
23 , a3 out nocopy JTF_NUMBER_TABLE
24 , a4 out nocopy JTF_NUMBER_TABLE
25 , a5 out nocopy JTF_NUMBER_TABLE
26 , a6 out nocopy JTF_VARCHAR2_TABLE_4000
27 , a7 out nocopy JTF_VARCHAR2_TABLE_4000
28 , a8 out nocopy JTF_VARCHAR2_TABLE_4000
29 );
30
31 procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
32 , a1 JTF_VARCHAR2_TABLE_100
33 , a2 JTF_NUMBER_TABLE
34 , a3 JTF_NUMBER_TABLE
35 , a4 JTF_VARCHAR2_TABLE_100
36 , a5 JTF_VARCHAR2_TABLE_100
37 , a6 JTF_NUMBER_TABLE
38 , a7 JTF_NUMBER_TABLE
39 , a8 JTF_NUMBER_TABLE
40 , a9 JTF_VARCHAR2_TABLE_100
41 );
42 procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43 , a1 out nocopy JTF_VARCHAR2_TABLE_100
44 , a2 out nocopy JTF_NUMBER_TABLE
45 , a3 out nocopy JTF_NUMBER_TABLE
46 , a4 out nocopy JTF_VARCHAR2_TABLE_100
47 , a5 out nocopy JTF_VARCHAR2_TABLE_100
48 , a6 out nocopy JTF_NUMBER_TABLE
49 , a7 out nocopy JTF_NUMBER_TABLE
50 , a8 out nocopy JTF_NUMBER_TABLE
51 , a9 out nocopy JTF_VARCHAR2_TABLE_100
52 );
53
54 procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
55 , a1 JTF_VARCHAR2_TABLE_100
56 , a2 JTF_NUMBER_TABLE
57 , a3 JTF_NUMBER_TABLE
58 , a4 JTF_NUMBER_TABLE
59 , a5 JTF_NUMBER_TABLE
60 , a6 JTF_VARCHAR2_TABLE_100
61 , a7 JTF_NUMBER_TABLE
62 , a8 JTF_VARCHAR2_TABLE_100
63 , a9 JTF_NUMBER_TABLE
64 , a10 JTF_NUMBER_TABLE
65 , a11 JTF_NUMBER_TABLE
66 , a12 JTF_VARCHAR2_TABLE_100
67 , a13 JTF_DATE_TABLE
68 , a14 JTF_VARCHAR2_TABLE_100
69 , a15 JTF_NUMBER_TABLE
70 , a16 JTF_VARCHAR2_TABLE_100
71 );
72 procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73 , a1 out nocopy JTF_VARCHAR2_TABLE_100
74 , a2 out nocopy JTF_NUMBER_TABLE
75 , a3 out nocopy JTF_NUMBER_TABLE
76 , a4 out nocopy JTF_NUMBER_TABLE
77 , a5 out nocopy JTF_NUMBER_TABLE
78 , a6 out nocopy JTF_VARCHAR2_TABLE_100
79 , a7 out nocopy JTF_NUMBER_TABLE
80 , a8 out nocopy JTF_VARCHAR2_TABLE_100
81 , a9 out nocopy JTF_NUMBER_TABLE
82 , a10 out nocopy JTF_NUMBER_TABLE
83 , a11 out nocopy JTF_NUMBER_TABLE
84 , a12 out nocopy JTF_VARCHAR2_TABLE_100
85 , a13 out nocopy JTF_DATE_TABLE
86 , a14 out nocopy JTF_VARCHAR2_TABLE_100
87 , a15 out nocopy JTF_NUMBER_TABLE
88 , a16 out nocopy JTF_VARCHAR2_TABLE_100
89 );
90
91 procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
92 , a1 JTF_VARCHAR2_TABLE_100
93 , a2 JTF_VARCHAR2_TABLE_100
94 , a3 JTF_NUMBER_TABLE
95 , a4 JTF_VARCHAR2_TABLE_100
96 , a5 JTF_NUMBER_TABLE
97 );
98 procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99 , a1 out nocopy JTF_VARCHAR2_TABLE_100
100 , a2 out nocopy JTF_VARCHAR2_TABLE_100
101 , a3 out nocopy JTF_NUMBER_TABLE
102 , a4 out nocopy JTF_VARCHAR2_TABLE_100
103 , a5 out nocopy JTF_NUMBER_TABLE
104 );
105
106 procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
107 , a1 JTF_VARCHAR2_TABLE_100
108 , a2 JTF_NUMBER_TABLE
109 , a3 JTF_NUMBER_TABLE
110 , a4 JTF_VARCHAR2_TABLE_100
111 , a5 JTF_NUMBER_TABLE
112 , a6 JTF_NUMBER_TABLE
113 , a7 JTF_NUMBER_TABLE
114 , a8 JTF_VARCHAR2_TABLE_100
115 , a9 JTF_DATE_TABLE
116 , a10 JTF_DATE_TABLE
117 , a11 JTF_VARCHAR2_TABLE_100
118 , a12 JTF_NUMBER_TABLE
119 , a13 JTF_NUMBER_TABLE
120 , a14 JTF_VARCHAR2_TABLE_100
121 , a15 JTF_VARCHAR2_TABLE_100
122 );
123 procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
124 , a1 out nocopy JTF_VARCHAR2_TABLE_100
125 , a2 out nocopy JTF_NUMBER_TABLE
126 , a3 out nocopy JTF_NUMBER_TABLE
127 , a4 out nocopy JTF_VARCHAR2_TABLE_100
128 , a5 out nocopy JTF_NUMBER_TABLE
129 , a6 out nocopy JTF_NUMBER_TABLE
130 , a7 out nocopy JTF_NUMBER_TABLE
131 , a8 out nocopy JTF_VARCHAR2_TABLE_100
132 , a9 out nocopy JTF_DATE_TABLE
133 , a10 out nocopy JTF_DATE_TABLE
134 , a11 out nocopy JTF_VARCHAR2_TABLE_100
135 , a12 out nocopy JTF_NUMBER_TABLE
136 , a13 out nocopy JTF_NUMBER_TABLE
137 , a14 out nocopy JTF_VARCHAR2_TABLE_100
138 , a15 out nocopy JTF_VARCHAR2_TABLE_100
139 );
140
141 procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
142 , a1 JTF_VARCHAR2_TABLE_100
143 , a2 JTF_NUMBER_TABLE
144 , a3 JTF_NUMBER_TABLE
145 , a4 JTF_VARCHAR2_TABLE_100
146 , a5 JTF_NUMBER_TABLE
147 , a6 JTF_NUMBER_TABLE
148 , a7 JTF_NUMBER_TABLE
149 , a8 JTF_VARCHAR2_TABLE_100
150 , a9 JTF_DATE_TABLE
151 , a10 JTF_DATE_TABLE
152 , a11 JTF_VARCHAR2_TABLE_100
153 , a12 JTF_NUMBER_TABLE
154 , a13 JTF_NUMBER_TABLE
155 , a14 JTF_VARCHAR2_TABLE_100
156 , a15 JTF_VARCHAR2_TABLE_100
157 );
158 procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
159 , a1 out nocopy JTF_VARCHAR2_TABLE_100
160 , a2 out nocopy JTF_NUMBER_TABLE
161 , a3 out nocopy JTF_NUMBER_TABLE
162 , a4 out nocopy JTF_VARCHAR2_TABLE_100
163 , a5 out nocopy JTF_NUMBER_TABLE
164 , a6 out nocopy JTF_NUMBER_TABLE
165 , a7 out nocopy JTF_NUMBER_TABLE
166 , a8 out nocopy JTF_VARCHAR2_TABLE_100
167 , a9 out nocopy JTF_DATE_TABLE
168 , a10 out nocopy JTF_DATE_TABLE
169 , a11 out nocopy JTF_VARCHAR2_TABLE_100
170 , a12 out nocopy JTF_NUMBER_TABLE
171 , a13 out nocopy JTF_NUMBER_TABLE
172 , a14 out nocopy JTF_VARCHAR2_TABLE_100
173 , a15 out nocopy JTF_VARCHAR2_TABLE_100
174 );
175
176 procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
177 , a1 JTF_VARCHAR2_TABLE_100
178 , a2 JTF_VARCHAR2_TABLE_100
179 , a3 JTF_NUMBER_TABLE
180 , a4 JTF_VARCHAR2_TABLE_100
181 , a5 JTF_NUMBER_TABLE
182 );
183 procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
184 , a1 out nocopy JTF_VARCHAR2_TABLE_100
185 , a2 out nocopy JTF_VARCHAR2_TABLE_100
186 , a3 out nocopy JTF_NUMBER_TABLE
187 , a4 out nocopy JTF_VARCHAR2_TABLE_100
188 , a5 out nocopy JTF_NUMBER_TABLE
189 );
190
191 procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
192 , a1 JTF_VARCHAR2_TABLE_100
193 , a2 JTF_NUMBER_TABLE
194 , a3 JTF_VARCHAR2_TABLE_100
195 , a4 JTF_VARCHAR2_TABLE_100
196 , a5 JTF_VARCHAR2_TABLE_300
197 , a6 JTF_NUMBER_TABLE
198 , a7 JTF_VARCHAR2_TABLE_300
199 , a8 JTF_VARCHAR2_TABLE_100
200 , a9 JTF_VARCHAR2_TABLE_100
201 , a10 JTF_NUMBER_TABLE
202 , a11 JTF_NUMBER_TABLE
203 , a12 JTF_VARCHAR2_TABLE_100
204 , a13 JTF_NUMBER_TABLE
205 , a14 JTF_NUMBER_TABLE
206 , a15 JTF_VARCHAR2_TABLE_100
207 , a16 JTF_VARCHAR2_TABLE_100
208 , a17 JTF_DATE_TABLE
209 , a18 JTF_DATE_TABLE
210 , a19 JTF_VARCHAR2_TABLE_100
211 , a20 JTF_VARCHAR2_TABLE_100
212 );
213 procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
214 , a1 out nocopy JTF_VARCHAR2_TABLE_100
215 , a2 out nocopy JTF_NUMBER_TABLE
216 , a3 out nocopy JTF_VARCHAR2_TABLE_100
217 , a4 out nocopy JTF_VARCHAR2_TABLE_100
218 , a5 out nocopy JTF_VARCHAR2_TABLE_300
219 , a6 out nocopy JTF_NUMBER_TABLE
220 , a7 out nocopy JTF_VARCHAR2_TABLE_300
221 , a8 out nocopy JTF_VARCHAR2_TABLE_100
222 , a9 out nocopy JTF_VARCHAR2_TABLE_100
223 , a10 out nocopy JTF_NUMBER_TABLE
224 , a11 out nocopy JTF_NUMBER_TABLE
225 , a12 out nocopy JTF_VARCHAR2_TABLE_100
226 , a13 out nocopy JTF_NUMBER_TABLE
227 , a14 out nocopy JTF_NUMBER_TABLE
228 , a15 out nocopy JTF_VARCHAR2_TABLE_100
229 , a16 out nocopy JTF_VARCHAR2_TABLE_100
230 , a17 out nocopy JTF_DATE_TABLE
231 , a18 out nocopy JTF_DATE_TABLE
232 , a19 out nocopy JTF_VARCHAR2_TABLE_100
233 , a20 out nocopy JTF_VARCHAR2_TABLE_100
234 );
235
236 procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
237 , a1 JTF_NUMBER_TABLE
238 , a2 JTF_NUMBER_TABLE
239 , a3 JTF_VARCHAR2_TABLE_100
240 , a4 JTF_VARCHAR2_TABLE_100
241 , a5 JTF_VARCHAR2_TABLE_300
242 );
243 procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
244 , a1 out nocopy JTF_NUMBER_TABLE
245 , a2 out nocopy JTF_NUMBER_TABLE
246 , a3 out nocopy JTF_VARCHAR2_TABLE_100
247 , a4 out nocopy JTF_VARCHAR2_TABLE_100
248 , a5 out nocopy JTF_VARCHAR2_TABLE_300
249 );
250
251 procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
252 , a1 JTF_VARCHAR2_TABLE_100
253 , a2 JTF_VARCHAR2_TABLE_100
254 , a3 JTF_NUMBER_TABLE
255 , a4 JTF_NUMBER_TABLE
256 , a5 JTF_VARCHAR2_TABLE_100
257 , a6 JTF_NUMBER_TABLE
258 , a7 JTF_NUMBER_TABLE
259 );
260 procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
261 , a1 out nocopy JTF_VARCHAR2_TABLE_100
262 , a2 out nocopy JTF_VARCHAR2_TABLE_100
263 , a3 out nocopy JTF_NUMBER_TABLE
264 , a4 out nocopy JTF_NUMBER_TABLE
265 , a5 out nocopy JTF_VARCHAR2_TABLE_100
266 , a6 out nocopy JTF_NUMBER_TABLE
267 , a7 out nocopy JTF_NUMBER_TABLE
268 );
269
270 procedure get_availability_options(p_api_version_number NUMBER
271 , p_task_id NUMBER
272 , p2_a0 JTF_NUMBER_TABLE
273 , p2_a1 JTF_VARCHAR2_TABLE_100
274 , p3_a0 DATE
275 , p3_a1 DATE
276 , p_likelihood NUMBER
277 , p_subinv_only number
278 , p_mandatory number
279 , p_trunk number
280 , p_warehouse number
281 , p9_a0 out nocopy JTF_NUMBER_TABLE
282 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
283 , p9_a2 out nocopy JTF_DATE_TABLE
284 , p9_a3 out nocopy JTF_NUMBER_TABLE
285 , p9_a4 out nocopy JTF_NUMBER_TABLE
286 , p9_a5 out nocopy JTF_NUMBER_TABLE
287 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_4000
288 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_4000
289 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_4000
290 , x_return_status out nocopy VARCHAR2
291 , x_msg_data out nocopy VARCHAR2
292 , x_msg_count out nocopy NUMBER
293 );
294 procedure choose_option(p_api_version_number NUMBER
295 , p_task_id NUMBER
296 , p_task_assignment_id NUMBER
297 , p_likelihood NUMBER
298 , p_mandatory number
299 , p_trunk number
300 , p_warehouse number
301 , p7_a0 NUMBER
302 , p7_a1 VARCHAR2
303 , p7_a2 DATE
304 , p7_a3 NUMBER
305 , p7_a4 NUMBER
306 , p7_a5 NUMBER
307 , p7_a6 VARCHAR2
308 , p7_a7 VARCHAR2
309 , p7_a8 VARCHAR2
310 , x_return_status out nocopy VARCHAR2
311 , x_msg_data out nocopy VARCHAR2
312 , x_msg_count out nocopy NUMBER
313 );
314 procedure check_parts_availability(p0_a0 NUMBER
315 , p0_a1 VARCHAR2
316 , p_organization_id NUMBER
317 , p_subinv_code VARCHAR2
318 , p_need_by_date date
319 , p4_a0 JTF_NUMBER_TABLE
320 , p4_a1 JTF_VARCHAR2_TABLE_100
321 , p4_a2 JTF_VARCHAR2_TABLE_100
322 , p4_a3 JTF_NUMBER_TABLE
323 , p4_a4 JTF_VARCHAR2_TABLE_100
324 , p4_a5 JTF_NUMBER_TABLE
325 , p_timezone_id NUMBER
326 , p6_a0 out nocopy JTF_NUMBER_TABLE
327 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
328 , p6_a2 out nocopy JTF_NUMBER_TABLE
329 , p6_a3 out nocopy JTF_NUMBER_TABLE
330 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
331 , p6_a5 out nocopy JTF_NUMBER_TABLE
332 , p6_a6 out nocopy JTF_NUMBER_TABLE
333 , p6_a7 out nocopy JTF_NUMBER_TABLE
334 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
335 , p6_a9 out nocopy JTF_DATE_TABLE
336 , p6_a10 out nocopy JTF_DATE_TABLE
337 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
338 , p6_a12 out nocopy JTF_NUMBER_TABLE
339 , p6_a13 out nocopy JTF_NUMBER_TABLE
340 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
341 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
342 , x_return_status out nocopy VARCHAR2
343 , x_msg_data out nocopy VARCHAR2
344 , x_msg_count out nocopy NUMBER
345 , p_called_from VARCHAR2
346 , p_location_id NUMBER
347 );
348 function create_reservation(p0_a0 DATE
349 , p0_a1 NUMBER
350 , p0_a2 NUMBER
351 , p0_a3 VARCHAR2
352 , p0_a4 NUMBER
353 , p0_a5 VARCHAR2
354 , p0_a6 NUMBER
355 , p0_a7 VARCHAR2
356 , x_return_status out nocopy VARCHAR2
357 , x_msg_data out nocopy VARCHAR2
358 ) return number;
359 procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
360 , p0_a1 JTF_NUMBER_TABLE
361 , p0_a2 JTF_NUMBER_TABLE
362 , p0_a3 JTF_VARCHAR2_TABLE_100
363 , p0_a4 JTF_VARCHAR2_TABLE_100
364 , p0_a5 JTF_VARCHAR2_TABLE_300
365 , p1_a0 JTF_NUMBER_TABLE
366 , p1_a1 JTF_VARCHAR2_TABLE_100
367 , p1_a2 JTF_VARCHAR2_TABLE_100
368 , p1_a3 JTF_NUMBER_TABLE
369 , p1_a4 JTF_VARCHAR2_TABLE_100
370 , p1_a5 JTF_NUMBER_TABLE
371 , p_include_alternate VARCHAR2
372 , p3_a0 out nocopy JTF_NUMBER_TABLE
373 , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
374 , p3_a2 out nocopy JTF_NUMBER_TABLE
375 , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
376 , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
377 , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
378 , p3_a6 out nocopy JTF_NUMBER_TABLE
379 , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
380 , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
381 , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
382 , p3_a10 out nocopy JTF_NUMBER_TABLE
383 , p3_a11 out nocopy JTF_NUMBER_TABLE
384 , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
385 , p3_a13 out nocopy JTF_NUMBER_TABLE
386 , p3_a14 out nocopy JTF_NUMBER_TABLE
387 , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
388 , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
389 , p3_a17 out nocopy JTF_DATE_TABLE
390 , p3_a18 out nocopy JTF_DATE_TABLE
391 , p3_a19 out nocopy JTF_VARCHAR2_TABLE_100
392 , p3_a20 out nocopy JTF_VARCHAR2_TABLE_100
393 , x_return_status out nocopy VARCHAR2
394 , x_msg_data out nocopy VARCHAR2
395 , x_msg_count out nocopy NUMBER
396 );
397 procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
398 , p_resource_id NUMBER
399 , p2_a0 JTF_NUMBER_TABLE
400 , p2_a1 JTF_VARCHAR2_TABLE_100
401 , p2_a2 JTF_VARCHAR2_TABLE_100
402 , p2_a3 JTF_NUMBER_TABLE
403 , p2_a4 JTF_VARCHAR2_TABLE_100
404 , p2_a5 JTF_NUMBER_TABLE
405 , p_include_alternate VARCHAR2
406 , p4_a0 out nocopy JTF_NUMBER_TABLE
407 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
408 , p4_a2 out nocopy JTF_NUMBER_TABLE
409 , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
410 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
411 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
412 , p4_a6 out nocopy JTF_NUMBER_TABLE
413 , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
414 , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
415 , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
416 , p4_a10 out nocopy JTF_NUMBER_TABLE
417 , p4_a11 out nocopy JTF_NUMBER_TABLE
418 , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
419 , p4_a13 out nocopy JTF_NUMBER_TABLE
420 , p4_a14 out nocopy JTF_NUMBER_TABLE
421 , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
422 , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
423 , p4_a17 out nocopy JTF_DATE_TABLE
424 , p4_a18 out nocopy JTF_DATE_TABLE
425 , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
426 , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
427 , x_return_status out nocopy VARCHAR2
428 , x_msg_data out nocopy VARCHAR2
429 , x_msg_count out nocopy NUMBER
430 );
431 procedure ws_check_organizations(p_resource_type VARCHAR2
432 , p_resource_id NUMBER
433 , p2_a0 JTF_NUMBER_TABLE
434 , p2_a1 JTF_VARCHAR2_TABLE_100
435 , p2_a2 JTF_VARCHAR2_TABLE_100
436 , p2_a3 JTF_NUMBER_TABLE
437 , p2_a4 JTF_VARCHAR2_TABLE_100
438 , p2_a5 JTF_NUMBER_TABLE
439 , p_include_alternate VARCHAR2
440 , p4_a0 out nocopy JTF_NUMBER_TABLE
441 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442 , p4_a2 out nocopy JTF_NUMBER_TABLE
443 , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
445 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
446 , p4_a6 out nocopy JTF_NUMBER_TABLE
447 , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
448 , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449 , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450 , p4_a10 out nocopy JTF_NUMBER_TABLE
451 , p4_a11 out nocopy JTF_NUMBER_TABLE
452 , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453 , p4_a13 out nocopy JTF_NUMBER_TABLE
454 , p4_a14 out nocopy JTF_NUMBER_TABLE
455 , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
456 , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
457 , p4_a17 out nocopy JTF_DATE_TABLE
458 , p4_a18 out nocopy JTF_DATE_TABLE
459 , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
460 , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
461 , x_return_status out nocopy VARCHAR2
462 , x_msg_data out nocopy VARCHAR2
463 , x_msg_count out nocopy NUMBER
464 );
465 procedure get_alternates(p0_a0 NUMBER
466 , p0_a1 VARCHAR2
467 , p0_a2 VARCHAR2
468 , p0_a3 NUMBER
469 , p0_a4 VARCHAR2
470 , p0_a5 NUMBER
471 , p_org_id NUMBER
472 , p2_a0 in out nocopy JTF_NUMBER_TABLE
473 , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
474 , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
475 , p2_a3 in out nocopy JTF_NUMBER_TABLE
476 , p2_a4 in out nocopy JTF_NUMBER_TABLE
477 , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
478 , p2_a6 in out nocopy JTF_NUMBER_TABLE
479 , p2_a7 in out nocopy JTF_NUMBER_TABLE
480 , x_return_status out nocopy VARCHAR2
481 , x_msg_data out nocopy VARCHAR2
482 , x_msg_count out nocopy NUMBER
483 );
484 procedure get_delivery_date(p_relation_ship_id NUMBER
485 , x_delivery_date out nocopy DATE
486 , x_shipping_option out nocopy number
487 , x_return_status out nocopy VARCHAR2
488 , x_msg_data out nocopy VARCHAR2
489 , x_msg_count out nocopy NUMBER
490 );
491 function get_arrival_date(p_ship_date date
492 , p_lead_time NUMBER
493 , p_org_id NUMBER
494 ) return date;
495 procedure spares_check2(p0_a0 JTF_NUMBER_TABLE
496 , p0_a1 JTF_VARCHAR2_TABLE_100
497 , p_task_id NUMBER
498 , p_need_by_date date
499 , p_trunk number
500 , p_warehouse number
501 , p_mandatory number
502 , p6_a0 out nocopy JTF_NUMBER_TABLE
503 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
504 , p6_a2 out nocopy JTF_DATE_TABLE
505 , p6_a3 out nocopy JTF_NUMBER_TABLE
506 , p6_a4 out nocopy JTF_NUMBER_TABLE
507 , p6_a5 out nocopy JTF_NUMBER_TABLE
508 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_4000
509 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_4000
510 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_4000
511 , x_return_status out nocopy VARCHAR2
512 , x_msg_data out nocopy VARCHAR2
513 , x_msg_count out nocopy NUMBER
514 );
515 end csp_sch_int_pvt_w;