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_CONTRACT_PROD_OPTNS_PVT_W

Source


1 package okl_contract_prod_optns_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLOCSPS.pls 120.1 2005/07/08 10:19:32 asawanka noship $ */
3   procedure create_contract_option(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  NUMBER
11     , p6_a3 out nocopy  NUMBER
12     , p6_a4 out nocopy  VARCHAR2
13     , p6_a5 out nocopy  VARCHAR2
14     , p6_a6 out nocopy  VARCHAR2
15     , p6_a7 out nocopy  VARCHAR2
16     , p6_a8 out nocopy  VARCHAR2
17     , p6_a9 out nocopy  VARCHAR2
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  NUMBER
29     , p6_a21 out nocopy  DATE
30     , p6_a22 out nocopy  NUMBER
31     , p6_a23 out nocopy  DATE
32     , p6_a24 out nocopy  NUMBER
33     , p5_a0  NUMBER := 0-1962.0724
34     , p5_a1  NUMBER := 0-1962.0724
35     , p5_a2  NUMBER := 0-1962.0724
36     , p5_a3  NUMBER := 0-1962.0724
37     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
38     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
39     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
40     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
41     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
42     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
43     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
44     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
45     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
46     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
47     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
48     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
49     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
50     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
51     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
52     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
53     , p5_a20  NUMBER := 0-1962.0724
54     , p5_a21  DATE := fnd_api.g_miss_date
55     , p5_a22  NUMBER := 0-1962.0724
56     , p5_a23  DATE := fnd_api.g_miss_date
57     , p5_a24  NUMBER := 0-1962.0724
58   );
59   procedure create_contract_option(p_api_version  NUMBER
60     , p_init_msg_list  VARCHAR2
61     , x_return_status out nocopy  VARCHAR2
62     , x_msg_count out nocopy  NUMBER
63     , x_msg_data out nocopy  VARCHAR2
64     , p5_a0 JTF_NUMBER_TABLE
65     , p5_a1 JTF_NUMBER_TABLE
66     , p5_a2 JTF_NUMBER_TABLE
67     , p5_a3 JTF_NUMBER_TABLE
68     , p5_a4 JTF_VARCHAR2_TABLE_100
69     , p5_a5 JTF_VARCHAR2_TABLE_500
70     , p5_a6 JTF_VARCHAR2_TABLE_500
71     , p5_a7 JTF_VARCHAR2_TABLE_500
72     , p5_a8 JTF_VARCHAR2_TABLE_500
73     , p5_a9 JTF_VARCHAR2_TABLE_500
74     , p5_a10 JTF_VARCHAR2_TABLE_500
75     , p5_a11 JTF_VARCHAR2_TABLE_500
76     , p5_a12 JTF_VARCHAR2_TABLE_500
77     , p5_a13 JTF_VARCHAR2_TABLE_500
78     , p5_a14 JTF_VARCHAR2_TABLE_500
79     , p5_a15 JTF_VARCHAR2_TABLE_500
80     , p5_a16 JTF_VARCHAR2_TABLE_500
81     , p5_a17 JTF_VARCHAR2_TABLE_500
82     , p5_a18 JTF_VARCHAR2_TABLE_500
83     , p5_a19 JTF_VARCHAR2_TABLE_500
84     , p5_a20 JTF_NUMBER_TABLE
85     , p5_a21 JTF_DATE_TABLE
86     , p5_a22 JTF_NUMBER_TABLE
87     , p5_a23 JTF_DATE_TABLE
88     , p5_a24 JTF_NUMBER_TABLE
89     , p6_a0 out nocopy JTF_NUMBER_TABLE
90     , p6_a1 out nocopy JTF_NUMBER_TABLE
91     , p6_a2 out nocopy JTF_NUMBER_TABLE
92     , p6_a3 out nocopy JTF_NUMBER_TABLE
93     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
94     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
95     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
96     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
97     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
98     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
99     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
100     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
101     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
102     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
103     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
104     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
105     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
106     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
107     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
108     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
109     , p6_a20 out nocopy JTF_NUMBER_TABLE
110     , p6_a21 out nocopy JTF_DATE_TABLE
111     , p6_a22 out nocopy JTF_NUMBER_TABLE
112     , p6_a23 out nocopy JTF_DATE_TABLE
113     , p6_a24 out nocopy JTF_NUMBER_TABLE
114   );
115   procedure update_contract_option(p_api_version  NUMBER
116     , p_init_msg_list  VARCHAR2
117     , x_return_status out nocopy  VARCHAR2
118     , x_msg_count out nocopy  NUMBER
119     , x_msg_data out nocopy  VARCHAR2
120     , p6_a0 out nocopy  NUMBER
121     , p6_a1 out nocopy  NUMBER
122     , p6_a2 out nocopy  NUMBER
123     , p6_a3 out nocopy  NUMBER
124     , p6_a4 out nocopy  VARCHAR2
125     , p6_a5 out nocopy  VARCHAR2
126     , p6_a6 out nocopy  VARCHAR2
127     , p6_a7 out nocopy  VARCHAR2
128     , p6_a8 out nocopy  VARCHAR2
129     , p6_a9 out nocopy  VARCHAR2
130     , p6_a10 out nocopy  VARCHAR2
131     , p6_a11 out nocopy  VARCHAR2
132     , p6_a12 out nocopy  VARCHAR2
133     , p6_a13 out nocopy  VARCHAR2
134     , p6_a14 out nocopy  VARCHAR2
135     , p6_a15 out nocopy  VARCHAR2
136     , p6_a16 out nocopy  VARCHAR2
137     , p6_a17 out nocopy  VARCHAR2
138     , p6_a18 out nocopy  VARCHAR2
139     , p6_a19 out nocopy  VARCHAR2
140     , p6_a20 out nocopy  NUMBER
141     , p6_a21 out nocopy  DATE
142     , p6_a22 out nocopy  NUMBER
143     , p6_a23 out nocopy  DATE
144     , p6_a24 out nocopy  NUMBER
145     , p5_a0  NUMBER := 0-1962.0724
146     , p5_a1  NUMBER := 0-1962.0724
147     , p5_a2  NUMBER := 0-1962.0724
148     , p5_a3  NUMBER := 0-1962.0724
149     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
150     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
151     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
152     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
153     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
154     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
155     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
156     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
157     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
158     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
159     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
160     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
161     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
162     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
163     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
164     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
165     , p5_a20  NUMBER := 0-1962.0724
166     , p5_a21  DATE := fnd_api.g_miss_date
167     , p5_a22  NUMBER := 0-1962.0724
168     , p5_a23  DATE := fnd_api.g_miss_date
169     , p5_a24  NUMBER := 0-1962.0724
170   );
171   procedure update_contract_option(p_api_version  NUMBER
172     , p_init_msg_list  VARCHAR2
173     , x_return_status out nocopy  VARCHAR2
174     , x_msg_count out nocopy  NUMBER
175     , x_msg_data out nocopy  VARCHAR2
176     , p5_a0 JTF_NUMBER_TABLE
177     , p5_a1 JTF_NUMBER_TABLE
178     , p5_a2 JTF_NUMBER_TABLE
179     , p5_a3 JTF_NUMBER_TABLE
180     , p5_a4 JTF_VARCHAR2_TABLE_100
181     , p5_a5 JTF_VARCHAR2_TABLE_500
182     , p5_a6 JTF_VARCHAR2_TABLE_500
183     , p5_a7 JTF_VARCHAR2_TABLE_500
184     , p5_a8 JTF_VARCHAR2_TABLE_500
185     , p5_a9 JTF_VARCHAR2_TABLE_500
186     , p5_a10 JTF_VARCHAR2_TABLE_500
187     , p5_a11 JTF_VARCHAR2_TABLE_500
188     , p5_a12 JTF_VARCHAR2_TABLE_500
189     , p5_a13 JTF_VARCHAR2_TABLE_500
190     , p5_a14 JTF_VARCHAR2_TABLE_500
191     , p5_a15 JTF_VARCHAR2_TABLE_500
192     , p5_a16 JTF_VARCHAR2_TABLE_500
193     , p5_a17 JTF_VARCHAR2_TABLE_500
194     , p5_a18 JTF_VARCHAR2_TABLE_500
195     , p5_a19 JTF_VARCHAR2_TABLE_500
196     , p5_a20 JTF_NUMBER_TABLE
197     , p5_a21 JTF_DATE_TABLE
198     , p5_a22 JTF_NUMBER_TABLE
199     , p5_a23 JTF_DATE_TABLE
200     , p5_a24 JTF_NUMBER_TABLE
201     , p6_a0 out nocopy JTF_NUMBER_TABLE
202     , p6_a1 out nocopy JTF_NUMBER_TABLE
203     , p6_a2 out nocopy JTF_NUMBER_TABLE
204     , p6_a3 out nocopy JTF_NUMBER_TABLE
205     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
206     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
207     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
208     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
209     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
210     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
211     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
212     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
213     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
214     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
215     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
216     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
217     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
218     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
219     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
220     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
221     , p6_a20 out nocopy JTF_NUMBER_TABLE
222     , p6_a21 out nocopy JTF_DATE_TABLE
223     , p6_a22 out nocopy JTF_NUMBER_TABLE
224     , p6_a23 out nocopy JTF_DATE_TABLE
225     , p6_a24 out nocopy JTF_NUMBER_TABLE
226   );
227   procedure delete_contract_option(p_api_version  NUMBER
228     , p_init_msg_list  VARCHAR2
229     , x_return_status out nocopy  VARCHAR2
230     , x_msg_count out nocopy  NUMBER
231     , x_msg_data out nocopy  VARCHAR2
232     , p5_a0  NUMBER := 0-1962.0724
233     , p5_a1  NUMBER := 0-1962.0724
234     , p5_a2  NUMBER := 0-1962.0724
235     , p5_a3  NUMBER := 0-1962.0724
236     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
237     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
238     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
239     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
240     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
241     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
242     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
243     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
244     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
245     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
246     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
247     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
248     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
249     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
250     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
251     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
252     , p5_a20  NUMBER := 0-1962.0724
253     , p5_a21  DATE := fnd_api.g_miss_date
254     , p5_a22  NUMBER := 0-1962.0724
255     , p5_a23  DATE := fnd_api.g_miss_date
256     , p5_a24  NUMBER := 0-1962.0724
257   );
258   procedure delete_contract_option(p_api_version  NUMBER
259     , p_init_msg_list  VARCHAR2
260     , x_return_status out nocopy  VARCHAR2
261     , x_msg_count out nocopy  NUMBER
262     , x_msg_data out nocopy  VARCHAR2
263     , p5_a0 JTF_NUMBER_TABLE
264     , p5_a1 JTF_NUMBER_TABLE
265     , p5_a2 JTF_NUMBER_TABLE
266     , p5_a3 JTF_NUMBER_TABLE
267     , p5_a4 JTF_VARCHAR2_TABLE_100
268     , p5_a5 JTF_VARCHAR2_TABLE_500
269     , p5_a6 JTF_VARCHAR2_TABLE_500
270     , p5_a7 JTF_VARCHAR2_TABLE_500
271     , p5_a8 JTF_VARCHAR2_TABLE_500
272     , p5_a9 JTF_VARCHAR2_TABLE_500
273     , p5_a10 JTF_VARCHAR2_TABLE_500
274     , p5_a11 JTF_VARCHAR2_TABLE_500
275     , p5_a12 JTF_VARCHAR2_TABLE_500
276     , p5_a13 JTF_VARCHAR2_TABLE_500
277     , p5_a14 JTF_VARCHAR2_TABLE_500
278     , p5_a15 JTF_VARCHAR2_TABLE_500
279     , p5_a16 JTF_VARCHAR2_TABLE_500
280     , p5_a17 JTF_VARCHAR2_TABLE_500
281     , p5_a18 JTF_VARCHAR2_TABLE_500
282     , p5_a19 JTF_VARCHAR2_TABLE_500
283     , p5_a20 JTF_NUMBER_TABLE
284     , p5_a21 JTF_DATE_TABLE
285     , p5_a22 JTF_NUMBER_TABLE
286     , p5_a23 JTF_DATE_TABLE
287     , p5_a24 JTF_NUMBER_TABLE
288   );
289   procedure lock_contract_option(p_api_version  NUMBER
290     , p_init_msg_list  VARCHAR2
291     , x_return_status out nocopy  VARCHAR2
292     , x_msg_count out nocopy  NUMBER
293     , x_msg_data out nocopy  VARCHAR2
294     , p5_a0  NUMBER := 0-1962.0724
295     , p5_a1  NUMBER := 0-1962.0724
296     , p5_a2  NUMBER := 0-1962.0724
297     , p5_a3  NUMBER := 0-1962.0724
298     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
299     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
300     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
301     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
302     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
303     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
304     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
305     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
306     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
307     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
308     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
309     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
310     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
311     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
312     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
313     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
314     , p5_a20  NUMBER := 0-1962.0724
315     , p5_a21  DATE := fnd_api.g_miss_date
316     , p5_a22  NUMBER := 0-1962.0724
317     , p5_a23  DATE := fnd_api.g_miss_date
318     , p5_a24  NUMBER := 0-1962.0724
319   );
320   procedure lock_contract_option(p_api_version  NUMBER
321     , p_init_msg_list  VARCHAR2
322     , x_return_status out nocopy  VARCHAR2
323     , x_msg_count out nocopy  NUMBER
324     , x_msg_data out nocopy  VARCHAR2
325     , p5_a0 JTF_NUMBER_TABLE
326     , p5_a1 JTF_NUMBER_TABLE
327     , p5_a2 JTF_NUMBER_TABLE
328     , p5_a3 JTF_NUMBER_TABLE
329     , p5_a4 JTF_VARCHAR2_TABLE_100
330     , p5_a5 JTF_VARCHAR2_TABLE_500
331     , p5_a6 JTF_VARCHAR2_TABLE_500
332     , p5_a7 JTF_VARCHAR2_TABLE_500
333     , p5_a8 JTF_VARCHAR2_TABLE_500
334     , p5_a9 JTF_VARCHAR2_TABLE_500
335     , p5_a10 JTF_VARCHAR2_TABLE_500
336     , p5_a11 JTF_VARCHAR2_TABLE_500
337     , p5_a12 JTF_VARCHAR2_TABLE_500
338     , p5_a13 JTF_VARCHAR2_TABLE_500
339     , p5_a14 JTF_VARCHAR2_TABLE_500
340     , p5_a15 JTF_VARCHAR2_TABLE_500
341     , p5_a16 JTF_VARCHAR2_TABLE_500
342     , p5_a17 JTF_VARCHAR2_TABLE_500
343     , p5_a18 JTF_VARCHAR2_TABLE_500
344     , p5_a19 JTF_VARCHAR2_TABLE_500
345     , p5_a20 JTF_NUMBER_TABLE
346     , p5_a21 JTF_DATE_TABLE
347     , p5_a22 JTF_NUMBER_TABLE
348     , p5_a23 JTF_DATE_TABLE
349     , p5_a24 JTF_NUMBER_TABLE
350   );
351   procedure validate_contract_option(p_api_version  NUMBER
352     , p_init_msg_list  VARCHAR2
353     , x_return_status out nocopy  VARCHAR2
354     , x_msg_count out nocopy  NUMBER
355     , x_msg_data out nocopy  VARCHAR2
356     , p5_a0  NUMBER := 0-1962.0724
357     , p5_a1  NUMBER := 0-1962.0724
358     , p5_a2  NUMBER := 0-1962.0724
359     , p5_a3  NUMBER := 0-1962.0724
360     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
361     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
362     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
363     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
364     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
365     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
366     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
367     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
368     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
369     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
370     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
371     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
372     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
373     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
374     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
375     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
376     , p5_a20  NUMBER := 0-1962.0724
377     , p5_a21  DATE := fnd_api.g_miss_date
378     , p5_a22  NUMBER := 0-1962.0724
379     , p5_a23  DATE := fnd_api.g_miss_date
380     , p5_a24  NUMBER := 0-1962.0724
381   );
382   procedure validate_contract_option(p_api_version  NUMBER
383     , p_init_msg_list  VARCHAR2
384     , x_return_status out nocopy  VARCHAR2
385     , x_msg_count out nocopy  NUMBER
386     , x_msg_data out nocopy  VARCHAR2
387     , p5_a0 JTF_NUMBER_TABLE
388     , p5_a1 JTF_NUMBER_TABLE
389     , p5_a2 JTF_NUMBER_TABLE
390     , p5_a3 JTF_NUMBER_TABLE
391     , p5_a4 JTF_VARCHAR2_TABLE_100
392     , p5_a5 JTF_VARCHAR2_TABLE_500
393     , p5_a6 JTF_VARCHAR2_TABLE_500
394     , p5_a7 JTF_VARCHAR2_TABLE_500
395     , p5_a8 JTF_VARCHAR2_TABLE_500
396     , p5_a9 JTF_VARCHAR2_TABLE_500
397     , p5_a10 JTF_VARCHAR2_TABLE_500
398     , p5_a11 JTF_VARCHAR2_TABLE_500
399     , p5_a12 JTF_VARCHAR2_TABLE_500
400     , p5_a13 JTF_VARCHAR2_TABLE_500
401     , p5_a14 JTF_VARCHAR2_TABLE_500
402     , p5_a15 JTF_VARCHAR2_TABLE_500
403     , p5_a16 JTF_VARCHAR2_TABLE_500
404     , p5_a17 JTF_VARCHAR2_TABLE_500
405     , p5_a18 JTF_VARCHAR2_TABLE_500
406     , p5_a19 JTF_VARCHAR2_TABLE_500
407     , p5_a20 JTF_NUMBER_TABLE
408     , p5_a21 JTF_DATE_TABLE
409     , p5_a22 JTF_NUMBER_TABLE
410     , p5_a23 JTF_DATE_TABLE
411     , p5_a24 JTF_NUMBER_TABLE
412   );
413 end okl_contract_prod_optns_pvt_w;