[Home] [Help]
PACKAGE BODY: APPS.AMS_SETUP_ATTR_PVT_W
Source
1 package body ams_setup_attr_pvt_w as
2 /* $Header: amswattb.pls 115.14 2002/12/30 05:31:40 vmodur 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_setup_attr(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_setup_attr_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 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 NUMBER := 0-1962.0724
46 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50 , p7_a20 NUMBER := 0-1962.0724
51 )
52
53 as
54 ddp_setup_attr_rec ams_setup_attr_pvt.setup_attr_rec_type;
55 ddindx binary_integer; indx binary_integer;
56 begin
57
58 -- copy data to the local IN or IN-OUT args, if any
59
60
61
62
63
64
65
66 ddp_setup_attr_rec.setup_attribute_id := rosetta_g_miss_num_map(p7_a0);
67 ddp_setup_attr_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a1);
68 ddp_setup_attr_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
69 ddp_setup_attr_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
70 ddp_setup_attr_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
71 ddp_setup_attr_rec.created_by := rosetta_g_miss_num_map(p7_a5);
72 ddp_setup_attr_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
73 ddp_setup_attr_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
74 ddp_setup_attr_rec.display_sequence_no := rosetta_g_miss_num_map(p7_a8);
75 ddp_setup_attr_rec.object_attribute := p7_a9;
76 ddp_setup_attr_rec.attr_mandatory_flag := p7_a10;
77 ddp_setup_attr_rec.attr_available_flag := p7_a11;
78 ddp_setup_attr_rec.function_name := p7_a12;
79 ddp_setup_attr_rec.parent_function_name := p7_a13;
80 ddp_setup_attr_rec.parent_setup_attribute := p7_a14;
81 ddp_setup_attr_rec.parent_display_sequence := rosetta_g_miss_num_map(p7_a15);
82 ddp_setup_attr_rec.show_in_report := p7_a16;
83 ddp_setup_attr_rec.show_in_cue_card := p7_a17;
84 ddp_setup_attr_rec.copy_allowed_flag := p7_a18;
85 ddp_setup_attr_rec.related_ak_attribute := p7_a19;
86 ddp_setup_attr_rec.essential_seq_num := rosetta_g_miss_num_map(p7_a20);
87
88
89 -- here's the delegated call to the old PL/SQL routine
90 ams_setup_attr_pvt.create_setup_attr(p_api_version,
91 p_init_msg_list,
92 p_commit,
93 p_validation_level,
94 x_return_status,
95 x_msg_count,
96 x_msg_data,
97 ddp_setup_attr_rec,
98 x_setup_attr_id);
99
100 -- copy data back from the local variables to OUT or IN-OUT args, if any
101
102
103
104
105
106
107
108
109 end;
110
111 procedure update_setup_attr(p_api_version NUMBER
112 , p_init_msg_list VARCHAR2
113 , p_commit VARCHAR2
114 , p_validation_level NUMBER
115 , x_return_status OUT NOCOPY VARCHAR2
116 , x_msg_count OUT NOCOPY NUMBER
117 , x_msg_data OUT NOCOPY VARCHAR2
118 , p7_a0 NUMBER := 0-1962.0724
119 , p7_a1 NUMBER := 0-1962.0724
120 , p7_a2 DATE := fnd_api.g_miss_date
121 , p7_a3 NUMBER := 0-1962.0724
122 , p7_a4 DATE := fnd_api.g_miss_date
123 , p7_a5 NUMBER := 0-1962.0724
124 , p7_a6 NUMBER := 0-1962.0724
125 , p7_a7 NUMBER := 0-1962.0724
126 , p7_a8 NUMBER := 0-1962.0724
127 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
128 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
129 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
130 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
131 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
132 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
133 , p7_a15 NUMBER := 0-1962.0724
134 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
135 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
136 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
137 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
138 , p7_a20 NUMBER := 0-1962.0724
139 )
140
141 as
142 ddp_setup_attr_rec ams_setup_attr_pvt.setup_attr_rec_type;
143 ddindx binary_integer; indx binary_integer;
144 begin
145
146 -- copy data to the local IN or IN-OUT args, if any
147
148
149
150
151
152
153
154 ddp_setup_attr_rec.setup_attribute_id := rosetta_g_miss_num_map(p7_a0);
155 ddp_setup_attr_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a1);
156 ddp_setup_attr_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
157 ddp_setup_attr_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
158 ddp_setup_attr_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
159 ddp_setup_attr_rec.created_by := rosetta_g_miss_num_map(p7_a5);
160 ddp_setup_attr_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
161 ddp_setup_attr_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
162 ddp_setup_attr_rec.display_sequence_no := rosetta_g_miss_num_map(p7_a8);
163 ddp_setup_attr_rec.object_attribute := p7_a9;
164 ddp_setup_attr_rec.attr_mandatory_flag := p7_a10;
165 ddp_setup_attr_rec.attr_available_flag := p7_a11;
166 ddp_setup_attr_rec.function_name := p7_a12;
167 ddp_setup_attr_rec.parent_function_name := p7_a13;
168 ddp_setup_attr_rec.parent_setup_attribute := p7_a14;
169 ddp_setup_attr_rec.parent_display_sequence := rosetta_g_miss_num_map(p7_a15);
170 ddp_setup_attr_rec.show_in_report := p7_a16;
171 ddp_setup_attr_rec.show_in_cue_card := p7_a17;
172 ddp_setup_attr_rec.copy_allowed_flag := p7_a18;
173 ddp_setup_attr_rec.related_ak_attribute := p7_a19;
174 ddp_setup_attr_rec.essential_seq_num := rosetta_g_miss_num_map(p7_a20);
175
176 -- here's the delegated call to the old PL/SQL routine
177 ams_setup_attr_pvt.update_setup_attr(p_api_version,
178 p_init_msg_list,
179 p_commit,
180 p_validation_level,
181 x_return_status,
182 x_msg_count,
183 x_msg_data,
184 ddp_setup_attr_rec);
185
186 -- copy data back from the local variables to OUT or IN-OUT args, if any
187
188
189
190
191
192
193
194 end;
195
196 procedure validate_setup_attr(p_api_version NUMBER
197 , p_init_msg_list VARCHAR2
198 , p_validation_level NUMBER
199 , x_return_status OUT NOCOPY VARCHAR2
200 , x_msg_count OUT NOCOPY NUMBER
201 , x_msg_data OUT NOCOPY VARCHAR2
202 , p6_a0 NUMBER := 0-1962.0724
203 , p6_a1 NUMBER := 0-1962.0724
204 , p6_a2 DATE := fnd_api.g_miss_date
205 , p6_a3 NUMBER := 0-1962.0724
206 , p6_a4 DATE := fnd_api.g_miss_date
207 , p6_a5 NUMBER := 0-1962.0724
208 , p6_a6 NUMBER := 0-1962.0724
209 , p6_a7 NUMBER := 0-1962.0724
210 , p6_a8 NUMBER := 0-1962.0724
211 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
212 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
213 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
214 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
215 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
216 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
217 , p6_a15 NUMBER := 0-1962.0724
218 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
219 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
220 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
221 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
222 , p6_a20 NUMBER := 0-1962.0724
223 )
224
225 as
226 ddp_setup_attr_rec ams_setup_attr_pvt.setup_attr_rec_type;
227 ddindx binary_integer; indx binary_integer;
228 begin
229
230 -- copy data to the local IN or IN-OUT args, if any
231
232
233
234
235
236
237 ddp_setup_attr_rec.setup_attribute_id := rosetta_g_miss_num_map(p6_a0);
238 ddp_setup_attr_rec.custom_setup_id := rosetta_g_miss_num_map(p6_a1);
239 ddp_setup_attr_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a2);
240 ddp_setup_attr_rec.last_updated_by := rosetta_g_miss_num_map(p6_a3);
241 ddp_setup_attr_rec.creation_date := rosetta_g_miss_date_in_map(p6_a4);
242 ddp_setup_attr_rec.created_by := rosetta_g_miss_num_map(p6_a5);
243 ddp_setup_attr_rec.last_update_login := rosetta_g_miss_num_map(p6_a6);
244 ddp_setup_attr_rec.object_version_number := rosetta_g_miss_num_map(p6_a7);
245 ddp_setup_attr_rec.display_sequence_no := rosetta_g_miss_num_map(p6_a8);
246 ddp_setup_attr_rec.object_attribute := p6_a9;
247 ddp_setup_attr_rec.attr_mandatory_flag := p6_a10;
248 ddp_setup_attr_rec.attr_available_flag := p6_a11;
249 ddp_setup_attr_rec.function_name := p6_a12;
250 ddp_setup_attr_rec.parent_function_name := p6_a13;
251 ddp_setup_attr_rec.parent_setup_attribute := p6_a14;
252 ddp_setup_attr_rec.parent_display_sequence := rosetta_g_miss_num_map(p6_a15);
253 ddp_setup_attr_rec.show_in_report := p6_a16;
254 ddp_setup_attr_rec.show_in_cue_card := p6_a17;
255 ddp_setup_attr_rec.copy_allowed_flag := p6_a18;
256 ddp_setup_attr_rec.related_ak_attribute := p6_a19;
257 ddp_setup_attr_rec.essential_seq_num := rosetta_g_miss_num_map(p6_a20);
258
259 -- here's the delegated call to the old PL/SQL routine
260 ams_setup_attr_pvt.validate_setup_attr(p_api_version,
261 p_init_msg_list,
262 p_validation_level,
263 x_return_status,
264 x_msg_count,
265 x_msg_data,
266 ddp_setup_attr_rec);
267
268 -- copy data back from the local variables to OUT or IN-OUT args, if any
269
270
271
272
273
274
275 end;
276
277 procedure check_items(p_validation_mode VARCHAR2
278 , x_return_status OUT NOCOPY VARCHAR2
279 , p2_a0 NUMBER := 0-1962.0724
280 , p2_a1 NUMBER := 0-1962.0724
281 , p2_a2 DATE := fnd_api.g_miss_date
282 , p2_a3 NUMBER := 0-1962.0724
283 , p2_a4 DATE := fnd_api.g_miss_date
284 , p2_a5 NUMBER := 0-1962.0724
285 , p2_a6 NUMBER := 0-1962.0724
286 , p2_a7 NUMBER := 0-1962.0724
287 , p2_a8 NUMBER := 0-1962.0724
288 , p2_a9 VARCHAR2 := fnd_api.g_miss_char
289 , p2_a10 VARCHAR2 := fnd_api.g_miss_char
290 , p2_a11 VARCHAR2 := fnd_api.g_miss_char
291 , p2_a12 VARCHAR2 := fnd_api.g_miss_char
292 , p2_a13 VARCHAR2 := fnd_api.g_miss_char
293 , p2_a14 VARCHAR2 := fnd_api.g_miss_char
294 , p2_a15 NUMBER := 0-1962.0724
295 , p2_a16 VARCHAR2 := fnd_api.g_miss_char
296 , p2_a17 VARCHAR2 := fnd_api.g_miss_char
297 , p2_a18 VARCHAR2 := fnd_api.g_miss_char
298 , p2_a19 VARCHAR2 := fnd_api.g_miss_char
299 , p2_a20 NUMBER := 0-1962.0724
300 )
301
302 as
303 ddp_setup_attr_rec ams_setup_attr_pvt.setup_attr_rec_type;
304 ddindx binary_integer; indx binary_integer;
305 begin
306
307 -- copy data to the local IN or IN-OUT args, if any
308
309
310 ddp_setup_attr_rec.setup_attribute_id := rosetta_g_miss_num_map(p2_a0);
311 ddp_setup_attr_rec.custom_setup_id := rosetta_g_miss_num_map(p2_a1);
312 ddp_setup_attr_rec.last_update_date := rosetta_g_miss_date_in_map(p2_a2);
313 ddp_setup_attr_rec.last_updated_by := rosetta_g_miss_num_map(p2_a3);
314 ddp_setup_attr_rec.creation_date := rosetta_g_miss_date_in_map(p2_a4);
315 ddp_setup_attr_rec.created_by := rosetta_g_miss_num_map(p2_a5);
316 ddp_setup_attr_rec.last_update_login := rosetta_g_miss_num_map(p2_a6);
317 ddp_setup_attr_rec.object_version_number := rosetta_g_miss_num_map(p2_a7);
318 ddp_setup_attr_rec.display_sequence_no := rosetta_g_miss_num_map(p2_a8);
319 ddp_setup_attr_rec.object_attribute := p2_a9;
320 ddp_setup_attr_rec.attr_mandatory_flag := p2_a10;
321 ddp_setup_attr_rec.attr_available_flag := p2_a11;
322 ddp_setup_attr_rec.function_name := p2_a12;
323 ddp_setup_attr_rec.parent_function_name := p2_a13;
324 ddp_setup_attr_rec.parent_setup_attribute := p2_a14;
325 ddp_setup_attr_rec.parent_display_sequence := rosetta_g_miss_num_map(p2_a15);
326 ddp_setup_attr_rec.show_in_report := p2_a16;
327 ddp_setup_attr_rec.show_in_cue_card := p2_a17;
328 ddp_setup_attr_rec.copy_allowed_flag := p2_a18;
329 ddp_setup_attr_rec.related_ak_attribute := p2_a19;
330 ddp_setup_attr_rec.essential_seq_num := rosetta_g_miss_num_map(p2_a20);
331
332 -- here's the delegated call to the old PL/SQL routine
333 ams_setup_attr_pvt.check_items(p_validation_mode,
334 x_return_status,
335 ddp_setup_attr_rec);
336
337 -- copy data back from the local variables to OUT or IN-OUT args, if any
338
339
340 end;
341
342 procedure check_setup_attr_req_items(p_validation_mode VARCHAR2
343 , x_return_status OUT NOCOPY VARCHAR2
344 , p1_a0 NUMBER := 0-1962.0724
345 , p1_a1 NUMBER := 0-1962.0724
346 , p1_a2 DATE := fnd_api.g_miss_date
347 , p1_a3 NUMBER := 0-1962.0724
348 , p1_a4 DATE := fnd_api.g_miss_date
349 , p1_a5 NUMBER := 0-1962.0724
350 , p1_a6 NUMBER := 0-1962.0724
351 , p1_a7 NUMBER := 0-1962.0724
352 , p1_a8 NUMBER := 0-1962.0724
353 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
354 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
355 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
356 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
357 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
358 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
359 , p1_a15 NUMBER := 0-1962.0724
360 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
361 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
362 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
363 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
364 , p1_a20 NUMBER := 0-1962.0724
365 )
366
367 as
368 ddp_setup_attr_rec ams_setup_attr_pvt.setup_attr_rec_type;
369 ddindx binary_integer; indx binary_integer;
370 begin
371
372 -- copy data to the local IN or IN-OUT args, if any
373
374 ddp_setup_attr_rec.setup_attribute_id := rosetta_g_miss_num_map(p1_a0);
375 ddp_setup_attr_rec.custom_setup_id := rosetta_g_miss_num_map(p1_a1);
376 ddp_setup_attr_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a2);
377 ddp_setup_attr_rec.last_updated_by := rosetta_g_miss_num_map(p1_a3);
378 ddp_setup_attr_rec.creation_date := rosetta_g_miss_date_in_map(p1_a4);
379 ddp_setup_attr_rec.created_by := rosetta_g_miss_num_map(p1_a5);
380 ddp_setup_attr_rec.last_update_login := rosetta_g_miss_num_map(p1_a6);
381 ddp_setup_attr_rec.object_version_number := rosetta_g_miss_num_map(p1_a7);
382 ddp_setup_attr_rec.display_sequence_no := rosetta_g_miss_num_map(p1_a8);
383 ddp_setup_attr_rec.object_attribute := p1_a9;
384 ddp_setup_attr_rec.attr_mandatory_flag := p1_a10;
385 ddp_setup_attr_rec.attr_available_flag := p1_a11;
386 ddp_setup_attr_rec.function_name := p1_a12;
390 ddp_setup_attr_rec.show_in_report := p1_a16;
387 ddp_setup_attr_rec.parent_function_name := p1_a13;
388 ddp_setup_attr_rec.parent_setup_attribute := p1_a14;
389 ddp_setup_attr_rec.parent_display_sequence := rosetta_g_miss_num_map(p1_a15);
391 ddp_setup_attr_rec.show_in_cue_card := p1_a17;
392 ddp_setup_attr_rec.copy_allowed_flag := p1_a18;
393 ddp_setup_attr_rec.related_ak_attribute := p1_a19;
394 ddp_setup_attr_rec.essential_seq_num := rosetta_g_miss_num_map(p1_a20);
395
396
397 -- here's the delegated call to the old PL/SQL routine
398 ams_setup_attr_pvt.check_setup_attr_req_items(p_validation_mode,
399 ddp_setup_attr_rec,
400 x_return_status);
401
402 -- copy data back from the local variables to OUT or IN-OUT args, if any
403
404
405 end;
406
407 procedure check_setup_attr_uk_items(p_validation_mode VARCHAR2
408 , x_return_status OUT NOCOPY VARCHAR2
409 , p1_a0 NUMBER := 0-1962.0724
410 , p1_a1 NUMBER := 0-1962.0724
411 , p1_a2 DATE := fnd_api.g_miss_date
412 , p1_a3 NUMBER := 0-1962.0724
413 , p1_a4 DATE := fnd_api.g_miss_date
414 , p1_a5 NUMBER := 0-1962.0724
415 , p1_a6 NUMBER := 0-1962.0724
416 , p1_a7 NUMBER := 0-1962.0724
417 , p1_a8 NUMBER := 0-1962.0724
418 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
419 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
420 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
421 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
422 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
423 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
424 , p1_a15 NUMBER := 0-1962.0724
425 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
426 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
427 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
428 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
429 , p1_a20 NUMBER := 0-1962.0724
430 )
431
432 as
433 ddp_setup_attr_rec ams_setup_attr_pvt.setup_attr_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 ddp_setup_attr_rec.setup_attribute_id := rosetta_g_miss_num_map(p1_a0);
440 ddp_setup_attr_rec.custom_setup_id := rosetta_g_miss_num_map(p1_a1);
441 ddp_setup_attr_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a2);
442 ddp_setup_attr_rec.last_updated_by := rosetta_g_miss_num_map(p1_a3);
443 ddp_setup_attr_rec.creation_date := rosetta_g_miss_date_in_map(p1_a4);
444 ddp_setup_attr_rec.created_by := rosetta_g_miss_num_map(p1_a5);
445 ddp_setup_attr_rec.last_update_login := rosetta_g_miss_num_map(p1_a6);
446 ddp_setup_attr_rec.object_version_number := rosetta_g_miss_num_map(p1_a7);
447 ddp_setup_attr_rec.display_sequence_no := rosetta_g_miss_num_map(p1_a8);
448 ddp_setup_attr_rec.object_attribute := p1_a9;
449 ddp_setup_attr_rec.attr_mandatory_flag := p1_a10;
450 ddp_setup_attr_rec.attr_available_flag := p1_a11;
451 ddp_setup_attr_rec.function_name := p1_a12;
452 ddp_setup_attr_rec.parent_function_name := p1_a13;
453 ddp_setup_attr_rec.parent_setup_attribute := p1_a14;
454 ddp_setup_attr_rec.parent_display_sequence := rosetta_g_miss_num_map(p1_a15);
455 ddp_setup_attr_rec.show_in_report := p1_a16;
456 ddp_setup_attr_rec.show_in_cue_card := p1_a17;
457 ddp_setup_attr_rec.copy_allowed_flag := p1_a18;
458 ddp_setup_attr_rec.related_ak_attribute := p1_a19;
459 ddp_setup_attr_rec.essential_seq_num := rosetta_g_miss_num_map(p1_a20);
460
461
462 -- here's the delegated call to the old PL/SQL routine
463 ams_setup_attr_pvt.check_setup_attr_uk_items(p_validation_mode,
464 ddp_setup_attr_rec,
465 x_return_status);
466
467 -- copy data back from the local variables to OUT or IN-OUT args, if any
468
469
470 end;
471
472 procedure check_setup_attr_fk_items(x_return_status OUT NOCOPY VARCHAR2
473 , p0_a0 NUMBER := 0-1962.0724
474 , p0_a1 NUMBER := 0-1962.0724
475 , p0_a2 DATE := fnd_api.g_miss_date
476 , p0_a3 NUMBER := 0-1962.0724
477 , p0_a4 DATE := fnd_api.g_miss_date
478 , p0_a5 NUMBER := 0-1962.0724
479 , p0_a6 NUMBER := 0-1962.0724
480 , p0_a7 NUMBER := 0-1962.0724
481 , p0_a8 NUMBER := 0-1962.0724
482 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
483 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
484 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
485 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
486 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
487 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
488 , p0_a15 NUMBER := 0-1962.0724
489 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
490 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
491 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
492 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
493 , p0_a20 NUMBER := 0-1962.0724
494 )
495
496 as
497 ddp_setup_attr_rec ams_setup_attr_pvt.setup_attr_rec_type;
498 ddindx binary_integer; indx binary_integer;
499 begin
500
501 -- copy data to the local IN or IN-OUT args, if any
502 ddp_setup_attr_rec.setup_attribute_id := rosetta_g_miss_num_map(p0_a0);
503 ddp_setup_attr_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a1);
504 ddp_setup_attr_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
505 ddp_setup_attr_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
509 ddp_setup_attr_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
506 ddp_setup_attr_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
507 ddp_setup_attr_rec.created_by := rosetta_g_miss_num_map(p0_a5);
508 ddp_setup_attr_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
510 ddp_setup_attr_rec.display_sequence_no := rosetta_g_miss_num_map(p0_a8);
511 ddp_setup_attr_rec.object_attribute := p0_a9;
512 ddp_setup_attr_rec.attr_mandatory_flag := p0_a10;
513 ddp_setup_attr_rec.attr_available_flag := p0_a11;
514 ddp_setup_attr_rec.function_name := p0_a12;
515 ddp_setup_attr_rec.parent_function_name := p0_a13;
516 ddp_setup_attr_rec.parent_setup_attribute := p0_a14;
517 ddp_setup_attr_rec.parent_display_sequence := rosetta_g_miss_num_map(p0_a15);
518 ddp_setup_attr_rec.show_in_report := p0_a16;
519 ddp_setup_attr_rec.show_in_cue_card := p0_a17;
520 ddp_setup_attr_rec.copy_allowed_flag := p0_a18;
521 ddp_setup_attr_rec.related_ak_attribute := p0_a19;
522 ddp_setup_attr_rec.essential_seq_num := rosetta_g_miss_num_map(p0_a20);
523
524
525 -- here's the delegated call to the old PL/SQL routine
526 ams_setup_attr_pvt.check_setup_attr_fk_items(ddp_setup_attr_rec,
527 x_return_status);
528
529 -- copy data back from the local variables to OUT or IN-OUT args, if any
530
531 end;
532
533 procedure check_setup_attr_flag_items(x_return_status OUT NOCOPY VARCHAR2
534 , p0_a0 NUMBER := 0-1962.0724
535 , p0_a1 NUMBER := 0-1962.0724
536 , p0_a2 DATE := fnd_api.g_miss_date
537 , p0_a3 NUMBER := 0-1962.0724
538 , p0_a4 DATE := fnd_api.g_miss_date
539 , p0_a5 NUMBER := 0-1962.0724
540 , p0_a6 NUMBER := 0-1962.0724
541 , p0_a7 NUMBER := 0-1962.0724
542 , p0_a8 NUMBER := 0-1962.0724
543 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
544 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
545 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
546 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
547 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
548 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
549 , p0_a15 NUMBER := 0-1962.0724
550 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
551 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
552 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
553 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
554 , p0_a20 NUMBER := 0-1962.0724
555 )
556
557 as
558 ddp_setup_attr_rec ams_setup_attr_pvt.setup_attr_rec_type;
559 ddindx binary_integer; indx binary_integer;
560 begin
561
562 -- copy data to the local IN or IN-OUT args, if any
563 ddp_setup_attr_rec.setup_attribute_id := rosetta_g_miss_num_map(p0_a0);
564 ddp_setup_attr_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a1);
565 ddp_setup_attr_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
566 ddp_setup_attr_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
567 ddp_setup_attr_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
568 ddp_setup_attr_rec.created_by := rosetta_g_miss_num_map(p0_a5);
569 ddp_setup_attr_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
570 ddp_setup_attr_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
571 ddp_setup_attr_rec.display_sequence_no := rosetta_g_miss_num_map(p0_a8);
572 ddp_setup_attr_rec.object_attribute := p0_a9;
573 ddp_setup_attr_rec.attr_mandatory_flag := p0_a10;
574 ddp_setup_attr_rec.attr_available_flag := p0_a11;
575 ddp_setup_attr_rec.function_name := p0_a12;
576 ddp_setup_attr_rec.parent_function_name := p0_a13;
577 ddp_setup_attr_rec.parent_setup_attribute := p0_a14;
578 ddp_setup_attr_rec.parent_display_sequence := rosetta_g_miss_num_map(p0_a15);
579 ddp_setup_attr_rec.show_in_report := p0_a16;
580 ddp_setup_attr_rec.show_in_cue_card := p0_a17;
581 ddp_setup_attr_rec.copy_allowed_flag := p0_a18;
582 ddp_setup_attr_rec.related_ak_attribute := p0_a19;
583 ddp_setup_attr_rec.essential_seq_num := rosetta_g_miss_num_map(p0_a20);
584
585
586 -- here's the delegated call to the old PL/SQL routine
587 ams_setup_attr_pvt.check_setup_attr_flag_items(ddp_setup_attr_rec,
588 x_return_status);
589
590 -- copy data back from the local variables to OUT or IN-OUT args, if any
591
592 end;
593
594 procedure complete_setup_attr_rec(p1_a0 OUT NOCOPY NUMBER
595 , p1_a1 OUT NOCOPY NUMBER
596 , p1_a2 OUT NOCOPY DATE
597 , p1_a3 OUT NOCOPY NUMBER
598 , p1_a4 OUT NOCOPY DATE
599 , p1_a5 OUT NOCOPY NUMBER
600 , p1_a6 OUT NOCOPY NUMBER
601 , p1_a7 OUT NOCOPY NUMBER
602 , p1_a8 OUT NOCOPY NUMBER
603 , p1_a9 OUT NOCOPY VARCHAR2
604 , p1_a10 OUT NOCOPY VARCHAR2
605 , p1_a11 OUT NOCOPY VARCHAR2
606 , p1_a12 OUT NOCOPY VARCHAR2
607 , p1_a13 OUT NOCOPY VARCHAR2
608 , p1_a14 OUT NOCOPY VARCHAR2
609 , p1_a15 OUT NOCOPY NUMBER
610 , p1_a16 OUT NOCOPY VARCHAR2
611 , p1_a17 OUT NOCOPY VARCHAR2
612 , p1_a18 OUT NOCOPY VARCHAR2
613 , p1_a19 OUT NOCOPY VARCHAR2
614 , p1_a20 OUT NOCOPY NUMBER
615 , p0_a0 NUMBER := 0-1962.0724
616 , p0_a1 NUMBER := 0-1962.0724
617 , p0_a2 DATE := fnd_api.g_miss_date
618 , p0_a3 NUMBER := 0-1962.0724
619 , p0_a4 DATE := fnd_api.g_miss_date
620 , p0_a5 NUMBER := 0-1962.0724
621 , p0_a6 NUMBER := 0-1962.0724
625 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
622 , p0_a7 NUMBER := 0-1962.0724
623 , p0_a8 NUMBER := 0-1962.0724
624 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
626 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
627 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
628 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
629 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
630 , p0_a15 NUMBER := 0-1962.0724
631 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
632 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
633 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
634 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
635 , p0_a20 NUMBER := 0-1962.0724
636 )
637
638 as
639 ddp_setup_attr_rec ams_setup_attr_pvt.setup_attr_rec_type;
640 ddx_complete_rec ams_setup_attr_pvt.setup_attr_rec_type;
641 ddindx binary_integer; indx binary_integer;
642 begin
643
644 -- copy data to the local IN or IN-OUT args, if any
645 ddp_setup_attr_rec.setup_attribute_id := rosetta_g_miss_num_map(p0_a0);
646 ddp_setup_attr_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a1);
647 ddp_setup_attr_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
648 ddp_setup_attr_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
649 ddp_setup_attr_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
650 ddp_setup_attr_rec.created_by := rosetta_g_miss_num_map(p0_a5);
651 ddp_setup_attr_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
652 ddp_setup_attr_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
653 ddp_setup_attr_rec.display_sequence_no := rosetta_g_miss_num_map(p0_a8);
654 ddp_setup_attr_rec.object_attribute := p0_a9;
655 ddp_setup_attr_rec.attr_mandatory_flag := p0_a10;
656 ddp_setup_attr_rec.attr_available_flag := p0_a11;
657 ddp_setup_attr_rec.function_name := p0_a12;
658 ddp_setup_attr_rec.parent_function_name := p0_a13;
659 ddp_setup_attr_rec.parent_setup_attribute := p0_a14;
660 ddp_setup_attr_rec.parent_display_sequence := rosetta_g_miss_num_map(p0_a15);
661 ddp_setup_attr_rec.show_in_report := p0_a16;
662 ddp_setup_attr_rec.show_in_cue_card := p0_a17;
663 ddp_setup_attr_rec.copy_allowed_flag := p0_a18;
664 ddp_setup_attr_rec.related_ak_attribute := p0_a19;
665 ddp_setup_attr_rec.essential_seq_num := rosetta_g_miss_num_map(p0_a20);
666
667
668 -- here's the delegated call to the old PL/SQL routine
669 ams_setup_attr_pvt.complete_setup_attr_rec(ddp_setup_attr_rec,
670 ddx_complete_rec);
671
672 -- copy data back from the local variables to OUT or IN-OUT args, if any
673
674 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.setup_attribute_id);
675 p1_a1 := rosetta_g_miss_num_map(ddx_complete_rec.custom_setup_id);
676 p1_a2 := ddx_complete_rec.last_update_date;
677 p1_a3 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
678 p1_a4 := ddx_complete_rec.creation_date;
679 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
680 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
681 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
682 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.display_sequence_no);
683 p1_a9 := ddx_complete_rec.object_attribute;
684 p1_a10 := ddx_complete_rec.attr_mandatory_flag;
685 p1_a11 := ddx_complete_rec.attr_available_flag;
686 p1_a12 := ddx_complete_rec.function_name;
687 p1_a13 := ddx_complete_rec.parent_function_name;
688 p1_a14 := ddx_complete_rec.parent_setup_attribute;
689 p1_a15 := rosetta_g_miss_num_map(ddx_complete_rec.parent_display_sequence);
690 p1_a16 := ddx_complete_rec.show_in_report;
691 p1_a17 := ddx_complete_rec.show_in_cue_card;
692 p1_a18 := ddx_complete_rec.copy_allowed_flag;
693 p1_a19 := ddx_complete_rec.related_ak_attribute;
694 p1_a20 := rosetta_g_miss_num_map(ddx_complete_rec.essential_seq_num);
695 end;
696
697 procedure init_rec(p0_a0 OUT NOCOPY NUMBER
698 , p0_a1 OUT NOCOPY NUMBER
699 , p0_a2 OUT NOCOPY DATE
700 , p0_a3 OUT NOCOPY NUMBER
701 , p0_a4 OUT NOCOPY DATE
702 , p0_a5 OUT NOCOPY NUMBER
703 , p0_a6 OUT NOCOPY NUMBER
704 , p0_a7 OUT NOCOPY NUMBER
705 , p0_a8 OUT NOCOPY NUMBER
706 , p0_a9 OUT NOCOPY VARCHAR2
707 , p0_a10 OUT NOCOPY VARCHAR2
708 , p0_a11 OUT NOCOPY VARCHAR2
709 , p0_a12 OUT NOCOPY VARCHAR2
710 , p0_a13 OUT NOCOPY VARCHAR2
711 , p0_a14 OUT NOCOPY VARCHAR2
712 , p0_a15 OUT NOCOPY NUMBER
713 , p0_a16 OUT NOCOPY VARCHAR2
714 , p0_a17 OUT NOCOPY VARCHAR2
715 , p0_a18 OUT NOCOPY VARCHAR2
716 , p0_a19 OUT NOCOPY VARCHAR2
717 , p0_a20 OUT NOCOPY NUMBER
718 )
719
720 as
721 ddx_setup_attr_rec ams_setup_attr_pvt.setup_attr_rec_type;
722 ddindx binary_integer; indx binary_integer;
723 begin
724
725 -- copy data to the local IN or IN-OUT args, if any
726
727 -- here's the delegated call to the old PL/SQL routine
728 ams_setup_attr_pvt.init_rec(ddx_setup_attr_rec);
729
730 -- copy data back from the local variables to OUT or IN-OUT args, if any
731 p0_a0 := rosetta_g_miss_num_map(ddx_setup_attr_rec.setup_attribute_id);
732 p0_a1 := rosetta_g_miss_num_map(ddx_setup_attr_rec.custom_setup_id);
733 p0_a2 := ddx_setup_attr_rec.last_update_date;
734 p0_a3 := rosetta_g_miss_num_map(ddx_setup_attr_rec.last_updated_by);
735 p0_a4 := ddx_setup_attr_rec.creation_date;
736 p0_a5 := rosetta_g_miss_num_map(ddx_setup_attr_rec.created_by);
737 p0_a6 := rosetta_g_miss_num_map(ddx_setup_attr_rec.last_update_login);
738 p0_a7 := rosetta_g_miss_num_map(ddx_setup_attr_rec.object_version_number);
739 p0_a8 := rosetta_g_miss_num_map(ddx_setup_attr_rec.display_sequence_no);
740 p0_a9 := ddx_setup_attr_rec.object_attribute;
741 p0_a10 := ddx_setup_attr_rec.attr_mandatory_flag;
742 p0_a11 := ddx_setup_attr_rec.attr_available_flag;
743 p0_a12 := ddx_setup_attr_rec.function_name;
744 p0_a13 := ddx_setup_attr_rec.parent_function_name;
745 p0_a14 := ddx_setup_attr_rec.parent_setup_attribute;
746 p0_a15 := rosetta_g_miss_num_map(ddx_setup_attr_rec.parent_display_sequence);
747 p0_a16 := ddx_setup_attr_rec.show_in_report;
748 p0_a17 := ddx_setup_attr_rec.show_in_cue_card;
749 p0_a18 := ddx_setup_attr_rec.copy_allowed_flag;
750 p0_a19 := ddx_setup_attr_rec.related_ak_attribute;
751 p0_a20 := rosetta_g_miss_num_map(ddx_setup_attr_rec.essential_seq_num);
752 end;
753
754 end ams_setup_attr_pvt_w;