APPS.AMS_LIST_RULES_ALL_PVT_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

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;

Line 18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; 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_rule(p_api_version NUMBER

Line 31: , p7_a1 DATE := fnd_api.g_miss_date

27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , x_list_rule_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

Line 33: , p7_a3 DATE := fnd_api.g_miss_date

29: , x_list_rule_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

Line 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 DATE := fnd_api.g_miss_date
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 39: , p7_a9 DATE := fnd_api.g_miss_date

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 DATE := fnd_api.g_miss_date
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 VARCHAR := fnd_api.g_miss_char

Line 40: , p7_a10 DATE := fnd_api.g_miss_date

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 DATE := fnd_api.g_miss_date
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 VARCHAR := fnd_api.g_miss_char
44: )

Line 41: , p7_a11 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 DATE := fnd_api.g_miss_date
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 VARCHAR := fnd_api.g_miss_char
44: )
45: as

Line 43: , p7_a13 VARCHAR := fnd_api.g_miss_char

39: , p7_a9 DATE := fnd_api.g_miss_date
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 VARCHAR := fnd_api.g_miss_char
44: )
45: as
46: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
47: ddindx binary_integer; indx binary_integer;

Line 104: , p7_a1 DATE := fnd_api.g_miss_date

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

Line 106: , p7_a3 DATE := fnd_api.g_miss_date

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

Line 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 NUMBER := 0-1962.0724
112: , p7_a9 DATE := fnd_api.g_miss_date
113: , p7_a10 DATE := fnd_api.g_miss_date
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 112: , p7_a9 DATE := fnd_api.g_miss_date

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 NUMBER := 0-1962.0724
112: , p7_a9 DATE := fnd_api.g_miss_date
113: , p7_a10 DATE := fnd_api.g_miss_date
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 NUMBER := 0-1962.0724
116: , p7_a13 VARCHAR := fnd_api.g_miss_char

Line 113: , p7_a10 DATE := fnd_api.g_miss_date

109: , p7_a6 NUMBER := 0-1962.0724
110: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a8 NUMBER := 0-1962.0724
112: , p7_a9 DATE := fnd_api.g_miss_date
113: , p7_a10 DATE := fnd_api.g_miss_date
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 NUMBER := 0-1962.0724
116: , p7_a13 VARCHAR := fnd_api.g_miss_char
117: )

Line 114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

110: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a8 NUMBER := 0-1962.0724
112: , p7_a9 DATE := fnd_api.g_miss_date
113: , p7_a10 DATE := fnd_api.g_miss_date
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 NUMBER := 0-1962.0724
116: , p7_a13 VARCHAR := fnd_api.g_miss_char
117: )
118: as

Line 116: , p7_a13 VARCHAR := fnd_api.g_miss_char

112: , p7_a9 DATE := fnd_api.g_miss_date
113: , p7_a10 DATE := fnd_api.g_miss_date
114: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p7_a12 NUMBER := 0-1962.0724
116: , p7_a13 VARCHAR := fnd_api.g_miss_char
117: )
118: as
119: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
120: ddindx binary_integer; indx binary_integer;

Line 173: , p6_a1 DATE := fnd_api.g_miss_date

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

Line 175: , p6_a3 DATE := fnd_api.g_miss_date

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

Line 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 NUMBER := 0-1962.0724
181: , p6_a9 DATE := fnd_api.g_miss_date
182: , p6_a10 DATE := fnd_api.g_miss_date
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char

Line 181: , p6_a9 DATE := fnd_api.g_miss_date

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 NUMBER := 0-1962.0724
181: , p6_a9 DATE := fnd_api.g_miss_date
182: , p6_a10 DATE := fnd_api.g_miss_date
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 NUMBER := 0-1962.0724
185: , p6_a13 VARCHAR := fnd_api.g_miss_char

Line 182: , p6_a10 DATE := fnd_api.g_miss_date

178: , p6_a6 NUMBER := 0-1962.0724
179: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a8 NUMBER := 0-1962.0724
181: , p6_a9 DATE := fnd_api.g_miss_date
182: , p6_a10 DATE := fnd_api.g_miss_date
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 NUMBER := 0-1962.0724
185: , p6_a13 VARCHAR := fnd_api.g_miss_char
186: )

Line 183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char

179: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
180: , p6_a8 NUMBER := 0-1962.0724
181: , p6_a9 DATE := fnd_api.g_miss_date
182: , p6_a10 DATE := fnd_api.g_miss_date
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 NUMBER := 0-1962.0724
185: , p6_a13 VARCHAR := fnd_api.g_miss_char
186: )
187: as

Line 185: , p6_a13 VARCHAR := fnd_api.g_miss_char

181: , p6_a9 DATE := fnd_api.g_miss_date
182: , p6_a10 DATE := fnd_api.g_miss_date
183: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
184: , p6_a12 NUMBER := 0-1962.0724
185: , p6_a13 VARCHAR := fnd_api.g_miss_char
186: )
187: as
188: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
189: ddindx binary_integer; indx binary_integer;

Line 235: , p2_a1 DATE := fnd_api.g_miss_date

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

Line 237: , p2_a3 DATE := fnd_api.g_miss_date

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

Line 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 NUMBER := 0-1962.0724
243: , p2_a9 DATE := fnd_api.g_miss_date
244: , p2_a10 DATE := fnd_api.g_miss_date
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char

Line 243: , p2_a9 DATE := fnd_api.g_miss_date

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 NUMBER := 0-1962.0724
243: , p2_a9 DATE := fnd_api.g_miss_date
244: , p2_a10 DATE := fnd_api.g_miss_date
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 NUMBER := 0-1962.0724
247: , p2_a13 VARCHAR := fnd_api.g_miss_char

Line 244: , p2_a10 DATE := fnd_api.g_miss_date

240: , p2_a6 NUMBER := 0-1962.0724
241: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a8 NUMBER := 0-1962.0724
243: , p2_a9 DATE := fnd_api.g_miss_date
244: , p2_a10 DATE := fnd_api.g_miss_date
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 NUMBER := 0-1962.0724
247: , p2_a13 VARCHAR := fnd_api.g_miss_char
248: )

Line 245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char

241: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p2_a8 NUMBER := 0-1962.0724
243: , p2_a9 DATE := fnd_api.g_miss_date
244: , p2_a10 DATE := fnd_api.g_miss_date
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 NUMBER := 0-1962.0724
247: , p2_a13 VARCHAR := fnd_api.g_miss_char
248: )
249: as

Line 247: , p2_a13 VARCHAR := fnd_api.g_miss_char

243: , p2_a9 DATE := fnd_api.g_miss_date
244: , p2_a10 DATE := fnd_api.g_miss_date
245: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p2_a12 NUMBER := 0-1962.0724
247: , p2_a13 VARCHAR := fnd_api.g_miss_char
248: )
249: as
250: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
251: ddindx binary_integer; indx binary_integer;

Line 285: , p1_a1 DATE := fnd_api.g_miss_date

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

Line 287: , p1_a3 DATE := fnd_api.g_miss_date

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

Line 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 NUMBER := 0-1962.0724
293: , p1_a9 DATE := fnd_api.g_miss_date
294: , p1_a10 DATE := fnd_api.g_miss_date
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

Line 293: , p1_a9 DATE := fnd_api.g_miss_date

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 NUMBER := 0-1962.0724
293: , p1_a9 DATE := fnd_api.g_miss_date
294: , p1_a10 DATE := fnd_api.g_miss_date
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a12 NUMBER := 0-1962.0724
297: , p1_a13 VARCHAR := fnd_api.g_miss_char

Line 294: , p1_a10 DATE := fnd_api.g_miss_date

290: , p1_a6 NUMBER := 0-1962.0724
291: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a8 NUMBER := 0-1962.0724
293: , p1_a9 DATE := fnd_api.g_miss_date
294: , p1_a10 DATE := fnd_api.g_miss_date
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a12 NUMBER := 0-1962.0724
297: , p1_a13 VARCHAR := fnd_api.g_miss_char
298: )

Line 295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

291: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
292: , p1_a8 NUMBER := 0-1962.0724
293: , p1_a9 DATE := fnd_api.g_miss_date
294: , p1_a10 DATE := fnd_api.g_miss_date
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a12 NUMBER := 0-1962.0724
297: , p1_a13 VARCHAR := fnd_api.g_miss_char
298: )
299: as

Line 297: , p1_a13 VARCHAR := fnd_api.g_miss_char

293: , p1_a9 DATE := fnd_api.g_miss_date
294: , p1_a10 DATE := fnd_api.g_miss_date
295: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p1_a12 NUMBER := 0-1962.0724
297: , p1_a13 VARCHAR := fnd_api.g_miss_char
298: )
299: as
300: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
301: ddindx binary_integer; indx binary_integer;

Line 335: , p1_a1 DATE := fnd_api.g_miss_date

331:
332: procedure check_uk_items(p_validation_mode VARCHAR2
333: , x_return_status OUT NOCOPY VARCHAR2
334: , p1_a0 NUMBER := 0-1962.0724
335: , p1_a1 DATE := fnd_api.g_miss_date
336: , p1_a2 NUMBER := 0-1962.0724
337: , p1_a3 DATE := fnd_api.g_miss_date
338: , p1_a4 NUMBER := 0-1962.0724
339: , p1_a5 NUMBER := 0-1962.0724

Line 337: , p1_a3 DATE := fnd_api.g_miss_date

333: , x_return_status OUT NOCOPY VARCHAR2
334: , p1_a0 NUMBER := 0-1962.0724
335: , p1_a1 DATE := fnd_api.g_miss_date
336: , p1_a2 NUMBER := 0-1962.0724
337: , p1_a3 DATE := fnd_api.g_miss_date
338: , p1_a4 NUMBER := 0-1962.0724
339: , p1_a5 NUMBER := 0-1962.0724
340: , p1_a6 NUMBER := 0-1962.0724
341: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

Line 341: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

337: , p1_a3 DATE := fnd_api.g_miss_date
338: , p1_a4 NUMBER := 0-1962.0724
339: , p1_a5 NUMBER := 0-1962.0724
340: , p1_a6 NUMBER := 0-1962.0724
341: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a8 NUMBER := 0-1962.0724
343: , p1_a9 DATE := fnd_api.g_miss_date
344: , p1_a10 DATE := fnd_api.g_miss_date
345: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

Line 343: , p1_a9 DATE := fnd_api.g_miss_date

339: , p1_a5 NUMBER := 0-1962.0724
340: , p1_a6 NUMBER := 0-1962.0724
341: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a8 NUMBER := 0-1962.0724
343: , p1_a9 DATE := fnd_api.g_miss_date
344: , p1_a10 DATE := fnd_api.g_miss_date
345: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
346: , p1_a12 NUMBER := 0-1962.0724
347: , p1_a13 VARCHAR := fnd_api.g_miss_char

Line 344: , p1_a10 DATE := fnd_api.g_miss_date

340: , p1_a6 NUMBER := 0-1962.0724
341: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a8 NUMBER := 0-1962.0724
343: , p1_a9 DATE := fnd_api.g_miss_date
344: , p1_a10 DATE := fnd_api.g_miss_date
345: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
346: , p1_a12 NUMBER := 0-1962.0724
347: , p1_a13 VARCHAR := fnd_api.g_miss_char
348: )

Line 345: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

341: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a8 NUMBER := 0-1962.0724
343: , p1_a9 DATE := fnd_api.g_miss_date
344: , p1_a10 DATE := fnd_api.g_miss_date
345: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
346: , p1_a12 NUMBER := 0-1962.0724
347: , p1_a13 VARCHAR := fnd_api.g_miss_char
348: )
349: as

Line 347: , p1_a13 VARCHAR := fnd_api.g_miss_char

343: , p1_a9 DATE := fnd_api.g_miss_date
344: , p1_a10 DATE := fnd_api.g_miss_date
345: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
346: , p1_a12 NUMBER := 0-1962.0724
347: , p1_a13 VARCHAR := fnd_api.g_miss_char
348: )
349: as
350: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
351: ddindx binary_integer; indx binary_integer;

Line 384: , p0_a1 DATE := fnd_api.g_miss_date

380: end;
381:
382: procedure check_lookup_items(x_return_status OUT NOCOPY VARCHAR2
383: , p0_a0 NUMBER := 0-1962.0724
384: , p0_a1 DATE := fnd_api.g_miss_date
385: , p0_a2 NUMBER := 0-1962.0724
386: , p0_a3 DATE := fnd_api.g_miss_date
387: , p0_a4 NUMBER := 0-1962.0724
388: , p0_a5 NUMBER := 0-1962.0724

Line 386: , p0_a3 DATE := fnd_api.g_miss_date

382: procedure check_lookup_items(x_return_status OUT NOCOPY VARCHAR2
383: , p0_a0 NUMBER := 0-1962.0724
384: , p0_a1 DATE := fnd_api.g_miss_date
385: , p0_a2 NUMBER := 0-1962.0724
386: , p0_a3 DATE := fnd_api.g_miss_date
387: , p0_a4 NUMBER := 0-1962.0724
388: , p0_a5 NUMBER := 0-1962.0724
389: , p0_a6 NUMBER := 0-1962.0724
390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

386: , p0_a3 DATE := fnd_api.g_miss_date
387: , p0_a4 NUMBER := 0-1962.0724
388: , p0_a5 NUMBER := 0-1962.0724
389: , p0_a6 NUMBER := 0-1962.0724
390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a8 NUMBER := 0-1962.0724
392: , p0_a9 DATE := fnd_api.g_miss_date
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 392: , p0_a9 DATE := fnd_api.g_miss_date

388: , p0_a5 NUMBER := 0-1962.0724
389: , p0_a6 NUMBER := 0-1962.0724
390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a8 NUMBER := 0-1962.0724
392: , p0_a9 DATE := fnd_api.g_miss_date
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p0_a12 NUMBER := 0-1962.0724
396: , p0_a13 VARCHAR := fnd_api.g_miss_char

Line 393: , p0_a10 DATE := fnd_api.g_miss_date

389: , p0_a6 NUMBER := 0-1962.0724
390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a8 NUMBER := 0-1962.0724
392: , p0_a9 DATE := fnd_api.g_miss_date
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p0_a12 NUMBER := 0-1962.0724
396: , p0_a13 VARCHAR := fnd_api.g_miss_char
397: )

Line 394: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

390: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
391: , p0_a8 NUMBER := 0-1962.0724
392: , p0_a9 DATE := fnd_api.g_miss_date
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p0_a12 NUMBER := 0-1962.0724
396: , p0_a13 VARCHAR := fnd_api.g_miss_char
397: )
398: as

Line 396: , p0_a13 VARCHAR := fnd_api.g_miss_char

392: , p0_a9 DATE := fnd_api.g_miss_date
393: , p0_a10 DATE := fnd_api.g_miss_date
394: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
395: , p0_a12 NUMBER := 0-1962.0724
396: , p0_a13 VARCHAR := fnd_api.g_miss_char
397: )
398: as
399: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
400: ddindx binary_integer; indx binary_integer;

Line 430: , p0_a1 DATE := fnd_api.g_miss_date

426: end;
427:
428: procedure check_record(x_return_status OUT NOCOPY VARCHAR2
429: , p0_a0 NUMBER := 0-1962.0724
430: , p0_a1 DATE := fnd_api.g_miss_date
431: , p0_a2 NUMBER := 0-1962.0724
432: , p0_a3 DATE := fnd_api.g_miss_date
433: , p0_a4 NUMBER := 0-1962.0724
434: , p0_a5 NUMBER := 0-1962.0724

Line 432: , p0_a3 DATE := fnd_api.g_miss_date

428: procedure check_record(x_return_status OUT NOCOPY VARCHAR2
429: , p0_a0 NUMBER := 0-1962.0724
430: , p0_a1 DATE := fnd_api.g_miss_date
431: , p0_a2 NUMBER := 0-1962.0724
432: , p0_a3 DATE := fnd_api.g_miss_date
433: , p0_a4 NUMBER := 0-1962.0724
434: , p0_a5 NUMBER := 0-1962.0724
435: , p0_a6 NUMBER := 0-1962.0724
436: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 436: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

432: , p0_a3 DATE := fnd_api.g_miss_date
433: , p0_a4 NUMBER := 0-1962.0724
434: , p0_a5 NUMBER := 0-1962.0724
435: , p0_a6 NUMBER := 0-1962.0724
436: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p0_a8 NUMBER := 0-1962.0724
438: , p0_a9 DATE := fnd_api.g_miss_date
439: , p0_a10 DATE := fnd_api.g_miss_date
440: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 438: , p0_a9 DATE := fnd_api.g_miss_date

434: , p0_a5 NUMBER := 0-1962.0724
435: , p0_a6 NUMBER := 0-1962.0724
436: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p0_a8 NUMBER := 0-1962.0724
438: , p0_a9 DATE := fnd_api.g_miss_date
439: , p0_a10 DATE := fnd_api.g_miss_date
440: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a12 NUMBER := 0-1962.0724
442: , p0_a13 VARCHAR := fnd_api.g_miss_char

Line 439: , p0_a10 DATE := fnd_api.g_miss_date

435: , p0_a6 NUMBER := 0-1962.0724
436: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p0_a8 NUMBER := 0-1962.0724
438: , p0_a9 DATE := fnd_api.g_miss_date
439: , p0_a10 DATE := fnd_api.g_miss_date
440: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a12 NUMBER := 0-1962.0724
442: , p0_a13 VARCHAR := fnd_api.g_miss_char
443: , p1_a0 NUMBER := 0-1962.0724

Line 440: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

436: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
437: , p0_a8 NUMBER := 0-1962.0724
438: , p0_a9 DATE := fnd_api.g_miss_date
439: , p0_a10 DATE := fnd_api.g_miss_date
440: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a12 NUMBER := 0-1962.0724
442: , p0_a13 VARCHAR := fnd_api.g_miss_char
443: , p1_a0 NUMBER := 0-1962.0724
444: , p1_a1 DATE := fnd_api.g_miss_date

Line 442: , p0_a13 VARCHAR := fnd_api.g_miss_char

438: , p0_a9 DATE := fnd_api.g_miss_date
439: , p0_a10 DATE := fnd_api.g_miss_date
440: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a12 NUMBER := 0-1962.0724
442: , p0_a13 VARCHAR := fnd_api.g_miss_char
443: , p1_a0 NUMBER := 0-1962.0724
444: , p1_a1 DATE := fnd_api.g_miss_date
445: , p1_a2 NUMBER := 0-1962.0724
446: , p1_a3 DATE := fnd_api.g_miss_date

Line 444: , p1_a1 DATE := fnd_api.g_miss_date

440: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a12 NUMBER := 0-1962.0724
442: , p0_a13 VARCHAR := fnd_api.g_miss_char
443: , p1_a0 NUMBER := 0-1962.0724
444: , p1_a1 DATE := fnd_api.g_miss_date
445: , p1_a2 NUMBER := 0-1962.0724
446: , p1_a3 DATE := fnd_api.g_miss_date
447: , p1_a4 NUMBER := 0-1962.0724
448: , p1_a5 NUMBER := 0-1962.0724

Line 446: , p1_a3 DATE := fnd_api.g_miss_date

442: , p0_a13 VARCHAR := fnd_api.g_miss_char
443: , p1_a0 NUMBER := 0-1962.0724
444: , p1_a1 DATE := fnd_api.g_miss_date
445: , p1_a2 NUMBER := 0-1962.0724
446: , p1_a3 DATE := fnd_api.g_miss_date
447: , p1_a4 NUMBER := 0-1962.0724
448: , p1_a5 NUMBER := 0-1962.0724
449: , p1_a6 NUMBER := 0-1962.0724
450: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

Line 450: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

446: , p1_a3 DATE := fnd_api.g_miss_date
447: , p1_a4 NUMBER := 0-1962.0724
448: , p1_a5 NUMBER := 0-1962.0724
449: , p1_a6 NUMBER := 0-1962.0724
450: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a8 NUMBER := 0-1962.0724
452: , p1_a9 DATE := fnd_api.g_miss_date
453: , p1_a10 DATE := fnd_api.g_miss_date
454: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

Line 452: , p1_a9 DATE := fnd_api.g_miss_date

448: , p1_a5 NUMBER := 0-1962.0724
449: , p1_a6 NUMBER := 0-1962.0724
450: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a8 NUMBER := 0-1962.0724
452: , p1_a9 DATE := fnd_api.g_miss_date
453: , p1_a10 DATE := fnd_api.g_miss_date
454: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a12 NUMBER := 0-1962.0724
456: , p1_a13 VARCHAR := fnd_api.g_miss_char

Line 453: , p1_a10 DATE := fnd_api.g_miss_date

449: , p1_a6 NUMBER := 0-1962.0724
450: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a8 NUMBER := 0-1962.0724
452: , p1_a9 DATE := fnd_api.g_miss_date
453: , p1_a10 DATE := fnd_api.g_miss_date
454: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a12 NUMBER := 0-1962.0724
456: , p1_a13 VARCHAR := fnd_api.g_miss_char
457: )

Line 454: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

450: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a8 NUMBER := 0-1962.0724
452: , p1_a9 DATE := fnd_api.g_miss_date
453: , p1_a10 DATE := fnd_api.g_miss_date
454: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a12 NUMBER := 0-1962.0724
456: , p1_a13 VARCHAR := fnd_api.g_miss_char
457: )
458: as

Line 456: , p1_a13 VARCHAR := fnd_api.g_miss_char

452: , p1_a9 DATE := fnd_api.g_miss_date
453: , p1_a10 DATE := fnd_api.g_miss_date
454: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a12 NUMBER := 0-1962.0724
456: , p1_a13 VARCHAR := fnd_api.g_miss_char
457: )
458: as
459: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
460: ddp_complete_rec ams_list_rules_all_pvt.list_rule_rec_type;

Line 521: , p0_a1 DATE := fnd_api.g_miss_date

517: , p1_a11 OUT NOCOPY VARCHAR2
518: , p1_a12 OUT NOCOPY NUMBER
519: , p1_a13 OUT NOCOPY VARCHAR
520: , p0_a0 NUMBER := 0-1962.0724
521: , p0_a1 DATE := fnd_api.g_miss_date
522: , p0_a2 NUMBER := 0-1962.0724
523: , p0_a3 DATE := fnd_api.g_miss_date
524: , p0_a4 NUMBER := 0-1962.0724
525: , p0_a5 NUMBER := 0-1962.0724

Line 523: , p0_a3 DATE := fnd_api.g_miss_date

519: , p1_a13 OUT NOCOPY VARCHAR
520: , p0_a0 NUMBER := 0-1962.0724
521: , p0_a1 DATE := fnd_api.g_miss_date
522: , p0_a2 NUMBER := 0-1962.0724
523: , p0_a3 DATE := fnd_api.g_miss_date
524: , p0_a4 NUMBER := 0-1962.0724
525: , p0_a5 NUMBER := 0-1962.0724
526: , p0_a6 NUMBER := 0-1962.0724
527: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 527: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

523: , p0_a3 DATE := fnd_api.g_miss_date
524: , p0_a4 NUMBER := 0-1962.0724
525: , p0_a5 NUMBER := 0-1962.0724
526: , p0_a6 NUMBER := 0-1962.0724
527: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a8 NUMBER := 0-1962.0724
529: , p0_a9 DATE := fnd_api.g_miss_date
530: , p0_a10 DATE := fnd_api.g_miss_date
531: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 529: , p0_a9 DATE := fnd_api.g_miss_date

525: , p0_a5 NUMBER := 0-1962.0724
526: , p0_a6 NUMBER := 0-1962.0724
527: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a8 NUMBER := 0-1962.0724
529: , p0_a9 DATE := fnd_api.g_miss_date
530: , p0_a10 DATE := fnd_api.g_miss_date
531: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a12 NUMBER := 0-1962.0724
533: , p0_a13 VARCHAR := fnd_api.g_miss_char

Line 530: , p0_a10 DATE := fnd_api.g_miss_date

526: , p0_a6 NUMBER := 0-1962.0724
527: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a8 NUMBER := 0-1962.0724
529: , p0_a9 DATE := fnd_api.g_miss_date
530: , p0_a10 DATE := fnd_api.g_miss_date
531: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a12 NUMBER := 0-1962.0724
533: , p0_a13 VARCHAR := fnd_api.g_miss_char
534: )

Line 531: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

527: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a8 NUMBER := 0-1962.0724
529: , p0_a9 DATE := fnd_api.g_miss_date
530: , p0_a10 DATE := fnd_api.g_miss_date
531: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a12 NUMBER := 0-1962.0724
533: , p0_a13 VARCHAR := fnd_api.g_miss_char
534: )
535: as

Line 533: , p0_a13 VARCHAR := fnd_api.g_miss_char

529: , p0_a9 DATE := fnd_api.g_miss_date
530: , p0_a10 DATE := fnd_api.g_miss_date
531: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a12 NUMBER := 0-1962.0724
533: , p0_a13 VARCHAR := fnd_api.g_miss_char
534: )
535: as
536: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
537: ddx_complete_rec ams_list_rules_all_pvt.list_rule_rec_type;