DBA Data[Home] [Help]

PACKAGE: APPS.OKL_CNTR_LVLNG_LINES_PUB_W

Source


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