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_list_word_field(p_api_version NUMBER
27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , x_wrd_fld_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_wrd_fld_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 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
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
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
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: )
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
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: )
45: as
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
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: )
45: as
46: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
39: , p7_a9 NUMBER := 0-1962.0724
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: )
45: as
46: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
47: ddindx binary_integer; indx binary_integer;
100: , x_return_status OUT NOCOPY VARCHAR2
101: , x_msg_count OUT NOCOPY NUMBER
102: , x_msg_data OUT NOCOPY VARCHAR2
103: , p7_a0 NUMBER := 0-1962.0724
104: , p7_a1 DATE := fnd_api.g_miss_date
105: , p7_a2 NUMBER := 0-1962.0724
106: , p7_a3 DATE := fnd_api.g_miss_date
107: , p7_a4 NUMBER := 0-1962.0724
108: , p7_a5 NUMBER := 0-1962.0724
102: , x_msg_data OUT NOCOPY VARCHAR2
103: , p7_a0 NUMBER := 0-1962.0724
104: , p7_a1 DATE := fnd_api.g_miss_date
105: , p7_a2 NUMBER := 0-1962.0724
106: , p7_a3 DATE := fnd_api.g_miss_date
107: , p7_a4 NUMBER := 0-1962.0724
108: , p7_a5 NUMBER := 0-1962.0724
109: , p7_a6 NUMBER := 0-1962.0724
110: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a3 DATE := fnd_api.g_miss_date
107: , p7_a4 NUMBER := 0-1962.0724
108: , p7_a5 NUMBER := 0-1962.0724
109: , p7_a6 NUMBER := 0-1962.0724
110: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a9 NUMBER := 0-1962.0724
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a4 NUMBER := 0-1962.0724
108: , p7_a5 NUMBER := 0-1962.0724
109: , p7_a6 NUMBER := 0-1962.0724
110: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a9 NUMBER := 0-1962.0724
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a6 NUMBER := 0-1962.0724
110: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a9 NUMBER := 0-1962.0724
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
117: )
110: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a9 NUMBER := 0-1962.0724
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
117: )
118: as
111: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a9 NUMBER := 0-1962.0724
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
117: )
118: as
119: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
112: , p7_a9 NUMBER := 0-1962.0724
113: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
117: )
118: as
119: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
120: ddindx binary_integer; indx binary_integer;
169: , x_return_status OUT NOCOPY VARCHAR2
170: , x_msg_count OUT NOCOPY NUMBER
171: , x_msg_data OUT NOCOPY VARCHAR2
172: , p6_a0 NUMBER := 0-1962.0724
173: , p6_a1 DATE := fnd_api.g_miss_date
174: , p6_a2 NUMBER := 0-1962.0724
175: , p6_a3 DATE := fnd_api.g_miss_date
176: , p6_a4 NUMBER := 0-1962.0724
177: , p6_a5 NUMBER := 0-1962.0724
171: , x_msg_data OUT NOCOPY VARCHAR2
172: , p6_a0 NUMBER := 0-1962.0724
173: , p6_a1 DATE := fnd_api.g_miss_date
174: , p6_a2 NUMBER := 0-1962.0724
175: , p6_a3 DATE := fnd_api.g_miss_date
176: , p6_a4 NUMBER := 0-1962.0724
177: , p6_a5 NUMBER := 0-1962.0724
178: , p6_a6 NUMBER := 0-1962.0724
179: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
175: , p6_a3 DATE := fnd_api.g_miss_date
176: , p6_a4 NUMBER := 0-1962.0724
177: , p6_a5 NUMBER := 0-1962.0724
178: , p6_a6 NUMBER := 0-1962.0724
179: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a9 NUMBER := 0-1962.0724
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p6_a4 NUMBER := 0-1962.0724
177: , p6_a5 NUMBER := 0-1962.0724
178: , p6_a6 NUMBER := 0-1962.0724
179: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a9 NUMBER := 0-1962.0724
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
178: , p6_a6 NUMBER := 0-1962.0724
179: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a9 NUMBER := 0-1962.0724
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
186: )
179: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a9 NUMBER := 0-1962.0724
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
186: )
187: as
180: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
181: , p6_a9 NUMBER := 0-1962.0724
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
186: )
187: as
188: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
181: , p6_a9 NUMBER := 0-1962.0724
182: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
185: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
186: )
187: as
188: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
189: ddindx binary_integer; indx binary_integer;
231:
232: procedure check_items(p_validation_mode VARCHAR2
233: , x_return_status OUT NOCOPY VARCHAR2
234: , p2_a0 NUMBER := 0-1962.0724
235: , p2_a1 DATE := fnd_api.g_miss_date
236: , p2_a2 NUMBER := 0-1962.0724
237: , p2_a3 DATE := fnd_api.g_miss_date
238: , p2_a4 NUMBER := 0-1962.0724
239: , p2_a5 NUMBER := 0-1962.0724
233: , x_return_status OUT NOCOPY VARCHAR2
234: , p2_a0 NUMBER := 0-1962.0724
235: , p2_a1 DATE := fnd_api.g_miss_date
236: , p2_a2 NUMBER := 0-1962.0724
237: , p2_a3 DATE := fnd_api.g_miss_date
238: , p2_a4 NUMBER := 0-1962.0724
239: , p2_a5 NUMBER := 0-1962.0724
240: , p2_a6 NUMBER := 0-1962.0724
241: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
237: , p2_a3 DATE := fnd_api.g_miss_date
238: , p2_a4 NUMBER := 0-1962.0724
239: , p2_a5 NUMBER := 0-1962.0724
240: , p2_a6 NUMBER := 0-1962.0724
241: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a9 NUMBER := 0-1962.0724
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
238: , p2_a4 NUMBER := 0-1962.0724
239: , p2_a5 NUMBER := 0-1962.0724
240: , p2_a6 NUMBER := 0-1962.0724
241: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a9 NUMBER := 0-1962.0724
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p2_a6 NUMBER := 0-1962.0724
241: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a9 NUMBER := 0-1962.0724
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
248: )
241: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a9 NUMBER := 0-1962.0724
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
248: )
249: as
242: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p2_a9 NUMBER := 0-1962.0724
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
248: )
249: as
250: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
243: , p2_a9 NUMBER := 0-1962.0724
244: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
248: )
249: as
250: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
251: ddindx binary_integer; indx binary_integer;
281:
282: procedure check_req_items(p_validation_mode VARCHAR2
283: , x_return_status OUT NOCOPY VARCHAR2
284: , p1_a0 NUMBER := 0-1962.0724
285: , p1_a1 DATE := fnd_api.g_miss_date
286: , p1_a2 NUMBER := 0-1962.0724
287: , p1_a3 DATE := fnd_api.g_miss_date
288: , p1_a4 NUMBER := 0-1962.0724
289: , p1_a5 NUMBER := 0-1962.0724
283: , x_return_status OUT NOCOPY VARCHAR2
284: , p1_a0 NUMBER := 0-1962.0724
285: , p1_a1 DATE := fnd_api.g_miss_date
286: , p1_a2 NUMBER := 0-1962.0724
287: , p1_a3 DATE := fnd_api.g_miss_date
288: , p1_a4 NUMBER := 0-1962.0724
289: , p1_a5 NUMBER := 0-1962.0724
290: , p1_a6 NUMBER := 0-1962.0724
291: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
287: , p1_a3 DATE := fnd_api.g_miss_date
288: , p1_a4 NUMBER := 0-1962.0724
289: , p1_a5 NUMBER := 0-1962.0724
290: , p1_a6 NUMBER := 0-1962.0724
291: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a9 NUMBER := 0-1962.0724
294: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
288: , p1_a4 NUMBER := 0-1962.0724
289: , p1_a5 NUMBER := 0-1962.0724
290: , p1_a6 NUMBER := 0-1962.0724
291: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a9 NUMBER := 0-1962.0724
294: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
290: , p1_a6 NUMBER := 0-1962.0724
291: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a9 NUMBER := 0-1962.0724
294: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
298: )
291: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a9 NUMBER := 0-1962.0724
294: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
298: )
299: as
292: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
293: , p1_a9 NUMBER := 0-1962.0724
294: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
298: )
299: as
300: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
293: , p1_a9 NUMBER := 0-1962.0724
294: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
298: )
299: as
300: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
301: ddindx binary_integer; indx binary_integer;
330: end;
331:
332: procedure check_fk_items(x_return_status OUT NOCOPY VARCHAR2
333: , p0_a0 NUMBER := 0-1962.0724
334: , p0_a1 DATE := fnd_api.g_miss_date
335: , p0_a2 NUMBER := 0-1962.0724
336: , p0_a3 DATE := fnd_api.g_miss_date
337: , p0_a4 NUMBER := 0-1962.0724
338: , p0_a5 NUMBER := 0-1962.0724
332: procedure check_fk_items(x_return_status OUT NOCOPY VARCHAR2
333: , p0_a0 NUMBER := 0-1962.0724
334: , p0_a1 DATE := fnd_api.g_miss_date
335: , p0_a2 NUMBER := 0-1962.0724
336: , p0_a3 DATE := fnd_api.g_miss_date
337: , p0_a4 NUMBER := 0-1962.0724
338: , p0_a5 NUMBER := 0-1962.0724
339: , p0_a6 NUMBER := 0-1962.0724
340: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
336: , p0_a3 DATE := fnd_api.g_miss_date
337: , p0_a4 NUMBER := 0-1962.0724
338: , p0_a5 NUMBER := 0-1962.0724
339: , p0_a6 NUMBER := 0-1962.0724
340: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a9 NUMBER := 0-1962.0724
343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
337: , p0_a4 NUMBER := 0-1962.0724
338: , p0_a5 NUMBER := 0-1962.0724
339: , p0_a6 NUMBER := 0-1962.0724
340: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a9 NUMBER := 0-1962.0724
343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a6 NUMBER := 0-1962.0724
340: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a9 NUMBER := 0-1962.0724
343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
347: )
340: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a9 NUMBER := 0-1962.0724
343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
347: )
348: as
341: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a9 NUMBER := 0-1962.0724
343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
347: )
348: as
349: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
342: , p0_a9 NUMBER := 0-1962.0724
343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
347: )
348: as
349: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
350: ddindx binary_integer; indx binary_integer;
377:
378: procedure check_uk_items(p_validation_mode VARCHAR2
379: , x_return_status OUT NOCOPY VARCHAR2
380: , p1_a0 NUMBER := 0-1962.0724
381: , p1_a1 DATE := fnd_api.g_miss_date
382: , p1_a2 NUMBER := 0-1962.0724
383: , p1_a3 DATE := fnd_api.g_miss_date
384: , p1_a4 NUMBER := 0-1962.0724
385: , p1_a5 NUMBER := 0-1962.0724
379: , x_return_status OUT NOCOPY VARCHAR2
380: , p1_a0 NUMBER := 0-1962.0724
381: , p1_a1 DATE := fnd_api.g_miss_date
382: , p1_a2 NUMBER := 0-1962.0724
383: , p1_a3 DATE := fnd_api.g_miss_date
384: , p1_a4 NUMBER := 0-1962.0724
385: , p1_a5 NUMBER := 0-1962.0724
386: , p1_a6 NUMBER := 0-1962.0724
387: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
383: , p1_a3 DATE := fnd_api.g_miss_date
384: , p1_a4 NUMBER := 0-1962.0724
385: , p1_a5 NUMBER := 0-1962.0724
386: , p1_a6 NUMBER := 0-1962.0724
387: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
388: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
389: , p1_a9 NUMBER := 0-1962.0724
390: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
391: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
384: , p1_a4 NUMBER := 0-1962.0724
385: , p1_a5 NUMBER := 0-1962.0724
386: , p1_a6 NUMBER := 0-1962.0724
387: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
388: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
389: , p1_a9 NUMBER := 0-1962.0724
390: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
391: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
392: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
386: , p1_a6 NUMBER := 0-1962.0724
387: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
388: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
389: , p1_a9 NUMBER := 0-1962.0724
390: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
391: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
392: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
393: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
394: )
387: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
388: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
389: , p1_a9 NUMBER := 0-1962.0724
390: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
391: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
392: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
393: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
394: )
395: as
388: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
389: , p1_a9 NUMBER := 0-1962.0724
390: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
391: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
392: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
393: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
394: )
395: as
396: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
389: , p1_a9 NUMBER := 0-1962.0724
390: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
391: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
392: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
393: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
394: )
395: as
396: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
397: ddindx binary_integer; indx binary_integer;
439: , p1_a11 OUT NOCOPY VARCHAR2
440: , p1_a12 OUT NOCOPY VARCHAR2
441: , p1_a13 OUT NOCOPY VARCHAR2
442: , p0_a0 NUMBER := 0-1962.0724
443: , p0_a1 DATE := fnd_api.g_miss_date
444: , p0_a2 NUMBER := 0-1962.0724
445: , p0_a3 DATE := fnd_api.g_miss_date
446: , p0_a4 NUMBER := 0-1962.0724
447: , p0_a5 NUMBER := 0-1962.0724
441: , p1_a13 OUT NOCOPY VARCHAR2
442: , p0_a0 NUMBER := 0-1962.0724
443: , p0_a1 DATE := fnd_api.g_miss_date
444: , p0_a2 NUMBER := 0-1962.0724
445: , p0_a3 DATE := fnd_api.g_miss_date
446: , p0_a4 NUMBER := 0-1962.0724
447: , p0_a5 NUMBER := 0-1962.0724
448: , p0_a6 NUMBER := 0-1962.0724
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a3 DATE := fnd_api.g_miss_date
446: , p0_a4 NUMBER := 0-1962.0724
447: , p0_a5 NUMBER := 0-1962.0724
448: , p0_a6 NUMBER := 0-1962.0724
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a4 NUMBER := 0-1962.0724
447: , p0_a5 NUMBER := 0-1962.0724
448: , p0_a6 NUMBER := 0-1962.0724
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
454: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a6 NUMBER := 0-1962.0724
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
454: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
456: )
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
454: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
456: )
457: as
450: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
454: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
456: )
457: as
458: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
454: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
456: )
457: as
458: ddp_wrd_fld_rec ams_list_word_fields_pvt.wrd_fld_rec_type;
459: ddx_complete_rec ams_list_word_fields_pvt.wrd_fld_rec_type;