APPS.AMS_ACCESS_PVT_W dependencies on FND_API

Line 9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

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

Line 14: a number := fnd_api.g_miss_num;

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;

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_access_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_access_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 NUMBER := 0-1962.0724

Line 38: , p7_a8 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 NUMBER := 0-1962.0724
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 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 NUMBER := 0-1962.0724
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 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 DATE := fnd_api.g_miss_date

Line 41: , p7_a11 DATE := fnd_api.g_miss_date

37: , p7_a7 NUMBER := 0-1962.0724
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 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 42: , p7_a12 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 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 43: , p7_a13 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 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: )

Line 44: , p7_a14 DATE := fnd_api.g_miss_date

40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: )
48:

Line 45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

41: , p7_a11 DATE := fnd_api.g_miss_date
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: )
48:
49: as

Line 46: , p7_a16 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 DATE := fnd_api.g_miss_date
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: )
48:
49: as
50: ddp_access_rec ams_access_pvt.access_rec_type;

Line 111: , p7_a1 DATE := fnd_api.g_miss_date

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

Line 113: , p7_a3 DATE := fnd_api.g_miss_date

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 NUMBER := 0-1962.0724

Line 118: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

114: , p7_a4 NUMBER := 0-1962.0724
115: , p7_a5 NUMBER := 0-1962.0724
116: , p7_a6 NUMBER := 0-1962.0724
117: , p7_a7 NUMBER := 0-1962.0724
118: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a9 NUMBER := 0-1962.0724
120: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a11 DATE := fnd_api.g_miss_date
122: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 120: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

116: , p7_a6 NUMBER := 0-1962.0724
117: , p7_a7 NUMBER := 0-1962.0724
118: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a9 NUMBER := 0-1962.0724
120: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a11 DATE := fnd_api.g_miss_date
122: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a14 DATE := fnd_api.g_miss_date

Line 121: , p7_a11 DATE := fnd_api.g_miss_date

117: , p7_a7 NUMBER := 0-1962.0724
118: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a9 NUMBER := 0-1962.0724
120: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a11 DATE := fnd_api.g_miss_date
122: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a14 DATE := fnd_api.g_miss_date
125: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 122: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

118: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a9 NUMBER := 0-1962.0724
120: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a11 DATE := fnd_api.g_miss_date
122: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a14 DATE := fnd_api.g_miss_date
125: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 123: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

119: , p7_a9 NUMBER := 0-1962.0724
120: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a11 DATE := fnd_api.g_miss_date
122: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a14 DATE := fnd_api.g_miss_date
125: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
127: )

Line 124: , p7_a14 DATE := fnd_api.g_miss_date

120: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a11 DATE := fnd_api.g_miss_date
122: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a14 DATE := fnd_api.g_miss_date
125: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
127: )
128:

Line 125: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

121: , p7_a11 DATE := fnd_api.g_miss_date
122: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a14 DATE := fnd_api.g_miss_date
125: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
127: )
128:
129: as

Line 126: , p7_a16 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 DATE := fnd_api.g_miss_date
125: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
127: )
128:
129: as
130: ddp_access_rec ams_access_pvt.access_rec_type;

Line 187: , p6_a1 DATE := fnd_api.g_miss_date

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

Line 189: , p6_a3 DATE := fnd_api.g_miss_date

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 NUMBER := 0-1962.0724

Line 194: , p6_a8 VARCHAR2 := fnd_api.g_miss_char

190: , p6_a4 NUMBER := 0-1962.0724
191: , p6_a5 NUMBER := 0-1962.0724
192: , p6_a6 NUMBER := 0-1962.0724
193: , p6_a7 NUMBER := 0-1962.0724
194: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p6_a9 NUMBER := 0-1962.0724
196: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p6_a11 DATE := fnd_api.g_miss_date
198: , p6_a12 VARCHAR2 := fnd_api.g_miss_char

Line 196: , p6_a10 VARCHAR2 := fnd_api.g_miss_char

192: , p6_a6 NUMBER := 0-1962.0724
193: , p6_a7 NUMBER := 0-1962.0724
194: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p6_a9 NUMBER := 0-1962.0724
196: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p6_a11 DATE := fnd_api.g_miss_date
198: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p6_a14 DATE := fnd_api.g_miss_date

Line 197: , p6_a11 DATE := fnd_api.g_miss_date

193: , p6_a7 NUMBER := 0-1962.0724
194: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p6_a9 NUMBER := 0-1962.0724
196: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p6_a11 DATE := fnd_api.g_miss_date
198: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p6_a14 DATE := fnd_api.g_miss_date
201: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

Line 198: , p6_a12 VARCHAR2 := fnd_api.g_miss_char

194: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p6_a9 NUMBER := 0-1962.0724
196: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p6_a11 DATE := fnd_api.g_miss_date
198: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p6_a14 DATE := fnd_api.g_miss_date
201: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p6_a16 VARCHAR2 := fnd_api.g_miss_char

Line 199: , p6_a13 VARCHAR2 := fnd_api.g_miss_char

195: , p6_a9 NUMBER := 0-1962.0724
196: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p6_a11 DATE := fnd_api.g_miss_date
198: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p6_a14 DATE := fnd_api.g_miss_date
201: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
203: )

Line 200: , p6_a14 DATE := fnd_api.g_miss_date

196: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
197: , p6_a11 DATE := fnd_api.g_miss_date
198: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p6_a14 DATE := fnd_api.g_miss_date
201: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
203: )
204:

Line 201: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

197: , p6_a11 DATE := fnd_api.g_miss_date
198: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
199: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
200: , p6_a14 DATE := fnd_api.g_miss_date
201: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
203: )
204:
205: as

Line 202: , p6_a16 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 DATE := fnd_api.g_miss_date
201: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
202: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
203: )
204:
205: as
206: ddp_access_rec ams_access_pvt.access_rec_type;

Line 256: , p0_a1 DATE := fnd_api.g_miss_date

252:
253: procedure check_access_items(p_validation_mode VARCHAR2
254: , x_return_status out nocopy VARCHAR2
255: , p0_a0 NUMBER := 0-1962.0724
256: , p0_a1 DATE := fnd_api.g_miss_date
257: , p0_a2 NUMBER := 0-1962.0724
258: , p0_a3 DATE := fnd_api.g_miss_date
259: , p0_a4 NUMBER := 0-1962.0724
260: , p0_a5 NUMBER := 0-1962.0724

Line 258: , p0_a3 DATE := fnd_api.g_miss_date

254: , x_return_status out nocopy VARCHAR2
255: , p0_a0 NUMBER := 0-1962.0724
256: , p0_a1 DATE := fnd_api.g_miss_date
257: , p0_a2 NUMBER := 0-1962.0724
258: , p0_a3 DATE := fnd_api.g_miss_date
259: , p0_a4 NUMBER := 0-1962.0724
260: , p0_a5 NUMBER := 0-1962.0724
261: , p0_a6 NUMBER := 0-1962.0724
262: , p0_a7 NUMBER := 0-1962.0724

Line 263: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

259: , p0_a4 NUMBER := 0-1962.0724
260: , p0_a5 NUMBER := 0-1962.0724
261: , p0_a6 NUMBER := 0-1962.0724
262: , p0_a7 NUMBER := 0-1962.0724
263: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
264: , p0_a9 NUMBER := 0-1962.0724
265: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
266: , p0_a11 DATE := fnd_api.g_miss_date
267: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 265: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

261: , p0_a6 NUMBER := 0-1962.0724
262: , p0_a7 NUMBER := 0-1962.0724
263: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
264: , p0_a9 NUMBER := 0-1962.0724
265: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
266: , p0_a11 DATE := fnd_api.g_miss_date
267: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
269: , p0_a14 DATE := fnd_api.g_miss_date

Line 266: , p0_a11 DATE := fnd_api.g_miss_date

262: , p0_a7 NUMBER := 0-1962.0724
263: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
264: , p0_a9 NUMBER := 0-1962.0724
265: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
266: , p0_a11 DATE := fnd_api.g_miss_date
267: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
269: , p0_a14 DATE := fnd_api.g_miss_date
270: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 267: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

263: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
264: , p0_a9 NUMBER := 0-1962.0724
265: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
266: , p0_a11 DATE := fnd_api.g_miss_date
267: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
269: , p0_a14 DATE := fnd_api.g_miss_date
270: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
271: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 268: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

264: , p0_a9 NUMBER := 0-1962.0724
265: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
266: , p0_a11 DATE := fnd_api.g_miss_date
267: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
269: , p0_a14 DATE := fnd_api.g_miss_date
270: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
271: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
272: )

Line 269: , p0_a14 DATE := fnd_api.g_miss_date

265: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
266: , p0_a11 DATE := fnd_api.g_miss_date
267: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
269: , p0_a14 DATE := fnd_api.g_miss_date
270: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
271: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
272: )
273:

Line 270: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

266: , p0_a11 DATE := fnd_api.g_miss_date
267: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
269: , p0_a14 DATE := fnd_api.g_miss_date
270: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
271: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
272: )
273:
274: as

Line 271: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

267: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
269: , p0_a14 DATE := fnd_api.g_miss_date
270: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
271: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
272: )
273:
274: as
275: ddp_access_rec ams_access_pvt.access_rec_type;

Line 312: , p0_a1 DATE := fnd_api.g_miss_date

308: end;
309:
310: procedure check_access_record(x_return_status out nocopy VARCHAR2
311: , p0_a0 NUMBER := 0-1962.0724
312: , p0_a1 DATE := fnd_api.g_miss_date
313: , p0_a2 NUMBER := 0-1962.0724
314: , p0_a3 DATE := fnd_api.g_miss_date
315: , p0_a4 NUMBER := 0-1962.0724
316: , p0_a5 NUMBER := 0-1962.0724

Line 314: , p0_a3 DATE := fnd_api.g_miss_date

310: procedure check_access_record(x_return_status out nocopy VARCHAR2
311: , p0_a0 NUMBER := 0-1962.0724
312: , p0_a1 DATE := fnd_api.g_miss_date
313: , p0_a2 NUMBER := 0-1962.0724
314: , p0_a3 DATE := fnd_api.g_miss_date
315: , p0_a4 NUMBER := 0-1962.0724
316: , p0_a5 NUMBER := 0-1962.0724
317: , p0_a6 NUMBER := 0-1962.0724
318: , p0_a7 NUMBER := 0-1962.0724

Line 319: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

315: , p0_a4 NUMBER := 0-1962.0724
316: , p0_a5 NUMBER := 0-1962.0724
317: , p0_a6 NUMBER := 0-1962.0724
318: , p0_a7 NUMBER := 0-1962.0724
319: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
320: , p0_a9 NUMBER := 0-1962.0724
321: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a11 DATE := fnd_api.g_miss_date
323: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 321: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

317: , p0_a6 NUMBER := 0-1962.0724
318: , p0_a7 NUMBER := 0-1962.0724
319: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
320: , p0_a9 NUMBER := 0-1962.0724
321: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a11 DATE := fnd_api.g_miss_date
323: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
324: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
325: , p0_a14 DATE := fnd_api.g_miss_date

Line 322: , p0_a11 DATE := fnd_api.g_miss_date

318: , p0_a7 NUMBER := 0-1962.0724
319: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
320: , p0_a9 NUMBER := 0-1962.0724
321: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a11 DATE := fnd_api.g_miss_date
323: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
324: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
325: , p0_a14 DATE := fnd_api.g_miss_date
326: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 323: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

319: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
320: , p0_a9 NUMBER := 0-1962.0724
321: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a11 DATE := fnd_api.g_miss_date
323: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
324: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
325: , p0_a14 DATE := fnd_api.g_miss_date
326: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
327: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 324: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

320: , p0_a9 NUMBER := 0-1962.0724
321: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a11 DATE := fnd_api.g_miss_date
323: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
324: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
325: , p0_a14 DATE := fnd_api.g_miss_date
326: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
327: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
328: , p1_a0 NUMBER := 0-1962.0724

Line 325: , p0_a14 DATE := fnd_api.g_miss_date

321: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a11 DATE := fnd_api.g_miss_date
323: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
324: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
325: , p0_a14 DATE := fnd_api.g_miss_date
326: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
327: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
328: , p1_a0 NUMBER := 0-1962.0724
329: , p1_a1 DATE := fnd_api.g_miss_date

Line 326: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

322: , p0_a11 DATE := fnd_api.g_miss_date
323: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
324: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
325: , p0_a14 DATE := fnd_api.g_miss_date
326: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
327: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
328: , p1_a0 NUMBER := 0-1962.0724
329: , p1_a1 DATE := fnd_api.g_miss_date
330: , p1_a2 NUMBER := 0-1962.0724

Line 327: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

323: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
324: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
325: , p0_a14 DATE := fnd_api.g_miss_date
326: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
327: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
328: , p1_a0 NUMBER := 0-1962.0724
329: , p1_a1 DATE := fnd_api.g_miss_date
330: , p1_a2 NUMBER := 0-1962.0724
331: , p1_a3 DATE := fnd_api.g_miss_date

Line 329: , p1_a1 DATE := fnd_api.g_miss_date

325: , p0_a14 DATE := fnd_api.g_miss_date
326: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
327: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
328: , p1_a0 NUMBER := 0-1962.0724
329: , p1_a1 DATE := fnd_api.g_miss_date
330: , p1_a2 NUMBER := 0-1962.0724
331: , p1_a3 DATE := fnd_api.g_miss_date
332: , p1_a4 NUMBER := 0-1962.0724
333: , p1_a5 NUMBER := 0-1962.0724

Line 331: , p1_a3 DATE := fnd_api.g_miss_date

327: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
328: , p1_a0 NUMBER := 0-1962.0724
329: , p1_a1 DATE := fnd_api.g_miss_date
330: , p1_a2 NUMBER := 0-1962.0724
331: , p1_a3 DATE := fnd_api.g_miss_date
332: , p1_a4 NUMBER := 0-1962.0724
333: , p1_a5 NUMBER := 0-1962.0724
334: , p1_a6 NUMBER := 0-1962.0724
335: , p1_a7 NUMBER := 0-1962.0724

Line 336: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

332: , p1_a4 NUMBER := 0-1962.0724
333: , p1_a5 NUMBER := 0-1962.0724
334: , p1_a6 NUMBER := 0-1962.0724
335: , p1_a7 NUMBER := 0-1962.0724
336: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
337: , p1_a9 NUMBER := 0-1962.0724
338: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
339: , p1_a11 DATE := fnd_api.g_miss_date
340: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

Line 338: , p1_a10 VARCHAR2 := fnd_api.g_miss_char

334: , p1_a6 NUMBER := 0-1962.0724
335: , p1_a7 NUMBER := 0-1962.0724
336: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
337: , p1_a9 NUMBER := 0-1962.0724
338: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
339: , p1_a11 DATE := fnd_api.g_miss_date
340: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
341: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a14 DATE := fnd_api.g_miss_date

Line 339: , p1_a11 DATE := fnd_api.g_miss_date

335: , p1_a7 NUMBER := 0-1962.0724
336: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
337: , p1_a9 NUMBER := 0-1962.0724
338: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
339: , p1_a11 DATE := fnd_api.g_miss_date
340: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
341: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a14 DATE := fnd_api.g_miss_date
343: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

Line 340: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

336: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
337: , p1_a9 NUMBER := 0-1962.0724
338: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
339: , p1_a11 DATE := fnd_api.g_miss_date
340: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
341: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a14 DATE := fnd_api.g_miss_date
343: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
344: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 341: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

337: , p1_a9 NUMBER := 0-1962.0724
338: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
339: , p1_a11 DATE := fnd_api.g_miss_date
340: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
341: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a14 DATE := fnd_api.g_miss_date
343: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
344: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
345: )

Line 342: , p1_a14 DATE := fnd_api.g_miss_date

338: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
339: , p1_a11 DATE := fnd_api.g_miss_date
340: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
341: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a14 DATE := fnd_api.g_miss_date
343: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
344: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
345: )
346:

Line 343: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

339: , p1_a11 DATE := fnd_api.g_miss_date
340: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
341: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a14 DATE := fnd_api.g_miss_date
343: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
344: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
345: )
346:
347: as

Line 344: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

340: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
341: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
342: , p1_a14 DATE := fnd_api.g_miss_date
343: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
344: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
345: )
346:
347: as
348: ddp_access_rec ams_access_pvt.access_rec_type;

Line 468: , p0_a1 DATE := fnd_api.g_miss_date

464: , p1_a14 out nocopy DATE
465: , p1_a15 out nocopy VARCHAR2
466: , p1_a16 out nocopy VARCHAR2
467: , p0_a0 NUMBER := 0-1962.0724
468: , p0_a1 DATE := fnd_api.g_miss_date
469: , p0_a2 NUMBER := 0-1962.0724
470: , p0_a3 DATE := fnd_api.g_miss_date
471: , p0_a4 NUMBER := 0-1962.0724
472: , p0_a5 NUMBER := 0-1962.0724

Line 470: , p0_a3 DATE := fnd_api.g_miss_date

466: , p1_a16 out nocopy VARCHAR2
467: , p0_a0 NUMBER := 0-1962.0724
468: , p0_a1 DATE := fnd_api.g_miss_date
469: , p0_a2 NUMBER := 0-1962.0724
470: , p0_a3 DATE := fnd_api.g_miss_date
471: , p0_a4 NUMBER := 0-1962.0724
472: , p0_a5 NUMBER := 0-1962.0724
473: , p0_a6 NUMBER := 0-1962.0724
474: , p0_a7 NUMBER := 0-1962.0724

Line 475: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

471: , p0_a4 NUMBER := 0-1962.0724
472: , p0_a5 NUMBER := 0-1962.0724
473: , p0_a6 NUMBER := 0-1962.0724
474: , p0_a7 NUMBER := 0-1962.0724
475: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a9 NUMBER := 0-1962.0724
477: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a11 DATE := fnd_api.g_miss_date
479: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 477: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

473: , p0_a6 NUMBER := 0-1962.0724
474: , p0_a7 NUMBER := 0-1962.0724
475: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a9 NUMBER := 0-1962.0724
477: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a11 DATE := fnd_api.g_miss_date
479: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a14 DATE := fnd_api.g_miss_date

Line 478: , p0_a11 DATE := fnd_api.g_miss_date

474: , p0_a7 NUMBER := 0-1962.0724
475: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a9 NUMBER := 0-1962.0724
477: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a11 DATE := fnd_api.g_miss_date
479: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a14 DATE := fnd_api.g_miss_date
482: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 479: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

475: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a9 NUMBER := 0-1962.0724
477: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a11 DATE := fnd_api.g_miss_date
479: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a14 DATE := fnd_api.g_miss_date
482: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 480: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

476: , p0_a9 NUMBER := 0-1962.0724
477: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a11 DATE := fnd_api.g_miss_date
479: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a14 DATE := fnd_api.g_miss_date
482: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
484: )

Line 481: , p0_a14 DATE := fnd_api.g_miss_date

477: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a11 DATE := fnd_api.g_miss_date
479: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a14 DATE := fnd_api.g_miss_date
482: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
484: )
485:

Line 482: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

478: , p0_a11 DATE := fnd_api.g_miss_date
479: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a14 DATE := fnd_api.g_miss_date
482: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
484: )
485:
486: as

Line 483: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

479: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a14 DATE := fnd_api.g_miss_date
482: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
484: )
485:
486: as
487: ddp_access_rec ams_access_pvt.access_rec_type;