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