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

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

Line 127: , p5_a4 DATE := fnd_api.g_miss_date

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

Line 128: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 130: , p5_a7 DATE := fnd_api.g_miss_date

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

Line 132: , p5_a9 DATE := fnd_api.g_miss_date

128: , p5_a5 DATE := fnd_api.g_miss_date
129: , p5_a6 NUMBER := 0-1962.0724
130: , p5_a7 DATE := fnd_api.g_miss_date
131: , p5_a8 NUMBER := 0-1962.0724
132: , p5_a9 DATE := fnd_api.g_miss_date
133: , p5_a10 NUMBER := 0-1962.0724
134: )
135:
136: as

Line 256: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 257: , p5_a4 DATE := fnd_api.g_miss_date

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

Line 258: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 260: , p5_a7 DATE := fnd_api.g_miss_date

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

Line 262: , p5_a9 DATE := fnd_api.g_miss_date

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

Line 409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

405: , p6_a10 out nocopy NUMBER
406: , p5_a0 NUMBER := 0-1962.0724
407: , p5_a1 NUMBER := 0-1962.0724
408: , p5_a2 NUMBER := 0-1962.0724
409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 DATE := fnd_api.g_miss_date
411: , p5_a5 DATE := fnd_api.g_miss_date
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date

Line 410: , p5_a4 DATE := fnd_api.g_miss_date

406: , p5_a0 NUMBER := 0-1962.0724
407: , p5_a1 NUMBER := 0-1962.0724
408: , p5_a2 NUMBER := 0-1962.0724
409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 DATE := fnd_api.g_miss_date
411: , p5_a5 DATE := fnd_api.g_miss_date
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date
414: , p5_a8 NUMBER := 0-1962.0724

Line 411: , p5_a5 DATE := fnd_api.g_miss_date

407: , p5_a1 NUMBER := 0-1962.0724
408: , p5_a2 NUMBER := 0-1962.0724
409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 DATE := fnd_api.g_miss_date
411: , p5_a5 DATE := fnd_api.g_miss_date
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date
414: , p5_a8 NUMBER := 0-1962.0724
415: , p5_a9 DATE := fnd_api.g_miss_date

Line 413: , p5_a7 DATE := fnd_api.g_miss_date

409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 DATE := fnd_api.g_miss_date
411: , p5_a5 DATE := fnd_api.g_miss_date
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date
414: , p5_a8 NUMBER := 0-1962.0724
415: , p5_a9 DATE := fnd_api.g_miss_date
416: , p5_a10 NUMBER := 0-1962.0724
417: )

Line 415: , p5_a9 DATE := fnd_api.g_miss_date

411: , p5_a5 DATE := fnd_api.g_miss_date
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date
414: , p5_a8 NUMBER := 0-1962.0724
415: , p5_a9 DATE := fnd_api.g_miss_date
416: , p5_a10 NUMBER := 0-1962.0724
417: )
418:
419: as

Line 539: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 NUMBER := 0-1962.0724
537: , p5_a1 NUMBER := 0-1962.0724
538: , p5_a2 NUMBER := 0-1962.0724
539: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a4 DATE := fnd_api.g_miss_date
541: , p5_a5 DATE := fnd_api.g_miss_date
542: , p5_a6 NUMBER := 0-1962.0724
543: , p5_a7 DATE := fnd_api.g_miss_date

Line 540: , p5_a4 DATE := fnd_api.g_miss_date

536: , p5_a0 NUMBER := 0-1962.0724
537: , p5_a1 NUMBER := 0-1962.0724
538: , p5_a2 NUMBER := 0-1962.0724
539: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a4 DATE := fnd_api.g_miss_date
541: , p5_a5 DATE := fnd_api.g_miss_date
542: , p5_a6 NUMBER := 0-1962.0724
543: , p5_a7 DATE := fnd_api.g_miss_date
544: , p5_a8 NUMBER := 0-1962.0724

Line 541: , p5_a5 DATE := fnd_api.g_miss_date

537: , p5_a1 NUMBER := 0-1962.0724
538: , p5_a2 NUMBER := 0-1962.0724
539: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a4 DATE := fnd_api.g_miss_date
541: , p5_a5 DATE := fnd_api.g_miss_date
542: , p5_a6 NUMBER := 0-1962.0724
543: , p5_a7 DATE := fnd_api.g_miss_date
544: , p5_a8 NUMBER := 0-1962.0724
545: , p5_a9 DATE := fnd_api.g_miss_date

Line 543: , p5_a7 DATE := fnd_api.g_miss_date

539: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a4 DATE := fnd_api.g_miss_date
541: , p5_a5 DATE := fnd_api.g_miss_date
542: , p5_a6 NUMBER := 0-1962.0724
543: , p5_a7 DATE := fnd_api.g_miss_date
544: , p5_a8 NUMBER := 0-1962.0724
545: , p5_a9 DATE := fnd_api.g_miss_date
546: , p5_a10 NUMBER := 0-1962.0724
547: )

Line 545: , p5_a9 DATE := fnd_api.g_miss_date

541: , p5_a5 DATE := fnd_api.g_miss_date
542: , p5_a6 NUMBER := 0-1962.0724
543: , p5_a7 DATE := fnd_api.g_miss_date
544: , p5_a8 NUMBER := 0-1962.0724
545: , p5_a9 DATE := fnd_api.g_miss_date
546: , p5_a10 NUMBER := 0-1962.0724
547: )
548:
549: as

Line 654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

650: , x_msg_data out nocopy VARCHAR2
651: , p5_a0 NUMBER := 0-1962.0724
652: , p5_a1 NUMBER := 0-1962.0724
653: , p5_a2 NUMBER := 0-1962.0724
654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 DATE := fnd_api.g_miss_date
656: , p5_a5 DATE := fnd_api.g_miss_date
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date

Line 655: , p5_a4 DATE := fnd_api.g_miss_date

651: , p5_a0 NUMBER := 0-1962.0724
652: , p5_a1 NUMBER := 0-1962.0724
653: , p5_a2 NUMBER := 0-1962.0724
654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 DATE := fnd_api.g_miss_date
656: , p5_a5 DATE := fnd_api.g_miss_date
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date
659: , p5_a8 NUMBER := 0-1962.0724

Line 656: , p5_a5 DATE := fnd_api.g_miss_date

652: , p5_a1 NUMBER := 0-1962.0724
653: , p5_a2 NUMBER := 0-1962.0724
654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 DATE := fnd_api.g_miss_date
656: , p5_a5 DATE := fnd_api.g_miss_date
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date
659: , p5_a8 NUMBER := 0-1962.0724
660: , p5_a9 DATE := fnd_api.g_miss_date

Line 658: , p5_a7 DATE := fnd_api.g_miss_date

654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 DATE := fnd_api.g_miss_date
656: , p5_a5 DATE := fnd_api.g_miss_date
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date
659: , p5_a8 NUMBER := 0-1962.0724
660: , p5_a9 DATE := fnd_api.g_miss_date
661: , p5_a10 NUMBER := 0-1962.0724
662: )

Line 660: , p5_a9 DATE := fnd_api.g_miss_date

656: , p5_a5 DATE := fnd_api.g_miss_date
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date
659: , p5_a8 NUMBER := 0-1962.0724
660: , p5_a9 DATE := fnd_api.g_miss_date
661: , p5_a10 NUMBER := 0-1962.0724
662: )
663:
664: as