DBA Data[Home] [Help]

APPS.OKL_BUCKETS_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 47: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

43: , p6_a16 out nocopy NUMBER
44: , p5_a0 NUMBER := 0-1962.0724
45: , p5_a1 NUMBER := 0-1962.0724
46: , p5_a2 NUMBER := 0-1962.0724
47: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724

Line 48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

44: , p5_a0 NUMBER := 0-1962.0724
45: , p5_a1 NUMBER := 0-1962.0724
46: , p5_a2 NUMBER := 0-1962.0724
47: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724

Line 53: , p5_a9 DATE := fnd_api.g_miss_date

49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date

Line 54: , p5_a10 DATE := fnd_api.g_miss_date

50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724

Line 55: , p5_a11 DATE := fnd_api.g_miss_date

51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
59: , p5_a15 DATE := fnd_api.g_miss_date

Line 57: , p5_a13 DATE := fnd_api.g_miss_date

53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
59: , p5_a15 DATE := fnd_api.g_miss_date
60: , p5_a16 NUMBER := 0-1962.0724
61: )

Line 59: , p5_a15 DATE := fnd_api.g_miss_date

55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
59: , p5_a15 DATE := fnd_api.g_miss_date
60: , p5_a16 NUMBER := 0-1962.0724
61: )
62:
63: as

Line 246: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

242: , x_msg_data out nocopy VARCHAR2
243: , p5_a0 NUMBER := 0-1962.0724
244: , p5_a1 NUMBER := 0-1962.0724
245: , p5_a2 NUMBER := 0-1962.0724
246: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a5 NUMBER := 0-1962.0724
249: , p5_a6 NUMBER := 0-1962.0724
250: , p5_a7 NUMBER := 0-1962.0724

Line 247: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

243: , p5_a0 NUMBER := 0-1962.0724
244: , p5_a1 NUMBER := 0-1962.0724
245: , p5_a2 NUMBER := 0-1962.0724
246: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a5 NUMBER := 0-1962.0724
249: , p5_a6 NUMBER := 0-1962.0724
250: , p5_a7 NUMBER := 0-1962.0724
251: , p5_a8 NUMBER := 0-1962.0724

Line 252: , p5_a9 DATE := fnd_api.g_miss_date

248: , p5_a5 NUMBER := 0-1962.0724
249: , p5_a6 NUMBER := 0-1962.0724
250: , p5_a7 NUMBER := 0-1962.0724
251: , p5_a8 NUMBER := 0-1962.0724
252: , p5_a9 DATE := fnd_api.g_miss_date
253: , p5_a10 DATE := fnd_api.g_miss_date
254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date

Line 253: , p5_a10 DATE := fnd_api.g_miss_date

249: , p5_a6 NUMBER := 0-1962.0724
250: , p5_a7 NUMBER := 0-1962.0724
251: , p5_a8 NUMBER := 0-1962.0724
252: , p5_a9 DATE := fnd_api.g_miss_date
253: , p5_a10 DATE := fnd_api.g_miss_date
254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date
257: , p5_a14 NUMBER := 0-1962.0724

Line 254: , p5_a11 DATE := fnd_api.g_miss_date

250: , p5_a7 NUMBER := 0-1962.0724
251: , p5_a8 NUMBER := 0-1962.0724
252: , p5_a9 DATE := fnd_api.g_miss_date
253: , p5_a10 DATE := fnd_api.g_miss_date
254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date
257: , p5_a14 NUMBER := 0-1962.0724
258: , p5_a15 DATE := fnd_api.g_miss_date

Line 256: , p5_a13 DATE := fnd_api.g_miss_date

252: , p5_a9 DATE := fnd_api.g_miss_date
253: , p5_a10 DATE := fnd_api.g_miss_date
254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date
257: , p5_a14 NUMBER := 0-1962.0724
258: , p5_a15 DATE := fnd_api.g_miss_date
259: , p5_a16 NUMBER := 0-1962.0724
260: )

Line 258: , p5_a15 DATE := fnd_api.g_miss_date

254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date
257: , p5_a14 NUMBER := 0-1962.0724
258: , p5_a15 DATE := fnd_api.g_miss_date
259: , p5_a16 NUMBER := 0-1962.0724
260: )
261:
262: as

Line 402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

398: , p6_a16 out nocopy NUMBER
399: , p5_a0 NUMBER := 0-1962.0724
400: , p5_a1 NUMBER := 0-1962.0724
401: , p5_a2 NUMBER := 0-1962.0724
402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a5 NUMBER := 0-1962.0724
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 NUMBER := 0-1962.0724

Line 403: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

399: , p5_a0 NUMBER := 0-1962.0724
400: , p5_a1 NUMBER := 0-1962.0724
401: , p5_a2 NUMBER := 0-1962.0724
402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a5 NUMBER := 0-1962.0724
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 NUMBER := 0-1962.0724

Line 408: , p5_a9 DATE := fnd_api.g_miss_date

404: , p5_a5 NUMBER := 0-1962.0724
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 DATE := fnd_api.g_miss_date
409: , p5_a10 DATE := fnd_api.g_miss_date
410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date

Line 409: , p5_a10 DATE := fnd_api.g_miss_date

405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 DATE := fnd_api.g_miss_date
409: , p5_a10 DATE := fnd_api.g_miss_date
410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date
413: , p5_a14 NUMBER := 0-1962.0724

Line 410: , p5_a11 DATE := fnd_api.g_miss_date

406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 DATE := fnd_api.g_miss_date
409: , p5_a10 DATE := fnd_api.g_miss_date
410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date
413: , p5_a14 NUMBER := 0-1962.0724
414: , p5_a15 DATE := fnd_api.g_miss_date

Line 412: , p5_a13 DATE := fnd_api.g_miss_date

408: , p5_a9 DATE := fnd_api.g_miss_date
409: , p5_a10 DATE := fnd_api.g_miss_date
410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date
413: , p5_a14 NUMBER := 0-1962.0724
414: , p5_a15 DATE := fnd_api.g_miss_date
415: , p5_a16 NUMBER := 0-1962.0724
416: )

Line 414: , p5_a15 DATE := fnd_api.g_miss_date

410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date
413: , p5_a14 NUMBER := 0-1962.0724
414: , p5_a15 DATE := fnd_api.g_miss_date
415: , p5_a16 NUMBER := 0-1962.0724
416: )
417:
418: as

Line 601: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

597: , x_msg_data out nocopy VARCHAR2
598: , p5_a0 NUMBER := 0-1962.0724
599: , p5_a1 NUMBER := 0-1962.0724
600: , p5_a2 NUMBER := 0-1962.0724
601: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a5 NUMBER := 0-1962.0724
604: , p5_a6 NUMBER := 0-1962.0724
605: , p5_a7 NUMBER := 0-1962.0724

Line 602: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

598: , p5_a0 NUMBER := 0-1962.0724
599: , p5_a1 NUMBER := 0-1962.0724
600: , p5_a2 NUMBER := 0-1962.0724
601: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a5 NUMBER := 0-1962.0724
604: , p5_a6 NUMBER := 0-1962.0724
605: , p5_a7 NUMBER := 0-1962.0724
606: , p5_a8 NUMBER := 0-1962.0724

Line 607: , p5_a9 DATE := fnd_api.g_miss_date

603: , p5_a5 NUMBER := 0-1962.0724
604: , p5_a6 NUMBER := 0-1962.0724
605: , p5_a7 NUMBER := 0-1962.0724
606: , p5_a8 NUMBER := 0-1962.0724
607: , p5_a9 DATE := fnd_api.g_miss_date
608: , p5_a10 DATE := fnd_api.g_miss_date
609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date

Line 608: , p5_a10 DATE := fnd_api.g_miss_date

604: , p5_a6 NUMBER := 0-1962.0724
605: , p5_a7 NUMBER := 0-1962.0724
606: , p5_a8 NUMBER := 0-1962.0724
607: , p5_a9 DATE := fnd_api.g_miss_date
608: , p5_a10 DATE := fnd_api.g_miss_date
609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date
612: , p5_a14 NUMBER := 0-1962.0724

Line 609: , p5_a11 DATE := fnd_api.g_miss_date

605: , p5_a7 NUMBER := 0-1962.0724
606: , p5_a8 NUMBER := 0-1962.0724
607: , p5_a9 DATE := fnd_api.g_miss_date
608: , p5_a10 DATE := fnd_api.g_miss_date
609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date
612: , p5_a14 NUMBER := 0-1962.0724
613: , p5_a15 DATE := fnd_api.g_miss_date

Line 611: , p5_a13 DATE := fnd_api.g_miss_date

607: , p5_a9 DATE := fnd_api.g_miss_date
608: , p5_a10 DATE := fnd_api.g_miss_date
609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date
612: , p5_a14 NUMBER := 0-1962.0724
613: , p5_a15 DATE := fnd_api.g_miss_date
614: , p5_a16 NUMBER := 0-1962.0724
615: )

Line 613: , p5_a15 DATE := fnd_api.g_miss_date

609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date
612: , p5_a14 NUMBER := 0-1962.0724
613: , p5_a15 DATE := fnd_api.g_miss_date
614: , p5_a16 NUMBER := 0-1962.0724
615: )
616:
617: as

Line 740: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

736: , x_msg_data out nocopy VARCHAR2
737: , p5_a0 NUMBER := 0-1962.0724
738: , p5_a1 NUMBER := 0-1962.0724
739: , p5_a2 NUMBER := 0-1962.0724
740: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a5 NUMBER := 0-1962.0724
743: , p5_a6 NUMBER := 0-1962.0724
744: , p5_a7 NUMBER := 0-1962.0724

Line 741: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

737: , p5_a0 NUMBER := 0-1962.0724
738: , p5_a1 NUMBER := 0-1962.0724
739: , p5_a2 NUMBER := 0-1962.0724
740: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a5 NUMBER := 0-1962.0724
743: , p5_a6 NUMBER := 0-1962.0724
744: , p5_a7 NUMBER := 0-1962.0724
745: , p5_a8 NUMBER := 0-1962.0724

Line 746: , p5_a9 DATE := fnd_api.g_miss_date

742: , p5_a5 NUMBER := 0-1962.0724
743: , p5_a6 NUMBER := 0-1962.0724
744: , p5_a7 NUMBER := 0-1962.0724
745: , p5_a8 NUMBER := 0-1962.0724
746: , p5_a9 DATE := fnd_api.g_miss_date
747: , p5_a10 DATE := fnd_api.g_miss_date
748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date

Line 747: , p5_a10 DATE := fnd_api.g_miss_date

743: , p5_a6 NUMBER := 0-1962.0724
744: , p5_a7 NUMBER := 0-1962.0724
745: , p5_a8 NUMBER := 0-1962.0724
746: , p5_a9 DATE := fnd_api.g_miss_date
747: , p5_a10 DATE := fnd_api.g_miss_date
748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date
751: , p5_a14 NUMBER := 0-1962.0724

Line 748: , p5_a11 DATE := fnd_api.g_miss_date

744: , p5_a7 NUMBER := 0-1962.0724
745: , p5_a8 NUMBER := 0-1962.0724
746: , p5_a9 DATE := fnd_api.g_miss_date
747: , p5_a10 DATE := fnd_api.g_miss_date
748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date
751: , p5_a14 NUMBER := 0-1962.0724
752: , p5_a15 DATE := fnd_api.g_miss_date

Line 750: , p5_a13 DATE := fnd_api.g_miss_date

746: , p5_a9 DATE := fnd_api.g_miss_date
747: , p5_a10 DATE := fnd_api.g_miss_date
748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date
751: , p5_a14 NUMBER := 0-1962.0724
752: , p5_a15 DATE := fnd_api.g_miss_date
753: , p5_a16 NUMBER := 0-1962.0724
754: )

Line 752: , p5_a15 DATE := fnd_api.g_miss_date

748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date
751: , p5_a14 NUMBER := 0-1962.0724
752: , p5_a15 DATE := fnd_api.g_miss_date
753: , p5_a16 NUMBER := 0-1962.0724
754: )
755:
756: as