[Home] [Help]
PACKAGE BODY: APPS.OZF_OFFER_PERFORMANCE_PVT_W
Source
1 package body ozf_offer_performance_pvt_w as
2 /* $Header: ozfwperb.pls 120.1 2005/10/04 20:48 julou 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_p3(t out nocopy ozf_offer_performance_pvt.offer_perf_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_DATE_TABLE
25 , a3 JTF_NUMBER_TABLE
26 , a4 JTF_DATE_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_NUMBER_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_VARCHAR2_TABLE_100
31 , a9 JTF_VARCHAR2_TABLE_100
32 , a10 JTF_VARCHAR2_TABLE_300
33 , a11 JTF_NUMBER_TABLE
34 , a12 JTF_DATE_TABLE
35 , a13 JTF_DATE_TABLE
36 , a14 JTF_NUMBER_TABLE
37 , a15 JTF_VARCHAR2_TABLE_100
38 , a16 JTF_VARCHAR2_TABLE_100
39 , a17 JTF_VARCHAR2_TABLE_200
40 , a18 JTF_VARCHAR2_TABLE_200
41 , a19 JTF_VARCHAR2_TABLE_200
42 , a20 JTF_VARCHAR2_TABLE_200
43 , a21 JTF_VARCHAR2_TABLE_200
44 , a22 JTF_VARCHAR2_TABLE_200
45 , a23 JTF_VARCHAR2_TABLE_200
46 , a24 JTF_VARCHAR2_TABLE_200
47 , a25 JTF_VARCHAR2_TABLE_200
48 , a26 JTF_VARCHAR2_TABLE_200
49 , a27 JTF_VARCHAR2_TABLE_200
50 , a28 JTF_VARCHAR2_TABLE_200
51 , a29 JTF_VARCHAR2_TABLE_200
52 , a30 JTF_VARCHAR2_TABLE_200
53 , a31 JTF_VARCHAR2_TABLE_200
54 , a32 JTF_NUMBER_TABLE
55 , a33 JTF_VARCHAR2_TABLE_100
56 , a34 JTF_VARCHAR2_TABLE_100
57 , a35 JTF_VARCHAR2_TABLE_4000
58 ) as
59 ddindx binary_integer; indx binary_integer;
60 begin
61 if a0 is not null and a0.count > 0 then
62 if a0.count > 0 then
63 indx := a0.first;
64 ddindx := 1;
65 while true loop
66 t(ddindx).offer_performance_id := rosetta_g_miss_num_map(a0(indx));
67 t(ddindx).list_header_id := rosetta_g_miss_num_map(a1(indx));
68 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a2(indx));
69 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a3(indx));
70 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a4(indx));
71 t(ddindx).created_by := rosetta_g_miss_num_map(a5(indx));
72 t(ddindx).last_update_login := rosetta_g_miss_num_map(a6(indx));
73 t(ddindx).object_version_number := rosetta_g_miss_num_map(a7(indx));
74 t(ddindx).product_attribute_context := a8(indx);
75 t(ddindx).product_attribute := a9(indx);
76 t(ddindx).product_attr_value := a10(indx);
77 t(ddindx).channel_id := rosetta_g_miss_num_map(a11(indx));
78 t(ddindx).start_date := rosetta_g_miss_date_in_map(a12(indx));
79 t(ddindx).end_date := rosetta_g_miss_date_in_map(a13(indx));
80 t(ddindx).estimated_value := rosetta_g_miss_num_map(a14(indx));
81 t(ddindx).required_flag := a15(indx);
82 t(ddindx).attribute_category := a16(indx);
83 t(ddindx).attribute1 := a17(indx);
84 t(ddindx).attribute2 := a18(indx);
85 t(ddindx).attribute3 := a19(indx);
86 t(ddindx).attribute4 := a20(indx);
87 t(ddindx).attribute5 := a21(indx);
88 t(ddindx).attribute6 := a22(indx);
89 t(ddindx).attribute7 := a23(indx);
90 t(ddindx).attribute8 := a24(indx);
91 t(ddindx).attribute9 := a25(indx);
92 t(ddindx).attribute10 := a26(indx);
93 t(ddindx).attribute11 := a27(indx);
94 t(ddindx).attribute12 := a28(indx);
95 t(ddindx).attribute13 := a29(indx);
96 t(ddindx).attribute14 := a30(indx);
97 t(ddindx).attribute15 := a31(indx);
98 t(ddindx).security_group_id := rosetta_g_miss_num_map(a32(indx));
99 t(ddindx).requirement_type := a33(indx);
100 t(ddindx).uom_code := a34(indx);
101 t(ddindx).description := a35(indx);
102 ddindx := ddindx+1;
103 if a0.last =indx
104 then exit;
105 end if;
106 indx := a0.next(indx);
107 end loop;
108 end if;
109 end if;
110 end rosetta_table_copy_in_p3;
111 procedure rosetta_table_copy_out_p3(t ozf_offer_performance_pvt.offer_perf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
112 , a1 out nocopy JTF_NUMBER_TABLE
113 , a2 out nocopy JTF_DATE_TABLE
114 , a3 out nocopy JTF_NUMBER_TABLE
115 , a4 out nocopy JTF_DATE_TABLE
116 , a5 out nocopy JTF_NUMBER_TABLE
117 , a6 out nocopy JTF_NUMBER_TABLE
118 , a7 out nocopy JTF_NUMBER_TABLE
119 , a8 out nocopy JTF_VARCHAR2_TABLE_100
120 , a9 out nocopy JTF_VARCHAR2_TABLE_100
121 , a10 out nocopy JTF_VARCHAR2_TABLE_300
122 , a11 out nocopy JTF_NUMBER_TABLE
123 , a12 out nocopy JTF_DATE_TABLE
124 , a13 out nocopy JTF_DATE_TABLE
125 , a14 out nocopy JTF_NUMBER_TABLE
126 , a15 out nocopy JTF_VARCHAR2_TABLE_100
127 , a16 out nocopy JTF_VARCHAR2_TABLE_100
128 , a17 out nocopy JTF_VARCHAR2_TABLE_200
129 , a18 out nocopy JTF_VARCHAR2_TABLE_200
130 , a19 out nocopy JTF_VARCHAR2_TABLE_200
131 , a20 out nocopy JTF_VARCHAR2_TABLE_200
132 , a21 out nocopy JTF_VARCHAR2_TABLE_200
133 , a22 out nocopy JTF_VARCHAR2_TABLE_200
134 , a23 out nocopy JTF_VARCHAR2_TABLE_200
135 , a24 out nocopy JTF_VARCHAR2_TABLE_200
136 , a25 out nocopy JTF_VARCHAR2_TABLE_200
137 , a26 out nocopy JTF_VARCHAR2_TABLE_200
138 , a27 out nocopy JTF_VARCHAR2_TABLE_200
139 , a28 out nocopy JTF_VARCHAR2_TABLE_200
140 , a29 out nocopy JTF_VARCHAR2_TABLE_200
141 , a30 out nocopy JTF_VARCHAR2_TABLE_200
142 , a31 out nocopy JTF_VARCHAR2_TABLE_200
143 , a32 out nocopy JTF_NUMBER_TABLE
144 , a33 out nocopy JTF_VARCHAR2_TABLE_100
145 , a34 out nocopy JTF_VARCHAR2_TABLE_100
146 , a35 out nocopy JTF_VARCHAR2_TABLE_4000
147 ) as
148 ddindx binary_integer; indx binary_integer;
149 begin
150 if t is null or t.count = 0 then
151 a0 := JTF_NUMBER_TABLE();
152 a1 := JTF_NUMBER_TABLE();
153 a2 := JTF_DATE_TABLE();
154 a3 := JTF_NUMBER_TABLE();
155 a4 := JTF_DATE_TABLE();
156 a5 := JTF_NUMBER_TABLE();
157 a6 := JTF_NUMBER_TABLE();
158 a7 := JTF_NUMBER_TABLE();
159 a8 := JTF_VARCHAR2_TABLE_100();
160 a9 := JTF_VARCHAR2_TABLE_100();
161 a10 := JTF_VARCHAR2_TABLE_300();
162 a11 := JTF_NUMBER_TABLE();
163 a12 := JTF_DATE_TABLE();
164 a13 := JTF_DATE_TABLE();
165 a14 := JTF_NUMBER_TABLE();
166 a15 := JTF_VARCHAR2_TABLE_100();
167 a16 := JTF_VARCHAR2_TABLE_100();
168 a17 := JTF_VARCHAR2_TABLE_200();
169 a18 := JTF_VARCHAR2_TABLE_200();
170 a19 := JTF_VARCHAR2_TABLE_200();
171 a20 := JTF_VARCHAR2_TABLE_200();
172 a21 := JTF_VARCHAR2_TABLE_200();
173 a22 := JTF_VARCHAR2_TABLE_200();
174 a23 := JTF_VARCHAR2_TABLE_200();
175 a24 := JTF_VARCHAR2_TABLE_200();
176 a25 := JTF_VARCHAR2_TABLE_200();
177 a26 := JTF_VARCHAR2_TABLE_200();
178 a27 := JTF_VARCHAR2_TABLE_200();
179 a28 := JTF_VARCHAR2_TABLE_200();
180 a29 := JTF_VARCHAR2_TABLE_200();
181 a30 := JTF_VARCHAR2_TABLE_200();
182 a31 := JTF_VARCHAR2_TABLE_200();
183 a32 := JTF_NUMBER_TABLE();
184 a33 := JTF_VARCHAR2_TABLE_100();
185 a34 := JTF_VARCHAR2_TABLE_100();
186 a35 := JTF_VARCHAR2_TABLE_4000();
187 else
188 a0 := JTF_NUMBER_TABLE();
189 a1 := JTF_NUMBER_TABLE();
190 a2 := JTF_DATE_TABLE();
191 a3 := JTF_NUMBER_TABLE();
192 a4 := JTF_DATE_TABLE();
193 a5 := JTF_NUMBER_TABLE();
194 a6 := JTF_NUMBER_TABLE();
195 a7 := JTF_NUMBER_TABLE();
196 a8 := JTF_VARCHAR2_TABLE_100();
197 a9 := JTF_VARCHAR2_TABLE_100();
198 a10 := JTF_VARCHAR2_TABLE_300();
199 a11 := JTF_NUMBER_TABLE();
200 a12 := JTF_DATE_TABLE();
201 a13 := JTF_DATE_TABLE();
202 a14 := JTF_NUMBER_TABLE();
203 a15 := JTF_VARCHAR2_TABLE_100();
204 a16 := JTF_VARCHAR2_TABLE_100();
205 a17 := JTF_VARCHAR2_TABLE_200();
206 a18 := JTF_VARCHAR2_TABLE_200();
207 a19 := JTF_VARCHAR2_TABLE_200();
208 a20 := JTF_VARCHAR2_TABLE_200();
209 a21 := JTF_VARCHAR2_TABLE_200();
210 a22 := JTF_VARCHAR2_TABLE_200();
211 a23 := JTF_VARCHAR2_TABLE_200();
212 a24 := JTF_VARCHAR2_TABLE_200();
213 a25 := JTF_VARCHAR2_TABLE_200();
214 a26 := JTF_VARCHAR2_TABLE_200();
215 a27 := JTF_VARCHAR2_TABLE_200();
216 a28 := JTF_VARCHAR2_TABLE_200();
217 a29 := JTF_VARCHAR2_TABLE_200();
218 a30 := JTF_VARCHAR2_TABLE_200();
219 a31 := JTF_VARCHAR2_TABLE_200();
220 a32 := JTF_NUMBER_TABLE();
221 a33 := JTF_VARCHAR2_TABLE_100();
222 a34 := JTF_VARCHAR2_TABLE_100();
223 a35 := JTF_VARCHAR2_TABLE_4000();
224 if t.count > 0 then
225 a0.extend(t.count);
226 a1.extend(t.count);
227 a2.extend(t.count);
228 a3.extend(t.count);
229 a4.extend(t.count);
230 a5.extend(t.count);
231 a6.extend(t.count);
232 a7.extend(t.count);
233 a8.extend(t.count);
234 a9.extend(t.count);
235 a10.extend(t.count);
236 a11.extend(t.count);
237 a12.extend(t.count);
238 a13.extend(t.count);
239 a14.extend(t.count);
240 a15.extend(t.count);
241 a16.extend(t.count);
242 a17.extend(t.count);
243 a18.extend(t.count);
244 a19.extend(t.count);
245 a20.extend(t.count);
246 a21.extend(t.count);
247 a22.extend(t.count);
248 a23.extend(t.count);
249 a24.extend(t.count);
250 a25.extend(t.count);
251 a26.extend(t.count);
252 a27.extend(t.count);
253 a28.extend(t.count);
254 a29.extend(t.count);
255 a30.extend(t.count);
256 a31.extend(t.count);
257 a32.extend(t.count);
258 a33.extend(t.count);
259 a34.extend(t.count);
260 a35.extend(t.count);
261 ddindx := t.first;
262 indx := 1;
263 while true loop
264 a0(indx) := rosetta_g_miss_num_map(t(ddindx).offer_performance_id);
265 a1(indx) := rosetta_g_miss_num_map(t(ddindx).list_header_id);
266 a2(indx) := t(ddindx).last_update_date;
267 a3(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
268 a4(indx) := t(ddindx).creation_date;
269 a5(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
270 a6(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
271 a7(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
272 a8(indx) := t(ddindx).product_attribute_context;
273 a9(indx) := t(ddindx).product_attribute;
274 a10(indx) := t(ddindx).product_attr_value;
275 a11(indx) := rosetta_g_miss_num_map(t(ddindx).channel_id);
276 a12(indx) := t(ddindx).start_date;
277 a13(indx) := t(ddindx).end_date;
278 a14(indx) := rosetta_g_miss_num_map(t(ddindx).estimated_value);
279 a15(indx) := t(ddindx).required_flag;
280 a16(indx) := t(ddindx).attribute_category;
281 a17(indx) := t(ddindx).attribute1;
282 a18(indx) := t(ddindx).attribute2;
283 a19(indx) := t(ddindx).attribute3;
284 a20(indx) := t(ddindx).attribute4;
285 a21(indx) := t(ddindx).attribute5;
286 a22(indx) := t(ddindx).attribute6;
287 a23(indx) := t(ddindx).attribute7;
288 a24(indx) := t(ddindx).attribute8;
289 a25(indx) := t(ddindx).attribute9;
290 a26(indx) := t(ddindx).attribute10;
291 a27(indx) := t(ddindx).attribute11;
292 a28(indx) := t(ddindx).attribute12;
293 a29(indx) := t(ddindx).attribute13;
294 a30(indx) := t(ddindx).attribute14;
295 a31(indx) := t(ddindx).attribute15;
296 a32(indx) := rosetta_g_miss_num_map(t(ddindx).security_group_id);
297 a33(indx) := t(ddindx).requirement_type;
298 a34(indx) := t(ddindx).uom_code;
299 a35(indx) := t(ddindx).description;
300 indx := indx+1;
301 if t.last =ddindx
302 then exit;
303 end if;
304 ddindx := t.next(ddindx);
305 end loop;
306 end if;
307 end if;
308 end rosetta_table_copy_out_p3;
309
310 procedure create_offer_performance(p_api_version_number NUMBER
311 , p_init_msg_list VARCHAR2
312 , p_commit VARCHAR2
313 , p_validation_level NUMBER
314 , x_return_status out nocopy VARCHAR2
315 , x_msg_count out nocopy NUMBER
316 , x_msg_data out nocopy VARCHAR2
317 , x_offer_performance_id out nocopy NUMBER
318 , p7_a0 NUMBER := 0-1962.0724
319 , p7_a1 NUMBER := 0-1962.0724
320 , p7_a2 DATE := fnd_api.g_miss_date
321 , p7_a3 NUMBER := 0-1962.0724
322 , p7_a4 DATE := fnd_api.g_miss_date
323 , p7_a5 NUMBER := 0-1962.0724
324 , p7_a6 NUMBER := 0-1962.0724
325 , p7_a7 NUMBER := 0-1962.0724
326 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
327 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
328 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
329 , p7_a11 NUMBER := 0-1962.0724
330 , p7_a12 DATE := fnd_api.g_miss_date
331 , p7_a13 DATE := fnd_api.g_miss_date
332 , p7_a14 NUMBER := 0-1962.0724
333 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
334 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
335 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
336 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
337 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
338 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
339 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
340 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
341 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
342 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
343 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
344 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
345 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
346 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
347 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
348 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
349 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
350 , p7_a32 NUMBER := 0-1962.0724
351 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
352 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
353 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
354 )
355
356 as
357 ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;
358 ddindx binary_integer; indx binary_integer;
359 begin
360
361 -- copy data to the local IN or IN-OUT args, if any
362
363
364
365
366
367
368
369 ddp_offer_perf_rec.offer_performance_id := rosetta_g_miss_num_map(p7_a0);
370 ddp_offer_perf_rec.list_header_id := rosetta_g_miss_num_map(p7_a1);
371 ddp_offer_perf_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
372 ddp_offer_perf_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
373 ddp_offer_perf_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
374 ddp_offer_perf_rec.created_by := rosetta_g_miss_num_map(p7_a5);
375 ddp_offer_perf_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
376 ddp_offer_perf_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
377 ddp_offer_perf_rec.product_attribute_context := p7_a8;
378 ddp_offer_perf_rec.product_attribute := p7_a9;
379 ddp_offer_perf_rec.product_attr_value := p7_a10;
380 ddp_offer_perf_rec.channel_id := rosetta_g_miss_num_map(p7_a11);
381 ddp_offer_perf_rec.start_date := rosetta_g_miss_date_in_map(p7_a12);
382 ddp_offer_perf_rec.end_date := rosetta_g_miss_date_in_map(p7_a13);
383 ddp_offer_perf_rec.estimated_value := rosetta_g_miss_num_map(p7_a14);
384 ddp_offer_perf_rec.required_flag := p7_a15;
385 ddp_offer_perf_rec.attribute_category := p7_a16;
386 ddp_offer_perf_rec.attribute1 := p7_a17;
387 ddp_offer_perf_rec.attribute2 := p7_a18;
388 ddp_offer_perf_rec.attribute3 := p7_a19;
389 ddp_offer_perf_rec.attribute4 := p7_a20;
390 ddp_offer_perf_rec.attribute5 := p7_a21;
391 ddp_offer_perf_rec.attribute6 := p7_a22;
392 ddp_offer_perf_rec.attribute7 := p7_a23;
393 ddp_offer_perf_rec.attribute8 := p7_a24;
394 ddp_offer_perf_rec.attribute9 := p7_a25;
395 ddp_offer_perf_rec.attribute10 := p7_a26;
396 ddp_offer_perf_rec.attribute11 := p7_a27;
397 ddp_offer_perf_rec.attribute12 := p7_a28;
398 ddp_offer_perf_rec.attribute13 := p7_a29;
399 ddp_offer_perf_rec.attribute14 := p7_a30;
400 ddp_offer_perf_rec.attribute15 := p7_a31;
401 ddp_offer_perf_rec.security_group_id := rosetta_g_miss_num_map(p7_a32);
402 ddp_offer_perf_rec.requirement_type := p7_a33;
403 ddp_offer_perf_rec.uom_code := p7_a34;
404 ddp_offer_perf_rec.description := p7_a35;
405
406
407 -- here's the delegated call to the old PL/SQL routine
408 ozf_offer_performance_pvt.create_offer_performance(p_api_version_number,
409 p_init_msg_list,
410 p_commit,
411 p_validation_level,
412 x_return_status,
413 x_msg_count,
414 x_msg_data,
415 ddp_offer_perf_rec,
416 x_offer_performance_id);
417
418 -- copy data back from the local variables to OUT or IN-OUT args, if any
419
420
421
422
423
424
425
426
427 end;
428
429 procedure update_offer_performance(p_api_version_number NUMBER
430 , p_init_msg_list VARCHAR2
431 , p_commit VARCHAR2
432 , p_validation_level NUMBER
433 , x_return_status out nocopy VARCHAR2
434 , x_msg_count out nocopy NUMBER
435 , x_msg_data out nocopy VARCHAR2
436 , x_object_version_number out nocopy NUMBER
437 , p7_a0 NUMBER := 0-1962.0724
438 , p7_a1 NUMBER := 0-1962.0724
439 , p7_a2 DATE := fnd_api.g_miss_date
440 , p7_a3 NUMBER := 0-1962.0724
441 , p7_a4 DATE := fnd_api.g_miss_date
442 , p7_a5 NUMBER := 0-1962.0724
443 , p7_a6 NUMBER := 0-1962.0724
444 , p7_a7 NUMBER := 0-1962.0724
445 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
446 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
447 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
448 , p7_a11 NUMBER := 0-1962.0724
449 , p7_a12 DATE := fnd_api.g_miss_date
450 , p7_a13 DATE := fnd_api.g_miss_date
451 , p7_a14 NUMBER := 0-1962.0724
452 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
453 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
454 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
455 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
456 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
457 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
458 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
459 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
460 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
461 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
462 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
463 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
464 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
465 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
466 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
467 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
468 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
469 , p7_a32 NUMBER := 0-1962.0724
470 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
471 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
472 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
473 )
474
475 as
476 ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;
477 ddindx binary_integer; indx binary_integer;
478 begin
479
480 -- copy data to the local IN or IN-OUT args, if any
481
482
483
484
485
486
487
488 ddp_offer_perf_rec.offer_performance_id := rosetta_g_miss_num_map(p7_a0);
489 ddp_offer_perf_rec.list_header_id := rosetta_g_miss_num_map(p7_a1);
490 ddp_offer_perf_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
491 ddp_offer_perf_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
492 ddp_offer_perf_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
493 ddp_offer_perf_rec.created_by := rosetta_g_miss_num_map(p7_a5);
494 ddp_offer_perf_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
495 ddp_offer_perf_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
496 ddp_offer_perf_rec.product_attribute_context := p7_a8;
497 ddp_offer_perf_rec.product_attribute := p7_a9;
498 ddp_offer_perf_rec.product_attr_value := p7_a10;
499 ddp_offer_perf_rec.channel_id := rosetta_g_miss_num_map(p7_a11);
500 ddp_offer_perf_rec.start_date := rosetta_g_miss_date_in_map(p7_a12);
501 ddp_offer_perf_rec.end_date := rosetta_g_miss_date_in_map(p7_a13);
502 ddp_offer_perf_rec.estimated_value := rosetta_g_miss_num_map(p7_a14);
503 ddp_offer_perf_rec.required_flag := p7_a15;
504 ddp_offer_perf_rec.attribute_category := p7_a16;
505 ddp_offer_perf_rec.attribute1 := p7_a17;
506 ddp_offer_perf_rec.attribute2 := p7_a18;
507 ddp_offer_perf_rec.attribute3 := p7_a19;
508 ddp_offer_perf_rec.attribute4 := p7_a20;
509 ddp_offer_perf_rec.attribute5 := p7_a21;
510 ddp_offer_perf_rec.attribute6 := p7_a22;
511 ddp_offer_perf_rec.attribute7 := p7_a23;
512 ddp_offer_perf_rec.attribute8 := p7_a24;
513 ddp_offer_perf_rec.attribute9 := p7_a25;
514 ddp_offer_perf_rec.attribute10 := p7_a26;
515 ddp_offer_perf_rec.attribute11 := p7_a27;
516 ddp_offer_perf_rec.attribute12 := p7_a28;
517 ddp_offer_perf_rec.attribute13 := p7_a29;
518 ddp_offer_perf_rec.attribute14 := p7_a30;
519 ddp_offer_perf_rec.attribute15 := p7_a31;
520 ddp_offer_perf_rec.security_group_id := rosetta_g_miss_num_map(p7_a32);
521 ddp_offer_perf_rec.requirement_type := p7_a33;
522 ddp_offer_perf_rec.uom_code := p7_a34;
523 ddp_offer_perf_rec.description := p7_a35;
524
525
526 -- here's the delegated call to the old PL/SQL routine
527 ozf_offer_performance_pvt.update_offer_performance(p_api_version_number,
528 p_init_msg_list,
529 p_commit,
530 p_validation_level,
531 x_return_status,
532 x_msg_count,
533 x_msg_data,
534 ddp_offer_perf_rec,
535 x_object_version_number);
536
537 -- copy data back from the local variables to OUT or IN-OUT args, if any
538
539
540
541
542
543
544
545
546 end;
547
548 procedure validate_offer_performance(p_api_version_number NUMBER
549 , p_init_msg_list VARCHAR2
550 , p_validation_level NUMBER
551 , p_validation_mode VARCHAR2
552 , x_return_status out nocopy VARCHAR2
553 , x_msg_count out nocopy NUMBER
554 , x_msg_data out nocopy VARCHAR2
555 , p3_a0 NUMBER := 0-1962.0724
556 , p3_a1 NUMBER := 0-1962.0724
557 , p3_a2 DATE := fnd_api.g_miss_date
558 , p3_a3 NUMBER := 0-1962.0724
559 , p3_a4 DATE := fnd_api.g_miss_date
560 , p3_a5 NUMBER := 0-1962.0724
561 , p3_a6 NUMBER := 0-1962.0724
562 , p3_a7 NUMBER := 0-1962.0724
563 , p3_a8 VARCHAR2 := fnd_api.g_miss_char
564 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
565 , p3_a10 VARCHAR2 := fnd_api.g_miss_char
566 , p3_a11 NUMBER := 0-1962.0724
567 , p3_a12 DATE := fnd_api.g_miss_date
568 , p3_a13 DATE := fnd_api.g_miss_date
569 , p3_a14 NUMBER := 0-1962.0724
570 , p3_a15 VARCHAR2 := fnd_api.g_miss_char
571 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
572 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
573 , p3_a18 VARCHAR2 := fnd_api.g_miss_char
574 , p3_a19 VARCHAR2 := fnd_api.g_miss_char
575 , p3_a20 VARCHAR2 := fnd_api.g_miss_char
576 , p3_a21 VARCHAR2 := fnd_api.g_miss_char
577 , p3_a22 VARCHAR2 := fnd_api.g_miss_char
578 , p3_a23 VARCHAR2 := fnd_api.g_miss_char
579 , p3_a24 VARCHAR2 := fnd_api.g_miss_char
580 , p3_a25 VARCHAR2 := fnd_api.g_miss_char
581 , p3_a26 VARCHAR2 := fnd_api.g_miss_char
582 , p3_a27 VARCHAR2 := fnd_api.g_miss_char
583 , p3_a28 VARCHAR2 := fnd_api.g_miss_char
584 , p3_a29 VARCHAR2 := fnd_api.g_miss_char
585 , p3_a30 VARCHAR2 := fnd_api.g_miss_char
586 , p3_a31 VARCHAR2 := fnd_api.g_miss_char
587 , p3_a32 NUMBER := 0-1962.0724
588 , p3_a33 VARCHAR2 := fnd_api.g_miss_char
589 , p3_a34 VARCHAR2 := fnd_api.g_miss_char
590 , p3_a35 VARCHAR2 := fnd_api.g_miss_char
591 )
592
593 as
594 ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;
595 ddindx binary_integer; indx binary_integer;
596 begin
597
598 -- copy data to the local IN or IN-OUT args, if any
599
600
601
602 ddp_offer_perf_rec.offer_performance_id := rosetta_g_miss_num_map(p3_a0);
603 ddp_offer_perf_rec.list_header_id := rosetta_g_miss_num_map(p3_a1);
604 ddp_offer_perf_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a2);
605 ddp_offer_perf_rec.last_updated_by := rosetta_g_miss_num_map(p3_a3);
606 ddp_offer_perf_rec.creation_date := rosetta_g_miss_date_in_map(p3_a4);
607 ddp_offer_perf_rec.created_by := rosetta_g_miss_num_map(p3_a5);
608 ddp_offer_perf_rec.last_update_login := rosetta_g_miss_num_map(p3_a6);
609 ddp_offer_perf_rec.object_version_number := rosetta_g_miss_num_map(p3_a7);
610 ddp_offer_perf_rec.product_attribute_context := p3_a8;
611 ddp_offer_perf_rec.product_attribute := p3_a9;
612 ddp_offer_perf_rec.product_attr_value := p3_a10;
613 ddp_offer_perf_rec.channel_id := rosetta_g_miss_num_map(p3_a11);
614 ddp_offer_perf_rec.start_date := rosetta_g_miss_date_in_map(p3_a12);
615 ddp_offer_perf_rec.end_date := rosetta_g_miss_date_in_map(p3_a13);
616 ddp_offer_perf_rec.estimated_value := rosetta_g_miss_num_map(p3_a14);
617 ddp_offer_perf_rec.required_flag := p3_a15;
618 ddp_offer_perf_rec.attribute_category := p3_a16;
619 ddp_offer_perf_rec.attribute1 := p3_a17;
620 ddp_offer_perf_rec.attribute2 := p3_a18;
621 ddp_offer_perf_rec.attribute3 := p3_a19;
622 ddp_offer_perf_rec.attribute4 := p3_a20;
623 ddp_offer_perf_rec.attribute5 := p3_a21;
624 ddp_offer_perf_rec.attribute6 := p3_a22;
625 ddp_offer_perf_rec.attribute7 := p3_a23;
626 ddp_offer_perf_rec.attribute8 := p3_a24;
627 ddp_offer_perf_rec.attribute9 := p3_a25;
628 ddp_offer_perf_rec.attribute10 := p3_a26;
629 ddp_offer_perf_rec.attribute11 := p3_a27;
630 ddp_offer_perf_rec.attribute12 := p3_a28;
631 ddp_offer_perf_rec.attribute13 := p3_a29;
632 ddp_offer_perf_rec.attribute14 := p3_a30;
633 ddp_offer_perf_rec.attribute15 := p3_a31;
634 ddp_offer_perf_rec.security_group_id := rosetta_g_miss_num_map(p3_a32);
635 ddp_offer_perf_rec.requirement_type := p3_a33;
636 ddp_offer_perf_rec.uom_code := p3_a34;
637 ddp_offer_perf_rec.description := p3_a35;
638
639
640
641
642
643 -- here's the delegated call to the old PL/SQL routine
644 ozf_offer_performance_pvt.validate_offer_performance(p_api_version_number,
645 p_init_msg_list,
646 p_validation_level,
647 ddp_offer_perf_rec,
648 p_validation_mode,
649 x_return_status,
650 x_msg_count,
651 x_msg_data);
652
653 -- copy data back from the local variables to OUT or IN-OUT args, if any
654
655
656
657
658
659
660
661 end;
662
663 procedure check_offer_perf_items(p_validation_mode VARCHAR2
664 , x_return_status out nocopy VARCHAR2
665 , p0_a0 NUMBER := 0-1962.0724
666 , p0_a1 NUMBER := 0-1962.0724
667 , p0_a2 DATE := fnd_api.g_miss_date
668 , p0_a3 NUMBER := 0-1962.0724
669 , p0_a4 DATE := fnd_api.g_miss_date
670 , p0_a5 NUMBER := 0-1962.0724
671 , p0_a6 NUMBER := 0-1962.0724
672 , p0_a7 NUMBER := 0-1962.0724
673 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
674 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
675 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
676 , p0_a11 NUMBER := 0-1962.0724
677 , p0_a12 DATE := fnd_api.g_miss_date
678 , p0_a13 DATE := fnd_api.g_miss_date
679 , p0_a14 NUMBER := 0-1962.0724
680 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
681 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
682 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
683 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
684 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
685 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
686 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
687 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
688 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
689 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
690 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
691 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
692 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
693 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
694 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
695 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
696 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
697 , p0_a32 NUMBER := 0-1962.0724
698 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
699 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
700 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
701 )
702
703 as
704 ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;
705 ddindx binary_integer; indx binary_integer;
706 begin
707
708 -- copy data to the local IN or IN-OUT args, if any
709 ddp_offer_perf_rec.offer_performance_id := rosetta_g_miss_num_map(p0_a0);
710 ddp_offer_perf_rec.list_header_id := rosetta_g_miss_num_map(p0_a1);
711 ddp_offer_perf_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
712 ddp_offer_perf_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
713 ddp_offer_perf_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
714 ddp_offer_perf_rec.created_by := rosetta_g_miss_num_map(p0_a5);
715 ddp_offer_perf_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
716 ddp_offer_perf_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
717 ddp_offer_perf_rec.product_attribute_context := p0_a8;
718 ddp_offer_perf_rec.product_attribute := p0_a9;
719 ddp_offer_perf_rec.product_attr_value := p0_a10;
720 ddp_offer_perf_rec.channel_id := rosetta_g_miss_num_map(p0_a11);
721 ddp_offer_perf_rec.start_date := rosetta_g_miss_date_in_map(p0_a12);
722 ddp_offer_perf_rec.end_date := rosetta_g_miss_date_in_map(p0_a13);
723 ddp_offer_perf_rec.estimated_value := rosetta_g_miss_num_map(p0_a14);
724 ddp_offer_perf_rec.required_flag := p0_a15;
725 ddp_offer_perf_rec.attribute_category := p0_a16;
726 ddp_offer_perf_rec.attribute1 := p0_a17;
727 ddp_offer_perf_rec.attribute2 := p0_a18;
728 ddp_offer_perf_rec.attribute3 := p0_a19;
729 ddp_offer_perf_rec.attribute4 := p0_a20;
730 ddp_offer_perf_rec.attribute5 := p0_a21;
731 ddp_offer_perf_rec.attribute6 := p0_a22;
732 ddp_offer_perf_rec.attribute7 := p0_a23;
733 ddp_offer_perf_rec.attribute8 := p0_a24;
734 ddp_offer_perf_rec.attribute9 := p0_a25;
735 ddp_offer_perf_rec.attribute10 := p0_a26;
736 ddp_offer_perf_rec.attribute11 := p0_a27;
737 ddp_offer_perf_rec.attribute12 := p0_a28;
738 ddp_offer_perf_rec.attribute13 := p0_a29;
739 ddp_offer_perf_rec.attribute14 := p0_a30;
740 ddp_offer_perf_rec.attribute15 := p0_a31;
741 ddp_offer_perf_rec.security_group_id := rosetta_g_miss_num_map(p0_a32);
742 ddp_offer_perf_rec.requirement_type := p0_a33;
743 ddp_offer_perf_rec.uom_code := p0_a34;
744 ddp_offer_perf_rec.description := p0_a35;
745
746
747
748 -- here's the delegated call to the old PL/SQL routine
749 ozf_offer_performance_pvt.check_offer_perf_items(ddp_offer_perf_rec,
750 p_validation_mode,
751 x_return_status);
752
753 -- copy data back from the local variables to OUT or IN-OUT args, if any
754
755
756 end;
757
758 procedure validate_offer_perf_rec(p_api_version_number NUMBER
759 , p_init_msg_list VARCHAR2
760 , x_return_status out nocopy VARCHAR2
761 , x_msg_count out nocopy NUMBER
762 , x_msg_data out nocopy VARCHAR2
763 , p5_a0 NUMBER := 0-1962.0724
764 , p5_a1 NUMBER := 0-1962.0724
765 , p5_a2 DATE := fnd_api.g_miss_date
766 , p5_a3 NUMBER := 0-1962.0724
767 , p5_a4 DATE := fnd_api.g_miss_date
768 , p5_a5 NUMBER := 0-1962.0724
769 , p5_a6 NUMBER := 0-1962.0724
770 , p5_a7 NUMBER := 0-1962.0724
771 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
773 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
774 , p5_a11 NUMBER := 0-1962.0724
775 , p5_a12 DATE := fnd_api.g_miss_date
776 , p5_a13 DATE := fnd_api.g_miss_date
777 , p5_a14 NUMBER := 0-1962.0724
778 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795 , p5_a32 NUMBER := 0-1962.0724
796 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
797 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
798 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
799 )
800
801 as
802 ddp_offer_perf_rec ozf_offer_performance_pvt.offer_perf_rec_type;
803 ddindx binary_integer; indx binary_integer;
804 begin
805
806 -- copy data to the local IN or IN-OUT args, if any
807
808
809
810
811
812 ddp_offer_perf_rec.offer_performance_id := rosetta_g_miss_num_map(p5_a0);
813 ddp_offer_perf_rec.list_header_id := rosetta_g_miss_num_map(p5_a1);
814 ddp_offer_perf_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a2);
815 ddp_offer_perf_rec.last_updated_by := rosetta_g_miss_num_map(p5_a3);
816 ddp_offer_perf_rec.creation_date := rosetta_g_miss_date_in_map(p5_a4);
817 ddp_offer_perf_rec.created_by := rosetta_g_miss_num_map(p5_a5);
818 ddp_offer_perf_rec.last_update_login := rosetta_g_miss_num_map(p5_a6);
819 ddp_offer_perf_rec.object_version_number := rosetta_g_miss_num_map(p5_a7);
820 ddp_offer_perf_rec.product_attribute_context := p5_a8;
821 ddp_offer_perf_rec.product_attribute := p5_a9;
822 ddp_offer_perf_rec.product_attr_value := p5_a10;
823 ddp_offer_perf_rec.channel_id := rosetta_g_miss_num_map(p5_a11);
824 ddp_offer_perf_rec.start_date := rosetta_g_miss_date_in_map(p5_a12);
825 ddp_offer_perf_rec.end_date := rosetta_g_miss_date_in_map(p5_a13);
826 ddp_offer_perf_rec.estimated_value := rosetta_g_miss_num_map(p5_a14);
827 ddp_offer_perf_rec.required_flag := p5_a15;
828 ddp_offer_perf_rec.attribute_category := p5_a16;
829 ddp_offer_perf_rec.attribute1 := p5_a17;
830 ddp_offer_perf_rec.attribute2 := p5_a18;
831 ddp_offer_perf_rec.attribute3 := p5_a19;
832 ddp_offer_perf_rec.attribute4 := p5_a20;
833 ddp_offer_perf_rec.attribute5 := p5_a21;
834 ddp_offer_perf_rec.attribute6 := p5_a22;
835 ddp_offer_perf_rec.attribute7 := p5_a23;
836 ddp_offer_perf_rec.attribute8 := p5_a24;
837 ddp_offer_perf_rec.attribute9 := p5_a25;
838 ddp_offer_perf_rec.attribute10 := p5_a26;
839 ddp_offer_perf_rec.attribute11 := p5_a27;
840 ddp_offer_perf_rec.attribute12 := p5_a28;
841 ddp_offer_perf_rec.attribute13 := p5_a29;
842 ddp_offer_perf_rec.attribute14 := p5_a30;
843 ddp_offer_perf_rec.attribute15 := p5_a31;
844 ddp_offer_perf_rec.security_group_id := rosetta_g_miss_num_map(p5_a32);
845 ddp_offer_perf_rec.requirement_type := p5_a33;
846 ddp_offer_perf_rec.uom_code := p5_a34;
847 ddp_offer_perf_rec.description := p5_a35;
848
849 -- here's the delegated call to the old PL/SQL routine
850 ozf_offer_performance_pvt.validate_offer_perf_rec(p_api_version_number,
851 p_init_msg_list,
852 x_return_status,
853 x_msg_count,
854 x_msg_data,
855 ddp_offer_perf_rec);
856
857 -- copy data back from the local variables to OUT or IN-OUT args, if any
858
859
860
861
862
863 end;
864
865 end ozf_offer_performance_pvt_w;