eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_AM_SHIPPING_INSTR_PVT_W

Source


1 package okl_am_shipping_instr_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLESHIS.pls 115.6 2002/12/19 23:23:55 gkadarka noship $ */
3   procedure create_shipping_instr(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , x_return_status out nocopy  VARCHAR2
6     , x_msg_count out nocopy  NUMBER
7     , x_msg_data out nocopy  VARCHAR2
8     , p6_a0 out nocopy  NUMBER
9     , p6_a1 out nocopy  NUMBER
10     , p6_a2 out nocopy  VARCHAR2
11     , p6_a3 out nocopy  NUMBER
12     , p6_a4 out nocopy  NUMBER
13     , p6_a5 out nocopy  NUMBER
14     , p6_a6 out nocopy  DATE
15     , p6_a7 out nocopy  VARCHAR2
16     , p6_a8 out nocopy  VARCHAR2
17     , p6_a9 out nocopy  NUMBER
18     , p6_a10 out nocopy  VARCHAR2
19     , p6_a11 out nocopy  VARCHAR2
20     , p6_a12 out nocopy  VARCHAR2
21     , p6_a13 out nocopy  VARCHAR2
22     , p6_a14 out nocopy  VARCHAR2
23     , p6_a15 out nocopy  VARCHAR2
24     , p6_a16 out nocopy  VARCHAR2
25     , p6_a17 out nocopy  VARCHAR2
26     , p6_a18 out nocopy  VARCHAR2
27     , p6_a19 out nocopy  VARCHAR2
28     , p6_a20 out nocopy  VARCHAR2
29     , p6_a21 out nocopy  VARCHAR2
30     , p6_a22 out nocopy  VARCHAR2
31     , p6_a23 out nocopy  VARCHAR2
32     , p6_a24 out nocopy  VARCHAR2
33     , p6_a25 out nocopy  VARCHAR2
34     , p6_a26 out nocopy  NUMBER
35     , p6_a27 out nocopy  NUMBER
36     , p6_a28 out nocopy  NUMBER
37     , p6_a29 out nocopy  NUMBER
38     , p6_a30 out nocopy  DATE
39     , p6_a31 out nocopy  NUMBER
40     , p6_a32 out nocopy  DATE
41     , p6_a33 out nocopy  NUMBER
42     , p6_a34 out nocopy  NUMBER
43     , p6_a35 out nocopy  DATE
44     , p6_a36 out nocopy  VARCHAR2
45     , p6_a37 out nocopy  VARCHAR2
46     , p6_a38 out nocopy  VARCHAR2
47     , p6_a39 out nocopy  NUMBER
48     , p6_a40 out nocopy  DATE
49     , p5_a0  NUMBER := 0-1962.0724
50     , p5_a1  NUMBER := 0-1962.0724
51     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
52     , p5_a3  NUMBER := 0-1962.0724
53     , p5_a4  NUMBER := 0-1962.0724
54     , p5_a5  NUMBER := 0-1962.0724
55     , p5_a6  DATE := fnd_api.g_miss_date
56     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
57     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
58     , p5_a9  NUMBER := 0-1962.0724
59     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
60     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
61     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
62     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
63     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
64     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
65     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
66     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
67     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
68     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
69     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
70     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
71     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
72     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
73     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
74     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
75     , p5_a26  NUMBER := 0-1962.0724
76     , p5_a27  NUMBER := 0-1962.0724
77     , p5_a28  NUMBER := 0-1962.0724
78     , p5_a29  NUMBER := 0-1962.0724
79     , p5_a30  DATE := fnd_api.g_miss_date
80     , p5_a31  NUMBER := 0-1962.0724
81     , p5_a32  DATE := fnd_api.g_miss_date
82     , p5_a33  NUMBER := 0-1962.0724
83     , p5_a34  NUMBER := 0-1962.0724
84     , p5_a35  DATE := fnd_api.g_miss_date
85     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
86     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
87     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
88     , p5_a39  NUMBER := 0-1962.0724
89     , p5_a40  DATE := fnd_api.g_miss_date
90   );
91   procedure create_shipping_instr(p_api_version  NUMBER
92     , p_init_msg_list  VARCHAR2
93     , x_return_status out nocopy  VARCHAR2
94     , x_msg_count out nocopy  NUMBER
95     , x_msg_data out nocopy  VARCHAR2
96     , p5_a0 JTF_NUMBER_TABLE
97     , p5_a1 JTF_NUMBER_TABLE
98     , p5_a2 JTF_VARCHAR2_TABLE_100
99     , p5_a3 JTF_NUMBER_TABLE
100     , p5_a4 JTF_NUMBER_TABLE
101     , p5_a5 JTF_NUMBER_TABLE
102     , p5_a6 JTF_DATE_TABLE
103     , p5_a7 JTF_VARCHAR2_TABLE_2000
104     , p5_a8 JTF_VARCHAR2_TABLE_300
105     , p5_a9 JTF_NUMBER_TABLE
106     , p5_a10 JTF_VARCHAR2_TABLE_100
107     , p5_a11 JTF_VARCHAR2_TABLE_500
108     , p5_a12 JTF_VARCHAR2_TABLE_500
109     , p5_a13 JTF_VARCHAR2_TABLE_500
110     , p5_a14 JTF_VARCHAR2_TABLE_500
111     , p5_a15 JTF_VARCHAR2_TABLE_500
112     , p5_a16 JTF_VARCHAR2_TABLE_500
113     , p5_a17 JTF_VARCHAR2_TABLE_500
114     , p5_a18 JTF_VARCHAR2_TABLE_500
115     , p5_a19 JTF_VARCHAR2_TABLE_500
116     , p5_a20 JTF_VARCHAR2_TABLE_500
117     , p5_a21 JTF_VARCHAR2_TABLE_500
118     , p5_a22 JTF_VARCHAR2_TABLE_500
119     , p5_a23 JTF_VARCHAR2_TABLE_500
120     , p5_a24 JTF_VARCHAR2_TABLE_500
121     , p5_a25 JTF_VARCHAR2_TABLE_500
122     , p5_a26 JTF_NUMBER_TABLE
123     , p5_a27 JTF_NUMBER_TABLE
124     , p5_a28 JTF_NUMBER_TABLE
125     , p5_a29 JTF_NUMBER_TABLE
126     , p5_a30 JTF_DATE_TABLE
127     , p5_a31 JTF_NUMBER_TABLE
128     , p5_a32 JTF_DATE_TABLE
129     , p5_a33 JTF_NUMBER_TABLE
130     , p5_a34 JTF_NUMBER_TABLE
131     , p5_a35 JTF_DATE_TABLE
132     , p5_a36 JTF_VARCHAR2_TABLE_100
133     , p5_a37 JTF_VARCHAR2_TABLE_100
134     , p5_a38 JTF_VARCHAR2_TABLE_100
135     , p5_a39 JTF_NUMBER_TABLE
136     , p5_a40 JTF_DATE_TABLE
137     , p6_a0 out nocopy JTF_NUMBER_TABLE
138     , p6_a1 out nocopy JTF_NUMBER_TABLE
139     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
140     , p6_a3 out nocopy JTF_NUMBER_TABLE
141     , p6_a4 out nocopy JTF_NUMBER_TABLE
142     , p6_a5 out nocopy JTF_NUMBER_TABLE
143     , p6_a6 out nocopy JTF_DATE_TABLE
144     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
145     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
146     , p6_a9 out nocopy JTF_NUMBER_TABLE
147     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
148     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
149     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
150     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
151     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
152     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
153     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
154     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
155     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
156     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
157     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
158     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
159     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
160     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
161     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
162     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
163     , p6_a26 out nocopy JTF_NUMBER_TABLE
164     , p6_a27 out nocopy JTF_NUMBER_TABLE
165     , p6_a28 out nocopy JTF_NUMBER_TABLE
166     , p6_a29 out nocopy JTF_NUMBER_TABLE
167     , p6_a30 out nocopy JTF_DATE_TABLE
168     , p6_a31 out nocopy JTF_NUMBER_TABLE
169     , p6_a32 out nocopy JTF_DATE_TABLE
170     , p6_a33 out nocopy JTF_NUMBER_TABLE
171     , p6_a34 out nocopy JTF_NUMBER_TABLE
172     , p6_a35 out nocopy JTF_DATE_TABLE
173     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
174     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
175     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
176     , p6_a39 out nocopy JTF_NUMBER_TABLE
177     , p6_a40 out nocopy JTF_DATE_TABLE
178   );
179   procedure update_shipping_instr(p_api_version  NUMBER
180     , p_init_msg_list  VARCHAR2
181     , x_return_status out nocopy  VARCHAR2
182     , x_msg_count out nocopy  NUMBER
183     , x_msg_data out nocopy  VARCHAR2
184     , p6_a0 out nocopy  NUMBER
185     , p6_a1 out nocopy  NUMBER
186     , p6_a2 out nocopy  VARCHAR2
187     , p6_a3 out nocopy  NUMBER
188     , p6_a4 out nocopy  NUMBER
189     , p6_a5 out nocopy  NUMBER
190     , p6_a6 out nocopy  DATE
191     , p6_a7 out nocopy  VARCHAR2
192     , p6_a8 out nocopy  VARCHAR2
193     , p6_a9 out nocopy  NUMBER
194     , p6_a10 out nocopy  VARCHAR2
195     , p6_a11 out nocopy  VARCHAR2
196     , p6_a12 out nocopy  VARCHAR2
197     , p6_a13 out nocopy  VARCHAR2
198     , p6_a14 out nocopy  VARCHAR2
199     , p6_a15 out nocopy  VARCHAR2
200     , p6_a16 out nocopy  VARCHAR2
201     , p6_a17 out nocopy  VARCHAR2
202     , p6_a18 out nocopy  VARCHAR2
203     , p6_a19 out nocopy  VARCHAR2
204     , p6_a20 out nocopy  VARCHAR2
205     , p6_a21 out nocopy  VARCHAR2
206     , p6_a22 out nocopy  VARCHAR2
207     , p6_a23 out nocopy  VARCHAR2
208     , p6_a24 out nocopy  VARCHAR2
209     , p6_a25 out nocopy  VARCHAR2
210     , p6_a26 out nocopy  NUMBER
211     , p6_a27 out nocopy  NUMBER
212     , p6_a28 out nocopy  NUMBER
213     , p6_a29 out nocopy  NUMBER
214     , p6_a30 out nocopy  DATE
215     , p6_a31 out nocopy  NUMBER
216     , p6_a32 out nocopy  DATE
217     , p6_a33 out nocopy  NUMBER
218     , p6_a34 out nocopy  NUMBER
219     , p6_a35 out nocopy  DATE
220     , p6_a36 out nocopy  VARCHAR2
221     , p6_a37 out nocopy  VARCHAR2
222     , p6_a38 out nocopy  VARCHAR2
223     , p6_a39 out nocopy  NUMBER
224     , p6_a40 out nocopy  DATE
225     , p5_a0  NUMBER := 0-1962.0724
226     , p5_a1  NUMBER := 0-1962.0724
227     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
228     , p5_a3  NUMBER := 0-1962.0724
229     , p5_a4  NUMBER := 0-1962.0724
230     , p5_a5  NUMBER := 0-1962.0724
231     , p5_a6  DATE := fnd_api.g_miss_date
232     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
233     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
234     , p5_a9  NUMBER := 0-1962.0724
235     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
236     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
237     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
238     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
239     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
240     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
241     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
242     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
243     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
244     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
245     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
246     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
247     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
248     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
249     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
250     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
251     , p5_a26  NUMBER := 0-1962.0724
252     , p5_a27  NUMBER := 0-1962.0724
253     , p5_a28  NUMBER := 0-1962.0724
254     , p5_a29  NUMBER := 0-1962.0724
255     , p5_a30  DATE := fnd_api.g_miss_date
256     , p5_a31  NUMBER := 0-1962.0724
257     , p5_a32  DATE := fnd_api.g_miss_date
258     , p5_a33  NUMBER := 0-1962.0724
259     , p5_a34  NUMBER := 0-1962.0724
260     , p5_a35  DATE := fnd_api.g_miss_date
261     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
262     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
263     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
264     , p5_a39  NUMBER := 0-1962.0724
265     , p5_a40  DATE := fnd_api.g_miss_date
266   );
267   procedure update_shipping_instr(p_api_version  NUMBER
268     , p_init_msg_list  VARCHAR2
269     , x_return_status out nocopy  VARCHAR2
270     , x_msg_count out nocopy  NUMBER
271     , x_msg_data out nocopy  VARCHAR2
272     , p5_a0 JTF_NUMBER_TABLE
273     , p5_a1 JTF_NUMBER_TABLE
274     , p5_a2 JTF_VARCHAR2_TABLE_100
275     , p5_a3 JTF_NUMBER_TABLE
276     , p5_a4 JTF_NUMBER_TABLE
277     , p5_a5 JTF_NUMBER_TABLE
278     , p5_a6 JTF_DATE_TABLE
279     , p5_a7 JTF_VARCHAR2_TABLE_2000
280     , p5_a8 JTF_VARCHAR2_TABLE_300
281     , p5_a9 JTF_NUMBER_TABLE
282     , p5_a10 JTF_VARCHAR2_TABLE_100
283     , p5_a11 JTF_VARCHAR2_TABLE_500
284     , p5_a12 JTF_VARCHAR2_TABLE_500
285     , p5_a13 JTF_VARCHAR2_TABLE_500
286     , p5_a14 JTF_VARCHAR2_TABLE_500
287     , p5_a15 JTF_VARCHAR2_TABLE_500
288     , p5_a16 JTF_VARCHAR2_TABLE_500
289     , p5_a17 JTF_VARCHAR2_TABLE_500
290     , p5_a18 JTF_VARCHAR2_TABLE_500
291     , p5_a19 JTF_VARCHAR2_TABLE_500
292     , p5_a20 JTF_VARCHAR2_TABLE_500
293     , p5_a21 JTF_VARCHAR2_TABLE_500
294     , p5_a22 JTF_VARCHAR2_TABLE_500
295     , p5_a23 JTF_VARCHAR2_TABLE_500
296     , p5_a24 JTF_VARCHAR2_TABLE_500
297     , p5_a25 JTF_VARCHAR2_TABLE_500
298     , p5_a26 JTF_NUMBER_TABLE
299     , p5_a27 JTF_NUMBER_TABLE
300     , p5_a28 JTF_NUMBER_TABLE
301     , p5_a29 JTF_NUMBER_TABLE
302     , p5_a30 JTF_DATE_TABLE
303     , p5_a31 JTF_NUMBER_TABLE
304     , p5_a32 JTF_DATE_TABLE
305     , p5_a33 JTF_NUMBER_TABLE
306     , p5_a34 JTF_NUMBER_TABLE
307     , p5_a35 JTF_DATE_TABLE
308     , p5_a36 JTF_VARCHAR2_TABLE_100
309     , p5_a37 JTF_VARCHAR2_TABLE_100
310     , p5_a38 JTF_VARCHAR2_TABLE_100
311     , p5_a39 JTF_NUMBER_TABLE
312     , p5_a40 JTF_DATE_TABLE
313     , p6_a0 out nocopy JTF_NUMBER_TABLE
314     , p6_a1 out nocopy JTF_NUMBER_TABLE
315     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
316     , p6_a3 out nocopy JTF_NUMBER_TABLE
317     , p6_a4 out nocopy JTF_NUMBER_TABLE
318     , p6_a5 out nocopy JTF_NUMBER_TABLE
319     , p6_a6 out nocopy JTF_DATE_TABLE
320     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
321     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
322     , p6_a9 out nocopy JTF_NUMBER_TABLE
323     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
324     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
325     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
326     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
327     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
328     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
329     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
330     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
331     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
332     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
333     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
334     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
335     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
336     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
337     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
338     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
339     , p6_a26 out nocopy JTF_NUMBER_TABLE
340     , p6_a27 out nocopy JTF_NUMBER_TABLE
341     , p6_a28 out nocopy JTF_NUMBER_TABLE
342     , p6_a29 out nocopy JTF_NUMBER_TABLE
343     , p6_a30 out nocopy JTF_DATE_TABLE
344     , p6_a31 out nocopy JTF_NUMBER_TABLE
345     , p6_a32 out nocopy JTF_DATE_TABLE
346     , p6_a33 out nocopy JTF_NUMBER_TABLE
347     , p6_a34 out nocopy JTF_NUMBER_TABLE
348     , p6_a35 out nocopy JTF_DATE_TABLE
349     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
350     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
351     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
352     , p6_a39 out nocopy JTF_NUMBER_TABLE
353     , p6_a40 out nocopy JTF_DATE_TABLE
354   );
355   procedure send_shipping_instr(p_api_version  NUMBER
356     , p_init_msg_list  VARCHAR2
357     , x_return_status out nocopy  VARCHAR2
358     , x_msg_count out nocopy  NUMBER
359     , x_msg_data out nocopy  VARCHAR2
360     , p6_a0 out nocopy  NUMBER
361     , p6_a1 out nocopy  NUMBER
362     , p6_a2 out nocopy  VARCHAR2
363     , p6_a3 out nocopy  NUMBER
364     , p6_a4 out nocopy  NUMBER
365     , p6_a5 out nocopy  NUMBER
366     , p6_a6 out nocopy  DATE
367     , p6_a7 out nocopy  VARCHAR2
368     , p6_a8 out nocopy  VARCHAR2
369     , p6_a9 out nocopy  NUMBER
370     , p6_a10 out nocopy  VARCHAR2
371     , p6_a11 out nocopy  VARCHAR2
372     , p6_a12 out nocopy  VARCHAR2
373     , p6_a13 out nocopy  VARCHAR2
374     , p6_a14 out nocopy  VARCHAR2
375     , p6_a15 out nocopy  VARCHAR2
376     , p6_a16 out nocopy  VARCHAR2
377     , p6_a17 out nocopy  VARCHAR2
378     , p6_a18 out nocopy  VARCHAR2
379     , p6_a19 out nocopy  VARCHAR2
380     , p6_a20 out nocopy  VARCHAR2
381     , p6_a21 out nocopy  VARCHAR2
382     , p6_a22 out nocopy  VARCHAR2
383     , p6_a23 out nocopy  VARCHAR2
384     , p6_a24 out nocopy  VARCHAR2
385     , p6_a25 out nocopy  VARCHAR2
386     , p6_a26 out nocopy  NUMBER
387     , p6_a27 out nocopy  NUMBER
388     , p6_a28 out nocopy  NUMBER
389     , p6_a29 out nocopy  NUMBER
390     , p6_a30 out nocopy  DATE
391     , p6_a31 out nocopy  NUMBER
392     , p6_a32 out nocopy  DATE
393     , p6_a33 out nocopy  NUMBER
394     , p6_a34 out nocopy  NUMBER
395     , p6_a35 out nocopy  DATE
396     , p6_a36 out nocopy  VARCHAR2
397     , p6_a37 out nocopy  VARCHAR2
398     , p6_a38 out nocopy  VARCHAR2
399     , p6_a39 out nocopy  NUMBER
400     , p6_a40 out nocopy  DATE
401     , p5_a0  NUMBER := 0-1962.0724
402     , p5_a1  NUMBER := 0-1962.0724
403     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
404     , p5_a3  NUMBER := 0-1962.0724
405     , p5_a4  NUMBER := 0-1962.0724
406     , p5_a5  NUMBER := 0-1962.0724
407     , p5_a6  DATE := fnd_api.g_miss_date
408     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
409     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
410     , p5_a9  NUMBER := 0-1962.0724
411     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
412     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
413     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
414     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
415     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
416     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
417     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
418     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
419     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
420     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
421     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
422     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
423     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
424     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
425     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
426     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
427     , p5_a26  NUMBER := 0-1962.0724
428     , p5_a27  NUMBER := 0-1962.0724
429     , p5_a28  NUMBER := 0-1962.0724
430     , p5_a29  NUMBER := 0-1962.0724
431     , p5_a30  DATE := fnd_api.g_miss_date
432     , p5_a31  NUMBER := 0-1962.0724
433     , p5_a32  DATE := fnd_api.g_miss_date
434     , p5_a33  NUMBER := 0-1962.0724
435     , p5_a34  NUMBER := 0-1962.0724
436     , p5_a35  DATE := fnd_api.g_miss_date
437     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
438     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
439     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
440     , p5_a39  NUMBER := 0-1962.0724
441     , p5_a40  DATE := fnd_api.g_miss_date
442   );
443   procedure send_shipping_instr(p_api_version  NUMBER
444     , p_init_msg_list  VARCHAR2
445     , x_return_status out nocopy  VARCHAR2
446     , x_msg_count out nocopy  NUMBER
447     , x_msg_data out nocopy  VARCHAR2
448     , p5_a0 JTF_NUMBER_TABLE
449     , p5_a1 JTF_NUMBER_TABLE
450     , p5_a2 JTF_VARCHAR2_TABLE_100
451     , p5_a3 JTF_NUMBER_TABLE
452     , p5_a4 JTF_NUMBER_TABLE
453     , p5_a5 JTF_NUMBER_TABLE
454     , p5_a6 JTF_DATE_TABLE
455     , p5_a7 JTF_VARCHAR2_TABLE_2000
456     , p5_a8 JTF_VARCHAR2_TABLE_300
457     , p5_a9 JTF_NUMBER_TABLE
458     , p5_a10 JTF_VARCHAR2_TABLE_100
459     , p5_a11 JTF_VARCHAR2_TABLE_500
460     , p5_a12 JTF_VARCHAR2_TABLE_500
461     , p5_a13 JTF_VARCHAR2_TABLE_500
462     , p5_a14 JTF_VARCHAR2_TABLE_500
463     , p5_a15 JTF_VARCHAR2_TABLE_500
464     , p5_a16 JTF_VARCHAR2_TABLE_500
465     , p5_a17 JTF_VARCHAR2_TABLE_500
466     , p5_a18 JTF_VARCHAR2_TABLE_500
467     , p5_a19 JTF_VARCHAR2_TABLE_500
468     , p5_a20 JTF_VARCHAR2_TABLE_500
469     , p5_a21 JTF_VARCHAR2_TABLE_500
470     , p5_a22 JTF_VARCHAR2_TABLE_500
471     , p5_a23 JTF_VARCHAR2_TABLE_500
472     , p5_a24 JTF_VARCHAR2_TABLE_500
473     , p5_a25 JTF_VARCHAR2_TABLE_500
474     , p5_a26 JTF_NUMBER_TABLE
475     , p5_a27 JTF_NUMBER_TABLE
476     , p5_a28 JTF_NUMBER_TABLE
477     , p5_a29 JTF_NUMBER_TABLE
478     , p5_a30 JTF_DATE_TABLE
479     , p5_a31 JTF_NUMBER_TABLE
480     , p5_a32 JTF_DATE_TABLE
481     , p5_a33 JTF_NUMBER_TABLE
482     , p5_a34 JTF_NUMBER_TABLE
483     , p5_a35 JTF_DATE_TABLE
484     , p5_a36 JTF_VARCHAR2_TABLE_100
485     , p5_a37 JTF_VARCHAR2_TABLE_100
486     , p5_a38 JTF_VARCHAR2_TABLE_100
487     , p5_a39 JTF_NUMBER_TABLE
488     , p5_a40 JTF_DATE_TABLE
489     , p6_a0 out nocopy JTF_NUMBER_TABLE
490     , p6_a1 out nocopy JTF_NUMBER_TABLE
491     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
492     , p6_a3 out nocopy JTF_NUMBER_TABLE
493     , p6_a4 out nocopy JTF_NUMBER_TABLE
494     , p6_a5 out nocopy JTF_NUMBER_TABLE
495     , p6_a6 out nocopy JTF_DATE_TABLE
496     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
497     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
498     , p6_a9 out nocopy JTF_NUMBER_TABLE
499     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
500     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
501     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
502     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
503     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
504     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
505     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
506     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
507     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
508     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
509     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
510     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
511     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
512     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
513     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
514     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
515     , p6_a26 out nocopy JTF_NUMBER_TABLE
516     , p6_a27 out nocopy JTF_NUMBER_TABLE
517     , p6_a28 out nocopy JTF_NUMBER_TABLE
518     , p6_a29 out nocopy JTF_NUMBER_TABLE
519     , p6_a30 out nocopy JTF_DATE_TABLE
520     , p6_a31 out nocopy JTF_NUMBER_TABLE
521     , p6_a32 out nocopy JTF_DATE_TABLE
522     , p6_a33 out nocopy JTF_NUMBER_TABLE
523     , p6_a34 out nocopy JTF_NUMBER_TABLE
524     , p6_a35 out nocopy JTF_DATE_TABLE
525     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
526     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
527     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
528     , p6_a39 out nocopy JTF_NUMBER_TABLE
529     , p6_a40 out nocopy JTF_DATE_TABLE
530   );
531 end okl_am_shipping_instr_pvt_w;