DBA Data[Home] [Help]

APPS.OKL_SIF_TRX_PARMS_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 44: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 52: , p5_a11 DATE := fnd_api.g_miss_date

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

Line 53: , p5_a12 DATE := fnd_api.g_miss_date

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

Line 222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 230: , p5_a11 DATE := fnd_api.g_miss_date

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

Line 231: , p5_a12 DATE := fnd_api.g_miss_date

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

Line 363: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 371: , p5_a11 DATE := fnd_api.g_miss_date

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

Line 372: , p5_a12 DATE := fnd_api.g_miss_date

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

Line 555: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

551: , p6_a13 out nocopy NUMBER
552: , p5_a0 NUMBER := 0-1962.0724
553: , p5_a1 NUMBER := 0-1962.0724
554: , p5_a2 NUMBER := 0-1962.0724
555: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a4 NUMBER := 0-1962.0724
557: , p5_a5 NUMBER := 0-1962.0724
558: , p5_a6 NUMBER := 0-1962.0724
559: , p5_a7 NUMBER := 0-1962.0724

Line 563: , p5_a11 DATE := fnd_api.g_miss_date

559: , p5_a7 NUMBER := 0-1962.0724
560: , p5_a8 NUMBER := 0-1962.0724
561: , p5_a9 NUMBER := 0-1962.0724
562: , p5_a10 NUMBER := 0-1962.0724
563: , p5_a11 DATE := fnd_api.g_miss_date
564: , p5_a12 DATE := fnd_api.g_miss_date
565: , p5_a13 NUMBER := 0-1962.0724
566: )
567:

Line 564: , p5_a12 DATE := fnd_api.g_miss_date

560: , p5_a8 NUMBER := 0-1962.0724
561: , p5_a9 NUMBER := 0-1962.0724
562: , p5_a10 NUMBER := 0-1962.0724
563: , p5_a11 DATE := fnd_api.g_miss_date
564: , p5_a12 DATE := fnd_api.g_miss_date
565: , p5_a13 NUMBER := 0-1962.0724
566: )
567:
568: as

Line 747: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

743: , p6_a13 out nocopy NUMBER
744: , p5_a0 NUMBER := 0-1962.0724
745: , p5_a1 NUMBER := 0-1962.0724
746: , p5_a2 NUMBER := 0-1962.0724
747: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a4 NUMBER := 0-1962.0724
749: , p5_a5 NUMBER := 0-1962.0724
750: , p5_a6 NUMBER := 0-1962.0724
751: , p5_a7 NUMBER := 0-1962.0724

Line 755: , p5_a11 DATE := fnd_api.g_miss_date

751: , p5_a7 NUMBER := 0-1962.0724
752: , p5_a8 NUMBER := 0-1962.0724
753: , p5_a9 NUMBER := 0-1962.0724
754: , p5_a10 NUMBER := 0-1962.0724
755: , p5_a11 DATE := fnd_api.g_miss_date
756: , p5_a12 DATE := fnd_api.g_miss_date
757: , p5_a13 NUMBER := 0-1962.0724
758: )
759:

Line 756: , p5_a12 DATE := fnd_api.g_miss_date

752: , p5_a8 NUMBER := 0-1962.0724
753: , p5_a9 NUMBER := 0-1962.0724
754: , p5_a10 NUMBER := 0-1962.0724
755: , p5_a11 DATE := fnd_api.g_miss_date
756: , p5_a12 DATE := fnd_api.g_miss_date
757: , p5_a13 NUMBER := 0-1962.0724
758: )
759:
760: as