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