APPS.AMS_LISTACTION_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_listaction(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_action_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_action_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 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 NUMBER := 0-1962.0724

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 NUMBER := 0-1962.0724
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 NUMBER := 0-1962.0724

Line 46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 NUMBER := 0-1962.0724
44: , p7_a14 NUMBER := 0-1962.0724
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724

Line 47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

43: , p7_a13 NUMBER := 0-1962.0724
44: , p7_a14 NUMBER := 0-1962.0724
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

44: , p7_a14 NUMBER := 0-1962.0724
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: )

Line 51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: )
53: as
54: ddp_action_rec ams_listaction_pvt.action_rec_type;
55: ddindx binary_integer; indx binary_integer;

Line 120: , p7_a1 DATE := fnd_api.g_miss_date

116: , x_return_status OUT NOCOPY VARCHAR2
117: , x_msg_count OUT NOCOPY NUMBER
118: , x_msg_data OUT NOCOPY VARCHAR2
119: , p7_a0 NUMBER := 0-1962.0724
120: , p7_a1 DATE := fnd_api.g_miss_date
121: , p7_a2 NUMBER := 0-1962.0724
122: , p7_a3 DATE := fnd_api.g_miss_date
123: , p7_a4 NUMBER := 0-1962.0724
124: , p7_a5 NUMBER := 0-1962.0724

Line 122: , p7_a3 DATE := fnd_api.g_miss_date

118: , x_msg_data OUT NOCOPY VARCHAR2
119: , p7_a0 NUMBER := 0-1962.0724
120: , p7_a1 DATE := fnd_api.g_miss_date
121: , p7_a2 NUMBER := 0-1962.0724
122: , p7_a3 DATE := fnd_api.g_miss_date
123: , p7_a4 NUMBER := 0-1962.0724
124: , p7_a5 NUMBER := 0-1962.0724
125: , p7_a6 NUMBER := 0-1962.0724
126: , p7_a7 NUMBER := 0-1962.0724

Line 127: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

123: , p7_a4 NUMBER := 0-1962.0724
124: , p7_a5 NUMBER := 0-1962.0724
125: , p7_a6 NUMBER := 0-1962.0724
126: , p7_a7 NUMBER := 0-1962.0724
127: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a10 NUMBER := 0-1962.0724
130: , p7_a11 NUMBER := 0-1962.0724
131: , p7_a12 NUMBER := 0-1962.0724

Line 128: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

124: , p7_a5 NUMBER := 0-1962.0724
125: , p7_a6 NUMBER := 0-1962.0724
126: , p7_a7 NUMBER := 0-1962.0724
127: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a10 NUMBER := 0-1962.0724
130: , p7_a11 NUMBER := 0-1962.0724
131: , p7_a12 NUMBER := 0-1962.0724
132: , p7_a13 NUMBER := 0-1962.0724

Line 135: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

131: , p7_a12 NUMBER := 0-1962.0724
132: , p7_a13 NUMBER := 0-1962.0724
133: , p7_a14 NUMBER := 0-1962.0724
134: , p7_a15 NUMBER := 0-1962.0724
135: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a19 NUMBER := 0-1962.0724
139: , p7_a20 NUMBER := 0-1962.0724

Line 136: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

132: , p7_a13 NUMBER := 0-1962.0724
133: , p7_a14 NUMBER := 0-1962.0724
134: , p7_a15 NUMBER := 0-1962.0724
135: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a19 NUMBER := 0-1962.0724
139: , p7_a20 NUMBER := 0-1962.0724
140: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 137: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

133: , p7_a14 NUMBER := 0-1962.0724
134: , p7_a15 NUMBER := 0-1962.0724
135: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a19 NUMBER := 0-1962.0724
139: , p7_a20 NUMBER := 0-1962.0724
140: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
141: )

Line 140: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

136: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a19 NUMBER := 0-1962.0724
139: , p7_a20 NUMBER := 0-1962.0724
140: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
141: )
142: as
143: ddp_action_rec ams_listaction_pvt.action_rec_type;
144: ddindx binary_integer; indx binary_integer;

Line 205: , p6_a1 DATE := fnd_api.g_miss_date

201: , x_return_status OUT NOCOPY VARCHAR2
202: , x_msg_count OUT NOCOPY NUMBER
203: , x_msg_data OUT NOCOPY VARCHAR2
204: , p6_a0 NUMBER := 0-1962.0724
205: , p6_a1 DATE := fnd_api.g_miss_date
206: , p6_a2 NUMBER := 0-1962.0724
207: , p6_a3 DATE := fnd_api.g_miss_date
208: , p6_a4 NUMBER := 0-1962.0724
209: , p6_a5 NUMBER := 0-1962.0724

Line 207: , p6_a3 DATE := fnd_api.g_miss_date

203: , x_msg_data OUT NOCOPY VARCHAR2
204: , p6_a0 NUMBER := 0-1962.0724
205: , p6_a1 DATE := fnd_api.g_miss_date
206: , p6_a2 NUMBER := 0-1962.0724
207: , p6_a3 DATE := fnd_api.g_miss_date
208: , p6_a4 NUMBER := 0-1962.0724
209: , p6_a5 NUMBER := 0-1962.0724
210: , p6_a6 NUMBER := 0-1962.0724
211: , p6_a7 NUMBER := 0-1962.0724

Line 212: , p6_a8 VARCHAR2 := fnd_api.g_miss_char

208: , p6_a4 NUMBER := 0-1962.0724
209: , p6_a5 NUMBER := 0-1962.0724
210: , p6_a6 NUMBER := 0-1962.0724
211: , p6_a7 NUMBER := 0-1962.0724
212: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a10 NUMBER := 0-1962.0724
215: , p6_a11 NUMBER := 0-1962.0724
216: , p6_a12 NUMBER := 0-1962.0724

Line 213: , p6_a9 VARCHAR2 := fnd_api.g_miss_char

209: , p6_a5 NUMBER := 0-1962.0724
210: , p6_a6 NUMBER := 0-1962.0724
211: , p6_a7 NUMBER := 0-1962.0724
212: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a10 NUMBER := 0-1962.0724
215: , p6_a11 NUMBER := 0-1962.0724
216: , p6_a12 NUMBER := 0-1962.0724
217: , p6_a13 NUMBER := 0-1962.0724

Line 220: , p6_a16 VARCHAR2 := fnd_api.g_miss_char

216: , p6_a12 NUMBER := 0-1962.0724
217: , p6_a13 NUMBER := 0-1962.0724
218: , p6_a14 NUMBER := 0-1962.0724
219: , p6_a15 NUMBER := 0-1962.0724
220: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
221: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
222: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
223: , p6_a19 NUMBER := 0-1962.0724
224: , p6_a20 NUMBER := 0-1962.0724

Line 221: , p6_a17 VARCHAR2 := fnd_api.g_miss_char

217: , p6_a13 NUMBER := 0-1962.0724
218: , p6_a14 NUMBER := 0-1962.0724
219: , p6_a15 NUMBER := 0-1962.0724
220: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
221: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
222: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
223: , p6_a19 NUMBER := 0-1962.0724
224: , p6_a20 NUMBER := 0-1962.0724
225: , p6_a21 VARCHAR2 := fnd_api.g_miss_char

Line 222: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

218: , p6_a14 NUMBER := 0-1962.0724
219: , p6_a15 NUMBER := 0-1962.0724
220: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
221: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
222: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
223: , p6_a19 NUMBER := 0-1962.0724
224: , p6_a20 NUMBER := 0-1962.0724
225: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
226: )

Line 225: , p6_a21 VARCHAR2 := fnd_api.g_miss_char

221: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
222: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
223: , p6_a19 NUMBER := 0-1962.0724
224: , p6_a20 NUMBER := 0-1962.0724
225: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
226: )
227: as
228: ddp_action_rec ams_listaction_pvt.action_rec_type;
229: ddindx binary_integer; indx binary_integer;

Line 361: , p0_a1 DATE := fnd_api.g_miss_date

357: , p1_a19 OUT NOCOPY NUMBER
358: , p1_a20 OUT NOCOPY NUMBER
359: , p1_a21 OUT NOCOPY VARCHAR2
360: , p0_a0 NUMBER := 0-1962.0724
361: , p0_a1 DATE := fnd_api.g_miss_date
362: , p0_a2 NUMBER := 0-1962.0724
363: , p0_a3 DATE := fnd_api.g_miss_date
364: , p0_a4 NUMBER := 0-1962.0724
365: , p0_a5 NUMBER := 0-1962.0724

Line 363: , p0_a3 DATE := fnd_api.g_miss_date

359: , p1_a21 OUT NOCOPY VARCHAR2
360: , p0_a0 NUMBER := 0-1962.0724
361: , p0_a1 DATE := fnd_api.g_miss_date
362: , p0_a2 NUMBER := 0-1962.0724
363: , p0_a3 DATE := fnd_api.g_miss_date
364: , p0_a4 NUMBER := 0-1962.0724
365: , p0_a5 NUMBER := 0-1962.0724
366: , p0_a6 NUMBER := 0-1962.0724
367: , p0_a7 NUMBER := 0-1962.0724

Line 368: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

364: , p0_a4 NUMBER := 0-1962.0724
365: , p0_a5 NUMBER := 0-1962.0724
366: , p0_a6 NUMBER := 0-1962.0724
367: , p0_a7 NUMBER := 0-1962.0724
368: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
370: , p0_a10 NUMBER := 0-1962.0724
371: , p0_a11 NUMBER := 0-1962.0724
372: , p0_a12 NUMBER := 0-1962.0724

Line 369: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

365: , p0_a5 NUMBER := 0-1962.0724
366: , p0_a6 NUMBER := 0-1962.0724
367: , p0_a7 NUMBER := 0-1962.0724
368: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
370: , p0_a10 NUMBER := 0-1962.0724
371: , p0_a11 NUMBER := 0-1962.0724
372: , p0_a12 NUMBER := 0-1962.0724
373: , p0_a13 NUMBER := 0-1962.0724

Line 376: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

372: , p0_a12 NUMBER := 0-1962.0724
373: , p0_a13 NUMBER := 0-1962.0724
374: , p0_a14 NUMBER := 0-1962.0724
375: , p0_a15 NUMBER := 0-1962.0724
376: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
377: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p0_a19 NUMBER := 0-1962.0724
380: , p0_a20 NUMBER := 0-1962.0724

Line 377: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

373: , p0_a13 NUMBER := 0-1962.0724
374: , p0_a14 NUMBER := 0-1962.0724
375: , p0_a15 NUMBER := 0-1962.0724
376: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
377: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p0_a19 NUMBER := 0-1962.0724
380: , p0_a20 NUMBER := 0-1962.0724
381: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

Line 378: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

374: , p0_a14 NUMBER := 0-1962.0724
375: , p0_a15 NUMBER := 0-1962.0724
376: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
377: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p0_a19 NUMBER := 0-1962.0724
380: , p0_a20 NUMBER := 0-1962.0724
381: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
382: )

Line 381: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

377: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p0_a19 NUMBER := 0-1962.0724
380: , p0_a20 NUMBER := 0-1962.0724
381: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
382: )
383: as
384: ddp_action_rec ams_listaction_pvt.action_rec_type;
385: ddx_complete_rec ams_listaction_pvt.action_rec_type;