APPS.OKL_PERD_STATUS_PVT_W dependencies on FND_API

Line 9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

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

Line 14: a number := fnd_api.g_miss_num;

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;

Line 273: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

269: , p6_a24 out nocopy JTF_NUMBER_TABLE
270: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a0 NUMBER := 0-1962.0724
272: , p5_a1 NUMBER := 0-1962.0724
273: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a3 DATE := fnd_api.g_miss_date
275: , p5_a4 NUMBER := 0-1962.0724
276: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a6 DATE := fnd_api.g_miss_date

Line 274: , p5_a3 DATE := fnd_api.g_miss_date

270: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a0 NUMBER := 0-1962.0724
272: , p5_a1 NUMBER := 0-1962.0724
273: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a3 DATE := fnd_api.g_miss_date
275: , p5_a4 NUMBER := 0-1962.0724
276: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a6 DATE := fnd_api.g_miss_date
278: , p5_a7 DATE := fnd_api.g_miss_date

Line 276: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

272: , p5_a1 NUMBER := 0-1962.0724
273: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a3 DATE := fnd_api.g_miss_date
275: , p5_a4 NUMBER := 0-1962.0724
276: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a6 DATE := fnd_api.g_miss_date
278: , p5_a7 DATE := fnd_api.g_miss_date
279: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a9 NUMBER := 0-1962.0724

Line 277: , p5_a6 DATE := fnd_api.g_miss_date

273: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a3 DATE := fnd_api.g_miss_date
275: , p5_a4 NUMBER := 0-1962.0724
276: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a6 DATE := fnd_api.g_miss_date
278: , p5_a7 DATE := fnd_api.g_miss_date
279: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a9 NUMBER := 0-1962.0724
281: , p5_a10 NUMBER := 0-1962.0724

Line 278: , p5_a7 DATE := fnd_api.g_miss_date

274: , p5_a3 DATE := fnd_api.g_miss_date
275: , p5_a4 NUMBER := 0-1962.0724
276: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a6 DATE := fnd_api.g_miss_date
278: , p5_a7 DATE := fnd_api.g_miss_date
279: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a9 NUMBER := 0-1962.0724
281: , p5_a10 NUMBER := 0-1962.0724
282: , p5_a11 NUMBER := 0-1962.0724

Line 279: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

275: , p5_a4 NUMBER := 0-1962.0724
276: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a6 DATE := fnd_api.g_miss_date
278: , p5_a7 DATE := fnd_api.g_miss_date
279: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a9 NUMBER := 0-1962.0724
281: , p5_a10 NUMBER := 0-1962.0724
282: , p5_a11 NUMBER := 0-1962.0724
283: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 283: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

279: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a9 NUMBER := 0-1962.0724
281: , p5_a10 NUMBER := 0-1962.0724
282: , p5_a11 NUMBER := 0-1962.0724
283: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a13 DATE := fnd_api.g_miss_date
285: , p5_a14 NUMBER := 0-1962.0724
286: , p5_a15 NUMBER := 0-1962.0724
287: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 284: , p5_a13 DATE := fnd_api.g_miss_date

280: , p5_a9 NUMBER := 0-1962.0724
281: , p5_a10 NUMBER := 0-1962.0724
282: , p5_a11 NUMBER := 0-1962.0724
283: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a13 DATE := fnd_api.g_miss_date
285: , p5_a14 NUMBER := 0-1962.0724
286: , p5_a15 NUMBER := 0-1962.0724
287: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 287: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

283: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a13 DATE := fnd_api.g_miss_date
285: , p5_a14 NUMBER := 0-1962.0724
286: , p5_a15 NUMBER := 0-1962.0724
287: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 288: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

284: , p5_a13 DATE := fnd_api.g_miss_date
285: , p5_a14 NUMBER := 0-1962.0724
286: , p5_a15 NUMBER := 0-1962.0724
287: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 289: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

285: , p5_a14 NUMBER := 0-1962.0724
286: , p5_a15 NUMBER := 0-1962.0724
287: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a22 DATE := fnd_api.g_miss_date

Line 290: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

286: , p5_a15 NUMBER := 0-1962.0724
287: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a22 DATE := fnd_api.g_miss_date
294: , p5_a23 DATE := fnd_api.g_miss_date

Line 291: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

287: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a22 DATE := fnd_api.g_miss_date
294: , p5_a23 DATE := fnd_api.g_miss_date
295: , p5_a24 NUMBER := 0-1962.0724

Line 292: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

288: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a22 DATE := fnd_api.g_miss_date
294: , p5_a23 DATE := fnd_api.g_miss_date
295: , p5_a24 NUMBER := 0-1962.0724
296: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 293: , p5_a22 DATE := fnd_api.g_miss_date

289: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a22 DATE := fnd_api.g_miss_date
294: , p5_a23 DATE := fnd_api.g_miss_date
295: , p5_a24 NUMBER := 0-1962.0724
296: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
297: )

Line 294: , p5_a23 DATE := fnd_api.g_miss_date

290: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a22 DATE := fnd_api.g_miss_date
294: , p5_a23 DATE := fnd_api.g_miss_date
295: , p5_a24 NUMBER := 0-1962.0724
296: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
297: )
298:

Line 296: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

292: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a22 DATE := fnd_api.g_miss_date
294: , p5_a23 DATE := fnd_api.g_miss_date
295: , p5_a24 NUMBER := 0-1962.0724
296: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
297: )
298:
299: as
300: ddp_period_rec okl_perd_status_pvt.period_rec_type;

Line 479: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

475: , x_msg_count out nocopy NUMBER
476: , x_msg_data out nocopy VARCHAR2
477: , p5_a0 NUMBER := 0-1962.0724
478: , p5_a1 NUMBER := 0-1962.0724
479: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a3 DATE := fnd_api.g_miss_date
481: , p5_a4 NUMBER := 0-1962.0724
482: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a6 DATE := fnd_api.g_miss_date

Line 480: , p5_a3 DATE := fnd_api.g_miss_date

476: , x_msg_data out nocopy VARCHAR2
477: , p5_a0 NUMBER := 0-1962.0724
478: , p5_a1 NUMBER := 0-1962.0724
479: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a3 DATE := fnd_api.g_miss_date
481: , p5_a4 NUMBER := 0-1962.0724
482: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a6 DATE := fnd_api.g_miss_date
484: , p5_a7 DATE := fnd_api.g_miss_date

Line 482: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

478: , p5_a1 NUMBER := 0-1962.0724
479: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a3 DATE := fnd_api.g_miss_date
481: , p5_a4 NUMBER := 0-1962.0724
482: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a6 DATE := fnd_api.g_miss_date
484: , p5_a7 DATE := fnd_api.g_miss_date
485: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a9 NUMBER := 0-1962.0724

Line 483: , p5_a6 DATE := fnd_api.g_miss_date

479: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a3 DATE := fnd_api.g_miss_date
481: , p5_a4 NUMBER := 0-1962.0724
482: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a6 DATE := fnd_api.g_miss_date
484: , p5_a7 DATE := fnd_api.g_miss_date
485: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a9 NUMBER := 0-1962.0724
487: , p5_a10 NUMBER := 0-1962.0724

Line 484: , p5_a7 DATE := fnd_api.g_miss_date

480: , p5_a3 DATE := fnd_api.g_miss_date
481: , p5_a4 NUMBER := 0-1962.0724
482: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a6 DATE := fnd_api.g_miss_date
484: , p5_a7 DATE := fnd_api.g_miss_date
485: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a9 NUMBER := 0-1962.0724
487: , p5_a10 NUMBER := 0-1962.0724
488: , p5_a11 NUMBER := 0-1962.0724

Line 485: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

481: , p5_a4 NUMBER := 0-1962.0724
482: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a6 DATE := fnd_api.g_miss_date
484: , p5_a7 DATE := fnd_api.g_miss_date
485: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a9 NUMBER := 0-1962.0724
487: , p5_a10 NUMBER := 0-1962.0724
488: , p5_a11 NUMBER := 0-1962.0724
489: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 489: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

485: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a9 NUMBER := 0-1962.0724
487: , p5_a10 NUMBER := 0-1962.0724
488: , p5_a11 NUMBER := 0-1962.0724
489: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a13 DATE := fnd_api.g_miss_date
491: , p5_a14 NUMBER := 0-1962.0724
492: , p5_a15 NUMBER := 0-1962.0724
493: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 490: , p5_a13 DATE := fnd_api.g_miss_date

486: , p5_a9 NUMBER := 0-1962.0724
487: , p5_a10 NUMBER := 0-1962.0724
488: , p5_a11 NUMBER := 0-1962.0724
489: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a13 DATE := fnd_api.g_miss_date
491: , p5_a14 NUMBER := 0-1962.0724
492: , p5_a15 NUMBER := 0-1962.0724
493: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 493: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

489: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a13 DATE := fnd_api.g_miss_date
491: , p5_a14 NUMBER := 0-1962.0724
492: , p5_a15 NUMBER := 0-1962.0724
493: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 494: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

490: , p5_a13 DATE := fnd_api.g_miss_date
491: , p5_a14 NUMBER := 0-1962.0724
492: , p5_a15 NUMBER := 0-1962.0724
493: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 495: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

491: , p5_a14 NUMBER := 0-1962.0724
492: , p5_a15 NUMBER := 0-1962.0724
493: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a22 DATE := fnd_api.g_miss_date

Line 496: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

492: , p5_a15 NUMBER := 0-1962.0724
493: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a22 DATE := fnd_api.g_miss_date
500: , p5_a23 DATE := fnd_api.g_miss_date

Line 497: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

493: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a22 DATE := fnd_api.g_miss_date
500: , p5_a23 DATE := fnd_api.g_miss_date
501: , p5_a24 NUMBER := 0-1962.0724

Line 498: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

494: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a22 DATE := fnd_api.g_miss_date
500: , p5_a23 DATE := fnd_api.g_miss_date
501: , p5_a24 NUMBER := 0-1962.0724
502: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 499: , p5_a22 DATE := fnd_api.g_miss_date

495: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a22 DATE := fnd_api.g_miss_date
500: , p5_a23 DATE := fnd_api.g_miss_date
501: , p5_a24 NUMBER := 0-1962.0724
502: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
503: )

Line 500: , p5_a23 DATE := fnd_api.g_miss_date

496: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a22 DATE := fnd_api.g_miss_date
500: , p5_a23 DATE := fnd_api.g_miss_date
501: , p5_a24 NUMBER := 0-1962.0724
502: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
503: )
504:

Line 502: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

498: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a22 DATE := fnd_api.g_miss_date
500: , p5_a23 DATE := fnd_api.g_miss_date
501: , p5_a24 NUMBER := 0-1962.0724
502: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
503: )
504:
505: as
506: ddp_period_rec okl_perd_status_pvt.period_rec_type;