eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPPQYVALUES_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 39: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

35: , p3_a11 out nocopy NUMBER
36: , p0_a0 NUMBER := 0-1962.0724
37: , p0_a1 NUMBER := 0-1962.0724
38: , p0_a2 NUMBER := 0-1962.0724
39: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724

Line 40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

36: , p0_a0 NUMBER := 0-1962.0724
37: , p0_a1 NUMBER := 0-1962.0724
38: , p0_a2 NUMBER := 0-1962.0724
39: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date

Line 41: , p0_a5 DATE := fnd_api.g_miss_date

37: , p0_a1 NUMBER := 0-1962.0724
38: , p0_a2 NUMBER := 0-1962.0724
39: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date
45: , p0_a9 NUMBER := 0-1962.0724

Line 42: , p0_a6 DATE := fnd_api.g_miss_date

38: , p0_a2 NUMBER := 0-1962.0724
39: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date
45: , p0_a9 NUMBER := 0-1962.0724
46: , p0_a10 DATE := fnd_api.g_miss_date

Line 44: , p0_a8 DATE := fnd_api.g_miss_date

40: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
41: , p0_a5 DATE := fnd_api.g_miss_date
42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date
45: , p0_a9 NUMBER := 0-1962.0724
46: , p0_a10 DATE := fnd_api.g_miss_date
47: , p0_a11 NUMBER := 0-1962.0724
48: )

Line 46: , p0_a10 DATE := fnd_api.g_miss_date

42: , p0_a6 DATE := fnd_api.g_miss_date
43: , p0_a7 NUMBER := 0-1962.0724
44: , p0_a8 DATE := fnd_api.g_miss_date
45: , p0_a9 NUMBER := 0-1962.0724
46: , p0_a10 DATE := fnd_api.g_miss_date
47: , p0_a11 NUMBER := 0-1962.0724
48: )
49:
50: as

Line 123: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

119: , p7_a10 out nocopy DATE
120: , p7_a11 out nocopy NUMBER
121: , p5_a0 NUMBER := 0-1962.0724
122: , p5_a1 NUMBER := 0-1962.0724
123: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a5 DATE := fnd_api.g_miss_date
127: , p5_a6 DATE := fnd_api.g_miss_date

Line 124: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

120: , p7_a11 out nocopy NUMBER
121: , p5_a0 NUMBER := 0-1962.0724
122: , p5_a1 NUMBER := 0-1962.0724
123: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a5 DATE := fnd_api.g_miss_date
127: , p5_a6 DATE := fnd_api.g_miss_date
128: , p5_a7 NUMBER := 0-1962.0724

Line 125: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

121: , p5_a0 NUMBER := 0-1962.0724
122: , p5_a1 NUMBER := 0-1962.0724
123: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a5 DATE := fnd_api.g_miss_date
127: , p5_a6 DATE := fnd_api.g_miss_date
128: , p5_a7 NUMBER := 0-1962.0724
129: , p5_a8 DATE := fnd_api.g_miss_date

Line 126: , p5_a5 DATE := fnd_api.g_miss_date

122: , p5_a1 NUMBER := 0-1962.0724
123: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a5 DATE := fnd_api.g_miss_date
127: , p5_a6 DATE := fnd_api.g_miss_date
128: , p5_a7 NUMBER := 0-1962.0724
129: , p5_a8 DATE := fnd_api.g_miss_date
130: , p5_a9 NUMBER := 0-1962.0724

Line 127: , p5_a6 DATE := fnd_api.g_miss_date

123: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a5 DATE := fnd_api.g_miss_date
127: , p5_a6 DATE := fnd_api.g_miss_date
128: , p5_a7 NUMBER := 0-1962.0724
129: , p5_a8 DATE := fnd_api.g_miss_date
130: , p5_a9 NUMBER := 0-1962.0724
131: , p5_a10 DATE := fnd_api.g_miss_date

Line 129: , p5_a8 DATE := fnd_api.g_miss_date

125: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a5 DATE := fnd_api.g_miss_date
127: , p5_a6 DATE := fnd_api.g_miss_date
128: , p5_a7 NUMBER := 0-1962.0724
129: , p5_a8 DATE := fnd_api.g_miss_date
130: , p5_a9 NUMBER := 0-1962.0724
131: , p5_a10 DATE := fnd_api.g_miss_date
132: , p5_a11 NUMBER := 0-1962.0724
133: , p6_a0 NUMBER := 0-1962.0724

Line 131: , p5_a10 DATE := fnd_api.g_miss_date

127: , p5_a6 DATE := fnd_api.g_miss_date
128: , p5_a7 NUMBER := 0-1962.0724
129: , p5_a8 DATE := fnd_api.g_miss_date
130: , p5_a9 NUMBER := 0-1962.0724
131: , p5_a10 DATE := fnd_api.g_miss_date
132: , p5_a11 NUMBER := 0-1962.0724
133: , p6_a0 NUMBER := 0-1962.0724
134: , p6_a1 NUMBER := 0-1962.0724
135: , p6_a2 NUMBER := 0-1962.0724

Line 136: , p6_a3 VARCHAR2 := fnd_api.g_miss_char

132: , p5_a11 NUMBER := 0-1962.0724
133: , p6_a0 NUMBER := 0-1962.0724
134: , p6_a1 NUMBER := 0-1962.0724
135: , p6_a2 NUMBER := 0-1962.0724
136: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
137: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
138: , p6_a5 DATE := fnd_api.g_miss_date
139: , p6_a6 DATE := fnd_api.g_miss_date
140: , p6_a7 NUMBER := 0-1962.0724

Line 137: , p6_a4 VARCHAR2 := fnd_api.g_miss_char

133: , p6_a0 NUMBER := 0-1962.0724
134: , p6_a1 NUMBER := 0-1962.0724
135: , p6_a2 NUMBER := 0-1962.0724
136: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
137: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
138: , p6_a5 DATE := fnd_api.g_miss_date
139: , p6_a6 DATE := fnd_api.g_miss_date
140: , p6_a7 NUMBER := 0-1962.0724
141: , p6_a8 DATE := fnd_api.g_miss_date

Line 138: , p6_a5 DATE := fnd_api.g_miss_date

134: , p6_a1 NUMBER := 0-1962.0724
135: , p6_a2 NUMBER := 0-1962.0724
136: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
137: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
138: , p6_a5 DATE := fnd_api.g_miss_date
139: , p6_a6 DATE := fnd_api.g_miss_date
140: , p6_a7 NUMBER := 0-1962.0724
141: , p6_a8 DATE := fnd_api.g_miss_date
142: , p6_a9 NUMBER := 0-1962.0724

Line 139: , p6_a6 DATE := fnd_api.g_miss_date

135: , p6_a2 NUMBER := 0-1962.0724
136: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
137: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
138: , p6_a5 DATE := fnd_api.g_miss_date
139: , p6_a6 DATE := fnd_api.g_miss_date
140: , p6_a7 NUMBER := 0-1962.0724
141: , p6_a8 DATE := fnd_api.g_miss_date
142: , p6_a9 NUMBER := 0-1962.0724
143: , p6_a10 DATE := fnd_api.g_miss_date

Line 141: , p6_a8 DATE := fnd_api.g_miss_date

137: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
138: , p6_a5 DATE := fnd_api.g_miss_date
139: , p6_a6 DATE := fnd_api.g_miss_date
140: , p6_a7 NUMBER := 0-1962.0724
141: , p6_a8 DATE := fnd_api.g_miss_date
142: , p6_a9 NUMBER := 0-1962.0724
143: , p6_a10 DATE := fnd_api.g_miss_date
144: , p6_a11 NUMBER := 0-1962.0724
145: )

Line 143: , p6_a10 DATE := fnd_api.g_miss_date

139: , p6_a6 DATE := fnd_api.g_miss_date
140: , p6_a7 NUMBER := 0-1962.0724
141: , p6_a8 DATE := fnd_api.g_miss_date
142: , p6_a9 NUMBER := 0-1962.0724
143: , p6_a10 DATE := fnd_api.g_miss_date
144: , p6_a11 NUMBER := 0-1962.0724
145: )
146:
147: as

Line 238: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

234: , p7_a10 out nocopy DATE
235: , p7_a11 out nocopy NUMBER
236: , p5_a0 NUMBER := 0-1962.0724
237: , p5_a1 NUMBER := 0-1962.0724
238: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a5 DATE := fnd_api.g_miss_date
242: , p5_a6 DATE := fnd_api.g_miss_date

Line 239: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

235: , p7_a11 out nocopy NUMBER
236: , p5_a0 NUMBER := 0-1962.0724
237: , p5_a1 NUMBER := 0-1962.0724
238: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a5 DATE := fnd_api.g_miss_date
242: , p5_a6 DATE := fnd_api.g_miss_date
243: , p5_a7 NUMBER := 0-1962.0724

Line 240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

236: , p5_a0 NUMBER := 0-1962.0724
237: , p5_a1 NUMBER := 0-1962.0724
238: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a5 DATE := fnd_api.g_miss_date
242: , p5_a6 DATE := fnd_api.g_miss_date
243: , p5_a7 NUMBER := 0-1962.0724
244: , p5_a8 DATE := fnd_api.g_miss_date

Line 241: , p5_a5 DATE := fnd_api.g_miss_date

237: , p5_a1 NUMBER := 0-1962.0724
238: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a5 DATE := fnd_api.g_miss_date
242: , p5_a6 DATE := fnd_api.g_miss_date
243: , p5_a7 NUMBER := 0-1962.0724
244: , p5_a8 DATE := fnd_api.g_miss_date
245: , p5_a9 NUMBER := 0-1962.0724

Line 242: , p5_a6 DATE := fnd_api.g_miss_date

238: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a5 DATE := fnd_api.g_miss_date
242: , p5_a6 DATE := fnd_api.g_miss_date
243: , p5_a7 NUMBER := 0-1962.0724
244: , p5_a8 DATE := fnd_api.g_miss_date
245: , p5_a9 NUMBER := 0-1962.0724
246: , p5_a10 DATE := fnd_api.g_miss_date

Line 244: , p5_a8 DATE := fnd_api.g_miss_date

240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a5 DATE := fnd_api.g_miss_date
242: , p5_a6 DATE := fnd_api.g_miss_date
243: , p5_a7 NUMBER := 0-1962.0724
244: , p5_a8 DATE := fnd_api.g_miss_date
245: , p5_a9 NUMBER := 0-1962.0724
246: , p5_a10 DATE := fnd_api.g_miss_date
247: , p5_a11 NUMBER := 0-1962.0724
248: , p6_a0 NUMBER := 0-1962.0724

Line 246: , p5_a10 DATE := fnd_api.g_miss_date

242: , p5_a6 DATE := fnd_api.g_miss_date
243: , p5_a7 NUMBER := 0-1962.0724
244: , p5_a8 DATE := fnd_api.g_miss_date
245: , p5_a9 NUMBER := 0-1962.0724
246: , p5_a10 DATE := fnd_api.g_miss_date
247: , p5_a11 NUMBER := 0-1962.0724
248: , p6_a0 NUMBER := 0-1962.0724
249: , p6_a1 NUMBER := 0-1962.0724
250: , p6_a2 NUMBER := 0-1962.0724

Line 251: , p6_a3 VARCHAR2 := fnd_api.g_miss_char

247: , p5_a11 NUMBER := 0-1962.0724
248: , p6_a0 NUMBER := 0-1962.0724
249: , p6_a1 NUMBER := 0-1962.0724
250: , p6_a2 NUMBER := 0-1962.0724
251: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a5 DATE := fnd_api.g_miss_date
254: , p6_a6 DATE := fnd_api.g_miss_date
255: , p6_a7 NUMBER := 0-1962.0724

Line 252: , p6_a4 VARCHAR2 := fnd_api.g_miss_char

248: , p6_a0 NUMBER := 0-1962.0724
249: , p6_a1 NUMBER := 0-1962.0724
250: , p6_a2 NUMBER := 0-1962.0724
251: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a5 DATE := fnd_api.g_miss_date
254: , p6_a6 DATE := fnd_api.g_miss_date
255: , p6_a7 NUMBER := 0-1962.0724
256: , p6_a8 DATE := fnd_api.g_miss_date

Line 253: , p6_a5 DATE := fnd_api.g_miss_date

249: , p6_a1 NUMBER := 0-1962.0724
250: , p6_a2 NUMBER := 0-1962.0724
251: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a5 DATE := fnd_api.g_miss_date
254: , p6_a6 DATE := fnd_api.g_miss_date
255: , p6_a7 NUMBER := 0-1962.0724
256: , p6_a8 DATE := fnd_api.g_miss_date
257: , p6_a9 NUMBER := 0-1962.0724

Line 254: , p6_a6 DATE := fnd_api.g_miss_date

250: , p6_a2 NUMBER := 0-1962.0724
251: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a5 DATE := fnd_api.g_miss_date
254: , p6_a6 DATE := fnd_api.g_miss_date
255: , p6_a7 NUMBER := 0-1962.0724
256: , p6_a8 DATE := fnd_api.g_miss_date
257: , p6_a9 NUMBER := 0-1962.0724
258: , p6_a10 DATE := fnd_api.g_miss_date

Line 256: , p6_a8 DATE := fnd_api.g_miss_date

252: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a5 DATE := fnd_api.g_miss_date
254: , p6_a6 DATE := fnd_api.g_miss_date
255: , p6_a7 NUMBER := 0-1962.0724
256: , p6_a8 DATE := fnd_api.g_miss_date
257: , p6_a9 NUMBER := 0-1962.0724
258: , p6_a10 DATE := fnd_api.g_miss_date
259: , p6_a11 NUMBER := 0-1962.0724
260: )

Line 258: , p6_a10 DATE := fnd_api.g_miss_date

254: , p6_a6 DATE := fnd_api.g_miss_date
255: , p6_a7 NUMBER := 0-1962.0724
256: , p6_a8 DATE := fnd_api.g_miss_date
257: , p6_a9 NUMBER := 0-1962.0724
258: , p6_a10 DATE := fnd_api.g_miss_date
259: , p6_a11 NUMBER := 0-1962.0724
260: )
261:
262: as