APPS.IEX_FILTER_PUB_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 69: , p1_a1 VARCHAR2 := fnd_api.g_miss_char

65: , x_return_status out nocopy VARCHAR2
66: , x_msg_count out nocopy NUMBER
67: , x_msg_data out nocopy VARCHAR2
68: , p1_a0 NUMBER := 0-1962.0724
69: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
70: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a3 NUMBER := 0-1962.0724
72: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a5 VARCHAR2 := fnd_api.g_miss_char

Line 70: , p1_a2 VARCHAR2 := fnd_api.g_miss_char

66: , x_msg_count out nocopy NUMBER
67: , x_msg_data out nocopy VARCHAR2
68: , p1_a0 NUMBER := 0-1962.0724
69: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
70: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a3 NUMBER := 0-1962.0724
72: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a6 VARCHAR2 := fnd_api.g_miss_char

Line 72: , p1_a4 VARCHAR2 := fnd_api.g_miss_char

68: , p1_a0 NUMBER := 0-1962.0724
69: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
70: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a3 NUMBER := 0-1962.0724
72: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
75: , p1_a7 NUMBER := 0-1962.0724
76: , p1_a8 NUMBER := 0-1962.0724

Line 73: , p1_a5 VARCHAR2 := fnd_api.g_miss_char

69: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
70: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a3 NUMBER := 0-1962.0724
72: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
75: , p1_a7 NUMBER := 0-1962.0724
76: , p1_a8 NUMBER := 0-1962.0724
77: , p1_a9 NUMBER := 0-1962.0724

Line 74: , p1_a6 VARCHAR2 := fnd_api.g_miss_char

70: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
71: , p1_a3 NUMBER := 0-1962.0724
72: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
73: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
74: , p1_a6 VARCHAR2 := fnd_api.g_miss_char
75: , p1_a7 NUMBER := 0-1962.0724
76: , p1_a8 NUMBER := 0-1962.0724
77: , p1_a9 NUMBER := 0-1962.0724
78: , p1_a10 NUMBER := 0-1962.0724

Line 79: , p1_a11 DATE := fnd_api.g_miss_date

75: , p1_a7 NUMBER := 0-1962.0724
76: , p1_a8 NUMBER := 0-1962.0724
77: , p1_a9 NUMBER := 0-1962.0724
78: , p1_a10 NUMBER := 0-1962.0724
79: , p1_a11 DATE := fnd_api.g_miss_date
80: , p1_a12 DATE := fnd_api.g_miss_date
81: , p1_a13 NUMBER := 0-1962.0724
82: , p1_a14 DATE := fnd_api.g_miss_date
83: , p1_a15 NUMBER := 0-1962.0724

Line 80: , p1_a12 DATE := fnd_api.g_miss_date

76: , p1_a8 NUMBER := 0-1962.0724
77: , p1_a9 NUMBER := 0-1962.0724
78: , p1_a10 NUMBER := 0-1962.0724
79: , p1_a11 DATE := fnd_api.g_miss_date
80: , p1_a12 DATE := fnd_api.g_miss_date
81: , p1_a13 NUMBER := 0-1962.0724
82: , p1_a14 DATE := fnd_api.g_miss_date
83: , p1_a15 NUMBER := 0-1962.0724
84: , p1_a16 NUMBER := 0-1962.0724

Line 82: , p1_a14 DATE := fnd_api.g_miss_date

78: , p1_a10 NUMBER := 0-1962.0724
79: , p1_a11 DATE := fnd_api.g_miss_date
80: , p1_a12 DATE := fnd_api.g_miss_date
81: , p1_a13 NUMBER := 0-1962.0724
82: , p1_a14 DATE := fnd_api.g_miss_date
83: , p1_a15 NUMBER := 0-1962.0724
84: , p1_a16 NUMBER := 0-1962.0724
85: )
86:

Line 141: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , x_filter_id out nocopy NUMBER
140: , p3_a0 NUMBER := 0-1962.0724
141: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
142: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a3 NUMBER := 0-1962.0724
144: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a5 VARCHAR2 := fnd_api.g_miss_char

Line 142: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

138: , x_msg_data out nocopy VARCHAR2
139: , x_filter_id out nocopy NUMBER
140: , p3_a0 NUMBER := 0-1962.0724
141: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
142: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a3 NUMBER := 0-1962.0724
144: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

Line 144: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

140: , p3_a0 NUMBER := 0-1962.0724
141: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
142: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a3 NUMBER := 0-1962.0724
144: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a7 NUMBER := 0-1962.0724
148: , p3_a8 NUMBER := 0-1962.0724

Line 145: , p3_a5 VARCHAR2 := fnd_api.g_miss_char

141: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
142: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a3 NUMBER := 0-1962.0724
144: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a7 NUMBER := 0-1962.0724
148: , p3_a8 NUMBER := 0-1962.0724
149: , p3_a9 NUMBER := 0-1962.0724

Line 146: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

142: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a3 NUMBER := 0-1962.0724
144: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
145: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
146: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
147: , p3_a7 NUMBER := 0-1962.0724
148: , p3_a8 NUMBER := 0-1962.0724
149: , p3_a9 NUMBER := 0-1962.0724
150: , p3_a10 NUMBER := 0-1962.0724

Line 151: , p3_a11 DATE := fnd_api.g_miss_date

147: , p3_a7 NUMBER := 0-1962.0724
148: , p3_a8 NUMBER := 0-1962.0724
149: , p3_a9 NUMBER := 0-1962.0724
150: , p3_a10 NUMBER := 0-1962.0724
151: , p3_a11 DATE := fnd_api.g_miss_date
152: , p3_a12 DATE := fnd_api.g_miss_date
153: , p3_a13 NUMBER := 0-1962.0724
154: , p3_a14 DATE := fnd_api.g_miss_date
155: , p3_a15 NUMBER := 0-1962.0724

Line 152: , p3_a12 DATE := fnd_api.g_miss_date

148: , p3_a8 NUMBER := 0-1962.0724
149: , p3_a9 NUMBER := 0-1962.0724
150: , p3_a10 NUMBER := 0-1962.0724
151: , p3_a11 DATE := fnd_api.g_miss_date
152: , p3_a12 DATE := fnd_api.g_miss_date
153: , p3_a13 NUMBER := 0-1962.0724
154: , p3_a14 DATE := fnd_api.g_miss_date
155: , p3_a15 NUMBER := 0-1962.0724
156: , p3_a16 NUMBER := 0-1962.0724

Line 154: , p3_a14 DATE := fnd_api.g_miss_date

150: , p3_a10 NUMBER := 0-1962.0724
151: , p3_a11 DATE := fnd_api.g_miss_date
152: , p3_a12 DATE := fnd_api.g_miss_date
153: , p3_a13 NUMBER := 0-1962.0724
154: , p3_a14 DATE := fnd_api.g_miss_date
155: , p3_a15 NUMBER := 0-1962.0724
156: , p3_a16 NUMBER := 0-1962.0724
157: )
158:

Line 221: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

217: , x_return_status out nocopy VARCHAR2
218: , x_msg_count out nocopy NUMBER
219: , x_msg_data out nocopy VARCHAR2
220: , p3_a0 NUMBER := 0-1962.0724
221: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
222: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p3_a3 NUMBER := 0-1962.0724
224: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
225: , p3_a5 VARCHAR2 := fnd_api.g_miss_char

Line 222: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

218: , x_msg_count out nocopy NUMBER
219: , x_msg_data out nocopy VARCHAR2
220: , p3_a0 NUMBER := 0-1962.0724
221: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
222: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p3_a3 NUMBER := 0-1962.0724
224: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
225: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

Line 224: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

220: , p3_a0 NUMBER := 0-1962.0724
221: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
222: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p3_a3 NUMBER := 0-1962.0724
224: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
225: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
227: , p3_a7 NUMBER := 0-1962.0724
228: , p3_a8 NUMBER := 0-1962.0724

Line 225: , p3_a5 VARCHAR2 := fnd_api.g_miss_char

221: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
222: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p3_a3 NUMBER := 0-1962.0724
224: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
225: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
227: , p3_a7 NUMBER := 0-1962.0724
228: , p3_a8 NUMBER := 0-1962.0724
229: , p3_a9 NUMBER := 0-1962.0724

Line 226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

222: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p3_a3 NUMBER := 0-1962.0724
224: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
225: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
227: , p3_a7 NUMBER := 0-1962.0724
228: , p3_a8 NUMBER := 0-1962.0724
229: , p3_a9 NUMBER := 0-1962.0724
230: , p3_a10 NUMBER := 0-1962.0724

Line 231: , p3_a11 DATE := fnd_api.g_miss_date

227: , p3_a7 NUMBER := 0-1962.0724
228: , p3_a8 NUMBER := 0-1962.0724
229: , p3_a9 NUMBER := 0-1962.0724
230: , p3_a10 NUMBER := 0-1962.0724
231: , p3_a11 DATE := fnd_api.g_miss_date
232: , p3_a12 DATE := fnd_api.g_miss_date
233: , p3_a13 NUMBER := 0-1962.0724
234: , p3_a14 DATE := fnd_api.g_miss_date
235: , p3_a15 NUMBER := 0-1962.0724

Line 232: , p3_a12 DATE := fnd_api.g_miss_date

228: , p3_a8 NUMBER := 0-1962.0724
229: , p3_a9 NUMBER := 0-1962.0724
230: , p3_a10 NUMBER := 0-1962.0724
231: , p3_a11 DATE := fnd_api.g_miss_date
232: , p3_a12 DATE := fnd_api.g_miss_date
233: , p3_a13 NUMBER := 0-1962.0724
234: , p3_a14 DATE := fnd_api.g_miss_date
235: , p3_a15 NUMBER := 0-1962.0724
236: , p3_a16 NUMBER := 0-1962.0724

Line 234: , p3_a14 DATE := fnd_api.g_miss_date

230: , p3_a10 NUMBER := 0-1962.0724
231: , p3_a11 DATE := fnd_api.g_miss_date
232: , p3_a12 DATE := fnd_api.g_miss_date
233: , p3_a13 NUMBER := 0-1962.0724
234: , p3_a14 DATE := fnd_api.g_miss_date
235: , p3_a15 NUMBER := 0-1962.0724
236: , p3_a16 NUMBER := 0-1962.0724
237: )
238: