[Home] [Help]
PACKAGE BODY: APPS.AMS_CUST_SETUP_PVT_W
Source
1 package body ams_cust_setup_pvt_w as
2 /* $Header: amswcusb.pls 120.1 2005/08/25 23:42 vmodur noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure create_cust_setup(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_cust_setup_id out nocopy NUMBER
30 , p7_a0 NUMBER := 0-1962.0724
31 , p7_a1 DATE := fnd_api.g_miss_date
32 , p7_a2 NUMBER := 0-1962.0724
33 , p7_a3 DATE := fnd_api.g_miss_date
34 , p7_a4 NUMBER := 0-1962.0724
35 , p7_a5 NUMBER := 0-1962.0724
36 , p7_a6 NUMBER := 0-1962.0724
37 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38 , p7_a8 NUMBER := 0-1962.0724
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 )
48
49 as
50 ddp_cust_setup_rec ams_cust_setup_pvt.cust_setup_rec_type;
51 ddindx binary_integer; indx binary_integer;
52 begin
53
54 -- copy data to the local IN or IN-OUT args, if any
55
56
57
58
59
60
61
62 ddp_cust_setup_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a0);
63 ddp_cust_setup_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
64 ddp_cust_setup_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
65 ddp_cust_setup_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
66 ddp_cust_setup_rec.created_by := rosetta_g_miss_num_map(p7_a4);
67 ddp_cust_setup_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
68 ddp_cust_setup_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
69 ddp_cust_setup_rec.activity_type_code := p7_a7;
70 ddp_cust_setup_rec.media_id := rosetta_g_miss_num_map(p7_a8);
71 ddp_cust_setup_rec.enabled_flag := p7_a9;
72 ddp_cust_setup_rec.allow_essential_grouping := p7_a10;
73 ddp_cust_setup_rec.usage := p7_a11;
74 ddp_cust_setup_rec.object_type := p7_a12;
75 ddp_cust_setup_rec.source_code_suffix := p7_a13;
76 ddp_cust_setup_rec.setup_name := p7_a14;
77 ddp_cust_setup_rec.description := p7_a15;
78 ddp_cust_setup_rec.application_id := rosetta_g_miss_num_map(p7_a16);
79
80
81 -- here's the delegated call to the old PL/SQL routine
82 ams_cust_setup_pvt.create_cust_setup(p_api_version,
83 p_init_msg_list,
84 p_commit,
85 p_validation_level,
86 x_return_status,
87 x_msg_count,
88 x_msg_data,
89 ddp_cust_setup_rec,
90 x_cust_setup_id);
91
92 -- copy data back from the local variables to OUT or IN-OUT args, if any
93
94
95
96
97
98
99
100
101 end;
102
103 procedure update_cust_setup(p_api_version NUMBER
104 , p_init_msg_list VARCHAR2
105 , p_commit VARCHAR2
106 , p_validation_level NUMBER
107 , x_return_status out nocopy VARCHAR2
108 , x_msg_count out nocopy NUMBER
109 , x_msg_data out nocopy VARCHAR2
110 , p7_a0 NUMBER := 0-1962.0724
111 , p7_a1 DATE := fnd_api.g_miss_date
112 , p7_a2 NUMBER := 0-1962.0724
113 , p7_a3 DATE := fnd_api.g_miss_date
114 , p7_a4 NUMBER := 0-1962.0724
115 , p7_a5 NUMBER := 0-1962.0724
116 , p7_a6 NUMBER := 0-1962.0724
117 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
118 , p7_a8 NUMBER := 0-1962.0724
119 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
120 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
121 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
122 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
123 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
124 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
125 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
126 , p7_a16 NUMBER := 0-1962.0724
127 )
128
129 as
130 ddp_cust_setup_rec ams_cust_setup_pvt.cust_setup_rec_type;
131 ddindx binary_integer; indx binary_integer;
132 begin
133
134 -- copy data to the local IN or IN-OUT args, if any
135
136
137
138
139
140
141
142 ddp_cust_setup_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a0);
143 ddp_cust_setup_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
144 ddp_cust_setup_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
145 ddp_cust_setup_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
146 ddp_cust_setup_rec.created_by := rosetta_g_miss_num_map(p7_a4);
147 ddp_cust_setup_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
148 ddp_cust_setup_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
149 ddp_cust_setup_rec.activity_type_code := p7_a7;
150 ddp_cust_setup_rec.media_id := rosetta_g_miss_num_map(p7_a8);
151 ddp_cust_setup_rec.enabled_flag := p7_a9;
152 ddp_cust_setup_rec.allow_essential_grouping := p7_a10;
153 ddp_cust_setup_rec.usage := p7_a11;
154 ddp_cust_setup_rec.object_type := p7_a12;
155 ddp_cust_setup_rec.source_code_suffix := p7_a13;
156 ddp_cust_setup_rec.setup_name := p7_a14;
157 ddp_cust_setup_rec.description := p7_a15;
158 ddp_cust_setup_rec.application_id := rosetta_g_miss_num_map(p7_a16);
159
160 -- here's the delegated call to the old PL/SQL routine
161 ams_cust_setup_pvt.update_cust_setup(p_api_version,
162 p_init_msg_list,
163 p_commit,
164 p_validation_level,
165 x_return_status,
166 x_msg_count,
167 x_msg_data,
168 ddp_cust_setup_rec);
169
170 -- copy data back from the local variables to OUT or IN-OUT args, if any
171
172
173
174
175
176
177
178 end;
179
180 procedure validate_cust_setup(p_api_version NUMBER
181 , p_init_msg_list VARCHAR2
182 , p_validation_level NUMBER
183 , x_return_status out nocopy VARCHAR2
184 , x_msg_count out nocopy NUMBER
185 , x_msg_data out nocopy VARCHAR2
186 , p6_a0 NUMBER := 0-1962.0724
187 , p6_a1 DATE := fnd_api.g_miss_date
188 , p6_a2 NUMBER := 0-1962.0724
189 , p6_a3 DATE := fnd_api.g_miss_date
190 , p6_a4 NUMBER := 0-1962.0724
191 , p6_a5 NUMBER := 0-1962.0724
192 , p6_a6 NUMBER := 0-1962.0724
193 , p6_a7 VARCHAR2 := fnd_api.g_miss_char
194 , p6_a8 NUMBER := 0-1962.0724
195 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
196 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
197 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
198 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
199 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
200 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
201 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
202 , p6_a16 NUMBER := 0-1962.0724
203 )
204
205 as
206 ddp_cust_setup_rec ams_cust_setup_pvt.cust_setup_rec_type;
207 ddindx binary_integer; indx binary_integer;
208 begin
209
210 -- copy data to the local IN or IN-OUT args, if any
211
212
213
214
215
216
217 ddp_cust_setup_rec.custom_setup_id := rosetta_g_miss_num_map(p6_a0);
218 ddp_cust_setup_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
219 ddp_cust_setup_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
220 ddp_cust_setup_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
221 ddp_cust_setup_rec.created_by := rosetta_g_miss_num_map(p6_a4);
222 ddp_cust_setup_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
223 ddp_cust_setup_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
224 ddp_cust_setup_rec.activity_type_code := p6_a7;
225 ddp_cust_setup_rec.media_id := rosetta_g_miss_num_map(p6_a8);
226 ddp_cust_setup_rec.enabled_flag := p6_a9;
227 ddp_cust_setup_rec.allow_essential_grouping := p6_a10;
228 ddp_cust_setup_rec.usage := p6_a11;
229 ddp_cust_setup_rec.object_type := p6_a12;
230 ddp_cust_setup_rec.source_code_suffix := p6_a13;
231 ddp_cust_setup_rec.setup_name := p6_a14;
232 ddp_cust_setup_rec.description := p6_a15;
233 ddp_cust_setup_rec.application_id := rosetta_g_miss_num_map(p6_a16);
234
235 -- here's the delegated call to the old PL/SQL routine
236 ams_cust_setup_pvt.validate_cust_setup(p_api_version,
237 p_init_msg_list,
238 p_validation_level,
239 x_return_status,
240 x_msg_count,
241 x_msg_data,
242 ddp_cust_setup_rec);
243
244 -- copy data back from the local variables to OUT or IN-OUT args, if any
245
246
247
248
249
250
251 end;
252
253 procedure check_items(p_validation_mode VARCHAR2
254 , x_return_status out nocopy VARCHAR2
255 , p2_a0 NUMBER := 0-1962.0724
256 , p2_a1 DATE := fnd_api.g_miss_date
257 , p2_a2 NUMBER := 0-1962.0724
258 , p2_a3 DATE := fnd_api.g_miss_date
259 , p2_a4 NUMBER := 0-1962.0724
260 , p2_a5 NUMBER := 0-1962.0724
261 , p2_a6 NUMBER := 0-1962.0724
262 , p2_a7 VARCHAR2 := fnd_api.g_miss_char
263 , p2_a8 NUMBER := 0-1962.0724
264 , p2_a9 VARCHAR2 := fnd_api.g_miss_char
265 , p2_a10 VARCHAR2 := fnd_api.g_miss_char
266 , p2_a11 VARCHAR2 := fnd_api.g_miss_char
267 , p2_a12 VARCHAR2 := fnd_api.g_miss_char
268 , p2_a13 VARCHAR2 := fnd_api.g_miss_char
269 , p2_a14 VARCHAR2 := fnd_api.g_miss_char
270 , p2_a15 VARCHAR2 := fnd_api.g_miss_char
271 , p2_a16 NUMBER := 0-1962.0724
272 )
273
274 as
275 ddp_cust_setup_rec ams_cust_setup_pvt.cust_setup_rec_type;
276 ddindx binary_integer; indx binary_integer;
277 begin
278
279 -- copy data to the local IN or IN-OUT args, if any
280
281
282 ddp_cust_setup_rec.custom_setup_id := rosetta_g_miss_num_map(p2_a0);
283 ddp_cust_setup_rec.last_update_date := rosetta_g_miss_date_in_map(p2_a1);
284 ddp_cust_setup_rec.last_updated_by := rosetta_g_miss_num_map(p2_a2);
285 ddp_cust_setup_rec.creation_date := rosetta_g_miss_date_in_map(p2_a3);
286 ddp_cust_setup_rec.created_by := rosetta_g_miss_num_map(p2_a4);
287 ddp_cust_setup_rec.last_update_login := rosetta_g_miss_num_map(p2_a5);
288 ddp_cust_setup_rec.object_version_number := rosetta_g_miss_num_map(p2_a6);
289 ddp_cust_setup_rec.activity_type_code := p2_a7;
290 ddp_cust_setup_rec.media_id := rosetta_g_miss_num_map(p2_a8);
291 ddp_cust_setup_rec.enabled_flag := p2_a9;
292 ddp_cust_setup_rec.allow_essential_grouping := p2_a10;
293 ddp_cust_setup_rec.usage := p2_a11;
294 ddp_cust_setup_rec.object_type := p2_a12;
295 ddp_cust_setup_rec.source_code_suffix := p2_a13;
296 ddp_cust_setup_rec.setup_name := p2_a14;
297 ddp_cust_setup_rec.description := p2_a15;
298 ddp_cust_setup_rec.application_id := rosetta_g_miss_num_map(p2_a16);
299
300 -- here's the delegated call to the old PL/SQL routine
301 ams_cust_setup_pvt.check_items(p_validation_mode,
302 x_return_status,
303 ddp_cust_setup_rec);
304
305 -- copy data back from the local variables to OUT or IN-OUT args, if any
306
307
308 end;
309
310 procedure check_cust_setup_req_items(p_validation_mode VARCHAR2
311 , x_return_status out nocopy VARCHAR2
312 , p1_a0 NUMBER := 0-1962.0724
313 , p1_a1 DATE := fnd_api.g_miss_date
314 , p1_a2 NUMBER := 0-1962.0724
315 , p1_a3 DATE := fnd_api.g_miss_date
316 , p1_a4 NUMBER := 0-1962.0724
317 , p1_a5 NUMBER := 0-1962.0724
318 , p1_a6 NUMBER := 0-1962.0724
319 , p1_a7 VARCHAR2 := fnd_api.g_miss_char
320 , p1_a8 NUMBER := 0-1962.0724
321 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
322 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
323 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
324 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
325 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
326 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
327 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
328 , p1_a16 NUMBER := 0-1962.0724
329 )
330
331 as
332 ddp_cust_setup_rec ams_cust_setup_pvt.cust_setup_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 ddp_cust_setup_rec.custom_setup_id := rosetta_g_miss_num_map(p1_a0);
339 ddp_cust_setup_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
340 ddp_cust_setup_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
341 ddp_cust_setup_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
342 ddp_cust_setup_rec.created_by := rosetta_g_miss_num_map(p1_a4);
343 ddp_cust_setup_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
344 ddp_cust_setup_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
345 ddp_cust_setup_rec.activity_type_code := p1_a7;
346 ddp_cust_setup_rec.media_id := rosetta_g_miss_num_map(p1_a8);
347 ddp_cust_setup_rec.enabled_flag := p1_a9;
348 ddp_cust_setup_rec.allow_essential_grouping := p1_a10;
349 ddp_cust_setup_rec.usage := p1_a11;
350 ddp_cust_setup_rec.object_type := p1_a12;
351 ddp_cust_setup_rec.source_code_suffix := p1_a13;
352 ddp_cust_setup_rec.setup_name := p1_a14;
353 ddp_cust_setup_rec.description := p1_a15;
354 ddp_cust_setup_rec.application_id := rosetta_g_miss_num_map(p1_a16);
355
356
357 -- here's the delegated call to the old PL/SQL routine
358 ams_cust_setup_pvt.check_cust_setup_req_items(p_validation_mode,
359 ddp_cust_setup_rec,
360 x_return_status);
361
362 -- copy data back from the local variables to OUT or IN-OUT args, if any
363
364
365 end;
366
367 procedure check_cust_setup_uk_items(p_validation_mode VARCHAR2
368 , x_return_status out nocopy VARCHAR2
369 , p1_a0 NUMBER := 0-1962.0724
370 , p1_a1 DATE := fnd_api.g_miss_date
371 , p1_a2 NUMBER := 0-1962.0724
372 , p1_a3 DATE := fnd_api.g_miss_date
373 , p1_a4 NUMBER := 0-1962.0724
374 , p1_a5 NUMBER := 0-1962.0724
375 , p1_a6 NUMBER := 0-1962.0724
376 , p1_a7 VARCHAR2 := fnd_api.g_miss_char
377 , p1_a8 NUMBER := 0-1962.0724
378 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
379 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
383 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
380 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
381 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
382 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
384 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
385 , p1_a16 NUMBER := 0-1962.0724
386 )
387
388 as
389 ddp_cust_setup_rec ams_cust_setup_pvt.cust_setup_rec_type;
390 ddindx binary_integer; indx binary_integer;
391 begin
392
393 -- copy data to the local IN or IN-OUT args, if any
394
395 ddp_cust_setup_rec.custom_setup_id := rosetta_g_miss_num_map(p1_a0);
396 ddp_cust_setup_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
397 ddp_cust_setup_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
398 ddp_cust_setup_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
399 ddp_cust_setup_rec.created_by := rosetta_g_miss_num_map(p1_a4);
400 ddp_cust_setup_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
401 ddp_cust_setup_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
402 ddp_cust_setup_rec.activity_type_code := p1_a7;
403 ddp_cust_setup_rec.media_id := rosetta_g_miss_num_map(p1_a8);
404 ddp_cust_setup_rec.enabled_flag := p1_a9;
405 ddp_cust_setup_rec.allow_essential_grouping := p1_a10;
406 ddp_cust_setup_rec.usage := p1_a11;
407 ddp_cust_setup_rec.object_type := p1_a12;
408 ddp_cust_setup_rec.source_code_suffix := p1_a13;
409 ddp_cust_setup_rec.setup_name := p1_a14;
410 ddp_cust_setup_rec.description := p1_a15;
411 ddp_cust_setup_rec.application_id := rosetta_g_miss_num_map(p1_a16);
412
413
414 -- here's the delegated call to the old PL/SQL routine
415 ams_cust_setup_pvt.check_cust_setup_uk_items(p_validation_mode,
416 ddp_cust_setup_rec,
417 x_return_status);
418
419 -- copy data back from the local variables to OUT or IN-OUT args, if any
420
421
422 end;
423
424 procedure check_cust_setup_fk_items(x_return_status out nocopy VARCHAR2
425 , p0_a0 NUMBER := 0-1962.0724
426 , p0_a1 DATE := fnd_api.g_miss_date
427 , p0_a2 NUMBER := 0-1962.0724
428 , p0_a3 DATE := fnd_api.g_miss_date
429 , p0_a4 NUMBER := 0-1962.0724
430 , p0_a5 NUMBER := 0-1962.0724
431 , p0_a6 NUMBER := 0-1962.0724
432 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
433 , p0_a8 NUMBER := 0-1962.0724
434 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
435 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
436 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
437 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
438 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
439 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
440 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
441 , p0_a16 NUMBER := 0-1962.0724
442 )
443
444 as
445 ddp_cust_setup_rec ams_cust_setup_pvt.cust_setup_rec_type;
446 ddindx binary_integer; indx binary_integer;
447 begin
448
449 -- copy data to the local IN or IN-OUT args, if any
450 ddp_cust_setup_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a0);
451 ddp_cust_setup_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
452 ddp_cust_setup_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
453 ddp_cust_setup_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
454 ddp_cust_setup_rec.created_by := rosetta_g_miss_num_map(p0_a4);
455 ddp_cust_setup_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
456 ddp_cust_setup_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
457 ddp_cust_setup_rec.activity_type_code := p0_a7;
458 ddp_cust_setup_rec.media_id := rosetta_g_miss_num_map(p0_a8);
459 ddp_cust_setup_rec.enabled_flag := p0_a9;
460 ddp_cust_setup_rec.allow_essential_grouping := p0_a10;
461 ddp_cust_setup_rec.usage := p0_a11;
462 ddp_cust_setup_rec.object_type := p0_a12;
463 ddp_cust_setup_rec.source_code_suffix := p0_a13;
464 ddp_cust_setup_rec.setup_name := p0_a14;
465 ddp_cust_setup_rec.description := p0_a15;
466 ddp_cust_setup_rec.application_id := rosetta_g_miss_num_map(p0_a16);
467
468
469 -- here's the delegated call to the old PL/SQL routine
470 ams_cust_setup_pvt.check_cust_setup_fk_items(ddp_cust_setup_rec,
471 x_return_status);
472
473 -- copy data back from the local variables to OUT or IN-OUT args, if any
474
475 end;
476
477 procedure check_cust_setup_flag_items(x_return_status out nocopy VARCHAR2
478 , p0_a0 NUMBER := 0-1962.0724
479 , p0_a1 DATE := fnd_api.g_miss_date
480 , p0_a2 NUMBER := 0-1962.0724
481 , p0_a3 DATE := fnd_api.g_miss_date
482 , p0_a4 NUMBER := 0-1962.0724
483 , p0_a5 NUMBER := 0-1962.0724
484 , p0_a6 NUMBER := 0-1962.0724
485 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
486 , p0_a8 NUMBER := 0-1962.0724
487 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
488 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
489 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
490 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
491 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
492 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
493 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
494 , p0_a16 NUMBER := 0-1962.0724
495 )
496
497 as
498 ddp_cust_setup_rec ams_cust_setup_pvt.cust_setup_rec_type;
502 -- copy data to the local IN or IN-OUT args, if any
499 ddindx binary_integer; indx binary_integer;
500 begin
501
503 ddp_cust_setup_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a0);
504 ddp_cust_setup_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
505 ddp_cust_setup_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
506 ddp_cust_setup_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
507 ddp_cust_setup_rec.created_by := rosetta_g_miss_num_map(p0_a4);
508 ddp_cust_setup_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
509 ddp_cust_setup_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
510 ddp_cust_setup_rec.activity_type_code := p0_a7;
511 ddp_cust_setup_rec.media_id := rosetta_g_miss_num_map(p0_a8);
512 ddp_cust_setup_rec.enabled_flag := p0_a9;
513 ddp_cust_setup_rec.allow_essential_grouping := p0_a10;
514 ddp_cust_setup_rec.usage := p0_a11;
515 ddp_cust_setup_rec.object_type := p0_a12;
516 ddp_cust_setup_rec.source_code_suffix := p0_a13;
517 ddp_cust_setup_rec.setup_name := p0_a14;
518 ddp_cust_setup_rec.description := p0_a15;
519 ddp_cust_setup_rec.application_id := rosetta_g_miss_num_map(p0_a16);
520
521
522 -- here's the delegated call to the old PL/SQL routine
523 ams_cust_setup_pvt.check_cust_setup_flag_items(ddp_cust_setup_rec,
524 x_return_status);
525
526 -- copy data back from the local variables to OUT or IN-OUT args, if any
527
528 end;
529
530 procedure complete_cust_setup_rec(p1_a0 out nocopy NUMBER
531 , p1_a1 out nocopy DATE
532 , p1_a2 out nocopy NUMBER
533 , p1_a3 out nocopy DATE
534 , p1_a4 out nocopy NUMBER
535 , p1_a5 out nocopy NUMBER
536 , p1_a6 out nocopy NUMBER
537 , p1_a7 out nocopy VARCHAR2
538 , p1_a8 out nocopy NUMBER
539 , p1_a9 out nocopy VARCHAR2
540 , p1_a10 out nocopy VARCHAR2
541 , p1_a11 out nocopy VARCHAR2
542 , p1_a12 out nocopy VARCHAR2
543 , p1_a13 out nocopy VARCHAR2
544 , p1_a14 out nocopy VARCHAR2
545 , p1_a15 out nocopy VARCHAR2
546 , p1_a16 out nocopy NUMBER
547 , p0_a0 NUMBER := 0-1962.0724
548 , p0_a1 DATE := fnd_api.g_miss_date
549 , p0_a2 NUMBER := 0-1962.0724
550 , p0_a3 DATE := fnd_api.g_miss_date
551 , p0_a4 NUMBER := 0-1962.0724
552 , p0_a5 NUMBER := 0-1962.0724
553 , p0_a6 NUMBER := 0-1962.0724
554 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
555 , p0_a8 NUMBER := 0-1962.0724
556 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
557 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
558 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
559 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
560 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
561 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
562 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
563 , p0_a16 NUMBER := 0-1962.0724
564 )
565
566 as
567 ddp_cust_setup_rec ams_cust_setup_pvt.cust_setup_rec_type;
568 ddx_complete_rec ams_cust_setup_pvt.cust_setup_rec_type;
569 ddindx binary_integer; indx binary_integer;
570 begin
571
572 -- copy data to the local IN or IN-OUT args, if any
573 ddp_cust_setup_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a0);
574 ddp_cust_setup_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
575 ddp_cust_setup_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
576 ddp_cust_setup_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
577 ddp_cust_setup_rec.created_by := rosetta_g_miss_num_map(p0_a4);
578 ddp_cust_setup_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
579 ddp_cust_setup_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
580 ddp_cust_setup_rec.activity_type_code := p0_a7;
581 ddp_cust_setup_rec.media_id := rosetta_g_miss_num_map(p0_a8);
582 ddp_cust_setup_rec.enabled_flag := p0_a9;
583 ddp_cust_setup_rec.allow_essential_grouping := p0_a10;
584 ddp_cust_setup_rec.usage := p0_a11;
585 ddp_cust_setup_rec.object_type := p0_a12;
586 ddp_cust_setup_rec.source_code_suffix := p0_a13;
587 ddp_cust_setup_rec.setup_name := p0_a14;
588 ddp_cust_setup_rec.description := p0_a15;
589 ddp_cust_setup_rec.application_id := rosetta_g_miss_num_map(p0_a16);
590
591
592 -- here's the delegated call to the old PL/SQL routine
593 ams_cust_setup_pvt.complete_cust_setup_rec(ddp_cust_setup_rec,
594 ddx_complete_rec);
595
596 -- copy data back from the local variables to OUT or IN-OUT args, if any
597
598 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.custom_setup_id);
599 p1_a1 := ddx_complete_rec.last_update_date;
600 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
601 p1_a3 := ddx_complete_rec.creation_date;
602 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
603 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
604 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
605 p1_a7 := ddx_complete_rec.activity_type_code;
606 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.media_id);
607 p1_a9 := ddx_complete_rec.enabled_flag;
608 p1_a10 := ddx_complete_rec.allow_essential_grouping;
609 p1_a11 := ddx_complete_rec.usage;
610 p1_a12 := ddx_complete_rec.object_type;
611 p1_a13 := ddx_complete_rec.source_code_suffix;
617 procedure init_rec(p0_a0 out nocopy NUMBER
612 p1_a14 := ddx_complete_rec.setup_name;
613 p1_a15 := ddx_complete_rec.description;
614 p1_a16 := rosetta_g_miss_num_map(ddx_complete_rec.application_id);
615 end;
616
618 , p0_a1 out nocopy DATE
619 , p0_a2 out nocopy NUMBER
620 , p0_a3 out nocopy DATE
621 , p0_a4 out nocopy NUMBER
622 , p0_a5 out nocopy NUMBER
623 , p0_a6 out nocopy NUMBER
624 , p0_a7 out nocopy VARCHAR2
625 , p0_a8 out nocopy NUMBER
626 , p0_a9 out nocopy VARCHAR2
627 , p0_a10 out nocopy VARCHAR2
628 , p0_a11 out nocopy VARCHAR2
629 , p0_a12 out nocopy VARCHAR2
630 , p0_a13 out nocopy VARCHAR2
631 , p0_a14 out nocopy VARCHAR2
632 , p0_a15 out nocopy VARCHAR2
633 , p0_a16 out nocopy NUMBER
634 )
635
636 as
637 ddx_cust_setup_rec ams_cust_setup_pvt.cust_setup_rec_type;
638 ddindx binary_integer; indx binary_integer;
639 begin
640
641 -- copy data to the local IN or IN-OUT args, if any
642
643 -- here's the delegated call to the old PL/SQL routine
644 ams_cust_setup_pvt.init_rec(ddx_cust_setup_rec);
645
646 -- copy data back from the local variables to OUT or IN-OUT args, if any
647 p0_a0 := rosetta_g_miss_num_map(ddx_cust_setup_rec.custom_setup_id);
648 p0_a1 := ddx_cust_setup_rec.last_update_date;
649 p0_a2 := rosetta_g_miss_num_map(ddx_cust_setup_rec.last_updated_by);
650 p0_a3 := ddx_cust_setup_rec.creation_date;
651 p0_a4 := rosetta_g_miss_num_map(ddx_cust_setup_rec.created_by);
652 p0_a5 := rosetta_g_miss_num_map(ddx_cust_setup_rec.last_update_login);
653 p0_a6 := rosetta_g_miss_num_map(ddx_cust_setup_rec.object_version_number);
654 p0_a7 := ddx_cust_setup_rec.activity_type_code;
655 p0_a8 := rosetta_g_miss_num_map(ddx_cust_setup_rec.media_id);
656 p0_a9 := ddx_cust_setup_rec.enabled_flag;
657 p0_a10 := ddx_cust_setup_rec.allow_essential_grouping;
658 p0_a11 := ddx_cust_setup_rec.usage;
659 p0_a12 := ddx_cust_setup_rec.object_type;
660 p0_a13 := ddx_cust_setup_rec.source_code_suffix;
661 p0_a14 := ddx_cust_setup_rec.setup_name;
662 p0_a15 := ddx_cust_setup_rec.description;
663 p0_a16 := rosetta_g_miss_num_map(ddx_cust_setup_rec.application_id);
664 end;
665
666 end ams_cust_setup_pvt_w;