DBA Data[Home] [Help]

APPS.OKL_SETUP_ACCRUALS_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:

Line 18: a number := fnd_api.g_miss_num;

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

Line 51: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

47: , p6_a16 out nocopy DATE
48: , p6_a17 out nocopy NUMBER
49: , p5_a0 NUMBER := 0-1962.0724
50: , p5_a1 NUMBER := 0-1962.0724
51: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 52: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

48: , p6_a17 out nocopy NUMBER
49: , p5_a0 NUMBER := 0-1962.0724
50: , p5_a1 NUMBER := 0-1962.0724
51: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 53: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

49: , p5_a0 NUMBER := 0-1962.0724
50: , p5_a1 NUMBER := 0-1962.0724
51: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 55: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

51: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 DATE := fnd_api.g_miss_date

Line 56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

52: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 DATE := fnd_api.g_miss_date
60: , p5_a11 DATE := fnd_api.g_miss_date

Line 57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

53: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 DATE := fnd_api.g_miss_date
60: , p5_a11 DATE := fnd_api.g_miss_date
61: , p5_a12 NUMBER := 0-1962.0724

Line 58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 DATE := fnd_api.g_miss_date
60: , p5_a11 DATE := fnd_api.g_miss_date
61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724

Line 59: , p5_a10 DATE := fnd_api.g_miss_date

55: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 DATE := fnd_api.g_miss_date
60: , p5_a11 DATE := fnd_api.g_miss_date
61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724
63: , p5_a14 DATE := fnd_api.g_miss_date

Line 60: , p5_a11 DATE := fnd_api.g_miss_date

56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 DATE := fnd_api.g_miss_date
60: , p5_a11 DATE := fnd_api.g_miss_date
61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724
63: , p5_a14 DATE := fnd_api.g_miss_date
64: , p5_a15 NUMBER := 0-1962.0724

Line 63: , p5_a14 DATE := fnd_api.g_miss_date

59: , p5_a10 DATE := fnd_api.g_miss_date
60: , p5_a11 DATE := fnd_api.g_miss_date
61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724
63: , p5_a14 DATE := fnd_api.g_miss_date
64: , p5_a15 NUMBER := 0-1962.0724
65: , p5_a16 DATE := fnd_api.g_miss_date
66: , p5_a17 NUMBER := 0-1962.0724
67: )

Line 65: , p5_a16 DATE := fnd_api.g_miss_date

61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724
63: , p5_a14 DATE := fnd_api.g_miss_date
64: , p5_a15 NUMBER := 0-1962.0724
65: , p5_a16 DATE := fnd_api.g_miss_date
66: , p5_a17 NUMBER := 0-1962.0724
67: )
68:
69: as

Line 275: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

271: , p6_a16 out nocopy DATE
272: , p6_a17 out nocopy NUMBER
273: , p5_a0 NUMBER := 0-1962.0724
274: , p5_a1 NUMBER := 0-1962.0724
275: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a5 NUMBER := 0-1962.0724
279: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 276: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

272: , p6_a17 out nocopy NUMBER
273: , p5_a0 NUMBER := 0-1962.0724
274: , p5_a1 NUMBER := 0-1962.0724
275: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a5 NUMBER := 0-1962.0724
279: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 277: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

273: , p5_a0 NUMBER := 0-1962.0724
274: , p5_a1 NUMBER := 0-1962.0724
275: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a5 NUMBER := 0-1962.0724
279: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 279: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

275: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a5 NUMBER := 0-1962.0724
279: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a10 DATE := fnd_api.g_miss_date

Line 280: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

276: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a5 NUMBER := 0-1962.0724
279: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a10 DATE := fnd_api.g_miss_date
284: , p5_a11 DATE := fnd_api.g_miss_date

Line 281: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

277: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a5 NUMBER := 0-1962.0724
279: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a10 DATE := fnd_api.g_miss_date
284: , p5_a11 DATE := fnd_api.g_miss_date
285: , p5_a12 NUMBER := 0-1962.0724

Line 282: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

278: , p5_a5 NUMBER := 0-1962.0724
279: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a10 DATE := fnd_api.g_miss_date
284: , p5_a11 DATE := fnd_api.g_miss_date
285: , p5_a12 NUMBER := 0-1962.0724
286: , p5_a13 NUMBER := 0-1962.0724

Line 283: , p5_a10 DATE := fnd_api.g_miss_date

279: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a10 DATE := fnd_api.g_miss_date
284: , p5_a11 DATE := fnd_api.g_miss_date
285: , p5_a12 NUMBER := 0-1962.0724
286: , p5_a13 NUMBER := 0-1962.0724
287: , p5_a14 DATE := fnd_api.g_miss_date

Line 284: , p5_a11 DATE := fnd_api.g_miss_date

280: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a10 DATE := fnd_api.g_miss_date
284: , p5_a11 DATE := fnd_api.g_miss_date
285: , p5_a12 NUMBER := 0-1962.0724
286: , p5_a13 NUMBER := 0-1962.0724
287: , p5_a14 DATE := fnd_api.g_miss_date
288: , p5_a15 NUMBER := 0-1962.0724

Line 287: , p5_a14 DATE := fnd_api.g_miss_date

283: , p5_a10 DATE := fnd_api.g_miss_date
284: , p5_a11 DATE := fnd_api.g_miss_date
285: , p5_a12 NUMBER := 0-1962.0724
286: , p5_a13 NUMBER := 0-1962.0724
287: , p5_a14 DATE := fnd_api.g_miss_date
288: , p5_a15 NUMBER := 0-1962.0724
289: , p5_a16 DATE := fnd_api.g_miss_date
290: , p5_a17 NUMBER := 0-1962.0724
291: )

Line 289: , p5_a16 DATE := fnd_api.g_miss_date

285: , p5_a12 NUMBER := 0-1962.0724
286: , p5_a13 NUMBER := 0-1962.0724
287: , p5_a14 DATE := fnd_api.g_miss_date
288: , p5_a15 NUMBER := 0-1962.0724
289: , p5_a16 DATE := fnd_api.g_miss_date
290: , p5_a17 NUMBER := 0-1962.0724
291: )
292:
293: as

Line 481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

477: , x_msg_count out nocopy NUMBER
478: , x_msg_data out nocopy VARCHAR2
479: , p5_a0 NUMBER := 0-1962.0724
480: , p5_a1 NUMBER := 0-1962.0724
481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 NUMBER := 0-1962.0724
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 482: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

478: , x_msg_data out nocopy VARCHAR2
479: , p5_a0 NUMBER := 0-1962.0724
480: , p5_a1 NUMBER := 0-1962.0724
481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 NUMBER := 0-1962.0724
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

479: , p5_a0 NUMBER := 0-1962.0724
480: , p5_a1 NUMBER := 0-1962.0724
481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 NUMBER := 0-1962.0724
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 NUMBER := 0-1962.0724
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a10 DATE := fnd_api.g_miss_date

Line 486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

482: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 NUMBER := 0-1962.0724
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 DATE := fnd_api.g_miss_date

Line 487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 NUMBER := 0-1962.0724
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 DATE := fnd_api.g_miss_date
491: , p5_a12 NUMBER := 0-1962.0724

Line 488: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

484: , p5_a5 NUMBER := 0-1962.0724
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 DATE := fnd_api.g_miss_date
491: , p5_a12 NUMBER := 0-1962.0724
492: , p5_a13 NUMBER := 0-1962.0724

Line 489: , p5_a10 DATE := fnd_api.g_miss_date

485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 DATE := fnd_api.g_miss_date
491: , p5_a12 NUMBER := 0-1962.0724
492: , p5_a13 NUMBER := 0-1962.0724
493: , p5_a14 DATE := fnd_api.g_miss_date

Line 490: , p5_a11 DATE := fnd_api.g_miss_date

486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 DATE := fnd_api.g_miss_date
491: , p5_a12 NUMBER := 0-1962.0724
492: , p5_a13 NUMBER := 0-1962.0724
493: , p5_a14 DATE := fnd_api.g_miss_date
494: , p5_a15 NUMBER := 0-1962.0724

Line 493: , p5_a14 DATE := fnd_api.g_miss_date

489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 DATE := fnd_api.g_miss_date
491: , p5_a12 NUMBER := 0-1962.0724
492: , p5_a13 NUMBER := 0-1962.0724
493: , p5_a14 DATE := fnd_api.g_miss_date
494: , p5_a15 NUMBER := 0-1962.0724
495: , p5_a16 DATE := fnd_api.g_miss_date
496: , p5_a17 NUMBER := 0-1962.0724
497: )

Line 495: , p5_a16 DATE := fnd_api.g_miss_date

491: , p5_a12 NUMBER := 0-1962.0724
492: , p5_a13 NUMBER := 0-1962.0724
493: , p5_a14 DATE := fnd_api.g_miss_date
494: , p5_a15 NUMBER := 0-1962.0724
495: , p5_a16 DATE := fnd_api.g_miss_date
496: , p5_a17 NUMBER := 0-1962.0724
497: )
498:
499: as