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;
345: , p6_a19 out nocopy JTF_NUMBER_TABLE
346: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
347: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
349: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a1 NUMBER := 0-1962.0724
351: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a4 NUMBER := 0-1962.0724
347: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
349: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a1 NUMBER := 0-1962.0724
351: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a4 NUMBER := 0-1962.0724
354: , p5_a5 NUMBER := 0-1962.0724
355: , p5_a6 NUMBER := 0-1962.0724
348: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
349: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a1 NUMBER := 0-1962.0724
351: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a4 NUMBER := 0-1962.0724
354: , p5_a5 NUMBER := 0-1962.0724
355: , p5_a6 NUMBER := 0-1962.0724
356: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
352: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a4 NUMBER := 0-1962.0724
354: , p5_a5 NUMBER := 0-1962.0724
355: , p5_a6 NUMBER := 0-1962.0724
356: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a8 NUMBER := 0-1962.0724
358: , p5_a9 NUMBER := 0-1962.0724
359: , p5_a10 DATE := fnd_api.g_miss_date
360: , p5_a11 DATE := fnd_api.g_miss_date
355: , p5_a6 NUMBER := 0-1962.0724
356: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a8 NUMBER := 0-1962.0724
358: , p5_a9 NUMBER := 0-1962.0724
359: , p5_a10 DATE := fnd_api.g_miss_date
360: , p5_a11 DATE := fnd_api.g_miss_date
361: , p5_a12 DATE := fnd_api.g_miss_date
362: , p5_a13 DATE := fnd_api.g_miss_date
363: , p5_a14 DATE := fnd_api.g_miss_date
356: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a8 NUMBER := 0-1962.0724
358: , p5_a9 NUMBER := 0-1962.0724
359: , p5_a10 DATE := fnd_api.g_miss_date
360: , p5_a11 DATE := fnd_api.g_miss_date
361: , p5_a12 DATE := fnd_api.g_miss_date
362: , p5_a13 DATE := fnd_api.g_miss_date
363: , p5_a14 DATE := fnd_api.g_miss_date
364: , p5_a15 DATE := fnd_api.g_miss_date
357: , p5_a8 NUMBER := 0-1962.0724
358: , p5_a9 NUMBER := 0-1962.0724
359: , p5_a10 DATE := fnd_api.g_miss_date
360: , p5_a11 DATE := fnd_api.g_miss_date
361: , p5_a12 DATE := fnd_api.g_miss_date
362: , p5_a13 DATE := fnd_api.g_miss_date
363: , p5_a14 DATE := fnd_api.g_miss_date
364: , p5_a15 DATE := fnd_api.g_miss_date
365: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a9 NUMBER := 0-1962.0724
359: , p5_a10 DATE := fnd_api.g_miss_date
360: , p5_a11 DATE := fnd_api.g_miss_date
361: , p5_a12 DATE := fnd_api.g_miss_date
362: , p5_a13 DATE := fnd_api.g_miss_date
363: , p5_a14 DATE := fnd_api.g_miss_date
364: , p5_a15 DATE := fnd_api.g_miss_date
365: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a17 VARCHAR := fnd_api.g_miss_char
359: , p5_a10 DATE := fnd_api.g_miss_date
360: , p5_a11 DATE := fnd_api.g_miss_date
361: , p5_a12 DATE := fnd_api.g_miss_date
362: , p5_a13 DATE := fnd_api.g_miss_date
363: , p5_a14 DATE := fnd_api.g_miss_date
364: , p5_a15 DATE := fnd_api.g_miss_date
365: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a17 VARCHAR := fnd_api.g_miss_char
367: , p5_a18 NUMBER := 0-1962.0724
360: , p5_a11 DATE := fnd_api.g_miss_date
361: , p5_a12 DATE := fnd_api.g_miss_date
362: , p5_a13 DATE := fnd_api.g_miss_date
363: , p5_a14 DATE := fnd_api.g_miss_date
364: , p5_a15 DATE := fnd_api.g_miss_date
365: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a17 VARCHAR := fnd_api.g_miss_char
367: , p5_a18 NUMBER := 0-1962.0724
368: , p5_a19 NUMBER := 0-1962.0724
361: , p5_a12 DATE := fnd_api.g_miss_date
362: , p5_a13 DATE := fnd_api.g_miss_date
363: , p5_a14 DATE := fnd_api.g_miss_date
364: , p5_a15 DATE := fnd_api.g_miss_date
365: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a17 VARCHAR := fnd_api.g_miss_char
367: , p5_a18 NUMBER := 0-1962.0724
368: , p5_a19 NUMBER := 0-1962.0724
369: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a13 DATE := fnd_api.g_miss_date
363: , p5_a14 DATE := fnd_api.g_miss_date
364: , p5_a15 DATE := fnd_api.g_miss_date
365: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a17 VARCHAR := fnd_api.g_miss_char
367: , p5_a18 NUMBER := 0-1962.0724
368: , p5_a19 NUMBER := 0-1962.0724
369: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a17 VARCHAR := fnd_api.g_miss_char
367: , p5_a18 NUMBER := 0-1962.0724
368: , p5_a19 NUMBER := 0-1962.0724
369: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
372: )
373:
366: , p5_a17 VARCHAR := fnd_api.g_miss_char
367: , p5_a18 NUMBER := 0-1962.0724
368: , p5_a19 NUMBER := 0-1962.0724
369: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
372: )
373:
374: as
367: , p5_a18 NUMBER := 0-1962.0724
368: , p5_a19 NUMBER := 0-1962.0724
369: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
370: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
371: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
372: )
373:
374: as
375: ddp_las_rec okl_la_asset_pvt.las_rec_type;