[Home] [Help]
PACKAGE BODY: APPS.OZF_OFFER_ADJ_LINE_PVT_W
Source
1 package body ozf_offer_adj_line_pvt_w as
2 /* $Header: ozfwoalb.pls 120.1 2005/09/26 17:59 rssharma noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_adj_line_pvt.offadj_line_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_VARCHAR2_TABLE_100
26 , a4 JTF_NUMBER_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_DATE_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_DATE_TABLE
31 , a9 JTF_NUMBER_TABLE
32 , a10 JTF_NUMBER_TABLE
33 , a11 JTF_NUMBER_TABLE
34 , a12 JTF_NUMBER_TABLE
35 , a13 JTF_VARCHAR2_TABLE_100
36 , a14 JTF_NUMBER_TABLE
37 , a15 JTF_NUMBER_TABLE
38 , a16 JTF_NUMBER_TABLE
39 , a17 JTF_NUMBER_TABLE
40 , a18 JTF_VARCHAR2_TABLE_100
41 , a19 JTF_DATE_TABLE
42 ) as
43 ddindx binary_integer; indx binary_integer;
44 begin
45 if a0 is not null and a0.count > 0 then
46 if a0.count > 0 then
47 indx := a0.first;
48 ddindx := 1;
49 while true loop
50 t(ddindx).offer_adjustment_line_id := rosetta_g_miss_num_map(a0(indx));
51 t(ddindx).offer_adjustment_id := rosetta_g_miss_num_map(a1(indx));
52 t(ddindx).list_line_id := rosetta_g_miss_num_map(a2(indx));
53 t(ddindx).arithmetic_operator := a3(indx);
54 t(ddindx).original_discount := rosetta_g_miss_num_map(a4(indx));
55 t(ddindx).modified_discount := rosetta_g_miss_num_map(a5(indx));
56 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a6(indx));
57 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a7(indx));
58 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a8(indx));
59 t(ddindx).created_by := rosetta_g_miss_num_map(a9(indx));
60 t(ddindx).last_update_login := rosetta_g_miss_num_map(a10(indx));
61 t(ddindx).object_version_number := rosetta_g_miss_num_map(a11(indx));
62 t(ddindx).list_header_id := rosetta_g_miss_num_map(a12(indx));
63 t(ddindx).accrual_flag := a13(indx);
64 t(ddindx).list_line_id_td := rosetta_g_miss_num_map(a14(indx));
65 t(ddindx).original_discount_td := rosetta_g_miss_num_map(a15(indx));
66 t(ddindx).modified_discount_td := rosetta_g_miss_num_map(a16(indx));
67 t(ddindx).quantity := rosetta_g_miss_num_map(a17(indx));
68 t(ddindx).created_from_adjustments := a18(indx);
69 t(ddindx).discount_end_date := rosetta_g_miss_date_in_map(a19(indx));
70 ddindx := ddindx+1;
71 if a0.last =indx
72 then exit;
73 end if;
74 indx := a0.next(indx);
75 end loop;
76 end if;
77 end if;
78 end rosetta_table_copy_in_p2;
79 procedure rosetta_table_copy_out_p2(t ozf_offer_adj_line_pvt.offadj_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80 , a1 out nocopy JTF_NUMBER_TABLE
81 , a2 out nocopy JTF_NUMBER_TABLE
82 , a3 out nocopy JTF_VARCHAR2_TABLE_100
83 , a4 out nocopy JTF_NUMBER_TABLE
84 , a5 out nocopy JTF_NUMBER_TABLE
85 , a6 out nocopy JTF_DATE_TABLE
86 , a7 out nocopy JTF_NUMBER_TABLE
87 , a8 out nocopy JTF_DATE_TABLE
88 , a9 out nocopy JTF_NUMBER_TABLE
89 , a10 out nocopy JTF_NUMBER_TABLE
90 , a11 out nocopy JTF_NUMBER_TABLE
91 , a12 out nocopy JTF_NUMBER_TABLE
92 , a13 out nocopy JTF_VARCHAR2_TABLE_100
93 , a14 out nocopy JTF_NUMBER_TABLE
94 , a15 out nocopy JTF_NUMBER_TABLE
95 , a16 out nocopy JTF_NUMBER_TABLE
96 , a17 out nocopy JTF_NUMBER_TABLE
97 , a18 out nocopy JTF_VARCHAR2_TABLE_100
98 , a19 out nocopy JTF_DATE_TABLE
99 ) as
100 ddindx binary_integer; indx binary_integer;
101 begin
102 if t is null or t.count = 0 then
103 a0 := JTF_NUMBER_TABLE();
104 a1 := JTF_NUMBER_TABLE();
105 a2 := JTF_NUMBER_TABLE();
106 a3 := JTF_VARCHAR2_TABLE_100();
107 a4 := JTF_NUMBER_TABLE();
108 a5 := JTF_NUMBER_TABLE();
109 a6 := JTF_DATE_TABLE();
110 a7 := JTF_NUMBER_TABLE();
111 a8 := JTF_DATE_TABLE();
112 a9 := JTF_NUMBER_TABLE();
113 a10 := JTF_NUMBER_TABLE();
114 a11 := JTF_NUMBER_TABLE();
115 a12 := JTF_NUMBER_TABLE();
116 a13 := JTF_VARCHAR2_TABLE_100();
117 a14 := JTF_NUMBER_TABLE();
118 a15 := JTF_NUMBER_TABLE();
119 a16 := JTF_NUMBER_TABLE();
120 a17 := JTF_NUMBER_TABLE();
121 a18 := JTF_VARCHAR2_TABLE_100();
122 a19 := JTF_DATE_TABLE();
123 else
124 a0 := JTF_NUMBER_TABLE();
125 a1 := JTF_NUMBER_TABLE();
126 a2 := JTF_NUMBER_TABLE();
127 a3 := JTF_VARCHAR2_TABLE_100();
128 a4 := JTF_NUMBER_TABLE();
129 a5 := JTF_NUMBER_TABLE();
130 a6 := JTF_DATE_TABLE();
131 a7 := JTF_NUMBER_TABLE();
132 a8 := JTF_DATE_TABLE();
133 a9 := JTF_NUMBER_TABLE();
134 a10 := JTF_NUMBER_TABLE();
135 a11 := JTF_NUMBER_TABLE();
136 a12 := JTF_NUMBER_TABLE();
137 a13 := JTF_VARCHAR2_TABLE_100();
138 a14 := JTF_NUMBER_TABLE();
139 a15 := JTF_NUMBER_TABLE();
140 a16 := JTF_NUMBER_TABLE();
141 a17 := JTF_NUMBER_TABLE();
142 a18 := JTF_VARCHAR2_TABLE_100();
143 a19 := JTF_DATE_TABLE();
144 if t.count > 0 then
145 a0.extend(t.count);
146 a1.extend(t.count);
147 a2.extend(t.count);
148 a3.extend(t.count);
149 a4.extend(t.count);
150 a5.extend(t.count);
151 a6.extend(t.count);
152 a7.extend(t.count);
153 a8.extend(t.count);
154 a9.extend(t.count);
155 a10.extend(t.count);
156 a11.extend(t.count);
157 a12.extend(t.count);
158 a13.extend(t.count);
159 a14.extend(t.count);
160 a15.extend(t.count);
161 a16.extend(t.count);
162 a17.extend(t.count);
163 a18.extend(t.count);
164 a19.extend(t.count);
165 ddindx := t.first;
166 indx := 1;
167 while true loop
168 a0(indx) := rosetta_g_miss_num_map(t(ddindx).offer_adjustment_line_id);
169 a1(indx) := rosetta_g_miss_num_map(t(ddindx).offer_adjustment_id);
170 a2(indx) := rosetta_g_miss_num_map(t(ddindx).list_line_id);
171 a3(indx) := t(ddindx).arithmetic_operator;
172 a4(indx) := rosetta_g_miss_num_map(t(ddindx).original_discount);
173 a5(indx) := rosetta_g_miss_num_map(t(ddindx).modified_discount);
174 a6(indx) := t(ddindx).last_update_date;
175 a7(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
176 a8(indx) := t(ddindx).creation_date;
177 a9(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
178 a10(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
179 a11(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
180 a12(indx) := rosetta_g_miss_num_map(t(ddindx).list_header_id);
181 a13(indx) := t(ddindx).accrual_flag;
182 a14(indx) := rosetta_g_miss_num_map(t(ddindx).list_line_id_td);
183 a15(indx) := rosetta_g_miss_num_map(t(ddindx).original_discount_td);
184 a16(indx) := rosetta_g_miss_num_map(t(ddindx).modified_discount_td);
185 a17(indx) := rosetta_g_miss_num_map(t(ddindx).quantity);
186 a18(indx) := t(ddindx).created_from_adjustments;
187 a19(indx) := t(ddindx).discount_end_date;
188 indx := indx+1;
189 if t.last =ddindx
190 then exit;
191 end if;
192 ddindx := t.next(ddindx);
193 end loop;
194 end if;
195 end if;
196 end rosetta_table_copy_out_p2;
197
198 procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_adj_line_pvt.offadj_new_line_tbl_type, a0 JTF_NUMBER_TABLE
199 , a1 JTF_NUMBER_TABLE
200 , a2 JTF_NUMBER_TABLE
201 , a3 JTF_NUMBER_TABLE
202 , a4 JTF_VARCHAR2_TABLE_100
203 , a5 JTF_NUMBER_TABLE
204 , a6 JTF_VARCHAR2_TABLE_100
205 , a7 JTF_VARCHAR2_TABLE_100
206 , a8 JTF_VARCHAR2_TABLE_300
207 , a9 JTF_VARCHAR2_TABLE_100
208 , a10 JTF_VARCHAR2_TABLE_100
209 , a11 JTF_VARCHAR2_TABLE_300
210 , a12 JTF_VARCHAR2_TABLE_300
211 , a13 JTF_NUMBER_TABLE
212 , a14 JTF_NUMBER_TABLE
213 , a15 JTF_NUMBER_TABLE
214 , a16 JTF_NUMBER_TABLE
215 , a17 JTF_VARCHAR2_TABLE_100
216 , a18 JTF_NUMBER_TABLE
217 , a19 JTF_NUMBER_TABLE
218 , a20 JTF_NUMBER_TABLE
219 , a21 JTF_NUMBER_TABLE
220 , a22 JTF_NUMBER_TABLE
221 , a23 JTF_VARCHAR2_TABLE_100
222 , a24 JTF_NUMBER_TABLE
223 , a25 JTF_VARCHAR2_TABLE_100
224 , a26 JTF_VARCHAR2_TABLE_100
225 , a27 JTF_NUMBER_TABLE
226 , a28 JTF_VARCHAR2_TABLE_100
227 , a29 JTF_NUMBER_TABLE
228 , a30 JTF_VARCHAR2_TABLE_100
229 , a31 JTF_NUMBER_TABLE
230 , a32 JTF_DATE_TABLE
231 , a33 JTF_NUMBER_TABLE
232 , a34 JTF_DATE_TABLE
233 , a35 JTF_NUMBER_TABLE
234 , a36 JTF_NUMBER_TABLE
235 , a37 JTF_NUMBER_TABLE
236 , a38 JTF_DATE_TABLE
237 , a39 JTF_DATE_TABLE
238 , a40 JTF_VARCHAR2_TABLE_300
239 , a41 JTF_VARCHAR2_TABLE_300
240 , a42 JTF_VARCHAR2_TABLE_300
241 , a43 JTF_VARCHAR2_TABLE_300
242 , a44 JTF_VARCHAR2_TABLE_300
243 , a45 JTF_VARCHAR2_TABLE_300
244 , a46 JTF_VARCHAR2_TABLE_300
245 , a47 JTF_VARCHAR2_TABLE_300
246 , a48 JTF_VARCHAR2_TABLE_300
247 , a49 JTF_VARCHAR2_TABLE_300
248 , a50 JTF_VARCHAR2_TABLE_300
249 , a51 JTF_VARCHAR2_TABLE_300
250 , a52 JTF_VARCHAR2_TABLE_300
251 , a53 JTF_VARCHAR2_TABLE_300
252 , a54 JTF_VARCHAR2_TABLE_300
253 , a55 JTF_VARCHAR2_TABLE_100
254 , a56 JTF_DATE_TABLE
255 ) as
256 ddindx binary_integer; indx binary_integer;
257 begin
258 if a0 is not null and a0.count > 0 then
259 if a0.count > 0 then
260 indx := a0.first;
261 ddindx := 1;
262 while true loop
263 t(ddindx).offer_adjustment_line_id := rosetta_g_miss_num_map(a0(indx));
264 t(ddindx).offer_adjustment_id := rosetta_g_miss_num_map(a1(indx));
265 t(ddindx).list_header_id := rosetta_g_miss_num_map(a2(indx));
266 t(ddindx).list_line_id := rosetta_g_miss_num_map(a3(indx));
267 t(ddindx).list_line_type_code := a4(indx);
268 t(ddindx).operand := rosetta_g_miss_num_map(a5(indx));
269 t(ddindx).arithmetic_operator := a6(indx);
270 t(ddindx).product_attr := a7(indx);
271 t(ddindx).product_attr_val := a8(indx);
272 t(ddindx).product_uom_code := a9(indx);
273 t(ddindx).pricing_attr := a10(indx);
274 t(ddindx).pricing_attr_value_from := a11(indx);
275 t(ddindx).pricing_attr_value_to := a12(indx);
276 t(ddindx).pricing_attribute_id := rosetta_g_miss_num_map(a13(indx));
277 t(ddindx).order_value_from := rosetta_g_miss_num_map(a14(indx));
278 t(ddindx).order_value_to := rosetta_g_miss_num_map(a15(indx));
279 t(ddindx).qualifier_id := rosetta_g_miss_num_map(a16(indx));
280 t(ddindx).inactive_flag := a17(indx);
281 t(ddindx).max_qty_per_order_id := rosetta_g_miss_num_map(a18(indx));
282 t(ddindx).max_qty_per_customer_id := rosetta_g_miss_num_map(a19(indx));
283 t(ddindx).max_qty_per_rule_id := rosetta_g_miss_num_map(a20(indx));
284 t(ddindx).max_orders_per_customer_id := rosetta_g_miss_num_map(a21(indx));
285 t(ddindx).max_amount_per_rule_id := rosetta_g_miss_num_map(a22(indx));
286 t(ddindx).qd_arithmetic_operator := a23(indx);
287 t(ddindx).qd_operand := rosetta_g_miss_num_map(a24(indx));
288 t(ddindx).qd_estimated_qty_is_max := a25(indx);
289 t(ddindx).qd_estimated_amount_is_max := a26(indx);
290 t(ddindx).price_by_formula_id := rosetta_g_miss_num_map(a27(indx));
291 t(ddindx).operation := a28(indx);
292 t(ddindx).benefit_price_list_line_id := rosetta_g_miss_num_map(a29(indx));
293 t(ddindx).benefit_uom_code := a30(indx);
294 t(ddindx).benefit_qty := rosetta_g_miss_num_map(a31(indx));
295 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a32(indx));
296 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a33(indx));
297 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a34(indx));
298 t(ddindx).created_by := rosetta_g_miss_num_map(a35(indx));
299 t(ddindx).last_update_login := rosetta_g_miss_num_map(a36(indx));
300 t(ddindx).object_version_number := rosetta_g_miss_num_map(a37(indx));
301 t(ddindx).start_date_active := rosetta_g_miss_date_in_map(a38(indx));
302 t(ddindx).end_date_active := rosetta_g_miss_date_in_map(a39(indx));
303 t(ddindx).attribute1 := a40(indx);
304 t(ddindx).attribute2 := a41(indx);
305 t(ddindx).attribute3 := a42(indx);
306 t(ddindx).attribute4 := a43(indx);
307 t(ddindx).attribute5 := a44(indx);
308 t(ddindx).attribute6 := a45(indx);
309 t(ddindx).attribute7 := a46(indx);
310 t(ddindx).attribute8 := a47(indx);
311 t(ddindx).attribute9 := a48(indx);
312 t(ddindx).attribute10 := a49(indx);
313 t(ddindx).attribute11 := a50(indx);
314 t(ddindx).attribute12 := a51(indx);
315 t(ddindx).attribute13 := a52(indx);
316 t(ddindx).attribute14 := a53(indx);
317 t(ddindx).attribute15 := a54(indx);
318 t(ddindx).context := a55(indx);
319 t(ddindx).discount_end_date := rosetta_g_miss_date_in_map(a56(indx));
320 ddindx := ddindx+1;
321 if a0.last =indx
322 then exit;
323 end if;
324 indx := a0.next(indx);
325 end loop;
326 end if;
327 end if;
328 end rosetta_table_copy_in_p6;
329 procedure rosetta_table_copy_out_p6(t ozf_offer_adj_line_pvt.offadj_new_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330 , a1 out nocopy JTF_NUMBER_TABLE
331 , a2 out nocopy JTF_NUMBER_TABLE
332 , a3 out nocopy JTF_NUMBER_TABLE
333 , a4 out nocopy JTF_VARCHAR2_TABLE_100
334 , a5 out nocopy JTF_NUMBER_TABLE
335 , a6 out nocopy JTF_VARCHAR2_TABLE_100
336 , a7 out nocopy JTF_VARCHAR2_TABLE_100
337 , a8 out nocopy JTF_VARCHAR2_TABLE_300
338 , a9 out nocopy JTF_VARCHAR2_TABLE_100
339 , a10 out nocopy JTF_VARCHAR2_TABLE_100
340 , a11 out nocopy JTF_VARCHAR2_TABLE_300
341 , a12 out nocopy JTF_VARCHAR2_TABLE_300
342 , a13 out nocopy JTF_NUMBER_TABLE
343 , a14 out nocopy JTF_NUMBER_TABLE
344 , a15 out nocopy JTF_NUMBER_TABLE
345 , a16 out nocopy JTF_NUMBER_TABLE
346 , a17 out nocopy JTF_VARCHAR2_TABLE_100
347 , a18 out nocopy JTF_NUMBER_TABLE
348 , a19 out nocopy JTF_NUMBER_TABLE
349 , a20 out nocopy JTF_NUMBER_TABLE
350 , a21 out nocopy JTF_NUMBER_TABLE
351 , a22 out nocopy JTF_NUMBER_TABLE
352 , a23 out nocopy JTF_VARCHAR2_TABLE_100
353 , a24 out nocopy JTF_NUMBER_TABLE
354 , a25 out nocopy JTF_VARCHAR2_TABLE_100
355 , a26 out nocopy JTF_VARCHAR2_TABLE_100
356 , a27 out nocopy JTF_NUMBER_TABLE
357 , a28 out nocopy JTF_VARCHAR2_TABLE_100
358 , a29 out nocopy JTF_NUMBER_TABLE
359 , a30 out nocopy JTF_VARCHAR2_TABLE_100
360 , a31 out nocopy JTF_NUMBER_TABLE
361 , a32 out nocopy JTF_DATE_TABLE
362 , a33 out nocopy JTF_NUMBER_TABLE
363 , a34 out nocopy JTF_DATE_TABLE
364 , a35 out nocopy JTF_NUMBER_TABLE
365 , a36 out nocopy JTF_NUMBER_TABLE
366 , a37 out nocopy JTF_NUMBER_TABLE
367 , a38 out nocopy JTF_DATE_TABLE
368 , a39 out nocopy JTF_DATE_TABLE
369 , a40 out nocopy JTF_VARCHAR2_TABLE_300
370 , a41 out nocopy JTF_VARCHAR2_TABLE_300
371 , a42 out nocopy JTF_VARCHAR2_TABLE_300
372 , a43 out nocopy JTF_VARCHAR2_TABLE_300
373 , a44 out nocopy JTF_VARCHAR2_TABLE_300
374 , a45 out nocopy JTF_VARCHAR2_TABLE_300
375 , a46 out nocopy JTF_VARCHAR2_TABLE_300
376 , a47 out nocopy JTF_VARCHAR2_TABLE_300
377 , a48 out nocopy JTF_VARCHAR2_TABLE_300
378 , a49 out nocopy JTF_VARCHAR2_TABLE_300
379 , a50 out nocopy JTF_VARCHAR2_TABLE_300
380 , a51 out nocopy JTF_VARCHAR2_TABLE_300
381 , a52 out nocopy JTF_VARCHAR2_TABLE_300
382 , a53 out nocopy JTF_VARCHAR2_TABLE_300
383 , a54 out nocopy JTF_VARCHAR2_TABLE_300
384 , a55 out nocopy JTF_VARCHAR2_TABLE_100
385 , a56 out nocopy JTF_DATE_TABLE
386 ) as
387 ddindx binary_integer; indx binary_integer;
388 begin
389 if t is null or t.count = 0 then
390 a0 := JTF_NUMBER_TABLE();
391 a1 := JTF_NUMBER_TABLE();
392 a2 := JTF_NUMBER_TABLE();
393 a3 := JTF_NUMBER_TABLE();
394 a4 := JTF_VARCHAR2_TABLE_100();
395 a5 := JTF_NUMBER_TABLE();
396 a6 := JTF_VARCHAR2_TABLE_100();
397 a7 := JTF_VARCHAR2_TABLE_100();
398 a8 := JTF_VARCHAR2_TABLE_300();
399 a9 := JTF_VARCHAR2_TABLE_100();
400 a10 := JTF_VARCHAR2_TABLE_100();
401 a11 := JTF_VARCHAR2_TABLE_300();
402 a12 := JTF_VARCHAR2_TABLE_300();
403 a13 := JTF_NUMBER_TABLE();
404 a14 := JTF_NUMBER_TABLE();
405 a15 := JTF_NUMBER_TABLE();
406 a16 := JTF_NUMBER_TABLE();
407 a17 := JTF_VARCHAR2_TABLE_100();
408 a18 := JTF_NUMBER_TABLE();
409 a19 := JTF_NUMBER_TABLE();
410 a20 := JTF_NUMBER_TABLE();
411 a21 := JTF_NUMBER_TABLE();
412 a22 := JTF_NUMBER_TABLE();
413 a23 := JTF_VARCHAR2_TABLE_100();
414 a24 := JTF_NUMBER_TABLE();
415 a25 := JTF_VARCHAR2_TABLE_100();
416 a26 := JTF_VARCHAR2_TABLE_100();
417 a27 := JTF_NUMBER_TABLE();
418 a28 := JTF_VARCHAR2_TABLE_100();
419 a29 := JTF_NUMBER_TABLE();
420 a30 := JTF_VARCHAR2_TABLE_100();
421 a31 := JTF_NUMBER_TABLE();
422 a32 := JTF_DATE_TABLE();
423 a33 := JTF_NUMBER_TABLE();
424 a34 := JTF_DATE_TABLE();
425 a35 := JTF_NUMBER_TABLE();
426 a36 := JTF_NUMBER_TABLE();
427 a37 := JTF_NUMBER_TABLE();
428 a38 := JTF_DATE_TABLE();
429 a39 := JTF_DATE_TABLE();
430 a40 := JTF_VARCHAR2_TABLE_300();
431 a41 := JTF_VARCHAR2_TABLE_300();
432 a42 := JTF_VARCHAR2_TABLE_300();
433 a43 := JTF_VARCHAR2_TABLE_300();
434 a44 := JTF_VARCHAR2_TABLE_300();
435 a45 := JTF_VARCHAR2_TABLE_300();
436 a46 := JTF_VARCHAR2_TABLE_300();
437 a47 := JTF_VARCHAR2_TABLE_300();
438 a48 := JTF_VARCHAR2_TABLE_300();
439 a49 := JTF_VARCHAR2_TABLE_300();
440 a50 := JTF_VARCHAR2_TABLE_300();
441 a51 := JTF_VARCHAR2_TABLE_300();
442 a52 := JTF_VARCHAR2_TABLE_300();
443 a53 := JTF_VARCHAR2_TABLE_300();
444 a54 := JTF_VARCHAR2_TABLE_300();
445 a55 := JTF_VARCHAR2_TABLE_100();
446 a56 := JTF_DATE_TABLE();
447 else
448 a0 := JTF_NUMBER_TABLE();
449 a1 := JTF_NUMBER_TABLE();
450 a2 := JTF_NUMBER_TABLE();
451 a3 := JTF_NUMBER_TABLE();
452 a4 := JTF_VARCHAR2_TABLE_100();
453 a5 := JTF_NUMBER_TABLE();
454 a6 := JTF_VARCHAR2_TABLE_100();
455 a7 := JTF_VARCHAR2_TABLE_100();
456 a8 := JTF_VARCHAR2_TABLE_300();
457 a9 := JTF_VARCHAR2_TABLE_100();
458 a10 := JTF_VARCHAR2_TABLE_100();
459 a11 := JTF_VARCHAR2_TABLE_300();
460 a12 := JTF_VARCHAR2_TABLE_300();
461 a13 := JTF_NUMBER_TABLE();
462 a14 := JTF_NUMBER_TABLE();
463 a15 := JTF_NUMBER_TABLE();
464 a16 := JTF_NUMBER_TABLE();
465 a17 := JTF_VARCHAR2_TABLE_100();
466 a18 := JTF_NUMBER_TABLE();
467 a19 := JTF_NUMBER_TABLE();
468 a20 := JTF_NUMBER_TABLE();
469 a21 := JTF_NUMBER_TABLE();
470 a22 := JTF_NUMBER_TABLE();
471 a23 := JTF_VARCHAR2_TABLE_100();
472 a24 := JTF_NUMBER_TABLE();
473 a25 := JTF_VARCHAR2_TABLE_100();
474 a26 := JTF_VARCHAR2_TABLE_100();
475 a27 := JTF_NUMBER_TABLE();
476 a28 := JTF_VARCHAR2_TABLE_100();
477 a29 := JTF_NUMBER_TABLE();
478 a30 := JTF_VARCHAR2_TABLE_100();
479 a31 := JTF_NUMBER_TABLE();
480 a32 := JTF_DATE_TABLE();
481 a33 := JTF_NUMBER_TABLE();
482 a34 := JTF_DATE_TABLE();
483 a35 := JTF_NUMBER_TABLE();
484 a36 := JTF_NUMBER_TABLE();
485 a37 := JTF_NUMBER_TABLE();
486 a38 := JTF_DATE_TABLE();
487 a39 := JTF_DATE_TABLE();
488 a40 := JTF_VARCHAR2_TABLE_300();
489 a41 := JTF_VARCHAR2_TABLE_300();
490 a42 := JTF_VARCHAR2_TABLE_300();
491 a43 := JTF_VARCHAR2_TABLE_300();
492 a44 := JTF_VARCHAR2_TABLE_300();
493 a45 := JTF_VARCHAR2_TABLE_300();
494 a46 := JTF_VARCHAR2_TABLE_300();
495 a47 := JTF_VARCHAR2_TABLE_300();
496 a48 := JTF_VARCHAR2_TABLE_300();
497 a49 := JTF_VARCHAR2_TABLE_300();
498 a50 := JTF_VARCHAR2_TABLE_300();
499 a51 := JTF_VARCHAR2_TABLE_300();
500 a52 := JTF_VARCHAR2_TABLE_300();
501 a53 := JTF_VARCHAR2_TABLE_300();
502 a54 := JTF_VARCHAR2_TABLE_300();
503 a55 := JTF_VARCHAR2_TABLE_100();
504 a56 := JTF_DATE_TABLE();
505 if t.count > 0 then
506 a0.extend(t.count);
507 a1.extend(t.count);
508 a2.extend(t.count);
509 a3.extend(t.count);
510 a4.extend(t.count);
511 a5.extend(t.count);
512 a6.extend(t.count);
513 a7.extend(t.count);
514 a8.extend(t.count);
515 a9.extend(t.count);
516 a10.extend(t.count);
517 a11.extend(t.count);
518 a12.extend(t.count);
519 a13.extend(t.count);
520 a14.extend(t.count);
521 a15.extend(t.count);
522 a16.extend(t.count);
523 a17.extend(t.count);
524 a18.extend(t.count);
525 a19.extend(t.count);
526 a20.extend(t.count);
527 a21.extend(t.count);
528 a22.extend(t.count);
529 a23.extend(t.count);
530 a24.extend(t.count);
531 a25.extend(t.count);
532 a26.extend(t.count);
533 a27.extend(t.count);
534 a28.extend(t.count);
535 a29.extend(t.count);
536 a30.extend(t.count);
537 a31.extend(t.count);
538 a32.extend(t.count);
539 a33.extend(t.count);
540 a34.extend(t.count);
541 a35.extend(t.count);
542 a36.extend(t.count);
543 a37.extend(t.count);
544 a38.extend(t.count);
545 a39.extend(t.count);
546 a40.extend(t.count);
547 a41.extend(t.count);
548 a42.extend(t.count);
549 a43.extend(t.count);
550 a44.extend(t.count);
551 a45.extend(t.count);
552 a46.extend(t.count);
553 a47.extend(t.count);
554 a48.extend(t.count);
555 a49.extend(t.count);
556 a50.extend(t.count);
557 a51.extend(t.count);
558 a52.extend(t.count);
559 a53.extend(t.count);
560 a54.extend(t.count);
561 a55.extend(t.count);
562 a56.extend(t.count);
563 ddindx := t.first;
564 indx := 1;
565 while true loop
566 a0(indx) := rosetta_g_miss_num_map(t(ddindx).offer_adjustment_line_id);
567 a1(indx) := rosetta_g_miss_num_map(t(ddindx).offer_adjustment_id);
568 a2(indx) := rosetta_g_miss_num_map(t(ddindx).list_header_id);
569 a3(indx) := rosetta_g_miss_num_map(t(ddindx).list_line_id);
570 a4(indx) := t(ddindx).list_line_type_code;
571 a5(indx) := rosetta_g_miss_num_map(t(ddindx).operand);
572 a6(indx) := t(ddindx).arithmetic_operator;
573 a7(indx) := t(ddindx).product_attr;
574 a8(indx) := t(ddindx).product_attr_val;
575 a9(indx) := t(ddindx).product_uom_code;
576 a10(indx) := t(ddindx).pricing_attr;
577 a11(indx) := t(ddindx).pricing_attr_value_from;
578 a12(indx) := t(ddindx).pricing_attr_value_to;
579 a13(indx) := rosetta_g_miss_num_map(t(ddindx).pricing_attribute_id);
580 a14(indx) := rosetta_g_miss_num_map(t(ddindx).order_value_from);
581 a15(indx) := rosetta_g_miss_num_map(t(ddindx).order_value_to);
582 a16(indx) := rosetta_g_miss_num_map(t(ddindx).qualifier_id);
583 a17(indx) := t(ddindx).inactive_flag;
584 a18(indx) := rosetta_g_miss_num_map(t(ddindx).max_qty_per_order_id);
585 a19(indx) := rosetta_g_miss_num_map(t(ddindx).max_qty_per_customer_id);
586 a20(indx) := rosetta_g_miss_num_map(t(ddindx).max_qty_per_rule_id);
587 a21(indx) := rosetta_g_miss_num_map(t(ddindx).max_orders_per_customer_id);
588 a22(indx) := rosetta_g_miss_num_map(t(ddindx).max_amount_per_rule_id);
589 a23(indx) := t(ddindx).qd_arithmetic_operator;
590 a24(indx) := rosetta_g_miss_num_map(t(ddindx).qd_operand);
591 a25(indx) := t(ddindx).qd_estimated_qty_is_max;
592 a26(indx) := t(ddindx).qd_estimated_amount_is_max;
593 a27(indx) := rosetta_g_miss_num_map(t(ddindx).price_by_formula_id);
594 a28(indx) := t(ddindx).operation;
595 a29(indx) := rosetta_g_miss_num_map(t(ddindx).benefit_price_list_line_id);
596 a30(indx) := t(ddindx).benefit_uom_code;
597 a31(indx) := rosetta_g_miss_num_map(t(ddindx).benefit_qty);
598 a32(indx) := t(ddindx).last_update_date;
599 a33(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
600 a34(indx) := t(ddindx).creation_date;
601 a35(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
602 a36(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
603 a37(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
604 a38(indx) := t(ddindx).start_date_active;
605 a39(indx) := t(ddindx).end_date_active;
606 a40(indx) := t(ddindx).attribute1;
607 a41(indx) := t(ddindx).attribute2;
608 a42(indx) := t(ddindx).attribute3;
609 a43(indx) := t(ddindx).attribute4;
610 a44(indx) := t(ddindx).attribute5;
611 a45(indx) := t(ddindx).attribute6;
612 a46(indx) := t(ddindx).attribute7;
613 a47(indx) := t(ddindx).attribute8;
614 a48(indx) := t(ddindx).attribute9;
615 a49(indx) := t(ddindx).attribute10;
616 a50(indx) := t(ddindx).attribute11;
617 a51(indx) := t(ddindx).attribute12;
618 a52(indx) := t(ddindx).attribute13;
619 a53(indx) := t(ddindx).attribute14;
620 a54(indx) := t(ddindx).attribute15;
621 a55(indx) := t(ddindx).context;
622 a56(indx) := t(ddindx).discount_end_date;
623 indx := indx+1;
624 if t.last =ddindx
625 then exit;
626 end if;
627 ddindx := t.next(ddindx);
628 end loop;
629 end if;
630 end if;
631 end rosetta_table_copy_out_p6;
632
633 procedure create_offer_adj_line(p_api_version_number NUMBER
634 , p_init_msg_list VARCHAR2
635 , p_commit VARCHAR2
636 , p_validation_level NUMBER
637 , x_return_status out nocopy VARCHAR2
638 , x_msg_count out nocopy NUMBER
639 , x_msg_data out nocopy VARCHAR2
640 , x_offer_adjustment_line_id out nocopy NUMBER
641 , p7_a0 NUMBER := 0-1962.0724
642 , p7_a1 NUMBER := 0-1962.0724
643 , p7_a2 NUMBER := 0-1962.0724
644 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
645 , p7_a4 NUMBER := 0-1962.0724
646 , p7_a5 NUMBER := 0-1962.0724
647 , p7_a6 DATE := fnd_api.g_miss_date
648 , p7_a7 NUMBER := 0-1962.0724
649 , p7_a8 DATE := fnd_api.g_miss_date
650 , p7_a9 NUMBER := 0-1962.0724
651 , p7_a10 NUMBER := 0-1962.0724
652 , p7_a11 NUMBER := 0-1962.0724
653 , p7_a12 NUMBER := 0-1962.0724
654 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
655 , p7_a14 NUMBER := 0-1962.0724
656 , p7_a15 NUMBER := 0-1962.0724
657 , p7_a16 NUMBER := 0-1962.0724
658 , p7_a17 NUMBER := 0-1962.0724
659 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
660 , p7_a19 DATE := fnd_api.g_miss_date
661 )
662
663 as
664 ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
665 ddindx binary_integer; indx binary_integer;
666 begin
667
668 -- copy data to the local IN or IN-OUT args, if any
669
670
671
672
673
674
675
676 ddp_offadj_line_rec.offer_adjustment_line_id := rosetta_g_miss_num_map(p7_a0);
677 ddp_offadj_line_rec.offer_adjustment_id := rosetta_g_miss_num_map(p7_a1);
678 ddp_offadj_line_rec.list_line_id := rosetta_g_miss_num_map(p7_a2);
679 ddp_offadj_line_rec.arithmetic_operator := p7_a3;
680 ddp_offadj_line_rec.original_discount := rosetta_g_miss_num_map(p7_a4);
681 ddp_offadj_line_rec.modified_discount := rosetta_g_miss_num_map(p7_a5);
682 ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a6);
683 ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a7);
684 ddp_offadj_line_rec.creation_date := rosetta_g_miss_date_in_map(p7_a8);
685 ddp_offadj_line_rec.created_by := rosetta_g_miss_num_map(p7_a9);
686 ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a10);
687 ddp_offadj_line_rec.object_version_number := rosetta_g_miss_num_map(p7_a11);
688 ddp_offadj_line_rec.list_header_id := rosetta_g_miss_num_map(p7_a12);
689 ddp_offadj_line_rec.accrual_flag := p7_a13;
690 ddp_offadj_line_rec.list_line_id_td := rosetta_g_miss_num_map(p7_a14);
691 ddp_offadj_line_rec.original_discount_td := rosetta_g_miss_num_map(p7_a15);
692 ddp_offadj_line_rec.modified_discount_td := rosetta_g_miss_num_map(p7_a16);
693 ddp_offadj_line_rec.quantity := rosetta_g_miss_num_map(p7_a17);
694 ddp_offadj_line_rec.created_from_adjustments := p7_a18;
695 ddp_offadj_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p7_a19);
696
697
698 -- here's the delegated call to the old PL/SQL routine
699 ozf_offer_adj_line_pvt.create_offer_adj_line(p_api_version_number,
700 p_init_msg_list,
701 p_commit,
702 p_validation_level,
703 x_return_status,
704 x_msg_count,
705 x_msg_data,
706 ddp_offadj_line_rec,
707 x_offer_adjustment_line_id);
708
709 -- copy data back from the local variables to OUT or IN-OUT args, if any
710
711
712
713
714
715
716
717
718 end;
719
720 procedure create_new_offer_adj_line(p_api_version_number NUMBER
721 , p_init_msg_list VARCHAR2
722 , p_commit VARCHAR2
723 , p_validation_level NUMBER
724 , x_return_status out nocopy VARCHAR2
725 , x_msg_count out nocopy NUMBER
726 , x_msg_data out nocopy VARCHAR2
727 , x_offer_adjustment_line_id out nocopy NUMBER
728 , p7_a0 NUMBER := 0-1962.0724
729 , p7_a1 NUMBER := 0-1962.0724
730 , p7_a2 NUMBER := 0-1962.0724
731 , p7_a3 NUMBER := 0-1962.0724
732 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
733 , p7_a5 NUMBER := 0-1962.0724
734 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
735 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
736 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
737 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
738 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
739 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
740 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
741 , p7_a13 NUMBER := 0-1962.0724
742 , p7_a14 NUMBER := 0-1962.0724
743 , p7_a15 NUMBER := 0-1962.0724
744 , p7_a16 NUMBER := 0-1962.0724
745 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
746 , p7_a18 NUMBER := 0-1962.0724
747 , p7_a19 NUMBER := 0-1962.0724
748 , p7_a20 NUMBER := 0-1962.0724
749 , p7_a21 NUMBER := 0-1962.0724
750 , p7_a22 NUMBER := 0-1962.0724
751 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
752 , p7_a24 NUMBER := 0-1962.0724
753 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
754 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
755 , p7_a27 NUMBER := 0-1962.0724
756 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
757 , p7_a29 NUMBER := 0-1962.0724
758 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
759 , p7_a31 NUMBER := 0-1962.0724
760 , p7_a32 DATE := fnd_api.g_miss_date
761 , p7_a33 NUMBER := 0-1962.0724
762 , p7_a34 DATE := fnd_api.g_miss_date
763 , p7_a35 NUMBER := 0-1962.0724
764 , p7_a36 NUMBER := 0-1962.0724
765 , p7_a37 NUMBER := 0-1962.0724
766 , p7_a38 DATE := fnd_api.g_miss_date
767 , p7_a39 DATE := fnd_api.g_miss_date
768 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
769 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
770 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
771 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
772 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
773 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
774 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
775 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
776 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
777 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
778 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
779 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
780 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
781 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
782 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
783 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
784 , p7_a56 DATE := fnd_api.g_miss_date
785 )
786
787 as
788 ddp_list_line_rec ozf_offer_adj_line_pvt.offadj_new_line_rec_type;
789 ddindx binary_integer; indx binary_integer;
790 begin
791
792 -- copy data to the local IN or IN-OUT args, if any
793
794
795
796
797
798
799
800 ddp_list_line_rec.offer_adjustment_line_id := rosetta_g_miss_num_map(p7_a0);
801 ddp_list_line_rec.offer_adjustment_id := rosetta_g_miss_num_map(p7_a1);
802 ddp_list_line_rec.list_header_id := rosetta_g_miss_num_map(p7_a2);
803 ddp_list_line_rec.list_line_id := rosetta_g_miss_num_map(p7_a3);
804 ddp_list_line_rec.list_line_type_code := p7_a4;
805 ddp_list_line_rec.operand := rosetta_g_miss_num_map(p7_a5);
806 ddp_list_line_rec.arithmetic_operator := p7_a6;
807 ddp_list_line_rec.product_attr := p7_a7;
808 ddp_list_line_rec.product_attr_val := p7_a8;
809 ddp_list_line_rec.product_uom_code := p7_a9;
810 ddp_list_line_rec.pricing_attr := p7_a10;
811 ddp_list_line_rec.pricing_attr_value_from := p7_a11;
812 ddp_list_line_rec.pricing_attr_value_to := p7_a12;
813 ddp_list_line_rec.pricing_attribute_id := rosetta_g_miss_num_map(p7_a13);
814 ddp_list_line_rec.order_value_from := rosetta_g_miss_num_map(p7_a14);
815 ddp_list_line_rec.order_value_to := rosetta_g_miss_num_map(p7_a15);
816 ddp_list_line_rec.qualifier_id := rosetta_g_miss_num_map(p7_a16);
817 ddp_list_line_rec.inactive_flag := p7_a17;
818 ddp_list_line_rec.max_qty_per_order_id := rosetta_g_miss_num_map(p7_a18);
819 ddp_list_line_rec.max_qty_per_customer_id := rosetta_g_miss_num_map(p7_a19);
820 ddp_list_line_rec.max_qty_per_rule_id := rosetta_g_miss_num_map(p7_a20);
821 ddp_list_line_rec.max_orders_per_customer_id := rosetta_g_miss_num_map(p7_a21);
822 ddp_list_line_rec.max_amount_per_rule_id := rosetta_g_miss_num_map(p7_a22);
823 ddp_list_line_rec.qd_arithmetic_operator := p7_a23;
824 ddp_list_line_rec.qd_operand := rosetta_g_miss_num_map(p7_a24);
825 ddp_list_line_rec.qd_estimated_qty_is_max := p7_a25;
826 ddp_list_line_rec.qd_estimated_amount_is_max := p7_a26;
827 ddp_list_line_rec.price_by_formula_id := rosetta_g_miss_num_map(p7_a27);
828 ddp_list_line_rec.operation := p7_a28;
829 ddp_list_line_rec.benefit_price_list_line_id := rosetta_g_miss_num_map(p7_a29);
830 ddp_list_line_rec.benefit_uom_code := p7_a30;
831 ddp_list_line_rec.benefit_qty := rosetta_g_miss_num_map(p7_a31);
832 ddp_list_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a32);
833 ddp_list_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a33);
834 ddp_list_line_rec.creation_date := rosetta_g_miss_date_in_map(p7_a34);
835 ddp_list_line_rec.created_by := rosetta_g_miss_num_map(p7_a35);
836 ddp_list_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a36);
837 ddp_list_line_rec.object_version_number := rosetta_g_miss_num_map(p7_a37);
838 ddp_list_line_rec.start_date_active := rosetta_g_miss_date_in_map(p7_a38);
839 ddp_list_line_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a39);
840 ddp_list_line_rec.attribute1 := p7_a40;
841 ddp_list_line_rec.attribute2 := p7_a41;
842 ddp_list_line_rec.attribute3 := p7_a42;
843 ddp_list_line_rec.attribute4 := p7_a43;
844 ddp_list_line_rec.attribute5 := p7_a44;
845 ddp_list_line_rec.attribute6 := p7_a45;
846 ddp_list_line_rec.attribute7 := p7_a46;
847 ddp_list_line_rec.attribute8 := p7_a47;
848 ddp_list_line_rec.attribute9 := p7_a48;
849 ddp_list_line_rec.attribute10 := p7_a49;
850 ddp_list_line_rec.attribute11 := p7_a50;
851 ddp_list_line_rec.attribute12 := p7_a51;
852 ddp_list_line_rec.attribute13 := p7_a52;
853 ddp_list_line_rec.attribute14 := p7_a53;
854 ddp_list_line_rec.attribute15 := p7_a54;
855 ddp_list_line_rec.context := p7_a55;
856 ddp_list_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p7_a56);
857
858
859 -- here's the delegated call to the old PL/SQL routine
860 ozf_offer_adj_line_pvt.create_new_offer_adj_line(p_api_version_number,
861 p_init_msg_list,
862 p_commit,
863 p_validation_level,
864 x_return_status,
865 x_msg_count,
866 x_msg_data,
867 ddp_list_line_rec,
868 x_offer_adjustment_line_id);
869
870 -- copy data back from the local variables to OUT or IN-OUT args, if any
871
872
873
874
875
876
877
878
879 end;
880
881 procedure update_offer_adj_line(p_api_version_number NUMBER
882 , p_init_msg_list VARCHAR2
883 , p_commit VARCHAR2
884 , p_validation_level NUMBER
885 , x_return_status out nocopy VARCHAR2
886 , x_msg_count out nocopy NUMBER
887 , x_msg_data out nocopy VARCHAR2
888 , x_object_version_number out nocopy NUMBER
889 , p7_a0 NUMBER := 0-1962.0724
890 , p7_a1 NUMBER := 0-1962.0724
891 , p7_a2 NUMBER := 0-1962.0724
892 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
893 , p7_a4 NUMBER := 0-1962.0724
894 , p7_a5 NUMBER := 0-1962.0724
895 , p7_a6 DATE := fnd_api.g_miss_date
896 , p7_a7 NUMBER := 0-1962.0724
897 , p7_a8 DATE := fnd_api.g_miss_date
898 , p7_a9 NUMBER := 0-1962.0724
899 , p7_a10 NUMBER := 0-1962.0724
900 , p7_a11 NUMBER := 0-1962.0724
901 , p7_a12 NUMBER := 0-1962.0724
902 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
903 , p7_a14 NUMBER := 0-1962.0724
904 , p7_a15 NUMBER := 0-1962.0724
905 , p7_a16 NUMBER := 0-1962.0724
906 , p7_a17 NUMBER := 0-1962.0724
907 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
908 , p7_a19 DATE := fnd_api.g_miss_date
909 )
910
911 as
912 ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
913 ddindx binary_integer; indx binary_integer;
914 begin
915
916 -- copy data to the local IN or IN-OUT args, if any
917
918
919
920
921
922
923
924 ddp_offadj_line_rec.offer_adjustment_line_id := rosetta_g_miss_num_map(p7_a0);
925 ddp_offadj_line_rec.offer_adjustment_id := rosetta_g_miss_num_map(p7_a1);
926 ddp_offadj_line_rec.list_line_id := rosetta_g_miss_num_map(p7_a2);
927 ddp_offadj_line_rec.arithmetic_operator := p7_a3;
928 ddp_offadj_line_rec.original_discount := rosetta_g_miss_num_map(p7_a4);
929 ddp_offadj_line_rec.modified_discount := rosetta_g_miss_num_map(p7_a5);
930 ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a6);
931 ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a7);
932 ddp_offadj_line_rec.creation_date := rosetta_g_miss_date_in_map(p7_a8);
933 ddp_offadj_line_rec.created_by := rosetta_g_miss_num_map(p7_a9);
934 ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a10);
935 ddp_offadj_line_rec.object_version_number := rosetta_g_miss_num_map(p7_a11);
936 ddp_offadj_line_rec.list_header_id := rosetta_g_miss_num_map(p7_a12);
937 ddp_offadj_line_rec.accrual_flag := p7_a13;
938 ddp_offadj_line_rec.list_line_id_td := rosetta_g_miss_num_map(p7_a14);
939 ddp_offadj_line_rec.original_discount_td := rosetta_g_miss_num_map(p7_a15);
940 ddp_offadj_line_rec.modified_discount_td := rosetta_g_miss_num_map(p7_a16);
941 ddp_offadj_line_rec.quantity := rosetta_g_miss_num_map(p7_a17);
942 ddp_offadj_line_rec.created_from_adjustments := p7_a18;
943 ddp_offadj_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p7_a19);
944
945
946 -- here's the delegated call to the old PL/SQL routine
947 ozf_offer_adj_line_pvt.update_offer_adj_line(p_api_version_number,
948 p_init_msg_list,
949 p_commit,
950 p_validation_level,
951 x_return_status,
952 x_msg_count,
953 x_msg_data,
954 ddp_offadj_line_rec,
955 x_object_version_number);
956
957 -- copy data back from the local variables to OUT or IN-OUT args, if any
958
959
960
961
962
963
964
965
966 end;
967
968 procedure update_new_offer_adj_line(p_api_version_number NUMBER
969 , p_init_msg_list VARCHAR2
970 , p_commit VARCHAR2
971 , p_validation_level NUMBER
972 , x_return_status out nocopy VARCHAR2
973 , x_msg_count out nocopy NUMBER
974 , x_msg_data out nocopy VARCHAR2
975 , x_object_version_number out nocopy NUMBER
976 , p7_a0 NUMBER := 0-1962.0724
977 , p7_a1 NUMBER := 0-1962.0724
978 , p7_a2 NUMBER := 0-1962.0724
979 , p7_a3 NUMBER := 0-1962.0724
980 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
981 , p7_a5 NUMBER := 0-1962.0724
982 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
983 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
984 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
985 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
986 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
987 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
988 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
989 , p7_a13 NUMBER := 0-1962.0724
990 , p7_a14 NUMBER := 0-1962.0724
991 , p7_a15 NUMBER := 0-1962.0724
992 , p7_a16 NUMBER := 0-1962.0724
993 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
994 , p7_a18 NUMBER := 0-1962.0724
995 , p7_a19 NUMBER := 0-1962.0724
996 , p7_a20 NUMBER := 0-1962.0724
997 , p7_a21 NUMBER := 0-1962.0724
998 , p7_a22 NUMBER := 0-1962.0724
999 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1000 , p7_a24 NUMBER := 0-1962.0724
1001 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1002 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1003 , p7_a27 NUMBER := 0-1962.0724
1004 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1005 , p7_a29 NUMBER := 0-1962.0724
1006 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
1007 , p7_a31 NUMBER := 0-1962.0724
1008 , p7_a32 DATE := fnd_api.g_miss_date
1009 , p7_a33 NUMBER := 0-1962.0724
1010 , p7_a34 DATE := fnd_api.g_miss_date
1011 , p7_a35 NUMBER := 0-1962.0724
1012 , p7_a36 NUMBER := 0-1962.0724
1013 , p7_a37 NUMBER := 0-1962.0724
1014 , p7_a38 DATE := fnd_api.g_miss_date
1015 , p7_a39 DATE := fnd_api.g_miss_date
1016 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
1017 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
1018 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
1019 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
1020 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
1021 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
1022 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
1023 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
1024 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
1025 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
1026 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
1027 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
1028 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
1029 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
1030 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
1031 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
1032 , p7_a56 DATE := fnd_api.g_miss_date
1033 )
1034
1035 as
1036 ddp_list_line_rec ozf_offer_adj_line_pvt.offadj_new_line_rec_type;
1037 ddindx binary_integer; indx binary_integer;
1038 begin
1039 ozf_utility_pvt.debug_message('EndDateActive in Rosetta:'||p7_a56);
1040 -- copy data to the local IN or IN-OUT args, if any
1041
1042
1043
1044
1045
1046
1047
1048 ddp_list_line_rec.offer_adjustment_line_id := rosetta_g_miss_num_map(p7_a0);
1049 ddp_list_line_rec.offer_adjustment_id := rosetta_g_miss_num_map(p7_a1);
1050 ddp_list_line_rec.list_header_id := rosetta_g_miss_num_map(p7_a2);
1051 ddp_list_line_rec.list_line_id := rosetta_g_miss_num_map(p7_a3);
1052 ddp_list_line_rec.list_line_type_code := p7_a4;
1053 ddp_list_line_rec.operand := rosetta_g_miss_num_map(p7_a5);
1054 ddp_list_line_rec.arithmetic_operator := p7_a6;
1055 ddp_list_line_rec.product_attr := p7_a7;
1056 ddp_list_line_rec.product_attr_val := p7_a8;
1057 ddp_list_line_rec.product_uom_code := p7_a9;
1058 ddp_list_line_rec.pricing_attr := p7_a10;
1059 ddp_list_line_rec.pricing_attr_value_from := p7_a11;
1060 ddp_list_line_rec.pricing_attr_value_to := p7_a12;
1061 ddp_list_line_rec.pricing_attribute_id := rosetta_g_miss_num_map(p7_a13);
1062 ddp_list_line_rec.order_value_from := rosetta_g_miss_num_map(p7_a14);
1063 ddp_list_line_rec.order_value_to := rosetta_g_miss_num_map(p7_a15);
1064 ddp_list_line_rec.qualifier_id := rosetta_g_miss_num_map(p7_a16);
1065 ddp_list_line_rec.inactive_flag := p7_a17;
1066 ddp_list_line_rec.max_qty_per_order_id := rosetta_g_miss_num_map(p7_a18);
1067 ddp_list_line_rec.max_qty_per_customer_id := rosetta_g_miss_num_map(p7_a19);
1068 ddp_list_line_rec.max_qty_per_rule_id := rosetta_g_miss_num_map(p7_a20);
1069 ddp_list_line_rec.max_orders_per_customer_id := rosetta_g_miss_num_map(p7_a21);
1070 ddp_list_line_rec.max_amount_per_rule_id := rosetta_g_miss_num_map(p7_a22);
1071 ddp_list_line_rec.qd_arithmetic_operator := p7_a23;
1072 ddp_list_line_rec.qd_operand := rosetta_g_miss_num_map(p7_a24);
1073 ddp_list_line_rec.qd_estimated_qty_is_max := p7_a25;
1074 ddp_list_line_rec.qd_estimated_amount_is_max := p7_a26;
1075 ddp_list_line_rec.price_by_formula_id := rosetta_g_miss_num_map(p7_a27);
1076 ddp_list_line_rec.operation := p7_a28;
1077 ddp_list_line_rec.benefit_price_list_line_id := rosetta_g_miss_num_map(p7_a29);
1078 ddp_list_line_rec.benefit_uom_code := p7_a30;
1079 ddp_list_line_rec.benefit_qty := rosetta_g_miss_num_map(p7_a31);
1080 ddp_list_line_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a32);
1081 ddp_list_line_rec.last_updated_by := rosetta_g_miss_num_map(p7_a33);
1082 ddp_list_line_rec.creation_date := rosetta_g_miss_date_in_map(p7_a34);
1083 ddp_list_line_rec.created_by := rosetta_g_miss_num_map(p7_a35);
1084 ddp_list_line_rec.last_update_login := rosetta_g_miss_num_map(p7_a36);
1085 ddp_list_line_rec.object_version_number := rosetta_g_miss_num_map(p7_a37);
1086 ddp_list_line_rec.start_date_active := rosetta_g_miss_date_in_map(p7_a38);
1087 ddp_list_line_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a39);
1088 ddp_list_line_rec.attribute1 := p7_a40;
1089 ddp_list_line_rec.attribute2 := p7_a41;
1090 ddp_list_line_rec.attribute3 := p7_a42;
1091 ddp_list_line_rec.attribute4 := p7_a43;
1092 ddp_list_line_rec.attribute5 := p7_a44;
1093 ddp_list_line_rec.attribute6 := p7_a45;
1094 ddp_list_line_rec.attribute7 := p7_a46;
1095 ddp_list_line_rec.attribute8 := p7_a47;
1096 ddp_list_line_rec.attribute9 := p7_a48;
1097 ddp_list_line_rec.attribute10 := p7_a49;
1098 ddp_list_line_rec.attribute11 := p7_a50;
1099 ddp_list_line_rec.attribute12 := p7_a51;
1100 ddp_list_line_rec.attribute13 := p7_a52;
1101 ddp_list_line_rec.attribute14 := p7_a53;
1102 ddp_list_line_rec.attribute15 := p7_a54;
1103 ddp_list_line_rec.context := p7_a55;
1104 ddp_list_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p7_a56);
1105
1106
1107 -- here's the delegated call to the old PL/SQL routine
1108 ozf_offer_adj_line_pvt.update_new_offer_adj_line(p_api_version_number,
1109 p_init_msg_list,
1110 p_commit,
1111 p_validation_level,
1112 x_return_status,
1113 x_msg_count,
1114 x_msg_data,
1115 ddp_list_line_rec,
1116 x_object_version_number);
1117
1118 -- copy data back from the local variables to OUT or IN-OUT args, if any
1119
1120
1121
1122
1123
1124
1125
1126
1127 end;
1128
1129 procedure validate_offer_adj_line(p_api_version_number NUMBER
1130 , p_init_msg_list VARCHAR2
1131 , p_validation_level NUMBER
1132 , p_validation_mode VARCHAR2
1133 , x_return_status out nocopy VARCHAR2
1134 , x_msg_count out nocopy NUMBER
1135 , x_msg_data out nocopy VARCHAR2
1136 , p3_a0 NUMBER := 0-1962.0724
1137 , p3_a1 NUMBER := 0-1962.0724
1138 , p3_a2 NUMBER := 0-1962.0724
1139 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1140 , p3_a4 NUMBER := 0-1962.0724
1141 , p3_a5 NUMBER := 0-1962.0724
1142 , p3_a6 DATE := fnd_api.g_miss_date
1143 , p3_a7 NUMBER := 0-1962.0724
1144 , p3_a8 DATE := fnd_api.g_miss_date
1145 , p3_a9 NUMBER := 0-1962.0724
1146 , p3_a10 NUMBER := 0-1962.0724
1147 , p3_a11 NUMBER := 0-1962.0724
1148 , p3_a12 NUMBER := 0-1962.0724
1149 , p3_a13 VARCHAR2 := fnd_api.g_miss_char
1150 , p3_a14 NUMBER := 0-1962.0724
1151 , p3_a15 NUMBER := 0-1962.0724
1152 , p3_a16 NUMBER := 0-1962.0724
1153 , p3_a17 NUMBER := 0-1962.0724
1154 , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1155 , p3_a19 DATE := fnd_api.g_miss_date
1156 )
1157
1158 as
1159 ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
1160 ddindx binary_integer; indx binary_integer;
1161 begin
1162
1163 -- copy data to the local IN or IN-OUT args, if any
1164
1165
1166
1167 ddp_offadj_line_rec.offer_adjustment_line_id := rosetta_g_miss_num_map(p3_a0);
1168 ddp_offadj_line_rec.offer_adjustment_id := rosetta_g_miss_num_map(p3_a1);
1169 ddp_offadj_line_rec.list_line_id := rosetta_g_miss_num_map(p3_a2);
1170 ddp_offadj_line_rec.arithmetic_operator := p3_a3;
1171 ddp_offadj_line_rec.original_discount := rosetta_g_miss_num_map(p3_a4);
1172 ddp_offadj_line_rec.modified_discount := rosetta_g_miss_num_map(p3_a5);
1173 ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a6);
1174 ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p3_a7);
1175 ddp_offadj_line_rec.creation_date := rosetta_g_miss_date_in_map(p3_a8);
1176 ddp_offadj_line_rec.created_by := rosetta_g_miss_num_map(p3_a9);
1177 ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p3_a10);
1178 ddp_offadj_line_rec.object_version_number := rosetta_g_miss_num_map(p3_a11);
1179 ddp_offadj_line_rec.list_header_id := rosetta_g_miss_num_map(p3_a12);
1180 ddp_offadj_line_rec.accrual_flag := p3_a13;
1181 ddp_offadj_line_rec.list_line_id_td := rosetta_g_miss_num_map(p3_a14);
1182 ddp_offadj_line_rec.original_discount_td := rosetta_g_miss_num_map(p3_a15);
1183 ddp_offadj_line_rec.modified_discount_td := rosetta_g_miss_num_map(p3_a16);
1184 ddp_offadj_line_rec.quantity := rosetta_g_miss_num_map(p3_a17);
1185 ddp_offadj_line_rec.created_from_adjustments := p3_a18;
1186 ddp_offadj_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p3_a19);
1187
1188
1189
1190
1191
1192 -- here's the delegated call to the old PL/SQL routine
1193 ozf_offer_adj_line_pvt.validate_offer_adj_line(p_api_version_number,
1194 p_init_msg_list,
1195 p_validation_level,
1196 ddp_offadj_line_rec,
1197 p_validation_mode,
1198 x_return_status,
1199 x_msg_count,
1200 x_msg_data);
1201
1202 -- copy data back from the local variables to OUT or IN-OUT args, if any
1203
1204
1205
1206
1207
1208
1209
1210 end;
1211
1212 procedure check_offadj_line_items(p_validation_mode VARCHAR2
1213 , x_return_status out nocopy VARCHAR2
1214 , p0_a0 NUMBER := 0-1962.0724
1215 , p0_a1 NUMBER := 0-1962.0724
1216 , p0_a2 NUMBER := 0-1962.0724
1217 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1218 , p0_a4 NUMBER := 0-1962.0724
1219 , p0_a5 NUMBER := 0-1962.0724
1220 , p0_a6 DATE := fnd_api.g_miss_date
1221 , p0_a7 NUMBER := 0-1962.0724
1222 , p0_a8 DATE := fnd_api.g_miss_date
1223 , p0_a9 NUMBER := 0-1962.0724
1224 , p0_a10 NUMBER := 0-1962.0724
1225 , p0_a11 NUMBER := 0-1962.0724
1226 , p0_a12 NUMBER := 0-1962.0724
1227 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1228 , p0_a14 NUMBER := 0-1962.0724
1229 , p0_a15 NUMBER := 0-1962.0724
1230 , p0_a16 NUMBER := 0-1962.0724
1231 , p0_a17 NUMBER := 0-1962.0724
1232 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1233 , p0_a19 DATE := fnd_api.g_miss_date
1234 )
1235
1236 as
1237 ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
1238 ddindx binary_integer; indx binary_integer;
1239 begin
1240
1241 -- copy data to the local IN or IN-OUT args, if any
1242 ddp_offadj_line_rec.offer_adjustment_line_id := rosetta_g_miss_num_map(p0_a0);
1243 ddp_offadj_line_rec.offer_adjustment_id := rosetta_g_miss_num_map(p0_a1);
1244 ddp_offadj_line_rec.list_line_id := rosetta_g_miss_num_map(p0_a2);
1245 ddp_offadj_line_rec.arithmetic_operator := p0_a3;
1246 ddp_offadj_line_rec.original_discount := rosetta_g_miss_num_map(p0_a4);
1247 ddp_offadj_line_rec.modified_discount := rosetta_g_miss_num_map(p0_a5);
1248 ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a6);
1249 ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p0_a7);
1250 ddp_offadj_line_rec.creation_date := rosetta_g_miss_date_in_map(p0_a8);
1251 ddp_offadj_line_rec.created_by := rosetta_g_miss_num_map(p0_a9);
1252 ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p0_a10);
1253 ddp_offadj_line_rec.object_version_number := rosetta_g_miss_num_map(p0_a11);
1254 ddp_offadj_line_rec.list_header_id := rosetta_g_miss_num_map(p0_a12);
1255 ddp_offadj_line_rec.accrual_flag := p0_a13;
1256 ddp_offadj_line_rec.list_line_id_td := rosetta_g_miss_num_map(p0_a14);
1257 ddp_offadj_line_rec.original_discount_td := rosetta_g_miss_num_map(p0_a15);
1258 ddp_offadj_line_rec.modified_discount_td := rosetta_g_miss_num_map(p0_a16);
1259 ddp_offadj_line_rec.quantity := rosetta_g_miss_num_map(p0_a17);
1260 ddp_offadj_line_rec.created_from_adjustments := p0_a18;
1261 ddp_offadj_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p0_a19);
1262
1263
1264
1265 -- here's the delegated call to the old PL/SQL routine
1266 ozf_offer_adj_line_pvt.check_offadj_line_items(ddp_offadj_line_rec,
1267 p_validation_mode,
1268 x_return_status);
1269
1270 -- copy data back from the local variables to OUT or IN-OUT args, if any
1271
1272
1273 end;
1274
1275 procedure validate_offadj_line_rec(p_api_version_number NUMBER
1276 , p_init_msg_list VARCHAR2
1277 , x_return_status out nocopy VARCHAR2
1278 , x_msg_count out nocopy NUMBER
1279 , x_msg_data out nocopy VARCHAR2
1280 , p5_a0 NUMBER := 0-1962.0724
1281 , p5_a1 NUMBER := 0-1962.0724
1282 , p5_a2 NUMBER := 0-1962.0724
1283 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1284 , p5_a4 NUMBER := 0-1962.0724
1285 , p5_a5 NUMBER := 0-1962.0724
1286 , p5_a6 DATE := fnd_api.g_miss_date
1287 , p5_a7 NUMBER := 0-1962.0724
1288 , p5_a8 DATE := fnd_api.g_miss_date
1289 , p5_a9 NUMBER := 0-1962.0724
1290 , p5_a10 NUMBER := 0-1962.0724
1291 , p5_a11 NUMBER := 0-1962.0724
1292 , p5_a12 NUMBER := 0-1962.0724
1293 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1294 , p5_a14 NUMBER := 0-1962.0724
1295 , p5_a15 NUMBER := 0-1962.0724
1296 , p5_a16 NUMBER := 0-1962.0724
1297 , p5_a17 NUMBER := 0-1962.0724
1298 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1299 , p5_a19 DATE := fnd_api.g_miss_date
1300 )
1301
1302 as
1303 ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
1304 ddindx binary_integer; indx binary_integer;
1305 begin
1306
1307 -- copy data to the local IN or IN-OUT args, if any
1308
1309
1310
1311
1312
1313 ddp_offadj_line_rec.offer_adjustment_line_id := rosetta_g_miss_num_map(p5_a0);
1314 ddp_offadj_line_rec.offer_adjustment_id := rosetta_g_miss_num_map(p5_a1);
1315 ddp_offadj_line_rec.list_line_id := rosetta_g_miss_num_map(p5_a2);
1316 ddp_offadj_line_rec.arithmetic_operator := p5_a3;
1317 ddp_offadj_line_rec.original_discount := rosetta_g_miss_num_map(p5_a4);
1318 ddp_offadj_line_rec.modified_discount := rosetta_g_miss_num_map(p5_a5);
1319 ddp_offadj_line_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a6);
1320 ddp_offadj_line_rec.last_updated_by := rosetta_g_miss_num_map(p5_a7);
1321 ddp_offadj_line_rec.creation_date := rosetta_g_miss_date_in_map(p5_a8);
1322 ddp_offadj_line_rec.created_by := rosetta_g_miss_num_map(p5_a9);
1323 ddp_offadj_line_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
1324 ddp_offadj_line_rec.object_version_number := rosetta_g_miss_num_map(p5_a11);
1325 ddp_offadj_line_rec.list_header_id := rosetta_g_miss_num_map(p5_a12);
1326 ddp_offadj_line_rec.accrual_flag := p5_a13;
1327 ddp_offadj_line_rec.list_line_id_td := rosetta_g_miss_num_map(p5_a14);
1328 ddp_offadj_line_rec.original_discount_td := rosetta_g_miss_num_map(p5_a15);
1329 ddp_offadj_line_rec.modified_discount_td := rosetta_g_miss_num_map(p5_a16);
1330 ddp_offadj_line_rec.quantity := rosetta_g_miss_num_map(p5_a17);
1331 ddp_offadj_line_rec.created_from_adjustments := p5_a18;
1332 ddp_offadj_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p5_a19);
1333
1334 -- here's the delegated call to the old PL/SQL routine
1335 ozf_offer_adj_line_pvt.validate_offadj_line_rec(p_api_version_number,
1336 p_init_msg_list,
1337 x_return_status,
1338 x_msg_count,
1339 x_msg_data,
1340 ddp_offadj_line_rec);
1341
1342 -- copy data back from the local variables to OUT or IN-OUT args, if any
1343
1344
1345
1346
1347
1348 end;
1349
1350 end ozf_offer_adj_line_pvt_w;