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:
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
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;
187: , p5_a1 NUMBER := 0-1962.0724
188: , p5_a2 NUMBER := 0-1962.0724
189: , p5_a3 NUMBER := 0-1962.0724
190: , p5_a4 NUMBER := 0-1962.0724
191: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a7 NUMBER := 0-1962.0724
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 NUMBER := 0-1962.0724
188: , p5_a2 NUMBER := 0-1962.0724
189: , p5_a3 NUMBER := 0-1962.0724
190: , p5_a4 NUMBER := 0-1962.0724
191: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a7 NUMBER := 0-1962.0724
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 NUMBER := 0-1962.0724
196: , p5_a10 DATE := fnd_api.g_miss_date
190: , p5_a4 NUMBER := 0-1962.0724
191: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a7 NUMBER := 0-1962.0724
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 NUMBER := 0-1962.0724
196: , p5_a10 DATE := fnd_api.g_miss_date
197: , p5_a11 NUMBER := 0-1962.0724
198: , p5_a12 DATE := fnd_api.g_miss_date
192: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a7 NUMBER := 0-1962.0724
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 NUMBER := 0-1962.0724
196: , p5_a10 DATE := fnd_api.g_miss_date
197: , p5_a11 NUMBER := 0-1962.0724
198: , p5_a12 DATE := fnd_api.g_miss_date
199: , p5_a13 NUMBER := 0-1962.0724
200: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a9 NUMBER := 0-1962.0724
196: , p5_a10 DATE := fnd_api.g_miss_date
197: , p5_a11 NUMBER := 0-1962.0724
198: , p5_a12 DATE := fnd_api.g_miss_date
199: , p5_a13 NUMBER := 0-1962.0724
200: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
201: )
202:
196: , p5_a10 DATE := fnd_api.g_miss_date
197: , p5_a11 NUMBER := 0-1962.0724
198: , p5_a12 DATE := fnd_api.g_miss_date
199: , p5_a13 NUMBER := 0-1962.0724
200: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
201: )
202:
203: as
204: ddp_bct_rec okl_bct_pvt.okl_bct_rec;
387: , p5_a1 NUMBER := 0-1962.0724
388: , p5_a2 NUMBER := 0-1962.0724
389: , p5_a3 NUMBER := 0-1962.0724
390: , p5_a4 NUMBER := 0-1962.0724
391: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a7 NUMBER := 0-1962.0724
394: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a9 NUMBER := 0-1962.0724
388: , p5_a2 NUMBER := 0-1962.0724
389: , p5_a3 NUMBER := 0-1962.0724
390: , p5_a4 NUMBER := 0-1962.0724
391: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a7 NUMBER := 0-1962.0724
394: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a9 NUMBER := 0-1962.0724
396: , p5_a10 DATE := fnd_api.g_miss_date
390: , p5_a4 NUMBER := 0-1962.0724
391: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a7 NUMBER := 0-1962.0724
394: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a9 NUMBER := 0-1962.0724
396: , p5_a10 DATE := fnd_api.g_miss_date
397: , p5_a11 NUMBER := 0-1962.0724
398: , p5_a12 DATE := fnd_api.g_miss_date
392: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a7 NUMBER := 0-1962.0724
394: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a9 NUMBER := 0-1962.0724
396: , p5_a10 DATE := fnd_api.g_miss_date
397: , p5_a11 NUMBER := 0-1962.0724
398: , p5_a12 DATE := fnd_api.g_miss_date
399: , p5_a13 NUMBER := 0-1962.0724
400: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a9 NUMBER := 0-1962.0724
396: , p5_a10 DATE := fnd_api.g_miss_date
397: , p5_a11 NUMBER := 0-1962.0724
398: , p5_a12 DATE := fnd_api.g_miss_date
399: , p5_a13 NUMBER := 0-1962.0724
400: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
401: )
402:
396: , p5_a10 DATE := fnd_api.g_miss_date
397: , p5_a11 NUMBER := 0-1962.0724
398: , p5_a12 DATE := fnd_api.g_miss_date
399: , p5_a13 NUMBER := 0-1962.0724
400: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
401: )
402:
403: as
404: ddp_bct_rec okl_bct_pvt.okl_bct_rec;
572: , p5_a1 NUMBER := 0-1962.0724
573: , p5_a2 NUMBER := 0-1962.0724
574: , p5_a3 NUMBER := 0-1962.0724
575: , p5_a4 NUMBER := 0-1962.0724
576: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a7 NUMBER := 0-1962.0724
579: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a9 NUMBER := 0-1962.0724
573: , p5_a2 NUMBER := 0-1962.0724
574: , p5_a3 NUMBER := 0-1962.0724
575: , p5_a4 NUMBER := 0-1962.0724
576: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a7 NUMBER := 0-1962.0724
579: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a9 NUMBER := 0-1962.0724
581: , p5_a10 DATE := fnd_api.g_miss_date
575: , p5_a4 NUMBER := 0-1962.0724
576: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a7 NUMBER := 0-1962.0724
579: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a9 NUMBER := 0-1962.0724
581: , p5_a10 DATE := fnd_api.g_miss_date
582: , p5_a11 NUMBER := 0-1962.0724
583: , p5_a12 DATE := fnd_api.g_miss_date
577: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a7 NUMBER := 0-1962.0724
579: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a9 NUMBER := 0-1962.0724
581: , p5_a10 DATE := fnd_api.g_miss_date
582: , p5_a11 NUMBER := 0-1962.0724
583: , p5_a12 DATE := fnd_api.g_miss_date
584: , p5_a13 NUMBER := 0-1962.0724
585: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a9 NUMBER := 0-1962.0724
581: , p5_a10 DATE := fnd_api.g_miss_date
582: , p5_a11 NUMBER := 0-1962.0724
583: , p5_a12 DATE := fnd_api.g_miss_date
584: , p5_a13 NUMBER := 0-1962.0724
585: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
586: )
587:
581: , p5_a10 DATE := fnd_api.g_miss_date
582: , p5_a11 NUMBER := 0-1962.0724
583: , p5_a12 DATE := fnd_api.g_miss_date
584: , p5_a13 NUMBER := 0-1962.0724
585: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
586: )
587:
588: as
589: ddp_bct_rec okl_bct_pvt.okl_bct_rec;