DBA Data[Home] [Help]

APPS.OKL_AGR_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 251: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

247: , p6_a8 out nocopy DATE
248: , p6_a9 out nocopy NUMBER
249: , p5_a0 NUMBER := 0-1962.0724
250: , p5_a1 NUMBER := 0-1962.0724
251: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a3 NUMBER := 0-1962.0724
253: , p5_a4 NUMBER := 0-1962.0724
254: , p5_a5 NUMBER := 0-1962.0724
255: , p5_a6 DATE := fnd_api.g_miss_date

Line 255: , p5_a6 DATE := fnd_api.g_miss_date

251: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a3 NUMBER := 0-1962.0724
253: , p5_a4 NUMBER := 0-1962.0724
254: , p5_a5 NUMBER := 0-1962.0724
255: , p5_a6 DATE := fnd_api.g_miss_date
256: , p5_a7 NUMBER := 0-1962.0724
257: , p5_a8 DATE := fnd_api.g_miss_date
258: , p5_a9 NUMBER := 0-1962.0724
259: )

Line 257: , p5_a8 DATE := fnd_api.g_miss_date

253: , p5_a4 NUMBER := 0-1962.0724
254: , p5_a5 NUMBER := 0-1962.0724
255: , p5_a6 DATE := fnd_api.g_miss_date
256: , p5_a7 NUMBER := 0-1962.0724
257: , p5_a8 DATE := fnd_api.g_miss_date
258: , p5_a9 NUMBER := 0-1962.0724
259: )
260:
261: as

Line 401: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

397: , x_msg_count out nocopy NUMBER
398: , x_msg_data out nocopy VARCHAR2
399: , p5_a0 NUMBER := 0-1962.0724
400: , p5_a1 NUMBER := 0-1962.0724
401: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a3 NUMBER := 0-1962.0724
403: , p5_a4 NUMBER := 0-1962.0724
404: , p5_a5 NUMBER := 0-1962.0724
405: , p5_a6 DATE := fnd_api.g_miss_date

Line 405: , p5_a6 DATE := fnd_api.g_miss_date

401: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a3 NUMBER := 0-1962.0724
403: , p5_a4 NUMBER := 0-1962.0724
404: , p5_a5 NUMBER := 0-1962.0724
405: , p5_a6 DATE := fnd_api.g_miss_date
406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 DATE := fnd_api.g_miss_date
408: , p5_a9 NUMBER := 0-1962.0724
409: )

Line 407: , p5_a8 DATE := fnd_api.g_miss_date

403: , p5_a4 NUMBER := 0-1962.0724
404: , p5_a5 NUMBER := 0-1962.0724
405: , p5_a6 DATE := fnd_api.g_miss_date
406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 DATE := fnd_api.g_miss_date
408: , p5_a9 NUMBER := 0-1962.0724
409: )
410:
411: as

Line 522: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

518: , p6_a8 out nocopy DATE
519: , p6_a9 out nocopy NUMBER
520: , p5_a0 NUMBER := 0-1962.0724
521: , p5_a1 NUMBER := 0-1962.0724
522: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a3 NUMBER := 0-1962.0724
524: , p5_a4 NUMBER := 0-1962.0724
525: , p5_a5 NUMBER := 0-1962.0724
526: , p5_a6 DATE := fnd_api.g_miss_date

Line 526: , p5_a6 DATE := fnd_api.g_miss_date

522: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a3 NUMBER := 0-1962.0724
524: , p5_a4 NUMBER := 0-1962.0724
525: , p5_a5 NUMBER := 0-1962.0724
526: , p5_a6 DATE := fnd_api.g_miss_date
527: , p5_a7 NUMBER := 0-1962.0724
528: , p5_a8 DATE := fnd_api.g_miss_date
529: , p5_a9 NUMBER := 0-1962.0724
530: )

Line 528: , p5_a8 DATE := fnd_api.g_miss_date

524: , p5_a4 NUMBER := 0-1962.0724
525: , p5_a5 NUMBER := 0-1962.0724
526: , p5_a6 DATE := fnd_api.g_miss_date
527: , p5_a7 NUMBER := 0-1962.0724
528: , p5_a8 DATE := fnd_api.g_miss_date
529: , p5_a9 NUMBER := 0-1962.0724
530: )
531:
532: as

Line 672: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

668: , x_msg_count out nocopy NUMBER
669: , x_msg_data out nocopy VARCHAR2
670: , p5_a0 NUMBER := 0-1962.0724
671: , p5_a1 NUMBER := 0-1962.0724
672: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a3 NUMBER := 0-1962.0724
674: , p5_a4 NUMBER := 0-1962.0724
675: , p5_a5 NUMBER := 0-1962.0724
676: , p5_a6 DATE := fnd_api.g_miss_date

Line 676: , p5_a6 DATE := fnd_api.g_miss_date

672: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a3 NUMBER := 0-1962.0724
674: , p5_a4 NUMBER := 0-1962.0724
675: , p5_a5 NUMBER := 0-1962.0724
676: , p5_a6 DATE := fnd_api.g_miss_date
677: , p5_a7 NUMBER := 0-1962.0724
678: , p5_a8 DATE := fnd_api.g_miss_date
679: , p5_a9 NUMBER := 0-1962.0724
680: )

Line 678: , p5_a8 DATE := fnd_api.g_miss_date

674: , p5_a4 NUMBER := 0-1962.0724
675: , p5_a5 NUMBER := 0-1962.0724
676: , p5_a6 DATE := fnd_api.g_miss_date
677: , p5_a7 NUMBER := 0-1962.0724
678: , p5_a8 DATE := fnd_api.g_miss_date
679: , p5_a9 NUMBER := 0-1962.0724
680: )
681:
682: as

Line 783: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

779: , x_msg_count out nocopy NUMBER
780: , x_msg_data out nocopy VARCHAR2
781: , p5_a0 NUMBER := 0-1962.0724
782: , p5_a1 NUMBER := 0-1962.0724
783: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a3 NUMBER := 0-1962.0724
785: , p5_a4 NUMBER := 0-1962.0724
786: , p5_a5 NUMBER := 0-1962.0724
787: , p5_a6 DATE := fnd_api.g_miss_date

Line 787: , p5_a6 DATE := fnd_api.g_miss_date

783: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a3 NUMBER := 0-1962.0724
785: , p5_a4 NUMBER := 0-1962.0724
786: , p5_a5 NUMBER := 0-1962.0724
787: , p5_a6 DATE := fnd_api.g_miss_date
788: , p5_a7 NUMBER := 0-1962.0724
789: , p5_a8 DATE := fnd_api.g_miss_date
790: , p5_a9 NUMBER := 0-1962.0724
791: )

Line 789: , p5_a8 DATE := fnd_api.g_miss_date

785: , p5_a4 NUMBER := 0-1962.0724
786: , p5_a5 NUMBER := 0-1962.0724
787: , p5_a6 DATE := fnd_api.g_miss_date
788: , p5_a7 NUMBER := 0-1962.0724
789: , p5_a8 DATE := fnd_api.g_miss_date
790: , p5_a9 NUMBER := 0-1962.0724
791: )
792:
793: as