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.

[Home] [Help]

APPS.OKL_SETUPPMVALUES_PVT_W dependencies on FND_API

Line 11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;

7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:

Line 12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;

8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as

Line 17: a number := fnd_api.g_miss_num;

13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;

Line 44: , p0_a5 DATE := fnd_api.g_miss_date

40: , p0_a1 NUMBER := 0-1962.0724
41: , p0_a2 NUMBER := 0-1962.0724
42: , p0_a3 NUMBER := 0-1962.0724
43: , p0_a4 NUMBER := 0-1962.0724
44: , p0_a5 DATE := fnd_api.g_miss_date
45: , p0_a6 DATE := fnd_api.g_miss_date
46: , p0_a7 NUMBER := 0-1962.0724
47: , p0_a8 DATE := fnd_api.g_miss_date
48: , p0_a9 NUMBER := 0-1962.0724

Line 45: , p0_a6 DATE := fnd_api.g_miss_date

41: , p0_a2 NUMBER := 0-1962.0724
42: , p0_a3 NUMBER := 0-1962.0724
43: , p0_a4 NUMBER := 0-1962.0724
44: , p0_a5 DATE := fnd_api.g_miss_date
45: , p0_a6 DATE := fnd_api.g_miss_date
46: , p0_a7 NUMBER := 0-1962.0724
47: , p0_a8 DATE := fnd_api.g_miss_date
48: , p0_a9 NUMBER := 0-1962.0724
49: , p0_a10 DATE := fnd_api.g_miss_date

Line 47: , p0_a8 DATE := fnd_api.g_miss_date

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

Line 49: , p0_a10 DATE := fnd_api.g_miss_date

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

Line 126: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 127: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 128: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

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

Line 129: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 130: , p5_a6 DATE := fnd_api.g_miss_date

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

Line 132: , p5_a8 DATE := fnd_api.g_miss_date

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

Line 134: , p5_a10 DATE := fnd_api.g_miss_date

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

Line 141: , p6_a5 DATE := fnd_api.g_miss_date

137: , p6_a1 NUMBER := 0-1962.0724
138: , p6_a2 NUMBER := 0-1962.0724
139: , p6_a3 NUMBER := 0-1962.0724
140: , p6_a4 NUMBER := 0-1962.0724
141: , p6_a5 DATE := fnd_api.g_miss_date
142: , p6_a6 DATE := fnd_api.g_miss_date
143: , p6_a7 NUMBER := 0-1962.0724
144: , p6_a8 DATE := fnd_api.g_miss_date
145: , p6_a9 NUMBER := 0-1962.0724

Line 142: , p6_a6 DATE := fnd_api.g_miss_date

138: , p6_a2 NUMBER := 0-1962.0724
139: , p6_a3 NUMBER := 0-1962.0724
140: , p6_a4 NUMBER := 0-1962.0724
141: , p6_a5 DATE := fnd_api.g_miss_date
142: , p6_a6 DATE := fnd_api.g_miss_date
143: , p6_a7 NUMBER := 0-1962.0724
144: , p6_a8 DATE := fnd_api.g_miss_date
145: , p6_a9 NUMBER := 0-1962.0724
146: , p6_a10 DATE := fnd_api.g_miss_date

Line 144: , p6_a8 DATE := fnd_api.g_miss_date

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

Line 146: , p6_a10 DATE := fnd_api.g_miss_date

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

Line 253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

249: , p7_a10 out nocopy JTF_DATE_TABLE
250: , p7_a11 out nocopy JTF_NUMBER_TABLE
251: , p5_a0 NUMBER := 0-1962.0724
252: , p5_a1 NUMBER := 0-1962.0724
253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 DATE := fnd_api.g_miss_date
257: , p5_a6 DATE := fnd_api.g_miss_date

Line 254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

250: , p7_a11 out nocopy JTF_NUMBER_TABLE
251: , p5_a0 NUMBER := 0-1962.0724
252: , p5_a1 NUMBER := 0-1962.0724
253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 DATE := fnd_api.g_miss_date
257: , p5_a6 DATE := fnd_api.g_miss_date
258: , p5_a7 NUMBER := 0-1962.0724

Line 255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

251: , p5_a0 NUMBER := 0-1962.0724
252: , p5_a1 NUMBER := 0-1962.0724
253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 DATE := fnd_api.g_miss_date
257: , p5_a6 DATE := fnd_api.g_miss_date
258: , p5_a7 NUMBER := 0-1962.0724
259: , p5_a8 DATE := fnd_api.g_miss_date

Line 256: , p5_a5 DATE := fnd_api.g_miss_date

252: , p5_a1 NUMBER := 0-1962.0724
253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 DATE := fnd_api.g_miss_date
257: , p5_a6 DATE := fnd_api.g_miss_date
258: , p5_a7 NUMBER := 0-1962.0724
259: , p5_a8 DATE := fnd_api.g_miss_date
260: , p5_a9 NUMBER := 0-1962.0724

Line 257: , p5_a6 DATE := fnd_api.g_miss_date

253: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 DATE := fnd_api.g_miss_date
257: , p5_a6 DATE := fnd_api.g_miss_date
258: , p5_a7 NUMBER := 0-1962.0724
259: , p5_a8 DATE := fnd_api.g_miss_date
260: , p5_a9 NUMBER := 0-1962.0724
261: , p5_a10 DATE := fnd_api.g_miss_date

Line 259: , p5_a8 DATE := fnd_api.g_miss_date

255: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a5 DATE := fnd_api.g_miss_date
257: , p5_a6 DATE := fnd_api.g_miss_date
258: , p5_a7 NUMBER := 0-1962.0724
259: , p5_a8 DATE := fnd_api.g_miss_date
260: , p5_a9 NUMBER := 0-1962.0724
261: , p5_a10 DATE := fnd_api.g_miss_date
262: , p5_a11 NUMBER := 0-1962.0724
263: )

Line 261: , p5_a10 DATE := fnd_api.g_miss_date

257: , p5_a6 DATE := fnd_api.g_miss_date
258: , p5_a7 NUMBER := 0-1962.0724
259: , p5_a8 DATE := fnd_api.g_miss_date
260: , p5_a9 NUMBER := 0-1962.0724
261: , p5_a10 DATE := fnd_api.g_miss_date
262: , p5_a11 NUMBER := 0-1962.0724
263: )
264:
265: as

Line 358: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

354: , p6_a10 JTF_DATE_TABLE
355: , p6_a11 JTF_NUMBER_TABLE
356: , p5_a0 NUMBER := 0-1962.0724
357: , p5_a1 NUMBER := 0-1962.0724
358: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a5 DATE := fnd_api.g_miss_date
362: , p5_a6 DATE := fnd_api.g_miss_date

Line 359: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

355: , p6_a11 JTF_NUMBER_TABLE
356: , p5_a0 NUMBER := 0-1962.0724
357: , p5_a1 NUMBER := 0-1962.0724
358: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a5 DATE := fnd_api.g_miss_date
362: , p5_a6 DATE := fnd_api.g_miss_date
363: , p5_a7 NUMBER := 0-1962.0724

Line 360: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

356: , p5_a0 NUMBER := 0-1962.0724
357: , p5_a1 NUMBER := 0-1962.0724
358: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a5 DATE := fnd_api.g_miss_date
362: , p5_a6 DATE := fnd_api.g_miss_date
363: , p5_a7 NUMBER := 0-1962.0724
364: , p5_a8 DATE := fnd_api.g_miss_date

Line 361: , p5_a5 DATE := fnd_api.g_miss_date

357: , p5_a1 NUMBER := 0-1962.0724
358: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a5 DATE := fnd_api.g_miss_date
362: , p5_a6 DATE := fnd_api.g_miss_date
363: , p5_a7 NUMBER := 0-1962.0724
364: , p5_a8 DATE := fnd_api.g_miss_date
365: , p5_a9 NUMBER := 0-1962.0724

Line 362: , p5_a6 DATE := fnd_api.g_miss_date

358: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a5 DATE := fnd_api.g_miss_date
362: , p5_a6 DATE := fnd_api.g_miss_date
363: , p5_a7 NUMBER := 0-1962.0724
364: , p5_a8 DATE := fnd_api.g_miss_date
365: , p5_a9 NUMBER := 0-1962.0724
366: , p5_a10 DATE := fnd_api.g_miss_date

Line 364: , p5_a8 DATE := fnd_api.g_miss_date

360: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a5 DATE := fnd_api.g_miss_date
362: , p5_a6 DATE := fnd_api.g_miss_date
363: , p5_a7 NUMBER := 0-1962.0724
364: , p5_a8 DATE := fnd_api.g_miss_date
365: , p5_a9 NUMBER := 0-1962.0724
366: , p5_a10 DATE := fnd_api.g_miss_date
367: , p5_a11 NUMBER := 0-1962.0724
368: )

Line 366: , p5_a10 DATE := fnd_api.g_miss_date

362: , p5_a6 DATE := fnd_api.g_miss_date
363: , p5_a7 NUMBER := 0-1962.0724
364: , p5_a8 DATE := fnd_api.g_miss_date
365: , p5_a9 NUMBER := 0-1962.0724
366: , p5_a10 DATE := fnd_api.g_miss_date
367: , p5_a11 NUMBER := 0-1962.0724
368: )
369:
370: as