DBA Data[Home] [Help]

APPS.CSI_CZ_INT_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 596: , p1_a1 VARCHAR2 := fnd_api.g_miss_char

592: , x_msg_count out nocopy NUMBER
593: , x_msg_data out nocopy VARCHAR2
594: , ddrosetta_retval_bool OUT NOCOPY NUMBER
595: , p1_a0 NUMBER := 0-1962.0724
596: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a5 NUMBER := 0-1962.0724

Line 597: , p1_a2 VARCHAR2 := fnd_api.g_miss_char

593: , x_msg_data out nocopy VARCHAR2
594: , ddrosetta_retval_bool OUT NOCOPY NUMBER
595: , p1_a0 NUMBER := 0-1962.0724
596: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a5 NUMBER := 0-1962.0724
601: , p1_a6 NUMBER := 0-1962.0724

Line 598: , p1_a3 VARCHAR2 := fnd_api.g_miss_char

594: , ddrosetta_retval_bool OUT NOCOPY NUMBER
595: , p1_a0 NUMBER := 0-1962.0724
596: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a5 NUMBER := 0-1962.0724
601: , p1_a6 NUMBER := 0-1962.0724
602: , p1_a7 NUMBER := 0-1962.0724

Line 599: , p1_a4 VARCHAR2 := fnd_api.g_miss_char

595: , p1_a0 NUMBER := 0-1962.0724
596: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a5 NUMBER := 0-1962.0724
601: , p1_a6 NUMBER := 0-1962.0724
602: , p1_a7 NUMBER := 0-1962.0724
603: , p1_a8 NUMBER := 0-1962.0724

Line 748: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

744: , x_return_status out nocopy VARCHAR2
745: , x_msg_count out nocopy NUMBER
746: , x_msg_data out nocopy VARCHAR2
747: , p4_a0 NUMBER := 0-1962.0724
748: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
749: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
750: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
751: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
752: , p4_a5 NUMBER := 0-1962.0724

Line 749: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

745: , x_msg_count out nocopy NUMBER
746: , x_msg_data out nocopy VARCHAR2
747: , p4_a0 NUMBER := 0-1962.0724
748: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
749: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
750: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
751: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
752: , p4_a5 NUMBER := 0-1962.0724
753: , p4_a6 NUMBER := 0-1962.0724

Line 750: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

746: , x_msg_data out nocopy VARCHAR2
747: , p4_a0 NUMBER := 0-1962.0724
748: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
749: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
750: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
751: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
752: , p4_a5 NUMBER := 0-1962.0724
753: , p4_a6 NUMBER := 0-1962.0724
754: , p4_a7 NUMBER := 0-1962.0724

Line 751: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

747: , p4_a0 NUMBER := 0-1962.0724
748: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
749: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
750: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
751: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
752: , p4_a5 NUMBER := 0-1962.0724
753: , p4_a6 NUMBER := 0-1962.0724
754: , p4_a7 NUMBER := 0-1962.0724
755: , p4_a8 NUMBER := 0-1962.0724