[Home] [Help]
PACKAGE BODY: APPS.OZF_OFFER_PUB_W
Source
1 package body ozf_offer_pub_w as
2 /* $Header: ozfwofpb.pls 120.3 2005/08/10 17:37 appldev ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_VARCHAR2_TABLE_100
26 , a4 JTF_VARCHAR2_TABLE_100
27 , a5 JTF_VARCHAR2_TABLE_100
28 , a6 JTF_VARCHAR2_TABLE_100
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_NUMBER_TABLE
31 , a9 JTF_NUMBER_TABLE
32 , a10 JTF_NUMBER_TABLE
33 , a11 JTF_VARCHAR2_TABLE_100
34 , a12 JTF_VARCHAR2_TABLE_100
35 , a13 JTF_VARCHAR2_TABLE_100
36 , a14 JTF_NUMBER_TABLE
37 , a15 JTF_NUMBER_TABLE
38 , a16 JTF_NUMBER_TABLE
39 , a17 JTF_VARCHAR2_TABLE_100
40 , a18 JTF_VARCHAR2_TABLE_100
41 , a19 JTF_NUMBER_TABLE
42 , a20 JTF_NUMBER_TABLE
43 , a21 JTF_NUMBER_TABLE
44 , a22 JTF_VARCHAR2_TABLE_100
45 ) as
46 ddindx binary_integer; indx binary_integer;
47 begin
48 if a0 is not null and a0.count > 0 then
49 if a0.count > 0 then
50 indx := a0.first;
51 ddindx := 1;
52 while true loop
53 t(ddindx).activity_product_id := rosetta_g_miss_num_map(a0(indx));
54 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
55 t(ddindx).act_product_used_by_id := rosetta_g_miss_num_map(a2(indx));
56 t(ddindx).arc_act_product_used_by := a3(indx);
57 t(ddindx).product_sale_type := a4(indx);
58 t(ddindx).primary_product_flag := a5(indx);
59 t(ddindx).enabled_flag := a6(indx);
60 t(ddindx).inventory_item_id := rosetta_g_miss_num_map(a7(indx));
61 t(ddindx).organization_id := rosetta_g_miss_num_map(a8(indx));
62 t(ddindx).category_id := rosetta_g_miss_num_map(a9(indx));
63 t(ddindx).category_set_id := rosetta_g_miss_num_map(a10(indx));
64 t(ddindx).attribute_category := a11(indx);
65 t(ddindx).level_type_code := a12(indx);
66 t(ddindx).excluded_flag := a13(indx);
67 t(ddindx).line_lumpsum_amount := rosetta_g_miss_num_map(a14(indx));
68 t(ddindx).line_lumpsum_qty := rosetta_g_miss_num_map(a15(indx));
69 t(ddindx).scan_value := rosetta_g_miss_num_map(a16(indx));
70 t(ddindx).uom_code := a17(indx);
71 t(ddindx).adjustment_flag := a18(indx);
72 t(ddindx).scan_unit_forecast := rosetta_g_miss_num_map(a19(indx));
73 t(ddindx).channel_id := rosetta_g_miss_num_map(a20(indx));
74 t(ddindx).quantity := rosetta_g_miss_num_map(a21(indx));
75 t(ddindx).operation := a22(indx);
76 ddindx := ddindx+1;
77 if a0.last =indx
78 then exit;
79 end if;
80 indx := a0.next(indx);
81 end loop;
82 end if;
83 end if;
84 end rosetta_table_copy_in_p2;
85 procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86 , a1 out nocopy JTF_NUMBER_TABLE
87 , a2 out nocopy JTF_NUMBER_TABLE
88 , a3 out nocopy JTF_VARCHAR2_TABLE_100
89 , a4 out nocopy JTF_VARCHAR2_TABLE_100
90 , a5 out nocopy JTF_VARCHAR2_TABLE_100
91 , a6 out nocopy JTF_VARCHAR2_TABLE_100
92 , a7 out nocopy JTF_NUMBER_TABLE
93 , a8 out nocopy JTF_NUMBER_TABLE
94 , a9 out nocopy JTF_NUMBER_TABLE
95 , a10 out nocopy JTF_NUMBER_TABLE
96 , a11 out nocopy JTF_VARCHAR2_TABLE_100
97 , a12 out nocopy JTF_VARCHAR2_TABLE_100
98 , a13 out nocopy JTF_VARCHAR2_TABLE_100
99 , a14 out nocopy JTF_NUMBER_TABLE
100 , a15 out nocopy JTF_NUMBER_TABLE
101 , a16 out nocopy JTF_NUMBER_TABLE
102 , a17 out nocopy JTF_VARCHAR2_TABLE_100
103 , a18 out nocopy JTF_VARCHAR2_TABLE_100
104 , a19 out nocopy JTF_NUMBER_TABLE
105 , a20 out nocopy JTF_NUMBER_TABLE
106 , a21 out nocopy JTF_NUMBER_TABLE
107 , a22 out nocopy JTF_VARCHAR2_TABLE_100
108 ) as
109 ddindx binary_integer; indx binary_integer;
110 begin
111 if t is null or t.count = 0 then
112 a0 := JTF_NUMBER_TABLE();
113 a1 := JTF_NUMBER_TABLE();
114 a2 := JTF_NUMBER_TABLE();
115 a3 := JTF_VARCHAR2_TABLE_100();
116 a4 := JTF_VARCHAR2_TABLE_100();
117 a5 := JTF_VARCHAR2_TABLE_100();
118 a6 := JTF_VARCHAR2_TABLE_100();
119 a7 := JTF_NUMBER_TABLE();
120 a8 := JTF_NUMBER_TABLE();
121 a9 := JTF_NUMBER_TABLE();
122 a10 := JTF_NUMBER_TABLE();
123 a11 := JTF_VARCHAR2_TABLE_100();
124 a12 := JTF_VARCHAR2_TABLE_100();
125 a13 := JTF_VARCHAR2_TABLE_100();
126 a14 := JTF_NUMBER_TABLE();
127 a15 := JTF_NUMBER_TABLE();
128 a16 := JTF_NUMBER_TABLE();
129 a17 := JTF_VARCHAR2_TABLE_100();
130 a18 := JTF_VARCHAR2_TABLE_100();
131 a19 := JTF_NUMBER_TABLE();
132 a20 := JTF_NUMBER_TABLE();
133 a21 := JTF_NUMBER_TABLE();
134 a22 := JTF_VARCHAR2_TABLE_100();
135 else
136 a0 := JTF_NUMBER_TABLE();
137 a1 := JTF_NUMBER_TABLE();
138 a2 := JTF_NUMBER_TABLE();
139 a3 := JTF_VARCHAR2_TABLE_100();
140 a4 := JTF_VARCHAR2_TABLE_100();
141 a5 := JTF_VARCHAR2_TABLE_100();
142 a6 := JTF_VARCHAR2_TABLE_100();
143 a7 := JTF_NUMBER_TABLE();
144 a8 := JTF_NUMBER_TABLE();
145 a9 := JTF_NUMBER_TABLE();
146 a10 := JTF_NUMBER_TABLE();
147 a11 := JTF_VARCHAR2_TABLE_100();
148 a12 := JTF_VARCHAR2_TABLE_100();
149 a13 := JTF_VARCHAR2_TABLE_100();
150 a14 := JTF_NUMBER_TABLE();
151 a15 := JTF_NUMBER_TABLE();
152 a16 := JTF_NUMBER_TABLE();
153 a17 := JTF_VARCHAR2_TABLE_100();
154 a18 := JTF_VARCHAR2_TABLE_100();
155 a19 := JTF_NUMBER_TABLE();
156 a20 := JTF_NUMBER_TABLE();
157 a21 := JTF_NUMBER_TABLE();
158 a22 := JTF_VARCHAR2_TABLE_100();
159 if t.count > 0 then
160 a0.extend(t.count);
161 a1.extend(t.count);
162 a2.extend(t.count);
163 a3.extend(t.count);
164 a4.extend(t.count);
165 a5.extend(t.count);
166 a6.extend(t.count);
167 a7.extend(t.count);
168 a8.extend(t.count);
169 a9.extend(t.count);
170 a10.extend(t.count);
171 a11.extend(t.count);
172 a12.extend(t.count);
173 a13.extend(t.count);
174 a14.extend(t.count);
175 a15.extend(t.count);
176 a16.extend(t.count);
177 a17.extend(t.count);
178 a18.extend(t.count);
179 a19.extend(t.count);
180 a20.extend(t.count);
181 a21.extend(t.count);
182 a22.extend(t.count);
183 ddindx := t.first;
184 indx := 1;
185 while true loop
186 a0(indx) := rosetta_g_miss_num_map(t(ddindx).activity_product_id);
187 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
188 a2(indx) := rosetta_g_miss_num_map(t(ddindx).act_product_used_by_id);
189 a3(indx) := t(ddindx).arc_act_product_used_by;
190 a4(indx) := t(ddindx).product_sale_type;
191 a5(indx) := t(ddindx).primary_product_flag;
192 a6(indx) := t(ddindx).enabled_flag;
193 a7(indx) := rosetta_g_miss_num_map(t(ddindx).inventory_item_id);
194 a8(indx) := rosetta_g_miss_num_map(t(ddindx).organization_id);
195 a9(indx) := rosetta_g_miss_num_map(t(ddindx).category_id);
196 a10(indx) := rosetta_g_miss_num_map(t(ddindx).category_set_id);
197 a11(indx) := t(ddindx).attribute_category;
198 a12(indx) := t(ddindx).level_type_code;
199 a13(indx) := t(ddindx).excluded_flag;
200 a14(indx) := rosetta_g_miss_num_map(t(ddindx).line_lumpsum_amount);
201 a15(indx) := rosetta_g_miss_num_map(t(ddindx).line_lumpsum_qty);
202 a16(indx) := rosetta_g_miss_num_map(t(ddindx).scan_value);
203 a17(indx) := t(ddindx).uom_code;
204 a18(indx) := t(ddindx).adjustment_flag;
205 a19(indx) := rosetta_g_miss_num_map(t(ddindx).scan_unit_forecast);
206 a20(indx) := rosetta_g_miss_num_map(t(ddindx).channel_id);
207 a21(indx) := rosetta_g_miss_num_map(t(ddindx).quantity);
208 a22(indx) := t(ddindx).operation;
209 indx := indx+1;
210 if t.last =ddindx
211 then exit;
212 end if;
213 ddindx := t.next(ddindx);
214 end loop;
215 end if;
216 end if;
217 end rosetta_table_copy_out_p2;
218
219 procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
220 , a1 JTF_NUMBER_TABLE
221 , a2 JTF_NUMBER_TABLE
222 , a3 JTF_NUMBER_TABLE
223 , a4 JTF_VARCHAR2_TABLE_100
224 , a5 JTF_VARCHAR2_TABLE_100
225 , a6 JTF_VARCHAR2_TABLE_100
226 , a7 JTF_NUMBER_TABLE
227 , a8 JTF_VARCHAR2_TABLE_100
228 , a9 JTF_VARCHAR2_TABLE_100
229 , a10 JTF_VARCHAR2_TABLE_100
230 , a11 JTF_VARCHAR2_TABLE_100
231 , a12 JTF_NUMBER_TABLE
232 , a13 JTF_VARCHAR2_TABLE_100
233 , a14 JTF_NUMBER_TABLE
234 , a15 JTF_NUMBER_TABLE
235 , a16 JTF_NUMBER_TABLE
236 , a17 JTF_NUMBER_TABLE
237 , a18 JTF_VARCHAR2_TABLE_100
238 , a19 JTF_DATE_TABLE
239 , a20 JTF_DATE_TABLE
240 , a21 JTF_VARCHAR2_TABLE_100
241 , a22 JTF_DATE_TABLE
242 , a23 JTF_NUMBER_TABLE
243 , a24 JTF_DATE_TABLE
244 , a25 JTF_NUMBER_TABLE
245 , a26 JTF_NUMBER_TABLE
246 , a27 JTF_NUMBER_TABLE
247 , a28 JTF_NUMBER_TABLE
248 , a29 JTF_NUMBER_TABLE
249 , a30 JTF_NUMBER_TABLE
250 , a31 JTF_VARCHAR2_TABLE_100
251 , a32 JTF_NUMBER_TABLE
252 , a33 JTF_VARCHAR2_TABLE_100
253 , a34 JTF_VARCHAR2_TABLE_100
254 ) as
255 ddindx binary_integer; indx binary_integer;
256 begin
257 if a0 is not null and a0.count > 0 then
258 if a0.count > 0 then
259 indx := a0.first;
260 ddindx := 1;
261 while true loop
262 t(ddindx).offer_discount_line_id := rosetta_g_miss_num_map(a0(indx));
263 t(ddindx).parent_discount_line_id := rosetta_g_miss_num_map(a1(indx));
264 t(ddindx).volume_from := rosetta_g_miss_num_map(a2(indx));
265 t(ddindx).volume_to := rosetta_g_miss_num_map(a3(indx));
266 t(ddindx).volume_operator := a4(indx);
267 t(ddindx).volume_type := a5(indx);
268 t(ddindx).volume_break_type := a6(indx);
269 t(ddindx).discount := rosetta_g_miss_num_map(a7(indx));
270 t(ddindx).discount_type := a8(indx);
271 t(ddindx).tier_type := a9(indx);
272 t(ddindx).tier_level := a10(indx);
273 t(ddindx).incompatibility_group := a11(indx);
274 t(ddindx).precedence := rosetta_g_miss_num_map(a12(indx));
275 t(ddindx).bucket := a13(indx);
276 t(ddindx).scan_value := rosetta_g_miss_num_map(a14(indx));
277 t(ddindx).scan_data_quantity := rosetta_g_miss_num_map(a15(indx));
278 t(ddindx).scan_unit_forecast := rosetta_g_miss_num_map(a16(indx));
279 t(ddindx).channel_id := rosetta_g_miss_num_map(a17(indx));
280 t(ddindx).adjustment_flag := a18(indx);
281 t(ddindx).start_date_active := rosetta_g_miss_date_in_map(a19(indx));
282 t(ddindx).end_date_active := rosetta_g_miss_date_in_map(a20(indx));
283 t(ddindx).uom_code := a21(indx);
284 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a22(indx));
285 t(ddindx).created_by := rosetta_g_miss_num_map(a23(indx));
286 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a24(indx));
287 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a25(indx));
288 t(ddindx).last_update_login := rosetta_g_miss_num_map(a26(indx));
289 t(ddindx).object_version_number := rosetta_g_miss_num_map(a27(indx));
290 t(ddindx).offer_id := rosetta_g_miss_num_map(a28(indx));
291 t(ddindx).off_discount_product_id := rosetta_g_miss_num_map(a29(indx));
292 t(ddindx).parent_off_disc_prod_id := rosetta_g_miss_num_map(a30(indx));
293 t(ddindx).product_level := a31(indx);
294 t(ddindx).product_id := rosetta_g_miss_num_map(a32(indx));
295 t(ddindx).excluder_flag := a33(indx);
296 t(ddindx).operation := a34(indx);
297 ddindx := ddindx+1;
298 if a0.last =indx
299 then exit;
300 end if;
301 indx := a0.next(indx);
302 end loop;
303 end if;
304 end if;
305 end rosetta_table_copy_in_p4;
306 procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
307 , a1 out nocopy JTF_NUMBER_TABLE
308 , a2 out nocopy JTF_NUMBER_TABLE
309 , a3 out nocopy JTF_NUMBER_TABLE
310 , a4 out nocopy JTF_VARCHAR2_TABLE_100
311 , a5 out nocopy JTF_VARCHAR2_TABLE_100
312 , a6 out nocopy JTF_VARCHAR2_TABLE_100
313 , a7 out nocopy JTF_NUMBER_TABLE
314 , a8 out nocopy JTF_VARCHAR2_TABLE_100
315 , a9 out nocopy JTF_VARCHAR2_TABLE_100
316 , a10 out nocopy JTF_VARCHAR2_TABLE_100
317 , a11 out nocopy JTF_VARCHAR2_TABLE_100
318 , a12 out nocopy JTF_NUMBER_TABLE
319 , a13 out nocopy JTF_VARCHAR2_TABLE_100
320 , a14 out nocopy JTF_NUMBER_TABLE
321 , a15 out nocopy JTF_NUMBER_TABLE
322 , a16 out nocopy JTF_NUMBER_TABLE
323 , a17 out nocopy JTF_NUMBER_TABLE
324 , a18 out nocopy JTF_VARCHAR2_TABLE_100
325 , a19 out nocopy JTF_DATE_TABLE
326 , a20 out nocopy JTF_DATE_TABLE
327 , a21 out nocopy JTF_VARCHAR2_TABLE_100
328 , a22 out nocopy JTF_DATE_TABLE
329 , a23 out nocopy JTF_NUMBER_TABLE
330 , a24 out nocopy JTF_DATE_TABLE
331 , a25 out nocopy JTF_NUMBER_TABLE
332 , a26 out nocopy JTF_NUMBER_TABLE
333 , a27 out nocopy JTF_NUMBER_TABLE
334 , a28 out nocopy JTF_NUMBER_TABLE
335 , a29 out nocopy JTF_NUMBER_TABLE
336 , a30 out nocopy JTF_NUMBER_TABLE
337 , a31 out nocopy JTF_VARCHAR2_TABLE_100
338 , a32 out nocopy JTF_NUMBER_TABLE
339 , a33 out nocopy JTF_VARCHAR2_TABLE_100
340 , a34 out nocopy JTF_VARCHAR2_TABLE_100
341 ) as
342 ddindx binary_integer; indx binary_integer;
343 begin
344 if t is null or t.count = 0 then
345 a0 := JTF_NUMBER_TABLE();
346 a1 := JTF_NUMBER_TABLE();
347 a2 := JTF_NUMBER_TABLE();
348 a3 := JTF_NUMBER_TABLE();
349 a4 := JTF_VARCHAR2_TABLE_100();
350 a5 := JTF_VARCHAR2_TABLE_100();
351 a6 := JTF_VARCHAR2_TABLE_100();
352 a7 := JTF_NUMBER_TABLE();
353 a8 := JTF_VARCHAR2_TABLE_100();
354 a9 := JTF_VARCHAR2_TABLE_100();
355 a10 := JTF_VARCHAR2_TABLE_100();
356 a11 := JTF_VARCHAR2_TABLE_100();
357 a12 := JTF_NUMBER_TABLE();
358 a13 := JTF_VARCHAR2_TABLE_100();
359 a14 := JTF_NUMBER_TABLE();
360 a15 := JTF_NUMBER_TABLE();
361 a16 := JTF_NUMBER_TABLE();
362 a17 := JTF_NUMBER_TABLE();
363 a18 := JTF_VARCHAR2_TABLE_100();
364 a19 := JTF_DATE_TABLE();
365 a20 := JTF_DATE_TABLE();
366 a21 := JTF_VARCHAR2_TABLE_100();
367 a22 := JTF_DATE_TABLE();
368 a23 := JTF_NUMBER_TABLE();
369 a24 := JTF_DATE_TABLE();
370 a25 := JTF_NUMBER_TABLE();
371 a26 := JTF_NUMBER_TABLE();
372 a27 := JTF_NUMBER_TABLE();
373 a28 := JTF_NUMBER_TABLE();
374 a29 := JTF_NUMBER_TABLE();
375 a30 := JTF_NUMBER_TABLE();
376 a31 := JTF_VARCHAR2_TABLE_100();
377 a32 := JTF_NUMBER_TABLE();
378 a33 := JTF_VARCHAR2_TABLE_100();
379 a34 := JTF_VARCHAR2_TABLE_100();
380 else
381 a0 := JTF_NUMBER_TABLE();
382 a1 := JTF_NUMBER_TABLE();
383 a2 := JTF_NUMBER_TABLE();
384 a3 := JTF_NUMBER_TABLE();
385 a4 := JTF_VARCHAR2_TABLE_100();
386 a5 := JTF_VARCHAR2_TABLE_100();
387 a6 := JTF_VARCHAR2_TABLE_100();
388 a7 := JTF_NUMBER_TABLE();
389 a8 := JTF_VARCHAR2_TABLE_100();
390 a9 := JTF_VARCHAR2_TABLE_100();
391 a10 := JTF_VARCHAR2_TABLE_100();
392 a11 := JTF_VARCHAR2_TABLE_100();
393 a12 := JTF_NUMBER_TABLE();
394 a13 := JTF_VARCHAR2_TABLE_100();
395 a14 := JTF_NUMBER_TABLE();
396 a15 := JTF_NUMBER_TABLE();
397 a16 := JTF_NUMBER_TABLE();
398 a17 := JTF_NUMBER_TABLE();
399 a18 := JTF_VARCHAR2_TABLE_100();
400 a19 := JTF_DATE_TABLE();
401 a20 := JTF_DATE_TABLE();
402 a21 := JTF_VARCHAR2_TABLE_100();
403 a22 := JTF_DATE_TABLE();
404 a23 := JTF_NUMBER_TABLE();
405 a24 := JTF_DATE_TABLE();
406 a25 := JTF_NUMBER_TABLE();
407 a26 := JTF_NUMBER_TABLE();
408 a27 := JTF_NUMBER_TABLE();
409 a28 := JTF_NUMBER_TABLE();
410 a29 := JTF_NUMBER_TABLE();
411 a30 := JTF_NUMBER_TABLE();
412 a31 := JTF_VARCHAR2_TABLE_100();
413 a32 := JTF_NUMBER_TABLE();
414 a33 := JTF_VARCHAR2_TABLE_100();
415 a34 := JTF_VARCHAR2_TABLE_100();
416 if t.count > 0 then
417 a0.extend(t.count);
418 a1.extend(t.count);
419 a2.extend(t.count);
420 a3.extend(t.count);
421 a4.extend(t.count);
422 a5.extend(t.count);
423 a6.extend(t.count);
424 a7.extend(t.count);
425 a8.extend(t.count);
426 a9.extend(t.count);
427 a10.extend(t.count);
428 a11.extend(t.count);
429 a12.extend(t.count);
430 a13.extend(t.count);
431 a14.extend(t.count);
432 a15.extend(t.count);
433 a16.extend(t.count);
434 a17.extend(t.count);
435 a18.extend(t.count);
436 a19.extend(t.count);
437 a20.extend(t.count);
438 a21.extend(t.count);
439 a22.extend(t.count);
440 a23.extend(t.count);
441 a24.extend(t.count);
442 a25.extend(t.count);
443 a26.extend(t.count);
444 a27.extend(t.count);
445 a28.extend(t.count);
446 a29.extend(t.count);
447 a30.extend(t.count);
448 a31.extend(t.count);
449 a32.extend(t.count);
450 a33.extend(t.count);
451 a34.extend(t.count);
452 ddindx := t.first;
453 indx := 1;
454 while true loop
455 a0(indx) := rosetta_g_miss_num_map(t(ddindx).offer_discount_line_id);
456 a1(indx) := rosetta_g_miss_num_map(t(ddindx).parent_discount_line_id);
457 a2(indx) := rosetta_g_miss_num_map(t(ddindx).volume_from);
458 a3(indx) := rosetta_g_miss_num_map(t(ddindx).volume_to);
459 a4(indx) := t(ddindx).volume_operator;
460 a5(indx) := t(ddindx).volume_type;
461 a6(indx) := t(ddindx).volume_break_type;
462 a7(indx) := rosetta_g_miss_num_map(t(ddindx).discount);
463 a8(indx) := t(ddindx).discount_type;
464 a9(indx) := t(ddindx).tier_type;
465 a10(indx) := t(ddindx).tier_level;
466 a11(indx) := t(ddindx).incompatibility_group;
467 a12(indx) := rosetta_g_miss_num_map(t(ddindx).precedence);
468 a13(indx) := t(ddindx).bucket;
469 a14(indx) := rosetta_g_miss_num_map(t(ddindx).scan_value);
470 a15(indx) := rosetta_g_miss_num_map(t(ddindx).scan_data_quantity);
471 a16(indx) := rosetta_g_miss_num_map(t(ddindx).scan_unit_forecast);
472 a17(indx) := rosetta_g_miss_num_map(t(ddindx).channel_id);
473 a18(indx) := t(ddindx).adjustment_flag;
474 a19(indx) := t(ddindx).start_date_active;
475 a20(indx) := t(ddindx).end_date_active;
476 a21(indx) := t(ddindx).uom_code;
477 a22(indx) := t(ddindx).creation_date;
478 a23(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
479 a24(indx) := t(ddindx).last_update_date;
480 a25(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
481 a26(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
482 a27(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
483 a28(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
484 a29(indx) := rosetta_g_miss_num_map(t(ddindx).off_discount_product_id);
485 a30(indx) := rosetta_g_miss_num_map(t(ddindx).parent_off_disc_prod_id);
486 a31(indx) := t(ddindx).product_level;
487 a32(indx) := rosetta_g_miss_num_map(t(ddindx).product_id);
488 a33(indx) := t(ddindx).excluder_flag;
489 a34(indx) := t(ddindx).operation;
490 indx := indx+1;
491 if t.last =ddindx
492 then exit;
493 end if;
494 ddindx := t.next(ddindx);
495 end loop;
496 end if;
497 end if;
498 end rosetta_table_copy_out_p4;
499
500 procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
501 , a1 JTF_NUMBER_TABLE
502 , a2 JTF_VARCHAR2_TABLE_100
503 , a3 JTF_NUMBER_TABLE
504 , a4 JTF_VARCHAR2_TABLE_100
505 , a5 JTF_VARCHAR2_TABLE_100
506 , a6 JTF_DATE_TABLE
507 , a7 JTF_DATE_TABLE
508 , a8 JTF_NUMBER_TABLE
509 , a9 JTF_NUMBER_TABLE
510 , a10 JTF_DATE_TABLE
511 , a11 JTF_NUMBER_TABLE
512 , a12 JTF_DATE_TABLE
513 , a13 JTF_NUMBER_TABLE
514 , a14 JTF_NUMBER_TABLE
515 , a15 JTF_NUMBER_TABLE
516 , a16 JTF_VARCHAR2_TABLE_100
517 ) as
518 ddindx binary_integer; indx binary_integer;
519 begin
520 if a0 is not null and a0.count > 0 then
521 if a0.count > 0 then
522 indx := a0.first;
523 ddindx := 1;
524 while true loop
525 t(ddindx).off_discount_product_id := rosetta_g_miss_num_map(a0(indx));
526 t(ddindx).parent_off_disc_prod_id := rosetta_g_miss_num_map(a1(indx));
527 t(ddindx).product_level := a2(indx);
528 t(ddindx).product_id := rosetta_g_miss_num_map(a3(indx));
529 t(ddindx).excluder_flag := a4(indx);
530 t(ddindx).uom_code := a5(indx);
531 t(ddindx).start_date_active := rosetta_g_miss_date_in_map(a6(indx));
532 t(ddindx).end_date_active := rosetta_g_miss_date_in_map(a7(indx));
533 t(ddindx).offer_discount_line_id := rosetta_g_miss_num_map(a8(indx));
534 t(ddindx).offer_id := rosetta_g_miss_num_map(a9(indx));
535 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a10(indx));
536 t(ddindx).created_by := rosetta_g_miss_num_map(a11(indx));
537 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a12(indx));
538 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a13(indx));
539 t(ddindx).last_update_login := rosetta_g_miss_num_map(a14(indx));
540 t(ddindx).object_version_number := rosetta_g_miss_num_map(a15(indx));
541 t(ddindx).operation := a16(indx);
542 ddindx := ddindx+1;
543 if a0.last =indx
544 then exit;
545 end if;
546 indx := a0.next(indx);
547 end loop;
548 end if;
549 end if;
550 end rosetta_table_copy_in_p6;
551 procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
552 , a1 out nocopy JTF_NUMBER_TABLE
553 , a2 out nocopy JTF_VARCHAR2_TABLE_100
554 , a3 out nocopy JTF_NUMBER_TABLE
555 , a4 out nocopy JTF_VARCHAR2_TABLE_100
556 , a5 out nocopy JTF_VARCHAR2_TABLE_100
557 , a6 out nocopy JTF_DATE_TABLE
558 , a7 out nocopy JTF_DATE_TABLE
559 , a8 out nocopy JTF_NUMBER_TABLE
560 , a9 out nocopy JTF_NUMBER_TABLE
561 , a10 out nocopy JTF_DATE_TABLE
562 , a11 out nocopy JTF_NUMBER_TABLE
563 , a12 out nocopy JTF_DATE_TABLE
564 , a13 out nocopy JTF_NUMBER_TABLE
565 , a14 out nocopy JTF_NUMBER_TABLE
566 , a15 out nocopy JTF_NUMBER_TABLE
567 , a16 out nocopy JTF_VARCHAR2_TABLE_100
568 ) as
569 ddindx binary_integer; indx binary_integer;
570 begin
571 if t is null or t.count = 0 then
572 a0 := JTF_NUMBER_TABLE();
573 a1 := JTF_NUMBER_TABLE();
574 a2 := JTF_VARCHAR2_TABLE_100();
575 a3 := JTF_NUMBER_TABLE();
576 a4 := JTF_VARCHAR2_TABLE_100();
577 a5 := JTF_VARCHAR2_TABLE_100();
578 a6 := JTF_DATE_TABLE();
579 a7 := JTF_DATE_TABLE();
580 a8 := JTF_NUMBER_TABLE();
581 a9 := JTF_NUMBER_TABLE();
582 a10 := JTF_DATE_TABLE();
583 a11 := JTF_NUMBER_TABLE();
584 a12 := JTF_DATE_TABLE();
585 a13 := JTF_NUMBER_TABLE();
586 a14 := JTF_NUMBER_TABLE();
587 a15 := JTF_NUMBER_TABLE();
588 a16 := JTF_VARCHAR2_TABLE_100();
589 else
590 a0 := JTF_NUMBER_TABLE();
591 a1 := JTF_NUMBER_TABLE();
592 a2 := JTF_VARCHAR2_TABLE_100();
593 a3 := JTF_NUMBER_TABLE();
594 a4 := JTF_VARCHAR2_TABLE_100();
595 a5 := JTF_VARCHAR2_TABLE_100();
596 a6 := JTF_DATE_TABLE();
597 a7 := JTF_DATE_TABLE();
598 a8 := JTF_NUMBER_TABLE();
599 a9 := JTF_NUMBER_TABLE();
600 a10 := JTF_DATE_TABLE();
601 a11 := JTF_NUMBER_TABLE();
602 a12 := JTF_DATE_TABLE();
603 a13 := JTF_NUMBER_TABLE();
604 a14 := JTF_NUMBER_TABLE();
605 a15 := JTF_NUMBER_TABLE();
606 a16 := JTF_VARCHAR2_TABLE_100();
607 if t.count > 0 then
608 a0.extend(t.count);
609 a1.extend(t.count);
610 a2.extend(t.count);
611 a3.extend(t.count);
612 a4.extend(t.count);
613 a5.extend(t.count);
614 a6.extend(t.count);
615 a7.extend(t.count);
616 a8.extend(t.count);
617 a9.extend(t.count);
618 a10.extend(t.count);
619 a11.extend(t.count);
620 a12.extend(t.count);
621 a13.extend(t.count);
622 a14.extend(t.count);
623 a15.extend(t.count);
624 a16.extend(t.count);
625 ddindx := t.first;
626 indx := 1;
627 while true loop
628 a0(indx) := rosetta_g_miss_num_map(t(ddindx).off_discount_product_id);
629 a1(indx) := rosetta_g_miss_num_map(t(ddindx).parent_off_disc_prod_id);
630 a2(indx) := t(ddindx).product_level;
631 a3(indx) := rosetta_g_miss_num_map(t(ddindx).product_id);
632 a4(indx) := t(ddindx).excluder_flag;
633 a5(indx) := t(ddindx).uom_code;
634 a6(indx) := t(ddindx).start_date_active;
635 a7(indx) := t(ddindx).end_date_active;
636 a8(indx) := rosetta_g_miss_num_map(t(ddindx).offer_discount_line_id);
637 a9(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
638 a10(indx) := t(ddindx).creation_date;
639 a11(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
640 a12(indx) := t(ddindx).last_update_date;
641 a13(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
642 a14(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
643 a15(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
644 a16(indx) := t(ddindx).operation;
645 indx := indx+1;
646 if t.last =ddindx
647 then exit;
648 end if;
649 ddindx := t.next(ddindx);
650 end loop;
651 end if;
652 end if;
653 end rosetta_table_copy_out_p6;
654
655 procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
656 , a1 JTF_NUMBER_TABLE
657 , a2 JTF_VARCHAR2_TABLE_100
658 , a3 JTF_NUMBER_TABLE
659 , a4 JTF_NUMBER_TABLE
660 , a5 JTF_DATE_TABLE
661 , a6 JTF_DATE_TABLE
662 , a7 JTF_VARCHAR2_TABLE_100
663 ) as
664 ddindx binary_integer; indx binary_integer;
665 begin
666 if a0 is not null and a0.count > 0 then
667 if a0.count > 0 then
668 indx := a0.first;
669 ddindx := 1;
670 while true loop
671 t(ddindx).off_discount_product_id := rosetta_g_miss_num_map(a0(indx));
672 t(ddindx).parent_off_disc_prod_id := rosetta_g_miss_num_map(a1(indx));
673 t(ddindx).product_level := a2(indx);
674 t(ddindx).product_id := rosetta_g_miss_num_map(a3(indx));
675 t(ddindx).object_version_number := rosetta_g_miss_num_map(a4(indx));
676 t(ddindx).start_date_active := rosetta_g_miss_date_in_map(a5(indx));
677 t(ddindx).end_date_active := rosetta_g_miss_date_in_map(a6(indx));
678 t(ddindx).operation := a7(indx);
679 ddindx := ddindx+1;
680 if a0.last =indx
681 then exit;
682 end if;
683 indx := a0.next(indx);
684 end loop;
685 end if;
686 end if;
687 end rosetta_table_copy_in_p8;
688 procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
689 , a1 out nocopy JTF_NUMBER_TABLE
690 , a2 out nocopy JTF_VARCHAR2_TABLE_100
691 , a3 out nocopy JTF_NUMBER_TABLE
692 , a4 out nocopy JTF_NUMBER_TABLE
693 , a5 out nocopy JTF_DATE_TABLE
694 , a6 out nocopy JTF_DATE_TABLE
695 , a7 out nocopy JTF_VARCHAR2_TABLE_100
696 ) as
697 ddindx binary_integer; indx binary_integer;
698 begin
699 if t is null or t.count = 0 then
700 a0 := JTF_NUMBER_TABLE();
701 a1 := JTF_NUMBER_TABLE();
702 a2 := JTF_VARCHAR2_TABLE_100();
703 a3 := JTF_NUMBER_TABLE();
704 a4 := JTF_NUMBER_TABLE();
705 a5 := JTF_DATE_TABLE();
706 a6 := JTF_DATE_TABLE();
707 a7 := JTF_VARCHAR2_TABLE_100();
708 else
709 a0 := JTF_NUMBER_TABLE();
710 a1 := JTF_NUMBER_TABLE();
711 a2 := JTF_VARCHAR2_TABLE_100();
712 a3 := JTF_NUMBER_TABLE();
713 a4 := JTF_NUMBER_TABLE();
714 a5 := JTF_DATE_TABLE();
715 a6 := JTF_DATE_TABLE();
716 a7 := JTF_VARCHAR2_TABLE_100();
717 if t.count > 0 then
718 a0.extend(t.count);
719 a1.extend(t.count);
720 a2.extend(t.count);
721 a3.extend(t.count);
722 a4.extend(t.count);
723 a5.extend(t.count);
724 a6.extend(t.count);
725 a7.extend(t.count);
726 ddindx := t.first;
727 indx := 1;
728 while true loop
729 a0(indx) := rosetta_g_miss_num_map(t(ddindx).off_discount_product_id);
730 a1(indx) := rosetta_g_miss_num_map(t(ddindx).parent_off_disc_prod_id);
731 a2(indx) := t(ddindx).product_level;
732 a3(indx) := rosetta_g_miss_num_map(t(ddindx).product_id);
733 a4(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
734 a5(indx) := t(ddindx).start_date_active;
735 a6(indx) := t(ddindx).end_date_active;
736 a7(indx) := t(ddindx).operation;
737 indx := indx+1;
738 if t.last =ddindx
739 then exit;
740 end if;
741 ddindx := t.next(ddindx);
742 end loop;
743 end if;
744 end if;
745 end rosetta_table_copy_out_p8;
746
747 procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
748 , a1 JTF_NUMBER_TABLE
749 , a2 JTF_NUMBER_TABLE
750 , a3 JTF_NUMBER_TABLE
751 , a4 JTF_NUMBER_TABLE
752 , a5 JTF_VARCHAR2_TABLE_100
753 , a6 JTF_VARCHAR2_TABLE_100
754 , a7 JTF_VARCHAR2_TABLE_100
755 , a8 JTF_NUMBER_TABLE
756 , a9 JTF_VARCHAR2_TABLE_100
757 , a10 JTF_DATE_TABLE
758 , a11 JTF_DATE_TABLE
759 , a12 JTF_VARCHAR2_TABLE_100
760 , a13 JTF_NUMBER_TABLE
761 , a14 JTF_VARCHAR2_TABLE_100
762 ) as
763 ddindx binary_integer; indx binary_integer;
764 begin
765 if a0 is not null and a0.count > 0 then
766 if a0.count > 0 then
767 indx := a0.first;
768 ddindx := 1;
769 while true loop
770 t(ddindx).offer_discount_line_id := rosetta_g_miss_num_map(a0(indx));
771 t(ddindx).parent_discount_line_id := rosetta_g_miss_num_map(a1(indx));
772 t(ddindx).offer_id := rosetta_g_miss_num_map(a2(indx));
773 t(ddindx).volume_from := rosetta_g_miss_num_map(a3(indx));
774 t(ddindx).volume_to := rosetta_g_miss_num_map(a4(indx));
775 t(ddindx).volume_operator := a5(indx);
776 t(ddindx).volume_type := a6(indx);
777 t(ddindx).volume_break_type := a7(indx);
778 t(ddindx).discount := rosetta_g_miss_num_map(a8(indx));
779 t(ddindx).discount_type := a9(indx);
780 t(ddindx).start_date_active := rosetta_g_miss_date_in_map(a10(indx));
781 t(ddindx).end_date_active := rosetta_g_miss_date_in_map(a11(indx));
782 t(ddindx).uom_code := a12(indx);
783 t(ddindx).object_version_number := rosetta_g_miss_num_map(a13(indx));
784 t(ddindx).operation := a14(indx);
785 ddindx := ddindx+1;
786 if a0.last =indx
787 then exit;
788 end if;
789 indx := a0.next(indx);
790 end loop;
791 end if;
792 end if;
793 end rosetta_table_copy_in_p10;
794 procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
795 , a1 out nocopy JTF_NUMBER_TABLE
796 , a2 out nocopy JTF_NUMBER_TABLE
797 , a3 out nocopy JTF_NUMBER_TABLE
798 , a4 out nocopy JTF_NUMBER_TABLE
799 , a5 out nocopy JTF_VARCHAR2_TABLE_100
800 , a6 out nocopy JTF_VARCHAR2_TABLE_100
801 , a7 out nocopy JTF_VARCHAR2_TABLE_100
802 , a8 out nocopy JTF_NUMBER_TABLE
803 , a9 out nocopy JTF_VARCHAR2_TABLE_100
804 , a10 out nocopy JTF_DATE_TABLE
805 , a11 out nocopy JTF_DATE_TABLE
806 , a12 out nocopy JTF_VARCHAR2_TABLE_100
807 , a13 out nocopy JTF_NUMBER_TABLE
808 , a14 out nocopy JTF_VARCHAR2_TABLE_100
809 ) as
810 ddindx binary_integer; indx binary_integer;
811 begin
812 if t is null or t.count = 0 then
813 a0 := JTF_NUMBER_TABLE();
814 a1 := JTF_NUMBER_TABLE();
815 a2 := JTF_NUMBER_TABLE();
816 a3 := JTF_NUMBER_TABLE();
817 a4 := JTF_NUMBER_TABLE();
818 a5 := JTF_VARCHAR2_TABLE_100();
819 a6 := JTF_VARCHAR2_TABLE_100();
820 a7 := JTF_VARCHAR2_TABLE_100();
821 a8 := JTF_NUMBER_TABLE();
822 a9 := JTF_VARCHAR2_TABLE_100();
823 a10 := JTF_DATE_TABLE();
824 a11 := JTF_DATE_TABLE();
825 a12 := JTF_VARCHAR2_TABLE_100();
826 a13 := JTF_NUMBER_TABLE();
827 a14 := JTF_VARCHAR2_TABLE_100();
828 else
829 a0 := JTF_NUMBER_TABLE();
830 a1 := JTF_NUMBER_TABLE();
831 a2 := JTF_NUMBER_TABLE();
832 a3 := JTF_NUMBER_TABLE();
833 a4 := JTF_NUMBER_TABLE();
834 a5 := JTF_VARCHAR2_TABLE_100();
835 a6 := JTF_VARCHAR2_TABLE_100();
836 a7 := JTF_VARCHAR2_TABLE_100();
837 a8 := JTF_NUMBER_TABLE();
838 a9 := JTF_VARCHAR2_TABLE_100();
839 a10 := JTF_DATE_TABLE();
840 a11 := JTF_DATE_TABLE();
841 a12 := JTF_VARCHAR2_TABLE_100();
842 a13 := JTF_NUMBER_TABLE();
843 a14 := JTF_VARCHAR2_TABLE_100();
844 if t.count > 0 then
845 a0.extend(t.count);
846 a1.extend(t.count);
847 a2.extend(t.count);
848 a3.extend(t.count);
849 a4.extend(t.count);
850 a5.extend(t.count);
851 a6.extend(t.count);
852 a7.extend(t.count);
853 a8.extend(t.count);
854 a9.extend(t.count);
855 a10.extend(t.count);
856 a11.extend(t.count);
857 a12.extend(t.count);
858 a13.extend(t.count);
859 a14.extend(t.count);
860 ddindx := t.first;
861 indx := 1;
862 while true loop
863 a0(indx) := rosetta_g_miss_num_map(t(ddindx).offer_discount_line_id);
864 a1(indx) := rosetta_g_miss_num_map(t(ddindx).parent_discount_line_id);
865 a2(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
866 a3(indx) := rosetta_g_miss_num_map(t(ddindx).volume_from);
867 a4(indx) := rosetta_g_miss_num_map(t(ddindx).volume_to);
868 a5(indx) := t(ddindx).volume_operator;
869 a6(indx) := t(ddindx).volume_type;
870 a7(indx) := t(ddindx).volume_break_type;
871 a8(indx) := rosetta_g_miss_num_map(t(ddindx).discount);
872 a9(indx) := t(ddindx).discount_type;
873 a10(indx) := t(ddindx).start_date_active;
874 a11(indx) := t(ddindx).end_date_active;
875 a12(indx) := t(ddindx).uom_code;
876 a13(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
877 a14(indx) := t(ddindx).operation;
878 indx := indx+1;
879 if t.last =ddindx
880 then exit;
881 end if;
882 ddindx := t.next(ddindx);
883 end loop;
884 end if;
885 end if;
886 end rosetta_table_copy_out_p10;
887
888 procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
889 , a1 JTF_DATE_TABLE
890 , a2 JTF_NUMBER_TABLE
891 , a3 JTF_DATE_TABLE
892 , a4 JTF_NUMBER_TABLE
893 , a5 JTF_NUMBER_TABLE
894 , a6 JTF_NUMBER_TABLE
895 , a7 JTF_VARCHAR2_TABLE_100
896 , a8 JTF_VARCHAR2_TABLE_100
897 , a9 JTF_VARCHAR2_TABLE_300
898 , a10 JTF_DATE_TABLE
899 , a11 JTF_DATE_TABLE
900 , a12 JTF_NUMBER_TABLE
901 , a13 JTF_NUMBER_TABLE
902 , a14 JTF_VARCHAR2_TABLE_100
903 , a15 JTF_VARCHAR2_TABLE_300
904 , a16 JTF_VARCHAR2_TABLE_300
905 , a17 JTF_VARCHAR2_TABLE_300
906 , a18 JTF_VARCHAR2_TABLE_300
907 , a19 JTF_VARCHAR2_TABLE_300
908 , a20 JTF_VARCHAR2_TABLE_300
909 , a21 JTF_VARCHAR2_TABLE_300
910 , a22 JTF_VARCHAR2_TABLE_300
911 , a23 JTF_VARCHAR2_TABLE_300
912 , a24 JTF_VARCHAR2_TABLE_300
913 , a25 JTF_VARCHAR2_TABLE_300
914 , a26 JTF_VARCHAR2_TABLE_300
915 , a27 JTF_VARCHAR2_TABLE_300
916 , a28 JTF_VARCHAR2_TABLE_300
917 , a29 JTF_VARCHAR2_TABLE_300
918 , a30 JTF_VARCHAR2_TABLE_100
919 , a31 JTF_NUMBER_TABLE
920 , a32 JTF_VARCHAR2_TABLE_100
921 ) as
922 ddindx binary_integer; indx binary_integer;
923 begin
924 if a0 is not null and a0.count > 0 then
925 if a0.count > 0 then
926 indx := a0.first;
927 ddindx := 1;
928 while true loop
929 t(ddindx).qualifier_id := rosetta_g_miss_num_map(a0(indx));
930 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a1(indx));
931 t(ddindx).created_by := rosetta_g_miss_num_map(a2(indx));
932 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a3(indx));
933 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a4(indx));
934 t(ddindx).last_update_login := rosetta_g_miss_num_map(a5(indx));
935 t(ddindx).qualifier_grouping_no := rosetta_g_miss_num_map(a6(indx));
936 t(ddindx).qualifier_context := a7(indx);
937 t(ddindx).qualifier_attribute := a8(indx);
938 t(ddindx).qualifier_attr_value := a9(indx);
939 t(ddindx).start_date_active := rosetta_g_miss_date_in_map(a10(indx));
940 t(ddindx).end_date_active := rosetta_g_miss_date_in_map(a11(indx));
941 t(ddindx).offer_id := rosetta_g_miss_num_map(a12(indx));
942 t(ddindx).offer_discount_line_id := rosetta_g_miss_num_map(a13(indx));
943 t(ddindx).context := a14(indx);
944 t(ddindx).attribute1 := a15(indx);
945 t(ddindx).attribute2 := a16(indx);
946 t(ddindx).attribute3 := a17(indx);
947 t(ddindx).attribute4 := a18(indx);
948 t(ddindx).attribute5 := a19(indx);
949 t(ddindx).attribute6 := a20(indx);
950 t(ddindx).attribute7 := a21(indx);
951 t(ddindx).attribute8 := a22(indx);
952 t(ddindx).attribute9 := a23(indx);
953 t(ddindx).attribute10 := a24(indx);
954 t(ddindx).attribute11 := a25(indx);
955 t(ddindx).attribute12 := a26(indx);
956 t(ddindx).attribute13 := a27(indx);
957 t(ddindx).attribute14 := a28(indx);
958 t(ddindx).attribute15 := a29(indx);
959 t(ddindx).active_flag := a30(indx);
960 t(ddindx).object_version_number := rosetta_g_miss_num_map(a31(indx));
961 t(ddindx).operation := a32(indx);
962 ddindx := ddindx+1;
963 if a0.last =indx
964 then exit;
965 end if;
966 indx := a0.next(indx);
967 end loop;
968 end if;
969 end if;
970 end rosetta_table_copy_in_p12;
971 procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
972 , a1 out nocopy JTF_DATE_TABLE
973 , a2 out nocopy JTF_NUMBER_TABLE
974 , a3 out nocopy JTF_DATE_TABLE
975 , a4 out nocopy JTF_NUMBER_TABLE
976 , a5 out nocopy JTF_NUMBER_TABLE
977 , a6 out nocopy JTF_NUMBER_TABLE
978 , a7 out nocopy JTF_VARCHAR2_TABLE_100
979 , a8 out nocopy JTF_VARCHAR2_TABLE_100
980 , a9 out nocopy JTF_VARCHAR2_TABLE_300
981 , a10 out nocopy JTF_DATE_TABLE
982 , a11 out nocopy JTF_DATE_TABLE
983 , a12 out nocopy JTF_NUMBER_TABLE
984 , a13 out nocopy JTF_NUMBER_TABLE
985 , a14 out nocopy JTF_VARCHAR2_TABLE_100
986 , a15 out nocopy JTF_VARCHAR2_TABLE_300
987 , a16 out nocopy JTF_VARCHAR2_TABLE_300
988 , a17 out nocopy JTF_VARCHAR2_TABLE_300
989 , a18 out nocopy JTF_VARCHAR2_TABLE_300
990 , a19 out nocopy JTF_VARCHAR2_TABLE_300
991 , a20 out nocopy JTF_VARCHAR2_TABLE_300
992 , a21 out nocopy JTF_VARCHAR2_TABLE_300
993 , a22 out nocopy JTF_VARCHAR2_TABLE_300
994 , a23 out nocopy JTF_VARCHAR2_TABLE_300
995 , a24 out nocopy JTF_VARCHAR2_TABLE_300
996 , a25 out nocopy JTF_VARCHAR2_TABLE_300
997 , a26 out nocopy JTF_VARCHAR2_TABLE_300
998 , a27 out nocopy JTF_VARCHAR2_TABLE_300
999 , a28 out nocopy JTF_VARCHAR2_TABLE_300
1000 , a29 out nocopy JTF_VARCHAR2_TABLE_300
1001 , a30 out nocopy JTF_VARCHAR2_TABLE_100
1002 , a31 out nocopy JTF_NUMBER_TABLE
1003 , a32 out nocopy JTF_VARCHAR2_TABLE_100
1004 ) as
1005 ddindx binary_integer; indx binary_integer;
1006 begin
1007 if t is null or t.count = 0 then
1008 a0 := JTF_NUMBER_TABLE();
1009 a1 := JTF_DATE_TABLE();
1010 a2 := JTF_NUMBER_TABLE();
1011 a3 := JTF_DATE_TABLE();
1012 a4 := JTF_NUMBER_TABLE();
1013 a5 := JTF_NUMBER_TABLE();
1014 a6 := JTF_NUMBER_TABLE();
1015 a7 := JTF_VARCHAR2_TABLE_100();
1016 a8 := JTF_VARCHAR2_TABLE_100();
1017 a9 := JTF_VARCHAR2_TABLE_300();
1018 a10 := JTF_DATE_TABLE();
1019 a11 := JTF_DATE_TABLE();
1020 a12 := JTF_NUMBER_TABLE();
1021 a13 := JTF_NUMBER_TABLE();
1022 a14 := JTF_VARCHAR2_TABLE_100();
1023 a15 := JTF_VARCHAR2_TABLE_300();
1024 a16 := JTF_VARCHAR2_TABLE_300();
1025 a17 := JTF_VARCHAR2_TABLE_300();
1026 a18 := JTF_VARCHAR2_TABLE_300();
1027 a19 := JTF_VARCHAR2_TABLE_300();
1028 a20 := JTF_VARCHAR2_TABLE_300();
1029 a21 := JTF_VARCHAR2_TABLE_300();
1030 a22 := JTF_VARCHAR2_TABLE_300();
1031 a23 := JTF_VARCHAR2_TABLE_300();
1032 a24 := JTF_VARCHAR2_TABLE_300();
1033 a25 := JTF_VARCHAR2_TABLE_300();
1034 a26 := JTF_VARCHAR2_TABLE_300();
1035 a27 := JTF_VARCHAR2_TABLE_300();
1036 a28 := JTF_VARCHAR2_TABLE_300();
1037 a29 := JTF_VARCHAR2_TABLE_300();
1038 a30 := JTF_VARCHAR2_TABLE_100();
1039 a31 := JTF_NUMBER_TABLE();
1040 a32 := JTF_VARCHAR2_TABLE_100();
1041 else
1042 a0 := JTF_NUMBER_TABLE();
1043 a1 := JTF_DATE_TABLE();
1044 a2 := JTF_NUMBER_TABLE();
1045 a3 := JTF_DATE_TABLE();
1046 a4 := JTF_NUMBER_TABLE();
1047 a5 := JTF_NUMBER_TABLE();
1048 a6 := JTF_NUMBER_TABLE();
1049 a7 := JTF_VARCHAR2_TABLE_100();
1050 a8 := JTF_VARCHAR2_TABLE_100();
1051 a9 := JTF_VARCHAR2_TABLE_300();
1052 a10 := JTF_DATE_TABLE();
1053 a11 := JTF_DATE_TABLE();
1054 a12 := JTF_NUMBER_TABLE();
1055 a13 := JTF_NUMBER_TABLE();
1056 a14 := JTF_VARCHAR2_TABLE_100();
1057 a15 := JTF_VARCHAR2_TABLE_300();
1058 a16 := JTF_VARCHAR2_TABLE_300();
1059 a17 := JTF_VARCHAR2_TABLE_300();
1060 a18 := JTF_VARCHAR2_TABLE_300();
1061 a19 := JTF_VARCHAR2_TABLE_300();
1062 a20 := JTF_VARCHAR2_TABLE_300();
1063 a21 := JTF_VARCHAR2_TABLE_300();
1064 a22 := JTF_VARCHAR2_TABLE_300();
1065 a23 := JTF_VARCHAR2_TABLE_300();
1066 a24 := JTF_VARCHAR2_TABLE_300();
1067 a25 := JTF_VARCHAR2_TABLE_300();
1068 a26 := JTF_VARCHAR2_TABLE_300();
1069 a27 := JTF_VARCHAR2_TABLE_300();
1070 a28 := JTF_VARCHAR2_TABLE_300();
1071 a29 := JTF_VARCHAR2_TABLE_300();
1072 a30 := JTF_VARCHAR2_TABLE_100();
1073 a31 := JTF_NUMBER_TABLE();
1074 a32 := JTF_VARCHAR2_TABLE_100();
1075 if t.count > 0 then
1076 a0.extend(t.count);
1077 a1.extend(t.count);
1078 a2.extend(t.count);
1079 a3.extend(t.count);
1080 a4.extend(t.count);
1081 a5.extend(t.count);
1082 a6.extend(t.count);
1083 a7.extend(t.count);
1084 a8.extend(t.count);
1085 a9.extend(t.count);
1086 a10.extend(t.count);
1087 a11.extend(t.count);
1088 a12.extend(t.count);
1089 a13.extend(t.count);
1090 a14.extend(t.count);
1091 a15.extend(t.count);
1092 a16.extend(t.count);
1093 a17.extend(t.count);
1094 a18.extend(t.count);
1095 a19.extend(t.count);
1096 a20.extend(t.count);
1097 a21.extend(t.count);
1098 a22.extend(t.count);
1099 a23.extend(t.count);
1100 a24.extend(t.count);
1101 a25.extend(t.count);
1102 a26.extend(t.count);
1103 a27.extend(t.count);
1104 a28.extend(t.count);
1105 a29.extend(t.count);
1106 a30.extend(t.count);
1107 a31.extend(t.count);
1108 a32.extend(t.count);
1109 ddindx := t.first;
1110 indx := 1;
1111 while true loop
1112 a0(indx) := rosetta_g_miss_num_map(t(ddindx).qualifier_id);
1113 a1(indx) := t(ddindx).creation_date;
1114 a2(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
1115 a3(indx) := t(ddindx).last_update_date;
1116 a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
1117 a5(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
1118 a6(indx) := rosetta_g_miss_num_map(t(ddindx).qualifier_grouping_no);
1119 a7(indx) := t(ddindx).qualifier_context;
1120 a8(indx) := t(ddindx).qualifier_attribute;
1121 a9(indx) := t(ddindx).qualifier_attr_value;
1122 a10(indx) := t(ddindx).start_date_active;
1123 a11(indx) := t(ddindx).end_date_active;
1124 a12(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
1125 a13(indx) := rosetta_g_miss_num_map(t(ddindx).offer_discount_line_id);
1126 a14(indx) := t(ddindx).context;
1127 a15(indx) := t(ddindx).attribute1;
1128 a16(indx) := t(ddindx).attribute2;
1129 a17(indx) := t(ddindx).attribute3;
1130 a18(indx) := t(ddindx).attribute4;
1131 a19(indx) := t(ddindx).attribute5;
1132 a20(indx) := t(ddindx).attribute6;
1133 a21(indx) := t(ddindx).attribute7;
1134 a22(indx) := t(ddindx).attribute8;
1135 a23(indx) := t(ddindx).attribute9;
1136 a24(indx) := t(ddindx).attribute10;
1137 a25(indx) := t(ddindx).attribute11;
1138 a26(indx) := t(ddindx).attribute12;
1139 a27(indx) := t(ddindx).attribute13;
1140 a28(indx) := t(ddindx).attribute14;
1141 a29(indx) := t(ddindx).attribute15;
1142 a30(indx) := t(ddindx).active_flag;
1143 a31(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
1144 a32(indx) := t(ddindx).operation;
1145 indx := indx+1;
1146 if t.last =ddindx
1147 then exit;
1148 end if;
1149 ddindx := t.next(ddindx);
1150 end loop;
1151 end if;
1152 end if;
1153 end rosetta_table_copy_out_p12;
1154
1155 procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
1156 , a1 JTF_NUMBER_TABLE
1157 , a2 JTF_NUMBER_TABLE
1158 , a3 JTF_VARCHAR2_TABLE_100
1159 ) as
1160 ddindx binary_integer; indx binary_integer;
1161 begin
1162 if a0 is not null and a0.count > 0 then
1163 if a0.count > 0 then
1164 indx := a0.first;
1165 ddindx := 1;
1166 while true loop
1167 t(ddindx).act_budget_id := rosetta_g_miss_num_map(a0(indx));
1168 t(ddindx).budget_id := rosetta_g_miss_num_map(a1(indx));
1169 t(ddindx).budget_amount := rosetta_g_miss_num_map(a2(indx));
1170 t(ddindx).operation := a3(indx);
1171 ddindx := ddindx+1;
1172 if a0.last =indx
1173 then exit;
1174 end if;
1175 indx := a0.next(indx);
1176 end loop;
1177 end if;
1178 end if;
1179 end rosetta_table_copy_in_p14;
1180 procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1181 , a1 out nocopy JTF_NUMBER_TABLE
1182 , a2 out nocopy JTF_NUMBER_TABLE
1183 , a3 out nocopy JTF_VARCHAR2_TABLE_100
1184 ) as
1185 ddindx binary_integer; indx binary_integer;
1186 begin
1187 if t is null or t.count = 0 then
1188 a0 := JTF_NUMBER_TABLE();
1189 a1 := JTF_NUMBER_TABLE();
1190 a2 := JTF_NUMBER_TABLE();
1191 a3 := JTF_VARCHAR2_TABLE_100();
1192 else
1193 a0 := JTF_NUMBER_TABLE();
1194 a1 := JTF_NUMBER_TABLE();
1195 a2 := JTF_NUMBER_TABLE();
1196 a3 := JTF_VARCHAR2_TABLE_100();
1197 if t.count > 0 then
1198 a0.extend(t.count);
1199 a1.extend(t.count);
1200 a2.extend(t.count);
1201 a3.extend(t.count);
1202 ddindx := t.first;
1203 indx := 1;
1204 while true loop
1205 a0(indx) := rosetta_g_miss_num_map(t(ddindx).act_budget_id);
1206 a1(indx) := rosetta_g_miss_num_map(t(ddindx).budget_id);
1207 a2(indx) := rosetta_g_miss_num_map(t(ddindx).budget_amount);
1208 a3(indx) := t(ddindx).operation;
1209 indx := indx+1;
1210 if t.last =ddindx
1211 then exit;
1212 end if;
1213 ddindx := t.next(ddindx);
1214 end loop;
1215 end if;
1216 end if;
1217 end rosetta_table_copy_out_p14;
1218
1219 procedure rosetta_table_copy_in_p17(t out nocopy ozf_offer_pub.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1220 , a1 JTF_VARCHAR2_TABLE_100
1221 , a2 JTF_NUMBER_TABLE
1222 , a3 JTF_NUMBER_TABLE
1223 , a4 JTF_VARCHAR2_TABLE_100
1224 , a5 JTF_NUMBER_TABLE
1225 , a6 JTF_DATE_TABLE
1226 , a7 JTF_DATE_TABLE
1227 , a8 JTF_VARCHAR2_TABLE_100
1228 , a9 JTF_VARCHAR2_TABLE_100
1229 , a10 JTF_NUMBER_TABLE
1230 , a11 JTF_VARCHAR2_TABLE_100
1231 , a12 JTF_NUMBER_TABLE
1232 , a13 JTF_NUMBER_TABLE
1233 , a14 JTF_VARCHAR2_TABLE_100
1234 , a15 JTF_NUMBER_TABLE
1235 , a16 JTF_VARCHAR2_TABLE_100
1236 , a17 JTF_NUMBER_TABLE
1237 , a18 JTF_NUMBER_TABLE
1238 , a19 JTF_NUMBER_TABLE
1239 , a20 JTF_NUMBER_TABLE
1240 , a21 JTF_VARCHAR2_TABLE_100
1241 , a22 JTF_VARCHAR2_TABLE_100
1242 , a23 JTF_VARCHAR2_TABLE_100
1243 , a24 JTF_VARCHAR2_TABLE_300
1244 , a25 JTF_VARCHAR2_TABLE_100
1245 , a26 JTF_NUMBER_TABLE
1246 , a27 JTF_VARCHAR2_TABLE_100
1247 , a28 JTF_VARCHAR2_TABLE_100
1248 , a29 JTF_VARCHAR2_TABLE_300
1249 , a30 JTF_VARCHAR2_TABLE_100
1250 , a31 JTF_VARCHAR2_TABLE_100
1251 , a32 JTF_VARCHAR2_TABLE_100
1252 , a33 JTF_VARCHAR2_TABLE_300
1253 , a34 JTF_VARCHAR2_TABLE_300
1254 , a35 JTF_VARCHAR2_TABLE_100
1255 , a36 JTF_VARCHAR2_TABLE_300
1256 , a37 JTF_VARCHAR2_TABLE_300
1257 , a38 JTF_NUMBER_TABLE
1258 , a39 JTF_VARCHAR2_TABLE_2000
1259 , a40 JTF_VARCHAR2_TABLE_100
1260 , a41 JTF_VARCHAR2_TABLE_300
1261 , a42 JTF_VARCHAR2_TABLE_300
1262 , a43 JTF_VARCHAR2_TABLE_300
1263 , a44 JTF_VARCHAR2_TABLE_300
1264 , a45 JTF_VARCHAR2_TABLE_300
1265 , a46 JTF_VARCHAR2_TABLE_300
1266 , a47 JTF_VARCHAR2_TABLE_300
1267 , a48 JTF_VARCHAR2_TABLE_300
1268 , a49 JTF_VARCHAR2_TABLE_300
1269 , a50 JTF_VARCHAR2_TABLE_300
1270 , a51 JTF_VARCHAR2_TABLE_300
1271 , a52 JTF_VARCHAR2_TABLE_300
1272 , a53 JTF_VARCHAR2_TABLE_300
1273 , a54 JTF_VARCHAR2_TABLE_300
1274 , a55 JTF_VARCHAR2_TABLE_300
1275 , a56 JTF_NUMBER_TABLE
1276 , a57 JTF_NUMBER_TABLE
1277 , a58 JTF_NUMBER_TABLE
1278 , a59 JTF_NUMBER_TABLE
1279 , a60 JTF_NUMBER_TABLE
1280 , a61 JTF_NUMBER_TABLE
1281 , a62 JTF_NUMBER_TABLE
1282 , a63 JTF_NUMBER_TABLE
1283 , a64 JTF_NUMBER_TABLE
1284 , a65 JTF_NUMBER_TABLE
1285 , a66 JTF_VARCHAR2_TABLE_100
1286 , a67 JTF_NUMBER_TABLE
1287 , a68 JTF_NUMBER_TABLE
1288 , a69 JTF_VARCHAR2_TABLE_300
1289 , a70 JTF_VARCHAR2_TABLE_300
1290 ) as
1291 ddindx binary_integer; indx binary_integer;
1292 begin
1293 if a0 is not null and a0.count > 0 then
1294 if a0.count > 0 then
1295 indx := a0.first;
1296 ddindx := 1;
1297 while true loop
1298 t(ddindx).offer_line_type := a0(indx);
1299 t(ddindx).operation := a1(indx);
1300 t(ddindx).list_line_id := rosetta_g_miss_num_map(a2(indx));
1301 t(ddindx).list_header_id := rosetta_g_miss_num_map(a3(indx));
1302 t(ddindx).list_line_type_code := a4(indx);
1303 t(ddindx).operand := rosetta_g_miss_num_map(a5(indx));
1304 t(ddindx).start_date_active := rosetta_g_miss_date_in_map(a6(indx));
1305 t(ddindx).end_date_active := rosetta_g_miss_date_in_map(a7(indx));
1306 t(ddindx).arithmetic_operator := a8(indx);
1307 t(ddindx).active_flag := a9(indx);
1308 t(ddindx).qd_operand := rosetta_g_miss_num_map(a10(indx));
1309 t(ddindx).qd_arithmetic_operator := a11(indx);
1310 t(ddindx).qd_related_deal_lines_id := rosetta_g_miss_num_map(a12(indx));
1311 t(ddindx).qd_object_version_number := rosetta_g_miss_num_map(a13(indx));
1312 t(ddindx).qd_estimated_qty_is_max := a14(indx);
1313 t(ddindx).qd_list_line_id := rosetta_g_miss_num_map(a15(indx));
1314 t(ddindx).qd_estimated_amount_is_max := a16(indx);
1315 t(ddindx).estim_gl_value := rosetta_g_miss_num_map(a17(indx));
1316 t(ddindx).benefit_price_list_line_id := rosetta_g_miss_num_map(a18(indx));
1317 t(ddindx).benefit_limit := rosetta_g_miss_num_map(a19(indx));
1318 t(ddindx).benefit_qty := rosetta_g_miss_num_map(a20(indx));
1319 t(ddindx).benefit_uom_code := a21(indx);
1320 t(ddindx).substitution_context := a22(indx);
1321 t(ddindx).substitution_attr := a23(indx);
1322 t(ddindx).substitution_val := a24(indx);
1323 t(ddindx).price_break_type_code := a25(indx);
1324 t(ddindx).pricing_attribute_id := rosetta_g_miss_num_map(a26(indx));
1325 t(ddindx).product_attribute_context := a27(indx);
1326 t(ddindx).product_attr := a28(indx);
1327 t(ddindx).product_attr_val := a29(indx);
1328 t(ddindx).product_uom_code := a30(indx);
1329 t(ddindx).pricing_attribute_context := a31(indx);
1330 t(ddindx).pricing_attr := a32(indx);
1331 t(ddindx).pricing_attr_value_from := a33(indx);
1332 t(ddindx).pricing_attr_value_to := a34(indx);
1333 t(ddindx).excluder_flag := a35(indx);
1334 t(ddindx).order_value_from := a36(indx);
1335 t(ddindx).order_value_to := a37(indx);
1336 t(ddindx).qualifier_id := rosetta_g_miss_num_map(a38(indx));
1337 t(ddindx).comments := a39(indx);
1338 t(ddindx).context := a40(indx);
1339 t(ddindx).attribute1 := a41(indx);
1340 t(ddindx).attribute2 := a42(indx);
1341 t(ddindx).attribute3 := a43(indx);
1342 t(ddindx).attribute4 := a44(indx);
1343 t(ddindx).attribute5 := a45(indx);
1344 t(ddindx).attribute6 := a46(indx);
1345 t(ddindx).attribute7 := a47(indx);
1346 t(ddindx).attribute8 := a48(indx);
1347 t(ddindx).attribute9 := a49(indx);
1348 t(ddindx).attribute10 := a50(indx);
1349 t(ddindx).attribute11 := a51(indx);
1350 t(ddindx).attribute12 := a52(indx);
1351 t(ddindx).attribute13 := a53(indx);
1352 t(ddindx).attribute14 := a54(indx);
1353 t(ddindx).attribute15 := a55(indx);
1354 t(ddindx).max_qty_per_order := rosetta_g_miss_num_map(a56(indx));
1355 t(ddindx).max_qty_per_order_id := rosetta_g_miss_num_map(a57(indx));
1356 t(ddindx).max_qty_per_customer := rosetta_g_miss_num_map(a58(indx));
1357 t(ddindx).max_qty_per_customer_id := rosetta_g_miss_num_map(a59(indx));
1358 t(ddindx).max_qty_per_rule := rosetta_g_miss_num_map(a60(indx));
1359 t(ddindx).max_qty_per_rule_id := rosetta_g_miss_num_map(a61(indx));
1360 t(ddindx).max_orders_per_customer := rosetta_g_miss_num_map(a62(indx));
1361 t(ddindx).max_orders_per_customer_id := rosetta_g_miss_num_map(a63(indx));
1362 t(ddindx).max_amount_per_rule := rosetta_g_miss_num_map(a64(indx));
1363 t(ddindx).max_amount_per_rule_id := rosetta_g_miss_num_map(a65(indx));
1364 t(ddindx).estimate_qty_uom := a66(indx);
1365 t(ddindx).generate_using_formula_id := rosetta_g_miss_num_map(a67(indx));
1366 t(ddindx).price_by_formula_id := rosetta_g_miss_num_map(a68(indx));
1367 t(ddindx).generate_using_formula := a69(indx);
1368 t(ddindx).price_by_formula := a70(indx);
1369 ddindx := ddindx+1;
1370 if a0.last =indx
1371 then exit;
1372 end if;
1373 indx := a0.next(indx);
1374 end loop;
1375 end if;
1376 end if;
1377 end rosetta_table_copy_in_p17;
1378 procedure rosetta_table_copy_out_p17(t ozf_offer_pub.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1379 , a1 out nocopy JTF_VARCHAR2_TABLE_100
1380 , a2 out nocopy JTF_NUMBER_TABLE
1381 , a3 out nocopy JTF_NUMBER_TABLE
1382 , a4 out nocopy JTF_VARCHAR2_TABLE_100
1383 , a5 out nocopy JTF_NUMBER_TABLE
1384 , a6 out nocopy JTF_DATE_TABLE
1385 , a7 out nocopy JTF_DATE_TABLE
1386 , a8 out nocopy JTF_VARCHAR2_TABLE_100
1387 , a9 out nocopy JTF_VARCHAR2_TABLE_100
1388 , a10 out nocopy JTF_NUMBER_TABLE
1389 , a11 out nocopy JTF_VARCHAR2_TABLE_100
1390 , a12 out nocopy JTF_NUMBER_TABLE
1391 , a13 out nocopy JTF_NUMBER_TABLE
1392 , a14 out nocopy JTF_VARCHAR2_TABLE_100
1393 , a15 out nocopy JTF_NUMBER_TABLE
1394 , a16 out nocopy JTF_VARCHAR2_TABLE_100
1395 , a17 out nocopy JTF_NUMBER_TABLE
1396 , a18 out nocopy JTF_NUMBER_TABLE
1397 , a19 out nocopy JTF_NUMBER_TABLE
1398 , a20 out nocopy JTF_NUMBER_TABLE
1399 , a21 out nocopy JTF_VARCHAR2_TABLE_100
1400 , a22 out nocopy JTF_VARCHAR2_TABLE_100
1401 , a23 out nocopy JTF_VARCHAR2_TABLE_100
1402 , a24 out nocopy JTF_VARCHAR2_TABLE_300
1403 , a25 out nocopy JTF_VARCHAR2_TABLE_100
1404 , a26 out nocopy JTF_NUMBER_TABLE
1405 , a27 out nocopy JTF_VARCHAR2_TABLE_100
1406 , a28 out nocopy JTF_VARCHAR2_TABLE_100
1407 , a29 out nocopy JTF_VARCHAR2_TABLE_300
1408 , a30 out nocopy JTF_VARCHAR2_TABLE_100
1409 , a31 out nocopy JTF_VARCHAR2_TABLE_100
1410 , a32 out nocopy JTF_VARCHAR2_TABLE_100
1411 , a33 out nocopy JTF_VARCHAR2_TABLE_300
1412 , a34 out nocopy JTF_VARCHAR2_TABLE_300
1413 , a35 out nocopy JTF_VARCHAR2_TABLE_100
1414 , a36 out nocopy JTF_VARCHAR2_TABLE_300
1415 , a37 out nocopy JTF_VARCHAR2_TABLE_300
1416 , a38 out nocopy JTF_NUMBER_TABLE
1417 , a39 out nocopy JTF_VARCHAR2_TABLE_2000
1418 , a40 out nocopy JTF_VARCHAR2_TABLE_100
1419 , a41 out nocopy JTF_VARCHAR2_TABLE_300
1420 , a42 out nocopy JTF_VARCHAR2_TABLE_300
1421 , a43 out nocopy JTF_VARCHAR2_TABLE_300
1422 , a44 out nocopy JTF_VARCHAR2_TABLE_300
1423 , a45 out nocopy JTF_VARCHAR2_TABLE_300
1424 , a46 out nocopy JTF_VARCHAR2_TABLE_300
1425 , a47 out nocopy JTF_VARCHAR2_TABLE_300
1426 , a48 out nocopy JTF_VARCHAR2_TABLE_300
1427 , a49 out nocopy JTF_VARCHAR2_TABLE_300
1428 , a50 out nocopy JTF_VARCHAR2_TABLE_300
1429 , a51 out nocopy JTF_VARCHAR2_TABLE_300
1430 , a52 out nocopy JTF_VARCHAR2_TABLE_300
1431 , a53 out nocopy JTF_VARCHAR2_TABLE_300
1432 , a54 out nocopy JTF_VARCHAR2_TABLE_300
1433 , a55 out nocopy JTF_VARCHAR2_TABLE_300
1434 , a56 out nocopy JTF_NUMBER_TABLE
1435 , a57 out nocopy JTF_NUMBER_TABLE
1436 , a58 out nocopy JTF_NUMBER_TABLE
1437 , a59 out nocopy JTF_NUMBER_TABLE
1438 , a60 out nocopy JTF_NUMBER_TABLE
1439 , a61 out nocopy JTF_NUMBER_TABLE
1440 , a62 out nocopy JTF_NUMBER_TABLE
1441 , a63 out nocopy JTF_NUMBER_TABLE
1442 , a64 out nocopy JTF_NUMBER_TABLE
1443 , a65 out nocopy JTF_NUMBER_TABLE
1444 , a66 out nocopy JTF_VARCHAR2_TABLE_100
1445 , a67 out nocopy JTF_NUMBER_TABLE
1446 , a68 out nocopy JTF_NUMBER_TABLE
1447 , a69 out nocopy JTF_VARCHAR2_TABLE_300
1448 , a70 out nocopy JTF_VARCHAR2_TABLE_300
1449 ) as
1450 ddindx binary_integer; indx binary_integer;
1451 begin
1452 if t is null or t.count = 0 then
1453 a0 := JTF_VARCHAR2_TABLE_100();
1454 a1 := JTF_VARCHAR2_TABLE_100();
1455 a2 := JTF_NUMBER_TABLE();
1456 a3 := JTF_NUMBER_TABLE();
1457 a4 := JTF_VARCHAR2_TABLE_100();
1458 a5 := JTF_NUMBER_TABLE();
1459 a6 := JTF_DATE_TABLE();
1460 a7 := JTF_DATE_TABLE();
1461 a8 := JTF_VARCHAR2_TABLE_100();
1462 a9 := JTF_VARCHAR2_TABLE_100();
1463 a10 := JTF_NUMBER_TABLE();
1464 a11 := JTF_VARCHAR2_TABLE_100();
1465 a12 := JTF_NUMBER_TABLE();
1466 a13 := JTF_NUMBER_TABLE();
1467 a14 := JTF_VARCHAR2_TABLE_100();
1468 a15 := JTF_NUMBER_TABLE();
1469 a16 := JTF_VARCHAR2_TABLE_100();
1470 a17 := JTF_NUMBER_TABLE();
1471 a18 := JTF_NUMBER_TABLE();
1472 a19 := JTF_NUMBER_TABLE();
1473 a20 := JTF_NUMBER_TABLE();
1474 a21 := JTF_VARCHAR2_TABLE_100();
1475 a22 := JTF_VARCHAR2_TABLE_100();
1476 a23 := JTF_VARCHAR2_TABLE_100();
1477 a24 := JTF_VARCHAR2_TABLE_300();
1478 a25 := JTF_VARCHAR2_TABLE_100();
1479 a26 := JTF_NUMBER_TABLE();
1480 a27 := JTF_VARCHAR2_TABLE_100();
1481 a28 := JTF_VARCHAR2_TABLE_100();
1482 a29 := JTF_VARCHAR2_TABLE_300();
1483 a30 := JTF_VARCHAR2_TABLE_100();
1484 a31 := JTF_VARCHAR2_TABLE_100();
1485 a32 := JTF_VARCHAR2_TABLE_100();
1486 a33 := JTF_VARCHAR2_TABLE_300();
1487 a34 := JTF_VARCHAR2_TABLE_300();
1488 a35 := JTF_VARCHAR2_TABLE_100();
1489 a36 := JTF_VARCHAR2_TABLE_300();
1490 a37 := JTF_VARCHAR2_TABLE_300();
1491 a38 := JTF_NUMBER_TABLE();
1492 a39 := JTF_VARCHAR2_TABLE_2000();
1493 a40 := JTF_VARCHAR2_TABLE_100();
1494 a41 := JTF_VARCHAR2_TABLE_300();
1495 a42 := JTF_VARCHAR2_TABLE_300();
1496 a43 := JTF_VARCHAR2_TABLE_300();
1497 a44 := JTF_VARCHAR2_TABLE_300();
1498 a45 := JTF_VARCHAR2_TABLE_300();
1499 a46 := JTF_VARCHAR2_TABLE_300();
1500 a47 := JTF_VARCHAR2_TABLE_300();
1501 a48 := JTF_VARCHAR2_TABLE_300();
1502 a49 := JTF_VARCHAR2_TABLE_300();
1503 a50 := JTF_VARCHAR2_TABLE_300();
1504 a51 := JTF_VARCHAR2_TABLE_300();
1505 a52 := JTF_VARCHAR2_TABLE_300();
1506 a53 := JTF_VARCHAR2_TABLE_300();
1507 a54 := JTF_VARCHAR2_TABLE_300();
1508 a55 := JTF_VARCHAR2_TABLE_300();
1509 a56 := JTF_NUMBER_TABLE();
1510 a57 := JTF_NUMBER_TABLE();
1511 a58 := JTF_NUMBER_TABLE();
1512 a59 := JTF_NUMBER_TABLE();
1513 a60 := JTF_NUMBER_TABLE();
1514 a61 := JTF_NUMBER_TABLE();
1515 a62 := JTF_NUMBER_TABLE();
1516 a63 := JTF_NUMBER_TABLE();
1517 a64 := JTF_NUMBER_TABLE();
1518 a65 := JTF_NUMBER_TABLE();
1519 a66 := JTF_VARCHAR2_TABLE_100();
1520 a67 := JTF_NUMBER_TABLE();
1521 a68 := JTF_NUMBER_TABLE();
1522 a69 := JTF_VARCHAR2_TABLE_300();
1523 a70 := JTF_VARCHAR2_TABLE_300();
1524 else
1525 a0 := JTF_VARCHAR2_TABLE_100();
1526 a1 := JTF_VARCHAR2_TABLE_100();
1527 a2 := JTF_NUMBER_TABLE();
1528 a3 := JTF_NUMBER_TABLE();
1529 a4 := JTF_VARCHAR2_TABLE_100();
1530 a5 := JTF_NUMBER_TABLE();
1531 a6 := JTF_DATE_TABLE();
1532 a7 := JTF_DATE_TABLE();
1533 a8 := JTF_VARCHAR2_TABLE_100();
1534 a9 := JTF_VARCHAR2_TABLE_100();
1535 a10 := JTF_NUMBER_TABLE();
1536 a11 := JTF_VARCHAR2_TABLE_100();
1537 a12 := JTF_NUMBER_TABLE();
1538 a13 := JTF_NUMBER_TABLE();
1539 a14 := JTF_VARCHAR2_TABLE_100();
1540 a15 := JTF_NUMBER_TABLE();
1541 a16 := JTF_VARCHAR2_TABLE_100();
1542 a17 := JTF_NUMBER_TABLE();
1543 a18 := JTF_NUMBER_TABLE();
1544 a19 := JTF_NUMBER_TABLE();
1545 a20 := JTF_NUMBER_TABLE();
1546 a21 := JTF_VARCHAR2_TABLE_100();
1547 a22 := JTF_VARCHAR2_TABLE_100();
1548 a23 := JTF_VARCHAR2_TABLE_100();
1549 a24 := JTF_VARCHAR2_TABLE_300();
1550 a25 := JTF_VARCHAR2_TABLE_100();
1551 a26 := JTF_NUMBER_TABLE();
1552 a27 := JTF_VARCHAR2_TABLE_100();
1553 a28 := JTF_VARCHAR2_TABLE_100();
1554 a29 := JTF_VARCHAR2_TABLE_300();
1555 a30 := JTF_VARCHAR2_TABLE_100();
1556 a31 := JTF_VARCHAR2_TABLE_100();
1557 a32 := JTF_VARCHAR2_TABLE_100();
1558 a33 := JTF_VARCHAR2_TABLE_300();
1559 a34 := JTF_VARCHAR2_TABLE_300();
1560 a35 := JTF_VARCHAR2_TABLE_100();
1561 a36 := JTF_VARCHAR2_TABLE_300();
1562 a37 := JTF_VARCHAR2_TABLE_300();
1563 a38 := JTF_NUMBER_TABLE();
1564 a39 := JTF_VARCHAR2_TABLE_2000();
1565 a40 := JTF_VARCHAR2_TABLE_100();
1566 a41 := JTF_VARCHAR2_TABLE_300();
1567 a42 := JTF_VARCHAR2_TABLE_300();
1568 a43 := JTF_VARCHAR2_TABLE_300();
1569 a44 := JTF_VARCHAR2_TABLE_300();
1570 a45 := JTF_VARCHAR2_TABLE_300();
1571 a46 := JTF_VARCHAR2_TABLE_300();
1572 a47 := JTF_VARCHAR2_TABLE_300();
1573 a48 := JTF_VARCHAR2_TABLE_300();
1574 a49 := JTF_VARCHAR2_TABLE_300();
1575 a50 := JTF_VARCHAR2_TABLE_300();
1576 a51 := JTF_VARCHAR2_TABLE_300();
1577 a52 := JTF_VARCHAR2_TABLE_300();
1578 a53 := JTF_VARCHAR2_TABLE_300();
1579 a54 := JTF_VARCHAR2_TABLE_300();
1580 a55 := JTF_VARCHAR2_TABLE_300();
1581 a56 := JTF_NUMBER_TABLE();
1582 a57 := JTF_NUMBER_TABLE();
1583 a58 := JTF_NUMBER_TABLE();
1584 a59 := JTF_NUMBER_TABLE();
1585 a60 := JTF_NUMBER_TABLE();
1586 a61 := JTF_NUMBER_TABLE();
1587 a62 := JTF_NUMBER_TABLE();
1588 a63 := JTF_NUMBER_TABLE();
1589 a64 := JTF_NUMBER_TABLE();
1590 a65 := JTF_NUMBER_TABLE();
1591 a66 := JTF_VARCHAR2_TABLE_100();
1592 a67 := JTF_NUMBER_TABLE();
1593 a68 := JTF_NUMBER_TABLE();
1594 a69 := JTF_VARCHAR2_TABLE_300();
1595 a70 := JTF_VARCHAR2_TABLE_300();
1596 if t.count > 0 then
1597 a0.extend(t.count);
1598 a1.extend(t.count);
1599 a2.extend(t.count);
1600 a3.extend(t.count);
1601 a4.extend(t.count);
1602 a5.extend(t.count);
1603 a6.extend(t.count);
1604 a7.extend(t.count);
1605 a8.extend(t.count);
1606 a9.extend(t.count);
1607 a10.extend(t.count);
1608 a11.extend(t.count);
1609 a12.extend(t.count);
1610 a13.extend(t.count);
1611 a14.extend(t.count);
1612 a15.extend(t.count);
1613 a16.extend(t.count);
1614 a17.extend(t.count);
1615 a18.extend(t.count);
1616 a19.extend(t.count);
1617 a20.extend(t.count);
1618 a21.extend(t.count);
1619 a22.extend(t.count);
1620 a23.extend(t.count);
1621 a24.extend(t.count);
1622 a25.extend(t.count);
1623 a26.extend(t.count);
1624 a27.extend(t.count);
1625 a28.extend(t.count);
1626 a29.extend(t.count);
1627 a30.extend(t.count);
1628 a31.extend(t.count);
1629 a32.extend(t.count);
1630 a33.extend(t.count);
1631 a34.extend(t.count);
1632 a35.extend(t.count);
1633 a36.extend(t.count);
1634 a37.extend(t.count);
1635 a38.extend(t.count);
1636 a39.extend(t.count);
1637 a40.extend(t.count);
1638 a41.extend(t.count);
1639 a42.extend(t.count);
1640 a43.extend(t.count);
1641 a44.extend(t.count);
1642 a45.extend(t.count);
1643 a46.extend(t.count);
1644 a47.extend(t.count);
1645 a48.extend(t.count);
1646 a49.extend(t.count);
1647 a50.extend(t.count);
1648 a51.extend(t.count);
1649 a52.extend(t.count);
1650 a53.extend(t.count);
1651 a54.extend(t.count);
1652 a55.extend(t.count);
1653 a56.extend(t.count);
1654 a57.extend(t.count);
1655 a58.extend(t.count);
1656 a59.extend(t.count);
1657 a60.extend(t.count);
1658 a61.extend(t.count);
1659 a62.extend(t.count);
1660 a63.extend(t.count);
1661 a64.extend(t.count);
1662 a65.extend(t.count);
1663 a66.extend(t.count);
1664 a67.extend(t.count);
1665 a68.extend(t.count);
1666 a69.extend(t.count);
1667 a70.extend(t.count);
1668 ddindx := t.first;
1669 indx := 1;
1670 while true loop
1671 a0(indx) := t(ddindx).offer_line_type;
1672 a1(indx) := t(ddindx).operation;
1673 a2(indx) := rosetta_g_miss_num_map(t(ddindx).list_line_id);
1674 a3(indx) := rosetta_g_miss_num_map(t(ddindx).list_header_id);
1675 a4(indx) := t(ddindx).list_line_type_code;
1676 a5(indx) := rosetta_g_miss_num_map(t(ddindx).operand);
1677 a6(indx) := t(ddindx).start_date_active;
1678 a7(indx) := t(ddindx).end_date_active;
1679 a8(indx) := t(ddindx).arithmetic_operator;
1680 a9(indx) := t(ddindx).active_flag;
1681 a10(indx) := rosetta_g_miss_num_map(t(ddindx).qd_operand);
1682 a11(indx) := t(ddindx).qd_arithmetic_operator;
1683 a12(indx) := rosetta_g_miss_num_map(t(ddindx).qd_related_deal_lines_id);
1684 a13(indx) := rosetta_g_miss_num_map(t(ddindx).qd_object_version_number);
1685 a14(indx) := t(ddindx).qd_estimated_qty_is_max;
1686 a15(indx) := rosetta_g_miss_num_map(t(ddindx).qd_list_line_id);
1687 a16(indx) := t(ddindx).qd_estimated_amount_is_max;
1688 a17(indx) := rosetta_g_miss_num_map(t(ddindx).estim_gl_value);
1689 a18(indx) := rosetta_g_miss_num_map(t(ddindx).benefit_price_list_line_id);
1690 a19(indx) := rosetta_g_miss_num_map(t(ddindx).benefit_limit);
1691 a20(indx) := rosetta_g_miss_num_map(t(ddindx).benefit_qty);
1692 a21(indx) := t(ddindx).benefit_uom_code;
1693 a22(indx) := t(ddindx).substitution_context;
1694 a23(indx) := t(ddindx).substitution_attr;
1695 a24(indx) := t(ddindx).substitution_val;
1696 a25(indx) := t(ddindx).price_break_type_code;
1697 a26(indx) := rosetta_g_miss_num_map(t(ddindx).pricing_attribute_id);
1698 a27(indx) := t(ddindx).product_attribute_context;
1699 a28(indx) := t(ddindx).product_attr;
1700 a29(indx) := t(ddindx).product_attr_val;
1701 a30(indx) := t(ddindx).product_uom_code;
1702 a31(indx) := t(ddindx).pricing_attribute_context;
1703 a32(indx) := t(ddindx).pricing_attr;
1704 a33(indx) := t(ddindx).pricing_attr_value_from;
1705 a34(indx) := t(ddindx).pricing_attr_value_to;
1706 a35(indx) := t(ddindx).excluder_flag;
1707 a36(indx) := t(ddindx).order_value_from;
1708 a37(indx) := t(ddindx).order_value_to;
1709 a38(indx) := rosetta_g_miss_num_map(t(ddindx).qualifier_id);
1710 a39(indx) := t(ddindx).comments;
1711 a40(indx) := t(ddindx).context;
1712 a41(indx) := t(ddindx).attribute1;
1713 a42(indx) := t(ddindx).attribute2;
1714 a43(indx) := t(ddindx).attribute3;
1715 a44(indx) := t(ddindx).attribute4;
1716 a45(indx) := t(ddindx).attribute5;
1717 a46(indx) := t(ddindx).attribute6;
1718 a47(indx) := t(ddindx).attribute7;
1719 a48(indx) := t(ddindx).attribute8;
1720 a49(indx) := t(ddindx).attribute9;
1721 a50(indx) := t(ddindx).attribute10;
1722 a51(indx) := t(ddindx).attribute11;
1723 a52(indx) := t(ddindx).attribute12;
1724 a53(indx) := t(ddindx).attribute13;
1725 a54(indx) := t(ddindx).attribute14;
1726 a55(indx) := t(ddindx).attribute15;
1727 a56(indx) := rosetta_g_miss_num_map(t(ddindx).max_qty_per_order);
1728 a57(indx) := rosetta_g_miss_num_map(t(ddindx).max_qty_per_order_id);
1729 a58(indx) := rosetta_g_miss_num_map(t(ddindx).max_qty_per_customer);
1730 a59(indx) := rosetta_g_miss_num_map(t(ddindx).max_qty_per_customer_id);
1731 a60(indx) := rosetta_g_miss_num_map(t(ddindx).max_qty_per_rule);
1732 a61(indx) := rosetta_g_miss_num_map(t(ddindx).max_qty_per_rule_id);
1733 a62(indx) := rosetta_g_miss_num_map(t(ddindx).max_orders_per_customer);
1734 a63(indx) := rosetta_g_miss_num_map(t(ddindx).max_orders_per_customer_id);
1735 a64(indx) := rosetta_g_miss_num_map(t(ddindx).max_amount_per_rule);
1736 a65(indx) := rosetta_g_miss_num_map(t(ddindx).max_amount_per_rule_id);
1737 a66(indx) := t(ddindx).estimate_qty_uom;
1738 a67(indx) := rosetta_g_miss_num_map(t(ddindx).generate_using_formula_id);
1739 a68(indx) := rosetta_g_miss_num_map(t(ddindx).price_by_formula_id);
1740 a69(indx) := t(ddindx).generate_using_formula;
1741 a70(indx) := t(ddindx).price_by_formula;
1742 indx := indx+1;
1743 if t.last =ddindx
1744 then exit;
1745 end if;
1746 ddindx := t.next(ddindx);
1747 end loop;
1748 end if;
1749 end if;
1750 end rosetta_table_copy_out_p17;
1751
1752 procedure rosetta_table_copy_in_p19(t out nocopy ozf_offer_pub.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1753 , a1 JTF_VARCHAR2_TABLE_100
1754 , a2 JTF_VARCHAR2_TABLE_300
1755 , a3 JTF_VARCHAR2_TABLE_300
1756 , a4 JTF_VARCHAR2_TABLE_100
1757 , a5 JTF_NUMBER_TABLE
1758 , a6 JTF_NUMBER_TABLE
1759 , a7 JTF_NUMBER_TABLE
1760 , a8 JTF_NUMBER_TABLE
1761 , a9 JTF_DATE_TABLE
1762 , a10 JTF_DATE_TABLE
1763 , a11 JTF_NUMBER_TABLE
1764 , a12 JTF_VARCHAR2_TABLE_100
1765 , a13 JTF_VARCHAR2_TABLE_100
1766 , a14 JTF_VARCHAR2_TABLE_300
1767 , a15 JTF_VARCHAR2_TABLE_300
1768 , a16 JTF_VARCHAR2_TABLE_300
1769 , a17 JTF_VARCHAR2_TABLE_300
1770 , a18 JTF_VARCHAR2_TABLE_300
1771 , a19 JTF_VARCHAR2_TABLE_300
1772 , a20 JTF_VARCHAR2_TABLE_300
1773 , a21 JTF_VARCHAR2_TABLE_300
1774 , a22 JTF_VARCHAR2_TABLE_300
1775 , a23 JTF_VARCHAR2_TABLE_300
1776 , a24 JTF_VARCHAR2_TABLE_300
1777 , a25 JTF_VARCHAR2_TABLE_300
1778 , a26 JTF_VARCHAR2_TABLE_300
1779 , a27 JTF_VARCHAR2_TABLE_300
1780 , a28 JTF_VARCHAR2_TABLE_300
1781 ) as
1782 ddindx binary_integer; indx binary_integer;
1783 begin
1784 if a0 is not null and a0.count > 0 then
1785 if a0.count > 0 then
1786 indx := a0.first;
1787 ddindx := 1;
1788 while true loop
1789 t(ddindx).qualifier_context := a0(indx);
1790 t(ddindx).qualifier_attribute := a1(indx);
1791 t(ddindx).qualifier_attr_value := a2(indx);
1792 t(ddindx).qualifier_attr_value_to := a3(indx);
1793 t(ddindx).comparison_operator_code := a4(indx);
1794 t(ddindx).qualifier_grouping_no := rosetta_g_miss_num_map(a5(indx));
1795 t(ddindx).list_line_id := rosetta_g_miss_num_map(a6(indx));
1796 t(ddindx).list_header_id := rosetta_g_miss_num_map(a7(indx));
1797 t(ddindx).qualifier_id := rosetta_g_miss_num_map(a8(indx));
1798 t(ddindx).start_date_active := rosetta_g_miss_date_in_map(a9(indx));
1799 t(ddindx).end_date_active := rosetta_g_miss_date_in_map(a10(indx));
1800 t(ddindx).activity_market_segment_id := rosetta_g_miss_num_map(a11(indx));
1801 t(ddindx).operation := a12(indx);
1802 t(ddindx).context := a13(indx);
1803 t(ddindx).attribute1 := a14(indx);
1804 t(ddindx).attribute2 := a15(indx);
1805 t(ddindx).attribute3 := a16(indx);
1806 t(ddindx).attribute4 := a17(indx);
1807 t(ddindx).attribute5 := a18(indx);
1808 t(ddindx).attribute6 := a19(indx);
1809 t(ddindx).attribute7 := a20(indx);
1810 t(ddindx).attribute8 := a21(indx);
1811 t(ddindx).attribute9 := a22(indx);
1812 t(ddindx).attribute10 := a23(indx);
1813 t(ddindx).attribute11 := a24(indx);
1814 t(ddindx).attribute12 := a25(indx);
1815 t(ddindx).attribute13 := a26(indx);
1816 t(ddindx).attribute14 := a27(indx);
1817 t(ddindx).attribute15 := a28(indx);
1818 ddindx := ddindx+1;
1819 if a0.last =indx
1820 then exit;
1821 end if;
1822 indx := a0.next(indx);
1823 end loop;
1824 end if;
1825 end if;
1826 end rosetta_table_copy_in_p19;
1827 procedure rosetta_table_copy_out_p19(t ozf_offer_pub.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1828 , a1 out nocopy JTF_VARCHAR2_TABLE_100
1829 , a2 out nocopy JTF_VARCHAR2_TABLE_300
1830 , a3 out nocopy JTF_VARCHAR2_TABLE_300
1831 , a4 out nocopy JTF_VARCHAR2_TABLE_100
1832 , a5 out nocopy JTF_NUMBER_TABLE
1833 , a6 out nocopy JTF_NUMBER_TABLE
1834 , a7 out nocopy JTF_NUMBER_TABLE
1835 , a8 out nocopy JTF_NUMBER_TABLE
1836 , a9 out nocopy JTF_DATE_TABLE
1837 , a10 out nocopy JTF_DATE_TABLE
1838 , a11 out nocopy JTF_NUMBER_TABLE
1839 , a12 out nocopy JTF_VARCHAR2_TABLE_100
1840 , a13 out nocopy JTF_VARCHAR2_TABLE_100
1841 , a14 out nocopy JTF_VARCHAR2_TABLE_300
1842 , a15 out nocopy JTF_VARCHAR2_TABLE_300
1843 , a16 out nocopy JTF_VARCHAR2_TABLE_300
1844 , a17 out nocopy JTF_VARCHAR2_TABLE_300
1845 , a18 out nocopy JTF_VARCHAR2_TABLE_300
1846 , a19 out nocopy JTF_VARCHAR2_TABLE_300
1847 , a20 out nocopy JTF_VARCHAR2_TABLE_300
1848 , a21 out nocopy JTF_VARCHAR2_TABLE_300
1849 , a22 out nocopy JTF_VARCHAR2_TABLE_300
1850 , a23 out nocopy JTF_VARCHAR2_TABLE_300
1851 , a24 out nocopy JTF_VARCHAR2_TABLE_300
1852 , a25 out nocopy JTF_VARCHAR2_TABLE_300
1853 , a26 out nocopy JTF_VARCHAR2_TABLE_300
1854 , a27 out nocopy JTF_VARCHAR2_TABLE_300
1855 , a28 out nocopy JTF_VARCHAR2_TABLE_300
1856 ) as
1857 ddindx binary_integer; indx binary_integer;
1858 begin
1859 if t is null or t.count = 0 then
1860 a0 := JTF_VARCHAR2_TABLE_100();
1861 a1 := JTF_VARCHAR2_TABLE_100();
1862 a2 := JTF_VARCHAR2_TABLE_300();
1863 a3 := JTF_VARCHAR2_TABLE_300();
1864 a4 := JTF_VARCHAR2_TABLE_100();
1865 a5 := JTF_NUMBER_TABLE();
1866 a6 := JTF_NUMBER_TABLE();
1867 a7 := JTF_NUMBER_TABLE();
1868 a8 := JTF_NUMBER_TABLE();
1869 a9 := JTF_DATE_TABLE();
1870 a10 := JTF_DATE_TABLE();
1871 a11 := JTF_NUMBER_TABLE();
1872 a12 := JTF_VARCHAR2_TABLE_100();
1873 a13 := JTF_VARCHAR2_TABLE_100();
1874 a14 := JTF_VARCHAR2_TABLE_300();
1875 a15 := JTF_VARCHAR2_TABLE_300();
1876 a16 := JTF_VARCHAR2_TABLE_300();
1877 a17 := JTF_VARCHAR2_TABLE_300();
1878 a18 := JTF_VARCHAR2_TABLE_300();
1879 a19 := JTF_VARCHAR2_TABLE_300();
1880 a20 := JTF_VARCHAR2_TABLE_300();
1881 a21 := JTF_VARCHAR2_TABLE_300();
1882 a22 := JTF_VARCHAR2_TABLE_300();
1883 a23 := JTF_VARCHAR2_TABLE_300();
1884 a24 := JTF_VARCHAR2_TABLE_300();
1885 a25 := JTF_VARCHAR2_TABLE_300();
1886 a26 := JTF_VARCHAR2_TABLE_300();
1887 a27 := JTF_VARCHAR2_TABLE_300();
1888 a28 := JTF_VARCHAR2_TABLE_300();
1889 else
1890 a0 := JTF_VARCHAR2_TABLE_100();
1891 a1 := JTF_VARCHAR2_TABLE_100();
1892 a2 := JTF_VARCHAR2_TABLE_300();
1893 a3 := JTF_VARCHAR2_TABLE_300();
1894 a4 := JTF_VARCHAR2_TABLE_100();
1895 a5 := JTF_NUMBER_TABLE();
1896 a6 := JTF_NUMBER_TABLE();
1897 a7 := JTF_NUMBER_TABLE();
1898 a8 := JTF_NUMBER_TABLE();
1899 a9 := JTF_DATE_TABLE();
1900 a10 := JTF_DATE_TABLE();
1901 a11 := JTF_NUMBER_TABLE();
1902 a12 := JTF_VARCHAR2_TABLE_100();
1903 a13 := JTF_VARCHAR2_TABLE_100();
1904 a14 := JTF_VARCHAR2_TABLE_300();
1905 a15 := JTF_VARCHAR2_TABLE_300();
1906 a16 := JTF_VARCHAR2_TABLE_300();
1907 a17 := JTF_VARCHAR2_TABLE_300();
1908 a18 := JTF_VARCHAR2_TABLE_300();
1909 a19 := JTF_VARCHAR2_TABLE_300();
1910 a20 := JTF_VARCHAR2_TABLE_300();
1911 a21 := JTF_VARCHAR2_TABLE_300();
1912 a22 := JTF_VARCHAR2_TABLE_300();
1913 a23 := JTF_VARCHAR2_TABLE_300();
1914 a24 := JTF_VARCHAR2_TABLE_300();
1915 a25 := JTF_VARCHAR2_TABLE_300();
1916 a26 := JTF_VARCHAR2_TABLE_300();
1917 a27 := JTF_VARCHAR2_TABLE_300();
1918 a28 := JTF_VARCHAR2_TABLE_300();
1919 if t.count > 0 then
1920 a0.extend(t.count);
1921 a1.extend(t.count);
1922 a2.extend(t.count);
1923 a3.extend(t.count);
1924 a4.extend(t.count);
1925 a5.extend(t.count);
1926 a6.extend(t.count);
1927 a7.extend(t.count);
1928 a8.extend(t.count);
1929 a9.extend(t.count);
1930 a10.extend(t.count);
1931 a11.extend(t.count);
1932 a12.extend(t.count);
1933 a13.extend(t.count);
1934 a14.extend(t.count);
1935 a15.extend(t.count);
1936 a16.extend(t.count);
1937 a17.extend(t.count);
1938 a18.extend(t.count);
1939 a19.extend(t.count);
1940 a20.extend(t.count);
1941 a21.extend(t.count);
1942 a22.extend(t.count);
1943 a23.extend(t.count);
1944 a24.extend(t.count);
1945 a25.extend(t.count);
1946 a26.extend(t.count);
1947 a27.extend(t.count);
1948 a28.extend(t.count);
1949 ddindx := t.first;
1950 indx := 1;
1951 while true loop
1952 a0(indx) := t(ddindx).qualifier_context;
1953 a1(indx) := t(ddindx).qualifier_attribute;
1954 a2(indx) := t(ddindx).qualifier_attr_value;
1955 a3(indx) := t(ddindx).qualifier_attr_value_to;
1956 a4(indx) := t(ddindx).comparison_operator_code;
1957 a5(indx) := rosetta_g_miss_num_map(t(ddindx).qualifier_grouping_no);
1958 a6(indx) := rosetta_g_miss_num_map(t(ddindx).list_line_id);
1959 a7(indx) := rosetta_g_miss_num_map(t(ddindx).list_header_id);
1960 a8(indx) := rosetta_g_miss_num_map(t(ddindx).qualifier_id);
1961 a9(indx) := t(ddindx).start_date_active;
1962 a10(indx) := t(ddindx).end_date_active;
1963 a11(indx) := rosetta_g_miss_num_map(t(ddindx).activity_market_segment_id);
1964 a12(indx) := t(ddindx).operation;
1965 a13(indx) := t(ddindx).context;
1966 a14(indx) := t(ddindx).attribute1;
1967 a15(indx) := t(ddindx).attribute2;
1968 a16(indx) := t(ddindx).attribute3;
1969 a17(indx) := t(ddindx).attribute4;
1970 a18(indx) := t(ddindx).attribute5;
1971 a19(indx) := t(ddindx).attribute6;
1972 a20(indx) := t(ddindx).attribute7;
1973 a21(indx) := t(ddindx).attribute8;
1974 a22(indx) := t(ddindx).attribute9;
1975 a23(indx) := t(ddindx).attribute10;
1976 a24(indx) := t(ddindx).attribute11;
1977 a25(indx) := t(ddindx).attribute12;
1978 a26(indx) := t(ddindx).attribute13;
1979 a27(indx) := t(ddindx).attribute14;
1980 a28(indx) := t(ddindx).attribute15;
1981 indx := indx+1;
1982 if t.last =ddindx
1983 then exit;
1984 end if;
1985 ddindx := t.next(ddindx);
1986 end loop;
1987 end if;
1988 end if;
1989 end rosetta_table_copy_out_p19;
1990
1991 procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1992 , a1 JTF_NUMBER_TABLE
1993 , a2 JTF_NUMBER_TABLE
1994 , a3 JTF_NUMBER_TABLE
1995 , a4 JTF_VARCHAR2_TABLE_100
1996 , a5 JTF_VARCHAR2_TABLE_100
1997 , a6 JTF_VARCHAR2_TABLE_100
1998 , a7 JTF_NUMBER_TABLE
1999 , a8 JTF_VARCHAR2_TABLE_100
2000 , a9 JTF_VARCHAR2_TABLE_100
2001 , a10 JTF_VARCHAR2_TABLE_100
2002 , a11 JTF_VARCHAR2_TABLE_100
2003 , a12 JTF_NUMBER_TABLE
2004 , a13 JTF_NUMBER_TABLE
2005 , a14 JTF_VARCHAR2_TABLE_100
2006 , a15 JTF_NUMBER_TABLE
2007 , a16 JTF_NUMBER_TABLE
2008 , a17 JTF_VARCHAR2_TABLE_300
2009 , a18 JTF_VARCHAR2_TABLE_2000
2010 , a19 JTF_VARCHAR2_TABLE_100
2011 , a20 JTF_NUMBER_TABLE
2012 ) as
2013 ddindx binary_integer; indx binary_integer;
2014 begin
2015 if a0 is not null and a0.count > 0 then
2016 if a0.count > 0 then
2017 indx := a0.first;
2018 ddindx := 1;
2019 while true loop
2020 t(ddindx).offer_discount_line_id := rosetta_g_miss_num_map(a0(indx));
2021 t(ddindx).parent_discount_line_id := rosetta_g_miss_num_map(a1(indx));
2022 t(ddindx).volume_from := rosetta_g_miss_num_map(a2(indx));
2023 t(ddindx).volume_to := rosetta_g_miss_num_map(a3(indx));
2024 t(ddindx).volume_operator := a4(indx);
2025 t(ddindx).volume_type := a5(indx);
2026 t(ddindx).volume_break_type := a6(indx);
2027 t(ddindx).discount := rosetta_g_miss_num_map(a7(indx));
2028 t(ddindx).discount_type := a8(indx);
2029 t(ddindx).tier_type := a9(indx);
2030 t(ddindx).tier_level := a10(indx);
2031 t(ddindx).uom_code := a11(indx);
2032 t(ddindx).object_version_number := rosetta_g_miss_num_map(a12(indx));
2033 t(ddindx).offer_id := rosetta_g_miss_num_map(a13(indx));
2034 t(ddindx).discount_by_code := a14(indx);
2035 t(ddindx).formula_id := rosetta_g_miss_num_map(a15(indx));
2036 t(ddindx).offr_disc_struct_name_id := rosetta_g_miss_num_map(a16(indx));
2037 t(ddindx).name := a17(indx);
2038 t(ddindx).description := a18(indx);
2039 t(ddindx).operation := a19(indx);
2040 t(ddindx).pbh_index := rosetta_g_miss_num_map(a20(indx));
2041 ddindx := ddindx+1;
2042 if a0.last =indx
2043 then exit;
2044 end if;
2045 indx := a0.next(indx);
2046 end loop;
2047 end if;
2048 end if;
2049 end rosetta_table_copy_in_p21;
2050 procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2051 , a1 out nocopy JTF_NUMBER_TABLE
2052 , a2 out nocopy JTF_NUMBER_TABLE
2053 , a3 out nocopy JTF_NUMBER_TABLE
2054 , a4 out nocopy JTF_VARCHAR2_TABLE_100
2055 , a5 out nocopy JTF_VARCHAR2_TABLE_100
2056 , a6 out nocopy JTF_VARCHAR2_TABLE_100
2057 , a7 out nocopy JTF_NUMBER_TABLE
2058 , a8 out nocopy JTF_VARCHAR2_TABLE_100
2059 , a9 out nocopy JTF_VARCHAR2_TABLE_100
2060 , a10 out nocopy JTF_VARCHAR2_TABLE_100
2061 , a11 out nocopy JTF_VARCHAR2_TABLE_100
2062 , a12 out nocopy JTF_NUMBER_TABLE
2063 , a13 out nocopy JTF_NUMBER_TABLE
2064 , a14 out nocopy JTF_VARCHAR2_TABLE_100
2065 , a15 out nocopy JTF_NUMBER_TABLE
2066 , a16 out nocopy JTF_NUMBER_TABLE
2067 , a17 out nocopy JTF_VARCHAR2_TABLE_300
2068 , a18 out nocopy JTF_VARCHAR2_TABLE_2000
2069 , a19 out nocopy JTF_VARCHAR2_TABLE_100
2070 , a20 out nocopy JTF_NUMBER_TABLE
2071 ) as
2072 ddindx binary_integer; indx binary_integer;
2073 begin
2074 if t is null or t.count = 0 then
2075 a0 := JTF_NUMBER_TABLE();
2076 a1 := JTF_NUMBER_TABLE();
2077 a2 := JTF_NUMBER_TABLE();
2078 a3 := JTF_NUMBER_TABLE();
2079 a4 := JTF_VARCHAR2_TABLE_100();
2080 a5 := JTF_VARCHAR2_TABLE_100();
2081 a6 := JTF_VARCHAR2_TABLE_100();
2082 a7 := JTF_NUMBER_TABLE();
2083 a8 := JTF_VARCHAR2_TABLE_100();
2084 a9 := JTF_VARCHAR2_TABLE_100();
2085 a10 := JTF_VARCHAR2_TABLE_100();
2086 a11 := JTF_VARCHAR2_TABLE_100();
2087 a12 := JTF_NUMBER_TABLE();
2088 a13 := JTF_NUMBER_TABLE();
2089 a14 := JTF_VARCHAR2_TABLE_100();
2090 a15 := JTF_NUMBER_TABLE();
2091 a16 := JTF_NUMBER_TABLE();
2092 a17 := JTF_VARCHAR2_TABLE_300();
2093 a18 := JTF_VARCHAR2_TABLE_2000();
2094 a19 := JTF_VARCHAR2_TABLE_100();
2095 a20 := JTF_NUMBER_TABLE();
2096 else
2097 a0 := JTF_NUMBER_TABLE();
2098 a1 := JTF_NUMBER_TABLE();
2099 a2 := JTF_NUMBER_TABLE();
2100 a3 := JTF_NUMBER_TABLE();
2101 a4 := JTF_VARCHAR2_TABLE_100();
2102 a5 := JTF_VARCHAR2_TABLE_100();
2103 a6 := JTF_VARCHAR2_TABLE_100();
2104 a7 := JTF_NUMBER_TABLE();
2105 a8 := JTF_VARCHAR2_TABLE_100();
2106 a9 := JTF_VARCHAR2_TABLE_100();
2107 a10 := JTF_VARCHAR2_TABLE_100();
2108 a11 := JTF_VARCHAR2_TABLE_100();
2109 a12 := JTF_NUMBER_TABLE();
2110 a13 := JTF_NUMBER_TABLE();
2111 a14 := JTF_VARCHAR2_TABLE_100();
2112 a15 := JTF_NUMBER_TABLE();
2113 a16 := JTF_NUMBER_TABLE();
2114 a17 := JTF_VARCHAR2_TABLE_300();
2115 a18 := JTF_VARCHAR2_TABLE_2000();
2116 a19 := JTF_VARCHAR2_TABLE_100();
2117 a20 := JTF_NUMBER_TABLE();
2118 if t.count > 0 then
2119 a0.extend(t.count);
2120 a1.extend(t.count);
2121 a2.extend(t.count);
2122 a3.extend(t.count);
2123 a4.extend(t.count);
2124 a5.extend(t.count);
2125 a6.extend(t.count);
2126 a7.extend(t.count);
2127 a8.extend(t.count);
2128 a9.extend(t.count);
2129 a10.extend(t.count);
2130 a11.extend(t.count);
2131 a12.extend(t.count);
2132 a13.extend(t.count);
2133 a14.extend(t.count);
2134 a15.extend(t.count);
2135 a16.extend(t.count);
2136 a17.extend(t.count);
2137 a18.extend(t.count);
2138 a19.extend(t.count);
2139 a20.extend(t.count);
2140 ddindx := t.first;
2141 indx := 1;
2142 while true loop
2143 a0(indx) := rosetta_g_miss_num_map(t(ddindx).offer_discount_line_id);
2144 a1(indx) := rosetta_g_miss_num_map(t(ddindx).parent_discount_line_id);
2145 a2(indx) := rosetta_g_miss_num_map(t(ddindx).volume_from);
2146 a3(indx) := rosetta_g_miss_num_map(t(ddindx).volume_to);
2147 a4(indx) := t(ddindx).volume_operator;
2148 a5(indx) := t(ddindx).volume_type;
2149 a6(indx) := t(ddindx).volume_break_type;
2150 a7(indx) := rosetta_g_miss_num_map(t(ddindx).discount);
2151 a8(indx) := t(ddindx).discount_type;
2152 a9(indx) := t(ddindx).tier_type;
2153 a10(indx) := t(ddindx).tier_level;
2154 a11(indx) := t(ddindx).uom_code;
2155 a12(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
2156 a13(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
2157 a14(indx) := t(ddindx).discount_by_code;
2158 a15(indx) := rosetta_g_miss_num_map(t(ddindx).formula_id);
2159 a16(indx) := rosetta_g_miss_num_map(t(ddindx).offr_disc_struct_name_id);
2160 a17(indx) := t(ddindx).name;
2161 a18(indx) := t(ddindx).description;
2162 a19(indx) := t(ddindx).operation;
2163 a20(indx) := rosetta_g_miss_num_map(t(ddindx).pbh_index);
2164 indx := indx+1;
2165 if t.last =ddindx
2166 then exit;
2167 end if;
2168 ddindx := t.next(ddindx);
2169 end loop;
2170 end if;
2171 end if;
2172 end rosetta_table_copy_out_p21;
2173
2174 procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2175 , a1 JTF_VARCHAR2_TABLE_100
2176 , a2 JTF_NUMBER_TABLE
2177 , a3 JTF_NUMBER_TABLE
2178 , a4 JTF_NUMBER_TABLE
2179 , a5 JTF_VARCHAR2_TABLE_100
2180 , a6 JTF_VARCHAR2_TABLE_100
2181 , a7 JTF_VARCHAR2_TABLE_300
2182 , a8 JTF_VARCHAR2_TABLE_100
2183 , a9 JTF_VARCHAR2_TABLE_100
2184 , a10 JTF_VARCHAR2_TABLE_100
2185 , a11 JTF_NUMBER_TABLE
2186 ) as
2187 ddindx binary_integer; indx binary_integer;
2188 begin
2189 if a0 is not null and a0.count > 0 then
2190 if a0.count > 0 then
2191 indx := a0.first;
2192 ddindx := 1;
2193 while true loop
2194 t(ddindx).off_discount_product_id := rosetta_g_miss_num_map(a0(indx));
2195 t(ddindx).excluder_flag := a1(indx);
2196 t(ddindx).offer_discount_line_id := rosetta_g_miss_num_map(a2(indx));
2197 t(ddindx).offer_id := rosetta_g_miss_num_map(a3(indx));
2198 t(ddindx).object_version_number := rosetta_g_miss_num_map(a4(indx));
2199 t(ddindx).product_context := a5(indx);
2200 t(ddindx).product_attribute := a6(indx);
2201 t(ddindx).product_attr_value := a7(indx);
2202 t(ddindx).apply_discount_flag := a8(indx);
2203 t(ddindx).include_volume_flag := a9(indx);
2204 t(ddindx).operation := a10(indx);
2205 t(ddindx).pbh_index := rosetta_g_miss_num_map(a11(indx));
2206 ddindx := ddindx+1;
2207 if a0.last =indx
2208 then exit;
2209 end if;
2210 indx := a0.next(indx);
2211 end loop;
2212 end if;
2213 end if;
2214 end rosetta_table_copy_in_p23;
2215 procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2216 , a1 out nocopy JTF_VARCHAR2_TABLE_100
2217 , a2 out nocopy JTF_NUMBER_TABLE
2218 , a3 out nocopy JTF_NUMBER_TABLE
2219 , a4 out nocopy JTF_NUMBER_TABLE
2220 , a5 out nocopy JTF_VARCHAR2_TABLE_100
2221 , a6 out nocopy JTF_VARCHAR2_TABLE_100
2222 , a7 out nocopy JTF_VARCHAR2_TABLE_300
2223 , a8 out nocopy JTF_VARCHAR2_TABLE_100
2224 , a9 out nocopy JTF_VARCHAR2_TABLE_100
2225 , a10 out nocopy JTF_VARCHAR2_TABLE_100
2226 , a11 out nocopy JTF_NUMBER_TABLE
2227 ) as
2228 ddindx binary_integer; indx binary_integer;
2229 begin
2230 if t is null or t.count = 0 then
2231 a0 := JTF_NUMBER_TABLE();
2232 a1 := JTF_VARCHAR2_TABLE_100();
2233 a2 := JTF_NUMBER_TABLE();
2234 a3 := JTF_NUMBER_TABLE();
2235 a4 := JTF_NUMBER_TABLE();
2236 a5 := JTF_VARCHAR2_TABLE_100();
2237 a6 := JTF_VARCHAR2_TABLE_100();
2238 a7 := JTF_VARCHAR2_TABLE_300();
2239 a8 := JTF_VARCHAR2_TABLE_100();
2240 a9 := JTF_VARCHAR2_TABLE_100();
2241 a10 := JTF_VARCHAR2_TABLE_100();
2242 a11 := JTF_NUMBER_TABLE();
2243 else
2244 a0 := JTF_NUMBER_TABLE();
2245 a1 := JTF_VARCHAR2_TABLE_100();
2246 a2 := JTF_NUMBER_TABLE();
2247 a3 := JTF_NUMBER_TABLE();
2248 a4 := JTF_NUMBER_TABLE();
2249 a5 := JTF_VARCHAR2_TABLE_100();
2250 a6 := JTF_VARCHAR2_TABLE_100();
2251 a7 := JTF_VARCHAR2_TABLE_300();
2252 a8 := JTF_VARCHAR2_TABLE_100();
2253 a9 := JTF_VARCHAR2_TABLE_100();
2254 a10 := JTF_VARCHAR2_TABLE_100();
2255 a11 := JTF_NUMBER_TABLE();
2256 if t.count > 0 then
2257 a0.extend(t.count);
2258 a1.extend(t.count);
2259 a2.extend(t.count);
2260 a3.extend(t.count);
2261 a4.extend(t.count);
2262 a5.extend(t.count);
2263 a6.extend(t.count);
2264 a7.extend(t.count);
2265 a8.extend(t.count);
2266 a9.extend(t.count);
2267 a10.extend(t.count);
2268 a11.extend(t.count);
2269 ddindx := t.first;
2270 indx := 1;
2271 while true loop
2272 a0(indx) := rosetta_g_miss_num_map(t(ddindx).off_discount_product_id);
2273 a1(indx) := t(ddindx).excluder_flag;
2274 a2(indx) := rosetta_g_miss_num_map(t(ddindx).offer_discount_line_id);
2275 a3(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
2276 a4(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
2277 a5(indx) := t(ddindx).product_context;
2278 a6(indx) := t(ddindx).product_attribute;
2279 a7(indx) := t(ddindx).product_attr_value;
2280 a8(indx) := t(ddindx).apply_discount_flag;
2281 a9(indx) := t(ddindx).include_volume_flag;
2282 a10(indx) := t(ddindx).operation;
2283 a11(indx) := rosetta_g_miss_num_map(t(ddindx).pbh_index);
2284 indx := indx+1;
2285 if t.last =ddindx
2286 then exit;
2287 end if;
2288 ddindx := t.next(ddindx);
2289 end loop;
2290 end if;
2291 end if;
2292 end rosetta_table_copy_out_p23;
2293
2294 procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2295 , a1 JTF_NUMBER_TABLE
2296 , a2 JTF_NUMBER_TABLE
2297 , a3 JTF_NUMBER_TABLE
2298 , a4 JTF_VARCHAR2_TABLE_100
2299 , a5 JTF_NUMBER_TABLE
2300 , a6 JTF_VARCHAR2_TABLE_100
2301 , a7 JTF_VARCHAR2_TABLE_100
2302 , a8 JTF_VARCHAR2_TABLE_100
2303 , a9 JTF_NUMBER_TABLE
2304 , a10 JTF_NUMBER_TABLE
2305 , a11 JTF_NUMBER_TABLE
2306 , a12 JTF_VARCHAR2_TABLE_100
2307 ) as
2308 ddindx binary_integer; indx binary_integer;
2309 begin
2310 if a0 is not null and a0.count > 0 then
2311 if a0.count > 0 then
2312 indx := a0.first;
2313 ddindx := 1;
2314 while true loop
2315 t(ddindx).offer_market_option_id := rosetta_g_miss_num_map(a0(indx));
2316 t(ddindx).offer_id := rosetta_g_miss_num_map(a1(indx));
2317 t(ddindx).qp_list_header_id := rosetta_g_miss_num_map(a2(indx));
2318 t(ddindx).group_number := rosetta_g_miss_num_map(a3(indx));
2319 t(ddindx).retroactive_flag := a4(indx);
2320 t(ddindx).beneficiary_party_id := rosetta_g_miss_num_map(a5(indx));
2321 t(ddindx).combine_schedule_flag := a6(indx);
2322 t(ddindx).volume_tracking_level_code := a7(indx);
2323 t(ddindx).accrue_to_code := a8(indx);
2324 t(ddindx).precedence := rosetta_g_miss_num_map(a9(indx));
2325 t(ddindx).object_version_number := rosetta_g_miss_num_map(a10(indx));
2326 t(ddindx).security_group_id := rosetta_g_miss_num_map(a11(indx));
2327 t(ddindx).operation := a12(indx);
2328 ddindx := ddindx+1;
2329 if a0.last =indx
2330 then exit;
2331 end if;
2332 indx := a0.next(indx);
2333 end loop;
2334 end if;
2335 end if;
2336 end rosetta_table_copy_in_p25;
2337 procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2338 , a1 out nocopy JTF_NUMBER_TABLE
2339 , a2 out nocopy JTF_NUMBER_TABLE
2340 , a3 out nocopy JTF_NUMBER_TABLE
2341 , a4 out nocopy JTF_VARCHAR2_TABLE_100
2342 , a5 out nocopy JTF_NUMBER_TABLE
2343 , a6 out nocopy JTF_VARCHAR2_TABLE_100
2344 , a7 out nocopy JTF_VARCHAR2_TABLE_100
2345 , a8 out nocopy JTF_VARCHAR2_TABLE_100
2346 , a9 out nocopy JTF_NUMBER_TABLE
2347 , a10 out nocopy JTF_NUMBER_TABLE
2348 , a11 out nocopy JTF_NUMBER_TABLE
2349 , a12 out nocopy JTF_VARCHAR2_TABLE_100
2350 ) as
2351 ddindx binary_integer; indx binary_integer;
2352 begin
2353 if t is null or t.count = 0 then
2354 a0 := JTF_NUMBER_TABLE();
2355 a1 := JTF_NUMBER_TABLE();
2356 a2 := JTF_NUMBER_TABLE();
2357 a3 := JTF_NUMBER_TABLE();
2358 a4 := JTF_VARCHAR2_TABLE_100();
2359 a5 := JTF_NUMBER_TABLE();
2360 a6 := JTF_VARCHAR2_TABLE_100();
2361 a7 := JTF_VARCHAR2_TABLE_100();
2362 a8 := JTF_VARCHAR2_TABLE_100();
2363 a9 := JTF_NUMBER_TABLE();
2364 a10 := JTF_NUMBER_TABLE();
2365 a11 := JTF_NUMBER_TABLE();
2366 a12 := JTF_VARCHAR2_TABLE_100();
2367 else
2368 a0 := JTF_NUMBER_TABLE();
2369 a1 := JTF_NUMBER_TABLE();
2370 a2 := JTF_NUMBER_TABLE();
2371 a3 := JTF_NUMBER_TABLE();
2372 a4 := JTF_VARCHAR2_TABLE_100();
2373 a5 := JTF_NUMBER_TABLE();
2374 a6 := JTF_VARCHAR2_TABLE_100();
2375 a7 := JTF_VARCHAR2_TABLE_100();
2376 a8 := JTF_VARCHAR2_TABLE_100();
2377 a9 := JTF_NUMBER_TABLE();
2378 a10 := JTF_NUMBER_TABLE();
2379 a11 := JTF_NUMBER_TABLE();
2380 a12 := JTF_VARCHAR2_TABLE_100();
2381 if t.count > 0 then
2382 a0.extend(t.count);
2383 a1.extend(t.count);
2384 a2.extend(t.count);
2385 a3.extend(t.count);
2386 a4.extend(t.count);
2387 a5.extend(t.count);
2388 a6.extend(t.count);
2389 a7.extend(t.count);
2390 a8.extend(t.count);
2391 a9.extend(t.count);
2392 a10.extend(t.count);
2393 a11.extend(t.count);
2394 a12.extend(t.count);
2395 ddindx := t.first;
2396 indx := 1;
2397 while true loop
2398 a0(indx) := rosetta_g_miss_num_map(t(ddindx).offer_market_option_id);
2399 a1(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
2400 a2(indx) := rosetta_g_miss_num_map(t(ddindx).qp_list_header_id);
2401 a3(indx) := rosetta_g_miss_num_map(t(ddindx).group_number);
2402 a4(indx) := t(ddindx).retroactive_flag;
2403 a5(indx) := rosetta_g_miss_num_map(t(ddindx).beneficiary_party_id);
2404 a6(indx) := t(ddindx).combine_schedule_flag;
2405 a7(indx) := t(ddindx).volume_tracking_level_code;
2406 a8(indx) := t(ddindx).accrue_to_code;
2407 a9(indx) := rosetta_g_miss_num_map(t(ddindx).precedence);
2408 a10(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
2409 a11(indx) := rosetta_g_miss_num_map(t(ddindx).security_group_id);
2410 a12(indx) := t(ddindx).operation;
2411 indx := indx+1;
2412 if t.last =ddindx
2413 then exit;
2414 end if;
2415 ddindx := t.next(ddindx);
2416 end loop;
2417 end if;
2418 end if;
2419 end rosetta_table_copy_out_p25;
2420
2421 procedure process_modifiers(p_init_msg_list VARCHAR2
2422 , p_api_version NUMBER
2423 , p_commit VARCHAR2
2424 , x_return_status out nocopy VARCHAR2
2425 , x_msg_count out nocopy NUMBER
2426 , x_msg_data out nocopy VARCHAR2
2427 , p_offer_type VARCHAR2
2428 , p8_a0 JTF_VARCHAR2_TABLE_100
2429 , p8_a1 JTF_VARCHAR2_TABLE_100
2430 , p8_a2 JTF_NUMBER_TABLE
2431 , p8_a3 JTF_NUMBER_TABLE
2432 , p8_a4 JTF_VARCHAR2_TABLE_100
2433 , p8_a5 JTF_NUMBER_TABLE
2434 , p8_a6 JTF_DATE_TABLE
2435 , p8_a7 JTF_DATE_TABLE
2436 , p8_a8 JTF_VARCHAR2_TABLE_100
2437 , p8_a9 JTF_VARCHAR2_TABLE_100
2438 , p8_a10 JTF_NUMBER_TABLE
2439 , p8_a11 JTF_VARCHAR2_TABLE_100
2440 , p8_a12 JTF_NUMBER_TABLE
2441 , p8_a13 JTF_NUMBER_TABLE
2442 , p8_a14 JTF_VARCHAR2_TABLE_100
2443 , p8_a15 JTF_NUMBER_TABLE
2444 , p8_a16 JTF_VARCHAR2_TABLE_100
2445 , p8_a17 JTF_NUMBER_TABLE
2446 , p8_a18 JTF_NUMBER_TABLE
2447 , p8_a19 JTF_NUMBER_TABLE
2448 , p8_a20 JTF_NUMBER_TABLE
2449 , p8_a21 JTF_VARCHAR2_TABLE_100
2450 , p8_a22 JTF_VARCHAR2_TABLE_100
2451 , p8_a23 JTF_VARCHAR2_TABLE_100
2452 , p8_a24 JTF_VARCHAR2_TABLE_300
2453 , p8_a25 JTF_VARCHAR2_TABLE_100
2454 , p8_a26 JTF_NUMBER_TABLE
2455 , p8_a27 JTF_VARCHAR2_TABLE_100
2456 , p8_a28 JTF_VARCHAR2_TABLE_100
2457 , p8_a29 JTF_VARCHAR2_TABLE_300
2458 , p8_a30 JTF_VARCHAR2_TABLE_100
2459 , p8_a31 JTF_VARCHAR2_TABLE_100
2460 , p8_a32 JTF_VARCHAR2_TABLE_100
2461 , p8_a33 JTF_VARCHAR2_TABLE_300
2462 , p8_a34 JTF_VARCHAR2_TABLE_300
2463 , p8_a35 JTF_VARCHAR2_TABLE_100
2464 , p8_a36 JTF_VARCHAR2_TABLE_300
2465 , p8_a37 JTF_VARCHAR2_TABLE_300
2466 , p8_a38 JTF_NUMBER_TABLE
2467 , p8_a39 JTF_VARCHAR2_TABLE_2000
2468 , p8_a40 JTF_VARCHAR2_TABLE_100
2469 , p8_a41 JTF_VARCHAR2_TABLE_300
2470 , p8_a42 JTF_VARCHAR2_TABLE_300
2471 , p8_a43 JTF_VARCHAR2_TABLE_300
2472 , p8_a44 JTF_VARCHAR2_TABLE_300
2473 , p8_a45 JTF_VARCHAR2_TABLE_300
2474 , p8_a46 JTF_VARCHAR2_TABLE_300
2475 , p8_a47 JTF_VARCHAR2_TABLE_300
2476 , p8_a48 JTF_VARCHAR2_TABLE_300
2477 , p8_a49 JTF_VARCHAR2_TABLE_300
2478 , p8_a50 JTF_VARCHAR2_TABLE_300
2479 , p8_a51 JTF_VARCHAR2_TABLE_300
2480 , p8_a52 JTF_VARCHAR2_TABLE_300
2481 , p8_a53 JTF_VARCHAR2_TABLE_300
2482 , p8_a54 JTF_VARCHAR2_TABLE_300
2483 , p8_a55 JTF_VARCHAR2_TABLE_300
2484 , p8_a56 JTF_NUMBER_TABLE
2485 , p8_a57 JTF_NUMBER_TABLE
2486 , p8_a58 JTF_NUMBER_TABLE
2487 , p8_a59 JTF_NUMBER_TABLE
2488 , p8_a60 JTF_NUMBER_TABLE
2489 , p8_a61 JTF_NUMBER_TABLE
2490 , p8_a62 JTF_NUMBER_TABLE
2491 , p8_a63 JTF_NUMBER_TABLE
2492 , p8_a64 JTF_NUMBER_TABLE
2493 , p8_a65 JTF_NUMBER_TABLE
2494 , p8_a66 JTF_VARCHAR2_TABLE_100
2495 , p8_a67 JTF_NUMBER_TABLE
2496 , p8_a68 JTF_NUMBER_TABLE
2497 , p8_a69 JTF_VARCHAR2_TABLE_300
2498 , p8_a70 JTF_VARCHAR2_TABLE_300
2499 , p9_a0 JTF_VARCHAR2_TABLE_100
2500 , p9_a1 JTF_VARCHAR2_TABLE_100
2501 , p9_a2 JTF_VARCHAR2_TABLE_300
2502 , p9_a3 JTF_VARCHAR2_TABLE_300
2503 , p9_a4 JTF_VARCHAR2_TABLE_100
2504 , p9_a5 JTF_NUMBER_TABLE
2505 , p9_a6 JTF_NUMBER_TABLE
2506 , p9_a7 JTF_NUMBER_TABLE
2507 , p9_a8 JTF_NUMBER_TABLE
2508 , p9_a9 JTF_DATE_TABLE
2509 , p9_a10 JTF_DATE_TABLE
2510 , p9_a11 JTF_NUMBER_TABLE
2511 , p9_a12 JTF_VARCHAR2_TABLE_100
2512 , p9_a13 JTF_VARCHAR2_TABLE_100
2513 , p9_a14 JTF_VARCHAR2_TABLE_300
2514 , p9_a15 JTF_VARCHAR2_TABLE_300
2515 , p9_a16 JTF_VARCHAR2_TABLE_300
2516 , p9_a17 JTF_VARCHAR2_TABLE_300
2517 , p9_a18 JTF_VARCHAR2_TABLE_300
2518 , p9_a19 JTF_VARCHAR2_TABLE_300
2519 , p9_a20 JTF_VARCHAR2_TABLE_300
2520 , p9_a21 JTF_VARCHAR2_TABLE_300
2521 , p9_a22 JTF_VARCHAR2_TABLE_300
2522 , p9_a23 JTF_VARCHAR2_TABLE_300
2523 , p9_a24 JTF_VARCHAR2_TABLE_300
2524 , p9_a25 JTF_VARCHAR2_TABLE_300
2525 , p9_a26 JTF_VARCHAR2_TABLE_300
2526 , p9_a27 JTF_VARCHAR2_TABLE_300
2527 , p9_a28 JTF_VARCHAR2_TABLE_300
2528 , p10_a0 JTF_NUMBER_TABLE
2529 , p10_a1 JTF_NUMBER_TABLE
2530 , p10_a2 JTF_NUMBER_TABLE
2531 , p10_a3 JTF_VARCHAR2_TABLE_100
2532 , p11_a0 JTF_NUMBER_TABLE
2533 , p11_a1 JTF_NUMBER_TABLE
2534 , p11_a2 JTF_NUMBER_TABLE
2535 , p11_a3 JTF_VARCHAR2_TABLE_100
2536 , p11_a4 JTF_VARCHAR2_TABLE_100
2537 , p11_a5 JTF_VARCHAR2_TABLE_100
2538 , p11_a6 JTF_VARCHAR2_TABLE_100
2539 , p11_a7 JTF_NUMBER_TABLE
2540 , p11_a8 JTF_NUMBER_TABLE
2541 , p11_a9 JTF_NUMBER_TABLE
2542 , p11_a10 JTF_NUMBER_TABLE
2543 , p11_a11 JTF_VARCHAR2_TABLE_100
2544 , p11_a12 JTF_VARCHAR2_TABLE_100
2545 , p11_a13 JTF_VARCHAR2_TABLE_100
2546 , p11_a14 JTF_NUMBER_TABLE
2547 , p11_a15 JTF_NUMBER_TABLE
2548 , p11_a16 JTF_NUMBER_TABLE
2549 , p11_a17 JTF_VARCHAR2_TABLE_100
2550 , p11_a18 JTF_VARCHAR2_TABLE_100
2551 , p11_a19 JTF_NUMBER_TABLE
2552 , p11_a20 JTF_NUMBER_TABLE
2553 , p11_a21 JTF_NUMBER_TABLE
2554 , p11_a22 JTF_VARCHAR2_TABLE_100
2555 , p12_a0 JTF_NUMBER_TABLE
2556 , p12_a1 JTF_NUMBER_TABLE
2557 , p12_a2 JTF_NUMBER_TABLE
2558 , p12_a3 JTF_NUMBER_TABLE
2559 , p12_a4 JTF_VARCHAR2_TABLE_100
2560 , p12_a5 JTF_VARCHAR2_TABLE_100
2561 , p12_a6 JTF_VARCHAR2_TABLE_100
2562 , p12_a7 JTF_NUMBER_TABLE
2563 , p12_a8 JTF_VARCHAR2_TABLE_100
2564 , p12_a9 JTF_VARCHAR2_TABLE_100
2565 , p12_a10 JTF_VARCHAR2_TABLE_100
2566 , p12_a11 JTF_VARCHAR2_TABLE_100
2567 , p12_a12 JTF_NUMBER_TABLE
2568 , p12_a13 JTF_VARCHAR2_TABLE_100
2569 , p12_a14 JTF_NUMBER_TABLE
2570 , p12_a15 JTF_NUMBER_TABLE
2571 , p12_a16 JTF_NUMBER_TABLE
2572 , p12_a17 JTF_NUMBER_TABLE
2573 , p12_a18 JTF_VARCHAR2_TABLE_100
2574 , p12_a19 JTF_DATE_TABLE
2575 , p12_a20 JTF_DATE_TABLE
2576 , p12_a21 JTF_VARCHAR2_TABLE_100
2577 , p12_a22 JTF_DATE_TABLE
2578 , p12_a23 JTF_NUMBER_TABLE
2579 , p12_a24 JTF_DATE_TABLE
2580 , p12_a25 JTF_NUMBER_TABLE
2581 , p12_a26 JTF_NUMBER_TABLE
2582 , p12_a27 JTF_NUMBER_TABLE
2583 , p12_a28 JTF_NUMBER_TABLE
2584 , p12_a29 JTF_NUMBER_TABLE
2585 , p12_a30 JTF_NUMBER_TABLE
2586 , p12_a31 JTF_VARCHAR2_TABLE_100
2587 , p12_a32 JTF_NUMBER_TABLE
2588 , p12_a33 JTF_VARCHAR2_TABLE_100
2589 , p12_a34 JTF_VARCHAR2_TABLE_100
2590 , p13_a0 JTF_NUMBER_TABLE
2591 , p13_a1 JTF_NUMBER_TABLE
2592 , p13_a2 JTF_VARCHAR2_TABLE_100
2593 , p13_a3 JTF_NUMBER_TABLE
2594 , p13_a4 JTF_NUMBER_TABLE
2595 , p13_a5 JTF_DATE_TABLE
2596 , p13_a6 JTF_DATE_TABLE
2597 , p13_a7 JTF_VARCHAR2_TABLE_100
2598 , p14_a0 JTF_NUMBER_TABLE
2599 , p14_a1 JTF_NUMBER_TABLE
2600 , p14_a2 JTF_NUMBER_TABLE
2601 , p14_a3 JTF_NUMBER_TABLE
2602 , p14_a4 JTF_NUMBER_TABLE
2603 , p14_a5 JTF_VARCHAR2_TABLE_100
2604 , p14_a6 JTF_VARCHAR2_TABLE_100
2605 , p14_a7 JTF_VARCHAR2_TABLE_100
2606 , p14_a8 JTF_NUMBER_TABLE
2607 , p14_a9 JTF_VARCHAR2_TABLE_100
2608 , p14_a10 JTF_DATE_TABLE
2609 , p14_a11 JTF_DATE_TABLE
2610 , p14_a12 JTF_VARCHAR2_TABLE_100
2611 , p14_a13 JTF_NUMBER_TABLE
2612 , p14_a14 JTF_VARCHAR2_TABLE_100
2613 , p15_a0 JTF_NUMBER_TABLE
2614 , p15_a1 JTF_NUMBER_TABLE
2615 , p15_a2 JTF_VARCHAR2_TABLE_100
2616 , p15_a3 JTF_NUMBER_TABLE
2617 , p15_a4 JTF_VARCHAR2_TABLE_100
2618 , p15_a5 JTF_VARCHAR2_TABLE_100
2619 , p15_a6 JTF_DATE_TABLE
2620 , p15_a7 JTF_DATE_TABLE
2621 , p15_a8 JTF_NUMBER_TABLE
2622 , p15_a9 JTF_NUMBER_TABLE
2623 , p15_a10 JTF_DATE_TABLE
2624 , p15_a11 JTF_NUMBER_TABLE
2625 , p15_a12 JTF_DATE_TABLE
2626 , p15_a13 JTF_NUMBER_TABLE
2627 , p15_a14 JTF_NUMBER_TABLE
2628 , p15_a15 JTF_NUMBER_TABLE
2629 , p15_a16 JTF_VARCHAR2_TABLE_100
2630 , p16_a0 JTF_NUMBER_TABLE
2631 , p16_a1 JTF_DATE_TABLE
2632 , p16_a2 JTF_NUMBER_TABLE
2633 , p16_a3 JTF_DATE_TABLE
2634 , p16_a4 JTF_NUMBER_TABLE
2635 , p16_a5 JTF_NUMBER_TABLE
2636 , p16_a6 JTF_NUMBER_TABLE
2637 , p16_a7 JTF_VARCHAR2_TABLE_100
2638 , p16_a8 JTF_VARCHAR2_TABLE_100
2639 , p16_a9 JTF_VARCHAR2_TABLE_300
2640 , p16_a10 JTF_DATE_TABLE
2641 , p16_a11 JTF_DATE_TABLE
2642 , p16_a12 JTF_NUMBER_TABLE
2643 , p16_a13 JTF_NUMBER_TABLE
2644 , p16_a14 JTF_VARCHAR2_TABLE_100
2645 , p16_a15 JTF_VARCHAR2_TABLE_300
2646 , p16_a16 JTF_VARCHAR2_TABLE_300
2647 , p16_a17 JTF_VARCHAR2_TABLE_300
2648 , p16_a18 JTF_VARCHAR2_TABLE_300
2649 , p16_a19 JTF_VARCHAR2_TABLE_300
2650 , p16_a20 JTF_VARCHAR2_TABLE_300
2651 , p16_a21 JTF_VARCHAR2_TABLE_300
2652 , p16_a22 JTF_VARCHAR2_TABLE_300
2653 , p16_a23 JTF_VARCHAR2_TABLE_300
2654 , p16_a24 JTF_VARCHAR2_TABLE_300
2655 , p16_a25 JTF_VARCHAR2_TABLE_300
2656 , p16_a26 JTF_VARCHAR2_TABLE_300
2657 , p16_a27 JTF_VARCHAR2_TABLE_300
2658 , p16_a28 JTF_VARCHAR2_TABLE_300
2659 , p16_a29 JTF_VARCHAR2_TABLE_300
2660 , p16_a30 JTF_VARCHAR2_TABLE_100
2661 , p16_a31 JTF_NUMBER_TABLE
2662 , p16_a32 JTF_VARCHAR2_TABLE_100
2663 , x_qp_list_header_id out nocopy NUMBER
2664 , x_error_location out nocopy NUMBER
2665 , p7_a0 NUMBER := 0-1962.0724
2666 , p7_a1 NUMBER := 0-1962.0724
2667 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
2668 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
2669 , p7_a4 NUMBER := 0-1962.0724
2670 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
2671 , p7_a6 NUMBER := 0-1962.0724
2672 , p7_a7 NUMBER := 0-1962.0724
2673 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
2674 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
2675 , p7_a10 NUMBER := 0-1962.0724
2676 , p7_a11 NUMBER := 0-1962.0724
2677 , p7_a12 DATE := fnd_api.g_miss_date
2678 , p7_a13 DATE := fnd_api.g_miss_date
2679 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
2680 , p7_a15 DATE := fnd_api.g_miss_date
2681 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
2682 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
2683 , p7_a18 NUMBER := 0-1962.0724
2684 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
2685 , p7_a20 NUMBER := 0-1962.0724
2686 , p7_a21 NUMBER := 0-1962.0724
2687 , p7_a22 NUMBER := 0-1962.0724
2688 , p7_a23 NUMBER := 0-1962.0724
2689 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
2690 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
2691 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
2692 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
2693 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
2694 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
2695 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
2696 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
2697 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
2698 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
2699 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
2700 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
2701 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
2702 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
2703 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
2704 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
2705 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
2706 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
2707 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
2708 , p7_a43 DATE := fnd_api.g_miss_date
2709 , p7_a44 DATE := fnd_api.g_miss_date
2710 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
2711 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
2712 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
2713 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
2714 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
2715 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
2716 , p7_a51 DATE := fnd_api.g_miss_date
2717 , p7_a52 DATE := fnd_api.g_miss_date
2718 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
2719 , p7_a54 DATE := fnd_api.g_miss_date
2720 , p7_a55 DATE := fnd_api.g_miss_date
2721 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
2722 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
2723 , p7_a58 NUMBER := 0-1962.0724
2724 , p7_a59 NUMBER := 0-1962.0724
2725 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
2726 , p7_a61 NUMBER := 0-1962.0724
2727 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
2728 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
2729 , p7_a64 NUMBER := 0-1962.0724
2730 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
2731 , p7_a66 NUMBER := 0-1962.0724
2732 , p7_a67 NUMBER := 0-1962.0724
2733 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
2734 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
2735 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
2736 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
2737 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
2738 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
2739 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
2740 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
2741 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
2742 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
2743 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
2744 , p7_a79 NUMBER := 0-1962.0724
2745 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
2746 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
2747 , p7_a82 NUMBER := 0-1962.0724
2748 )
2749
2750 as
2751 ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2752 ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2753 ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2754 ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2755 ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2756 ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2757 ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2758 ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2759 ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2760 ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
2761 ddindx binary_integer; indx binary_integer;
2762 begin
2763
2764 -- copy data to the local IN or IN-OUT args, if any
2765
2766
2767
2768
2769
2770
2771
2772 ddp_modifier_list_rec.offer_id := rosetta_g_miss_num_map(p7_a0);
2773 ddp_modifier_list_rec.qp_list_header_id := rosetta_g_miss_num_map(p7_a1);
2774 ddp_modifier_list_rec.offer_type := p7_a2;
2775 ddp_modifier_list_rec.offer_code := p7_a3;
2776 ddp_modifier_list_rec.activity_media_id := rosetta_g_miss_num_map(p7_a4);
2777 ddp_modifier_list_rec.reusable := p7_a5;
2778 ddp_modifier_list_rec.user_status_id := rosetta_g_miss_num_map(p7_a6);
2779 ddp_modifier_list_rec.owner_id := rosetta_g_miss_num_map(p7_a7);
2780 ddp_modifier_list_rec.wf_item_key := p7_a8;
2781 ddp_modifier_list_rec.customer_reference := p7_a9;
2782 ddp_modifier_list_rec.buying_group_contact_id := rosetta_g_miss_num_map(p7_a10);
2783 ddp_modifier_list_rec.object_version_number := rosetta_g_miss_num_map(p7_a11);
2784 ddp_modifier_list_rec.perf_date_from := rosetta_g_miss_date_in_map(p7_a12);
2785 ddp_modifier_list_rec.perf_date_to := rosetta_g_miss_date_in_map(p7_a13);
2786 ddp_modifier_list_rec.status_code := p7_a14;
2787 ddp_modifier_list_rec.status_date := rosetta_g_miss_date_in_map(p7_a15);
2788 ddp_modifier_list_rec.modifier_level_code := p7_a16;
2789 ddp_modifier_list_rec.order_value_discount_type := p7_a17;
2790 ddp_modifier_list_rec.lumpsum_amount := rosetta_g_miss_num_map(p7_a18);
2791 ddp_modifier_list_rec.lumpsum_payment_type := p7_a19;
2792 ddp_modifier_list_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a20);
2793 ddp_modifier_list_rec.offer_amount := rosetta_g_miss_num_map(p7_a21);
2794 ddp_modifier_list_rec.budget_amount_tc := rosetta_g_miss_num_map(p7_a22);
2795 ddp_modifier_list_rec.budget_amount_fc := rosetta_g_miss_num_map(p7_a23);
2796 ddp_modifier_list_rec.transaction_currency_code := p7_a24;
2797 ddp_modifier_list_rec.functional_currency_code := p7_a25;
2798 ddp_modifier_list_rec.context := p7_a26;
2799 ddp_modifier_list_rec.attribute1 := p7_a27;
2800 ddp_modifier_list_rec.attribute2 := p7_a28;
2801 ddp_modifier_list_rec.attribute3 := p7_a29;
2802 ddp_modifier_list_rec.attribute4 := p7_a30;
2803 ddp_modifier_list_rec.attribute5 := p7_a31;
2804 ddp_modifier_list_rec.attribute6 := p7_a32;
2805 ddp_modifier_list_rec.attribute7 := p7_a33;
2806 ddp_modifier_list_rec.attribute8 := p7_a34;
2807 ddp_modifier_list_rec.attribute9 := p7_a35;
2808 ddp_modifier_list_rec.attribute10 := p7_a36;
2809 ddp_modifier_list_rec.attribute11 := p7_a37;
2810 ddp_modifier_list_rec.attribute12 := p7_a38;
2811 ddp_modifier_list_rec.attribute13 := p7_a39;
2812 ddp_modifier_list_rec.attribute14 := p7_a40;
2813 ddp_modifier_list_rec.attribute15 := p7_a41;
2814 ddp_modifier_list_rec.currency_code := p7_a42;
2815 ddp_modifier_list_rec.start_date_active := rosetta_g_miss_date_in_map(p7_a43);
2816 ddp_modifier_list_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a44);
2817 ddp_modifier_list_rec.list_type_code := p7_a45;
2818 ddp_modifier_list_rec.discount_lines_flag := p7_a46;
2819 ddp_modifier_list_rec.name := p7_a47;
2820 ddp_modifier_list_rec.description := p7_a48;
2821 ddp_modifier_list_rec.comments := p7_a49;
2822 ddp_modifier_list_rec.ask_for_flag := p7_a50;
2823 ddp_modifier_list_rec.start_date_active_first := rosetta_g_miss_date_in_map(p7_a51);
2824 ddp_modifier_list_rec.end_date_active_first := rosetta_g_miss_date_in_map(p7_a52);
2825 ddp_modifier_list_rec.active_date_first_type := p7_a53;
2826 ddp_modifier_list_rec.start_date_active_second := rosetta_g_miss_date_in_map(p7_a54);
2827 ddp_modifier_list_rec.end_date_active_second := rosetta_g_miss_date_in_map(p7_a55);
2828 ddp_modifier_list_rec.active_date_second_type := p7_a56;
2829 ddp_modifier_list_rec.active_flag := p7_a57;
2830 ddp_modifier_list_rec.max_no_of_uses := rosetta_g_miss_num_map(p7_a58);
2831 ddp_modifier_list_rec.budget_source_id := rosetta_g_miss_num_map(p7_a59);
2832 ddp_modifier_list_rec.budget_source_type := p7_a60;
2833 ddp_modifier_list_rec.offer_used_by_id := rosetta_g_miss_num_map(p7_a61);
2834 ddp_modifier_list_rec.offer_used_by := p7_a62;
2835 ddp_modifier_list_rec.ql_qualifier_type := p7_a63;
2836 ddp_modifier_list_rec.ql_qualifier_id := rosetta_g_miss_num_map(p7_a64);
2837 ddp_modifier_list_rec.distribution_type := p7_a65;
2838 ddp_modifier_list_rec.amount_limit_id := rosetta_g_miss_num_map(p7_a66);
2839 ddp_modifier_list_rec.uses_limit_id := rosetta_g_miss_num_map(p7_a67);
2840 ddp_modifier_list_rec.offer_operation := p7_a68;
2841 ddp_modifier_list_rec.modifier_operation := p7_a69;
2842 ddp_modifier_list_rec.budget_offer_yn := p7_a70;
2843 ddp_modifier_list_rec.break_type := p7_a71;
2844 ddp_modifier_list_rec.retroactive := p7_a72;
2845 ddp_modifier_list_rec.volume_offer_type := p7_a73;
2846 ddp_modifier_list_rec.confidential_flag := p7_a74;
2847 ddp_modifier_list_rec.committed_amount_eq_max := p7_a75;
2848 ddp_modifier_list_rec.source_from_parent := p7_a76;
2849 ddp_modifier_list_rec.buyer_name := p7_a77;
2850 ddp_modifier_list_rec.tier_level := p7_a78;
2851 ddp_modifier_list_rec.na_rule_header_id := rosetta_g_miss_num_map(p7_a79);
2852 ddp_modifier_list_rec.sales_method_flag := p7_a80;
2853 ddp_modifier_list_rec.global_flag := p7_a81;
2854 ddp_modifier_list_rec.orig_org_id := rosetta_g_miss_num_map(p7_a82);
2855
2856 ozf_offer_pub_w.rosetta_table_copy_in_p17(ddp_modifier_line_tbl, p8_a0
2857 , p8_a1
2858 , p8_a2
2859 , p8_a3
2860 , p8_a4
2861 , p8_a5
2862 , p8_a6
2863 , p8_a7
2864 , p8_a8
2865 , p8_a9
2866 , p8_a10
2867 , p8_a11
2868 , p8_a12
2869 , p8_a13
2870 , p8_a14
2871 , p8_a15
2872 , p8_a16
2873 , p8_a17
2874 , p8_a18
2875 , p8_a19
2876 , p8_a20
2877 , p8_a21
2878 , p8_a22
2879 , p8_a23
2880 , p8_a24
2881 , p8_a25
2882 , p8_a26
2883 , p8_a27
2884 , p8_a28
2885 , p8_a29
2886 , p8_a30
2887 , p8_a31
2888 , p8_a32
2889 , p8_a33
2890 , p8_a34
2891 , p8_a35
2892 , p8_a36
2893 , p8_a37
2894 , p8_a38
2895 , p8_a39
2896 , p8_a40
2897 , p8_a41
2898 , p8_a42
2899 , p8_a43
2900 , p8_a44
2901 , p8_a45
2902 , p8_a46
2903 , p8_a47
2904 , p8_a48
2905 , p8_a49
2906 , p8_a50
2907 , p8_a51
2908 , p8_a52
2909 , p8_a53
2910 , p8_a54
2911 , p8_a55
2912 , p8_a56
2913 , p8_a57
2914 , p8_a58
2915 , p8_a59
2916 , p8_a60
2917 , p8_a61
2918 , p8_a62
2919 , p8_a63
2920 , p8_a64
2921 , p8_a65
2922 , p8_a66
2923 , p8_a67
2924 , p8_a68
2925 , p8_a69
2926 , p8_a70
2927 );
2928
2929 ozf_offer_pub_w.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p9_a0
2930 , p9_a1
2931 , p9_a2
2932 , p9_a3
2933 , p9_a4
2934 , p9_a5
2935 , p9_a6
2936 , p9_a7
2937 , p9_a8
2938 , p9_a9
2939 , p9_a10
2940 , p9_a11
2941 , p9_a12
2942 , p9_a13
2943 , p9_a14
2944 , p9_a15
2945 , p9_a16
2946 , p9_a17
2947 , p9_a18
2948 , p9_a19
2949 , p9_a20
2950 , p9_a21
2951 , p9_a22
2952 , p9_a23
2953 , p9_a24
2954 , p9_a25
2955 , p9_a26
2956 , p9_a27
2957 , p9_a28
2958 );
2959
2960 ozf_offer_pub_w.rosetta_table_copy_in_p14(ddp_budget_tbl, p10_a0
2961 , p10_a1
2962 , p10_a2
2963 , p10_a3
2964 );
2965
2966 ozf_offer_pub_w.rosetta_table_copy_in_p2(ddp_act_product_tbl, p11_a0
2967 , p11_a1
2968 , p11_a2
2969 , p11_a3
2970 , p11_a4
2971 , p11_a5
2972 , p11_a6
2973 , p11_a7
2974 , p11_a8
2975 , p11_a9
2976 , p11_a10
2977 , p11_a11
2978 , p11_a12
2979 , p11_a13
2980 , p11_a14
2981 , p11_a15
2982 , p11_a16
2983 , p11_a17
2984 , p11_a18
2985 , p11_a19
2986 , p11_a20
2987 , p11_a21
2988 , p11_a22
2989 );
2990
2991 ozf_offer_pub_w.rosetta_table_copy_in_p4(ddp_discount_tbl, p12_a0
2992 , p12_a1
2993 , p12_a2
2994 , p12_a3
2995 , p12_a4
2996 , p12_a5
2997 , p12_a6
2998 , p12_a7
2999 , p12_a8
3000 , p12_a9
3001 , p12_a10
3002 , p12_a11
3003 , p12_a12
3004 , p12_a13
3005 , p12_a14
3006 , p12_a15
3007 , p12_a16
3008 , p12_a17
3009 , p12_a18
3010 , p12_a19
3011 , p12_a20
3012 , p12_a21
3013 , p12_a22
3014 , p12_a23
3015 , p12_a24
3016 , p12_a25
3017 , p12_a26
3018 , p12_a27
3019 , p12_a28
3020 , p12_a29
3021 , p12_a30
3022 , p12_a31
3023 , p12_a32
3024 , p12_a33
3025 , p12_a34
3026 );
3027
3028 ozf_offer_pub_w.rosetta_table_copy_in_p8(ddp_excl_tbl, p13_a0
3029 , p13_a1
3030 , p13_a2
3031 , p13_a3
3032 , p13_a4
3033 , p13_a5
3034 , p13_a6
3035 , p13_a7
3036 );
3037
3038 ozf_offer_pub_w.rosetta_table_copy_in_p10(ddp_offer_tier_tbl, p14_a0
3039 , p14_a1
3040 , p14_a2
3041 , p14_a3
3042 , p14_a4
3043 , p14_a5
3044 , p14_a6
3045 , p14_a7
3046 , p14_a8
3047 , p14_a9
3048 , p14_a10
3049 , p14_a11
3050 , p14_a12
3051 , p14_a13
3052 , p14_a14
3053 );
3054
3055 ozf_offer_pub_w.rosetta_table_copy_in_p6(ddp_prod_tbl, p15_a0
3056 , p15_a1
3057 , p15_a2
3058 , p15_a3
3059 , p15_a4
3060 , p15_a5
3061 , p15_a6
3062 , p15_a7
3063 , p15_a8
3064 , p15_a9
3065 , p15_a10
3066 , p15_a11
3067 , p15_a12
3068 , p15_a13
3069 , p15_a14
3070 , p15_a15
3071 , p15_a16
3072 );
3073
3074 ozf_offer_pub_w.rosetta_table_copy_in_p12(ddp_na_qualifier_tbl, p16_a0
3075 , p16_a1
3076 , p16_a2
3077 , p16_a3
3078 , p16_a4
3079 , p16_a5
3080 , p16_a6
3081 , p16_a7
3082 , p16_a8
3083 , p16_a9
3084 , p16_a10
3085 , p16_a11
3086 , p16_a12
3087 , p16_a13
3088 , p16_a14
3089 , p16_a15
3090 , p16_a16
3091 , p16_a17
3092 , p16_a18
3093 , p16_a19
3094 , p16_a20
3095 , p16_a21
3096 , p16_a22
3097 , p16_a23
3098 , p16_a24
3099 , p16_a25
3100 , p16_a26
3101 , p16_a27
3102 , p16_a28
3103 , p16_a29
3104 , p16_a30
3105 , p16_a31
3106 , p16_a32
3107 );
3108
3109
3110
3111 -- here's the delegated call to the old PL/SQL routine
3112 ozf_offer_pub.process_modifiers(p_init_msg_list,
3113 p_api_version,
3114 p_commit,
3115 x_return_status,
3116 x_msg_count,
3117 x_msg_data,
3118 p_offer_type,
3119 ddp_modifier_list_rec,
3120 ddp_modifier_line_tbl,
3121 ddp_qualifier_tbl,
3122 ddp_budget_tbl,
3123 ddp_act_product_tbl,
3124 ddp_discount_tbl,
3125 ddp_excl_tbl,
3126 ddp_offer_tier_tbl,
3127 ddp_prod_tbl,
3128 ddp_na_qualifier_tbl,
3129 x_qp_list_header_id,
3130 x_error_location);
3131
3132 -- copy data back from the local variables to OUT or IN-OUT args, if any
3133
3134
3135
3136
3137
3138
3139
3140
3141
3142
3143
3144
3145
3146
3147
3148
3149
3150
3151 end;
3152
3153 procedure process_vo(p_init_msg_list VARCHAR2
3154 , p_api_version NUMBER
3155 , p_commit VARCHAR2
3156 , x_return_status out nocopy VARCHAR2
3157 , x_msg_count out nocopy NUMBER
3158 , x_msg_data out nocopy VARCHAR2
3159 , p7_a0 JTF_NUMBER_TABLE
3160 , p7_a1 JTF_NUMBER_TABLE
3161 , p7_a2 JTF_NUMBER_TABLE
3162 , p7_a3 JTF_NUMBER_TABLE
3163 , p7_a4 JTF_VARCHAR2_TABLE_100
3164 , p7_a5 JTF_VARCHAR2_TABLE_100
3165 , p7_a6 JTF_VARCHAR2_TABLE_100
3166 , p7_a7 JTF_NUMBER_TABLE
3167 , p7_a8 JTF_VARCHAR2_TABLE_100
3168 , p7_a9 JTF_VARCHAR2_TABLE_100
3169 , p7_a10 JTF_VARCHAR2_TABLE_100
3170 , p7_a11 JTF_VARCHAR2_TABLE_100
3171 , p7_a12 JTF_NUMBER_TABLE
3172 , p7_a13 JTF_NUMBER_TABLE
3173 , p7_a14 JTF_VARCHAR2_TABLE_100
3174 , p7_a15 JTF_NUMBER_TABLE
3175 , p7_a16 JTF_NUMBER_TABLE
3176 , p7_a17 JTF_VARCHAR2_TABLE_300
3177 , p7_a18 JTF_VARCHAR2_TABLE_2000
3178 , p7_a19 JTF_VARCHAR2_TABLE_100
3179 , p7_a20 JTF_NUMBER_TABLE
3180 , p8_a0 JTF_NUMBER_TABLE
3181 , p8_a1 JTF_NUMBER_TABLE
3182 , p8_a2 JTF_NUMBER_TABLE
3183 , p8_a3 JTF_NUMBER_TABLE
3184 , p8_a4 JTF_VARCHAR2_TABLE_100
3185 , p8_a5 JTF_VARCHAR2_TABLE_100
3186 , p8_a6 JTF_VARCHAR2_TABLE_100
3187 , p8_a7 JTF_NUMBER_TABLE
3188 , p8_a8 JTF_VARCHAR2_TABLE_100
3189 , p8_a9 JTF_VARCHAR2_TABLE_100
3190 , p8_a10 JTF_VARCHAR2_TABLE_100
3191 , p8_a11 JTF_VARCHAR2_TABLE_100
3192 , p8_a12 JTF_NUMBER_TABLE
3193 , p8_a13 JTF_NUMBER_TABLE
3194 , p8_a14 JTF_VARCHAR2_TABLE_100
3195 , p8_a15 JTF_NUMBER_TABLE
3196 , p8_a16 JTF_NUMBER_TABLE
3197 , p8_a17 JTF_VARCHAR2_TABLE_300
3198 , p8_a18 JTF_VARCHAR2_TABLE_2000
3199 , p8_a19 JTF_VARCHAR2_TABLE_100
3200 , p8_a20 JTF_NUMBER_TABLE
3201 , p9_a0 JTF_NUMBER_TABLE
3202 , p9_a1 JTF_VARCHAR2_TABLE_100
3203 , p9_a2 JTF_NUMBER_TABLE
3204 , p9_a3 JTF_NUMBER_TABLE
3205 , p9_a4 JTF_NUMBER_TABLE
3206 , p9_a5 JTF_VARCHAR2_TABLE_100
3207 , p9_a6 JTF_VARCHAR2_TABLE_100
3208 , p9_a7 JTF_VARCHAR2_TABLE_300
3209 , p9_a8 JTF_VARCHAR2_TABLE_100
3210 , p9_a9 JTF_VARCHAR2_TABLE_100
3211 , p9_a10 JTF_VARCHAR2_TABLE_100
3212 , p9_a11 JTF_NUMBER_TABLE
3213 , p10_a0 JTF_VARCHAR2_TABLE_100
3214 , p10_a1 JTF_VARCHAR2_TABLE_100
3215 , p10_a2 JTF_VARCHAR2_TABLE_300
3216 , p10_a3 JTF_VARCHAR2_TABLE_300
3217 , p10_a4 JTF_VARCHAR2_TABLE_100
3218 , p10_a5 JTF_NUMBER_TABLE
3219 , p10_a6 JTF_NUMBER_TABLE
3220 , p10_a7 JTF_NUMBER_TABLE
3221 , p10_a8 JTF_NUMBER_TABLE
3222 , p10_a9 JTF_DATE_TABLE
3223 , p10_a10 JTF_DATE_TABLE
3224 , p10_a11 JTF_NUMBER_TABLE
3225 , p10_a12 JTF_VARCHAR2_TABLE_100
3226 , p10_a13 JTF_VARCHAR2_TABLE_100
3227 , p10_a14 JTF_VARCHAR2_TABLE_300
3228 , p10_a15 JTF_VARCHAR2_TABLE_300
3229 , p10_a16 JTF_VARCHAR2_TABLE_300
3230 , p10_a17 JTF_VARCHAR2_TABLE_300
3231 , p10_a18 JTF_VARCHAR2_TABLE_300
3232 , p10_a19 JTF_VARCHAR2_TABLE_300
3233 , p10_a20 JTF_VARCHAR2_TABLE_300
3234 , p10_a21 JTF_VARCHAR2_TABLE_300
3235 , p10_a22 JTF_VARCHAR2_TABLE_300
3236 , p10_a23 JTF_VARCHAR2_TABLE_300
3237 , p10_a24 JTF_VARCHAR2_TABLE_300
3238 , p10_a25 JTF_VARCHAR2_TABLE_300
3239 , p10_a26 JTF_VARCHAR2_TABLE_300
3240 , p10_a27 JTF_VARCHAR2_TABLE_300
3241 , p10_a28 JTF_VARCHAR2_TABLE_300
3242 , p11_a0 JTF_NUMBER_TABLE
3243 , p11_a1 JTF_NUMBER_TABLE
3244 , p11_a2 JTF_NUMBER_TABLE
3245 , p11_a3 JTF_NUMBER_TABLE
3246 , p11_a4 JTF_VARCHAR2_TABLE_100
3247 , p11_a5 JTF_NUMBER_TABLE
3248 , p11_a6 JTF_VARCHAR2_TABLE_100
3249 , p11_a7 JTF_VARCHAR2_TABLE_100
3250 , p11_a8 JTF_VARCHAR2_TABLE_100
3251 , p11_a9 JTF_NUMBER_TABLE
3252 , p11_a10 JTF_NUMBER_TABLE
3253 , p11_a11 JTF_NUMBER_TABLE
3254 , p11_a12 JTF_VARCHAR2_TABLE_100
3255 , p12_a0 JTF_NUMBER_TABLE
3256 , p12_a1 JTF_NUMBER_TABLE
3257 , p12_a2 JTF_NUMBER_TABLE
3258 , p12_a3 JTF_VARCHAR2_TABLE_100
3259 , x_qp_list_header_id out nocopy NUMBER
3260 , x_error_location out nocopy NUMBER
3261 , p6_a0 NUMBER := 0-1962.0724
3262 , p6_a1 NUMBER := 0-1962.0724
3263 , p6_a2 VARCHAR2 := fnd_api.g_miss_char
3264 , p6_a3 VARCHAR2 := fnd_api.g_miss_char
3265 , p6_a4 NUMBER := 0-1962.0724
3266 , p6_a5 VARCHAR2 := fnd_api.g_miss_char
3267 , p6_a6 NUMBER := 0-1962.0724
3268 , p6_a7 NUMBER := 0-1962.0724
3269 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
3270 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
3271 , p6_a10 NUMBER := 0-1962.0724
3272 , p6_a11 NUMBER := 0-1962.0724
3273 , p6_a12 DATE := fnd_api.g_miss_date
3274 , p6_a13 DATE := fnd_api.g_miss_date
3275 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
3276 , p6_a15 DATE := fnd_api.g_miss_date
3277 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
3278 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
3279 , p6_a18 NUMBER := 0-1962.0724
3280 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
3281 , p6_a20 NUMBER := 0-1962.0724
3282 , p6_a21 NUMBER := 0-1962.0724
3283 , p6_a22 NUMBER := 0-1962.0724
3284 , p6_a23 NUMBER := 0-1962.0724
3285 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
3286 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
3287 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
3288 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
3289 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
3290 , p6_a29 VARCHAR2 := fnd_api.g_miss_char
3291 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
3292 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
3293 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
3294 , p6_a33 VARCHAR2 := fnd_api.g_miss_char
3295 , p6_a34 VARCHAR2 := fnd_api.g_miss_char
3296 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
3297 , p6_a36 VARCHAR2 := fnd_api.g_miss_char
3298 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
3299 , p6_a38 VARCHAR2 := fnd_api.g_miss_char
3300 , p6_a39 VARCHAR2 := fnd_api.g_miss_char
3301 , p6_a40 VARCHAR2 := fnd_api.g_miss_char
3302 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
3303 , p6_a42 VARCHAR2 := fnd_api.g_miss_char
3304 , p6_a43 DATE := fnd_api.g_miss_date
3305 , p6_a44 DATE := fnd_api.g_miss_date
3306 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
3307 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
3308 , p6_a47 VARCHAR2 := fnd_api.g_miss_char
3309 , p6_a48 VARCHAR2 := fnd_api.g_miss_char
3310 , p6_a49 VARCHAR2 := fnd_api.g_miss_char
3311 , p6_a50 VARCHAR2 := fnd_api.g_miss_char
3312 , p6_a51 DATE := fnd_api.g_miss_date
3313 , p6_a52 DATE := fnd_api.g_miss_date
3314 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
3315 , p6_a54 DATE := fnd_api.g_miss_date
3316 , p6_a55 DATE := fnd_api.g_miss_date
3317 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
3318 , p6_a57 VARCHAR2 := fnd_api.g_miss_char
3319 , p6_a58 NUMBER := 0-1962.0724
3320 , p6_a59 NUMBER := 0-1962.0724
3321 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
3322 , p6_a61 NUMBER := 0-1962.0724
3323 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
3324 , p6_a63 VARCHAR2 := fnd_api.g_miss_char
3325 , p6_a64 NUMBER := 0-1962.0724
3326 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
3327 , p6_a66 NUMBER := 0-1962.0724
3328 , p6_a67 NUMBER := 0-1962.0724
3329 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
3330 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
3331 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
3332 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
3333 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
3334 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
3335 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
3336 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
3337 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
3338 , p6_a77 VARCHAR2 := fnd_api.g_miss_char
3339 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
3340 , p6_a79 NUMBER := 0-1962.0724
3341 , p6_a80 VARCHAR2 := fnd_api.g_miss_char
3342 , p6_a81 VARCHAR2 := fnd_api.g_miss_char
3343 , p6_a82 NUMBER := 0-1962.0724
3344 )
3345
3346 as
3347 ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3348 ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3349 ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3350 ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3351 ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3352 ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3353 ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
3354 ddindx binary_integer; indx binary_integer;
3355 begin
3356
3357 -- copy data to the local IN or IN-OUT args, if any
3358
3359
3360
3361
3362
3363
3364 ddp_modifier_list_rec.offer_id := rosetta_g_miss_num_map(p6_a0);
3365 ddp_modifier_list_rec.qp_list_header_id := rosetta_g_miss_num_map(p6_a1);
3366 ddp_modifier_list_rec.offer_type := p6_a2;
3367 ddp_modifier_list_rec.offer_code := p6_a3;
3368 ddp_modifier_list_rec.activity_media_id := rosetta_g_miss_num_map(p6_a4);
3369 ddp_modifier_list_rec.reusable := p6_a5;
3370 ddp_modifier_list_rec.user_status_id := rosetta_g_miss_num_map(p6_a6);
3371 ddp_modifier_list_rec.owner_id := rosetta_g_miss_num_map(p6_a7);
3372 ddp_modifier_list_rec.wf_item_key := p6_a8;
3373 ddp_modifier_list_rec.customer_reference := p6_a9;
3374 ddp_modifier_list_rec.buying_group_contact_id := rosetta_g_miss_num_map(p6_a10);
3375 ddp_modifier_list_rec.object_version_number := rosetta_g_miss_num_map(p6_a11);
3376 ddp_modifier_list_rec.perf_date_from := rosetta_g_miss_date_in_map(p6_a12);
3377 ddp_modifier_list_rec.perf_date_to := rosetta_g_miss_date_in_map(p6_a13);
3378 ddp_modifier_list_rec.status_code := p6_a14;
3379 ddp_modifier_list_rec.status_date := rosetta_g_miss_date_in_map(p6_a15);
3380 ddp_modifier_list_rec.modifier_level_code := p6_a16;
3381 ddp_modifier_list_rec.order_value_discount_type := p6_a17;
3382 ddp_modifier_list_rec.lumpsum_amount := rosetta_g_miss_num_map(p6_a18);
3383 ddp_modifier_list_rec.lumpsum_payment_type := p6_a19;
3384 ddp_modifier_list_rec.custom_setup_id := rosetta_g_miss_num_map(p6_a20);
3385 ddp_modifier_list_rec.offer_amount := rosetta_g_miss_num_map(p6_a21);
3386 ddp_modifier_list_rec.budget_amount_tc := rosetta_g_miss_num_map(p6_a22);
3387 ddp_modifier_list_rec.budget_amount_fc := rosetta_g_miss_num_map(p6_a23);
3388 ddp_modifier_list_rec.transaction_currency_code := p6_a24;
3389 ddp_modifier_list_rec.functional_currency_code := p6_a25;
3390 ddp_modifier_list_rec.context := p6_a26;
3391 ddp_modifier_list_rec.attribute1 := p6_a27;
3392 ddp_modifier_list_rec.attribute2 := p6_a28;
3393 ddp_modifier_list_rec.attribute3 := p6_a29;
3394 ddp_modifier_list_rec.attribute4 := p6_a30;
3395 ddp_modifier_list_rec.attribute5 := p6_a31;
3396 ddp_modifier_list_rec.attribute6 := p6_a32;
3397 ddp_modifier_list_rec.attribute7 := p6_a33;
3398 ddp_modifier_list_rec.attribute8 := p6_a34;
3399 ddp_modifier_list_rec.attribute9 := p6_a35;
3400 ddp_modifier_list_rec.attribute10 := p6_a36;
3401 ddp_modifier_list_rec.attribute11 := p6_a37;
3402 ddp_modifier_list_rec.attribute12 := p6_a38;
3403 ddp_modifier_list_rec.attribute13 := p6_a39;
3404 ddp_modifier_list_rec.attribute14 := p6_a40;
3405 ddp_modifier_list_rec.attribute15 := p6_a41;
3406 ddp_modifier_list_rec.currency_code := p6_a42;
3407 ddp_modifier_list_rec.start_date_active := rosetta_g_miss_date_in_map(p6_a43);
3408 ddp_modifier_list_rec.end_date_active := rosetta_g_miss_date_in_map(p6_a44);
3409 ddp_modifier_list_rec.list_type_code := p6_a45;
3410 ddp_modifier_list_rec.discount_lines_flag := p6_a46;
3411 ddp_modifier_list_rec.name := p6_a47;
3412 ddp_modifier_list_rec.description := p6_a48;
3413 ddp_modifier_list_rec.comments := p6_a49;
3414 ddp_modifier_list_rec.ask_for_flag := p6_a50;
3415 ddp_modifier_list_rec.start_date_active_first := rosetta_g_miss_date_in_map(p6_a51);
3416 ddp_modifier_list_rec.end_date_active_first := rosetta_g_miss_date_in_map(p6_a52);
3417 ddp_modifier_list_rec.active_date_first_type := p6_a53;
3418 ddp_modifier_list_rec.start_date_active_second := rosetta_g_miss_date_in_map(p6_a54);
3419 ddp_modifier_list_rec.end_date_active_second := rosetta_g_miss_date_in_map(p6_a55);
3420 ddp_modifier_list_rec.active_date_second_type := p6_a56;
3421 ddp_modifier_list_rec.active_flag := p6_a57;
3422 ddp_modifier_list_rec.max_no_of_uses := rosetta_g_miss_num_map(p6_a58);
3423 ddp_modifier_list_rec.budget_source_id := rosetta_g_miss_num_map(p6_a59);
3424 ddp_modifier_list_rec.budget_source_type := p6_a60;
3425 ddp_modifier_list_rec.offer_used_by_id := rosetta_g_miss_num_map(p6_a61);
3426 ddp_modifier_list_rec.offer_used_by := p6_a62;
3427 ddp_modifier_list_rec.ql_qualifier_type := p6_a63;
3428 ddp_modifier_list_rec.ql_qualifier_id := rosetta_g_miss_num_map(p6_a64);
3429 ddp_modifier_list_rec.distribution_type := p6_a65;
3430 ddp_modifier_list_rec.amount_limit_id := rosetta_g_miss_num_map(p6_a66);
3431 ddp_modifier_list_rec.uses_limit_id := rosetta_g_miss_num_map(p6_a67);
3432 ddp_modifier_list_rec.offer_operation := p6_a68;
3433 ddp_modifier_list_rec.modifier_operation := p6_a69;
3434 ddp_modifier_list_rec.budget_offer_yn := p6_a70;
3435 ddp_modifier_list_rec.break_type := p6_a71;
3436 ddp_modifier_list_rec.retroactive := p6_a72;
3437 ddp_modifier_list_rec.volume_offer_type := p6_a73;
3438 ddp_modifier_list_rec.confidential_flag := p6_a74;
3439 ddp_modifier_list_rec.committed_amount_eq_max := p6_a75;
3440 ddp_modifier_list_rec.source_from_parent := p6_a76;
3441 ddp_modifier_list_rec.buyer_name := p6_a77;
3442 ddp_modifier_list_rec.tier_level := p6_a78;
3443 ddp_modifier_list_rec.na_rule_header_id := rosetta_g_miss_num_map(p6_a79);
3444 ddp_modifier_list_rec.sales_method_flag := p6_a80;
3445 ddp_modifier_list_rec.global_flag := p6_a81;
3446 ddp_modifier_list_rec.orig_org_id := rosetta_g_miss_num_map(p6_a82);
3447
3448 ozf_offer_pub_w.rosetta_table_copy_in_p21(ddp_vo_pbh_tbl, p7_a0
3449 , p7_a1
3450 , p7_a2
3451 , p7_a3
3452 , p7_a4
3453 , p7_a5
3454 , p7_a6
3455 , p7_a7
3456 , p7_a8
3457 , p7_a9
3458 , p7_a10
3459 , p7_a11
3460 , p7_a12
3461 , p7_a13
3462 , p7_a14
3463 , p7_a15
3464 , p7_a16
3465 , p7_a17
3466 , p7_a18
3467 , p7_a19
3468 , p7_a20
3469 );
3470
3471 ozf_offer_pub_w.rosetta_table_copy_in_p21(ddp_vo_dis_tbl, p8_a0
3472 , p8_a1
3473 , p8_a2
3474 , p8_a3
3475 , p8_a4
3476 , p8_a5
3477 , p8_a6
3478 , p8_a7
3479 , p8_a8
3480 , p8_a9
3481 , p8_a10
3482 , p8_a11
3483 , p8_a12
3484 , p8_a13
3485 , p8_a14
3486 , p8_a15
3487 , p8_a16
3488 , p8_a17
3489 , p8_a18
3490 , p8_a19
3491 , p8_a20
3492 );
3493
3494 ozf_offer_pub_w.rosetta_table_copy_in_p23(ddp_vo_prod_tbl, p9_a0
3495 , p9_a1
3496 , p9_a2
3497 , p9_a3
3498 , p9_a4
3499 , p9_a5
3500 , p9_a6
3501 , p9_a7
3502 , p9_a8
3503 , p9_a9
3504 , p9_a10
3505 , p9_a11
3506 );
3507
3508 ozf_offer_pub_w.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p10_a0
3509 , p10_a1
3510 , p10_a2
3511 , p10_a3
3512 , p10_a4
3513 , p10_a5
3514 , p10_a6
3515 , p10_a7
3516 , p10_a8
3517 , p10_a9
3518 , p10_a10
3519 , p10_a11
3520 , p10_a12
3521 , p10_a13
3522 , p10_a14
3523 , p10_a15
3524 , p10_a16
3525 , p10_a17
3526 , p10_a18
3527 , p10_a19
3528 , p10_a20
3529 , p10_a21
3530 , p10_a22
3531 , p10_a23
3532 , p10_a24
3533 , p10_a25
3534 , p10_a26
3535 , p10_a27
3536 , p10_a28
3537 );
3538
3539 ozf_offer_pub_w.rosetta_table_copy_in_p25(ddp_vo_mo_tbl, p11_a0
3540 , p11_a1
3541 , p11_a2
3542 , p11_a3
3543 , p11_a4
3544 , p11_a5
3545 , p11_a6
3546 , p11_a7
3547 , p11_a8
3548 , p11_a9
3549 , p11_a10
3550 , p11_a11
3551 , p11_a12
3552 );
3553
3554 ozf_offer_pub_w.rosetta_table_copy_in_p14(ddp_budget_tbl, p12_a0
3555 , p12_a1
3556 , p12_a2
3557 , p12_a3
3558 );
3559
3560
3561
3562 -- here's the delegated call to the old PL/SQL routine
3563 ozf_offer_pub.process_vo(p_init_msg_list,
3564 p_api_version,
3565 p_commit,
3566 x_return_status,
3567 x_msg_count,
3568 x_msg_data,
3569 ddp_modifier_list_rec,
3570 ddp_vo_pbh_tbl,
3571 ddp_vo_dis_tbl,
3572 ddp_vo_prod_tbl,
3573 ddp_qualifier_tbl,
3574 ddp_vo_mo_tbl,
3575 ddp_budget_tbl,
3576 x_qp_list_header_id,
3577 x_error_location);
3578
3579 -- copy data back from the local variables to OUT or IN-OUT args, if any
3580
3581
3582
3583
3584
3585
3586
3587
3588
3589
3590
3591
3592
3593
3594 end;
3595
3596 end ozf_offer_pub_w;