APPS.AMS_USER_STATUSES_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_user_status_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_user_status_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 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

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 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date

Line 39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date

Line 40: , p7_a10 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 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 42: , p7_a12 DATE := fnd_api.g_miss_date

38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: )

Line 43: , p7_a13 DATE := fnd_api.g_miss_date

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

Line 44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

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

Line 45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

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

Line 109: , p7_a1 DATE := fnd_api.g_miss_date

105: , x_return_status out nocopy VARCHAR2
106: , x_msg_count out nocopy NUMBER
107: , x_msg_data out nocopy VARCHAR2
108: , p7_a0 NUMBER := 0-1962.0724
109: , p7_a1 DATE := fnd_api.g_miss_date
110: , p7_a2 NUMBER := 0-1962.0724
111: , p7_a3 DATE := fnd_api.g_miss_date
112: , p7_a4 NUMBER := 0-1962.0724
113: , p7_a5 NUMBER := 0-1962.0724

Line 111: , p7_a3 DATE := fnd_api.g_miss_date

107: , x_msg_data out nocopy VARCHAR2
108: , p7_a0 NUMBER := 0-1962.0724
109: , p7_a1 DATE := fnd_api.g_miss_date
110: , p7_a2 NUMBER := 0-1962.0724
111: , p7_a3 DATE := fnd_api.g_miss_date
112: , p7_a4 NUMBER := 0-1962.0724
113: , p7_a5 NUMBER := 0-1962.0724
114: , p7_a6 NUMBER := 0-1962.0724
115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

111: , p7_a3 DATE := fnd_api.g_miss_date
112: , p7_a4 NUMBER := 0-1962.0724
113: , p7_a5 NUMBER := 0-1962.0724
114: , p7_a6 NUMBER := 0-1962.0724
115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

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

Line 118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

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

Line 119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

115: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 DATE := fnd_api.g_miss_date
121: , p7_a13 DATE := fnd_api.g_miss_date
122: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 120: , p7_a12 DATE := fnd_api.g_miss_date

116: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 DATE := fnd_api.g_miss_date
121: , p7_a13 DATE := fnd_api.g_miss_date
122: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
124: )

Line 121: , p7_a13 DATE := fnd_api.g_miss_date

117: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 DATE := fnd_api.g_miss_date
121: , p7_a13 DATE := fnd_api.g_miss_date
122: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
124: )
125:

Line 122: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

118: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 DATE := fnd_api.g_miss_date
121: , p7_a13 DATE := fnd_api.g_miss_date
122: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
124: )
125:
126: as

Line 123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

119: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a12 DATE := fnd_api.g_miss_date
121: , p7_a13 DATE := fnd_api.g_miss_date
122: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
124: )
125:
126: as
127: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

Line 184: , p7_a1 DATE := fnd_api.g_miss_date

180: , x_return_status out nocopy VARCHAR2
181: , x_msg_count out nocopy NUMBER
182: , x_msg_data out nocopy VARCHAR2
183: , p7_a0 NUMBER := 0-1962.0724
184: , p7_a1 DATE := fnd_api.g_miss_date
185: , p7_a2 NUMBER := 0-1962.0724
186: , p7_a3 DATE := fnd_api.g_miss_date
187: , p7_a4 NUMBER := 0-1962.0724
188: , p7_a5 NUMBER := 0-1962.0724

Line 186: , p7_a3 DATE := fnd_api.g_miss_date

182: , x_msg_data out nocopy VARCHAR2
183: , p7_a0 NUMBER := 0-1962.0724
184: , p7_a1 DATE := fnd_api.g_miss_date
185: , p7_a2 NUMBER := 0-1962.0724
186: , p7_a3 DATE := fnd_api.g_miss_date
187: , p7_a4 NUMBER := 0-1962.0724
188: , p7_a5 NUMBER := 0-1962.0724
189: , p7_a6 NUMBER := 0-1962.0724
190: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 190: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

186: , p7_a3 DATE := fnd_api.g_miss_date
187: , p7_a4 NUMBER := 0-1962.0724
188: , p7_a5 NUMBER := 0-1962.0724
189: , p7_a6 NUMBER := 0-1962.0724
190: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 191: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

187: , p7_a4 NUMBER := 0-1962.0724
188: , p7_a5 NUMBER := 0-1962.0724
189: , p7_a6 NUMBER := 0-1962.0724
190: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a12 DATE := fnd_api.g_miss_date

Line 192: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

188: , p7_a5 NUMBER := 0-1962.0724
189: , p7_a6 NUMBER := 0-1962.0724
190: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a12 DATE := fnd_api.g_miss_date
196: , p7_a13 DATE := fnd_api.g_miss_date

Line 193: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

189: , p7_a6 NUMBER := 0-1962.0724
190: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a12 DATE := fnd_api.g_miss_date
196: , p7_a13 DATE := fnd_api.g_miss_date
197: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

190: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a12 DATE := fnd_api.g_miss_date
196: , p7_a13 DATE := fnd_api.g_miss_date
197: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
198: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 195: , p7_a12 DATE := fnd_api.g_miss_date

191: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a12 DATE := fnd_api.g_miss_date
196: , p7_a13 DATE := fnd_api.g_miss_date
197: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
198: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
199: )

Line 196: , p7_a13 DATE := fnd_api.g_miss_date

192: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a12 DATE := fnd_api.g_miss_date
196: , p7_a13 DATE := fnd_api.g_miss_date
197: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
198: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
199: )
200:

Line 197: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

193: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a12 DATE := fnd_api.g_miss_date
196: , p7_a13 DATE := fnd_api.g_miss_date
197: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
198: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
199: )
200:
201: as

Line 198: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

194: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a12 DATE := fnd_api.g_miss_date
196: , p7_a13 DATE := fnd_api.g_miss_date
197: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
198: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
199: )
200:
201: as
202: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

Line 254: , p0_a1 DATE := fnd_api.g_miss_date

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

Line 256: , p0_a3 DATE := fnd_api.g_miss_date

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

Line 260: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

256: , p0_a3 DATE := fnd_api.g_miss_date
257: , p0_a4 NUMBER := 0-1962.0724
258: , p0_a5 NUMBER := 0-1962.0724
259: , p0_a6 NUMBER := 0-1962.0724
260: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
261: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
262: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
263: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
264: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 261: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 262: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

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

Line 263: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

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

Line 264: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

260: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
261: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
262: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
263: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
264: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
265: , p0_a12 DATE := fnd_api.g_miss_date
266: , p0_a13 DATE := fnd_api.g_miss_date
267: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 265: , p0_a12 DATE := fnd_api.g_miss_date

261: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
262: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
263: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
264: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
265: , p0_a12 DATE := fnd_api.g_miss_date
266: , p0_a13 DATE := fnd_api.g_miss_date
267: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
269: )

Line 266: , p0_a13 DATE := fnd_api.g_miss_date

262: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
263: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
264: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
265: , p0_a12 DATE := fnd_api.g_miss_date
266: , p0_a13 DATE := fnd_api.g_miss_date
267: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
269: )
270:

Line 267: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

263: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
264: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
265: , p0_a12 DATE := fnd_api.g_miss_date
266: , p0_a13 DATE := fnd_api.g_miss_date
267: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
269: )
270:
271: as

Line 268: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

264: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
265: , p0_a12 DATE := fnd_api.g_miss_date
266: , p0_a13 DATE := fnd_api.g_miss_date
267: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
268: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
269: )
270:
271: as
272: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

Line 308: , p0_a1 DATE := fnd_api.g_miss_date

304: end;
305:
306: procedure check_user_status_record(x_return_status out nocopy VARCHAR2
307: , p0_a0 NUMBER := 0-1962.0724
308: , p0_a1 DATE := fnd_api.g_miss_date
309: , p0_a2 NUMBER := 0-1962.0724
310: , p0_a3 DATE := fnd_api.g_miss_date
311: , p0_a4 NUMBER := 0-1962.0724
312: , p0_a5 NUMBER := 0-1962.0724

Line 310: , p0_a3 DATE := fnd_api.g_miss_date

306: procedure check_user_status_record(x_return_status out nocopy VARCHAR2
307: , p0_a0 NUMBER := 0-1962.0724
308: , p0_a1 DATE := fnd_api.g_miss_date
309: , p0_a2 NUMBER := 0-1962.0724
310: , p0_a3 DATE := fnd_api.g_miss_date
311: , p0_a4 NUMBER := 0-1962.0724
312: , p0_a5 NUMBER := 0-1962.0724
313: , p0_a6 NUMBER := 0-1962.0724
314: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 314: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

310: , p0_a3 DATE := fnd_api.g_miss_date
311: , p0_a4 NUMBER := 0-1962.0724
312: , p0_a5 NUMBER := 0-1962.0724
313: , p0_a6 NUMBER := 0-1962.0724
314: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
315: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
316: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
317: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 315: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

311: , p0_a4 NUMBER := 0-1962.0724
312: , p0_a5 NUMBER := 0-1962.0724
313: , p0_a6 NUMBER := 0-1962.0724
314: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
315: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
316: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
317: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
319: , p0_a12 DATE := fnd_api.g_miss_date

Line 316: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

312: , p0_a5 NUMBER := 0-1962.0724
313: , p0_a6 NUMBER := 0-1962.0724
314: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
315: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
316: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
317: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
319: , p0_a12 DATE := fnd_api.g_miss_date
320: , p0_a13 DATE := fnd_api.g_miss_date

Line 317: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

313: , p0_a6 NUMBER := 0-1962.0724
314: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
315: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
316: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
317: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
319: , p0_a12 DATE := fnd_api.g_miss_date
320: , p0_a13 DATE := fnd_api.g_miss_date
321: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

314: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
315: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
316: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
317: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
319: , p0_a12 DATE := fnd_api.g_miss_date
320: , p0_a13 DATE := fnd_api.g_miss_date
321: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 319: , p0_a12 DATE := fnd_api.g_miss_date

315: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
316: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
317: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
319: , p0_a12 DATE := fnd_api.g_miss_date
320: , p0_a13 DATE := fnd_api.g_miss_date
321: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
323: , p1_a0 NUMBER := 0-1962.0724

Line 320: , p0_a13 DATE := fnd_api.g_miss_date

316: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
317: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
319: , p0_a12 DATE := fnd_api.g_miss_date
320: , p0_a13 DATE := fnd_api.g_miss_date
321: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
323: , p1_a0 NUMBER := 0-1962.0724
324: , p1_a1 DATE := fnd_api.g_miss_date

Line 321: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

317: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
319: , p0_a12 DATE := fnd_api.g_miss_date
320: , p0_a13 DATE := fnd_api.g_miss_date
321: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
323: , p1_a0 NUMBER := 0-1962.0724
324: , p1_a1 DATE := fnd_api.g_miss_date
325: , p1_a2 NUMBER := 0-1962.0724

Line 322: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

318: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
319: , p0_a12 DATE := fnd_api.g_miss_date
320: , p0_a13 DATE := fnd_api.g_miss_date
321: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
323: , p1_a0 NUMBER := 0-1962.0724
324: , p1_a1 DATE := fnd_api.g_miss_date
325: , p1_a2 NUMBER := 0-1962.0724
326: , p1_a3 DATE := fnd_api.g_miss_date

Line 324: , p1_a1 DATE := fnd_api.g_miss_date

320: , p0_a13 DATE := fnd_api.g_miss_date
321: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
323: , p1_a0 NUMBER := 0-1962.0724
324: , p1_a1 DATE := fnd_api.g_miss_date
325: , p1_a2 NUMBER := 0-1962.0724
326: , p1_a3 DATE := fnd_api.g_miss_date
327: , p1_a4 NUMBER := 0-1962.0724
328: , p1_a5 NUMBER := 0-1962.0724

Line 326: , p1_a3 DATE := fnd_api.g_miss_date

322: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
323: , p1_a0 NUMBER := 0-1962.0724
324: , p1_a1 DATE := fnd_api.g_miss_date
325: , p1_a2 NUMBER := 0-1962.0724
326: , p1_a3 DATE := fnd_api.g_miss_date
327: , p1_a4 NUMBER := 0-1962.0724
328: , p1_a5 NUMBER := 0-1962.0724
329: , p1_a6 NUMBER := 0-1962.0724
330: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

Line 330: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

326: , p1_a3 DATE := fnd_api.g_miss_date
327: , p1_a4 NUMBER := 0-1962.0724
328: , p1_a5 NUMBER := 0-1962.0724
329: , p1_a6 NUMBER := 0-1962.0724
330: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
331: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
332: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
333: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

Line 331: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

327: , p1_a4 NUMBER := 0-1962.0724
328: , p1_a5 NUMBER := 0-1962.0724
329: , p1_a6 NUMBER := 0-1962.0724
330: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
331: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
332: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
333: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
335: , p1_a12 DATE := fnd_api.g_miss_date

Line 332: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

328: , p1_a5 NUMBER := 0-1962.0724
329: , p1_a6 NUMBER := 0-1962.0724
330: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
331: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
332: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
333: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
335: , p1_a12 DATE := fnd_api.g_miss_date
336: , p1_a13 DATE := fnd_api.g_miss_date

Line 333: , p1_a10 VARCHAR2 := fnd_api.g_miss_char

329: , p1_a6 NUMBER := 0-1962.0724
330: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
331: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
332: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
333: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
335: , p1_a12 DATE := fnd_api.g_miss_date
336: , p1_a13 DATE := fnd_api.g_miss_date
337: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

330: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
331: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
332: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
333: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
335: , p1_a12 DATE := fnd_api.g_miss_date
336: , p1_a13 DATE := fnd_api.g_miss_date
337: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
338: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

Line 335: , p1_a12 DATE := fnd_api.g_miss_date

331: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
332: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
333: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
335: , p1_a12 DATE := fnd_api.g_miss_date
336: , p1_a13 DATE := fnd_api.g_miss_date
337: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
338: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
339: )

Line 336: , p1_a13 DATE := fnd_api.g_miss_date

332: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
333: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
335: , p1_a12 DATE := fnd_api.g_miss_date
336: , p1_a13 DATE := fnd_api.g_miss_date
337: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
338: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
339: )
340:

Line 337: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

333: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
335: , p1_a12 DATE := fnd_api.g_miss_date
336: , p1_a13 DATE := fnd_api.g_miss_date
337: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
338: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
339: )
340:
341: as

Line 338: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

334: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
335: , p1_a12 DATE := fnd_api.g_miss_date
336: , p1_a13 DATE := fnd_api.g_miss_date
337: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
338: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
339: )
340:
341: as
342: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

Line 457: , p0_a1 DATE := fnd_api.g_miss_date

453: , p1_a13 out nocopy DATE
454: , p1_a14 out nocopy VARCHAR2
455: , p1_a15 out nocopy VARCHAR2
456: , p0_a0 NUMBER := 0-1962.0724
457: , p0_a1 DATE := fnd_api.g_miss_date
458: , p0_a2 NUMBER := 0-1962.0724
459: , p0_a3 DATE := fnd_api.g_miss_date
460: , p0_a4 NUMBER := 0-1962.0724
461: , p0_a5 NUMBER := 0-1962.0724

Line 459: , p0_a3 DATE := fnd_api.g_miss_date

455: , p1_a15 out nocopy VARCHAR2
456: , p0_a0 NUMBER := 0-1962.0724
457: , p0_a1 DATE := fnd_api.g_miss_date
458: , p0_a2 NUMBER := 0-1962.0724
459: , p0_a3 DATE := fnd_api.g_miss_date
460: , p0_a4 NUMBER := 0-1962.0724
461: , p0_a5 NUMBER := 0-1962.0724
462: , p0_a6 NUMBER := 0-1962.0724
463: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 463: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

459: , p0_a3 DATE := fnd_api.g_miss_date
460: , p0_a4 NUMBER := 0-1962.0724
461: , p0_a5 NUMBER := 0-1962.0724
462: , p0_a6 NUMBER := 0-1962.0724
463: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
464: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
465: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
466: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 464: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

460: , p0_a4 NUMBER := 0-1962.0724
461: , p0_a5 NUMBER := 0-1962.0724
462: , p0_a6 NUMBER := 0-1962.0724
463: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
464: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
465: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
466: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
468: , p0_a12 DATE := fnd_api.g_miss_date

Line 465: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

461: , p0_a5 NUMBER := 0-1962.0724
462: , p0_a6 NUMBER := 0-1962.0724
463: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
464: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
465: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
466: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
468: , p0_a12 DATE := fnd_api.g_miss_date
469: , p0_a13 DATE := fnd_api.g_miss_date

Line 466: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

462: , p0_a6 NUMBER := 0-1962.0724
463: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
464: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
465: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
466: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
468: , p0_a12 DATE := fnd_api.g_miss_date
469: , p0_a13 DATE := fnd_api.g_miss_date
470: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

463: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
464: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
465: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
466: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
468: , p0_a12 DATE := fnd_api.g_miss_date
469: , p0_a13 DATE := fnd_api.g_miss_date
470: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 468: , p0_a12 DATE := fnd_api.g_miss_date

464: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
465: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
466: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
468: , p0_a12 DATE := fnd_api.g_miss_date
469: , p0_a13 DATE := fnd_api.g_miss_date
470: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
472: )

Line 469: , p0_a13 DATE := fnd_api.g_miss_date

465: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
466: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
468: , p0_a12 DATE := fnd_api.g_miss_date
469: , p0_a13 DATE := fnd_api.g_miss_date
470: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
472: )
473:

Line 470: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

466: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
468: , p0_a12 DATE := fnd_api.g_miss_date
469: , p0_a13 DATE := fnd_api.g_miss_date
470: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
472: )
473:
474: as

Line 471: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

467: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
468: , p0_a12 DATE := fnd_api.g_miss_date
469: , p0_a13 DATE := fnd_api.g_miss_date
470: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
472: )
473:
474: as
475: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;