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
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;
149: , p6_a9 out nocopy NUMBER
150: , p6_a10 out nocopy VARCHAR2
151: , p5_a0 NUMBER := 0-1962.0724
152: , p5_a1 NUMBER := 0-1962.0724
153: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a4 NUMBER := 0-1962.0724
156: , p5_a5 NUMBER := 0-1962.0724
157: , p5_a6 NUMBER := 0-1962.0724
150: , p6_a10 out nocopy VARCHAR2
151: , p5_a0 NUMBER := 0-1962.0724
152: , p5_a1 NUMBER := 0-1962.0724
153: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a4 NUMBER := 0-1962.0724
156: , p5_a5 NUMBER := 0-1962.0724
157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
159: , p5_a8 NUMBER := 0-1962.0724
160: , p5_a9 NUMBER := 0-1962.0724
161: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
162: )
163:
164: as
165: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
317: , p6_a9 out nocopy NUMBER
318: , p6_a10 out nocopy VARCHAR2
319: , p5_a0 NUMBER := 0-1962.0724
320: , p5_a1 NUMBER := 0-1962.0724
321: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
322: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
323: , p5_a4 NUMBER := 0-1962.0724
324: , p5_a5 NUMBER := 0-1962.0724
325: , p5_a6 NUMBER := 0-1962.0724
318: , p6_a10 out nocopy VARCHAR2
319: , p5_a0 NUMBER := 0-1962.0724
320: , p5_a1 NUMBER := 0-1962.0724
321: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
322: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
323: , p5_a4 NUMBER := 0-1962.0724
324: , p5_a5 NUMBER := 0-1962.0724
325: , p5_a6 NUMBER := 0-1962.0724
326: , p5_a7 NUMBER := 0-1962.0724
325: , p5_a6 NUMBER := 0-1962.0724
326: , p5_a7 NUMBER := 0-1962.0724
327: , p5_a8 NUMBER := 0-1962.0724
328: , p5_a9 NUMBER := 0-1962.0724
329: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
330: )
331:
332: as
333: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
474: , x_msg_count out nocopy NUMBER
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 NUMBER := 0-1962.0724
477: , p5_a1 NUMBER := 0-1962.0724
478: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a4 NUMBER := 0-1962.0724
481: , p5_a5 NUMBER := 0-1962.0724
482: , p5_a6 NUMBER := 0-1962.0724
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 NUMBER := 0-1962.0724
477: , p5_a1 NUMBER := 0-1962.0724
478: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a4 NUMBER := 0-1962.0724
481: , p5_a5 NUMBER := 0-1962.0724
482: , p5_a6 NUMBER := 0-1962.0724
483: , p5_a7 NUMBER := 0-1962.0724
482: , p5_a6 NUMBER := 0-1962.0724
483: , p5_a7 NUMBER := 0-1962.0724
484: , p5_a8 NUMBER := 0-1962.0724
485: , p5_a9 NUMBER := 0-1962.0724
486: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
487: )
488:
489: as
490: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
589: , x_msg_count out nocopy NUMBER
590: , x_msg_data out nocopy VARCHAR2
591: , p5_a0 NUMBER := 0-1962.0724
592: , p5_a1 NUMBER := 0-1962.0724
593: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a4 NUMBER := 0-1962.0724
596: , p5_a5 NUMBER := 0-1962.0724
597: , p5_a6 NUMBER := 0-1962.0724
590: , x_msg_data out nocopy VARCHAR2
591: , p5_a0 NUMBER := 0-1962.0724
592: , p5_a1 NUMBER := 0-1962.0724
593: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a4 NUMBER := 0-1962.0724
596: , p5_a5 NUMBER := 0-1962.0724
597: , p5_a6 NUMBER := 0-1962.0724
598: , p5_a7 NUMBER := 0-1962.0724
597: , p5_a6 NUMBER := 0-1962.0724
598: , p5_a7 NUMBER := 0-1962.0724
599: , p5_a8 NUMBER := 0-1962.0724
600: , p5_a9 NUMBER := 0-1962.0724
601: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
602: )
603:
604: as
605: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;
715: , p6_a9 out nocopy NUMBER
716: , p6_a10 out nocopy VARCHAR2
717: , p5_a0 NUMBER := 0-1962.0724
718: , p5_a1 NUMBER := 0-1962.0724
719: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a4 NUMBER := 0-1962.0724
722: , p5_a5 NUMBER := 0-1962.0724
723: , p5_a6 NUMBER := 0-1962.0724
716: , p6_a10 out nocopy VARCHAR2
717: , p5_a0 NUMBER := 0-1962.0724
718: , p5_a1 NUMBER := 0-1962.0724
719: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a4 NUMBER := 0-1962.0724
722: , p5_a5 NUMBER := 0-1962.0724
723: , p5_a6 NUMBER := 0-1962.0724
724: , p5_a7 NUMBER := 0-1962.0724
723: , p5_a6 NUMBER := 0-1962.0724
724: , p5_a7 NUMBER := 0-1962.0724
725: , p5_a8 NUMBER := 0-1962.0724
726: , p5_a9 NUMBER := 0-1962.0724
727: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
728: )
729:
730: as
731: ddp_asb_rec okl_asset_subsidy_pvt.asb_rec_type;