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