APPS.AMS_LISTSOURCETYPE_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_listsourcetype(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_source_type_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_source_type_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 VARCHAR2 := fnd_api.g_miss_char

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

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

Line 43: , p7_a13 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 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
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

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 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
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

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 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
50: )

Line 47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
50: )
51: as

Line 48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
50: )
51: as
52: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;

Line 49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

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 VARCHAR2 := fnd_api.g_miss_char
50: )
51: as
52: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;
53: ddindx binary_integer; indx binary_integer;

Line 116: , p7_a1 DATE := fnd_api.g_miss_date

112: , x_return_status OUT NOCOPY VARCHAR2
113: , x_msg_count OUT NOCOPY NUMBER
114: , x_msg_data OUT NOCOPY VARCHAR2
115: , p7_a0 NUMBER := 0-1962.0724
116: , p7_a1 DATE := fnd_api.g_miss_date
117: , p7_a2 NUMBER := 0-1962.0724
118: , p7_a3 DATE := fnd_api.g_miss_date
119: , p7_a4 NUMBER := 0-1962.0724
120: , p7_a5 NUMBER := 0-1962.0724

Line 118: , p7_a3 DATE := fnd_api.g_miss_date

114: , x_msg_data OUT NOCOPY VARCHAR2
115: , p7_a0 NUMBER := 0-1962.0724
116: , p7_a1 DATE := fnd_api.g_miss_date
117: , p7_a2 NUMBER := 0-1962.0724
118: , p7_a3 DATE := fnd_api.g_miss_date
119: , p7_a4 NUMBER := 0-1962.0724
120: , p7_a5 NUMBER := 0-1962.0724
121: , p7_a6 NUMBER := 0-1962.0724
122: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 122: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

118: , p7_a3 DATE := fnd_api.g_miss_date
119: , p7_a4 NUMBER := 0-1962.0724
120: , p7_a5 NUMBER := 0-1962.0724
121: , p7_a6 NUMBER := 0-1962.0724
122: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 123: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

119: , p7_a4 NUMBER := 0-1962.0724
120: , p7_a5 NUMBER := 0-1962.0724
121: , p7_a6 NUMBER := 0-1962.0724
122: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 124: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

120: , p7_a5 NUMBER := 0-1962.0724
121: , p7_a6 NUMBER := 0-1962.0724
122: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 125: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

121: , p7_a6 NUMBER := 0-1962.0724
122: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 126: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

122: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a15 NUMBER := 0-1962.0724

Line 127: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

123: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a15 NUMBER := 0-1962.0724
131: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 128: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

124: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a15 NUMBER := 0-1962.0724
131: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 129: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

125: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a15 NUMBER := 0-1962.0724
131: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 131: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

127: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a15 NUMBER := 0-1962.0724
131: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
135: )

Line 132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

128: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a15 NUMBER := 0-1962.0724
131: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
135: )
136: as

Line 133: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

129: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a15 NUMBER := 0-1962.0724
131: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
135: )
136: as
137: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;

Line 134: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

130: , p7_a15 NUMBER := 0-1962.0724
131: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
135: )
136: as
137: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;
138: ddindx binary_integer; indx binary_integer;

Line 198: , p7_a1 DATE := fnd_api.g_miss_date

194: , x_return_status OUT NOCOPY VARCHAR2
195: , x_msg_count OUT NOCOPY NUMBER
196: , x_msg_data OUT NOCOPY VARCHAR2
197: , p7_a0 NUMBER := 0-1962.0724
198: , p7_a1 DATE := fnd_api.g_miss_date
199: , p7_a2 NUMBER := 0-1962.0724
200: , p7_a3 DATE := fnd_api.g_miss_date
201: , p7_a4 NUMBER := 0-1962.0724
202: , p7_a5 NUMBER := 0-1962.0724

Line 200: , p7_a3 DATE := fnd_api.g_miss_date

196: , x_msg_data OUT NOCOPY VARCHAR2
197: , p7_a0 NUMBER := 0-1962.0724
198: , p7_a1 DATE := fnd_api.g_miss_date
199: , p7_a2 NUMBER := 0-1962.0724
200: , p7_a3 DATE := fnd_api.g_miss_date
201: , p7_a4 NUMBER := 0-1962.0724
202: , p7_a5 NUMBER := 0-1962.0724
203: , p7_a6 NUMBER := 0-1962.0724
204: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 204: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

200: , p7_a3 DATE := fnd_api.g_miss_date
201: , p7_a4 NUMBER := 0-1962.0724
202: , p7_a5 NUMBER := 0-1962.0724
203: , p7_a6 NUMBER := 0-1962.0724
204: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
205: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
206: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
207: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 205: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

201: , p7_a4 NUMBER := 0-1962.0724
202: , p7_a5 NUMBER := 0-1962.0724
203: , p7_a6 NUMBER := 0-1962.0724
204: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
205: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
206: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
207: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 206: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

202: , p7_a5 NUMBER := 0-1962.0724
203: , p7_a6 NUMBER := 0-1962.0724
204: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
205: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
206: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
207: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 207: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

203: , p7_a6 NUMBER := 0-1962.0724
204: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
205: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
206: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
207: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 208: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

204: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
205: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
206: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
207: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a15 NUMBER := 0-1962.0724

Line 209: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

205: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
206: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
207: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a15 NUMBER := 0-1962.0724
213: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 210: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

206: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
207: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a15 NUMBER := 0-1962.0724
213: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 211: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

207: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
208: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a15 NUMBER := 0-1962.0724
213: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 213: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

209: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a15 NUMBER := 0-1962.0724
213: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
217: )

Line 214: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

210: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a15 NUMBER := 0-1962.0724
213: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
217: )
218: as

Line 215: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

211: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a15 NUMBER := 0-1962.0724
213: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
217: )
218: as
219: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;

Line 216: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

212: , p7_a15 NUMBER := 0-1962.0724
213: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
217: )
218: as
219: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;
220: ddindx binary_integer; indx binary_integer;

Line 275: , p0_a1 DATE := fnd_api.g_miss_date

271:
272: procedure check_listsourcetype_items(p_validation_mode VARCHAR2
273: , x_return_status OUT NOCOPY VARCHAR2
274: , p0_a0 NUMBER := 0-1962.0724
275: , p0_a1 DATE := fnd_api.g_miss_date
276: , p0_a2 NUMBER := 0-1962.0724
277: , p0_a3 DATE := fnd_api.g_miss_date
278: , p0_a4 NUMBER := 0-1962.0724
279: , p0_a5 NUMBER := 0-1962.0724

Line 277: , p0_a3 DATE := fnd_api.g_miss_date

273: , x_return_status OUT NOCOPY VARCHAR2
274: , p0_a0 NUMBER := 0-1962.0724
275: , p0_a1 DATE := fnd_api.g_miss_date
276: , p0_a2 NUMBER := 0-1962.0724
277: , p0_a3 DATE := fnd_api.g_miss_date
278: , p0_a4 NUMBER := 0-1962.0724
279: , p0_a5 NUMBER := 0-1962.0724
280: , p0_a6 NUMBER := 0-1962.0724
281: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 281: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

277: , p0_a3 DATE := fnd_api.g_miss_date
278: , p0_a4 NUMBER := 0-1962.0724
279: , p0_a5 NUMBER := 0-1962.0724
280: , p0_a6 NUMBER := 0-1962.0724
281: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
282: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
283: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 282: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

278: , p0_a4 NUMBER := 0-1962.0724
279: , p0_a5 NUMBER := 0-1962.0724
280: , p0_a6 NUMBER := 0-1962.0724
281: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
282: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
283: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 283: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

279: , p0_a5 NUMBER := 0-1962.0724
280: , p0_a6 NUMBER := 0-1962.0724
281: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
282: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
283: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 284: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

280: , p0_a6 NUMBER := 0-1962.0724
281: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
282: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
283: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 285: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

281: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
282: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
283: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a15 NUMBER := 0-1962.0724

Line 286: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

282: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
283: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a15 NUMBER := 0-1962.0724
290: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 287: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

283: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a15 NUMBER := 0-1962.0724
290: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 288: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

284: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a15 NUMBER := 0-1962.0724
290: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 290: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

286: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a15 NUMBER := 0-1962.0724
290: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
294: )

Line 291: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

287: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a15 NUMBER := 0-1962.0724
290: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
294: )
295: as

Line 292: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

288: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a15 NUMBER := 0-1962.0724
290: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
294: )
295: as
296: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;

Line 293: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

289: , p0_a15 NUMBER := 0-1962.0724
290: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
294: )
295: as
296: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;
297: ddindx binary_integer; indx binary_integer;

Line 336: , p0_a1 DATE := fnd_api.g_miss_date

332: end;
333:
334: procedure check_listsourcetype_record(x_return_status OUT NOCOPY VARCHAR2
335: , p0_a0 NUMBER := 0-1962.0724
336: , p0_a1 DATE := fnd_api.g_miss_date
337: , p0_a2 NUMBER := 0-1962.0724
338: , p0_a3 DATE := fnd_api.g_miss_date
339: , p0_a4 NUMBER := 0-1962.0724
340: , p0_a5 NUMBER := 0-1962.0724

Line 338: , p0_a3 DATE := fnd_api.g_miss_date

334: procedure check_listsourcetype_record(x_return_status OUT NOCOPY VARCHAR2
335: , p0_a0 NUMBER := 0-1962.0724
336: , p0_a1 DATE := fnd_api.g_miss_date
337: , p0_a2 NUMBER := 0-1962.0724
338: , p0_a3 DATE := fnd_api.g_miss_date
339: , p0_a4 NUMBER := 0-1962.0724
340: , p0_a5 NUMBER := 0-1962.0724
341: , p0_a6 NUMBER := 0-1962.0724
342: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 342: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

338: , p0_a3 DATE := fnd_api.g_miss_date
339: , p0_a4 NUMBER := 0-1962.0724
340: , p0_a5 NUMBER := 0-1962.0724
341: , p0_a6 NUMBER := 0-1962.0724
342: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 343: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

339: , p0_a4 NUMBER := 0-1962.0724
340: , p0_a5 NUMBER := 0-1962.0724
341: , p0_a6 NUMBER := 0-1962.0724
342: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 344: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

340: , p0_a5 NUMBER := 0-1962.0724
341: , p0_a6 NUMBER := 0-1962.0724
342: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 345: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

341: , p0_a6 NUMBER := 0-1962.0724
342: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 346: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

342: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a15 NUMBER := 0-1962.0724

Line 347: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

343: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a15 NUMBER := 0-1962.0724
351: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 348: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

344: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a15 NUMBER := 0-1962.0724
351: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 349: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

345: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a15 NUMBER := 0-1962.0724
351: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 351: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

347: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a15 NUMBER := 0-1962.0724
351: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a0 NUMBER := 0-1962.0724

Line 352: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

348: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a15 NUMBER := 0-1962.0724
351: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a0 NUMBER := 0-1962.0724
356: , p1_a1 DATE := fnd_api.g_miss_date

Line 353: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

349: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a15 NUMBER := 0-1962.0724
351: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a0 NUMBER := 0-1962.0724
356: , p1_a1 DATE := fnd_api.g_miss_date
357: , p1_a2 NUMBER := 0-1962.0724

Line 354: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

350: , p0_a15 NUMBER := 0-1962.0724
351: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a0 NUMBER := 0-1962.0724
356: , p1_a1 DATE := fnd_api.g_miss_date
357: , p1_a2 NUMBER := 0-1962.0724
358: , p1_a3 DATE := fnd_api.g_miss_date

Line 356: , p1_a1 DATE := fnd_api.g_miss_date

352: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a0 NUMBER := 0-1962.0724
356: , p1_a1 DATE := fnd_api.g_miss_date
357: , p1_a2 NUMBER := 0-1962.0724
358: , p1_a3 DATE := fnd_api.g_miss_date
359: , p1_a4 NUMBER := 0-1962.0724
360: , p1_a5 NUMBER := 0-1962.0724

Line 358: , p1_a3 DATE := fnd_api.g_miss_date

354: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a0 NUMBER := 0-1962.0724
356: , p1_a1 DATE := fnd_api.g_miss_date
357: , p1_a2 NUMBER := 0-1962.0724
358: , p1_a3 DATE := fnd_api.g_miss_date
359: , p1_a4 NUMBER := 0-1962.0724
360: , p1_a5 NUMBER := 0-1962.0724
361: , p1_a6 NUMBER := 0-1962.0724
362: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

Line 362: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

358: , p1_a3 DATE := fnd_api.g_miss_date
359: , p1_a4 NUMBER := 0-1962.0724
360: , p1_a5 NUMBER := 0-1962.0724
361: , p1_a6 NUMBER := 0-1962.0724
362: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

Line 363: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

359: , p1_a4 NUMBER := 0-1962.0724
360: , p1_a5 NUMBER := 0-1962.0724
361: , p1_a6 NUMBER := 0-1962.0724
362: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

Line 364: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

360: , p1_a5 NUMBER := 0-1962.0724
361: , p1_a6 NUMBER := 0-1962.0724
362: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

Line 365: , p1_a10 VARCHAR2 := fnd_api.g_miss_char

361: , p1_a6 NUMBER := 0-1962.0724
362: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 366: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

362: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
363: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p1_a15 NUMBER := 0-1962.0724

Line 367: , p1_a12 VARCHAR2 := fnd_api.g_miss_char

363: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
364: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p1_a15 NUMBER := 0-1962.0724
371: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 368: , p1_a13 VARCHAR2 := fnd_api.g_miss_char

364: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
365: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p1_a15 NUMBER := 0-1962.0724
371: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p1_a17 VARCHAR2 := fnd_api.g_miss_char

Line 369: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

365: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
366: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
367: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p1_a15 NUMBER := 0-1962.0724
371: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 371: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

367: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
368: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p1_a15 NUMBER := 0-1962.0724
371: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
375: )

Line 372: , p1_a17 VARCHAR2 := fnd_api.g_miss_char

368: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
369: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p1_a15 NUMBER := 0-1962.0724
371: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
375: )
376: as

Line 373: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

369: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
370: , p1_a15 NUMBER := 0-1962.0724
371: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
375: )
376: as
377: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;

Line 374: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

370: , p1_a15 NUMBER := 0-1962.0724
371: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
372: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
373: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
374: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
375: )
376: as
377: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;
378: ddp_complete_rec ams_listsourcetype_pvt.listsourcetype_rec_type;

Line 511: , p0_a1 DATE := fnd_api.g_miss_date

507: , p1_a17 OUT NOCOPY VARCHAR2
508: , p1_a18 OUT NOCOPY VARCHAR2
509: , p1_a19 OUT NOCOPY VARCHAR2
510: , p0_a0 NUMBER := 0-1962.0724
511: , p0_a1 DATE := fnd_api.g_miss_date
512: , p0_a2 NUMBER := 0-1962.0724
513: , p0_a3 DATE := fnd_api.g_miss_date
514: , p0_a4 NUMBER := 0-1962.0724
515: , p0_a5 NUMBER := 0-1962.0724

Line 513: , p0_a3 DATE := fnd_api.g_miss_date

509: , p1_a19 OUT NOCOPY VARCHAR2
510: , p0_a0 NUMBER := 0-1962.0724
511: , p0_a1 DATE := fnd_api.g_miss_date
512: , p0_a2 NUMBER := 0-1962.0724
513: , p0_a3 DATE := fnd_api.g_miss_date
514: , p0_a4 NUMBER := 0-1962.0724
515: , p0_a5 NUMBER := 0-1962.0724
516: , p0_a6 NUMBER := 0-1962.0724
517: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 517: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

513: , p0_a3 DATE := fnd_api.g_miss_date
514: , p0_a4 NUMBER := 0-1962.0724
515: , p0_a5 NUMBER := 0-1962.0724
516: , p0_a6 NUMBER := 0-1962.0724
517: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
518: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
519: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
520: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
521: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 518: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

514: , p0_a4 NUMBER := 0-1962.0724
515: , p0_a5 NUMBER := 0-1962.0724
516: , p0_a6 NUMBER := 0-1962.0724
517: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
518: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
519: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
520: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
521: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
522: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 519: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

515: , p0_a5 NUMBER := 0-1962.0724
516: , p0_a6 NUMBER := 0-1962.0724
517: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
518: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
519: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
520: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
521: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
522: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
523: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 520: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

516: , p0_a6 NUMBER := 0-1962.0724
517: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
518: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
519: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
520: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
521: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
522: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
523: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
524: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 521: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

517: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
518: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
519: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
520: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
521: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
522: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
523: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
524: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
525: , p0_a15 NUMBER := 0-1962.0724

Line 522: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

518: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
519: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
520: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
521: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
522: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
523: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
524: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
525: , p0_a15 NUMBER := 0-1962.0724
526: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 523: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

519: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
520: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
521: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
522: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
523: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
524: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
525: , p0_a15 NUMBER := 0-1962.0724
526: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
527: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 524: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

520: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
521: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
522: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
523: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
524: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
525: , p0_a15 NUMBER := 0-1962.0724
526: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
527: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 526: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

522: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
523: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
524: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
525: , p0_a15 NUMBER := 0-1962.0724
526: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
527: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
530: )

Line 527: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

523: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
524: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
525: , p0_a15 NUMBER := 0-1962.0724
526: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
527: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
530: )
531: as

Line 528: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

524: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
525: , p0_a15 NUMBER := 0-1962.0724
526: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
527: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
530: )
531: as
532: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;

Line 529: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

525: , p0_a15 NUMBER := 0-1962.0724
526: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
527: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
530: )
531: as
532: ddp_listsrctype_rec ams_listsourcetype_pvt.listsourcetype_rec_type;
533: ddx_complete_rec ams_listsourcetype_pvt.listsourcetype_rec_type;