DBA Data[Home] [Help]

APPS.OKL_PCM_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 150: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

146: , p5_a0 NUMBER := 0-1962.0724
147: , p5_a1 NUMBER := 0-1962.0724
148: , p5_a2 NUMBER := 0-1962.0724
149: , p5_a3 NUMBER := 0-1962.0724
150: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a5 NUMBER := 0-1962.0724
152: , p5_a6 DATE := fnd_api.g_miss_date
153: , p5_a7 NUMBER := 0-1962.0724
154: , p5_a8 DATE := fnd_api.g_miss_date

Line 152: , p5_a6 DATE := fnd_api.g_miss_date

148: , p5_a2 NUMBER := 0-1962.0724
149: , p5_a3 NUMBER := 0-1962.0724
150: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a5 NUMBER := 0-1962.0724
152: , p5_a6 DATE := fnd_api.g_miss_date
153: , p5_a7 NUMBER := 0-1962.0724
154: , p5_a8 DATE := fnd_api.g_miss_date
155: , p5_a9 NUMBER := 0-1962.0724
156: )

Line 154: , p5_a8 DATE := fnd_api.g_miss_date

150: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p5_a5 NUMBER := 0-1962.0724
152: , p5_a6 DATE := fnd_api.g_miss_date
153: , p5_a7 NUMBER := 0-1962.0724
154: , p5_a8 DATE := fnd_api.g_miss_date
155: , p5_a9 NUMBER := 0-1962.0724
156: )
157:
158: as

Line 300: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

296: , p5_a0 NUMBER := 0-1962.0724
297: , p5_a1 NUMBER := 0-1962.0724
298: , p5_a2 NUMBER := 0-1962.0724
299: , p5_a3 NUMBER := 0-1962.0724
300: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a5 NUMBER := 0-1962.0724
302: , p5_a6 DATE := fnd_api.g_miss_date
303: , p5_a7 NUMBER := 0-1962.0724
304: , p5_a8 DATE := fnd_api.g_miss_date

Line 302: , p5_a6 DATE := fnd_api.g_miss_date

298: , p5_a2 NUMBER := 0-1962.0724
299: , p5_a3 NUMBER := 0-1962.0724
300: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a5 NUMBER := 0-1962.0724
302: , p5_a6 DATE := fnd_api.g_miss_date
303: , p5_a7 NUMBER := 0-1962.0724
304: , p5_a8 DATE := fnd_api.g_miss_date
305: , p5_a9 NUMBER := 0-1962.0724
306: )

Line 304: , p5_a8 DATE := fnd_api.g_miss_date

300: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a5 NUMBER := 0-1962.0724
302: , p5_a6 DATE := fnd_api.g_miss_date
303: , p5_a7 NUMBER := 0-1962.0724
304: , p5_a8 DATE := fnd_api.g_miss_date
305: , p5_a9 NUMBER := 0-1962.0724
306: )
307:
308: as

Line 421: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

417: , p5_a0 NUMBER := 0-1962.0724
418: , p5_a1 NUMBER := 0-1962.0724
419: , p5_a2 NUMBER := 0-1962.0724
420: , p5_a3 NUMBER := 0-1962.0724
421: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a5 NUMBER := 0-1962.0724
423: , p5_a6 DATE := fnd_api.g_miss_date
424: , p5_a7 NUMBER := 0-1962.0724
425: , p5_a8 DATE := fnd_api.g_miss_date

Line 423: , p5_a6 DATE := fnd_api.g_miss_date

419: , p5_a2 NUMBER := 0-1962.0724
420: , p5_a3 NUMBER := 0-1962.0724
421: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a5 NUMBER := 0-1962.0724
423: , p5_a6 DATE := fnd_api.g_miss_date
424: , p5_a7 NUMBER := 0-1962.0724
425: , p5_a8 DATE := fnd_api.g_miss_date
426: , p5_a9 NUMBER := 0-1962.0724
427: )

Line 425: , p5_a8 DATE := fnd_api.g_miss_date

421: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a5 NUMBER := 0-1962.0724
423: , p5_a6 DATE := fnd_api.g_miss_date
424: , p5_a7 NUMBER := 0-1962.0724
425: , p5_a8 DATE := fnd_api.g_miss_date
426: , p5_a9 NUMBER := 0-1962.0724
427: )
428:
429: as

Line 571: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

567: , p5_a0 NUMBER := 0-1962.0724
568: , p5_a1 NUMBER := 0-1962.0724
569: , p5_a2 NUMBER := 0-1962.0724
570: , p5_a3 NUMBER := 0-1962.0724
571: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a5 NUMBER := 0-1962.0724
573: , p5_a6 DATE := fnd_api.g_miss_date
574: , p5_a7 NUMBER := 0-1962.0724
575: , p5_a8 DATE := fnd_api.g_miss_date

Line 573: , p5_a6 DATE := fnd_api.g_miss_date

569: , p5_a2 NUMBER := 0-1962.0724
570: , p5_a3 NUMBER := 0-1962.0724
571: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a5 NUMBER := 0-1962.0724
573: , p5_a6 DATE := fnd_api.g_miss_date
574: , p5_a7 NUMBER := 0-1962.0724
575: , p5_a8 DATE := fnd_api.g_miss_date
576: , p5_a9 NUMBER := 0-1962.0724
577: )

Line 575: , p5_a8 DATE := fnd_api.g_miss_date

571: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a5 NUMBER := 0-1962.0724
573: , p5_a6 DATE := fnd_api.g_miss_date
574: , p5_a7 NUMBER := 0-1962.0724
575: , p5_a8 DATE := fnd_api.g_miss_date
576: , p5_a9 NUMBER := 0-1962.0724
577: )
578:
579: as

Line 682: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

678: , p5_a0 NUMBER := 0-1962.0724
679: , p5_a1 NUMBER := 0-1962.0724
680: , p5_a2 NUMBER := 0-1962.0724
681: , p5_a3 NUMBER := 0-1962.0724
682: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
683: , p5_a5 NUMBER := 0-1962.0724
684: , p5_a6 DATE := fnd_api.g_miss_date
685: , p5_a7 NUMBER := 0-1962.0724
686: , p5_a8 DATE := fnd_api.g_miss_date

Line 684: , p5_a6 DATE := fnd_api.g_miss_date

680: , p5_a2 NUMBER := 0-1962.0724
681: , p5_a3 NUMBER := 0-1962.0724
682: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
683: , p5_a5 NUMBER := 0-1962.0724
684: , p5_a6 DATE := fnd_api.g_miss_date
685: , p5_a7 NUMBER := 0-1962.0724
686: , p5_a8 DATE := fnd_api.g_miss_date
687: , p5_a9 NUMBER := 0-1962.0724
688: )

Line 686: , p5_a8 DATE := fnd_api.g_miss_date

682: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
683: , p5_a5 NUMBER := 0-1962.0724
684: , p5_a6 DATE := fnd_api.g_miss_date
685: , p5_a7 NUMBER := 0-1962.0724
686: , p5_a8 DATE := fnd_api.g_miss_date
687: , p5_a9 NUMBER := 0-1962.0724
688: )
689:
690: as