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

261: , x_return_status out nocopy VARCHAR2
262: , x_msg_count out nocopy NUMBER
263: , x_msg_data out nocopy VARCHAR2
264: , p4_a0 NUMBER := 0-1962.0724
265: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
266: , p4_a2 NUMBER := 0-1962.0724
267: , p4_a3 NUMBER := 0-1962.0724
268: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
269: , p4_a5 NUMBER := 0-1962.0724

Line 268: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

264: , p4_a0 NUMBER := 0-1962.0724
265: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
266: , p4_a2 NUMBER := 0-1962.0724
267: , p4_a3 NUMBER := 0-1962.0724
268: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
269: , p4_a5 NUMBER := 0-1962.0724
270: , p4_a6 NUMBER := 0-1962.0724
271: , p4_a7 NUMBER := 0-1962.0724
272: , p4_a8 VARCHAR2 := fnd_api.g_miss_char

Line 272: , p4_a8 VARCHAR2 := fnd_api.g_miss_char

268: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
269: , p4_a5 NUMBER := 0-1962.0724
270: , p4_a6 NUMBER := 0-1962.0724
271: , p4_a7 NUMBER := 0-1962.0724
272: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
273: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
274: , p4_a10 NUMBER := 0-1962.0724
275: , p4_a11 NUMBER := 0-1962.0724
276: , p4_a12 DATE := fnd_api.g_miss_date

Line 273: , p4_a9 VARCHAR2 := fnd_api.g_miss_char

269: , p4_a5 NUMBER := 0-1962.0724
270: , p4_a6 NUMBER := 0-1962.0724
271: , p4_a7 NUMBER := 0-1962.0724
272: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
273: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
274: , p4_a10 NUMBER := 0-1962.0724
275: , p4_a11 NUMBER := 0-1962.0724
276: , p4_a12 DATE := fnd_api.g_miss_date
277: , p4_a13 DATE := fnd_api.g_miss_date

Line 276: , p4_a12 DATE := fnd_api.g_miss_date

272: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
273: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
274: , p4_a10 NUMBER := 0-1962.0724
275: , p4_a11 NUMBER := 0-1962.0724
276: , p4_a12 DATE := fnd_api.g_miss_date
277: , p4_a13 DATE := fnd_api.g_miss_date
278: , p4_a14 NUMBER := 0-1962.0724
279: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
280: , p4_a16 NUMBER := 0-1962.0724

Line 277: , p4_a13 DATE := fnd_api.g_miss_date

273: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
274: , p4_a10 NUMBER := 0-1962.0724
275: , p4_a11 NUMBER := 0-1962.0724
276: , p4_a12 DATE := fnd_api.g_miss_date
277: , p4_a13 DATE := fnd_api.g_miss_date
278: , p4_a14 NUMBER := 0-1962.0724
279: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
280: , p4_a16 NUMBER := 0-1962.0724
281: )

Line 279: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

275: , p4_a11 NUMBER := 0-1962.0724
276: , p4_a12 DATE := fnd_api.g_miss_date
277: , p4_a13 DATE := fnd_api.g_miss_date
278: , p4_a14 NUMBER := 0-1962.0724
279: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
280: , p4_a16 NUMBER := 0-1962.0724
281: )
282:
283: as

Line 598: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

594: , x_msg_count out nocopy NUMBER
595: , x_msg_data out nocopy VARCHAR2
596: , p4_a0 NUMBER := 0-1962.0724
597: , p4_a1 NUMBER := 0-1962.0724
598: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
599: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
600: , p4_a4 NUMBER := 0-1962.0724
601: , p4_a5 NUMBER := 0-1962.0724
602: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

Line 599: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

595: , x_msg_data out nocopy VARCHAR2
596: , p4_a0 NUMBER := 0-1962.0724
597: , p4_a1 NUMBER := 0-1962.0724
598: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
599: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
600: , p4_a4 NUMBER := 0-1962.0724
601: , p4_a5 NUMBER := 0-1962.0724
602: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
603: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

Line 602: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

598: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
599: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
600: , p4_a4 NUMBER := 0-1962.0724
601: , p4_a5 NUMBER := 0-1962.0724
602: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
603: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
604: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
605: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char

Line 603: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

599: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
600: , p4_a4 NUMBER := 0-1962.0724
601: , p4_a5 NUMBER := 0-1962.0724
602: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
603: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
604: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
605: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char

Line 604: , p4_a8 VARCHAR2 := fnd_api.g_miss_char

600: , p4_a4 NUMBER := 0-1962.0724
601: , p4_a5 NUMBER := 0-1962.0724
602: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
603: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
604: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
605: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char

Line 605: , p4_a9 VARCHAR2 := fnd_api.g_miss_char

601: , p4_a5 NUMBER := 0-1962.0724
602: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
603: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
604: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
605: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char

Line 606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char

602: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
603: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
604: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
605: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

Line 607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char

603: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
604: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
605: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

Line 608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char

604: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
605: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char

Line 609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char

605: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char

Line 610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

606: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char

Line 611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char

607: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p4_a19 VARCHAR2 := fnd_api.g_miss_char

Line 612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char

608: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p4_a20 VARCHAR2 := fnd_api.g_miss_char

Line 613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char

609: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p4_a21 VARCHAR2 := fnd_api.g_miss_char

Line 614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char

610: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p4_a22 VARCHAR2 := fnd_api.g_miss_char

Line 615: , p4_a19 VARCHAR2 := fnd_api.g_miss_char

611: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
619: )

Line 616: , p4_a20 VARCHAR2 := fnd_api.g_miss_char

612: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
619: )
620:

Line 617: , p4_a21 VARCHAR2 := fnd_api.g_miss_char

613: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
619: )
620:
621: as

Line 618: , p4_a22 VARCHAR2 := fnd_api.g_miss_char

614: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
619: )
620:
621: as
622: ddp_estimate_rec eam_est_datastructures_pub.eam_construction_estimate_rec;

Line 777: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

773: , x_return_status out nocopy VARCHAR2
774: , x_msg_count out nocopy NUMBER
775: , x_msg_data out nocopy VARCHAR2
776: , p4_a0 NUMBER := 0-1962.0724
777: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
778: , p4_a2 NUMBER := 0-1962.0724
779: , p4_a3 NUMBER := 0-1962.0724
780: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
781: , p4_a5 NUMBER := 0-1962.0724

Line 780: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

776: , p4_a0 NUMBER := 0-1962.0724
777: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
778: , p4_a2 NUMBER := 0-1962.0724
779: , p4_a3 NUMBER := 0-1962.0724
780: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
781: , p4_a5 NUMBER := 0-1962.0724
782: , p4_a6 NUMBER := 0-1962.0724
783: , p4_a7 NUMBER := 0-1962.0724
784: , p4_a8 VARCHAR2 := fnd_api.g_miss_char

Line 784: , p4_a8 VARCHAR2 := fnd_api.g_miss_char

780: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
781: , p4_a5 NUMBER := 0-1962.0724
782: , p4_a6 NUMBER := 0-1962.0724
783: , p4_a7 NUMBER := 0-1962.0724
784: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
785: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
786: , p4_a10 NUMBER := 0-1962.0724
787: , p4_a11 NUMBER := 0-1962.0724
788: , p4_a12 DATE := fnd_api.g_miss_date

Line 785: , p4_a9 VARCHAR2 := fnd_api.g_miss_char

781: , p4_a5 NUMBER := 0-1962.0724
782: , p4_a6 NUMBER := 0-1962.0724
783: , p4_a7 NUMBER := 0-1962.0724
784: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
785: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
786: , p4_a10 NUMBER := 0-1962.0724
787: , p4_a11 NUMBER := 0-1962.0724
788: , p4_a12 DATE := fnd_api.g_miss_date
789: , p4_a13 DATE := fnd_api.g_miss_date

Line 788: , p4_a12 DATE := fnd_api.g_miss_date

784: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
785: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
786: , p4_a10 NUMBER := 0-1962.0724
787: , p4_a11 NUMBER := 0-1962.0724
788: , p4_a12 DATE := fnd_api.g_miss_date
789: , p4_a13 DATE := fnd_api.g_miss_date
790: , p4_a14 NUMBER := 0-1962.0724
791: , p4_a15 NUMBER := 0-1962.0724
792: )

Line 789: , p4_a13 DATE := fnd_api.g_miss_date

785: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
786: , p4_a10 NUMBER := 0-1962.0724
787: , p4_a11 NUMBER := 0-1962.0724
788: , p4_a12 DATE := fnd_api.g_miss_date
789: , p4_a13 DATE := fnd_api.g_miss_date
790: , p4_a14 NUMBER := 0-1962.0724
791: , p4_a15 NUMBER := 0-1962.0724
792: )
793: