DBA Data[Home] [Help]

APPS.OKL_SIT_PVT_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 286: , p5_a7 DATE := fnd_api.g_miss_date

282: , p5_a3 NUMBER := 0-1962.0724
283: , p5_a4 NUMBER := 0-1962.0724
284: , p5_a5 NUMBER := 0-1962.0724
285: , p5_a6 NUMBER := 0-1962.0724
286: , p5_a7 DATE := fnd_api.g_miss_date
287: , p5_a8 NUMBER := 0-1962.0724
288: , p5_a9 DATE := fnd_api.g_miss_date
289: , p5_a10 NUMBER := 0-1962.0724
290: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 288: , p5_a9 DATE := fnd_api.g_miss_date

284: , p5_a5 NUMBER := 0-1962.0724
285: , p5_a6 NUMBER := 0-1962.0724
286: , p5_a7 DATE := fnd_api.g_miss_date
287: , p5_a8 NUMBER := 0-1962.0724
288: , p5_a9 DATE := fnd_api.g_miss_date
289: , p5_a10 NUMBER := 0-1962.0724
290: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
291: )
292:

Line 290: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

286: , p5_a7 DATE := fnd_api.g_miss_date
287: , p5_a8 NUMBER := 0-1962.0724
288: , p5_a9 DATE := fnd_api.g_miss_date
289: , p5_a10 NUMBER := 0-1962.0724
290: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
291: )
292:
293: as
294: ddp_sitv_rec okl_sit_pvt.sitv_rec_type;

Line 450: , p5_a7 DATE := fnd_api.g_miss_date

446: , p5_a3 NUMBER := 0-1962.0724
447: , p5_a4 NUMBER := 0-1962.0724
448: , p5_a5 NUMBER := 0-1962.0724
449: , p5_a6 NUMBER := 0-1962.0724
450: , p5_a7 DATE := fnd_api.g_miss_date
451: , p5_a8 NUMBER := 0-1962.0724
452: , p5_a9 DATE := fnd_api.g_miss_date
453: , p5_a10 NUMBER := 0-1962.0724
454: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 452: , p5_a9 DATE := fnd_api.g_miss_date

448: , p5_a5 NUMBER := 0-1962.0724
449: , p5_a6 NUMBER := 0-1962.0724
450: , p5_a7 DATE := fnd_api.g_miss_date
451: , p5_a8 NUMBER := 0-1962.0724
452: , p5_a9 DATE := fnd_api.g_miss_date
453: , p5_a10 NUMBER := 0-1962.0724
454: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
455: )
456:

Line 454: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

450: , p5_a7 DATE := fnd_api.g_miss_date
451: , p5_a8 NUMBER := 0-1962.0724
452: , p5_a9 DATE := fnd_api.g_miss_date
453: , p5_a10 NUMBER := 0-1962.0724
454: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
455: )
456:
457: as
458: ddp_sitv_rec okl_sit_pvt.sitv_rec_type;

Line 581: , p5_a7 DATE := fnd_api.g_miss_date

577: , p5_a3 NUMBER := 0-1962.0724
578: , p5_a4 NUMBER := 0-1962.0724
579: , p5_a5 NUMBER := 0-1962.0724
580: , p5_a6 NUMBER := 0-1962.0724
581: , p5_a7 DATE := fnd_api.g_miss_date
582: , p5_a8 NUMBER := 0-1962.0724
583: , p5_a9 DATE := fnd_api.g_miss_date
584: , p5_a10 NUMBER := 0-1962.0724
585: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 583: , p5_a9 DATE := fnd_api.g_miss_date

579: , p5_a5 NUMBER := 0-1962.0724
580: , p5_a6 NUMBER := 0-1962.0724
581: , p5_a7 DATE := fnd_api.g_miss_date
582: , p5_a8 NUMBER := 0-1962.0724
583: , p5_a9 DATE := fnd_api.g_miss_date
584: , p5_a10 NUMBER := 0-1962.0724
585: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
586: )
587:

Line 585: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

581: , p5_a7 DATE := fnd_api.g_miss_date
582: , p5_a8 NUMBER := 0-1962.0724
583: , p5_a9 DATE := fnd_api.g_miss_date
584: , p5_a10 NUMBER := 0-1962.0724
585: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
586: )
587:
588: as
589: ddp_sitv_rec okl_sit_pvt.sitv_rec_type;

Line 745: , p5_a7 DATE := fnd_api.g_miss_date

741: , p5_a3 NUMBER := 0-1962.0724
742: , p5_a4 NUMBER := 0-1962.0724
743: , p5_a5 NUMBER := 0-1962.0724
744: , p5_a6 NUMBER := 0-1962.0724
745: , p5_a7 DATE := fnd_api.g_miss_date
746: , p5_a8 NUMBER := 0-1962.0724
747: , p5_a9 DATE := fnd_api.g_miss_date
748: , p5_a10 NUMBER := 0-1962.0724
749: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 747: , p5_a9 DATE := fnd_api.g_miss_date

743: , p5_a5 NUMBER := 0-1962.0724
744: , p5_a6 NUMBER := 0-1962.0724
745: , p5_a7 DATE := fnd_api.g_miss_date
746: , p5_a8 NUMBER := 0-1962.0724
747: , p5_a9 DATE := fnd_api.g_miss_date
748: , p5_a10 NUMBER := 0-1962.0724
749: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
750: )
751:

Line 749: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

745: , p5_a7 DATE := fnd_api.g_miss_date
746: , p5_a8 NUMBER := 0-1962.0724
747: , p5_a9 DATE := fnd_api.g_miss_date
748: , p5_a10 NUMBER := 0-1962.0724
749: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
750: )
751:
752: as
753: ddp_sitv_rec okl_sit_pvt.sitv_rec_type;

Line 864: , p5_a7 DATE := fnd_api.g_miss_date

860: , p5_a3 NUMBER := 0-1962.0724
861: , p5_a4 NUMBER := 0-1962.0724
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 DATE := fnd_api.g_miss_date
865: , p5_a8 NUMBER := 0-1962.0724
866: , p5_a9 DATE := fnd_api.g_miss_date
867: , p5_a10 NUMBER := 0-1962.0724
868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 866: , p5_a9 DATE := fnd_api.g_miss_date

862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 DATE := fnd_api.g_miss_date
865: , p5_a8 NUMBER := 0-1962.0724
866: , p5_a9 DATE := fnd_api.g_miss_date
867: , p5_a10 NUMBER := 0-1962.0724
868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
869: )
870:

Line 868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

864: , p5_a7 DATE := fnd_api.g_miss_date
865: , p5_a8 NUMBER := 0-1962.0724
866: , p5_a9 DATE := fnd_api.g_miss_date
867: , p5_a10 NUMBER := 0-1962.0724
868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
869: )
870:
871: as
872: ddp_sitv_rec okl_sit_pvt.sitv_rec_type;