[Home] [Help]
PACKAGE BODY: APPS.OZF_OFFER_PVT_OA
Source
1 package body ozf_offer_pvt_oa as
2 /* $Header: ozfaofub.pls 120.2 2006/07/20 12:01:28 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 ) as
75 ddindx binary_integer; indx binary_integer;
76 begin
77 if a0 is not null and a0.count > 0 then
78 if a0.count > 0 then
79 indx := a0.first;
80 ddindx := 1;
81 while true loop
82 t(ddindx).offer_line_type := a0(indx);
83 t(ddindx).operation := a1(indx);
84 t(ddindx).list_line_id := a2(indx);
85 t(ddindx).list_header_id := a3(indx);
86 t(ddindx).list_line_type_code := a4(indx);
87 t(ddindx).operand := a5(indx);
88 t(ddindx).start_date_active := a6(indx);
89 t(ddindx).end_date_active := a7(indx);
90 t(ddindx).arithmetic_operator := a8(indx);
91 t(ddindx).inactive_flag := a9(indx);
92 t(ddindx).qd_operand := a10(indx);
93 t(ddindx).qd_arithmetic_operator := a11(indx);
94 t(ddindx).qd_related_deal_lines_id := a12(indx);
95 t(ddindx).qd_object_version_number := a13(indx);
96 t(ddindx).qd_estimated_qty_is_max := a14(indx);
97 t(ddindx).qd_list_line_id := a15(indx);
98 t(ddindx).qd_estimated_amount_is_max := a16(indx);
99 t(ddindx).estim_gl_value := a17(indx);
100 t(ddindx).benefit_price_list_line_id := a18(indx);
101 t(ddindx).benefit_limit := a19(indx);
102 t(ddindx).benefit_qty := a20(indx);
103 t(ddindx).benefit_uom_code := a21(indx);
104 t(ddindx).substitution_context := a22(indx);
105 t(ddindx).substitution_attr := a23(indx);
106 t(ddindx).substitution_val := a24(indx);
107 t(ddindx).price_break_type_code := a25(indx);
108 t(ddindx).pricing_attribute_id := a26(indx);
109 t(ddindx).product_attribute_context := a27(indx);
110 t(ddindx).product_attr := a28(indx);
111 t(ddindx).product_attr_val := a29(indx);
112 t(ddindx).product_uom_code := a30(indx);
113 t(ddindx).pricing_attribute_context := a31(indx);
114 t(ddindx).pricing_attr := a32(indx);
115 t(ddindx).pricing_attr_value_from := a33(indx);
116 t(ddindx).pricing_attr_value_to := a34(indx);
117 t(ddindx).excluder_flag := a35(indx);
118 t(ddindx).order_value_from := a36(indx);
119 t(ddindx).order_value_to := a37(indx);
120 t(ddindx).qualifier_id := a38(indx);
121 t(ddindx).comments := a39(indx);
122 t(ddindx).context := a40(indx);
123 t(ddindx).attribute1 := a41(indx);
124 t(ddindx).attribute2 := a42(indx);
125 t(ddindx).attribute3 := a43(indx);
126 t(ddindx).attribute4 := a44(indx);
127 t(ddindx).attribute5 := a45(indx);
128 t(ddindx).attribute6 := a46(indx);
129 t(ddindx).attribute7 := a47(indx);
130 t(ddindx).attribute8 := a48(indx);
131 t(ddindx).attribute9 := a49(indx);
132 t(ddindx).attribute10 := a50(indx);
133 t(ddindx).attribute11 := a51(indx);
134 t(ddindx).attribute12 := a52(indx);
135 t(ddindx).attribute13 := a53(indx);
136 t(ddindx).attribute14 := a54(indx);
137 t(ddindx).attribute15 := a55(indx);
138 t(ddindx).max_qty_per_order := a56(indx);
139 t(ddindx).max_qty_per_order_id := a57(indx);
140 t(ddindx).max_qty_per_customer := a58(indx);
141 t(ddindx).max_qty_per_customer_id := a59(indx);
142 t(ddindx).max_qty_per_rule := a60(indx);
143 t(ddindx).max_qty_per_rule_id := a61(indx);
144 t(ddindx).max_orders_per_customer := a62(indx);
145 t(ddindx).max_orders_per_customer_id := a63(indx);
146 t(ddindx).max_amount_per_rule := a64(indx);
147 t(ddindx).max_amount_per_rule_id := a65(indx);
148 t(ddindx).estimate_qty_uom := a66(indx);
149 t(ddindx).generate_using_formula_id := a67(indx);
150 t(ddindx).price_by_formula_id := a68(indx);
151 t(ddindx).generate_using_formula := a69(indx);
152 t(ddindx).price_by_formula := a70(indx);
153 ddindx := ddindx+1;
154 if a0.last =indx
155 then exit;
156 end if;
157 indx := a0.next(indx);
158 end loop;
159 end if;
160 end if;
161 end rosetta_table_copy_in_p2;
162 procedure rosetta_table_copy_out_p2(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
163 , a1 out nocopy JTF_VARCHAR2_TABLE_100
164 , a2 out nocopy JTF_NUMBER_TABLE
165 , a3 out nocopy JTF_NUMBER_TABLE
166 , a4 out nocopy JTF_VARCHAR2_TABLE_100
167 , a5 out nocopy JTF_NUMBER_TABLE
168 , a6 out nocopy JTF_DATE_TABLE
169 , a7 out nocopy JTF_DATE_TABLE
170 , a8 out nocopy JTF_VARCHAR2_TABLE_100
171 , a9 out nocopy JTF_VARCHAR2_TABLE_100
172 , a10 out nocopy JTF_NUMBER_TABLE
173 , a11 out nocopy JTF_VARCHAR2_TABLE_100
174 , a12 out nocopy JTF_NUMBER_TABLE
175 , a13 out nocopy JTF_NUMBER_TABLE
176 , a14 out nocopy JTF_VARCHAR2_TABLE_100
177 , a15 out nocopy JTF_NUMBER_TABLE
178 , a16 out nocopy JTF_VARCHAR2_TABLE_100
179 , a17 out nocopy JTF_NUMBER_TABLE
180 , a18 out nocopy JTF_NUMBER_TABLE
181 , a19 out nocopy JTF_NUMBER_TABLE
182 , a20 out nocopy JTF_NUMBER_TABLE
183 , a21 out nocopy JTF_VARCHAR2_TABLE_100
184 , a22 out nocopy JTF_VARCHAR2_TABLE_100
185 , a23 out nocopy JTF_VARCHAR2_TABLE_100
186 , a24 out nocopy JTF_VARCHAR2_TABLE_300
187 , a25 out nocopy JTF_VARCHAR2_TABLE_100
188 , a26 out nocopy JTF_NUMBER_TABLE
189 , a27 out nocopy JTF_VARCHAR2_TABLE_100
190 , a28 out nocopy JTF_VARCHAR2_TABLE_100
191 , a29 out nocopy JTF_VARCHAR2_TABLE_300
192 , a30 out nocopy JTF_VARCHAR2_TABLE_100
193 , a31 out nocopy JTF_VARCHAR2_TABLE_100
194 , a32 out nocopy JTF_VARCHAR2_TABLE_100
195 , a33 out nocopy JTF_VARCHAR2_TABLE_300
196 , a34 out nocopy JTF_VARCHAR2_TABLE_300
197 , a35 out nocopy JTF_VARCHAR2_TABLE_100
198 , a36 out nocopy JTF_VARCHAR2_TABLE_300
199 , a37 out nocopy JTF_VARCHAR2_TABLE_300
200 , a38 out nocopy JTF_NUMBER_TABLE
201 , a39 out nocopy JTF_VARCHAR2_TABLE_2000
202 , a40 out nocopy JTF_VARCHAR2_TABLE_100
203 , a41 out nocopy JTF_VARCHAR2_TABLE_300
204 , a42 out nocopy JTF_VARCHAR2_TABLE_300
205 , a43 out nocopy JTF_VARCHAR2_TABLE_300
206 , a44 out nocopy JTF_VARCHAR2_TABLE_300
207 , a45 out nocopy JTF_VARCHAR2_TABLE_300
208 , a46 out nocopy JTF_VARCHAR2_TABLE_300
209 , a47 out nocopy JTF_VARCHAR2_TABLE_300
210 , a48 out nocopy JTF_VARCHAR2_TABLE_300
211 , a49 out nocopy JTF_VARCHAR2_TABLE_300
212 , a50 out nocopy JTF_VARCHAR2_TABLE_300
213 , a51 out nocopy JTF_VARCHAR2_TABLE_300
214 , a52 out nocopy JTF_VARCHAR2_TABLE_300
215 , a53 out nocopy JTF_VARCHAR2_TABLE_300
216 , a54 out nocopy JTF_VARCHAR2_TABLE_300
217 , a55 out nocopy JTF_VARCHAR2_TABLE_300
218 , a56 out nocopy JTF_NUMBER_TABLE
219 , a57 out nocopy JTF_NUMBER_TABLE
220 , a58 out nocopy JTF_NUMBER_TABLE
221 , a59 out nocopy JTF_NUMBER_TABLE
222 , a60 out nocopy JTF_NUMBER_TABLE
223 , a61 out nocopy JTF_NUMBER_TABLE
224 , a62 out nocopy JTF_NUMBER_TABLE
225 , a63 out nocopy JTF_NUMBER_TABLE
226 , a64 out nocopy JTF_NUMBER_TABLE
227 , a65 out nocopy JTF_NUMBER_TABLE
228 , a66 out nocopy JTF_VARCHAR2_TABLE_100
229 , a67 out nocopy JTF_NUMBER_TABLE
230 , a68 out nocopy JTF_NUMBER_TABLE
231 , a69 out nocopy JTF_VARCHAR2_TABLE_300
232 , a70 out nocopy JTF_VARCHAR2_TABLE_300
233 ) as
234 ddindx binary_integer; indx binary_integer;
235 begin
236 if t is null or t.count = 0 then
237 a0 := JTF_VARCHAR2_TABLE_100();
238 a1 := JTF_VARCHAR2_TABLE_100();
239 a2 := JTF_NUMBER_TABLE();
240 a3 := JTF_NUMBER_TABLE();
241 a4 := JTF_VARCHAR2_TABLE_100();
242 a5 := JTF_NUMBER_TABLE();
243 a6 := JTF_DATE_TABLE();
244 a7 := JTF_DATE_TABLE();
245 a8 := JTF_VARCHAR2_TABLE_100();
246 a9 := JTF_VARCHAR2_TABLE_100();
247 a10 := JTF_NUMBER_TABLE();
248 a11 := JTF_VARCHAR2_TABLE_100();
249 a12 := JTF_NUMBER_TABLE();
250 a13 := JTF_NUMBER_TABLE();
251 a14 := JTF_VARCHAR2_TABLE_100();
252 a15 := JTF_NUMBER_TABLE();
253 a16 := JTF_VARCHAR2_TABLE_100();
254 a17 := JTF_NUMBER_TABLE();
255 a18 := JTF_NUMBER_TABLE();
256 a19 := JTF_NUMBER_TABLE();
257 a20 := JTF_NUMBER_TABLE();
258 a21 := JTF_VARCHAR2_TABLE_100();
259 a22 := JTF_VARCHAR2_TABLE_100();
260 a23 := JTF_VARCHAR2_TABLE_100();
261 a24 := JTF_VARCHAR2_TABLE_300();
262 a25 := JTF_VARCHAR2_TABLE_100();
263 a26 := JTF_NUMBER_TABLE();
264 a27 := JTF_VARCHAR2_TABLE_100();
265 a28 := JTF_VARCHAR2_TABLE_100();
266 a29 := JTF_VARCHAR2_TABLE_300();
267 a30 := JTF_VARCHAR2_TABLE_100();
268 a31 := JTF_VARCHAR2_TABLE_100();
269 a32 := JTF_VARCHAR2_TABLE_100();
270 a33 := JTF_VARCHAR2_TABLE_300();
271 a34 := JTF_VARCHAR2_TABLE_300();
272 a35 := JTF_VARCHAR2_TABLE_100();
273 a36 := JTF_VARCHAR2_TABLE_300();
274 a37 := JTF_VARCHAR2_TABLE_300();
275 a38 := JTF_NUMBER_TABLE();
276 a39 := JTF_VARCHAR2_TABLE_2000();
277 a40 := JTF_VARCHAR2_TABLE_100();
278 a41 := JTF_VARCHAR2_TABLE_300();
279 a42 := JTF_VARCHAR2_TABLE_300();
280 a43 := JTF_VARCHAR2_TABLE_300();
281 a44 := JTF_VARCHAR2_TABLE_300();
282 a45 := JTF_VARCHAR2_TABLE_300();
283 a46 := JTF_VARCHAR2_TABLE_300();
284 a47 := JTF_VARCHAR2_TABLE_300();
285 a48 := JTF_VARCHAR2_TABLE_300();
286 a49 := JTF_VARCHAR2_TABLE_300();
287 a50 := JTF_VARCHAR2_TABLE_300();
288 a51 := JTF_VARCHAR2_TABLE_300();
289 a52 := JTF_VARCHAR2_TABLE_300();
290 a53 := JTF_VARCHAR2_TABLE_300();
291 a54 := JTF_VARCHAR2_TABLE_300();
292 a55 := JTF_VARCHAR2_TABLE_300();
293 a56 := JTF_NUMBER_TABLE();
294 a57 := JTF_NUMBER_TABLE();
295 a58 := JTF_NUMBER_TABLE();
296 a59 := JTF_NUMBER_TABLE();
297 a60 := JTF_NUMBER_TABLE();
298 a61 := JTF_NUMBER_TABLE();
299 a62 := JTF_NUMBER_TABLE();
300 a63 := JTF_NUMBER_TABLE();
301 a64 := JTF_NUMBER_TABLE();
302 a65 := JTF_NUMBER_TABLE();
303 a66 := JTF_VARCHAR2_TABLE_100();
304 a67 := JTF_NUMBER_TABLE();
305 a68 := JTF_NUMBER_TABLE();
306 a69 := JTF_VARCHAR2_TABLE_300();
307 a70 := JTF_VARCHAR2_TABLE_300();
308 else
309 a0 := JTF_VARCHAR2_TABLE_100();
310 a1 := JTF_VARCHAR2_TABLE_100();
311 a2 := JTF_NUMBER_TABLE();
312 a3 := JTF_NUMBER_TABLE();
313 a4 := JTF_VARCHAR2_TABLE_100();
314 a5 := JTF_NUMBER_TABLE();
315 a6 := JTF_DATE_TABLE();
316 a7 := JTF_DATE_TABLE();
317 a8 := JTF_VARCHAR2_TABLE_100();
318 a9 := JTF_VARCHAR2_TABLE_100();
319 a10 := JTF_NUMBER_TABLE();
320 a11 := JTF_VARCHAR2_TABLE_100();
321 a12 := JTF_NUMBER_TABLE();
322 a13 := JTF_NUMBER_TABLE();
323 a14 := JTF_VARCHAR2_TABLE_100();
324 a15 := JTF_NUMBER_TABLE();
325 a16 := JTF_VARCHAR2_TABLE_100();
326 a17 := JTF_NUMBER_TABLE();
327 a18 := JTF_NUMBER_TABLE();
328 a19 := JTF_NUMBER_TABLE();
329 a20 := JTF_NUMBER_TABLE();
330 a21 := JTF_VARCHAR2_TABLE_100();
331 a22 := JTF_VARCHAR2_TABLE_100();
332 a23 := JTF_VARCHAR2_TABLE_100();
333 a24 := JTF_VARCHAR2_TABLE_300();
334 a25 := JTF_VARCHAR2_TABLE_100();
335 a26 := JTF_NUMBER_TABLE();
336 a27 := JTF_VARCHAR2_TABLE_100();
337 a28 := JTF_VARCHAR2_TABLE_100();
338 a29 := JTF_VARCHAR2_TABLE_300();
339 a30 := JTF_VARCHAR2_TABLE_100();
340 a31 := JTF_VARCHAR2_TABLE_100();
341 a32 := JTF_VARCHAR2_TABLE_100();
342 a33 := JTF_VARCHAR2_TABLE_300();
343 a34 := JTF_VARCHAR2_TABLE_300();
344 a35 := JTF_VARCHAR2_TABLE_100();
345 a36 := JTF_VARCHAR2_TABLE_300();
346 a37 := JTF_VARCHAR2_TABLE_300();
347 a38 := JTF_NUMBER_TABLE();
348 a39 := JTF_VARCHAR2_TABLE_2000();
349 a40 := JTF_VARCHAR2_TABLE_100();
350 a41 := JTF_VARCHAR2_TABLE_300();
351 a42 := JTF_VARCHAR2_TABLE_300();
352 a43 := JTF_VARCHAR2_TABLE_300();
353 a44 := JTF_VARCHAR2_TABLE_300();
354 a45 := JTF_VARCHAR2_TABLE_300();
355 a46 := JTF_VARCHAR2_TABLE_300();
356 a47 := JTF_VARCHAR2_TABLE_300();
357 a48 := JTF_VARCHAR2_TABLE_300();
358 a49 := JTF_VARCHAR2_TABLE_300();
359 a50 := JTF_VARCHAR2_TABLE_300();
360 a51 := JTF_VARCHAR2_TABLE_300();
361 a52 := JTF_VARCHAR2_TABLE_300();
362 a53 := JTF_VARCHAR2_TABLE_300();
363 a54 := JTF_VARCHAR2_TABLE_300();
364 a55 := JTF_VARCHAR2_TABLE_300();
365 a56 := JTF_NUMBER_TABLE();
366 a57 := JTF_NUMBER_TABLE();
367 a58 := JTF_NUMBER_TABLE();
368 a59 := JTF_NUMBER_TABLE();
369 a60 := JTF_NUMBER_TABLE();
370 a61 := JTF_NUMBER_TABLE();
371 a62 := JTF_NUMBER_TABLE();
372 a63 := JTF_NUMBER_TABLE();
373 a64 := JTF_NUMBER_TABLE();
374 a65 := JTF_NUMBER_TABLE();
375 a66 := JTF_VARCHAR2_TABLE_100();
376 a67 := JTF_NUMBER_TABLE();
377 a68 := JTF_NUMBER_TABLE();
378 a69 := JTF_VARCHAR2_TABLE_300();
379 a70 := JTF_VARCHAR2_TABLE_300();
380 if t.count > 0 then
381 a0.extend(t.count);
382 a1.extend(t.count);
383 a2.extend(t.count);
384 a3.extend(t.count);
385 a4.extend(t.count);
386 a5.extend(t.count);
387 a6.extend(t.count);
388 a7.extend(t.count);
389 a8.extend(t.count);
390 a9.extend(t.count);
391 a10.extend(t.count);
392 a11.extend(t.count);
393 a12.extend(t.count);
394 a13.extend(t.count);
395 a14.extend(t.count);
396 a15.extend(t.count);
397 a16.extend(t.count);
398 a17.extend(t.count);
399 a18.extend(t.count);
400 a19.extend(t.count);
401 a20.extend(t.count);
402 a21.extend(t.count);
403 a22.extend(t.count);
404 a23.extend(t.count);
405 a24.extend(t.count);
406 a25.extend(t.count);
407 a26.extend(t.count);
408 a27.extend(t.count);
409 a28.extend(t.count);
410 a29.extend(t.count);
411 a30.extend(t.count);
412 a31.extend(t.count);
413 a32.extend(t.count);
414 a33.extend(t.count);
415 a34.extend(t.count);
416 a35.extend(t.count);
417 a36.extend(t.count);
418 a37.extend(t.count);
419 a38.extend(t.count);
420 a39.extend(t.count);
421 a40.extend(t.count);
422 a41.extend(t.count);
423 a42.extend(t.count);
424 a43.extend(t.count);
425 a44.extend(t.count);
426 a45.extend(t.count);
427 a46.extend(t.count);
428 a47.extend(t.count);
429 a48.extend(t.count);
430 a49.extend(t.count);
431 a50.extend(t.count);
432 a51.extend(t.count);
433 a52.extend(t.count);
434 a53.extend(t.count);
435 a54.extend(t.count);
436 a55.extend(t.count);
437 a56.extend(t.count);
438 a57.extend(t.count);
439 a58.extend(t.count);
440 a59.extend(t.count);
441 a60.extend(t.count);
442 a61.extend(t.count);
443 a62.extend(t.count);
444 a63.extend(t.count);
445 a64.extend(t.count);
446 a65.extend(t.count);
447 a66.extend(t.count);
448 a67.extend(t.count);
449 a68.extend(t.count);
450 a69.extend(t.count);
451 a70.extend(t.count);
452 ddindx := t.first;
453 indx := 1;
454 while true loop
455 a0(indx) := t(ddindx).offer_line_type;
456 a1(indx) := t(ddindx).operation;
457 a2(indx) := t(ddindx).list_line_id;
458 a3(indx) := t(ddindx).list_header_id;
459 a4(indx) := t(ddindx).list_line_type_code;
460 a5(indx) := t(ddindx).operand;
461 a6(indx) := t(ddindx).start_date_active;
462 a7(indx) := t(ddindx).end_date_active;
463 a8(indx) := t(ddindx).arithmetic_operator;
464 a9(indx) := t(ddindx).inactive_flag;
465 a10(indx) := t(ddindx).qd_operand;
466 a11(indx) := t(ddindx).qd_arithmetic_operator;
467 a12(indx) := t(ddindx).qd_related_deal_lines_id;
468 a13(indx) := t(ddindx).qd_object_version_number;
469 a14(indx) := t(ddindx).qd_estimated_qty_is_max;
470 a15(indx) := t(ddindx).qd_list_line_id;
471 a16(indx) := t(ddindx).qd_estimated_amount_is_max;
472 a17(indx) := t(ddindx).estim_gl_value;
473 a18(indx) := t(ddindx).benefit_price_list_line_id;
474 a19(indx) := t(ddindx).benefit_limit;
475 a20(indx) := t(ddindx).benefit_qty;
476 a21(indx) := t(ddindx).benefit_uom_code;
477 a22(indx) := t(ddindx).substitution_context;
478 a23(indx) := t(ddindx).substitution_attr;
479 a24(indx) := t(ddindx).substitution_val;
480 a25(indx) := t(ddindx).price_break_type_code;
481 a26(indx) := t(ddindx).pricing_attribute_id;
482 a27(indx) := t(ddindx).product_attribute_context;
483 a28(indx) := t(ddindx).product_attr;
484 a29(indx) := t(ddindx).product_attr_val;
485 a30(indx) := t(ddindx).product_uom_code;
486 a31(indx) := t(ddindx).pricing_attribute_context;
487 a32(indx) := t(ddindx).pricing_attr;
488 a33(indx) := t(ddindx).pricing_attr_value_from;
489 a34(indx) := t(ddindx).pricing_attr_value_to;
490 a35(indx) := t(ddindx).excluder_flag;
491 a36(indx) := t(ddindx).order_value_from;
492 a37(indx) := t(ddindx).order_value_to;
493 a38(indx) := t(ddindx).qualifier_id;
494 a39(indx) := t(ddindx).comments;
495 a40(indx) := t(ddindx).context;
496 a41(indx) := t(ddindx).attribute1;
497 a42(indx) := t(ddindx).attribute2;
498 a43(indx) := t(ddindx).attribute3;
499 a44(indx) := t(ddindx).attribute4;
500 a45(indx) := t(ddindx).attribute5;
501 a46(indx) := t(ddindx).attribute6;
502 a47(indx) := t(ddindx).attribute7;
503 a48(indx) := t(ddindx).attribute8;
504 a49(indx) := t(ddindx).attribute9;
505 a50(indx) := t(ddindx).attribute10;
506 a51(indx) := t(ddindx).attribute11;
507 a52(indx) := t(ddindx).attribute12;
508 a53(indx) := t(ddindx).attribute13;
509 a54(indx) := t(ddindx).attribute14;
510 a55(indx) := t(ddindx).attribute15;
511 a56(indx) := t(ddindx).max_qty_per_order;
512 a57(indx) := t(ddindx).max_qty_per_order_id;
513 a58(indx) := t(ddindx).max_qty_per_customer;
514 a59(indx) := t(ddindx).max_qty_per_customer_id;
515 a60(indx) := t(ddindx).max_qty_per_rule;
516 a61(indx) := t(ddindx).max_qty_per_rule_id;
517 a62(indx) := t(ddindx).max_orders_per_customer;
518 a63(indx) := t(ddindx).max_orders_per_customer_id;
519 a64(indx) := t(ddindx).max_amount_per_rule;
520 a65(indx) := t(ddindx).max_amount_per_rule_id;
521 a66(indx) := t(ddindx).estimate_qty_uom;
522 a67(indx) := t(ddindx).generate_using_formula_id;
523 a68(indx) := t(ddindx).price_by_formula_id;
524 a69(indx) := t(ddindx).generate_using_formula;
525 a70(indx) := t(ddindx).price_by_formula;
526 indx := indx+1;
527 if t.last =ddindx
528 then exit;
529 end if;
530 ddindx := t.next(ddindx);
531 end loop;
532 end if;
533 end if;
534 end rosetta_table_copy_out_p2;
535
536 procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
537 , a1 JTF_VARCHAR2_TABLE_100
538 , a2 JTF_NUMBER_TABLE
539 , a3 JTF_VARCHAR2_TABLE_100
540 , a4 JTF_VARCHAR2_TABLE_100
541 , a5 JTF_VARCHAR2_TABLE_300
542 , a6 JTF_VARCHAR2_TABLE_100
543 , a7 JTF_VARCHAR2_TABLE_100
544 , a8 JTF_VARCHAR2_TABLE_100
545 , a9 JTF_VARCHAR2_TABLE_300
546 , a10 JTF_VARCHAR2_TABLE_300
547 , a11 JTF_NUMBER_TABLE
548 , a12 JTF_VARCHAR2_TABLE_100
549 ) as
550 ddindx binary_integer; indx binary_integer;
551 begin
552 if a0 is not null and a0.count > 0 then
553 if a0.count > 0 then
554 indx := a0.first;
555 ddindx := 1;
556 while true loop
557 t(ddindx).list_line_id := a0(indx);
558 t(ddindx).excluder_flag := a1(indx);
559 t(ddindx).pricing_attribute_id := a2(indx);
560 t(ddindx).product_attribute_context := a3(indx);
561 t(ddindx).product_attribute := a4(indx);
562 t(ddindx).product_attr_value := a5(indx);
563 t(ddindx).product_uom_code := a6(indx);
564 t(ddindx).pricing_attribute_context := a7(indx);
565 t(ddindx).pricing_attribute := a8(indx);
566 t(ddindx).pricing_attr_value_from := a9(indx);
567 t(ddindx).pricing_attr_value_to := a10(indx);
568 t(ddindx).modifiers_index := a11(indx);
569 t(ddindx).operation := a12(indx);
570 ddindx := ddindx+1;
571 if a0.last =indx
572 then exit;
573 end if;
574 indx := a0.next(indx);
575 end loop;
576 end if;
577 end if;
578 end rosetta_table_copy_in_p4;
579 procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
580 , a1 out nocopy JTF_VARCHAR2_TABLE_100
581 , a2 out nocopy JTF_NUMBER_TABLE
582 , a3 out nocopy JTF_VARCHAR2_TABLE_100
583 , a4 out nocopy JTF_VARCHAR2_TABLE_100
584 , a5 out nocopy JTF_VARCHAR2_TABLE_300
585 , a6 out nocopy JTF_VARCHAR2_TABLE_100
586 , a7 out nocopy JTF_VARCHAR2_TABLE_100
587 , a8 out nocopy JTF_VARCHAR2_TABLE_100
588 , a9 out nocopy JTF_VARCHAR2_TABLE_300
589 , a10 out nocopy JTF_VARCHAR2_TABLE_300
590 , a11 out nocopy JTF_NUMBER_TABLE
591 , a12 out nocopy JTF_VARCHAR2_TABLE_100
592 ) as
593 ddindx binary_integer; indx binary_integer;
594 begin
595 if t is null or t.count = 0 then
596 a0 := JTF_NUMBER_TABLE();
597 a1 := JTF_VARCHAR2_TABLE_100();
598 a2 := JTF_NUMBER_TABLE();
599 a3 := JTF_VARCHAR2_TABLE_100();
600 a4 := JTF_VARCHAR2_TABLE_100();
601 a5 := JTF_VARCHAR2_TABLE_300();
602 a6 := JTF_VARCHAR2_TABLE_100();
603 a7 := JTF_VARCHAR2_TABLE_100();
604 a8 := JTF_VARCHAR2_TABLE_100();
605 a9 := JTF_VARCHAR2_TABLE_300();
606 a10 := JTF_VARCHAR2_TABLE_300();
607 a11 := JTF_NUMBER_TABLE();
608 a12 := JTF_VARCHAR2_TABLE_100();
609 else
610 a0 := JTF_NUMBER_TABLE();
611 a1 := JTF_VARCHAR2_TABLE_100();
612 a2 := JTF_NUMBER_TABLE();
613 a3 := JTF_VARCHAR2_TABLE_100();
614 a4 := JTF_VARCHAR2_TABLE_100();
615 a5 := JTF_VARCHAR2_TABLE_300();
616 a6 := JTF_VARCHAR2_TABLE_100();
617 a7 := JTF_VARCHAR2_TABLE_100();
618 a8 := JTF_VARCHAR2_TABLE_100();
619 a9 := JTF_VARCHAR2_TABLE_300();
620 a10 := JTF_VARCHAR2_TABLE_300();
621 a11 := JTF_NUMBER_TABLE();
622 a12 := JTF_VARCHAR2_TABLE_100();
623 if t.count > 0 then
624 a0.extend(t.count);
625 a1.extend(t.count);
626 a2.extend(t.count);
627 a3.extend(t.count);
628 a4.extend(t.count);
629 a5.extend(t.count);
630 a6.extend(t.count);
631 a7.extend(t.count);
632 a8.extend(t.count);
633 a9.extend(t.count);
634 a10.extend(t.count);
635 a11.extend(t.count);
636 a12.extend(t.count);
637 ddindx := t.first;
638 indx := 1;
639 while true loop
640 a0(indx) := t(ddindx).list_line_id;
641 a1(indx) := t(ddindx).excluder_flag;
642 a2(indx) := t(ddindx).pricing_attribute_id;
643 a3(indx) := t(ddindx).product_attribute_context;
644 a4(indx) := t(ddindx).product_attribute;
645 a5(indx) := t(ddindx).product_attr_value;
646 a6(indx) := t(ddindx).product_uom_code;
647 a7(indx) := t(ddindx).pricing_attribute_context;
648 a8(indx) := t(ddindx).pricing_attribute;
649 a9(indx) := t(ddindx).pricing_attr_value_from;
650 a10(indx) := t(ddindx).pricing_attr_value_to;
651 a11(indx) := t(ddindx).modifiers_index;
652 a12(indx) := t(ddindx).operation;
653 indx := indx+1;
654 if t.last =ddindx
655 then exit;
656 end if;
657 ddindx := t.next(ddindx);
658 end loop;
659 end if;
660 end if;
661 end rosetta_table_copy_out_p4;
662
663 procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
664 , a1 JTF_VARCHAR2_TABLE_100
665 , a2 JTF_VARCHAR2_TABLE_300
666 , a3 JTF_VARCHAR2_TABLE_300
667 , a4 JTF_VARCHAR2_TABLE_100
668 , a5 JTF_NUMBER_TABLE
669 , a6 JTF_NUMBER_TABLE
670 , a7 JTF_NUMBER_TABLE
671 , a8 JTF_NUMBER_TABLE
672 , a9 JTF_DATE_TABLE
673 , a10 JTF_DATE_TABLE
674 , a11 JTF_NUMBER_TABLE
675 , a12 JTF_VARCHAR2_TABLE_100
676 , a13 JTF_VARCHAR2_TABLE_100
677 , a14 JTF_VARCHAR2_TABLE_300
678 , a15 JTF_VARCHAR2_TABLE_300
679 , a16 JTF_VARCHAR2_TABLE_300
680 , a17 JTF_VARCHAR2_TABLE_300
681 , a18 JTF_VARCHAR2_TABLE_300
682 , a19 JTF_VARCHAR2_TABLE_300
683 , a20 JTF_VARCHAR2_TABLE_300
684 , a21 JTF_VARCHAR2_TABLE_300
685 , a22 JTF_VARCHAR2_TABLE_300
686 , a23 JTF_VARCHAR2_TABLE_300
687 , a24 JTF_VARCHAR2_TABLE_300
688 , a25 JTF_VARCHAR2_TABLE_300
689 , a26 JTF_VARCHAR2_TABLE_300
690 , a27 JTF_VARCHAR2_TABLE_300
691 , a28 JTF_VARCHAR2_TABLE_300
692 ) as
693 ddindx binary_integer; indx binary_integer;
694 begin
695 if a0 is not null and a0.count > 0 then
696 if a0.count > 0 then
697 indx := a0.first;
698 ddindx := 1;
699 while true loop
700 t(ddindx).qualifier_context := a0(indx);
701 t(ddindx).qualifier_attribute := a1(indx);
702 t(ddindx).qualifier_attr_value := a2(indx);
703 t(ddindx).qualifier_attr_value_to := a3(indx);
704 t(ddindx).comparison_operator_code := a4(indx);
705 t(ddindx).qualifier_grouping_no := a5(indx);
706 t(ddindx).list_line_id := a6(indx);
707 t(ddindx).list_header_id := a7(indx);
708 t(ddindx).qualifier_id := a8(indx);
709 t(ddindx).start_date_active := a9(indx);
710 t(ddindx).end_date_active := a10(indx);
711 t(ddindx).activity_market_segment_id := a11(indx);
712 t(ddindx).operation := a12(indx);
713 t(ddindx).context := a13(indx);
714 t(ddindx).attribute1 := a14(indx);
715 t(ddindx).attribute2 := a15(indx);
716 t(ddindx).attribute3 := a16(indx);
717 t(ddindx).attribute4 := a17(indx);
718 t(ddindx).attribute5 := a18(indx);
719 t(ddindx).attribute6 := a19(indx);
720 t(ddindx).attribute7 := a20(indx);
721 t(ddindx).attribute8 := a21(indx);
722 t(ddindx).attribute9 := a22(indx);
723 t(ddindx).attribute10 := a23(indx);
724 t(ddindx).attribute11 := a24(indx);
725 t(ddindx).attribute12 := a25(indx);
726 t(ddindx).attribute13 := a26(indx);
727 t(ddindx).attribute14 := a27(indx);
728 t(ddindx).attribute15 := a28(indx);
729 ddindx := ddindx+1;
730 if a0.last =indx
731 then exit;
732 end if;
733 indx := a0.next(indx);
734 end loop;
735 end if;
736 end if;
737 end rosetta_table_copy_in_p6;
738 procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
739 , a1 out nocopy JTF_VARCHAR2_TABLE_100
740 , a2 out nocopy JTF_VARCHAR2_TABLE_300
741 , a3 out nocopy JTF_VARCHAR2_TABLE_300
742 , a4 out nocopy JTF_VARCHAR2_TABLE_100
743 , a5 out nocopy JTF_NUMBER_TABLE
744 , a6 out nocopy JTF_NUMBER_TABLE
745 , a7 out nocopy JTF_NUMBER_TABLE
746 , a8 out nocopy JTF_NUMBER_TABLE
747 , a9 out nocopy JTF_DATE_TABLE
748 , a10 out nocopy JTF_DATE_TABLE
749 , a11 out nocopy JTF_NUMBER_TABLE
750 , a12 out nocopy JTF_VARCHAR2_TABLE_100
751 , a13 out nocopy JTF_VARCHAR2_TABLE_100
752 , a14 out nocopy JTF_VARCHAR2_TABLE_300
753 , a15 out nocopy JTF_VARCHAR2_TABLE_300
754 , a16 out nocopy JTF_VARCHAR2_TABLE_300
755 , a17 out nocopy JTF_VARCHAR2_TABLE_300
756 , a18 out nocopy JTF_VARCHAR2_TABLE_300
757 , a19 out nocopy JTF_VARCHAR2_TABLE_300
758 , a20 out nocopy JTF_VARCHAR2_TABLE_300
759 , a21 out nocopy JTF_VARCHAR2_TABLE_300
760 , a22 out nocopy JTF_VARCHAR2_TABLE_300
761 , a23 out nocopy JTF_VARCHAR2_TABLE_300
762 , a24 out nocopy JTF_VARCHAR2_TABLE_300
763 , a25 out nocopy JTF_VARCHAR2_TABLE_300
764 , a26 out nocopy JTF_VARCHAR2_TABLE_300
765 , a27 out nocopy JTF_VARCHAR2_TABLE_300
766 , a28 out nocopy JTF_VARCHAR2_TABLE_300
767 ) as
768 ddindx binary_integer; indx binary_integer;
769 begin
770 if t is null or t.count = 0 then
771 a0 := JTF_VARCHAR2_TABLE_100();
772 a1 := JTF_VARCHAR2_TABLE_100();
773 a2 := JTF_VARCHAR2_TABLE_300();
774 a3 := JTF_VARCHAR2_TABLE_300();
775 a4 := JTF_VARCHAR2_TABLE_100();
776 a5 := JTF_NUMBER_TABLE();
777 a6 := JTF_NUMBER_TABLE();
778 a7 := JTF_NUMBER_TABLE();
779 a8 := JTF_NUMBER_TABLE();
780 a9 := JTF_DATE_TABLE();
781 a10 := JTF_DATE_TABLE();
782 a11 := JTF_NUMBER_TABLE();
783 a12 := JTF_VARCHAR2_TABLE_100();
784 a13 := JTF_VARCHAR2_TABLE_100();
785 a14 := JTF_VARCHAR2_TABLE_300();
786 a15 := JTF_VARCHAR2_TABLE_300();
787 a16 := JTF_VARCHAR2_TABLE_300();
788 a17 := JTF_VARCHAR2_TABLE_300();
789 a18 := JTF_VARCHAR2_TABLE_300();
790 a19 := JTF_VARCHAR2_TABLE_300();
791 a20 := JTF_VARCHAR2_TABLE_300();
792 a21 := JTF_VARCHAR2_TABLE_300();
793 a22 := JTF_VARCHAR2_TABLE_300();
794 a23 := JTF_VARCHAR2_TABLE_300();
795 a24 := JTF_VARCHAR2_TABLE_300();
796 a25 := JTF_VARCHAR2_TABLE_300();
797 a26 := JTF_VARCHAR2_TABLE_300();
798 a27 := JTF_VARCHAR2_TABLE_300();
799 a28 := JTF_VARCHAR2_TABLE_300();
800 else
801 a0 := JTF_VARCHAR2_TABLE_100();
802 a1 := JTF_VARCHAR2_TABLE_100();
803 a2 := JTF_VARCHAR2_TABLE_300();
804 a3 := JTF_VARCHAR2_TABLE_300();
805 a4 := JTF_VARCHAR2_TABLE_100();
806 a5 := JTF_NUMBER_TABLE();
807 a6 := JTF_NUMBER_TABLE();
808 a7 := JTF_NUMBER_TABLE();
809 a8 := JTF_NUMBER_TABLE();
810 a9 := JTF_DATE_TABLE();
811 a10 := JTF_DATE_TABLE();
812 a11 := JTF_NUMBER_TABLE();
813 a12 := JTF_VARCHAR2_TABLE_100();
814 a13 := JTF_VARCHAR2_TABLE_100();
815 a14 := JTF_VARCHAR2_TABLE_300();
816 a15 := JTF_VARCHAR2_TABLE_300();
817 a16 := JTF_VARCHAR2_TABLE_300();
818 a17 := JTF_VARCHAR2_TABLE_300();
819 a18 := JTF_VARCHAR2_TABLE_300();
820 a19 := JTF_VARCHAR2_TABLE_300();
821 a20 := JTF_VARCHAR2_TABLE_300();
822 a21 := JTF_VARCHAR2_TABLE_300();
823 a22 := JTF_VARCHAR2_TABLE_300();
824 a23 := JTF_VARCHAR2_TABLE_300();
825 a24 := JTF_VARCHAR2_TABLE_300();
826 a25 := JTF_VARCHAR2_TABLE_300();
827 a26 := JTF_VARCHAR2_TABLE_300();
828 a27 := JTF_VARCHAR2_TABLE_300();
829 a28 := JTF_VARCHAR2_TABLE_300();
830 if t.count > 0 then
831 a0.extend(t.count);
832 a1.extend(t.count);
833 a2.extend(t.count);
834 a3.extend(t.count);
835 a4.extend(t.count);
836 a5.extend(t.count);
837 a6.extend(t.count);
838 a7.extend(t.count);
839 a8.extend(t.count);
840 a9.extend(t.count);
841 a10.extend(t.count);
842 a11.extend(t.count);
843 a12.extend(t.count);
844 a13.extend(t.count);
845 a14.extend(t.count);
846 a15.extend(t.count);
847 a16.extend(t.count);
848 a17.extend(t.count);
849 a18.extend(t.count);
850 a19.extend(t.count);
851 a20.extend(t.count);
852 a21.extend(t.count);
853 a22.extend(t.count);
854 a23.extend(t.count);
855 a24.extend(t.count);
856 a25.extend(t.count);
857 a26.extend(t.count);
858 a27.extend(t.count);
859 a28.extend(t.count);
860 ddindx := t.first;
861 indx := 1;
862 while true loop
863 a0(indx) := t(ddindx).qualifier_context;
864 a1(indx) := t(ddindx).qualifier_attribute;
865 a2(indx) := t(ddindx).qualifier_attr_value;
866 a3(indx) := t(ddindx).qualifier_attr_value_to;
867 a4(indx) := t(ddindx).comparison_operator_code;
868 a5(indx) := t(ddindx).qualifier_grouping_no;
869 a6(indx) := t(ddindx).list_line_id;
870 a7(indx) := t(ddindx).list_header_id;
871 a8(indx) := t(ddindx).qualifier_id;
872 a9(indx) := t(ddindx).start_date_active;
873 a10(indx) := t(ddindx).end_date_active;
874 a11(indx) := t(ddindx).activity_market_segment_id;
875 a12(indx) := t(ddindx).operation;
876 a13(indx) := t(ddindx).context;
877 a14(indx) := t(ddindx).attribute1;
878 a15(indx) := t(ddindx).attribute2;
879 a16(indx) := t(ddindx).attribute3;
880 a17(indx) := t(ddindx).attribute4;
881 a18(indx) := t(ddindx).attribute5;
882 a19(indx) := t(ddindx).attribute6;
883 a20(indx) := t(ddindx).attribute7;
884 a21(indx) := t(ddindx).attribute8;
885 a22(indx) := t(ddindx).attribute9;
886 a23(indx) := t(ddindx).attribute10;
887 a24(indx) := t(ddindx).attribute11;
888 a25(indx) := t(ddindx).attribute12;
889 a26(indx) := t(ddindx).attribute13;
890 a27(indx) := t(ddindx).attribute14;
891 a28(indx) := t(ddindx).attribute15;
892 indx := indx+1;
893 if t.last =ddindx
894 then exit;
895 end if;
896 ddindx := t.next(ddindx);
897 end loop;
898 end if;
899 end if;
900 end rosetta_table_copy_out_p6;
901
902 procedure process_modifiers(p_init_msg_list VARCHAR2
903 , p_api_version NUMBER
904 , p_commit VARCHAR2
905 , x_return_status out nocopy VARCHAR2
906 , x_msg_count out nocopy NUMBER
907 , x_msg_data out nocopy VARCHAR2
908 , p_offer_type VARCHAR2
909 , p7_a0 NUMBER
910 , p7_a1 NUMBER
911 , p7_a2 VARCHAR2
912 , p7_a3 VARCHAR2
913 , p7_a4 NUMBER
914 , p7_a5 VARCHAR2
915 , p7_a6 NUMBER
916 , p7_a7 NUMBER
917 , p7_a8 VARCHAR2
918 , p7_a9 VARCHAR2
919 , p7_a10 NUMBER
920 , p7_a11 NUMBER
921 , p7_a12 DATE
922 , p7_a13 DATE
923 , p7_a14 VARCHAR2
924 , p7_a15 DATE
925 , p7_a16 VARCHAR2
926 , p7_a17 VARCHAR2
927 , p7_a18 NUMBER
928 , p7_a19 VARCHAR2
929 , p7_a20 NUMBER
930 , p7_a21 NUMBER
931 , p7_a22 NUMBER
932 , p7_a23 NUMBER
933 , p7_a24 VARCHAR2
934 , p7_a25 VARCHAR2
935 , p7_a26 VARCHAR2
936 , p7_a27 VARCHAR2
937 , p7_a28 VARCHAR2
938 , p7_a29 VARCHAR2
939 , p7_a30 VARCHAR2
940 , p7_a31 VARCHAR2
941 , p7_a32 VARCHAR2
942 , p7_a33 VARCHAR2
943 , p7_a34 VARCHAR2
944 , p7_a35 VARCHAR2
945 , p7_a36 VARCHAR2
946 , p7_a37 VARCHAR2
947 , p7_a38 VARCHAR2
948 , p7_a39 VARCHAR2
949 , p7_a40 VARCHAR2
950 , p7_a41 VARCHAR2
951 , p7_a42 VARCHAR2
952 , p7_a43 DATE
953 , p7_a44 DATE
954 , p7_a45 VARCHAR2
955 , p7_a46 VARCHAR2
956 , p7_a47 VARCHAR2
957 , p7_a48 VARCHAR2
958 , p7_a49 VARCHAR2
959 , p7_a50 VARCHAR2
960 , p7_a51 DATE
961 , p7_a52 DATE
962 , p7_a53 VARCHAR2
963 , p7_a54 DATE
964 , p7_a55 DATE
965 , p7_a56 VARCHAR2
966 , p7_a57 VARCHAR2
967 , p7_a58 NUMBER
968 , p7_a59 NUMBER
969 , p7_a60 VARCHAR2
970 , p7_a61 NUMBER
971 , p7_a62 VARCHAR2
972 , p7_a63 VARCHAR2
973 , p7_a64 NUMBER
974 , p7_a65 VARCHAR2
975 , p7_a66 NUMBER
976 , p7_a67 NUMBER
977 , p7_a68 VARCHAR2
978 , p7_a69 VARCHAR2
979 , p7_a70 VARCHAR2
980 , p7_a71 VARCHAR2
981 , p7_a72 VARCHAR2
982 , p7_a73 VARCHAR2
983 , p7_a74 VARCHAR2
984 , p7_a75 VARCHAR2
985 , p7_a76 VARCHAR2
986 , p7_a77 VARCHAR2
987 , p7_a78 VARCHAR2
988 , p7_a79 NUMBER
989 , p7_a80 VARCHAR2
990 , p7_a81 VARCHAR2
991 , p7_a82 NUMBER
992 , p8_a0 JTF_VARCHAR2_TABLE_100
993 , p8_a1 JTF_VARCHAR2_TABLE_100
994 , p8_a2 JTF_NUMBER_TABLE
995 , p8_a3 JTF_NUMBER_TABLE
996 , p8_a4 JTF_VARCHAR2_TABLE_100
997 , p8_a5 JTF_NUMBER_TABLE
998 , p8_a6 JTF_DATE_TABLE
999 , p8_a7 JTF_DATE_TABLE
1000 , p8_a8 JTF_VARCHAR2_TABLE_100
1001 , p8_a9 JTF_VARCHAR2_TABLE_100
1002 , p8_a10 JTF_NUMBER_TABLE
1003 , p8_a11 JTF_VARCHAR2_TABLE_100
1004 , p8_a12 JTF_NUMBER_TABLE
1005 , p8_a13 JTF_NUMBER_TABLE
1006 , p8_a14 JTF_VARCHAR2_TABLE_100
1007 , p8_a15 JTF_NUMBER_TABLE
1008 , p8_a16 JTF_VARCHAR2_TABLE_100
1009 , p8_a17 JTF_NUMBER_TABLE
1010 , p8_a18 JTF_NUMBER_TABLE
1011 , p8_a19 JTF_NUMBER_TABLE
1012 , p8_a20 JTF_NUMBER_TABLE
1013 , p8_a21 JTF_VARCHAR2_TABLE_100
1014 , p8_a22 JTF_VARCHAR2_TABLE_100
1015 , p8_a23 JTF_VARCHAR2_TABLE_100
1016 , p8_a24 JTF_VARCHAR2_TABLE_300
1017 , p8_a25 JTF_VARCHAR2_TABLE_100
1018 , p8_a26 JTF_NUMBER_TABLE
1019 , p8_a27 JTF_VARCHAR2_TABLE_100
1020 , p8_a28 JTF_VARCHAR2_TABLE_100
1021 , p8_a29 JTF_VARCHAR2_TABLE_300
1022 , p8_a30 JTF_VARCHAR2_TABLE_100
1023 , p8_a31 JTF_VARCHAR2_TABLE_100
1024 , p8_a32 JTF_VARCHAR2_TABLE_100
1025 , p8_a33 JTF_VARCHAR2_TABLE_300
1026 , p8_a34 JTF_VARCHAR2_TABLE_300
1027 , p8_a35 JTF_VARCHAR2_TABLE_100
1028 , p8_a36 JTF_VARCHAR2_TABLE_300
1029 , p8_a37 JTF_VARCHAR2_TABLE_300
1030 , p8_a38 JTF_NUMBER_TABLE
1031 , p8_a39 JTF_VARCHAR2_TABLE_2000
1032 , p8_a40 JTF_VARCHAR2_TABLE_100
1033 , p8_a41 JTF_VARCHAR2_TABLE_300
1034 , p8_a42 JTF_VARCHAR2_TABLE_300
1035 , p8_a43 JTF_VARCHAR2_TABLE_300
1036 , p8_a44 JTF_VARCHAR2_TABLE_300
1037 , p8_a45 JTF_VARCHAR2_TABLE_300
1038 , p8_a46 JTF_VARCHAR2_TABLE_300
1039 , p8_a47 JTF_VARCHAR2_TABLE_300
1040 , p8_a48 JTF_VARCHAR2_TABLE_300
1041 , p8_a49 JTF_VARCHAR2_TABLE_300
1042 , p8_a50 JTF_VARCHAR2_TABLE_300
1043 , p8_a51 JTF_VARCHAR2_TABLE_300
1044 , p8_a52 JTF_VARCHAR2_TABLE_300
1045 , p8_a53 JTF_VARCHAR2_TABLE_300
1046 , p8_a54 JTF_VARCHAR2_TABLE_300
1047 , p8_a55 JTF_VARCHAR2_TABLE_300
1048 , p8_a56 JTF_NUMBER_TABLE
1049 , p8_a57 JTF_NUMBER_TABLE
1050 , p8_a58 JTF_NUMBER_TABLE
1051 , p8_a59 JTF_NUMBER_TABLE
1052 , p8_a60 JTF_NUMBER_TABLE
1053 , p8_a61 JTF_NUMBER_TABLE
1054 , p8_a62 JTF_NUMBER_TABLE
1055 , p8_a63 JTF_NUMBER_TABLE
1056 , p8_a64 JTF_NUMBER_TABLE
1057 , p8_a65 JTF_NUMBER_TABLE
1058 , p8_a66 JTF_VARCHAR2_TABLE_100
1059 , p8_a67 JTF_NUMBER_TABLE
1060 , p8_a68 JTF_NUMBER_TABLE
1061 , p8_a69 JTF_VARCHAR2_TABLE_300
1062 , p8_a70 JTF_VARCHAR2_TABLE_300
1063 , x_qp_list_header_id out nocopy NUMBER
1064 , x_error_location out nocopy NUMBER
1065 )
1066
1067 as
1068 ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1069 ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1070 ddindx binary_integer; indx binary_integer;
1071 begin
1072
1073 -- copy data to the local IN or IN-OUT args, if any
1074
1075
1076
1077
1078
1079
1080
1081 ddp_modifier_list_rec.offer_id := p7_a0;
1082 ddp_modifier_list_rec.qp_list_header_id := p7_a1;
1083 ddp_modifier_list_rec.offer_type := p7_a2;
1084 ddp_modifier_list_rec.offer_code := p7_a3;
1085 ddp_modifier_list_rec.activity_media_id := p7_a4;
1086 ddp_modifier_list_rec.reusable := p7_a5;
1087 ddp_modifier_list_rec.user_status_id := p7_a6;
1088 ddp_modifier_list_rec.owner_id := p7_a7;
1089 ddp_modifier_list_rec.wf_item_key := p7_a8;
1090 ddp_modifier_list_rec.customer_reference := p7_a9;
1091 ddp_modifier_list_rec.buying_group_contact_id := p7_a10;
1092 ddp_modifier_list_rec.object_version_number := p7_a11;
1093 ddp_modifier_list_rec.perf_date_from := p7_a12;
1094 ddp_modifier_list_rec.perf_date_to := p7_a13;
1095 ddp_modifier_list_rec.status_code := p7_a14;
1096 ddp_modifier_list_rec.status_date := p7_a15;
1097 ddp_modifier_list_rec.modifier_level_code := p7_a16;
1098 ddp_modifier_list_rec.order_value_discount_type := p7_a17;
1099 ddp_modifier_list_rec.lumpsum_amount := p7_a18;
1100 ddp_modifier_list_rec.lumpsum_payment_type := p7_a19;
1101 ddp_modifier_list_rec.custom_setup_id := p7_a20;
1102 ddp_modifier_list_rec.offer_amount := p7_a21;
1103 ddp_modifier_list_rec.budget_amount_tc := p7_a22;
1104 ddp_modifier_list_rec.budget_amount_fc := p7_a23;
1105 ddp_modifier_list_rec.transaction_currency_code := p7_a24;
1106 ddp_modifier_list_rec.functional_currency_code := p7_a25;
1107 ddp_modifier_list_rec.context := p7_a26;
1108 ddp_modifier_list_rec.attribute1 := p7_a27;
1109 ddp_modifier_list_rec.attribute2 := p7_a28;
1110 ddp_modifier_list_rec.attribute3 := p7_a29;
1111 ddp_modifier_list_rec.attribute4 := p7_a30;
1112 ddp_modifier_list_rec.attribute5 := p7_a31;
1113 ddp_modifier_list_rec.attribute6 := p7_a32;
1114 ddp_modifier_list_rec.attribute7 := p7_a33;
1115 ddp_modifier_list_rec.attribute8 := p7_a34;
1116 ddp_modifier_list_rec.attribute9 := p7_a35;
1117 ddp_modifier_list_rec.attribute10 := p7_a36;
1118 ddp_modifier_list_rec.attribute11 := p7_a37;
1119 ddp_modifier_list_rec.attribute12 := p7_a38;
1120 ddp_modifier_list_rec.attribute13 := p7_a39;
1121 ddp_modifier_list_rec.attribute14 := p7_a40;
1122 ddp_modifier_list_rec.attribute15 := p7_a41;
1123 ddp_modifier_list_rec.currency_code := p7_a42;
1124 ddp_modifier_list_rec.start_date_active := p7_a43;
1125 ddp_modifier_list_rec.end_date_active := p7_a44;
1126 ddp_modifier_list_rec.list_type_code := p7_a45;
1127 ddp_modifier_list_rec.discount_lines_flag := p7_a46;
1128 ddp_modifier_list_rec.name := p7_a47;
1129 ddp_modifier_list_rec.description := p7_a48;
1130 ddp_modifier_list_rec.comments := p7_a49;
1131 ddp_modifier_list_rec.ask_for_flag := p7_a50;
1132 ddp_modifier_list_rec.start_date_active_first := p7_a51;
1133 ddp_modifier_list_rec.end_date_active_first := p7_a52;
1134 ddp_modifier_list_rec.active_date_first_type := p7_a53;
1135 ddp_modifier_list_rec.start_date_active_second := p7_a54;
1136 ddp_modifier_list_rec.end_date_active_second := p7_a55;
1137 ddp_modifier_list_rec.active_date_second_type := p7_a56;
1138 ddp_modifier_list_rec.active_flag := p7_a57;
1139 ddp_modifier_list_rec.max_no_of_uses := p7_a58;
1140 ddp_modifier_list_rec.budget_source_id := p7_a59;
1141 ddp_modifier_list_rec.budget_source_type := p7_a60;
1142 ddp_modifier_list_rec.offer_used_by_id := p7_a61;
1143 ddp_modifier_list_rec.offer_used_by := p7_a62;
1144 ddp_modifier_list_rec.ql_qualifier_type := p7_a63;
1145 ddp_modifier_list_rec.ql_qualifier_id := p7_a64;
1146 ddp_modifier_list_rec.distribution_type := p7_a65;
1147 ddp_modifier_list_rec.amount_limit_id := p7_a66;
1148 ddp_modifier_list_rec.uses_limit_id := p7_a67;
1149 ddp_modifier_list_rec.offer_operation := p7_a68;
1150 ddp_modifier_list_rec.modifier_operation := p7_a69;
1151 ddp_modifier_list_rec.budget_offer_yn := p7_a70;
1152 ddp_modifier_list_rec.break_type := p7_a71;
1153 ddp_modifier_list_rec.retroactive := p7_a72;
1154 ddp_modifier_list_rec.volume_offer_type := p7_a73;
1155 ddp_modifier_list_rec.confidential_flag := p7_a74;
1156 ddp_modifier_list_rec.committed_amount_eq_max := p7_a75;
1157 ddp_modifier_list_rec.source_from_parent := p7_a76;
1158 ddp_modifier_list_rec.buyer_name := p7_a77;
1159 ddp_modifier_list_rec.tier_level := p7_a78;
1160 ddp_modifier_list_rec.na_rule_header_id := p7_a79;
1161 ddp_modifier_list_rec.sales_method_flag := p7_a80;
1162 ddp_modifier_list_rec.global_flag := p7_a81;
1163 ddp_modifier_list_rec.orig_org_id := p7_a82;
1164
1165 ozf_offer_pvt_oa.rosetta_table_copy_in_p2(ddp_modifier_line_tbl, p8_a0
1166 , p8_a1
1167 , p8_a2
1168 , p8_a3
1169 , p8_a4
1170 , p8_a5
1171 , p8_a6
1172 , p8_a7
1173 , p8_a8
1174 , p8_a9
1175 , p8_a10
1176 , p8_a11
1177 , p8_a12
1178 , p8_a13
1179 , p8_a14
1180 , p8_a15
1181 , p8_a16
1182 , p8_a17
1183 , p8_a18
1184 , p8_a19
1185 , p8_a20
1186 , p8_a21
1187 , p8_a22
1188 , p8_a23
1189 , p8_a24
1190 , p8_a25
1191 , p8_a26
1192 , p8_a27
1193 , p8_a28
1194 , p8_a29
1195 , p8_a30
1196 , p8_a31
1197 , p8_a32
1198 , p8_a33
1199 , p8_a34
1200 , p8_a35
1201 , p8_a36
1202 , p8_a37
1203 , p8_a38
1204 , p8_a39
1205 , p8_a40
1206 , p8_a41
1207 , p8_a42
1208 , p8_a43
1209 , p8_a44
1210 , p8_a45
1211 , p8_a46
1212 , p8_a47
1213 , p8_a48
1214 , p8_a49
1215 , p8_a50
1216 , p8_a51
1217 , p8_a52
1218 , p8_a53
1219 , p8_a54
1220 , p8_a55
1221 , p8_a56
1222 , p8_a57
1223 , p8_a58
1224 , p8_a59
1225 , p8_a60
1226 , p8_a61
1227 , p8_a62
1228 , p8_a63
1229 , p8_a64
1230 , p8_a65
1231 , p8_a66
1232 , p8_a67
1233 , p8_a68
1234 , p8_a69
1235 , p8_a70
1236 );
1237
1238
1239
1240 -- here's the delegated call to the old PL/SQL routine
1241 ozf_offer_pvt.process_modifiers(p_init_msg_list,
1242 p_api_version,
1243 p_commit,
1244 x_return_status,
1245 x_msg_count,
1246 x_msg_data,
1247 p_offer_type,
1248 ddp_modifier_list_rec,
1249 ddp_modifier_line_tbl,
1250 x_qp_list_header_id,
1251 x_error_location);
1252
1253 -- copy data back from the local variables to OUT or IN-OUT args, if any
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264 end;
1265 /*
1266 procedure create_offer_tiers(p_init_msg_list VARCHAR2
1267 , p_api_version NUMBER
1268 , p_commit VARCHAR2
1269 , x_return_status out nocopy VARCHAR2
1270 , x_msg_count out nocopy NUMBER
1271 , x_msg_data out nocopy VARCHAR2
1272 , p6_a0 JTF_VARCHAR2_TABLE_100
1273 , p6_a1 JTF_VARCHAR2_TABLE_100
1274 , p6_a2 JTF_NUMBER_TABLE
1275 , p6_a3 JTF_NUMBER_TABLE
1276 , p6_a4 JTF_VARCHAR2_TABLE_100
1277 , p6_a5 JTF_NUMBER_TABLE
1278 , p6_a6 JTF_DATE_TABLE
1279 , p6_a7 JTF_DATE_TABLE
1280 , p6_a8 JTF_VARCHAR2_TABLE_100
1281 , p6_a9 JTF_VARCHAR2_TABLE_100
1282 , p6_a10 JTF_NUMBER_TABLE
1283 , p6_a11 JTF_VARCHAR2_TABLE_100
1284 , p6_a12 JTF_NUMBER_TABLE
1285 , p6_a13 JTF_NUMBER_TABLE
1286 , p6_a14 JTF_VARCHAR2_TABLE_100
1287 , p6_a15 JTF_NUMBER_TABLE
1288 , p6_a16 JTF_VARCHAR2_TABLE_100
1289 , p6_a17 JTF_NUMBER_TABLE
1290 , p6_a18 JTF_NUMBER_TABLE
1291 , p6_a19 JTF_NUMBER_TABLE
1292 , p6_a20 JTF_NUMBER_TABLE
1293 , p6_a21 JTF_VARCHAR2_TABLE_100
1294 , p6_a22 JTF_VARCHAR2_TABLE_100
1295 , p6_a23 JTF_VARCHAR2_TABLE_100
1296 , p6_a24 JTF_VARCHAR2_TABLE_300
1297 , p6_a25 JTF_VARCHAR2_TABLE_100
1298 , p6_a26 JTF_NUMBER_TABLE
1299 , p6_a27 JTF_VARCHAR2_TABLE_100
1300 , p6_a28 JTF_VARCHAR2_TABLE_100
1301 , p6_a29 JTF_VARCHAR2_TABLE_300
1302 , p6_a30 JTF_VARCHAR2_TABLE_100
1303 , p6_a31 JTF_VARCHAR2_TABLE_100
1304 , p6_a32 JTF_VARCHAR2_TABLE_100
1305 , p6_a33 JTF_VARCHAR2_TABLE_300
1306 , p6_a34 JTF_VARCHAR2_TABLE_300
1307 , p6_a35 JTF_VARCHAR2_TABLE_100
1308 , p6_a36 JTF_VARCHAR2_TABLE_300
1309 , p6_a37 JTF_VARCHAR2_TABLE_300
1310 , p6_a38 JTF_NUMBER_TABLE
1311 , p6_a39 JTF_VARCHAR2_TABLE_2000
1312 , p6_a40 JTF_VARCHAR2_TABLE_100
1313 , p6_a41 JTF_VARCHAR2_TABLE_300
1314 , p6_a42 JTF_VARCHAR2_TABLE_300
1315 , p6_a43 JTF_VARCHAR2_TABLE_300
1316 , p6_a44 JTF_VARCHAR2_TABLE_300
1317 , p6_a45 JTF_VARCHAR2_TABLE_300
1318 , p6_a46 JTF_VARCHAR2_TABLE_300
1319 , p6_a47 JTF_VARCHAR2_TABLE_300
1320 , p6_a48 JTF_VARCHAR2_TABLE_300
1321 , p6_a49 JTF_VARCHAR2_TABLE_300
1322 , p6_a50 JTF_VARCHAR2_TABLE_300
1323 , p6_a51 JTF_VARCHAR2_TABLE_300
1324 , p6_a52 JTF_VARCHAR2_TABLE_300
1325 , p6_a53 JTF_VARCHAR2_TABLE_300
1326 , p6_a54 JTF_VARCHAR2_TABLE_300
1327 , p6_a55 JTF_VARCHAR2_TABLE_300
1328 , p6_a56 JTF_NUMBER_TABLE
1329 , p6_a57 JTF_NUMBER_TABLE
1330 , p6_a58 JTF_NUMBER_TABLE
1331 , p6_a59 JTF_NUMBER_TABLE
1332 , p6_a60 JTF_NUMBER_TABLE
1333 , p6_a61 JTF_NUMBER_TABLE
1334 , p6_a62 JTF_NUMBER_TABLE
1335 , p6_a63 JTF_NUMBER_TABLE
1336 , p6_a64 JTF_NUMBER_TABLE
1337 , p6_a65 JTF_NUMBER_TABLE
1338 , p6_a66 JTF_VARCHAR2_TABLE_100
1339 , p6_a67 JTF_NUMBER_TABLE
1340 , p6_a68 JTF_NUMBER_TABLE
1341 , p6_a69 JTF_VARCHAR2_TABLE_300
1342 , p6_a70 JTF_VARCHAR2_TABLE_300
1343 , x_error_location out nocopy NUMBER
1344 , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
1345 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
1346 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
1347 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_300
1348 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_300
1349 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_300
1350 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_300
1351 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_300
1352 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_300
1353 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_300
1354 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_300
1355 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_300
1356 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_300
1357 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_300
1358 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_300
1359 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_300
1360 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1361 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_2000
1362 , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
1363 , p8_a19 out nocopy JTF_NUMBER_TABLE
1364 , p8_a20 out nocopy JTF_DATE_TABLE
1365 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
1366 , p8_a22 out nocopy JTF_DATE_TABLE
1367 , p8_a23 out nocopy JTF_NUMBER_TABLE
1368 , p8_a24 out nocopy JTF_NUMBER_TABLE
1369 , p8_a25 out nocopy JTF_NUMBER_TABLE
1370 , p8_a26 out nocopy JTF_NUMBER_TABLE
1371 , p8_a27 out nocopy JTF_DATE_TABLE
1372 , p8_a28 out nocopy JTF_NUMBER_TABLE
1373 , p8_a29 out nocopy JTF_NUMBER_TABLE
1374 , p8_a30 out nocopy JTF_NUMBER_TABLE
1375 , p8_a31 out nocopy JTF_VARCHAR2_TABLE_100
1376 , p8_a32 out nocopy JTF_NUMBER_TABLE
1377 , p8_a33 out nocopy JTF_VARCHAR2_TABLE_100
1378 , p8_a34 out nocopy JTF_NUMBER_TABLE
1379 , p8_a35 out nocopy JTF_NUMBER_TABLE
1380 , p8_a36 out nocopy JTF_NUMBER_TABLE
1381 , p8_a37 out nocopy JTF_VARCHAR2_TABLE_100
1382 , p8_a38 out nocopy JTF_NUMBER_TABLE
1383 , p8_a39 out nocopy JTF_VARCHAR2_TABLE_100
1384 , p8_a40 out nocopy JTF_NUMBER_TABLE
1385 , p8_a41 out nocopy JTF_VARCHAR2_TABLE_100
1386 , p8_a42 out nocopy JTF_VARCHAR2_TABLE_100
1387 , p8_a43 out nocopy JTF_NUMBER_TABLE
1388 , p8_a44 out nocopy JTF_NUMBER_TABLE
1389 , p8_a45 out nocopy JTF_DATE_TABLE
1390 , p8_a46 out nocopy JTF_VARCHAR2_TABLE_100
1391 , p8_a47 out nocopy JTF_NUMBER_TABLE
1392 , p8_a48 out nocopy JTF_NUMBER_TABLE
1393 , p8_a49 out nocopy JTF_VARCHAR2_TABLE_100
1394 , p8_a50 out nocopy JTF_NUMBER_TABLE
1395 , p8_a51 out nocopy JTF_VARCHAR2_TABLE_100
1396 , p8_a52 out nocopy JTF_DATE_TABLE
1397 , p8_a53 out nocopy JTF_VARCHAR2_TABLE_100
1398 , p8_a54 out nocopy JTF_DATE_TABLE
1399 , p8_a55 out nocopy JTF_VARCHAR2_TABLE_100
1400 , p8_a56 out nocopy JTF_VARCHAR2_TABLE_100
1401 , p8_a57 out nocopy JTF_VARCHAR2_TABLE_300
1402 , p8_a58 out nocopy JTF_VARCHAR2_TABLE_100
1403 , p8_a59 out nocopy JTF_NUMBER_TABLE
1404 , p8_a60 out nocopy JTF_VARCHAR2_TABLE_100
1405 , p8_a61 out nocopy JTF_VARCHAR2_TABLE_100
1406 , p8_a62 out nocopy JTF_NUMBER_TABLE
1407 , p8_a63 out nocopy JTF_NUMBER_TABLE
1408 , p8_a64 out nocopy JTF_NUMBER_TABLE
1409 , p8_a65 out nocopy JTF_NUMBER_TABLE
1410 , p8_a66 out nocopy JTF_VARCHAR2_TABLE_100
1411 , p8_a67 out nocopy JTF_NUMBER_TABLE
1412 , p8_a68 out nocopy JTF_NUMBER_TABLE
1413 , p8_a69 out nocopy JTF_DATE_TABLE
1414 , p8_a70 out nocopy JTF_NUMBER_TABLE
1415 , p8_a71 out nocopy JTF_VARCHAR2_TABLE_100
1416 , p8_a72 out nocopy JTF_DATE_TABLE
1417 , p8_a73 out nocopy JTF_NUMBER_TABLE
1418 , p8_a74 out nocopy JTF_NUMBER_TABLE
1419 , p8_a75 out nocopy JTF_NUMBER_TABLE
1420 , p8_a76 out nocopy JTF_VARCHAR2_TABLE_100
1421 , p8_a77 out nocopy JTF_VARCHAR2_TABLE_100
1422 , p8_a78 out nocopy JTF_NUMBER_TABLE
1423 , p8_a79 out nocopy JTF_VARCHAR2_TABLE_100
1424 , p8_a80 out nocopy JTF_NUMBER_TABLE
1425 , p8_a81 out nocopy JTF_VARCHAR2_TABLE_100
1426 , p8_a82 out nocopy JTF_VARCHAR2_TABLE_100
1427 , p8_a83 out nocopy JTF_VARCHAR2_TABLE_100
1428 , p8_a84 out nocopy JTF_VARCHAR2_TABLE_100
1429 , p8_a85 out nocopy JTF_VARCHAR2_TABLE_100
1430 , p8_a86 out nocopy JTF_NUMBER_TABLE
1431 , p8_a87 out nocopy JTF_NUMBER_TABLE
1432 , p8_a88 out nocopy JTF_VARCHAR2_TABLE_100
1433 , p8_a89 out nocopy JTF_VARCHAR2_TABLE_300
1434 , p9_a0 out nocopy JTF_NUMBER_TABLE
1435 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1436 , p9_a2 out nocopy JTF_NUMBER_TABLE
1437 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
1438 , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
1439 , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
1440 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1441 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
1442 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1443 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_300
1444 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_300
1445 , p9_a11 out nocopy JTF_NUMBER_TABLE
1446 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1447 )
1448
1449 as
1450 ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1451 ddx_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1452 ddx_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1453 ddindx binary_integer; indx binary_integer;
1454 begin
1455
1456 -- copy data to the local IN or IN-OUT args, if any
1457
1458
1459
1460
1461
1462
1463 ozf_offer_pvt_oa.rosetta_table_copy_in_p2(ddp_modifier_line_tbl, p6_a0
1464 , p6_a1
1465 , p6_a2
1466 , p6_a3
1467 , p6_a4
1468 , p6_a5
1469 , p6_a6
1470 , p6_a7
1471 , p6_a8
1472 , p6_a9
1473 , p6_a10
1474 , p6_a11
1475 , p6_a12
1476 , p6_a13
1477 , p6_a14
1478 , p6_a15
1479 , p6_a16
1480 , p6_a17
1481 , p6_a18
1482 , p6_a19
1483 , p6_a20
1484 , p6_a21
1485 , p6_a22
1486 , p6_a23
1487 , p6_a24
1488 , p6_a25
1489 , p6_a26
1490 , p6_a27
1491 , p6_a28
1492 , p6_a29
1493 , p6_a30
1494 , p6_a31
1495 , p6_a32
1496 , p6_a33
1497 , p6_a34
1498 , p6_a35
1499 , p6_a36
1500 , p6_a37
1501 , p6_a38
1502 , p6_a39
1503 , p6_a40
1504 , p6_a41
1505 , p6_a42
1506 , p6_a43
1507 , p6_a44
1508 , p6_a45
1509 , p6_a46
1510 , p6_a47
1511 , p6_a48
1512 , p6_a49
1513 , p6_a50
1514 , p6_a51
1515 , p6_a52
1516 , p6_a53
1517 , p6_a54
1518 , p6_a55
1519 , p6_a56
1520 , p6_a57
1521 , p6_a58
1522 , p6_a59
1523 , p6_a60
1524 , p6_a61
1525 , p6_a62
1526 , p6_a63
1527 , p6_a64
1528 , p6_a65
1529 , p6_a66
1530 , p6_a67
1531 , p6_a68
1532 , p6_a69
1533 , p6_a70
1534 );
1535
1536
1537
1538
1539 -- here's the delegated call to the old PL/SQL routine
1540 ozf_offer_pvt.create_offer_tiers(p_init_msg_list,
1541 p_api_version,
1542 p_commit,
1543 x_return_status,
1544 x_msg_count,
1545 x_msg_data,
1546 ddp_modifier_line_tbl,
1547 x_error_location,
1548 ddx_modifiers_tbl,
1549 ddx_pricing_attr_tbl);
1550
1551 -- copy data back from the local variables to OUT or IN-OUT args, if any
1552
1553
1554
1555
1556
1557
1558
1559
1560 qp_modifiers_pub_oa.rosetta_table_copy_out_p3(ddx_modifiers_tbl, p8_a0
1561 , p8_a1
1562 , p8_a2
1563 , p8_a3
1564 , p8_a4
1565 , p8_a5
1566 , p8_a6
1567 , p8_a7
1568 , p8_a8
1569 , p8_a9
1570 , p8_a10
1571 , p8_a11
1572 , p8_a12
1573 , p8_a13
1574 , p8_a14
1575 , p8_a15
1576 , p8_a16
1577 , p8_a17
1578 , p8_a18
1579 , p8_a19
1580 , p8_a20
1581 , p8_a21
1582 , p8_a22
1583 , p8_a23
1584 , p8_a24
1585 , p8_a25
1586 , p8_a26
1587 , p8_a27
1588 , p8_a28
1589 , p8_a29
1590 , p8_a30
1591 , p8_a31
1592 , p8_a32
1593 , p8_a33
1594 , p8_a34
1595 , p8_a35
1596 , p8_a36
1597 , p8_a37
1598 , p8_a38
1599 , p8_a39
1600 , p8_a40
1601 , p8_a41
1602 , p8_a42
1603 , p8_a43
1604 , p8_a44
1605 , p8_a45
1606 , p8_a46
1607 , p8_a47
1608 , p8_a48
1609 , p8_a49
1610 , p8_a50
1611 , p8_a51
1612 , p8_a52
1613 , p8_a53
1614 , p8_a54
1615 , p8_a55
1616 , p8_a56
1617 , p8_a57
1618 , p8_a58
1619 , p8_a59
1620 , p8_a60
1621 , p8_a61
1622 , p8_a62
1623 , p8_a63
1624 , p8_a64
1625 , p8_a65
1626 , p8_a66
1627 , p8_a67
1628 , p8_a68
1629 , p8_a69
1630 , p8_a70
1631 , p8_a71
1632 , p8_a72
1633 , p8_a73
1634 , p8_a74
1635 , p8_a75
1636 , p8_a76
1637 , p8_a77
1638 , p8_a78
1639 , p8_a79
1640 , p8_a80
1641 , p8_a81
1642 , p8_a82
1643 , p8_a83
1644 , p8_a84
1645 , p8_a85
1646 , p8_a86
1647 , p8_a87
1648 , p8_a88
1649 , p8_a89
1650 );
1651
1652 qp_modifiers_pub_oa.rosetta_table_copy_out_p1(ddx_pricing_attr_tbl, p9_a0
1653 , p9_a1
1654 , p9_a2
1655 , p9_a3
1656 , p9_a4
1657 , p9_a5
1658 , p9_a6
1659 , p9_a7
1660 , p9_a8
1661 , p9_a9
1662 , p9_a10
1663 , p9_a11
1664 , p9_a12
1665 );
1666 end;
1667 */
1668 procedure process_market_qualifiers(p_init_msg_list VARCHAR2
1669 , p_api_version NUMBER
1670 , p_commit VARCHAR2
1671 , x_return_status out nocopy VARCHAR2
1672 , x_msg_count out nocopy NUMBER
1673 , x_msg_data out nocopy VARCHAR2
1674 , p6_a0 JTF_VARCHAR2_TABLE_100
1675 , p6_a1 JTF_VARCHAR2_TABLE_100
1676 , p6_a2 JTF_VARCHAR2_TABLE_300
1677 , p6_a3 JTF_VARCHAR2_TABLE_300
1678 , p6_a4 JTF_VARCHAR2_TABLE_100
1679 , p6_a5 JTF_NUMBER_TABLE
1680 , p6_a6 JTF_NUMBER_TABLE
1681 , p6_a7 JTF_NUMBER_TABLE
1682 , p6_a8 JTF_NUMBER_TABLE
1683 , p6_a9 JTF_DATE_TABLE
1684 , p6_a10 JTF_DATE_TABLE
1685 , p6_a11 JTF_NUMBER_TABLE
1686 , p6_a12 JTF_VARCHAR2_TABLE_100
1687 , p6_a13 JTF_VARCHAR2_TABLE_100
1688 , p6_a14 JTF_VARCHAR2_TABLE_300
1689 , p6_a15 JTF_VARCHAR2_TABLE_300
1690 , p6_a16 JTF_VARCHAR2_TABLE_300
1691 , p6_a17 JTF_VARCHAR2_TABLE_300
1692 , p6_a18 JTF_VARCHAR2_TABLE_300
1693 , p6_a19 JTF_VARCHAR2_TABLE_300
1694 , p6_a20 JTF_VARCHAR2_TABLE_300
1695 , p6_a21 JTF_VARCHAR2_TABLE_300
1696 , p6_a22 JTF_VARCHAR2_TABLE_300
1697 , p6_a23 JTF_VARCHAR2_TABLE_300
1698 , p6_a24 JTF_VARCHAR2_TABLE_300
1699 , p6_a25 JTF_VARCHAR2_TABLE_300
1700 , p6_a26 JTF_VARCHAR2_TABLE_300
1701 , p6_a27 JTF_VARCHAR2_TABLE_300
1702 , p6_a28 JTF_VARCHAR2_TABLE_300
1703 , x_error_location out nocopy NUMBER
1704 , p8_a0 out nocopy JTF_VARCHAR2_TABLE_300
1705 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
1706 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
1707 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_300
1708 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_300
1709 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_300
1710 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_300
1711 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_300
1712 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_300
1713 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_300
1714 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_300
1715 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_300
1716 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_300
1717 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_300
1718 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_300
1719 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1720 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1721 , p8_a17 out nocopy JTF_NUMBER_TABLE
1722 , p8_a18 out nocopy JTF_NUMBER_TABLE
1723 , p8_a19 out nocopy JTF_DATE_TABLE
1724 , p8_a20 out nocopy JTF_DATE_TABLE
1725 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
1726 , p8_a22 out nocopy JTF_NUMBER_TABLE
1727 , p8_a23 out nocopy JTF_DATE_TABLE
1728 , p8_a24 out nocopy JTF_NUMBER_TABLE
1729 , p8_a25 out nocopy JTF_NUMBER_TABLE
1730 , p8_a26 out nocopy JTF_NUMBER_TABLE
1731 , p8_a27 out nocopy JTF_NUMBER_TABLE
1732 , p8_a28 out nocopy JTF_NUMBER_TABLE
1733 , p8_a29 out nocopy JTF_DATE_TABLE
1734 , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
1735 , p8_a31 out nocopy JTF_VARCHAR2_TABLE_300
1736 , p8_a32 out nocopy JTF_VARCHAR2_TABLE_300
1737 , p8_a33 out nocopy JTF_VARCHAR2_TABLE_100
1738 , p8_a34 out nocopy JTF_VARCHAR2_TABLE_100
1739 , p8_a35 out nocopy JTF_NUMBER_TABLE
1740 , p8_a36 out nocopy JTF_NUMBER_TABLE
1741 , p8_a37 out nocopy JTF_NUMBER_TABLE
1742 , p8_a38 out nocopy JTF_NUMBER_TABLE
1743 , p8_a39 out nocopy JTF_NUMBER_TABLE
1744 , p8_a40 out nocopy JTF_DATE_TABLE
1745 , p8_a41 out nocopy JTF_VARCHAR2_TABLE_100
1746 , p8_a42 out nocopy JTF_NUMBER_TABLE
1747 , p8_a43 out nocopy JTF_NUMBER_TABLE
1748 , p8_a44 out nocopy JTF_VARCHAR2_TABLE_100
1749 , p8_a45 out nocopy JTF_NUMBER_TABLE
1750 , p8_a46 out nocopy JTF_NUMBER_TABLE
1751 , p8_a47 out nocopy JTF_VARCHAR2_TABLE_100
1752 , p8_a48 out nocopy JTF_NUMBER_TABLE
1753 , p8_a49 out nocopy JTF_VARCHAR2_TABLE_100
1754 , p8_a50 out nocopy JTF_VARCHAR2_TABLE_100
1755 , p8_a51 out nocopy JTF_VARCHAR2_TABLE_100
1756 )
1757
1758 as
1759 ddp_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
1760 ddx_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1761 ddindx binary_integer; indx binary_integer;
1762 begin
1763
1764 -- copy data to the local IN or IN-OUT args, if any
1765
1766
1767
1768
1769
1770
1771 ozf_offer_pvt_oa.rosetta_table_copy_in_p6(ddp_qualifiers_tbl, p6_a0
1772 , p6_a1
1773 , p6_a2
1774 , p6_a3
1775 , p6_a4
1776 , p6_a5
1777 , p6_a6
1778 , p6_a7
1779 , p6_a8
1780 , p6_a9
1781 , p6_a10
1782 , p6_a11
1783 , p6_a12
1784 , p6_a13
1785 , p6_a14
1786 , p6_a15
1787 , p6_a16
1788 , p6_a17
1789 , p6_a18
1790 , p6_a19
1791 , p6_a20
1792 , p6_a21
1793 , p6_a22
1794 , p6_a23
1795 , p6_a24
1796 , p6_a25
1797 , p6_a26
1798 , p6_a27
1799 , p6_a28
1800 );
1801
1802
1803
1804 -- here's the delegated call to the old PL/SQL routine
1805 ozf_offer_pvt.process_market_qualifiers(p_init_msg_list,
1806 p_api_version,
1807 p_commit,
1808 x_return_status,
1809 x_msg_count,
1810 x_msg_data,
1811 ddp_qualifiers_tbl,
1812 x_error_location,
1813 ddx_qualifiers_tbl);
1814
1815 -- copy data back from the local variables to OUT or IN-OUT args, if any
1816
1817
1818
1819
1820
1821
1822
1823
1824 qp_qualifier_rules_pub_oa.rosetta_table_copy_out_p1(ddx_qualifiers_tbl, p8_a0
1825 , p8_a1
1826 , p8_a2
1827 , p8_a3
1828 , p8_a4
1829 , p8_a5
1830 , p8_a6
1831 , p8_a7
1832 , p8_a8
1833 , p8_a9
1834 , p8_a10
1835 , p8_a11
1836 , p8_a12
1837 , p8_a13
1838 , p8_a14
1839 , p8_a15
1840 , p8_a16
1841 , p8_a17
1842 , p8_a18
1843 , p8_a19
1844 , p8_a20
1845 , p8_a21
1846 , p8_a22
1847 , p8_a23
1848 , p8_a24
1849 , p8_a25
1850 , p8_a26
1851 , p8_a27
1852 , p8_a28
1853 , p8_a29
1854 , p8_a30
1855 , p8_a31
1856 , p8_a32
1857 , p8_a33
1858 , p8_a34
1859 , p8_a35
1860 , p8_a36
1861 , p8_a37
1862 , p8_a38
1863 , p8_a39
1864 , p8_a40
1865 , p8_a41
1866 , p8_a42
1867 , p8_a43
1868 , p8_a44
1869 , p8_a45
1870 , p8_a46
1871 , p8_a47
1872 , p8_a48
1873 , p8_a49
1874 , p8_a50
1875 , p8_a51
1876 );
1877 end;
1878
1879 procedure process_exclusions(p_init_msg_list VARCHAR2
1880 , p_api_version NUMBER
1881 , p_commit VARCHAR2
1882 , x_return_status out nocopy VARCHAR2
1883 , x_msg_count out nocopy NUMBER
1884 , x_msg_data out nocopy VARCHAR2
1885 , p6_a0 JTF_NUMBER_TABLE
1886 , p6_a1 JTF_VARCHAR2_TABLE_100
1887 , p6_a2 JTF_NUMBER_TABLE
1888 , p6_a3 JTF_VARCHAR2_TABLE_100
1889 , p6_a4 JTF_VARCHAR2_TABLE_100
1890 , p6_a5 JTF_VARCHAR2_TABLE_300
1891 , p6_a6 JTF_VARCHAR2_TABLE_100
1892 , p6_a7 JTF_VARCHAR2_TABLE_100
1893 , p6_a8 JTF_VARCHAR2_TABLE_100
1894 , p6_a9 JTF_VARCHAR2_TABLE_300
1895 , p6_a10 JTF_VARCHAR2_TABLE_300
1896 , p6_a11 JTF_NUMBER_TABLE
1897 , p6_a12 JTF_VARCHAR2_TABLE_100
1898 , x_error_location out nocopy NUMBER
1899 )
1900
1901 as
1902 ddp_pricing_attr_tbl ozf_offer_pvt.pricing_attr_tbl_type;
1903 ddindx binary_integer; indx binary_integer;
1904 begin
1905
1906 -- copy data to the local IN or IN-OUT args, if any
1907
1908
1909
1910
1911
1912
1913 ozf_offer_pvt_oa.rosetta_table_copy_in_p4(ddp_pricing_attr_tbl, p6_a0
1914 , p6_a1
1915 , p6_a2
1916 , p6_a3
1917 , p6_a4
1918 , p6_a5
1919 , p6_a6
1920 , p6_a7
1921 , p6_a8
1922 , p6_a9
1923 , p6_a10
1924 , p6_a11
1925 , p6_a12
1926 );
1927
1928
1929 -- here's the delegated call to the old PL/SQL routine
1930 ozf_offer_pvt.process_exclusions(p_init_msg_list,
1931 p_api_version,
1932 p_commit,
1933 x_return_status,
1934 x_msg_count,
1935 x_msg_data,
1936 ddp_pricing_attr_tbl,
1937 x_error_location);
1938
1939 -- copy data back from the local variables to OUT or IN-OUT args, if any
1940
1941
1942
1943
1944
1945
1946
1947 end;
1948
1949 procedure process_adv_options(p_init_msg_list VARCHAR2
1950 , p_api_version NUMBER
1951 , p_commit VARCHAR2
1952 , x_return_status out nocopy VARCHAR2
1953 , x_msg_count out nocopy NUMBER
1954 , x_msg_data out nocopy VARCHAR2
1955 , p6_a0 NUMBER
1956 , p6_a1 NUMBER
1957 , p6_a2 VARCHAR2
1958 , p6_a3 VARCHAR2
1959 , p6_a4 NUMBER
1960 , p6_a5 VARCHAR2
1961 , p6_a6 NUMBER
1962 , p6_a7 NUMBER
1963 , p6_a8 VARCHAR2
1964 , p6_a9 VARCHAR2
1965 , p6_a10 NUMBER
1966 , p6_a11 VARCHAR2
1967 , p6_a12 VARCHAR2
1968 , p6_a13 NUMBER
1969 )
1970
1971 as
1972 ddp_advanced_options_rec ozf_offer_pvt.advanced_option_rec_type;
1973 ddindx binary_integer; indx binary_integer;
1974 begin
1975
1976 -- copy data to the local IN or IN-OUT args, if any
1977
1978
1979
1980
1981
1982
1983 ddp_advanced_options_rec.list_line_id := p6_a0;
1984 ddp_advanced_options_rec.list_header_id := p6_a1;
1985 ddp_advanced_options_rec.offer_type := p6_a2;
1986 ddp_advanced_options_rec.modifier_level_code := p6_a3;
1987 ddp_advanced_options_rec.pricing_phase_id := p6_a4;
1988 ddp_advanced_options_rec.incompatibility_grp_code := p6_a5;
1989 ddp_advanced_options_rec.product_precedence := p6_a6;
1990 ddp_advanced_options_rec.pricing_group_sequence := p6_a7;
1991 ddp_advanced_options_rec.print_on_invoice_flag := p6_a8;
1992 ddp_advanced_options_rec.autopay_flag := p6_a9;
1993 ddp_advanced_options_rec.autopay_days := p6_a10;
1994 ddp_advanced_options_rec.autopay_method := p6_a11;
1995 ddp_advanced_options_rec.autopay_party_attr := p6_a12;
1996 ddp_advanced_options_rec.autopay_party_id := p6_a13;
1997
1998 -- here's the delegated call to the old PL/SQL routine
1999 ozf_offer_pvt.process_adv_options(p_init_msg_list,
2000 p_api_version,
2001 p_commit,
2002 x_return_status,
2003 x_msg_count,
2004 x_msg_data,
2005 ddp_advanced_options_rec);
2006
2007 -- copy data back from the local variables to OUT or IN-OUT args, if any
2008
2009
2010
2011
2012
2013
2014 end;
2015
2016 procedure activate_offer_over(p_init_msg_list VARCHAR2
2017 , p_api_version NUMBER
2018 , p_commit VARCHAR2
2019 , x_return_status out nocopy VARCHAR2
2020 , x_msg_count out nocopy NUMBER
2021 , x_msg_data out nocopy VARCHAR2
2022 , p_called_from VARCHAR2
2023 , p7_a0 NUMBER
2024 , p7_a1 NUMBER
2025 , p7_a2 VARCHAR2
2026 , p7_a3 VARCHAR2
2027 , p7_a4 NUMBER
2028 , p7_a5 VARCHAR2
2029 , p7_a6 NUMBER
2030 , p7_a7 NUMBER
2031 , p7_a8 VARCHAR2
2032 , p7_a9 VARCHAR2
2033 , p7_a10 NUMBER
2034 , p7_a11 NUMBER
2035 , p7_a12 DATE
2036 , p7_a13 DATE
2037 , p7_a14 VARCHAR2
2038 , p7_a15 DATE
2039 , p7_a16 VARCHAR2
2040 , p7_a17 VARCHAR2
2041 , p7_a18 NUMBER
2042 , p7_a19 VARCHAR2
2043 , p7_a20 NUMBER
2044 , p7_a21 NUMBER
2045 , p7_a22 NUMBER
2046 , p7_a23 NUMBER
2047 , p7_a24 VARCHAR2
2048 , p7_a25 VARCHAR2
2049 , p7_a26 VARCHAR2
2050 , p7_a27 VARCHAR2
2051 , p7_a28 VARCHAR2
2052 , p7_a29 VARCHAR2
2053 , p7_a30 VARCHAR2
2054 , p7_a31 VARCHAR2
2055 , p7_a32 VARCHAR2
2056 , p7_a33 VARCHAR2
2057 , p7_a34 VARCHAR2
2058 , p7_a35 VARCHAR2
2059 , p7_a36 VARCHAR2
2060 , p7_a37 VARCHAR2
2061 , p7_a38 VARCHAR2
2062 , p7_a39 VARCHAR2
2063 , p7_a40 VARCHAR2
2064 , p7_a41 VARCHAR2
2065 , p7_a42 VARCHAR2
2066 , p7_a43 DATE
2067 , p7_a44 DATE
2068 , p7_a45 VARCHAR2
2069 , p7_a46 VARCHAR2
2070 , p7_a47 VARCHAR2
2071 , p7_a48 VARCHAR2
2072 , p7_a49 VARCHAR2
2073 , p7_a50 VARCHAR2
2074 , p7_a51 DATE
2075 , p7_a52 DATE
2076 , p7_a53 VARCHAR2
2077 , p7_a54 DATE
2078 , p7_a55 DATE
2079 , p7_a56 VARCHAR2
2080 , p7_a57 VARCHAR2
2081 , p7_a58 NUMBER
2082 , p7_a59 NUMBER
2083 , p7_a60 VARCHAR2
2084 , p7_a61 NUMBER
2085 , p7_a62 VARCHAR2
2086 , p7_a63 VARCHAR2
2087 , p7_a64 NUMBER
2088 , p7_a65 VARCHAR2
2089 , p7_a66 NUMBER
2090 , p7_a67 NUMBER
2091 , p7_a68 VARCHAR2
2092 , p7_a69 VARCHAR2
2093 , p7_a70 VARCHAR2
2094 , p7_a71 VARCHAR2
2095 , p7_a72 VARCHAR2
2096 , p7_a73 VARCHAR2
2097 , p7_a74 VARCHAR2
2098 , p7_a75 VARCHAR2
2099 , p7_a76 VARCHAR2
2100 , p7_a77 VARCHAR2
2101 , p7_a78 VARCHAR2
2102 , p7_a79 NUMBER
2103 , p7_a80 VARCHAR2
2104 , p7_a81 VARCHAR2
2105 , p7_a82 NUMBER
2106 , x_amount_error out nocopy VARCHAR2
2107 )
2108
2109 as
2110 ddp_offer_rec ozf_offer_pvt.modifier_list_rec_type;
2111 ddindx binary_integer; indx binary_integer;
2112 begin
2113
2114 -- copy data to the local IN or IN-OUT args, if any
2115
2116
2117
2118
2119
2120
2121
2122 ddp_offer_rec.offer_id := p7_a0;
2123 ddp_offer_rec.qp_list_header_id := p7_a1;
2124 ddp_offer_rec.offer_type := p7_a2;
2125 ddp_offer_rec.offer_code := p7_a3;
2126 ddp_offer_rec.activity_media_id := p7_a4;
2127 ddp_offer_rec.reusable := p7_a5;
2128 ddp_offer_rec.user_status_id := p7_a6;
2129 ddp_offer_rec.owner_id := p7_a7;
2130 ddp_offer_rec.wf_item_key := p7_a8;
2131 ddp_offer_rec.customer_reference := p7_a9;
2132 ddp_offer_rec.buying_group_contact_id := p7_a10;
2133 ddp_offer_rec.object_version_number := p7_a11;
2134 ddp_offer_rec.perf_date_from := p7_a12;
2135 ddp_offer_rec.perf_date_to := p7_a13;
2136 ddp_offer_rec.status_code := p7_a14;
2137 ddp_offer_rec.status_date := p7_a15;
2138 ddp_offer_rec.modifier_level_code := p7_a16;
2139 ddp_offer_rec.order_value_discount_type := p7_a17;
2140 ddp_offer_rec.lumpsum_amount := p7_a18;
2141 ddp_offer_rec.lumpsum_payment_type := p7_a19;
2142 ddp_offer_rec.custom_setup_id := p7_a20;
2143 ddp_offer_rec.offer_amount := p7_a21;
2144 ddp_offer_rec.budget_amount_tc := p7_a22;
2145 ddp_offer_rec.budget_amount_fc := p7_a23;
2146 ddp_offer_rec.transaction_currency_code := p7_a24;
2147 ddp_offer_rec.functional_currency_code := p7_a25;
2148 ddp_offer_rec.context := p7_a26;
2149 ddp_offer_rec.attribute1 := p7_a27;
2150 ddp_offer_rec.attribute2 := p7_a28;
2151 ddp_offer_rec.attribute3 := p7_a29;
2152 ddp_offer_rec.attribute4 := p7_a30;
2153 ddp_offer_rec.attribute5 := p7_a31;
2154 ddp_offer_rec.attribute6 := p7_a32;
2155 ddp_offer_rec.attribute7 := p7_a33;
2156 ddp_offer_rec.attribute8 := p7_a34;
2157 ddp_offer_rec.attribute9 := p7_a35;
2158 ddp_offer_rec.attribute10 := p7_a36;
2159 ddp_offer_rec.attribute11 := p7_a37;
2160 ddp_offer_rec.attribute12 := p7_a38;
2161 ddp_offer_rec.attribute13 := p7_a39;
2162 ddp_offer_rec.attribute14 := p7_a40;
2163 ddp_offer_rec.attribute15 := p7_a41;
2164 ddp_offer_rec.currency_code := p7_a42;
2165 ddp_offer_rec.start_date_active := p7_a43;
2166 ddp_offer_rec.end_date_active := p7_a44;
2167 ddp_offer_rec.list_type_code := p7_a45;
2168 ddp_offer_rec.discount_lines_flag := p7_a46;
2169 ddp_offer_rec.name := p7_a47;
2170 ddp_offer_rec.description := p7_a48;
2171 ddp_offer_rec.comments := p7_a49;
2172 ddp_offer_rec.ask_for_flag := p7_a50;
2173 ddp_offer_rec.start_date_active_first := p7_a51;
2174 ddp_offer_rec.end_date_active_first := p7_a52;
2175 ddp_offer_rec.active_date_first_type := p7_a53;
2176 ddp_offer_rec.start_date_active_second := p7_a54;
2177 ddp_offer_rec.end_date_active_second := p7_a55;
2178 ddp_offer_rec.active_date_second_type := p7_a56;
2179 ddp_offer_rec.active_flag := p7_a57;
2180 ddp_offer_rec.max_no_of_uses := p7_a58;
2181 ddp_offer_rec.budget_source_id := p7_a59;
2182 ddp_offer_rec.budget_source_type := p7_a60;
2183 ddp_offer_rec.offer_used_by_id := p7_a61;
2184 ddp_offer_rec.offer_used_by := p7_a62;
2185 ddp_offer_rec.ql_qualifier_type := p7_a63;
2186 ddp_offer_rec.ql_qualifier_id := p7_a64;
2187 ddp_offer_rec.distribution_type := p7_a65;
2188 ddp_offer_rec.amount_limit_id := p7_a66;
2189 ddp_offer_rec.uses_limit_id := p7_a67;
2190 ddp_offer_rec.offer_operation := p7_a68;
2191 ddp_offer_rec.modifier_operation := p7_a69;
2192 ddp_offer_rec.budget_offer_yn := p7_a70;
2193 ddp_offer_rec.break_type := p7_a71;
2194 ddp_offer_rec.retroactive := p7_a72;
2195 ddp_offer_rec.volume_offer_type := p7_a73;
2196 ddp_offer_rec.confidential_flag := p7_a74;
2197 ddp_offer_rec.committed_amount_eq_max := p7_a75;
2198 ddp_offer_rec.source_from_parent := p7_a76;
2199 ddp_offer_rec.buyer_name := p7_a77;
2200 ddp_offer_rec.tier_level := p7_a78;
2201 ddp_offer_rec.na_rule_header_id := p7_a79;
2202 ddp_offer_rec.sales_method_flag := p7_a80;
2203 ddp_offer_rec.global_flag := p7_a81;
2204 ddp_offer_rec.orig_org_id := p7_a82;
2205
2206
2207 -- here's the delegated call to the old PL/SQL routine
2208 ozf_offer_pvt.activate_offer_over(p_init_msg_list,
2209 p_api_version,
2210 p_commit,
2211 x_return_status,
2212 x_msg_count,
2213 x_msg_data,
2214 p_called_from,
2215 ddp_offer_rec,
2216 x_amount_error);
2217
2218 -- copy data back from the local variables to OUT or IN-OUT args, if any
2219
2220
2221
2222
2223
2224
2225
2226
2227 end;
2228
2229 procedure update_offer_status(p_commit VARCHAR2
2230 , x_return_status out nocopy VARCHAR2
2231 , x_msg_count out nocopy NUMBER
2232 , x_msg_data out nocopy VARCHAR2
2233 , p4_a0 NUMBER
2234 , p4_a1 NUMBER
2235 , p4_a2 VARCHAR2
2236 , p4_a3 VARCHAR2
2237 , p4_a4 NUMBER
2238 , p4_a5 VARCHAR2
2239 , p4_a6 NUMBER
2240 , p4_a7 NUMBER
2241 , p4_a8 VARCHAR2
2242 , p4_a9 VARCHAR2
2243 , p4_a10 NUMBER
2244 , p4_a11 NUMBER
2245 , p4_a12 DATE
2246 , p4_a13 DATE
2247 , p4_a14 VARCHAR2
2248 , p4_a15 DATE
2249 , p4_a16 VARCHAR2
2250 , p4_a17 VARCHAR2
2251 , p4_a18 NUMBER
2252 , p4_a19 VARCHAR2
2253 , p4_a20 NUMBER
2254 , p4_a21 NUMBER
2255 , p4_a22 NUMBER
2256 , p4_a23 NUMBER
2257 , p4_a24 VARCHAR2
2258 , p4_a25 VARCHAR2
2259 , p4_a26 VARCHAR2
2260 , p4_a27 VARCHAR2
2261 , p4_a28 VARCHAR2
2262 , p4_a29 VARCHAR2
2263 , p4_a30 VARCHAR2
2264 , p4_a31 VARCHAR2
2265 , p4_a32 VARCHAR2
2266 , p4_a33 VARCHAR2
2267 , p4_a34 VARCHAR2
2268 , p4_a35 VARCHAR2
2269 , p4_a36 VARCHAR2
2270 , p4_a37 VARCHAR2
2271 , p4_a38 VARCHAR2
2272 , p4_a39 VARCHAR2
2273 , p4_a40 VARCHAR2
2274 , p4_a41 VARCHAR2
2275 , p4_a42 VARCHAR2
2276 , p4_a43 DATE
2277 , p4_a44 DATE
2278 , p4_a45 VARCHAR2
2279 , p4_a46 VARCHAR2
2280 , p4_a47 VARCHAR2
2281 , p4_a48 VARCHAR2
2282 , p4_a49 VARCHAR2
2283 , p4_a50 VARCHAR2
2284 , p4_a51 DATE
2285 , p4_a52 DATE
2286 , p4_a53 VARCHAR2
2287 , p4_a54 DATE
2288 , p4_a55 DATE
2289 , p4_a56 VARCHAR2
2290 , p4_a57 VARCHAR2
2291 , p4_a58 NUMBER
2292 , p4_a59 NUMBER
2293 , p4_a60 VARCHAR2
2294 , p4_a61 NUMBER
2295 , p4_a62 VARCHAR2
2296 , p4_a63 VARCHAR2
2297 , p4_a64 NUMBER
2298 , p4_a65 VARCHAR2
2299 , p4_a66 NUMBER
2300 , p4_a67 NUMBER
2301 , p4_a68 VARCHAR2
2302 , p4_a69 VARCHAR2
2303 , p4_a70 VARCHAR2
2304 , p4_a71 VARCHAR2
2305 , p4_a72 VARCHAR2
2306 , p4_a73 VARCHAR2
2307 , p4_a74 VARCHAR2
2308 , p4_a75 VARCHAR2
2309 , p4_a76 VARCHAR2
2310 , p4_a77 VARCHAR2
2311 , p4_a78 VARCHAR2
2312 , p4_a79 NUMBER
2313 , p4_a80 VARCHAR2
2314 , p4_a81 VARCHAR2
2315 , p4_a82 NUMBER
2316 )
2317
2318 as
2319 ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
2320 ddindx binary_integer; indx binary_integer;
2321 begin
2322
2323 -- copy data to the local IN or IN-OUT args, if any
2324
2325
2326
2327
2328 ddp_modifier_list_rec.offer_id := p4_a0;
2329 ddp_modifier_list_rec.qp_list_header_id := p4_a1;
2330 ddp_modifier_list_rec.offer_type := p4_a2;
2331 ddp_modifier_list_rec.offer_code := p4_a3;
2332 ddp_modifier_list_rec.activity_media_id := p4_a4;
2333 ddp_modifier_list_rec.reusable := p4_a5;
2334 ddp_modifier_list_rec.user_status_id := p4_a6;
2335 ddp_modifier_list_rec.owner_id := p4_a7;
2336 ddp_modifier_list_rec.wf_item_key := p4_a8;
2337 ddp_modifier_list_rec.customer_reference := p4_a9;
2338 ddp_modifier_list_rec.buying_group_contact_id := p4_a10;
2339 ddp_modifier_list_rec.object_version_number := p4_a11;
2340 ddp_modifier_list_rec.perf_date_from := p4_a12;
2341 ddp_modifier_list_rec.perf_date_to := p4_a13;
2342 ddp_modifier_list_rec.status_code := p4_a14;
2343 ddp_modifier_list_rec.status_date := p4_a15;
2344 ddp_modifier_list_rec.modifier_level_code := p4_a16;
2345 ddp_modifier_list_rec.order_value_discount_type := p4_a17;
2346 ddp_modifier_list_rec.lumpsum_amount := p4_a18;
2347 ddp_modifier_list_rec.lumpsum_payment_type := p4_a19;
2348 ddp_modifier_list_rec.custom_setup_id := p4_a20;
2349 ddp_modifier_list_rec.offer_amount := p4_a21;
2350 ddp_modifier_list_rec.budget_amount_tc := p4_a22;
2351 ddp_modifier_list_rec.budget_amount_fc := p4_a23;
2352 ddp_modifier_list_rec.transaction_currency_code := p4_a24;
2353 ddp_modifier_list_rec.functional_currency_code := p4_a25;
2354 ddp_modifier_list_rec.context := p4_a26;
2355 ddp_modifier_list_rec.attribute1 := p4_a27;
2356 ddp_modifier_list_rec.attribute2 := p4_a28;
2357 ddp_modifier_list_rec.attribute3 := p4_a29;
2358 ddp_modifier_list_rec.attribute4 := p4_a30;
2359 ddp_modifier_list_rec.attribute5 := p4_a31;
2360 ddp_modifier_list_rec.attribute6 := p4_a32;
2361 ddp_modifier_list_rec.attribute7 := p4_a33;
2362 ddp_modifier_list_rec.attribute8 := p4_a34;
2363 ddp_modifier_list_rec.attribute9 := p4_a35;
2364 ddp_modifier_list_rec.attribute10 := p4_a36;
2365 ddp_modifier_list_rec.attribute11 := p4_a37;
2366 ddp_modifier_list_rec.attribute12 := p4_a38;
2367 ddp_modifier_list_rec.attribute13 := p4_a39;
2368 ddp_modifier_list_rec.attribute14 := p4_a40;
2369 ddp_modifier_list_rec.attribute15 := p4_a41;
2370 ddp_modifier_list_rec.currency_code := p4_a42;
2371 ddp_modifier_list_rec.start_date_active := p4_a43;
2372 ddp_modifier_list_rec.end_date_active := p4_a44;
2373 ddp_modifier_list_rec.list_type_code := p4_a45;
2374 ddp_modifier_list_rec.discount_lines_flag := p4_a46;
2375 ddp_modifier_list_rec.name := p4_a47;
2376 ddp_modifier_list_rec.description := p4_a48;
2377 ddp_modifier_list_rec.comments := p4_a49;
2378 ddp_modifier_list_rec.ask_for_flag := p4_a50;
2379 ddp_modifier_list_rec.start_date_active_first := p4_a51;
2380 ddp_modifier_list_rec.end_date_active_first := p4_a52;
2381 ddp_modifier_list_rec.active_date_first_type := p4_a53;
2382 ddp_modifier_list_rec.start_date_active_second := p4_a54;
2383 ddp_modifier_list_rec.end_date_active_second := p4_a55;
2384 ddp_modifier_list_rec.active_date_second_type := p4_a56;
2385 ddp_modifier_list_rec.active_flag := p4_a57;
2386 ddp_modifier_list_rec.max_no_of_uses := p4_a58;
2387 ddp_modifier_list_rec.budget_source_id := p4_a59;
2388 ddp_modifier_list_rec.budget_source_type := p4_a60;
2389 ddp_modifier_list_rec.offer_used_by_id := p4_a61;
2390 ddp_modifier_list_rec.offer_used_by := p4_a62;
2391 ddp_modifier_list_rec.ql_qualifier_type := p4_a63;
2392 ddp_modifier_list_rec.ql_qualifier_id := p4_a64;
2393 ddp_modifier_list_rec.distribution_type := p4_a65;
2394 ddp_modifier_list_rec.amount_limit_id := p4_a66;
2395 ddp_modifier_list_rec.uses_limit_id := p4_a67;
2396 ddp_modifier_list_rec.offer_operation := p4_a68;
2397 ddp_modifier_list_rec.modifier_operation := p4_a69;
2398 ddp_modifier_list_rec.budget_offer_yn := p4_a70;
2399 ddp_modifier_list_rec.break_type := p4_a71;
2400 ddp_modifier_list_rec.retroactive := p4_a72;
2401 ddp_modifier_list_rec.volume_offer_type := p4_a73;
2402 ddp_modifier_list_rec.confidential_flag := p4_a74;
2403 ddp_modifier_list_rec.committed_amount_eq_max := p4_a75;
2404 ddp_modifier_list_rec.source_from_parent := p4_a76;
2405 ddp_modifier_list_rec.buyer_name := p4_a77;
2406 ddp_modifier_list_rec.tier_level := p4_a78;
2407 ddp_modifier_list_rec.na_rule_header_id := p4_a79;
2408 ddp_modifier_list_rec.sales_method_flag := p4_a80;
2409 ddp_modifier_list_rec.global_flag := p4_a81;
2410 ddp_modifier_list_rec.orig_org_id := p4_a82;
2411
2412 -- here's the delegated call to the old PL/SQL routine
2413 ozf_offer_pvt.update_offer_status(p_commit,
2414 x_return_status,
2415 x_msg_count,
2416 x_msg_data,
2417 ddp_modifier_list_rec);
2418
2419 -- copy data back from the local variables to OUT or IN-OUT args, if any
2420
2421
2422
2423
2424 end;
2425
2426 procedure process_qp_list_lines(x_return_status out nocopy VARCHAR2
2427 , x_msg_count out nocopy NUMBER
2428 , x_msg_data out nocopy VARCHAR2
2429 , p_offer_type VARCHAR2
2430 , p4_a0 JTF_VARCHAR2_TABLE_100
2431 , p4_a1 JTF_VARCHAR2_TABLE_100
2432 , p4_a2 JTF_NUMBER_TABLE
2433 , p4_a3 JTF_NUMBER_TABLE
2434 , p4_a4 JTF_VARCHAR2_TABLE_100
2435 , p4_a5 JTF_NUMBER_TABLE
2436 , p4_a6 JTF_DATE_TABLE
2437 , p4_a7 JTF_DATE_TABLE
2438 , p4_a8 JTF_VARCHAR2_TABLE_100
2439 , p4_a9 JTF_VARCHAR2_TABLE_100
2440 , p4_a10 JTF_NUMBER_TABLE
2441 , p4_a11 JTF_VARCHAR2_TABLE_100
2442 , p4_a12 JTF_NUMBER_TABLE
2443 , p4_a13 JTF_NUMBER_TABLE
2444 , p4_a14 JTF_VARCHAR2_TABLE_100
2445 , p4_a15 JTF_NUMBER_TABLE
2446 , p4_a16 JTF_VARCHAR2_TABLE_100
2447 , p4_a17 JTF_NUMBER_TABLE
2448 , p4_a18 JTF_NUMBER_TABLE
2449 , p4_a19 JTF_NUMBER_TABLE
2450 , p4_a20 JTF_NUMBER_TABLE
2451 , p4_a21 JTF_VARCHAR2_TABLE_100
2452 , p4_a22 JTF_VARCHAR2_TABLE_100
2453 , p4_a23 JTF_VARCHAR2_TABLE_100
2454 , p4_a24 JTF_VARCHAR2_TABLE_300
2455 , p4_a25 JTF_VARCHAR2_TABLE_100
2456 , p4_a26 JTF_NUMBER_TABLE
2457 , p4_a27 JTF_VARCHAR2_TABLE_100
2458 , p4_a28 JTF_VARCHAR2_TABLE_100
2459 , p4_a29 JTF_VARCHAR2_TABLE_300
2460 , p4_a30 JTF_VARCHAR2_TABLE_100
2461 , p4_a31 JTF_VARCHAR2_TABLE_100
2462 , p4_a32 JTF_VARCHAR2_TABLE_100
2463 , p4_a33 JTF_VARCHAR2_TABLE_300
2464 , p4_a34 JTF_VARCHAR2_TABLE_300
2465 , p4_a35 JTF_VARCHAR2_TABLE_100
2466 , p4_a36 JTF_VARCHAR2_TABLE_300
2467 , p4_a37 JTF_VARCHAR2_TABLE_300
2468 , p4_a38 JTF_NUMBER_TABLE
2469 , p4_a39 JTF_VARCHAR2_TABLE_2000
2470 , p4_a40 JTF_VARCHAR2_TABLE_100
2471 , p4_a41 JTF_VARCHAR2_TABLE_300
2472 , p4_a42 JTF_VARCHAR2_TABLE_300
2473 , p4_a43 JTF_VARCHAR2_TABLE_300
2474 , p4_a44 JTF_VARCHAR2_TABLE_300
2475 , p4_a45 JTF_VARCHAR2_TABLE_300
2476 , p4_a46 JTF_VARCHAR2_TABLE_300
2477 , p4_a47 JTF_VARCHAR2_TABLE_300
2478 , p4_a48 JTF_VARCHAR2_TABLE_300
2479 , p4_a49 JTF_VARCHAR2_TABLE_300
2480 , p4_a50 JTF_VARCHAR2_TABLE_300
2481 , p4_a51 JTF_VARCHAR2_TABLE_300
2482 , p4_a52 JTF_VARCHAR2_TABLE_300
2483 , p4_a53 JTF_VARCHAR2_TABLE_300
2484 , p4_a54 JTF_VARCHAR2_TABLE_300
2485 , p4_a55 JTF_VARCHAR2_TABLE_300
2486 , p4_a56 JTF_NUMBER_TABLE
2487 , p4_a57 JTF_NUMBER_TABLE
2488 , p4_a58 JTF_NUMBER_TABLE
2489 , p4_a59 JTF_NUMBER_TABLE
2490 , p4_a60 JTF_NUMBER_TABLE
2491 , p4_a61 JTF_NUMBER_TABLE
2492 , p4_a62 JTF_NUMBER_TABLE
2493 , p4_a63 JTF_NUMBER_TABLE
2494 , p4_a64 JTF_NUMBER_TABLE
2495 , p4_a65 JTF_NUMBER_TABLE
2496 , p4_a66 JTF_VARCHAR2_TABLE_100
2497 , p4_a67 JTF_NUMBER_TABLE
2498 , p4_a68 JTF_NUMBER_TABLE
2499 , p4_a69 JTF_VARCHAR2_TABLE_300
2500 , p4_a70 JTF_VARCHAR2_TABLE_300
2501 , p_list_header_id NUMBER
2502 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2503 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
2504 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
2505 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
2506 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2507 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
2508 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
2509 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
2510 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
2511 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
2512 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
2513 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
2514 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
2515 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
2516 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
2517 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_300
2518 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2519 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
2520 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
2521 , p6_a19 out nocopy JTF_NUMBER_TABLE
2522 , p6_a20 out nocopy JTF_DATE_TABLE
2523 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2524 , p6_a22 out nocopy JTF_DATE_TABLE
2525 , p6_a23 out nocopy JTF_NUMBER_TABLE
2526 , p6_a24 out nocopy JTF_NUMBER_TABLE
2527 , p6_a25 out nocopy JTF_NUMBER_TABLE
2528 , p6_a26 out nocopy JTF_NUMBER_TABLE
2529 , p6_a27 out nocopy JTF_DATE_TABLE
2530 , p6_a28 out nocopy JTF_NUMBER_TABLE
2531 , p6_a29 out nocopy JTF_NUMBER_TABLE
2532 , p6_a30 out nocopy JTF_NUMBER_TABLE
2533 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2534 , p6_a32 out nocopy JTF_NUMBER_TABLE
2535 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
2536 , p6_a34 out nocopy JTF_NUMBER_TABLE
2537 , p6_a35 out nocopy JTF_NUMBER_TABLE
2538 , p6_a36 out nocopy JTF_NUMBER_TABLE
2539 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
2540 , p6_a38 out nocopy JTF_NUMBER_TABLE
2541 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
2542 , p6_a40 out nocopy JTF_NUMBER_TABLE
2543 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
2544 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
2545 , p6_a43 out nocopy JTF_NUMBER_TABLE
2546 , p6_a44 out nocopy JTF_NUMBER_TABLE
2547 , p6_a45 out nocopy JTF_DATE_TABLE
2548 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
2549 , p6_a47 out nocopy JTF_NUMBER_TABLE
2550 , p6_a48 out nocopy JTF_NUMBER_TABLE
2551 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
2552 , p6_a50 out nocopy JTF_NUMBER_TABLE
2553 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
2554 , p6_a52 out nocopy JTF_DATE_TABLE
2555 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
2556 , p6_a54 out nocopy JTF_DATE_TABLE
2557 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
2558 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
2559 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_300
2560 , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
2561 , p6_a59 out nocopy JTF_NUMBER_TABLE
2562 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
2563 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
2564 , p6_a62 out nocopy JTF_NUMBER_TABLE
2565 , p6_a63 out nocopy JTF_NUMBER_TABLE
2566 , p6_a64 out nocopy JTF_NUMBER_TABLE
2567 , p6_a65 out nocopy JTF_NUMBER_TABLE
2568 , p6_a66 out nocopy JTF_VARCHAR2_TABLE_100
2569 , p6_a67 out nocopy JTF_NUMBER_TABLE
2570 , p6_a68 out nocopy JTF_NUMBER_TABLE
2571 , p6_a69 out nocopy JTF_DATE_TABLE
2572 , p6_a70 out nocopy JTF_NUMBER_TABLE
2573 , p6_a71 out nocopy JTF_VARCHAR2_TABLE_100
2574 , p6_a72 out nocopy JTF_DATE_TABLE
2575 , p6_a73 out nocopy JTF_NUMBER_TABLE
2576 , p6_a74 out nocopy JTF_NUMBER_TABLE
2577 , p6_a75 out nocopy JTF_NUMBER_TABLE
2578 , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
2579 , p6_a77 out nocopy JTF_VARCHAR2_TABLE_100
2580 , p6_a78 out nocopy JTF_NUMBER_TABLE
2581 , p6_a79 out nocopy JTF_VARCHAR2_TABLE_100
2582 , p6_a80 out nocopy JTF_NUMBER_TABLE
2583 , p6_a81 out nocopy JTF_VARCHAR2_TABLE_100
2584 , p6_a82 out nocopy JTF_VARCHAR2_TABLE_100
2585 , p6_a83 out nocopy JTF_VARCHAR2_TABLE_100
2586 , p6_a84 out nocopy JTF_VARCHAR2_TABLE_100
2587 , p6_a85 out nocopy JTF_VARCHAR2_TABLE_100
2588 , p6_a86 out nocopy JTF_NUMBER_TABLE
2589 , p6_a87 out nocopy JTF_NUMBER_TABLE
2590 , p6_a88 out nocopy JTF_VARCHAR2_TABLE_100
2591 , p6_a89 out nocopy JTF_VARCHAR2_TABLE_300
2592 , x_error_location out nocopy NUMBER
2593 )
2594
2595 as
2596 ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
2597 ddx_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
2598 ddindx binary_integer; indx binary_integer;
2599 begin
2600
2601 -- copy data to the local IN or IN-OUT args, if any
2602
2603
2604
2605
2606 ozf_offer_pvt_oa.rosetta_table_copy_in_p2(ddp_modifier_line_tbl, p4_a0
2607 , p4_a1
2608 , p4_a2
2609 , p4_a3
2610 , p4_a4
2611 , p4_a5
2612 , p4_a6
2613 , p4_a7
2614 , p4_a8
2615 , p4_a9
2616 , p4_a10
2617 , p4_a11
2618 , p4_a12
2619 , p4_a13
2620 , p4_a14
2621 , p4_a15
2622 , p4_a16
2623 , p4_a17
2624 , p4_a18
2625 , p4_a19
2626 , p4_a20
2627 , p4_a21
2628 , p4_a22
2629 , p4_a23
2630 , p4_a24
2631 , p4_a25
2632 , p4_a26
2633 , p4_a27
2634 , p4_a28
2635 , p4_a29
2636 , p4_a30
2637 , p4_a31
2638 , p4_a32
2639 , p4_a33
2640 , p4_a34
2641 , p4_a35
2642 , p4_a36
2643 , p4_a37
2644 , p4_a38
2645 , p4_a39
2646 , p4_a40
2647 , p4_a41
2648 , p4_a42
2649 , p4_a43
2650 , p4_a44
2651 , p4_a45
2652 , p4_a46
2653 , p4_a47
2654 , p4_a48
2655 , p4_a49
2656 , p4_a50
2657 , p4_a51
2658 , p4_a52
2659 , p4_a53
2660 , p4_a54
2661 , p4_a55
2662 , p4_a56
2663 , p4_a57
2664 , p4_a58
2665 , p4_a59
2666 , p4_a60
2667 , p4_a61
2668 , p4_a62
2669 , p4_a63
2670 , p4_a64
2671 , p4_a65
2672 , p4_a66
2673 , p4_a67
2674 , p4_a68
2675 , p4_a69
2676 , p4_a70
2677 );
2678
2679
2680
2681
2682 -- here's the delegated call to the old PL/SQL routine
2683 ozf_offer_pvt.process_qp_list_lines(x_return_status,
2684 x_msg_count,
2685 x_msg_data,
2686 p_offer_type,
2687 ddp_modifier_line_tbl,
2688 p_list_header_id,
2689 ddx_modifier_line_tbl,
2690 x_error_location);
2691
2692 -- copy data back from the local variables to OUT or IN-OUT args, if any
2693
2694
2695
2696
2697
2698
2699 qp_modifiers_pub_oa.rosetta_table_copy_out_p3(ddx_modifier_line_tbl, p6_a0
2700 , p6_a1
2701 , p6_a2
2702 , p6_a3
2703 , p6_a4
2704 , p6_a5
2705 , p6_a6
2706 , p6_a7
2707 , p6_a8
2708 , p6_a9
2709 , p6_a10
2710 , p6_a11
2711 , p6_a12
2712 , p6_a13
2713 , p6_a14
2714 , p6_a15
2715 , p6_a16
2716 , p6_a17
2717 , p6_a18
2718 , p6_a19
2719 , p6_a20
2720 , p6_a21
2721 , p6_a22
2722 , p6_a23
2723 , p6_a24
2724 , p6_a25
2725 , p6_a26
2726 , p6_a27
2727 , p6_a28
2728 , p6_a29
2729 , p6_a30
2730 , p6_a31
2731 , p6_a32
2732 , p6_a33
2733 , p6_a34
2734 , p6_a35
2735 , p6_a36
2736 , p6_a37
2737 , p6_a38
2738 , p6_a39
2739 , p6_a40
2740 , p6_a41
2741 , p6_a42
2742 , p6_a43
2743 , p6_a44
2744 , p6_a45
2745 , p6_a46
2746 , p6_a47
2747 , p6_a48
2748 , p6_a49
2749 , p6_a50
2750 , p6_a51
2751 , p6_a52
2752 , p6_a53
2753 , p6_a54
2754 , p6_a55
2755 , p6_a56
2756 , p6_a57
2757 , p6_a58
2758 , p6_a59
2759 , p6_a60
2760 , p6_a61
2761 , p6_a62
2762 , p6_a63
2763 , p6_a64
2764 , p6_a65
2765 , p6_a66
2766 , p6_a67
2767 , p6_a68
2768 , p6_a69
2769 , p6_a70
2770 , p6_a71
2771 , p6_a72
2772 , p6_a73
2773 , p6_a74
2774 , p6_a75
2775 , p6_a76
2776 , p6_a77
2777 , p6_a78
2778 , p6_a79
2779 , p6_a80
2780 , p6_a81
2781 , p6_a82
2782 , p6_a83
2783 , p6_a84
2784 , p6_a85
2785 , p6_a86
2786 , p6_a87
2787 , p6_a88
2788 , p6_a89
2789 );
2790
2791 end;
2792
2793 end ozf_offer_pvt_oa;