[Home] [Help]
PACKAGE: APPS.OZF_OFFER_PVT_W
Source
1 package ozf_offer_pvt_w AUTHID CURRENT_USER as
2 /* $Header: ozfwofrs.pls 120.14 2011/03/14 05:13:57 nirprasa ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 );
8 procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
9 , a1 out nocopy JTF_NUMBER_TABLE
10 , a2 out nocopy JTF_NUMBER_TABLE
11 , a3 out nocopy JTF_NUMBER_TABLE
12 );
13
14 procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
15 , a1 JTF_VARCHAR2_TABLE_100
16 , a2 JTF_NUMBER_TABLE
17 , a3 JTF_VARCHAR2_TABLE_100
18 , a4 JTF_NUMBER_TABLE
19 , a5 JTF_VARCHAR2_TABLE_100
20 , a6 JTF_NUMBER_TABLE
21 , a7 JTF_DATE_TABLE
22 , a8 JTF_DATE_TABLE
23 , a9 JTF_VARCHAR2_TABLE_100
24 , a10 JTF_VARCHAR2_TABLE_100
25 , a11 JTF_NUMBER_TABLE
26 , a12 JTF_VARCHAR2_TABLE_100
27 , a13 JTF_NUMBER_TABLE
28 , a14 JTF_NUMBER_TABLE
29 , a15 JTF_VARCHAR2_TABLE_100
30 , a16 JTF_NUMBER_TABLE
31 , a17 JTF_VARCHAR2_TABLE_100
32 , a18 JTF_NUMBER_TABLE
33 , a19 JTF_NUMBER_TABLE
34 , a20 JTF_NUMBER_TABLE
35 , a21 JTF_NUMBER_TABLE
36 , a22 JTF_VARCHAR2_TABLE_100
37 , a23 JTF_VARCHAR2_TABLE_100
38 , a24 JTF_VARCHAR2_TABLE_100
39 , a25 JTF_VARCHAR2_TABLE_300
40 , a26 JTF_VARCHAR2_TABLE_100
41 , a27 JTF_NUMBER_TABLE
42 , a28 JTF_VARCHAR2_TABLE_100
43 , a29 JTF_VARCHAR2_TABLE_100
44 , a30 JTF_VARCHAR2_TABLE_300
45 , a31 JTF_VARCHAR2_TABLE_100
46 , a32 JTF_VARCHAR2_TABLE_100
47 , a33 JTF_VARCHAR2_TABLE_100
48 , a34 JTF_VARCHAR2_TABLE_300
49 , a35 JTF_VARCHAR2_TABLE_300
50 , a36 JTF_VARCHAR2_TABLE_100
51 , a37 JTF_VARCHAR2_TABLE_300
52 , a38 JTF_VARCHAR2_TABLE_300
53 , a39 JTF_NUMBER_TABLE
54 , a40 JTF_VARCHAR2_TABLE_2000
55 , a41 JTF_VARCHAR2_TABLE_100
56 , a42 JTF_VARCHAR2_TABLE_300
57 , a43 JTF_VARCHAR2_TABLE_300
58 , a44 JTF_VARCHAR2_TABLE_300
59 , a45 JTF_VARCHAR2_TABLE_300
60 , a46 JTF_VARCHAR2_TABLE_300
61 , a47 JTF_VARCHAR2_TABLE_300
62 , a48 JTF_VARCHAR2_TABLE_300
63 , a49 JTF_VARCHAR2_TABLE_300
64 , a50 JTF_VARCHAR2_TABLE_300
65 , a51 JTF_VARCHAR2_TABLE_300
66 , a52 JTF_VARCHAR2_TABLE_300
67 , a53 JTF_VARCHAR2_TABLE_300
68 , a54 JTF_VARCHAR2_TABLE_300
69 , a55 JTF_VARCHAR2_TABLE_300
70 , a56 JTF_VARCHAR2_TABLE_300
71 , a57 JTF_NUMBER_TABLE
72 , a58 JTF_NUMBER_TABLE
73 , a59 JTF_NUMBER_TABLE
74 , a60 JTF_NUMBER_TABLE
75 , a61 JTF_NUMBER_TABLE
76 , a62 JTF_NUMBER_TABLE
77 , a63 JTF_NUMBER_TABLE
78 , a64 JTF_NUMBER_TABLE
79 , a65 JTF_NUMBER_TABLE
80 , a66 JTF_NUMBER_TABLE
81 , a67 JTF_VARCHAR2_TABLE_100
82 , a68 JTF_NUMBER_TABLE
83 , a69 JTF_NUMBER_TABLE
84 , a70 JTF_VARCHAR2_TABLE_300
85 , a71 JTF_VARCHAR2_TABLE_300
86 , a72 JTF_VARCHAR2_TABLE_300
87 );
88 procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
89 , a1 out nocopy JTF_VARCHAR2_TABLE_100
90 , a2 out nocopy JTF_NUMBER_TABLE
91 , a3 out nocopy JTF_VARCHAR2_TABLE_100
92 , a4 out nocopy JTF_NUMBER_TABLE
93 , a5 out nocopy JTF_VARCHAR2_TABLE_100
94 , a6 out nocopy JTF_NUMBER_TABLE
95 , a7 out nocopy JTF_DATE_TABLE
96 , a8 out nocopy JTF_DATE_TABLE
97 , a9 out nocopy JTF_VARCHAR2_TABLE_100
98 , a10 out nocopy JTF_VARCHAR2_TABLE_100
99 , a11 out nocopy JTF_NUMBER_TABLE
100 , a12 out nocopy JTF_VARCHAR2_TABLE_100
101 , a13 out nocopy JTF_NUMBER_TABLE
102 , a14 out nocopy JTF_NUMBER_TABLE
103 , a15 out nocopy JTF_VARCHAR2_TABLE_100
104 , a16 out nocopy JTF_NUMBER_TABLE
105 , a17 out nocopy JTF_VARCHAR2_TABLE_100
106 , a18 out nocopy JTF_NUMBER_TABLE
107 , a19 out nocopy JTF_NUMBER_TABLE
108 , a20 out nocopy JTF_NUMBER_TABLE
109 , a21 out nocopy JTF_NUMBER_TABLE
110 , a22 out nocopy JTF_VARCHAR2_TABLE_100
111 , a23 out nocopy JTF_VARCHAR2_TABLE_100
112 , a24 out nocopy JTF_VARCHAR2_TABLE_100
113 , a25 out nocopy JTF_VARCHAR2_TABLE_300
114 , a26 out nocopy JTF_VARCHAR2_TABLE_100
115 , a27 out nocopy JTF_NUMBER_TABLE
116 , a28 out nocopy JTF_VARCHAR2_TABLE_100
117 , a29 out nocopy JTF_VARCHAR2_TABLE_100
118 , a30 out nocopy JTF_VARCHAR2_TABLE_300
119 , a31 out nocopy JTF_VARCHAR2_TABLE_100
120 , a32 out nocopy JTF_VARCHAR2_TABLE_100
121 , a33 out nocopy JTF_VARCHAR2_TABLE_100
122 , a34 out nocopy JTF_VARCHAR2_TABLE_300
123 , a35 out nocopy JTF_VARCHAR2_TABLE_300
124 , a36 out nocopy JTF_VARCHAR2_TABLE_100
125 , a37 out nocopy JTF_VARCHAR2_TABLE_300
126 , a38 out nocopy JTF_VARCHAR2_TABLE_300
127 , a39 out nocopy JTF_NUMBER_TABLE
128 , a40 out nocopy JTF_VARCHAR2_TABLE_2000
129 , a41 out nocopy JTF_VARCHAR2_TABLE_100
130 , a42 out nocopy JTF_VARCHAR2_TABLE_300
131 , a43 out nocopy JTF_VARCHAR2_TABLE_300
132 , a44 out nocopy JTF_VARCHAR2_TABLE_300
133 , a45 out nocopy JTF_VARCHAR2_TABLE_300
134 , a46 out nocopy JTF_VARCHAR2_TABLE_300
135 , a47 out nocopy JTF_VARCHAR2_TABLE_300
136 , a48 out nocopy JTF_VARCHAR2_TABLE_300
137 , a49 out nocopy JTF_VARCHAR2_TABLE_300
138 , a50 out nocopy JTF_VARCHAR2_TABLE_300
139 , a51 out nocopy JTF_VARCHAR2_TABLE_300
140 , a52 out nocopy JTF_VARCHAR2_TABLE_300
141 , a53 out nocopy JTF_VARCHAR2_TABLE_300
142 , a54 out nocopy JTF_VARCHAR2_TABLE_300
143 , a55 out nocopy JTF_VARCHAR2_TABLE_300
144 , a56 out nocopy JTF_VARCHAR2_TABLE_300
145 , a57 out nocopy JTF_NUMBER_TABLE
146 , a58 out nocopy JTF_NUMBER_TABLE
147 , a59 out nocopy JTF_NUMBER_TABLE
148 , a60 out nocopy JTF_NUMBER_TABLE
149 , a61 out nocopy JTF_NUMBER_TABLE
150 , a62 out nocopy JTF_NUMBER_TABLE
151 , a63 out nocopy JTF_NUMBER_TABLE
152 , a64 out nocopy JTF_NUMBER_TABLE
153 , a65 out nocopy JTF_NUMBER_TABLE
154 , a66 out nocopy JTF_NUMBER_TABLE
155 , a67 out nocopy JTF_VARCHAR2_TABLE_100
156 , a68 out nocopy JTF_NUMBER_TABLE
157 , a69 out nocopy JTF_NUMBER_TABLE
158 , a70 out nocopy JTF_VARCHAR2_TABLE_300
159 , a71 out nocopy JTF_VARCHAR2_TABLE_300
160 , a72 out nocopy JTF_VARCHAR2_TABLE_300
161 );
162
163 procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
164 , a1 JTF_VARCHAR2_TABLE_100
165 , a2 JTF_NUMBER_TABLE
166 , a3 JTF_VARCHAR2_TABLE_100
167 , a4 JTF_VARCHAR2_TABLE_100
168 , a5 JTF_VARCHAR2_TABLE_300
169 , a6 JTF_VARCHAR2_TABLE_100
170 , a7 JTF_VARCHAR2_TABLE_100
171 , a8 JTF_VARCHAR2_TABLE_100
172 , a9 JTF_VARCHAR2_TABLE_300
173 , a10 JTF_VARCHAR2_TABLE_300
174 , a11 JTF_NUMBER_TABLE
175 , a12 JTF_VARCHAR2_TABLE_100
176 );
177 procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178 , a1 out nocopy JTF_VARCHAR2_TABLE_100
179 , a2 out nocopy JTF_NUMBER_TABLE
180 , a3 out nocopy JTF_VARCHAR2_TABLE_100
181 , a4 out nocopy JTF_VARCHAR2_TABLE_100
182 , a5 out nocopy JTF_VARCHAR2_TABLE_300
183 , a6 out nocopy JTF_VARCHAR2_TABLE_100
184 , a7 out nocopy JTF_VARCHAR2_TABLE_100
185 , a8 out nocopy JTF_VARCHAR2_TABLE_100
186 , a9 out nocopy JTF_VARCHAR2_TABLE_300
187 , a10 out nocopy JTF_VARCHAR2_TABLE_300
188 , a11 out nocopy JTF_NUMBER_TABLE
189 , a12 out nocopy JTF_VARCHAR2_TABLE_100
190 );
191
192 procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
193 , a1 JTF_VARCHAR2_TABLE_100
194 , a2 JTF_VARCHAR2_TABLE_300
195 , a3 JTF_VARCHAR2_TABLE_300
196 , a4 JTF_VARCHAR2_TABLE_100
197 , a5 JTF_NUMBER_TABLE
198 , a6 JTF_NUMBER_TABLE
199 , a7 JTF_NUMBER_TABLE
200 , a8 JTF_NUMBER_TABLE
201 , a9 JTF_DATE_TABLE
202 , a10 JTF_DATE_TABLE
203 , a11 JTF_NUMBER_TABLE
204 , a12 JTF_VARCHAR2_TABLE_100
205 , a13 JTF_VARCHAR2_TABLE_100
206 , a14 JTF_VARCHAR2_TABLE_300
207 , a15 JTF_VARCHAR2_TABLE_300
208 , a16 JTF_VARCHAR2_TABLE_300
209 , a17 JTF_VARCHAR2_TABLE_300
210 , a18 JTF_VARCHAR2_TABLE_300
211 , a19 JTF_VARCHAR2_TABLE_300
212 , a20 JTF_VARCHAR2_TABLE_300
213 , a21 JTF_VARCHAR2_TABLE_300
214 , a22 JTF_VARCHAR2_TABLE_300
215 , a23 JTF_VARCHAR2_TABLE_300
216 , a24 JTF_VARCHAR2_TABLE_300
217 , a25 JTF_VARCHAR2_TABLE_300
218 , a26 JTF_VARCHAR2_TABLE_300
219 , a27 JTF_VARCHAR2_TABLE_300
220 , a28 JTF_VARCHAR2_TABLE_300
221 );
222 procedure rosetta_table_copy_out_p8(t ozf_offer_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
223 , a1 out nocopy JTF_VARCHAR2_TABLE_100
224 , a2 out nocopy JTF_VARCHAR2_TABLE_300
225 , a3 out nocopy JTF_VARCHAR2_TABLE_300
226 , a4 out nocopy JTF_VARCHAR2_TABLE_100
227 , a5 out nocopy JTF_NUMBER_TABLE
228 , a6 out nocopy JTF_NUMBER_TABLE
229 , a7 out nocopy JTF_NUMBER_TABLE
230 , a8 out nocopy JTF_NUMBER_TABLE
231 , a9 out nocopy JTF_DATE_TABLE
232 , a10 out nocopy JTF_DATE_TABLE
233 , a11 out nocopy JTF_NUMBER_TABLE
234 , a12 out nocopy JTF_VARCHAR2_TABLE_100
235 , a13 out nocopy JTF_VARCHAR2_TABLE_100
236 , a14 out nocopy JTF_VARCHAR2_TABLE_300
237 , a15 out nocopy JTF_VARCHAR2_TABLE_300
238 , a16 out nocopy JTF_VARCHAR2_TABLE_300
239 , a17 out nocopy JTF_VARCHAR2_TABLE_300
240 , a18 out nocopy JTF_VARCHAR2_TABLE_300
241 , a19 out nocopy JTF_VARCHAR2_TABLE_300
242 , a20 out nocopy JTF_VARCHAR2_TABLE_300
243 , a21 out nocopy JTF_VARCHAR2_TABLE_300
244 , a22 out nocopy JTF_VARCHAR2_TABLE_300
245 , a23 out nocopy JTF_VARCHAR2_TABLE_300
246 , a24 out nocopy JTF_VARCHAR2_TABLE_300
247 , a25 out nocopy JTF_VARCHAR2_TABLE_300
248 , a26 out nocopy JTF_VARCHAR2_TABLE_300
249 , a27 out nocopy JTF_VARCHAR2_TABLE_300
250 , a28 out nocopy JTF_VARCHAR2_TABLE_300
251 );
252
253 procedure process_modifiers(p_init_msg_list VARCHAR2
254 , p_api_version NUMBER
255 , p_commit VARCHAR2
256 , x_return_status out nocopy VARCHAR2
257 , x_msg_count out nocopy NUMBER
258 , x_msg_data out nocopy VARCHAR2
259 , p_offer_type VARCHAR2
260 , p8_a0 JTF_VARCHAR2_TABLE_100
261 , p8_a1 JTF_VARCHAR2_TABLE_100
262 , p8_a2 JTF_NUMBER_TABLE
263 , p8_a3 JTF_VARCHAR2_TABLE_100
264 , p8_a4 JTF_NUMBER_TABLE
265 , p8_a5 JTF_VARCHAR2_TABLE_100
266 , p8_a6 JTF_NUMBER_TABLE
267 , p8_a7 JTF_DATE_TABLE
268 , p8_a8 JTF_DATE_TABLE
269 , p8_a9 JTF_VARCHAR2_TABLE_100
270 , p8_a10 JTF_VARCHAR2_TABLE_100
271 , p8_a11 JTF_NUMBER_TABLE
272 , p8_a12 JTF_VARCHAR2_TABLE_100
273 , p8_a13 JTF_NUMBER_TABLE
274 , p8_a14 JTF_NUMBER_TABLE
275 , p8_a15 JTF_VARCHAR2_TABLE_100
276 , p8_a16 JTF_NUMBER_TABLE
277 , p8_a17 JTF_VARCHAR2_TABLE_100
278 , p8_a18 JTF_NUMBER_TABLE
279 , p8_a19 JTF_NUMBER_TABLE
280 , p8_a20 JTF_NUMBER_TABLE
281 , p8_a21 JTF_NUMBER_TABLE
282 , p8_a22 JTF_VARCHAR2_TABLE_100
283 , p8_a23 JTF_VARCHAR2_TABLE_100
284 , p8_a24 JTF_VARCHAR2_TABLE_100
285 , p8_a25 JTF_VARCHAR2_TABLE_300
286 , p8_a26 JTF_VARCHAR2_TABLE_100
287 , p8_a27 JTF_NUMBER_TABLE
288 , p8_a28 JTF_VARCHAR2_TABLE_100
289 , p8_a29 JTF_VARCHAR2_TABLE_100
290 , p8_a30 JTF_VARCHAR2_TABLE_300
291 , p8_a31 JTF_VARCHAR2_TABLE_100
292 , p8_a32 JTF_VARCHAR2_TABLE_100
293 , p8_a33 JTF_VARCHAR2_TABLE_100
294 , p8_a34 JTF_VARCHAR2_TABLE_300
295 , p8_a35 JTF_VARCHAR2_TABLE_300
296 , p8_a36 JTF_VARCHAR2_TABLE_100
297 , p8_a37 JTF_VARCHAR2_TABLE_300
298 , p8_a38 JTF_VARCHAR2_TABLE_300
299 , p8_a39 JTF_NUMBER_TABLE
300 , p8_a40 JTF_VARCHAR2_TABLE_2000
301 , p8_a41 JTF_VARCHAR2_TABLE_100
302 , p8_a42 JTF_VARCHAR2_TABLE_300
303 , p8_a43 JTF_VARCHAR2_TABLE_300
304 , p8_a44 JTF_VARCHAR2_TABLE_300
305 , p8_a45 JTF_VARCHAR2_TABLE_300
306 , p8_a46 JTF_VARCHAR2_TABLE_300
307 , p8_a47 JTF_VARCHAR2_TABLE_300
308 , p8_a48 JTF_VARCHAR2_TABLE_300
309 , p8_a49 JTF_VARCHAR2_TABLE_300
310 , p8_a50 JTF_VARCHAR2_TABLE_300
311 , p8_a51 JTF_VARCHAR2_TABLE_300
312 , p8_a52 JTF_VARCHAR2_TABLE_300
313 , p8_a53 JTF_VARCHAR2_TABLE_300
314 , p8_a54 JTF_VARCHAR2_TABLE_300
315 , p8_a55 JTF_VARCHAR2_TABLE_300
316 , p8_a56 JTF_VARCHAR2_TABLE_300
317 , p8_a57 JTF_NUMBER_TABLE
318 , p8_a58 JTF_NUMBER_TABLE
319 , p8_a59 JTF_NUMBER_TABLE
320 , p8_a60 JTF_NUMBER_TABLE
321 , p8_a61 JTF_NUMBER_TABLE
322 , p8_a62 JTF_NUMBER_TABLE
323 , p8_a63 JTF_NUMBER_TABLE
324 , p8_a64 JTF_NUMBER_TABLE
325 , p8_a65 JTF_NUMBER_TABLE
326 , p8_a66 JTF_NUMBER_TABLE
327 , p8_a67 JTF_VARCHAR2_TABLE_100
328 , p8_a68 JTF_NUMBER_TABLE
329 , p8_a69 JTF_NUMBER_TABLE
330 , p8_a70 JTF_VARCHAR2_TABLE_300
331 , p8_a71 JTF_VARCHAR2_TABLE_300
332 , p8_a72 JTF_VARCHAR2_TABLE_300
333 , x_qp_list_header_id out nocopy NUMBER
334 , x_error_location out nocopy NUMBER
335 , p7_a0 NUMBER := 0-1962.0724
336 , p7_a1 NUMBER := 0-1962.0724
337 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
338 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
339 , p7_a4 NUMBER := 0-1962.0724
340 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
341 , p7_a6 NUMBER := 0-1962.0724
342 , p7_a7 NUMBER := 0-1962.0724
343 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
344 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
345 , p7_a10 NUMBER := 0-1962.0724
346 , p7_a11 NUMBER := 0-1962.0724
347 , p7_a12 DATE := fnd_api.g_miss_date
348 , p7_a13 DATE := fnd_api.g_miss_date
349 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
350 , p7_a15 DATE := fnd_api.g_miss_date
351 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
352 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
353 , p7_a18 NUMBER := 0-1962.0724
354 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
355 , p7_a20 NUMBER := 0-1962.0724
356 , p7_a21 NUMBER := 0-1962.0724
357 , p7_a22 NUMBER := 0-1962.0724
358 , p7_a23 NUMBER := 0-1962.0724
359 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
360 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
361 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
362 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
363 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
364 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
365 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
366 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
367 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
368 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
369 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
370 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
371 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
372 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
373 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
374 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
375 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
376 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
377 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
378 , p7_a43 DATE := fnd_api.g_miss_date
379 , p7_a44 DATE := fnd_api.g_miss_date
380 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
381 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
382 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
383 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
384 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
385 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
386 , p7_a51 DATE := fnd_api.g_miss_date
387 , p7_a52 DATE := fnd_api.g_miss_date
388 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
389 , p7_a54 DATE := fnd_api.g_miss_date
390 , p7_a55 DATE := fnd_api.g_miss_date
391 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
392 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
393 , p7_a58 NUMBER := 0-1962.0724
394 , p7_a59 NUMBER := 0-1962.0724
395 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
396 , p7_a61 NUMBER := 0-1962.0724
397 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
398 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
399 , p7_a64 NUMBER := 0-1962.0724
400 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
401 , p7_a66 NUMBER := 0-1962.0724
402 , p7_a67 NUMBER := 0-1962.0724
403 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
404 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
405 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
406 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
407 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
408 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
409 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
410 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
411 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
412 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
413 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
414 , p7_a79 NUMBER := 0-1962.0724
415 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
416 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
417 , p7_a82 NUMBER := 0-1962.0724
418 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
419 , p7_a84 NUMBER := 0-1962.0724
420 , p7_a85 NUMBER := 0-1962.0724
421 );
422 procedure create_offer_tiers(p_init_msg_list VARCHAR2
423 , p_api_version NUMBER
424 , p_commit VARCHAR2
425 , x_return_status out nocopy VARCHAR2
426 , x_msg_count out nocopy NUMBER
427 , x_msg_data out nocopy VARCHAR2
428 , p6_a0 JTF_VARCHAR2_TABLE_100
429 , p6_a1 JTF_VARCHAR2_TABLE_100
430 , p6_a2 JTF_NUMBER_TABLE
431 , p6_a3 JTF_VARCHAR2_TABLE_100
432 , p6_a4 JTF_NUMBER_TABLE
433 , p6_a5 JTF_VARCHAR2_TABLE_100
434 , p6_a6 JTF_NUMBER_TABLE
435 , p6_a7 JTF_DATE_TABLE
436 , p6_a8 JTF_DATE_TABLE
437 , p6_a9 JTF_VARCHAR2_TABLE_100
438 , p6_a10 JTF_VARCHAR2_TABLE_100
439 , p6_a11 JTF_NUMBER_TABLE
440 , p6_a12 JTF_VARCHAR2_TABLE_100
441 , p6_a13 JTF_NUMBER_TABLE
442 , p6_a14 JTF_NUMBER_TABLE
443 , p6_a15 JTF_VARCHAR2_TABLE_100
444 , p6_a16 JTF_NUMBER_TABLE
445 , p6_a17 JTF_VARCHAR2_TABLE_100
446 , p6_a18 JTF_NUMBER_TABLE
447 , p6_a19 JTF_NUMBER_TABLE
448 , p6_a20 JTF_NUMBER_TABLE
449 , p6_a21 JTF_NUMBER_TABLE
450 , p6_a22 JTF_VARCHAR2_TABLE_100
451 , p6_a23 JTF_VARCHAR2_TABLE_100
452 , p6_a24 JTF_VARCHAR2_TABLE_100
453 , p6_a25 JTF_VARCHAR2_TABLE_300
454 , p6_a26 JTF_VARCHAR2_TABLE_100
455 , p6_a27 JTF_NUMBER_TABLE
456 , p6_a28 JTF_VARCHAR2_TABLE_100
457 , p6_a29 JTF_VARCHAR2_TABLE_100
458 , p6_a30 JTF_VARCHAR2_TABLE_300
459 , p6_a31 JTF_VARCHAR2_TABLE_100
460 , p6_a32 JTF_VARCHAR2_TABLE_100
461 , p6_a33 JTF_VARCHAR2_TABLE_100
462 , p6_a34 JTF_VARCHAR2_TABLE_300
463 , p6_a35 JTF_VARCHAR2_TABLE_300
464 , p6_a36 JTF_VARCHAR2_TABLE_100
465 , p6_a37 JTF_VARCHAR2_TABLE_300
466 , p6_a38 JTF_VARCHAR2_TABLE_300
467 , p6_a39 JTF_NUMBER_TABLE
468 , p6_a40 JTF_VARCHAR2_TABLE_2000
469 , p6_a41 JTF_VARCHAR2_TABLE_100
470 , p6_a42 JTF_VARCHAR2_TABLE_300
471 , p6_a43 JTF_VARCHAR2_TABLE_300
472 , p6_a44 JTF_VARCHAR2_TABLE_300
473 , p6_a45 JTF_VARCHAR2_TABLE_300
474 , p6_a46 JTF_VARCHAR2_TABLE_300
475 , p6_a47 JTF_VARCHAR2_TABLE_300
476 , p6_a48 JTF_VARCHAR2_TABLE_300
477 , p6_a49 JTF_VARCHAR2_TABLE_300
478 , p6_a50 JTF_VARCHAR2_TABLE_300
479 , p6_a51 JTF_VARCHAR2_TABLE_300
480 , p6_a52 JTF_VARCHAR2_TABLE_300
481 , p6_a53 JTF_VARCHAR2_TABLE_300
482 , p6_a54 JTF_VARCHAR2_TABLE_300
483 , p6_a55 JTF_VARCHAR2_TABLE_300
484 , p6_a56 JTF_VARCHAR2_TABLE_300
485 , p6_a57 JTF_NUMBER_TABLE
486 , p6_a58 JTF_NUMBER_TABLE
487 , p6_a59 JTF_NUMBER_TABLE
488 , p6_a60 JTF_NUMBER_TABLE
489 , p6_a61 JTF_NUMBER_TABLE
490 , p6_a62 JTF_NUMBER_TABLE
491 , p6_a63 JTF_NUMBER_TABLE
492 , p6_a64 JTF_NUMBER_TABLE
493 , p6_a65 JTF_NUMBER_TABLE
494 , p6_a66 JTF_NUMBER_TABLE
495 , p6_a67 JTF_VARCHAR2_TABLE_100
496 , p6_a68 JTF_NUMBER_TABLE
497 , p6_a69 JTF_NUMBER_TABLE
498 , p6_a70 JTF_VARCHAR2_TABLE_300
499 , p6_a71 JTF_VARCHAR2_TABLE_300
500 , p6_a72 JTF_VARCHAR2_TABLE_300
501 , x_error_location out nocopy NUMBER
502 );
503 procedure process_market_qualifiers(p_init_msg_list VARCHAR2
504 , p_api_version NUMBER
505 , p_commit VARCHAR2
506 , x_return_status out nocopy VARCHAR2
507 , x_msg_count out nocopy NUMBER
508 , x_msg_data out nocopy VARCHAR2
509 , p6_a0 JTF_VARCHAR2_TABLE_100
510 , p6_a1 JTF_VARCHAR2_TABLE_100
511 , p6_a2 JTF_VARCHAR2_TABLE_300
512 , p6_a3 JTF_VARCHAR2_TABLE_300
513 , p6_a4 JTF_VARCHAR2_TABLE_100
514 , p6_a5 JTF_NUMBER_TABLE
515 , p6_a6 JTF_NUMBER_TABLE
516 , p6_a7 JTF_NUMBER_TABLE
517 , p6_a8 JTF_NUMBER_TABLE
518 , p6_a9 JTF_DATE_TABLE
519 , p6_a10 JTF_DATE_TABLE
520 , p6_a11 JTF_NUMBER_TABLE
521 , p6_a12 JTF_VARCHAR2_TABLE_100
522 , p6_a13 JTF_VARCHAR2_TABLE_100
523 , p6_a14 JTF_VARCHAR2_TABLE_300
524 , p6_a15 JTF_VARCHAR2_TABLE_300
525 , p6_a16 JTF_VARCHAR2_TABLE_300
526 , p6_a17 JTF_VARCHAR2_TABLE_300
527 , p6_a18 JTF_VARCHAR2_TABLE_300
528 , p6_a19 JTF_VARCHAR2_TABLE_300
529 , p6_a20 JTF_VARCHAR2_TABLE_300
530 , p6_a21 JTF_VARCHAR2_TABLE_300
531 , p6_a22 JTF_VARCHAR2_TABLE_300
532 , p6_a23 JTF_VARCHAR2_TABLE_300
533 , p6_a24 JTF_VARCHAR2_TABLE_300
534 , p6_a25 JTF_VARCHAR2_TABLE_300
535 , p6_a26 JTF_VARCHAR2_TABLE_300
536 , p6_a27 JTF_VARCHAR2_TABLE_300
537 , p6_a28 JTF_VARCHAR2_TABLE_300
538 , x_error_location out nocopy NUMBER
539 );
540 procedure process_exclusions(p_init_msg_list VARCHAR2
541 , p_api_version NUMBER
542 , p_commit VARCHAR2
543 , x_return_status out nocopy VARCHAR2
544 , x_msg_count out nocopy NUMBER
545 , x_msg_data out nocopy VARCHAR2
546 , p6_a0 JTF_NUMBER_TABLE
547 , p6_a1 JTF_VARCHAR2_TABLE_100
548 , p6_a2 JTF_NUMBER_TABLE
549 , p6_a3 JTF_VARCHAR2_TABLE_100
550 , p6_a4 JTF_VARCHAR2_TABLE_100
551 , p6_a5 JTF_VARCHAR2_TABLE_300
552 , p6_a6 JTF_VARCHAR2_TABLE_100
553 , p6_a7 JTF_VARCHAR2_TABLE_100
554 , p6_a8 JTF_VARCHAR2_TABLE_100
555 , p6_a9 JTF_VARCHAR2_TABLE_300
556 , p6_a10 JTF_VARCHAR2_TABLE_300
557 , p6_a11 JTF_NUMBER_TABLE
558 , p6_a12 JTF_VARCHAR2_TABLE_100
559 , x_error_location out nocopy NUMBER
560 );
561 procedure process_adv_options(p_init_msg_list VARCHAR2
562 , p_api_version NUMBER
563 , p_commit VARCHAR2
564 , x_return_status out nocopy VARCHAR2
565 , x_msg_count out nocopy NUMBER
566 , x_msg_data out nocopy VARCHAR2
567 , p6_a0 NUMBER := 0-1962.0724
568 , p6_a1 NUMBER := 0-1962.0724
569 , p6_a2 VARCHAR2 := fnd_api.g_miss_char
570 , p6_a3 VARCHAR2 := fnd_api.g_miss_char
571 , p6_a4 NUMBER := 0-1962.0724
572 , p6_a5 VARCHAR2 := fnd_api.g_miss_char
573 , p6_a6 NUMBER := 0-1962.0724
574 , p6_a7 NUMBER := 0-1962.0724
575 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
576 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
577 , p6_a10 NUMBER := 0-1962.0724
578 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
579 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
580 , p6_a13 NUMBER := 0-1962.0724
581 );
582 procedure activate_offer_over(p_init_msg_list VARCHAR2
583 , p_api_version NUMBER
584 , p_commit VARCHAR2
585 , x_return_status out nocopy VARCHAR2
586 , x_msg_count out nocopy NUMBER
587 , x_msg_data out nocopy VARCHAR2
588 , p_called_from VARCHAR2
589 , x_amount_error out nocopy VARCHAR2
590 , p7_a0 NUMBER := 0-1962.0724
591 , p7_a1 NUMBER := 0-1962.0724
592 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
593 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
594 , p7_a4 NUMBER := 0-1962.0724
595 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
596 , p7_a6 NUMBER := 0-1962.0724
597 , p7_a7 NUMBER := 0-1962.0724
598 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
599 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
600 , p7_a10 NUMBER := 0-1962.0724
601 , p7_a11 NUMBER := 0-1962.0724
602 , p7_a12 DATE := fnd_api.g_miss_date
603 , p7_a13 DATE := fnd_api.g_miss_date
604 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
605 , p7_a15 DATE := fnd_api.g_miss_date
606 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
607 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
608 , p7_a18 NUMBER := 0-1962.0724
609 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
610 , p7_a20 NUMBER := 0-1962.0724
611 , p7_a21 NUMBER := 0-1962.0724
612 , p7_a22 NUMBER := 0-1962.0724
613 , p7_a23 NUMBER := 0-1962.0724
614 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
615 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
616 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
617 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
618 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
619 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
620 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
621 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
622 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
623 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
624 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
625 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
626 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
627 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
628 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
629 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
630 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
631 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
632 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
633 , p7_a43 DATE := fnd_api.g_miss_date
634 , p7_a44 DATE := fnd_api.g_miss_date
635 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
636 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
637 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
638 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
639 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
640 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
641 , p7_a51 DATE := fnd_api.g_miss_date
642 , p7_a52 DATE := fnd_api.g_miss_date
643 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
644 , p7_a54 DATE := fnd_api.g_miss_date
645 , p7_a55 DATE := fnd_api.g_miss_date
646 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
647 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
648 , p7_a58 NUMBER := 0-1962.0724
649 , p7_a59 NUMBER := 0-1962.0724
650 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
651 , p7_a61 NUMBER := 0-1962.0724
652 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
653 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
654 , p7_a64 NUMBER := 0-1962.0724
655 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
656 , p7_a66 NUMBER := 0-1962.0724
657 , p7_a67 NUMBER := 0-1962.0724
658 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
659 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
660 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
661 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
662 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
663 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
664 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
665 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
666 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
667 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
668 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
669 , p7_a79 NUMBER := 0-1962.0724
670 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
671 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
672 , p7_a82 NUMBER := 0-1962.0724
673 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
674 , p7_a84 NUMBER := 0-1962.0724
675 , p7_a85 NUMBER := 0-1962.0724
676 );
677 procedure update_offer_status(p_commit VARCHAR2
678 , x_return_status out nocopy VARCHAR2
679 , x_msg_count out nocopy NUMBER
680 , x_msg_data out nocopy VARCHAR2
681 , p4_a0 NUMBER := 0-1962.0724
682 , p4_a1 NUMBER := 0-1962.0724
683 , p4_a2 VARCHAR2 := fnd_api.g_miss_char
684 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
685 , p4_a4 NUMBER := 0-1962.0724
686 , p4_a5 VARCHAR2 := fnd_api.g_miss_char
687 , p4_a6 NUMBER := 0-1962.0724
688 , p4_a7 NUMBER := 0-1962.0724
689 , p4_a8 VARCHAR2 := fnd_api.g_miss_char
690 , p4_a9 VARCHAR2 := fnd_api.g_miss_char
691 , p4_a10 NUMBER := 0-1962.0724
692 , p4_a11 NUMBER := 0-1962.0724
693 , p4_a12 DATE := fnd_api.g_miss_date
694 , p4_a13 DATE := fnd_api.g_miss_date
695 , p4_a14 VARCHAR2 := fnd_api.g_miss_char
696 , p4_a15 DATE := fnd_api.g_miss_date
697 , p4_a16 VARCHAR2 := fnd_api.g_miss_char
698 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
699 , p4_a18 NUMBER := 0-1962.0724
700 , p4_a19 VARCHAR2 := fnd_api.g_miss_char
701 , p4_a20 NUMBER := 0-1962.0724
702 , p4_a21 NUMBER := 0-1962.0724
703 , p4_a22 NUMBER := 0-1962.0724
704 , p4_a23 NUMBER := 0-1962.0724
705 , p4_a24 VARCHAR2 := fnd_api.g_miss_char
706 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
707 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
708 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
709 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
710 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
711 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
712 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
713 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
714 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
715 , p4_a34 VARCHAR2 := fnd_api.g_miss_char
716 , p4_a35 VARCHAR2 := fnd_api.g_miss_char
717 , p4_a36 VARCHAR2 := fnd_api.g_miss_char
718 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
719 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
720 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
721 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
722 , p4_a41 VARCHAR2 := fnd_api.g_miss_char
723 , p4_a42 VARCHAR2 := fnd_api.g_miss_char
724 , p4_a43 DATE := fnd_api.g_miss_date
725 , p4_a44 DATE := fnd_api.g_miss_date
726 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
727 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
728 , p4_a47 VARCHAR2 := fnd_api.g_miss_char
729 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
730 , p4_a49 VARCHAR2 := fnd_api.g_miss_char
731 , p4_a50 VARCHAR2 := fnd_api.g_miss_char
732 , p4_a51 DATE := fnd_api.g_miss_date
733 , p4_a52 DATE := fnd_api.g_miss_date
734 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
735 , p4_a54 DATE := fnd_api.g_miss_date
736 , p4_a55 DATE := fnd_api.g_miss_date
737 , p4_a56 VARCHAR2 := fnd_api.g_miss_char
738 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
739 , p4_a58 NUMBER := 0-1962.0724
740 , p4_a59 NUMBER := 0-1962.0724
741 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
742 , p4_a61 NUMBER := 0-1962.0724
743 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
744 , p4_a63 VARCHAR2 := fnd_api.g_miss_char
745 , p4_a64 NUMBER := 0-1962.0724
746 , p4_a65 VARCHAR2 := fnd_api.g_miss_char
747 , p4_a66 NUMBER := 0-1962.0724
748 , p4_a67 NUMBER := 0-1962.0724
749 , p4_a68 VARCHAR2 := fnd_api.g_miss_char
750 , p4_a69 VARCHAR2 := fnd_api.g_miss_char
751 , p4_a70 VARCHAR2 := fnd_api.g_miss_char
752 , p4_a71 VARCHAR2 := fnd_api.g_miss_char
753 , p4_a72 VARCHAR2 := fnd_api.g_miss_char
754 , p4_a73 VARCHAR2 := fnd_api.g_miss_char
755 , p4_a74 VARCHAR2 := fnd_api.g_miss_char
756 , p4_a75 VARCHAR2 := fnd_api.g_miss_char
757 , p4_a76 VARCHAR2 := fnd_api.g_miss_char
758 , p4_a77 VARCHAR2 := fnd_api.g_miss_char
759 , p4_a78 VARCHAR2 := fnd_api.g_miss_char
760 , p4_a79 NUMBER := 0-1962.0724
761 , p4_a80 VARCHAR2 := fnd_api.g_miss_char
762 , p4_a81 VARCHAR2 := fnd_api.g_miss_char
763 , p4_a82 NUMBER := 0-1962.0724
764 , p4_a83 VARCHAR2 := fnd_api.g_miss_char
765 , p4_a84 NUMBER := 0-1962.0724
766 , p4_a85 NUMBER := 0-1962.0724
767 );
768 procedure process_offer_activation(p_api_version_number NUMBER
769 , p_init_msg_list VARCHAR2
770 , p_commit VARCHAR2
771 , p_validation_level VARCHAR2
772 , x_return_status out nocopy VARCHAR2
773 , x_msg_count out nocopy NUMBER
774 , x_msg_data out nocopy VARCHAR2
775 , p7_a0 NUMBER := 0-1962.0724
776 , p7_a1 NUMBER := 0-1962.0724
777 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
778 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
779 , p7_a4 NUMBER := 0-1962.0724
780 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
781 , p7_a6 NUMBER := 0-1962.0724
782 , p7_a7 NUMBER := 0-1962.0724
783 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
784 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
785 , p7_a10 NUMBER := 0-1962.0724
786 , p7_a11 NUMBER := 0-1962.0724
787 , p7_a12 DATE := fnd_api.g_miss_date
788 , p7_a13 DATE := fnd_api.g_miss_date
789 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
790 , p7_a15 DATE := fnd_api.g_miss_date
791 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
792 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
793 , p7_a18 NUMBER := 0-1962.0724
794 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
795 , p7_a20 NUMBER := 0-1962.0724
796 , p7_a21 NUMBER := 0-1962.0724
797 , p7_a22 NUMBER := 0-1962.0724
798 , p7_a23 NUMBER := 0-1962.0724
799 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
800 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
801 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
802 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
803 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
804 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
805 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
806 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
807 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
808 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
809 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
810 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
811 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
812 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
813 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
814 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
815 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
816 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
817 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
818 , p7_a43 DATE := fnd_api.g_miss_date
819 , p7_a44 DATE := fnd_api.g_miss_date
820 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
821 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
822 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
823 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
824 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
825 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
826 , p7_a51 DATE := fnd_api.g_miss_date
827 , p7_a52 DATE := fnd_api.g_miss_date
828 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
829 , p7_a54 DATE := fnd_api.g_miss_date
830 , p7_a55 DATE := fnd_api.g_miss_date
831 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
832 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
833 , p7_a58 NUMBER := 0-1962.0724
834 , p7_a59 NUMBER := 0-1962.0724
835 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
836 , p7_a61 NUMBER := 0-1962.0724
837 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
838 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
839 , p7_a64 NUMBER := 0-1962.0724
840 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
841 , p7_a66 NUMBER := 0-1962.0724
842 , p7_a67 NUMBER := 0-1962.0724
843 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
844 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
845 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
846 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
847 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
848 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
849 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
850 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
851 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
852 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
853 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
854 , p7_a79 NUMBER := 0-1962.0724
855 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
856 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
857 , p7_a82 NUMBER := 0-1962.0724
858 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
859 , p7_a84 NUMBER := 0-1962.0724
860 , p7_a85 NUMBER := 0-1962.0724
861 );
862 end ozf_offer_pvt_w;