DBA Data[Home] [Help]

APPS.OKL_LA_ASSET_PVT_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 349: , p5_a0 VARCHAR2 := fnd_api.g_miss_char

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

Line 351: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 352: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 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

Line 359: , p5_a10 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

Line 360: , p5_a11 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

Line 361: , p5_a12 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

Line 362: , p5_a13 DATE := fnd_api.g_miss_date

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

Line 363: , p5_a14 DATE := fnd_api.g_miss_date

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

Line 364: , p5_a15 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
368: , p5_a19 NUMBER := 0-1962.0724

Line 365: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

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

Line 366: , p5_a17 VARCHAR := 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

Line 369: , p5_a20 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:

Line 370: , p5_a21 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:
374: as

Line 371: , p5_a22 VARCHAR2 := 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
375: ddp_las_rec okl_la_asset_pvt.las_rec_type;