APPS.CSI_II_RELATIONSHIPS_PUB_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 67: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

63: , x_return_status out nocopy VARCHAR2
64: , x_msg_count out nocopy NUMBER
65: , x_msg_data out nocopy VARCHAR2
66: , p4_a0 NUMBER := 0-1962.0724
67: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
68: , p4_a2 NUMBER := 0-1962.0724
69: , p4_a3 NUMBER := 0-1962.0724
70: )
71:

Line 698: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

694: , x_return_status out nocopy VARCHAR2
695: , x_msg_count out nocopy NUMBER
696: , x_msg_data out nocopy VARCHAR2
697: , p4_a0 NUMBER := 0-1962.0724
698: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
699: , p4_a2 NUMBER := 0-1962.0724
700: , p4_a3 NUMBER := 0-1962.0724
701: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
702: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

Line 701: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

697: , p4_a0 NUMBER := 0-1962.0724
698: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
699: , p4_a2 NUMBER := 0-1962.0724
700: , p4_a3 NUMBER := 0-1962.0724
701: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
702: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
703: , p4_a6 DATE := fnd_api.g_miss_date
704: , p4_a7 DATE := fnd_api.g_miss_date
705: , p4_a8 NUMBER := 0-1962.0724

Line 702: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

698: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
699: , p4_a2 NUMBER := 0-1962.0724
700: , p4_a3 NUMBER := 0-1962.0724
701: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
702: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
703: , p4_a6 DATE := fnd_api.g_miss_date
704: , p4_a7 DATE := fnd_api.g_miss_date
705: , p4_a8 NUMBER := 0-1962.0724
706: , p4_a9 VARCHAR2 := fnd_api.g_miss_char

Line 703: , p4_a6 DATE := fnd_api.g_miss_date

699: , p4_a2 NUMBER := 0-1962.0724
700: , p4_a3 NUMBER := 0-1962.0724
701: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
702: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
703: , p4_a6 DATE := fnd_api.g_miss_date
704: , p4_a7 DATE := fnd_api.g_miss_date
705: , p4_a8 NUMBER := 0-1962.0724
706: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
707: , p4_a10 VARCHAR2 := fnd_api.g_miss_char

Line 704: , p4_a7 DATE := fnd_api.g_miss_date

700: , p4_a3 NUMBER := 0-1962.0724
701: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
702: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
703: , p4_a6 DATE := fnd_api.g_miss_date
704: , p4_a7 DATE := fnd_api.g_miss_date
705: , p4_a8 NUMBER := 0-1962.0724
706: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
707: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
708: , p4_a11 VARCHAR2 := fnd_api.g_miss_char

Line 706: , p4_a9 VARCHAR2 := fnd_api.g_miss_char

702: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
703: , p4_a6 DATE := fnd_api.g_miss_date
704: , p4_a7 DATE := fnd_api.g_miss_date
705: , p4_a8 NUMBER := 0-1962.0724
706: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
707: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
708: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
709: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char

Line 707: , p4_a10 VARCHAR2 := fnd_api.g_miss_char

703: , p4_a6 DATE := fnd_api.g_miss_date
704: , p4_a7 DATE := fnd_api.g_miss_date
705: , p4_a8 NUMBER := 0-1962.0724
706: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
707: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
708: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
709: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

Line 708: , p4_a11 VARCHAR2 := fnd_api.g_miss_char

704: , p4_a7 DATE := fnd_api.g_miss_date
705: , p4_a8 NUMBER := 0-1962.0724
706: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
707: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
708: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
709: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

Line 709: , p4_a12 VARCHAR2 := fnd_api.g_miss_char

705: , p4_a8 NUMBER := 0-1962.0724
706: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
707: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
708: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
709: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char

Line 710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char

706: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
707: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
708: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
709: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char

Line 711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

707: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
708: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
709: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char

Line 712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

708: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
709: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char

Line 713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char

709: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char

Line 714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char

710: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char

Line 715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char

711: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
719: , p4_a22 VARCHAR2 := fnd_api.g_miss_char

Line 716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char

712: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
719: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
720: , p4_a23 VARCHAR2 := fnd_api.g_miss_char

Line 717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char

713: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
719: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
720: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
721: , p4_a24 VARCHAR2 := fnd_api.g_miss_char

Line 718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char

714: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
719: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
720: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
721: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
722: , p4_a25 VARCHAR2 := fnd_api.g_miss_char

Line 719: , p4_a22 VARCHAR2 := fnd_api.g_miss_char

715: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
719: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
720: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
721: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
722: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
723: , p4_a26 NUMBER := 0-1962.0724

Line 720: , p4_a23 VARCHAR2 := fnd_api.g_miss_char

716: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
719: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
720: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
721: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
722: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
723: , p4_a26 NUMBER := 0-1962.0724
724: , p4_a27 NUMBER := 0-1962.0724

Line 721: , p4_a24 VARCHAR2 := fnd_api.g_miss_char

717: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
719: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
720: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
721: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
722: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
723: , p4_a26 NUMBER := 0-1962.0724
724: , p4_a27 NUMBER := 0-1962.0724
725: , p4_a28 VARCHAR2 := fnd_api.g_miss_char

Line 722: , p4_a25 VARCHAR2 := fnd_api.g_miss_char

718: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
719: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
720: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
721: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
722: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
723: , p4_a26 NUMBER := 0-1962.0724
724: , p4_a27 NUMBER := 0-1962.0724
725: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
726: , p4_a29 NUMBER := 0-1962.0724

Line 725: , p4_a28 VARCHAR2 := fnd_api.g_miss_char

721: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
722: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
723: , p4_a26 NUMBER := 0-1962.0724
724: , p4_a27 NUMBER := 0-1962.0724
725: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
726: , p4_a29 NUMBER := 0-1962.0724
727: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
728: )
729:

Line 727: , p4_a30 VARCHAR2 := fnd_api.g_miss_char

723: , p4_a26 NUMBER := 0-1962.0724
724: , p4_a27 NUMBER := 0-1962.0724
725: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
726: , p4_a29 NUMBER := 0-1962.0724
727: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
728: )
729:
730: as
731: ddp_relationship_rec csi_datastructures_pub.ii_relationship_rec;