[Home] [Help]
PACKAGE BODY: APPS.AMS_VENUE_PVT_W
Source
1 package body ams_venue_pvt_w as
2 /* $Header: amswvnub.pls 115.8 2002/11/16 01:47:41 dbiswas 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 create_venue(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , x_return_status OUT NOCOPY VARCHAR2
27 , x_msg_count OUT NOCOPY NUMBER
28 , x_msg_data OUT NOCOPY VARCHAR2
29 , x_venue_id OUT NOCOPY NUMBER
30 , p7_a0 NUMBER := 0-1962.0724
31 , p7_a1 NUMBER := 0-1962.0724
32 , p7_a2 DATE := fnd_api.g_miss_date
33 , p7_a3 NUMBER := 0-1962.0724
34 , p7_a4 DATE := fnd_api.g_miss_date
35 , p7_a5 NUMBER := 0-1962.0724
36 , p7_a6 NUMBER := 0-1962.0724
37 , p7_a7 NUMBER := 0-1962.0724
38 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a16 NUMBER := 0-1962.0724
47 , p7_a17 NUMBER := 0-1962.0724
48 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a19 NUMBER := 0-1962.0724
50 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a21 NUMBER := 0-1962.0724
52 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a24 NUMBER := 0-1962.0724
55 , p7_a25 NUMBER := 0-1962.0724
56 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
63 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
64 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
65 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
66 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
67 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
68 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
69 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
70 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
71 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
72 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
73 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
74 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
75 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
76 , p7_a46 NUMBER := 0-1962.0724
77 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
78 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
79 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
80 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
81 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
82 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
84 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
85 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89 , p7_a59 NUMBER := 0-1962.0724
90 , p7_a60 NUMBER := 0-1962.0724
91 , p7_a61 NUMBER := 0-1962.0724
92 )
93 as
94 ddp_venue_rec ams_venue_pvt.venue_rec_type;
95 ddindx binary_integer; indx binary_integer;
96 begin
97
98 -- copy data to the local IN or IN-OUT args, if any
99
100
101
102
103
104
105
106 ddp_venue_rec.venue_id := rosetta_g_miss_num_map(p7_a0);
107 ddp_venue_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a1);
108 ddp_venue_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
109 ddp_venue_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
110 ddp_venue_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
111 ddp_venue_rec.created_by := rosetta_g_miss_num_map(p7_a5);
112 ddp_venue_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
113 ddp_venue_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
114 ddp_venue_rec.venue_type_code := p7_a8;
115 ddp_venue_rec.venue_type_name := p7_a9;
116 ddp_venue_rec.direct_phone_flag := p7_a10;
117 ddp_venue_rec.internal_flag := p7_a11;
118 ddp_venue_rec.enabled_flag := p7_a12;
119 ddp_venue_rec.rating_code := p7_a13;
120 ddp_venue_rec.telecom_code := p7_a14;
121 ddp_venue_rec.rating_name := p7_a15;
122 ddp_venue_rec.capacity := rosetta_g_miss_num_map(p7_a16);
123 ddp_venue_rec.area_size := rosetta_g_miss_num_map(p7_a17);
124 ddp_venue_rec.area_size_uom_code := p7_a18;
125 ddp_venue_rec.ceiling_height := rosetta_g_miss_num_map(p7_a19);
126 ddp_venue_rec.ceiling_height_uom_code := p7_a20;
127 ddp_venue_rec.usage_cost := rosetta_g_miss_num_map(p7_a21);
128 ddp_venue_rec.usage_cost_uom_code := p7_a22;
129 ddp_venue_rec.usage_cost_currency_code := p7_a23;
130 ddp_venue_rec.parent_venue_id := rosetta_g_miss_num_map(p7_a24);
131 ddp_venue_rec.location_id := rosetta_g_miss_num_map(p7_a25);
132 ddp_venue_rec.directions := p7_a26;
133 ddp_venue_rec.venue_code := p7_a27;
134 ddp_venue_rec.object_type := p7_a28;
135 ddp_venue_rec.attribute_category := p7_a29;
136 ddp_venue_rec.attribute1 := p7_a30;
137 ddp_venue_rec.attribute2 := p7_a31;
138 ddp_venue_rec.attribute3 := p7_a32;
139 ddp_venue_rec.attribute4 := p7_a33;
140 ddp_venue_rec.attribute5 := p7_a34;
141 ddp_venue_rec.attribute6 := p7_a35;
142 ddp_venue_rec.attribute7 := p7_a36;
143 ddp_venue_rec.attribute8 := p7_a37;
144 ddp_venue_rec.attribute9 := p7_a38;
145 ddp_venue_rec.attribute10 := p7_a39;
146 ddp_venue_rec.attribute11 := p7_a40;
147 ddp_venue_rec.attribute12 := p7_a41;
148 ddp_venue_rec.attribute13 := p7_a42;
149 ddp_venue_rec.attribute14 := p7_a43;
150 ddp_venue_rec.attribute15 := p7_a44;
151 ddp_venue_rec.venue_name := p7_a45;
152 ddp_venue_rec.party_id := rosetta_g_miss_num_map(p7_a46);
153 ddp_venue_rec.description := p7_a47;
154 ddp_venue_rec.address1 := p7_a48;
155 ddp_venue_rec.address2 := p7_a49;
156 ddp_venue_rec.address3 := p7_a50;
157 ddp_venue_rec.address4 := p7_a51;
158 ddp_venue_rec.country_code := p7_a52;
159 ddp_venue_rec.country := p7_a53;
160 ddp_venue_rec.city := p7_a54;
161 ddp_venue_rec.postal_code := p7_a55;
162 ddp_venue_rec.state := p7_a56;
163 ddp_venue_rec.province := p7_a57;
164 ddp_venue_rec.county := p7_a58;
165 ddp_venue_rec.salesforce_id := rosetta_g_miss_num_map(p7_a59);
166 ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p7_a60);
167 ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
168
169
170 -- here's the delegated call to the old PL/SQL routine
171 ams_venue_pvt.create_venue(p_api_version,
172 p_init_msg_list,
173 p_commit,
174 p_validation_level,
175 x_return_status,
176 x_msg_count,
177 x_msg_data,
178 ddp_venue_rec,
179 x_venue_id);
180
181 -- copy data back from the local OUT or IN-OUT args, if any
182
183
184
185
186
187
188
189
190 end;
191
192 procedure create_room(p_api_version NUMBER
193 , p_init_msg_list VARCHAR2
194 , p_commit VARCHAR2
195 , p_validation_level NUMBER
196 , x_return_status OUT NOCOPY VARCHAR2
197 , x_msg_count OUT NOCOPY NUMBER
198 , x_msg_data OUT NOCOPY VARCHAR2
199 , x_venue_id OUT NOCOPY NUMBER
200 , p7_a0 NUMBER := 0-1962.0724
201 , p7_a1 NUMBER := 0-1962.0724
202 , p7_a2 DATE := fnd_api.g_miss_date
203 , p7_a3 NUMBER := 0-1962.0724
204 , p7_a4 DATE := fnd_api.g_miss_date
205 , p7_a5 NUMBER := 0-1962.0724
206 , p7_a6 NUMBER := 0-1962.0724
207 , p7_a7 NUMBER := 0-1962.0724
208 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
209 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
210 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
211 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
212 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
213 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
214 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
215 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
216 , p7_a16 NUMBER := 0-1962.0724
217 , p7_a17 NUMBER := 0-1962.0724
218 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
219 , p7_a19 NUMBER := 0-1962.0724
220 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
221 , p7_a21 NUMBER := 0-1962.0724
222 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
223 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
224 , p7_a24 NUMBER := 0-1962.0724
225 , p7_a25 NUMBER := 0-1962.0724
226 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
227 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
228 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
229 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
230 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
231 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
232 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
233 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
234 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
235 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
236 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
237 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
238 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
239 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
240 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
241 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
242 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
243 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
244 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
245 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
246 , p7_a46 NUMBER := 0-1962.0724
247 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
248 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
249 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
250 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
251 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
252 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
253 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
254 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
255 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
256 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
257 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
258 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
259 , p7_a59 NUMBER := 0-1962.0724
260 , p7_a60 NUMBER := 0-1962.0724
261 , p7_a61 NUMBER := 0-1962.0724
262 )
263 as
264 ddp_venue_rec ams_venue_pvt.venue_rec_type;
265 ddindx binary_integer; indx binary_integer;
266 begin
267
268 -- copy data to the local IN or IN-OUT args, if any
269
270
271
272
273
274
275
276 ddp_venue_rec.venue_id := rosetta_g_miss_num_map(p7_a0);
277 ddp_venue_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a1);
278 ddp_venue_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
279 ddp_venue_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
280 ddp_venue_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
281 ddp_venue_rec.created_by := rosetta_g_miss_num_map(p7_a5);
282 ddp_venue_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
283 ddp_venue_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
284 ddp_venue_rec.venue_type_code := p7_a8;
285 ddp_venue_rec.venue_type_name := p7_a9;
286 ddp_venue_rec.direct_phone_flag := p7_a10;
287 ddp_venue_rec.internal_flag := p7_a11;
288 ddp_venue_rec.enabled_flag := p7_a12;
289 ddp_venue_rec.rating_code := p7_a13;
290 ddp_venue_rec.telecom_code := p7_a14;
291 ddp_venue_rec.rating_name := p7_a15;
292 ddp_venue_rec.capacity := rosetta_g_miss_num_map(p7_a16);
293 ddp_venue_rec.area_size := rosetta_g_miss_num_map(p7_a17);
294 ddp_venue_rec.area_size_uom_code := p7_a18;
295 ddp_venue_rec.ceiling_height := rosetta_g_miss_num_map(p7_a19);
296 ddp_venue_rec.ceiling_height_uom_code := p7_a20;
297 ddp_venue_rec.usage_cost := rosetta_g_miss_num_map(p7_a21);
298 ddp_venue_rec.usage_cost_uom_code := p7_a22;
299 ddp_venue_rec.usage_cost_currency_code := p7_a23;
300 ddp_venue_rec.parent_venue_id := rosetta_g_miss_num_map(p7_a24);
301 ddp_venue_rec.location_id := rosetta_g_miss_num_map(p7_a25);
302 ddp_venue_rec.directions := p7_a26;
303 ddp_venue_rec.venue_code := p7_a27;
304 ddp_venue_rec.object_type := p7_a28;
305 ddp_venue_rec.attribute_category := p7_a29;
306 ddp_venue_rec.attribute1 := p7_a30;
307 ddp_venue_rec.attribute2 := p7_a31;
308 ddp_venue_rec.attribute3 := p7_a32;
309 ddp_venue_rec.attribute4 := p7_a33;
310 ddp_venue_rec.attribute5 := p7_a34;
311 ddp_venue_rec.attribute6 := p7_a35;
312 ddp_venue_rec.attribute7 := p7_a36;
313 ddp_venue_rec.attribute8 := p7_a37;
314 ddp_venue_rec.attribute9 := p7_a38;
315 ddp_venue_rec.attribute10 := p7_a39;
316 ddp_venue_rec.attribute11 := p7_a40;
317 ddp_venue_rec.attribute12 := p7_a41;
318 ddp_venue_rec.attribute13 := p7_a42;
319 ddp_venue_rec.attribute14 := p7_a43;
320 ddp_venue_rec.attribute15 := p7_a44;
321 ddp_venue_rec.venue_name := p7_a45;
322 ddp_venue_rec.party_id := rosetta_g_miss_num_map(p7_a46);
323 ddp_venue_rec.description := p7_a47;
324 ddp_venue_rec.address1 := p7_a48;
325 ddp_venue_rec.address2 := p7_a49;
326 ddp_venue_rec.address3 := p7_a50;
327 ddp_venue_rec.address4 := p7_a51;
328 ddp_venue_rec.country_code := p7_a52;
329 ddp_venue_rec.country := p7_a53;
330 ddp_venue_rec.city := p7_a54;
331 ddp_venue_rec.postal_code := p7_a55;
332 ddp_venue_rec.state := p7_a56;
333 ddp_venue_rec.province := p7_a57;
334 ddp_venue_rec.county := p7_a58;
335 ddp_venue_rec.salesforce_id := rosetta_g_miss_num_map(p7_a59);
336 ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p7_a60);
337 ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
338
339
340 -- here's the delegated call to the old PL/SQL routine
341 ams_venue_pvt.create_room(p_api_version,
342 p_init_msg_list,
343 p_commit,
344 p_validation_level,
345 x_return_status,
346 x_msg_count,
347 x_msg_data,
348 ddp_venue_rec,
349 x_venue_id);
350
351 -- copy data back from the local OUT or IN-OUT args, if any
352
353
354
355
356
357
358
359
360 end;
361
362 procedure update_venue(p_api_version NUMBER
363 , p_init_msg_list VARCHAR2
364 , p_commit VARCHAR2
365 , p_validation_level NUMBER
366 , x_return_status OUT NOCOPY VARCHAR2
367 , x_msg_count OUT NOCOPY NUMBER
368 , x_msg_data OUT NOCOPY VARCHAR2
369 , p7_a0 NUMBER := 0-1962.0724
370 , p7_a1 NUMBER := 0-1962.0724
371 , p7_a2 DATE := fnd_api.g_miss_date
372 , p7_a3 NUMBER := 0-1962.0724
373 , p7_a4 DATE := fnd_api.g_miss_date
374 , p7_a5 NUMBER := 0-1962.0724
375 , p7_a6 NUMBER := 0-1962.0724
376 , p7_a7 NUMBER := 0-1962.0724
377 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
378 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
379 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
380 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
381 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
382 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
383 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
384 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
385 , p7_a16 NUMBER := 0-1962.0724
386 , p7_a17 NUMBER := 0-1962.0724
387 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
388 , p7_a19 NUMBER := 0-1962.0724
389 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
390 , p7_a21 NUMBER := 0-1962.0724
391 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
392 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
393 , p7_a24 NUMBER := 0-1962.0724
394 , p7_a25 NUMBER := 0-1962.0724
395 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
396 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
397 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
398 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
399 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
400 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
401 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
402 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
403 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
404 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
405 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
406 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
407 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
408 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
409 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
410 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
411 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
412 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
413 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
414 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
415 , p7_a46 NUMBER := 0-1962.0724
416 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
417 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
418 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
419 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
420 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
421 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
422 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
423 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
424 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
425 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
426 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
427 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
428 , p7_a59 NUMBER := 0-1962.0724
429 , p7_a60 NUMBER := 0-1962.0724
430 , p7_a61 NUMBER := 0-1962.0724
431 )
432 as
433 ddp_venue_rec ams_venue_pvt.venue_rec_type;
434 ddindx binary_integer; indx binary_integer;
435 begin
436
437 -- copy data to the local IN or IN-OUT args, if any
438
439
440
441
442
443
444
445 ddp_venue_rec.venue_id := rosetta_g_miss_num_map(p7_a0);
446 ddp_venue_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a1);
447 ddp_venue_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
448 ddp_venue_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
449 ddp_venue_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
450 ddp_venue_rec.created_by := rosetta_g_miss_num_map(p7_a5);
451 ddp_venue_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
452 ddp_venue_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
453 ddp_venue_rec.venue_type_code := p7_a8;
454 ddp_venue_rec.venue_type_name := p7_a9;
455 ddp_venue_rec.direct_phone_flag := p7_a10;
456 ddp_venue_rec.internal_flag := p7_a11;
457 ddp_venue_rec.enabled_flag := p7_a12;
458 ddp_venue_rec.rating_code := p7_a13;
459 ddp_venue_rec.telecom_code := p7_a14;
460 ddp_venue_rec.rating_name := p7_a15;
461 ddp_venue_rec.capacity := rosetta_g_miss_num_map(p7_a16);
462 ddp_venue_rec.area_size := rosetta_g_miss_num_map(p7_a17);
463 ddp_venue_rec.area_size_uom_code := p7_a18;
464 ddp_venue_rec.ceiling_height := rosetta_g_miss_num_map(p7_a19);
465 ddp_venue_rec.ceiling_height_uom_code := p7_a20;
466 ddp_venue_rec.usage_cost := rosetta_g_miss_num_map(p7_a21);
467 ddp_venue_rec.usage_cost_uom_code := p7_a22;
468 ddp_venue_rec.usage_cost_currency_code := p7_a23;
469 ddp_venue_rec.parent_venue_id := rosetta_g_miss_num_map(p7_a24);
470 ddp_venue_rec.location_id := rosetta_g_miss_num_map(p7_a25);
471 ddp_venue_rec.directions := p7_a26;
472 ddp_venue_rec.venue_code := p7_a27;
473 ddp_venue_rec.object_type := p7_a28;
474 ddp_venue_rec.attribute_category := p7_a29;
475 ddp_venue_rec.attribute1 := p7_a30;
476 ddp_venue_rec.attribute2 := p7_a31;
477 ddp_venue_rec.attribute3 := p7_a32;
478 ddp_venue_rec.attribute4 := p7_a33;
479 ddp_venue_rec.attribute5 := p7_a34;
480 ddp_venue_rec.attribute6 := p7_a35;
481 ddp_venue_rec.attribute7 := p7_a36;
482 ddp_venue_rec.attribute8 := p7_a37;
483 ddp_venue_rec.attribute9 := p7_a38;
484 ddp_venue_rec.attribute10 := p7_a39;
485 ddp_venue_rec.attribute11 := p7_a40;
486 ddp_venue_rec.attribute12 := p7_a41;
487 ddp_venue_rec.attribute13 := p7_a42;
488 ddp_venue_rec.attribute14 := p7_a43;
489 ddp_venue_rec.attribute15 := p7_a44;
490 ddp_venue_rec.venue_name := p7_a45;
491 ddp_venue_rec.party_id := rosetta_g_miss_num_map(p7_a46);
492 ddp_venue_rec.description := p7_a47;
493 ddp_venue_rec.address1 := p7_a48;
494 ddp_venue_rec.address2 := p7_a49;
495 ddp_venue_rec.address3 := p7_a50;
496 ddp_venue_rec.address4 := p7_a51;
497 ddp_venue_rec.country_code := p7_a52;
498 ddp_venue_rec.country := p7_a53;
499 ddp_venue_rec.city := p7_a54;
500 ddp_venue_rec.postal_code := p7_a55;
501 ddp_venue_rec.state := p7_a56;
502 ddp_venue_rec.province := p7_a57;
503 ddp_venue_rec.county := p7_a58;
504 ddp_venue_rec.salesforce_id := rosetta_g_miss_num_map(p7_a59);
505 ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p7_a60);
506 ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
507
508 -- here's the delegated call to the old PL/SQL routine
509 ams_venue_pvt.update_venue(p_api_version,
510 p_init_msg_list,
511 p_commit,
512 p_validation_level,
513 x_return_status,
514 x_msg_count,
515 x_msg_data,
516 ddp_venue_rec);
517
518 -- copy data back from the local OUT or IN-OUT args, if any
519
520
521
522
523
524
525
526 end;
527
528 procedure update_room(p_api_version NUMBER
529 , p_init_msg_list VARCHAR2
530 , p_commit VARCHAR2
531 , p_validation_level NUMBER
532 , x_return_status OUT NOCOPY VARCHAR2
533 , x_msg_count OUT NOCOPY NUMBER
534 , x_msg_data OUT NOCOPY VARCHAR2
535 , p7_a0 NUMBER := 0-1962.0724
536 , p7_a1 NUMBER := 0-1962.0724
537 , p7_a2 DATE := fnd_api.g_miss_date
538 , p7_a3 NUMBER := 0-1962.0724
539 , p7_a4 DATE := fnd_api.g_miss_date
540 , p7_a5 NUMBER := 0-1962.0724
541 , p7_a6 NUMBER := 0-1962.0724
542 , p7_a7 NUMBER := 0-1962.0724
543 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
544 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
545 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
546 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
547 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
548 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
549 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
550 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
551 , p7_a16 NUMBER := 0-1962.0724
552 , p7_a17 NUMBER := 0-1962.0724
553 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
554 , p7_a19 NUMBER := 0-1962.0724
555 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
556 , p7_a21 NUMBER := 0-1962.0724
557 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
558 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
559 , p7_a24 NUMBER := 0-1962.0724
560 , p7_a25 NUMBER := 0-1962.0724
561 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
562 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
563 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
564 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
565 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
566 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
567 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
568 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
569 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
570 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
571 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
572 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
573 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
574 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
575 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
576 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
577 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
578 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
579 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
580 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
581 , p7_a46 NUMBER := 0-1962.0724
582 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
583 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
584 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
585 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
586 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
587 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
588 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
589 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
590 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
591 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
592 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
593 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
594 , p7_a59 NUMBER := 0-1962.0724
595 , p7_a60 NUMBER := 0-1962.0724
596 , p7_a61 NUMBER := 0-1962.0724
597 )
598 as
599 ddp_venue_rec ams_venue_pvt.venue_rec_type;
600 ddindx binary_integer; indx binary_integer;
601 begin
602
603 -- copy data to the local IN or IN-OUT args, if any
604
605
606
607
608
609
610
611 ddp_venue_rec.venue_id := rosetta_g_miss_num_map(p7_a0);
612 ddp_venue_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a1);
613 ddp_venue_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
614 ddp_venue_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
615 ddp_venue_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
616 ddp_venue_rec.created_by := rosetta_g_miss_num_map(p7_a5);
617 ddp_venue_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
618 ddp_venue_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
619 ddp_venue_rec.venue_type_code := p7_a8;
620 ddp_venue_rec.venue_type_name := p7_a9;
621 ddp_venue_rec.direct_phone_flag := p7_a10;
622 ddp_venue_rec.internal_flag := p7_a11;
623 ddp_venue_rec.enabled_flag := p7_a12;
624 ddp_venue_rec.rating_code := p7_a13;
625 ddp_venue_rec.telecom_code := p7_a14;
626 ddp_venue_rec.rating_name := p7_a15;
627 ddp_venue_rec.capacity := rosetta_g_miss_num_map(p7_a16);
628 ddp_venue_rec.area_size := rosetta_g_miss_num_map(p7_a17);
629 ddp_venue_rec.area_size_uom_code := p7_a18;
630 ddp_venue_rec.ceiling_height := rosetta_g_miss_num_map(p7_a19);
631 ddp_venue_rec.ceiling_height_uom_code := p7_a20;
632 ddp_venue_rec.usage_cost := rosetta_g_miss_num_map(p7_a21);
633 ddp_venue_rec.usage_cost_uom_code := p7_a22;
634 ddp_venue_rec.usage_cost_currency_code := p7_a23;
635 ddp_venue_rec.parent_venue_id := rosetta_g_miss_num_map(p7_a24);
636 ddp_venue_rec.location_id := rosetta_g_miss_num_map(p7_a25);
637 ddp_venue_rec.directions := p7_a26;
638 ddp_venue_rec.venue_code := p7_a27;
639 ddp_venue_rec.object_type := p7_a28;
640 ddp_venue_rec.attribute_category := p7_a29;
641 ddp_venue_rec.attribute1 := p7_a30;
642 ddp_venue_rec.attribute2 := p7_a31;
643 ddp_venue_rec.attribute3 := p7_a32;
644 ddp_venue_rec.attribute4 := p7_a33;
645 ddp_venue_rec.attribute5 := p7_a34;
646 ddp_venue_rec.attribute6 := p7_a35;
647 ddp_venue_rec.attribute7 := p7_a36;
648 ddp_venue_rec.attribute8 := p7_a37;
649 ddp_venue_rec.attribute9 := p7_a38;
650 ddp_venue_rec.attribute10 := p7_a39;
651 ddp_venue_rec.attribute11 := p7_a40;
652 ddp_venue_rec.attribute12 := p7_a41;
653 ddp_venue_rec.attribute13 := p7_a42;
654 ddp_venue_rec.attribute14 := p7_a43;
655 ddp_venue_rec.attribute15 := p7_a44;
656 ddp_venue_rec.venue_name := p7_a45;
657 ddp_venue_rec.party_id := rosetta_g_miss_num_map(p7_a46);
658 ddp_venue_rec.description := p7_a47;
659 ddp_venue_rec.address1 := p7_a48;
660 ddp_venue_rec.address2 := p7_a49;
661 ddp_venue_rec.address3 := p7_a50;
662 ddp_venue_rec.address4 := p7_a51;
663 ddp_venue_rec.country_code := p7_a52;
664 ddp_venue_rec.country := p7_a53;
665 ddp_venue_rec.city := p7_a54;
666 ddp_venue_rec.postal_code := p7_a55;
667 ddp_venue_rec.state := p7_a56;
668 ddp_venue_rec.province := p7_a57;
669 ddp_venue_rec.county := p7_a58;
670 ddp_venue_rec.salesforce_id := rosetta_g_miss_num_map(p7_a59);
671 ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p7_a60);
672 ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
673
674 -- here's the delegated call to the old PL/SQL routine
675 ams_venue_pvt.update_room(p_api_version,
676 p_init_msg_list,
677 p_commit,
678 p_validation_level,
679 x_return_status,
680 x_msg_count,
681 x_msg_data,
682 ddp_venue_rec);
683
684 -- copy data back from the local OUT or IN-OUT args, if any
685
686
687
688
689
690
691
692 end;
693
694 procedure validate_venue(p_api_version NUMBER
695 , p_init_msg_list VARCHAR2
696 , p_commit VARCHAR2
697 , p_validation_level NUMBER
698 , x_return_status OUT NOCOPY VARCHAR2
699 , x_msg_count OUT NOCOPY NUMBER
700 , x_msg_data OUT NOCOPY VARCHAR2
701 , p_object_type VARCHAR2
702 , p7_a0 NUMBER := 0-1962.0724
703 , p7_a1 NUMBER := 0-1962.0724
704 , p7_a2 DATE := fnd_api.g_miss_date
705 , p7_a3 NUMBER := 0-1962.0724
706 , p7_a4 DATE := fnd_api.g_miss_date
707 , p7_a5 NUMBER := 0-1962.0724
708 , p7_a6 NUMBER := 0-1962.0724
709 , p7_a7 NUMBER := 0-1962.0724
710 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
711 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
712 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
713 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
714 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
715 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
716 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
717 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
718 , p7_a16 NUMBER := 0-1962.0724
719 , p7_a17 NUMBER := 0-1962.0724
720 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
721 , p7_a19 NUMBER := 0-1962.0724
722 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
723 , p7_a21 NUMBER := 0-1962.0724
724 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
725 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
726 , p7_a24 NUMBER := 0-1962.0724
727 , p7_a25 NUMBER := 0-1962.0724
728 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
729 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
730 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
731 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
732 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
733 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
734 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
735 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
736 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
737 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
738 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
739 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
740 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
741 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
742 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
743 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
744 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
745 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
746 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
747 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
748 , p7_a46 NUMBER := 0-1962.0724
749 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
750 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
751 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
752 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
753 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
754 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
755 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
756 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
757 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
758 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
759 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
760 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
761 , p7_a59 NUMBER := 0-1962.0724
762 , p7_a60 NUMBER := 0-1962.0724
763 , p7_a61 NUMBER := 0-1962.0724
764 )
765 as
766 ddp_venue_rec ams_venue_pvt.venue_rec_type;
767 ddindx binary_integer; indx binary_integer;
768 begin
769
770 -- copy data to the local IN or IN-OUT args, if any
771
772
773
774
775
776
777
778 ddp_venue_rec.venue_id := rosetta_g_miss_num_map(p7_a0);
779 ddp_venue_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a1);
780 ddp_venue_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
781 ddp_venue_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
782 ddp_venue_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
783 ddp_venue_rec.created_by := rosetta_g_miss_num_map(p7_a5);
784 ddp_venue_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
785 ddp_venue_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
786 ddp_venue_rec.venue_type_code := p7_a8;
787 ddp_venue_rec.venue_type_name := p7_a9;
788 ddp_venue_rec.direct_phone_flag := p7_a10;
789 ddp_venue_rec.internal_flag := p7_a11;
790 ddp_venue_rec.enabled_flag := p7_a12;
791 ddp_venue_rec.rating_code := p7_a13;
792 ddp_venue_rec.telecom_code := p7_a14;
793 ddp_venue_rec.rating_name := p7_a15;
794 ddp_venue_rec.capacity := rosetta_g_miss_num_map(p7_a16);
795 ddp_venue_rec.area_size := rosetta_g_miss_num_map(p7_a17);
796 ddp_venue_rec.area_size_uom_code := p7_a18;
797 ddp_venue_rec.ceiling_height := rosetta_g_miss_num_map(p7_a19);
798 ddp_venue_rec.ceiling_height_uom_code := p7_a20;
799 ddp_venue_rec.usage_cost := rosetta_g_miss_num_map(p7_a21);
800 ddp_venue_rec.usage_cost_uom_code := p7_a22;
801 ddp_venue_rec.usage_cost_currency_code := p7_a23;
802 ddp_venue_rec.parent_venue_id := rosetta_g_miss_num_map(p7_a24);
803 ddp_venue_rec.location_id := rosetta_g_miss_num_map(p7_a25);
804 ddp_venue_rec.directions := p7_a26;
805 ddp_venue_rec.venue_code := p7_a27;
806 ddp_venue_rec.object_type := p7_a28;
807 ddp_venue_rec.attribute_category := p7_a29;
808 ddp_venue_rec.attribute1 := p7_a30;
809 ddp_venue_rec.attribute2 := p7_a31;
810 ddp_venue_rec.attribute3 := p7_a32;
811 ddp_venue_rec.attribute4 := p7_a33;
812 ddp_venue_rec.attribute5 := p7_a34;
813 ddp_venue_rec.attribute6 := p7_a35;
814 ddp_venue_rec.attribute7 := p7_a36;
815 ddp_venue_rec.attribute8 := p7_a37;
816 ddp_venue_rec.attribute9 := p7_a38;
817 ddp_venue_rec.attribute10 := p7_a39;
818 ddp_venue_rec.attribute11 := p7_a40;
819 ddp_venue_rec.attribute12 := p7_a41;
820 ddp_venue_rec.attribute13 := p7_a42;
821 ddp_venue_rec.attribute14 := p7_a43;
822 ddp_venue_rec.attribute15 := p7_a44;
823 ddp_venue_rec.venue_name := p7_a45;
824 ddp_venue_rec.party_id := rosetta_g_miss_num_map(p7_a46);
825 ddp_venue_rec.description := p7_a47;
826 ddp_venue_rec.address1 := p7_a48;
827 ddp_venue_rec.address2 := p7_a49;
828 ddp_venue_rec.address3 := p7_a50;
829 ddp_venue_rec.address4 := p7_a51;
830 ddp_venue_rec.country_code := p7_a52;
831 ddp_venue_rec.country := p7_a53;
832 ddp_venue_rec.city := p7_a54;
833 ddp_venue_rec.postal_code := p7_a55;
834 ddp_venue_rec.state := p7_a56;
835 ddp_venue_rec.province := p7_a57;
836 ddp_venue_rec.county := p7_a58;
837 ddp_venue_rec.salesforce_id := rosetta_g_miss_num_map(p7_a59);
838 ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p7_a60);
839 ddp_venue_rec.person_id := rosetta_g_miss_num_map(p7_a61);
840
841
842 -- here's the delegated call to the old PL/SQL routine
843 ams_venue_pvt.validate_venue(p_api_version,
844 p_init_msg_list,
845 p_commit,
846 p_validation_level,
847 x_return_status,
848 x_msg_count,
849 x_msg_data,
850 ddp_venue_rec,
851 p_object_type);
852
853 -- copy data back from the local OUT or IN-OUT args, if any
854
855
856
857
858
859
860
861
862 end;
863
864 procedure check_venue_items(p_object_type VARCHAR2
865 , p_validation_mode VARCHAR2
866 , x_return_status OUT NOCOPY VARCHAR2
867 , p0_a0 NUMBER := 0-1962.0724
868 , p0_a1 NUMBER := 0-1962.0724
869 , p0_a2 DATE := fnd_api.g_miss_date
870 , p0_a3 NUMBER := 0-1962.0724
871 , p0_a4 DATE := fnd_api.g_miss_date
872 , p0_a5 NUMBER := 0-1962.0724
873 , p0_a6 NUMBER := 0-1962.0724
874 , p0_a7 NUMBER := 0-1962.0724
875 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
876 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
877 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
878 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
879 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
880 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
881 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
882 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
883 , p0_a16 NUMBER := 0-1962.0724
884 , p0_a17 NUMBER := 0-1962.0724
885 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
886 , p0_a19 NUMBER := 0-1962.0724
887 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
888 , p0_a21 NUMBER := 0-1962.0724
889 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
890 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
891 , p0_a24 NUMBER := 0-1962.0724
892 , p0_a25 NUMBER := 0-1962.0724
893 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
894 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
895 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
896 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
897 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
898 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
899 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
900 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
901 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
902 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
903 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
904 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
905 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
906 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
907 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
908 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
909 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
910 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
911 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
912 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
913 , p0_a46 NUMBER := 0-1962.0724
914 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
915 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
916 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
917 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
918 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
919 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
920 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
921 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
922 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
923 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
924 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
925 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
926 , p0_a59 NUMBER := 0-1962.0724
927 , p0_a60 NUMBER := 0-1962.0724
928 , p0_a61 NUMBER := 0-1962.0724
929 )
930 as
931 ddp_venue_rec ams_venue_pvt.venue_rec_type;
932 ddindx binary_integer; indx binary_integer;
933 begin
934
935 -- copy data to the local IN or IN-OUT args, if any
936 ddp_venue_rec.venue_id := rosetta_g_miss_num_map(p0_a0);
937 ddp_venue_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a1);
938 ddp_venue_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
939 ddp_venue_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
940 ddp_venue_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
941 ddp_venue_rec.created_by := rosetta_g_miss_num_map(p0_a5);
942 ddp_venue_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
943 ddp_venue_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
944 ddp_venue_rec.venue_type_code := p0_a8;
945 ddp_venue_rec.venue_type_name := p0_a9;
946 ddp_venue_rec.direct_phone_flag := p0_a10;
947 ddp_venue_rec.internal_flag := p0_a11;
948 ddp_venue_rec.enabled_flag := p0_a12;
949 ddp_venue_rec.rating_code := p0_a13;
950 ddp_venue_rec.telecom_code := p0_a14;
951 ddp_venue_rec.rating_name := p0_a15;
952 ddp_venue_rec.capacity := rosetta_g_miss_num_map(p0_a16);
953 ddp_venue_rec.area_size := rosetta_g_miss_num_map(p0_a17);
954 ddp_venue_rec.area_size_uom_code := p0_a18;
955 ddp_venue_rec.ceiling_height := rosetta_g_miss_num_map(p0_a19);
956 ddp_venue_rec.ceiling_height_uom_code := p0_a20;
957 ddp_venue_rec.usage_cost := rosetta_g_miss_num_map(p0_a21);
958 ddp_venue_rec.usage_cost_uom_code := p0_a22;
959 ddp_venue_rec.usage_cost_currency_code := p0_a23;
960 ddp_venue_rec.parent_venue_id := rosetta_g_miss_num_map(p0_a24);
961 ddp_venue_rec.location_id := rosetta_g_miss_num_map(p0_a25);
962 ddp_venue_rec.directions := p0_a26;
963 ddp_venue_rec.venue_code := p0_a27;
964 ddp_venue_rec.object_type := p0_a28;
965 ddp_venue_rec.attribute_category := p0_a29;
966 ddp_venue_rec.attribute1 := p0_a30;
967 ddp_venue_rec.attribute2 := p0_a31;
968 ddp_venue_rec.attribute3 := p0_a32;
969 ddp_venue_rec.attribute4 := p0_a33;
970 ddp_venue_rec.attribute5 := p0_a34;
971 ddp_venue_rec.attribute6 := p0_a35;
972 ddp_venue_rec.attribute7 := p0_a36;
973 ddp_venue_rec.attribute8 := p0_a37;
974 ddp_venue_rec.attribute9 := p0_a38;
975 ddp_venue_rec.attribute10 := p0_a39;
976 ddp_venue_rec.attribute11 := p0_a40;
977 ddp_venue_rec.attribute12 := p0_a41;
978 ddp_venue_rec.attribute13 := p0_a42;
979 ddp_venue_rec.attribute14 := p0_a43;
980 ddp_venue_rec.attribute15 := p0_a44;
981 ddp_venue_rec.venue_name := p0_a45;
982 ddp_venue_rec.party_id := rosetta_g_miss_num_map(p0_a46);
983 ddp_venue_rec.description := p0_a47;
984 ddp_venue_rec.address1 := p0_a48;
985 ddp_venue_rec.address2 := p0_a49;
986 ddp_venue_rec.address3 := p0_a50;
987 ddp_venue_rec.address4 := p0_a51;
988 ddp_venue_rec.country_code := p0_a52;
989 ddp_venue_rec.country := p0_a53;
990 ddp_venue_rec.city := p0_a54;
991 ddp_venue_rec.postal_code := p0_a55;
992 ddp_venue_rec.state := p0_a56;
993 ddp_venue_rec.province := p0_a57;
994 ddp_venue_rec.county := p0_a58;
995 ddp_venue_rec.salesforce_id := rosetta_g_miss_num_map(p0_a59);
996 ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p0_a60);
997 ddp_venue_rec.person_id := rosetta_g_miss_num_map(p0_a61);
998
999
1000
1001
1002 -- here's the delegated call to the old PL/SQL routine
1003 ams_venue_pvt.check_venue_items(ddp_venue_rec,
1004 p_object_type,
1005 p_validation_mode,
1006 x_return_status);
1007
1008 -- copy data back from the local OUT or IN-OUT args, if any
1009
1010
1011
1012 end;
1013
1014 procedure check_venue_record(x_return_status OUT NOCOPY VARCHAR2
1015 , p0_a0 NUMBER := 0-1962.0724
1016 , p0_a1 NUMBER := 0-1962.0724
1017 , p0_a2 DATE := fnd_api.g_miss_date
1018 , p0_a3 NUMBER := 0-1962.0724
1019 , p0_a4 DATE := fnd_api.g_miss_date
1020 , p0_a5 NUMBER := 0-1962.0724
1021 , p0_a6 NUMBER := 0-1962.0724
1022 , p0_a7 NUMBER := 0-1962.0724
1023 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1024 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
1025 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
1026 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
1027 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
1028 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1029 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1030 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1031 , p0_a16 NUMBER := 0-1962.0724
1032 , p0_a17 NUMBER := 0-1962.0724
1033 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1034 , p0_a19 NUMBER := 0-1962.0724
1035 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1036 , p0_a21 NUMBER := 0-1962.0724
1037 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1038 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1039 , p0_a24 NUMBER := 0-1962.0724
1040 , p0_a25 NUMBER := 0-1962.0724
1041 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1042 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1043 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1044 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
1045 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1046 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
1047 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1048 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
1049 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
1050 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
1051 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
1052 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1053 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1054 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1055 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
1056 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1057 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1058 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1059 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1060 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1061 , p0_a46 NUMBER := 0-1962.0724
1062 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1063 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1064 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1065 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1066 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1067 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1068 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1069 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1070 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1071 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1072 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
1073 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
1074 , p0_a59 NUMBER := 0-1962.0724
1075 , p0_a60 NUMBER := 0-1962.0724
1076 , p0_a61 NUMBER := 0-1962.0724
1077 , p1_a0 NUMBER := 0-1962.0724
1078 , p1_a1 NUMBER := 0-1962.0724
1079 , p1_a2 DATE := fnd_api.g_miss_date
1080 , p1_a3 NUMBER := 0-1962.0724
1081 , p1_a4 DATE := fnd_api.g_miss_date
1082 , p1_a5 NUMBER := 0-1962.0724
1083 , p1_a6 NUMBER := 0-1962.0724
1084 , p1_a7 NUMBER := 0-1962.0724
1085 , p1_a8 VARCHAR2 := fnd_api.g_miss_char
1086 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
1087 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
1088 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
1089 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
1090 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
1091 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
1092 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
1093 , p1_a16 NUMBER := 0-1962.0724
1094 , p1_a17 NUMBER := 0-1962.0724
1095 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
1096 , p1_a19 NUMBER := 0-1962.0724
1097 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
1098 , p1_a21 NUMBER := 0-1962.0724
1099 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
1100 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
1101 , p1_a24 NUMBER := 0-1962.0724
1102 , p1_a25 NUMBER := 0-1962.0724
1103 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
1104 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
1105 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
1106 , p1_a29 VARCHAR2 := fnd_api.g_miss_char
1107 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
1108 , p1_a31 VARCHAR2 := fnd_api.g_miss_char
1109 , p1_a32 VARCHAR2 := fnd_api.g_miss_char
1110 , p1_a33 VARCHAR2 := fnd_api.g_miss_char
1111 , p1_a34 VARCHAR2 := fnd_api.g_miss_char
1112 , p1_a35 VARCHAR2 := fnd_api.g_miss_char
1113 , p1_a36 VARCHAR2 := fnd_api.g_miss_char
1114 , p1_a37 VARCHAR2 := fnd_api.g_miss_char
1115 , p1_a38 VARCHAR2 := fnd_api.g_miss_char
1116 , p1_a39 VARCHAR2 := fnd_api.g_miss_char
1117 , p1_a40 VARCHAR2 := fnd_api.g_miss_char
1118 , p1_a41 VARCHAR2 := fnd_api.g_miss_char
1119 , p1_a42 VARCHAR2 := fnd_api.g_miss_char
1120 , p1_a43 VARCHAR2 := fnd_api.g_miss_char
1121 , p1_a44 VARCHAR2 := fnd_api.g_miss_char
1122 , p1_a45 VARCHAR2 := fnd_api.g_miss_char
1123 , p1_a46 NUMBER := 0-1962.0724
1124 , p1_a47 VARCHAR2 := fnd_api.g_miss_char
1125 , p1_a48 VARCHAR2 := fnd_api.g_miss_char
1126 , p1_a49 VARCHAR2 := fnd_api.g_miss_char
1127 , p1_a50 VARCHAR2 := fnd_api.g_miss_char
1128 , p1_a51 VARCHAR2 := fnd_api.g_miss_char
1129 , p1_a52 VARCHAR2 := fnd_api.g_miss_char
1130 , p1_a53 VARCHAR2 := fnd_api.g_miss_char
1131 , p1_a54 VARCHAR2 := fnd_api.g_miss_char
1132 , p1_a55 VARCHAR2 := fnd_api.g_miss_char
1133 , p1_a56 VARCHAR2 := fnd_api.g_miss_char
1134 , p1_a57 VARCHAR2 := fnd_api.g_miss_char
1135 , p1_a58 VARCHAR2 := fnd_api.g_miss_char
1136 , p1_a59 NUMBER := 0-1962.0724
1137 , p1_a60 NUMBER := 0-1962.0724
1138 , p1_a61 NUMBER := 0-1962.0724
1139 )
1140 as
1141 ddp_venue_rec ams_venue_pvt.venue_rec_type;
1142 ddp_complete_rec ams_venue_pvt.venue_rec_type;
1143 ddindx binary_integer; indx binary_integer;
1144 begin
1145
1146 -- copy data to the local IN or IN-OUT args, if any
1147 ddp_venue_rec.venue_id := rosetta_g_miss_num_map(p0_a0);
1148 ddp_venue_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a1);
1149 ddp_venue_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
1150 ddp_venue_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
1151 ddp_venue_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
1152 ddp_venue_rec.created_by := rosetta_g_miss_num_map(p0_a5);
1153 ddp_venue_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
1154 ddp_venue_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
1155 ddp_venue_rec.venue_type_code := p0_a8;
1156 ddp_venue_rec.venue_type_name := p0_a9;
1157 ddp_venue_rec.direct_phone_flag := p0_a10;
1158 ddp_venue_rec.internal_flag := p0_a11;
1159 ddp_venue_rec.enabled_flag := p0_a12;
1160 ddp_venue_rec.rating_code := p0_a13;
1161 ddp_venue_rec.telecom_code := p0_a14;
1162 ddp_venue_rec.rating_name := p0_a15;
1163 ddp_venue_rec.capacity := rosetta_g_miss_num_map(p0_a16);
1164 ddp_venue_rec.area_size := rosetta_g_miss_num_map(p0_a17);
1165 ddp_venue_rec.area_size_uom_code := p0_a18;
1166 ddp_venue_rec.ceiling_height := rosetta_g_miss_num_map(p0_a19);
1167 ddp_venue_rec.ceiling_height_uom_code := p0_a20;
1168 ddp_venue_rec.usage_cost := rosetta_g_miss_num_map(p0_a21);
1169 ddp_venue_rec.usage_cost_uom_code := p0_a22;
1170 ddp_venue_rec.usage_cost_currency_code := p0_a23;
1171 ddp_venue_rec.parent_venue_id := rosetta_g_miss_num_map(p0_a24);
1172 ddp_venue_rec.location_id := rosetta_g_miss_num_map(p0_a25);
1173 ddp_venue_rec.directions := p0_a26;
1174 ddp_venue_rec.venue_code := p0_a27;
1175 ddp_venue_rec.object_type := p0_a28;
1176 ddp_venue_rec.attribute_category := p0_a29;
1177 ddp_venue_rec.attribute1 := p0_a30;
1178 ddp_venue_rec.attribute2 := p0_a31;
1179 ddp_venue_rec.attribute3 := p0_a32;
1180 ddp_venue_rec.attribute4 := p0_a33;
1181 ddp_venue_rec.attribute5 := p0_a34;
1182 ddp_venue_rec.attribute6 := p0_a35;
1183 ddp_venue_rec.attribute7 := p0_a36;
1184 ddp_venue_rec.attribute8 := p0_a37;
1185 ddp_venue_rec.attribute9 := p0_a38;
1186 ddp_venue_rec.attribute10 := p0_a39;
1187 ddp_venue_rec.attribute11 := p0_a40;
1188 ddp_venue_rec.attribute12 := p0_a41;
1189 ddp_venue_rec.attribute13 := p0_a42;
1190 ddp_venue_rec.attribute14 := p0_a43;
1191 ddp_venue_rec.attribute15 := p0_a44;
1192 ddp_venue_rec.venue_name := p0_a45;
1193 ddp_venue_rec.party_id := rosetta_g_miss_num_map(p0_a46);
1194 ddp_venue_rec.description := p0_a47;
1195 ddp_venue_rec.address1 := p0_a48;
1196 ddp_venue_rec.address2 := p0_a49;
1197 ddp_venue_rec.address3 := p0_a50;
1198 ddp_venue_rec.address4 := p0_a51;
1199 ddp_venue_rec.country_code := p0_a52;
1200 ddp_venue_rec.country := p0_a53;
1201 ddp_venue_rec.city := p0_a54;
1202 ddp_venue_rec.postal_code := p0_a55;
1203 ddp_venue_rec.state := p0_a56;
1204 ddp_venue_rec.province := p0_a57;
1205 ddp_venue_rec.county := p0_a58;
1206 ddp_venue_rec.salesforce_id := rosetta_g_miss_num_map(p0_a59);
1207 ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p0_a60);
1208 ddp_venue_rec.person_id := rosetta_g_miss_num_map(p0_a61);
1209
1210 ddp_complete_rec.venue_id := rosetta_g_miss_num_map(p1_a0);
1211 ddp_complete_rec.custom_setup_id := rosetta_g_miss_num_map(p1_a1);
1212 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a2);
1213 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a3);
1214 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a4);
1215 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a5);
1216 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a6);
1217 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a7);
1218 ddp_complete_rec.venue_type_code := p1_a8;
1219 ddp_complete_rec.venue_type_name := p1_a9;
1220 ddp_complete_rec.direct_phone_flag := p1_a10;
1221 ddp_complete_rec.internal_flag := p1_a11;
1222 ddp_complete_rec.enabled_flag := p1_a12;
1223 ddp_complete_rec.rating_code := p1_a13;
1224 ddp_complete_rec.telecom_code := p1_a14;
1225 ddp_complete_rec.rating_name := p1_a15;
1226 ddp_complete_rec.capacity := rosetta_g_miss_num_map(p1_a16);
1227 ddp_complete_rec.area_size := rosetta_g_miss_num_map(p1_a17);
1228 ddp_complete_rec.area_size_uom_code := p1_a18;
1229 ddp_complete_rec.ceiling_height := rosetta_g_miss_num_map(p1_a19);
1230 ddp_complete_rec.ceiling_height_uom_code := p1_a20;
1231 ddp_complete_rec.usage_cost := rosetta_g_miss_num_map(p1_a21);
1232 ddp_complete_rec.usage_cost_uom_code := p1_a22;
1233 ddp_complete_rec.usage_cost_currency_code := p1_a23;
1234 ddp_complete_rec.parent_venue_id := rosetta_g_miss_num_map(p1_a24);
1235 ddp_complete_rec.location_id := rosetta_g_miss_num_map(p1_a25);
1236 ddp_complete_rec.directions := p1_a26;
1237 ddp_complete_rec.venue_code := p1_a27;
1238 ddp_complete_rec.object_type := p1_a28;
1239 ddp_complete_rec.attribute_category := p1_a29;
1240 ddp_complete_rec.attribute1 := p1_a30;
1241 ddp_complete_rec.attribute2 := p1_a31;
1242 ddp_complete_rec.attribute3 := p1_a32;
1243 ddp_complete_rec.attribute4 := p1_a33;
1244 ddp_complete_rec.attribute5 := p1_a34;
1245 ddp_complete_rec.attribute6 := p1_a35;
1246 ddp_complete_rec.attribute7 := p1_a36;
1247 ddp_complete_rec.attribute8 := p1_a37;
1248 ddp_complete_rec.attribute9 := p1_a38;
1249 ddp_complete_rec.attribute10 := p1_a39;
1250 ddp_complete_rec.attribute11 := p1_a40;
1251 ddp_complete_rec.attribute12 := p1_a41;
1252 ddp_complete_rec.attribute13 := p1_a42;
1253 ddp_complete_rec.attribute14 := p1_a43;
1254 ddp_complete_rec.attribute15 := p1_a44;
1255 ddp_complete_rec.venue_name := p1_a45;
1256 ddp_complete_rec.party_id := rosetta_g_miss_num_map(p1_a46);
1257 ddp_complete_rec.description := p1_a47;
1258 ddp_complete_rec.address1 := p1_a48;
1259 ddp_complete_rec.address2 := p1_a49;
1260 ddp_complete_rec.address3 := p1_a50;
1261 ddp_complete_rec.address4 := p1_a51;
1262 ddp_complete_rec.country_code := p1_a52;
1263 ddp_complete_rec.country := p1_a53;
1264 ddp_complete_rec.city := p1_a54;
1265 ddp_complete_rec.postal_code := p1_a55;
1266 ddp_complete_rec.state := p1_a56;
1267 ddp_complete_rec.province := p1_a57;
1268 ddp_complete_rec.county := p1_a58;
1269 ddp_complete_rec.salesforce_id := rosetta_g_miss_num_map(p1_a59);
1270 ddp_complete_rec.sales_group_id := rosetta_g_miss_num_map(p1_a60);
1271 ddp_complete_rec.person_id := rosetta_g_miss_num_map(p1_a61);
1272
1273
1274 -- here's the delegated call to the old PL/SQL routine
1275 ams_venue_pvt.check_venue_record(ddp_venue_rec,
1276 ddp_complete_rec,
1277 x_return_status);
1278
1279 -- copy data back from the local OUT or IN-OUT args, if any
1280
1281
1282 end;
1283
1284 procedure init_venue_rec(p0_a0 OUT NOCOPY NUMBER
1285 , p0_a1 OUT NOCOPY NUMBER
1286 , p0_a2 OUT NOCOPY DATE
1287 , p0_a3 OUT NOCOPY NUMBER
1288 , p0_a4 OUT NOCOPY DATE
1289 , p0_a5 OUT NOCOPY NUMBER
1290 , p0_a6 OUT NOCOPY NUMBER
1291 , p0_a7 OUT NOCOPY NUMBER
1292 , p0_a8 OUT NOCOPY VARCHAR2
1293 , p0_a9 OUT NOCOPY VARCHAR2
1294 , p0_a10 OUT NOCOPY VARCHAR2
1295 , p0_a11 OUT NOCOPY VARCHAR2
1296 , p0_a12 OUT NOCOPY VARCHAR2
1297 , p0_a13 OUT NOCOPY VARCHAR2
1298 , p0_a14 OUT NOCOPY VARCHAR2
1299 , p0_a15 OUT NOCOPY VARCHAR2
1300 , p0_a16 OUT NOCOPY NUMBER
1301 , p0_a17 OUT NOCOPY NUMBER
1302 , p0_a18 OUT NOCOPY VARCHAR2
1303 , p0_a19 OUT NOCOPY NUMBER
1304 , p0_a20 OUT NOCOPY VARCHAR2
1305 , p0_a21 OUT NOCOPY NUMBER
1306 , p0_a22 OUT NOCOPY VARCHAR2
1307 , p0_a23 OUT NOCOPY VARCHAR2
1308 , p0_a24 OUT NOCOPY NUMBER
1309 , p0_a25 OUT NOCOPY NUMBER
1310 , p0_a26 OUT NOCOPY VARCHAR2
1311 , p0_a27 OUT NOCOPY VARCHAR2
1312 , p0_a28 OUT NOCOPY VARCHAR2
1313 , p0_a29 OUT NOCOPY VARCHAR2
1314 , p0_a30 OUT NOCOPY VARCHAR2
1315 , p0_a31 OUT NOCOPY VARCHAR2
1316 , p0_a32 OUT NOCOPY VARCHAR2
1317 , p0_a33 OUT NOCOPY VARCHAR2
1318 , p0_a34 OUT NOCOPY VARCHAR2
1319 , p0_a35 OUT NOCOPY VARCHAR2
1320 , p0_a36 OUT NOCOPY VARCHAR2
1321 , p0_a37 OUT NOCOPY VARCHAR2
1322 , p0_a38 OUT NOCOPY VARCHAR2
1323 , p0_a39 OUT NOCOPY VARCHAR2
1324 , p0_a40 OUT NOCOPY VARCHAR2
1325 , p0_a41 OUT NOCOPY VARCHAR2
1326 , p0_a42 OUT NOCOPY VARCHAR2
1327 , p0_a43 OUT NOCOPY VARCHAR2
1328 , p0_a44 OUT NOCOPY VARCHAR2
1329 , p0_a45 OUT NOCOPY VARCHAR2
1330 , p0_a46 OUT NOCOPY NUMBER
1331 , p0_a47 OUT NOCOPY VARCHAR2
1332 , p0_a48 OUT NOCOPY VARCHAR2
1333 , p0_a49 OUT NOCOPY VARCHAR2
1334 , p0_a50 OUT NOCOPY VARCHAR2
1335 , p0_a51 OUT NOCOPY VARCHAR2
1336 , p0_a52 OUT NOCOPY VARCHAR2
1337 , p0_a53 OUT NOCOPY VARCHAR2
1338 , p0_a54 OUT NOCOPY VARCHAR2
1339 , p0_a55 OUT NOCOPY VARCHAR2
1340 , p0_a56 OUT NOCOPY VARCHAR2
1341 , p0_a57 OUT NOCOPY VARCHAR2
1342 , p0_a58 OUT NOCOPY VARCHAR2
1343 , p0_a59 OUT NOCOPY NUMBER
1344 , p0_a60 OUT NOCOPY NUMBER
1345 , p0_a61 OUT NOCOPY NUMBER
1346 )
1347 as
1348 ddx_venue_rec ams_venue_pvt.venue_rec_type;
1349 ddindx binary_integer; indx binary_integer;
1350 begin
1351
1352 -- copy data to the local IN or IN-OUT args, if any
1353
1354 -- here's the delegated call to the old PL/SQL routine
1355 ams_venue_pvt.init_venue_rec(ddx_venue_rec);
1356
1357 -- copy data back from the local OUT or IN-OUT args, if any
1358 p0_a0 := rosetta_g_miss_num_map(ddx_venue_rec.venue_id);
1359 p0_a1 := rosetta_g_miss_num_map(ddx_venue_rec.custom_setup_id);
1360 p0_a2 := ddx_venue_rec.last_update_date;
1361 p0_a3 := rosetta_g_miss_num_map(ddx_venue_rec.last_updated_by);
1362 p0_a4 := ddx_venue_rec.creation_date;
1363 p0_a5 := rosetta_g_miss_num_map(ddx_venue_rec.created_by);
1364 p0_a6 := rosetta_g_miss_num_map(ddx_venue_rec.last_update_login);
1365 p0_a7 := rosetta_g_miss_num_map(ddx_venue_rec.object_version_number);
1366 p0_a8 := ddx_venue_rec.venue_type_code;
1367 p0_a9 := ddx_venue_rec.venue_type_name;
1368 p0_a10 := ddx_venue_rec.direct_phone_flag;
1369 p0_a11 := ddx_venue_rec.internal_flag;
1370 p0_a12 := ddx_venue_rec.enabled_flag;
1371 p0_a13 := ddx_venue_rec.rating_code;
1372 p0_a14 := ddx_venue_rec.telecom_code;
1373 p0_a15 := ddx_venue_rec.rating_name;
1374 p0_a16 := rosetta_g_miss_num_map(ddx_venue_rec.capacity);
1375 p0_a17 := rosetta_g_miss_num_map(ddx_venue_rec.area_size);
1376 p0_a18 := ddx_venue_rec.area_size_uom_code;
1377 p0_a19 := rosetta_g_miss_num_map(ddx_venue_rec.ceiling_height);
1378 p0_a20 := ddx_venue_rec.ceiling_height_uom_code;
1379 p0_a21 := rosetta_g_miss_num_map(ddx_venue_rec.usage_cost);
1380 p0_a22 := ddx_venue_rec.usage_cost_uom_code;
1381 p0_a23 := ddx_venue_rec.usage_cost_currency_code;
1382 p0_a24 := rosetta_g_miss_num_map(ddx_venue_rec.parent_venue_id);
1383 p0_a25 := rosetta_g_miss_num_map(ddx_venue_rec.location_id);
1384 p0_a26 := ddx_venue_rec.directions;
1385 p0_a27 := ddx_venue_rec.venue_code;
1386 p0_a28 := ddx_venue_rec.object_type;
1387 p0_a29 := ddx_venue_rec.attribute_category;
1388 p0_a30 := ddx_venue_rec.attribute1;
1389 p0_a31 := ddx_venue_rec.attribute2;
1390 p0_a32 := ddx_venue_rec.attribute3;
1391 p0_a33 := ddx_venue_rec.attribute4;
1392 p0_a34 := ddx_venue_rec.attribute5;
1393 p0_a35 := ddx_venue_rec.attribute6;
1394 p0_a36 := ddx_venue_rec.attribute7;
1395 p0_a37 := ddx_venue_rec.attribute8;
1396 p0_a38 := ddx_venue_rec.attribute9;
1397 p0_a39 := ddx_venue_rec.attribute10;
1398 p0_a40 := ddx_venue_rec.attribute11;
1399 p0_a41 := ddx_venue_rec.attribute12;
1400 p0_a42 := ddx_venue_rec.attribute13;
1401 p0_a43 := ddx_venue_rec.attribute14;
1402 p0_a44 := ddx_venue_rec.attribute15;
1403 p0_a45 := ddx_venue_rec.venue_name;
1404 p0_a46 := rosetta_g_miss_num_map(ddx_venue_rec.party_id);
1405 p0_a47 := ddx_venue_rec.description;
1406 p0_a48 := ddx_venue_rec.address1;
1407 p0_a49 := ddx_venue_rec.address2;
1408 p0_a50 := ddx_venue_rec.address3;
1409 p0_a51 := ddx_venue_rec.address4;
1410 p0_a52 := ddx_venue_rec.country_code;
1411 p0_a53 := ddx_venue_rec.country;
1412 p0_a54 := ddx_venue_rec.city;
1413 p0_a55 := ddx_venue_rec.postal_code;
1414 p0_a56 := ddx_venue_rec.state;
1415 p0_a57 := ddx_venue_rec.province;
1416 p0_a58 := ddx_venue_rec.county;
1417 p0_a59 := rosetta_g_miss_num_map(ddx_venue_rec.salesforce_id);
1418 p0_a60 := rosetta_g_miss_num_map(ddx_venue_rec.sales_group_id);
1419 p0_a61 := rosetta_g_miss_num_map(ddx_venue_rec.person_id);
1420 end;
1421
1422 procedure complete_venue_rec(p1_a0 OUT NOCOPY NUMBER
1423 , p1_a1 OUT NOCOPY NUMBER
1424 , p1_a2 OUT NOCOPY DATE
1425 , p1_a3 OUT NOCOPY NUMBER
1426 , p1_a4 OUT NOCOPY DATE
1427 , p1_a5 OUT NOCOPY NUMBER
1428 , p1_a6 OUT NOCOPY NUMBER
1429 , p1_a7 OUT NOCOPY NUMBER
1430 , p1_a8 OUT NOCOPY VARCHAR2
1431 , p1_a9 OUT NOCOPY VARCHAR2
1432 , p1_a10 OUT NOCOPY VARCHAR2
1433 , p1_a11 OUT NOCOPY VARCHAR2
1434 , p1_a12 OUT NOCOPY VARCHAR2
1435 , p1_a13 OUT NOCOPY VARCHAR2
1436 , p1_a14 OUT NOCOPY VARCHAR2
1437 , p1_a15 OUT NOCOPY VARCHAR2
1438 , p1_a16 OUT NOCOPY NUMBER
1439 , p1_a17 OUT NOCOPY NUMBER
1440 , p1_a18 OUT NOCOPY VARCHAR2
1441 , p1_a19 OUT NOCOPY NUMBER
1442 , p1_a20 OUT NOCOPY VARCHAR2
1443 , p1_a21 OUT NOCOPY NUMBER
1444 , p1_a22 OUT NOCOPY VARCHAR2
1445 , p1_a23 OUT NOCOPY VARCHAR2
1446 , p1_a24 OUT NOCOPY NUMBER
1447 , p1_a25 OUT NOCOPY NUMBER
1448 , p1_a26 OUT NOCOPY VARCHAR2
1449 , p1_a27 OUT NOCOPY VARCHAR2
1450 , p1_a28 OUT NOCOPY VARCHAR2
1451 , p1_a29 OUT NOCOPY VARCHAR2
1452 , p1_a30 OUT NOCOPY VARCHAR2
1453 , p1_a31 OUT NOCOPY VARCHAR2
1454 , p1_a32 OUT NOCOPY VARCHAR2
1455 , p1_a33 OUT NOCOPY VARCHAR2
1456 , p1_a34 OUT NOCOPY VARCHAR2
1457 , p1_a35 OUT NOCOPY VARCHAR2
1458 , p1_a36 OUT NOCOPY VARCHAR2
1459 , p1_a37 OUT NOCOPY VARCHAR2
1460 , p1_a38 OUT NOCOPY VARCHAR2
1461 , p1_a39 OUT NOCOPY VARCHAR2
1462 , p1_a40 OUT NOCOPY VARCHAR2
1463 , p1_a41 OUT NOCOPY VARCHAR2
1464 , p1_a42 OUT NOCOPY VARCHAR2
1465 , p1_a43 OUT NOCOPY VARCHAR2
1466 , p1_a44 OUT NOCOPY VARCHAR2
1467 , p1_a45 OUT NOCOPY VARCHAR2
1468 , p1_a46 OUT NOCOPY NUMBER
1469 , p1_a47 OUT NOCOPY VARCHAR2
1470 , p1_a48 OUT NOCOPY VARCHAR2
1471 , p1_a49 OUT NOCOPY VARCHAR2
1472 , p1_a50 OUT NOCOPY VARCHAR2
1473 , p1_a51 OUT NOCOPY VARCHAR2
1474 , p1_a52 OUT NOCOPY VARCHAR2
1475 , p1_a53 OUT NOCOPY VARCHAR2
1476 , p1_a54 OUT NOCOPY VARCHAR2
1477 , p1_a55 OUT NOCOPY VARCHAR2
1478 , p1_a56 OUT NOCOPY VARCHAR2
1479 , p1_a57 OUT NOCOPY VARCHAR2
1480 , p1_a58 OUT NOCOPY VARCHAR2
1481 , p1_a59 OUT NOCOPY NUMBER
1482 , p1_a60 OUT NOCOPY NUMBER
1483 , p1_a61 OUT NOCOPY NUMBER
1484 , p0_a0 NUMBER := 0-1962.0724
1485 , p0_a1 NUMBER := 0-1962.0724
1486 , p0_a2 DATE := fnd_api.g_miss_date
1487 , p0_a3 NUMBER := 0-1962.0724
1488 , p0_a4 DATE := fnd_api.g_miss_date
1489 , p0_a5 NUMBER := 0-1962.0724
1490 , p0_a6 NUMBER := 0-1962.0724
1491 , p0_a7 NUMBER := 0-1962.0724
1492 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1493 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
1494 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
1495 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
1496 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
1497 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1498 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1499 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1500 , p0_a16 NUMBER := 0-1962.0724
1501 , p0_a17 NUMBER := 0-1962.0724
1502 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1503 , p0_a19 NUMBER := 0-1962.0724
1504 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1505 , p0_a21 NUMBER := 0-1962.0724
1506 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1507 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1508 , p0_a24 NUMBER := 0-1962.0724
1509 , p0_a25 NUMBER := 0-1962.0724
1510 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1511 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1512 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1513 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
1514 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1515 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
1516 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1517 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
1518 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
1519 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
1520 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
1521 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1522 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1523 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1524 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
1525 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1526 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1527 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1528 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1529 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1530 , p0_a46 NUMBER := 0-1962.0724
1531 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1532 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1533 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1534 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1535 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1536 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1537 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1538 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1539 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1540 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1541 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
1542 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
1543 , p0_a59 NUMBER := 0-1962.0724
1544 , p0_a60 NUMBER := 0-1962.0724
1545 , p0_a61 NUMBER := 0-1962.0724
1546 )
1547 as
1548 ddp_venue_rec ams_venue_pvt.venue_rec_type;
1549 ddx_complete_rec ams_venue_pvt.venue_rec_type;
1550 ddindx binary_integer; indx binary_integer;
1551 begin
1552
1553 -- copy data to the local IN or IN-OUT args, if any
1554 ddp_venue_rec.venue_id := rosetta_g_miss_num_map(p0_a0);
1555 ddp_venue_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a1);
1556 ddp_venue_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
1557 ddp_venue_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
1558 ddp_venue_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
1559 ddp_venue_rec.created_by := rosetta_g_miss_num_map(p0_a5);
1560 ddp_venue_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
1561 ddp_venue_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
1562 ddp_venue_rec.venue_type_code := p0_a8;
1563 ddp_venue_rec.venue_type_name := p0_a9;
1564 ddp_venue_rec.direct_phone_flag := p0_a10;
1565 ddp_venue_rec.internal_flag := p0_a11;
1566 ddp_venue_rec.enabled_flag := p0_a12;
1567 ddp_venue_rec.rating_code := p0_a13;
1568 ddp_venue_rec.telecom_code := p0_a14;
1569 ddp_venue_rec.rating_name := p0_a15;
1570 ddp_venue_rec.capacity := rosetta_g_miss_num_map(p0_a16);
1571 ddp_venue_rec.area_size := rosetta_g_miss_num_map(p0_a17);
1572 ddp_venue_rec.area_size_uom_code := p0_a18;
1573 ddp_venue_rec.ceiling_height := rosetta_g_miss_num_map(p0_a19);
1574 ddp_venue_rec.ceiling_height_uom_code := p0_a20;
1575 ddp_venue_rec.usage_cost := rosetta_g_miss_num_map(p0_a21);
1576 ddp_venue_rec.usage_cost_uom_code := p0_a22;
1577 ddp_venue_rec.usage_cost_currency_code := p0_a23;
1578 ddp_venue_rec.parent_venue_id := rosetta_g_miss_num_map(p0_a24);
1579 ddp_venue_rec.location_id := rosetta_g_miss_num_map(p0_a25);
1580 ddp_venue_rec.directions := p0_a26;
1581 ddp_venue_rec.venue_code := p0_a27;
1582 ddp_venue_rec.object_type := p0_a28;
1583 ddp_venue_rec.attribute_category := p0_a29;
1584 ddp_venue_rec.attribute1 := p0_a30;
1585 ddp_venue_rec.attribute2 := p0_a31;
1586 ddp_venue_rec.attribute3 := p0_a32;
1587 ddp_venue_rec.attribute4 := p0_a33;
1588 ddp_venue_rec.attribute5 := p0_a34;
1589 ddp_venue_rec.attribute6 := p0_a35;
1590 ddp_venue_rec.attribute7 := p0_a36;
1591 ddp_venue_rec.attribute8 := p0_a37;
1592 ddp_venue_rec.attribute9 := p0_a38;
1593 ddp_venue_rec.attribute10 := p0_a39;
1594 ddp_venue_rec.attribute11 := p0_a40;
1595 ddp_venue_rec.attribute12 := p0_a41;
1596 ddp_venue_rec.attribute13 := p0_a42;
1597 ddp_venue_rec.attribute14 := p0_a43;
1598 ddp_venue_rec.attribute15 := p0_a44;
1599 ddp_venue_rec.venue_name := p0_a45;
1600 ddp_venue_rec.party_id := rosetta_g_miss_num_map(p0_a46);
1601 ddp_venue_rec.description := p0_a47;
1602 ddp_venue_rec.address1 := p0_a48;
1603 ddp_venue_rec.address2 := p0_a49;
1604 ddp_venue_rec.address3 := p0_a50;
1605 ddp_venue_rec.address4 := p0_a51;
1606 ddp_venue_rec.country_code := p0_a52;
1607 ddp_venue_rec.country := p0_a53;
1608 ddp_venue_rec.city := p0_a54;
1609 ddp_venue_rec.postal_code := p0_a55;
1610 ddp_venue_rec.state := p0_a56;
1611 ddp_venue_rec.province := p0_a57;
1612 ddp_venue_rec.county := p0_a58;
1613 ddp_venue_rec.salesforce_id := rosetta_g_miss_num_map(p0_a59);
1614 ddp_venue_rec.sales_group_id := rosetta_g_miss_num_map(p0_a60);
1615 ddp_venue_rec.person_id := rosetta_g_miss_num_map(p0_a61);
1616
1617
1618 -- here's the delegated call to the old PL/SQL routine
1619 ams_venue_pvt.complete_venue_rec(ddp_venue_rec,
1620 ddx_complete_rec);
1621
1622 -- copy data back from the local OUT or IN-OUT args, if any
1623
1624 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.venue_id);
1625 p1_a1 := rosetta_g_miss_num_map(ddx_complete_rec.custom_setup_id);
1626 p1_a2 := ddx_complete_rec.last_update_date;
1627 p1_a3 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
1628 p1_a4 := ddx_complete_rec.creation_date;
1629 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
1630 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
1631 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
1632 p1_a8 := ddx_complete_rec.venue_type_code;
1633 p1_a9 := ddx_complete_rec.venue_type_name;
1634 p1_a10 := ddx_complete_rec.direct_phone_flag;
1635 p1_a11 := ddx_complete_rec.internal_flag;
1636 p1_a12 := ddx_complete_rec.enabled_flag;
1637 p1_a13 := ddx_complete_rec.rating_code;
1638 p1_a14 := ddx_complete_rec.telecom_code;
1639 p1_a15 := ddx_complete_rec.rating_name;
1640 p1_a16 := rosetta_g_miss_num_map(ddx_complete_rec.capacity);
1641 p1_a17 := rosetta_g_miss_num_map(ddx_complete_rec.area_size);
1642 p1_a18 := ddx_complete_rec.area_size_uom_code;
1643 p1_a19 := rosetta_g_miss_num_map(ddx_complete_rec.ceiling_height);
1644 p1_a20 := ddx_complete_rec.ceiling_height_uom_code;
1645 p1_a21 := rosetta_g_miss_num_map(ddx_complete_rec.usage_cost);
1646 p1_a22 := ddx_complete_rec.usage_cost_uom_code;
1647 p1_a23 := ddx_complete_rec.usage_cost_currency_code;
1648 p1_a24 := rosetta_g_miss_num_map(ddx_complete_rec.parent_venue_id);
1649 p1_a25 := rosetta_g_miss_num_map(ddx_complete_rec.location_id);
1650 p1_a26 := ddx_complete_rec.directions;
1651 p1_a27 := ddx_complete_rec.venue_code;
1652 p1_a28 := ddx_complete_rec.object_type;
1653 p1_a29 := ddx_complete_rec.attribute_category;
1654 p1_a30 := ddx_complete_rec.attribute1;
1655 p1_a31 := ddx_complete_rec.attribute2;
1656 p1_a32 := ddx_complete_rec.attribute3;
1657 p1_a33 := ddx_complete_rec.attribute4;
1658 p1_a34 := ddx_complete_rec.attribute5;
1659 p1_a35 := ddx_complete_rec.attribute6;
1660 p1_a36 := ddx_complete_rec.attribute7;
1661 p1_a37 := ddx_complete_rec.attribute8;
1662 p1_a38 := ddx_complete_rec.attribute9;
1663 p1_a39 := ddx_complete_rec.attribute10;
1664 p1_a40 := ddx_complete_rec.attribute11;
1665 p1_a41 := ddx_complete_rec.attribute12;
1666 p1_a42 := ddx_complete_rec.attribute13;
1667 p1_a43 := ddx_complete_rec.attribute14;
1668 p1_a44 := ddx_complete_rec.attribute15;
1669 p1_a45 := ddx_complete_rec.venue_name;
1670 p1_a46 := rosetta_g_miss_num_map(ddx_complete_rec.party_id);
1671 p1_a47 := ddx_complete_rec.description;
1672 p1_a48 := ddx_complete_rec.address1;
1673 p1_a49 := ddx_complete_rec.address2;
1674 p1_a50 := ddx_complete_rec.address3;
1675 p1_a51 := ddx_complete_rec.address4;
1676 p1_a52 := ddx_complete_rec.country_code;
1677 p1_a53 := ddx_complete_rec.country;
1678 p1_a54 := ddx_complete_rec.city;
1679 p1_a55 := ddx_complete_rec.postal_code;
1680 p1_a56 := ddx_complete_rec.state;
1681 p1_a57 := ddx_complete_rec.province;
1682 p1_a58 := ddx_complete_rec.county;
1683 p1_a59 := rosetta_g_miss_num_map(ddx_complete_rec.salesforce_id);
1684 p1_a60 := rosetta_g_miss_num_map(ddx_complete_rec.sales_group_id);
1685 p1_a61 := rosetta_g_miss_num_map(ddx_complete_rec.person_id);
1686 end;
1687
1688 end ams_venue_pvt_w;