[Home] [Help]
PACKAGE: APPS.OZF_DISC_LINE_PVT_W
Source
1 package ozf_disc_line_pvt_w AUTHID CURRENT_USER as
2 /* $Header: ozfwodls.pls 120.3 2006/05/04 15:26 julou ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy ozf_disc_line_pvt.ozf_offer_line_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_VARCHAR2_TABLE_100
32 , a29 JTF_VARCHAR2_TABLE_300
33 , a30 JTF_VARCHAR2_TABLE_300
34 , a31 JTF_VARCHAR2_TABLE_300
35 , a32 JTF_VARCHAR2_TABLE_300
36 , a33 JTF_VARCHAR2_TABLE_300
37 , a34 JTF_VARCHAR2_TABLE_300
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_NUMBER_TABLE
48 );
49 procedure rosetta_table_copy_out_p2(t ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50 , a1 out nocopy JTF_NUMBER_TABLE
51 , a2 out nocopy JTF_NUMBER_TABLE
52 , a3 out nocopy JTF_NUMBER_TABLE
53 , a4 out nocopy JTF_VARCHAR2_TABLE_100
54 , a5 out nocopy JTF_VARCHAR2_TABLE_100
55 , a6 out nocopy JTF_VARCHAR2_TABLE_100
56 , a7 out nocopy JTF_NUMBER_TABLE
57 , a8 out nocopy JTF_VARCHAR2_TABLE_100
58 , a9 out nocopy JTF_VARCHAR2_TABLE_100
59 , a10 out nocopy JTF_VARCHAR2_TABLE_100
60 , a11 out nocopy JTF_VARCHAR2_TABLE_100
61 , a12 out nocopy JTF_NUMBER_TABLE
62 , a13 out nocopy JTF_VARCHAR2_TABLE_100
63 , a14 out nocopy JTF_NUMBER_TABLE
64 , a15 out nocopy JTF_NUMBER_TABLE
65 , a16 out nocopy JTF_NUMBER_TABLE
66 , a17 out nocopy JTF_NUMBER_TABLE
67 , a18 out nocopy JTF_VARCHAR2_TABLE_100
68 , a19 out nocopy JTF_DATE_TABLE
69 , a20 out nocopy JTF_DATE_TABLE
70 , a21 out nocopy JTF_VARCHAR2_TABLE_100
71 , a22 out nocopy JTF_DATE_TABLE
72 , a23 out nocopy JTF_NUMBER_TABLE
73 , a24 out nocopy JTF_DATE_TABLE
74 , a25 out nocopy JTF_NUMBER_TABLE
75 , a26 out nocopy JTF_NUMBER_TABLE
76 , a27 out nocopy JTF_NUMBER_TABLE
77 , a28 out nocopy JTF_VARCHAR2_TABLE_100
78 , a29 out nocopy JTF_VARCHAR2_TABLE_300
79 , a30 out nocopy JTF_VARCHAR2_TABLE_300
80 , a31 out nocopy JTF_VARCHAR2_TABLE_300
81 , a32 out nocopy JTF_VARCHAR2_TABLE_300
82 , a33 out nocopy JTF_VARCHAR2_TABLE_300
83 , a34 out nocopy JTF_VARCHAR2_TABLE_300
84 , a35 out nocopy JTF_VARCHAR2_TABLE_300
85 , a36 out nocopy JTF_VARCHAR2_TABLE_300
86 , a37 out nocopy JTF_VARCHAR2_TABLE_300
87 , a38 out nocopy JTF_VARCHAR2_TABLE_300
88 , a39 out nocopy JTF_VARCHAR2_TABLE_300
89 , a40 out nocopy JTF_VARCHAR2_TABLE_300
90 , a41 out nocopy JTF_VARCHAR2_TABLE_300
91 , a42 out nocopy JTF_VARCHAR2_TABLE_300
92 , a43 out nocopy JTF_VARCHAR2_TABLE_300
93 , a44 out nocopy JTF_NUMBER_TABLE
94 );
95
96 procedure rosetta_table_copy_in_p6(t out nocopy ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
97 , a1 JTF_NUMBER_TABLE
98 , a2 JTF_NUMBER_TABLE
99 , a3 JTF_NUMBER_TABLE
100 , a4 JTF_NUMBER_TABLE
101 , a5 JTF_VARCHAR2_TABLE_100
102 , a6 JTF_VARCHAR2_TABLE_100
103 , a7 JTF_VARCHAR2_TABLE_100
104 , a8 JTF_NUMBER_TABLE
105 , a9 JTF_VARCHAR2_TABLE_100
106 , a10 JTF_DATE_TABLE
107 , a11 JTF_DATE_TABLE
108 , a12 JTF_VARCHAR2_TABLE_100
109 , a13 JTF_NUMBER_TABLE
110 , a14 JTF_VARCHAR2_TABLE_100
111 , a15 JTF_VARCHAR2_TABLE_300
112 , a16 JTF_VARCHAR2_TABLE_300
113 , a17 JTF_VARCHAR2_TABLE_300
114 , a18 JTF_VARCHAR2_TABLE_300
115 , a19 JTF_VARCHAR2_TABLE_300
116 , a20 JTF_VARCHAR2_TABLE_300
117 , a21 JTF_VARCHAR2_TABLE_300
118 , a22 JTF_VARCHAR2_TABLE_300
119 , a23 JTF_VARCHAR2_TABLE_300
120 , a24 JTF_VARCHAR2_TABLE_300
121 , a25 JTF_VARCHAR2_TABLE_300
122 , a26 JTF_VARCHAR2_TABLE_300
123 , a27 JTF_VARCHAR2_TABLE_300
124 , a28 JTF_VARCHAR2_TABLE_300
125 , a29 JTF_VARCHAR2_TABLE_300
126 );
127 procedure rosetta_table_copy_out_p6(t ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128 , a1 out nocopy JTF_NUMBER_TABLE
129 , a2 out nocopy JTF_NUMBER_TABLE
130 , a3 out nocopy JTF_NUMBER_TABLE
131 , a4 out nocopy JTF_NUMBER_TABLE
132 , a5 out nocopy JTF_VARCHAR2_TABLE_100
133 , a6 out nocopy JTF_VARCHAR2_TABLE_100
134 , a7 out nocopy JTF_VARCHAR2_TABLE_100
135 , a8 out nocopy JTF_NUMBER_TABLE
136 , a9 out nocopy JTF_VARCHAR2_TABLE_100
137 , a10 out nocopy JTF_DATE_TABLE
138 , a11 out nocopy JTF_DATE_TABLE
139 , a12 out nocopy JTF_VARCHAR2_TABLE_100
140 , a13 out nocopy JTF_NUMBER_TABLE
141 , a14 out nocopy JTF_VARCHAR2_TABLE_100
142 , a15 out nocopy JTF_VARCHAR2_TABLE_300
143 , a16 out nocopy JTF_VARCHAR2_TABLE_300
144 , a17 out nocopy JTF_VARCHAR2_TABLE_300
145 , a18 out nocopy JTF_VARCHAR2_TABLE_300
146 , a19 out nocopy JTF_VARCHAR2_TABLE_300
147 , a20 out nocopy JTF_VARCHAR2_TABLE_300
148 , a21 out nocopy JTF_VARCHAR2_TABLE_300
149 , a22 out nocopy JTF_VARCHAR2_TABLE_300
150 , a23 out nocopy JTF_VARCHAR2_TABLE_300
151 , a24 out nocopy JTF_VARCHAR2_TABLE_300
152 , a25 out nocopy JTF_VARCHAR2_TABLE_300
153 , a26 out nocopy JTF_VARCHAR2_TABLE_300
154 , a27 out nocopy JTF_VARCHAR2_TABLE_300
155 , a28 out nocopy JTF_VARCHAR2_TABLE_300
156 , a29 out nocopy JTF_VARCHAR2_TABLE_300
157 );
158
159 procedure rosetta_table_copy_in_p9(t out nocopy ozf_disc_line_pvt.ozf_discount_line_tbl, a0 JTF_NUMBER_TABLE
160 , a1 JTF_NUMBER_TABLE
161 , a2 JTF_NUMBER_TABLE
162 , a3 JTF_NUMBER_TABLE
163 , a4 JTF_VARCHAR2_TABLE_100
164 , a5 JTF_VARCHAR2_TABLE_100
165 , a6 JTF_VARCHAR2_TABLE_100
166 , a7 JTF_NUMBER_TABLE
167 , a8 JTF_VARCHAR2_TABLE_100
168 , a9 JTF_VARCHAR2_TABLE_100
169 , a10 JTF_VARCHAR2_TABLE_100
170 , a11 JTF_VARCHAR2_TABLE_100
171 , a12 JTF_NUMBER_TABLE
172 , a13 JTF_VARCHAR2_TABLE_100
173 , a14 JTF_NUMBER_TABLE
174 , a15 JTF_NUMBER_TABLE
175 , a16 JTF_NUMBER_TABLE
176 , a17 JTF_NUMBER_TABLE
177 , a18 JTF_VARCHAR2_TABLE_100
178 , a19 JTF_DATE_TABLE
179 , a20 JTF_DATE_TABLE
180 , a21 JTF_VARCHAR2_TABLE_100
181 , a22 JTF_DATE_TABLE
182 , a23 JTF_NUMBER_TABLE
183 , a24 JTF_DATE_TABLE
184 , a25 JTF_NUMBER_TABLE
185 , a26 JTF_NUMBER_TABLE
186 , a27 JTF_NUMBER_TABLE
187 , a28 JTF_NUMBER_TABLE
188 , a29 JTF_NUMBER_TABLE
189 , a30 JTF_NUMBER_TABLE
190 , a31 JTF_VARCHAR2_TABLE_100
191 , a32 JTF_NUMBER_TABLE
192 , a33 JTF_VARCHAR2_TABLE_100
193 , a34 JTF_VARCHAR2_TABLE_100
194 , a35 JTF_VARCHAR2_TABLE_300
195 , a36 JTF_VARCHAR2_TABLE_300
196 , a37 JTF_VARCHAR2_TABLE_300
197 , a38 JTF_VARCHAR2_TABLE_300
198 , a39 JTF_VARCHAR2_TABLE_300
199 , a40 JTF_VARCHAR2_TABLE_300
200 , a41 JTF_VARCHAR2_TABLE_300
201 , a42 JTF_VARCHAR2_TABLE_300
202 , a43 JTF_VARCHAR2_TABLE_300
203 , a44 JTF_VARCHAR2_TABLE_300
204 , a45 JTF_VARCHAR2_TABLE_300
205 , a46 JTF_VARCHAR2_TABLE_300
206 , a47 JTF_VARCHAR2_TABLE_300
207 , a48 JTF_VARCHAR2_TABLE_300
208 , a49 JTF_VARCHAR2_TABLE_300
209 );
210 procedure rosetta_table_copy_out_p9(t ozf_disc_line_pvt.ozf_discount_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
211 , a1 out nocopy JTF_NUMBER_TABLE
212 , a2 out nocopy JTF_NUMBER_TABLE
213 , a3 out nocopy JTF_NUMBER_TABLE
214 , a4 out nocopy JTF_VARCHAR2_TABLE_100
215 , a5 out nocopy JTF_VARCHAR2_TABLE_100
216 , a6 out nocopy JTF_VARCHAR2_TABLE_100
217 , a7 out nocopy JTF_NUMBER_TABLE
218 , a8 out nocopy JTF_VARCHAR2_TABLE_100
219 , a9 out nocopy JTF_VARCHAR2_TABLE_100
220 , a10 out nocopy JTF_VARCHAR2_TABLE_100
221 , a11 out nocopy JTF_VARCHAR2_TABLE_100
222 , a12 out nocopy JTF_NUMBER_TABLE
223 , a13 out nocopy JTF_VARCHAR2_TABLE_100
224 , a14 out nocopy JTF_NUMBER_TABLE
225 , a15 out nocopy JTF_NUMBER_TABLE
226 , a16 out nocopy JTF_NUMBER_TABLE
227 , a17 out nocopy JTF_NUMBER_TABLE
228 , a18 out nocopy JTF_VARCHAR2_TABLE_100
229 , a19 out nocopy JTF_DATE_TABLE
230 , a20 out nocopy JTF_DATE_TABLE
231 , a21 out nocopy JTF_VARCHAR2_TABLE_100
232 , a22 out nocopy JTF_DATE_TABLE
233 , a23 out nocopy JTF_NUMBER_TABLE
234 , a24 out nocopy JTF_DATE_TABLE
235 , a25 out nocopy JTF_NUMBER_TABLE
236 , a26 out nocopy JTF_NUMBER_TABLE
237 , a27 out nocopy JTF_NUMBER_TABLE
238 , a28 out nocopy JTF_NUMBER_TABLE
239 , a29 out nocopy JTF_NUMBER_TABLE
240 , a30 out nocopy JTF_NUMBER_TABLE
241 , a31 out nocopy JTF_VARCHAR2_TABLE_100
242 , a32 out nocopy JTF_NUMBER_TABLE
243 , a33 out nocopy JTF_VARCHAR2_TABLE_100
244 , a34 out nocopy JTF_VARCHAR2_TABLE_100
245 , a35 out nocopy JTF_VARCHAR2_TABLE_300
246 , a36 out nocopy JTF_VARCHAR2_TABLE_300
247 , a37 out nocopy JTF_VARCHAR2_TABLE_300
248 , a38 out nocopy JTF_VARCHAR2_TABLE_300
249 , a39 out nocopy JTF_VARCHAR2_TABLE_300
250 , a40 out nocopy JTF_VARCHAR2_TABLE_300
251 , a41 out nocopy JTF_VARCHAR2_TABLE_300
252 , a42 out nocopy JTF_VARCHAR2_TABLE_300
253 , a43 out nocopy JTF_VARCHAR2_TABLE_300
254 , a44 out nocopy JTF_VARCHAR2_TABLE_300
255 , a45 out nocopy JTF_VARCHAR2_TABLE_300
256 , a46 out nocopy JTF_VARCHAR2_TABLE_300
257 , a47 out nocopy JTF_VARCHAR2_TABLE_300
258 , a48 out nocopy JTF_VARCHAR2_TABLE_300
259 , a49 out nocopy JTF_VARCHAR2_TABLE_300
260 );
261
262 procedure rosetta_table_copy_in_p12(t out nocopy ozf_disc_line_pvt.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
263 , a1 JTF_NUMBER_TABLE
264 , a2 JTF_VARCHAR2_TABLE_100
265 , a3 JTF_NUMBER_TABLE
266 , a4 JTF_VARCHAR2_TABLE_100
267 , a5 JTF_VARCHAR2_TABLE_100
268 , a6 JTF_DATE_TABLE
269 , a7 JTF_DATE_TABLE
270 , a8 JTF_NUMBER_TABLE
271 , a9 JTF_NUMBER_TABLE
272 , a10 JTF_DATE_TABLE
273 , a11 JTF_NUMBER_TABLE
274 , a12 JTF_DATE_TABLE
275 , a13 JTF_NUMBER_TABLE
276 , a14 JTF_NUMBER_TABLE
277 , a15 JTF_NUMBER_TABLE
278 );
279 procedure rosetta_table_copy_out_p12(t ozf_disc_line_pvt.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280 , a1 out nocopy JTF_NUMBER_TABLE
281 , a2 out nocopy JTF_VARCHAR2_TABLE_100
282 , a3 out nocopy JTF_NUMBER_TABLE
283 , a4 out nocopy JTF_VARCHAR2_TABLE_100
284 , a5 out nocopy JTF_VARCHAR2_TABLE_100
285 , a6 out nocopy JTF_DATE_TABLE
286 , a7 out nocopy JTF_DATE_TABLE
287 , a8 out nocopy JTF_NUMBER_TABLE
288 , a9 out nocopy JTF_NUMBER_TABLE
289 , a10 out nocopy JTF_DATE_TABLE
290 , a11 out nocopy JTF_NUMBER_TABLE
291 , a12 out nocopy JTF_DATE_TABLE
292 , a13 out nocopy JTF_NUMBER_TABLE
293 , a14 out nocopy JTF_NUMBER_TABLE
294 , a15 out nocopy JTF_NUMBER_TABLE
295 );
296
297 procedure rosetta_table_copy_in_p15(t out nocopy ozf_disc_line_pvt.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
298 , a1 JTF_NUMBER_TABLE
299 , a2 JTF_VARCHAR2_TABLE_100
300 , a3 JTF_NUMBER_TABLE
301 , a4 JTF_NUMBER_TABLE
302 , a5 JTF_DATE_TABLE
303 , a6 JTF_DATE_TABLE
304 );
305 procedure rosetta_table_copy_out_p15(t ozf_disc_line_pvt.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
306 , a1 out nocopy JTF_NUMBER_TABLE
307 , a2 out nocopy JTF_VARCHAR2_TABLE_100
308 , a3 out nocopy JTF_NUMBER_TABLE
309 , a4 out nocopy JTF_NUMBER_TABLE
310 , a5 out nocopy JTF_DATE_TABLE
311 , a6 out nocopy JTF_DATE_TABLE
312 );
313
314 procedure rosetta_table_copy_in_p18(t out nocopy ozf_disc_line_pvt.prod_reln_tbl_type, a0 JTF_NUMBER_TABLE
315 , a1 JTF_NUMBER_TABLE
316 , a2 JTF_NUMBER_TABLE
317 , a3 JTF_DATE_TABLE
318 , a4 JTF_NUMBER_TABLE
319 , a5 JTF_DATE_TABLE
320 , a6 JTF_NUMBER_TABLE
321 , a7 JTF_NUMBER_TABLE
322 , a8 JTF_NUMBER_TABLE
323 );
324 procedure rosetta_table_copy_out_p18(t ozf_disc_line_pvt.prod_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
325 , a1 out nocopy JTF_NUMBER_TABLE
326 , a2 out nocopy JTF_NUMBER_TABLE
327 , a3 out nocopy JTF_DATE_TABLE
328 , a4 out nocopy JTF_NUMBER_TABLE
329 , a5 out nocopy JTF_DATE_TABLE
330 , a6 out nocopy JTF_NUMBER_TABLE
331 , a7 out nocopy JTF_NUMBER_TABLE
332 , a8 out nocopy JTF_NUMBER_TABLE
333 );
334
335 procedure create_discount_line(p_api_version_number NUMBER
336 , p_init_msg_list VARCHAR2
337 , p_commit VARCHAR2
338 , p_validation_level NUMBER
339 , x_return_status out nocopy VARCHAR2
340 , x_msg_count out nocopy NUMBER
341 , x_msg_data out nocopy VARCHAR2
342 , x_offer_discount_line_id out nocopy NUMBER
343 , p7_a0 NUMBER := 0-1962.0724
344 , p7_a1 NUMBER := 0-1962.0724
345 , p7_a2 NUMBER := 0-1962.0724
346 , p7_a3 NUMBER := 0-1962.0724
347 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
348 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
349 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
350 , p7_a7 NUMBER := 0-1962.0724
351 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
352 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
353 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
354 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
355 , p7_a12 NUMBER := 0-1962.0724
356 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
357 , p7_a14 NUMBER := 0-1962.0724
358 , p7_a15 NUMBER := 0-1962.0724
359 , p7_a16 NUMBER := 0-1962.0724
360 , p7_a17 NUMBER := 0-1962.0724
361 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
362 , p7_a19 DATE := fnd_api.g_miss_date
363 , p7_a20 DATE := fnd_api.g_miss_date
364 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
365 , p7_a22 DATE := fnd_api.g_miss_date
366 , p7_a23 NUMBER := 0-1962.0724
367 , p7_a24 DATE := fnd_api.g_miss_date
368 , p7_a25 NUMBER := 0-1962.0724
369 , p7_a26 NUMBER := 0-1962.0724
370 , p7_a27 NUMBER := 0-1962.0724
371 , p7_a28 NUMBER := 0-1962.0724
372 , p7_a29 NUMBER := 0-1962.0724
373 , p7_a30 NUMBER := 0-1962.0724
374 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
375 , p7_a32 NUMBER := 0-1962.0724
376 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
377 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
378 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
379 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
380 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
381 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
382 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
383 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
384 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
385 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
386 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
387 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
388 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
389 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
390 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
391 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
392 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
393 );
394 procedure update_discount_line(p_api_version_number NUMBER
395 , p_init_msg_list VARCHAR2
396 , p_commit VARCHAR2
397 , p_validation_level NUMBER
398 , x_return_status out nocopy VARCHAR2
399 , x_msg_count out nocopy NUMBER
400 , x_msg_data out nocopy VARCHAR2
401 , p7_a0 NUMBER := 0-1962.0724
402 , p7_a1 NUMBER := 0-1962.0724
403 , p7_a2 NUMBER := 0-1962.0724
404 , p7_a3 NUMBER := 0-1962.0724
405 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
406 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
407 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
408 , p7_a7 NUMBER := 0-1962.0724
409 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
410 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
411 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
412 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
413 , p7_a12 NUMBER := 0-1962.0724
414 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
415 , p7_a14 NUMBER := 0-1962.0724
416 , p7_a15 NUMBER := 0-1962.0724
417 , p7_a16 NUMBER := 0-1962.0724
418 , p7_a17 NUMBER := 0-1962.0724
419 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
420 , p7_a19 DATE := fnd_api.g_miss_date
421 , p7_a20 DATE := fnd_api.g_miss_date
422 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
423 , p7_a22 DATE := fnd_api.g_miss_date
424 , p7_a23 NUMBER := 0-1962.0724
425 , p7_a24 DATE := fnd_api.g_miss_date
426 , p7_a25 NUMBER := 0-1962.0724
427 , p7_a26 NUMBER := 0-1962.0724
428 , p7_a27 NUMBER := 0-1962.0724
429 , p7_a28 NUMBER := 0-1962.0724
430 , p7_a29 NUMBER := 0-1962.0724
431 , p7_a30 NUMBER := 0-1962.0724
432 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
433 , p7_a32 NUMBER := 0-1962.0724
434 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
435 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
436 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
437 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
438 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
439 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
440 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
441 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
442 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
443 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
444 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
445 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
446 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
447 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
448 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
449 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
450 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
451 );
452 procedure create_product_exclusion(p_api_version_number NUMBER
453 , p_init_msg_list VARCHAR2
454 , p_commit VARCHAR2
455 , p_validation_level NUMBER
456 , x_return_status out nocopy VARCHAR2
457 , x_msg_count out nocopy NUMBER
458 , x_msg_data out nocopy VARCHAR2
459 , x_off_discount_product_id out nocopy NUMBER
460 , p7_a0 NUMBER := 0-1962.0724
461 , p7_a1 NUMBER := 0-1962.0724
462 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
463 , p7_a3 NUMBER := 0-1962.0724
464 , p7_a4 NUMBER := 0-1962.0724
465 , p7_a5 DATE := fnd_api.g_miss_date
466 , p7_a6 DATE := fnd_api.g_miss_date
467 );
468 procedure update_product_exclusion(p_api_version_number NUMBER
469 , p_init_msg_list VARCHAR2
470 , p_commit VARCHAR2
471 , p_validation_level NUMBER
472 , x_return_status out nocopy VARCHAR2
473 , x_msg_count out nocopy NUMBER
474 , x_msg_data out nocopy VARCHAR2
475 , p7_a0 NUMBER := 0-1962.0724
476 , p7_a1 NUMBER := 0-1962.0724
477 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
478 , p7_a3 NUMBER := 0-1962.0724
479 , p7_a4 NUMBER := 0-1962.0724
480 , p7_a5 DATE := fnd_api.g_miss_date
481 , p7_a6 DATE := fnd_api.g_miss_date
482 );
483 procedure create_disc_tiers(p_api_version_number NUMBER
484 , p_init_msg_list VARCHAR2
485 , p_commit VARCHAR2
486 , p_validation_level NUMBER
487 , x_return_status out nocopy VARCHAR2
488 , x_msg_count out nocopy NUMBER
489 , x_msg_data out nocopy VARCHAR2
490 , x_offer_discount_line_id out nocopy NUMBER
491 , p7_a0 NUMBER := 0-1962.0724
492 , p7_a1 NUMBER := 0-1962.0724
493 , p7_a2 NUMBER := 0-1962.0724
494 , p7_a3 NUMBER := 0-1962.0724
495 , p7_a4 NUMBER := 0-1962.0724
496 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
497 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
498 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
499 , p7_a8 NUMBER := 0-1962.0724
500 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
501 , p7_a10 DATE := fnd_api.g_miss_date
502 , p7_a11 DATE := fnd_api.g_miss_date
503 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
504 , p7_a13 NUMBER := 0-1962.0724
505 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
506 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
507 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
508 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
509 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
510 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
511 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
512 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
513 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
514 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
515 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
516 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
517 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
518 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
519 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
520 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
521 );
522 procedure update_disc_tiers(p_api_version_number NUMBER
523 , p_init_msg_list VARCHAR2
524 , p_commit VARCHAR2
525 , p_validation_level NUMBER
526 , x_return_status out nocopy VARCHAR2
527 , x_msg_count out nocopy NUMBER
528 , x_msg_data out nocopy VARCHAR2
529 , p7_a0 NUMBER := 0-1962.0724
530 , p7_a1 NUMBER := 0-1962.0724
531 , p7_a2 NUMBER := 0-1962.0724
532 , p7_a3 NUMBER := 0-1962.0724
533 , p7_a4 NUMBER := 0-1962.0724
534 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
535 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
536 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
537 , p7_a8 NUMBER := 0-1962.0724
538 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
539 , p7_a10 DATE := fnd_api.g_miss_date
540 , p7_a11 DATE := fnd_api.g_miss_date
541 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
542 , p7_a13 NUMBER := 0-1962.0724
543 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
544 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
545 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
546 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
547 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
548 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
549 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
550 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
551 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
552 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
553 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
554 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
555 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
556 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
557 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
558 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
559 );
560 procedure create_ozf_prod_line(p_api_version_number NUMBER
561 , p_init_msg_list VARCHAR2
562 , p_commit VARCHAR2
563 , p_validation_level NUMBER
564 , x_return_status out nocopy VARCHAR2
565 , x_msg_count out nocopy NUMBER
566 , x_msg_data out nocopy VARCHAR2
567 , x_off_discount_product_id out nocopy NUMBER
568 , p7_a0 NUMBER := 0-1962.0724
569 , p7_a1 NUMBER := 0-1962.0724
570 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
571 , p7_a3 NUMBER := 0-1962.0724
572 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
573 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
574 , p7_a6 DATE := fnd_api.g_miss_date
575 , p7_a7 DATE := fnd_api.g_miss_date
576 , p7_a8 NUMBER := 0-1962.0724
577 , p7_a9 NUMBER := 0-1962.0724
578 , p7_a10 DATE := fnd_api.g_miss_date
579 , p7_a11 NUMBER := 0-1962.0724
580 , p7_a12 DATE := fnd_api.g_miss_date
581 , p7_a13 NUMBER := 0-1962.0724
582 , p7_a14 NUMBER := 0-1962.0724
583 , p7_a15 NUMBER := 0-1962.0724
584 );
585 procedure update_ozf_prod_line(p_api_version_number NUMBER
586 , p_init_msg_list VARCHAR2
587 , p_commit VARCHAR2
588 , p_validation_level NUMBER
589 , x_return_status out nocopy VARCHAR2
590 , x_msg_count out nocopy NUMBER
591 , x_msg_data out nocopy VARCHAR2
592 , p7_a0 NUMBER := 0-1962.0724
593 , p7_a1 NUMBER := 0-1962.0724
594 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
595 , p7_a3 NUMBER := 0-1962.0724
596 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
597 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
598 , p7_a6 DATE := fnd_api.g_miss_date
599 , p7_a7 DATE := fnd_api.g_miss_date
600 , p7_a8 NUMBER := 0-1962.0724
601 , p7_a9 NUMBER := 0-1962.0724
602 , p7_a10 DATE := fnd_api.g_miss_date
603 , p7_a11 NUMBER := 0-1962.0724
604 , p7_a12 DATE := fnd_api.g_miss_date
605 , p7_a13 NUMBER := 0-1962.0724
606 , p7_a14 NUMBER := 0-1962.0724
607 , p7_a15 NUMBER := 0-1962.0724
608 );
609 end ozf_disc_line_pvt_w;