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;
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
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
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
622: , p0_a7 NUMBER := 0-1962.0724
623: , p0_a8 NUMBER := 0-1962.0724
620: , p0_a5 NUMBER := 0-1962.0724
621: , p0_a6 NUMBER := 0-1962.0724
622: , p0_a7 NUMBER := 0-1962.0724
623: , p0_a8 NUMBER := 0-1962.0724
624: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a10 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
621: , p0_a6 NUMBER := 0-1962.0724
622: , p0_a7 NUMBER := 0-1962.0724
623: , p0_a8 NUMBER := 0-1962.0724
624: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a10 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
622: , p0_a7 NUMBER := 0-1962.0724
623: , p0_a8 NUMBER := 0-1962.0724
624: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a10 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
623: , p0_a8 NUMBER := 0-1962.0724
624: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a10 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
624: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a10 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
625: , p0_a10 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
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
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: )
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:
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