APPS.OKL_FNCTN_PRMTRS_PUB_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 43: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

39: , p6_a12 out nocopy DATE
40: , p6_a13 out nocopy NUMBER
41: , p5_a0 NUMBER := 0-1962.0724
42: , p5_a1 NUMBER := 0-1962.0724
43: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a3 NUMBER := 0-1962.0724
45: , p5_a4 NUMBER := 0-1962.0724
46: , p5_a5 NUMBER := 0-1962.0724
47: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 47: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

43: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
44: , p5_a3 NUMBER := 0-1962.0724
45: , p5_a4 NUMBER := 0-1962.0724
46: , p5_a5 NUMBER := 0-1962.0724
47: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date

Line 48: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

44: , p5_a3 NUMBER := 0-1962.0724
45: , p5_a4 NUMBER := 0-1962.0724
46: , p5_a5 NUMBER := 0-1962.0724
47: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date
52: , p5_a11 NUMBER := 0-1962.0724

Line 49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

45: , p5_a4 NUMBER := 0-1962.0724
46: , p5_a5 NUMBER := 0-1962.0724
47: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date
52: , p5_a11 NUMBER := 0-1962.0724
53: , p5_a12 DATE := fnd_api.g_miss_date

Line 51: , p5_a10 DATE := fnd_api.g_miss_date

47: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date
52: , p5_a11 NUMBER := 0-1962.0724
53: , p5_a12 DATE := fnd_api.g_miss_date
54: , p5_a13 NUMBER := 0-1962.0724
55: )

Line 53: , p5_a12 DATE := fnd_api.g_miss_date

49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date
52: , p5_a11 NUMBER := 0-1962.0724
53: , p5_a12 DATE := fnd_api.g_miss_date
54: , p5_a13 NUMBER := 0-1962.0724
55: )
56:
57: as

Line 221: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

217: , x_msg_count out nocopy NUMBER
218: , x_msg_data out nocopy VARCHAR2
219: , p5_a0 NUMBER := 0-1962.0724
220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a3 NUMBER := 0-1962.0724
223: , p5_a4 NUMBER := 0-1962.0724
224: , p5_a5 NUMBER := 0-1962.0724
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

221: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
222: , p5_a3 NUMBER := 0-1962.0724
223: , p5_a4 NUMBER := 0-1962.0724
224: , p5_a5 NUMBER := 0-1962.0724
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date

Line 226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

222: , p5_a3 NUMBER := 0-1962.0724
223: , p5_a4 NUMBER := 0-1962.0724
224: , p5_a5 NUMBER := 0-1962.0724
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724

Line 227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

223: , p5_a4 NUMBER := 0-1962.0724
224: , p5_a5 NUMBER := 0-1962.0724
225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
231: , p5_a12 DATE := fnd_api.g_miss_date

Line 229: , p5_a10 DATE := fnd_api.g_miss_date

225: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
226: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
231: , p5_a12 DATE := fnd_api.g_miss_date
232: , p5_a13 NUMBER := 0-1962.0724
233: )

Line 231: , p5_a12 DATE := fnd_api.g_miss_date

227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
231: , p5_a12 DATE := fnd_api.g_miss_date
232: , p5_a13 NUMBER := 0-1962.0724
233: )
234:
235: as

Line 362: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

358: , p6_a12 out nocopy DATE
359: , p6_a13 out nocopy NUMBER
360: , p5_a0 NUMBER := 0-1962.0724
361: , p5_a1 NUMBER := 0-1962.0724
362: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a3 NUMBER := 0-1962.0724
364: , p5_a4 NUMBER := 0-1962.0724
365: , p5_a5 NUMBER := 0-1962.0724
366: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 366: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

362: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a3 NUMBER := 0-1962.0724
364: , p5_a4 NUMBER := 0-1962.0724
365: , p5_a5 NUMBER := 0-1962.0724
366: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date

Line 367: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

363: , p5_a3 NUMBER := 0-1962.0724
364: , p5_a4 NUMBER := 0-1962.0724
365: , p5_a5 NUMBER := 0-1962.0724
366: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date
371: , p5_a11 NUMBER := 0-1962.0724

Line 368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

364: , p5_a4 NUMBER := 0-1962.0724
365: , p5_a5 NUMBER := 0-1962.0724
366: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date
371: , p5_a11 NUMBER := 0-1962.0724
372: , p5_a12 DATE := fnd_api.g_miss_date

Line 370: , p5_a10 DATE := fnd_api.g_miss_date

366: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date
371: , p5_a11 NUMBER := 0-1962.0724
372: , p5_a12 DATE := fnd_api.g_miss_date
373: , p5_a13 NUMBER := 0-1962.0724
374: )

Line 372: , p5_a12 DATE := fnd_api.g_miss_date

368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date
371: , p5_a11 NUMBER := 0-1962.0724
372: , p5_a12 DATE := fnd_api.g_miss_date
373: , p5_a13 NUMBER := 0-1962.0724
374: )
375:
376: as

Line 540: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

536: , x_msg_count out nocopy NUMBER
537: , x_msg_data out nocopy VARCHAR2
538: , p5_a0 NUMBER := 0-1962.0724
539: , p5_a1 NUMBER := 0-1962.0724
540: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a3 NUMBER := 0-1962.0724
542: , p5_a4 NUMBER := 0-1962.0724
543: , p5_a5 NUMBER := 0-1962.0724
544: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 544: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

540: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a3 NUMBER := 0-1962.0724
542: , p5_a4 NUMBER := 0-1962.0724
543: , p5_a5 NUMBER := 0-1962.0724
544: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date

Line 545: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

541: , p5_a3 NUMBER := 0-1962.0724
542: , p5_a4 NUMBER := 0-1962.0724
543: , p5_a5 NUMBER := 0-1962.0724
544: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date
549: , p5_a11 NUMBER := 0-1962.0724

Line 546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

542: , p5_a4 NUMBER := 0-1962.0724
543: , p5_a5 NUMBER := 0-1962.0724
544: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date
549: , p5_a11 NUMBER := 0-1962.0724
550: , p5_a12 DATE := fnd_api.g_miss_date

Line 548: , p5_a10 DATE := fnd_api.g_miss_date

544: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date
549: , p5_a11 NUMBER := 0-1962.0724
550: , p5_a12 DATE := fnd_api.g_miss_date
551: , p5_a13 NUMBER := 0-1962.0724
552: )

Line 550: , p5_a12 DATE := fnd_api.g_miss_date

546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date
549: , p5_a11 NUMBER := 0-1962.0724
550: , p5_a12 DATE := fnd_api.g_miss_date
551: , p5_a13 NUMBER := 0-1962.0724
552: )
553:
554: as

Line 667: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

663: , x_msg_count out nocopy NUMBER
664: , x_msg_data out nocopy VARCHAR2
665: , p5_a0 NUMBER := 0-1962.0724
666: , p5_a1 NUMBER := 0-1962.0724
667: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
668: , p5_a3 NUMBER := 0-1962.0724
669: , p5_a4 NUMBER := 0-1962.0724
670: , p5_a5 NUMBER := 0-1962.0724
671: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 671: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

667: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
668: , p5_a3 NUMBER := 0-1962.0724
669: , p5_a4 NUMBER := 0-1962.0724
670: , p5_a5 NUMBER := 0-1962.0724
671: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date

Line 672: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

668: , p5_a3 NUMBER := 0-1962.0724
669: , p5_a4 NUMBER := 0-1962.0724
670: , p5_a5 NUMBER := 0-1962.0724
671: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date
676: , p5_a11 NUMBER := 0-1962.0724

Line 673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

669: , p5_a4 NUMBER := 0-1962.0724
670: , p5_a5 NUMBER := 0-1962.0724
671: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date
676: , p5_a11 NUMBER := 0-1962.0724
677: , p5_a12 DATE := fnd_api.g_miss_date

Line 675: , p5_a10 DATE := fnd_api.g_miss_date

671: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date
676: , p5_a11 NUMBER := 0-1962.0724
677: , p5_a12 DATE := fnd_api.g_miss_date
678: , p5_a13 NUMBER := 0-1962.0724
679: )

Line 677: , p5_a12 DATE := fnd_api.g_miss_date

673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date
676: , p5_a11 NUMBER := 0-1962.0724
677: , p5_a12 DATE := fnd_api.g_miss_date
678: , p5_a13 NUMBER := 0-1962.0724
679: )
680:
681: as