APPS.AMS_LIST_QUERY_PUB_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;

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

14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure create_list_query(p_api_version_number NUMBER

Line 30: , p6_a1 DATE := fnd_api.g_miss_date

26: , x_msg_count OUT NOCOPY NUMBER
27: , x_msg_data OUT NOCOPY VARCHAR2
28: , x_list_query_id OUT NOCOPY NUMBER
29: , p6_a0 NUMBER := 0-1962.0724
30: , p6_a1 DATE := fnd_api.g_miss_date
31: , p6_a2 NUMBER := 0-1962.0724
32: , p6_a3 DATE := fnd_api.g_miss_date
33: , p6_a4 NUMBER := 0-1962.0724
34: , p6_a5 NUMBER := 0-1962.0724

Line 32: , p6_a3 DATE := fnd_api.g_miss_date

28: , x_list_query_id OUT NOCOPY NUMBER
29: , p6_a0 NUMBER := 0-1962.0724
30: , p6_a1 DATE := fnd_api.g_miss_date
31: , p6_a2 NUMBER := 0-1962.0724
32: , p6_a3 DATE := fnd_api.g_miss_date
33: , p6_a4 NUMBER := 0-1962.0724
34: , p6_a5 NUMBER := 0-1962.0724
35: , p6_a6 NUMBER := 0-1962.0724
36: , p6_a7 VARCHAR2 := fnd_api.g_miss_char

Line 36: , p6_a7 VARCHAR2 := fnd_api.g_miss_char

32: , p6_a3 DATE := fnd_api.g_miss_date
33: , p6_a4 NUMBER := 0-1962.0724
34: , p6_a5 NUMBER := 0-1962.0724
35: , p6_a6 NUMBER := 0-1962.0724
36: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p6_a11 VARCHAR2 := fnd_api.g_miss_char

Line 37: , p6_a8 VARCHAR2 := fnd_api.g_miss_char

33: , p6_a4 NUMBER := 0-1962.0724
34: , p6_a5 NUMBER := 0-1962.0724
35: , p6_a6 NUMBER := 0-1962.0724
36: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p6_a12 VARCHAR2 := fnd_api.g_miss_char

Line 38: , p6_a9 VARCHAR2 := fnd_api.g_miss_char

34: , p6_a5 NUMBER := 0-1962.0724
35: , p6_a6 NUMBER := 0-1962.0724
36: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p6_a13 VARCHAR2 := fnd_api.g_miss_char

Line 39: , p6_a10 VARCHAR2 := fnd_api.g_miss_char

35: , p6_a6 NUMBER := 0-1962.0724
36: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
43: , p6_a14 NUMBER := 0-1962.0724

Line 40: , p6_a11 VARCHAR2 := fnd_api.g_miss_char

36: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
43: , p6_a14 NUMBER := 0-1962.0724
44: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

Line 41: , p6_a12 VARCHAR2 := fnd_api.g_miss_char

37: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
43: , p6_a14 NUMBER := 0-1962.0724
44: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
45: , p6_a16 NUMBER := 0-1962.0724

Line 42: , p6_a13 VARCHAR2 := fnd_api.g_miss_char

38: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
39: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
40: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
43: , p6_a14 NUMBER := 0-1962.0724
44: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
45: , p6_a16 NUMBER := 0-1962.0724
46: , p6_a17 VARCHAR2 := fnd_api.g_miss_char

Line 44: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

40: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
41: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
42: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
43: , p6_a14 NUMBER := 0-1962.0724
44: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
45: , p6_a16 NUMBER := 0-1962.0724
46: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
47: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
48: , p6_a19 NUMBER := 0-1962.0724

Line 46: , p6_a17 VARCHAR2 := fnd_api.g_miss_char

42: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
43: , p6_a14 NUMBER := 0-1962.0724
44: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
45: , p6_a16 NUMBER := 0-1962.0724
46: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
47: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
48: , p6_a19 NUMBER := 0-1962.0724
49: , p6_a20 NUMBER := 0-1962.0724
50: )

Line 47: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

43: , p6_a14 NUMBER := 0-1962.0724
44: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
45: , p6_a16 NUMBER := 0-1962.0724
46: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
47: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
48: , p6_a19 NUMBER := 0-1962.0724
49: , p6_a20 NUMBER := 0-1962.0724
50: )
51: as

Line 116: , p7_a1 DATE := fnd_api.g_miss_date

112: , x_msg_data OUT NOCOPY VARCHAR2
113: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000
114: , x_parent_list_query_id OUT NOCOPY NUMBER
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_parent_list_query_id OUT NOCOPY NUMBER
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 NUMBER := 0-1962.0724

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 NUMBER := 0-1962.0724
130: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

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 NUMBER := 0-1962.0724
130: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a16 NUMBER := 0-1962.0724

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 NUMBER := 0-1962.0724
130: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a16 NUMBER := 0-1962.0724
132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 130: , p7_a15 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 NUMBER := 0-1962.0724
130: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a16 NUMBER := 0-1962.0724
132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a18 NUMBER := 0-1962.0724
134: , p7_a19 NUMBER := 0-1962.0724

Line 132: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

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

Line 206: , p6_a1 DATE := fnd_api.g_miss_date

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

Line 208: , p6_a3 DATE := fnd_api.g_miss_date

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

Line 212: , p6_a7 VARCHAR2 := fnd_api.g_miss_char

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

Line 213: , p6_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 214: , p6_a9 VARCHAR2 := fnd_api.g_miss_char

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

Line 215: , p6_a10 VARCHAR2 := fnd_api.g_miss_char

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

Line 216: , p6_a11 VARCHAR2 := fnd_api.g_miss_char

212: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
213: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a14 NUMBER := 0-1962.0724
220: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

Line 217: , p6_a12 VARCHAR2 := fnd_api.g_miss_char

213: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
214: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a14 NUMBER := 0-1962.0724
220: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
221: , p6_a16 NUMBER := 0-1962.0724

Line 218: , p6_a13 VARCHAR2 := fnd_api.g_miss_char

214: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
215: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
216: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
217: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
218: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a14 NUMBER := 0-1962.0724
220: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
221: , p6_a16 NUMBER := 0-1962.0724
222: , p6_a17 VARCHAR2 := fnd_api.g_miss_char

Line 220: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

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

Line 222: , p6_a17 VARCHAR2 := fnd_api.g_miss_char

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

Line 223: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

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

Line 292: , p7_a1 DATE := fnd_api.g_miss_date

288: , x_msg_data OUT NOCOPY VARCHAR2
289: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000
290: , x_object_version_number OUT NOCOPY NUMBER
291: , p7_a0 NUMBER := 0-1962.0724
292: , p7_a1 DATE := fnd_api.g_miss_date
293: , p7_a2 NUMBER := 0-1962.0724
294: , p7_a3 DATE := fnd_api.g_miss_date
295: , p7_a4 NUMBER := 0-1962.0724
296: , p7_a5 NUMBER := 0-1962.0724

Line 294: , p7_a3 DATE := fnd_api.g_miss_date

290: , x_object_version_number OUT NOCOPY NUMBER
291: , p7_a0 NUMBER := 0-1962.0724
292: , p7_a1 DATE := fnd_api.g_miss_date
293: , p7_a2 NUMBER := 0-1962.0724
294: , p7_a3 DATE := fnd_api.g_miss_date
295: , p7_a4 NUMBER := 0-1962.0724
296: , p7_a5 NUMBER := 0-1962.0724
297: , p7_a6 NUMBER := 0-1962.0724
298: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 298: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

294: , p7_a3 DATE := fnd_api.g_miss_date
295: , p7_a4 NUMBER := 0-1962.0724
296: , p7_a5 NUMBER := 0-1962.0724
297: , p7_a6 NUMBER := 0-1962.0724
298: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 299: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

295: , p7_a4 NUMBER := 0-1962.0724
296: , p7_a5 NUMBER := 0-1962.0724
297: , p7_a6 NUMBER := 0-1962.0724
298: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 300: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

296: , p7_a5 NUMBER := 0-1962.0724
297: , p7_a6 NUMBER := 0-1962.0724
298: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 301: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

297: , p7_a6 NUMBER := 0-1962.0724
298: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a14 NUMBER := 0-1962.0724

Line 302: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

298: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a14 NUMBER := 0-1962.0724
306: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 303: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

299: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a14 NUMBER := 0-1962.0724
306: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a16 NUMBER := 0-1962.0724

Line 304: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

300: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a14 NUMBER := 0-1962.0724
306: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a16 NUMBER := 0-1962.0724
308: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 306: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

302: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a14 NUMBER := 0-1962.0724
306: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a16 NUMBER := 0-1962.0724
308: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a18 NUMBER := 0-1962.0724
310: , p7_a19 NUMBER := 0-1962.0724

Line 308: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

304: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a14 NUMBER := 0-1962.0724
306: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a16 NUMBER := 0-1962.0724
308: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a18 NUMBER := 0-1962.0724
310: , p7_a19 NUMBER := 0-1962.0724
311: )
312: as