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
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;
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
380: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
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
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
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
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
383: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
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
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
383: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p1_a15 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
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
383: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p1_a16 NUMBER := 0-1962.0724
378: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p1_a10 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
383: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p1_a16 NUMBER := 0-1962.0724
386: )
379: , p1_a10 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
383: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p1_a16 NUMBER := 0-1962.0724
386: )
387:
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
383: , p1_a14 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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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: )
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:
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
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
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
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
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
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
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
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
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: )
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:
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