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_PDT_STYS_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 40: , p5_a1 DATE := fnd_api.g_miss_date

36: , p6_a9 out nocopy DATE
37: , p6_a10 out nocopy NUMBER
38: , p6_a11 out nocopy NUMBER
39: , p5_a0 NUMBER := 0-1962.0724
40: , p5_a1 DATE := fnd_api.g_miss_date
41: , p5_a2 DATE := fnd_api.g_miss_date
42: , p5_a3 NUMBER := 0-1962.0724
43: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a5 NUMBER := 0-1962.0724

Line 41: , p5_a2 DATE := fnd_api.g_miss_date

37: , p6_a10 out nocopy NUMBER
38: , p6_a11 out nocopy NUMBER
39: , p5_a0 NUMBER := 0-1962.0724
40: , p5_a1 DATE := fnd_api.g_miss_date
41: , p5_a2 DATE := fnd_api.g_miss_date
42: , p5_a3 NUMBER := 0-1962.0724
43: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a5 NUMBER := 0-1962.0724
45: , p5_a6 NUMBER := 0-1962.0724

Line 43: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

39: , p5_a0 NUMBER := 0-1962.0724
40: , p5_a1 DATE := fnd_api.g_miss_date
41: , p5_a2 DATE := fnd_api.g_miss_date
42: , p5_a3 NUMBER := 0-1962.0724
43: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a5 NUMBER := 0-1962.0724
45: , p5_a6 NUMBER := 0-1962.0724
46: , p5_a7 NUMBER := 0-1962.0724
47: , p5_a8 DATE := fnd_api.g_miss_date

Line 47: , p5_a8 DATE := fnd_api.g_miss_date

43: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a5 NUMBER := 0-1962.0724
45: , p5_a6 NUMBER := 0-1962.0724
46: , p5_a7 NUMBER := 0-1962.0724
47: , p5_a8 DATE := fnd_api.g_miss_date
48: , p5_a9 DATE := fnd_api.g_miss_date
49: , p5_a10 NUMBER := 0-1962.0724
50: , p5_a11 NUMBER := 0-1962.0724
51: )

Line 48: , p5_a9 DATE := fnd_api.g_miss_date

44: , p5_a5 NUMBER := 0-1962.0724
45: , p5_a6 NUMBER := 0-1962.0724
46: , p5_a7 NUMBER := 0-1962.0724
47: , p5_a8 DATE := fnd_api.g_miss_date
48: , p5_a9 DATE := fnd_api.g_miss_date
49: , p5_a10 NUMBER := 0-1962.0724
50: , p5_a11 NUMBER := 0-1962.0724
51: )
52:

Line 204: , p5_a1 DATE := fnd_api.g_miss_date

200: , x_return_status out nocopy VARCHAR2
201: , x_msg_count out nocopy NUMBER
202: , x_msg_data out nocopy VARCHAR2
203: , p5_a0 NUMBER := 0-1962.0724
204: , p5_a1 DATE := fnd_api.g_miss_date
205: , p5_a2 DATE := fnd_api.g_miss_date
206: , p5_a3 NUMBER := 0-1962.0724
207: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a5 NUMBER := 0-1962.0724

Line 205: , p5_a2 DATE := fnd_api.g_miss_date

201: , x_msg_count out nocopy NUMBER
202: , x_msg_data out nocopy VARCHAR2
203: , p5_a0 NUMBER := 0-1962.0724
204: , p5_a1 DATE := fnd_api.g_miss_date
205: , p5_a2 DATE := fnd_api.g_miss_date
206: , p5_a3 NUMBER := 0-1962.0724
207: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a5 NUMBER := 0-1962.0724
209: , p5_a6 NUMBER := 0-1962.0724

Line 207: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

203: , p5_a0 NUMBER := 0-1962.0724
204: , p5_a1 DATE := fnd_api.g_miss_date
205: , p5_a2 DATE := fnd_api.g_miss_date
206: , p5_a3 NUMBER := 0-1962.0724
207: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a5 NUMBER := 0-1962.0724
209: , p5_a6 NUMBER := 0-1962.0724
210: , p5_a7 NUMBER := 0-1962.0724
211: , p5_a8 DATE := fnd_api.g_miss_date

Line 211: , p5_a8 DATE := fnd_api.g_miss_date

207: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
208: , p5_a5 NUMBER := 0-1962.0724
209: , p5_a6 NUMBER := 0-1962.0724
210: , p5_a7 NUMBER := 0-1962.0724
211: , p5_a8 DATE := fnd_api.g_miss_date
212: , p5_a9 DATE := fnd_api.g_miss_date
213: , p5_a10 NUMBER := 0-1962.0724
214: , p5_a11 NUMBER := 0-1962.0724
215: )

Line 212: , p5_a9 DATE := fnd_api.g_miss_date

208: , p5_a5 NUMBER := 0-1962.0724
209: , p5_a6 NUMBER := 0-1962.0724
210: , p5_a7 NUMBER := 0-1962.0724
211: , p5_a8 DATE := fnd_api.g_miss_date
212: , p5_a9 DATE := fnd_api.g_miss_date
213: , p5_a10 NUMBER := 0-1962.0724
214: , p5_a11 NUMBER := 0-1962.0724
215: )
216:

Line 335: , p5_a1 DATE := fnd_api.g_miss_date

331: , p6_a9 out nocopy DATE
332: , p6_a10 out nocopy NUMBER
333: , p6_a11 out nocopy NUMBER
334: , p5_a0 NUMBER := 0-1962.0724
335: , p5_a1 DATE := fnd_api.g_miss_date
336: , p5_a2 DATE := fnd_api.g_miss_date
337: , p5_a3 NUMBER := 0-1962.0724
338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a5 NUMBER := 0-1962.0724

Line 336: , p5_a2 DATE := fnd_api.g_miss_date

332: , p6_a10 out nocopy NUMBER
333: , p6_a11 out nocopy NUMBER
334: , p5_a0 NUMBER := 0-1962.0724
335: , p5_a1 DATE := fnd_api.g_miss_date
336: , p5_a2 DATE := fnd_api.g_miss_date
337: , p5_a3 NUMBER := 0-1962.0724
338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a5 NUMBER := 0-1962.0724
340: , p5_a6 NUMBER := 0-1962.0724

Line 338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

334: , p5_a0 NUMBER := 0-1962.0724
335: , p5_a1 DATE := fnd_api.g_miss_date
336: , p5_a2 DATE := fnd_api.g_miss_date
337: , p5_a3 NUMBER := 0-1962.0724
338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a5 NUMBER := 0-1962.0724
340: , p5_a6 NUMBER := 0-1962.0724
341: , p5_a7 NUMBER := 0-1962.0724
342: , p5_a8 DATE := fnd_api.g_miss_date

Line 342: , p5_a8 DATE := fnd_api.g_miss_date

338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a5 NUMBER := 0-1962.0724
340: , p5_a6 NUMBER := 0-1962.0724
341: , p5_a7 NUMBER := 0-1962.0724
342: , p5_a8 DATE := fnd_api.g_miss_date
343: , p5_a9 DATE := fnd_api.g_miss_date
344: , p5_a10 NUMBER := 0-1962.0724
345: , p5_a11 NUMBER := 0-1962.0724
346: )

Line 343: , p5_a9 DATE := fnd_api.g_miss_date

339: , p5_a5 NUMBER := 0-1962.0724
340: , p5_a6 NUMBER := 0-1962.0724
341: , p5_a7 NUMBER := 0-1962.0724
342: , p5_a8 DATE := fnd_api.g_miss_date
343: , p5_a9 DATE := fnd_api.g_miss_date
344: , p5_a10 NUMBER := 0-1962.0724
345: , p5_a11 NUMBER := 0-1962.0724
346: )
347:

Line 499: , p5_a1 DATE := fnd_api.g_miss_date

495: , x_return_status out nocopy VARCHAR2
496: , x_msg_count out nocopy NUMBER
497: , x_msg_data out nocopy VARCHAR2
498: , p5_a0 NUMBER := 0-1962.0724
499: , p5_a1 DATE := fnd_api.g_miss_date
500: , p5_a2 DATE := fnd_api.g_miss_date
501: , p5_a3 NUMBER := 0-1962.0724
502: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a5 NUMBER := 0-1962.0724

Line 500: , p5_a2 DATE := fnd_api.g_miss_date

496: , x_msg_count out nocopy NUMBER
497: , x_msg_data out nocopy VARCHAR2
498: , p5_a0 NUMBER := 0-1962.0724
499: , p5_a1 DATE := fnd_api.g_miss_date
500: , p5_a2 DATE := fnd_api.g_miss_date
501: , p5_a3 NUMBER := 0-1962.0724
502: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a5 NUMBER := 0-1962.0724
504: , p5_a6 NUMBER := 0-1962.0724

Line 502: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

498: , p5_a0 NUMBER := 0-1962.0724
499: , p5_a1 DATE := fnd_api.g_miss_date
500: , p5_a2 DATE := fnd_api.g_miss_date
501: , p5_a3 NUMBER := 0-1962.0724
502: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a5 NUMBER := 0-1962.0724
504: , p5_a6 NUMBER := 0-1962.0724
505: , p5_a7 NUMBER := 0-1962.0724
506: , p5_a8 DATE := fnd_api.g_miss_date

Line 506: , p5_a8 DATE := fnd_api.g_miss_date

502: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a5 NUMBER := 0-1962.0724
504: , p5_a6 NUMBER := 0-1962.0724
505: , p5_a7 NUMBER := 0-1962.0724
506: , p5_a8 DATE := fnd_api.g_miss_date
507: , p5_a9 DATE := fnd_api.g_miss_date
508: , p5_a10 NUMBER := 0-1962.0724
509: , p5_a11 NUMBER := 0-1962.0724
510: )

Line 507: , p5_a9 DATE := fnd_api.g_miss_date

503: , p5_a5 NUMBER := 0-1962.0724
504: , p5_a6 NUMBER := 0-1962.0724
505: , p5_a7 NUMBER := 0-1962.0724
506: , p5_a8 DATE := fnd_api.g_miss_date
507: , p5_a9 DATE := fnd_api.g_miss_date
508: , p5_a10 NUMBER := 0-1962.0724
509: , p5_a11 NUMBER := 0-1962.0724
510: )
511:

Line 618: , p5_a1 DATE := fnd_api.g_miss_date

614: , x_return_status out nocopy VARCHAR2
615: , x_msg_count out nocopy NUMBER
616: , x_msg_data out nocopy VARCHAR2
617: , p5_a0 NUMBER := 0-1962.0724
618: , p5_a1 DATE := fnd_api.g_miss_date
619: , p5_a2 DATE := fnd_api.g_miss_date
620: , p5_a3 NUMBER := 0-1962.0724
621: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a5 NUMBER := 0-1962.0724

Line 619: , p5_a2 DATE := fnd_api.g_miss_date

615: , x_msg_count out nocopy NUMBER
616: , x_msg_data out nocopy VARCHAR2
617: , p5_a0 NUMBER := 0-1962.0724
618: , p5_a1 DATE := fnd_api.g_miss_date
619: , p5_a2 DATE := fnd_api.g_miss_date
620: , p5_a3 NUMBER := 0-1962.0724
621: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a5 NUMBER := 0-1962.0724
623: , p5_a6 NUMBER := 0-1962.0724

Line 621: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

617: , p5_a0 NUMBER := 0-1962.0724
618: , p5_a1 DATE := fnd_api.g_miss_date
619: , p5_a2 DATE := fnd_api.g_miss_date
620: , p5_a3 NUMBER := 0-1962.0724
621: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a5 NUMBER := 0-1962.0724
623: , p5_a6 NUMBER := 0-1962.0724
624: , p5_a7 NUMBER := 0-1962.0724
625: , p5_a8 DATE := fnd_api.g_miss_date

Line 625: , p5_a8 DATE := fnd_api.g_miss_date

621: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a5 NUMBER := 0-1962.0724
623: , p5_a6 NUMBER := 0-1962.0724
624: , p5_a7 NUMBER := 0-1962.0724
625: , p5_a8 DATE := fnd_api.g_miss_date
626: , p5_a9 DATE := fnd_api.g_miss_date
627: , p5_a10 NUMBER := 0-1962.0724
628: , p5_a11 NUMBER := 0-1962.0724
629: )

Line 626: , p5_a9 DATE := fnd_api.g_miss_date

622: , p5_a5 NUMBER := 0-1962.0724
623: , p5_a6 NUMBER := 0-1962.0724
624: , p5_a7 NUMBER := 0-1962.0724
625: , p5_a8 DATE := fnd_api.g_miss_date
626: , p5_a9 DATE := fnd_api.g_miss_date
627: , p5_a10 NUMBER := 0-1962.0724
628: , p5_a11 NUMBER := 0-1962.0724
629: )
630: