[Home] [Help]
PACKAGE: APPS.OZF_VOLUME_OFFER_DISC_PVT_W
Source
1 package ozf_volume_offer_disc_pvt_w AUTHID CURRENT_USER as
2 /* $Header: ozfwvods.pls 120.4 2006/05/05 11:05 julou noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy ozf_volume_offer_disc_pvt.ozf_vo_disc_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_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_VARCHAR2_TABLE_100
22 , a19 JTF_DATE_TABLE
23 , a20 JTF_DATE_TABLE
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_DATE_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_DATE_TABLE
28 , a25 JTF_NUMBER_TABLE
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_VARCHAR2_TABLE_100
33 , a30 JTF_NUMBER_TABLE
34 , a31 JTF_NUMBER_TABLE
35 , a32 JTF_VARCHAR2_TABLE_300
36 , a33 JTF_VARCHAR2_TABLE_2000
37 , a34 JTF_VARCHAR2_TABLE_100
38 , a35 JTF_VARCHAR2_TABLE_300
39 , a36 JTF_VARCHAR2_TABLE_300
40 , a37 JTF_VARCHAR2_TABLE_300
41 , a38 JTF_VARCHAR2_TABLE_300
42 , a39 JTF_VARCHAR2_TABLE_300
43 , a40 JTF_VARCHAR2_TABLE_300
44 , a41 JTF_VARCHAR2_TABLE_300
45 , a42 JTF_VARCHAR2_TABLE_300
46 , a43 JTF_VARCHAR2_TABLE_300
47 , a44 JTF_VARCHAR2_TABLE_300
48 , a45 JTF_VARCHAR2_TABLE_300
49 , a46 JTF_VARCHAR2_TABLE_300
50 , a47 JTF_VARCHAR2_TABLE_300
51 , a48 JTF_VARCHAR2_TABLE_300
52 , a49 JTF_VARCHAR2_TABLE_300
53 );
54 procedure rosetta_table_copy_out_p2(t ozf_volume_offer_disc_pvt.ozf_vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55 , a1 out nocopy JTF_NUMBER_TABLE
56 , a2 out nocopy JTF_NUMBER_TABLE
57 , a3 out nocopy JTF_NUMBER_TABLE
58 , a4 out nocopy JTF_VARCHAR2_TABLE_100
59 , a5 out nocopy JTF_VARCHAR2_TABLE_100
60 , a6 out nocopy JTF_VARCHAR2_TABLE_100
61 , a7 out nocopy JTF_NUMBER_TABLE
62 , a8 out nocopy JTF_VARCHAR2_TABLE_100
63 , a9 out nocopy JTF_VARCHAR2_TABLE_100
64 , a10 out nocopy JTF_VARCHAR2_TABLE_100
65 , a11 out nocopy JTF_VARCHAR2_TABLE_100
66 , a12 out nocopy JTF_NUMBER_TABLE
67 , a13 out nocopy JTF_VARCHAR2_TABLE_100
68 , a14 out nocopy JTF_NUMBER_TABLE
69 , a15 out nocopy JTF_NUMBER_TABLE
70 , a16 out nocopy JTF_NUMBER_TABLE
71 , a17 out nocopy JTF_NUMBER_TABLE
72 , a18 out nocopy JTF_VARCHAR2_TABLE_100
73 , a19 out nocopy JTF_DATE_TABLE
74 , a20 out nocopy JTF_DATE_TABLE
75 , a21 out nocopy JTF_VARCHAR2_TABLE_100
76 , a22 out nocopy JTF_DATE_TABLE
77 , a23 out nocopy JTF_NUMBER_TABLE
78 , a24 out nocopy JTF_DATE_TABLE
79 , a25 out nocopy JTF_NUMBER_TABLE
80 , a26 out nocopy JTF_NUMBER_TABLE
81 , a27 out nocopy JTF_NUMBER_TABLE
82 , a28 out nocopy JTF_NUMBER_TABLE
83 , a29 out nocopy JTF_VARCHAR2_TABLE_100
84 , a30 out nocopy JTF_NUMBER_TABLE
85 , a31 out nocopy JTF_NUMBER_TABLE
86 , a32 out nocopy JTF_VARCHAR2_TABLE_300
87 , a33 out nocopy JTF_VARCHAR2_TABLE_2000
88 , a34 out nocopy JTF_VARCHAR2_TABLE_100
89 , a35 out nocopy JTF_VARCHAR2_TABLE_300
90 , a36 out nocopy JTF_VARCHAR2_TABLE_300
91 , a37 out nocopy JTF_VARCHAR2_TABLE_300
92 , a38 out nocopy JTF_VARCHAR2_TABLE_300
93 , a39 out nocopy JTF_VARCHAR2_TABLE_300
94 , a40 out nocopy JTF_VARCHAR2_TABLE_300
95 , a41 out nocopy JTF_VARCHAR2_TABLE_300
96 , a42 out nocopy JTF_VARCHAR2_TABLE_300
97 , a43 out nocopy JTF_VARCHAR2_TABLE_300
98 , a44 out nocopy JTF_VARCHAR2_TABLE_300
99 , a45 out nocopy JTF_VARCHAR2_TABLE_300
100 , a46 out nocopy JTF_VARCHAR2_TABLE_300
101 , a47 out nocopy JTF_VARCHAR2_TABLE_300
102 , a48 out nocopy JTF_VARCHAR2_TABLE_300
103 , a49 out nocopy JTF_VARCHAR2_TABLE_300
104 );
105
106 procedure rosetta_table_copy_in_p6(t out nocopy ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
107 , a1 JTF_VARCHAR2_TABLE_100
108 , a2 JTF_NUMBER_TABLE
109 , a3 JTF_VARCHAR2_TABLE_100
110 , a4 JTF_VARCHAR2_TABLE_100
111 , a5 JTF_DATE_TABLE
112 , a6 JTF_DATE_TABLE
113 , a7 JTF_NUMBER_TABLE
114 , a8 JTF_NUMBER_TABLE
115 , a9 JTF_DATE_TABLE
116 , a10 JTF_NUMBER_TABLE
117 , a11 JTF_DATE_TABLE
118 , a12 JTF_NUMBER_TABLE
119 , a13 JTF_NUMBER_TABLE
120 , a14 JTF_NUMBER_TABLE
121 , a15 JTF_NUMBER_TABLE
122 , a16 JTF_VARCHAR2_TABLE_100
123 , a17 JTF_VARCHAR2_TABLE_100
124 , a18 JTF_VARCHAR2_TABLE_300
125 , a19 JTF_VARCHAR2_TABLE_100
126 , a20 JTF_VARCHAR2_TABLE_100
127 );
128 procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129 , a1 out nocopy JTF_VARCHAR2_TABLE_100
130 , a2 out nocopy JTF_NUMBER_TABLE
131 , a3 out nocopy JTF_VARCHAR2_TABLE_100
132 , a4 out nocopy JTF_VARCHAR2_TABLE_100
133 , a5 out nocopy JTF_DATE_TABLE
134 , a6 out nocopy JTF_DATE_TABLE
135 , a7 out nocopy JTF_NUMBER_TABLE
136 , a8 out nocopy JTF_NUMBER_TABLE
137 , a9 out nocopy JTF_DATE_TABLE
138 , a10 out nocopy JTF_NUMBER_TABLE
139 , a11 out nocopy JTF_DATE_TABLE
140 , a12 out nocopy JTF_NUMBER_TABLE
141 , a13 out nocopy JTF_NUMBER_TABLE
142 , a14 out nocopy JTF_NUMBER_TABLE
143 , a15 out nocopy JTF_NUMBER_TABLE
144 , a16 out nocopy JTF_VARCHAR2_TABLE_100
145 , a17 out nocopy JTF_VARCHAR2_TABLE_100
146 , a18 out nocopy JTF_VARCHAR2_TABLE_300
147 , a19 out nocopy JTF_VARCHAR2_TABLE_100
148 , a20 out nocopy JTF_VARCHAR2_TABLE_100
149 );
150
151 procedure create_vo_discount(p_api_version_number NUMBER
152 , p_init_msg_list VARCHAR2
153 , p_commit VARCHAR2
154 , p_validation_level NUMBER
155 , x_return_status out nocopy VARCHAR2
156 , x_msg_count out nocopy NUMBER
157 , x_msg_data out nocopy VARCHAR2
158 , x_vo_discount_line_id out nocopy NUMBER
159 , p7_a0 NUMBER := 0-1962.0724
160 , p7_a1 NUMBER := 0-1962.0724
161 , p7_a2 NUMBER := 0-1962.0724
162 , p7_a3 NUMBER := 0-1962.0724
163 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
164 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
165 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
166 , p7_a7 NUMBER := 0-1962.0724
167 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
168 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
169 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
170 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
171 , p7_a12 NUMBER := 0-1962.0724
172 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
173 , p7_a14 NUMBER := 0-1962.0724
174 , p7_a15 NUMBER := 0-1962.0724
175 , p7_a16 NUMBER := 0-1962.0724
176 , p7_a17 NUMBER := 0-1962.0724
177 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
178 , p7_a19 DATE := fnd_api.g_miss_date
179 , p7_a20 DATE := fnd_api.g_miss_date
180 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
181 , p7_a22 DATE := fnd_api.g_miss_date
182 , p7_a23 NUMBER := 0-1962.0724
183 , p7_a24 DATE := fnd_api.g_miss_date
184 , p7_a25 NUMBER := 0-1962.0724
185 , p7_a26 NUMBER := 0-1962.0724
186 , p7_a27 NUMBER := 0-1962.0724
187 , p7_a28 NUMBER := 0-1962.0724
188 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
189 , p7_a30 NUMBER := 0-1962.0724
190 , p7_a31 NUMBER := 0-1962.0724
191 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
192 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
193 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
194 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
195 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
196 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
197 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
198 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
199 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
200 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
201 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
202 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
203 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
204 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
205 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
206 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
207 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
208 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
209 );
210 procedure update_vo_discount(p_api_version_number NUMBER
211 , p_init_msg_list VARCHAR2
212 , p_commit VARCHAR2
213 , p_validation_level NUMBER
214 , x_return_status out nocopy VARCHAR2
215 , x_msg_count out nocopy NUMBER
216 , x_msg_data out nocopy VARCHAR2
217 , p7_a0 NUMBER := 0-1962.0724
218 , p7_a1 NUMBER := 0-1962.0724
219 , p7_a2 NUMBER := 0-1962.0724
220 , p7_a3 NUMBER := 0-1962.0724
221 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
222 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
223 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
224 , p7_a7 NUMBER := 0-1962.0724
225 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
226 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
227 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
228 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
229 , p7_a12 NUMBER := 0-1962.0724
230 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
231 , p7_a14 NUMBER := 0-1962.0724
232 , p7_a15 NUMBER := 0-1962.0724
233 , p7_a16 NUMBER := 0-1962.0724
234 , p7_a17 NUMBER := 0-1962.0724
235 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
236 , p7_a19 DATE := fnd_api.g_miss_date
237 , p7_a20 DATE := fnd_api.g_miss_date
238 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
239 , p7_a22 DATE := fnd_api.g_miss_date
240 , p7_a23 NUMBER := 0-1962.0724
241 , p7_a24 DATE := fnd_api.g_miss_date
242 , p7_a25 NUMBER := 0-1962.0724
243 , p7_a26 NUMBER := 0-1962.0724
244 , p7_a27 NUMBER := 0-1962.0724
245 , p7_a28 NUMBER := 0-1962.0724
246 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
247 , p7_a30 NUMBER := 0-1962.0724
248 , p7_a31 NUMBER := 0-1962.0724
249 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
250 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
251 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
252 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
253 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
254 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
255 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
256 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
257 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
258 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
259 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
260 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
261 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
262 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
263 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
264 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
265 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
266 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
267 );
268 procedure create_vo_product(p_api_version_number NUMBER
269 , p_init_msg_list VARCHAR2
270 , p_commit VARCHAR2
271 , p_validation_level NUMBER
272 , x_return_status out nocopy VARCHAR2
273 , x_msg_count out nocopy NUMBER
274 , x_msg_data out nocopy VARCHAR2
275 , x_off_discount_product_id out nocopy NUMBER
276 , p7_a0 NUMBER := 0-1962.0724
277 , p7_a1 VARCHAR2 := fnd_api.g_miss_char
278 , p7_a2 NUMBER := 0-1962.0724
279 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
280 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
281 , p7_a5 DATE := fnd_api.g_miss_date
282 , p7_a6 DATE := fnd_api.g_miss_date
283 , p7_a7 NUMBER := 0-1962.0724
284 , p7_a8 NUMBER := 0-1962.0724
285 , p7_a9 DATE := fnd_api.g_miss_date
286 , p7_a10 NUMBER := 0-1962.0724
287 , p7_a11 DATE := fnd_api.g_miss_date
288 , p7_a12 NUMBER := 0-1962.0724
289 , p7_a13 NUMBER := 0-1962.0724
290 , p7_a14 NUMBER := 0-1962.0724
291 , p7_a15 NUMBER := 0-1962.0724
292 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
293 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
294 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
295 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
296 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
297 );
298 procedure update_vo_product(p_api_version_number NUMBER
299 , p_init_msg_list VARCHAR2
300 , p_commit VARCHAR2
301 , p_validation_level NUMBER
302 , x_return_status out nocopy VARCHAR2
303 , x_msg_count out nocopy NUMBER
304 , x_msg_data out nocopy VARCHAR2
305 , p7_a0 NUMBER := 0-1962.0724
306 , p7_a1 VARCHAR2 := fnd_api.g_miss_char
307 , p7_a2 NUMBER := 0-1962.0724
308 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
309 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
310 , p7_a5 DATE := fnd_api.g_miss_date
311 , p7_a6 DATE := fnd_api.g_miss_date
312 , p7_a7 NUMBER := 0-1962.0724
313 , p7_a8 NUMBER := 0-1962.0724
314 , p7_a9 DATE := fnd_api.g_miss_date
315 , p7_a10 NUMBER := 0-1962.0724
316 , p7_a11 DATE := fnd_api.g_miss_date
317 , p7_a12 NUMBER := 0-1962.0724
318 , p7_a13 NUMBER := 0-1962.0724
319 , p7_a14 NUMBER := 0-1962.0724
320 , p7_a15 NUMBER := 0-1962.0724
321 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
322 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
323 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
324 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
325 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
326 );
327 procedure copy_vo_discounts(p_api_version_number NUMBER
328 , p_init_msg_list VARCHAR2
329 , p_commit VARCHAR2
330 , p_validation_level NUMBER
331 , x_return_status out nocopy VARCHAR2
332 , x_msg_count out nocopy NUMBER
333 , x_msg_data out nocopy VARCHAR2
334 , p_discount_line_id NUMBER
335 , x_vo_discount_line_id out nocopy NUMBER
336 , p8_a0 NUMBER := 0-1962.0724
337 , p8_a1 NUMBER := 0-1962.0724
338 , p8_a2 NUMBER := 0-1962.0724
339 , p8_a3 NUMBER := 0-1962.0724
340 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
341 , p8_a5 VARCHAR2 := fnd_api.g_miss_char
342 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
343 , p8_a7 NUMBER := 0-1962.0724
344 , p8_a8 VARCHAR2 := fnd_api.g_miss_char
345 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
346 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
347 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
348 , p8_a12 NUMBER := 0-1962.0724
349 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
350 , p8_a14 NUMBER := 0-1962.0724
351 , p8_a15 NUMBER := 0-1962.0724
352 , p8_a16 NUMBER := 0-1962.0724
353 , p8_a17 NUMBER := 0-1962.0724
354 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
355 , p8_a19 DATE := fnd_api.g_miss_date
356 , p8_a20 DATE := fnd_api.g_miss_date
357 , p8_a21 VARCHAR2 := fnd_api.g_miss_char
358 , p8_a22 DATE := fnd_api.g_miss_date
359 , p8_a23 NUMBER := 0-1962.0724
360 , p8_a24 DATE := fnd_api.g_miss_date
361 , p8_a25 NUMBER := 0-1962.0724
362 , p8_a26 NUMBER := 0-1962.0724
363 , p8_a27 NUMBER := 0-1962.0724
364 , p8_a28 NUMBER := 0-1962.0724
365 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
366 , p8_a30 NUMBER := 0-1962.0724
367 , p8_a31 NUMBER := 0-1962.0724
368 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
369 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
370 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
371 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
372 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
373 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
374 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
375 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
376 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
377 , p8_a41 VARCHAR2 := fnd_api.g_miss_char
378 , p8_a42 VARCHAR2 := fnd_api.g_miss_char
379 , p8_a43 VARCHAR2 := fnd_api.g_miss_char
380 , p8_a44 VARCHAR2 := fnd_api.g_miss_char
381 , p8_a45 VARCHAR2 := fnd_api.g_miss_char
382 , p8_a46 VARCHAR2 := fnd_api.g_miss_char
383 , p8_a47 VARCHAR2 := fnd_api.g_miss_char
384 , p8_a48 VARCHAR2 := fnd_api.g_miss_char
385 , p8_a49 VARCHAR2 := fnd_api.g_miss_char
386 );
387 procedure check_vo_product_attr(x_return_status out nocopy VARCHAR2
388 , p0_a0 NUMBER := 0-1962.0724
389 , p0_a1 VARCHAR2 := fnd_api.g_miss_char
390 , p0_a2 NUMBER := 0-1962.0724
391 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
392 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
393 , p0_a5 DATE := fnd_api.g_miss_date
394 , p0_a6 DATE := fnd_api.g_miss_date
395 , p0_a7 NUMBER := 0-1962.0724
396 , p0_a8 NUMBER := 0-1962.0724
397 , p0_a9 DATE := fnd_api.g_miss_date
398 , p0_a10 NUMBER := 0-1962.0724
399 , p0_a11 DATE := fnd_api.g_miss_date
400 , p0_a12 NUMBER := 0-1962.0724
401 , p0_a13 NUMBER := 0-1962.0724
402 , p0_a14 NUMBER := 0-1962.0724
403 , p0_a15 NUMBER := 0-1962.0724
404 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
405 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
406 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
407 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
408 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
409 );
410 end ozf_volume_offer_disc_pvt_w;