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