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