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 update_listfield(p_api_version NUMBER
26: , x_return_status OUT NOCOPY VARCHAR2
27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , p7_a0 NUMBER := 0-1962.0724
30: , p7_a1 DATE := fnd_api.g_miss_date
31: , p7_a2 NUMBER := 0-1962.0724
32: , p7_a3 DATE := fnd_api.g_miss_date
33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , p7_a0 NUMBER := 0-1962.0724
30: , p7_a1 DATE := fnd_api.g_miss_date
31: , p7_a2 NUMBER := 0-1962.0724
32: , p7_a3 DATE := fnd_api.g_miss_date
33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724
35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
32: , p7_a3 DATE := fnd_api.g_miss_date
33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724
35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a10 NUMBER := 0-1962.0724
40: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724
35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a10 NUMBER := 0-1962.0724
40: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
34: , p7_a5 NUMBER := 0-1962.0724
35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a10 NUMBER := 0-1962.0724
40: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a10 NUMBER := 0-1962.0724
40: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
43: )
44: as
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a10 NUMBER := 0-1962.0724
40: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
43: )
44: as
45: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a10 NUMBER := 0-1962.0724
40: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
43: )
44: as
45: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
46: ddindx binary_integer; indx binary_integer;
96: , x_return_status OUT NOCOPY VARCHAR2
97: , x_msg_count OUT NOCOPY NUMBER
98: , x_msg_data OUT NOCOPY VARCHAR2
99: , p7_a0 NUMBER := 0-1962.0724
100: , p7_a1 DATE := fnd_api.g_miss_date
101: , p7_a2 NUMBER := 0-1962.0724
102: , p7_a3 DATE := fnd_api.g_miss_date
103: , p7_a4 NUMBER := 0-1962.0724
104: , p7_a5 NUMBER := 0-1962.0724
98: , x_msg_data OUT NOCOPY VARCHAR2
99: , p7_a0 NUMBER := 0-1962.0724
100: , p7_a1 DATE := fnd_api.g_miss_date
101: , p7_a2 NUMBER := 0-1962.0724
102: , p7_a3 DATE := fnd_api.g_miss_date
103: , p7_a4 NUMBER := 0-1962.0724
104: , p7_a5 NUMBER := 0-1962.0724
105: , p7_a6 NUMBER := 0-1962.0724
106: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a3 DATE := fnd_api.g_miss_date
103: , p7_a4 NUMBER := 0-1962.0724
104: , p7_a5 NUMBER := 0-1962.0724
105: , p7_a6 NUMBER := 0-1962.0724
106: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a10 NUMBER := 0-1962.0724
110: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a4 NUMBER := 0-1962.0724
104: , p7_a5 NUMBER := 0-1962.0724
105: , p7_a6 NUMBER := 0-1962.0724
106: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a10 NUMBER := 0-1962.0724
110: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a5 NUMBER := 0-1962.0724
105: , p7_a6 NUMBER := 0-1962.0724
106: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a10 NUMBER := 0-1962.0724
110: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a10 NUMBER := 0-1962.0724
110: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
113: )
114: as
107: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a10 NUMBER := 0-1962.0724
110: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
113: )
114: as
115: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
108: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a10 NUMBER := 0-1962.0724
110: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
113: )
114: as
115: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
116: ddindx binary_integer; indx binary_integer;
161:
162: procedure check_listfield_items(p_validation_mode VARCHAR2
163: , x_return_status OUT NOCOPY VARCHAR2
164: , p0_a0 NUMBER := 0-1962.0724
165: , p0_a1 DATE := fnd_api.g_miss_date
166: , p0_a2 NUMBER := 0-1962.0724
167: , p0_a3 DATE := fnd_api.g_miss_date
168: , p0_a4 NUMBER := 0-1962.0724
169: , p0_a5 NUMBER := 0-1962.0724
163: , x_return_status OUT NOCOPY VARCHAR2
164: , p0_a0 NUMBER := 0-1962.0724
165: , p0_a1 DATE := fnd_api.g_miss_date
166: , p0_a2 NUMBER := 0-1962.0724
167: , p0_a3 DATE := fnd_api.g_miss_date
168: , p0_a4 NUMBER := 0-1962.0724
169: , p0_a5 NUMBER := 0-1962.0724
170: , p0_a6 NUMBER := 0-1962.0724
171: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
167: , p0_a3 DATE := fnd_api.g_miss_date
168: , p0_a4 NUMBER := 0-1962.0724
169: , p0_a5 NUMBER := 0-1962.0724
170: , p0_a6 NUMBER := 0-1962.0724
171: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a10 NUMBER := 0-1962.0724
175: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
168: , p0_a4 NUMBER := 0-1962.0724
169: , p0_a5 NUMBER := 0-1962.0724
170: , p0_a6 NUMBER := 0-1962.0724
171: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a10 NUMBER := 0-1962.0724
175: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a5 NUMBER := 0-1962.0724
170: , p0_a6 NUMBER := 0-1962.0724
171: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a10 NUMBER := 0-1962.0724
175: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a10 NUMBER := 0-1962.0724
175: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
178: )
179: as
172: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a10 NUMBER := 0-1962.0724
175: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
178: )
179: as
180: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
173: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a10 NUMBER := 0-1962.0724
175: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
178: )
179: as
180: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
181: ddindx binary_integer; indx binary_integer;
210: end;
211:
212: procedure check_listfield_record(x_return_status OUT NOCOPY VARCHAR2
213: , p0_a0 NUMBER := 0-1962.0724
214: , p0_a1 DATE := fnd_api.g_miss_date
215: , p0_a2 NUMBER := 0-1962.0724
216: , p0_a3 DATE := fnd_api.g_miss_date
217: , p0_a4 NUMBER := 0-1962.0724
218: , p0_a5 NUMBER := 0-1962.0724
212: procedure check_listfield_record(x_return_status OUT NOCOPY VARCHAR2
213: , p0_a0 NUMBER := 0-1962.0724
214: , p0_a1 DATE := fnd_api.g_miss_date
215: , p0_a2 NUMBER := 0-1962.0724
216: , p0_a3 DATE := fnd_api.g_miss_date
217: , p0_a4 NUMBER := 0-1962.0724
218: , p0_a5 NUMBER := 0-1962.0724
219: , p0_a6 NUMBER := 0-1962.0724
220: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a3 DATE := fnd_api.g_miss_date
217: , p0_a4 NUMBER := 0-1962.0724
218: , p0_a5 NUMBER := 0-1962.0724
219: , p0_a6 NUMBER := 0-1962.0724
220: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a10 NUMBER := 0-1962.0724
224: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a4 NUMBER := 0-1962.0724
218: , p0_a5 NUMBER := 0-1962.0724
219: , p0_a6 NUMBER := 0-1962.0724
220: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a10 NUMBER := 0-1962.0724
224: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a5 NUMBER := 0-1962.0724
219: , p0_a6 NUMBER := 0-1962.0724
220: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a10 NUMBER := 0-1962.0724
224: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
226: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a10 NUMBER := 0-1962.0724
224: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
226: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
227: , p1_a0 NUMBER := 0-1962.0724
228: , p1_a1 DATE := fnd_api.g_miss_date
221: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a10 NUMBER := 0-1962.0724
224: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
226: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
227: , p1_a0 NUMBER := 0-1962.0724
228: , p1_a1 DATE := fnd_api.g_miss_date
229: , p1_a2 NUMBER := 0-1962.0724
222: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a10 NUMBER := 0-1962.0724
224: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
226: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
227: , p1_a0 NUMBER := 0-1962.0724
228: , p1_a1 DATE := fnd_api.g_miss_date
229: , p1_a2 NUMBER := 0-1962.0724
230: , p1_a3 DATE := fnd_api.g_miss_date
224: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
225: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
226: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
227: , p1_a0 NUMBER := 0-1962.0724
228: , p1_a1 DATE := fnd_api.g_miss_date
229: , p1_a2 NUMBER := 0-1962.0724
230: , p1_a3 DATE := fnd_api.g_miss_date
231: , p1_a4 NUMBER := 0-1962.0724
232: , p1_a5 NUMBER := 0-1962.0724
226: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
227: , p1_a0 NUMBER := 0-1962.0724
228: , p1_a1 DATE := fnd_api.g_miss_date
229: , p1_a2 NUMBER := 0-1962.0724
230: , p1_a3 DATE := fnd_api.g_miss_date
231: , p1_a4 NUMBER := 0-1962.0724
232: , p1_a5 NUMBER := 0-1962.0724
233: , p1_a6 NUMBER := 0-1962.0724
234: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
230: , p1_a3 DATE := fnd_api.g_miss_date
231: , p1_a4 NUMBER := 0-1962.0724
232: , p1_a5 NUMBER := 0-1962.0724
233: , p1_a6 NUMBER := 0-1962.0724
234: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p1_a10 NUMBER := 0-1962.0724
238: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
231: , p1_a4 NUMBER := 0-1962.0724
232: , p1_a5 NUMBER := 0-1962.0724
233: , p1_a6 NUMBER := 0-1962.0724
234: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p1_a10 NUMBER := 0-1962.0724
238: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p1_a5 NUMBER := 0-1962.0724
233: , p1_a6 NUMBER := 0-1962.0724
234: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p1_a10 NUMBER := 0-1962.0724
238: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
234: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p1_a10 NUMBER := 0-1962.0724
238: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
241: )
242: as
235: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p1_a10 NUMBER := 0-1962.0724
238: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
241: )
242: as
243: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
236: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p1_a10 NUMBER := 0-1962.0724
238: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
241: )
242: as
243: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
244: ddp_complete_rec ams_listfield_pvt.list_field_rec_type;
343: , p1_a11 OUT NOCOPY VARCHAR2
344: , p1_a12 OUT NOCOPY VARCHAR2
345: , p1_a13 OUT NOCOPY VARCHAR2
346: , p0_a0 NUMBER := 0-1962.0724
347: , p0_a1 DATE := fnd_api.g_miss_date
348: , p0_a2 NUMBER := 0-1962.0724
349: , p0_a3 DATE := fnd_api.g_miss_date
350: , p0_a4 NUMBER := 0-1962.0724
351: , p0_a5 NUMBER := 0-1962.0724
345: , p1_a13 OUT NOCOPY VARCHAR2
346: , p0_a0 NUMBER := 0-1962.0724
347: , p0_a1 DATE := fnd_api.g_miss_date
348: , p0_a2 NUMBER := 0-1962.0724
349: , p0_a3 DATE := fnd_api.g_miss_date
350: , p0_a4 NUMBER := 0-1962.0724
351: , p0_a5 NUMBER := 0-1962.0724
352: , p0_a6 NUMBER := 0-1962.0724
353: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a3 DATE := fnd_api.g_miss_date
350: , p0_a4 NUMBER := 0-1962.0724
351: , p0_a5 NUMBER := 0-1962.0724
352: , p0_a6 NUMBER := 0-1962.0724
353: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a10 NUMBER := 0-1962.0724
357: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a4 NUMBER := 0-1962.0724
351: , p0_a5 NUMBER := 0-1962.0724
352: , p0_a6 NUMBER := 0-1962.0724
353: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a10 NUMBER := 0-1962.0724
357: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a5 NUMBER := 0-1962.0724
352: , p0_a6 NUMBER := 0-1962.0724
353: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a10 NUMBER := 0-1962.0724
357: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a10 NUMBER := 0-1962.0724
357: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
360: )
361: as
354: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a10 NUMBER := 0-1962.0724
357: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
360: )
361: as
362: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
355: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a10 NUMBER := 0-1962.0724
357: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
360: )
361: as
362: ddp_listfield_rec ams_listfield_pvt.list_field_rec_type;
363: ddx_complete_rec ams_listfield_pvt.list_field_rec_type;